SUMMARY:

• Software professional over 15 years of IT industry experience encompassing a wide range of skill set, roles and Industry verticals.
• 15 years of strong technical experience in Dimensional Modeling, ETL architecture, design, development, testing, debugging and performance tuning in Data Warehousing environment.
• Extensive experience in using Teradata SQL Assistant, import/export utilities like BTEQ, Fast Load, Multi Load, Fast Export on Windows/UNIX and Mainframe environment and running the batch process for Teradata.
• Experience in SQL Performance Tuning by Collecting Statistics, Analyzing Explains, creating secondary Indexes, Join Index, PPI on Teradata
• I have experience in all the phases of Software Engineering Life Cycle, specializing in design, development, testing and implementation.
• Well knowledgeable with Data Warehousing, Data Modeling, Dimensional Modeling (Star and Snowflake schema), Logical and Physical data modeling involving Very Large Databases.
• I have experience in analyzing and translating business requirements to technical specifications.
• Solid knowledge of general data architecture concepts, metadata management, modeling standards and best practices for medium to large - sized complex environments.
• Expertise in Teradata, Informatica Administration, Data Modeling/Architecture, Shell Scripting, PL/SQL, ETL, Oracle, DB2, Informatica.

TECHNICAL SKILLS:

ETL Tools: Informatica (Power Center, Power Exchange),Ab Initio,Data Stage and Metadata Manager

OLAP Tools: Tableau, MicroStrategy, Business Objects and Cognos

Data Modeling Tools: ERwin, Visio

Databases: Teradata, DB2, Oracle 12g/11g/10g/9i Exadata, MS SQL Server 2005, MS Access

Languages: SQL, PL/SQL, UNIX Shell Scripting, DOS Scripting, PERL, Java, C, C++, Visual Basic, VB Script, HTML, XML, Java Script, Python

Tools: Workload Manager(WLM),Tivoli Work Scheduler, SQL Navigator, TOAD for Oracle, TOAD for DB2, MS Projects 2000, Rational ClearCase,HL7,Jenkins, Continuous Integration and Continuous Deployment (CI/CD).

Operating Systems: Windows, REDHAT Linux (Command Line; vi editor; scripting), Sun Solaris, AIX

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Senior ETL/ Teradata Lead Developer

Responsibilities:

• Develop and maintaining of scripts using Teradata utilities like Multiload (MLoad), Fastload, BTEQ, TPT and TPUMP for the new and existing data marts to feed the Data Warehouse
• Designed and developed data warehouse using Hive external tables, partitioned tables in Hive and created hive queries for analysis.
• Involved in creating end-to-end automation using UNIX shell scripts; this includes processing files to and from FTP server, executing informatica workflows to process data into staging area and then in to Teradata ware house.
• Performing the analysis of dumps generated by Teradata due to software or hardware failures.
• Designed and developed jobs to Extract and load data into Data Lake environment by using Sqoop which was accessed by business UsersReview business requirement
• Star Datawarehouse modelling
• Design
• Build new/modify ETL coding that involves Informatica mappings to extract data from different sources. UNIX scripting.
• Provide knowledge sharing to my team.

Environment: Teradata, INFORMATICA 10.2 ( Pushdown), ORACLE, UNIX SCRIPTS,Auto Scheduler, JIRA Agile Project Management.

Confidential, Richmond, VA

Senior ETL/ Teradata Consultant

Responsibilities:

• Load Monitoring
• Gather Business Requirements by collecting information from the Business Users. Conduct Business Impact Analysis.
• Used Informatica Power Center to pull data from different source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
• Worked on Informatica-Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Developed Fast load scripts to load data from host file in to Landing Zone table.
• Initial load process, we will Mload the Source file in to Teradata staging table and archive the file in to archive folder after Mload completes successfully. Fixing Production jobs abends on turn around solution within 6 hours
• Incidents Management
• Production Release related Activities
• Work Intake Process through Tivoli Service Request Manager (TSRM) Work Orders
• Other activites in EDWard Production environment such and identify performance issues on jobs and provide technical solutions suggestion to Development team on the projects plan to be migrate into Production environment.

Environment: INFORMATICA 9.6.1, TERADATA, MAIN FRAME, DB2, ORACLE, UNIX SCRIPTS,WLM Scheduler.

Confidential, Dallas, TX

Team Lead & Informatica Admin

Responsibilities:

• Architecture, Installed and Configured Databases and Informatica ETL platform for Development, QA and Production Environments.
• Snowflake Datawarehouse modelling
• ETL scripts migration from old into the new IBM UNIX AIX 6.1 servers.
• Standardize Extract Transform Load scripts, Informatica objects on the new IBM UNIX AIX 6.1.
• Install Informatica Power Center 9.x on IBM AIX 6.1 the new IBM UNIX AIX 6.1 servers.
• Upgrade Informatica Power Center 9.x with latest hot fixes /patches.
• Provided Technical/Administration Support and maintained Informatica Servers.
• Install and configure IBM Tivoli Workload Scheduler on the Linux Red Hat release 5.6.
• Migrate UNIX cron and Informatica jobs into Tivoli Workload Scheduler.
• Informatica Power Center and Tivoli Workload Scheduler setup on the new EDW servers and ensure automation of all ETL jobs on the new environments.
• Optimized Legacy ETL code by debugging and applying various performance tuning measures.
• Reviewed Business Requirements and worked with Enterprise Architects, SME's and Business Analysts and provided Technical Design Specifications.
• Designed and created Data Models, DDL's, Source to Target mapping documents and Developed Mapping Templates.
• Developed file handling and archiving scripts and integrated with the ETL process.
• Designed and Built ETL code to extract data from the Legacy Systems into EDW data warehouse.
• Design metadata tables, control tables, transaction tables for the new project.
• Built several complex ETL mappings, PL/SQL, Procedures, Shell Scripts, debugging, performance tuning and provided end to end solutions and support for very large data warehousing applications.

Project Specific Skills: Unix AIX 6.1, Linux Red Hat, INFORMATICA 9.0.1(Pushdown), MS SQL Server,ORACLE, UNIX SCRIPTS.

Confidential, Richmond, VA

Team Lead

Responsibilities:

• Study and analyze the business requirements and functional specifications in order to define the technical requirements.
• Architected and Integrated systems into a single DWH repository. Provided the best possible reporting solutions for the business needs.
• Snowflake Datawarehouse modelling
• Preparation of High & low level Design documents.
• Extensively code ETL jobs for LAB vendors HL7 files into EDWard using Unix Scripts, Informatica B2B, Teradata BTEQ Script.
• Applied various Performance Tuning techniques to expedite ETL Loading which includes Indices, Partitioning, Partition Points, Persistent Cache Lookups, Materialized Views, Parallel processing.
• Team Leader of 20 members contributed to the successful implementation of the project.

Project Specific Skills: INFORMATICA 8.1.1, TERADATA, MAIN FRAME, DB2, ORACLE, UNIX SCRIPTS.

Confidential, Los Angeles, CA

Team Lead

Responsibilities:

• Study and analyze the business requirements and functional specifications in order to define the technical requirements.
• Preparation of High & low level Design documents.
• Develop complex mappings in Informatica to extract, transform, cleanse and load data.
• Design UNIX and Perl Scripts to extract data from different sources such as flat files and Mainframe in combination with Informatica tool.
• Conduct code review and involved in testing phases and production implementation.
• Team Leader of 10 members contributed to the successful implementation of the project.

Project Specific Skills: INFORMATICA 7.1.3/8.1.1 , ORACLE 9I, MS SQL SERVER, UNIX SCRIPTS, XML.

Confidential, Manchester, New Hampshire

Team Lead

Responsibilities:

• Study and analyze the business requirements and functional specifications in order to define the technical requirements.
• Snowflake Datawarehouse modelling
• Preparation of High & low level Design documents.
• Coordinate with Data Architecture Team on modify Data warehouse model.
• Build new/modify Informatica mappings to extract data from mainframe, DB2 and perform transformation through Teradata macros and stored procedures.
• Team Leader of 8 members contributed to the successful implementation of the project.

Project Specific Skills: TERADATA, INFORMATICA 7.1.3, ORACLE 9I, MAIN FRAME, DB2, UNIX SCRIPTS.

Confidential, Seattle, WA

Team Lead

Responsibilities:

• Data extracted to flat files, transform through Ab Initio graphs into Confidential Data warehouse.
• Study and analyze the business requirements and functional specifications in order to define the technical requirements.
• Design code modules according to Confidential specifications and standards.
• Convert Informatica mappings that extract data from Oracle tables and flat files, transform data through Ab Initio Graphs then load to Teradata target tables.
• Schedule new/modify jobs using Approx Scheduler.
• Team Leader of 30 members contributed to the successful implementation of the project.

Project Specific Skills: TERADATA, INFORMATICA 7.1.3, AB INITIO, ORACLE 9I, UNIX SCRIPTS.

Confidential, Oklahoma City, OK

Team Lead

Responsibilities:

• Study and analyze the business requirements and functional specifications in order to define the technical requirements.
• Develop mappings based on business rules and cleanse data from ODS to the Data Mart.
• Coordinate with Informatica Administrator on Informatica upgrade from 6.2 to 7.1 versions.
• Team Leader of 8 members contributed to the successful implementation of the project.

Project Specific Skills: INFORMATICA 6.2/7.1, ORACLE 8I/9I, UNIX SCRIPTS.