QA Analyst , OpenVMS Developer

Madhumitha Badhri

Profile

>Four and half years of IT industry experience in development and production support using

>Datastage (ETL Tool) and Teradata utilities with emphasis on Data Warehousing.

>Strong working experience in development, testing and maintenance of application with support of Data Transformations & Data Loading with ETL tool – Data Stage which involves Repository Creation, Creating Mappings, Sessions, and Scheduling the workflow.

>Good domain knowledge on Banking, Retail and Health Care functionalities.

>Strong analytical and problem-solving skills.

>Excellent Team player with good oral and written communication, presentation and interpersonal skills.

>Involved in providing company-wide technical and functional training activities.

Skill Set

RDBMS:

Teradata V2R5, V2R6, TD12, Oracle 8.1, 10g, DB2

Languages:

Unix Shell script, SQL, SQL plus, C, C++, Java, .Net

O/S:

Windows NT/2000, SCO UNIX, LINUX

ETL Tools:

DataStage (Both server jobs and parallel extender) 7.5.x,8.0, 8.1, Teradata utilities - FastLoad, MultiLoad, SQL Assistant, BTEQ Export/Import facility

Training

Data Stage Essentials V8.0(DX444)

Informatica Power center

Education

Bachelor of Engineering in Computer Science - 2006, Anna University (Chennai), India.

Professional Experience

Feb 10 – Till date, Data Specialist – ETL Datastage IBM Global Services, Hyderabad, India

Environment: IBM Datastage 7.5.1, Teradata V8.0, Autosys Scheduler, UNIX

Team Size: 8 to 12

The project is for the client Bank Of America, USA. The project involves monitoring and supporting the existing system which has jobs running in IIS Datastage 7.5.1 parallel extender. Help maintain the data in Teradata Database for the 3 important domains of the bank – customer, deposit and cards.

>Responsible for monitoring the jobs done in Datastage and handling the production issues.

>Fixing issues that occur on day-to-day basis and in maintaining the system.

>Maintaining internal trackers and dashboard that has the reports on the daily job runs.

>Responsible for effective communication between the project team and the customer.

>Review various documents with the new production changes.

>Track the changes that happen in the production during each releases and maintain them in Bank Of America Sharepoint.

Aug 08 – Feb 10, Technology Associate, Infosys Technologies Limited, Chennai, India

Environment: IBM Datastage 7.5.1, Oracle 10g, UNIX, IBM TX, .Net

Team Size: 9

The project is for the client Ameri Health Merci Family of Companies, USA in health care domain. The project involves end-to-end analysis of the existing system and automation of the manual validation process. The data to process comes in as a file which is mapped to the target database using IBM TX. This mapped data is validated using IBM Datastage 7.5.1 server jobs. The incoming data is Post-Adjudicated Data for claims which are validated against the rules set by standard agency (Health Insurance Portability and Accountability Act (1996)). The valid claims are then identified and stored in the database for further downstream applications.

>Responsible for leading a project team in delivering solution to our customer in Healthcare sector.

>Creating high-level design based on business requirements and Deliver new and complex high quality solutions to clients

>Responsible for managing scope, planning, tracking, change control, aspects of the project.

>Responsible for effective communication between the project team and the customer.

>Provide day to day direction to the project team and regular project status to the customer.

>Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing.

>Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goal.

Jul 07 – Aug 08, Module Lead, Infosys Technologies Limited, Chennai, India

Environment: IBM Datastage 7.5.1, Teradata (Bteq script), UNIX, ControlM Scheduler and Java

Team Size: 5

The project is for the client Limited Brands, USA in Retail domain. The project involves understanding the existing system and maintenance of the jobs scheduled by ControlM scheduler. The maintenance involves analysis of the fact and the dimension tables, and understanding the data that gets loaded from source to target. Balancing is done after each load and verified if all the data in the source is loaded to the target. Towards the end of the project, Express got disengaged from Limited Brands and a new system had to be built for Express which involved complete Knowledge transfer on the system maintenance to the client.

>Responsible for maintaining data that involves the sales details of Limited and Express Brands.

>Understanding the scheduling process of ControlM jobs.

>Fixing issues and maintaining the system. Creating an internal tool (Data Comparison) to maintain the balancing of the target data with the source data.

>Enhancing the code (Bteq scripts and Datastage Jobs) for better performance.

>Using an internal tool (IPSP) that maintains the bug fixing details on a daily basis.

>Maintaining Dashboard and developing monthly custom reports for the issues resolved and SLA adherence.

>Gave presentation to Express Brands clients on the maintenance of the existing system.

Achievement: Received a Special Recognition Award from client for excellent management of the module and for maintaining and tracking the incidents using the internal tool – IPSP.

Dec 06 – Jul 07, Software Engineer, Infosys Technologies Limited, Chennai, India

Environment: IBM Datastage 7.5.1, Teradata (Bteq script), UNIX, ControlM Scheduler and Java

Team Size: 12

The project is for the client Hallmark Cards, USA in Retail domain. The project involves creation of a new system to maintain the store related details for Hallmark Cards. The data from input is transformed using Datastage jobs and stored in the Data warehouse. The input to the Datastage comes as IDoc from SAP and the data is processed and stored in the database.

>Responsible for maintaining jobs for Extraction, transformation and loading were performed using Datastage 7.1 parallel extender to build the data warehouse.

>Extensively used Datastage Designer to create and manipulate source and target definitions, mappings, transformations, re-usable transformations.

>Worked on various processing stages such as Transformer stage, Aggregator stage, Lookup stage, Remove-Duplicate stage, Sort stage, Filter stage, Sequence Generator stage, Join stage, etc.

>Developed Datastage mappings for Slowly Changing Dimensions.

>Created Containers for reusable business rules.

>Created tool to validate the Jobs created in Datastage.

References: Available upon request

Contact this candidate