PHILIP LUKE JOHN

ac2zad@r.postjobfree.com

Phone: 224-***-****

PROFESSIONAL SUMMARY

Experienced IT professional working in the Information Technology Industry more than 10 years, with specific focus on Data warehousing technology.

Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Development, Testing, and Deployment.

Design document preparation and presentation to architect signoff.

Used Informatica Power Center versions like 9.6/9.1/8.5 and 10

Worked on projects using Informatica IDQ for data Standardization.

Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Web Service transformation, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets

Automated, Redesigned and tuned several ETL Process for optimal utilization of Time and resources.

Trouble Shoot, Tune and Maintain complex ETL Mappings.

Reengineered ETL jobs and Processes to bring down the load times by more than 70%.

Worked on Acceptance Test Driven Development to get approval from BAO’s .

Extensive experience in analyzing business, technical and functional requirements to develop Test plans, Test cases and Test strategies.

Preparation of Release notes, Batch Run Books, Roll Back Plans, List of Components prior deployment.

Responsibilities for deployment of ETL components to Testing and Production environments

Warranty support for ETL integrations deployed to production.

Worked on ESP Scheduler using CA Workstation and CICS Explorer.

TECHNICAL SKILLS:

Operating Systems : Win NT / 9X, UNIX.

Databases: Oracle, Tera Data, MS SQL Server, Sybase.

ETL Tools: Informatica 8x,9.1,10,Informatica Data Quality.

Others: Perl, Ruby, ESP.

PROJECTS & SKILLS EXECUTED

CLIENT: NETJETS, COLUMBUS, OH JULY 2017 – CURRENT

PROJECT: BODS TO INFORMATICA CONVERSION

ROLE: SR ETL Developer

EMPLOYER (INFORMATION CONTROL COMPANY)

PROJECT: FLIGHT MANAGEMENT is a conversion project from SAP BODS to INFORMATICA which has NETJETS flight maintenance data sourced from MAINTAINEX system to OMI database. NETJETS flight maintenance records has three main subjects Work Order, Work Order Details and Work Order Parts. Mainly maintenance data contains NJA(NETJETS AMERICA) and NJE(NETJETS EUROPE) records.

RESPONSIBILITIES:

Design jobs based on the analysis of specifications provided by the business.

Created mapping document with all the necessary fields which helps to develop or customize the mappings more efficiently.

Developed new and customized existing mappings and bought in data into data warehouse

Extensively used flat files as source table and loaded data into database tables.

Extensively used mapping variables, mapping parameters and parameter files in ETL mappings.

Acceptance /Unit testing on developed codes to make sure code meets business expectations.

Creation of run book for production support team and documentations related to developed code.

Involved in code deployments while pushing from one environment to the other using Repository Manager.

Carrying out deployment activities for both the History and Incremental code respectively.

Responsible to monitor data during the daily and weekly loads and fix the issues related to load failures.

Coordinating with end user and making sure newly deployed code meeting user requirements.

Responsible for Optimization of Informatica mappings, sessions, SQL queries.

Defect fixing based on the new defects raised in QC by testing team.

Raising RFC and IT requests for new releases.

CLIENT: NATIONWIDE INSURANCE, COLUMBUS, OH AUG 2014 – MAY 2017

PROJECT: PRODUCER INFORMATION MANAGEMENT

ROLE: SR ETL Developer

EMPLOYER (INFORMATION CONTROL COMPANY)

PROJECT: DPIM(Distribution Producer Information Management) is one more Producer-centric corporate model which requires seamless service delivery across multiple products and producer touch points and a whole new level of producer knowledge across the enterprise for sales and servicing.

DPIM provides a consolidated view of the Producer, and allows Nationwide to take advantage of enhanced selling capabilities, such as active marketing, cross-enterprise business models and cross sell analysis. To enable this view and the enhanced sales and servicing capabilities DPIM will become the system of record for producer preference data (i.e. opt-out preferences, billing preferences, etc.), Household account data and the system of reference for all other customer related data. To enable the enterprise customer goals, certain existing systems need to be retired/ migrated to DPIM.

Informatica power Centre is used to develop ETL mappings and Informatica Data Quality for building Data Quality rules for loading to enterprise system from different source system.

RESPONSIBILITIES:

Create Mapping Documents by understanding different source systems and targets.

Design and work on complex mappings with XML targets in Informatica to interact with MDM.

Create IDQ mapplets which is used in Informatica.

Developed complex Informatica mappings, sessions and workflows.

Create mappings which uses web services to call SOA online services.

Develop mappings which uses transformations like router, lookup, source qualifier, joiner, expression, sorter, XML, Update strategy, union, aggregator, normalizer and sequence generator.

Created reusable mapplets and reusable transformations.

Responsible for code migration during deployments.

Created and performed Unit tests over Informatica code.

Responsible for Monitoring and tracking the critical daily applications.

Worked on Performance tuning of Informatica designs and mappings.

Develop functional/regression automated testing solutions using RubyMine, Cucumber and data driven techniques.

Train/mentor junior automation developers and test automation end users.

CLIENT:AAA INSURANCE, GLENDALE SEPT 2012 –JUNE 2014

PROJECT: POLICY ADMIN SYSTEM

ROLE: ETL DEVELOPER /ASSOCIATE

EMPLOYER: COGNIZANT TECHNOLOGY SOLUTIONS.

PROJECT: AAA is a not-for-profit organization of clubs serving more than 50 million members in the United States and Canada. AAA serves its members through a network of 1,100 offices with more than 45,000 employees. Policy Admin System [PAS] is the major application AAA use to handles Auto /Property policy information’s, ETL Integrations are one of the application used to handle policy information in PAS which pulls policy related information from PAS database and sends to AAA vendors

RESPONSIBILITIES

Lead of offshore team of six members.

Coordinated for onsite-offshore work model for deligation of tasks.

Worked with Business Analysts and Data Architects in gathering the requirements and designed the Source to Target Mapping Specification Documents.

Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica

Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from Oracle, SQL Server, flat file sources to target database (Oracle).

Implemented Slowly Changing Dimensions - Type II mappings as per the requirements.

Worked on Informatica PowerCenter tool – Source Analyzer, Mapping Designer, Designer and Transformation Developer.

Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.

Implemented the Change Data Capture (CDC) to capture the incremental load from the sources. Used the Control Table Logic in order to implement in the Change Data Capture.

Created Sessions and Workflows to load data from the Oracle, SQL Server, flat file sources.

Performance tuning on sources, targets mappings and SQL (Optimization) tuning.

Used various performance enhancement techniques to enhance the performance of the sessions and workflows.

Scheduled the workflows to pull data from the source databases at daily intervals

Involved in unit testing, Integration testing and User acceptance testing of the mappings.

Installation and configuring the PowerCenter tool including database connections.

Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.

Created the Production Support Document and assisted the Production Support Team with all the production related issues.

Prepared batch cycle and execution flow document for scheduling in Control-M.

Environment: Informatica PowerCenter 8.6, Oracle 9i/10g,Unix

CLIENT: BLUECROSS BLUE SHIELD OF LOUSIANA MAY 2012 – AUG 2012

ROLE: ETL DEVELOPER

EMPLOYER: COGNIZANT TECHNOLOGY SOLUTIONS

PROJECT: Blue Cross and Blue Shield of Louisiana is Louisiana's oldest and largest health insurer. Mission is to improve the lives of customers by providing health guidance and affordable access to quality care. Blue Cross offers a full line of Medicare supplement plans, life and dental insurance and voluntary options for groups. CTS hold the responsibility for Converting existing ETL package SSISEE30C from SSIS to Informatica. Ensure that the converted Informatica workflow supports the same or improved functionalities as the original SSIS packages and with improved performance, less production issues, or increase maintainability and reusability

RESPONSIBILITIES:

Participated in project planning sessions with project managers, business analysts and Team members to analyze business requirements and outline the proposed solution.

Preparation of high level ETL design document.

Preparation of detailed design document.

Developing mappings that handle functional requirements.

Coordination with onshore for resolution of issues.

Preparation of unit test cases.

Unit testing of the ETL mappings.

Executing system test cases.

Involved in project Deployment by coordinating with Deployment team and verification of components before Production run.

Production Support.

Environment: Informatica Power Center 8.6, Oracle 10g, Flat Files, XML Files, SQL

CLIENT: FLORIDA POWER AND LIGHT JAN 2011 – APRIL 2012

ROLE: ETL DEVELOPER

EMPLOYER: COGNIZANT TECHNOLOGY SOLUTIONS

PROJECT:Florida Power & Light Company is the largest electric utility in Florida and one of the largest rate-regulated utilities in the United States. FPL serves approximately 4.5 million customer accounts in Florida and is a leading employer in the state with more than 10,000 employees.

The purpose of this project is to provide Marketing Data Warehouse data extracts along with Work Force Management Supplement to implement the ClickFox Customer Experience Analytics (CEA) solution. This aids in conducting systematic analysis and provide actionable insight across multiple interaction channels to help achieve key Customer Care objectives

RESPONSIBILITIES:

Involved in requirement analysis.

Preparation of high level ETL design document.

Preparation of detailed design document.

Developing mappings for loading MDW data and WFM data.

Coordination with Onsite for resolution of issues.

Preparation of unit test cases.

Unit testing of the ETL mappings.

Executing system test cases.

Involved in project management and quality process.

Environment: Informatica Power Center 8.6, Oracle 10g, Flat Files, XML Files, SQL.

ACS A XEROX COMPANY. NOV 2005 – DEC 2010

ROLE: SR BA [DATA WAREHOUSE PROJECTS]

ACS mainly into Human Resource Information Systems business for major clients like HESS, SONY PICTURES, DELTA, SAFEWAY etc.HRIS (Human Resource Information Systems) is commonly used to refer to the client system that maintains the employee information in Data warehouse using Informatica ETL. Census data files or HR files is the term commonly used to refer to the file transmitted from the client that contains the indicative information that clients keep on their HRIS system for their employees .ACS will load HRIS/Census and Payroll files to data warehouse that come into the ACS HR Solutions organization from our clients and from vendors on behalf of our clients. Payroll files are also transmitted from our organization to the client payroll team in order to administer payroll (i.e. 401k deductions, medical or dental deductions).H&W (Health and Welfare) Vendor extracts refers to some of the medical and legal benefits that employees are entitled for. The premium or deductions are received from the clients which get loaded into ACS record keeping system, Sybase. Informatica jobs/ UNIX scripts are executed and to get an extract of the benefits of employees pertaining to the client which are then transmitted to the respective vendors who offer the services.

RESPONSIBILITIES:

As a member of Corporate Data Management Team, responsible for analyzing, designing and developing strategies and processes, writing business requirement specifications for developer.

Problem managements, researching on flaw in the process design and implementation. Find resolutions for the problem/Issues.

Part of ETL development team to create Mappings that loads HRIS/Census and Payroll files to data warehouse.

Key role in diagnosing analyzing and reporting requests from the client and to convert the reporting request to development life cycle.

Creating test plans and test cases to insure data integrity and enforcing quality. UAT (User Acceptance Testing) to ensure that the functional requirements are met.

Responsible for creating Source to Target mapping documents based on the Data model and Business understanding.

Data Management, updating, maintaining and validating the data using Informatica as and when the requirement arises.

Identifying informatica ETL process improvement opportunities.

Execution and monitoring recurring and non-recurring batch job processing. Validate the data processing results, report data processing when errors encountered and finally manage the resolution of data processing problems.

EDUCATION

Bachelor Of Engineering and Technology from Visvesvaraya Technological University, Belgaum, INDIA

Contact this candidate