Lolita Dmello

Business Analyst @Cenovus Energy

Dublin, OH, US

Developed and deployed an automated real-time dashboard using MSSQL and Power BI, providing the BA team with consolidated process insights, reducing manual effort by 93.33%.• Designed a discrepancy detection dashboard to identify missing or errored data in MSSQL from Oracle, significantly improving data accuracy and reducing troubleshooting time.• Managed ticketing and data processes in SRAS, ensuring 100% data accuracy and efficiency through proactive issue resolution.• Collaborated with internal teams and customers to investigate and resolve data integrity issues, improving overall data quality and reporting accuracy.• Automated data entry workflows using Python, reducing manual errors by 70% and streamlining operations.• Utilized Power Query and advanced Excel formulas to automate data integration and transformation, cutting down processing time by 66.67%.• Documented business processes, trained users, and provided ongoing support, ensuring seamless adoption of new dashboards and tools.• Liaised with software vendors and internal developers to troubleshoot issues and implement system enhancements, ensuring continuous process improvement.• Identified root causes of missing data across systems by collaborating with service providers and writing business cases for code changes, resulting in a significant reduction in recurring data issues and manual ticket handling time.• Conducted end-to-end testing for multiple interface upgrades (S11 to S23) within the SRA project, collaborating closely with developers to identify performance bottlenecks and optimize system functionality, resulting in smoother deployments and enhanced system stability.

University of Mumbai

Bachelor of Science - BSc, Mathematics

The University of Texas at Arlington

Masters, Data Science

University of Mumbai

Masters of Science , Mathematics