MADHAVI KOLANAGIREDDY

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, 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.