Candidates About

 

Madhu Tirumandyam

Professional Summary:

·         Over 10 + Years of IT Experience in development of Enterprise Data Warehouse applications using Informatica, Oracle and Teradata.

·         Experience in all phases of Data warehouse development from Requirements, analysis, design, development, testing and post production support.

·         Strong in-depth knowledge in doing data analysis, data quality and source system analysis.

·         Independent, Self-starter, enthusiastic team player with strong adaptability to new technologies.

·         Excellent track record in delivering quality software on time to meet the business priorities.

·         Developed Data Warehouse/Data Mart systems, using various RDBMS (Oracle, MS-SQL Server, Mainframes, Teradata and DB2).

·         Extensive experience using Informatica Power Center (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, and Repository Manager), Oracle, MS SQL Server, DB2 and SAP.

·         Expertise in Informatica ETL tool to develop, test and tune Mappings, sessions and workflows

·         Expertise in testing mappings in Informatica Power Center. Assisted in creating Test Plans, Test Cases, Reporting defects and resolving the technical issues based on Business Requirements.

·         Highly Proficient in using Informatica Power Center, Power Exchange, Power Connect , IDQ, MDM and explore on Informatica Data Services.

·         Strong Knowledge in BDM (Big data Management)

·         Experience in Big Data Technologies using Hadoop, Sqoop, Pig and Hive.

 

Computer Expertise:

ETL Tools	Informatica, Data Stage, SSIS
Databases	Teradata 12/13/14, Oracle 9i/10g/11g/12c, MySQL, SQL Server 2000/2005, MS Access, DB2, Hadoop (HDFS)
GUI	.Net Custom development, Business Objects, Micro Strategy ,OBIEE
Operating Systems	Windows, Unix, Linux, Python
Languages	C#, VB Script, HTML, DHTML, Java Script, SQL, PL/SQL, Unix Shell, Python, Hive, Pig
Web Related	ASP.NET, VB Script, HTML, DHTML, JAVA, Java Script,REST, SOAP, Web Services
Tools & Utilities	Teradata Parallel Transporter, Aprimo 6.1/8.X, Bteq, SQL Assistant, Toad, SQL Navigator, SQL*Loader, $U , HP Quality center, PVCS, Data Flux, UC4, Control-M
Domain Knowledge	Banking, Finance, Insurances, Health Care, Energy, Retail

 

Education

• B.Tech.  in Computer Science, JNTU University, Hyderabad, India

 

Professional Experience

Professional Experience

Teradata developer

/ETL Deveploer                                                                    May 2017 – Till Date

Safeway Pleasanton, CA

Project Description:

 

Albertson’s Merger

           

            United Market is independent organization owned by Albertsons companies. Albertson’s Marketing team need visibility into Sales, Promotional and marketing data to me merged with rest of the Organization. EDW data from United markets was extracted, mapped and integrated with Albertson’s data.

           

• Worked with Safeway and united business users to capture data requirements and transformational rules between source systems with Albertsons EDW.
• Developed Mapping and design documents for Sales, Promotional and Marketing data.
• Performed data profiling, source systems analysis to understand data  and quality issues.
• Developed BTEQ scripts to transform from Stage to 3rd NF and then to aggregate.
• Tuned Complex Teradata queries to meet performance level agreements using statics, Indices, and Partitioning Techniques.
• Multiload, Fast load, BTEQ, Created, modified databases, performed capacity planning.
• Developed Informatica mappings for source to target loading from BODI to TP.
• Worked on Aprimo Integration/Customization and configuration.
• Source System Analysis and provide input to data modeling, and developing ETL design document as per business requirements.
• Expertise in Informatica ETL tool to develop, test and tune Mappings, sessions and workflows
• Expertise in testing mappings in Informatica Power Center. Assisted in creating Test Plans, Test Cases, Reporting defects and resolving the technical issues based on Business Requirements.
• Generating Flat files from Teradata 3NF tables using Teradata Fast Export utility, and

then FTP them using shell script to a different UNIX server for the Application team’s consumption.

 

 

Environment: Teradata, Teradata Viewpoint, Teradata Studio, Informatica, ALM, Unix.

 

 

 

ETL Developer                                                                           Feb 2017 – Apr 2017

 

Sutter Health, Scaramento, CA

Project Description:

 

AQRS(Ambulatory Quality Reporting System) is used to report the quality of health care cost incurred and preventive medicine that is used by doctors and physicians. It includes both commercial and Medicare patients.

 

 

 

• Source System Analysis and provide input to data modeling, and developing ETL design document as per business requirements.
• Design, Developing and testing of the various Mappings and Mapplets, worklets and workflows involved in the ETL process.
• Developed and Integrated Data Quality measures into ETL frame work using Informatica Data Quality (IDQ).
• Expertise in Informatica ETL tool to develop, test and tune Mappings, sessions and workflows
• Expertise in testing mappings in Informatica Power Center. Assisted in creating Test Plans, Test Cases, Reporting defects and resolving the technical issues based on Business Requirements.
•  

 

Environment: SQL Server, PL/SQL, MySQL, Informatica Power Center, Windows XP, UNIX Shell scripting.

 

 

Teradata Performance Engineer/ETL developer

Bank of the West, CA                                                                     Sep 2014 – Jan 2017

Project Description:

 

Customer Relationship Management (CRM) implemented by a Teradata Aprimo, to handle its contact with its customers. CRM software is used to support these processes, storing information about current and prospective customers. The interface helps to improve services provided directly to customers and to use the information in the system for targeted marketing and sales purposes.

Responsibilities:

·         Performance tuning, including collecting statistics, analyzing explains & determine which tables needed stats.  Increased performance by 50-75% in some situations.

• Develop complex SQL queries to identify the performance bottle necks in the processing.
• Profound understanding of Banking Campaign management experience.
• Working with Business analyst to develop productive models and advance SQL statements.
• Multiload, BTEQ, created & modified databases, performed capacity planning.
• Developed Sqoop Jobs to integrate Data from Oracle and Teradata for application migration.
• Transformed data from STG Tables into Final Tables using Hive Scripts.
• Developed PIG scripts for Analysts to analyze data on HDFS.
• Writing python scripts to get the usage stats for all edge nodes.
• From Hadoop used to refine and analyze clickstream data
• Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
• Refreshed the data by using fast export and fast load utilities.
• Developed Informatica mappings for source to target loading from BODI to TP.
• Worked on Aprimo Integration/Customization and configuration.
• Source System Analysis and provide input to data modeling, and developing ETL design document as per business requirements.
• Expertise in Informatica ETL tool to develop, test and tune Mappings, sessions and workflows
• Expertise in testing mappings in Informatica Power Center. Assisted in creating Test Plans, Test Cases, Reporting defects and resolving the technical issues based on Business Requirements.
• Worked on OBIEE Reports
• Worked on Python to run the jobs used to clean data.

Environment: Teradata, Teradata Viewpoint, Aprimo, Informatica ,  Oracle , PL/SQL, OBIEE, Windows, HP Quality center, Unix, Python.

ETL and Teradata Developer

PayPal, CA                                                                                       Feb 2014 – Aug 2014

 

Project Description:

GCE (Global Credit Expansion), is to expand BillMeLater services globally. This project aimed at consolidating multiple source systems into Single Source of Truth for BI Reporting, Decision Support Systems.

 

Responsibilities:

·         Analysis, Design, Development, Testing and Deployment of Informatica workflows, BTEQ scripts, Python and shell scripts.

• Source System Analysis and provide input to data modeling, and developing ETL design document as per business requirements.
• Design, Developing and testing of the various Mappings and Mapplets, worklets and workflows involved in the ETL process.
• Developed and Integrated Data Quality measures into ETL frame work using Informatica Data Quality (IDQ).
• Developed Mapplet and Worklets as a part of standard Procedure while developing SAP inbound/outbound mappings.
• Worked on Pushdown Optimization.
• Optimized Performance of existing Workflow Manager.
• Experience in data profiling using IDQ for input into ETL Design and Data Modelling.
• Extensively used ETL to transfer data from different source system and load the data into the target DB.
• Developing Informatica mappings with the collection of all Sources, Targets, and Transformations using Informatica Designer.
• Extracting data from various sources across the organization (Oracle, MySQL, SQL Server and Flat files) and loading into staging area.

Environment: Teradata, Oracle  ,PL/SQL, MySQL, Informatica Power Center , Power Exchange, IDQ, OCL Tool, UC4, Control-M, ER Viewer, Business Intelligence, Windows, HP Quality center ,Unix, Linux.

ETL Developer

Maryland State, Annapolis, MD                                                        June 2010 –  Jan 2014

Project Description:

 

Modernized Integrated Tax System (MITS) will enable Maryland state department of audit control to run analytics on Tax filings. MITS systems extract tax filing data from multiple sources for individuals and Organizations both filed electronically and manually. Data is integrated in EDW and feed to downstream applications in other state departments.

 

Responsibilities:

·         Developed Low level mappings for Tables and columns from source to target systems.

• Wrote and optimized Initial data load scripts using Information and Database utilities.
• Using Partitions to extract data from source and load it to Teradata using TPT load with proper load balance on Teradata server.
• Wrote Complex Bteq scripts to incorporate Business functionality in transforming the data from Staging into 3^rd normal form.
• Participated in Teradata Upgrade project to upgrade from TD12 to TD13.10 to conduct regression testing.
• Developed packages ,load data by using SSIS.

Environment: Teradata, Oracle, PL/SQL, MySQL, Informatica Power Center, Ab Initio, ER Viewer, Windows XP, HP Quality center , UNIX Shell scripting.

 

Care First (Blue Cross Blue Shields)

Owings Mills, MD                                                                                  Dec 2008 – Jun 2010

 

Role: Senior ETL Developer

Project Description:

The project scope is to build Departmental Data Mart for CareFirst Human resources and Administration. This Data mart consolidates data from PeopleSoft and external vendors. Employees Health plan information is integrated from PeopleSoft for all its employees on CareFirst plan as well as other offered plans. External Data is integrated using File Extracts on daily basis.

 

Responsibilities:

·         Created Uprocs, Sessions, Management Unit to schedule jobs using $U.

• Conduct source System Analysis and developed ETL design document to meet business requirements.
• Tuned Teradata Sql queries and resolved performance issues due to Data Skew and Spool space issues.
• Developed Flat files from Teradata using fast export, Bteq to disseminate to downstream dependent systems.

Environment: Teradata, Oracle PL/SQL, Informatica Power Center, $U, Business Objects, SSIS, Windows XP, UNIX Shell scripting.

Scott & White Hospital, Temple, TX                                                  Jan 2008 – Nov 2008

Role:  ETL Developer

Project Description

This project was executed to develop enterprise knowledge data warehouse which is intended to ultimately delivering the right information to the right people in the underwriting organization. System maintains claims, payments and financial information.

 

Responsibilities:

·         Documenting functional specifications and other aspects used for the development of ETL mappings

• Design, Developing and testing of the various Mappings and Mapplets, worklets and
• Optimized Performance of existing Informatica workflows.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.

 

Environment: Oracle, SQL Server, DB2, Informatica Power Center , Erwin, Cognos, XML, Windows NT/2000, Unix

 

XCEL Energy, Minnesota, MN                                                          Oct 2006 – Dec 2007

Role: ETL Developer

 

Project Description

This project was designed for integrating various Data Marts that targeted specific Business processes including Marketing, Generation, Transmission and Distribution etc. The data warehouse has been designed using Erwin adopting Star Schema methodology. Cognos was used to analyze business decisions and to build long-term strategic plans.

 

Responsibilities:

• Developed various Mappings with the collection of all Sources, Targets, and Transformations using Informatica Designer
• Extracted data from various sources across the organization (Oracle, SQL Server and Flat files ) and loading into staging area
• Created and scheduled Sessions and Batch Process based on demand, run on time, or run only once using Informatica Workflow Manager and monitoring the data loads using the Workflow Monitor           

Environment: Oracle, SQL Server, PL/SQL, Informatica Power Center, Erwin, Cognos, Windows NT/2000, UNIX