Summary
Overview
Work History
Education
Skills
Databases
Power Bi
Timeline
Generic

David C. Era

Sacramento,CA

Summary

Dynamic Lead Business Systems Analyst with extensive experience at Health Net Federal Services, specializing in MS SQL Server and Power BI. Achieved a significant reduction in payroll errors while enhancing automation processes. Proven ability to lead cross-functional teams and drive impactful data analytics solutions, demonstrating both technical expertise and strong leadership skills.

Overview

29
29
years of professional experience

Work History

Lead Business Systems Analyst, Data Analytics

Health Net Federal Services (Centene)
Rancho Cordova, CA
03.2024 - 01.2025
  • Project lead, developer, and product expert for pilot implementations of Altyrx, Jira, and Snowflake. Tasks included vendor evaluation, multiple trials, procurement, implementation, initial development, and training.
  • Served as lead business systems analyst, Power BI admin, SQL Server database owner, Active Directory domain admin, and lead programmer on several platforms.
  • Evaluation of AWS, Azure, and Google Cloud in the .gov secure enclave for meeting both FedRAMP security standards and advanced requirements of the Data Analytics team for lift-and-shift hosting or cloud migration.
  • Led SQL Server and Integration Services implementations within the secure Federal Services domain.
  • Initial planning for SQL SSIS integration with Python for ML and AI within the secure Federal Services domain.
  • Secure Power BI Server (on-prem) planning, procurement, and implementations including shared data sources (Teradata, SQL Server, ODBC, Excel, file and folder), automated email and file subscriptions, AD integrated folder and role security meeting federal security requirements and critical features needed by the business.
  • Power BI Desktop production deployment and server connectivity, initial development of sample connections, data models, reports, training materials, coding standards, and more.
  • Create and document Power BI Desktop and Server DevOps processes including deployment pipelines, data and report version control, change data capture processes for direct connections, and much more.
  • Initial analysis of integrated PBI Services (cloud), Office 365 (cloud), SSIS, Web API, and Power Automate.

Project Lead Business Systems Analyst (Core Systems), Data Analytics

Health Net Federal Services (Centene)
Rancho Cordova, CA
03.2022 - 03.2024
  • Led the creation of Power BI cloud services, on-prem Gateways, and Desktop development and deployment pipeline processes as PBI admin, lead business systems architect, and lead pilot developer.
  • Evaluated feasibility of using a linked SQL Server to securely provide ETL and CDC automation of deidentified summary data between the secure Federal domain and Centene domain enabling analytics across commercial enterprise systems and Federal programs, initiatives, and processes.
  • Led the Data Analytics portion of the risk assessment, vendor evaluation, and vetting processes required by FedRAMP security standards for over 350 vendors seeking approval for upcoming sub-contracts enterprise wide.
  • Developed SQL Server and Oracle databases and ETL processes using T-SQL and PL SQL stored procedures and SSIS packages. Created distributed PL SQL queries across multiple Oracle databases and instances through SQL Server linked servers.
  • Created an SSIS framework of packages for file management and ingestion of B2B SFTP file transfer processes.
  • Wrote custom T-SQL, VB and C# .Net tasks within SSIS packages and sub packages.

Senior Business Systems Analyst, Finance

Health Net Federal Services (Centene)
Rancho Cordova, CA
03.2021 - 03.2022
  • Excel to SQL Server and Integration Services automation of Health & Welfare payroll processes. Worked with Legal, SCA, Payroll, Benefits, Accounting, 401k, SQL, SSIS, and Control-M teams. Roles included lead architect, project manager, sole developer and ongoing support.
  • Reliably eliminated reported payroll errors from 2-5 per bi-weekly cycle to 1-2 per year (26 cycles) while reducing manual processing time from 40+ hours per cycle to a few hours.
  • The new process archived all input and output files and provided complete error trapping, logging, monitoring, automated alerts, process monitoring and audit trail.
  • Change control processes allowed previous periods to be rerun with edited or existing input files for auditing, error remediation, and regression testing.
  • Code was branched as needed to support multiple file formats and versions throughout the life of the product based on change release dates.
  • Evaluated Always Encrypted and other solutions to secure sensitive data from DBAs, ETL programmers, and report writers within the SQL Server, Integration Services, Reporting Services, and MicroStrategy BI stack.

Business Systems Analyst, Finance

Health Net Federal Services (Centene)
Rancho Cordova, CA
09.2017 - 03.2021
  • Created SQL Server databases, ETL and CDC processes, and stored procedures with comments documenting my assumptions and work product for accounting and legal teams defending pre-existing complex contract litigation.
  • Created a reliable, repeatable, and self-documented audit process framework for 8.2 billion provider claim records across an 8-year period resulting in 'no finding' and a positive settlement.
  • Reconciled $2.4 billion in VA payments against provider accounting and banking systems resulting in nearly $100 million in additional provider payments and restored confidence in our systems.
  • Evaluated several internal and external systems and ancillary data sources to identify unique keys to cleanly relate and standardize individual transactions across previously unrelated systems and multimillion row tables.
  • Further remediation of claim data based on this work allowed for an additional $120 to $150 million in administrative service fees billed to the VA, and $200 million in provider overpayments identified for further handling.

Consultant (Principal Shareholder)

WineCompliancePro, Inc.
Sacramento, CA
10.2016 - 09.2017
  • Upgrade ASP.Net Web Services to WCF Services and refactor code as needed.
  • Upgrade to Server 2016, SQL Server 2016, .Net 4.6.2., and Visual Studio 2017.
  • Turn over of all executive duties and responsibilities in preparation to resign as a corporate officer and board member.

IT Manager / Lead Developer (Principal Shareholder)

WineCompliancePro, Inc.
Sacramento, CA
12.2013 - 10.2016
  • Development in VB.Net, ASP.Net, ADO.Net, IIS, and SQL Server.
  • Enhanced the OrderChx web portal, database, and web services adding address matching and scrubbing, calculation of sales tax jurisdictions and rates for all states in real-time, and business-to-business order processing and routing from point-of-sale winery systems to 3rd party warehouses and compliance providers in real-time.

Senior Business Analyst

Health Net (Truebridge)
Rancho Cordova, CA
04.2016 - 09.2016
  • Analysis of existing CMS reporting processes and development of technical specifications for automated reporting data mart using Visio, MS SQL Server, Oracle, Business Objects, and MS Access.
  • MS SQL Server database design including ER diagrams, table and stored procedure creation, SSIS packages and comprehensive ETL processes mining and sourcing data via Oracle and Business Objects.
  • Use case, class, object, and sequence UML diagrams in MS Visio.

Senior Programmer

Builders & Tradesmen's Insurance Services
Rocklin, CA
11.2015 - 03.2016
  • Maintain responsive ASP.Net website using JQuery, AJAX, JSON, MVC, Web API, LLBLGen, VB.Net, and C#.
  • Maintain FirstData and Authorize.Net payment gateways using SOAP, MSE 3.0 and X509 client certificates.
  • Maintain DNN site and integrated ASCX controls employing CSS, JavaScript, JS-Grid, Bootstrap, and JQuery.

Database Administrator

City of Roseville (Genuent)
Roseville, CA
08.2015 - 11.2015
  • SQL Server 2005 / 2008 to SQL Server 2012 / 2014 upgrades and / or migration to updated servers.
  • Monitoring (Spotlight), management (Toad), patching, upgrades, documentation, and best practices for SQL Server.

Report Developer

Blue Shield (KForce)
El Dorado Hills, CA
03.2015 - 05.2015
  • Development in ASP.NET MVC, Razor, C#, LINQ to SQL, SQL Server Reporting Services, and Java script.
  • Support and enhancement of custom workflow and time management applications and effectiveness reporting.

Senior Solutions Engineer

Sutter Health (Direct Technology)
Mather, CA
12.2014 - 01.2015
  • Support HTML / VB Script applications and SQL Server database for asset and active directory tracking.
  • Analysis and enhancement of the Epic EHR deployment database and application.

Senior VB.Net and SQL Server Consultant

Placer County (Randstad Technologies)
Auburn, CA
08.2014 - 11.2014
  • Development in VB.Net and SQL Server.
  • Analysis and enhancement of the Air Pollution Control Department database and application.

Senior Compliance Analyst

Sutter Health
Sacramento, CA
03.2006 - 12.2012
  • Automated compliance scorecard and dashboard reporting presented quarterly to the board of directors using SharePoint, SQL Server, and MS Access.
  • Stark / Anti-kickback SharePoint surveys feeding a SQL database with MS Access data-marts downstream.
  • Physician Medicare billing against national average by specialty and ICD9 codes for every Sutter physician.
  • COSO Survey project management, tracking, and automated analysis and reporting of survey results.
  • Extraction of EthicsPoint data into MS Access for analysis and reporting of cycle times and incident types.
  • Recovery Audit Contractor management including tracking of turnaround times, targets, and outcomes. Auditing of extrapolated and overlapping RAC audits in support of appeals and / or payment processes.

IT Manager / Lead Developer (Principal Shareholder)

WineCompliancePro, Inc.
Sacramento, CA
12.2005 - 12.2012
  • Development in VB.Net, ASP.Net, ADO.Net, IIS, SQL Server, and MS Access.
  • Design and development of web portal, database, and web services for compliance checking of aggregate customer limits, licensing, dry areas and all other state rules for direct-to-consumer wine shipping.
  • Design, development, and support of automated MS Access reporting applications providing pixel perfect state sales and excise tax reporting for wholesale and direct to consumer wine sales.
  • Automated QuickBooks data extraction tool calling QBXML and QBFC functions from MS Access.
  • Designed, developed, and supported the SmartSource ETL framework and import processes for most winery systems.
  • Assisted in developing marketing materials, sales, trade show setup and product demonstrations, and lead vendor integration and strategic partnerships.
  • Established co-located server and network hosting and oversaw the development and implementation of all IT infrastructure including domain (AD), file, Exchange, and web servers and all network and desktop infrastructure.
  • Established standards, best practices and development operations including version and source code control, release management, and automated build and release processes for both server and distributed desktop products.

Senior Technical Analyst

Sutter Health
Sacramento, CA
05.2006 - 01.2009
  • Support of multiple databases on about 20 SQL Servers in three environments including replication, failover clustering, performance tuning, stored procedures, SQL SendMail and NetIQ alerts, Tivoli backups and restores, and ad hoc queries as needed.
  • Maintain Cold Fusion support web site.
  • ISQL, OSQL, SqlCmd, DTS and SSIS packages and scripts for import and export of data.
  • HL7 MSMQ parsing and monitoring, system and resource performance monitors, system log monitoring, and automated service restart stored procedures using XP_CmdShell.
  • Automated weekly restore of training databases, log moving and archiving, and system monitoring through stored procedures and DOS batch files.
  • Develop and maintain Crystal Reports.

Programmer Analyst

Vital Merchant Services
Sacramento, CA
02.2005 - 12.2005
  • Analysis, design, and development of applications in Access, Visual Basic, and ERP system SQL Server databases to support and augment complex ERP and online order processing systems.
  • Wrote, improved and maintained stored procedures to update multiple data marts incorporating ERP and other data sources for business intelligence, order processing, and inventory control.
  • Maintained automated file import processes from FTP sites including monitoring, troubleshooting, and re-coding of Visual Basic import processes.
  • Monitored and resolved database blocking and locking issues on legacy database systems while implementing the JD Edwards replacement.
  • Custom order processing and label printing automation.

Business Technologist

Southcorp Wines the Americas
Napa, CA
10.2002 - 02.2005
  • Designed & implemented a dimensional model data warehouse incorporating product and sale data from ERP systems, depletions data from BDN, and retail scan data into a snowflake schema supporting MS Query data mining and later integrated with a global ERP Business Warehouse.
  • Data analysis and database design using MS SQL Server and DTS including table structures, stored procedures, indexing, performance tuning, user rights, ETL packages, and system monitoring.
  • Wrote specifications for and managed all aspects of the Corporate Radar business intelligence project including inhouse and consulting resources. Documented user requirements, wrote use cases, and assisted vendor development of MS SQL Server database and Corporate Radar OLAP reports and cubes.
  • Product expert and lead developer on SQL Server and Corporate Radar including training and support of staff.
  • Created SSAS (Analysis Services) cubes with hierarchical dimensions summarizing data for complex pivot tables.
  • Automated inventory reconciliation weekly and monthly between the SAP winery system and 3rd party warehouse.
  • Automated U.S. BDN, and Canadian depletions data collection and reporting supporting channel and distributor management applications.
  • Automated wholesale sales and excise tax reporting.
  • Automated sales and commission reporting by region.

Programmer Analyst

Aardvark Computer Solutions
Palo Alto, CA
06.2002 - 10.2002
  • Co-design and development of a suite of products, which calculate and graph laboratory test results utilizing Access, Visual Basic, and Excel.

Development Analyst

Alert Staffing
Pleasanton, CA
11.2000 - 11.2001
  • Co-designed and developed integration and web-based data entry modules in Visual Basic 6 and SQL Server 2000.
  • SQL database administration, data conversion, and import / export routines.
  • Interfaced with end users, department heads, and corporate managers to gather and document requirements, feature lists, use cases, and workflows. Performed GAP analysis, user approval testing, and training.
  • Coordinated with programmers to refine functionality and create concise technical documentation.
  • Provided onsite implementation, training, and support for mission critical application rollouts nationwide.
  • Developed Crystal Reports.
  • Administration of NT development servers and test PCs.

Programmer / Release Engineer

Computer Associates
Redwood Shores, CA
02.2000 - 11.2000
  • Designed and developed installation programs using Install Shield 6.2.
  • Responsible for compilation of all source code for over 250 C++ and Aion projects and technical writers nightly and tracking down problems stemming from the compile. Maintained and improved batch scripts.
  • Administration of NT development servers, global error tracking systems, and Visual Source Safe.

Development Analyst

Covanta Solutions
Pleasanton, CA
02.1998 - 02.2000
  • Development and on-site implementation of ERP and database systems.
  • Provided product expertise, enterprise design, workflow, and needs analysis.
  • Created data conversion, import, export, and data integrity procedures.
  • Responsible for all data conversion and functionality at cut-over.
  • Designed and programmed front office GUI screens and Crystal Reports.

Microcomputer Support Specialist

Coherent Medical Group
Palo Alto, CA
06.1997 - 12.1998
  • Support of all network and desktop hardware, operating systems, applications, and peripherals in a 500-node heterogeneous, multi-platform, multi-protocol, Ethernet WAN environment. Administration of Novell servers.
  • Multi-vendor integration and support of IPS/SPX, NetBEUI, VMS, FTP, Telnet and TCP/IP protocols and services.

Report and Database Developer

FAS Benefit Communications
Palo Alto, CA
05.1996 - 06.1997
  • Created, managed, and fulfilled project plans for Acer Computers, Applied Signal, Auspex, Centigram, Chips & Technologies, Consilium, Creative Labs, ETAK, Force Computers, Genentech, Synergy, VISX, and many others.

Education

Certificate - Beginner and advanced classes in JD Edwards and C++ programming.

JDE Tips - Klee Associates
Minneapolis, MN
11-2005

Certificate - MS SQL Server 2000 Database Design, Access 2000, Crystal Reports 8, Visual Studio.Net Overview, Visual Studio.Net and ASP, and XML.

Mindleaders E-Learning Courses
Santa Clara, CA
01-1998

Associate's degree equivalent - Troubleshooting of radar and communications gear down to component level.

U.S. Navy - College of Lake County
Chicago, IL
01-1993

Associate of Science - Studies in basic electricity, electronics troubleshooting, and repair theory.

U.S. Navy - Basic Electricity And Electronics
Orlando
01-1993

High School Diploma -

Sonora High School
Sonora, CA
01.1987

Some College (No Degree) - Modern Database Design, and Programming with XML.

Foothill Junior College
Los Altos Hills, CA

Some College (No Degree) - Programming with Transact - SQL, Visual Basic 6 Programming and User Interface Design, and Linux Administration and Shell Programming (Bash, Bourne and C). Self-studies in Object Oriented Design.

Modesto Junior College
Modesto, CA

Certificate - Studies in all phases of programming with Visual Basic.

International Correspondence School
Santa Clara

Certificate - Network Essentials. Subjects covered included architectures, the OSI model, protocol stacks, standards, cable & wireless media, and network components.

Knowledge Alliance
Santa Clara

Skills

  • MS SQL Server
  • T-SQL
  • SSMS
  • SSIS
  • SSAS
  • SqlCmd
  • Bulk Load
  • XP_CmdShell
  • Tables
  • Views
  • Indexes
  • Stored Procedures
  • Constraints
  • Database Mail
  • MS Query
  • Power Shell
  • Linked DBs
  • OSQL
  • ISQL
  • Triggers
  • System Tables
  • Dynamic SQL
  • Variables
  • Flow Control
  • Error Trapping
  • Transactions
  • MS Visual Studio
  • Net Framework
  • VBNet
  • C#
  • ASPNet
  • ADONet
  • WCF
  • ASP Web Services
  • SOAP
  • XML
  • JavaScript
  • HTML
  • Distributed Transactions
  • JQuery
  • AJAX
  • JSON
  • X509 Client Cert
  • MVC
  • LINQ to SQL
  • Entity Framework
  • Dependency Injection
  • Objects
  • Procedures
  • Functions
  • DLLs
  • Services
  • MS Power BI Desktop
  • MS Power BI Services
  • MS Power BI Gateway
  • MS Power BI Report Server
  • Datasets
  • Power Query
  • M
  • DAX
  • Transforms
  • Models
  • Workspaces
  • Audiences
  • Visualizations
  • Reports
  • Dashboards
  • AD Azure
  • Premium Capacity
  • Oracle
  • PL/SQL
  • PostgreSQL
  • MySQL
  • Mongo DB
  • Spotlight
  • Toad
  • MS Access
  • VBA
  • Cognos
  • LLBLGen Pro
  • SQL Server Reporting Services
  • Crystal Reports
  • Informatica
  • ITextSharp

Databases

  • Oracle
  • PL/SQL
  • PostgreSQL
  • MySQL
  • Mongo DB
  • Spotlight
  • Toad
  • MS Access
  • VBA
  • Cognos
  • LLBLGen Pro
  • SQL Server Reporting Services
  • Crystal Reports (7-9)
  • Informatica
  • ITextSharp

Power Bi

  • MS Power BI Desktop
  • Services
  • Gateway
  • Report Server
  • Datasets
  • Power Query
  • M
  • DAX
  • Transforms
  • Models
  • Workspaces
  • Audiences
  • Visualizations
  • Reports
  • Dashboards
  • AD Azure
  • Premium Capacity

Timeline

Lead Business Systems Analyst, Data Analytics

Health Net Federal Services (Centene)
03.2024 - 01.2025

Project Lead Business Systems Analyst (Core Systems), Data Analytics

Health Net Federal Services (Centene)
03.2022 - 03.2024

Senior Business Systems Analyst, Finance

Health Net Federal Services (Centene)
03.2021 - 03.2022

Business Systems Analyst, Finance

Health Net Federal Services (Centene)
09.2017 - 03.2021

Consultant (Principal Shareholder)

WineCompliancePro, Inc.
10.2016 - 09.2017

Senior Business Analyst

Health Net (Truebridge)
04.2016 - 09.2016

Senior Programmer

Builders & Tradesmen's Insurance Services
11.2015 - 03.2016

Database Administrator

City of Roseville (Genuent)
08.2015 - 11.2015

Report Developer

Blue Shield (KForce)
03.2015 - 05.2015

Senior Solutions Engineer

Sutter Health (Direct Technology)
12.2014 - 01.2015

Senior VB.Net and SQL Server Consultant

Placer County (Randstad Technologies)
08.2014 - 11.2014

IT Manager / Lead Developer (Principal Shareholder)

WineCompliancePro, Inc.
12.2013 - 10.2016

Senior Technical Analyst

Sutter Health
05.2006 - 01.2009

Senior Compliance Analyst

Sutter Health
03.2006 - 12.2012

IT Manager / Lead Developer (Principal Shareholder)

WineCompliancePro, Inc.
12.2005 - 12.2012

Programmer Analyst

Vital Merchant Services
02.2005 - 12.2005

Business Technologist

Southcorp Wines the Americas
10.2002 - 02.2005

Programmer Analyst

Aardvark Computer Solutions
06.2002 - 10.2002

Development Analyst

Alert Staffing
11.2000 - 11.2001

Programmer / Release Engineer

Computer Associates
02.2000 - 11.2000

Development Analyst

Covanta Solutions
02.1998 - 02.2000

Microcomputer Support Specialist

Coherent Medical Group
06.1997 - 12.1998

Report and Database Developer

FAS Benefit Communications
05.1996 - 06.1997

Certificate - Beginner and advanced classes in JD Edwards and C++ programming.

JDE Tips - Klee Associates

Certificate - MS SQL Server 2000 Database Design, Access 2000, Crystal Reports 8, Visual Studio.Net Overview, Visual Studio.Net and ASP, and XML.

Mindleaders E-Learning Courses

Associate's degree equivalent - Troubleshooting of radar and communications gear down to component level.

U.S. Navy - College of Lake County

Associate of Science - Studies in basic electricity, electronics troubleshooting, and repair theory.

U.S. Navy - Basic Electricity And Electronics

High School Diploma -

Sonora High School

Some College (No Degree) - Modern Database Design, and Programming with XML.

Foothill Junior College

Some College (No Degree) - Programming with Transact - SQL, Visual Basic 6 Programming and User Interface Design, and Linux Administration and Shell Programming (Bash, Bourne and C). Self-studies in Object Oriented Design.

Modesto Junior College

Certificate - Studies in all phases of programming with Visual Basic.

International Correspondence School

Certificate - Network Essentials. Subjects covered included architectures, the OSI model, protocol stacks, standards, cable & wireless media, and network components.

Knowledge Alliance

Similar Profiles

CREATE PROFILE
David C. Era