EXPERIENCE SUMMARY

• Over 12 years of experience in application development using Agile and traditional methodologies.
• Strong knowledge in developing PL/SQL objects such as Procedures, Functions, Packages, Views, Materialized views, DB links & Triggers.
• Experience in Query optimization, Performance Tuning (PL/SQL) using Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Rich experience in writing PL/SQL objects using Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL.
• Strong knowledge in Oracle files handling utilities such as SQL loader & UTL FILE.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Strong Knowledge on Oracle Architecture and Database Design.
• Excellent conceptual knowledge of Oracle 10g/11g, PL/SQL and SQL.
• Experience in data migration from SQL Server to Oracle, Oracle to SQL Server and MS Access to Oracle.
• More than 2 Years of Life sciences/ Pharmaceutical domain experience in the field of I - Many Medicaid, Government Pricing, Chargeback, contract sales and Rebate management/processing system.
• Experience in development of various price type like AMP, BP, ASP, NFAMP etc. to comply with CMS and VA regulation Pre-DRA and DRA ruling as well as knowledge of FSS, NFAMP calculations for Big4 and OGA pricing for VA.
• Hands on experience on Medicaid Classic V8.5 and Medicaid Contract sphere V7.0.
• Good functional and technical knowledge on I-MANY GP and Medicaid.
• Designed and coded I-Many SQL Packs and Report Packs for updates associated with smoothing and blending of AMP and ASP.
• 8 Months of experience in Facets 5.1.
• Experience in requirement gathering and analysis including Analyzing the requirement document sent by the client and interacting with them to arrive at the optimal solutions for their requirements as well as creating Technical design document based on the requirement document provided.
• As a part of competency development team ensures that all the new members in the team are technically competent for working in projects and always support them and encourage them.
• A Self-starter with a positive attitude, willingness to learn new concepts and confront challenges.
• Experience in the field of I-Many Medicaid, Government Pricing, Chargeback, contract sales and Rebate management/processing system.
• Experience in development of various price type like AMP, BP, ASP, NFAMP etc. to comply with CMS and VA regulation Pre-DRA and DRA ruling as well as knowledge of FSS, NFAMP calculations for Big4 and OGA pricing for VA.
• Hands on experience on Medicaid Classic V8.5 and Medicaid Contract sphere V7.0.
• Designed and coded I-Many SQL Packs and Report Packs for updates associated with smoothing and blending of AMP and ASP.
• Requirement gathering and analysis including Analyzing the requirement document sent by the client and interacting with them to arrive at the optimal solutions for their requirements as well as creating Technical design document based on the requirement document provided.

TECHNICAL SKILLS

Languages: SQL, PLSQL, Shell scripting

Databases: Oracle 11g/10g/9i, SQL Server 2012/2008, MS Access, Sybase

Scripting: UNIX Shell Scripting

Development Tools: TOAD, PL/SQL Developer, Putty

Other Tools: MS Visio, Erwin, MS Project Plan, HP Quality Center and Rally

Version Control: DB Maestro, Tortoise SVN, VSS

Operating Systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Team Lead

Technologies ORACLE, UNIX, XML and PowerBuilder

Responsibilities:

• Gathering requirement from Business.
• Coordinate with the business for the approval of the design.
• Designing and development of database objects, procedures, functions with optimum performance
• Coordinating with offshore team to help them to complete the task in time.
• Review the developed source code to ensure it meets the requirement.
• Review the performance of the code before it delivers to the quality team.

Confidential, Jessup, PA

SQL Senior Developer and Onsite/Offshore coordinator

Responsibilities:

• Strong knowledge in developing SQL objects such as Procedures, Functions, Views, Materialized views, DB links & Triggers.
• Experience in Query optimization, Performance Tuning.
• Managing offshore developers in India and driving the project as an Onsite lead.
• Gathering requirement from Business and Products teams.
• Assign the task between onsite and offshore team and coordinate with the client and the business for the approval of the design.
• Designing and development of database objects, procedures, functions with optimum performance
• Coordinating with offshore team to help them to complete the task in time.
• Review the developed source code to ensure it meets the requirement.
• Review the performance of the code before it delivers to the quality team.
• Strong knowledge in developing PL/SQL objects such as Procedures, Functions, Packages, Views, Materialized views, DB links & Triggers.
• Experience in Query optimization, Performance Tuning (PL/SQL) using Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Develop PL/SQL objects using Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL.
• Worked with third party database tools like TOAD & PL/SQL Developer.
• Managing the agile process for development by conducting scrums and reporting progress to the management.
• Managing offshore developers in India and driving the project as an Onsite lead.
• Gathering requirement from Business and Products teams during the user story grooming and sprint planning sessions.
• Designing and development of database objects, procedures, functions, packages with optimum performance
• Capacity planning and coordination with other teams for integration of different modules to application developed using ESB and ASP.Net
• Worked on complex collection objects with multiple nested tables

Confidential, Wilmington, DE

Lead and Onsite/Offshore coordinator

Responsibilities:

• Worked in Query optimization, Performance Tuning (PL/SQL) using Explain Plan, Indexing and Hints.
• Worked on PL/SQL objects using Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL.
• Worked with third party database tools like TOAD.
• Developed various price types like AMP, BP, ASP, NFAMP etc. to comply with CMS and VA regulation.
• Hands on experience on Medicaid Classic V8.5 and Medicaid Contract sphere V7.0.
• Designed and coded I-Many SQL Packs and Report Packs for updates associated with smoothing and blending of AMP and ASP.
• Managing offshore team in India and driving the project as an Onsite lead.
• Gathered requirement for new Government Pricing reports from client.
• Analyzed data and functional issues for existing reports to determine root cause and developed new Government Pricing reports.
• Ensured that all the reports meets the user requirement and runs successfully in Production.
• Managed the entire release of the project for more than 2 quarters
• Mentored the team member for performance tuning and best practices in SQL and PL/SQL

Confidential

Team Lead/Offshore Coordinator

Responsibilities:

• Worked in Query optimization, Performance Tuning (PL/SQL) using Explain Plan, Indexing and Hints.
• Worked on PL/SQL objects using Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL.
• Worked with third party database tools like TOAD.
• Developed Test plan and test cases as part of the migration.
• Developed various technical and process documents for the migration process.
• Managing offshore team in India and driving the project as an offshore lead.
• Involved in end to end planning for migration of Managed Markets complex suite of applications from IBM Datacenter to HCL Datacenter..
• Coordinating with various stake holders to come up with an activity plan for a smooth migration process.
• Provide technical inputs and solutions to counter any technical challenges encountered during the migration process.
• Interacting with the support team to analyze and capture any risk or issues that may create an impact as a result of migration.
• Preparing various technical and process documents required during the migration process.
• Interacting with the audit personals and involve in the audit process to keep a check on the quality of the process being followed.
• Coordinating with Business and other cross vendors to decide on the timelines and schedule of the migration to have the least impact on the business as a result of migration.
• Completion of Data Center transition of Managed Markets Applications with minimal business disruption.
• To maintain similar workings state of the application before and after transition.
• To provide assurance that systems are maintained and transferred with integrity.
• Migration using automated, repeatable, robust methods where possible.
• Provide necessary support to other suppliers in support of the overall migration.
• All associated applications which are in scope of Emerald project will also be moved to new Datacenter and integration testing for those applications with master systems will also be tested as a part of this Migration.

Application Support Associate/Offshore Coordinator

Confidential

Responsibilities:

• Developed various price types like AMP, BP, ASP, NFAMP etc. to comply with CMS and VA regulation.
• Designed and coded I-Many SQL Packs and Report Packs for updates associated with smoothing and blending of AMP and ASP.
• Provided support in monitoring daily scheduled jobs and coordinating with the IBM data center team to fix the data in case of any issue.
• Managing offshore team in India and driving the project as an offshore lead.
• Worked in Query optimization, Performance Tuning (PL/SQL) using Explain Plan, Indexing and Hints.
• Worked on PL/SQL objects using Cursors, Collections, Ref Cursor, Cursor variables, Dynamic SQL.
• Worked with third party database tools like SQL developer.
• Provided technical and Operational support to Government contracting business unit with respect to i-Many GP and i-Many Medicaid Application. These include i-Many functionalities like Model creation and execution, Report Set up, Pricing upload etc. for GP and Submission, Claim processing, settlement etc. for Medicaid.
• Provided formatted data extracts of ad-hoc requests from databases for trouble shooting, validation and further analysis purposes.
• Analyzed data and functional issues to determine root cause and provide solutions to businesses.
• Provided support to production environment to ensure that all scheduled jobs completed successfully.
• Analyzed and fixed major defects in the application to improve performance and stability.

Senior Executive

Confidential

Responsibilities:

• Involved in data migration process using automated, repeatable, robust methods where possible.
• Developed Test plan and test cases as part of the migration process.
• Developed various technical and process documents for the migration process.
• Provide necessary support to other suppliers in support of the overall migration.
• All associated applications which were in scope of ERP package moved to new Datacenter and integration testing for those applications tested as a part of this Migration.
• Analyzed System Requirement Specifications.
• Developed database stored procedures and packages.
• Involved in database design & data migration.
• Provided support to production environment to ensure that all scheduled jobs completed successfully.
• Responsible for functional and regression testing of the modules.
• Involved in Test Plan creation.
• Developed functional and regression test cases for different modules.
• Involved in creating system requirements.
• Managing the VSS to keep all the test cases and test scripts as part of the competency.
• Analyzed System Requirement Specifications.
• Developed and executed Test cases.
• Responsible for functional and regression testing of the modules.
• Tracking and reporting defects.