Business Analyst Power Bi

Ravi Kumar Ram

Gainesville, FL ***** +1-352-***-**** github.com/ravikram linkedin.com/in/ravikumarram ad3d8k@r.postjobfree.com PROFESSIONAL SUMMARY

Data-driven Business Analyst with a strong track record in data analysis and visualization, effectively collaborating with cross-functional teams to enhance decision-making. Proficient at optimizing processes, demonstrated by a 30% quality improvement in a financial software application and the successful resolution of $46MM in unapplied cash. Eager to leverage diverse experience in a Business Analyst role.

EDUCATION

• University of Florida - Warrington College of Business Gainesville, FL MS in Information Systems and Operations Management - Data Science (GPA - 3.75) Aug 2022 - May 2024

• University of Mumbai Mumbai, India

Bachelor of Engineering in Electronics (GPA - 3.7) Aug 2014 - May 2018 EXPERIENCE

• Business Analyst LTIMindTree – Mumbai, India May 2021 - May 2022 o Developed Power BI dashboards that boosted decision-making efficiency by 15% and reduced manual monitoring efforts by 20%, enabling end-users to evaluate performance and make data-driven decisions while monitoring progress o Gathered and assessed business requirements and process workflows, and communicated inconsistencies and critical issues to multiple stakeholders by coordinating with over 20 project leads and more than 10 project managers o Designed over 30 dashboards, reports and filters in Jira, enhancing project efficiencies by tracking the progress of 325+ enhancement tickets and bugs

o Devised scheduled Power BI reports and scorecards, boosting productivity and saving over 20 hours of manual work per month

• Lead Quality Analyst LTIMindTree – Mumbai, India Oct 2019 - Apr 2021 o Led an 8-person team of engineers to test and deliver projects on time and within budget using Agile Scrum o Managed database and testing teams during the development of a cash collaboration tool thereby cleaning up $46MM of unapplied cash and increasing the efficiency in payments and invoices by 74% o Built Excel-based automatic processes streamlining reporting and documentation, resulting in a reduction of effort of 4 hrs/week o Automated a web automation testing framework and regression test suites, achieving a 35% decrease in software testing time

• Quality Analyst LTIMindTree – Mumbai, India Oct 2018 - Sep 2019 o Enhanced the quality and stability of the financial software application by 30% by executing regression, UAT, performance, and load testing by adding 200 virtual users

o Tested 9 web and desktop applications with Waterfall methodology, and collaborated with cross-functional teams to highlight risks and suggest mitigation steps for delivering high-quality software PROJECTS

• Improving Filpkart Diwali Sales and CX: Implemented data-driven strategies based on Flipkart Diwali sales analysis, resulting in an enhanced customer experience and increased sales by 15% during the festive season

• Hotel Loss Analysis & Optimization: Suggested improvements in pricing and promotional decisions, resulting in a 10% revenue increase, and reduced reservation cancellations by 12% through data analysis, including data cleaning, manipulation, and EDA using Pandas, Matplotlib, and Seaborn

• Analyzing Streaming Giants: Led a data visualization (Tableau) comparative study of Netflix and Amazon Prime Video, crafting interactive 13+ dashboards to deliver insights for emerging streaming platforms, production houses, and wider consumer audience

• Unemployment's Impact on Global Development: Analyzed World Bank data to assess the unemployment-global development link for 5 major regions, creating regression models and determining confidence and prediction intervals

• Decoding Uber Tips: Analyzed variations in distance, passenger count, and payment methods to improve Uber tip accuracy by 11%; created a Python data model deployed on Google Cloud, loaded into BigQuery via Mage pipeline, and designed Looker Studio dashboard

SKILLS SUMMARY

• Languages: Python, R, SQL, C#, C, Java, PL/SQL, HTML

• Tools: Power BI, Tableau, Looker Studio, JIRA, MySQL, MS Excel, MS PowerPoint, MS Office, HP ALM, Testrail, Mage

• Platforms: Azure DevOps, Google Cloud Platform, BigQuery, Linux, Web, Windows, Arduino, Raspberry Pi

Contact this candidate