We provide IT Staff Augmentation Services!

Sr. Ab Initio Developer Resume

4.00/5 (Submit Your Rating)

Riverwoods, IL

SUMMARY:

  • Over 6+ years of IT experience in Analysis, Design, Development and Maintenance of various Business applications.
  • Strong experience in Ab Initio Architecture, GDE, Co>Operating System.
  • Extensively used AIR commands to check in/check - out, perform dependency analysis and other EME related operations.
  • Expertise in the use of Co-Op, Express-It (ACE), BRE, DQE, Metadata Hub, Conduct>IT, Correlate, Query>It, Dependency analysis for development and testing.
  • Hands on experience in handling data from various source systems such as Flat Files, XML Source, Oracle, MS SQL Server, IBM DB2, Teradata and Excel Files.
  • Extensively used different features of Teradata such as BTEQ, FastLoad, MultiLoad, Tpump, SQL Assistant.
  • Comprehensive knowledge of Mainframe programming, test plan, regression testing, and techniques.
  • Good working knowledge in Parameterizing Ab Initio graphs and creating PSETS
  • Experience in designing, developing, execute and maintain data extraction, transformation, and loading for multiple corporate Operational Data Store, Data warehousing, and Data mart systems.
  • Extensive knowledge of Mainframe tools and techniques as well as Unit regression testing.
  • Experience in EME, checkins, checkouts, command line interface, air commands and Dependency analysis.
  • Well versed with various Ab Initio parallelism techniques and implemented number of Ab Initio Graphs using Data parallelism techniques
  • Experience in integration of various data sources such as flat files, ASCII, EBCDIC files, XML files, DB tables etc.
  • Strong Experience in working with Business Objects.
  • Strong Experience in working with Autosys, CA7.
  • Experience with UNIX shell scripts, AutoSys JIL scripts and XML
  • Developed Unix Shell scripts, Perl scripts and SQL control files to load data through SQL Loader.
  • Worked on Metadata Importers for importing metadata from an EME Technical Repository and other sources like ETL tools (Informatica), Reporting tools (Cognos, SAS, Business Objects etc) and databases (Oracle, Teradata, DB2 etc.)
  • Experience in defining, creating, documenting, verifying and executing Test cases and work with development team to resolve product issues, create basic test plan and performing functional testing, Integration testing and performance testing.
  • Extremely effective in System Development Life Cycle (SDLC) from analysis, design, development, testing and implementation in diverse range of software applications.
  • Extensively used Control-M and Autosys for job management
  • Quick learner and ability to meet deadlines and work under pressure.
  • Experience with databases like Teradata 14, 13.10 and Oracle 9i/11g.
  • Knowledge of System Analysis and Design and Object Oriented Analysis & Design.
  • Working Knowledge of Cognos and Informatica.

TECHNICAL SKILLS:

ETL Tools Ab Initio GDE 3.1.5/3.0, Oxygen XML Editor 11.2, SQL server: 2000/2005/2008/2012, Toad, Teradata SQL assistance, Bteq, Fastload, MultiloadControl-M, Autosys, CA7.

Database Oracle 11i/10i/9i, SQL Server, Teradata, Mainframes: Languages C, C++, JAVA, SQL, PLSQL

Scripting Languages UNIX/Shell script, HTML/DHTML, XML, SQL: Operating Systems Windows XP, UNIX (IBM AIX, Solaris 9.0/10.0, LINUX)

Testing Tools Quality Center: Source control tools EME (Enterprise Meta Environment), and PVCS

Data Modeling ERWIN 4.1, ERStudio 8, Visio: Version control Tools Microsoft Visual SourceSafe

PROFESSIONAL EXPERIENCE:

Confidential, Riverwoods IL

Sr. Ab Initio Developer

Responsibilities:

  • Worked on the Production Enhancement fixes and High Priority Immediate fixes for issues in Production.
  • Involved in analysis of end user requirements and business rules based on given preliminary design, documentation and working closely with tech leads and data analysts in understanding the current system.
  • Used Ab Initio GDE to generate complex graphs for transformation and loading of data into Staging and Target Database areas for Confidential Applications.
  • Enhanced the Existing Application with new changes as per the Business requirements.
  • Worked on Creating the Design Addendum once the Applications are developed.
  • Created the detail design documents and run books for generic jobs.
  • Developed Ab Initio jobs for loading and extracting data from various data stores like DB2, Oracle.
  • Designed SCD type 2-dimension data flows for data ware house and designed Fact data flows to Datawarehouse.
  • Performed Unit Testing and responsible for the promotions to QA environment.
  • Support and Maintenance of more than 40 ETL applications in production environment.
  • Well versed in recovering applications for any technical failure or due to data issue.
  • Expertise in de-bugging applications whenever there is wrapper script or Ab Initio graph failure.
  • Involved in performance tuning of Ab Initio graphs.
  • Responsible for coordinating with Database Administrator (DBA) and System Administrator (SA) teams in maintaining applications and data warehouse on Oracle and Teradata.
  • Involved in Code reviews, Test reviews and coordinated with System Testing team in providing break-fix.
  • Development of ETL process and UNIX scripts.
  • Developed the Autosys JIL scripts for the new jobs in all the environments.
  • Working on DQE projects to help end user in generating issue reports
  • Preparation and maintenance of coding standards check list and actively participated in defect prevention (DP) activities.
  • Provided on-call support.
  • Coordinated with source, down-stream and business teams with respect to data issues.
  • Actively involved in application support during a mega outage of server movement.
  • Deployed and ran the graphs as executable Korn shell scripts in the applications system.
  • Have experience working in onsite-offshore model.
  • Have a very good experience in writing and reading from HDFS using Abinitio Components.
  • Developed generic Sqoop scripts to fetch the data from Oracle DB tables to HDFS

Environment: Ab Initio Version 3.1.5, Korn shell scripting, Co>Operating System- Version 3.1.1.6, UNIX, Oracle 10g, Metadata Hub, Teradata, Pure Scale DB2, DB2 on Mainframes V10.

Confidential, Atlanta GA

Ab Initio Developer

Responsibilities:

  • Developed and Modified existing graphs as per the business requirements graphs using Ab Initio components
  • Involved in QA environment with QA team and completed unit testing of each graph.
  • Extensively used AIR commands to check-in/check- out & other EME related operations
  • Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects.
  • Extensively used components and various editors of component parameters for development of graphs.
  • Worked with De-Partition Components like Gather, Merge which will be used for adding the files which is done partition for fast process of data files.
  • Done appropriate unit-level testing of work products and the management of the review process for the Ab Initio deliverables.
  • Responsible for effective communication between the offshore and the onshore team.
  • Scheduled ETL batch jobs using Autosys, Control-M tool.
  • Coordination with multiple teams like Development, PSO, DBA, Main Frames, CA7.
  • Exposure to BRE (Business Rule Environment), ACE (Application Configuration Environment) and DQE (Data Quality Environment) products.
  • Updating DMLs and XFRs to the existing Graphs according to the customer requirements. Used generic plans to extract data from different source systems and load
  • Used Lookups with Reformat component for fetching matched records based on the downstream process.
  • Worked with Partition components like partition by key, partition by Expression. Efficient use of Multi files system, which comes under Data Parallelism.
  • Interacting with Business users to understand each Interface in detail.
  • Understanding various applications to migrate them to Data Lake environment.
  • Validating business requirements before moving them to Atlas Data Lake.
  • Creating Ab Initio Psets to ingest files to Hadoop Lake file system.
  • Developing Ab Initio graphs and plans to fulfill business demands.
  • Reading and writing HDFS file system as part of validating applications.
  • Scheduling jobs in CA7 Automation tool to automate processes as per application requirements.
  • Have a very good experience in writing and reading from HDFS using Abinitio Components.
  • Performed Proof of Concept on Data Extraction from DB2EE, PDOA Tables to Hadoop Platform.
  • Created Hive Tables with partitions on HDFS Structure using Definitions from Oracle DB.
  • Importing the Catalog, Custom Catalog, Roles and Privileges Feeds for the Database (Oracle and Teradata) and to appear the Databases in the Physical Assets Hierarchy.
  • Extensively used UNIX Shell Scripting for writing SQL execution scripts in Data Loading Process.
  • Customizing the Metadata Explorer in order for the Business user to explore and analyze the Metadata and to see the contents of the system and applications and drill down in to details of the object.
  • Creating new feed files for importing the metadata on the command line and also in the Metadata Portal
  • Creating rule files for Transformations and importing the feeds.
  • Creating Data Source Connection files for connecting to the graphs in order to extract the Metadata
  • Generating Metadata Reports and auditing.

Environment: Ab Initio Version 3.1.5, Korn shell scripting, Co>Operating System- Version 3.1.1.6, UNIX, Oracle 10g, Metadata Hub, Pure Scale DB2, DB2 on Mainframes V10.5, Windows 7 Professional, Control-M, MS Share Point, Agile Methodology(Rally) and HP Quality center, HIVE 1.2, SQOOP 1.4, HortonWorks DP 2.7, Red Hat Linux, CA7.

Confidential, Chicago IL

Ab Initio Developer

Responsibilities:

  • Worked on the Production Enhancement fixes and High priority Immediate fixes for issues in Production.
  • Involved in analysis of end user requirements and business rules based on given preliminary design documentation and working closely with tech leads and data analysts in understanding the current system.
  • Used Ab Initio GDE to generate complex graphs for transformation and loading of data into Staging and Target Database areas for CCTI Applications.
  • Created a generic Ab initio job for automation testing like compare source and target tables, duplicate check in target.
  • Enhanced the Existing Application with new changes as per the Business requirements.
  • Worked on Creating the Design Addendum once the Applications are developed.
  • Created the detail design documents and run books for generic jobs.
  • Developed Ab Initio jobs for loading and extracting data from various data stores like DB2, Oracle.
  • Designed SCD type 2 dimension data flows for data ware house and designed Fact data flows to Data ware house.
  • Performed Unit Testing and responsible for the promotions to QA environment.
  • Used PDL and Shell interpretations to resolve the graph level parameters.
  • Created test cases and data validation for UAT.
  • Worked with Production Service and Automation teams to debug issues in production and for migrations from Pre-prod to Production.
  • Used Control-M as a job scheduler to automate the daily, weekly and monthly jobs.
  • Analyzed schedules in Control-M to check for dependencies, modified to add dependencies on new jobs using xmls.
  • Worked with Configuration Management team for code releases.
  • Expertise in Ab-initio Product Data Quality and Metadata Hub upgrades, view customization, extractor's registration, Metadata Hub Lineage and Metadata hub Import creations.
  • Involved in Teradata Query Tuning and tuned complex Queries, and Views, and implemented Macro's for reduce Parsing time. Developed stored procedures using PL/SQL and driving scripts using Unix Shell Scripts.

Environment: Ab Initio CO>OP 3.1.7.2, GDE 3.1.5, DB2, UNIX, QTP, Mainframes, Metadata hub Teradata, SQL server, Cognos, Control-M, Clear Quest, Service-Now, TOAD for DB2 6.1

Confidential, Greenville SC

Ab Initio Developer

Responsibilities:

  • Involved in migration all objects in the system to latest version of Co-op ( V2.0 toV3.2.7).
  • Analyzing the current architecture and functionality of the system and proposing with multiple design approaches for implementation of Parallelization in the system.
  • Implementation of the parallelization for performance optimization of system using Conduct IT.
  • Created multiple test cases for performance testing in terms of volume of incoming data.
  • Created new graphs to integrate to a new application (Smart Sensor) using Web Services components.
  • Single point of contact for maintenance/support of Web Services application.
  • Worked on gathering requirements for BAU enhancements.
  • Worked on Sprint planning with the team for each release.
  • Have extensive experience in decoding, analyzing, design and development in a Migration of .Net based project to Abinitio.
  • Creating the FSD (Functional Specification Document) and LLD (Low Level Design Document) for existing system for better understanding.
  • Leading the project as a whole from front end and backend perspective taking the project delivery responsibility.
  • Worked with QA team in performing the SIT and UAT testing for each release.
  • Preparation of Implementation Plan and Operational Readiness Documents.
  • Production deployment of the application.
  • Provided Warranty Support.
  • Major/Minor bug fixes in production.

Environment: Ab Initio CO>OP 3.1.7.2, GDE 3.1.5, DB2, UNIX, QTP, SQL server, Service-Now, Control-MTOAD for DB2 6.1, .Net

Confidential

ETL Developer

Responsibilities:

  • Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
  • Developed Ab Initio graphs in accordance to the Business requirements and worked on Unit testing and as well as system testing.
  • Played a key role in overall design of the entire application
  • Wrote multiple Ab Initio transforms to covert currency values coming from different countries.
  • Lead the design and development effort to consolidate all business rules into a common XFR for re-usability.
  • Configuring Ab Initio Config files to interact with Teradata database.
  • Worked on Common Extract and Load Graphs from a Teradata database.
  • Reviewed and helped define test cases for system test and UAT.
  • Played a key role in database design for tables used for reporting purposes
  • Responsible for code reviews across all modules of the application.
  • Anticipated and prepared teams through changes (requests from client, scope of work, adjustment in deadlines, etc.)
  • Identified and applied best practices to issues at hand. Generated new perspectives and frameworks that allow problems to be solved. Makes difficult ideas and concepts easy to understand (e.g. using diagrams, analogies, etc.)
  • Integrated requirements from multiple subject areas/business areas to define solution requirements.
  • Facilitated and negotiated the resolution of conflicting requirements and out of scope requirements.

Environment: Ab Initio CO>OS 2.13, GDE 1.13 Oracle9i/8i, UNIX, Teradata, DB2, Mainframe

We'd love your feedback!