Data Engineer

Purusothaman Ramamoorthy

Mail: ************.***********@*****.***

Mob: +1-213-***-****

Current work Location: Richardson, Texas.

Objective

Seeking challenging opportunity in an organisation to use exceptional experience on Date Warehouse, Database and BI to yields firm profit, success and career advancement.

Technical Skills

ETL Tool : Informatica 9.5, Teradata, Trained in Ab-Initio, Informatica Data Replicator.

Database : Teradata, Oracle, DB2, Netezza.

Language : SQL, Pl/Sql, Perl, Shell scripting, Regular Expression Scheduling Tool : Autosys, Maestro

Project Management tool : Perforce, Mercury Quality Center Data Modelling Tool : Erwin

OS : UNIX, Windows, Mac

Professional Summary:

Having 9 years of experience in data warehouse, worked on all phases of development lifecycle, from gathering requirements to implementation, and support.

Exceptional experience in requirement gathering, analysis, design, development, customization, and implementation of data warehouse applications.

Experienced in working with massive data – Biggest table worked is 12 TB with 900+ attributes and 1.4 Billion records.

Experienced in Data profiling, Data modelling, Code migrations, Data Backfilling, Offshore co-ordination, Code review, UAT support.

Worked on Teradata utilities like Bteq, Multi load, Fast load, fast exports, and Good knowledge on writing efficient sql and experienced in using view point.

Sound knowledge on Informatica PowerCenter. Experienced in using Pushdown optimization, various Informatica partitioning technique, workflow scheduling, Working with various source systems, Performance tuning technique, various workflow tasks, and workflow recovery strategy.

Worked on Oracle stored procedure and PL/SQL.

Good at communicating with various teams like Business users, Partners, Other Vendors, Offshore team.

Domain Knowledge:

Have extensive experience in Health care -- Pharmacy Benefit Management and Drug Manufacturer.

Have experience in Insurance

Have experience in Investment banking.

Experience Summary

Lead Engineer-II – Wipro Technologies, Richardson, Texas. Nov 2014 - Present.

Have been leading migration project, Retired legacy data warehouse of size 35 TB in 12 months. Extensive data analysis and data usage report was generated to identify candidates for migration and retirement.

Migrated data and decommissioned Legacy data warehouse, Retired 400+ Reports, 900+ ETL Jobs, Purged 35 TB of data in Teradata. Saved 2.5 Million Dollars by gaining space, CPU, I/O and by eliminating maintenance cost.

Have created data quality report to gain customer confidence on new data and Coordinated with customer to migrate reports from legacy to modern data warehouse.

Tuned Incremental ETL and History ETL to improve performance, Identified attributes for data compression which saved 5 - 10% space (out of 9 TB), In turn saved 50,000 to 90,000 Dollars.

Lead Engineer – I, Wipro Technologies, Los Angeles California. Nov 2013 - Oct 2014

Designed, developed and implemented Quotes data mart (For Insurance customer), Data mart used to target and provide attractive offers for prospective clients, who generated online quote and not enrolled for policy.

Developed fuzzy logic to de-dup the quotes.

Developed data mock up tool using ksh, which helped to save 20% of unit testing effort.

Lead Engineer – I, Wipro Technologies, Chennai, India. Jun 2012 - Oct 2013

Have been leading offshore development team, implemented various ETL projects.

Developed excel macro to validate coding standard of Informatica ETL and also generates warning report on unconnected I/O ports, Which improved code quality and reduced peer review effort by 20%.

Involved in project estimation and helped sales team for project bidding. Sr. Data Consultant, Hewlett Packard, Chennai/Mumbai, India. Sep 2010 - 2012 Jul

Enhanced Audit Balance and Control framework for ETL that runs in Informatica and Oracle in Unix Env, Which was used in many other projects as HP framework.

Have created Informatica Data Replicator mapping to perform Change data capture.

Have trained batch of fresher in informatica and ANSII SQL.

Have been part of recruitment team.

Sr. Data Consultant, Hewlett Packard, New York. Jul 2010 – Oct 2010

Participated in requirement gathering and design of Audit balance and Control framework along with senior architects in HP.

Sr. Data Consultant, Hewlett Packard, New Jersey. Mar 2010 – Jun 2010

Participated in requirement gathering.

Attended 2 weeks workshop on investment banking business and source system. Sr. Data Consultant, Hewlett Packard, Chennai. Dec 2009 – Feb 2010

Worked on data migration from Oracle to Netezza. Converted Oracle stored procedure to Netezza sql and informatica mapping.

Compared reports between Oracle and Netezza application.

Converted Oracle compatible reporting SQL to Netezza compatible sql. Data Consultant, Hewlett Packard, Chennai. Jul 2007 - Nov 2009

Have developed and Implemented ETL.

Have created ETL to read data from SAP system.

Have maintained ETL and Business Object production environment.

Created automation script to generate reports from ETL log with information like ETL start time, End time, Number of records read and Number of records written, which saved 10% of support effort.

Education Background:

Bachelor of Technology in Electrical and Electronics Engineering – 7.42/10 (CGPA). 2003 – 2007, Pondicherry University.

Contact this candidate