Power Bi Developer
Resume:
MADHAVI KOLANAGIREDDY
S U MMARY
Experienced Power BI developer with expertise in gathering data from diverse sources and transforming it into insightful reports and dynamic dashboards. With nearly 5 years of hands-on experience as a Power BI Developer and over 8 years in the IT industry, I possess a strong foundation in data visualization, reporting, and analytics. I have developed expertise in creating interactive dashboards, data models, and reports using Power BI, while leveraging my extensive IT background to solve complex data challenges and drive business insights. Certified Scrum Product Owner, Certified Scrum Master from Scrum Alliance and Certified SAP Successfactors Associate
Proficient in data modeling and adept at integrating reporting components from multiple data sources. Skilled in designing and developing reports and dashboards using the Power BI platform.
Proficient in extracting data from various sources including SQL Server, Excel workbooks, and files and folders
Skilled in designing and developing reports and dashboards using the Power BI platform.
Proficient in crafting complex DAX functions for Power BI and Power Pivot. Developed DAX Queries to create computed columns in Power BI. Utilized DAX to generate computed tables in Power BI. Experienced in producing various types of reports including Yearly, Quarterly, Monthly, and Daily.
Published Power BI reports within specified organizations and made Power BI Dashboards accessible via web clients. Explored data through diverse visualizations using Power BI.
Leveraged Power BI Gateways to ensure dashboards and reports remain current. Published reports and dashboards using Power BI.
Developed calculated columns and measures in Power BI Desktop to enhance data analysis.
Utilized all data transformation techniques available in Power BI Query Editor. Created formatted, reusable formulas for reports, incorporating conditional formatting
Designed reports using charts, gauges, tables, and matrices. Developed parameterized, dashboard, linked, and sub reports with drill-down and drill-through functionality by year, quarter, month, and week. Established best practices for Power BI report development. Developed provisioning reports for various groups and upper management. Effectively translated business questions into insightful visualizations. Leveraged data analysis skills to create reports using SSRS, Excel Services, and Power BI. These reports were deployed to SharePoint Server, meeting all business requirements.
Wrote and optimized SQL statements to support business intelligence initiatives. Developed a variety of reports including charts, gauges, tables, matrices, drill-down reports, drill-through reports by region, parameterized reports, and dashboard reports.
Executed and tested all queries and reports to ensure accuracy before publishing. E X P E R I E N C E
V I S A S T A T U S
US Citizen
L I N K E D I N
https://www.linkedin.com
/in/madhavi-kolanagireddy-
11948426/
Microsoft Power BI Desktop
Microsoft Power BI Service
Data Visualization and modeling
Critical thinking
Problem Solving and
Troubleshooting
Have Excellent Intellectual,
Interpersonal, Technical, and
Communication skills
Successful working in a team
environment, as well as
Independently
The ability to work under pressure
and multitask
The ability to follow Instructions and
deliver quality results
Facilitate meetings (daily Scrum,
Sprint Planning, Sprint demo and
Retrospective
Methodologies: Agile Scrum
Tools: MS Power BI Desktop, JIRA,
Confluence, MS Office, MS Excel,
MS Visio, MS Power Point
Technical: Java, SQL, MS SQL Server,
HTML, JavaScript
Other: SAP Success Factors
Employee Central, PM-GM, RCM
S K I L L S
C O N T A C T
*****.**********@*****.***
Avon, OH 44011
Microsoft Power BI Developer/Analyst
Technifab Inc (Aerospace Company) Avon, OH May 2023 - Current Technifab, a subsidiary of Forest City Technologies headquartered in Avon,OH is an aviation and aerospace company offering manufacturing and engineering services across various sectors, including aerospace, medical devices, packaging, and automotive
In my role, I led the development of diverse Power BI reports covering crucial areas such as Sales Orders, Invoices, Forecasts, Scrap, HR Metrics, Work hours and other modules.
Streamlined Workflow:
Implemented a streamlined workflow where each report undergoes a thorough process, starting with research and story creation in JIRA, including effort estimation. Iterative Development:
Utilized bi-weekly sprints to ensure user satisfaction and refine reports based on feedback. Implemented an iterative development process where changes, if necessary, are addressed in subsequent sprints. Approved reports are then documented and uploaded to Confluence.
Teamwork:
Collaborated with application developers to ensure complex SQL queries are addressed, fostering a cooperative environment within the scrum team. Below are some notable examples of these reports:
Open Sales Order Report:
Reduced Fulfillment Time: Designed an Open Sales Order report to analyze customer orders across five plants. Identified trends and optimized production scheduling, resulting in a 10% reduction in order fulfillment time.
Work Hours:
Improved Productivity Analysis: Developed and maintained comprehensive Power BI work hour reports, enabling analysis of employee productivity across all plants. Identified trends in labor allocation (direct vs. indirect, full-time vs. temporary) for data-driven decisions. Increased direct labor hours by 10% and optimized labor allocation, resulting in cost savings.
THUM (Temperature and Humidity) Monitoring Report: Enhanced Production Efficiency: Implemented a real-time THUM monitoring report in Power BI, enabling visualization of temperature, humidity, and alarm status across plants. Established KPI thresholds to identify potential production issues. Increased production efficiency by 20% through proactive detection and mitigation of temperature/humidity problems.
IssueTrak Report:
Streamlined Issue Resolution: Developed a Power BI report for IssueTrak, providing real-time insights into open/closed issues, types, and severity. Improved issue visibility and prioritization, leading to a 15% reduction in resolution time.
HR Metrics:
Optimized Workforce Planning: Developed HR reports in Power BI, providing insights that improved workforce planning and resource allocation across five manufacturing plants. Analyzed employee distribution (direct, indirect, temporary) and salary types, leading to a 10% reduction in temporary labor costs at Plant 3.
Scrap Report:
Reduced Scrap Costs: Developed a comprehensive Power BI report to visualize and analyze scrap data. Identified work cells with high scrap rates, enabling targeted interventions and process improvements. Achieved a 15% reduction in scrap costs within six months.
Forecast Report:
Enhanced Sales Forecasting: Created an interactive Power BI sales forecasting report, E D U C A T I O N
Master of Computer Applications
Osmania University
June 1999
Bachelor's in Computer Science
Osmania University
June 1996
C E R T I F I C A T I O N S
Certified Scrum Master (CSM),
Scrum Alliance
Certified Scrum Product Owner
(CSPO), Scrum Alliance
SAP Certified Application
Consultant-SuccessFactors
Employee Central-2021
SAP Certified Application
Consultant-SuccessFactors
Performance & Goal
Management-2020
SAP Certified Application
Consultant-SuccessFactors
Recruitment Management-2020
including key performance indicators (KPIs) for sales orders and invoiced totals. This report empowers users with data-driven insights to improve sales forecasts and production plans.
Invoice Report:
Reduced Redundancy: Improved invoice processing efficiency by 10% by developing a comprehensive Power BI Invoice report. This report features calculated fields for cost analysis and allows for data filtering by plant, month, year, and work cell. These functionalities empower data-driven decision-making, leading to cost savings.
Applied Supplier List(ASL) Report:
Improved Cost Optimization: Leveraged Power BI to generate in-depth ASL reports. This identified inactive suppliers, potential MRO (Maintenance, Repair, and Operations) bottlenecks, and R&D (Research and Development) sourcing opportunities. Gained valuable insights that informed supplier diversification and risk mitigation strategies, leading to potential cost savings.
Cycle Count Report:
Improved Inventory Accuracy: Developed Power BI cycle count reports to track discrepancies between physical inventory and system records. Data-driven analysis of these reports led to a 10% improvement in inventory accuracy and reduced shrinkage.
Daily Production Schedule (DPS) Report:
Optimized Production Scheduling: Analyzed production data using Power BI DPS reports to identify trends and monitor daily schedules. Utilized insights to develop production plans that optimized resource allocation and workflow.
Production Log Report:
Increased Manufacturing Efficiency: Created Power BI production log reports to analyze and improve manufacturing efficiency. Leveraged data points (employee, work cell, hours) to identify bottlenecks and track key metrics (FPY, process efficiency, labor efficiency) over time, enabling targeted interventions to boost efficiency.
TEN (Training Event Nexus) Matrix Report:
Designed and implemented a Power BI matrix to streamline training event management and improve employee compliance. Reduced training event management time by 25% and increased compliance by 15% through efficient scheduling and identification of training gaps.
Supplier On-Time Delivery Performance Report:
Created a Power BI report to optimize supplier performance and reduce supply chain disruptions. Identified underperforming suppliers, enabling a 20% increase in proactive issue resolution and a significant reduction in late deliveries.
Customer On-Time Delivery Performance Report:
Developed and implemented a Power BI dashboard to monitor and improve customer on-time delivery performance. Provided real-time insights into delivery metrics, enabling supply chain managers to identify trends, prioritize customer segments, and reduce late deliveries by 15%.
E A R L Y E X P E R I E N C E
Client Name: TECHNIFAB INC
Job Type: Cell Operations/Operations Analyst
Duration: July 2022-May 2023
Client Name: ASCII Group LLC, Michigan
Job Type: Entry Level BI Developer
Duration: Oct 2017-Dec 2019
Client Name: ASCII Group LLC, Michigan
Job Type: Manager
Duration: Dec 2010- Sept 2017
Client Name: Trinity Consulting, Michigan
Job Type: Manager
Duration: May 2007-Nov 2010
Client Name: Singapore Power Ltd, Singapore
Role: Software Developer
Duration: May 2001-Nov 2002
Client Name: Orpine Systems, Hi-tech City, Hyderabad Role: Java Web Developer
Duration: May 2000-Apr 2001
Contact this candidate