Worked in an Investment Data repository maintenance and enhancement project.

Client: American International Group (AIG).

Domain: Investments.

Description: Enhancement/Development, maintenance and support.

Technologies Version: Oracle 12c.

Language: Oracle PL/SQL.

Tools: PL/SQL Developer, Toad, Autosys, Microstrategy,TFS

Operating System: Windows 7,Unix.

Worked in an investment data repository maintenance and enhancement project for client AIG.IDR data loads from file to staging, staging to ODS then ODS to Data mart .I am taking care of data mart and reconcile code enhancement/development and batch support. I use to monitor the batch closely which load data from IDR-ODS to IDR-Data mart by autosys jobs which actually call the data mart package procedures, and troubleshoot and provide short term fix by writing SQL codes by creating TFS ticket while we face issues in Data mart load every day. Find out the RCA by debugging the underlying Oracle package and procedures and working on the development/enhancement of package, procedures for permanent fix with discussing with onshore client.

After Data mart load I take care of reconcile check which compare and checks data load between File Vs Staging and staging Vs Datamart.This is also autosys job which calls package and procedures to load data into recon tables. Then I analyze breaks [discrepancies] by debugging the package procedures and communicate with business for breaks.

I create new package procedures as an enhancement discussing with business analyst and create JIL files in autosys to automate and schedule them in Dev environroment the do the unit testing. Responsible to deploy them in QA environment for user testing and finally deploy them in Prod by crating TFS ticket.

Working as a Associate Projects in a data migration project for international Pharmaceutical client Novartis in VEEVA CRM system ,based on SalesForce platform.Working for source to destination mapping, interact with clients for gap analysis.Responsible for migrating the data from Alcon pharmaceuticals Veeva system to Novartis Veeva vantage system and after deployment in production provided product support.

Client: Novartis Pharmaceuticals

Domain: Healthcare, pharma and Life Sciences.

Description: Data Migration.

Technologies: SalesForce,SOQL queries,Veeva CRM

Tools: Workbench SOQL,SalesForce,Apex Dataloader,MS Exel,Ms Access.

Description: Clear understanding of Alocn source system and Veeva Vantage target system.Extract and analyze the source data using SOQL queries in Veeva system which need to migrate.

• Creating proper SOQL queries and scripts using Workbench to get the data in proper format from source system.Then cleaning the source data by applying logic provided by client.Finding the gaps between source and destination system and cover the gap after discussing with clients. Responsible for source to target field mapping.

• Using apex data loader to move the cleaned source data into target Veeva system.

• Assist the deployement team to deploy the data in production.Then provide the production support.

Working as an intrinsic part of the global production support and Implementation team member of a financial technology and integrated services for the administration of consumer healthcare accounts.

Helping both customer and internal technical teams to understand business requirements, working with Information Technology and Operations during implementation phase, planning and conversion mapping from existing systems to Acclaim platform.

Develop in-depth understanding of the Acclaim platform, a SaaS based end to end solution. This solution was developed in-house and is designed to manage reimbursement administration for a multitude of different reimbursement plans like HSA, FSA, HRA.

Interact with business owners and quickly identifying the underlying business needs and requirements. Analyzing the business and technical requirements and identify any gaps between customer requirements and the Acclaim platform. If necessary, identify any platform enhancements and build test cases as needed.

Client: Bank of America

Domain: Consumer healthcare account.

Description: Production Support, Implementation

Technologies: Oracle 11g

Languages: SQL,PLSQL (Oracle11g)

Operating System: Windows 7

Tools: PLSQL Developer,FileZilla,CiscoVpn

Period: Since May 2013 to present

Team Size: 15 members

Role: Production Support, Implementation Specialist and Tester

Description: Develop clear understanding and working knowledge of the Acclaim standard database structures, processes and incoming and outgoing file layouts.

Perform gap analysis between existing systems and Acclaim system and capabilities, coupled with new and existing business requirements that may arise during Implementation. .

• Writing SQL queries and scripts using SQL, PL/SQL during production support analysis, initial implementation, testing and stabilization periods.

• Perform QA and facilitate user testing for the developed work products.

Deftly managed the entire responsibilities based on: Creating understanding about documents and the project requirements. Mapping of the fields from the assigned database to clients requirements. Development and testing of the various insurance products. Writing PL/SQL and SQL codes so as to meet specific business requirements. Writing database procedure for business requirements.

• Writing SQL and PL/SQL codes and mapping business requirements and providing production support and customized software solutions involving finalization of product specifications and selection of appropriate techniques.
• Conducting system study and coordinating with team members for System Design & Integration, Application Maintenance, etc.
• Handling various technical aspects like software design, coding of modules, monitoring the critical paths as well as taking appropriate actions.
• Designing and executing test plans and Gap Analysis to ensure that business requirements and functional specifications are tested and fulfilled.
• Implementing the builds on client’s environment.
• Fixing the bugs on priority basis to meet the business SLAs
• Defining the best technical practices in terms of coding, testing and implementing.
• Review and mentoring the junior developers to ensure the end product to meet defined standard.

Major Projects:

Client: United India Insurance Company, Kolkata

Domain: General Insurance

Description: Insurance (Underwriting Module)

Technologies: Oracle 10g, ASP.NET 2.0

Module: Genisys Configurator

Team Size: 50 members

Role: Software Developer and Tester

Tools: PL/SQL Developer, Visual Studio 2008, Microsoft Blend, Product Designer, Multi UI Mapping Utility.

Period: Oct 2011 –May 2013

Accountabilities: Deftly managed the entire responsibilities based on:

• Creating understanding about documents and the project requirements.
• Mapping of the fields from the assigned database to clients requirements.
• Development and testing of the various insurance products.
• Writing PL/SQL and SQL codes so as to meet specific business requirements.
• Writing database procedure for business requirements.

Client: The New India Assurance Co. Ltd. (NIA)

Domain: General Insurance

Description: Genisys Data-Migration

Technologies: PL/SQL, Oracle 9i.

Languages: SQL, PLSQL (Oracle9i)

Operating System: Windows XP

Team Size: 35

Tools: PLSQL Developer, TOAD, WINSCP, PUTTY

Period: July 2010 – September 2011

Team Size: 35 members

Role: Software Developer and Tester

Description: Migration of data from decentralized core application (Genisys) to newly developed centralized system.

Accountabilities: Deftly managed the entire responsibilities based on:

• Development and testing of the process.
• Writing PL/SQL and SQL code so as to meet specific business requirements.
• Writing database procedure for business requirements.

Migration of data from decentralized core application (Genisys) to newly developed centralized system. Deftly managed the entire responsibilities based on: Development and testing of the process. Writing PL/SQL and SQL code so as to meet specific business requirements. Writing database procedure for business requirements.

Worked in an Investment Data repository maintenance and enhancement project for client AIG.IDR data loads from file to staging, staging to ODS then ODS to Data mart .I am taking care of data mart and reconcile code enhancement/development and batch support. I use to monitor the batch closely which load data from IDR-ODS to IDR-Data mart by autosys jobs which actually call the data mart package procedures, and troubleshoot and provide short term fix by writing SQL codes by creating TFS ticket while we face issues in Data mart load every day. Find out the RCA by debugging the underlying Oracle package and procedures and working on the development/enhancement of package, procedures for permanent fix with discussing with onshore client. After Data mart load I take care of reconcile check which compare and checks data load between File Vs Staging and staging Vs Datamart.This is also autosys job which calls package and procedures to load data into recon tables. Then I analyze breaks [discrepancies] by debugging the package procedures and communicate with business for breaks. I create new package procedures as an enhancement discussing with business analyst and create JIL files in autosys to automate and schedule them in Dev environroment the do the unit testing. Responsible to deploy them in QA environment for user testing and finally deploy them in Prod by crating TFS ticket.

Worked as a Software Engineer in GST implementation project for domestic manufacturing client Berger Paints India Ltd based on Oracle Apps R12. Client: Berger Paints India Ltd. Domain: Manufacturing. Description: Retro fitment and implementation of GST.[ Goods and Services Tax] Technologies: Oracle PL/SQL, Oracle Apps R12. Tools: PL/SQL Developer,Toad,Report Builder,WinSCP,Putty,BI publisher. Responsible for retro fitment of existing database objects, reports[.rdf file] and modifying their logic as per clients requirement to implement GST in development instances and deploy them into UAT instances for testing. Creating new .rtf files for new reports,developed new packages to implement GST logic. Developed code pack ,technical documents for client.

Working as a Associate Projects in a data migration project for international Pharmaceutical client Novartis in VEEVA CRM system ,based on SalesForce platform.Working for source to destination mapping, interact with clients for gap analysis.Responsible for migrating the data from Alcon pharmaceuticals Veeva system to Novartis Veeva vantage system and after deployment in production provided product support. Client: Novartis Pharmaceuticals Domain: Healthcare, pharma and Life Sciences. Description: Data Migration. Technologies: SalesForce,SOQL queries,Veeva CRM Tools: Workbench SOQL,SalesForce,Apex Dataloader,MS Exel,Ms Access. Description: Clear understanding of Alocn source system and Veeva Vantage target system.Extract and analyze the source data using SOQL queries in Veeva system which need to migrate. Creating proper SOQL queries and scripts using Workbench to get the data in proper format from source system.Then cleaning the source data by applying logic provided by client.Finding the gaps between source and destination system and cover the gap after discussing with clients. Responsible for source to target field mapping. Using apex data loader to move the cleaned source data into target Veeva system. Assist the deployement team to deploy the data in production.Then provide the production support.