Mohammed Ali Mohammed Khasim

• Implemented data separation process for divestiture.
• Identified applications for data separation
• Conducted one-on-one meetings, workshops, and working sessions with application owners and stakeholders to gather information - collaborating with cross-functional teams
• Created Key Decision documents for over 30 applications.
• Designed data flow diagrams and generated separation approach/strategy documentation.
• Managed projects, facilitated workshops and scheduled meetings, and planned delivery items
• Bridged the gap between technical and business teams.

• Data Separation
• Created data flow diagrams and key decision documents for the separation of medical device data and financial transactions.
• Conducted analysis of GL/AP/AO data with a focus on ERP systems such as SAP-ECC
• Created source to target mapping document with data transformation rules for technical team.

• Implemented fraud detection measures in commercial banking sector.
• Implemented third-party system (Verafin) for fraud detection, resulting in enhanced workflow efficiency.
• Conducted analysis on the current state architecture to generate insights for future state design
• Performed detailed analysis on Informatica PowerCenter 10.5 ETL code and SQL procedures
• Generated transformation rules, compiled mapping documentation, and organized metadata.
• Partnered with ETL development team to optimize transformation rules and ensure successful unit testing
• Engaged with QA team in conducting comprehensive system testing
• Reconciled postproduction deployment data during trial period.

• Implemented Wealth Management – Client Onboarding
• Successfully migrated high volumes of data metrics from Legacy Mainframe to AWS Cloud Services, enabling more efficient storage and computation for Financial Advisors
• Analyzed and reverse engineered Mainframe's existing data storage/computation in DB2 storage procedures
• Created SQL procedures to migrate data to AWS RDS.
• Created transformation rules for AWS developer to generate AWS Glue ETL code, facilitating the loading of data into DynamoDB.

• Wealth Management – Customer /Account Information Management – Big Data Migration
• Architectural/Data/ETL code analysis of the existing CRDB/CAI repository
• Gathering requirements for the new database built on Bigdata platform – Hive
• Document mapping rules & metadata
• Lead the development team for creating ETL code in informatica BDM & hqls.

• Defined audit review process for extracting data from HR application systems to Datawarehouse in Teradata for HR Integrated Data Repository Assessment.
• Validated code releases for appropriate classification and masking, ensuring adherence to company policies and standards.
• Ensuring accurate documentation is available for downstream/upstream systems
• Performed data reconciliation of database objects and identified gaps
• Developed code release metrics
• Performed hands-on data analysis using Teradata SQL Assistant.

• Collaborated with Business teams to develop a conceptual data model for the HR data repository

• Implemented Sourcing data from mobile applications to the Datawarehouse for reporting/analysis in the Mobile Audit Logging project
• Collected both functional and non-functional requirements
• Analyzed mobile source data in Oracle database.
• Identified and addressed gaps in transformation rules
• Reviewed and analyzed data models
• Created and refined Agile Scrum/Story stories
• Utilized Jira to effectively facilitate Sprint/Scrum ceremonies and track burndown and velocity metrics.
• Implemented Basel II requirements.
• Analyzed and identified gaps between stated business requirements and existing data.
• Created transformation rules to load data from various applications into Teradata warehouse.
• Implemented Journal Entry Creation in Retail Bank ODS
• Performed data analysis on Unix files to identify gaps in information.
• Collected functional and non-functional requirements for journal entries
• Reviewed target data model and created source-target mapping.
• Created unit tests and facilitated story grooming.
• Managed data warehouse sourcing for the commercial bank.
• Documented program goals and achieved system architecture and data flow design.
• Reviewed and refined data models
• Created source-to-target mapping document
• Validated test data.
• Built Operation Data Store for processing Credit Card data
• Collected business requirements and transformed them into detailed low-level requirements
• Created source-to-target mapping document
• Created test cases and validated test data.

DatawarehouseDatawarehousehqls

• Implemented credit card operation data store build
• Directly engaged with the customer business team to elicit and comprehend requirements
• Utilized Informatica PowerCenter to creDatawarehousengs and load the Datawarehouse from multiple source systems.
• Managed mainframe applications effectively
• Achieved process improvements by updating COBOL programs and received recognition.

• Completed Power Plant Engineer Training
• Worked in the Erection and Commissioning of Boiler Instrumentation Controls/Automation at the NTPC Kahalgaon Unit in Bihar,India

• Market Research Applications
• Fixed bugs in mainframe applications
• Updated COBOL programs for innovative process improvements and won accolades.