Kalaiyappan Meyyappan

------------------------------------------

*** **** **, **** *********** MA

Mob: 623-***-****

Email: u7ek15@r.postjobfree.com

Career Profile:

------------------------------------------

An extremely talented, organized and professional Project Leader in Data warehousing. Seeking a position

as Tech Lead/ Architect to enhance my skills and proficiency in a renowned organization.

Professional strengths:

------------------------------------------

* Certified Project management professional.

* 12 years of extensive IT experience in all aspects of Systems Development and complete Project Life Cycle in Data warehousing, and Client/Server technologies.

* 9 years of Information Systems experience involved in planning and designing Data warehouses, OLTP and Client Server applications for clients of several disciplines including Automotive, Marketing, Sales, Finance and Insurance

* 8 years in Conceptual Data Modeling, Enterprise Data Modeling, Logical Data Modeling, Physical Data Modeling, Enterprise Data Warehouse Design, and Operational Data store Design, Data mart Design, Metadata Management.

* 6 Years in Data warehousing & Business Intelligence architecture

* Possess excellent problem solving and leadership skills

* Worked for prestigious clients like Hyundai (Singapore), Mazda (Singapore), GE Capital, BMC Software, EBay, Hartford Insurance, Washington Mutual, Bank of New York Mellon, Mass Mutual Insurance.

Technical Proficiencies:

------------------------------------------

* Specialization in Data warehousing concepts & tools including Informatica RT 8.1, Business Objects XI, MS SQL Programming.

* Extensive experience in SQL Server database programming and Data modeling for 3NF, Dimension Modeling using ERWin and Visio.

* Familiar with client server programming - VB6.0, ASP, DHTML, VBScript, Java Script, XML, COM/DCOM.

* Expertise in Project management tools like MS Project 2003.

* Good experience with Oracle programming & Oracle Warehouse Builder 9i.

Educational Summary and Certifications:

------------------------------------------

* Bachelor's degree in Computer Science from Madurai University, India 1999

* Master's degree in Computer Applications from Madurai University, India 2002

* Project Management Professional, PMI 2010

Professional Experience:

------------------------------------------

Cognizant Technology Solutions, Teaneck NJ

Client: Babson Capital (Mass Mutual Insurance), Springfield MA

Mar 2009 to till date

Project Leader/ Data Architect

* Leading Pricing development team handling major changes and enhancements to the systems.

* Create Data Mapping for source and target databases

* Develop mappings and Perform code reviews.

* Acted as Lead Data/ETL Architect for building an Analytics & Reporting system for Pricing applications with receiving feeds from various Assets Inventory and Accounting systems.

* Designed and implemented the Supplemental system for Pricing getting prices from S&P and futures trade feed from Bloomberg, using Bloomberg Data License.

* Designed and implemented the Price overrides system which helps business to automate the manual pricing of hundreds of assets every month.

* Designed and implemented major structural changes to Pricing system to cater Pricing feeds to StateStreet Corp.

* Did performance tuning for current nightly processes to complete the ETL jobs 50-60 min earlier every day.

* Interact with Client business team for requirements gathering, business testing and approvals.

* Interact with vendor business, representing the client.

* Technologies used: Informatica 8.5, Maestro, Web Focus, SSRS, SQL Server 2005, .Net 2003, .Net 2005, .Net 2008

Cognizant Technology Solutions, Teaneck NJ

Client: Bank of New York Mellon, New York NY

May 2008 to Feb 2009

Project Leader/ Data Architect

* Interacted with the business, to define the functional requirements

* Lead system analysis of current databases and data feeds.

* Acted as Lead Data Architect for the Data Modeling to replace around 17 Sybase databases.

* Acted as Lead ETL Architect for the Data feed analysis and ETL design to receiving data from 8-10 Mainframe systems

* Data modeling and metadata analysis for the new BI Platform

* Design data mapping from various sources to target DW

* Devise data quality strategy to move data across the data warehouse

* Created master test plans, test strategies and test cases for accurate data movement

* Lead the Client engagement as the Project leader from the inception to the completion of the Project deliverables.

* Prepared Time & Cost Estimates.

* Prepared the Project management plan and executed with involving all the stakeholders.

* Technologies used: Sybase 11.x, Erwin 7.1, MS Visio 2003, Unix Shell scripting

Cognizant Technology Solutions, Teaneck NJ

Client: Washington Mutual, Seattle WA

Nov 2006 to Mar 2008

Tech Lead/ ETL Architect

* Acted as ETL and Data Architect for Wholesale bankloans datamart and Data architect for broker rewards datamart.

* Interacted with the business to arrive at technical requirements.

* Prepared data flow diagrams and business flow diagrams.

* Did extensive Source system analysis data analysis, data structure analysis, source-to-target data analysis and transformation analysis to prepare detailed design specification.

* Defined ETL for real-time fetch and populating consecutive layers.

* Develop strategies to identify, analyze, extract source data, cleanse, transform and load correct data into data marts.

* Develop strategies to cleanse data to ensure only correct data is loaded into data marts.

* Design historical data archival process for Enterprise data marts.

* Design error handling and validation routines for data loading process

* Led Development, Testing (Unit Testing, Regression Testing & SIT)

* Created mappings, workflows, shell scripts to fetch messages in Real-time

* Did Performance testing and tuning for Real-time fetch and populating CLOB data.

* Provided solutions and work-around for fetching and processing xml text.

* Created SQL scripts for Regression testing & Comparison studies

* Did Database Sizing

* Provided UAT and Initial Production Support

* Played crucial role in the Business objects universe design for the data marts as Data architect.

* Prepared Time & Cost Estimates.

* Technologies used: Informatica RT 8.1 , Oracle 9i , Unix Shell scripting , MS Visio 2003, Business Objects XI.

Client: Hartford Insurance, Windsor CT

May 2006 to Oct 2006

Systems analyst (Consultant)

* Led System study, Sampling, gathering requirements.

* Created data flow diagrams

* Interacted with the business, to arrive at technical requirements

* Design the ETL for populating the EDW (additional feeds).

* Involved in Database and Server sizing.

* Defined OMB plus modules to create dynamic mappings.

* Created Logical model for the data-mart.

* Led Quality stage modules for data cleansing: investigate, match, survivorship of customer data.

* Technologies used: Oracle Warehouse Builder 9i, Quality Stage, MS Visio 2003, Erwin 7.1

BMC Software - Pune India

Oct 2004 to Mar 2006

Project Lead (Offshore)

* Defined SDLC for the project & led the project, right from its inception (Project Assessment, Requirements, Design and Development).

* Involved in the requirements gathering.

* Involved in analysis of the existing system & Data Modeling Effort.

* Defined the ETL design for the project.

* Prepare technical requirements including use cases - to be used by the QA team.

* Create mappings, workflows & shell scripts

* Did exhaustive unit, system testing and QA move

* Created Business objects universe, reports & BI testing

* Also led the sun setting & conversion of Siebel Analytics reports to Business Objects for this CIS data warehouse.

* Technologies used: Informatica 7.1, Erwin 3.5, Oracle 9.2, Unix Shell Scripting, Control-M, Business Objects XI.

BirlaSoft - Gurgaon, India

Client: GE Capital, Delhi India

Oct 2003 to Sep 2004

Tech Lead

* Interacted with the business users to gather requirements.

* Did extensive Source system analysis.

* Defined the ETL design for the project & Led ETL development.

* Created ETL Logic to calculate Six Sigma across various processes.

* Created Views, Agents in Lotus Domino Server for Data Pull.

* Did database sizing, testing and performance tuning.

* Created Business objects universe, reports & BI testing

* Technologies used: SQL Server 2000, MS DTS, Stored Procedures, Erwin 3.5, Business Objects 5.1, Lotus Notes & Domino 4.1

Contact this candidate