Summary
Overview
Work History
Education
Skills
Timeline
Generic

YAMINI JANAPANA

Summary

Over 4+ years of rich and diversified Power BI experience in designing, developing, and implementing business intelligence solutions. Proven expertise in transforming raw data into meaningful insights, facilitating data-driven decision-making for organizations. Results-driven Power BI Consultant with a proven track record of delivering impactful solutions using Agile methodologies. Adept at creating visually appealing and interactive dashboards and reports to convey complex information in a clear and concise manner. Experienced in collaborating with cross-functional teams to gather requirements, analyze data needs, and deliver solutions that align with business objectives. Skilled in data modeling, ETL processes, and optimizing query performance to enhance overall system efficiency. Committed to staying current with industry trends and continuously improving skills to deliver high-quality, innovative Power BI solutions.

Overview

5
5
years of professional experience

Work History

Power BI Developer

Biz-Metric Partners, Inc.
07.2023 - Current
  • Proactively resolved tickets and incidents raised by business users for Power BI support through ServiceNow platform, ensuring timely and effective solutions
  • Developed tailored dashboards catering to diverse teams, including engineering, accounting, sales, and more, ensuring each team's specific needs and key performance indicators were addressed
  • Spearheaded the creation of robust data models and data marts within Power BI, optimizing data structures for efficient reporting and analytics
  • Integrated ArcGIS maps into Power BI dashboards successfully, enhancing geographical visualization capabilities for more insightful data analysis
  • Led the development of high-level Power BI dashboards, incorporating advanced visualizations and interactive features to deliver comprehensive insights to stakeholders
  • Spotfire to Power BI Migration
  • Led and developed migration of BI assets from TIBCO Spotfire to Microsoft Power BI
  • This project involved data migration, report and dashboard recreation, security configuration, and user training
  • Played a key role in sprint planning sessions, breaking down project tasks into manageable iterations
  • Engaged in continuous collaboration with stakeholders, incorporating feedback in each sprint to enhance dashboard effectiveness
  • Conducted user training sessions to empower teams with the skills and knowledge required to effectively utilize Power BI, promoting self-sufficiency and proficiency among users
  • Used Power Apps and Power Automate to meet specific user innovative requirements, streamlining processes and enhancing the overall functionality of Power BI solutions
  • Employed Python and R scripting to achieve advanced analytics within Power BI dashboards, enhancing the functionality and analytical capabilities of the solutions
  • Azure Databricks Cost Management
  • Independently led the development of a comprehensive cost management dashboard for Client utilizing Azure Databricks and Power BI
  • Leveraging data extracted from system tables in Databricks, I meticulously crafted a robust data model and designed an intuitive report to provide invaluable insights into Databricks-related expenditures
  • The dashboard serves as a powerful tool for Client's decision-makers, enabling them to make informed and strategic choices regarding their Databricks costs
  • Empowered the business to optimize resource allocation, identify cost-saving opportunities, and ensure a more cost-effective utilization of Azure Databricks.

Power BI Developer

CLOUDSERVE SOLUTIONS
05.2022 - 08.2022
  • Optimized data visualization techniques using Tableau and Power BI; created interactive dashboards and reports that empowered data analysts to identify trends and make data-driven recommendations, leading to a 30% improvement in customer retention and a 15% increase in cross-selling opportunities
  • Built Power BI reports, helped implement row-level-security protocols (RLS), and held Power BI training sessions for large groups of business and IT stakeholders to maximize adoption of new platform
  • Experienced in optimizing reports and setting up Power BI service, gateways, and scheduling data
  • Created different reports using Power BI custom visuals like Bar Charts, Pie charts, Line charts, Slicers, bubble chart etc
  • Implemented automated data pipelines using Azure and SQL Server Integration Services (SSIS), enabling real-time data updates, and reducing data processing time by 75%
  • Improved data accuracy and eliminated manual data extraction, saving 10+ hours per week
  • Played a key role in improving data accuracy and reporting efficiency through data transformation and modeling efforts
  • Assisted in the optimization of data refresh schedules, ensuring timely updates of critical business information.

Power BI Data Analyst

University of Houston
01.2022 - 04.2022
  • Developed and maintained robust SQL scripts for data extraction, transformation, and loading (ETL) processes, resulting in a 20% reduction in processing time
  • Conduct in-depth analysis of large datasets using SQL queries, optimizing performance, and ensuring data accuracy
  • Contributing to daily operations of the office by developing ad-hoc queries using query manager tool in PeopleSoft which would generate useful reports from the underlying data stored in the database
  • Utilized joins and sub-queries to simplify complex queries involving multiple tables while optimizing procedures and triggers in production
  • Conducted thorough data validation and cleansing to ensure data integrity, resulting in a 20% reduction in data errors
  • Utilized Power BI (Power View) to create various analytical dashboards that depict critical KPIs along with slicers and dicers enabling end-user to make filters.

Business Intelligence Engineer

CAPGEMINI TECHNOLOGY SERVICES LTD
06.2019 - 08.2021
  • Responsible for handling reporting, data engineering and implementation of BI solution across the group
  • Developed various creative reports and dashboards in Power BI from various sources across all the departments including key reports for stake holders such as financial report packages, group level reports, and executive dashboards
  • Implemented the full cycle of Power BI visualizations such as extracting / transforming data using Power Query
  • Applying DAX functions, calculated columns and data modelling using Power BI Desktop
  • Writing Power query M language to convert Json, csv structures and fixing errors if required
  • Integrated and configured various connections on Power BI gateway to schedule and automate data movement and reporting process
  • Significantly reduced workload by 30% of extracting data through various sources and manual processes by integrating interim and permanent solutions into Power BI
  • Implemented and administered PBI security protocols by applying row-level securities and restrictions on business users for sharing and accessing the reports and dataset
  • Collaborated closely with clients to gather and analyze their business requirements, translating them into data solutions and dashboard designs
  • Developed and maintained dataflows, ensuring data quality, accuracy, and consistency for reliable reporting and analysis
  • Created visually appealing and interactive dashboards using Power BI, incorporating custom visuals, slicers, and drill-through actions to enhance user experience
  • Implemented role-based security to restrict access to sensitive data within dashboards, maintaining data privacy and compliance
  • Automated data refresh schedules, reducing manual intervention and ensuring up-to-date information for users
  • Conducted performance tuning and optimization of Power BI reports and dashboards to enhance responsiveness and user satisfaction.

Education

Master of Management Information Systems -

C.T. Bauer College of Business
Houston, TX

Bachelor of Electrical and Electronics Engineering -

Osmania University - Vasavi College of Engineering

Skills

  • Microsoft Azure SQL DB
  • MySQL
  • MongoDB
  • PostgreSQL
  • HBase
  • Neo4j
  • Python
  • SQL
  • PL/SQL
  • R
  • Power BI
  • Tableau
  • TIBCO Spotfire
  • Project Management
  • Big Data Analytics
  • Technical Documentation
  • Problem Solving
  • Database Management
  • Agile Development Methodologies
  • SQL Integration
  • API Design Knowledge

Timeline

Power BI Developer

Biz-Metric Partners, Inc.
07.2023 - Current

Power BI Developer

CLOUDSERVE SOLUTIONS
05.2022 - 08.2022

Power BI Data Analyst

University of Houston
01.2022 - 04.2022

Business Intelligence Engineer

CAPGEMINI TECHNOLOGY SERVICES LTD
06.2019 - 08.2021

Master of Management Information Systems -

C.T. Bauer College of Business

Bachelor of Electrical and Electronics Engineering -

Osmania University - Vasavi College of Engineering

Similar Profiles

CREATE PROFILE
YAMINI JANAPANA