Hasnain Khan Email & Phone Number

Burbank, CA, US

Burbank, CA, US

Burbank, CA, US

• Planned and Implemented fully functioning Snowflake data warehouse for enterprise datahub team.
• Involved in decision making of the right tools/technologies for enterprise reporting/analytics platform.
• Used Talend for data integration and consolidation from various data sources (Oracle, SQL Server, MySQL) into Snowflake.
• Developed and enhanced highly efficient homegrown lightweight Python/PySpark ETL/ELT tool which involves spitting the files as parquet/CSV and dropping into Amazon S3 bucket and bulk loading as a variant datatype into.
• Created multiple Airflow DAGs to manage ETL/ELT workflow orchestration which involves setting up dependencies and upstream/downstream processes.
• Developed the data level security model in Postgres to handle the user access/privileges for the reporting portal.

Burbank, CA, US

• Architected and maintained Microstrategy project for Home Entertainment.
• Maintained Tableau project for Music and Media Analytics group.
• Created Databases and Tables/Views in Databricks for reporting and analytics purpose.
• Used Databricks as a source for Tableau Reporting, Streaming and ad-hoc analytics.
• Created Tableau Prep workflow to generate tableau hyper file and exposed the hyper file as a data source for the business users.
• Worked with Music/Home Entertainment/Media Analytics business teams to define the scope of the project and understand the requirements.

New York City, NY, US

• Architected and maintained Microstrategy environment for Film IT team.
• Worked with the business teams to define the scope of the project and understand the requirement.
• Led two major reporting projects through design, development and implementation phase.
• Modified and enhanced existing Microstrategy schema for better user experience.
• Developed and designed the data model as per the requirements.
• Successfully developed and delivered 20 complex Microstrategy Freeform SQL Reports/Documents for International Distribution Reporting & Analytics Team.

• Involved in requirement gathering and worked closely with business analyst and end users to better understand the requirements.
• Created Microstrategy Schema & Public objects as per business requirements.
• Resolved the legacy cache issue.
• Implemented Microstrategy system manager workflow to handle subscriptions.
• Led and maintained Microstrategy environment.
• Resolved web server slowness issue and implemented best practices.

Baltimore, Maryland, US

• Led the infrastructure team and administrating MicroStrategy in T.Rowe Price.
• Worked with MicroStrategy professional services to setup Dev, Qual & Prod environment.
• Identified and resolved multiple issues related to the setup and configuration of MicroStrategy within TRP security compliance.
• Added custom font to web using MicroStrategy Web SDK.
• Led the infrastructure team for sanity testing of the environment once it has been setup.
• Worked and finalized the test cases and custom security roles based on T.Rowe Price requirement and involved in extensive testing.

Brea, California, US

• Involved in gathering Business requirements for the ‘CARS’ and ‘Mobile Enhancement’ projects, and determined the appropriate facts, attributes and metrics.
• Prepared and Reviewed Business & technical specification Documents.
• Data Analysis and data profiling to include data from multiple sources such as guidewire & nextgen.
• Worked with ETL team to change the existing schema from star to snowflake based on the requirement.
• Led the BI team for ‘CARS’ project and architected MicroStrategy schema objects for current and historical attributes.
• Filtering (Hierarchy prompt) implemented on current and historical attributes used on the report grid based on requirements.

New York City, NY, US

• Developed timelines for project delivery, and managed resources for successful completion.
• Extensively involved in building and implementing MicroStrategy schema objects and public objects by creating facts, attributes, hierarchies, reports, filters, and metrics using MicroStrategy Desktop.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services.
• Created Dynamic Dashboards using panels, selectors, grid, graphs and widgets such as Micro Charts, Bubble Grid & Fish Eye Selector and also implemented Widgets as Selectors.
• Created and published intelligent cubes leveraging reports to access cubes instead of warehouse to get faster results.
• Used Report Cache Sharing and Data Mart reports to enhance the Report response time.

Los Angeles, CA, US

• Involved in BI team meetings to discuss the user requirements and enhancement of the user’s experience.
• Tested the integrity of Microstrategy reports and documents using Integrity Manager before upgrade.
• Upgraded Microstrategy version from 9.2.1 to 9.3.1 and 9.3.1 to 9.4 in Prod, Dev, QA and UAT Application Servers with corresponding Web-Servers.
• Created dataset and document to generate the monthly performance report for the end distributor available in their personal login on www.herbalife.com.
• Led the BI team for above project and worked with 7 different teams to implement it using Microstrategy Distribution Services ‘BURSTING’ feature.
• Created and managed many optimal intelligent cubes and worked extensively on dynamic sourcing of the cubes.

Northville, Michigan, US

• Gathered requirements by interacting with senior managers and users for design of reports.
• Participate in BI team meetings to discuss the user requirements.
• Created logical data models, recognize source tables and columns, and build Schema objects, Application objects necessary for creation of a MicroStrategy project.
• Provided training to BI TEAM to create report, document, filter, prompt and derive metrics on web for their requirement by using attributes and metrics.
• Architected schema objects such as attributes, facts and transformations.
• Used Integrity Manager to test the reports and documents.

London, GB

• Took part in regular meetings with Business Team and discussed the requirements and design for reports and documents.
• Fine Tuning of Reports, with DBA Team, to reduce High CPU consumption of Reports.
• Exercise involved close interaction with the Architect to bring in changes in Logical views.
• Gathered relevant data and analyzed before creating Schema that fit are in accordance with the reporting requirements, defining fact, dimensions and creating aggregate table for enhanced performance.
• Created Report Service dashboards in DHTML and Flash Mode and applied KPI and graphics wherever necessary.
• Developed and supported Microstrategy Objects applying features like Dimensional Metrics, Transformation Metrics, Conditional Metrics, and Relationship filters, Prompts, managed pass through functions.

London, GB

• Worked with Business and developed key business questions and to created datasets that answer those questions.
• Involved in meetings with business users to discuss and finalize the requirements and design of the reports.
• Implemented best practices for reporting, maintenance, data management and security.
• Processed third party data sources and updated missing data if required.
• Performed design, creation, interpretation and management of large datasets to achieve reporting as well as business goals.
• Managed, Trained and guided junior Data Engineers of team size 5.

Master Of Science (M.S.), Industrial & Systems Engineering/Operations Research

Bachelor Of Engineering (B.E.), Electrical Engineering With Interest In Robotics Programming