Power Bi Business Analyst

SUSAN TIJO

*************@*****.*** www.linkedin.com/in/susantijo 919-***-**** Raleigh, NC

EAD (Work Authorized)

Professional Summary

Results-driven Data/Business Analyst with over 10 years of experience delivering data- driven solutions in insurance, telecom, and operations. Skilled in SQL, Excel, Power BI, and data visualization. Proven ability to gather requirements, develop KPIs, and translate business goals into actionable analytics. Known for mentoring analysts, improving performance metrics, and delivering stakeholder-focused dashboards and scorecards. Adept at cross-functional collaboration and system analysis for enterprise-level reporting and decision-making.

Core Skills

• Business Intelligence and Reporting

• Advanced SQL and Data Modeling

• Data Analytics

• ETL Tools (ODI), Data Transformation

• Power BI, Tableau, Excel

• Stakeholder and Cross-Functional Communication

• Data Governance and Reusable Frameworks

• Requirements Gathering and UAT

• Team Leadership and Mentorship

• Performance Metrics and KPI Development

Technical Tools

Languages & Tools: SQL, PL/SQL, Excel, Power BI, Tableau, Alteryx, Python

Databases: Oracle, Google Big Query

ETL & Scheduling Tools: Oracle Data Integrator (ODI), Tidal Scheduler Professional Experience

EY – Business/Data Analyst/Production Support Lead Oct 2021 – May 2024

• Automated reporting pipelines using SQL and ODI, reducing manual reporting time by 40%.

• Designed and presented case studies to showcase analytics impact using Excel/Power BI and SQL.

• Designed report foundation using Excel and SQL for OAC [Oracle Analytics Cloud] based reports, improving access to real-time KPIs and financial insights.

• Created reusable data models and reporting templates to ensure consistency and reduce development time across teams.

• Partnered with cross-functional business units to understand reporting requirements and translate them into actionable solutions.

• Mentored analysts and delivered training workshops across geographies to improve technical and communication skills.

• Improved system availability to 99.8% and decreased incident resolution time by 44% through monitoring and proactive analytics.

• Real time Production Data Load cycle by proactive reporting and monitoring. Tools: SQL, Power BI, Alteryx, Excel, ODI, Tidal

Infosys – Technical Analyst (Data and Systems)

May 2009 – Mar 2013

• Developed SQL-based financial reports and analytics dashboards for operations and senior leadership.

• Managed the end-to-end delivery of data analysis solutions, including requirement gathering, master data creation, testing, deployment, and support.

• Standardized key metrics and created reports for telecom clients.

• Improved the reliability of reporting processes by automating data extraction and applying quality control procedures.

Tools: SQL, PL/SQL, Excel, Oracle

Infosys – Business Analyst / POC Lead

Feb 2006 – May 2009 (UK & India)

• Led client communications, requirement analysis, and delivery for telecom analytics projects.

• Engaged in cross-disciplinary teams to solve high-impact business problems, focusing on data-driven recommendations as a technical contributor, offering SQL expertise in 8 “Hot House” innovation workshops.

• Created performance dashboards, scorecards, and incident tracking reports using SQL and Excel.

• Mentored junior developers and facilitated team knowledge-sharing sessions.

• Documented business workflows and conducted gap analysis to enhance system capabilities.

• Data modelling and leading Data Architecture for common data model using ER diagrams.

Tools: SQL, Excel, ODI, Oracle

Key Accomplishments

• Received EY Exceptional Client Service Award (2024) and User Recognition Award for data analytics leadership.

• Built and maintained reusable SQL solutions to automate processes.

• Reduced dashboard build time by 30% through creation of modular Power BI reports.

• Enhanced incident resolution efficiency, leading to measurable operational improvements.

• Authored training guides and mentored analysts to improve team-wide reporting consistency.

Education

Master of Computer Applications (M.C.A.)

Bachelor of Science (B.Sc.) in Computer Applications Major: Computer Applications

Minor: Mathematics and Statistics

Certifications

• Google Business Intelligence Certificate

• Google Data Analytics Professional Certificate

• Introduction to Data Science Specialization

Contact this candidate