SUMMARY

• Over 8 years of experience in ETL, Design, Development and Implementation of Data Warehouse systems.
• Skilled in leading teams of diverse backgrounds to make sound business decisions based on analyses of short - and long-term business needs.
• Able to take a large conceptual problem or project, break it into components, establish plans and a critical path, achieve incremental goals and deliver project on time.
• Designed and Build ETL batch architecture to load data from Source System to Staging and Staging to Core EDW tables.
• Strong experience in performance tuning of Teradata SQL.
• Designed, Documented, Developed and Build Informatica Power Center Mappings and workflows using Teradata External Loaders.
• Extensively worked on Various Informatica transformations.
• Expertise in Collecting and Analyzing statistics for newly created tables and periodically colleting of existing table.
• Extensively used Teradata loader scripts (UNIX) for bulk load utilities like FastLoad, MLoad, BTEQ, TPT and performance tuning of scripts.
• Extensively worked on developing complex SQL queries for source system analysis, data analysis & data validation.
• Experience in Shell Scripting (KSh, Bourne Shell) and scheduling using Control-M and $Universe
• Expertise in understanding of Star Schema & Snowflake Schema, Fact & Dimension Tables, Physical & Logical data modeling.
• Involved in full life cycle development of Data Warehousing projects.
• Strong leadership qualities in mentoring and guiding team with Best Practices and make sure of on time delivery of project.
• Good experience on Business Intelligence tools like Business Objects, Hyperion.
• Superior communication, inter personal, presentation, strong analytical and trouble shooting skills. Great leadership quality and a versatile team player.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center, DataStage

Operating Systems: Windows, Solaris, UNIX

OLAP Tool: Business Objects, MicroStrategy, Hyperion

Databases: Teradata, Oracle(SQL, PL/SQL), Sybase, DB2, SQL Server

Teradata Utilities: BTEQ, SQL Assistant, FastLoad, MultiLoad, TPT, TDCH

Teradata tools: Teradata Administrator, Teradata SQL Assistant, ViewPoint

Scheduling tool: Control-M, $Universe

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Teradata/ETL Lead

Responsibilities:

• Responsible in the design and development of the ETL environment, processes, programs, and scripts to acquire data from source systems.
• Used Tardis framework to generate Teradata database objects and TPT scripts.
• Replicated DB2 Datamart (DM) data to Teradata using TPT scripts.
• Analyzed existing stored procedure in DB2 and translate to Teradata Stored Procedures and BTEQ scripts.
• Developed Informatica Mappings, Sessions, Workflows by analysing existing components.
• Developed TDCH jobs to move data from HIVE to Teradata.
• Did data analysis and data validation for source and target data.
• Developed Control-M jobs to schedule data plumbing from source to target.
• Performed Unit Testing & System Testing for Source to Landing Zone (LZ) to Atomic Data Store (ADS) to Data Mart (DM).
• Deployed all the objects to different environments using Stash, Source Tree, Jenkins, Perforce.
• Participated daily standup meetings with onsite managers.
• Coordinating and mentoring offshore team with daily status calls.

Confidential, Colorado Springs, CO

Teradata/Informatica Technical Lead

Responsibilities:

• Prepared detailed technical design document with regards to the business requirement.
• Involved in activities like design of high-level components, onsite & offshore team management, estimation, progress monitoring, resource planning and conducting quality reviews.
• Working as development lead in migrating from Sybase to Teradata, and involved with the team members in
• Developing efficient code
• Ensuring that the coding standards and the best practices are followed uniformly
• Performing code reviews
• Delivering of quality code
• Troubleshooting and optimizing ETL query performances
• Meeting timelines of the deliverables
• Performing end-to-end testing
• Prepared design documents, test plans and documented test results.
• Developing Teradata scripts for the migration by using Teradata Utilities like Fastload, BTEQ, and TPT, by analyzing existing Sybase scripts.
• Enhancing and developing stored procedures.
• Working on Informatica Power center in creating source to target mapping and workflows using Informatica designer and workflow manager.
• Involved in semantic layer design and development of semantic layer data model.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files.
• Developing Informatica scripts on UNIX servers, to schedule the jobs through $Universe-Scheduling tool.
• Participating in weekly status meetings and presenting the status report to the client.
• Coordinating and mentoring the offshore team.

Confidential, Plano, TX

Sr. ETL Informatica/Teradata Developer

Responsibilities:

• Created detailed technical design documents from business requirements.
• Develop Teradata SQL queries to generate ad-hoc reports for the business analysts of to implement complex business rules.
• Worked as Development Lead and is responsible for preparing ETL Design (source to target mapping documents), helping developers in developing efficient code, ensure coding standards are followed, perform code reviews, delivery of quality code, meeting the timelines for development, perform end-to-end testing and provide weekly status on projects to management.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Design, Developed scripts for loading data to target data Warehouse for BTEQ, FastLoad, and MultiLoad.
• Created Informatica mappings using Source Analyzer, Target Designer, Transformation Developer, and Mapping Designer to implement business logic from the various data source systems.
• Extensively worked on Informatica tool to integrate data using Mload connections.
• Worked on data analysis and data validation for source and target data.
• Developed integration and semantic layer according to reporting requirements.
• Implemented migrations and version controlling using Star Team revision control tool.
• Managed onsite- offshore teams and coordinated test execution across locations.
• Extensively worked on creating Migration documents and involved in migrating ETL code between different environments.

Confidential, Mountain View, CA

Sr. ETL Developer

Responsibilities:

• Interfaced with SMEs to prepare BRD documents for projects.
• Provided support to the testing and development team in innumerable issues which required lot of understanding of the EO data. Resolved many data issues that came up in the UAT and SIT and fixed the design as necessarily
• Created Adhoc reports using Teradata SQL
• Did error handling and performance tuning in Teradata queries and utilities.
• Did data reconciliation in various source systems and in Teradata.
• Designed and build Informatica Mappings, Sessions & workflows with various types of transformations like Lookup, Update Strategy, Stored Procedure, Normalizer etc to in corporate business rules \ mapping rules with batch based and Time stamp loads
• Designed, Developed, Documented and Build Teradata UNIX scripts for the FastLoad, BTEQ and MLoad Utilities to load data into Teradata tables.
• Defining and implementing Standard Operating Procedures at departmental level
• Involved in coding, Unit testing, System integration testing & UAT.
• Writing & executing test cases
• Involved in functional testing
• Involved in peer to peer-to-peer reviews.

Confidential, Hoffman Estates, IL

Teradata Developer

Responsibilities:

• Transformed businesses and Modeling rules in ETL - Specification documents with respective to subject area like Campaign, Opportunity and Leads.
• Done performance tuning of Teradata SQL.
• Design, Developing ETL technical Architecture involving process checks and error handling at various levels.
• Done data profiling of the source system to in corporate business rule and validation of data.
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Prepared the best practices, conventions and standards documents that are used by the team during their development.
• Designed, Developed, Documented and Build Teradata UNIX scripts for the FastLoad, BTEQ and MLoad Utilities to load data into Teradata tables.
• Designed the High Level ETL technical process to build Teradata scripts, Informatica mappings and Data Validation process that implement the Business logic and SLAs.
• Responsible for Code review of peers and Making sure of In corporation Best and Standard practices.
• Designed, Documented and developed Low level Design, Requirement Tractability Matrix, and Unit Test Plans.
• Designed, Documented, Developed and Build Informatica Power center Mappings and workflows using Teradata External Loaders.
• Designed and developed batch loads Jobs using Workload Scheduler based on Holiday calendar and Business calendar.

Confidential, Louisville, KY

Teradata Consultant

Responsibilities:

• Was involved right from the requirements gathering stage and helped out the KFC, Pizza Hut Taco Bell and Yum BA’s both in etching out the requirements technically.
• Conducted and participated in brainstorming sessions to finalize the design strategies for ADW and EDW.
• Prepared the source to target mapping documents design approach transformation rules documents and finally handed over the DDL to the Development team.
• Designed, Developed, Documented and Build Teradata UNIX scripts for the FastLoad, BTEQ and MLoad Utilities to load data into Teradata tables.
• Provided support to the testing and development team in innumerable issues, which required lot of understanding of the EO data. Resolved many data issues that came up in the UAT and SIT and fixed the design as necessarily.
• Involved in data model reviews with internal data architect, business analysts and business users with explanation of the data model in depth to make sure it is in line with business requirements.
• Designed, Developed, Documented and Build Teradata UNIX scripts for the FastLoad, BTEQ and MLoad Utilities to load data into Teradata tables.
• Transformed businesses and Modeling rules in ETL - Specification documents with respective to subject areas
• Created source to target mapping rules with table/column metadata and transformation rules.
• Done data profiling of the source system to in corporate business rule and validation of data.
• Create and implement procedures, and standards for the corporate data asset.
• Collected and Analyzed statistics for newly created tables and periodically colleted statistics for existing table.
• Performed Performance tuning of Teradata SQL.
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Prepared the best practices, conventions and standards documents that are used by the team during their development.