Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

LEO FRANCINA J

Summary

Experienced professional with over six years in Quality Assurance and Data Analysis, transitioning to a specialized role as Provider Data Specialist - Subject Matter Expert (SME). Skilled in statistical analysis, data visualization, and data-driven decision-making using Python, R, SQL, and data visualization tools. Proven track record in creating and maintaining data pipelines and dashboards, enhancing operational efficiency and decision-making. Expertise in VBA coding and Power BI for process automation and improved data quality improving efficiency by 40%. Recognized for mentorship and team development.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Sr. Provider Data Specialist

Optum
06.2018 - 06.2025
  • Dashboard Development: Developed interactive dashboards using Power BI, Excel, and Tableau that provide actionable insights, saving an estimated 20 hours per week through efficient visualization customization, drill-down implementation, and filter integration for enhanced user experience.
  • Data Visualization: Created compelling and insightful visualizations with Power BI, Tableau, and PowerPoint presentations, including Gantt charts for project planning, saving an estimated 15 hours per week across a team of 60, and enabling stakeholders to grasp complex data trends swiftly for informed decision-making.
  • Constructed and optimized Power BI dashboards that consolidated data from 10+ SQL databases and Excel spreadsheets, empowering the analysis team to generate reports 40% faster and facilitating real-time decision-making across departments.
  • Developed and implemented advanced DAX formulas in Power BI, enhancing reporting capabilities by delivering year-over-year growth calculations and improving data visualization; insights were leveraged by 10+ stakeholders for strategic decision-making.
  • Advanced Excel Functions: Strong knowledge in using advanced Excel functions for data analysis, such as VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and statistical functions like AVERAGE, STDEV, etc.
  • Technological Proficiency: Designed and implemented multiple VBA projects in Excel to automate daily reporting tasks, achieving a 50% reduction in report generation time and enhancing efficiency by up to 40%, while improving accuracy through automated data validation. These enhancements positively impacted a team of 60, resulting in significantly improved operational efficiency and higher-quality outputs.
  • Enhanced user interface functionality in Excel spreadsheets using VBA forms and controls, improving usability and data entry accuracy for cross-functional teams.
  • Process Improvement: Work on Multiple projects to Streamline the Process And improve the overall Quality and Efficiency of the Team.
  • Collaborated closely with management to provide training on Improved processes, enhancing team efficiency. Played a pivotal role in the creation and maintenance of quality training programs, fostering a culture of continuous improvement.
  • Served as a subject matter expert on the Provider Data Specialist team, providing guidance and support to colleagues when needed.
  • Streamlined data entry processes for increased efficiency and reduced errors.

Education

Bachelor of Computer Applications -

Jyoti Nivas College Autonomous
04.2018

Skills

  • Microsoft Office, VBA Coding
  • Microsoft Excel
  • My SQL
  • Power BI
  • Tableau
  • Data Visualization,Modelling and Analysis

    Soft Skills

  • Efficient time management
  • Fluent in English, Tamil, Kannada
  • Problem-solving
  • Multitasking Abilities
  • Excellent communication

Certification

Certified Data Analyst from Excelr - June 2025

Timeline

Sr. Provider Data Specialist

Optum
06.2018 - 06.2025

Bachelor of Computer Applications -

Jyoti Nivas College Autonomous
LEO FRANCINA J