Zain Khan Email & Phone Number

Canada

Stamford, Ct, Us

Thornhill, Ontario, Ca

• Manage and oversee analytics projects worth in excess of $50 million related to the enterprise data warehouse and business intelligence including IFRS-17, Qlik and Power BI development, Actuarial risk modeling as well as ETL and external data feeds• Work with key business stakeholders across the whole organization to champion the use of data and reporting to improve decision making• Oversee data governance and data management initiatives with data collection systems and business partners to maintain the integrity of master data which is critical to ensure credible and reliable analysis• Manage and coach the data analytics team comprising of Business Analysts, SQL Developers, Database Administrators, and multiple Partners• Collaborate with IT on the data architecture specifications to accurately define data warehouse, guide data integration, and control data assets to implement the organization’s data strategy

Mississauga, Ontario, Ca

Strategy & Planning• Gather and manage stakeholder expectations• Coordinate and execute projects using agile methods to achieve successful project objectives, within the schedule and within budget• Assist in developing, maintaining and adjusting Project Management processes• Create plans and other project artifacts to support the project and report to the client and manager• Manage project changes, risks, and resources capacity• Manage project activities through meetings, delegation, follow up and escalate as required.Acquisition & Deployment• Ensure that any new BI integration into company systems meets functional requirements, system compliance, and interface specifications• Collaborate with business analysts and system owners in the testing of new BI programs and applications

Mississauga, Ontario, Ca

Business Intelligence Development• Coordinate and oversee the development of Echelon's Enterprise Data Warehouse and Echelon's Data Warehouse Reporting Layer• Use high-performance T-SQL to analyze and prepare reports from 4 different Data Warehouses, including the Enterprise Data Warehouse as per business needs• Collaborate with ETL and Qlik vendors in the maintenance and development of the Enterprise Data Warehouse• Design and conduct end-user training programs for business intelligence (BI) solutions developed• Oversee and/or code Qlik View application and visualizations according to designs based on business requirements and user stories• Standardize the quality assurance procedures for BI development• Oversee the testing and fixing of any bugs associated with the code • Maintain changes to data structures, schema, and documentation as associated with the application being developed• Investigate user requests and assist in the development of requirements for new applications or changes to existing applications• Lead BI and software development teams and mentor others in the proper standards, practices, and procedures for application and reporting development

Vaughan, Ontario, Ca

Project Management and Data Analysis• Coordinated National Client program with 9 projects consisting of over 500 auditors across Canada• Prepared project tracking and master client reports using MS Excel and MS Access from large volumes of data (150,000+ rows) on a weekly basis• Processed and parsed 400+ audit files daily through Outlook using advanced functions such as rules and macros• Shipped, documented and maintained 1000+ field audit equipment database of tablets and scanners and their appropriate paperwork and agreements• Acted as the center of customer service and communication between 5 Field Managers, 7 Field Supervisors, 2 Project Managers and Project Director• Collaborated with cross-functional teams, such as IT, to develop business improvement processes such as designing and launching of National Client android app in use by over 2000 auditors across Canada

London, On, Ca

Research and Data Analysis• Employed strong analytical skills in gathering, plotting and analyzing large datasets involving earthquake events to oil and gas operations in Alberta from 1980-2015 using SQL, ArcGIS and MS Excel• Designed an environmentally and economically feasible alternate route for Keystone XL Pipeline in Canada using ArcGIS, SQL and MS Excel • Referenced and prepared highly technical and lengthy (5000 words+) scientific reports and literature reviews under strict deadlines

Master Of Science (M.Sc.), Geophysics

Project Management