Shahid Sheikh

Reporting / Database Analyst

Milton, Canada

Bank of Montreal

Feb 2016 - Jan 2025 -8 yrs, 11 months

Canada

Job Details:Developed technical requirement documents for report, card and dashboard automation. Designed and implemented conceptual, logical and physical database schemas using agile approach and sometimes waterfall. Built reports, cards, dashboards and data marts for collections and operational products. Prepared/conducted peer reviews of technical design documents, code, data lineage and reports using GitHub and UAT. Maintained and enhanced dashboards, scorecards and reports. Analyzed job failures and outages, implemented the job fix. Actively involved in data governance, data lineage, testing and validation during CACS9 implementation and technical support for LOB. Actively performed query optimization for reports and cards procedures.

Canadian Business College

Feb 2013 - Feb 2016 -3 yrs

Job Details:Conducted Microsoft and Oracle certification courses as an official partner. Provided training in SQL Server infrastructure and administration, data warehousing, SQL, TSQL, PL/SQL, Power BI and Oracle DBA and RAC. Mentored students. Actively involved in lab configuration and support for students.

York University / Fatima Jinnah Women University (FJWU)

Sep 2001 - Jan 2013 -11 yrs, 4 months

Job Details:Conducted database management, O/S, data warehousing, systems analysis and design, backup and recovery, distributed databases, operating systems using Linux, Unix, Python and intro to cloud computing courses. Managed university database projects, including admission, grading, and inventory systems and provided application support for every department. Oversaw backup, recovery, and database security implementations. Developed and implemented RFPs and evaluated technical proposals. Heavily involved in interviewing junior faculty and students interviews for admission. In-charge of both BCS and BSC labs actively involved in lab configuration, maintenance and support. Supervised more than 100 dissertations and research projects.

Bachelor's Degree in Computer Information Systems
Western International University
Bachelor's Degree in Mathematics
University of The Punjab
Bachelor's Degree in Cloud Computing
University of Toronto