SUMMARY:

• A seasoned IT professional having 7+ years of experience in Software Development, Maintenance and Production Support and Business Analysis using Oracle PL/SQL, UNIX and Pro C.
• Involved in various SDLC methods (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expertise in Client - Server application development using Oracle11g/10g, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Strong experience in key concepts, such as PL SQL Triggers, Procedures, Functions, Cursors, DBMS schedulers to call shell scripts via oracle procedures.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• Data loading from flat files/Excel into DB2/Oracle tables.
• Worked extensively onRef Cursor,Collections,Bulk Collect.
• Extensive knowledge in Performance Tuning mechanisms in PL/SQL .
• Expertise inDynamic SQL,and Exception handling.
• Experience in SQLQueryperformance tuningusing Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes.
• Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
• Extensively worked at analyzing AWR reports and monitored the queries for performance improvements.
• Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• Result oriented, self-starter and able to work with minimum guidance.
• Good experience in Team Leadership with excellent Communication, Management and Presentation skills.
• Hands-on experience in defining metrics and collection, tracking as well as reporting of metrics.
• Strong experience in creating Business documents, Functional documents, Wireframe documents, Technical documents etc.
• Proven ability to understand business problems and apply technology to formulate workable solutions.
• Hands on Experience in handling critical Business applications Issues and handling failure recoveries.
• Sound knowledge in Health Care domain working with CVS and Health net.

TECHNICAL SKILLS:

Programming Languages: C, C++, C#

Operating System: Windows, Linux, UNIX

Databases Worked: Oracle 9i, 10g, 11g

Tools: Used: PL/SQL Developer,RDBMS,Oracle SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential

Senior PL/SQL Developer

Responsibilities:

• Analyzed the requirements from Design document and prepared solution document that can be utilized by the team.
• Created Stored procedures, functions etc that can be used to retrieve the desired data from the extract and load into different data base tables based on the business rules and send the data to the Engage One server for mail service .
• Experience working with Sequences, Indexes, Views, Table Partitioning, Collections, Analytical functions and Materialized Views.
• Created Global temporary tables for the ease of getting rid of 'scratch' data. This helps in truncating the data explicitly, without affecting anyone else (or allow the implicit "truncate on commit / exit" effect to do

  the same thing

• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Ref.Cursors, Nested tables and Dynamic SQL.
• Developed unix shell scripts in order to check the data files received from the source application.
• Also worked in preparing different scripts inorder to do data quality check for the input files and making the data move through different data quality process like staging, data quality, Profiling, Seeding, Spooling, Proofing etc before sending for print.
• Strong knowledge in Oracle utilities like SQL*Loader
• Experience with SQL script migrations into Datastage
• Created various database objects as per the requirement.
• Developed shell scripts to read the extracts and prepared reports that can be sending securely via SSH.
• Done unit testing for the deliverable and provided support for SIT/UAT phases.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile
• Deep knowledge of System and database architecture: design, modeling and implementation
• Client coordination.

Confidential

Senior PL/SQL Developer

Responsibilities:

• Serve as technical lead of an offshore team of 6 members for the design and development of new projects in the data base application in Oracle PL/SQL.
• Prepared effort estimation for the project activities.
• Analyzed the requirements from FRS and prepared solution document that can be utilized by the team.
• Created stored procedures, functions and packages that can be used to retrieve the desired data.
• Experienced working with Oracle PL/SQL Functions, Sequences, Indexes, Views, Table Partitioning, Collections, Analytical functions, Materialized Views.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Ref.Cursors, Nested tables and Dynamic SQL.
• Extracted data from different flat files, MS Excel,,MS Acess and transformed the data based on user requirement using Informatica and loaded data into Target sessions.
• Experience setting up batch jobs using crontab and scheduler.
• Analyzed AWR reports from Oracle 10g/9i database for Oracle wait events, time consuming SQL queries, tablespace growth, database growth
• Worked on Performance tuning by analyzing on the explain plan and cost of the query.
• Strong knowledge in Oracle utilities like SQL*Loader
• Created various database objects as per the requirement.
• Developed unix shell scripts to read the extracts and prepared reports that can be sending securely via SSH.
• Done unit testing for the deliverable and provided support for SIT/UAT phases.
• Experience in Reports Development and Data Migration from flat files to Oracle Database using SQL Loader through scheduled batch operations.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile
• Deep knowledge of System and database architecture: design, modeling and implementation
• Client coordination.
• Hands on experience in support activities.
• Offshore - On shore coordination.
• Involved in knowledge transition, creation and execution of plan for new team members.
• Worked on high priority Incident, Problem tickets, QC defects and able to provide consistent solutions to business users within the time frame.

Confidential

PL/SQL Developer

Responsibilities:

• Business requirement analysis and preparing BSD documents.
• Detailed understanding of the application and providing better solutions for the requirement.
• Wrote complex stored procedures in PL/SQL to be called by UI through web service.
• Preparing unit test cases handling all the scenarios as per the design
• Development activities for the assigned modules
• Data Migration activities using UTL FILE Package.
• Job Scheduling activities using Crontab.
• Actively involved in unit testing and help SIT/UAT.
• Responsible to prioritize the activities and delivery.
• Offshore Onshore coordination.

Confidential

PRO*C Developer

Responsibilities:

• Provided estimation and project plan for enhancements prior to commencement of the project.
• Analyzed the services which are being called from front end of the Team RX, POWER, PROMISE, CORPED applications which are being used by Walgreens to run its pharmacy operations.
• Extracted the business rules for each of the services in the application and documented to the client.
• Involved in performing feasibility analysis wherever applicable for enhancement requests.
• Done minor enhancements on the rules as per the feedback from the clients. This helps in improvising the existing design performance with less cost.

Confidential

PRO*C Developer

Responsibilities:

• Analyzed the existing application code and proposed technical solutions and alternatives for future enhancements.
• Developed the code with minimal defects meeting the coding standards.
• Prepared effective test cases for the modules handling all the business scenarios.
• Performed unit testing for the deliverables and provided extended support for UAT/SIT.
• Created UNIX shell scripts for handling the business requirements.
• Involved in impact analysis of data fix and provide necessary solution if required.
• Maintain the defect log and status reporting.
• Communicate with client for enhancements, new requirements and provide effective solutions.