Summary

• Over 6 years in IT industry with excellent exposure in PL/SQL as a Lead Developer, Application Development, Deployment and Administration of IT Applications, Maintenance Enhancements and Having Strong Knowledge in Insurance Domain Business Solutions.
• Expert in designing and developing Stored Packages, Procedures, Functions and Triggers with PL/SQL using tools TOAD and PL/SQL Developer.
• Having Experience in developing and customizing Forms and Reports in Oracle 11g/10g/9i/8i, Oracle Reports/Forms 10g/9i/6i.
• Extensive knowledge of Extract, Transform, Load environment, Slowly Changing Dimensions SCD , CDC and different type of dimensions using PL/SQL ETL framework.
• Strong Knowledge in Maintenance enhancements and worked with various Insurance domain systems such as Billing and Data Warehouse using Informatica and PL/SQL.
• Experienced in Performance Tuning using query execution plan Indexes for large tables.
• Experienced in Maintenance enhancements using Message Queue MQ and Pro C.
• Expertise in developing scheduling jobs using Job Information Language JIL .
• Comfortable with basic Unix commands and shell scripting.
• Extensive knowledge in job monitoring using Autosys and Workload Control Center WCC .
• Experienced in defect reporting and management using HP Quality Center.
• Expertise in versioning control tools such as IBM Rational ClearCase and TortoiseSVN.
• Strong coordination skills between onshore, offshore models and agile methodology. Lead many projects single handed and delivered the quality projects on time.
• Strong Knowledge of all phases of Software Development Life Cycle in large scale projects.
• Proficient in coordinating with customers and translating business needs into successful implementation of technical solutions.
• Extremely comfortable in leading and mentoring technical teams in dynamic work environments with changing responsibilities and aggressive time lines.
• Self-motivated and dedicated. Rapidly assimilate new technologies to implement customized, state-of-the-art solutions. Exceptionally strong sense of attention to details.
• Roles played: Requirements Analyst, Lead Developer/Programmer, Maintenance Team Lead, Onsite Development Team Lead and Offshore Delivery Co-ordinator.

Career profile

The details of the various assignments that I have handled are listed here, in chronological order.

Confidential

Role : Onsite Development Team Lead

Description

• Analytical Data Mart is a Type 2 Slowly Changing Dimension data mart for commercial lines policies and claims.
• ADM will be used by the research team of Hartford Insurance to do the predictive analysis.
• This predictive analysis will be used by the pricing team and other stakeholders.
• The SDLC model is being used in this project is Agile Methodology.

Responsibilities

• Requirements gathering for the Data Mart through meetings with functional team and business users.
• Performing the Project Estimates and Planning for Large Initiative/Change Controls.
• Involved in Data warehouse dimensional star schema data model designing and prepared low level design documents.
• Performing the Internal peer review for the deliverables and code walkthrough.
• Involved in assisting Quality Control team to come up with the proper test cases to test the DW System.
• Mentoring the team members on regular basis and giving the regular guidance in ensuring the efficient deliverables.
• Conducting the regular status calls with the Offshore Team, and also participating the status calls with the Customer.

confidential

Role : Onsite Development Team Lead

Description

• The objective of this project is to change the look and feel of the consumer lines invoices.
• As a Billing application, the policy, billing and personal information will be sent to the downstream system as flat files.
• The downstream system will format, print and mail the hard copies of the billing invoices.
• As part of billing application, we have redesigned the complete invoice data. Added/Removed some data elements based on the business needs to give the good look and feel for the Insured.

Responsibilities include:

• Requirements gathering through meetings with functional team and business users.
• Performing the Project Estimates and Planning.
• Preparing High level Low level design documents and data mapping document.
• Developing the core PL/SQL components.
• Conducting regular status calls and addressing the issues now and then with the Interfacing teams.
• Preparing system testing cases and validating the test results.
• Involved in assisting Quality Control team to come up with the proper test cases to test the system and validating their test cases.
• Conducting the regular status calls with the Offshore Team, and also participating the status calls with the Customer.
• Owned the quality of all deliverables and timelines.

confidential

Role : Onsite Development Team Lead

Responsibilities include:

• Requirements gathering through meetings with functional team and business users.
• Performing the Project Estimates and Planning.
• Preparing High level Low level design documents.
• Developing the core PL/SQL components for CABR.
• Developing MQ and Pro C components for CABR.
• Preparing system testing cases and validating the test results.
• Involved in assisting Quality Control team to come up with the proper test cases to test the CABR System and validating their test cases.
• Conducting the regular status calls with the Offshore Team, and also participating the status calls with the Customer.
• Owned the quality of all deliverables and timelines.

confidential

Role : Onsite Maintenance Team Lead

Responsibilities include:

• Prioritizing and working with enhancements.
• Ensuring the availability of PLDW.
• Resolving the critical high priority incidents.
• Addressing the adhoc requests and user data requests.
• Back tracking and resolving the job failures using Informatica PL/SQL.
• Sending communication to all the stakeholders incase of any planned/unplanned outages.
• Remedy management and ticket reduction initiatives.
• Weekly status calls with DBA team and Linux team to ensure the application availability.
• Conducting the regular status calls with the Offshore and onsite Team to discuss the issues addressed, New invest projects implemented in production and other maintenance activities.

confidential

Role : Offshore Development Team Lead

Responsibilities include:

• Requirements gathering through meetings with functional team and business users.
• Performing the Project Estimates and Planning.
• Preparing High level Low level design documents.
• Developing the core PL/SQL components for the Billing remainders.
• Preparing system testing cases and validating the test results.
• Conducting regular status calls and addressing the issues now and then with the Interfacing teams.
• Conducting the regular status calls with the Offshore Team, and also participating the status calls with the Customer.
• Owned the quality of all deliverables and timelines from offshore.

Role : Offshore Maintenance Team Member

Responsibilities include:

• Working with Maintenance Enhancements for TABS.
• Ensuring the availability of TABS.
• Production Job Monitoring.
• Sending communication on in-stream /out-stream file delays.
• Resolving the critical high priority incidents.
• Addressing the adhoc requests and user data requests.
• Back tracking and resolving the job failures using Oracle Forms PL/SQL.
• Sending communication to all the stakeholders incase of any planned/unplanned outages.
• Remedy management and ticket reduction.