Sr. Informatica Developer / Consultant 11+ Yrs of Exp

Sureshkumar Periasamy

Mobile: +1-901-***-****

E-Mail: ***********.****@*******.***

PROFESSIONAL SYNOPSIS

Over 11 years of IT experience as specialist in performing Analysis Design Development Testing Deployment and Maintenance for various software applications.

Responsibilities include working with multiple clients as a ETL Lead, Onsite-coordinator, Tech Lead for various projects, with the ability to lead diversified teams and interests.

Extensive experience in ETL design development and maintenance using RDBMS database systems and Informatica Power Center / Cloud on UNIX and Windows platforms.

Expertise in Data Warehousing, Data Migration and Integration using Business Intelligence BI tools such as Informatica PowerCenter, Power Exchange CDC, B2B Data Transformation, Data Quality, SSIS etc.

Proficient in Informatica administration work including installing and configuring Informatica and repositories servers on Windows and UNIX platforms, backup repositories, enabling security and user account maintenance.

Experienced in Installing, Configuring, Upgrading and Administering Complete Informatica PC, IDQ, PIM and B2B Components.

Expertise in creating Deployment Groups and Applying Labels. Managing Informatica servers and Informatica services.

Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.

Extensively worked in SAP Integration/Migration Project using ETL (Informatica); Built Interfaces (Inbound/Outbound) or Data migration using BCI, RFC and IDOC through Informatica to load data into the system (Oracle, SQL Server).

Generated and Installed ABAP Program / SAP R3 Code Using Informatica 9.6.1.

Experienced with Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling and Data Governance.

Extensive knowledge of RDBMS like MSSQL, Oracle 9i, 11g, Teradata.

Experience in UNIX shell scripting, automation of ETL processes using Cron tab.

Experience is performing data migration from legacy system to Salesforce.COM.

Good working knowledge in querying Salesforce.com database using SOQL & SOSL queries using Force.com Explorer & Workbench.

Experience working in production support environment.

Having Greater Flexibility in working with any Data Warehousing Tool.

PROFESSIONAL QUALIFICATION

Master of Science (Computer Tech.,) from Kongu Engineering College (Affiliated to Anna univ). - 2005

SKILL SET

Operating Systems : UNIX (Sun-Solaris, HP-UX), AIX, Windows Platforms

ETL /BI Tools : Informatica PowerCenter 10x/9x/8x/7x, Informatica Administration, Informatica Cloud, Informatica (IDQ) Data Quality, Informatica Developer Client, Power Exchange 9.5.1, Informatica Product 360 8.0.6 (PIM), B2B Data Exchange, SQL Server Integration Services (SSIS), Erwin

Other Tools : SAP NetWeaver 730, JD Edwards i-Series, TIBCO Spotfire, Business Objects, IBM iSeries, Control-M, Autosys, Tidal, SQL Developer, Salesforce.com, Cognos

Languages : SQL, PL/SQL, UNIX Shell Scripting, Windows Batch Script

Databases : Oracle 9i/10g/11g/12c, Teradata V2R6.2, MS SQL Server 12/08/05, DB2, Greenplum DB

WORK EXPERIENCE

SL No.

Employer

Employment Period

1

Cognizant Technology Solutions / (Associate – Projects)

Dec 2010 – Till Date

2

E2E Infoware Pvt Ltd / (Informatica Developer)

Mar 2010 – Dec 2010

3

HCL Technologies / (Support Analyst)

Apr 2008 - Mar 2010

4

Klabs Technology & Solution Pvt Ltd / (Developer)

Sep 2006 - Mar 2008

PROJECT EXPERIENCE

Client: Smith & Nephew Inc., Memphis TN April 2016 -Till date

Role: Sr. Informatica Lead / BI Analyst

Environment : Informatica 10.1, 9.6.1, IDQ 10.1, Informatica P360 8.0.6.01.00, Oracle 12c Enterprises Edition, SAP, UNIX Shell Scripting, ServiceNow

Description:

Smith & Nephew (S&N) finished goods inventories have grown faster than revenues without improving customer service or delivery consistency to the S&N in-market companies. Supply Chain organization effectiveness is limited by low inventory visibility, low levels of collaboration with markets, and spending majority of time cobbling together information rather than analysing and acting on it. The goal of the projects is to standardize global supply chain processes contributing to global inventory reductions, improved service levels and better capacity utilization.

Contributions :

Led a team of Developers, which includes an outsourced development team, on the day-to-day efforts across multiple projects and provided architectural road map, direction and work packets for ETL needs.

Performed the roles of Senior ETL Informatica and Data Quality (IDQ) developer and responsible for requirements gathering, preparing mapping document, architecting end to end ETL flow, building complex ETL procedures, developing strategy.

As a developer; Worked with Functional consultant and SAP developers to design the function modules for extract the data from SAP R3 systems.

Read data from SAP BCI and full extract and loaded data to SAP targets through IDOC prepare transformation.

Extensively used Experience in working with SAP Developers to create Function modules or transparent (Z Table in SAP) tables for Migration /Loading of Data from SAP R3, SAP BW to Oracle and then loading to external targets like SQL Server and Flat files.

Extensively work on the performance tuning of Informatica PowerCenter Mappings as well as the tuning of the sessions by creating multiple sessions on primary key values by using partition query.

Developed ABAP Programs (reports) to upload the data/download the data. Performed unit, integration and system level performance testing.

Extensively worked on Informatica pushdown optimization. Also, worked on mapping / session / table level optimization etc.

Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.

Monitor Informatica platforms Performance across all the environments and taking necessary actions in case of File system/permission/space issues.

UNIX shell scripting, for various functions such as maintenance, backup, and server health checks.

Perform Disaster Recovery of ETL systems.

Provided 24/7 production support to all the ETL Informatica applications and Projects.

As an admin; provided operational support services relating to informatica components, installation, applications and infrastructure.

Created and managed global and local repositories. Worked on creating Informatica repositories, backup repositories, enabling security.

Configure and optimize all aspects of Informatica platform Server suit, including policies, control standards, procedures and dashboards.

Administer projects, roles, user, and privileges across all the environments.

Creating and managing connections and providing the required access levels Using Repository Manager.

Regular Monitoring and troubleshooting the Informatica domain.

Regular repository backup / recovery activities as part of disaster recovery plan.

Environment setup by Installation and configuration of Informatica suite (IPC, IDE, IDQ & MDM).

Created and configured the Reporting and Dashboards service for Data Quality application.

Client: Wright Medical Technology, Inc., Memphis TN Nov 2014 – Apr 2016

Role: Sr. Informatica Lead/ Sr. ETL Developer

Environment : Informatica 9.6.0/ Power Exchange, Greenplum, SQL Server 2012, SSIS, JDE i-Series, TIBCO Spotfire

Description:

Wright Medical Group is a specialty orthopaedic company that provides extremity and biologic solutions which alleviate pain and restores lifestyles. We are a recognized leader of surgical solutions for foot and ankle procedures in one of the fastest growing segments in medical technology. Wright Medical Technology Finance Data Warehouse Implementation program involves designing and implementing a Replication from ODS application to Greenplum Data warehouse and exposed the data for various reporting.

Contributions :

Prototyped Dimension Model & ETL process by matching the business requirements and core technical requirements from reporting team.

Requirements gathering and discussion with the Clients to understand the Business Logic.

Working with the Business Analysts and the QA team for validation and verification of the development.

Implementation experience of CDC using stored procedures, triggers and using Informatica power exchange.

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Handling System analysis, Estimations, design and development for enhancements and change requests.

Review of SIT plan, Support to change requests implementation

Involved in creating and management of global and local repositories and assigning permissions using Repository Manager. Also migrated repositories between development, testing and production systems.

Provided administrative functions like creating repositories, backing up repositories, setting up users, assigning permissions and setting up folders in Repository manager.

Created and Maintained users and User profiles.

Hands on experience in creating Deployment Groups and Applying Labels.

Involved in Installation & configuration of Informatica PowerCenter 9.6 (Client, Repository Service & Integration Service) on windows platform.

Preparation of QA migration and PROD migration Documents after development and testing in development environment and executed Quality Assurance testing.

Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use

Client: Abbott Diabetes Care (ADC), Chennai, India Feb 2014 – Nov 2014

Role: Sr Informatica Lead (Offshore)

Environment : Data Warehousing, Informatica 9.6/ Cloud, SQL Server 2012, Salesforce.COM, UNIX, Cygwin2.8

Description:

ADC DW is to build a new data warehouse that would cater to the business and reporting requirements for three primary data groups namely B2B SFA, Market Share and Customer Oriented Program/DtP.

Contributions:

Involved in Design Specifications and technical Sessions.

Developed Detail Design and Mapping Document to present to client for the Informatica cloud process for the Salesforce objects.

Created and edited custom objects and custom fields in Salesforce and checked the field level Securities.

Enabled Bulk data load for loading into the Sales force and checked the jobs in sales force Administration setup

Extracted data from Salesforce.com (SFDC), SQL Server DB and Data files using Informatica cloud tasks.

Wrote UNIX shell scripts for file transfer/archiving.

Assisted Business Analyst with drafting the requirements, implementing design and development of various components of ETL for various applications.

Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.

Analyzed requirements from the users and created, reviewed the specifications for the ETL.

Used PMCMD, and UNIX shell scripts for workflow automation.

Client: Johnson & Johnson, Chennai, India Jul 2012 – Feb 2014

Role: Sr Informatica Lead (Offshore)

Environment : Data Warehousing, Informatica 9.1/ Cloud, Oracle 11g, Sql Server 2008, Salesforce.COM, Qlikview

Description:

Mentor Sales Analytics Project involves build and loading of three layers – Staging, Integration and Data warehouse using the Informatica workflows. The data mart provides reporting capability to the user based on JD Edwards ERP. This data will be loaded into the Mart by a three stage process. Integrate the source sales data into the existing Mentor BIDW and make it available for reporting.

Contributions :

Involved in Design Specifications and technical Sessions.

Understood the Business point of view to implement coding using Informatica power center designer.

Understanding High Level ETL Requirement specifications to develop LLD for type-I, SCD Type-II and Type III mappings and done rigorous testing for various test cases.

Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.

Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.

Developed Informatica cloud task to load data from various sources into Salesforce.

Developed complex QlikView scripts to build model, to support various KPIs and time comparison

Client: Takeda Pharmaceutical, Chennai, India Dec 2011 – Jul 2012

Role: Sr Informatica Lead (Offshore)

Environment : Data Warehousing, Informatica 8.6.1, Oracle 9i, 10g, UNIX, Tidal

Description:

IMS Data project involves enhancement on a existing system to enable flexibility to switch a market and govern the processing frequency for IMS XPONENT split week data from weekly to monthly and vice versa and also, to enable the system to switch the processing for IMS DDD data from monthly to quarterly and vice versa for any selected Takeda markets. Development of ETL components for a separate flow to synergize the reporting standards in tune with the market switches.

Contributions :

Involved in Design Specifications and technical Sessions.

Worked Extensively on Informatica tools -Designer Workflow monitor and Workflow Manager.

Creation of ETL components to propagate the Monthly data feeds.

Evaluation and construction of methods to commandeer the effective run times of the ETL maps followed by the performance tuning.

Exhaustive system study to gauge the developed system most efficiently and synergize the two flows to work together to summarize the report schedules.

Provided support and quality validation thru test cases for all stages Unit and Integration testing

Have contributed in UNIX shell scripting and Oracle PL/SQL procedures.

Client: Bayer Healthcare Pharmaceuticals, Chennai, India Nov 2011 – Dec 2011

Role: Sr Informatica Lead / Developer (Offshore)

Environment : Data Warehousing, Informatica 8.6.1, Teradata, Unix

Description:

Bayer Healthcare Pharmaceutical's A Better Business Intelligence (ABBI) project corresponds to build phase of the program aimed at building a data warehouse of business intelligence gathered from heterogeneous data sources. Various data sources situated internally and externally would provide Commercial data for Bayer\'s range of products (for example sales by product category, sales by region). Cognizant\'s ABBI solution will integrate and maintain data coming from these sources on a single integrated platform.

Contributions :

Involved in Design Specifications and technical Sessions.

Understood the Business point of view to implement coding using Informatica power center designer.

Working with CR Implementation.

Interfaces are built and automated with Informatica ETL tool, Unix Shell Scripting.

Experienced using Informatica integrated with shell programming.

Experienced in Tuning Informatica Mappings to identify and remove processing bottlenecks

Involved in writing UNIX shell scripts to run and schedule batch jobs.

Client: Pfizer Inc., Tokyo, Japan Sep 2011 – Oct 2011

Role: Sr Informatica Lead / Developer (Offshore)

Environment : Data Warehousing, Informatica 8.6.1, Oracle 9i, 10g, Unix

Description:

A part of Pfizer's Japan, the Data Warehousing and Business Intelligence (DW & BI) group is responsible for providing DW & BI services and setting strategy for the division. The project includes building the new dataflow for the new product launched and make it available to the reporting layer.

Contributions :

Requirements gathering and discussion with the Clients to understand the Business Logic

Preparation of the following various technical and functional documents (applicable depending on the request types) Requirement Specification document, High Level Analysis and Approach document, High Level Design Document, Detailed Design Document and implementation plans.

Client: Pfizer Inc., Chennai, India Dec 2010 – Sep 2011

Role: Sr Informatica Lead / Developer (Offshore)

Environment : Data Warehousing, Informatica 8.6.1, Oracle 9i, 10g, Unix

Description:

The goal of the PfAST project is to develop a central repository for safety data, otherwise known as the Global Safety Data Warehouse (GSDW), as well as the PfAST Data Mart (PfAST DM) for surveillance, evaluation, and analysis of safety data. It also enables Pfizer to respond to regulatory needs and queries in a timely manner, thus ensuring Pfizer to meet its regulatory obligations. The GSDW contains data extracted from the legacy source systems. Data is propagated from the GSDW into the PfAST DM on daily basis.

Contributions :

I have worked in Data warehouse support and maintain project with a client from life science. In my entire work duration I have solving data and ETL issues along with functional and technical analysis development.

Review Business requirements and Change request.

Review of SIT plan, Support to change requests implementation

Extracting data from Different sources and loading into the staging table.

I extensively worked with source analyzer, target designer, transformation developer and mapping and mapplet designer

Performed unit testing at various levels of the ETL.

Involved in Creating sessions and workflows, and scheduling to load the data into the targets.

Involved in coding UNIX shell scripting to execute pre/post session commands.

Client: Xafinity Paymaster, Chennai, India Apr 2008 – Dec 2010

Role: Informatica Developer (Offshore)

Environment : Data Warehousing, Informatica 7.1.1, Oracle 9i, 10g

Description:

Xafinity Paymaster provides pensions administration and payroll services to more than 140 organisations, covering a wide range of industries across both the public and private sectors. This project was designed to track all the business transactions of the client and load them to a ware house.

Contributions :

Monitoring, troubleshooting & re/starting the application server, Informatica server for different clients in different instances like PRD, DEV & UAT.

Uploading the client’s report file in to the server to the specified instances.

Creating Transformations, Mapping designer, Mapplet designer, sessions, workflow manager in Informatica to carry out ETL.

Creating the Technical design specifications based on Client functional specs.

Database tuning and performance monitoring

Studied Reject Files and Session Log files to correct errors in mappings and sessions.

Used Debugger making use of Breakpoints to monitor data movement and troubleshoot the mappings.

Supervising the technical team to restore the database in-case of system failure.

Client: Mettex Laboratories of India, Chennai, India Sep 2006 – Mar 2008

Role: Informatica Developer (Offshore)

Environment : Data Warehousing, Informatica 7.1.1 / 6.2, Oracle 9i

Contribution:

Responsible for monitoring the Production status, and ensure the ETL process works as expected; handle user communication around production issues.

Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.

Performed tasks of validating and executing the sessions in Informatica.

Handled System analysis, Estimations, design and development for enhancements and change requests.

Responsible for Creating New Tables and Alter the existing table as per the requirement.

Contact this candidate