David C. Era
Sacramento
Summary
Dynamic and resourceful technologist with over 25 years of success in design and implementation leadership. Expertise in delivering solutions aligned with business objectives, backed by a strong background in developing and optimizing Business Intelligence systems for timely and budget-conscious results. Proficient in managing large-scale projects through Agile, hybrid, and waterfall methodologies, focusing on stakeholder engagement, risk mitigation, and comprehensive training initiatives. Skilled in crafting detailed development plans and building fully normalized databases to support transactional and ERP applications, as well as dimensional models for analytics in high-availability environments like large e-health record systems.
Overview
38
38
years of professional experience
Work History
Lead Business Systems Analyst, Data Analytics
Health Net Federal Services (Centene)
Rancho Cordova, CA
03.2024 - 01.2025
- Served as lead business systems analyst, Power BI admin, SQL Server database owner, and lead programmer.
- Project lead, developer, and product expert for SQL Server, SSIS, Power BI Server and Desktop implementations.
- Create and document Power BI DevOps processes for connections, deployment pipelines, data and report version control, change capture processes for direct connections, and more.
- Create test scripts and training documents for Power BI connections, data models, reports, visualizations, etc.
- Initial planning for SQL SSIS integration with Python for ML and AI pilot.
- Initial analysis of integrated PBI Services (cloud), Office 365 (cloud), SSIS, Web API, and Power Automate.
- Evaluation of AWS, Azure, and Google Cloud for lift-and-shift hosting or cloud migration.
- Project lead, developer, and product expert for pilot implementations of Alteryx, Jira, and Snowflake.
- Provide project management, technical and subject matter expertise, problem solving, and implementation oversight.
- Lead proof-of-concept developer and designer on multiple systems and special projects.
- Conduct product and solution trials and assist in budgeting, licensing, and procurement.
- Create development standards and best practices and ensure delivery of high-quality systems, software, and processes.
- Create system diagrams and define projects and requirements using Visio, MS Project, Excel, Draw IO, Jira, etc.
- Consult on and optimize project and program management methodologies and disciplines.
Project Lead Business Systems Analyst (Core Systems), Data Analytics
Health Net Federal Services (Centene)
Rancho Cordova, CA
03.2022 - 03.2024
- Combine data, analysis, and subject matter expertise to spotlight areas of greatest impact and create clear, concise, and insightful reports, visualizations, dashboards, and data extracts.
- 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.
- Developed SQL Server databases, stored procedures, and ETL processes in T-SQL, PL SQL and SSIS.
- Created distributed PL SQL queries across multiple Oracle database servers 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.
- Conduct vendor and product trials, design and implement new systems and processes including DevOps, role clarity, best practices, and continuous improvement.
Senior Business Systems Analyst, Finance
Health Net Federal Services (Centene)
Rancho Cordova, CA
03.2021 - 03.2022
- Design and implementation of MS SQL Server, Integration Services (SSIS), and Control-M data mart.
- Migration and automation of Health & Welfare payroll processes from Excel to SQL Server and Integration Services reducing reported payroll errors from 2-5 per bi-weekly cycle to 1-2 per year (26 cycles) and manual processing time from 40+ hours per cycle to a few hours.
- 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 Power BI.
Business Systems Analyst, Finance
Health Net Federal Services (Centene)
Rancho Cordova, CA
09.2017 - 03.2021
- Database design and development on AWS SQL Server including tables, indexes, views, and stored procedures.
- Developed a reliable, repeatable audit process framework for reconciling VA claim payments.
- Analysis of internal and external systems to identify unique keys to cleanly relate and reconcile individual transactions across previously unrelated claims, accounting, and banking systems.
- Further remediation of claim data based on my 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 - 07.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.
- Turnover 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 OrderChk 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 (Trubridge)
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.2009 - 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
- 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.
- 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.
- 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.
Senior Technical Analyst
Sutter Health
Mather, 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, 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 de America
Napa, CA
10.2002 - 02.2005
- Designed & implemented a dimensional model data warehouse incorporating product and sale data from ERP systems, depletions wholesale data, 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 in-house 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.
- Converted data from HRIS systems into useable formats and created custom databases and reports.
- Maintained Lantastic network, desktop applications, and office peripherals.
- Wrote Excel macros and dBase calculations to sort, graph and display data.
Project Manager / Analyst (Majority Owner)
Aardvark Computer Solutions
Palo Alto, CA
09.1994 - 05.1996
- Worked with customers to determine what network design and level of service was most appropriate.
- Compiled feature lists and program specifications for custom programming work.
- Estimated costs and compiled quotes for network upgrades, installations, and service contracts.
- Tracked and scheduled all phases of projects to ensure profitability and maintain customer relations.
U.S. Navy Reserve
01.1987 - 01.1994
- Other and unrelated work experience.
Education
Microsoft Certified: Azure Fundamentals - Course AZ-900T00-A: Introduction to Cloud Infrastructure, Introduction to Azure Data Factory, Explore core data concepts, Orchestrate data movement and transformation in Azure Data Factory or Azure Synapse Pipeline, Execute existing SSIS packages in Azure Data Factory or Azure Synapse Pipeline
Learn.Microsoft.com
JDE Tips - Beginner and advanced classes in JD Edwards and C++ programming
Klee Associates
U.S. Navy - Troubleshooting of radar and communications gear down to component level, Class work completed is equivalent to an associate’s degree in electronics troubleshooting and repair
College of Lake County
U.S. Navy - Studies in basic electricity, electronics troubleshooting, and repair theory
Basic Electricity and Electronics
Graduate - undefined
Sonora High School
Skills
- MS SQL Server
- T-SQL
- SSMS
- SSIS
- SSAS
- SqlCmd
- Bulk Load
- XP_CmdShell
- Tables
- Views
- Indexes
- Stored Procedures
- Constraints
- Database Mail
- Agent Jobs
- MS Query
- Power Shell
- Linked DBs
- OSQL
- ISQL
- Triggers
- System Tables
- Dynamic SQL
- Variables
- Flow Control
- Error Trapping
- Transactions
- MS Power BI Desktop
- Report Server
- Datasets
- Power Query
- DAX
- Transforms
- Models
- Workspaces
- Audiences
- Visualizations
- Reports
- Dashboards
- AD Azure
- Premium Capacity
- 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
- Oracle
- PL/SQL
- PostgreSQL
- MySQL
- Mongo DB
- Spotlight
- Toad
- MS Access
- VBA
- Cognos
- LLBLGen Pro
- SQL Server Reporting Services
- Crystal Reports
- Informatica
- ITextSharp
- MicroStrategy
- Snowflake
- Amazon Web Services
- Visio
- Draw IO
- Jira
- Confluence
- Trello
- ServiceNow
- MS Project
- SharePoint
- Excel
- Altyrx
- Active Directory
- IIS
- CSS
- QuickBooks
- QBXML
- QBFC
- IPS/SPX
- NetBEUI
- VMS
- FTP
- SFTP
- Telnet
- TCP/IP protocols
- DOS
- PowerShell
- CyberArk
- Password Manager Pro
- Request & Access Central
- GlobalScape
Personal Information
Title: LEAD BUSINESS SYSTEMS ANALYST AND DATA ENGINEER
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 - 07.2017
Senior Business Analyst
Health Net (Trubridge)
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 Compliance Analyst
Sutter Health
03.2009 - 12.2012
Senior Technical Analyst
Sutter Health
05.2006 - 01.2009
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 de America
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
Project Manager / Analyst (Majority Owner)
Aardvark Computer Solutions
09.1994 - 05.1996
U.S. Navy Reserve
01.1987 - 01.1994
JDE Tips - Beginner and advanced classes in JD Edwards and C++ programming
Klee Associates
U.S. Navy - Troubleshooting of radar and communications gear down to component level, Class work completed is equivalent to an associate’s degree in electronics troubleshooting and repair
College of Lake County
U.S. Navy - Studies in basic electricity, electronics troubleshooting, and repair theory
Basic Electricity and Electronics
Graduate - undefined
Sonora High School
Microsoft Certified: Azure Fundamentals - Course AZ-900T00-A: Introduction to Cloud Infrastructure, Introduction to Azure Data Factory, Explore core data concepts, Orchestrate data movement and transformation in Azure Data Factory or Azure Synapse Pipeline, Execute existing SSIS packages in Azure Data Factory or Azure Synapse Pipeline
Learn.Microsoft.com