Relational database management systems (RDBMS)
Microsoft SQL Server, Microsoft Access, Teradata, Oracle
Reporting Systems
SQL Server Reporting Services (SSRS), Microsoft Access, Microsoft Excel, Tableau, Microstrategy
Data Integration Systems
SQL Server Integration Services (SSIS), Oracle Loader
SQL Database Development
Design, Develop, and Maintain Databases and Database Objects: Tables, Stored Procedures, Views, Triggers, Rules and Functions
Coding / Programming / Web Development languages
Structured Query Language (SQL), Visual Basic (VB/VBA), JavaScript, jQuery, C#, HTML, CSS, XML
Application Development & Support Engineer
Conduent, Inc.
Sacramento, California
Jan 2018 - Present
• Develop/Administer/Maintain Production database solutions
• Develop Daily/Weekly/Monthly reports for executive review
• Develop customer facing web forms for online eligibility submissions
• Analysis and report automation using Microsoft SSRS/SSIS/SSMS
• IT project management
• Manage/Administer Dev/UAT/Production environments via Amazon Web Services using 3-tier architecture
Sr. Programmer Analyst
Health Net Federal Services, LLC
Rancho Cordova, California
2017
• Production database management and support
• Enterprise UI solution management and support
• Reports and data integration automation through SSRS and SSIS
• Enterprise claims and enrollment system upgrade and UI Integration
Systems Development Specialist
Xerox Solution Services
McClellan Park, CA
2016
• Support through analysis, automation and database management
• System/access administration for internal and external users
• UAT testing/debugging/tracking of customer facing interfaces
• Research and resolve complex customer issues
• Develop, test, and deploy solutions with SQL Server tools: SSMS, SSIS, SSRS
Data Analyst II
california health & wellness
Sacramento, CA
2014 - 2016
• Support Quality Improvement Department focused on Healthcare Effectiveness Data and Information Set, and Appeal and Grievance
• Extract and analyze data for national and state regulatory reporting
• Design, create and manage production databases to support department and enterprise goals
• Key Projects: Monthly provider HEDIS Status Reports and incentive programs with multi-million dollar budget; Build and manage Executive dashboard
Business Systems Analyst - Reporting
University Healthcare Alliance / Stanford Health Care
Richmond, CA
2014
• Support and manage enterprise reporting SSRS
• Enterprise reporting: Membership/Claims/Utilization Management/Provider Networks/Credentialing
• Key Projects: Design/Develop the Stanford Health Care Advantage Provider Directory (2015-2016)
Health Care Analyst
Health Net, LLC
Rancho Cordova, CA
2012 - 2014
• Support HEDIS Measurement and Reporting IT team
• Design, build and support databases for use of tracking, analysis, QC and reporting
• Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouse
• Standardization and normalization of large and complex data sets within the healthcare industry
• Create automated processes to manage and QA monthly data extracts from various data sources
• SQL Server and Oracle SQL data warehousing architecture and the healthcare industry