Madhuri Batti

ac19y8@r.postjobfree.com

715-***-****

PROFESSIONAL SUMMARY

Overall 11 years of IT experience - Teradata, Enterprise Data Warehousing, Big Data & ETL

Extensively worked on Architecture, Data Analysis, Design, Development, Implementation, Maintenance and Support on RDBMS Systems and Big Data Technologies

Strong working experience in Financial, Healthcare, Entertainment Domains/Industries

Extensively worked on Teradata 15 and load and unload utilities like MultiLoad, FastLoad, FastExport, BTEQ & TPT

Advanced and Strong working experience on SQL, Performance tuning and Query analysis

Capable of processing large sets of Structured, Semi-structured and Unstructured data and supporting systems application architecture using Hadoop Hive, MapReduce and Sqoop

Experience in Designing and Developing Informatica mappings from various transformation logics using filter, expression, rank, router, aggregator, joiner, lookup and update strategy

Strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis

Experience in building Data Marts, Data Structures, Data Storages, Data warehouses, Data Archives, and Data Analysis

Experience in Design, Enhancement, and Development of applications for OLAP and DSS - Decision Support Systems using Dimension Modelling

Good working knowledge in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling

Knowledge in creating Spotfire Dashboards and Reports

Strong working knowledge in Agile Project Management methodology

Ability to coordinate the flow of development initiatives and experience in all phases of Testing - Unit testing, System Testing, Integration Testing, Regression testing, Performance and Acceptance testing

Exceptional communication skills - Verbal and Written

Good understanding of Project Management methodologies and SDLC

Outstanding working relationship with the clients and as well effective communication with the management and within the team

AREAS OF EXPERTISE – TECHNOLOGY & TOOLS

Databases - Teradata 15, 14, 13, V2R6, V2R5

Big Data Technologies – Hadoop Hive, HDFS, MapReduce, Hue, Sqoop

Teradata Utilities - MultiLoad, FastLoad, FastExport, BTEQ, TPT

ETL Tools - Informatica PowerCenter 8.1

Reporting Tool - TIBCO Spotfire Professional and Spotfire Web player

Operating Systems - Windows 10/7/2000, Unix/Linux, WinSCP

Scripting Languages - SQL, PL/SQL, Shell Scripting

EDUCATION

Bachelor of Engineering in Electrical and Electronics - JNTU

Jun 2002 – Apr 2006

EXPERIENCE

Cognizant Technology Solutions U.S. Corporation – Senior Associate (Project Lead)

Nov 2016 - Present

Capgemini U.S. LLC (formerly IGATE Technologies) - Technical Lead

Apr 2012 – Nov 2016

Capgemini India Private Limited - Software Engineer

Aug 2009 – Mar 2012

Mahindra Satyam Computer Services Limited - Software Engineer

Jul 2006 – Jul 2009

PROJECTS

1.Project Name – Regulatory Reporting

Client : PayPal Holdings Inc – San Jose, CA

Role – Project Lead

Duration - Nov 2016 to Present

Environment - Teradata, Big Data Ecosystems – Hadoop Hive, HDFS & MapReduce, UNIX

Organization: Cognizant Technology Solutions, U.S. Corportion

Project Summary

“Regulatory reporting” is the submission of raw or summary data needed by regulators to evaluate PayPal's Financial operations and its overall health, thereby determining the status of compliance with applicable regulatory provisions. PayPal is required to develop Dynamic systems to keep themselves regulated according to the reforms across all the locations of PayPal in the World.

The main aim of the project is to transform, analyze, store Petabyte's of Transactional data and generate reports on Customers liabilities, Total Payment Volumes, Audits, Calculations using Teradata. This project also involves in migration of existing RDMS Teradata systems to Hadoop Ecosystems.

Responsibilities

Analyze and Develop Regulatory reports to schedule in a dynamic environment on large data sets with a minimum of ~50 Million transactions per day

Develop and enhance the Daily, Monthly and Quarterly regulatory reports using Teradata and Hadoop

To work on Migration of reports from Teradata to Hadoop systems and on reconciliation of the numbers

To import data using Sqoop to load data from Teradata to HDFS on regular basis

Developing Scripts and Batch Job to schedule various Hadoop Program

To write Hive queries for Data Analysis for ad-hoc querying

To analyze large data sets to determine optimal way to aggregate for reporting needs

To create HBase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX and Teradata

To manage and review Hadoop log files

To test raw data and execute performance scripts

Support code/design analysis, strategy development and project planning

Create and export Regulatory reports using Hive

Involve in creating tables, partitioning, bucketing of table in Hive

Review, evaluate and implement process improvements, as appropriate

To work and co-ordinate with the teams in offshore during the migration of reports

To work with Management & Operations Teams, and other departments on various requirements across the globe to gather the necessary information and data needed to produce the report

Produce the data required for ad-hoc requests on external audits and regulatory examinations

Good Overview and understanding of PayPal's operations, products and process flows in terms of balances, Payments, Deposits, Withdrawals etc.

2.Project Name - My Orders Reporting

Client : GE Healthcare – Milwaukee, WI

Role - Sr. Teradata Developer

Duration - Jan 2016 to Nov 2016

Environment - Teradata, Informatica, Cronacle and Spotfire

Organization: Capgemini U.S. LLC

Project Summary

My Orders Reporting Project mainly deals with all the backlog orders (eOM and OM data) from different source systems and shows data in different variances like Business benefits, SFDC, POD, KPIs and Graphical Analysis. It has different users across the globe which involves the reporting part in both OBIEE and Spotfire.

Responsibilities

Worked as an Onsite Coordinator - Interacting with the Business users on gathering the requirements Implemented the CRQ’s by analyzing the specifications provided by the clients

Designed and developed Informatica mappings, BTEQs (Teradata Utilities) and Job Chains using Cronacle to maintain optimal performance

Actively involved in development and testing phases like Unit Testing, System Testing, Regression Testing, UAT Support for providing Quality and Defect free code

Conducted code walkthroughs and review peer code and documentation

Worked with Junior/Senior developers, DBAs, and systems support personnel in elevating and automating successful code to Production

Involved in creating dashboards for the reporting standpoint

Involved in anticipating the customer’s needs and Coordinating with the Architects and the team to meet the deliverables on time

3.Project Name - Global ServiceShop

Client : GE Healthcare – Milwaukee, WI

Role - Data Analyst

Duration - Jul 2015 to Dec 2015

Environment - Hybris

Organization: IGATE Technologies

Project Summary

Global Service shop for GE Healthcare is an ecommerce project which was developed for marketing the GE Healthcare products online. The Service shop was made available online in USA, Canada, UK, France, Saudi, Australia, Germany, India and New Zealand regions.

Responsibilities

Involved with the Business and regional teams to understand the data request/requirements

Analyzed the data and ensure that the data shared is not deviating from the existing Global Catalog Structure

Primarily involved in developing the data files and was responsible for the smooth data loading process to Stage and Production environments

Responsible for all phases of testing in different environments

Maintain the Data Masters for the complete project for all the regions

4.Project Name - Global Service Visibility

Client : GE Healthcare – Milwaukee, WI

Role - Technical Lead

Duration - Apr 2012 to Jun 2016

Environment - Teradata, Informatica, Cronacle, UNIX & OBIEE, AWS (EC2)

Organization: IGATE Technologies

Project Summary

Global Service Visibility Project mainly dealt with all the closed service requests from different regions like CARES, CAPS, MUSIC, Siebel Intl, USCAN and Siebel Americas. Data is viewed in different angles at the system level and at the part level and the costs involved in different service requests.

Responsibilities

Involved in interacting with the Business users on gathering the requirements during the backlog/grooming sessions

Implemented complex transformations by creating custom transformations in addition to using built-in ones

Excellent experience in creating and managing Database users, Schemas, Roles, Tables views and Projections

Involved in providing the Optimal ETL Solution to extract and load the data from different source system to EDW

Strong working experience in Design of scalable, reusable, and minimal maintenance of ETL templates

Coordinated with the Technical architects and within the team to meet the deliverables on time and was responsible to handle and fix the issues in Stabilization period

Involved in development and testing phases including Coding, Unit Testing, UAT Support for providing Quality and Defect free code

Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures

Responsible for all phases of Testing in different environments

Prepared the Support document and Transition the project to the Support team

To propose the new optimized solutions to make the data available for NRT reporting

5.Project Name - MARVIN

Client : Warner Bros. Entertainment Inc – Bangalore, India

Role - Software engineer

Duration - Mar 2010 to till date

Environment - Teradata, Informatica and Business Objects

Organization: Capgemini India Pvt. Ltd

Project Summary

Warner Bros. Entertainment Inc is a Time Warner Company. It is a leading studio that produces and distributes entertainment content such as movies, home entertainment products, games and related products. Warner Home Video, as known in the US (also known as Warner Home Entertainment Internationally) is the business unit that manages the supply chain and associated logistics for the manufacturing, marketing and accounting of various lines of business including Video Sales, Games Distribution and Video on Demand (Electronic Sell Thru- EST).

MARVIN stands for Master Repository for Video Intelligence. Marvin is mainly needed to deal with data with respect to Video which in turn deals with Home video sales, Video rights sold to a channel, profits obtained from it etc. It also deals with video games industry like selling XBOX machines, revenue obtained from internet game download etc. It also deals in internal data i.e. amounts due from a dealer, cost involved in creation of video /video games software, manufacturing DVDs etc.

Responsibilities

Involved in developing a new module for APAC region using Teradata BTEQ’s

Implemented the CRQ’s by analyzing the specifications provided by the clients

Provided tech team support and was on-call coordinator for the project

Primarily involved in monitoring the Teradata jobs that were scheduled through ORSYP and made sure the loads were completed on time

To fix the scheduled jobs on failure, and to re-run the failed jobs through Unix environment

Ensured the compliance of Quality procedures related to the project

6.Project Name - CATEGORY MANAGEMENT

Client : Warner Bros – Bangalore, India

Role - Software Engineer

Duration - Aug 2009 to Feb 2010

Environment - Teradata, Informatica and MicroStrategy

Organization: Capgemini India Pvt. Ltd

Project Summary

Category Management is a service which is provided to selective retailers who plan to achieve their target and measure their effectiveness in the market. This objective was accomplished by standard dashboards which are generated in comparison with the industry data. The Industry data was purchased by WHE from external agencies such as AC Nielsen, GFK, OCC, NPD etc. This service was offered in Video industry, games industry and hardware industry. Planogram is also another service provided to the retailers. This helps in providing schematic layout to retailers about how to place various products on retailer store shelf.

Responsibilities

Implemented the CRQ’s by analyzing the specifications provided by the clients

Primarily involved in monitoring the Teradata jobs that were scheduled through ORSYP and made sure the loads were completed on time

To fix the scheduled jobs on failure

Ensured the compliance of Quality procedures related to the project

7.Project Name - CORE BANKING INDONESIA

Client : DBS Bank – The Development Bank of Singapore Limited - Bangalore, India

Role - Software Engineer

Duration - Nov 2008 to Mar 2009

Environment - Teradata SQL, Teradata, Teradata utilities and Informatica

Organization: Mahindra Satyam

Project Summary

DBS is the largest bank in Singapore as measured by assets and a leading bank in Hong Kong, providing the full range of services in corporate, SME, consumer and wholesale banking activities across Asia and the Middle East. IDM (Integrated Data Mart) is designed to capture regional reporting requirements for Business Analytics supporting OLAP features.

Responsibilities

Analyzed of the specifications provided by the clients

Developed scripts using TERADATA BTEQ

Created the detailed design document

Validated the data by using Unit testing

Ensured the compliance of Quality procedures related to the project

8.Project Name - TELSTRA

Client : Telstra – Australia

Role - Software Engineer

Duration - Oct 2007 to Sep 2008

Environment - Teradata V2R5, Linux Putty, Teradata Utilities, Data stage, Windows XP, 2003 Server, UNIX

Organization: Mahindra Satyam

Project Summary

The project was basically a transformation of the existing data warehouse into a new architecture. I was involved in the data out system testing and system integration testing team and was primarily responsible for running the shell scripts and checking the jobs.

Responsibilities

Involved in monitoring the workflows, re-running jobs on failure, updating the data and fixing the bugs

Validated the status of the jobs

Analyzed the root cause for failures

Handled jobs on failure and then scheduled the jobs

Ensured the compliance of Quality procedures related to the project

9.Project Name - SCB-Enterprise Data warehouse

Client : Siam Commercial Bank, Bangkok - Bangalore, India

Role - Software Engineer

Duration - Jan 2007 to Aug 2007

Environment - Teradata V2R5, Windows XP, ODI (Sunopsis)

Organization: Mahindra Satyam

Project Summary

This project was aimed at developing Enterprise data warehouse for SIAM COMMERCIAL BANK by replacing their existing data warehouse with EDW. The whole delivery was divided into three releases along with it the entire system was divided into different source systems. For this activity, Sunopsis was used as the front-end tool and Teradata as Database.

Responsibilities

Analyzed the specifications provided by the clients

Developed Interfaces using Sunopsis

Prepared Business Rules for the developed interfaces

Documented the developed interfaces

CERTIFICATIONS

Teradata Basics V2R5 [ NCR Certification ]

Teradata SQL V2R5 [ NCR Certification ]

Contact this candidate