Client: < USA base Global Manufacturing Services Company>Role: Application Developer - SQLDuration: September 2017- PresentResponsibilities:• Worked on all phases of SDLC.• Developed and enhanced stored procedures for application functionalities.• Worked on Pl/SQL exception handling. • Was involved in designing phase for several modules along with the architects.• Worked with Data model team to ensure the data modelling requirement of the application is fulfilled.• Created Test cases for testing team.• Was responsible for unit testing and system integration testing.• Was responsible for tuning all SQL queries present in the application.• Was responsible for working with BAs and clients to get complete requirement understanding for the team and then developing final logic.• Experience of creating documents of implements as well as design solution (SDD).• Was responsible for working on multiple modules of application at a time.• Ensured the adherence of the code to the project standards • Always ensured the adherence of quality deliverable to stringent timelines.

Client: < USA base Manufacturing Company>Role: SQL Developer and Performance TuningDuration: August 2016- July 2017Responsibilities:• Worked as a SQL developer to support business applications using Oracle SQL and PL/SQL.• Worked on packages, procedures, triggers, collections and exception handling.• Designed and created database tables, indexes, views and stored procedures.• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.• Developed new processes to facilitate import and normalization.• Worked with business users and application developers to identify business needs and provide solutions.• Wrote and performed test procedures.• Fast Forward Training on Tableau, Teradata and Big Data• Big Data Enablement Program (collaboration with Big Data University)

Client: < USA base Engineering and Manufacturing Company>Role: PL/SQL Developer and Performance TuningDuration: November 2013 – July 2016Responsibilities:• Worked on creating packages, procedures, triggers, views and synonyms.• Worked on Pl/SQL exception handling.• Worked on table partitioning.• Worked on all phases of SDLC.• Was responsible for tuning the new codes developed.• Was involved in unit testing phase.• Was responsible to analyze and tune the older codes.• Used tools like tkprof, SQL Profiler, AWR and TOAD.• Worked on various level of traces• Worked on basic UNIX commands and created shell scripts for packages and cron jobs• Had frequent communication with the client and onsite counterparts to understand the requirement and resolve the clarifications• Was responsible to tune the issues in concurrent programs and discoverer reports• Ensured the adherence of the code to the project standards • Always ensured the adherence of quality deliverables to stringent timelines• Have been instrumental in supporting Production environment and resolving performance issues during migration and upgradation