Ashwini CN

Senior Power BI Developer/Data Analyst

PROFESSIONAL SUMMARY:

 Having 9 years of professional experience as a Power BI Developer working with various Business Intelligence
tools, Databases and Data warehousing projects.
 Experienced in full SDLC development process including data analysis, data mapping, solution development and
delivering BI solutions.
 Proficient in gathering requirements from Business stakeholders, analyzing, documenting requirement
specifications, BI solution design, Development, Integration, Test planning, UA testing and deploying in
production environments.
 Proficient in identifying KPIs, Trend/Pattern analysis, Forecasting, finding Operational efficiencies, Risk
management, Benchmarking etc empowering teams to take data-driven decisions.
 Experience with data analysis, data modeling and data presentation and importing data from SQL Server,
Teradata, Oracle DB, and API to Power BI/Tableau to generate reports.
 Used Power BI, Power pivot to develop data analysis prototype, and used Power View and power map to
visualize reports.
 Conducted thorough testing of APIs, including functional testing, performance testing, and error handling
validation.
 Excellent knowledge on Power Query Parameters, Query Lists, Tables, Records and having expertise in
Cleansing and Transforming data with Power Query Editor.
 Experience in adjusting cross filter direction for a complex set of tables and relationships.
 Hands-on experience in utilizing DAX functions and measures and implemented several DAX functions, which
includes Aggregation, Counting, Logical and date functions for efficient data visualization.
 Strong experience in creating advanced chart types, and complex calculations to manipulate the data as per
business need through Power BI.
 Experienced in developing highly formatted, print-ready paginated reports for strategic and operational
reporting purposes.
 Proficient in utilizing advanced formatting options, including fonts, colors, borders, and conditional formatting,
to enhance report aesthetics and effectively convey information in both Power BI and Tableau.
 Performing regular data audits and ensuring data integrity.
 Identifying and analyzing incidents and problems related to configuration items. Investigating and diagnosing
the root causes of incidents and problems.
 Created and optimized SQL queries for data retrieval, manipulation, and reporting.
 Excellent knowledge in Performance tuning methodologies at data and visualization Level.
 Great team player, strong interpersonal and communication skills combined with self-motivation, initiative, and
the ability to think outside the box.

TECHNICAL SKILLS:

BI Tools Microsoft Power BI, Power Pivot, Power View, Power Query, Power Map, Power Apps,
Power Automation, Microsoft Power BI Desktop, Power BI Service, Tableau, Excel.
Databases MS SQL Server, Teradata, AWS, Oracle, Microsoft Azure on Cloud

Data Modelling Erwin, Visio

MS Office MS-Excel, MS-Access, MS- Power Point, Office 365, SharePoint
Application Packages MS Office, Microsoft SharePoint Server (MOSS)
PROFESSIONAL EXPERIENCE:

Client: Fidelity Investments, NC Jun2023 – Till Date

Role: Sr. Power BI Developer

 Involved in gathering, analyzing, and documenting the business requirements, functional requirements, and
data specifications for reports interacted with the users to analyze the changes for improvement they need in
the existing reports and developed the reports to satisfy their business needs.
 Designed and developed interactive Power BI reports and dashboards, enabling better patient care decisions
and improving healthcare operations.
 Created various dashboards in Power BI desktop using table, matrix, bar, card, gauge, and slicer visualizations.
 Started by understanding the business problem and identified all the KPI’s and started the dashboard by
creating the wireframes from scratch, initially using Power Point and then in Power BI.
 Leveraged Power BI to connect, visualize, and analyze data stored in Azure services, including Azure Data
Factory. Ensured data accuracy, consistency, and compliance with healthcare regulations, including HIPAA.
 Developed and optimized DAX calculations and measures to provide advanced healthcare data analysis and
insights. Worked on transformations that are available in Power bi query editor.
 Skilled in designing data-driven paginated reports with dynamic layouts, interactive parameters, and advanced
expressions. Published visualizations and pinned dashboards in the Power BI Service.
 Strong understanding of report parameterization to provide interactive features, allowing users to customize
report views, apply filters, and dynamically control report outputs based on their requirements.
 Trained and supported healthcare professionals in utilizing Power BI for data-driven patient care decisions
and healthcare operations improvement.
 Configure and deploy Power BI dataset for functional teams, implement incremental refresh on Power BI
dataset.
 Proficient in engineering datasets from Data Warehouses to support business intelligence and reporting needs.
 Created Workspace and Apps in Power BI and giving access to End-users to Apps.
 Configured Gateway in the Power BI service and Implemented Data security (Row-level security) on Dataset
and Reports in Power BI. Worked on Power BI, Power Pivot and Power View to visualize reports.
 Created Drill Down, Drill through, Book Marking and Hyperlinks features in the Power BI report.
 Extensively worked in analyzing profiling and modelling data in the Power BI Desktop using Query Editor and
Relationship view.
Environment: Microsoft Power BI, Power Query, Power BI Service, Oracle, MS Azure on Cloud, SQL Server, MS
office

Client: AT&T, GA May 2019- May2023

Role: Sr. Power BI Developer

 Collaborated with telecom industry experts to understand and translate business requirements into effective
BI solutions using Power BI Desktop to develop data analysis using multiple data sources.
 Created DAX Queries to generate computed columns in Power BI and generated computed tables in Power BI
by using DAX. Extract dataset from different data sources including SQL Server, excel and flat file prepare
datasets for Power BI.
 Played a pivotal role in establishing and maintaining telecom-specific data visualization best practices and
reporting style guides.
 Worked on Power Query in Power BI desktop to edit the queries and Model for data modelling and establishing
the relationships.
 Worked on Power BI service by publishing the Power BI reports onto Power BI server and collaborated team
using Power BI service to create the dashboards.
 Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Line &
Clustered Column Chart, Map, Slicer) in Power BI according to the requirements.
 Produced ad-hoc financial reports and visualizations to support executive decision-making.
 Experienced in Error handling and debugging coding issues and troubleshoot production problems.
 Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to
visualize reports. Published Power BI Reports in the required originations and Made Power BI Dashboards
available in Web clients and mobile apps.
 Used Power BI Gateways to keep the dashboards and reports up to date.
Environment: Power BI, DAX, SQL Server, AWS, Visual Studio

Client: Mayo clinic, MN Jul 2017- Apr 2019

Role: Data Analyst

 Working together with BAs and Business owners to understand business requirements and design BI solutions
to meet the requirements. Involved in the Requirement Analysis, Design phase and Development phase of SDLC
model system.
 Estimating, creating a project plan with timelines based on the requirements and tracking each task on
a weekly basis.
 The chain of hospital facilities data was stored in SQL Database. Worked closely with the database team to
understand the schemas of the table in the database to transform it in a meaningful report as per the desired
output.
 Setting Up Data source connection using Different ODBC Drivers. Data Modelling, Data Migration, and Solution
Sets were taken care in order organize the data in proper structure.
 Merging Multiple Tables of a Data source in to Power BI using Power Query Merge query option.
 With the help of Data team setting up the Data flow structure and type of access required
for the development teams and business users keeping in mind on security/privacy of
certain Data based.
 Data Validation using Excel; simultaneously verifying the data in the Database using SQL. Final Data Validation
using Excel Pivot table/ SQL before the UAT testing.
 Creating various reports to be viewed in multiple type of devices like mobile and tablet view.
 Data Analysis, Optimization and Data Visualization have been done.
 Managing Dashboard access to various users according to the Users role using Power BI services.
 Publishing the Reports into the Production Server. Maintaining of the reports was also taken care to make sure
timely data updates were being refreshed into the reports in a timely manner.

Environment: Power BI, DAX, MS SQL Server.

Client: Softizo, India Jan 2014- Apr 2015

Role: BI Developer

 Participated in project planning sessions with project managers, business analysts and team members to
analyze business requirements and outline the proposed solution.
 Supporting and updating existing reports and providing presentation to the business users about the reports
and their changes as required.
 Developed reports using Report studio as per the business requirements.
 Handled various types of reports like Simple lists, Complex Lists, Cross tabs, Drill through. Drill Down, Chart
etc. Handled conditional formatting, conditional blocks, Cascading Prompts, Prompts, Filters, Functions,
Conditional Variables etc.
 Used set operations like union and joins at query level in report Studio to display data as required by business.
 Providing application support and maintenance. Administering the user access issues.
 Implemented Master – Detail relations in the reports as per the requirement. Used Erwin modelling tool to
create data model diagrams. Worked on HP Quality Centre for testing and defect logging.
Environment: IBM Cognos Report Studio, MS SQL Server, Erwin, Quality Center

 Bachelor’s in Bio-Tech from Bangalore University