Jan 2025 – Jan 2026 · 1 yr · Riyadh, Saudi Arabia · On-site

• As a Senior Data Modeler at HRDF, I lead the design, development, and governance of enterprise-wide semantic and dimensional data models that power strategic decision-making across the organization. My role focuses on transforming complex business processes into scalable, accurate, and high-quality data structures that support analytics, reporting, and data products used by internal stakeholders and national programs.
• I collaborate closely with business owners, data engineers, BI teams, and domain experts to define clear business semantics, standardize data definitions, and ensure consistent metadata across all layers of the data ecosystem. I drive end-to-end modeling activities—including conceptual, logical, and physical modeling—while ensuring alignment with HRDF’s data architecture, quality standards, and compliance practices.
• Key responsibilities include:
• Leading semantic layer modeling for enterprise analytics and self-service BI.
• Designing and maintaining dimensional models, facts, and conformed dimensions.
• Translating business requirements into robust logical and physical data structures.
• Guiding data engineers in implementing data pipelines aligned with approved models.
• Establishing modeling best practices, naming standards, metadata documentation, and governance processes.
• Optimizing data models for performance, scalability, and usability across platforms.
• Mentoring teams on data modeling principles and ensuring consistency across projects.
• With a strong focus on clarity, reusability, and business alignment, I ensure that HRDF’s data models serve as a trusted foundation for analytics, digital transformation, and data-driven policy decisions.
• Note : Role is delivered through parent company - AiElement

Jan 2022 – Dec 2024 · 2 yrs 11 mos · Riyadh, Saudi Arabia · On-site

• Project: Enterprise Data Warehouse upgrade
• Tools used: Informatica Power Center, Teradata, UNIX, OBIEE
• Roles:
• 1. Writing data models for the semantic layer to fulfil specific client needs
• 2. Writing conceptual logical and physical data models for the new requirements.
• 3. Performing reverse engineering to create data models for Data Mart layer.
• 4. Developing source to target mapping documents and ETL pipeline frameworks.
• 5. Creation and improvement of data flow jobs, performance improvements, process development
• 6. Development of housekeeping jobs to understand dB size, query bottlenecks, skewed jobs and adding required constraints.
• Note : I've worked with Al-Rajhi bank from Wipro Arabia as parent company.

Aug 2019 – Dec 2021 · 2 yrs 4 mos · Riyadh, Saudi Arabia

• ● Responsible to analyse the customer information and data gaps between two banks to support customer data cleansing activities in the merger.
• ● Created weekly Data cleansing visualizations/reports and shared it with business.
• ● Working closely with architects to document the data issues and developing codes to cleanse the data.
• ● Working on creating procedure and functions to provide solutions on different business problems.
• ● Worked with Informatica to create migration mappings/workflow based on requirements.
• Major work performed:
• ● 99 Beneficiary resolution: one of the major issues where Alawwal can have more than 99, but target bank SABB has maximum limit have 99 beneficiaries (SARIE, SWIFT, SADAD, WITHIN BANK) per customer in SABBNET. Complexity increases when there are common customers, analysed the data from both systems to propose a solution with visualization and created a cleansing guideline.
• ● Customer Address Migration: Most complex issues in migration to generate National and PO addresses as per target system in both English and Arabic language. In source system data is total junk for 60% of the customers. With detailed analysis concluded a best data trend to extract National address from the source system and map it with target system. With the address data analysis resolved issues for 200k customers out of 500K customers that are migrated
• ● Customer Name Migration: Second most complex issue in migration to create a name as per target in English and Arabic format. Initially it is planned to go to central Yakeen agency to reach out for 300k customers to get their names in SAMA format but with help of name correction guidelines/procedure created/proposed by me we have resolved the names for 250K customers and saved a huge cost for bank.
• Note : I've worked with Alawwal-Sab migration project as business data migration expert from Al Khayarat Support Company as a parent company

Mar 2017 – Jul 2019 · 2 yrs 4 mos · Pune, Maharashtra, India

• ● Worked with application migration projects where customer payroll data needs to be migrated from older payroll systems to new payroll system.
• ● Created a multiple visualization using Tableau to create multiple reports and share it with stake holders.
• ● Responsible for developing or updating ICP’s as per business logic. ICP are created to cleanse the data automatically as per the target application.
• ● Technical POC to handle critical business scenario and develop the solutions on the same e.g., duplicate SSN, duplicate email report generation and correction, DET file encryption and decryption process development.
• ● Many manual processes were atomized to bring automation culture in the system using PLSQL and Informatica.
• ● Working with process improvement of migration projects by automating manual processes using SQL and PLSQL, Informatica.
• Major work performed (add-ons):
• ● Duplicate SSN Program: Initially in each client migration duplicate SSN scenario were handled manually by giving all the manual correction records to customer to get the clean data which involves cost to both client and company. I have initiated a process to create a SSN correction guidelines at company level based on previous migration and documented the scenario that can be corrected at company level and after approval from system architect, I have created a program that find the manual correction records and correct all possible customers within ODS and creating output file of only those SSN scenario that cannot be fixed at our level. As a result, we were able to reduce the timeliness by 30%. Same program in now used in many migration and data cleansing projects.

Feb 2016 – Mar 2017 · 1 yr 1 mo · Pune Area, India

• ● Responsible for creating various reports querying Teradata/Oracle.
• ● Working with Vodafone Telecom Product Teams (CSM, PROVIS etc.) to help them creating various data sets using SQL and Informatica.
• ● Worked on Adhoc report request from business to calculate requested KPI’s.
• ● Worked with UAT team to verify CR testing and performed OAT as well.
• ● Worked as POC to do analysis and provide the data as per the business need and formally creating the DWH request for CR if needed.

Jun 2013 – Feb 2016 · 2 yrs 8 mos · Pune Area, India

• ● Coordinated with Business Architect to create necessary database objects, stored procedure.
• ● Worked with Cognos reporting tool to create reports as per technical documents.
• ● Wrote complex queries to transform data as per the business logic.
• ● Created different mappings in Informatica power centre as per design.
• ● Wrote UNIX scripts to produce the files on daily basis like renaming the file, extracting date from file, unzipping the file and remove the junk characters from file before loading them into base tables.
• ● Involved in Testing of ETL mappings and reports using complex SQL queries.
• Major work performed:
• ● SMART SQL ENGINE (Individual): It is an oracle procedure that can be used for automated testing of one-to-one loaded oracle tables. This will automatically create test cases, execute the test and store output in a result table. Great efforts were saved.
• ● FILE VALIDATION ENGINE (Individual): It is the UNIX script that can be used for testing of file to table data flow. Automated creation and execution of count and data validation test cases can be done using this script. All records in file are compared, so advantages over sampling method. Also, efforts of test case creation and execution are reduced.