Results-producing BI Developer with 5+ years of experience in data optimization, workflow automation, and dashboard visualization.
Collaborating with cross-functional teams and end users to identify gaps and gather requirements for technical solutions, including data optimization, data warehousing, workflow automation, and general application development.
Documenting business requirements and translating technical information to project stakeholders.
Developing solutions on several BI platforms, including Power BI, Tableau, Knime, SSRS, SharePoint, and SAP business objects.
Strong problem-solving and critical thinking skills to help troubleshoot and resolve technical issues.
Managing workflows on multiple platforms - SAP, EPIC, Oracle, Scontracts, ServiceNow, SQL Server, Excel, ANAPLAN, Access, SharePoint, Clarity, Microsoft Dynamics 365, Microsoft Office 365, Peoplesoft, Hyperion, and SYMPLR.
Resourceful, organized, and dependable problem solver
Building winning environments, consistently adding value, delivering measurable results, and enhancing organizational viability and growth.
Experience in building Power Automate, Power Apps, SQL, Oracle MDX, Power BI, Python, and Excel models; leveraging data providers, including Service Now, Oracle, SAP, SharePoint, Clarity, Netsuite, TM1, COGNOS, Peoplesoft, Anaplan, Excel, Hyperion, and SmartView to mine, analyze, and automate division reporting.
Bachelor of Science – Accounting
Minor – Computer Science
Sinai Health Systems Apr 2020 - Present
Senior BI Developer
Building complex queries with SQL and Python, injecting them into Tableau and Power BI models.
Leveraging data providers, including SQL Server, Excel, Access, ServiceNow, SAP, EPIC, AXIOM, SharePoint, SQL Server Reporting Services, and SYMPLR.
Assisting with monthly ad-hoc analysis and running jobs for functional areas, including Finance, Accounting, Operations, Legal, HR, and IT.
Automating data entry and processing with Microsoft PowerApps and hybrid workflows, which extract data from incoming documents, such as invoices and purchase orders, and populate fields in a SQL Server and Axiom Financial Planning.
Improving overall decision-making by designing and developing BI reports providing invaluable insights.
Providing thought leadership and training for applications, financial matters, and project management framework procedures.
o Project 1 – Contract Management Software Implementation (Capital Project)
Lead Project Manager and BI Analyst for Scontract (SYMPLR) implementation. Established relationships with cross-functional stakeholders, including Legal, Accounting, Finance, and Clinical teams, to develop and document automated workflows and centralized contract information.
o Project 2 – Revenue Cycle Analytics (Operational)
Worked with Accounting, Finance, and Revenue Cycle teams to implement automated workflows for journal entries and transfer information into Axiom clinical forecasting and planning dashboards for managed care analytical models.
United Airlines Mar 2019 – Apr 2020
Senior BI Analyst
Strategized with business users and collected requests to update existing BI reports accommodating business needs.
Streamlining business processes by analyzing manual processes, such as project requests, reviews, and approvals - designing workflows that automate steps, reduce errors, and improve efficiency between multiple applications.
Lead project analyst for IT financial projects – planned and forecasted for headcount, hardware, and software. Worked with vendors to obtain quotes and resources.
o Project 1 – ServiceNow and Oracle interoperability
Worked with Finance and Technology to establish API connections, workflows, and analytics between Oracle and ServiceNow. Provided new workflows for project owners and stakeholders to manage requests, analyze project dashboards, and transfer information between Oracle and ServiceNow.
o Project 2 ¬– Complex PL SQL (MDX) queries in Oracle Hyperion
Developed highly complex PL SQL (MDX) queries extracting IT project financial data from Oracle Hyperion reporting. Created reports by injecting queries in Power BI and distributing them via SharePoint and MS Teams.
Imbibe Inc. Mar 2018 – Dec 2018
Sr. Financial Analyst & Technology Admin
Involved in planning, defining, and designing data schemas.
Collected business requirements and provided documentation.
Developed SOL scripts. Indexes, complex queries for data analysis and extraction
Used SSIS and t SQL stored procedures to transfer data from source to staging area and
o Project 1 – Migrating ERP – QuickBooks to Microsoft Dynamics 365
Lead Analyst and Project Manager - Worked with Finance, Accounting, Marketing, HR, Sales, and Regulatory teams to generate and
Microsoft SharePoint Development
Microsoft Power BI
Pro Forma Statement
Visual Basic for Applications