Benjamin Pacheco Email & Phone Number

Arvada, Co, Us

Centennial, Colorado, Us

Mergers and AcquisitionsAPIsCloud Data WarehousingPython

Broomfield, Co, Us

Duties of the job:• Build an analytics center of excellence across a multi-hospital and ambulatory system• Be responsible for Architecture and maintenance of Data Warehouses• Develop and apply Artificial Intelligence and Machine Learning solutions to healthcare business and operational problems• Manage data structures and automate ETL processes for Salesforce, Google BigQuery, ServiceNow, and OracleERP.• Develop and build custom applications, dashboards, interfaces, reports, data sets, registries, data visualizations, predictive models and other analytic solutions• Leverage big data, machine learning and artificial intelligence technologies to build innovative solutions• Lead the creation of analytic frameworks, use agile methodologies and design thinking to further develop analytic stack• Linux and Hadoop stack migration to Python and Google BigQueryKey Skills:• Google Cloud Platform• BigQuery• Storage• Google Sheets• GoogleScripts• ETLs• Google Analytics• Python (Anaconda)• Rest APIs• Service Account Authentication• OAuth2.0 Authentication• Sql Server Administration• PostgreSQL• Epic and Clarity• Revenue Data Model Certification

Wheat Ridge, Colorado, Us

API development with both REST for UltiPro web services (JSON) and SOAP web services for Netsmart EHR (XML).Integration of Tableau, Tableau Prep , and Ask Data experience.System architect for implementation of Atlassian products on Azure cloud.Administration of two cloud servers on Azure (running Windows Server 2016) - one server houses a data warehouse in SQL Server 2016 - on the second server, implemented JIRA, JIRA CORE, Portfolio, Confluence, Fisheye, and CrucibleIntegrated servers and software into private network while navigating firewall complicationsAdministrator/Developer for all Atlassian productsData conversion and structuring for data warehouseBitBucket AdministratorProgrammer Analyst:-Netsmart's Avatar EHR for Behavioral HealthScriptlink developer using Java & JavaScript through Eclipse editor for form design and web servicesXML web servicesAvatar Database web servicesCreation of web services and DCI importTesting and Documentation for web servicesCache DatabaseCache SQLForm CreationView CreationWidget developerRevision control through BitBucketCrystal ReportsSQL Management StudioT-SQLWeb page developer: HTML5, CSS, C#, Visual Studio 2012, 2010JCMH Portal (Intranet) - data and web page conversion from ColdFusion to ASP.NETContinued Portal (ASP.NET, C#) maintenanceDatabase conversion from ACCESS to SQL serverKPI Dashboard DevelopmentC#, ASP.NET web pagesCreated dynamic charts using Chartist.js / GoogleCharts and other javascriptWebMethod integration for live table and data updates from SQL serverData mining (text mining), analytics (medical claims), and prediction using KNIME Analytics Platform along with a few imported R and Python scriptsWS 2012 for clustering and partitioning for KNIME analytics platform jobs

Denver, Co, Us

• Database Administration for Microsoft Access and MSSQL Server 2008• ETL Microsoft SQL Server Integration Services• Data mining and analysis with very large datasets• Advanced SQL• Heavy Use of SQL• Heavy Use of PL/SQL• Data Analysis / Statistical Analysis• SAP Crystal Reports 2013 – Development• MS Visual Studio 2012• JDBC connections• Data Migrationo Colorado Department of Revenue Emissions Section – MS SQL Server 2008 R2 to MLO databaseso Colorado Department of Human Resources - Legacy Database to intuit QuickBase• Website development for all of Colorado Department of Revenue Emissions Sectiono https://www.colorado.gov/pacific/dmv/gas-vehicleso https://www.colorado.gov/pacific/dmv/rapidscreeno https://www.colorado.gov/pacific/dmv/diesel-vehicleso https://www.colorado.gov/pacific/dmv/emissions-complainto https://www.colorado.gov/pacific/dmv/emissions-waivero https://www.colorado.gov/pacific/dmv/coming-coloradoo https://www.colorado.gov/pacific/dmv/faqs-emissionso https://www.colorado.gov/pacific/dmv/contact-us-emissions• Google Analytics on webpage development• Use of HTML5, CSS, JavaScript with PHP (NetBeans) database connection.• Use of JavaScript and Google Script to alter forms and applets.• Visual Basic Application• VB.net (Visual Studio 2012), ASP.net (Visual Studio 2012), Java (Eclipse IDE)• My License Office (MLO) Development, User Defined Object creation.• Data Record Retention & Reportingo Colorado DOR License Section – Prevention of data loss and corrupt report analysis through migration of old reporting system to new Google Drive solution• UML Business Analysto Helped with ERP module implementation of MLO. In charge of Project Charter and Business Requirements documents.• Remote Desktop with test environments.• Built intuit database for HR department, Data analyst and migration from old system to new intuit databases.• Tableau• ORACLE 12 databases and earlier

Denver, Co, Us

• Program support of High Level Office Management by advising lower level Managers and Admin III employees• Analytical problem solving and decision making• Advanced proficiency with Microsoft Office Word (PowerPoint/Outlook/Access/SQL, Excel, etc.) and Pivot Tables/Reports• VBA• Advanced SQL• Gmail (Drive/email/messaging/etc)• Data Entry, Demographics, Verifications• Scanning, POS (Proof of Service), PSI Titles• Record Combinations• Quality Control• Crystal Report Development 2003• ORACLE

Master’S Degree, Computer And Information Systems Security/Information Assurance

Bachelor’S Degree, Engineering Physics