PROFESSIONAL SUMMARY

Around **+ years of experience in Information Technology with a strong background in Analyzing, Designing, Developing, Testing and Implementation of Data Warehousing projects in various verticals such as Health Insurance, Pharma(life science), Healthcare, and Financial

Strong experience in Data Warehousing and ETL using Informatica Power Center 9.5.1, Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, and Informatica server) ETL, Data mart, Salesforce Integration with Informatica, SQL server, Netezza database, Oracle, SQL, and OLTP.

Working experience on Informatica Integration with Salesforce cloud.

Working experience in ServiceMax, Veeva applications in Salesforce Cloud.

Working experience using Team Foundation server.

Actively participated in Informatica deployment activities from lower environments to QA, Production environments.

Provided instructions and resolution to provide SQL Server database with memory upgrade, Defragmentation, Indexing and health check of server.

Involved in Informatica Integration server performance improvement with port exhaustion, clearing cache, clearing the huge log files in Informatica server.

Improved the performance of Informatica mappings with Partitioning, Indexing the SQL queries in Source qualifier, lookup. Providing Sorting data to aggregator, Joiner transformation to improve the performance of code.

Hands on Experience on Informatica Repository manager Client and creating deployment groups for code deployment between DEV, TEST, QA and Production environments.

Hands on experience in batch scripting in windows and UNIX commands.

Hands on experience with Control M scheduling tool to schedule Informatica Integration jobs.

Experience in Dimensional Data Modeling using Star Schema & Snowflake Schema, FACT & Dimensions tables, Slowly Changing Dimensions (Type I & II), Physical & logical data modeling, surrogate key assignment and CDC (change data capture).

Configured Informatica Power Center Integration services to extract and load Relational, Non-Relational, and Changed Data during Batch, Change and Real- Time basis.

Experience in integration of various data sources like Oracle, Netezza, Sybase, SQL Server, MS Access, Flat Files (csv files, text files),XML files, Web service and Salesforce, etc.

Hands on experience in Database development skills using Oracle PL/SQL to write Stored Procedures, Functions.

Hands on experience of Migration, backup, recovery, tuning, tracing and troubleshooting.

Ability to work in teams as well as individually, quick learner and able to meet deadlines.

Involved in Unit testing, System testing and performing validation criteria in Development, test environments.

TECHNICAL EXPERIENCE

BI/Data Warehousing

Informatica Power Center Client Tools 9.x/8.x/7.x, SSIS, Business objects, OLTP

Dimensional Data Modeling

Dimensional Data Modeling using Star & Snow Flake schema, Ralph Kimball and Bill Inmon Methodologies.

Programming

SQL, PL/SQL, Batch Scripting.

Databases

Oracle SQL, MS SQL Server, Netezza,Sybase,DB2

CRM Application

Salesforce cloud, Veeva, Service Max

Environment

Windows, Unix, Linux.

Education Details

Bachelor of Technology(B.Tech) in Computer Science and Engineering

Awards

Awarded excellent team player in twice in my tenure in current employer.

Awarded employee of month twice in my current project.

Got many appreciations from client on providing accurate solutions, proper root cause analysis, and corrective action methods to provide defect free code and meeting up the SLAs flawlessly, along with prioritizing Customer delight.

PROFESSIONAL EXPERIENCE

Project #1 11/2014 – Present

Project Name : Envision Customer Relationship Model (CRM) application

Client : Alcon-Novartis Pharma, Fort Worth, TX, USA

Position : Lead ETL Informatica Architect & Onshore coordinator

Technologies : Informatica Power Center 9.5.1, MS SQL Server, Batch Scripting, Control M, Salesforce

Project Description: Alcon (Novartis) is a world leader in the research and development of products to protect and improve health and well-being. The company has core businesses in pharmaceuticals, vaccines, consumer health, generics, eye care and animal health.

To optimize cost and drive consolidation of not just its application portfolio but also bring down its vendor base, Novartis identified Alcon as a strategic partner. Accordingly, alcon took up the support, development and enhancement of the complete IT landscape across APAC, EU and NA regions covering huge number of Novartis users. Scope of applications primarily centers on Application development and Application Maintenance

Roles & Responsibilities:

Attending meetings with Client, Business users. Discuss business plan, effort estimation for code build, unit testing and QA testing, and deployment activities

Involving in coding for implementing CRM (Customer relationship model) project for around 30 countries.

Involving in Design documents creation and effort estimation of code.

Involving in code build in Informatica, SQL server and execute jobs with Control M tool.

Performing Unit testing, Integration testing and QA testing. Involving in submitting the documents to QA compliance team to get an approvals.

Monitor the Informatica Integration jobs in development, QA and environment for all interfaces in Envision CRM applications.

Respond to Incidents, work orders in remedy tool from Client and business user on data load issues and providing the solution to requests as per SLA for all incidents based on priority.

Involving in data base system ODS when integrating the data from JDE, SALSA applications, Salesforce in CRM application.

Analyze and worked on remediation of Informatica Job performance improvement and environmental improvements in all environment system (Development, QA and Production).

Creating the deployment document for code deployments and infrastructural changes in application.

Involving in code deployment for Enhancement releases approved by Client.

Create Change Request and documents in remedy tool to migrate Informatica code and database SQL code into QA, Production environments.

Involve in meetings with Users, Client to discuss root cause analysis for incidents, service requests created by business in remedy.

Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Involved in Unit testing, Iterative testing to check whether the data loads into target are accurate, which extracted from different source systems according to the user requirements.

Preparing and using test data/cases to verify accuracy and completeness of ETL process.

Actively involved in the production support and transferred knowledge to the other team members after code development, unit test, QA testing finished.

Working with Database and Informatica administration team for tool and performance related requests and improvement techniques of server.

Create, modify and scheduling jobs in Control M tool to run Informatica jobs.

Project #2 05/2014 – 11/2014

Project Name : AstraZeneca Salesforce COE

Client : AstraZeneca, USA

Position : Lead ETL Informatica developer

Technologies : Informatica Power Center 9.5.1, SQL server, Salesforce, batch scripting, Microsoft .Net

Project Description: The project is to load Accounts (Hospital) Physician, customer’s data and Account relationship data in Salesforce. Send outbound data to customers. Veeva Integration Work stream is responsible for designing and building new integrations with the Veeva CRM. The Veeva CRM is a cloud-based solution that runs on the SFDC platform along with the Veeva iRep tool for mobile clients. Veeva CRM will support AstraZeneca markets globally.

Roles & Responsibilities:

Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.

Involving in Knowledge transfer session with team, and provided reverse knowledge transfer on existing project overview.

Created technical design documents after analyzing the Functional design document and ETL data mapping documents provided by onshore team.

Developed Informatica mappings and implement the change requests provided by business analysts.

Involving in unit testing of Informatica mappings as per business requirements. Create and update the test case results in unit test case document.

Reviewing the code, optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases particular-to-particular ETL logic.

Mentor the team members by providing assistance with the functional environment/Technical aspects.

Project #3 10/2013 to 4/2014

Project Name : Celgene Veeva Sales Data integration

Client : Celgene Pharma Inc, USA

Position : Sr. Informatica Developer

Technologies : Informatica power center 8.6, Oracle SQL, UNIX, Win SCP FTP tool and Salesforce

Project Description:

The I&I Enablement describes the construction of a data Repository for the sales headquarter reporting with the data loading from various sources such as Veeva CRM, files from vendors (Symphony), MDM and the Hub. Extract source data from different source systems and loaded into Salesforce application.

Roles &Responsibilities:

Created technical design documents after analyzing the Functional design document and ETL data mapping documents provided by onshore.

Developed the mappings once technical design document approved by onshore and client.

Involved in unit testing of mappings developed in informatica. Created and update the test case results in unit test case document.

Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.

Created UNIX shell script file to find out latest source file and make indirect file, file archiving.

Performed the analysis on the defects against the code and working on code changes to fix the defects logged by QA Team.

Involved in code migration of informatica jobs using repository manager in informatica power center.

Provided on call support to the onshore team for executing the jobs in test environment and fixing the issues in executing of jobs

Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Involved in Unit testing, Iterative testing to check whether the data loads into target are accurate, according to the user requirements.

Preparing and using test data/cases to verify accuracy and completeness of ETL process.

Project #4 8/2011 to 9/2013

Project Name : Wellcare Enterprise Data Warehouse

Client : Wellcare Health Insurance Inc., USA

Position : Senior Informatica Developer

Technologies : Informatica power center 8.1.1, Oracle SQL, PL/SQL, Win SCP FTP tool, Team

Foundation Server

Project Description: Wellcare is Health Insurance Company in Unites states of America. Objective of the project is building an Enterprise Data warehouse for claims done by the customers of Wellcare. This model is Star flake schema mode with dimension, fact tables. Populate the data into data warehouse in releases wise from various source systems. Provide a Claim and Encounter data repository which can accommodate both X12 format specifications (4010A1 and 5010) used by WellCare for all three Claim and Encounter claim types (837D Dental, 837I Institutional and 837P Professional Services) in a single integrated warehouse Processing the X12 format (4010) in data from ODS source system and loaded into EDW as one time load.

Roles & Responsibilities:

Involved in Extraction, transformation, Loading and Implementation

Prepared Low Level design document.

Worked on Informatica tool –Source Analyzer, Mapping Designer and Transformations.

Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, oracle and loading to Netezza target database

Extensively used various types of transformations such as source qualifier, Expression, Joiner, Update strategy, Aggregator, Lookup to load the data

Created sessions to run the mappings and set the session parameters to improve the load performance.

Optimized/Tuned mappings for better performance and efficiency

Created the pl/sql procedures to create and drop partitions in target tables for performance tuning.

Check the defects against the code and provide the solution to defects logged by QA Team.

Created the defect tracker document and generate the reports by classifying the type of defects in each release.

Created UNIX shell script file to find out latest source file and verifying the file counts to load tables.

Worked with visual studio to maintain the versioning of the code and generate the code deployment forms of the code for release management.

Involved in code migration of informatica jobs using repository manager in informatica power center.

Provide the UAT and production warranty support for 3 releases in well care project. Involved in tuning of the code to improve the performance

Design and development of mapping and Database management.

We undergo discussion to understand the requirement.

Used Debugger to test the data flow and fix the mappings.

Project #5 01/2010 to 8/2011

Project Name : DSI Enterprise Data Warehouse

Client : Daiichi Sankyo Inc., USA

Position : Informatica Developer

Technologies : Informatica 8.x, Netezza, Winscp,Unix, Putty

Project Description:

DAIICHI SANKYO's goal is to establish itself as a "Global Pharma Innovator." DSI has about 2,300 overseas medical representatives in 33 locations, mainly in Europe and the United States.U.S. Subsidiary, Daiichi Sankyo, Inc. (DSI) has research and development and sales sections, and as the organization that forms the nucleus of our U.S. operations, is expected to grow in the future. European subsidiary, Daiichi Sankyo Europe GmbH (DSE), headquartered in Munich, Germany, and has around 800 medical representatives in operational bases in 10 European countries. Scope: To design and implement the new long term EDW Architecture. To ensure that all the current business functionality provided by Dendrite SM, and ZS catalyst is replicated/recreated in the new environment such that those services can be sunset. Analysis of the data and the data model to improve maintainability and performance while reducing the data latency within the data extraction, transformation and load cycles.

Roles & Responsibilities:

Involved in project initiation meeting and kickoff sessions with Client.

Involved in creating the ETL mapping document from mapping in reverse engineering.

Create ETL mapping documents and sent to onshore for approval to start build phase.

Developed the mappings using Informatica power center and performed the unit testing of mappings. Update the test case results.

Load data from flat file into temporary table in Netezza for data comparison between source file data and Staging tables.

Verify the source file counts and sample data from flat file in UNIX server as part of unit testing of code.

Check the defects against the code and provide the solution to defects logged by QA Team.

Involved in Data analysis in Fact and dimension table’s data to fill data gaps in target system.

Generate report with Informatica Data Quality tool in Informatica to validate source data before loading into Dimension tables.

Project #6 11/2008 to 12/2009

Project Name : Risk & Finance Data warehouse

Client : Barclays Financial, USA

Position : Informatica Developer

Technologies : Informatica power center 7.0, Oracle, Putty, Unix

Project Description: Barclay’s capital provides Consolidate and summarizes, in a standardized system Interface for all clients. This system contains the Trades, Valuations, EOD control and MOTIF as subsystems. MOTIF is an interface system for Trade, Valuation and EOD control. This system used for sending acknowledgement when new message comes from queue manager.

Trade system is maintains the data for client trade information for business of clients. Develop a Wealth Management Reporting solution that is flexible and scalable to accommodate new products, services and client segments.

Roles & Responsibilities:

Created the ETL design documents.

Involved in Extraction, transformation, Loading and Implementation

Worked on Informatica tool –Source Analyzer, Mapping Designer and Transformations.

Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, oracle and loading to Oracle target database

Extensively used various types of transformations such as source qualifier, Expression, Joiner, Update strategy, Aggregator, Lookup to load the data

Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.

Created sessions to run the mappings and set the session parameters to improve the load performance.

Created unit test cases and completed Unit testing

Having daily interaction with the client for gathering the requirements and status updates.

Reviewing the code, optimizing the code, optimizing source query to take less time, test case review, suggestion to include important test cases to specific ETL logic.

Project #7 03/2008 to 10/2008

Project Name : Basel II

Client : GE Systems, UK

Position : Informatica Developer

Technologies : Informatica power center 7.0, Oracle, Unix, Winscp, Putty

Project Description: GE Capital Services Ltd (the Group) has decided to adopt the Basel II Standardized approach for calculating its capital requirement for credit and operational risk, which requires the business to commence regulatory reporting to the FSA from January 2008.

Extract, transform and integrate relevant data from multiple source systems and input to the Fermat Calculation Engine. The Audit Reports, Data quality reports and finance reconciliation reports developed on the ETL server before the data sent to Fermat database. It assumed that the Fermat Calculation Engine produces the Basel II regulatory reports.

Roles and Responsibilities:

Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.

Imported source definitions, transformed and loaded into respective Target tables and flat files using Informatica.

Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.

Writing documentation to describe program development, logic, coding, Unit testing, System testing changes and corrections.

Involved in migration of mappings, workflows and sessions from Development to Testing repository.

Executing Sessions and Batches on the Informatica Server using Informatica Workflow Manager.

Project #8 08/2007 to 02/2008

Project Name : Anti money Laundering

Client : Morgan Stanley Financial

Position : Informatica Developer

Technologies : Informatica power center 7.0, Sybase, UNIX, Winscp, Putty

Project Description:

Morgan Stanley implemented an Anti-money laundering method to monitor and verify the customer transactions. PASAR (Patriot Activity suspicious Reporting System) is an Anti-Money laundering system used to monitor the transactions of the customers. AML has several applications. Patriot Activity Suspicious Act Reporting System (PASAR) is one of the applications of AML. It used for the monitor the status of Transactions. It has Mainframe, Flat file and Sybase sources. This application used for the Account and Transaction filtering.

Roles and Responsibilities:

Understanding of existing business model, customer requirements and involved to designing the Technical Specification design based on the consolidated solution design document.

Analyzing the change request requirement and developed the Informatica mappings using mapping technical specification document.

Created Document of Understanding describes the explanation of project, dependency chart of workflows.Create the Change Request documents and time estimation of tasks as per requirement of change request.

Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center Designer.

Create mappings using transformations like stored procedure, look up, Router, Joiner, Aggregator, Normalizer and expression transformations.

Create Unit Test plan documents for testing of mappings. Test the mappings by running the sessions in workflows as per dependency of the workflows.

Contact this candidate