Ab Initio Developer
Resume:
Naveen
Ab Initio Developer
*******@*******.***
Professional Summary
Around 8 years of IT experience in the Analysis, Design, Development, Implementation throughout various phases of project life cycle
ETL expertise with excellent exposure to Ab Initio in high volume, parallel processing data environments.
Extensive experience of coding using ETL Tool – AbInitio Proficient with various Ab Initio Parallelism and Multi File System techniques.
Expertise in all components in the GDE of Ab Initio for creating executing testing and maintaining graphs in Ab Initio and experience with Ab Initio Co-operating System in application tuning and debugging strategies.
Developed wide variety of DML’s for data from different sources.
Used various Ab-Initio components of partition, de-partition, database, datasets, transform, sort to build graphs in GDE and runs those graphs in UNIX environment. Used the Ab-Initio Web Interface to Navigate the EME to view graphs, files and datasets and examine the dependencies among objects.
Experience in providing production support to various Ab Initio ETL jobs and developing various UNIX shell wrappers to run Ab Initio.
Worked in Enterprise metadata environment (EME) environment for check in and check out of the sandbox, graphs and versioning of the graph.
Having Hands on experience with agile development methodology.
Good exposure to relation database SQL. Designed database, tables and views structure for the new data mart using Oracle.
Experience in writing basic SQL Queries.
Clear understanding of business procedures and ability to work as an individual and with the team.
Varied experience in gathering business requirements, mapping them to design specifications, Design & Code reviews and developing the test cases for unit and string tests based on requirements.
Handled Batch processing projects and the various NDM/FTP involved getting and sending source and targeting data according to requirement
Worked on creating jobs/jils and scheduling the projects as per requirement in Autosys schedulers.
Good exposure in working with different databases – Oracle, DB2.
Capable of learning new technologies in a very short time
Good Communication Skills and Strong interpersonal skills to deal effectively with a broad range of contacts from technical staff, to clients, and management.
Technical Skills:
ETL Technologies: Ab Initio
Databases: Oracle, DB2
Programming Languages: UNIX ShellScripting
Operating Systems: Windows, Linux
Scheduling Tools: Autosys, CA7 Scheduling
Professional Experience
Client: Truist Bank, Charlotte NC Jan 2020 – Till Date
Ab Initio Developer
Responsibilities:
Created complete design documents which contain details about data flow diagrams, job flow, normalization efforts, completed object lists and performance improvement steps for applications
Worked on enhancement Code changes, code check ins, deployment and providing support in case of defects found.
Handling multiple scrum team tasks and working on implementing changes to Abinitio components.
Worked with the offshore coordinators to ensure the tasks were completed in a timely manner by the offshore team without compromising quality
Providing weekend On-call support, worked on Deployments, SR Tickets and handing over batches to offshore teams as per schedule.
Involved in the implementation of complex ETL rules and logic using Ab Initio, UNIX and SQL
Closely coordinated with the client teams - database administrators, system analysts, and business analysts to articulate and moderate the requirements analysis for the work to be carried out offshore
Provided an exact estimate of the number of resources required for knowledge transitions, designs, builds, production support and monthly enhancements during analysis and post production phase
Interacted with Ab Initio support for various co-op upgrade issues, follow up and various solutions.
Created Sandbox and edited Sandbox parameters according to repository Extensive exposure to EME.
Used AIR commands to do dependency analysis for all ABI objects
Client: Fidelity, Boston MA Feb 2018 – Dec 2019
Ab Initio Developer
Responsibilities:
Responsible for interacting and discussing with Business Team to understand the business process and gather requirements. Developed and documented a high-level Conceptual Data Process Design for the projects.
Responsible for creating and executing development plans
Excelled guiding and managing technical resources within project schedule and budget.
Scheduling status meeting to get the status updates and discuss ongoing issue and blockers with the offshore team.
Responsible for updating project manager regarding status of development efforts.
Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards.
Handled the tasks of identifying system deficiencies and implementing effective solutions.
Migrated data between Databases.
Analyzing the method of transforming existing data into a format for the new environment and the loading of this data into other database structures.
Reviewing existing migration tools and providing recommendations for improving performance of the migration process.
Wrote several Shell scripts, to remove old files and move raw logs to the archives.
Providing necessary change and support documentation
Scheduled and executed Abinitio graphs as batch jobs using Autosys.
Created load ready files from oracle databases, created direct dumps of the data and loaded into SQL server.
Handled the responsibilities of managing technical risks throughout the project.
Drove impressive improvements across the business as a result of IT implementations.
Created cost-benefit analyses and ROI assessments that were used as the basis for decision-making on proposed IT implementation projects.
Created Ab Initio applications also made graphs generic by incorporating parameters into the graphs and adopted the best practices to enhance performance for the graphs.
Developed Conduct>IT plans and sub-plans by integrating graphs, scripts and programs.
Conducted and participated in design reviews to support Best Practices.
Performed code reviews and supervised junior developers
Used DQE to access data sources from files and join data sources to perform Data Quality analysis.
Worked on using SQL as well as Dataset APIs to interact with various SQL’s.
Performing Unit testing and involved in the System Integrated testing and regression testing to make sure downstream applications are not impacting.
Scheduled jobs using Operational Console (OC) and Control Center (CC)
Environment: Ab Initio 3.2.6 with Co>Op 3.2.6, Express>IT 3.2.6.1, Hadoop, Oracle 11g, Teradata 13.10, UNIX, Windows, Control Center 3.2.2.2.
ETL Developer Jun 2016 – Jan 2018
Client: Discover Financial Services, Riverwoods, IL
Responsibilities:
Worked on ETL tool Ab Initio to build applications to load data from different sources Text files, Cobol files to staging and staging to Data warehouse
Actively participated in business requirements discussions with vendors in grooming, sprint planning and demo session.
Documented detail design documents and Source to target mappings
Extensively used Abinadi Parallelism feature of Component, Data and Pipeline parallelism.
Used Different Ab Initio Components like Partition by Key and Sort, Dedup, Rollup, Scan, Reformat, Join in Various Graphs.
Used components like run program and runsql components to run UNIX and SQL commands in Ab Initio
Performing transformations of source data with Transform components like Join, Match Sorted, Dedup Sorted, Denormalize, Reformat, Filter-by- Expression
Created various Ab-Initio Multi File Systems (MFS) to run graphs in parallel.
Responsible for release creation and code migration to higher environments
Supported the product verification team during system and integration testing
Responsible for Production incident resolution documents for critical Production issues
Used Autosys for version control.
Documented the design specifications for the jobs developed and maintained run books for production support.
Used Autosys to schedule Jobs to invoke the AB-Initio Jobs as well as UNIX shell scripts in sequence
Fine-tuned the time taking SQL queries in production.
Responsible for deployment guide for the release.
Participated in Unit testing, QA, UAT testing and Code migration activities
Environment: Ab Initio GDE 3.3.3, Co>Operating System 3.5.3, Autosys, UNIX, Teradata
ETL Developer May 2013 – April 2015
Client: Genpact
Responsibilities:
Worked for Datoteca migration project for Banamax. that involved support projects
Extensively involved in all the phases of development, right from HLD preparation to Prod support
Preparing ETL mappings required for Data Warehouse by coordinating with business analysts
Extensively used AbInitio Parallelism feature of Component, Data and Pipeline parallelism.
Documented detail design documents and Source to target mappings
Developed high quality code using Ab initio graphs, reusable graphs, psets, dmls, ksh scripts and plans with very low defects and in given timeline.
Used Different Ab Initio components like partition by key and sort, dedup sorted, rollup, scan, reformat, join, lookup file in various graphs
Extensively used Partitioning Components like Broad Cast, partition by key, partition by Range, partition by round robin and Departition components like Concatenate, Gather and Merge in Ab Initio.
Created various Ab-Initio Multi File Systems (MFS) to run graphs in parallel.
Created test scenarios that were used to validate the Ab-Initio graphs.
Used EME for version control
Responsible for tag creation and code migration to higher environments and provide support for warranty period.
Created and Executed Ab initio PLAN to schedule run of E2E migration process.
Responsible for deployment guide for the release.
Participated in Unit testing, QA, UAT testing and Code migration activities.
Responsible for knowledge transfer sessions for Production support team
Created multiple psets to invoke the template Jobs
Created UNIX scripts to execute the AB-Initio Jobs developed
Environment: Ab Initio GDE 3.1.3.2, Co>Operating System 3.0.3.9, Autosys, UNIX, Oracle 11g
Contact this candidate