Rahman Mohammed Abdul
BI Solution Consultant
Dallas
Summary
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
16
16
years of professional experience
Work History
Business Intelligence Lead
UPS
01.2023 - Current
- 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.
- 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.
Sr. Power BI Expert
ATT
06.2021 - 01.2023
- Responsible for budgeting and forecasting, expense reporting, risk management, status reporting, and execution
- Create project documentation and strategy plans
- Collaborate with participants to determine project timeline
- 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.
Sr. Power BI Expert
Smile Direct
03.2021 - 06.2021
- 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.
- 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.
Azure Engineer / Power BI Expert
UPS
08.2020 - 03.2021
- 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.
Azure Engineer / Power BI Expert
Toyota
01.2020 - 08.2020
- 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.
- 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.
Azure Engineer / Power BI Expert
7 Eleven Inc
10.2018 - 12.2019
- 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 Overall 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.
Azure Engineer / Power BI Expert
Mr Cooper
04.2018 - 10.2018
- 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.
- 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 in the Analysis phase.
- Create stored procedures to transform the data in the fact and prepare the customized Dimension.
Azure Engineer / Power BI Lead
Zurich Insurance
12.2017 - 03.2018
- 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.
Business Intelligence (BI) Lead
Microsoft
06.2016 - 11.2017
- 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.
- Leading the project for using an Excel ad-in for giving the similar experience of the cube.
Data Analyst Lead
Farmers Insurance
06.2015 - 05.2016
- 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 Reinsurance 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.
Senior Business Intelligence Developer
Microsoft – Hyderabad
12.2009 - 06.2015
- BI developer consultant for developing and working with the design development in maintaining the Licensing 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.
Education
Bachelor of Science - Electrical And Electronics Engineering
Muffakhamjah College of Engineering And Technology
Hyderabad, India 05.2001 -
Skills
Power BI Developer
Microsoft SQL Server
Azure Data Factory
Power Apps
Timeline
Business Intelligence Lead
UPS
01.2023 - Current
Sr. Power BI Expert
ATT
06.2021 - 01.2023
Sr. Power BI Expert
Smile Direct
03.2021 - 06.2021
Azure Engineer / Power BI Expert
UPS
08.2020 - 03.2021
Azure Engineer / Power BI Expert
Toyota
01.2020 - 08.2020
Azure Engineer / Power BI Expert
7 Eleven Inc
10.2018 - 12.2019
Azure Engineer / Power BI Expert
Mr Cooper
04.2018 - 10.2018
Azure Engineer / Power BI Lead
Zurich Insurance
12.2017 - 03.2018
Business Intelligence (BI) Lead
Microsoft
06.2016 - 11.2017
Data Analyst Lead
Farmers Insurance
06.2015 - 05.2016
Senior Business Intelligence Developer
Microsoft – Hyderabad
12.2009 - 06.2015
Bachelor of Science - Electrical And Electronics Engineering
Muffakhamjah College of Engineering And Technology
05.2001 -
Similar Profiles
Michael DeppeMichael Deppe
Operations Full-Time Supervisor at UPSOperations Full-Time Supervisor at UPS
Adam Brown JrAdam Brown Jr
Warehouse Worker at UPSWarehouse Worker at UPS
Matthew LangfordMatthew Langford
On Car Supervisor at UPSOn Car Supervisor at UPS
Dakota OlsonDakota Olson
Pre-Loader at UPSPre-Loader at UPS
Emily MartinEmily Martin
Vice President Client Services at Business Wise IncVice President Client Services at Business Wise Inc