SUMMARY

DW/BI Architect with * yrs of experience in Data Warehousing, Data Integration, Master Data Management, BI and ETL solutions

Worked with Fortune 500 clients across North America and EMEA in verticals such as Finance, Telecommunication, Hi-Tec, Healthcare and Banking

TECHNICAL SKILLS

Data Integration

IBM InfoSphere DataStage 8.x, Informatica Power Center 9.x

MDM Tools

IBM MDM 11.x.

Data Quality

IBM QualityStage 8.x

Data Profiling

IBM Information Analyzer, AXIO

Programming/Scripting Languages

HTML, Unix Shell script, JAVA script, Python,R

RDBMS

Oracle 11g, DB2, Teradata, PL/SQL

Platform and Server

UNIX,Windows

Modeling Tool

Analytics

ERWin Data Modeller

Tableau, SpotFire

EDUCATION, CERTIFICATION & TRAINING

MCA, Madurai Kamaraj University,2006

Expert Rating Certified Data Warehousing Professional

Cognizant Certified Professional in Banking and Financial Services

IBM Certified Professional in AIX v.5 Basic Operations

IBM Certified Professional in IBM Information Server 8.5 Advanced Data Integration

EMPLOYMENT HISTORY - DETAILS

TIAA-CREF Apr 2015- Till Date

Developer:

Constructed a unified data platform that can integrate data from more than 5 data sources varied in business functions.

Design of ETL process using IBM Datastage (Data Integrator) to create golden customer record and load into MDM

Template based transformation rules to integrate data files into the rule engine using IBM Quality Stage

Data control, referential data store, exception data rules, audit process were designed as a part of ETL.

CDC process and history mechanism were taken for design consideration.

Exusia Inc AUG 2014 – Jan 2015

Client: Dealer Track Technologies

Senior Consultant( ETL/Analytics):

Developed the ETL components to create the analytics repository

Involved in the end to end development activities and vizualizations

Used the real time data to generate the reports and dashboards

Performed Predictive Analysis to gain competitive advantage

Troubleshoot technical issues when the need arises, and escalating appropriately as needed

Managed offshore resources to keep track of the project

Technologies: Datastage 8.x, Informatica 9.x, DB2 Blu, Spotfire Cloud

InfoTrellis, India AUG 2012 – Mar 2014

Client: DELL

Technical Manager:

Manage a team of ETL/MDM Developers

Preparing HLD & Detailed Design Document

Troubleshoot technical issues and ensured end to end delivery of the project

As part of the project, worked on a POC in a product team on R

Technologies: Informatica 9.1, Oracle 11g, R

Client: JCPenny

ETL Lead:

Lead a team of ETL developers to load the Account model with the new Rewards information from the source system

Design the Process Flow and Data Flow Diagrams.

Create High level and Low level Design Documents.

Create Audit and Error schema designs

Review of Informatica Power Center Mappings and Workflow against standards and best practices.

Performance Tuning of Workflows involving XML, XSD

Technologies: Informatica 9.1, Teradata, DB2, Erwin, Visio

Client: American Heart Association

ETL Lead:

Identify and fix data anomalies in ETL and MDM processes

Developed Quality stage jobs for data standardization and pattern matching

Prepare technical and system specifications documents for all ETL processes

Responsible for operational support activities and code deployments for IBM DataStage and MDM Server across Dev, QA and Production environments

Technologies: IBM Datastage v8.5, SQL Server 2008 R2, IBM MDM v9, Oracle 11g, PL/SQL, Quality Stage

IBM Private Ltd, India FEB 2011 – AUG 2012

Client: at&t

End-to-End Manager, Industrial Sector Lead:

Review the modules and assist the team on performance tuning

Devise Project planning, execution, monitoring and resource balancing skill

Support multiple simultaneous projects in a matrix organizational structure

Interact with stakeholders to provide accurate reporting and information regarding the ongoing projects and initiatives

Technologies: SQL Server, DB2, Oracle, Microsoft Project, AXIO, DataStage, Informatica

Cognizant Technology Solutions, India June 2008 – Feb 2011

Client: Bank of NY Mellon

Programmer Analyst & Lead:

Analyze the requirements to the functionality of both source and target systems

Conduct sessions on DataStage and Data Warehouse for onsite/offshore team

Coordinate with the Requirements gathering (onsite) team to design DataStage jobs

Extended support for bugs fixings and change requests raised by onsite testing team to incorporate the correct/additional functionality, and performance tuning

Developed Quality stage jobs for data standardization and pattern matching

Technologies: UNIX, Windows NT, SQL Server, DB2, Oracle, Microsoft Project, DataStage, PeopleSoft, Quality Stage

HCL Technologies, India Jan 2006– JUNE2008

Client: Halifax Bank of Scotland

Developer, Lead, PQA, DPA:

Prepare Technical Design Document

Design data models using the tool Erwin

Analyze and Developed complex jobs and implemented routines

Coordinate with the onsite co-coordinator in driving the Issues and Defects to closure.

Extend the support for Production

Play a PQA Role and increased the quality of the project to 95 %

Technologies:UNIX, Windows NT, SQL Server, DB2,Oracle, Microsoft Project, DataStage, Erwin, AXIO

Contact this candidate