Mounika J.

Mounika J.

Expert in writing complex sql queries and procedures

, India

Experience: 4 Years

Mounika

Expert in writing complex sql queries and procedures

20018.4 USD / Year

  • Notice Period: 30 Days

4 Years

Now you can Instantly Chat with Mounika!

About Me

Over 2.5 years of experience in Information Technology and a wide range of progressive experience in Data Warehousing and Business Intelligence, working experience as a backend developer in Application Management area.  Strong knowledge in SQL,...

Show More

Portfolio Projects

Swire

Company

Swire

Description

CLIENT: COCA COLA

Show More Show Less

Skills

MS Office

IKEA – EMIL (RETAIL SECTOR)

Company

IKEA – EMIL (RETAIL SECTOR)

Description

CLIENT: IKEA, SWEDEN

IKEA is a Swedish multinational group that designs and sells ready-to-assemble furniture, kitchen appliances and home accessories. It has been the world's largest furniture retailer since at least 2008.It is an AMS project with minor or major enhancements like CRs, requirements for developing new Services and solutions, and maintaining the Applications, providing the 24/7 support in BI (Business Intelligence) area. ROLES & RESPONSIBILITIES:  Deliver PBIs and CRs and create/maintain high quality of documentation like AOs, RCAs, DRs and other business-related documents.  Work on incidents where the SQL (query) needed to be written manually to compare the data with DB.  Offer strong analytical skills as working in AMS team in data level issues.  Support for all Control-M Jobs & give Proper resolution within SLA if any Control-M Job failed.  Work on EP (Emergency Patch), where the code need to be analyzed and tested and should be deployed within short span of time (1 day).  Work on CR, where data check will be done in particular area and mail will be sent to respective teams if any data is missing.  Work on complicated incidents and analyzed the issue, provided the resolution to the clients.  Communicate with source teams for data related issues and attended meetings with Source.  Work on High incidents –Data level issues, analyzed to get generic solutions.

Show More Show Less

BLUETOOTH CONTROLLED ROBOT USING ANDROID MOBILE Technologies AndroidRobot Framework

Company

BLUETOOTH CONTROLLED ROBOT USING ANDROID MOBILE Technologies AndroidRobot Framework

Description

xTechnologies

Show More Show Less

Skills

Android

ETL Developer Client: Hawlett Packard, USA

Company

ETL Developer Client: Hawlett Packard, USA

Role

Backend Developer

Description

  • Expertise in identifying and analyzing the business need of the end-users and building the project plan to translate the functional requirements into the technical task that guide the execution of the project.
  • Develop Scripts related to Data Migration activity and Involved in writing procedures, functions in PL/SQL.
  • Develop watchdog framework scripts related to missing data using complex stored procedures and cursors.
  • ON-TIME Remediation's for the failed DAGS in AIRFLOW.
  • Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Joiner and Rank.

Show More Show Less

SQL Developer Client: IKEA, SWEDEN

Company

SQL Developer Client: IKEA, SWEDEN

Description

  • Participated in client business need discussions and translating those needs into technical executions from a data standpoint
  • Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
  • Developed highly optimized stored procedures, functions, and database views to implement the business logic also created clustered and non-clustered indexes.
  • Involved in performance monitoring, tuning, and capacity planning. Tuned the slow performance queries by looking at Execution Plan
  • Responsible for implementation of data viewers, Logging, error configurations for error handling the packages. Involved in the complete life cycle in creating SSIS packages, building, deploying, and executing the packages in both environments (Development and Production).

Show More Show Less

Technology Analyst (Snowflake Developer) Client: CATERPILLAR, US)

Company

Technology Analyst (Snowflake Developer) Client: CATERPILLAR, US)

Role

Backend Developer

Description

  • Loading data into snowflake tables from the internal stage using Data modelling technique-Data walmart
  • Writing complex snowsql scripts in snowflake cloud data warehouse to business analysis and reporting
  • Performed data quality issue analysis using Snow SQL by building analytical warehouses on Snowflake Experience with AWS cloud services
  • Perform troubleshooting analysis and resolution of critical issues

Show More Show Less
Share: