Data Analyst Business
Resume:
Joe Schwartz
Cell: 248-***-****
SKILLS:
VBA
SQL
MySQL
Teradata SQL
Postgres SQL
Redshift SQL
Oracle SQL
Snowflake SQL
DOMO
Adobe Analytics
JIRA
Confluence
ServiceNow
Kanban
SharePoint
MS Excel
MS Access
MS Word
MS Outlook
PROFESSIONAL EXPERIENCE:
Optech for Flagstar Bank (Contract) January 2023 –
Business Analyst
Authored multiple Access Databases, linked directly to Oracle Databases to provide verification reports. All Access Databases were designed to be run with a single click.
Using both Oracle SQL and Snowflake SQL databases, supported department heads directly on various Ad-Hoc reporting.
Participated in hiring interviews for hiring a fellow team member.
Worked a PowerBI dashboard linked to an Oracle SQL database for testing purposes.
Promoted teamwork by actively redirecting tasks during critical timing activities.
Designed and maintained high visibility Excell reports using data from Oracle Databases with KPI for the entire organization.
Genesis10 for United Health Care (Contract) November 2021 – December 2022
Project Manager
Assisted in organizational capacity for new and existing businesses initiatives and brought forward initiatives previously delayed for over 3 years.
Interacted with both technical teams and business leads to translate between them.
Business Analyst
Performed Triage and ticket management of multiple Kanban boards simultaneously.
Performed administrative functions of Adobe Analytics dashboard, DOMO dashboard, and other platforms.
Authored DOMO dashboard per stakeholder requirements and performed adjustments during UAT stages.
Performed preliminary investigations for consolidation of Adobe cloud instances.
Data Analyst
Learned multiple processes quickly to become a SME backup.
Assisted with multiple projects in both Mainframe and AbInitio programs to get all tasks completed, meeting rapidly approaching deadlines.
IPS for Blue Cross Blue Shield of Michigan (Contract) June 2021 – October 2021
Data Analyst
Reversed engineered and Revised Access Database tool using VBA to automate several functions that were being performed manually increasing efficiency and meeting deadlines.
Added several new routines and features allowing for cost saving measures to be implemented within a tight timeline and frequently changing criteria and conditions.
RMC for Centene Health Care (Contract) January 2020 – March 2021
Data Analyst
Worked within an Agile environment utilizing JIRA, ServiceNow, and Confluence to organize workflow and assure deadlines were met.
Performed Parallel Testing of HEDIS Data for Quality Assurance of Measure data submissions and verify automated process results were performing to specifications using Advanced Ad Hoc Oracle SQL, Advanced Excel, and PowerShell Techniques.
Worked closely with Developers to verify coding changes met client’s needs.
Reverse engineered advanced SQL ETL routines to identify areas of improvement and the sources of issues reported by the client.
Performed trouble shooting and data investigation tasks using ad hoc SQL to solve issues from client reports.
Performed regular Data Deep Dives to proactively prevent bad data from reaching the client.
Created new documentation on processes that were already in place.
TAG for Autodata Solutions (Contract) June 2019 – January 2020
Data Scientist
Management of enterprise BI platform including highly visible KPI metrics of sales, close rates, affiliate & campaign management, digital advertising, and dealer performance facilitating the clients to make useful decisions in the Brand, Dealer Website & 3rd Party programs they maintain for online Lead Management System.
Worked closely with the sales team and clients to elicit, analyze, specify, and validate the business and functional requirements.
Created a PowerBI Dashboard to analyze both incoming and outgoing data traffic.
Maintained an ongoing, clear, and reasonable vision of 'next steps' and the 'big picture' with the client and own the program overview.
Created a new SQL ETL and Quality check routines for passing data through portals and to clients.
Performed troubleshooting for any noted discrepancies between source data and reporting software. Make recommendations and altered code as needed to correct the discrepancies.
Acted as primary provider contact through automated system changeover for data transfers. Includes analysis of both data quality and format of files submitted.
Work on Ad Hoc requests from clients demanding data crunching and analysis.
Created an MS Access tool to automatically generate XML coding.
Used Postman to review incoming and outgoing XML files to identify issues.
IPG for General Motors (Contract) July 2017 – May 2019
Database Administrator / Data Scientist
Originally hired as a Data Analyst to coordinate reporting for management and became the backup Database Administrator for the department. Upon the DBA’s retirement, took on the DBA role as well as retaining the Data Analyst position.
Maintained and tweaked an MS Excel tool using VBA and XML coding used by the department to provide better functionality.
Created and Maintained Security Features on Access Application used by the department.
Performed Weekly ETL Routines from SAS EG SQL Database to SharePoint tables, using PL/SQL, the Access Application was linked to.
Performed Daily Troubleshooting, Tuning, Refinement, and Enhancement on the Access Application’s VBA and UI components to assist in the multiple department’s various roles.
Created new functionality within the Access Application to automatically email KPI reports to management.
Proactively worked with the department to determine user needs and wants to enhance their work experience with the Excel and Access tools.
Created all documentation for the MS Access Database.
Contact this candidate