Ab Initio Sample Resumes – Ab Initio Developer Resume Samples

Ab Initio Sample Resumes – Ab Initio Developer Resume Samples. Here Coding compiler sharing a very useful Ab Initio Resume Sample for Ab Initio professionals. This is the original Ab Initio Developer sample resume contains real-time Ab Initio projects. You can use this Ab Initio resume as a reference and build your own resume and get shortlisted for your next Ab Initio job interview. All the best for your future and happy learning.

Ab Initio Sample Resumes

Ab Initio Developer Resume Profile Summary:

  • 3 +  years of professional experience in Application Development and Maintenance as  Abinitio Developer having extensive experience in Development, design and Production support in banking-finance and telecom domain.

Related Article: Ab Initio Interview Questions

Ab Initio Developer Resume Technical Skills & Responsibilities

  • 3 + years of professional experience in Application Development and Maintenance as Abinitio Developer for Client – CITI bank and AT&T.
  • Have extensive experience in Development, design and Production support.
  • Involved in preparation of HLD(High-level design), DD(Detailed Design), AID (Application Interface Document) for complex projects.
  • Have good knowledge of Telecom, Billing and Customer Care domains.
  • Have experience in Development on Abinitio and related technologies like – Abinitio, Conduct > It, Unix, Linux, SQL, Perl, Connect-Direct (NDM), etc.
  • Proficiency and experience in Ab initio development, code debugging, testing and handling EME metadata
  • The expertise of working on both GDE and background co-op (Unix).
  • Worked on below Abinitio features – Multi Files and parallelism, Batch/Continuous graph development, Plans, Queue processing, DB activities through the graph, FTP feature, RPC/JMS publish-subscribe features
  • Graph development and debugging using watcher, isolation and breakpoints.
  • Use of m_commands to create scripts
  • Conduct > It – worked on plans, sub plans, tasks and their handling using advance concepts Of Conduct>It.
  • Worked on SPLUNK– BI and Operational Intelligence tool

Ab Initio Sample Resume Projects

1) Ab Initio Sample Project – I

  • Optima DA – Finance Risk management
  • Client – CITI Bank
  • Project overview –

Optima is Citibank’s data warehousing solution for financial risk management. Optima DA is the initial layer of Optima application suit which receives inputs from 83 sources. It does data validation, cleansing and enrichment and stores feed into oracle database. Reporting graphs fetches data from the oracle DB and stores the reports in Sybase DB where historical data is maintained.

  • Responsibilities –
  • Attended business meetings with the client to understand business needs.
  • Involved in HLD preparation and application dependency check meetings.
  • Delivering KT to prod team on new features
  • Created MDD and TDD documents
  • Experience in Release activities and Rapid deployment.

Ab Initio Sample Project – II

  • UUP – Unlimited Usage Processing
  • Client – AT & T
  • Project overview –
  • Overview –

UUP is the product developed for big data processing. It processes ~550 M records per day. To handle this much big data, the feature ICFF files is used also load sharing has been handled using multifile system. UUP uses both continuous and batch graphs. Continuous graphs serve the queries of customer care or clients online while batch graphs send the bills to billing end. IDB uses features like RPC publish – RPC subscribe, Queue processing, Cache – Lookups.

Responsibilities –

  • Attended business meetings with the client to understand business needs.
  • Involved in HLD preparation and application dependency check meetings.
  • Created DD and AID documents for the CR
  • Developed CRs involving FTP activity, DB activity, and various transforms, new fields addition inflows, Report generations.
  • Extensive experience in Release activities and Rapid deployment.
  • Worked on critical and medium production issues and provided fixes.

Ab Initio Sample Resume -2

Ab Initio Sample Resume Profile Summary:

  • B.E. (Computer Science) professional with 9 years of experience in the area of data warehousing and application development.
  • Currently working with JP Morgan Chase, Mumbai as Associate.
  • Strong Technical skills with full life cycle experience on enterprise-wide projects. Extensive experience working across various roles such as Project Lead, Team Lead, Senior Ab Initio developer, Off-shore coordinator.
  • Very strong analytical skills and the ability to design and implement complex processes.
  • Demonstrated ability to understand business problems, goals, IT strategy, issues, and priorities.
  • Diligent communicator with strong relationship building & leadership skill and multi-tasking abilities.
  • Hands-on experience in all the stages of SDLC lifecycle such as requirements gathering, project estimations, design, and development, Integration Testing, SIT, UAT Production implementations.
  • Good understanding of Relational and Logical/Dimensional Data Modeling.
  • Experience in working in a cross-functional team environment, provide mentoring, conducting performance appraisals, knowledge transfer sessions, provide leadership and support in DW solutions.
  • Experience in projects involving migrations from one ETL tool to others & also in tool upgrade.

Ab Initio Developer IT SKILLS

Platforms: UNIX AIX Version 5.3

Tools: Ab-Initio v3.0, BRE (An Ab-Initio Tool), Oracle 10g, Datastage 7.1 Server E-Edition, Datastage 7.5 Enterprise Edition, Basics of Business Objects & SAP BW

Languages: UNIX Shell Scripts, C, SQL, PL/SQL, HTML

Scheduler: Control-M, Autosys

Ab Initio Sample Projects For Resume

Project 1: Replatform Upgrade (NA  Region)                

Role:    ETL Lead

Project Scope: The BASEL reports mainly indicate and quantify the market, credit and operational risk taken by the local JPMC entity and the adequate capital earmarked and kept aside to address and mitigate the risk, if it arises.

This project implements Reveleus strategic Basel platform which provides automated Basel II/Basel III/RBC/CAR calculations and reporting for APAC countries Legal Entities.

This solution provides a robust & efficient platform to address regulatory directive. This solution/project provides a fully automated data sourcing, calculation and reporting solution for Finance regulatory reports that meets the mandated requirements of the regulators.

Key Result Area

  • Actively involved in devising end to end ETL framework.
  • Prepared common generic graphs/scripts to avoid redundancy and for process standardization.
  • Handled crucial subject areas.
  • Provided guidance to the team and prepared checklists to avoid end to end integration issues later on.
  • Prepared custom made scripts to generate psets/dmls in order to reduce overall development effort and to enforce standardization.
  • Initiated self-reviews and peer-reviews against standard checklists.

Significant Highlights

  • Analyzed the data model and helped the designers to reduce the gap between data model and source to target mapping.
  • Established the accountability at individual level.
  • Worked closely with the team in order to achieve simple and efficient ETL solution.
  • As the project involves multi region phase wise implementation, preparation of generic graphs at the early stage helped to reduce the development effort and to switch the focus towards data quality and robustness.

Designing generic architecture for ETL to handle multi region with minimum coding effort for the subsequent

Project 2: Multi Region Basel Implementation (APAC Region)                   

Role:    ETL Lead

Proejct Scope: The BASEL reports mainly indicate and quantify the market, credit and operational risk taken by the local JPMC entity and the adequate capital earmarked and kept aside to address and mitigate the risk, if it arises.

This project implements Reveleus strategic Basel platform which provides automated Basel II/Basel III/RBC/CAR calculations and reporting for APAC countries Legal Entities. This solution provides a robust & efficient platform to address regulatory directive. This solution/project provides a fully automated data sourcing, calculation and reporting solution for Finance regulatory reports that meets the mandated requirements of the regulators.

Key Result Area

  • Actively involved in devising end to end ETL framework.
  • Prepared common generic graphs/scripts to avoid redundancy and for process standardization.
  • Handled crucial subject areas.
  • Provided guidance to the team and prepared checklists to avoid end to end integration issues later on.
  • Prepared custom made scripts to generate psets/dmls in order to reduce overall development effort and to enforce standardization.
  • Initiated self-reviews and peer-reviews against standard checklists.

Significant Highlights

  • Analyzed the data model and helped the designers to reduce the gap between data model and source to target mapping.
  • Established the accountability at individual level.
  • Worked closely with the team in order to achieve simple and efficient ETL solution.
  • As the project involves multi region phase wise implementation, preparation of generic graphs at the early stage helped to reduce the development effort and to switch the focus towards data quality and robustness.
  • Designing generic architecture for ETL to handle multi region with minimum coding effort for the subsequent regions.

Project 3: EMEA TP (EMEA Transfer Pricing)                                                    

Role: ETL Lead

Project Scope: The Strategic Fund Transfer Pricing Program has been developed to address a major pain point in various departments including T&SS / IB Finance, Global Treasury, Chief Investment Office (CIO) as well as LOB Business and Legal Entity Controllers on Fund Transfer Pricing.

This project will enhance overall process efficiency on Regional Fund transfer Pricing to align with global strategy. This will build a flexible and scalable financial platform to support New Business Expansion initiatives.

This solution will develop a Global Transfer Pricing Model for consistent transfer pricing methodology, for transparent system to review, reconcile and compare LOB results and move to daily transfer pricing from current disparate transfer pricing models

Key Result Area

  • Leading In-house and vendor resources.
  • Actively involved in devising end to end ETL framework.
  • Prepared common generic graphs/scripts to avoid redundancy and for process standardization.
  • Handled crucial subject areas.
  • Provided guidance to the team and prepared checklists to avoid end to end integration issues later on.
  • Prepared custom made scripts to generate psets/dml’s in order to reduce overall development effort and to enforce standardization.
  • Initiated self-reviews and peer-reviews against standard checklists.
  • Conduct Knowledge transfer sessions to Operate/Support Team.

Significant Highlights

  • Analyzed the data model and helped the designers to reduce the gap between data model and source to target mapping.
  • Established the accountability at individual level.
  • Worked closely with the in-house & vendor teams in order to achieve simple and efficient ETL solution.
  • As the project involves multi regional implementation, preparation of generic graphs at the early stage helped to reduce the development effort and to switch the focus towards data quality and robustness.

Project 3: LIBRA EMPort (Expense Management Portal)

Role: Team leader

Proejct Scope: 

To design and implement an existing system built on data stage, PL/SQL and UNIX to abinitio.

To upgrade the existing job scheduler Autosys to controlM.

Key Result Area

  • Devised and implemented entire Ab-Initio ETL process with focus on key areas
    • Streamlining the existing system
    • Accountability at record level
    • Performance enhancement
    • Controlled processing with more informative logs
    • Customer Service Standards
  • Redefined the dependencies by analyzing Autosys JIL scripts to suit ControlM requirements.
  • Analyzed data stage jobs, defined transformation rules and designed the system with better audit control.
  • Analyzed PL/SQL procedures used to build the complex hierarchy processes and redesigned and developed them in Ab-Initio.
  • Designed and developed scripts to move history data from old environment to new one.
  • Helped to configure and setup the environment of the new system.
  • Identified areas of quality and took steps to correct & prevent the occurrence.

Significant Highlights

  • Spearheaded the up gradation of an in-house project called EMPort end to end.
  • Built cohesive team that effectively developed and implemented the application, which resulted in short transition times and enhanced customer satisfaction.
  • Managed to meet the challenge of building a system to be fully developed from offshore for the first time.

Project 4: FDW (Finance Data Warehouse)

Role: Team member

Project Scope:

To understand the FDW system and to support enhancement activities

Key Result Area

  • Analyzed wrapper scripts and ETL processes in order to understand FDW technical framework.
  • Prepared shell scripts to load the audit tables dynamically.
  • Provided support for some processes.
  • Worked on enhancement activities.
  • Helped newly joined team members with the understanding of FDW architecture.

Significant Highlights

  • Have shown quick learning ability to understand the system and to provide support for some aligned processes.
  • Worked as a cohesive unit to streamline the processes.
  • Identified the scope of automation and worked on achieving them.

Project 5: ETL Migration

Role: ETL Lead

Proejct Scope:

 System performance improvement program to reduce SLA by 50%

Solution Environment: Datastage Server 7.1 Edition, Datastage 7.5 Parallel/Enterprise Edition.

Key Result Area

  • Generate Export Dumps of Applications undergoing Migration using DataStage Manager.
  • Design DataStage ETL jobs in Parallel Environment.
  • Fix the issues in semi migrated jobs in Parallel Environment.
  • Validate the logics used in DataStage Server & its corresponding Parallel Jobs.
  • Maintain issue/resolution logs for each job & develop comprehensive Test case documents for each job.

Significant Highlights

  • Developed strategy to handle performance tuning at all layers
  • Handled migration of multiple phases to Parallel Environment
  • Handled full regression testing and fixed missing functionalities in parallel environment.

Project 6: Reliance GSM & Number Portability

Role: ETL Lead

Project Scope:

In the event of successful achievement of many milestones set for CDMA business, Reliance Communications ventured into GSM business. This project is useful for capturing GSM Customer profile, GSM plan types and customer CDRS, Revenue generation patterns, etc. This project develops consolidated BW Reports for top management and detailed customer-wise BO report for circle users of Reliance Communications.

Solution Environment: Datastage Server 7.1 Edition, Datastage 7.5 Parallel/Enterprise Edition.

Key Result Area

  • Played a major role in Schema Designing of the target Data warehouse.
  • Designed ETL jobs in DataStage Enterprise Edition for extracting data from Oracle and flat files, transforming and finally loading into the target data warehouse.
  • Created re-usable components using Shared containers for local use.
  • Developed Unix Shell Script to transpose the data in the required format.
  • Debugging of the DataStage jobs using DataStage Debug Option.
  • Perform Unit Testing of Individual Modules.
  • Provide 24*7 Production Support.

Significant Highlights

  • Developed strategy to handle performance tuning at all layers
  • Worked closely with vendor team to identify scope of improvement.
  • Induced logics for re-usability & creation of generic scripts.
  • Played a vital role in re-designing the application flow that resulted in reduction of SLA.

Project 7: HLR Recon

Role: Senior Data warehouse Developer

Project Scope:                                       

This Project is developed to reconcile the active subscriber base and revenue generated from each subscriber across different source systems of RCOM .This will generate a top-level management SAP-BW report that displays the degree of concurrence between the various source systems. This will steer the source systems to bridge the gap between them to help the business achieve common decision making.

Solution Environment: Datastage Server 7.1 Edition.

Key Result Area

  • Involved in understanding Business Process and coordinating with Business-users to get specific user requirements to build the Data Marts.
  • Created jobs in DataStage to extract from heterogeneous data sources
  • Used Link Partitioner to Partition Data in order to enhance performance of DataStage jobs and Link Collector to collect partitioned data together.
  • Complex queries are written to facilitate the supply of data to other teams.

Significant Highlights

  • Developed strategy to handle performance tuning at all layers
  • Developed Automation scripts for unit testing.
  • Implemented Complex scripts for auto extraction from various source.
  • Played a crucial role in enhancing the transfer of files through Sftp mode.
  • Designed SAP-BW specific plug-ins to provide data.

Project 8:VXP (Voice Exchange Partition)

Role: Data warehouse Developer

Proejct Scope:

This project was developed to build a mechanism to load a very huge volume of data (approx 200 GB). This captures Call Detailed Records i.e. details of each and every call that has landed on Reliance Network.

It is a highly sensitive data used by Vigilance Team round the clock. Due to very huge volume, transformation and loading is done on hourly basis in a temp table. Data loaded on hourly basis is finally loaded into the target table using EXCHANGE PARTITION mechanism.

Solution Environment: Datastage Server 7.1 Edition

Key Result Area

  • Understanding the business rules completely and implemented data transformation Methodologies.
  • Designed Multi Instance jobs in DataStage 7.1 Server Edition.
  • Used Hashed Lookups to perform required transformations.
  • Load Data using OraBulk stage.
  • Develop PL/SQL Procedures to avoid double loading of data and Perform Exchange Partition.

Significant Highlights

  • Developed the entire logic that reduced 2 man-days’ efforts.
  • Created complex PL/SQL procedures for performance improvement.
  • Developed Reject/validation reports for quick TAT for LEA requirements.

Ab Initio Sample Resume – 3

Ab Initio Developer Job Profile & Responsibility: 

The project mainly focuses on ticket resolutions and bug fixing in SLA time. The analysis deals with the job and report failures. Tools used and familiar with are Citrix, Control M, HPSM, EME

  • Handle Production related incident tickets for Unix Applications, troubleshoot incidents, follow up with the daily stream cycle and maintain the application.
  • Had Interacted with the clients for requirements with respect to the project and worked accordingly.
  • Experience in working as Abinitio support personnel and resolved the tickets within SLA.
  • Monitor the Batch Jobs associated with Unix Applications and troubleshoot issues
  • Had participated in Daily incident meetings with the client and also weekly meetings to increase the efficiency of the project.
  • Monitor Systems and ensure any potential issues are proactively monitored and handled in a timely fashion to avoid incidents resulting from them.
  • Create, scheduling and monitoring the daily, weekly and monthly basis batch jobs and related scripts.
  • Create various Business Critical reports for the Applications and have the same sent over to Client’s top management.

Ab Initio Developer CAREER GRAPH

Company COMPANY NAME#
Designation Abinitio Developer and L3 Support
Period 04.04.20xx to 27-11-20xx
Business Line  Banking/Financial Services
Project      CAPITALONE
Team Size 16
ETL Tools    Ab Initio, Metadata Hub, Operational console,BRE
Tools SQLPLUS , TERADATA SQL Assistant , Control M,HPSM ,Putty,Domino
DB ORACLE , TERADATA

EXPERIENCE SUMMARY:

  • 3+ years of IT experience in developing and maintenance Data Warehouse applications using ETL tool Ab Initio.
  • Experience in working as Abinitio Production L3 and developer.
  • Have worked with different source/target systems and written complex transformations/transform functions.
  • Constructed Ab Initio Graphs using components like Join, Lookups, Reformat, Sort, Rollup, Filter by expression, Dedup Sorted, and Replicate etc.
  • Have a good exposure in Performance tuning and troubleshooting methods. Utilized the Phasing techniques to prevent deadlocks in the run time.
  • Experience in installing and configuring Abinitio software and license renewal.
  • Migrating Abinitio code into different environments
  • Have a good Knowledge of Data Warehousing Concepts.

Client:

Capital One – Diversified financial services company offering a broad array of credit, savings and loan products to customers in the United States, UK, and Canada.

Description of the Project:

The project mainly deals with the Enhancement / Maintenance of the applications used by the clients. The Product that my team maintained involves the Change Management / Application development which helps customers in net banking. And also this product gives them the opportunity to pay off their previous debt and also improve the credit history.

Job Profile: 

  • Expertise in Data Warehousing, AB INITIO (ETL) programming, and fulfillment of data warehouse project tasks including Data Extraction, Cleansing, Transforming and Loading. Involved in all stages of SDLC during projects, Analyzed designed and tested the new requirement for performance, efficiency and maintainability using ETL tool AB INITIO.
  • Experience in Ab Initio parallel and serial flow batch graphs, conditional components, other components like Transform, Read and Write XML, Read and Write Multiple files, Partition graphs.
  • Participated in meetings with Users, Business analysts in understanding the business requirements and analyzed use cases to develop detailed Test Plan
  • Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
  • Sandbox features like check in and checkout were used for this purpose
  • Involved in design of various graphs.
  • Extensively used various components like Input, Output (Table/File), Filter by Expression,          Rollup, Sort, Sort with in Groups, Dedup sort, Reformat and Join etc…
  • Bring up the Abinitio environment during DR activity.
  • Performed major role in understanding the business requirements and designing and loading data into Data Warehouse (ETL).
  • Working as ETL Developer in Data loading Phase from ODS into staging area (Source to Staging).
  • Extensively involved in Data Extraction, Transformation and Loading (ETL) from Source to Target systems using Abinitio.
  • Extensively used various components like Input, Output (Table/File), Filter by expression, Rollup, Sort with in groups, Dedup sort, Reformat and Join.
  • Documentation of all modules for user level and system level maintenance.

Rewards and Recognition:

  • Got good appreciation mails from customers during critical issues and failures.
  • Recognized as a good team member to resolve the issues within their deadlines.
  • Rewarded  with “Feather in My Cap Award” for my Excellency towards the team Work

Abinition Consultant CAREER GRAPH :

Company COMPANY NAME#
Designation Abinitio Consultant
Period 05-05-20xx to till now
Business Line  Retails & Marketing
Project     Group M and HSBC
Team Size 4
Tools SSH Tectia Client, Service management,outlook,TRM
ETL Tools Ab Initio (3.1.6 GDE, Co>op 3.1.6) ,Operational console,M-hub ,BRE

Job Profile:

  • Developed new projects of EME model in coordination with designing and technological teams.
  • Assisted in overall designing and development of software applications and systems.
  • Unit testing of codes and creation of test case analysis.
  • Fixing the defects.
  • Handling production issues
  • Facilitating knowledge transfer sessions.
  • Development and enhancement high performance graphs as per requirements.
  • Analyzing the preliminary designs and creating detailed designs.
  • Unit testing of new and enhanced codes.
  • Preparation of Source to Target Mapping documents.
  • Creation of scheduling diagrams and job schedules

Related Sample Resumes:

AWS Sample Resumes

Leave a Comment