Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Prashanthi

Summary

Business Intelligence Analyst with expertise in Power BI and data visualization. Demonstrated ability to improve reporting efficiency and ensure data integrity through automation and collaboration across teams.

Overview

15
15
years of professional experience

Work History

Business Intelligence Analyst/Data Analyst

United Airlines
01.2024 - Current
  • Served as liaison between BI and business stakeholders to develop reports aligned with Power BI roadmap.
  • Analyzed data trends to support business decision-making processes.
  • Collaborated with cross-functional teams to identify data requirements.
  • Managed data integrity by conducting regular quality assessments.
  • Streamlined reporting processes through automation and standardization techniques.
  • Conducted data analysis, created reports and dashboards using Tableau and Power BI.
  • Analyzed business requirements into technical requirements for reporting and visualizations, data models and databases.
  • Collaborated with stakeholders to define business requirements for reporting projects.
  • Prepared presentations summarizing findings from data analysis projects.
  • Collaborated with quality, risk management and other teams to identify process improvement opportunities based on in-depth BI reviews.
  • Monitored system performance and identified areas of improvement.
  • Participated in peer reviews of reports developed by other team members.
  • Gathered business requirements from process owners to create effective visualizations.
  • Collaborated with data analytics team on small to medium projects, delivering solutions for business challenges.
  • Developed automated daily, weekly, and monthly reports using Excel, SQL, and Power BI, enhancing efficiency by 40%.
  • Reduced data entry errors by 25% through improved master data linkage and automated validation checks.
  • Increased ingestion accuracy by 30% by standardizing external data formats with internal master schemas.
  • Created and maintained master data for customers and contracts, ensuring accurate internal system linkage.
  • Trained over 40 analysts on Tableau best practices, resulting in 50% increase in dashboard adoption.

Business Intelligence Analyst/Data Analyst

FedEx Ground
03.2022 - 08.2023
  • Provided analytical support for operational problem solving, translating large datasets into actionable insights.
  • Analyzed data trends to support business decision-making processes.
  • Developed interactive dashboards using BI tools for operational insights.
  • Streamlined reporting processes through automation and standardization techniques.
  • Presented analytical findings to stakeholders for strategic planning sessions.
  • Trained team members on BI tools and best practices for data analysis.
  • Assisted in the creation of key performance indicators to track operational efficiency.
  • Conducted data analysis, created reports and dashboards using Tableau and Power BI.
  • Developed complex SQL queries to extract and analyze data from multiple sources.
  • Analyzed business requirements into technical requirements for reporting and visualizations, data models and databases.
  • Collaborated with stakeholders to define business requirements for reporting projects.
  • Generated daily, monthly and annual reports to address short- or long-term business intelligence questions.
  • Identified opportunities for data optimization and automation of processes.
  • Collaborated with quality, risk management and other teams to identify process improvement opportunities based on in-depth BI reviews.
  • Gathered user feedback to improve existing reports or create new ones.
  • Analyzed customer profiles, segmentation models, market research and sales performance metrics to develop insights into customer behavior patterns.
  • Assisted development teams with analysis and design for new or existing systems.
  • Maintained documentation for all changes made to Business Intelligence systems.
  • Assisted with the design and implementation of a self-service reporting platform.
  • Provided detailed source analysis and data mappings and transformations for development and implementation.
  • Monitored system performance and identified areas of improvement.
  • Conducted data analysis, profiling and quality assessment to maintain integrity of business data.
  • Implemented automated testing strategies to ensure accuracy of report results.
  • Created technical documents outlining processes, procedures and standards used in Business Intelligence development efforts.
  • Trained users on how to use the various Business Intelligence platforms effectively.
  • Summarized conclusions of business intelligence analyses and presented findings at executive meetings.
  • Collaborated with Data Analytics team on small to medium projects, delivering data-driven solutions.
  • Managed and transformed data to ensure accuracy, supporting research that enhanced revenue-generating processes.
  • Coordinated cross-functional teams to gather requirements and execute successful project migrations.
  • Resolved issues in GCP-based systems, maintaining seamless operations through prompt troubleshooting.
  • Communicated findings and strategic recommendations to senior leaders effectively.
  • Designed automated workflows using Power Automate and SharePoint, optimizing collaboration and efficiency.
  • Developed 10+ interactive Tableau dashboards, consolidating data sources to reduce manual reporting time by 30%.

Sr. Reporting Analyst

Rockwell Automation
12.2012 - 12.2021
  • Captured stakeholder requirements for standard and custom reports in global finance organization.
  • Utilized advanced analytics tools to streamline reporting processes and improve insights.
  • Led training sessions for junior analysts on reporting best practices and tool usage.
  • Designed dashboards to visualize key performance indicators for stakeholder review.
  • Conducted data validation checks to ensure integrity of financial reporting materials.
  • Automated repetitive reporting tasks, saving time and reducing errors in analysis.
  • Presented findings to management, highlighting critical insights for strategic decision-making.
  • Designed dashboards and visualizations to facilitate rapid understanding of complex data sets.
  • Developed and maintained financial models to support budgeting, forecasting, and reporting processes.
  • Performed regular reconciliations between general ledger accounts and sub-ledgers in order to maintain data integrity across systems.
  • Conducted deep dives into individual accounts to ensure accuracy of reported results.
  • Supported senior leadership during external audits by providing requested documents or responding promptly to inquiries.
  • Identified opportunities for process improvements in order to streamline the production of financial statements.
  • Created ad-hoc reports to assist with trend analysis, variance analysis, and other special projects.
  • Maintained a library of corporate policies related to finance functions such as cash management or debt covenant compliance.
  • Developed an automated workflow system that improved report delivery time by 25%.
  • Provided timely feedback on financial performance against goals and objectives.
  • Trained new analysts on existing toolsets used for producing financial reports.
  • Participated in cross-functional meetings to discuss current business challenges related to financial reporting requirements.
  • Prepared detailed monthly expense analyses for management review.
  • Translated business needs into detailed user stories in JIRA to support Agile project management.
  • Executed data transformations to prepare datasets for advanced analytics, ensuring data integrity.
  • Conducted comprehensive analysis of business requirements, aligning them with design documents and specifications.
  • Migrated financial reports to Microsoft Power BI, developing actionable dashboards for informed decision-making.
  • Led migration of SAP systems to Microsoft Azure, minimizing operational disruption.
  • Designed complex Business Objects reports using Crystal Reports, Web Intelligence, and Xcelsius, publishing 38 reports.
  • Developed automated workflows and custom Power Automate solutions that reduced manual tasks significantly.

Business Objects Reporting Analyst

Experis – ManpowerGroup, Rockwell Automation
01.2012 - 12.2012
  • Worked as a liaison between BI & Business stakeholders to develop and deliver reports against the BOBJ reporting roadmap in gathering Business requirements from Process Owners to set up & develop SAP Business object reports (Web).
  • Worked with BI team (SAP BW 3.5) in designing and creating Info Objects, Info Sources, Standard and Custom Info Cubes, and Data Store Object (DSO) to ensure Reporting objects meet business requirements.
  • Prototyped and designed complex BO reports using Crystal Reports, Webi Intelligence, and Xcelsius and Published 38 reports (12 COPA, 11 Orders, 15 G/L) including graphs using Calculations, Breakpoints, Drill down, Functions and Formulas, Filters & Alerts.
  • Provided insightful financial reporting through BO analytics, metrics, and communication to the management team to support business decisions and ensured high-value reports are addressed timely, and business requirements are translated into relevant reports.
  • Successfully handled issues at the testing phase of the project & assisted the technical team on the changes to be made for the fix and made sure the changes are moved to production successfully.
  • Conducted training sessions for business users.
  • Conducted data quality validation and profiling after ETL processes to ensure clean, accurate, and consistent results leveraged by business users.
  • Wrote and optimized complex SQL in Teradata (including BTEQ, MultiLoad, TPT, FastExport, FastLoad) for large-scale data extraction, transformation, and reporting.
  • Proficient knowledge of Microsoft excel, used formulas, and pivot tables for data validation.
  • Used Alteryx for data preparation for handling complex datasets from multiple data sources before sending the data to visualization tools.

BO/CR Reporting Analyst

S4 Consultants, ASQ
03.2011 - 01.2012
  • Involved in full project life cycle implementation (requirement gathering to production support phase) and prepared the following -- business/technical writing of requirements, design templates, development standards document and detailed design documents.
  • Worked directly with Business users and other groups to develop and deliver reports against the BOBJ reporting roadmap.
  • Involved in creating test cases and regression testing.
  • Designed, built, and maintained Business Objects universes for different business groups and created complex reports based on user requirements and managed Universe consisting of 200 tables, 25 classes and 300 objects.
  • Created the reports using Crystal Reports functionalities like Add Queries (Command), Sub Reports, Drill down, Crosstab, Formulas, Parameters along with Dropdown lists etc.
  • Extensively used Calculations, Break points, Drill down, Slice and Dice, Functions and Formulas, Filters & Alerts for creating Web intelligence complex reports.
  • Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
  • Collaborate with cross-functional teams to integrate PL SQL solutions into applications.
  • Develop automated scripts for data migration and transformation using PL SQL.
  • Implement AI-driven data analysis techniques to enhance database functionalities.
  • Lead code reviews and mentor junior developers on PL SQL best practices.
  • Created various Views and Stored procedures using PL/SQL for Crystal Reports.

Education

Bachelors of Computer Science -

JNTU College of Engineering (Scient Institute of Engineering And Technology)
01.2007

Skills

  • Microsoft Power Platform
  • Power BI and dashboards
  • Data visualization
  • DAX and RLS
  • Power Automate
  • Power Apps
  • SQL and MySQL
  • MS Excel and PowerPoint
  • SharePoint
  • Spotfire and Tableau
  • Python programming
  • Six Sigma methodologies
  • Google Cloud, Azure, AWS
  • Teradata data warehousing
  • Data manipulation techniques
  • Agile project management
  • Jira software management
  • Data analytics and analysis
  • Dashboard design
  • Business intelligence analysis
  • Advanced Excel
  • Write reports
  • Team collaboration

Accomplishments

  • Six sigma belt

Timeline

Business Intelligence Analyst/Data Analyst

United Airlines
01.2024 - Current

Business Intelligence Analyst/Data Analyst

FedEx Ground
03.2022 - 08.2023

Sr. Reporting Analyst

Rockwell Automation
12.2012 - 12.2021

Business Objects Reporting Analyst

Experis – ManpowerGroup, Rockwell Automation
01.2012 - 12.2012

BO/CR Reporting Analyst

S4 Consultants, ASQ
03.2011 - 01.2012

Bachelors of Computer Science -

JNTU College of Engineering (Scient Institute of Engineering And Technology)

Similar Profiles

CREATE PROFILE
Prashanthi