SUMMARY

• IT Professional with extensive experience in various challenging development projects, requirement gathering, requirement analysis and application testing of several critical applications in Retail Domain.
• Strong experience working in IBM Infosphere Datastage 8.7 & 11, Teradata V2R6 & TD12 with Unix Shell Scripting and Mainframe.
• Hands on experience in Designing Datastage Parallel jobs, Job Sequencers, Batch jobs etc. for more than 5 years.
• Experience in Designing and Building Enterprise Data Warehouses/Data Marts with Extraction Transformation and Loading (ETL) processes using IBM InfoSphere Data Stage 11.5/8.7 version.
• Worked on development of Data Stage ETL process for extracting data from different data sources, data transformation and loading the data into data warehouse from data mart operations.
• Experience in designing and developing complex jobs involving complex transformation logic based on business requirements using various Data Stage Component as Copy, Aggregator, Filter, Funnel, Join, Lookup, Merge, Change Capture, Transformer, Remove duplicates, Pivot, Datasets, Sequential file, Complex Flat Files (CFF), XML, IDOC Extract, Load etc.
• Good knowledge on Unix Shell scripting.
• Hands on experience in Teradata Utilities like Bteq, Fastexport, Multiload, Fastload etc. 6 years.
• Extensively experienced in Root Cause Analysis, Scheduling and planning of work and Status reporting.
• Strength lies in analyzing the technical feasibility, meeting tight schedule and adhering to quality.
• Strong experience working in Data warehousing & Business Intelligence, ETL.

TECHNICAL SKILLS

Computer System: Windows, UNIX

Programming Languages: Teradata Utilities, SQL, Unix shell script

Special Software/Tools: IBM Infosphere Datastage V8.7 &11, Teradata V2R5, Teradata12, CA7, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

ETL DataStage Developer

Responsibilities:

• Analyzed the source and the target systems to aid the design of the Operational Data Warehouse.
• Participated in the high - level design of the ETL system and mapping of business rules.
• Interact with business teams to understand requirements and propose and implement solutions.
• Conducted performance analysis and optimized the ETL jobs performance.
• Support customers on complex technical issues including problems related to Middleware.
• Respond to requests and inquiries from clients within the pre-determined time frame of our service level agreement.
• Investigate and resolve problems related to Teradata and DataStage issues.
• Supported various Teradata utilities like Bteq, Fastload, Multiload and FastExport.
• Extensive experience with Extraction, Transformation, Loading (ETL) process using TERADARTA UTILITIES and IBM INFOSPHERE DATASTAGE V 8.7/11.5.
• Developed Jobs using different stages like Copy, Modify, Aggregator, Filter, Funnel, Join, Lookup, Merge, Pivot, Datasets, Sequential files and Transformer etc.
• Added DataStage Environmental Variables at the Project Level for better performance.
• Worked on DataStage admin activities like creating ODBC connections to various Data sources, Server Start up and shut down, Creating Environmental Variables, Dsparams File.
• Worked with Database Admins to setup and create connection to Teradata / Oracle / SQL Server Database with Datastage.
• Designed Datastage Parallel jobs, Job Sequencers, Batch jobs and Testing of jobs.
• Experienced in scheduling and running jobs using DS Director & Unix scripting.

Confidential

DataStge Developer

Responsibilities:

• Understanding the existing process, Analyzing the business requirement, Construction & Unit Testing, Causal Analysis of the Defects, Defect prevention.
• Understanding the client requirement from business requirement document.
• Construction.
• Preparation Test Plans.
• Developed DataStage jobs to load the data into tables using Multi- load, T-Pump and fast load utilities to load data into Teradata Base tables.
• Responsible for Performance tuning of DataStage jobs with proper DataStage partitioning techniques and Node configuration and also Teradata Scripts.
• Developed the DataStage Jobs to read data from Legacy Systems and provide flat files in the SAP required format.
• Used IDOC Extarct to extract data from SAP claim processing system and designed ETL programs to load data to the Target reporting databases
• Used Complex Flat Files (CFF) stage to extract Customer data from (CIF) Mainframe files (EBCDIC).
• Worked on Microsoft Visio to create the diagrams/flow charts for ETL source-target flow.
• Responsible for the Production On call Support.

Confidential

BI Support Analyst

Responsibilities:

• Production Support, Client Communication, Bug Fixing, Documentation
• Support customers on complex technical issues including problems related to Application Maintenance.
• Developed Data Migration jobs to load data from flat files into Oracle database using Data Stage 8.5.
• Used the Data Stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data Warehouse.
• Designing and developing Master controlling sequencer jobs using the Data Stage Job Sequencer.
• Developed Jobs using different stages like Copy, Modify, Aggregator, Filter, Funnel, Join, Lookup, Merge, Pivot, Datasets, Sequential files and Transformer etc.
• Ongoing support management and scheduling of the data extraction, loading, validation, transformation and publishing processes.
• Implementing performance-tuning techniques along various stages of the ETL process.
• Developed with standards for new Data Stage Jobs and fixing production issues.
• Used the Data Stage Director for Monitoring the Issues.
• Worked with DBA team for better production support and performance.
• Respond to requests and inquiries from clients within the pre-determined timeframe of our service level agreement.
• Improve documentation of support policies and procedures.
• Provided technical support training to other team members.

Confidential

Data Warehouse Developer

Responsibilities:

• Understanding the existing process, Analyzing the business requirement, Preparing System and Detail Design document, Coding, Preparation of Unit Test Plans and Integration Test Plans, Testing of modules, Causal Analysis of the Defects, Defect prevention and causal analysis activities.
• Analyzing the business requirement for new market
• Preparing System and Detail Design document
• Coding.
• Load the data into tables using Multi- load, T-Pump and fast load utilities to load data into Teradata Base tables.
• Preparation of Unit Test Plans and Integration Test Plans
• Causal Analysis of the Defects.
• Defect prevention and causal analysis activities.

Confidential

Data Warehouse Developer

Responsibilities:

• Understanding the existing process, Analyzing the business requirement, Preparing System and Detail Design document, Coding, Preparation of Unit Test Plans and Integration Test Plans, Testing of modules, Causal Analysis of the Defects, Defect prevention and causal analysis activities.
• Understanding the existing process
• Analyzing the business requirement for new market
• Preparing System and Detail Design document
• Coding
• Preparation of Unit Test Plans and Integration Test Plans
• Causal Analysis of the Defects.
• Defect prevention and causal analysis activities.

Confidential

Data Warehouse Developer

Responsibilities:

• Requirement Analysis, Design, Construction, Unit Testing, Code Review, Defect Fixing
• Analyzing the business requirement for new market
• Preparing System and Detail Design document
• Coding
• Preparation of Unit Test Plans and Integration Test Plans
• Causal Analysis of the Defects.
• Defect prevention and causal analysis activities.

Confidential

Trainee

Responsibilities:

• Understanding Software industry work culture and etiquettes, Software Development Lifecycle.
• Understanding each stages of Software Development Lifecycle. Overview of both procedural and object oriented approach of programming using Dr Java. Designing of DFDs and ERDs for the same above mentioned project.
• Learning the basics of Relational Database Management System.
• Completed the courses on various soft-skills viz., technical documentation, Client Communication, Corporate ethics, Industrial Etiquettes.
• Developed software called Library Management System using Dr Java.
• Undergone trainings in Confidential specific soft-skill courses.