AMIT M

Data Analyst / POWER BI Consultant

adkebh@r.postjobfree.com

Professional Summary:

Having 6+ years of experience working in the field of data analysis, data validation, ETL and data visualization with fortune 200 and Forbes 119 organizations; 2+ years of experience in PowerBI data visualization and analysis

Data acquisition, financial trend analysis, forecasting experience with large datasets using SQL and PowerBI

Provided cost and usage analysis using PowerBI and created 8+ dashboards that helped to save $200,000 per year.

Experienced Business Intelligence and Data Analyst with a demonstrated history of working in the Commutation Industry, Education, and working with Sales teams.

Strong information technology professional skilled in Analytical Skills, Power BI, Databases, Data Security and SQL.

Solutions-oriented with notable success directing a broad range of threat prevention and analysis initiatives.

Good knowledge in RDBMS concepts and capability to design relational databases model and implementation as per business needs.

Adept at receiving and monitoring data from multiple data streams, including AWS, AZURE, SQL and Excel data sources

Bringing forth the ability to synthesize quantitative information and interact efficiently with colleagues and clients

Proven track record of generating summary documents and monthly reports for senior management for monthly and quarterly audit and compliance reporting

Work alongside agile development teams to help improve completeness, accuracy and timeliness of datasets

Specialized in the Healthcare sector with an impressive background of providing data analysis to answer important ad-hoc business questions for minimizing the risk

Created data into actionable insights by predicting and modelling future outcomes using Excel Power pivots and Power Queries

Analyzing business data to develop Key performance indicators and building dashboards to visualize important trends and goals for decision making

Developed Tableau & Power BI dashboards to provide visual recommendations to branch managers and end users.

Experience in data extraction, transforming and loading (ETL) using tools such as SQL

server integration services (SSIS) involving migrations and sync processes between two databases

Performed detailed data validation spanning across different projects

Expert in writing queries, views, tables, Joins and DDL/DML triggers for data consistency and data manipulation using SQL

Extensively used DML and DDL queries to understand data flow

Implemented Power BI gateway different source to matching analysis criteria and further modeling for Power Pivot and Power View

Designed Power BI data visualization utilizing cross tables, maps, scatter plots and pie charts

Used analysis and visualization tools such as SQL and Excel to analyze data and design a credit scoring model to provide reliable insights to upper management and the financial team

Strong investigative and troubleshooting skills.

TOOLS & FRAMEWORKS

Visualization Tool: PowerBI, Tableau, SAS Business Analytics

ETL Tools: SQL, SSIS, Advance MS Excel (Macros, Vlookup, Pivot Table,Forecasting)

Programming languages: Python (Pandas, NumPy, Matpoltlib, Seaborn), PowerBI DAX

Cloud Technology: AWS, Azure

Database Management Tools: MS SQL Server (SSIS, SSMS), Oracle

Certification

AWS Certified Cloud Practitioner (CLF)

PROFESSIONAL EXPERIENCE:

Project # 1

Atkins North America, Denver, CO. Nov 2019Dec 2020

Data Analyst - Colorado Department of Transportation (CDOT)

Roles & Responsibilities:

Translated the business problems into analytical for financial modelling for highway construction projects

Designed and developed data models and integrations of multiple systems to help inject data into visualizations

Financial risk analysis and management of more than 250 construction projects using PowerBI dashboards

PowerBI helped in data modelling, data analysis and reporting for fiscal as well as calendar year analysis

Utilized T-SQL, PowerBI DAX to build new analysis and maintain existing reporting

Used PowerBI visualizations to help optimize all the funding assigned to various Colorado state projects

Acted as liaison between analytical team and CDOT project management team

Used modern data wrangling tools and techniques to inspect and transform data

Worked with features like drill down, drill through to reveal additional details

Developed technical leave behind documents and user help guides

Las Vegas Department of Transportation (LVDOT)

Used PowerBI visualizations to help LVDOT team in incoming and outgoing mail management

Used AWS cloud technology to store and transform data and even provided access using IAM roles

Created AWS S3 buckets and SQL server instance in AWS redshift to connect it to PowerBI for further analysis

Project # 2

Centura Health, Centennial, CO Sept 2018- Nov2019

Developer / Data Analyst

Roles & Responsibilities:

Translating the business problem into analytical for financial modelling and lease analysis using data visualizations

Increased the customer retention rate from 78% to 84% using PowerBI dashboards supporting the management team

Risk analysis and management of more than 300 leases using Python seaborn, pandas, Numpy libraries

Transformed and integrate data using python to help generate insights and meet reporting needs.

Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations

Interpret data, analyze results using statistical techniques and provide ongoing reports using Microsoft SQL Server SSMS and Power BI

Building queries to create stored procedures, user defined Functions, Views, Triggers and CTEs (Common Table Expressions) for complex financial business requirements

Create, modify and troubleshoot SQL queries, stored procedures and jobs

Connected to different data sources (SQL Server,AWS, Azure) and flat files to create and develop various complex reports as per given business requirement using Power BI

Developed Power BI Dashboard using Chart (Drill Down, Drill up & Cyclic Grouping), List box, Input Field, Table Box and Calendar.

Used Power query and created Power Pivots to fetch large data from Server on to MS Excel for further analysis

Utilized Excel and Power Pivots to analyze and present weekly progress updates to senior management.

Participated in various ad-hoc projects to assist process improvements and provided analytical monthly analysis presentations with long-range strategic plan and overall performance to the executive team.

Used Power BI to create various analytical dashboards that depict critical KPIs such as Region, Hospitals, account number, sub account numbers, project owner, equipment and lease status

Responsible for training other analysts on my team for various projects

Built PowerBI dashboard for pricing analysis and vendor management using forecasting and variance analysis.

Built T-SQL queries for data retrieval from internal and external sources such as SSMS for trend analysis of leases.

Using PowerBI DAX queries for financial modelling, billing process & visualizations to accelerate business decisions.

PowerBI is helping in statistical modelling, data analysis and reporting for fiscal as well as calendar year accounting

Project # 3

Century Link, Broomfield, CO, May 2018 – July 2018

BSA/ Data Analyst

Created complex SQL queries using joins, grouping, aggregation, nested queries to resolve key performanceissues

Performed data profiling for anomalies, gathered data, performed analysis and reported to senior leadership

Experienced in using SQL for tableau and writing parameterized queries for formatting the report

Developed usage and summary reports by verticals using Tableau and present these findings by presentations.

Involved in the development of Data Layer and created packages and stored procedures in SQL Server 2012.

Developed various Charts and Graphs like bar charts, line charts, pie charts etc. by using chart experts.

Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.

Daily support, troubleshooting, monitoring, optimization and tuning of SQL server environments across entire system.

Performed SQL Server software new installation and upgrades.

Extracted data from Excel and Flat file to MSSQL Server by using SSIS SSMS services.

Responsible for SQL Server production database to operate efficiently and securely.

Project # 4

Wipro Infotech June 2015 – June 2017

Business Intelligence Developer

Roles & Responsibilities:

Worked as a liaison to understand business requirements and KPI to translate them into Power BI based solutions

Data visualization using an internal tool- IDAM to represent performance related data

Successfully managed to reduce the query resolution time by 10% through process optimization

Building Power BI Data Models for regional data representation with multiple fact table and over 10M records

Helped reduce spending by 18% by financial modelling, as well as boosted revenue saving by 15%

Extracted and combined data from multiple sources within PowerBI to create executive level performance reports

Created packages to Extract, transform data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations

Used PowerBI DAX queries for Level 1 ticket resolution and network device maintenance reports

Used PowerBI visualizations for infrastructure maintenance reports and to accelerate business decisions

Created multiple dashboards to track material supply and production dashboard for each facility location.

Integrated Custom Visuals based to account for unique business requirements using Power BI desktop

Conducted data analysis on how to best support users and delivering the best services

Best Employee Award for the month July-2016

EDUCATION

University of Colorado Denver, Business School, Denver

Master of Science, Information Systems; 3.8 GPA

Shah and Anchor Kutchhi Engineering College

Bachelor of Engineering in Computer Engineering; 3.0 GPA

AFFILIATIONS / COMMUNITY SERVICE

EpicPM, CU Denver Chapter, Project Manage(http://www.epicpm-ucdenver.org/) Information Systems Association, CU Denver, Business School

Contact this candidate