PROTECTED 関係者外秘

Mohammed Abdul Rahman

Contact: +1-323-***-**** Email: adz420@r.postjobfree.com

Highest Education: Bachelors of Engineering(2005-2009) PROFESSIONAL SUMMARY:

14+ years of experience in Data Warehousing, Power BI and Business intelligence along with Requirement Analysis, Application design and development, testing, implementation and maintenance of Data Warehouse and Data Mart systems within various industries including Software and Insurance industries.

Responsible for budgeting and forecasting, expense reporting, risk management, status reporting, and execution using Project Online

Create project documentation and strategy plans using Gantt charts

Account for complete project lifecycle from inception to closure

Collaborate with participants to determine project timeline

Map projects for budget tracking

Design & automate business intelligence dashboards to facilitate data review and analysis, etc.

Experience in Analysis, Design, Development, Implementation and support of various business applications on On-Prem and Cloud Infrastructure (Azure).

Drive customers to adopt new technologies to help them thrive in business.

Expert in designing dashboards in Power BI.

Experience using Azure Data Factory to create Pipelines to transfer data across systems.

Automation methods using PowerShell and SQL.

Experience with Azure Blob Storage usage and handling files.

Experience with creating Analytical reports using Power BI.

Created different dashboards in Power BI, for clients showcasing different performance indicators per business details.

Proficient in understanding the requirement from the client and converting it to technical tasks.

Handles daily scrum and tracks status effectively from the whole team.

Extensive experience in SSIS, SSAS, Azure Analysis services and SQL development.

Experience in Migration of On-premise DB to Azure SQL.

Experience using Data Modeling Tools like Erwin, Visio. SKILLS

Version Control: Web Technologies:

Data

Modeling: Script: API:

Visual Studio XML Visio

Visual Studio

Code. Postman.

Team Foundation Server HTML ERWIN.

Azure Data

Studio.

Bit Bucket JSON. DAX Studio.

GIT. Tabular Editor

ALM Toolkit

PROTECTED 関係者外秘

EXPERIENCE SUMMARY:

ATT, Dallas, Texas

Sr. BI Solution Architect June’21 to Present

Key Areas of Impact:

Responsible for budgeting and forecasting, expense reporting, risk management, status reporting, and execution

Create project documentation and strategy plans

Account for complete project lifecycle from inception to closure

Collaborate with participants to determine project timeline

Map projects for budget tracking

Developed different Power BI dashboards for CSR team.

Implemented Power BI Deployment Pipelines successfully and used it to migrate dashboards from Dev till Prod.

Manage SQL server jobs to provide data for Power BI Dashboards.

Implemented community portal reports and integrated with ATT CSR community.

Provided important data insights into the CSR teams at Company, State president view.

Created multiple YTD. MTD Operational view for Organization leaders. Smile Direct, Nashville, Tennessee

Sr. Power BI Expert March’21 to June’21

Key Areas of Impact:

Developed different Power BI dashboards for executives.

Understood and implemented the Automation Anywhere bots with relevant level of logging and status for each batch processing.

Created dashboard to view insights of Automation Anywhere bots running and the trends of each bot with success percentage etc.

Programming

Languages: Cloud/Azure Tools: Tools & Packages: BI Tools: Power Platform: T-SQL Azure SQL Server

SQL Server

Management studio SSIS Power Apps

Power shell Azure Synapse Analytics SQL Profiler SSAS Power BI C# Azure Data Factory SQL Server Data tools Alteryx Power Automate VB scripts Azure Analysis Services Database Tuning Power Virtual Agents Lambda Functions Azure Blob Storage Advisor Power BI Python Azure Data Lake DTS

Azure Databricks Project Online

Azure Logic Apps

Azure Functions

Azure DevOps

Amazon Redshift

SQL Workbench

PROTECTED 関係者外秘

Created key KPI’s Operation metrics dashboard for the executives to view the status of each Business Unit

Created dashboards in Power BI pulling data from Service now for different teams reporting on Incident and Task data.

Create and maintain the ADF Pipelines for the ETL from different source

Created a data warehouse model for storing the logging information for Automation Anywhere bots.

UPS, Alpharetta, Georgia

Azure Engineer / Power BI Expert August’20 to March’21 Key Areas of Impact:

Responsible for budgeting and forecasting, status reporting using Microsoft Project Online.

Collaborate with participants to determine project timeline.

Developed different Power BI dashboards on Customer systems.

Create and Maintain the ADF Pipelines for the ETL from different source

Responsible for providing solutions to have the new Source system data into data warehouse.

Connect with client and stake holders to lay down the plan for releasing and onboarding different source systems into data warehouse enabling the Customer facing UI.

Responsible for maintaining and providing the data to the UI application which customer use to track their shipment.

Creating tabular Azure Analysis services cube hosting different measures for company level KPI’s.

Enhancements made to add new KPI’s to the tabular model.

Implementing different Performance improvement strategies to ensure best performing code from the data warehouse.

Creation of Enterprise level Power BI dashboards for different data analytics.

Creation of Summary layer for the Front-end team to access to provide only details which are needed by the front end.

Implementing the different Incremental update logic for summary layer to ensure smooth data movement and avoid any data full loads.

Toyota, Plano, TX

Azure Engineer / Power BI Expert January’20 to August’20 Key Areas of Impact:

Detailed Support to Customers of Microsoft Azure in Develop, Debug, And Migration of on Premises Infrastructure into Public or Private Clouds.

Developed different Power BI dashboards on Dealer systems.

Developed dashboards for Market Share for Toyota, helping in understanding the Market share by different demographics parameters.

Responsible for maintaining the Amazon Redshift data warehouse for different projects.

Responsible for maintaining the Lambda functions which populate different loading and transformations within the lambda functions.

PROTECTED 関係者外秘

Responsible to configure alert notification to monitor CPU matrices, VM server health and events logs.

Creating tabular Azure Analysis services cube hosting different measures for company level KPI’s.

Enhancements made to add new KPI’s to the tabular model.

Planning and implementing capacity planning, data archiving, backup/recovery strategies, Performance Analysis and optimization.

Creation of Enterprise level Power BI dashboards for different data analytics.

Setting up RPA code for downloading source files from a company portal.

Automation for the pumping the data from source files into the Azure SQL DB. 7 Eleven Inc, Irving, TX

Azure Engineer / Power BI Expert October’18 to December’19 Key Areas of Impact:

Detailed Support to Customers of Microsoft Azure in Develop, Debug, And Migration of on Premises Infrastructure into Public or Private Clouds.

Responsible to Configuring and managing Virtual Machines, Storage, network and applications using Windows Azure portal.

Setting up hybrid cloud environments, backup and disaster recovery solutions and migrating On- Prem servers into Cloud.

Planning and implementing Disaster Recovery solutions, capacity planning, data archiving, backup/recovery strategies, Performance Analysis and optimization.

Performed the Test Failover, Managed Failover and Failover of the Virtual machines that are Migrated.

Worked on the Application Insights to collect the telemetric data for Web apps and Log Analytics using the Kusto Query Language to collect the Azure IAAS log data and export to Power BI.

24/7 monitoring the Azure Resources using Azure Monitor and Web Apps for Application Insights and used Nagios/Grafana Monitor Tool to troubleshoot services, root cause analysis and security solutions.

Migration of existing SSRS reports to Power BI.

Create new Power BI Dashboards giving the users insights about Over all Business.

Performance improvement of Power BI reports in Refresh time taken each time it is refreshed.

Worked on different data modelling in Power BI Desktop to reduce the file size and which in turn improved the performance

Understanding the different business requirements and freeze the requirements to lay design of the Dashboards user is looking for Manage the Team offshore in Scrum/Agile model to make sure we meet the deadlines in each area of work

Work on various automation tasks where user can do load testing using PowerShell. Mr Cooper, Coppell, TX

Azure Engineer / Power BI Expert April’18 to October’18 Key Areas of Impact:

Conducted capacity planning and architecture of Storage Accounts.

Monitoring all the clusters health that are in Windows Azure environment and initiate the recovery action for the degraded/dead clusters which fall under threshold limit.

Investigate and troubleshoot the faulty nodes which are moved to Human-Investigate/Out-for- Repair state by the Fabric with respect to fault codes and fault reasons.

Investigating the fabric logs to find unidentified issues and diagnose the root cause of the issue.

PROTECTED 関係者外秘

Working on the faulty nodes that are out of production and recovering them to make the cluster healthy and available for the customers.

Led automation of Azure deployments utilizing PowerShell.

Migration of existing Excel reports to Power BI.

Analyze the existing reports and create mapping document of each element used in the report.

Create on fly running queries from the Service Data warehouse using the transformations identified i n the Analysis phase.

Create stored procedures to transform the data in the fact and prepare the customized Dimension. Zurich Insurance, Schaumburg, IL

Azure Engineer / Power BI Lead December’17 to March’18 Key Areas of Impact:

Mapped workloads to the capabilities of Microsoft Azure for public, private and hybrid clouds. The roles and responsibilities include:

Choosing the VM or Service as per the requirements.

Creating Virtual Networks as per the address spacing and joining VM's/Cloud Services to the VNETs.

Importing, Modifying and exporting network configuration files.

Configuring Cross-Premises connectivity (Point-to-Site/Site-to-Site/VNET-to-VNET) VPNs.

Configuring Auto Scaling, Availability sets, Load Balancing, Health Probes, Logging Alerts.

Creating, registering and attaching VHDs and Data disks on to the VM.

Installing VMs agents and Extensions and custom scripts on Virtual machines.

Migration of existing SAP BO reports to Power BI.

Migrate the existing database from Netezza to Azure SQL.

Create Pipelines for copying data over from the Netezza csv files to Azure SQL. Microsoft, Bellevue, WA, USA

Business Intelligence (BI) Lead June’16 to November’17 Consultant for design and development using Azure SQL, SQL Server Databases, ETL, SSIS, SSAS within the Bing advertising team powering pay per click advertising in Bing and Yahoo search engines Key areas of impact:

Migration from On-premise to Azure SQL.

Lead for the solution to come up with alternative for SSAS cubes.

Migration from On-premise to Azure SQL.

Responsible for budgeting and forecasting, status reporting, and execution using Gantt charts in Microsoft Project Online.

Create project documentation and strategy plans with Project plan.

Account for complete project lifecycle from start to close using project timeline views

Collaborate with participants to determine project timeline using Gantt charts.

Map projects for budget tracking

Worked on Power BI reports for extracting the customer critical data for analysis.

Performance tuned the Daily monitoring jobs and workflows.

Provided Automation solutions using internal Ads Pulse reports.

SME for the current system and handled multiple major releases involving multiple team

synchronizations.

Involved in critical migration of cubes to Azure databases.

PROTECTED 関係者外秘

Leading the project for using an Excel ad-in for giving the similar experience of the cube. Farmers Insurance, Los Angeles, USA

Data Analyst Lead Jun ’15 to May ‘16

Data Analyst lead consultant for data design, data analytics using statistical techniques, ETL, Power BI, SSIS, providing reports and services in different types of business entities like Farmers Insurance, Farmers Reinsur ance

and Accident and Health.

Key Areas of Impact

1. Drastic improvement of performance by redesigning ETL framework 2. Automation implemented using excel data load using Macros 3. Resolved many design and development issues of BI. 4. Automated monitoring and server job processes

5. SME for the Insurance domain for the project.

Microsoft – Hyderabad, India

Senior Business Intelligence Developer Dec ‘09 to Jun ’15 BI developer consultant for developing and working with the design development in maintaining the Licensi ng data

system.

Key Areas of Impact

1. Created SSIS packages to pull data from different data sources. 2. Performance tuned the querying of the data for reporting purpose. 3. SME in designing and development of ETL framework 4. Migration to SQL 2012 and key features were completed. 5. Extensively worked on the data transformation within the SQL using multiple servers to sync the data. 6. Translated the business requirements to the technical ETL design specifications

Contact this candidate