We provide IT Staff Augmentation Services!

Module Lead/ Ab Initio Programmer Resume

Warren, NJ

PROFESSIONAL SUMMARY:

  • I have more than 8 + years of hands - on experience on Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high-volume of data processing applications.
  • Experience in full life cycle of software design process (SDLC) including requirement gathering, design, development, documentation, implementation and Testing.
  • Hands on experience on various Ab Initio components, EME, PDL, XML Data and worked on both serial file system & multi file system.
  • Implemented various UNIX shell scripts for job control and for automation various manual tasks.
  • Worked on Schedulers for jobs automation processes Using Autosys and crontab.
  • Investigating ETL job failures due to resource constraints, missing/invalid data/files, and bugs and infrastructure component issues on time to meet the SLA’s.
  • Interaction with Client to discuss critical issues and taking the acknowledgement and providing the resolution and provide Daily/weekly status report to Customer.
  • Have worked with different source/target systems and written complex transformations/transform functions.
  • Working on in house rules engine/frame work called RULES HARMONY.
  • Having good knowledge on Data warehouse concepts like Star Schema, Snow Flake, Dimension and Fact tables.
  • Proven abilities at Guiding, Leading, Mentoring, and Training ETL Trainees inside the team and across.
  • Quick learner and highly motivated individual with ability to handle challenges as an individual (or) team contributor. Good in analysis and debugging skills.

TECHNICAL SKILLS:

ETL Tools: Ab-Initio ( 3.0.3/3.0.4/3.2.2.9/3.2.5.7)

Database: SybaseIQ, Oracle

Version Control: EME, SVN, Bit Bucket

Scheduling Tools: Autosys, Crontab

Scripting: UNIX Shell Scripting

Other Tools: CA Workload control center, JIRA, SQL Developer, and PUTTY, Interactive SQL

Programming Languages: SQL, JIL, Core Java

Domain Experience: Banking and Financial Services (BFS) and Mortgage

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Module lead/ Ab Initio Programmer

Responsibilities:

  • Participated in SAS to Ab Initio Migration as part of the project.
  • Designed and developed automated processes to extract, transform and load data with appropriate error handling mechanism.
  • Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
  • Translating the functional requirements into mapping designs.
  • Developed generic graphs with PDL features, Re-usable shell scripts to reduce development efforts & re-usability.
  • Redesigned the existing graphs for performance improvements.
  • Design and develop ETL jobs which extract information from Oracle Database, Sybase Database, flat files and load them into application specific tables and/or create files to be transferred to downstream systems.
  • Responsible for performing ETL unit and development tests, monitors results and take corrective action, when necessary.
  • Responsible for all the UAT and Production deployments and Post-Production Check out.
  • Developed generic graph to compare the result generated from SAS and Ab Initio which helped to validate the results
  • Responsible for delivery of all enhancements, maintenance and meeting SLA on all support related incidents.
  • Co-ordination of development work with team members, review ETL jobs, and create shell scripts for scheduling jobs.

Confidential, Warren, NJ

Module lead/ Ab initio Programmer

Responsibilities:

  • Developed generic graphs with PDL features, Re-usable shell scripts to reduce development efforts & re-usability.
  • Developed monthly and daily batch graphs since LLR application runs on daily and monthly basis.
  • Participating in periodic meetings, maintaining all applications for production, and planning appropriate strategies.
  • Investigating ETL job failures due to resource constraints, missing/invalid data/files, and bugs and infrastructure component issues.
  • Ensure root cause analysis is done and that proactive/preventative measures are taken to avoid a reoccurrence.
  • Created Job Information Language (JIL) and capabilities to recommend suggestions that will comply with internal standards and best practices.
  • Coordinating with other teams as the LLR module takes the source data from the other applications.
  • Responsible for delivery of all enhancements, maintenance and meeting SLA on all support related incidents.
  • Prepared the mapping documents as the application is under migration to Java.
Confidential

Ab initio Developer

Responsibilities:

  • Design and develop process to create scenario files using the market factors, shocks and Spreads given by Risk Analytics.
  • Design and develop the processes to extract, transform and create transaction request for OTCs/SFTs.
  • Responsible for Running the process and generate the stress results using VCS (Var Calculation Service) engine for given scenarios.
  • Responsible for validating the results and submission to the Risk Analytics.
  • Developed generic graphs with PDL features, Re-usable shell scripts to reduce development efforts & re-usability.
Confidential

Jr Ab initio Developer

Responsibilities:

  • Prepared the internal mapping Documents as part of the analysis and design phase.
  • Developed generic graphs with PDL features, Re-usable shell scripts to reduce development efforts & re-usability.
  • Have written the Unit test cases to make sure the business logics implemented properly.
  • Involved in code migrations to UAT and PROD environments.
  • Investigating ETL job failures due to resource constraints, missing/invalid data/files, and bugs and infrastructure component issues.

Hire Now