SUMMARY

• Over 8 years of overall experience in software development involving analysis, design and development of Data warehousing.
• Expertise on Data warehousing concepts, Teradata, Informatica, Oracle.
• Good experience with Teradata Fastload, Mload, BTEQ, TPT and Tpump loading from Sources to Targets.
• Extensive Knowledge in designing functional and detailed design documents for data warehouse development.
• Experienced in developingETLfor supporting Data Extraction, transformations and loading usingInformatica Power Center.
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Target Designer.
• Designed and developed complex mappings of data warehousing from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner and Update Strategy.
• Hands on experience inPerformance Tuningof sources, targets, transformations and sessions.
• Developed BTEQ’s to load the data Sources to Targets.
• Experience in writing UNIX shell scripts to call Teradata Utilities.
• Experience in documenting Design specs, Unit test plan and deployment plan.
• Good knowledge in Finance and collections part of telecom billing.
• 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.
• Excellent interpersonal and communication skills, technically competent and result - oriented with problem solving skills and ability to work independently and use sound judgment.
• Excellent Analytical & problem solving skills with attention to detail and persistence, team work and communications.
• Excellent in oral and written communication skills.
• Disciplined at following standards and Implement the Quality as per Company policy and procedure.
• Self-motivated and goal oriented, and able to operate with a sense of urgency as needed to make deadlines, can take ownership of assignments.
• Quick learner who can easily adapt to different responsibilities and technologies.

TECHNICAL SKILLS

• Informatica Power Center 8.1/8.6/ 9
• Teradata Tools & utilities like MLOAD
• TPUMP
• FAST LOAD
• FAST EXPORT
• TPT
• BTEQ
• SQL Assistant
• Teradata V2R5/V2R6/TD12/TD13
• Oracle 8.0/8i/9i
• DB2
• Micro Strategy
• Tableau
• HTML
• Java Script
• Windows 95/98/NT/2000/XP
• MS-DOS
• Unix
• C
• C++
• JAVA
• XML
• SQL
• UNIX Shell Script

PROFESSIONAL EXPERIENCE

Confidential, Greenwood Village, CO

Sr Teradata/ETL Lead/Analyst

Responsibilities:

• Active involvement in project workgroup meetings to resolve any ambiguity, incompleteness or incorrectness of requirement.
• High-level Impact analysis, business background analysis, arriving at basic assumptions and Estimation of work.
• Analysis of High Level Requirements from Project Business requirement document.
• Identified and Created new Tables, views to the existing Model and defined the different Staging Areas.
• Participation in full Software Development Life Cycle (SDLC) of data warehousing projects.
• Developed Mapplets using corresponding Source, Targets and Transformations.
• Implemented Aggregate, Filter, Join, and Expression, Java, Lookup, Sequence generator and Update Strategy, XML transformations.
• Write Extensive SQL s for data validation and requirement completion.
• Loading Data to the Teradata Data Warehouse Tables from multiple data sources using Teradata utilities Fastload, Mload, TPT, BTEQ, and Tpump.
• Involved in Data Modeling activities.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Involved in Integration and System testing.
• Work on Teradata Store procedures for batch deletes.
• Involved in Implementation and Deployment.
• Involved in writing Test Plans, Test Cases, Test Scripts and Test Queries. Also worked closely with Users and helped in accomplishing the UAT successfully.
• Extensively used the debugger in Informatica Power Center Designer to debug and fix any logical errors in the connections between the transformations in the mappings.
• Generate the reports.

Environment: Informatica Power Center 9.1, UNIX, Oracle11g, Teradata 14, Fastload, Fast export, BTEQ, Mload, Teradata SQL assistant, SQL Server.

Confidential, Thousand Oaks, CA

Sr Teradata/ETL Developer/Analyst

Responsibilities:

• Analysis of High Level Requirements from Project Business requirement document.
• High-level Impact analysis, business background analysis, arriving at basic assumptions and Estimation of work.
• Active involvement in project workgroup meetings to resolve any ambiguity, incompleteness or incorrectness of requirement.
• Identified and Created new Tables, views to the existing Model and defined the different Staging Areas.
• Write the shell scripts to call the teradata utilities.
• Participation in full Software Development Life Cycle (SDLC) of data warehousing projects.
• Loading Data to the Teradata Data Warehouse Tables from multiple data sources using Teradata utilities Fastload, Mload, TPT, BTEQ, and Tpump.
• Used Fast Export to get the data from tables.
• Developed Mapplets using corresponding Source, Targets and Transformations.
• Implemented Aggregate, Filter, Join, and Expression, Java, Lookup, Sequence generator and Update Strategy, XML transformations.
• Involved in Integration and System testing.
• Involved in Implementation and Deployment.
• Write Extensive SQL s for data validation and requirement completion.
• Utilizing Teradata Explain and Visual Explain to analyze and improve query performance. Redesigning and write new Teradata SQL for higher Performance.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Simplified the data flow by using a Router transformation to check multiple filter conditions at the same time.
• Involved in writing Test Plans, Test Cases, Test Scripts and Test Queries. Also worked closely with Users and helped in accomplishing the UAT successfully.
• Extensively used the debugger in Informatica Power Center Designer to debug and fix any logical errors in the connections between the transformations in the mappings.
• Generate the reports.

Environment: Informatica Power Center 9.1/8.6,UNIX, Oracle9i, Teradata 12, Fastload, Fast export, BTEQ, Mload, Teradata SQL assistant, Perl, PL/SQL.

Confidential, Phoenix, AZ

Teradata/ETL Developer / Module Lead

Responsibilities:

• Analysis and Understanding the ETL and Reporting requirements based on the design document
• Participated in Daily meeting with Business Units to resolve any issues/concerns.
• Preparation of High/Low level Analysis document.
• Developed mappings and workflows, BTEQ scripts.
• Teradata Fastload, Mload,Tpump and BTEQ utilities were used to loading from Sources to Targets
• Developed Mapplets using corresponding Source, Targets and Transformations.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Used Fast Export to load data from tables to flat files.
• Create UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems.
• Develop code to condition data while it is being extracted.
• Perform Unit Testing, System testing and Integration Testing.
• Performance tuning of the load process

Environment: Fastload, Fast export, BTEQ, Mload, Teradata SQL assistant, UNIX, Oracle, Teradata v2r6, Informatica Power Center 8.1,PL/SQL.

Confidential, Cincinnati, OH

Teradata/ETL Developer

Responsibilities:

• Developed mappings and workflows, BTEQ and Fastload scripts.
• Teradata Fastload, Mload and BTEQ utilities were used to load Sources data form flat files and apply business logic to load them into final target database.
• Developed and Implemented different transformation techniques for identifying slowly changing Dimensions as per technical specifications
• Developed complex mappings in Informatica Power Center to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router
• Extensively used ETL to load data from wide range of source such as flat files, oracle.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts, test cases for manual and automated testing.
• Worked actively in testing and bug fixing.
• Create reports using tableau.

Environment: Informatica Power Center 8.1, UNIX, Teradata, Fastload, Fast export, BTEQ, Mload, Teradata SQL assistant,PL/SQL,Tableau.

Confidential

Teradata/ETL Developer

Responsibilities:

• Created ftp connections, database connections for the sources and targets.
• Experience in documenting Design specs, Unit test plans and Deployment plans.
• Responsible for verification of daily loads.
• Teradata Fastload, Mload and BTEQ utilities were used to loading from Sources to Targets.
• Write Perl scripts.
• Created ftp connections, database connections for the sources and targets.
• Created workflows and work lets for designed mappings
• Implemented Variables and Parameters in the mappings
• Wrote UNIX shell scripts to automate the process.
• Involved in code review, testing and quality assurance of data
• Worked with various active & passive transformations.

Environment: Informatica Power Center, UNIX, Oracle 8i, Teradata, Fastload, Fastexport, BTEQ, Mload, Teradata SQL assistant.