S Sheikh Reporting/Technical/ Business and Data Analyst
No reviews yet

With extensive experience across banking, aviation, and software development, I have also built a strong teaching career at the university, college, and corporate levels, in partnership with leading organizations like Oracle and Microsoft. My teaching journey spans the USA, Canada, Saudi Arabia, and Pakistan. I focus on equipping students with cutting-edge technologies, delivering courses in reporting, technical aspects, database management, and business analysis.

Through hands-on experience with tools such as SQL Server, SQL, T-SQL, Power BI, Power Query, Excel, DAX, DAX Studio, Star and Snowflake Schema. I ensure that students are prepared with real-world examples and scenarios. My curriculum emphasizes key areas like database normalization, query optimization, data modeling, problem-solving techniques, and database administration, as well as creating efficient database structures and writing complex procedure queries.

Subjects

  • SQL Expert

  • Excel Intermediate

  • Power BI Expert

  • TSQL Expert

  • ERD (Entity Relationship Diagram) Expert

Experience

  • Reporting /Technical /data Analyst (Feb, 2016–Present) at Bank of Montreal
    Following complete Reporting Lifecycle: Analyzing, Designing, Coding, Implementation and maintenance also doing validation and testing through out lifecycle.
    • Preparing business and Technical requirements documentation to automate reports.
    • Analyzing, Designing and implementing Conceptual, Logical and physical schema objects.
    • Documenting, designing DFD, ERD and writing Pseudo Code for Technical Design documents.
    • Peer reviewing and evaluating Vendor’s Technical design documents, Code and reports
    • Building Data Marts for Collections and Operational products for analysis and forecasting.
    • Writing and enhancing different layered of procedures and Database structures.
    • Implementation, enhancement, Maintenance and troubleshooting Dash Boards and Score Cards.
    • Data Collection (Importing) and converting from different sources such as Oracle, SQL Server,
    Access, Sybase, Excel, text and SAS.
    • Effectively providing ETL, Technical and Functional (LOB) support for Reporting and Analysis.
    • Training and providing technical support to peers in Oracle, SQL Server and Reporting cycle.
    • Providing Functional and Technical support in performance and tuning, database Structure and
    Optimizing queries.
    • Effectively involve in data governance activities for different products while implementation in UAT and Production environment.
    • Languages and Databases: SQL, TSQL, PL/SQL, DB Visualizer, Python, Oracle and SQL Server
    • For Reporting: Power BI, EXCEL, DAX
    • Other Tools:, VISIO, SAS, Shared Point 365, SSMS, DB visualizer, Jira, GitHub
    • Application: CACS7, CACS9, TSYS Doc Direct
  • Senior DBA Consultant (Feb, 2013–Feb, 2016) at Canadian Business College, Toronto
    Being Oracle and Microsoft Partner.
    Conducting:
    Microsoft SQL Server DBA and Database housing Training classes
    • Provisioning SQL Server Databases SQL Server 2017 [20765C]
    • SQL Server Infrastructure [20764C]
    • Implementing a SQL Server Data Warehouse [20767C]
    • Querying Microsoft SQL Server [20461D]
    • Administering Microsoft SQL Server 2014 [20462D]
    • Implementing Data Warehousing with Microsoft SQL Server [20463D]

    Oracle DBA and RAC Classes
    • SQL, Advance SQL, Advance PL/SQL
    • Oracle Database 12C Admin, Install and Upgrade Accelerated
    • Backup and Recovery Workshop
    • Managing Multitenant Architecture
    • ASM Administration
    • EMCC

Education

  • Certification (Apr, 2015–Jun, 2015) from MIcrosoft Corporation
  • Certification (Mar, 2015–May, 2015) from MIcrosoft Corporation
  • Certification (Feb, 2014–Nov, 2015) from Oracle Corporation
  • MS (Oct, 1990–Oct, 1992) from Western International University–scored 3.135
  • MSc (Jul, 1986–Jul, 1988) from University of Punjab Lahore Pakistan–scored First div

Fee details

    CA$4,000–10,000/month (US$2898.55–7246.38/month)

    Will be teaching full professional courses such as Technical Analyst, Reporting Analyst, Data Analyst and Business Analyst and preparing students for a job in the industry. The course will be completed in one month with hands on experience with different scenarios and examples.
    If a full class is arranged, I can travel to any country for the class ad charges will be $20000 excluding Tickets and stay. $4000 online if the number of students are less than or equal to 4. More than 4 can be adjusted between $4000 and $10000 as per advice. The Modules will cover DFD, ERD, SQL, TSQL, DAX along with EXCEL and Power BI.
    If one or two students attending then fee will be $2000

Reviews

No reviews yet. Be the first one to review this tutor.

© 2016 - 2026 TeacherOn. All rights reserved