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 Snowflake staging using SnowSQL then parsing out the data into target table.• 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.• Developed SSRS reports and scheduled it to be delivered via email and file drop in the shared location. • Created Tableau Prep workflow to generate tableau hyper/tde file and use it as a data source in reports for better performance.• Designed and developed multiple Tableau reports and deployed to production.• Working with Operation/Finance/Product Adoption business teams to define the scope of the project and understand the requirements.

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.• Enhanced multiple existing Tableau dashboards and deployed to production.

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. • Created complex FFSQL reports/documents to satisfy the user’s real-time reporting need.• Led and mentored off-shore development 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.● Created multi tab report/document.

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.● Worked with MicroStrategy mobile app development team to resolve the security flaws in iOS version 9.4.1.● Received and tested custom build from MicroStrategy mobile iOS development team to make sure the app is working under T.Rowe Price security compliance.● Involved in configuration and setup of Qual and Prod environment for external users with LDAP.● Setup the best practices around the tool and defined the guidelines.● Created new projects and provisioned the access to the users and project teams.● Generated MicroStrategy Web Task URL to feed and use in iframe.● Trained infrastructure team and project team to use Microstrategy.

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.● Converted type I (current attributes) hierarchy prompt into split hierarchy based on the requirement● Developed multi-layered document report based on ‘CARS’ hierarchy with more than 15 KPI’s and metrics is aggregated based on the level.● Developed timelines for project delivery and successfully implemented on-time.● Created and published FFSQL intelligent cubes for the datasets which is used in Mobile dashboard enhancements.● Developed dashboard and enhanced the existing one based on the requirement.● Multiple production issues resolved as part of production support duties.● Involved in analysis, debugging, troubleshooting of incidents coming via service now.● Involved in data governance activities with claims and product management teams.

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.● Communicated, Managed and Mentored a team of offshore resources on a day to day basis to ensure delivery.● Used Integrity Manager before upgrade to test integrity of reports and documents.● Upgraded Microstrategy version 9.2.1m from 32 bit windows to version 9.4.1 windows 64 bit system in Prod, Dev, QA and DR (Disaster Recovery) APP Servers with corresponding Web-Servers successfully.● Configured Microstrategy Health Center to prevent, diagnose and fix problems in a MicroStrategy environment and to detect known issues.● Worked with security filter to restrict data from the group of user based on requirements.● Migrated objects from one environment to different using Object Manager.● Created users, subscription and changed user domain using Command Manager.● Architected Schema objects such as attribute, facts and transformations based on the requirements.● Build Intelligent Cube to feed the set of reports and enhanced its performance.● Created multi-layered documents to be delivered as an excel workbook using distribution services.● Developed, tested, and implemented new project to support go-live requirements for new distribution partner.

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.● Used Enterprise Manager for the performance monitoring and better management.● Worked using Command Manager to alter the subscription owner, enabling/disabling user account and several other tasks.● Created user’s accounts and managed different user groups and privileges for nearly 1200 accounts.● Managed subscriptions and created schedules (Time Triggered & Event Triggered) according to requirements.● Created different schema objects such as attributes, facts, logical views depending on the requirement.● Provide training to BI users to create report, document, filter, prompt and derived metrics on web.● Worked closely with EDW and SQL team to make sure data is available.● Tuned the SQL using different VLDB settings based on the requirements.● Used analytical and governing settings in VLDB properties to tune the SQL.● Resolved many production related issues and done production support.

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.● Managed the user’s account and different MicroStrategy groups.● Created different schedules and subscriptions based on the requirement. ● Coordinated with Database Architect and ETL developers for data availability and data model related issues by providing solutions that support MicroStrategy application.● Designed Interactive Dashboards to show company’s financial performance and monitor the overall goals of the business.● Implemented different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.● Used and help customize auto prompts filter feature to provide the end-user a choice of different filtering criteria and options during report runtime.● Created standardized reports (Canned reports) and Report Services documents for users.● Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the inner join, outer join, nulls and zeroes.● Used Transformations (table based, expression based) for comparative reports for Investment Operations.● Production support, trouble-shooting and fixing of reports was done in record time.

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.● Created Intelligent cubes for better performance and optimal use of database resource.● Proficient in data modelling techniques and involved in physical data modelling.● Worked on Project connectivity of Microstrategy metadata, database instances, project sources and ensuring connectivity to various servers to retrieve data for reporting purposes.

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.● Identified and solved issues concerning data management to improve data quality

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

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