Power Bi Data Analyst

PREETHI OFEELIYA

Chennai, India P: +91-741******* ofeepreethi@gma il.com LinkedIn

SUMMARY

Dedicated and results-driven Data Analyst with a strong background in quantitative analysis, and data visualization. Seeking a challenging position to leverage my expertise in data analytics and contribute to transforming raw data into actionable insights while implementing strategic data solutions. Proficient in Excel, SQL, data processing, and analytics with a keen eye for detail.

EDUCATION

ADHI COLLEGE OF ENGINEERING AND TECNOLOGY Chennai, India Bachelor of Engineering Jun 2013 – Aug 2017

Major in Electronics and communication; Minors in Mathematics Cummulative CGPA : 6 .9/10 WORK EXPERIENCE

AXISCADES Chennai, India

Da ta analyst Dec 2023 – Present

Power BI Dashboards: Designed and maintained dynamic, interactive dashboards for retail sales, wholesale sales, delivery analysis, fund block analysis, and sales trends, improving data-driven decision-making. Advanced Excel for Reporting: Utilized Advanced Excel functions (Pivot Tables, VLOOKUP, INDEX- MATCH, Power Query, Macros) to streamline daily MIS reports supporting strategic initiatives. SQL for Data Management: Leveraged SQL queries to extract, clean, and analyze large datasets from databases, ensuring accurate and actionable insights for decision-makers. Sales Trend Analysis: Analyzed daily sales trends using DAX measures in Power BI and SQL, comparing with previous years to identify growth opportunities and market patterns.

• KPI Development: Created robust KPIs using DAX functions and Excel-based models to monitor retail/wholesale.

TRAINITY Chennai, India

Data analyst Intern Aug 2023 – Dec 2023

• Enhanced data accuracy by 20% through data collection, cleaning, and preprocessing.

• Reduced SQL query execution time by 25% through query optimization.

• Developed interactive data visualizations and dashboards using Tableau/Power BI, resulting in a 30% improvement in data comprehension.

HAPAG LLOYD Chennai, India

Documentation Co-Ordinator Nov 2021 – Aug 2023

Data Accuracy Excellence: Achieved a 95% data accuracy rate by developing end-to-end dashboards in Power BI and Advanced Excel, enabling real-time tracking and analysis of employee performance. Process Automation with VBA: Automated repetitive tasks using VBA for Microsoft Excel, streamlining workflows and reducing manual data entry by 30%.

Stakeholder Collaboration: Delivered actionable insights and recommendations through data-driven feedback, enhancing decision-making and aligning with best practices in documentation design and communication. Dashboard Integration: Designed and implemented dynamic dashboards integrating data from SQL databases and other sources, ensuring seamless access to performance metrics. SANMINA PVT.LTD Chennai, India

Production Trainee Sep 2017 – Jul 2020

Data-Driven Decisions: Utilized Advanced Excel and statistical tools to monitor production metrics and identify areas for improvement.

Downtime Reduction: Achieved a 20% reduction in downtime by identifying bottlenecks, implementing corrective actions, and streamlining workflows with a focus on continuous improvement. Operational Excellence: Collaborated with cross-functional teams to resolve production issues, ensuring adherence to quality standards and maintaining consistent output.

•

in downtime.

PROJECTS

PART SALES RETAIL ANALYSIS

Optimized inventory management, leading to a 20% reduction in stockouts by analyzing sales trends using Power BI. Enhanced decision-making accuracy by 10% using advanced DAX formulas in Power BI.

• Improved customer satisfaction by 15% by identifying and addressing key issues in the sales process through detailed data analysis.

WHOLESALE SALES ANALYSIS

Increased profit margins by 18% by conducting comprehensive wholesale data analysis using Power BI and Excel. Enhanced sales team performance by providing real-time data insights, leading to a 10% improvement in sales closure rates.

• Streamlined reporting processes by automating data collection and transformation, reducing report generation time by 30%.

FUND BLOCK ANALYSIS

Dealer Payment Insights: Identified dealers with open orders in fund block by analyzing payment data and sales trends using Power BI, enabling targeted approaches for payment collection. Optimized Cash Flow: Streamlined fund block tracking processes, improving visibility of blocked funds and enabling proactive dealer engagement, resulting in a 15% reduction in order release delays. Actionable Dashboards: Developed interactive fund block dashboards that provided real-time insights into dealer payments, enabling leadership to make informed decisions. DELIVERY ANALYSIS

Monitored daily invoice deliveries, categorizing as fully delivered, partially delivered, or in progress, using Power BI for real-time insights.

Analyzed work-in-progress orders to track invoices at the working stage, improving delivery timelines Tracked and reported deleted invoices, identifying issues in order processing. Developed interactive Power BI dashboards to visualize key metrics and improve order fulfillment efficiency.

Contact this candidate