Ab Initio Tech Lead - Citibank, USA
(2024-10)
Rules Harmony & Helix (RH & Helix): Rules Harmony allows users to create, modify and manage rules through and intuitive GUI interface, and Helix helps those rules to execute in client's environment. Helix is an advanced Ab-Initio based framework that serves as an processing engine for leveraging the Rules Harmony System. It's a product-based role.
- Understanding the architecture of Rules Harmony and Helix Framework Functionality.
- Working with EAP and Non-EAP Data systems
- Our day-to-day activities involve discussing the requirements and design with the clients as well as with the offshore development team.
- Extensively used Linux commands and scripts to automate the creation of PSETs and execute them as per the business logic.
- Conducted meetings and involved in providing support to the testing team.
- Also interacted with the front-end team and helped them to use the transformed data by the development team.
- Coordinating with various business teams with to make sure the new deployments are accurate and as per the market standards.
- Managing and leading the internal stakeholders as well as the end users.
- Enhancing and Creating Express>IT templates for technology upgrades.
- Ensured the requirements and design is understood by internal stake holders and the projects team by clearly referencing the design with the features covers
Ab Initio Tech Lead - Citibank, USA
(2022-06 - 2024-04)
Disclosure of Interest (DOI): This project is mainly targeted to provide the Securities, Positions interest disclosure information (SPIDER) to the end users in the forms of reporting. It also calculates the same for the reporting purpose used for the Large Options Positions Regulatory (LOPR) Systems. There are many calculations which are dependent on various states and their taxes across the globe and on-going trading transactions.
- Understanding the architecture of the entire DOI system for SPIDER and LOPR Data.
- Our day-to-day activities involve discussing the requirements and design with the clients as well as with the offshore development team.
- Reviewed Ab Initio applications to validate and cleanse the data and transforming the data as per the business rules by evaluating the code of all components like reformat, join, Sort, rollup, scan, lookup, Normalize, partition and de-partition.
- Modifying the existing Ab Initio Graphs / Linux Scripts and SQLs to incorporate new requirements.
- Writing the complex transformations (XFR) and deploying them to the production.
- Providing support to the Production support team by analyzing and fixing the code issues.
- Extensively used Linux commands and scripts to automate the creation of PSETs and execute them as per the business logic.
- Conducted meetings and involved in providing support to the testing team.
- Also interacted with the front-end team and helped them to use the transformed data by the development team.
- Extensively used Autosys to provide the batch support in various environments throughout the SDLC process.
Ab Initio & Informatica BDM Consultant - CIHI (Canadian Institute for Health Information), Mississauga, ON, Canada - Mississauga, ON, Canada
(2021-10 - 2022-05)
The Canadian Institute for Health Information is a government-controlled not-for-profit Crown corporation that provides essential information on Canada's health systems and the health of Canadians. This client's main project is to convert the Ab Initio Code to Informatica BDM on cloud.
- Understanding the project which is developed about 10 years ago using Ab Initio.
- Designing the entire code from scratch in Informatica BDM.
- Extensively working with Java Component of Informatica Developer for the complex code of Ab Initio.
- Establishing the standards and creating the reusable artefacts, and Providing the usage guide on all the above applications
- Creating the couple of Proof of concepts for business
- Worked on Oracle PL/SQL procedures to apply business rules, Ab Initio Metadata Hub Lineage extensively to understand the project flow.
- Review of the artifacts. Supported the System testing, involved in performance tuning of Ab Initio jobs, preparing unit test cases, and unit testing.
- Conducted the training on the tool for the new-comers.
Ab Initio Lead - BMO (Bank Of Montreal), Mississauga, ON, Canada - Mississauga, ON, Canada
(2020-05 - 2021-08)
The Bank of Montreal is a Canadian multinational investment bank and financial services company. Founded in Montreal, Quebec, in 1817 as Montreal Bank, its head office remains in Montreal, while its operational headquarters and executive offices have been located in Toronto, Ontario since 1977.
- Designed and Developed Reusable UNIX wrapper Scripts. Reviewed and Involved in performance tuning of Ab Initio jobs, preparing unit test cases and unit testing.
- Provided efficient methods to meet the timelines.
- Provided support to the testing team and also helped the front-end team to validate to ensure that the code is in sync with requirements given.
- Reviewed Ab Initio applications for staging area and distribution area to validate and cleanse the data and transforming the data as per the business rules by evaluating the code of all components like reformat, join, Sort, rollup, scan, lookup, Normalize, partition and de-partition.
- Worked on Linux Scripts and ESP to schedule and run Ab Initio deployed jobs by applying various business rules.
Ab Initio Technical Architect - FedEx Canada Inc, Mississauga, ON, Canada - Mississauga, ON, Canada
(2019-03 - 2020-03)
FedEx Canada is known as a reliable shipper, committed to getting customer's packages - large or small - to its destination on time. But FedEx Canada is also a technological innovator, a supporter of community and global charities, a dedicated employer and much more. This client has multiple projects varying different tasks and responsibilities, starting from installation to production support.
