We provide IT Staff Augmentation Services!

Etl/ab Initio Technical Specialist Resume

MD

PROFESSIONAL SUMMARY:

  • 16 years of total IT industry experience in Software Development Life Cycle (SDLC), involving Requirements Analysis, Design, Development, Testing and Implementation of Software Applications using, ETL, Databases, Web and Mainframe platforms.
  • 10 years of strong Data Integration/Data Warehousing experience working with ETL using Ab initio, Oracle 11g/10g/9.i/8.x/7.x, Teradata and SQL Server 2005/2008.
  • Experienced in Financial, Mortgage and Insurance Domain areas and extensive experience in architecting ETL/ELT solutions as well as working as Lead ETL Designer and Developer.
  • Specialized in ETL methodology for supporting corporate - wide-ETL solution using Ab Initio.
  • Sound Knowledge of Data Warehouse/Data Mart, Data Modeling and Data Profiling Techniques.
  • Expertise in business requirements analysis, data extraction, data mapping, transformation, integration and loading in a complex, high-volume environment using Ab Initio as an ETL tool.
  • Strong skills in SQL, PL/SQL and UNIX Korn Shell scripting and expert in high-end programming experience using HP-Unix 11.0/10.x, Windows XP/2000/98, Windows NT 4.0, IBM AIX 4.3 and Sun Solaris 5.8.
  • Expert in project planning, systems analysis and troubleshooting, quality control, forecasting, scheduling, planning and tracking of results. Worked in the role of Data Specialist involving developing databases.
  • Strong communication skills, systematic approach and quick adaptability to new technologies and new working environment. Strong knowledge in Big Data and Hadoop technologies.
  • Working knowledge of SOX compliance and PII (Personally identifiable information) data.
  • Ability to multi-task and provide technical and analysis expertise for multiple projects and possess strong experience in translating business requirements into architectural technical solutions.

TECHNICAL SKILLS:

Hardware: Sun Sparc, HP9000, IBM 3090/ES9000, OS390, and IBM PCs

Operating Systems: MVS/ESA, UNIX AIX/HP-UNIX/SUN SOLARIS and Windows XP/2000/98

Databases: ORACLE 11g/10.x/9.i/8.x/7.x, DB2/UDB, Teradata, MS SQL Server 2005/2008, Greenplum DB and MS Access 7.0/ 97/2000

Languages: Unix Shell Programming:, COBOL, Visual Basic, C, XML, SQL, PL/SQL, Java, ColdFusion, and XML

Mainframe: TSO/ISPF:, XPEDITOR, Sync Sort, File-Aid, TELON, INTERTEST, QMF, IMS

ETL Tools: Ab Initio: (Co>OP 3.0.2, GDE 3.1.3 and EME), Oracle 9i Warehouse Builder

Data Modeler: Microsoft Visio

Oracle Tools: SQL Loader, TOAD, SQL * PLUS and SQL Developer

Testing/Other tools: Quality Center 10.0, Test Director 7.0, ClearCase and ClearQuest, Remedy, SharePoint, Crystal Reports, Business Objects, MS Office and Oracle9iAS Discoverer

PROJECTS PROFILE:

Confidential, MD

ETL/Ab Initio Technical Specialist

Responsibilities:

  • Developed a thorough understanding of business specifications and produced ETL technical architecture /design and code artifacts that meet the specifications using Ab Initio, Autosys, Oracle, Teradata and UNIX.
  • Became subject matter expert (SME) for various modules like Self-Service Payments, Branch Payments, CitiAlerts, Data Consolidation (Data warehouse) project and Gryphon Networks Data Integration.
  • Analyzed functional requirements, mapping documents, assisted in problem solving and trouble shooting for both real time and batch applications.
  • Worked with market data providers to process, transform and integrate into Symphony program.
  • Extracted data from various sources like databases, delimited flat files, mainframe files and XMLs and developed Ab Initio graphs for loading into target database or creating outbound feeds.
  • Designed and developed parameterized graphs and guided off-shore team to load data using Ab Initio as an ETL tool.
  • Wrote many Korn Shell scripts to automate parameter generation, combining files and support ad-hoc requests.
  • Performed tuning of ETL processes by means of maximizing the use of MFS, using lookup file instead of join if possible, removing unnecessary phasing, removing unnecessary components and making use of the indexes on the tables.
  • Involved in providing various data feeds to other systems by extracting, filtering and transforming and creating flat files, working with Mainframe datasets and XML data.
  • Involved in change management using Infoman by creating SRs, RFCs and IRs to raise issues.
  • Worked directly with non-IT professionals such as product owners, stake holders and business analysts throughout the development cycle and provided post-implementation support, investigation of data and report issues identified by customers.
  • Strong experience in onsite and off-shore model and involved in design and code reviews.

Environment: Solaris 5.8, Oracle 10.x SQL Developer, PL/SQL, Ab Initio ( GDE 3.1.5, Co-Op: 3.1.4 and EME), Teradada, TIBCO, Java, XML, Mainframe, ClearQuest/ClearCase, MS Office, Share Point, Autosys, Nortel Networks and VPN

Confidential, DC

Sr. Ab Initio Designer/Developer

Responsibilities:

  • Created Ab Initio graphs to load data from flat files into Oracle data warehouse (PRDW) after transforming the data based on Business requirements and mapping .
  • Designed and developed parameterized graphs using rollup, join, look up transformations from the Component Library and loaded data using Ab Initio as an ETL tool.
  • Developed Ab Initio graphs which generate different report ready and staging output files.
  • Wrote many Korn Shell scripts to automate parameter generation, combining files and support ad-hoc requests.
  • Involved in providing various data feeds to other systems by extracting, filtering and transforming and creating flat files and SAS datasets.
  • Extensively used Partition and Departition components, to speed up the ETL process.
  • Worked directly with non-IT business analysts throughout the development cycle and provided post-implementation support, investigation of data and report issues identified by customers.
  • Did Unit Testing of each graph and supported System Testing.

Environment: Solaris 5.8, Oracle 10.x SQL Developer, PL/SQL, Ab Initio ( GDE 1.14.20 and Co-Op: 2.14), ClearQuest/ClearCase, Remedy and Autosys

Confidential, FL

Sr. Ab Initio Developer

Responsibilities:

  • Involved in preparing the Technical System Design (TSD) Document for both Phase I and Phase II.
  • Created Ab Initio graphs to load data from monthly and historical feeds. These loads consisted of loading from flat files into DB2 UDB.
  • Designed and developed Ab Initio graphs to process and load monthly data of Claims and Pharmacy from Highmark and South Carolina.
  • Designed and developed graphs using rollup, join, look up transformations from the Component Library and loaded consolidated data identified by dimensions using Ab Initio tool.
  • Responsible for code review and tuning of Ab Initio graphs developed.
  • Worked with business analysts throughout the development cycle and provided post-implementation support, investigation of data and report issues identified by customers.
  • Developed Ab Initio XFR functions to derive new fields, apply business rules and solve various business requirements.
  • Worked with Partition and De-partition components to partition and gather data.
  • Wrote shell scripts to set environment, and to perform pre and post validation checks.
  • Identified dependencies and triggers to schedule ETL jobs for populating Data Marts on scheduled basis.
  • Did Unit & Integration testing of each graph and created schedules for the developed graphs.

Environment: UNIX (HP-AIX) 5.3, Ab Initio (GDE 1.13.13, EME and Co-Op: 2.13), DB2 UDB 12.x, Shell Scripting, Rational ClearCase and Quest Central for DB2.

Confidential, Dulles, VA

Ab Initio Developer

Responsibilities:

  • Extracted data from the binary, variable length files consisting of charge details.
  • Worked with graph parameters, environment variables and sandbox parameters. data is in Sybase and developed Ab Initio graphs to extract and load into dimensions.
  • Developed Ab Initio XFR functions to derive new fields, apply business rules and solve various business requirements.
  • Created load ready files for the fact table data.
  • Created wrapper shell scripts to set environment, and to perform pre and post validation checks.
  • Used multi files, ad-hoc multi files, conditional components, lookups, rollups and join.
  • Worked with Partition and De-partition components to partition and gather data.
  • Developed scripts using PL/SQL to perform DML functions on the tables in Oracle database.
  • Unit & integration tested each graph and Provided QA and production support.

Environment: UNIX (HP-UX), Ab Initio (GDE 1.11.15, Co-Op: 2.11.8), Oracle 9i, Sybase, ERwin, UNIX Shell Scripting, SQL Navigator, TOAD, PL/SQL and CVS.

Confidential, DC

Data warehouse Consultant

Responsibilities:

  • Understand and Analyze existing Entity Relationship data model.
  • Developed scripts using PL/SQL to perform DML functions on the tables in Oracle database.
  • Create business areas and Reports for Regulatory Compliance, Survey and Call Log modules using Oracle9iAs Discoverer.
  • Developed PL/SQL scripts for regular maintenance and production support to load the data warehouse in regular intervals.

Environment: Sun Solaris, ERwin, UNIX Shell Scripting, Oracle 9i, Oracle 9i Warehouse Builder, Oracle9iAs Discoverer, Discoverer Plus, SQL*Loader, SQL Navigator, TOAD, PL/SQL and Visual Source Safe.

Confidential, VA

Sr Programmer/Analyst

Responsibilities:

  • Involved in the requirements analysis and database design.
  • Developed Java classes to implement logging feature for Back-end Hosting of ImageCafe.
  • Develop COBOL programs to extract the data from DB2 database to a flat file structure.
  • Created data mappings to load the data from flat files to target Oracle tables.
  • Developed database triggers to implement data integration and to enforce validation rules.
  • Wrote several PL/SQL, SQL, and shell scripts to investigate errors and to scrub the customer account and mortgage production data.

Environment: IBM ES/9000, HP UNIX 10.2, Win NT 4.0/2000, Java 2, JDBC, Oracle 7.x/8.x, PL/SQL, FTP, Cobol, DB2, IMS DB, Crystal Reports, Test Director, Robo Help, Ultra Edit and Microsoft Project.

Confidential, VA

Programmer/Analyst

Responsibilities:

  • Developed new PL/SQL packages, Oracle tables and Unix Shell scripts.
  • Developed COBOL programs to extract data from VSAM files.
  • Developed mappings to load the data from External Sources - Flat files.
  • Shell and PL/SQL scripting for regular maintenance and production support to load the data warehouse in regular intervals.

Environment: IBM s390, Unix Shell scripting, COBOL/DB2, IMS DB, Perl, Sybase, Oracle 8i, HP-UX, NT 4.0, PL/SQ, VS-COBOL, FTP, XPEDITER, JCL, VSAM, FILE-AID, MVS/ESA and Clearcase.

Confidential

Systems Engineer

Responsibilities:

  • Responsible for developing 4 new modules for the application. Part of 4 person offshore team coordinating and working with client.
  • As a team member satisfied several periodic requests from the client, which includes development, problem analysis, bug fixing & enhancement.
  • Prepared test cases for the maintenance request. Reviewed requests serviced by other team members. Active member of Internal Quality Audit (IQA) throughout this project.
  • Responsible for the Quality Assurance of software release to remove obsolete functions. Designed the test cases for this project as part of 5-member team.
  • Converted programs from COBOL to Cobol II.

Environment: IBM 3090, COBOL, IMS DB, DB2, MVS, VSAM, Xpeditor and Easytrieve Plus.

Hire Now