SUMMARY

• 8+ Years of professional experience in Software Industry in Oracle SQL and PL/SQL programming.
• Extensive experience in Insurance and Banking Domains.
• Involved in requirements gathering, analysis, development, implementation, debugging, testing, quality reviews & user support etc.
• Good Understanding of Complete Software Development Life Cycle and Well versed with Agile and Waterfall methodologies.
• Participated in Ernst & Young LLP CMMI - Level 3 and CMMI -Level 5 certification interviews and contributed for its achievement.
• Migrated claims for the clients Confidential and Confidential, Ohio, US involving analysis of legacy table structures and creating corresponding mapping sheets for ClaimCenter development, writing DDL scripts, procedures, functions and other database logics in order to migrate claims through different databases successfully.
• Implemented Confidential banking product for the client Finance Building Society in Zambia, Africa performing the role of Technical Consultant involving Oracle DB setup, importing data dumps, executing Confidential scripts and bringing up system for users to login successfully. Had good functional knowledge in Funds Transfer, Consumer Lending, Core, SEPA and various other modules of Confidential .
• Quickly adaptable to newer technologies with strong client facing and problem solving skills.

TECHNICAL SKILLS

Functional Areas: Banking and Claims - Insurance

Languages: ORACLE SQL and PL/SQL Programming, C, XML, HTML and Core Java, UNIX Shell Scripting

Database: Oracle 9i/10g/11g and SQL SERVER 2008

Operating Systems: Windows Family, UNIX

Utilities: PLSQL Developer, Putty, TOAD, Rational Clear Case, RAD Tool, WinScp

ETL Tools: Power Center Informatica, SSIS

GUI: Forms 6i

Version Control Tools: Perforce, Sub Version (SVN)

Testing Tools: HP Quality Center

Development Methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Dublin, OH

ClaimCenter Downstream Data Expert

Environment: Oracle 11g, PLSQL Developer, HP Quality Center, WINS (Nationwide Legacy Policy System)

Responsibilities:

• Interacting with the onsite co-coordinators and technical SME (subject matter experts) of the different legacy claims systems to understand client's business requirements.
• Designing Conversion framework involving packages, procedures, functions and triggers as well as leading the conversion team
• Migrating claims data into ClaimCenter System with quality and managing different Oracle prestaging and staging databases.
• Implemented Parsing Technique for Informatica team by writing complex PLSQL procedures
• Preparing the list of Data Integrity errors and explain them in detail to the ETL team with possible technical solutions.
• Daily status reporting, Task assignment and Resource planning

Confidential, Medina, OH

Onsite Claims Migration Coordinator, Off-Shore Migration Team Lead and Technical Consultant

Environment: Oracle 11g, SQL Server Management Studio, Perforce, HP Quality Center, SSIS

Responsibilities:

• Meeting the customers to understand, analyze their existing Claims business operations and legacy systems in use and participate in requirements gathering sessions.
• Develop SQL scripts like procedures, functions and packages with error handling mechanisms to mitigate the risks during conversion.
• As a data conversion specialist, responsible for loading source system data to client’s target systems i.e. importing Claims data into Prestaging, Moving to Staging for Integrity errors and finally migrating to ClaimCenter database with zero errors.
• As a data reconciliation expert, solely designed and developed reconciliation framework writing complex Oracle SQL and PLSQL scripts to check if the migration of claims data is achieved properly with financials balanced.
• Reviewing the onshore and offshore development scripts for adherence to coding conventions, developers’ standards and best practices.
• Interacting with different technical teams to resolve the data integrity errors, bulk validation errors and data inconsistency errors.
• Performs unit testing for the accuracy of the data conversion and fixes testing defects.
• Responsible for onsite offshore delivery and coordination.

Confidential, Dublin, OH

Offshore Migration Lead

Environment: Oracle 11g, PLSQL Developer, HP Quality Center, Power center Informatica

Responsibilities:

• Analyzing the mapping logic for each Table - Field and understanding the requirements
• Developing Oracle database scripts - Procedures, Functions and Packages to implement desired functional requirements for the client.
• Ensuring zero defects in the module and working with testing team to help them understand major data related defects.
• Analyzing the data in the database to make sure all the required scenarios are moved to the flat files for testing.
• Appreciated by client for achieving financial balance between ClaimCenter and WINS systems.
• Coordinating with off-shore team in terms of WINS task assignment, Guiding with technical solutions and ensuring delivery with utmost quality.
• Participated in Project Demo’s and Knowledge Transition sessions
• Creating new Mappings, Workflows and Sessions based on mapping sheets

Confidential

Database developer and Lead

Environment: Oracle 11g, SQL and PL/SQL, PLSQL Developer, HP Quality Center, RAD Tool, WebLogic Server, Putty

Responsibilities:

• Creating Oracle Schemas, importing data dumps and making the data consistent
• Writing procedures, functions, packages as per client’s requirements and enhancements.
• Writing Program Specifications, Design Documents, Technical Documents and Unit test cases.
• Involved in unit testing, Regression testing and integration testing
• Providing Technical Support, defect analysis and fixing issues
• Compiling all sources related to Flex Cube versions
• Preparing the conversion Script and deploying it
• Testing the basic functionalities after upgrade
• Code reviews and Quality team meetings
• User Trainings on Flex Cube Product with hands-on experience
• Parameterization - setting up flex cube as per client’s requirements
• Setting up environment for Flex Cube and deploying Confidential using Application Server

Confidential

Oracle Developer

Environment: Oracle 9i, SQL and PL/SQL

Responsibilities:

• Writing procedures, functions, packages
• Defect Fixing and Code reviews
• Involved in unit testing, Regression testing and integration testing