Business Intelligence Analyst/Data Analyst

Mischon Ross ***********@*****.*** 281-***-****

https://www.linkedin.com/in/mischonross

BI/Data Analyst

Flexible, data-driven BI Analyst with experience designing, developing, and deploying impactful reports and dashboards to improve business performance. Proven ability to work with large, disparate datasets, identify actionable insights, and present findings to key stakeholders. Highlights of Expertise

Data Management & Analysis

Data Visualizations

Data Reporting

Business Intelligence Analysis

BI Tools (Tableau, Power BI, PowerQuery, SQL, SSMS, SSRS, Visual Studio, AWS Redshift, Oracle SQL Developer, Dbeaver)

Advanced Excel Reporting

JIRA

Ad-Hoc Reporting

ServiceNow

Needs & Requirements Analysis

Project Administration

Meticulous Organizational Skills

Cross-Functional Coordination

Workflow Planning & Prioritization

Relationship Building & Cultivation

Career Experience

Envision Healthcare

Business Intelligence Analyst II MAR 2022 - PRESENT

Applied data analysis skills to design and develop customized reports, dashboards and products that enabled business leaders to make data-driven decisions for the Revenue Cycle Management Legal

(RCM) team, leading to a 15% increase in revenue.

Proactively conducted requirements gathering and elicitation sessions for healthcare claim and charge analysis with stakeholders to identify critical objectives and develop data-driven solutions that addressed their specific needs, which facilitated the creation of plans to effectively answer questions about the data presented.

Utilized SQL and Tableau to integrate and analyze large, complex datasets, uncover actionable insights to build proprietary internal RCM products.

Leveraged data cleansing, blending, and validation techniques to ensure the accuracy and integrity of large healthcare datasets used for RCM Legal team analysis.

Designed and developed interactive dashboards in Tableau that leveraged data visualizations to increase stakeholder and user engagement on specialized internal healthcare products by 37%.

Conducted QA testing and UAT to ensure the quality and functionality of new data solutions, reports, and products.

BNY Mellon (Contract)

Project Analyst JAN 2020 - JULY 2021

Spearheaded gathering requirements and issues for business applications to formulate solutions and address open items for Wall Street Office (WSO) and Solvas migrations and implementations.

Extracted, compiled, analyzed, and tracked data to convert reports from the WSO application DB to SQL Server.

Analyzed and cleansed legacy customer data as well as tested and implemented ETL process to migrate raw data to usable data integration insights.

continued…

Mischon Ross Page 2

BNY Mellon (Contract)

Served as 1 of 2 key SMEs on ratings and ratings agency data for reporting and analysis.

Performed research and analysis on internal systems and documented findings.

Supported a global user base in Business Analysis, Support & Testing for WSO 12 and Solvas.

Analyzed testing impact of changes requirements and modified test scenarios as needed.

Liaised with business units, IT, internal and external clients, vendors, and offshore members regarding Solvas systems needs and analysis.

Championed acceptance and use of the Solvas platform to reduce dependence on WSO platform for overall system performance improvement.

Utilized JIRA to open, handle, and close service and change requests. SDG&E (Contract)

Business Systems Analyst FEB 2019 - DEC 2019

Supported the Transmission Engineering Design (TED) teams to ensure continuity and functionality of D2.

Raised, validated, and tracked system issues to closure for the D2 Project using ServiceNow.

Performed D2 analysis, UAT and provided recommendations based on findings.

Utilized Jira to manage internal project ticketing, documentation, and system requirements for D2.

Conducted weekly workshops with Stakeholders and IT to prioritize needs and provide updates.

Performed SharePoint administration using SharePoint Designer and InfoPath to build, enhance and customize team sites, build subsites, and maintain sites for the Transmission and Distribution Engineering teams.

UWA

Business Analyst-Reporting APR 2017 - AUG 2018

Provided BI solutions and reporting utilizing SQL, Visual Studio, Oracle SQL Developer, and other industry data tools to assist in solving data challenges for aviation business partners worldwide to make better-informed decisions.

Analyzed quantitative data to gain an understanding of domestic and international business aviation consumer behaviors, demographics and spend use.

Built customized data reports that improved 5 functional areas in TSS by collecting data and gathering insights into performance and productivity barriers.

Assessed, analyzed, and defined needs through research to identify gaps in operational and financial reporting for worldwide partners, implementing and generating appropriate solutions to issues.

Managed operational and financial reporting analytics for the 24/7 TSS teams by producing independent data reports that served as insights to aid in improving company processes.

Collaborated with multi-disciplinary teams to develop strategic operational performance metrics and dashboards to improve reporting efficiency.

Developed ad-hoc reports to gain insight into consumer business data as well as operational efficacy. continued…

Mischon Ross Page 3

Gexa Energy (Contract)

Business Analyst ll-Sales JAN 2016 – JAN 2017

Functioned as direct liaison for 2 sales representatives and 25+ energy brokers.

Collected sales data, integrating ETL strategies, to create efficient data modeling solutions.

Gathered CRM data via Salesforce and developed strategic comprehensive reports for management.

Built, executed, and managed opportunities, contracts and addendums including pricing transaction requirements for the sales teams and brokers.

Identified gaps in energy reporting data for the PJM Energy Markets and collaborated with cross- functional teams to create resolutions in a timely manner.

Designed, created, and conducted training, supported, and coached users in day-to-day interactions with SharePoint sites.

EDUCATION

Lone Star College-University Park Actively pursuing the RHIT Certification Lone Star College-University Park AA, 2016

CERTIFICATES

data, data analysis, data analytics, data visualization, data visualizations, viz, visualization, visualizations, data reporting, data analyst, data modeling, data blending, data cleansing, cleansing, blending, data validation, validation, bi, bi tools, BI Tools, UAT, uat, SAS, sas, software as a service, software-as-a-service, Software as a Service, data management, business intelligence, reporting, sql, sql server, ssrs, ssms, power bi, powerbi, Power BI, PowerBI, database, tableau, Tableau, Redshift, redshift, AWS, AWS Redshift, aws, aws redshift, Amazon Redshift, amazon redshift, python, html, css, js, javascript, finance, ad hoc, ad hoc reporting, analytics, visual studio, etl, business analysis, business analyst, requirements, requirements gathering, elicitation, financial, financial analysis, financial reporting, project management, jira, agile, wall street office, wso, solvas, deloitte, technologist, SharePoint, sharepoint, Microsoft, Microsoft Excel, excel, advanced excel, ms excel, Microsoft Word, word, ms word, Microsoft PowerPoint, powerpoint, ms powerpoint, Microsoft Access, access, Microsoft Visio, visio, crystal reports, oracle, oracle sql developer, agile, business cases, business processes, ERP, dashboards, business systems, energy, business operations, operations, research, projects, project, cross-functional, cross functional, JIRA, jira, confluence

Mastering Microsoft

PowerBI

Advanced SQL Server:

Reporting Services

Contact this candidate