SUMMARY

• Over 10 years of experience with Data Warehouse and BI systems at different roles like ETL developer, Analyst, ETL designer, ETL tester & team leader with good exposure to various OLAP and ETL tools.
• Over 10 years of working experience in AbInitio and Teradata delivered multiple assignments in ETL and Data warehousing using tools like Abinitio, UNIX, Oracle, Teradata SQL and having good knowledge on Banking domain.
• Expertise with most of AbInitio Components like Reformat, Joins, Roll up, Normalize, Sort, dedup, sort, datasets, lookup functions, various string functions, Partitioning components, de - Partitioning components, Database components, read multi file, XML Split and write multi file etc
• Involved in UNIX to Linux migration of the set of projects.
• Coded well-tuned SQL/Teradata scripts for warehouse instance
• Coded well-tuned Unix Korn Shell scripts, Wrapper scripts for high volume data warehouse instances.
• Involved in the migration of Mainframe code into AbInitio Graphs.
• Experience in creating ETL Mapping sheets, creating RDD (Requirements Definition Document), HLDD (High level Design document) and DDD(detailed design document) Unit testing and QA testing document.
• Experience in Complete development life (SDLC) cycle from gathering Requirements, Technical Design, Development, Testing, Implementation and Post Implementation Support
• Good knowledge in working with Relational database utilities like TOAD, SQL Assistant.
• Worked on scheduling tools like Maestro and Autosys.
• Worked on HP Quality Center to track the issues.
• Experience in Production migration and Release management Process.
• Experience in Data Integration of various data sources from databases such as Oracle, Teradata, flat files and CSV files.
• Extensive experience in analysis of Source Systems, Staging area & Target Warehouse and Data Mart systems.
• Experience in requirement analysis, client interaction, system design, development testing, documentation and implementation with extensive coding standards and state of the art technology.
• Excellent analytical and Communication Skills, Ability to work independently and good team player.
• Worked in onsite-offshore model.
• Good track record in demonstrating strong analytical and problem solving skills.
• Excellent team player.

TECHNICAL SKILLS

ETL Tools: AbInitio(GDE1.14, Co>Op 2.14),Teradata Fast Load, Multi Load, Fast Export

Database: Oracle 10g/9i/8i, Teradata

Scheduling Tools: Maestro, Autosys

Operating Systems: Unix, Linux, MS Windows XP/2003/2000/NT, MS DOS.

Concepts: OLTP, OLAP, Data Marts, Dimensional Modeling

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting (Korn)

Other Tools: Toad, Putty, Mercury Quality centre

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Check quality of software and determine its compliance to standards
• Designed, developed and implemented Ab Initio graphs, using Datasets, Partition (by Key/Expression/Range), De-partition (Gather, Merge), Transform (Filter by Expression, Reformat, Join, Dedup) and Sort (Sort, Partition by Key) and FTP components
• Involved in QA methodologies like regression testing, SIT testing and UAT support phases
• Developed the test plan and test cases to be used in testing based on business requirements
• Assisted with user testing of the system, developing and maintaining quality procedures, and ensuring business standards.
• Involved in writing the JIL scripts and implementing the same in production
• Used quality center for defect tracking
• Checking the quality of the software and determining it’s degree of compliance to standards by Quality Management and Defect Prevention activities

Confidential, Irving, TX

BI ETL Team lead

Responsibilities:

• Co-ordination and day-to-day communication of technical/business details with offshore team
• Performed cost-benefit, feasibility and impact analysis on system enhancements.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Involved in designing the data flow diagram.
• Documented the mappings used in ETL processes
• Check quality of software and determine its compliance to standards
• Creating the unix shell scripts for scheduling
• Involved in QA methodologies like regression testing, SIT testing and UAT support phases
• Developed the test plan and test cases to be used in testing based on business requirements
• Assisted with user testing of the system, developing and maintaining quality procedures, and ensuring business standards.
• Preparing the Maestro Schedules to Deploy the code into production
• Involved in writing the JIL scripts and implementing the same in production
• Used quality center for defect tracking
• Checking the quality of the software and determining it’s degree of compliance to standards by Quality Management and Defect Prevention activities

Confidential, Irving, TX

BI ETL Team lead

Responsibilities:

• Analyzing the requirement document and prepare a design document for Abinitio and Teradata components
• Perform Impact analysis and add required device id in all the required tables/views
• Developed the graphs for interfaces with required PCF and PDF scripts.
• Creating UNIX wrapper scripts
• Writing MultiLoad scripts, FastLoad and Bteq scripts for loading the data into stage tables and then process into EDW
• Involved in designing the data flow diagram.
• Documented the mappings used in ETL processes
• Check quality of software and determine its compliance to standards
• Metadata mapping from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Extensively used EME for version control management and dependency analysis
• Involved in QA methodologies like regression testing, SIT testing and UAT support phases
• Developed the test plan and test cases to be used in testing based on business requirements
• Managed the prioritization and allocation of tasks for the team of 5 associates in the US and at offshore. Conducted formal review meetings with the team to report, demonstrate, prioritize and suggest the resolution of issues.
• Extracting and transforming several Source Systems data populates CAM data warehouse
• Unit testing and Integration testing
• Maintaining review logs and defect tracking documents
• Checking the quality of the software and determining it’s degree of compliance to standards by Quality Management and Defect Prevention activities

Confidential, Irving, TX

BI ETL Team lead

Responsibilities:

• Analyzing the requirement document and prepare a design document for Abinitio and Teradata components
• Migrate existing graphs to load the data in Teradata EDW database.
• Perform SIT testing and compare the data loaded in Teradata database with the existing database
• Developed the graphs for some interfaces with required PCF and PDF scripts.
• Creating the Unix wrapper scripts
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Designed, developed and implemented Ab Initio graphs, using Datasets, Partition (by Key/Expression/Range), De-partition (Gather, Merge), Transform (Filter by Expression, Reformat, Join, Dedup) and Sort (Sort, Partition by Key) and FTP components
• Extracting and transforming several Source Systems data populates CAM data warehouse
• Unit testing and Integration testing
• Maintaining review logs and defect tracking documents
• Quality Management and Defect Prevention activities

Confidential

BI ETL Developer

Responsibilities:

• Analyzing the requirement document and prepare a design document for Abinitio and Teradata components
• Developed the graphs for some interfaces with required PCF and PDF scripts.
• Unit testing and Integration testing
• Maintaining review logs and defect tracking documents
• Development of scripts for loading the data into the base tables in EDW using Fast Load, MultiLoad and BTEQ utilities of Teradata.
• Designed, developed and implemented Ab Initio graphs, using Datasets, Partition (by Key/Expression/Range), De-partition (Gather, Merge), Transform (Filter by Expression, Reformat, Join, Dedup) and Sort (Sort, Partition by Key) and FTP components
• Quality Management and Defect Prevention activities