MOHAMED IRSHAD GANY

• Developed Extractors for extracting AWS S3 Bucket and Redshift Metadata
• Developed and Implemented permission modeling for the asset based on the roles
• Automated Manual process by creating custom unix script
• Built complex reports utilizing multiple sources of information from different systems.

• Developed generic Ab initio Graphs to ingest data from different sources, loading and unloading data from RDBMS

• Responsible for Creating and maintaining the ab initio graphs

• Worked on Code checker and Dependency Analysis and responsible for fixing the lineage

• Provided fixes for issues and existing defects.

• Participated in activities such as production monitoring, break fix resolution including ECC calls, design reviews, problem solving, gap analysis and configuration resolutions. Understood the business requirements with extensive interaction with client and assisted in developing the low-level design documents.

• Developed a unit test utility using Ab initio Express IT Single Test Framework and Python script for Jira defect assignment

• Involved in Code refactoring and Code optimization to the existing system.

• Responsible for Maintenance and added enhancement to the system

• Monitoring the Jobs in Production and handle failures. Also Analyzing the long running, Job.

• Worked on dependency analysis and fix lineage.

• Worked on root cause analysis and provided Fix and solution

• Created ETL pipeline for Ingesting the newly acquired agent’s data to the system.

• Responsible for Deploying Graphs and Maintaining it, Scheduling the jobs in UAT and Prod Environments

• Work with QC Analyst to ensure modifications are appropriately tested by identifying key test conditions,provide technical expertise on how to execute the cycle and assist with troubleshooting testing issues.

• Did Root cause analysis of a variety of existing production defects and provided fixes

• Participate in Production Support transition meetings

• Participate in production Deployment and validate the runs

• Developed a utility for code migration

• As a developer extensively used Ab-Initio in designing & implementing, Extract, Transformation & Load processes.

• Understood the business requirements with extensive interaction with client and assisted in developing the low-level design documents.

• Developed complex XFRs to derive new fields and solve various business requirements.

• Converted user defined functions and complex business logic of an existing application process into Ab Initio graphs using Ab Initio components such as Reformat, Join, Transform, Sort, Partition to facilitate the subsequent loading process

• Responsible for deploying Ab Initio graphs and running them through the Co-operating systems mp shell command language and responsible for creating documents like Technical design documents, Rollout documents, Demo Preparation, Toss G, Control M sheet, Unit testing documents, KT to L3 and automating the ETL process through scheduling.

• Experienced in HPSM tool to Migrate project to QA, creating branch, merge and directories of project.

• Experienced in HPSM tool to register Change order for Production Rollout.

• Involved in providing Production Support to various Ab Initio ETL jobs for daily, monthly and weekly schedule.