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 Teradata V2R6, TD12 & TD14 with Unix Shell Scripting and Mainframe and IBM Infosphere Datastage 8.7 & 11.
• Experience in load and unload tools like FastLoad, MultiLoad, TPump and FastExport.
• Performed bulk data load to Teradata RDBMS using BTEQ, Fast load and Multi load.
• Worked on development of Teradata ETL process for extracting data from different data sources, data transformation and loading the data into data warehouse from data mart operations with Teradata V2R6, TD12 & TD14.
• Thorough grasp of Teradata RDBMS Architecture and data warehouse concepts.
• Strong working experience in planning and carrying out of Teradata system Loading Processes, Data Warehousing, Large - Scale Database Management.
• Strong knowledge on Teradata SQL .
• Good knowledge on Unix Shell scripting.
• 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.
• Experience in designing and developing complex Datastage 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.
• 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: Teradata V2R5, Teradata12 & 14, IBM Infosphere Datastage V8.7 &11, CA7, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Teradata Developer

Responsibilities:

• Worked extensively on BTEQ, MULTILOAD, Mainframe Teradata and UNIX Shell scripting.
• Responsible to get actual and planned store visit data from various source and load it to EDW tables for reporting purpose.
• Responsible to extract the EDW sales data and send it to third party vendors for Loyalty Point Calculation.
• Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
• Developed the Teradata Macros, Stored Procedures to load data into Incremental/Staging tables and then move data from staging into Base tables.
• Reviewed the SQL for missing joins & join constraints, data format issues, miss-matched aliases, casting errors.
• Responsible for Design, Data Mapping Analysis, Mapping rules .
• Responsible for Development, Coding & testing.
• Responsible for Implementation & Post Implementation support.
• Extensively used loader utilities to load flat files into Teradata RDBMS.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Performed high volume maintenance on large Teradata tables using MultiLoad loader utility.
• Used Fast Export utility to extract large volumes of data at high speed from Teradata RDBMS.
• Collected statistics periodically on tables to improve system performance.

Confidential

BI Support Analyst

Responsibilities:

• Responsible for Requirements Collection, Analysis, Design, Coding and testing.
• Responsible for the Data Mapping Analysis, Mapping rules and design.
• Responsible for Creation & Analysis of Functional/Technical Specification Documents.
• Created some test cases as a part of System Testing.
• Generated reports /scripts using Teradata BTEQ.
• Responsible for project planning and management.
• Developed scripts using Teradata utilities like MLOAD, FLOAD, fastexport, Tpump
• Preparation of test data for regression testing.
• Validating the target data with the source data.
• Initiate project weekly status meetings.
• Develop best practices, development guidelines/standard, and governance process to help to maintain a healthy and stable production environment
• Implementation and production support for the enhancements to these systems.
• Responsible for Implementation & Post Implementation support.
• Provide 24x7 on call production support on a rotation basis

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.