Sql Developer Customer Experience

Mabula Shaik

Denver/Superior, CO +1-720-***-****

************@*****.***, www.linkedin.com/in/mabula-shaik220822, L2 EAD 8.7 Years of Experience in SQL Developer and PL/SQL Developer, I am Enthusiastic, positive, and Passionate about data and the commercial benefits of it. Predicting things that helps for business growth is my AIM. EDUCATION:

RVR & JC Collage of Engineering (Autonomous) – Bachelor’s in Electronic & Communication Engineering. Apr 2016 SKILLS:

Languages: SQL, PL/SQL, Python, UNIX, Shell Scripting. Tools: Cognos Report Studio, SAP BI Launch Pad User Interface, Putty, WinSCP, GIT Hub, SQL Developer, Toad, DBeaver, Beyond Compare. Databases: Oracle, MSSQL.

Operating Systems: Windows & Mac.

WORK EXPERIENCE:

Contract Lifecycle Management (CLM) – Infosys (Apple Client) – 2023(Feb) – 2025(Jan) -Technology Lead

• As a Lead developer, I used to handle multiple projects and enhanced the applications to improve the customer experience.

• Monitored production jobs to ensure smooth daily data loads in ETL batch processing, identifying and addressing issues proactively.

• Collecting the requirement from client, Design, develop, test and implemented the multiple changes requests (CR’s), Requirement gap fillers.

• Maintained clean, well-organized code repositories, ensuring efficient collaboration.

• Delivered the multiple features and improved the reports (IBM Cognos reports & SAP BI Launch pad reports) performance.

• Created and optimized stored procedures leveraging critical configuration tables to streamline data processing and ensure efficient querying. Asian Development Bank (ADB) – Infosys (ADB Client) - 2019(Aug) – 2023(Jan) -Technology Analyst

• Involved in Migration of Code from a given environment to another. For e.g.: Movement of Mappings, workflows & components related to it from One Environment (Code was in COBOL) to New Environment (Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages)).

• Collecting the requirement from client, Design, develop, test and implemented the multiple changes requests (CR’s), Requirement gap fillers.

• Created Documentation of development code and the test cases involved.

• Expert to identify the issues and resolve the issue asap.

• Good analysing skills.

• Involved in the development of new Procedures, Functions, Packages, Triggers and also updating the old ones based on the change requests.

• Read data from flat files and load into Database using SQL*Loader.

• Extensively worked with “With” Clause, Temporary tables & SYS RefCursors.

• Experience in creation of Synonyms, Constrains and Joins.

• Hands on experience in creation of Views.

• Experience in DEV, SIT, UAT & Prod Testing.

• Worked extensively on Exception Handling, to trouble-shoot PL/SQL code.

• Hands of experience in Analytical functions.

• Hands of experience in Aggregate functions.

• Monitoring existing SQL code and performance Tuning if necessary.

• Extensively worked on ETL.

Bayer Health Care – Accenture - 2019(Feb)-2019(Jul) - Application Development Analyst

• Worked on multiple internal projects to improve the performance.

• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).

• Monitoring existing SQL code and performance Tuning if necessary.

• Used Python to develop a variety of models for analytic purposes. State Bank of India (SBI) – Tata Consultancy Services 2016(Jun) - 2019(Feb) – System Engineer

• Collecting the requirement from client, Design, develop, test and implemented the multiple changes requests (CR’s), Requirement gap fillers.

• Involved in the development of new Procedures, Functions, Packages, Triggers and also updating the old ones based on the change requests.

• Worked extensively on Exception Handling, to trouble-shoot PL/SQL code.

• Hands of experience in Analytical functions & Aggregate functions.

• Monitoring existing SQL code and performance Tuning if necessary.

• Performance suggestions and Performance Impact reviews for other development teams.

• Proficient in research of current process and emerging new changes which user interface needs.

• Hands on experience in Collections, Records, Ref Cursors, bulk collect & bulk bind.

• Hands on experience in creation of Index’s, Synonyms, Views & Materialized views.

• Identification of transaction which is taking more time and tuning them from the perspective of reducing the response time. Main motive is to reduce the average response time of a transaction in SBI Bank.

• Intelligence logging mechanism for better analysis of online transaction.

• Experience in Query optimization using Explain plan.

• Hands on experience in SQL DDL, DML & DCL commands.

• Experience on standard Unix Commands.

Contact this candidate