We provide IT Staff Augmentation Services!

Etl Resume

CA

Summary:

ETL Consultant.

  • Over Ten years of IT experience including 7+ years on Datastage Enterprise Edition (PX) and 2+ years Experience on TIBCO an EAI tool and experience on data warehousing architecture, Business Intelligence, data marts, data integration, data modeling, with extensive ETL tool IBM Web sphere Datastage and Informatica ETL designing and reporting.
  • Worked as a Technical Lead, ETL Architect and my strengths are in a data warehousing Development and Architecture, technical leadership, enterprise applications research, analysis, Known for comprehending complex business processes, decision-making skills, problem identification and recommending best of the breed solutions
  • Certified on IBM Websphere Datastage Enterprise Edition
  • Ability to work with and supervise remote resources and provide resource, work load management
  • Converted Datastage jobs from 7.5.2 version to Datastage v8 and coded for multiple jobs to meet the updated and changed business rules.
  • Proven track record in troubleshooting of Datastage jobs and addressing production issues like performance tuning and enhancement.
  • Over 5+ years experience on Unix platform and strong in Unix shell scripts
  • Worked with various technologies including Real time systems, Data warehousing, IBM BDW(Banking DataWarehouse), Database technology which includes IBM Datastage, QualityStage, Informatica, Microstrategy, Hyperion, Crystal Reports, Erwin, Cognos, UNIX, XML, DB2, C, Pro*C, Oracle, Informix, PL/SQL, SQL, Perl, ksh, network/socket programming, operating systems, Cobol, OS 390, MVS, File Aid, .NET, C# and software development life cycle processes
  • Extensively involved in the architecture of ETL scripts. Very Strong SQL skills, including use of nested table expressions, unions, multi-table joins, scalar functions, outer joins, derived columns. Extensively worked with Logical and physical modeling along with design and implementation. Worked on different versions of IBM Datastage (5.2, 6, 7.2,7.5.2,8.0 and 8.1)
  • Expertise in working with various operational sources like Teradata, SAP(ABAP,IDOC,BAPI), Sybase, Oracle, DB2, SQLserver, XML, Siebel
  • Played significant role in various phases of project life cycle, such as requirements definition, functional & technical design, testing, Production Support and implementation.
  • Strong writing and documentation skills for the management, development and control of documentation

Skills:

ETL Tools and Utilities

Data Stage TX/EE8.5, 8.1, 8.0.1, 7.5.2/7.0/6.0 (Data stage Parallel Edition & Server Edition),Quality Stage 8.0, TIBCO Business Works 5.6, Business Events 3.0, ADB Adapters, Oracle Designer, Erwin, ER/Studio, TOAD, AutoSys

Programming Languages

C, C++,Java, SQL, PL/SQL, Perl script, Korn Shell

Databases

Oracle 10g/8i/9i, TERADATA, Sybase 11, SQL SERVER 6.5/7.0, DB2 , SAP R/3, Informix.

EAI/Integration tools

TIBCO Business Events 3.0, Business Works 5.6, Adapter for ADB 5.2

Web Technologies

JDBC, XML, Shell Scripts, SOAP, WSDL

Reporting Tools

Business Objects, COGNOS, MSAS, Brio

Operating System

Windows XP/NT/2000, Linux, IBM AIX 5.2/5.1

Certification: IBM Web Sphere IIS Datastage Enterprise Edition v7.5

Project Description:

Confidential, CAJune ‘12 to till date
Sr.ETL Consultant
Description:
The Projects SiteMerch Reporting and MCCS falls under the IDM, IDM Infrastructure is responsible for sourcing data from heterogeneous internal and external systems, transforms, aggregates, augments, stores data in the datamart for internal consumption and also syndicates the data to heterogeneous internal and external systems. IDM is the data hub as well as data integration layer in MACYS.com
Responsibilities:

  • Worked as an Offshore Tech lead for the MCCS Project and Sr ETL COnsultant in SITE MERCH project
  • Responsible for end-to-end delivery of the project from technical (ETL) standpoint
  • Written Technical specification, Unit Test scripts and participated in the TRB meetings to get the approval for Tech Specs
  • Estimation of the code delivery, assigning the work to offshore folks to get the code done in time and responsible for the code delivery.
  • Worked closely with business to meet the requirement
  • Involved in Logical and Physical Database changes on Oracle 9i/10g
  • Mentored and followed the coding standards and best practice methods to the FTEs and team members
  • Supported QA team with system testing
  • Created packages to maintain and migrating the code from DEV to INT and INT to PROD

Environment: Information Server DATASTAGE 8.5, EE (PX) ,Information Analyzer, Business Objects Web Intelligence, Flat files,PLSQL, Clear Quest, TortoiseSVN, SAP ABAP,IDOC,BAPI,DB2,Oracle,DB2,AIX, Windows XP, Toad, Control-M Scheduler

Confidential, CASept ‘11 to May ‘12
Sr.ETL Consultant
Description:
The ProfitMAX NextGen solution plays an important role for Wholesale Banking by providing the ability to report on profitability across Products, Customer Relationships, Organization, and Officers.ProfitMAX NextGen allows stakeholders to report on customer profitability within Wholesale. ProfitMAX NextGen provides the ability to calculate customer profitability from a product, officer, and organizational perspective for up to 5 years of historical financials. In addition to providing customer-driven profitability reporting
Responsibilities:

  • Coded for the new development and enhancement logic for the existing NextGen project.
  • Responsible for end-to-end delivery of the project from technical (ETL) standpoint
  • Written Technical specification, Unit Test scripts and participated in the TRB meetings to get the approval for Tech Specs
  • Written shell scripts, Parallel routines, Jil scripts for Autosys scheduler tool to meet the business requirement.
  • Worked closely with Business analysts to gather the requirements and arranged meetings.
  • Involved in Logical and Physical Database changes on Oracle 9i/10g
  • Mentored and followed the coding standards and best practice methods to the FTEs and team members
  • Supported QA team with system testing
  • Created and maintained Code catalogue, Build sheet, Developer Tracking sheet

Environment: Information Server DATASTAGE 8.1, EE (PX) ,Information Analyzer, Business Objects Web Intelligence, Flat files,PLSQL, Clear Quest, TortoiseSVN, SAP ABAP,IDOC,BAPI,DB2, Oracle,DB2,AIX, Windows XP, Toad, Autosys Scheduler

Confidential, Nov ‘10 to Aug ‘10
ETL Consultant
Description:
Galaxy medical claims are extracted based on their source (UNET or COSMOS or MAMSI) and processed through adjustment logic unique to the source. The adjustment logic mirrors the logic currently used in the legacy predictive model product. The adjusted claims will be initially held in files. NextGen processes to create the input tables that will be sent to the Common Service(CS) for processing of Impact Pro A service submitted on a facility claim for reimbursement.
Responsibilities:

  • Responsible for end-to-end delivery of the project from technical (ETL) standpoint.
  • Actively participated in all the phases of the project- Requirement gathering, Analysis & Design, Coding and Unit Testing, System Integration Testing, UAT, deployment and Warranty Support.
  • Monitor performance of production ETL processes and responded to errors and emergency problems
  • Designed and architected custom ETL components for transaction coordination and real time needs of the project which were used in multiple Datastage jobs
  • Extensively used the SAP plugins ABAP,IDOC,BAPI stages to pull and load the data in to SAP
  • Worked on Information Analyzer for Data profiling
  • Responsible for Datastage job performance tuning and SQL tuning in extracting the data
  • Acting as a Technical Mentor to all the SE’s on the project team and followed the best practice and tuned the jobs accordingly as per the volume of the data.
  • Coordinating with DBA, BA and Lead Tester on the project and
  • Analyzed complexity and technical impact of requirements for the existing system and provide guidance to Business Analyst for further refinement
  • Administrative task is been handled. Handled all the projects to move from DEV to QA and to PROD

Environment: Information Server DATASTAGE 7.5.2, 8.1, EE (PX) ,Information Analyzer,Business Objects Web Intelligence, Flat files, SAP ABAP,IDOC,BAPI,DB2, Teradata, Oracle,DB2,AIX, Windows XP, Toad, Autosys Scheduler

Confidential, Parker. OHAug 10 to Oct 10
ETL Consultant
Description:
At Parker, The current existing UCM data is migrated into HTIM. Datastage 8.1.0 Upgraded from Datastage 8.0.1
Responsibilities:

  • Lead the responsible for the Datastage upgrade to version 8.1 from 8.0.1.
  • Worked on Information Analyzer for Data Profiling - Column analysis, Configured Oracle database with Information Analyzer
  • Written ifb scripts to load the data into Siebel Tables from EIM tables.
  • Monitor performance of production ETL processes and responded to errors and emergency problems
  • Designed and architected custom ETL components for transaction coordination and real time needs of the project which were used in multiple Datastage jobs
  • Responsible for Datastage job performance tuning and SQL tuning in extracting the data
  • Mentored and followed the best practice and tuned the jobs accordingly as per the volume of the data.
  • Pulled the data from DB2 database and loaded into EIM tables (Base Tables) in Sibel and then written ifb scripts to load the data into SIEBEL tables.
  • Administrative task is been handled. Handled all the projects to move from DEV to QA and to PROD

Environment: InfoSphere DATASTAGE 8.1, 8.0.1, EE (PX) , Information Analyzer, DB2,SIEBEL,Oracle, SAP ABAP,BAPI,IDOC, AIX, Windows XP, Toad

Confidential, Westfield Grp. OHJan 09 to Jul 10
ETL Lead
Description:
At Westfield Group, Informatica Power Center is being replaced by IBM’s Datastage ETL tool. With this product change , we have converted current production PowerCenter maps to Datastage applications. This includes development, test and production environments with no impact to existing Informatica environment according to Westfield standards. Converted projects - CPM,BDDM,AIS Rewrite, Agency Data Load,EDW,TDW
Responsibilities:

  • Lead the team for the Conversion project and System Testing and designed Time lines overlapping per each resource and documented Team status reports and Mapping inventory
  • Converted Informatica Mapping / Mapplets / Workflows / Worklets into Information server Datastage Jobs and Sequences.
  • Review and assess business rules, project plans, development and test specifications
  • Plan, schedule and coordinate changes with SME’s to maximize effectiveness of system
  • Trained existing developers in Datastage EE(PX) and worked with middleware team to transfer administration responsibilities of the ETL and BI tools
  • Monitor performance of production ETL processes and responded to errors and emergency problems
  • Designed and architected custom ETL components for transaction coordination and real time needs of the project which were used in multiple Datastage jobs
  • Personally taken responsible for Datastage job performance tuning and SQL tuning in extracting the data
  • Designed reusable architecture components which can be used by all the ETL and reporting developers irrespective of the project requirements. This involved architecting various basic routines, C routines, Datastage Jobs (Server/PX), reusable shell scripts and C++ programs
  • Providing architectural guidance for projects in areas of data warehousing, data mining and analytics – Enterprise client Reporting, Enterprise ODS, EDW design and Real time systems.
  • Analyzing the Informatica mappings and designed Datastage jobs according to Daily, Weekly and Monthly loads into Data Warehouse
  • Mentored and followed the best practice and tuned the jobs accordingly as per the volume of the data.
  • Pulled the data from SAP MM(Material Master), Customer Master, Employee and loaded the data into SAP by using Datastage SAP plug-ins like ABAP stage , IDOC stage, BAPI stage
  • Extensively used the CFF stage, CDC stage, Sparse Lookup, Lookups, Joiners, Transformation, Pivot, Aggregator, BTEQ, TPUMP, DB2 UDB, Enterprise Stages
  • Administrative task is been handled. Handled all the projects to move from DEV to QA and to PROD
  • Converted the AIX scripts in to Datastage jobs and Linux scripts and designed and coded very complex Jobs in DatastageEnvironment: InfoSphere DATASTAGE 8.0.1, EE (PX) ,Infosphere Designer, InfoSphere Director, InfoSphere Administrator, Informatica 8.6.1 , Informatica 7.2,QualityStage 8.0.1, SAP, Oracle, Teradata, Information Analyzer 8.0.1 , MS Project, Java, XML, Sybase, DB2, Mainframe, COBOL files, SAAS files, SQLserver, AIX, Linux, Windows XP, DB Visualizer

Confidential, GAJul 08 to Dec 08
ETL Lead consultant
Description:
Extended Care Solution Group ,a Migration project, The Source ACT database will have to Freeze and the data need to be loaded in to the Siebel Data warehouse. With matching to existing data in Verespian Database and Siebel Warehouse and including non-existing datatofeed ECSG Siebel database. The Data from the ACT database is matched upon Hospital Names and Address and Contact details with using the Quality stage tool and then having the Transformation rules set up for the Migration in order to synchronize the existing ECSG Siebel Database.
Responsibilities:

  • Involved in two projects simultaneously, been through a complete project in the ECSG and CDM a short term projet on matching with the Qualitystage and Datastage.
  • Worked with project managers, DBA’s , application developers ,QA and LAN engineers to ensure that all necessary development and support infrastructure is in place to guarantee the new developments
  • Responsible for designing, developing and maintaining data integration processes using ETL
  • Responsible for scheduling and maintaining ETL jobs
  • Responsible for database data integrity
  • Worked extensively with Information Analyzer for Data Profiling
  • Responsible alone for both the projects to meet all the business needs.
  • Administrative task is been handled. Handled all the projects to move from DEV to QA and to PROD
  • Extensively used Investigate, Standardize, Match Frequency, Reference Match, Unduplicate Match, Survive stages in Qualitystage
  • Analyzed, designed, developed, implemented and maintained moderate to complex initial load Datastage jobs to provide data for data warehouse
  • Configured Active Database Adapter to Publish/Subscribe and Request/Reply services to interact with multiple databases
  • Created Custom triggers for the Adapters to publish the data to P tables
  • Wrote complex Datastage jobs to populate the data with the transformation rules from business
  • Collected the requirement form business and involved in the meetings for the business logics.

Environment: InfoSphere DATASTAGE EE (PX) 8.0.1/7.5.2,InfoSphere Designer, InfoSphere Director, InfoSphere Administrator, QualityStage8, Information Analyzer 8 , EAI tools Tibco Business Works, TIBCO Active Database Adapters, XML, Java, Teradata, MS Access, SQLserver, Sybase, Siebel, AIX, Active Directory, Windows XP, TOAD

Hire Now