We provide IT Staff Augmentation Services!

Sr.etl Consultant/ab Initio Lead Resume

Frederick, MD

PROFESSIONAL SUMMARY:

  • Over Nine years of professional experience in IT - Software Design, Development and Data warehousing ETL.
  • Experience includes developing Data Warehouses/Data Marts/ODS using in Telecom, Banking, Capital Markets, Finance and Insurance domains.
  • Extensive experience in Data warehousing and ETL, as a Data warehouse specialist, ETL Specialist and Sr. Ab Initio Consultant/Architect.
  • Excellent experience in Design and Implementing ETL processes and transformation mappings and loading using Ab Initio.
  • Actively involved in organizational level Bigdata and Hadoop ecosystem (MapReduce, Hive, Sqoop) architectural implementation sessions as well as pilot projects.
  • Highly experienced in creating Sandboxes, check in and checkout of graphs from teh EME, command line interface, air commands and Dependency analysis.
  • Hands on Experience in creating Plan it and using Conduct it. Migrated scripts/wrappers and graphs to Ab Initio Plans. Design, Code and implementation experience with Ab Initio ACE/BRE (DQE).
  • Strong data modeling experience in data modeling methodologies like Star, Snow flake schemas and designing with ERWIN.
  • Worked on configuration management and product administration with Ab Initio.
  • Product administration covers production support and developer support.
  • Design and development of OLAP models consisting of multidimensional cubes for data analysis.
  • Extensive experience in various databases like Teradata, Oracle, UDB DB2, Flat files and Legacy systems.
  • Extensively worked with Teradata utilities Fast & Multi Loads, Fast Export and SQL Assistant.
  • Strong skills on Ab Initio graph programming, Parameter Definition Language (PDL) and Data Manipulation Language (DML).
  • Experience in various Teradata utilities like Fastload, Multiload, BTEQ scripts, Teradata SQL Assistant and strong noledge on Teradata architecture, data model concepts.
  • Experience in working with Oracle using SQL, PL/SQL, SQL loader and solid expertise in oracle stored procedures, Triggers, Index, Table Partitions.
  • Extensive experience in UNIX Shell scripting to create wrappers and automate teh jobs.
  • Scheduling through Autosys by inserting, deleting and updating jobs in various Environment instances.
  • Experience in providing End-to-End production support to Ab Initio and various ETL jobs.
  • Excellent communication, interpersonal skills and has a strong ability to work as part of a team and as well as handle independent responsibilities.

TECHNICAL SKILLS:

ETL: Ab Initio Co>Op sys 3.1.5.1/2.15/2.14/2.13, GDE 3.1.2/1.15/1.14/1.13, PLAN IT; ACE/BRE 3.2.2.1; Metadata Hub; Informatica powercenter 9.5;

RDBMS: Teradata V12, UDB DB2, Oracle 11g/10g/9i, Sybase, MS SQL Server

Tools: ERWIN, MS VISIO, SQL Assistant, TOAD, Clear Quest, IBM Data studio, Clear case, Metadata hub

Scheduling Tools: Tivoli, Autosys, Control M

Programming: C, SQL, UNIX Shell Scripting, PL/SQL, Visual Basic 6.0

Operating Systems: UNIX AIX, Windows NT/98/2000/7, MVS-Mainframes, HP-UX, Linux.

PROFESSIONAL EXPERIENCE:

Confidential,Frederick, MD

Sr.ETL Consultant/Ab Initio Lead

Responsibilities:

  • Worked closely with business for Ab Initio GDE, ACE/BRE (Business Rules Engine) setup, design, coding and training. Used Metadata Hub for files, dml’s, xfr’s etc.
  • Involved in understanding teh Requirements of teh End Users/Business Analysts and Developed Strategies for ETL processes.
  • Developed various BRE .psets, generic graphs and plans to process CMIE to Staging DB, Reconciliation of new DB versus existing legacy data, MODE, SMS, ASDS data based on business requirements utilizing functionalities like Join-with-DB, Read-Excel, Rollup, Lookup, Reformat, Scan etc. to generate reports and CSV’s.
  • Designed graphs to extract data from different sources like Legacy DB’s (CORE, LIS, LPS, SMS, MODE and MIDE DB’s) and some UI interfaces, spreadsheets and other Databases.
  • Involved in high level architectural implementation sessions of Big data and Hadoop.
  • Designed generic graphs to generate LOAN’s for various test scenarios in order to validate teh rules.
  • Developed graphs for serving teh Business Users ADHOC requests.
  • Involved in developing Detailed Technical Design documents and test cases referring back to teh High Level Design.
  • Reverse engineered existing graphs to create teh necessary design documents like mapping documents and tan updated them for additional new functionality. Updated all design documents to ensure that they were always current and reviewed with team in design review meetings.
  • Responsible for End-to-end validation when project migration to higher environments (SIT, IFT, UAT). Co-ordinate with SUPPORT teams for on-time and error free CODE migration.
  • Designed migration documents for CMIE PROD, PRE-PROD and UAT rehearsals.
  • Validate Autosys BOX’s and CMD’s deployed to schedule Ab Initio graphs and scripts to automate jobs and co-ordinate with Autosys Admin team to ensure Job dependencies are set as expected.

Environment: Ab Initio Co >Op 3.1.5.1, GDE 3.1.7, ACE/BRE, EME, Oracle11g (11.2), Mainframes, Shell scripting, TOAD, Share point, Autosys, Informatica 9.5, Metadata Hub, MapReduce, Hive, Sqoop.

Confidential, Reston, VA.

Senior ETL Consultant Ab Initio & Informatica.

Responsibilities:

  • Involved in understanding teh Requirements of teh End Users/Business Analysts and Developed Strategies for ETL processes.
  • Developed various graphs to process SCD to Staging Reconciliation, STATS, P&I, RBM data based on business requirements utilizing functionalities like Join-with-DB, Read-Excel, Rollup, Lookup, Reformat, Scan etc. to generate reports and CSV’s.
  • Designed graphs to extract data from different sources like Legacy DB’s (STAT, SCBSL, TAX, FDW, CDS, IMP, and RACE), EUC files (Remic, IMPR, CMBS, and TX RCR), spreadsheets and other Databases.
  • Designed generic graphs to generate DCU’s for various test scenarios in order to validate teh rules.
  • Supported Informatica Sec-master application in various phases from development till migration and familiarized with Informatica transformations like Expression, Joiner, Aggregator, Filter, XML generator and parser, Sorter etc.
  • Developed graphs for serving teh Business Users ADHOC requests.
  • Worked closely with business for ACE/BRE (Business Rules Engine) setup, design, coding and training. Used Metadata Hub for files, dml’s, xfr’s etc.
  • Involved in developing Detailed Technical Design documents and test cases referring back to teh High Level Design.
  • Reverse engineered existing graphs to create teh necessary design documents like mapping documents and tan updated them for additional new functionality. Updated all design documents to ensure that they were always current and reviewed with team in design review meetings.
  • Responsible for End-to-end validation when project migration to higher environments (SYT, iUAT and BOT). Co-ordinate with SAM-SUPPORT for on-time and error free migration.
  • Designed migration documents for T&C project for PROD, PRE-PROD and IUAT (R. X rehearsals).
  • Validate Autosys BOX’s and CMD’s deployed to schedule Ab Initio graphs and scripts to automate jobs and co-ordinate with Autosys Admin team to ensure Job dependencies are set as expected.
  • Prime Participant in Big data and Hadoop session and involved in pilot project discussions.

Environment: Ab Initio Co >Op 3.1.5.1, GDE 3.1.7, EME, Oracle11g, Linux, Shell scripting, TOAD, Share point, Autosys, Simcorp Dimension, Informatica 9.5, ACE/BRE, Metadata Hub.

Confidential, Jacksonville, FL.

Ab Initio Developer-III (Sr. Developer)

Responsibilities:

  • Involved in understanding teh Requirements of teh End Users/Business Analysts and Developed Strategies for ETL processes.
  • Developed various graphs to process Contract, Group, Member and Pharmacy Claims data based on business requirements utilizing functionalities like Rollup, Lookup, Scan, etc.
  • Designed new graphs and tuned existing processes to use MFS for faster and efficient data processing and also implemented parallel processing wherever possible.
  • Extracted data from different sources like MVS data sets, Flat files (“pipe” delimited or fixed length), excel spreadsheets and Databases.
  • Implemented a Parameterized process using PSETs which was used to create numerous extracts based on teh Contract, Individual and group specific combination.
  • Designed various graphs to generate data for various test scenarios in order to validate teh numerous rules.
  • Developed graphs for serving teh Business Users ADHOC requests.
  • Responsible for designing graphs and generating Audit reports for MLR based on Individual, Self and employer level reports on all Member, Medical Claims, Pharmacy Claims and Authorization modules.
  • Built efficient graphs that could be used for mocked data population in teh Test environments like SIT, STAGE and UAT from Production based on teh Test Scenarios.
  • Involved in developing Detailed Design documents referring back to teh High Level Design.
  • Reverse engineered existing graphs to create teh necessary design documents like mapping documents and tan updated them for additional new functionality. Updated all design documents to ensure that they were always current and reviewed with team in design review meetings.
  • Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, DML, Pset, XFR, deployed scripts, DBC files for connectivity.
  • Gathered and Documented Business requirements in PSDD’s (Physical solution design document).
  • Designed and developed graphs using Ab Initio and written wrapper scripts to automate jobs.

Environment: Ab Initio Co >Op 3.1.5.1, GDE 3.1.2.2, EME, UNIX AIX, DB2 UDB, RBMS, IBM Data Studio, SQL Assistant, Shell scripting, TOAD, Clear case, Metadata hub, Control-M.

Confidential, Lincolnshire, IL

Sr. Ab Initio Developer.

Responsibilities:

  • Involved in understanding teh Requirements of teh End Users/Business Analysts and Developed Strategies for ETL processes.
  • Gathered and Documented Business requirements in PSDD’s (Physical solution design document).
  • Designed and developed graphs using Ab Initio and written numerous wrapper scripts (korn shell) to automate jobs.
  • Designed and Developed graphs for serving teh Business Users ADHOC requests.
  • Developed Plans for running teh Jobs in Dependency.
  • Worked closely with business for ACE/BRE (Business Rules Engine) setup, design, coding and training.
  • Performed unit testing and written test cases for every object.
  • Worked with QA, UAT and SIT teams to resolve incidents during object testing phase.
  • Performed tuning and optimization of database configuration and application SQL.
  • Experience in SQL Tuning using EXPLAIN PLAN.
  • Statistics collection and tuning based on API and UNTILITY.
  • Written UNIX Shell Scripts for Automation and Scheduling teh Jobs.

Environment: Ab Initio Co >Op 3.0.2.0, GDE 3.0.2, EME, Plan IT, ACE/BRE, UNIX Solaris, DB2, Oracle 11g, DB2, SQL Assistant, TOAD, Easy Reports, Sharepoint.

Confidential, Lake Oswego, OR

Sr. Ab Initio Developer

Responsibilities:

  • Involved in understanding teh Requirements of teh End Users/Business Analysts and Developed Strategies for ETL processes.
  • Gathered and Documented Business requirements in PSDD’s (Physical solution design document).
  • Performed tuning and optimization of database configuration and application SQL.
  • Implemented History preservative methods SCD2 and SCD3 for individual applications in Application data mart area using Ab initio. And also participated in data modeling meetings.
  • Designed and developed numerous graphs using Ab Initio and written numerous wrapper scripts (korn shell) to automate jobs.
  • Served many ad hoc requests submitted by Business users used components like read XML, write XML, read XML transform, write excel, read excel etc. and also provided production support for existing applications.
  • Worked on EDW (Enterprise Data Warehouse). Developed ab initio graphs to extract Enterprise Data Warehouse to create Data marts (Full Load and Incremental load).
  • Extensively used ETL to load data using Ab Initio DB components from heterogeneous and as well as homogeneous source systems from DB2, Oracle etc to target Data Warehouse Teradata Database and other file systems.
  • Performed potential transformations Confidential teh staging area, such as cleansing teh data (dealing with missing elements, parsing into standard formats) combining data from multiple sources, de-duping teh data and assigning surrogate keys.
  • Enabled component folding for optimal performance. Used phases, check points to an effective watchers and debugging mode while debugging teh graphs.
  • Tune Teradata Development and Production systems for optimal performance.
  • Experience in SQL Tuning using EXPLAIN PLAN.
  • Statistics collection and tuning based on UPI, NUPI, USI and NUSI.
  • Metadata mapping from legacy source system to target database fields and involved in creating AbInitio DML’s.
  • Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching teh business requirements to Teradata RDBMS.
  • Developed and worked on numerous BTEQ/SQL scripts, making changes to teh existing scripts and completed unit and system test.
  • Worked with remedy (change management system). Created CR (Change request) and RFC’s (Request for change).
  • Performed unit testing and written test cases for every object.
  • Worked with QA, UAT and SIT teams to resolve incidents during object testing phase.
  • Worked on Tivoli scheduling tool. Created Tivoli Web Forms for scheduling jobs.
  • Developed and supported teh extraction, transformation and load process (ETL) for teh Data Warehouse from heterogeneous source systems using Ab Initio.
  • Used Ab Initio GDE to generate complex graphs for teh ETL process using components like Join, Rollup, Reformat and executed using Co>Operating System.
  • Created .xfr and .dml files for various transformations and specifed teh record format. Involved in automating teh ETL process through scheduling.
  • Deploy and test run teh graph as executable Korn shell scripts in teh application system
  • Used teh sub graphs to increase teh clarity of graph and to impose reusable business restrictions. Capacity of designing solutions and advanced skills with high performance in Ab Initio.
  • Modified teh Ab Initio components parameters, utilize data parallelism and thereby improve teh overall performance to fine-tune teh execution times.
  • Utilized Phases, Checkpoints to avoid deadlocks and multi-files in graphs and also used Run program, Run SQL components to run UNIX and SQL commands.
  • Provided application requirements gathering, designing, development, technical documentation, and debugging. Assisted team members in defining Cleansing, Aggregating, and other Transformation rules.
  • Analyze business requirements and developed metadata mappings andAb InitioDMLs.
  • Involved as a Business Analyst interacted with product and Technical Managers of teh Source systems and came with Business transformation logic.
  • Able to interact effectively with other members of teh Business Engineering, Quality Assurance, users and other teams involved with teh System Development Life cycle.
  • Unit testing and end-to-end system testing of teh entire application. Creating graphs that use xml. Support for user acceptance testing. Production migration and production support.

Environment: Ab Initio Co >Op 2.15/14, GDE 1.15/14,EME, UNIX AIX, DB2, Teradata V2R12/6, Oracle 10g, DB2, Tivoli, SQL Assistant, TOAD, Easy Reports, Xerox DocuShare.

Confidential, Atlanta, GA.

Sr. Ab Initio Developer

Responsibilities:

  • Involved with business users to prepare functional specification and technical design documents for ETL process for complete data warehouse cycle for Confidential &T wireless customer support and sales.
  • Developed Jobs and used Ab-Initio as an ETL tool to load teh final loads.
  • Teh project is to centralize teh reporting system, previously used a hard coded program.
  • Working closely with onsite for delivering best quality deliverables in specified time lines.
  • Used Ab Initio as ETL tool to extract data from source systems, Transform, and Load data into databases.
  • Developed various Ab-Initio graphs for customer credit, contact, account detail, account XRef, data inserts & updates, data validate graphs, calling plan, network service XRef graphs and refresh graphs.
  • Developed re-usable generic / dynamic Ab Initio graphs and psets for teh quality check of teh source data.
  • Used various Ab-Initio components of partition, de-partition, database, datasets, transform, FTP and sort to build graphs in GDE.
  • Developed Ab-Initio graphs for data validation using validate components.
  • Deduping and consolidating customer records from various sources to create master customer list.
  • Created Ab-Initio multi file systems (MFS) to take advantage of partition parallelism to run graphs in parallel.
  • Involved in monitoring Ab Initio jobs using AB REPORT options.
  • Developed several stored procedures and functions to make teh existing code to be executed and make it more dynamic which is now considered to be teh centralized program for teh existing running programs and teh new EDW project.
  • Developed several database triggers to maintain teh data integrity.
  • Developed and loaded parameters called during teh execution of teh EDW program for dynamic execution.
  • Wrote several SQL* loader programs to load small loads into temporary tables for teh data, which may be required to move among different UNIX servers and databases while teh program is running.
  • Developed several KShell (Korn-Shell) programs, functions and packages to do teh pre-inspection, post -inspection, pre-extraction inspection of teh data getting loaded every week and populate errors, which are again used to generate error reports responsible for teh automation of Ab-Initio graphs using KShell (korn-shell) scripts.
  • Expertise in unit testing, system testing using of sample data, generate data, manipulate date and verify teh functional, data quality, performance of graphs.
  • Documentation of complete graphs and its components.

Environment: Ab Initio (Co>Op2.15, GDE 1.15), Sun Solaris 9, Oracle 11g, DB2 5.0, UNIX Korn Shell scripting, Erwin7.3.

Confidential, Philadelphia, PA

Ab Initio Developer

Responsibilities:

  • Performed Analysis, designing and preparing teh functional, technical design document, and code specifications.
  • Developed and supported teh extraction, transformation and loading process (ETL) for a Data Warehouse from their OLTP systems using Ab Initio and provide technical support and hands-on mentoring in teh use of Ab Initio.
  • Responsible for all pre-ETL tasks upon which teh Data Warehouse depends, including managing and collection of various existing data sources.
  • Involved in developing UNIX Shell wrappers to run various Ab Initio Scripts.
  • Developed Ab Initio XFR’s to derive new fields and solve various business requirements.
  • Designed several Ab Initio graphs that transfer data from various sources like Teradata, Oracle, flat files and CSV files to teh target database.
  • Developed number of Ab Initio Graphs based on business requirements using various Components such as Partition by Key, Partition by round robin, reformat, rollup, join, scan, normalize, gather, Broadcast, merge etc.
  • Worked on configuration management and product administration with Ab Initio.
  • Product administration covers installation, setup, configuration, production support, developer support, monitoring batch jobs, investigating and resolving teh problems
  • Teh performance of Ab Initio graphs are improved by using various Ab Initio performance technique’s like using lookups instead of Join’s etc.
  • Implemented Lookup’s, lookup local, in-Memory Joins and rollup’s to speed up various Ab Initio Graphs.
  • Design Documentation for teh developed graphs.
  • Flat files created for building teh Essbase cubes.
  • Created UNIX shell scripts to automate and schedule teh jobs.
  • Created teh migration scripts, test scripts for testing teh applications, creating and supporting teh Business Objects reports.
  • Performed physical data modeling, performing regular refreshes of development and test database environments using teh Export/Import utility.

Environment: Ab Initio Co>Op 2.15, GDE 1.15, Teradata, Oracle 10g, UNIX Shell scripts, Toad, Erwin 7.3, Control-M, Pl/Sql, Sql*Loader, Essbase 6.x, Solaris 9..

Confidential

PL/SQL Developer

Responsibilities:

  • Participated in database modeling and database design
  • Prepared program specifications for PL/SQL Procedures and Functions to do teh data-migration and conversion
  • Enhanced database programs using PL/SQL
  • Developed teh database by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections
  • Written and modified existing PL/SQL procedures, functions, packages and triggers.
  • Participated in performance tuning using Explain Plan
  • Development and Customization of various forms and reports.
  • Optimized and tuned Queries to reduce teh Run time of various reports.
  • Developed PL/SQL Procedures and Functions as per teh requirement. Involved in writing PL/SQL triggers for Data Validation.
  • Defined Descriptive Flexfields and Value sets as part of development and Customizations.
  • Created Menu Objects and attached responsibilities as per user guidelines.
  • Worked on data conversion for migrating data from legacy systems using SQL*Loader and PL/SQL.
  • Development and Customization of forms to Print Invoices and Reports, with information as required by teh client.
  • Building database applications using Oracle.
  • Involved in Writing PL/SQL triggers and procedures for Data Validation of key fields in teh required forms.
  • Defined various setups for implementing different modules.

Environment: Oracle 9i, PL/SQL, PRO*C, Oracle Reports, Forms, SQL*LOADER, UNIX Shell scripting.

Hire Now