Ron Smithberger

Ron Smithberger Email and Phone Number

Data Architect, Database Developer, Data and Integration Engineer with Health Care (PBM) Experience
Ron Smithberger's Location
Chapel Hill, North Carolina, United States, United States
Ron Smithberger's Contact Details

Ron Smithberger personal email

Ron Smithberger phone numbers

About Ron Smithberger

25+ years of experience designing, developing, and supporting corporate data warehouses as a systems analyst, lead PL/SQL programmer, and data warehouse architect.Proficient in all phases of the software development life cycle.Strong interpersonal and leadership skills with the ability to interface with all levels of management, team members, and business users in the public and private sectors.Proven ability to work on multiple tasks and projects under pressure while meeting targets and deadlines.Excellent oral and written communication skills.Relational database management/operating systems:Oracle 8i, 9i, 10g, 11g, and 12cSQL Server 2005, 2008, and 2012Sybase ASE 12.0LinuxUNIXWindowsProgramming languages/software tools:AutosysEmbarcadero DB Artisan, ER/Studio, and Rapid SQLOracle SQL DeveloperPerlPL/SQLSQL*PlusT-SQLTeam Foundation ServerToadTortoise SVNUC4

Ron Smithberger's Current Company Details

Data Architect, Database Developer, Data and Integration Engineer with Health Care (PBM) Experience
Ron Smithberger Work Experience Details
  • Ss&C Technologies
    Senior Data Architect
    Ss&C Technologies Jun 2022 - Sep 2024
    Windsor, Ct, Us
    View
  • Magellan Health
    Senior Manager/Technical Lead
    Magellan Health Dec 2018 - Jun 2022
    Frisco, Texas, Us
    Technical lead for a staff of a half dozen developers and analysts building and supporting the company’s drug manufacturer rebate and client payment system.Analyzed, designed, and developed the company’s monthly claim rebate file extracts to third-party vendors by identifying project plan tasks, analyzing source system data, building the physical data model, developing data transformation and validation processes within SnapLogic and json files, and producing audit summary reports.
    View
  • Cuna Mutual Group
    Solutions Architect
    Cuna Mutual Group Aug 2018 - Dec 2018
    Madison, Wi, Us
    Created data mappings and models for several Salesforce source systems being integrated into the company’s enterprise data warehouse.
    View
  • Magellan Health
    Senior Data Architect
    Magellan Health Mar 2016 - Aug 2018
    Frisco, Texas, Us
    Analyzed, designed, and developed the company’s data integration system of third-party adjudicated claims by establishing project plan tasks, analyzing source system data, building the physical data model, developing data transformation and validation processes with Oracle PL/SQL stored procedures, and producing data scorecards and other business reports.
    View
  • Sva
    Data Warehouse Architect
    Sva Dec 2014 - Feb 2016
    Madison, Wi, Us
    Redesigned the company’s data warehouse by establishing project plan tasks, analyzing source system data, standardizing database object naming conventions, streamlining and simplifying transformations, automating data mapping and auditing procedures, reducing daily incremental load times, producing more accurate data for business reporting needs, and eliminating production support issues.
    View
  • Vitech Systems Group
    Senior Data Analyst
    Vitech Systems Group Apr 2014 - Dec 2014
    New York, Ny, Us
    Developed data mappings for the State of Wisconsin Department of Employee Trust Funds’ legacy system data conversions to Vitech’s proprietary public retirement system benefit administration software solution.
    View
  • Department Of Defense (Defense Finance And Accounting Services)
    Oracle Pl/Sql Developer
    Department Of Defense (Defense Finance And Accounting Services) Nov 2013 - Apr 2014
    Gathered business requirements for new Defense Finance and Accounting Services system change requests.
  • Cpm Healthgrades
    Data Warehouse Architect
    Cpm Healthgrades Aug 2012 - Nov 2013
    Denver, Colorado, Us
    Redesigned the company’s call center data warehouse to better handle daily incremental loads with a modularized scripting approach using UC4.
    View
  • Meriter Health Services
    Data Warehouse Developer
    Meriter Health Services Mar 2012 - Aug 2012
    Madison, Wi, Us
    Analyzed and automated manual monthly load processes from the company’s Epic Clarity system to the enterprise data warehouse.Developed SSIS packages for the Meriter Medical Group rollout project.
    View
  • American Girl
    Data Warehouse Developer
    American Girl Feb 2007 - Mar 2012
    Middleton, Wisconsin, Us
    Analyzed and redesigned the daily load process from the company’s order management system to the marketing data warehouse to improve data quality and employ more advanced Oracle PL/SQL techniques for the growing volume of order transactions.Analyzed, designed, and developed the company’s email vendor replacement process which contains three million promotional email addresses for the American Girl, Barbie Collector, and Hot Wheels Collector brands.Analyzed and redesigned the internal search process which stores customer search activity from the company’s website.
    View
  • Dean Health Plan
    Data Warehouse Developer
    Dean Health Plan Apr 2006 - Feb 2007
    Madison, Wi, Us
    Analyzed, designed, and developed the migration from social security number to a generic identifier system for the company’s health plan members.
    View
  • Magellan Health Services
    Programmer Analyst
    Magellan Health Services Jun 2005 - Apr 2006
    Frisco, Texas, Us
    Developed Oracle stored procedures and packages to implement incremental transformation changes and historical updates of production-related errors and performance issues using advanced PL/SQL concepts.Analyzed, designed, and developed an internal process for auditing key business information being transformed from the operational data store environment into the data warehouse that helped the company achieve Six Sigma data quality assurance.Conducted a presentation of the internal audit process to the Analytical Services Department staff.Analyzed and redesigned a patient eligibility program that resulted in significant load performance improvement while improving the accuracy of patient membership information.
    View
  • Lockheed Martin
    Programmer Analyst
    Lockheed Martin Nov 2004 - Jun 2005
    Bethesda, Md, Us
    Analyzed, designed, and developed a daily reference table load process from the Social Security Administration’s Medicare prescription program operational data store into the data warehouse using Oracle system tables and dynamic SQL.
    View
  • Ajilon Consulting
    Database Analyst
    Ajilon Consulting Sep 2004 - Nov 2004
    Coordinated and developed the corporate headquarters’ UNIX 11i and Oracle 9i upgrade plans using Microsoft Project and Word and Oracle9i online documentation (e.g., Installation Guide, Release Notes, and Database Migration Manual).Conducted a backup and recovery training seminar for the database analyst team.
  • Magellan Health Services
    Business Analyst
    Magellan Health Services Feb 2003 - Sep 2004
    Frisco, Texas, Us
    Created data mappings and work breakdown structures for over 75 HIPAA-related patient, provider, and claim columns added to the company’s data warehouse.Created test case scenarios and performed all unit, system, integration, and regression testing for these columns.
    View
  • The St. Paul Companies
    Database Analyst
    The St. Paul Companies Jun 2000 - Feb 2003
    Served as primary DBA on several key projects and attended project meetings with developers, logical modelers, and key business staff to gather and understand business requirements.Developed a data migration process from the company’s old mainframe system to its new mainframe that saved $1MM annually.Assisted with the migration of 2,500 stored procedures and 1,100 tables from Sybase ASE 12.0 to Oracle 9i RDBMS using Oracle Migration Workbench and manual coding techniques.Developed Perl programs to automate project DBA tasks and conducted training seminars for other database analysts on their uses.Developed scripts to create database objects, stored procedures, data conversions, and cursors to handle data retrievals and point-in-time recoveries.

Ron Smithberger Skills

Data Warehousing Oracle Databases Etl Sql Unix Business Analysis Business Intelligence Pl/sql Database Administration Data Warehouse Architecture Database Design Microsoft Sql Server Integration Oracle Discoverer Performance Tuning Data Analysis Data Integration Data Migration Sql Tuning T Sql

Ron Smithberger Education Details

  • University Of Maryland Baltimore County
    University Of Maryland Baltimore County
    Information Systems; Architecture And Administration

Frequently Asked Questions about Ron Smithberger

What is Ron Smithberger's role at the current company?

Ron Smithberger's current role is Data Architect, Database Developer, Data and Integration Engineer with Health Care (PBM) Experience.

What is Ron Smithberger's email address?

Ron Smithberger's email address is ro****@****hoo.com

What is Ron Smithberger's direct phone number?

Ron Smithberger's direct phone number is (800) 701*****

What schools did Ron Smithberger attend?

Ron Smithberger attended University Of Maryland Baltimore County.

What skills is Ron Smithberger known for?

Ron Smithberger has skills like Data Warehousing, Oracle, Databases, Etl, Sql, Unix, Business Analysis, Business Intelligence, Pl/sql, Database Administration, Data Warehouse Architecture, Database Design.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.