JOE R. SCHWARTZ

Redford, MI ***** 248-***-**** adlt16@r.postjobfree.com

https://www.linkedin.com/in/joe-schwartz-9810b534/

DATA ANALYST/BUSINESS ANALYST/ DATABASE ADMINISTRATOR

An accomplished, detail-oriented, experienced Database Administrator and Data Scientist with a solid background in database management and data analysis. High expertise in managing multiple servers in multi-instance environments, backups/restores, troubleshooting and proactive maintenance. Excellent project management skills, with proven ability to direct and manage all aspects to ensure on-time and under-budget delivery. Proven ability to successfully streamline, optimize and maintain system functionality performance and recoverability.

Database Administration

Development

Data Analysis

Data Modeling

Data Mining

Quality Assurance

Creative

Analytical

Critical Thinking

Problem Solving

Time Management

Coding

Decision Making

Computer-based Proficiency

Multitasking

PROFESSIONAL EXPERIENCE

BUSINESS SYSTEM ANALYST

RMC for Centene Health Care Detroit, MI January 2020 to March 2021

•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 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.

•Maintained communication with both client and providers to assist in defining requirements and addressing any noted issues.

•Worked with team in new environment to brainstorm and implement process improvements.

•Created new documentation on processes that were already in place.

DATA SCIENTIST

TAG for Autodata Solutions Troy, MI June 2019 to January 2020

•Support analytical needs of the clientele of Fiat Chrysler Automobiles of US & Canada, Mitsubishi USA, Honda USA

•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.

•Helped translate conceptual business requirements into functional requirements.

•Performed various detailed analysis on large databases to assure data quality to transmit from company to company.

•Maintained an ongoing, clear, and reasonable vision of 'next steps' and the 'big picture' with the client and own the program overview.

•Create new 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.

•Aided in new automation project by providing formulas and SQL code to development team.

•Created and maintained MS Access tool to generate code for co-workers unfamiliar with XML coding.

•Used Postman to review incoming and outgoing XML files to identify issues.

DATABASE ADMINISTRATOR / DATA SCIENTIST

IPG for General Motors Warren, MI July 2017 to May 2019

•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 Backup and recovery procedures to assure Access Application stability

•Performed Weekly ETL Routines from SAS EG Database to SharePoint tables 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 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.

DATA ANALYST

Bartech for Ford Motor Company Dearborn, MI December 2015 to June 2017

•Catalogued, assigned, and released service part numbers for new vehicles utilizing CAD and In-house software.

•Analyzed CAD drawing to assure complete coverage and availability of all parts potentially needed.

•Collaborated with Engineering on potential issues in CAD systems to identify potential costly issues in release plans.

PARTS RESEARCH ANALYST

Motor Information Systems Troy, MI August 2011 to December 2015

• Authored new parts catalogs for many OEMs using multiple electronic sources using in-house software.

AUTOMOTIVE DATA ANALYST

Minacs Farm Hills, MI January 2008 to January 2011

•Performed daily deep dives into dealership verbatim data to identify patterns.

•Created Keyword data to be used to sort data into pre-defined categories.

•Tested and Tuned keyword data daily for quality assurance of record sorting procedure.

•Trained new team members on keyword creation and tunning to increase accuracy of matching program.

•Process accuracy reached sufficient levels to become fully automated.

MOPAR SPECIFIER

Minacs Farm Hills, MI January 2005 to January 2008

•Provided first-tier electronic catalog assistance for FCA dealerships across the US.

•Used highly creative methods to find information within an UNIX system.

•Created notations within the catalog on findings to assist others in the department, as well as the dealerships.

ASSISTANT STORE MANAGER

Murray’s Discount Auto January 1997 to December 2004

•Hired in as a parts counterperson, progressed through several levels to assistant store manager.

•Learned vehicle systems and common automotive problems faced by consumers, and how to best address them in the most cost-efficient method

•Created a superior customer service experience to achieve maximum market penetration, drive store growth, increase sales and profitability.

•Provided daily leadership and created and sustained a culture of employee engagement.

•Led a successful team, supported the store manager, and managed a fast-paced retail store.

•Built, coached, trained, and engaged crew team to deliver superior levels of customer care and business results.

•Instrumental in inventory protection, asset management, operational and safety issues.

•Assisted in rollout of new Electronic catalog by traveling to individual locations and holding seminars before the implementation to minimize disruption in customer service.

•Operated the POS and Accounting systems to provide financial security.

TECHNICAL SKILLS

VBA SQL MySQL Teradata Postgres HTML XML BASIC SAS EG JIRA Confluence ServiceNow SharePoint MS Excel MS Access MS Word MS Outlook

EDUCATION

Mathematics Major with Computer Science Minor

Lawrence Technological University Southfield, MI Completed two years.

Mathematics and Science Preparation Courses

Oakland Community College Farm Hills, MI Completed two years.

Managerial references available upon request.

Contact this candidate