Steven Ellinger Email & Phone Number

Lansing, Mi, Us

East Lansing, Michigan, United States

Ann Arbor, Mi

• Lead database warehousing and development for complete audits of medical and pharmacy data claims to ensure timely reporting and financial accuracy.•Consumer-facing relationship building both oral and written for data intake, ETL, programming & logic, and reconciliation of medical data.•Trained in SalesForce ticket system to accurately track communication between data managers, auditors, and Project managers.•Standardizing of customer data to encourage timely reporting across Healthcare platforms.•Supported medium to global businesses with Cost Sharing Reduction (CSR) program defined by the ACA including claim processing, validation, and financial reimbursement.•Creation of ETL packages in Microsoft Visual Basic to streamline procedures.•Proficient interoffice and customer-facing communications including leading online/teleconference meetings, project tracking through AGILE/SCRUM methodology, email, and presentations.•Daily experience with SalesForce, MS SQL Server, Visual Basic, MS Office Suite, Slack.

East Lansing, Mi

-Tasked with design, development, and maintenance of SQL databases including data analysis, manipulation, interpretation, and importing/exporting of data.-Established population health reports for multiple physician organizations, clinics, and individual providers.-Responsible for reporting and distributing multiple financial reports across provider networks including BCBSM, BCN, PMC, and HAP-Assisted in the design, build-out, and UAT of tools for clinical performance reporting multiple health care organizations-Project leader in development of electronic medical record (EMR) database integration system including schema, crosswalk, testing, and implementation.-Supported database systems across multiple clientele including ETL, QA testing, and end-user support.-Extensive use of Microsoft SQL Server 2012. (MS SQL)

East Lansing, Mi

-Standardized and expanded SQL databases including data analysis, manipulation, interpretation, and importing/exporting of data.-Created key SSIS packages for use with health care data originating from outside vendors.-Education in complex SQL Statements.-Experience with Microsoft Visual Studio 2010.-Extensive use of Microsoft SQL Server 2012. (MS SQL)-Assisted with SSAS and database management.-Trained cross-department with Medical Management for Controlled Disease Management (CDM) profiling and tracking.-Auditing of provider records for discrepancies across end-user databases.-Monitored admissions and discharges from in-network hospitals through member management services.-Tracked re-admission rates in compliance with NCQA standards

Flint, Mi

-Tasked with design, structure, and develop of report logic against the enterprise data warehouse and externally hosted analytic systems.-Responsible for mapping and designing service area networks representations though GIS programs and GEOaccess.-Maintains and updates full directory of all physicians and specialists available for Medicaid, Medicare, HMO, and PPO networks through McLaren Health Plan's website. -Assigned to analytical and structural support for data services through the Network Development department.-Responsible for the completion of departmental data analysis, registry management, and report development.-Advised cross-departmental data collection and analysis methods to create a sustainable database of member information.-Supports Health Services in research, collection, and analysis of health care data to identify areas for regulatory compliance by HEDIS and CMS standards.-Educated in Structured Query Language (SQL) as well as Visual Basic (VBA)

Greater Grand Rapids, Michigan Area

-Received quote requests from various customers and assigned production prices and costs over the immediate and long term outlook.-Developed pricing for production in association with engineering team leads.-Facilitated production development forecasts with help from lead pricing analyst.-Worked alongside buyers to negotiate the best price and terms for production materials.-Assisted business development manager in forecasting production line takeover from a multinational client.-Advised pricing and production based on material acquisition and lead times.-Developed tracking methods for material market shifts,-Extensive work with Microsoft Excel: Macros, nested if-functions, vlookup, forecasting, extrapolating data.-Handled multiple priority shifts and various deadlines for quotes.