Chenguttuvan Parthiban

Chenguttuvan Parthiban

Mob:- +919*********

Mail:- acszna@r.postjobfree.com/acszna@r.postjobfree.com Summary: 8.5+ years of IT experience

Over 8.5 years of experience in IT industry.

Have 6+ years of experience in US Health care and more than 1.5 years of retail functional domain experience.

Principal Consultant with tech-functional Experience in managing the design, development, support and implementation of ETL solutions in the Data warehousing

& Data Mining Business Intelligence technology.

Having Sound Experience of Software Development using Informatica, Datastage and Business Objects and databases like Oracle 11g, Teradata, and Netezza, SVN Tortoise, Jenkins.

Excellent SQL query writing skills and development skills using BTEQs in Teradata

Technically adapt and confident lead software developer with good flair of processes and their implementation combined with good analytical and communication skills

Excellent requirements management skills and coordination capabilities between Client and development teams

Experienced in working with various data sources like Oracle, Teradata, Netezza, XML, flat files, Fixed width files and MS-Excel

Extensive experience in code review.

Strong debugging skills.

Experienced in doing Business Analysis at US Health Care Projects

Experience involves requirement analysis, system design, High level Design, Low level Design, and testing in both database and File system application development

Technically adapt and confident lead software developer with good flair of processes and their implementation combined with good analytical and communication skills

Good Knowledge in multiple BI tools.

Proficient in creation of Audit Balance and Control (ABC) process in order to have dynamic parameter file creation without manual intervention and to keep track of history run information instead of referring logs.

Good in HLD and LLD designing skills. Proficient in Designing of data flow according to the business requirement.

Proficient experience in ETL where various kinds of sources and targets like Teradata, Oracle, Flat files, COBOL, SAP BI,VERTICA.

Have 3+ year of work experience in Teradata and Oracle.

Sound knowledge in SQL, UNIX file systems and Scripting skills.

Ability to handle and Lead multiple subject areas simultaneously. Chenguttuvan Parthiban

Qualifications:

Graduation

Degree Institute

B.TECH

Information

Technology

Anna University

Technical Proficiency:

ETL Tools Informatica, Data stage

Functional Domain US Health Care, Telecom and Retail Languages SQL, plsql in oracle and BTEQs in Teradata Frameworks High level Design and low level design

Databases Oracle 11g, Teradata, Netezza

Modeling Tool Erwin 7.1

IDE/Tools SQL Developer, Toad, PL/SQL Developer, SQL Navigator, Putty,Winscp, SVN Tortoise, Jenkins

Defect Tracking Tool HP Quality Centre, Jira

Application Servers Rapid Xchange, Developer tools Reporting Tool Business Objects

Operating System Unix, WINDOWS

Version control SVN, Jenkins, Aldea

Shell Script Unix shell scripting

Domain Knowledge:

Health Care Domain

1) Claims data marts

2) Membership datamarts

3) Party model at CVS Caremark

Retail Domain

1) Customer Subject area

Chenguttuvan Parthiban

2) Category/Product Subject area

3) Store-level Subject area

Telecom Domain

1) Inbound and Outbound

Career Profile:

Organization: Hewlett Packard Global Soft.

Project/Client: Blue Shield of California

Designation: Application Development coordinator (Technical lead) & Informatica Administration (Onsite)

Duration: Dec2012 to till date

Activities:

Data model changes for RDI using ERWIN tool

Providing consultancy to the team regarding business knowledge of Implementation Cycle, scenario and alert generation logic.

Handling the UAT, user training, and Project kick off meeting’s and Project closure and hand over Documents and ensure a smooth hand over to the support teams to perform support related activities after implementation.

Estimating the project implementation duration based on user’s requirement and technical feasibility.

Data processing and Data loading from Mantas side and Table to table data movement from RDI side.

Running End to End Data loads for RDI/Rosetta and fixing the errors.

Involved in Data quality checks for RDI/Rosetta.

Involved in solving UAT issues raised by Business users.

Managing the Implementation team and understanding the deployment activities to push the project to Production.

Install various Integration services to upgrade ETL Projects from 8.1 & 8.6 versions to 9.1

Unix environment and setups to new implementations

Smoke testing in each and every environments.

Debug and rectify the issues that causes in the set up.

Set up a template for smoke testing activities

Loading various Rosetta marts like Membership Revenue, Claims Daily, Claims weekly, Oasis Claims, Oasis Membership, and Segmentation in the newly set environments.

Maintain metadata in the DB for the execution of required workflows.

Handle CR requests raised by the customer requirement.

Dig and handle the various issues in the load that may be due to RDI or Facets or environmental.

Resolve and support the AD team till the mart loading is complete

Handling the UAT, user training and hand over Documents and Chenguttuvan Parthiban

Support related activities after implementation.

Understanding the requirement by analysis of Functional specification document.

Analyzing the Data Integration requirements and creating designs for implementing Informatica Jobs

Creating Data mock up sheet, Layer by layer mapping, Source to target mapping, and TDD.

Organized design meetings along with the Data modeler for the transition of the design from High-level to a Low level.

Educate the team members allocated to my project. About the HLD and LLD of the projects developed

Identifying team members’ strengths and weaknesses and allocate tasks accordingly.

Organization : Hewlett Packard Global Soft.

Project / Client: CVS Caremark

Designation : Team Lead

Duration : Feb2010 to Nov2012

Activities:

Analysis and Understanding of the business requirement.

Designed HLD according to the business requirement. HLD includes High level data flow, Layer by layer data mapping, STT preparation and the transition of HLD to LLD.

Organized Design meetings along with the onshore team members to freeze the design part after it suited the business requirement.

Knowledge transition of LLD to the team members for building the code.

Lead the team to develop the LLD.

Development of Teradata bteqs, Informatica Complex mappings for developing Data Warehousing applications.

Created data mocking to perform the UT.

Co-ordinate team members’ activities daily during development phase.

Co-ordinate team to do Unit testing for all those development works.

Signing off the coding and KT to QA team on the HLD to perform SIT.

Resolving for Defects and HEAT tickets raised by the QA team if any.

Organized a session to present our code and UT to other organization folks (Prod support), Data architects, and Business analyst and to our onshore coordinators.

Organization : Accenture Services Pvt Ltd.,

Project / Client: Blue Cross Blue Shield-Michigan

Designation : Software Engineer

Duration : Aug2008 – Feb2010.

Activities:

Chenguttuvan Parthiban

Understanding the requirement by analysis of Functional specification document.

Create Technical specification document for the requirement by understanding the Source to target mapping and FDD

Worked as a part of Design meetings along with the senior team members for the transition of High-level design to a Low level design.

Building of the design part as per the specification provided in TSD earlier.

Worked in the Production support environment handling tickets that directly goes to UAT without SIT.

Perform Unit testing for all those development works

Perform Regression testing, Focus testing, Integration testing based on the defects found by the testing team.

Organization : Reliance Info Solutions.

Project / Client: Reliance Retail

Designation : ETL Developer

Duration : Jan2007 – Aug2008.

Activities:

Development, UT, QA, Production support For the Customer Applications.

The Customer application deals with transactions by customers on daily, weekly, weekends, monthly is maintained and their points they get accumulated.

Development, UT, QA, Production support Jewelry Applications where data from several Reliance jewelry stores.

Insurance Coverage Of Stocks, data is sent To SAP-BW and It gets Reported by BW

Potential Loss Due To Stock Out –Store Wise

Segmentation of Loyalty customers.

Project Description:

Blue Shield of CA: (Dec2012- till date) at HP, San Francisco Tech skills used: Informatica, Oracle, Netezza, Unix, Erwin, Main Frame Blue Shield of California is a health care insurance company and our project mainly focusses on the Data warehousing and Data mining of Rosetta Data integration. This project covers various source system such as Main frame, Facets Data source, Fixed width, Flat Files. It covers design and development of HLD, LLD of the ETL and the data base modelling. The HLD includes Pre stage tables, Staging tables, Work tables and high level ETL flow. The LLD includes layer by layer data mapping, Source to Target transformations, and a mapping level ETL design. The project is a core dimensional modelling based one and it has various data marts which in turn has its own models. Our Project covered different and complex data marts which involves Chenguttuvan Parthiban

Claims Daily, Claims Weekly, Membership, HMOPPO, Pharmacy, Capitation subject areas. It also covers design and development of CalPERS, Medicare, Medicaid claims application extracts. CAREMARK: (Feb2010 – Nov2012) at HP, Chennai

Tech skills used: Informatica, Teradata, Unix, DT Studio Data warehousing of Caremark a Payer in Health care Industry dealt with various subject areas like Member, Client, Claims, Prescriber, Pharmacy. Huge data manipulation and maintenance is done with respect to membership, medical, claims by using famous modeling pattern called Party model. Data retrieval for various vendors through a fork lifting where a data could be either a through a file or a historical data. Data is provided from various sources like XML data file set, Oracle, Flat file, Teradata. Data from the above sources are moved to the target Teradata tables with some complex business logics. BCBS-M: (Aug’08 – Present) at Accenture, Chennai

Tech skills used: Informatica,Oracle, Unix

Data warehousing of Blue Cross Blue Shield of Michigan a Payer in Health care Industry dealt with various modules like Inbound, Outbound, Claims datamart, Wellness & care management. Huge data manipulation and maintenance is done with respect to membership, medical, claims. Data retrieval for various vendors through a request where a request id could be either a through a file or a historical data. Data is provided from various sources like DB2,Main frame data file set, Oracle, Flat file. Data from the above sources are moved to the targets like ODS, Marts, Flat files and oracle tables with some complex business logics.

DSS of Reliance Retail:(Jan`07-Aug-08) at Reliance Info Solutions, Mumbai Tech skills used: Informatica, Oracle, Unix, Jilaba, Retailix, Data stage Data Warehousing Of Reliance Retail Mainly Deals With Huge Maintenance, Manipulation of Data Related To Reliance Fresh, CDIT, Hyper, Digital, Reliance Jewelry etc. Data from the Retalix Comes In two Formats like EOD, Trickle in a XML Generated File Format The Data is being extracted and loaded into various Oracle tables by using ETL Tool, From there Operations, Finance. Testing and quality assurance was done by the data analysts and business analysts available in the team. Support to the production applications was done by the developer while the execution of ETL jobs or mappings was done by execution team . Finally Reporting is Made By Using Sap BW/BO

Personal Details

Chenguttuvan Parthiban

Date of Birth 14-June-1985

Passport Number F7262388

Place of issue Chennai -India

Contact this candidate