Mansi (RID : 474kwbrsbmh)

designation   SQL Developer

location   Location : Bangalore, India

experience   Experience : 4 Year

rate   Rate: $12 / Hourly

Availability   Availability : Immediate

Work From   Work From : Any

designation   Category : Information Technology & Services

Last Active: 28 Days ago
Shortlisted : 10
Total Views : 22
Key Skills
MySQL MSSQL SQLite SQL PL/SQL Unix
Discription

Software Developer

Summary

  • Software Engineer with 4 years of experience into MySQL, SQL/PLSQL, UNIX shell scripting and SQL/PLSQL Development.
  • Hands on experience in Development and Maintenance and Support
  • Expertise in programming language like MYSQL, MSSQL, SQL, PL/SQL and UNIX Shell Scripting
  • Can write simple and complex Procedures, Functions, Packages and Triggers
  • Good knowledge on complex SQL queries, Dynamic SQL, Analytical Functions and oracle supplied packages (DBMS_PROFILER, DBMS_TRACE, DBMS_SCHEDULER)
  • Knowledge on database performance tuning using Table Partitioning, Query Tuning, Collections, Records, PL/SQL Tables, Bulk Collections, Bind Variable, Explain Plan, Hints and Query Analyzer
  • Strong functional knowledge of Financial, Retail and Telecom domain (OSS/BSS)
  • Good knowledge on Production Issues & Support activities (L2 & L3)

Technical Skills

  • Operating Systems: Unix, Linux, Win XP/7/8/10
  • Programming Language : MySQL, MSSQL, SQLite, SQL, PL/SQL, UNIX Shell Script
  • Database: MySQL, MSSQL, SQLite, ORACLE (10g/11g/12c), MS SQL Server (2005/2008)
  • Tools: MySQL Workbench, Postman, SQL Developer, TOAD, Eclipse, SOUP UI

Experience & Project Details

Role

Period

Project Details

Database Developer and Support

Jan 2021- Till now

Project: WovVOken / WovVMOken

Tech Stack: MySQL Workbench, Postman

Project Description: OKEN SaaS platform bridges the gap between mall owners & customers. Mall owners provide customers information on turn-by-turn directions within the mall, GPS parking, discounts, store/ brand directories & special offers served within the app to make customers’ mall experience graceful.

The mall management and loyalty app provide a channel for on-the-fly access to precise information & customer engagement. It pumps up users’ shopping vibes at all levels – savings through rewards and gift vouchers, dining, store/ brand browsing & accessing restrooms and other amenities within the mall.

Project: WovVRA

Tech Stack: MySQL Workbench, Postman

Project Description: WovVRA is an intelligent business automation tool that enables concessionaires to record Automated Daily Sales Reports to increase revenue share. Concessionaires can maximize revenue using smarter analytics and accurate daily sales reports leading to better RoI.

ADSR software to capture sales data with all billing and revenue information from property owners, concessionaires, airports, and shopping centers & malls. performances, analyze sales trends, compare multiple locations’ data and more with advanced built-in analytics reports.

Database Developer and Support

July 2019- Dec 2020

Project: Goods Inwards System (GIS)

Tech Stack: Oracle 12c, SQL Developer, Service Now

Project Description: Goods Inwards System (GIS) is an integrated Module, which covers the activities of Stores, Purchase and Goods Inwards Functions of a Manufacturing Organization. This Module has provisions to capture Supplier Details (Vendors) required for the Purchase Department

Database Developer

June 2018- June 2019

Project: Captive Power Plants (CPP) Database

Tech Stack: Oracle 11g, Toad, BMC Remedy

Project Description: This system basically maintains the details of the power generated by the captives in the state and their usage of the power by the consumers and allows the GERC to generate the timely reports as per the requirement.

Overall Roles and Responsibilities

  • Design Data structure
  • Query Creation/ API Creation for every functionality
  • Create function, procedure and report
  • Production support/issue handling related WovVOken/WovVMOken
  • Setup utility at client system, create connection with client database
  • Adapter query creation and mapping
  • Create function, procedure and report
  • Production support/issue handling of wovVRA
  • Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  • Worked extensively on Ref Cursor, External Tables and Collections.
  • Expertise in Dynamic SQL, Collections and Exception handling.
  • Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
  • Interface with other support groups providing assistant and guidance as required.
  • Involved in writing PL SQL procedures, Functions, packages, and UNIX shell program for Daily data loading jobs and monthly data aggregate process.
  • Wrote simple stored procedures in PL/SQL to be called by batch processes.
  • Handling data quality issues, performance tuning, validating database data, responsible for troubleshooting and providing corrective solutions with a strong customer focus
  • Performed Unit testing of the PL/SQL code.
 
Matching Resources
My Project History & Feedbacks
Copyright : 2022 – OnBenchMark All Right Reserved.
Loading…

stuff goes in here!