Moin Khalid Email & Phone Number

United States

Amsterdam, North Holland, Nl

Major Highlights and Projects::- D365 Export to datalake- Onprem to cloud data migration using Datafactory and Synapse Analytics- Data Ingestion framework design and development using Synapse Analytics, Datafactory and Spark- Power-BI reporting solution design and development- Integration Middleware solution design using Azure API Management and Azure Logic Apps- Datamesh and Data Governance RIO AnalysisTools and Technologies:Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Microsoft Power BI, Azure DevOps, Microsoft SQL Server, D365 Export to Datalake, Synapse Link, Azure Logic Apps, Azure API Management

Cranbury, New Jersey, Us

Responsibilities:- Act as Liaison between Client and Offshore Development team- Design, Review and Development of Data Lake and Datawarehouse solution- Supervise timely and Quality Delivery of Tasks and Projects- Work with team to encourage and setup Goals that will both individuals and company- Review Exiting Data Landscape and provide recommendation on new tools and technologies- Setup and Maintain ERP Data Processing Pipelines- Setup and Maintain Azure Data lake to Google Bigquery Data Sync- Conventional ETL development and Maintenance (built in SSIS and TSQL Scripts)Major Highlights and Projects:- AX2012 to D365 Data Processing Pipeline Migration using Azure Data Lake Sync, Data Factory and Databricks- Customer Data Stitching and C360 DataMart Design and Setup- Customer ID Graph Design and Development using Neo4j Graph DB- ERP (Sales and Customer Data) Near Real Time Data Refresh in Elastic Search- Product Recommendation System (Scoring and Matching Algorithm) Design and Development - Sentiment Analysis Pipeline Design and Development- Chat bot Design and Development using Google Cloud Dialog flow- Google Cloud Project and Bigquery Data Lake Setup- Sales and Inventory DataMart Design and Development- SSRS to Power-BI Report Migration- Power-BI Data Model, Report and Dashboard Design and Development- Power-BI On-Prem Server Deployment and Management- Tableau Server Upgrade and Administration- Tableau Data Model, Reports and Dashboard DevelopmentTools and Technologies:Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Microsoft Power BI, Azure DevOps, GitHub, Google Cloud Composer, Google Cloud Dataproc, Google Cloud Functions, Microsoft SQL Server, Tableau, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Amazon Redshift, Neo4j Graph DB, Elastic Search

New York, New York City , Us

Project Titles: AX Evolution, WasabiJob Summary:Worked on BI Platform as Schema Architect/Report Developer. Goal of the project was to create Enterprise Analytical System that will enable ad-hoc reporting and provide prebuild Dashboard and Reports. Source data was extracted from Microsoft Dynamics AX 2012 and Retail pro solutions. This data was transformed and loaded into MS SQL Server. MS SQL Server was acting as Physical Data layer for MicroStrategy. Key Responsibilities:- Requirement Gathering and Analysis of source database (AX2012R3)- Work with team to setup Sprint Objectives- ETL Jobs creation in SSIS to pull data from AX2012 to Data warehouse- Physical and Logical Data Layer Design and Development- Schema Objects Creation in MicroStrategy- Application Objects Creation- Report and Dashboards Creation- Alias Dimension and Transformation Objects Creation- User and Data security application and maintenance - Cubes and Data Refresh Jobs MaintenanceTools and Technologies:MicroStrategy, MS Dynamics AX, SQL Server Integration Services, MS SQL Server

Lahore , Punjab, Pk

Project Title: Retail BI SolutionJob Summary:I have worked on Microstrategy as Schema Architect/Report Developer. Goal of the project is to develop a baseline solution for the Retail Industry that can be used as Decision Support System for Business users. This Solution offering was going to provide prebuild KPIs for the retail that can be aligned to retail customers needs easily.Responsibilities:- Identify Retail Industry Use Case and KPIs- Design and Develop Microstrategy Physical and logical Layer MSTR- Build Microstrategy 9 Schema Objects to provide reporting functionality for Retail- Build Application objects under different Retail subject areas- Co-ordinate with team to finalize the out of the box dashboards and reportsTools and Technologies:MicroStrategy, Amazon Redshift

Lahore , Punjab, Pk

Project: Dubai Road and Transportation Authority (RTA)Job Summary:Goal of the project was to analyze existing Reporting system and provide Recommendation and Best Practices to improve overall solution performance. Responsibilities:- Ensure compliance to all technical specifications and best practices- Analysis Data warehouse Setup in order to check if it is aligned with MicroStrategy schema design Recommendations and Business Requirements- Review MicroStrategy Semantic layer design (Logical Data Model) and schema objects. Review of Logical model while keeping in mind the Business Requirements. Attributes, Facts and Hierarchies are created by development team to be utilized in data view layer- Review of Application Object (Cubes, Documents) to check compliance with the requirement and Provide solutions to the bottle necks in the systemTools and Technologies:Azure PDW, MicroStrategy

Lahore , Punjab, Pk

Project Title: Ascena Retail BI TransformationJob Summary:Worked on MicroStrategy as Schema Architect. Goal of the project was to develop a self-service BI and Decision support system that can facilitate Business users to analyze their business at a glance and make better decision based on facts. I have worked as Technical Lead on this project while managing 4 resources. Resources were being utilized in Schema designing tasks and Report DevelopmentResponsibilities:- Estimated timeframe for development, testing and deployment against BRD and successfully delivered on time- Interacted with developers and team members to understand the business process- Involved in documentation, maintenance and enhancements of the system- Develop and maintain various codes, documents and associate technical files- Ensure compliance to all technical specifications and prepare modifications if required- Analyze business requirements and co-ordinate with data model team to finalize warehouse design- Analysis of the warehouse structure in order to check its compatibility with MicroStrategy schema design- MicroStrategy Semantic layer design (Logical Data Model), schema objects creation. Logical model is created while keeping in mind the Business Requirements. Attributes, Facts and Hierarchies are created to be utilized in data view layer- Application Object (Metrics, Filters, Reports, Prompts) creation and testing to insure data validity- Finalize MSTR Documents and Dashboard design/Development using MicroStrategy desktop and Web portal to provide analysis capability to end user- Narrowcast services creation to provide automated delivery of reports to the Business users- Maintain and update MicroStrategy system and configure and compile all required dataTools and Technologies:Teradata Data Warehouse, MicroStrategy

Melbourne, Victoria, Au

Project Title: MawhibaJob Summary:I have worked on development of comprehensive Business Intelligence solution for the Saudi Ministry of Education. BI solution goal was to give Mawhiba Higher Management a better inside to the program frequencies and campaigns outputs. Reports and Dashboards were created using SSRS and Tableau 8, to get the program inside at a glance and make decision making process smooth. I was working as off-shore Team Lead managing 5 resources. Resources were assigned on development of reports and ETL packages.Responsibilities:- Off-Shore Team Lead for the complete application- Responsible for gathering requirements from customer support teams/business analyst and convert them into technical specifications- Microsoft Server 2012 Server/BI System administration- Review, Develop Technical/Functional documents and Present recommendation- Works closely with client management to identify business needs and specify complex business requirements and processes. Document business requirement and prepare Functional Specification.- Analyze warehouse data and BI system. Correct broken reports and/or data. Recommend solutions to keep the data correct for reporting- Create, Deploy and Manage Tabular Cubes and SSIS packages- Use MS SQL server Reporting services (SSRS) to create reports (Tabular, Cross Tab) against the functional specifications- Used Tableau 8 to provide dashboard visualizations of data and to provide system analysis/performance information using KPIs and Interactive charts- Provided full documentation of the system. Involved in the maintenance and enhancements of the systemTools and Technologies:PowerPivot, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Microsoft SQL Server, Tableau, SQL Server Reporting Services (SSRS)

Lahore , Punjab, Pk

Project Title: BizTalk EAI SystemJob Summary:I was involved as a system Administrator for a project of UNFI foods in USA. This system uses BizTalk server to Integrate different source systems used by UNFI. Business logics were applied in BizTalk Orchestrations while mapping from source and destination systems were provided using BizTalk Schemas. BizTalk Server clustered environment was configured where messages were flowing in real timeResponsibilities:- Microsoft Server 2005/ 2008 Server administration- Providing BizTalk server and Database support to UNFI Corporation i.e. Identification of issues with EDI files generated from BizTalk and reprocess the incorrect files after resolving the issues- Installing BizTalk packages and Deploying Policies on clustered environment- Entertaining the Ad-hock Queries and providing answers to Questions- Finding and solving issues related to GIS, Elmer-E, Elmer-T and Elmer-I EDI applications to prevent any down time in production environment.- Perform daily activities to in-order get production statusTools and Technologies:Microsoft SQL Server, BizTalk