Akshay

Sr. MSBI/Power BI Developer

Professional Summary-

 Over 7+ years of experience in implementation & administration of Power BI, PowerApps,

SSRS, SSIS, Tableau, R and Python, and Microsoft SQL Server 2019 in development, testing
and production environment.
 Microsoft certified- Power BI, SQL Server, Azure Developer, Dynamics 365.
 Excellent working knowledge of Software Development Life Cycle (SDLC) and Software
Testing Life Cycle (STLC), Requirements gathering, Analysis, Design, Development,
Implementation and Testing, Methods like Agile/Scrum, Waterfall, Business Process and
Data Modeling with emphasis on Software Quality Assurance including Functional and
Integration testing.
 Extensive experience working on SSIS to create, maintain and troubleshoot SSIS/ETL
packages to validate, extract, transform and load data to data warehouse databases.
Performance tuning on existing ETL packages.
 Proficient in MySQL, SQL Server, Pl/SQL and T-SQL (DDL and DML) in constructing
Tables, Normalization techniques on database Tables.
 Highly experienced in Designing, Developing and Deploying various reports like Tabular,
Matrix, Chart, Drill down, List, Ad-hoc, Parameterized, Cascading and other reports using
SSRS. Worked on Subscriptions, scheduling snapshots, managing snapshot history. Expert in
managing the report manager and report server.
 Created Report Models for ad-hoc reporting and analysis using SSAS. Extensively involved
in the design of SSAS & Tabular storage, partitions and aggregations and developed different
calculated members, KPIs, actions by using the MDX & DAX while designing the cube
using SSAS.
 Experience in Angular 2, HTML, CSS, NodeJS, JavaScript, TypeScript.
 Thorough knowledge in data warehouse concepts, Relational Database Management Systems
(RDBMS), Normalization, Data Modeling and Documentation. Involved in Data modeling
by using Erwin tool.
 Experience developing new PowerApps canvas and model driven apps as well as enhancing
existing apps.
 Experience in using Microsoft Power Automate to automate business processes.
 Experience in developing custom connectors in MS PowerApps.
 Extensive knowledge of addressing performing issues and involved in performance tuning,
index tuning, Data Profiling and query optimization.
 Experience on publishing Power BI reports on dashboards in Power BI server. Designed and
developed Power BI graphical and visualization solutions based on business requirement.
 Expert with the backend data retrieval team, data mart team to guide the proper structuring of
data for Power BI reporting.
 Identified gaps in data collection, the data model, and metadata for future enhancements.
 Created simple to complex data, reporting, and business intelligence solutions by utilizing
existing reporting, analytics and business intelligence platforms.
 Proficient in MySQL, SQL Server and T-SQL (DDL and DML) in constructing Tables,
Normalization techniques on database Tables.
 Well experience in Data Extraction, Transforming and Loading (ETL) using various tools
such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
 Used MS SSIS to create SSIS tasks such as Conditional Split, Derived Column, which were
used for Data Scrubbing, data validation checks during Staging and before loading the data.
Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data
Warehouse using SSIS.

Software Skills

Database Technologies SQL Server 2019, Oracle 10g SQL, PLSQL, Oracle 11g/12c,
Azure Cosmos DB, Azure Data Lake, Data Bricks, Azure SQL
Server, CDS (Common Data Service)
Programming Languages MySQL, SQL, T-SQL, HTML, HTML5, CSS, XML, C#, Python
Business Intelligence Tools MSBI (SSIS, SSRS & SSAS), Metadata, PowerApps
IDEs /Tools MS Visual Studio 2019, SSMS
Other Tools MS Office Suite (Word, PowerPoint, Visio), OLAP, OLTP, TFS,
JIRA. MS Dynamics 365, ERWIN, Informatica
ETL Tools Data Transformation Services (DTS) – Export/Import, SQL Server
Integration Service (SSIS), Tableau Prep, Power Qwery
Reporting Tools SSRS 2019, Tableau, Power BI, Crystal Reporting, Webi
Reporting, Microsoft Access, Excel.
Automation Tools UiPath

Education

 Master of International Marketing & Project Management – Hult International

Business School – Boston, MA
 Bachelor of Computer Application – University of Rajasthan – Jaipur, Rajasthan

Professional Certifications –

 Analyzing and Visualizing Data with Power BI

 Developing SQL Databases
 Microsoft Dynamics 365 Customization and Configuration
 Developing Microsoft Azure Solutions
 Certified SAFe® 4 Scrum Master
 UiPath – Robotics Process Automation
 Certified Web Designer (CWD)
 Google Analytics
Professional Work Experience –

Chevron Corporation – San Ramon, CA/Houston, TX

August 2019 – May 2020
Sr. Power BI/MSBI Developer
Description- Chevron is the world’s leading and largest Oil and Gas producing company. The
scope of Permian Optimization Model (POM) is to optimize Chevron’s crude value chain,
starting from the Midland gathering point (Source location) to the end customers (Sales
location). The primary objective of the POM model is to evaluate optionality and provide a tool
for portfolio evaluation through scenario analysis to maximize the total netback margin. This
model will allow decision makers across Supply and Trading (“S&T”) and leadership to make
informed data-driven decisions and perform their current jobs more effectively.

Responsibilities:
 Created SSIS Packages to integrate data coming from Text files and Excel files.
 Directly involved into requirement gathering and understanding business functions with the
end users.
 Used Microsoft Power BI to Build and maintain the reports and dashboards and built the
custom applications on PowerApps.
 Modified existing dashboards as per new requirements in Power BI. Recreated reports from
MS Excel to Power BI. Explore data in a Variety of ways and across multiple visualizations
using Power BI.
 Created custom visuals using R and Python in Power BI as per the business requirements.
 Created and maintained apps on PowerApps as the business requirements. Created front end
application using workflows and dataflows.
 Extensively pulled the data from Cosmos DB into Power BI to generate the reports.
 Wrote complex DAX functions in Power BI and Power Pivot. Used various sources to pull
data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure, CDS (Common Data
Service).
 Created SSIS packages to validate, extract, transform and load data-to-data warehouse
databases and deployed with minimal changes using XML configuration file.
 Generated matrix reports, drill down, and drill through, sub reports.
 Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc
reports through report builders.
 Implementing SSRS solutions, used dashboards and gauges to enhance for the business
users.
 Used best practices in managing the administration and security of the Power Platform –
Power BI, Power Apps, and Power Automate.
 Used connectors, leverage the AI Builder, design Power BI dashboards, build canvas apps,
build Power Apps portals.
 Leveraged Power Automate to create business process flows as per the business requirement.
 Implemented application design and development across multiple technology areas.
 Developed product, platform prototypes, and proof of concepts across the technology stack
 Driven the consistent quality solution development and delivery in PROD environment.
 Developed the internal capability with the Power Platform to support company operations.
 Developed integrations using for PowerApps in the Azure platform.
 Worked on pull the data from the SSAS Cubes for the reporting purposes.
 Worked on Development and implementation of SSRS reports and ran them as per the
requirement.
 Generated daily, weekly and monthly reports for the managers.
 Developed complex SQL queries using stored procedures, common table expressions
(CTEs), temporary table to support Power BI and SSRS reports.

Blue Shield of California – Sacramento, CA

April 2019 – August 2019
Power BI/MSBI Developer
Description – Blue Shield of California is an independent member of the Blue Shield
Association, is a nonprofit health plan dedicated to providing Californians with access to high-
quality health care at an affordable price.
Responsibilities:
 Effectively interacting with the end users for requirement gathering and defined requirement
specifications document. Experience in the development of business, technical, and
administrative requirements for a project.
 Developing business focused automated reports using tools such as SSRS and Power BI as
well as building necessary SQL data objects used by reports.
 Using SSIS to create maintain and troubleshoot ETL packages to validate, extract, transform
and load data to data warehouse databases. Performance tuning on existing ETL packages.
 Analysis the metric dashboard reports and identified the formulas and functionality of the
dashboard reports and digitizing the metric dashboards to Power BI application.
 Designed and developed loss and decline report using MS SQL Stored procedure and DAX
functions in Power BI and Power Pivot.
 Maintained existing reports requests built on R and Python in Power BI. Also, created
custom visuals using R and Python in Power BI as per the business requirements from
scratch.
 Provided users with time being excel reports and used it as process improvement for the final
report in Power BI.
 Wrote calculated columns, measure queries in Power BI desktop to show good data analysis
techniques. Designed and developed stored procedures & used Power BI desktop to render
the report.

Environment: MS SQL Server 2016, Power BI, Salesforce, Google Analytics, SQL Server
Reporting Services, SQL Server Integration Services (SSIS), SSRS, CTD, ESRI GIS, Salesforce.

Covered California – Sacramento, CA

Oct 2017 – March 2019
Power BI/MSBI Developer
Description: CalHEERS (California Healthcare Eligibility, Enrollment and Retention System) is a
web-based system that will determine eligibility and facilitate plan enrollment for Exchange health
plans, federal subsidies, and for MAGI* Medi-Cal. This “Exchange” is an online marketplace for
individuals, families and small businesses to compare, and purchase, different health insurance plans.
California’s Exchange has been named “Covered California.” Worked on MediCal, Medicaid, and
Medicare projects.
Responsibilities:
 Identified the required data objects in the database and created various T-SQL, PL/SQL, and
OLAP data structures complex queries to pull data for reports.
 Experience working with Healthcare-related EDI files (834, 835, 837). Working knowledge
of the health care industry EDI transaction sets including the 5010 file layouts.
 Analyze business requirements and data sources from Salesforce, Excel, Oracle, SQL Server
for design, development, testing, and production rollover of reporting and analysis projects
within Power BI Desktop. Fine-tuned SQL Queries for maximum efficiency and
performance. Used SQL and Excel to cleanse and perform calculations against data.
 Modified existing dashboards as per new requirements in Power BI. Recreated reports from
MS Excel to Power BI. Explore data in a Variety of ways and across multiple visualizations
using Power BI.
 Wrote complex DAX functions in Power BI and Power Pivot. Used various sources to pull
data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure.
 Installed and configured Enterprise gateway and Personal gateway in Power BI Service.
 Developed various types of transformations that are available in Power BI query editor
 Created stored procedures and SQL queries to pull data into PowerPivot model.
 Participated in project planning sessions with project managers, business analysts and team
members to analyze business requirements and outline the proposed solution.
 Extensively used Joins and Sub-Queries to simplify complex queries involving multiple
tables.
 Converted 20+ excel reports into Power BI reports using R and Python custom visuals.
 Created new reports for marketing and sales teams using Google Analytics, R and Python.
 Involved in SQL queries tuning and improved the performance of Informatica session.
 Created informatica workflows and added the tasks like e-mail and Command.
 Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
 Transformed complex business logic into Database design and maintaining it by using SQL
objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
 Created Jobs Performance report that queries system tables to track the duration of each job
and weekly-average duration using SSRS.
 Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
 Developed confidential proprietary analytical tools and reports with Excel, and Power Pivot
and Power Point.
 Configure and maintain using Report Manager and Report Server for SSRS, Deployed and
Scheduled the Reports in Report Manager
 Created Reports using Charts, Gauges, Tables, matrix. Created Parameterized Report,
Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.
 Developing business focused automated reports using tools such as SSRS and Power BI as
well as building necessary SQL data objects used by reports.
 Working with Data Warehouse and related technologies such as Microsoft SSIS, SQL, ETL,
and OLAP data structures.
 Designing and developing various complex reports using drill down, drill through, sub
reports, cascade parametric, linked, and cross tabbed reports using SSRS.
 Demonstrating experience creating, debugging, and modifying complex stored procedures
and views, as well as querying and updating data using SQL.
 Built cubes for production application, Partitioned Cubes to decrease the processing time and
increase the performance of the queries running on front end application using SSAS.
 Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and
Extending OLAP Cubes, Dimensions, and data source view.
 Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from
different environments for the SSAS cubes.
 Involved in Troubleshooting of the already existing SSIS packages.

Environment: MS SQL Server 2016, Power BI, Tableau Desktop, Server, and Prep, Salesforce,
Google Analytics, SQL Server Reporting Services, SQL Server Integration Services (SSIS),
Dynamics 365, ETL, Business Objects XI 4.0/3.1, Crystal Reporting 2013/2008, Info View,
CMC, Visual Studio, OLAP, JIRA, Linux.

Sallie Mae Inc. - Boston, MA

September 2016 to October 2017
Business Intelligence/Report Developer
The project consisted of enhancing the current applications that provides various services to
customers and corporate.
Responsibilities:
 Facilitated gathering and analyzing business requirements and translating the same into
system / technical requirements.
 Analyze business requirements and data sources from Excel, Oracle, SQL Server for design,
development, testing, and production rollover of reporting and analysis projects within
Tableau Desktop.
 Create views in Tableau Desktop that are published to internal team for review and further
data analysis and customization using filters and actions.
 Designed Summary and Detailed reports using Data Blending and cascading feature
in Tableau to provide dependency on objects through filters. Helped Tableau power users in
optimizing their tableau reports with proper use of filter, optimized SQL queries etc.
 Created action filters, parameters and calculated sets for preparing dashboards and
worksheets in Tableau.
 Created customized reports using various chart types like text tables, bar, pie, tree maps, heat
maps, line charts, pivot tables, combination charts.
 Worked a great extent with the design and development of Tableau visualizations which
includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets
and hierarchies etc.
 Created numerous dashboards in Tableau Desktop based on the data collected from financial
reporting System by importing and blending data from MS Excel and CSV files along with
MS SQL Server Databases.
 Developed reports and dashboards for service center telephony data, interactive voice
response (IVR), workforce management.
 Develop important key performance indicators (KPI) metrics for the service center using
Tableau.
 Developed visual analytics reports and dashboards.
 Improved performance of the dashboard at report level, by reducing the scope of the
visualization with respect to sheet and data sources, reducing number of filters in the view,
creating efficient calculations.
 Performed Smoke Testing, Functional Testing, Regression Testing, Integration
Testing, UAT Testing and Localization Testing. Experience working with UAT testers
in UAT environment.
 Designed and developed various analytical reports from multiple data sources by blending
data on a single worksheet in Tableau Desktop.

Environment: MS SQL Server 2014/2012, SQL Server Management Studio, MS Excel, SQL
server Reporting Services (SSRS) 2012/2008, SQL Integration Services (SSIS)2012/2008, SQL
Analysis services (SSAS)2012/2008, Microsoft Visual Studio 2010/2008, T-SQL, VB.Net,
Java, Power BI.

Bindal Infotech – India

June 2014 – July 2015
Business Data Analyst
Description- Worked on 5 different projects with healthcare, financial, banking, public sector
clients.
Responsibilities:
 Involved in Technical decisions for the Business requirement, Interaction with Business
Analysts, Client team, Development team, Capacity planning and Upgrading of SQL Servers
 Developed stored procedures, views and User Defined Functions using T-SQL statements.
 Involved in creating clustered and Non-Clustered Indexes to improve the database
transactions performance.
 Worked a great extent with the design and development of Tableau visualizations which
includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets,
and hierarchies.
 Involved in database development using stored procedures, triggers, views, and cursors.
 Converted, loaded and integrated data from Access, Excel, text.csv files and internal database
applications including the mainframe with data captured for security applications
 Implemented SSIS data transformation scripts, created maintenance procedures and provided
data integrity strategies.
 Developed an SSIS solution for developing a fully-fledged data warehouse solution.
 Created SSIS Packages to import and export data from Excel Spreadsheets, Text files, and
CSV files.
 Generated Daily, Weekly, and Monthly Reports as per the customer requirements using
subscriptions and Created Tabular Reports, Cross Tab Reports, SubReports.
 Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized
and cascading parameterized reports using SSRS.

Environment: SQL Server 2012 Enterprise Edition, Tableau, SQL Server Data Tools, SQL
Server Business Intelligence Development Studio (SSIS, SSRS, SSAS), TSQL, C#, .Net
framework.