PROFESSIONAL SUMMARY

Over *.* years of experience in Information Technology with a strong background in ETL process using Informatica Power Center 9.x/8.x,Unix Scripting.

Experience working with Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor.

Worked with Clients such as Blue shield of California, Xerox State Healthcare and Morgan Stanley.

Proficiency in developing Reports and Dashboards using Splunk Query Language.

Certified in Splunk Certified Power user 6.4.

Proficiency in developing SQL with various relational databases like Oracle, SQL Server.

Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.

Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

Able to work independently and collaborate proactively & cross functionally within a team.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Ability to work with multiple teams and coordinating with them to make Deliverables in time and quality.

TECHNICAL SKILLS

Tools

Informatica Power Center 9.6/9.5/9.1,8.6,Splunk 6.4

Databases

Oracle 11g/10g,

MS SQL Server 2008 & DB2

Languages

C, SQL, UNIX Scripting

Operating Systems

LINUX, SUN Solaris, Windows7/XP/2000/98

Applications

Jenkins,Tortise Svn,JIRA,Tidal,Sql Developer,Sql Server

EMPLOYMENT HISTORY:

Name of the Company

Designation

Address of the employer

From

To

Duration(Years)

Cognizant Technology Solutions

Associate - Projects

MEPZ - Special Economic Zone,

Plot No A-15, Tambaram,

Chennai-600045

23 May 2012

Till Date

4.3

Capgemini India Private Limited

Associate Consultant

Capgemini India Private Limited,

455,Anna Salai,

Teynampet,

Chennai - 600018

21 Dec 2009

21 May 2012

2.5

EDUCATION

Bachelor’s in Information Technology from Anna University, Chennai.

PROFESSIONAL EXPERIENCE

Client: Xerox State Healthcare, LLC

Location: Los Angeles, California

Organization: Cognizant Technology Solutions

Role: ETL Informatica Developer

Duration: Mar 2016– Present

Project: NYSLR Conversion

Description:

Xerox Business Services, LLC provides business process outsourcing and information technology (IT) services worldwide. Xerox Business Services, LLC was formerly known as Affiliated Computer Services LLC and changed its name in April 2012. NYSLR Conversion program that will improve the way Xerox Business Services LLC functioning from converting the existing information form NY - Medicaid EHR (Electronic Health Record) Incentive Program Administrative Support Services (MEIPASS) to SLR system. SLR backend database is designed and implemented in SQL Server which consists of a primary database called PIPSLR and state specific databases to store state level data.

Responsibilities:

Responsible for converting Functional Requirements into Technical Specifications.

Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.

Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator.

Developed complex mappings, Mapplets using Informatica workflow designer to integrate data from varied sources like Teradata, Oracle, Flat files and loaded into target.

Worked with Shortcuts across Shared and Non Shared Folders.

Created Pre-Sql and Post-Sql scripts which need to be run at Informatica level.

Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.

Experience working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.

Extracted data from various heterogeneous sources like Oracle, MSSQL & Flat file.

Performed data validation by Unit testing, integration testing and System Testing.

Performed Source to Target Validation using queries and Prepared L1,L2 Reports.

Environment: Informatica Power center 9.6.1, SQL server 2012 and UNIX shell scripting.

Client: Blue Shield of California

Location: Chennai, India

Organization: Cognizant Technology Solutions

Role: ETL Informatica Developer

Duration: May 2012– FEB 2016

Description:

Shield Advance is the name of an enterprise wide program that will improve the way BSC service their customers – from bringing new products to market and enrolling members, to processing claims and managing their network of providers. BSC is engaged in this transformational business program beginning in 2007 and will continue for 7+ years. Purpose of Shield Advance project is to migrate from the Legacy system to Facets 5.1 and move the first block of membership (Release 1 - R1) onto the new platform in 2010, followed by Release 2, Release 3, Small Group during 2011, 2012, 2013 and Shield Advance Acceleration.

Responsibilities:

Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.

Extensively worked Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.

Worked with Session logs and Workflow logs for Error handling and troubleshooting in Dev environment.

Created Mapplets and used them in different Mappings.

Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.

Involved reviewing the code and validate before moving to higher environment.

Conducting weekly status meetings for the team.

Providing and conducting knowledge transfer sessions to the team members.

Written reusable shell scripts and adhcoc scripts which are needed for production runs.

Managed resources access details for each Environments

Worked extensively in code merge using SVN

Involved in identifying reasons due to code merge.

Involved in creating labels, Queries and deployed objects through Jenkins.

Verifying with team and identifying list of objects which will be deployed for particular release and make sure deployment is not affected.

Worked closely with SCRM team to facilitate all our team objects are deployed in time.

Involved in maintaining task tracker for everyday of Team and send to Onsite team.

Created Idea and Scripts to compare difference between two environments for each release.

Worked with Batch team to create jobs in Tidal.

Worked closely with testing team and respond immediately to ensure to deliver the fix/response in short time.

Prepared Adhoc Scripts to support Production fixes in short time.

Environment: Informatica Power Center 9.6.1,Unix Shell Programming,Sql Developer,JIRA,Tortise SVN

Client: Morgan Stanley

Location: New York City, NY

Organization: Cognizant Technology Solutions

Role: ETL Informatica Developer

Duration: Feb 2010– May 2012

Project Description:

Morgan Stanley is required to put measures in place to satisfy Federal requirements as a result of becoming a Financial Holding company. One such series of measures involves ensuring appropriate protections are in place in non-production environments to safeguard firm’s data. To that end, the QA renovation Firm Management Program (QAFMP) has been established. The goal is to provide a segregated non-production environment with controlled access points and sanitized data for development and quality assurance process.

Responsibilities:

Understand the business requirement to prepare Technical Specification documents (TSD) to code ETL Mappings for new requirement changes.

Involved in Data Analysis.

Developed Mappings, Sessions and Workflows to extract data from Source, Masked it and loaded into Target database by using Transformations

Involved in Migration of ETL Code between DEV, QA environment and involved in Autosys job creations

Written scripts to run, schedule and monitor Informatica workflows and documented the results

Involved in enhancements for existing mapping and shell scripts.

Used Source Analyzer and Warehouse designer to import the source and target database schemas, the Mapping Designer to map the sources to the target.

Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.

Extensively worked on Autosys to schedule the jobs for loading data.

Designed and Developed UNIX Shell Scripts for Data load and monitoring.

Environment: Informatica Power Center 9.1, Oracle 10g, DB2, UNIX Shell Scripting, Autosys.

PERSONAL DETAILS

Father Name : Ponnusamy

Date of Birth : 04-19-1988

Visa Type : H1 B

Valid Till : 04-19-2019

Hobbies : Listening music, Gardening

Contact this candidate