SUMMARY:

• Around 9 years of experiences with multiple roles in Data Warehouse Design/Architecture;
• Analysis & Development of relational database and ETL applications( Teradata, DataStage &
• Informatica), Business Requirements, Performance Tuning, Production Support
• Expertise on Data warehousing concepts, Teradata, Datastage and Informatica..
• Have worked on Teradata utilities namely Bteq, Fast load, Multi load, Fast export, Arcmain & Pack disk.
• Have good knowledge on Teradata Physical Implementation & Basic knowledge on Teradata DBA.
• Expert in Data Stage PX installation/Upgrading & setting up configuration file on UNIX.
• Have good Knowledge on project related application Installation.
• Expertise in Problem solving and Tracking Bugs.
• Expert in Scheduling tool WLM(work Load manager)
• Extensively used ETL methodology for Designing jobs that extract, integrate, aggregate, transform data Create, manage, and reuse metadata and run, monitor, and schedule jobs using DataStage.
• Experience in integration of various data sources from Databases like Teradata, Oracle, SQL Server,
• DB2 and formats like flat - files, CSV files, COBOL files and XML files.
• Experienced in using various Informatica Power Center Designer Tools like Source Analyzer,
• Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Excellent knowledge and experience in documents like BSD,TSD & Mapping documents.
• Experience in documenting Design specs, Unit test plan and deployment plan.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations
• Regularly evaluate processes and make recommendations to improve efficiency.
• Attend and participate in meetings that pertain to assigned responsibilities.
• Provide support outside normal business hours as required.
• Since last 3+ years I am working at client in USA & handling responsibilities of onshore-offshore model Delivery along with client communication that involves frequent dialogue with Technical
• Directors,Technical Architects, DBA's release team and Project Managers.

TECHNICAL PROFICIENCY:

Major Strong Skills: Teradata, Data stage,Informatica & UNIX

Operating Systems: Unix & Windows

Tools: Putty, File Zilla, Contol-M, Clear case, PVCS &Work Load Manager

Technical consultant

Tools: & Technology: Teradata, Informatica 9.1, UNIX & Clear case

Confidential, Richmond, VA

Responsibilities:-

• Gathering Requirement from Client and perform the detailed analysis

• Translating Business specifications in to Technical specification documents.
• Design and development of ETL process for loading the Eward tables.
• Apply all the business logics using BTEQ.
• Resolve the issue for history data & apply the necessary changes to Incremental scripts.
• Schedule the job using WLM.
• Co-coordinating with various teams such as Data modeler, Release, WLM, Production-Control,

Technical consultant

Tools: & Technology:

Teradata, Informatica 9.1, UNIX & Build Forge

Confidential, Minneapolis, MN

Responsibilities:

• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

• Responsible for effective communication between the project teams and the customer. Provide day to day direction to the project teams.
• Involved in writing the ETL specifications and unit test plans for the mappings.
• Design and development of ETL process extracting Member, pharmacy and provider from IDW and send files to Inovalon for generating analytic report.
• Automated the jobs thru scheduling using Main Frames scheduler i.e CA7, which runs every day by maintaining the data validations.
• Effectively worked with supporting groups data architect, DBA, Infa Admin, Testing team, Scheduling team and production control team
• Have developed a level of competency, which helps to anticipate issues and solve them in advance.

Technical consultant

Tools: & Technology:

Teradata, Informatica 9.1, UNIX & Build Forge

Confidential, Minneapolis, MN

Responsibilities:

• Gathering the project requirements & convert business requirement in to technical specification.

• Develop mappings to extract & load the data using Informatica.
• Analyze the existing grouper software & decommission with new windows grouper software without affecting the current process.
• Extract claims from claim related tables & subjected in to Grouper software to generate 5 versions for each claims.
• Implemented Aggregate, Filter, UNION, Router, Expression, Lookup, Sequence generator and transformations
• Involved in writing the ETL specifications and unit test plans for the mappings
• Provided required support in Multiple (SIT, UAT & PROD) stages of the project.
• Effectively worked with supporting groups data architect, DBA, Infa Admin, Testing team, Scheduling team and production control team
• Project delivery management - Single point of contact from onsite for deliverables/issues. Coordinating between onsite and offshore to ensure smooth and timely delivery
• Have developed a level of competency, which helps to anticipate issues and solve them in advance.
• Promote the code in to higher environment using Build forge & Clear case.
• Support Testing & Business acceptance team for the testing.

Technical consultant

Tools: & Technology:

Teradata,Informatica9.1,SQL-SERVER, Bteq, Fast export, Informatica9.1,SSIS package & WLM

Confidential, Richmond, VA

Responsibilities:

• Leading a team consisting of 8 members.

• Working with client to gather the requirement & distribute the work within the team.
• Build a BTEQ script to extract the data from Enterprise Data warehouse
• Design and development of ETL process loading the RHI data from EDW and Non EDW
• Apply all the business logics using BTEQ & Extract Data using Fast export script.
• Load History data using SSIS Package & Incremental data using Informatica.
• Creating validation and loading the rejected records into the relevant tables and revert it to the clients.
• Schedule the job using WLM.
• Used Informatica Manager for import & Export workflow from/ to repository.

Technical consultant

Tools: & Technology: Teradata, Informatica 9.1, UNIX & Build Forge

Responsibilities:

• Extract Flat files into Staging Area using Fast Load

• Performing necessary Data Cleansing, Formatting and Transformations using DataStage Server edition
• Load Data from Staging Area into Data warehouse using Bteq
• Perform Unit Testing & Bug Fixing.