Senior Consultant (Manager) - Hoonar Tekwurks
(2022-01)
Reference Data Management (RDM) Application is a key component within STC's Profitability Management Digitization initiative, aimed at modernizing and streamlining financial and operational processes across the organization. STC (Saudi Telecom Company) is undergoing a large-scale digital transformation to enhance profitability analysis, improve data governance, and automate data workflows.
- Working in an Agile environment to lead development and enhancement of data pipelines using Ab Initio ETL, ensuring efficient processing of large-scale reference and transactional data
- Designing and reviewing complex Ab Initio graphs, ensuring best practices in performance optimization, reusability, and scalability of ETL processes
- Mentoring team members on Ab Initio, UNIX scripting, and ETL design patterns, providing knowledge transfer sessions on graph development, error handling, and debugging techniques
- Developing and optimizing UNIX shell scripts for automation of batch jobs, file handling, and integration processes across upstream and downstream systems
- Leading integration with external systems using Web Services and APIs (REST/SOAP) to enable seamless data exchange between RDM, ODM, CPM, and other enterprise systems
- Ensuring data integrity, quality, and consistency across ETL processes, databases, and API responses, especially during data migration and transformation
- Implementing performance tuning strategies across Ab Initio jobs, SQL queries, and Teradata workloads to improve execution time and system efficiency
- Troubleshooting and resolving production issues related to ETL jobs, UNIX scripts, database queries, and API integrations, ensuring minimal business impact
- Contributing to team member performance evaluations, appraisal discussions, and providing constructive feedback to support professional growth and development of junior team members
Leadership and Senior Roles - Accenture
(2018-01 - 2022-12)
MA Auto application - Reconciles the premium data that AIG receives from Vendor (Pilgrim) and Lexington (Coverall). It is an automated monthly process which generates datasets for RRD NH. The reconciled records will be sent to RRD NH (Regulatory Reporting Department New Hampshire), which generates statistical and financial reports to be submitted to CAR. The non-reconciled records will be sent to users in a report called Out of Balance Report.
- Working in an Agile environment to help Migrate the existing application to Abinitio cloud and updating the existing database connection to point to snowflake DB
- Mentoring the team in Abinitio/UNIX by giving them KT of code pertaining to graph design and shell scripting
- Making sure that the data integrity is maintained and no change in data when storing in new snowflake DB
- Creating the STM for the existing code in abinitio to be migrated to IICS
- Code versioning is maintained in GitHub and migrated to higher environment using devops pipeline
- Creating the unit test case document for the code changes
- Autosys job creation for the one-time load including history data load and lookup/directory creation
- Closely working with various teams including the autosys, devops, QA for implementing the changes and moving the code to higher environment
Leadership and Senior Roles - Wipro
(2015-01 - 2018-12)
Enterprise Analytics Platform (EAP) program helps stakeholders to analyze the data loaded for each line of business portfolio in Big Data Environment from core services domains for analytics and reporting purpose.
- Understanding the business requirements, working with scrum master, project manager and assisting in developing the source to target mapping sheets
- Maintained code integrity using version control software (EME)
- Working with team to help them understand the requirements, work distribution and estimation process
- Creation of Test Data and regression Unit testing of all the graphs and plans
- Instrumental in performance tuning of queries at database and Ab Initio level to improve ETL load timings
- Worked on HQL and spark script execution process for data loading
- Creating and executing HQL queries for validating the source and target data
- Closely working with Hadoop admin team for Hadoop cluster/Environment issues encountered during the testing process
- Attending status calls with project stakeholders including client
- Delivering the test activities of each sprint on time while working in Agile
Leadership and Senior Roles - TCS
(2014-01 - 2015-12)
Integrate different tables of FX Mobility ADM (Master), CAT and FX specific tables into DARTS using ABI graphs for generating different KPIs and aggregates required by business.
For Postpaid
Mobile vertical there are 31 BCV servers, 1 CAT and 1 ADM server from which data will be extracted based on data extraction strategy for BASE and master's and stored in Hadoop File system based on defined file naming convention for each data set. The files after transformation will be loaded into HIVE based on partition keys defined on each table. The Postpaid KPIs will be derived from Base and Master data loaded and will be posted into corresponding FACT HIVE tables for each KPI post applying aggregation logic.
- Create graph/plans to extract the data from Customer Unit (CUs)
- Apply the transformations on the extracted data and load the same to the staging tables (Base tables)
- Developed mappings to implement type1, type2, type3 slowly changing dimensions
- Extensively used partitioning concepts to improve graph performance in Ab Initio (ETL)
- Ensuring the data quality in Source and Target levels to generate proper data report and profiling
- Preparation of the design and unit test cases document
- Carrying out the testing at various stages of the development
- Code fixes for the defects that occurs in TEST and UAT
- Assigning tasks to the team members and helping them in case of any issue/challenges faced
Team Member (Developer) - L&T Infotech
(2010-01 - 2014-12)
Multiple projects including Basic Department Management (BDM) System at Walgreens (Jul 2014 - Sept 2015), Fund Services Reporting at Citi Bank (Feb 2011 - Jul 2014), and Technology Portfolio Management (June 2010 - Feb 2011).
- Modified the graph which was used to generate the ADK report
- Automated the process for identifying the store BDM mismatches
- To meet the requirements of the BI reports developed the graphs to load the data in a high-volume environment
- Preparation of the design and unit test cases document
- Worked with EME / sandbox for version control and did impact analysis for various Ab Initio projects
- Carrying out the testing at various stages of the development
- Code fixes for the defects that occurs in QA and UAT
- Modifying existing graphs to handle the change requests
- Proficient at working with both Serial file & Multifile systems and have helped in optimizing graphs using different types of parallelisms
- Developed graphs with .xls and .dat source files as well
- Handling the production issues if any
