SUMMARY:

• Progressive software professional with over 9 years of experience in Leading Software development, ETL Architecture, Data Modelling, System analysis, Testing and Quality Assurance, Configuration Management, Production Support, with proficiency in in analyzing and translating business requirements into technical requirements. Successfully delivered multiple Enterprise Data Warehouse projects with aggressive development schedules by effectively leading and by making appropriate risk assessment.
• Data integration expertise in developing ETL mappings using Informatica PowerCenter 9.x/ 8.x from disparate Data sources like flat files, WSDL, VSAM and XML files.
• Extensively worked with XML files as the Source and Target, used transformations like XML Generator, XML Parser, Web services consumer and HTTP transformation.
• Expertise in Performance Tuning of data flow processes (ETL mappings) and loading high volumes of data on daily basis into data warehouse in a given load window using Informatica Partitioning and Pushdown Optimization.
• Experience in Incremental Aggregation, Dynamic Lookups, Transaction Control and Constraint Based Loading, Target Load Plan, Partitioning, Persistent Caching.
• Experience with design and development of Data Warehousing applications in Telecom and Insurance Domains, use of Teradata CLDM model.
• Utilized knowledge of functional and Technical experience in Teradata and other leading - edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Strong knowledge of Teradata versions from V2R5 to V15 and utilities including Multi Load, Fast Load, Fast Export, BTEQ, TPT and Archive & Restores using ARCMAIN utility.
• Applied skills in application development using OLAP functions, stored procedures, macros, triggers, Recursive queries, referential integrity and compression analysis for space recovery.
• Expertise in Database design, Physical Data Modeling and Performance Tuning of Teradata SQL by identifying bottlenecks through Viewpoint and dissecting explain plans using PPI Concepts, De-normalization and Join Index.
• Expertise in Developing complex SQL queries (Joins, sub queries, aggregations etc.) using Oracle 11g for data analysis and validate data that was populated by ETL applications.
• Experience in providing the solutions for the design and implementation of ad hoc and standard BI reports in MicroStrategy.
• Expertise in design and implementation of SCD - slowly changing dimensions’ types (1, 2 and 3).
• Experience in writing Perl Scripts for file transfers, job scheduling and error handling.
• Experience in mainframe technologies specifically with COBOL, JCL, DB2 and Netezza.
• Experience in Agile methodology for application development.

CORE COMPETENCIES:

• Enterprise Data Integration
• Teradata, IBM DB2, Oracle, Netezza
• Teradata 12 Certified Technical Specialist
• Extraction, Transformation, and Loading (ETL) Architecture
• Informatica PowerCenter MicroStrategy
• Teradata 12 SQL Certified
• Systems and Requirements Analysis
• ERWIN, Visio
• Teradata 12 Certified Professional
• Data Analysis, Database Design, and Data Modeling
• Maestro, ESP, Control - M
• IBM DB2 Certified (703) Application Developer
• IT concepts, strategies and methodologies
• SQL, Easytrieve, JCL, COBOL, Perl, Ruby
• IBM Certified Database Associate
• Documentation and Effective Communication skills, Ability to work independently and as part of a team
• Teradata SQL Assistant, Administrator, Viewpoint, Manager, MLOAD, FASTLOAD, FASTEXPORT, BTEQ, ARCMAIN, TPT troubleshooting and creative problem solving skills
• WS-FTP, BMC DB2 Utilities, TSO/ISPF, Connect: Direct, File-Aid, SPUFI, JRuby, Harvest Version control tool and MS Office

PROFESSIONAL EXPERIENCE:

ETL Lead

Confidential, Columbus, Ohio

Responsibilities:

• As a Technical ETL Lead Implemented Enterprise Data Warehouse for Direct Sales Reporting Program., responsible to oversee 11 data warehouse projects to integrate 50 distinct data sources to create 5 distinct subject areas (EParty, EProduct, EClaims, EDistribution, and EInteractions) with 8000 data attributes and 600 metrics.
• Worked with Business Analysts in translating business requirements into Functional Requirements Document and to Detailed Design Documents and preparation of various technical documentations including low level design specifications, test plan and cases, deployment plan.
• Extensively used Informatica Pushdown from loading Stage tables to Foundation tables.
• Developed complex mappings using multiple sources and xml files, transformations and targets from different databases like Teradata, Oracle, Netezza and flat files.
• Optimized Query Performance, Session Performance and Reliability.
• Wrote complex SQL queries for data analysis, validate data that was populated by ETL applications.
• Designed mappings for implementing SCD type 2.
• Implemented parallelism in loads using Pass-through partitions for huge source files.
• Effectively written Complex SQL queries to use the minimum spool space and resources.
• Worked on Ruby and also implemented ATDD, TDD approaches in direct project using Agile Software Development Methodology.

Environment: Informatica 9.5, Ruby, Cucumber, Teradata, ESP, Oracle 11g, Netezza, Linux, Perl, MicroStrategy

Confidential

Responsibilities:

• Implemented Enterprise Affinity Solution Enablement ( Confidential ) to build a three-way relationship between Nationwide, Affinity Group and Affinity Group Members. With Affinity Solutions, Nationwide entered into new affinity partnerships that introduced over 4 million group members to its product and services.
• Worked as Tech Lead to offshore and onsite Developers on the Requirements, Design and Development of existing projects.
• Coordinated the work requests between clients and development team members.
• Assisted development & testing team in complex SQL queries and performance tuning of the large and complex queries.
• Written Bteq scripts extensively with Overlap and Moving Window Functions to load data from staging into target database.
• Worked on Multiload, Fastload, FastExport, TPT utilities to Load and unload data to and from the Teradata database.
• Used Informatica client tools such as Informatica Power Center, Workflow Manager, and Workflow Monitor etc. The objective is to extract data from source systems like Oracle, flat files, salesforce application into a staging database and then load into single data warehouse.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Sorter, Aggregator, Joiner, Router, Lookup (Connected and Unconnected), Filter, Update Strategy, Sequence Generator, Normalizer and Rank.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Control).
• Developed shell scripts for Daily and monthly Loads and scheduled jobs using UNIX and ESP.
• Transitioned changes to Run/Support team for each Production release and provide initial problem troubleshooting and resolution for Production Failures.

Environment: Informatica 9.5, Teradata, Oracle 11g, Netezza, Ruby, Cucumber, ESP, UNIX, MicroStrategy

Confidential

Responsibilities:

• Implemented integration of Confidential data with existing Allied and Nationwide Policy, Claims and Agent data into eProduct Data warehouse.
• Extensively used Informatica to load data Confidential Policy and Claims XML files to Teradata.
• Worked closely with the Data modelers and DBA team for data mappings and database design to comply with Standards for corporate databases.
• Worked closely with testing and BA teams for identifying the testing strategies, to resolve Teradata technical issues and defect resolutions.
• Created ETL jobs using Informatica, SQL and PL/SQL to load integrated data in data warehouse with various source system files.
• Designed complex mappings for date chaining and deduping before loading the data into target database.
• Implemented parallelism in loads by partitioning workflows
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Developed Teradata Recursive Queries to load the hierarchy relations to the database.
• Used Teradata View Point to monitor and tune SQLs and reduce the skew the identified.

Environment: Informatica 9.5, Ruby, Cucumber, Teradata, Maestro, Oracle 11g, Netezza, Linux, Perl, MicroStrategy

Onshore Lead

Confidential, New Jersey, NJ

Responsibilities:

• Provided technical Lead /guidance to the team in MVS, Informatica, Teradata and DB2 areas.
• Being Advisory Subject Matter Expert of Confidential Application interacted with Clients directly for requirement gathering and translating the same to High Level Design.
• Translated customer requirements into formal requirements and design documents, establish specific solutions, and lead the efforts including programming and testing that culminate in client acceptance of the results.
• Delivered new and complex high quality solutions to clients in response to varying business requirements.
• Participated in data-modeling discussions with Business Analysts; Data modeling using Teradata cLDM to support application.
• Optimized Confidential application environments based on specific requirements, including physical database design, end-user access (query) structure and performance, as well as data transformation processes and procedures.
• Optimized performance of the database based on user access and data loading requirements and SQL performance tuning.
• Used PMON and Teradata - EXPLAIN facility to monitor and tune SQL’s and database.
• Used Statistics Wizard/Index Wizard/Visual Explain for analyzing and tuning performance.
• Responsible for Estimation & Tracking of the Maintenance requests.
• Responsible for Team building, mentoring and coaching new team members to make them productive in short span of time.
• Reviewed deliverables of all phases in SDLC. i.e. Design document, Code Review, Unit & System test results and Deployment plans.

Environment: Informatica 8.6.1, Teradata, DB2, JCL, COBOL, Oracle 10i, Netezza, Maestro

Application Developer

Confidential

Responsibilities:

• As an Application Developer responsible for Analysis, design, development, testing and implementation of customized solutions for Confidential application.
• Optimized Confidential application environments based on specific requirements, including physical database design, end-user access (query) structure and performance, as well as data transformation processes and procedures.
• Optimized performance of the database based on user access and data loading requirements and SQL performance tuning.
• Designed and developed ETL components in Informatica Power Center using low level design documents to load data from various source files into common data warehouse, which includes different databases like Teradata, Oracle and Netezza.
• Migrated DB2 tables from Mainframe to Netezza data warehouse platform
• Responsible for Estimation & Tracking of the Maintenance requests.
• Interacted with interface application contacts if there are any interface related issues or for new interface setup.
• Performed Unit, System and integration testing and delivering solution to client for User acceptance testing (UAT), and provided client support while performing UAT.
• Production Support to provide unremitting system support to client and handle the job down scenario if required.
• Followed full software development life cycle and worked on quality documents to assure the deliverables are in par with IBM standards.
• Worked on immediate system support/maintenance or bugs with high business impact.

Environment: Informatica, Teradata, DB2, JCL, COBOL, Oracle 10i, Netezza, Maestro