AHMED HISHAM SHAIKH
28 Ted Rogers Way, Toronto,ON
Summary
Challenging status quo while delivering impact are the outcomes that anchor my work ethic. Achieving results, transforming businesses and creating a culture where people can be their best is when I have the most fun at work. Currently seeking a management position in Business Intelligence and Data Governance to apply my 11+ Years of multidisciplinary experiences across Data warehousing, Data governance, ETL, database development, business intelligence, data analytics, project management, innovative problem solving, commercial capabilities and operations combined with the discipline of leading strong and successful teams
Overview
12
12
years of professional experience
1
1
Certification
Work History
Manager, Data Quality & Governance
JLL( Meta Real-estate Portfolio)
01.2024 - Current
- Lead the data quality program and data governance integration for CAFM Ops data audits and system enhancements
- Worked with the OP team in support of space data integrity and data quality program
- Worked closely with Meta execs to gather critical information to identify process and data improvement opportunities
- Worked with space management datasets and IWMS systems (E.g. Archibus)
- Lead the production of reporting templates and visual outputs in support of Meta's global portfolio planner
- Mentored and coached team members to further develop competencies
- Collaborated with Meta's technology & analytics team on iteration of existing data sets and modelling dashboards
- Monitor deliverables and ensuring timely completion - ensure stakeholders are informed and up to date with regular status updates including any issues and/or risks
- Established implementation plans for Meta's workplace strategic initiatives and programs, including audits, reports, corrective actions, process improvements and system enhancements
- Provided program planning and occupancy planning tooling support to meet Meta's needs
Lead Consultant, Data Quality & Governance
JLL( Google Real-estate Portfolio)
06.2022 - 12.2023
- Responsible for monitoring and developing complex Google PLX SQL statements as part ofData Integrity Audits
- Extensively involved in developing implementation plans for month end financial reports and system enhancements
- Worked closely with Google c-suite execs to gather critical information to identify process and data improvement opportunities
- Worked with space management datasets and IWMS systems (E.g. TRIRIGA)
- Exhibited outstanding presentation and communication expertise
- Mentored and coached team members to further develop competencies
- Planned and monitored resource utilization, task delegation and provided timely and effective feedback for direct reports
- Monitor deliverables and ensuring timely completion - ensure stakeholders are informed and up to date with regular status updates including any issues and/or risks
- Established implementation plans for audits, reports, corrective actions, process improvements and system enhancements
- Initiated and Collaborated recommendations and options for data fixes, process improvements, data audits to technical and non-technical audiences
Senior Data Analyst, Global Investment Technology
OMERS
11.2021 - 06.2022
- Developed complex SQL statements as part of enhancements requests
- Leading a team with month end financial reporting Involving critical data analysis
- Developed Power-BI Dashboards deriving financial insights across multiple BUs
- Developed ETL Workflow in Azure Data Factory to automate data processing
- Developed Automated Data Processing SQL scripts to capture data changes
- Involved In identifying process and data Improvement opportunities
- Extensively involved in developing implementation plans for month end financial reports, process improvements and system enhancements
- Redesigned an existing solution resulting in faster data processing and automation
Software Developer-BI Analytics
Arteria AI
12.2020 - 10.2021
- Developed Data Audit Tool in Power-BI
- Developed Power-BI Dashboards deriving financial insights across multiple clients
- Developed ETL Workflow in KNIME to transform and structure huge datasets
- Developed Generic Data Audit SQL Script which runs statistics on Tables
- Integrated BI solution to Integrate into the SaaS platform
BI Developer
Indegene Pvt Ltd India
02.2017 - 07.2020
- Developed generic sql scripts and procedures for data validation
- Developed KNIME ETL pipelines and test their functionality
- Developed more than 18 Power BI Reports and Dashboards for different business process such as Meetings information through reps, Allocations, HCP Journey, Emails information, Events reports, Calculating Time-off for meetings deriving key business insights
- Data designing and Data Modelling to pull data from source Microsoft Dynamics to accommodate into MYSQL which in turn is consumed by Power-BI reports for end user data analytics
- Evaluated, designed, implemented and modified databases and database applications.
ETL Developer
IMS Health (IQVIA)
01.2013 - 02.2017
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another
- Migrated Excel Based reports to PowerBI which involved writing complex DAX queries
- Developed all scripts for CDI framework introducing standard logging and error handling capability and Abinitio graphs on generic component.
- Created jobs in ESP Cybermation, scheduling tool
- Development of more complex Abintio ETL graphs to perform transformations as dictated by metadata tables.
- Helping business users on use of metadata tables and how to fill in data in tables to perform specific task.
- PDL development to graph to handle metadata changes.
- Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
- Verified performance and reliability of development database transformation solutions via extensive simulation testing
Education
Masters in Computer Applications -
Manipal University
India01-2016
Bachelor Of Computer Applications -
CMR Institute Of Management Studies
Bangalore, India01-2013
Skills
- SSIS, SSAS, SSRS POWER BI
- CRM Salesforce SCRUM
- Oracle 10g, 11g KNIME
- MySQL SQL Server
- Microsoft Dynamics JIRA
- Abinitio Talend
- Database management AGILE
- Database development Confluence
- Data Modelling Archibus
- Data Automation Azure Data Factory
- Python Google Cloud Platform
- Google App Script Big Query
Additional Information
- Reduced code defect by Maintaining 97% coding satisfaction score coding
- Reduced data processing time by 50% for visualization reports
- Collaborated with a team of 10 in the development of Power BI reports
- Mentored resources for a Power BI reporting development program
- Leading a team for financial month end closings which involves solving complex data issues with immediate resolution
Certification
- Project Management Foundations (LinkedInPMI) 2020
- Diploma In Java Technologies and SQA usingIBM Rational (NIIT)
Timeline
Manager, Data Quality & Governance
JLL( Meta Real-estate Portfolio)
01.2024 - Current
Lead Consultant, Data Quality & Governance
JLL( Google Real-estate Portfolio)
06.2022 - 12.2023
Senior Data Analyst, Global Investment Technology
OMERS
11.2021 - 06.2022
Software Developer-BI Analytics
Arteria AI
12.2020 - 10.2021
BI Developer
Indegene Pvt Ltd India
02.2017 - 07.2020
ETL Developer
IMS Health (IQVIA)
01.2013 - 02.2017
Masters in Computer Applications -
Manipal University
Bachelor Of Computer Applications -
CMR Institute Of Management Studies
Similar Profiles
Sheena WhitfieldSheena Whitfield
Director - Property Management at Jones Lang LaSalle Real Estate Services (JLL)Director - Property Management at Jones Lang LaSalle Real Estate Services (JLL)
Beatrix Demers-GavallerBeatrix Demers-Gavaller
National Specialty Leasing Manager, Business Development at JLL – Jones LangLasalle Real Estate Services Inc.National Specialty Leasing Manager, Business Development at JLL – Jones LangLasalle Real Estate Services Inc.
Hollie FredetteHollie Fredette
Senior Property Associate at Jones Lang LaSalle, JLL Amazon PortfolioSenior Property Associate at Jones Lang LaSalle, JLL Amazon Portfolio