SUMMARY:

• 8 Year’s 4 Months experience in analysis, design, development and implementation of Software development Life cycle (SDLC). Responsibilities included analyzing the client requirements, preparing specifications, development of the SQL Queries, Database design, Post implementation support and preparing the user documentation.
• Working as a Tech Lead Position in reputed organization and had experience in leading a small team
• Worked as a Business Analyst in Confidential for their Windows 7 Migration Project.
• Strong Technical expertise in SQL, PL/SQL, SQL Tuning, UNIX, Basic DBA Skills and CA Confidential Tool.
• Hands on experience in SQL Tuning, Unix Shell Scripting
• Understanding and working experience in CA Confidential Tools and basic DBA Skills
• Team player with the ability to communicate effectively in all the levels of development process
• Interface professionally and communicate easily with customers and team members.
• Proficient in writing PL/SQL Packages, Procedures, Functions, Triggers, Views, Index, Synonyms
• Sequences, Views and Materialized views.
• Expert in performing Oracle SQL Tuning on the Developed Code using Explain Plan, Optimizer Hints, TKProf, partitioning, Statistics and Automatic Workload Repository.
• Worked on Advanced PL/SQL concepts like Varrays, Associative Arrays, Nested Tables, Autonomous Transaction, PL/SQL optimization, Pipelined Table Functions and Bulk Binding
• Proven ability to quickly learn and apply new technologies
• Basic understanding and knowledge in Java/J2EE technologies
• Experience with Agile Methodology.

TECHNICAL SKILLS:

Technical skills & Languages: SQL, PL/SQL, SQL Tuning, Unix shell scripting

Tools: PL/SQL Developer, Oracle SQL Developer, Toad, CA Confidential Tool

Secondary Skills: Java/J2EE, HTML, DHTML, XML

Database: Oracle R11, SQL SERVER 2005

PROFESSIONAL EXPERIENCE:

Confidential, Ridgeland, MI

Programmer Analyst

Primary Skills: SQL, PLSQL, SQL TuningMOD MEDS project involves the maintenance of the automated eligibility determination system that determines the eligibility of the Mississippi state applicants

Responsibilities:

• Worked on identifying the main tables and their dependent tables
• Design and Development of the Confidential Database.
• Preparing PL/SQL Packages, Procedures, Functions, Triggers, Views, Index, Synonyms
• Sequences, Views and Materialized views.
• Performing Oracle SQL Performance Tuning on the Developed Code using Explain Plan, Optimizer Hints, TKProf, partitioning and Automatic Workload Repository.
• Worked on Advanced PL/SQL concepts like Varrays, Associative Arrays, Nested Tables and Bulk Binding
• Worked on the XML related packages for sending XML data to MMIS and Blaze
• Worked on Oracle 11g new Features like Invisible Index, Database Replay, Virtual columns etc
• Worked on designing and modifying Database model using CA Confidential Tool.
• Prepared and executed unit test cases
• Performing the code fixes for the developed code to meet the requirement
• Took the responsibility of leading the offshore team.

Confidential, Detroit, MI

Programmer Analyst

Primary Skills: SQL, PLSQL, SQL TuningGM OnStar TDI Project involves the automation of the GEN 10 Units set up in the Test Environments using TDI Website for testing purpose.

Responsibilities:

• Worked on identifying the main tables and their dependent tables
• Design and Development of the TDI Database.
• Preparing PL/SQL Packages, Procedures, Functions, Triggers, Views, Index, Synonyms
• Sequences, Views and Materialized views.
• Performing Oracle SQL Performance Tuning on the Developed Code using Explain Plan, Optimizer Hints, TKProf, partitioning and Automatic Workload Repository.
• Worked on Advanced PL/SQL concepts like Varrays, Associative Arrays, Nested Tables and Bulk Binding
• Worked on Oracle 11g new Features like Invisible Index, Database Replay, Virtual columns etc
• Worked on designing and modifying Database model using CA Confidential Tool.
• Prepared and executed unit test cases
• Performing the code fixes for the developed code to meet the requirement
• Took the responsibility of leading the offshore team.

Confidential, Naperville, IL

Programmer Analyst

Primary Skills: SQL, PLSQL, SQL Tuning, UNIX Shell Scripting, Oracle DBA and CA Confidential Tool

Responsibilities:

• Worked on identifying the main tables and their dependent tables that are to be archived in Confidential
• Prepared PL/SQL Packages, Procedures, Functions, Triggers, Views, Index, Synonyms
• Sequences, Views and Materialized views.
• Performed Oracle SQL Performance Tuning on the Developed Code using Explain Plan, Optimizer Hints, TKProf, partitioning, Statistics and Automatic Workload Repository.
• Worked on Advanced PL/SQL concepts like Varrays, Associative Arrays, Nested Tables, Autonomous Transaction, PL/SQL optimization, Pipelined Table Functions and Bulk Binding
• Prepared the queries for deleting the old data from the Confidential archival
• Helped the user in testing the integrity of the database in test and production
• Supported Confidential application as Onsite Team Lead
• Implemented multiple Change Requests in GC and prepared reports as and when required
• Prepared and executed unit test cases
• Took the responsibility of leading the offshore team.
• Worked on UNIX Shell Scripts for Confidential archival
• Worked on designing and modifying Database model using CA Confidential Tool.
• Worked as a Business Analyst in Confidential for their Windows 7 Migration.

Confidential

Oracle Developer

Primary Skills: SQL, PLSQL, SQL Tuning, UNIX Shell Scripting, CA Confidential Tool

Responsibilities:

• Worked on identifying the main tables and their dependent tables that are to be archived in Confidential
• Prepared PL/SQL Packages, Procedures, Functions, Triggers, Views, Index, Synonyms
• Sequences, Views and Materialized views.
• Performed Oracle SQL Performance Tuning on the Developed Code using Explain Plan, Optimizer Hints, TKProf, partitioning, Statistics and Automatic Workload Repository.
• Worked on Advanced PL/SQL concepts like Varrays, Associative Arrays, Nested Tables, Autonomous Transaction, PL/SQL optimization, Pipelined Table Functions and Bulk Binding
• Helped the user in testing the integrity of the database in test and production
• Design and development of Confidential application
• Implemented multiple Change Requests in GC and prepared reports as and when required
• Prepared and executed unit test cases
• Created UNIX Shell Scripts for Job Scheduling and Automation.
• Worked on designing and modifying Database model using CA Confidential Tool.

Confidential

Offshore Team Lead,

Primary Skills: SQL, PL - SQL, SQL Tuning, UNIX Shell Scripting

Responsibilities:

• Migration of the Data source of Confidential from IPS-Haht application to SAP
• Performed data monitoring, testing and prepared the reports, which helped in smooth transition of application
• Prepared PL/SQL Packages, Procedures, Functions, Triggers, Views, Index, Synonyms
• Sequences, Views and Materialized views.
• Performed Oracle SQL Performance Tuning on the Developed Code using Explain Plan, Optimizer Hints, TKProf, partitioning, Statistics and Automatic Workload Repository.
• Worked on Advanced PL/SQL concepts like Varrays, Associative Arrays, Nested Tables, Autonomous Transaction, PL/SQL optimization, Pipelined Table Functions and Bulk Binding
• Maintenance of Confidential and prepared reports on demand
• Developed java client application for Pepsi Cola Master File online
• Contributed in the preparing a web application for effort tracking in Pepsi.
• Experience in working with Confidential and Confidential SVN
• Experience in working in Java/J2EE for POLR application and EPM Applications
• Prepared and executed unit test cases
• Worked on Unix Shell Scripts for Job Scheduling and Automation.
• Understanding of Extract, Transform and Load
• Worked on designing and modifying Database model using CA Confidential Tool.