Saravanakumar Panneerselvam Phone: (***) ***- ****

ETL Lead/Architect Email : adizp2@r.postjobfree.com

Visa status: GC

Summary

• 15 years of IT experience with strong technical skills focus on Data warehousing and business intelligence using ETL Tool - Informaitca PowerCenter, Informatica Data Quality and Master Data Management, Oracle, Teradata, Redshift and Unix shell scripting with key emphasis on requirement gathering, data analysis, design and architect ETL solution

• Experience in design and architecting end to end ETL solutions. Have good hands on exposure (till date) in working with Informatica components like mappings, mapplets, sessions, workflows, reusable components, tasks, debugger, and troubleshooting on mapping failures also have good exposure in tuning the ETL for better performance with high data volumes

• Strong expertise on data warehouse architect including data modeling skills with experience in relational modeling theory and star & snow flake schemas

• Extensive experience in Informatica development, data profiling. Have good understanding on IDQ validations and MDM techniques with the match and merge techniques with the rules and configuration for the survivor / golden record

• Proficient in Logical data model, Physical data model, Data warehouse concepts, Dimensional Modeling using star schema and snow flake schema. Having experience in handling SQL, PL/SQL, packages, procedures, functions and triggers, tables, views, indexes, constraints, synonyms. Have good hands on project exposure in data migration from Oracle8 to Teradata13.1 and also from Netezza to Redshift

• Hands on Unix shell script experience, for handling the ETL loads, file handlings and automation process. Have good exposure in scheduling tools like Autosys, Informatica scheduler, Tidal, Opcon

• Have good exposure in interacting with business users, business analysts in analyzing business requirements and translating requirements into functional and technical design specifications. Experience in writing high level and detail design documents, mapping documents based on business requirements

• Experience in Informatica enterprise platform setup - server installation, configuration and Administration of Informatica Power center client/server. Have created/managed users, user groups, folders and upgrades. Comfortable in navigating the Informatica repository tables on need basis

• Experience on AWS cloud databases and implementing Data warehouse solutions using Redshift; Worked on data migration from on-premise databases to AWS Redshift and S3. Used SAP IDOC interpreters and application connectors with Informatica to bring the SAP data mappings to Warehouse

• Handled the migration activity such as:

Data Migration - Netezza to Redshift - on-premise to AWS migration Data Migration - Oracle to Teradata – Clinical dataset within Abbott/Abbvie Provider Switch - Insurance claims data switch from SHA system to IMS Provider Switch - Real estate data switch from CREST to dash system within Realogy

• Handled code migration / deployment activities, QA related activities and have very good understanding of quality assurance policies & procedures. Involved in conducting technical training on ETL process, DW concepts, and Informatica tool

• Experienced in version control and source code management tools like GIT, SVN. Good understanding of software development methodologies, including Agile (Scrum)

• Experience in handling the team at onsite and offshore with Onsite-Offshore model. Providing technical and managerial oversight of all application development projects: develop concepts and strategies; define scope, procedures and objectives; and coordinate cross-functional technical team resource. Involved in project plans and estimation and responsible for project tracking and deliverables and periodic customer status reporting

Saravanakumar Panneerselvam Phone: (224) 321- 3179 ETL Lead/Architect Email : adizp2@r.postjobfree.com

Visa status: GC

• Ability to work independently, with strong analytical and technical skills, with good communication, good team building, management skills. Good team player with excellent inter-personal skills and customer interaction capabilities. A quick learner and mentor with the ability to make solutions-oriented, creative and innovative contributions in highly demanding situations Academic Qualification

Master of Computer Applications, Bharathidasan University, Trichy, Tamil Nadu, India Organization

TEK Systems – Jul 2019 – Current

Cognizant Technology Solutions – Aug 2010 – Jun-2019 / Aug 2004 – Sep - 2006 Tata Consultancy Services – Sep 2006 – Aug 2010

Technical Skills

ETL Tools : Informatica PowerCenter 10/9.X/8.X, Informatica Data Quality, Kalido Database Systems : Oracle 9i/10g/11g sql, pl/sql, Teradata, Redshift, SQL Server Languages : Unix shell scripting

Operating Systems : Windows, Unix

Scheduling Tools : Autosys, Tidal, Opcon, Informatica scheduler Version Control : Bitbucket, Tortoise

Other Tools : Toad, SQL Developer, Oracle Forms and Reports, Putty, Visio, Erwin 3.x/4.x, Mercury Quality Center, service now, Heat, Jira

Roles and Responsibilities

• Responsible for overall project planning, execution of BI projects on ETL and Reporting needs. Requirement gathering from business, IT and other vendors. Co-ordination with other project stakeholders, and cross team co-ordinations

• Handling ETL and DB design, data modelling, data profiling, impact analysis, identify the data usage for statistical decision and Document and maintain the process and flow on the confluence page

• Architect the ETL framework - data quality / data validations / reconciliation, audits, data age and size monitoring

• Responsible to design and build the ETL solution with Audit and balance control mechanism, data reconciliation, error handling, Dashboard and reports on the metadata, handling ETL performance improvements, data profiling, gap assessment and implementing best practices

• Responsible to create - Informatica mappings, sessions and workflows for the ETL needs, reusable objects, etl deployment groups, Oracle SQL/PLSQL code, Unix scripting for the ETL requirements

• Responsible to create/maintain the project technical documents - High level, low level design documents, ETL specification documents, test cases document and traceability metrics

• Handling task tracker, code reviews, owns the deliverables. Data validation and data profiling. Assisting teams on the ETL and DB design solutions and addressing the technical challenges Saravanakumar Panneerselvam Phone: (224) 321- 3179 ETL Lead/Architect Email : adizp2@r.postjobfree.com

Visa status: GC

• Responsible for project status reports, audit compliance activity, adhoc queries, clarification, and requests from internal and external sources, Code deployment activity, Onsite-Offshore co-ordination Project Experience

Project - Current

Client : Bank of America

Project : Compliance and Surveillance Data Repository Role : Tech Lead

Organization : TEK Systems

Location & Duration : New Jersey – Jul 2019 – Current Environment & Tools : Informatica PowerCenter 9.6 and 10.2, Flat files, Oracle SQL, PL/SQL, SQL Server, Unix Scripting, Autosys, Jit Bash, ITSM, Jira

Project # 7

Client : JP Morgan Chase

Project : Global Identity and Access Management

Location & Duration : New Jersey – Oct 2018 – June 2019 Role : ETL Lead

Organization : Cognizant Technology Solutions

Environment & Tools : Informatica PowerCenter 9.6 and 10.2, Flat files, Oracle SQL, PL/SQL, SQL Server, Unix Scripting, Putty, Autosys, Jit Bash, ITSM, Jira

Project # 6

Client : Carnival Cruise Lines

Project : CRM System

Location & Duration : FL Miami – Jul 2017 – Sep 2018 Role : ETL Lead / Designer

Organization : Cognizant Technology Solutions

Environment & Tools : Informatica PowerCenter, Informatica Data Quality, Flat files, Oracle SQL, PL/SQL, SQL Server, Unix Scripting, Putty, Opcon, Service now, Platinum Project # 5

Client : Coty Inc

Project : MSTR Non-Finished Goods (NFG) inventory

Location & Duration : NY – May 2016– Jul 2017

Role : ETL Lead / Designer

Organization : Cognizant Technology Solutions

Environment & Tools : Informatica PowerCenter 9.6.1, Redshift 1.0.1369, Oracle 11, Linux3.4.2, Redwood, SAP, MicroStrategy, Control-M, Autosys

Project # 4

Client : Novo Nordisk

Project : Biopharm Dashboard and Data Integration

Location & Duration : NJ – Nov 2014 – Apr 2016

Role : ETL Lead & Architect

Organization : Cognizant Technology Solutions

Environment & tools : Informatica PowerCenter, IDQ, MDM, Business glossary, Oracle, OBI, Linux, Informatica scheduler.

Saravanakumar Panneerselvam Phone: (224) 321- 3179 ETL Lead/Architect Email : adizp2@r.postjobfree.com

Visa status: GC

Project # 3

Client : Abbott Laboratories

Project : GIS DW Enterprise Information Management System Location & Duration : India, USA-Chicago Aug 2010 –Nov 2014 Role : ETL Lead Developer

Organization : Cognizant Technology Solutions

Environment & tools : Informatica PowerCenter 9.1, Oracle, Teradata, Unix shell scripts, Autosys Project # 2

Client : Bank Of America

Project : Transaction Hub – Basel & FX

Location & Duration : India, USA-NY, Sep 2006 –Aug 2010 Role : ETL Lead Developer

Organization : Tata Consultancy Solutions

Environment & tools : Informatica PowerCenter, Oracle, DB2, Unix shell scripts, Autosys Project # 1

Client : Intuit

Project : Intuit Data Warehouse

Location & Duration : India, Apr 2004 –Sep 2006

Role : ETL Developer

Organization : Cognizant Technology Solutions

Environment & tools : Informatica PowerCenter, Oracle, Unix shell scripts, Autosys

Contact this candidate