We provide IT Staff Augmentation Services!

Azure Engineer / Power Bi Expert Resume

Plano, TX

PROFESSIONAL SUMMARY:

  • Confidential Azure Engineer with 10+ Years of experience in the field of Storage, Cloud Computing and System Center tools which cover intensive exposure to Design, Troubleshooting, Implementation, Deployment and Migrations.
  • 10+ 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.
  • Design and develop Azure Analysis services tabular model cube.
  • Technical lead for providing database solutions and managing the team.
  • 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.
  • Migrated different On-premise databases to Azure Data warehouse using AZCOPY.
  • Automation methods using PowerShell and SQL.
  • Experience with Azure Blob Storage usage and handling files.
  • Experience creating U-SQL script in Azure Data analytics to pull data from different source systems.
  • 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.
  • Extensive experience supporting and providing solutions for data Analyst.
  • Extensive experience in development and design of ETL solutions methodology for supporting data transformation and processing
  • Experience using Data Modeling Tools like Erwin, Visio.
  • Expertise in designing and developing Data marts and Data Warehouses.
  • Meticulous, as well as a team player; my past has taught me the importance of teamwork, attention to detail, and dedication in order to get the mission accomplished.

TECHNICAL SKILLS:

  • MS SQL Server
  • T-SQL
  • Power shell
  • C#
  • V B scripts
  • Lambda Functions
  • Python
  • Azure SQL Server
  • Azure Synapse Analytics
  • Azure Data Factory
  • Azure Analysis Services
  • Azure Blob Storage
  • Azure Data Lake
  • Azure Databricks
  • Amazon Redshift
  • SQL Workbench.
  • SQL Server Management studio
  • SQL Profiler
  • SQL Server Data tools
  • Database Tuning
  • Advisor
  • DTS
  • Visual Studio
  • Team Foundation Server
  • Bit Bucket
  • GIT.
  • SQL Server Integration Services (SSIS)
  • SQL Server Analysis Services (SSAS)
  • Alteryx.
  • Power BI.
  • XML
  • HTML
  • JSON .
  • Visio
  • ERWIN.
  • Power Apps.
  • Power BI
  • Power Automate.
  • Power Virtual Agents.
  • Postman.
  • Visual Studio Code.
  • Azure Data Studio.
  • DAX Studio.

EXPERIENCE SUMMARY :

Confidential, Plano, TX

Azure Engineer / Power BI Expert

Responsibilities:

  • Detailed Support to Customers of Confidential 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 Confidential, helping in understanding the Market share by different demographics parameters.
  • Responsible for maintaining the Amazon Redshift data warehouse for different projects.
  • Responsible for maintain 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.
  • Enhancement’s 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.

Confidential, Irving, TX

Azure Engineer / Power BI Expert

Responsibilities:

  • Detailed Support to Customers of Confidential 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

Responsibilities:

  • 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.
  • Architected automation of Azure Virtual Networks, Network Security Groups and access control rules.
  • Led implementation of Office 365 and Azure Active Directory for single sign on, authentication, authorization and Azure Role-based Access Control (RBAC).
  • Led migration of over 4,000 on premise Virtual Machines to Azure Virtual Machines for multiple global business units.
  • Utilized ASR (Azure Site Recovery), PowerShell and MVMC ( Confidential Virtual Machine Convertor) for on premise to cloud migrations.
  • 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.

Confidential, Schaumburg, IL

Azure Engineer / Power BI Lead

Responsibilities:

  • 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.
  • Designed and configured Azure Virtual Networks (VNets), subnets, Azure network settings, DHCP address blocks, DNS settings, security policies and routing.
  • Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.
  • Designed VNets and subscriptions to confirm to Azure Network Limits.
  • Exposed Virtual machines and cloud services in the VNets to the Internet using Azure External Load Balancer.
  • Provided high availability for IaaS VMs and PaaS role instances for access from other services in the VNets with Azure Internal Load Balancer.
  • Implemented high availability with Azure Classic and Azure Resource Manager deployment models.
  • Designed Network Security Groups (NSGs) to control inbound and outbound access to network interfaces (NICs), VMs and subnets.
  • Setup Azure Virtual Appliances (VMs) to meet security requirements as software based appliance functions (firewall, WAN optimization and intrusion detections).
  • 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.

Confidential, Bellevue, WA

Business Intelligence (BI) Lead

Responsibilities:

  • Migration from On - premise to Azure SQL.
  • Lead for the solution to come up with alternative for SSAS cubes.
  • Worked on Power BI reports for extracting the customer critical data for analysis.
  • Performance tuned the Daily monitoring jobs and workflows.
  • 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.

Environments: MS SQL Server Azure/ 2016/2014/2012/2008 R2/2008, Visio, MS SQL Analysis Services 2012, TabularModel, MS Integration Services, Power BI (Power Pivot, Power View, Power query), Power Shell, XML, MS Excel, Visual Studio 2015, GIT

Hire Now