PROFESSIONAL SUMMARY:

• 9 Year’s 08 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
• Working experience of Oracle supplied packages like UTL FILE, DBMS CRYPTO, DBMS JOB, DBMS LOB, DBMS MVIEW etc. Strong Technical expertise in SQL, PL/SQL, SQL Tuning, UNIX, Basic DBA Skills and CA Erwin Tool.
• Hands on experience in SQL Tuning, Unix Shell Scripting
• Expert knowledge of new features in Oracle 11g, such as Virtual Columns, Flashback Table, PIVOT and UNPIVOT queries, Scheduling and processing and in Oracle 12C like FETCH FIRST, Implicit Statement Results and InvisibleColumns etc.
• Worked on data extraction from various source sources like Oracle 12C/11g/10g, DB2, and Complex Flat Files.
• Extensive experience in creating XML files to store data and making them available when necessary.
• Understanding and working experience in CA ERWIN 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.
• Expert in performing Oracle SQL Tuning on the Developed Code using Explain Plan, Optimizer Hints, TKProf, partitioning, Statistics and Automatic Workload Repository.
• Expert in creating database objects like tables, views, sequences, synonyms, indexes, materialized. Debugging PL/SQL codes to identify the root cause of the issue and resolve it.
• View and worked closely with DBA on partition maintenance, index maintenance, Compression etc.
• Worked on Advanced PL/SQL concepts like Varrays, Associative Arrays, Nested Tables, Autonomous Transaction, PL/SQL optimization, Pipelined Table Functions and Bulk Binding
• Expertise on Oracle and UNIX development tool set (Like SQL*Plus, SQL Loader, SQL developer, TOAD, Putty, Win SCP).
• Having a basic awareness of Data warehousing concepts and Informatica. Having a basic awareness of reporting tool Cognos, Crystal Report and Oracle Report.
• Experience with version control (Tortoise SVN, SVN), change management and defect tracking systems (HP Quality Centre).
• Proven ability to quickly learn and apply new technologies
• Basic understanding and knowledge of Java/J2EE technologies
• Experience with Agile Methodology.
• Strong communication, interpersonal, analytical & team building skills with proficiency at grasping new concepts quickly and utilizing the same in a productive manner.

TECHNICAL SKILLS:

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

Tools: /Utilities: PL/SQL Developer, Oracle SQL Developer, Toad, CA Erwin Tool, SQL*LOADER

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

Database: Oracle R11, Oracle 12C, SQL SERVER 2005

Operating Systems: MS: DOS, Windows 7, Windows 2000, XP, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Ridgeland, MS

PL\SQL Team Lead

Primary Skills: SQL, PLSQL, SQL Tuning, UNIX Shell Scripting

Responsibilities:

• Performed maintenance for Mississippi State New Medicaid Eligibility Determination system.
• Worked on the merging the legacy MEDS system with New MEDS
• Solid understanding of Relational Data modeling and Normalization.
• Designed/modified design of database Tables, Constraints, Indexes, Grants, Packages, Functions and Procedures etc.
• Worked on External Tables and preparing files using Oracle Supplied Packages. Developed Database Triggers for audit and validation purpose.
• Experienced in troubleshooting SQL statements to increase the overall performance as part of Performance tuning.
• Worked on Oracle 12c new Features like FETCH FIRST, Implicit Statement Results and InvisibleColumns etc.
• Used Cursors, Ref - cursors, Bulking techniques, Collections and Dynamic SQL.
• Extensively used to generate XML code from oracle by using XMLELEMENT, XMLForest and XMLConcat etc.
• Used advanced PL/SQL concepts like Table Functions, Advanced Queuing.
• Perform Bulk-testing on the code changes and code review
• Took the responsibility of leading the offshore team.
• Designed and developed UNIX shell script to schedule the batch job and for receiving\sending files to Federal and State worksites

Confidential, Detroit, MI

Sr. PL/SQL Developer

Primary Skills: SQL, PLSQL, SQL Tuning,

Responsibilities:

• Design and Development of the TDI Database. Involved in the whole life cycle of the project.
• Understanding and gathering the business requirements for TDI Application
• Translated business/functional requirements to create and alter database objects like Tables, Indexes, Constraints, Indexes, Types, Grants, Synonyms, Queues, Queues Tables and Stored Procedures.
• Develop software, architecture specifications and business logic in Oracle using Stored Procedures, Packages, Functions and Views.
• Tuning queries/procedures for the application. UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Responsible for ensuring coding standards are followed at each phase of development.
• Responsible for estimation, planning and execution
• Worked on Oracle 11g new Features like Invisible Index and Virtual columns etc.
• Performing the code fixes for the developed code to meet the requirement
• Responsible for creating Detail design document, unit test cases, change request document and mapping documents for reporting.
• Responsible for people management, including goal setting and providing performance feedback.
• As an onsite resource passing the business requirements to the offshore team, coordinating with offshore team to get the assigned technical work completed, updating the offshore status to the customer on an ongoing basis.

Confidential, Naperville, IL

Onsite Team Lead

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

Responsibilities:

• Supported Confidential application as Onsite Team Lead in addition to the project work.
• Worked on identifying the main tables and their dependent tables that are to be effected in Confidential project
• Creation oftable space, indexes, user and database objects liketables, views, materialized views, procedures and packages using Oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Prepared the queries for deleting the BP Related data from the Cloned Application and archive the Confidential data using scripts
• Analyzing the Oracle objects and modify them in both applications according to the requirement.
• 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
• Implemented multiple Change Requests in GC and prepared reports as and when required
• Prepared and executed unit test cases
• Worked with DBA for setting up the Database Replay functionality for testing purpose.
• Modified UNIX shell script for scheduling the batch jobs for Confidential Project.
• Analyzing available information applying experience and system knowledge to diagnose problems and identify solutions to meet user requirement.
• Took the responsibility of leading the offshore team.
• Worked as a Business Analyst in Confidential for their Windows 7 Migration.

Confidential

Offshore Team Lead Developer

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

Responsibilities:

• Capturing business knowledge by closely working with customer technical teams and set of business users and documenting it in BRD.
• Design and developing packages, Stored Procedures, functions, SQL Scripts, Packages and Shell Script
• Worked on various tables to create Indexes to improve query performance and Oracle Statistics to improve query performance
• Used the concepts of Advanced PL/SQL concepts like Autonomous Transaction, PL/SQL optimization, Pipelined Table Functions and Bulk Binding during Confidential development
• 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
• Designing and modifying Database model using CA Erwin Tool.
• Adhere to full software development life cycle.
• Created programming code using advanced concepts of Records, Collections.

Confidential

Junior PL\SQL Developer

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

Secondary Skills: Core Java, J2EE, Java Script

Responsibilities:

• Migration of the Data source of PCMF from IPS-Haht application to SAP
• Performed data monitoring, testing and prepared the reports, which helped in smooth transition of application
• Created database objects like tables, views, Procedure etc.
• Preparing multiple Queries as per User Interface (UI).
• Maintenance of PCMF 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 CVS and Tortoise 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
• Responsible for creating a data model, ER diagram by using used cases.

Confidential

Reports Developer

Primary Skills: SQL, PL/SQL, Microsoft Excel

Responsibilities:

• Prepared daily, weekly and monthly data reports for Confidential and delivering them at the right time
• Worked with Database Administrators (DBAs) to add some hints in Extract SQL as required per Explain plan of the SQL to gain efficient performance results.