Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Optum (formerly Alere Wellbeing)Data Analyst II
Mar. 2018Remote/TelecommuteAccomplishments March 2020 Used Python/pyspark/pandas with Jupyter Notebook, in concert with Excel/VBA to create an aggressive data testing regime using a semi-automated pipeline that increased test data sampling (differences) on average by 4000% for a data migration project. The initiative moved data from multiple claim adjudication systems to an enterprise data warehouse used for data science and analytics where data could be refreshed daily instead of monthly. December 2019 Spearheaded COB user acceptance testing for the Daily Data Feed project for data inbound from the COSMOS and UNET platforms. March 2019 Using the Python language, cleaned/wrangled data and created a prototype machine learning model using the pandas and sklearn packages for predicting new COB (Coordination of Benefits) records among Medicaid members in CSP Facets using the following algorithms: • Naïve Bayes • K-Nearest Neighbors • Random Forest Wrote a report summarizing the development of the model and the resulting predictions: Top 5 states and age ranges to find new Medicare Parts A & B COB flags. Spearheaded the migration/access for 30 data analysts to the Data Science Workbench, a virtual platform designed specifically for data science and analytics. Also led Python training sessions on learnpython.org September 2018 Completed conversion of R data wrangling scripts, as well as Random Forest and Naïve Bayes machine learning scripts to Python using the pandas, numpy, and sklearn packages. August 2018 Using the R language, cleaned/wrangled data and created a prototype machine learning model with the caret package for predicting new COB (Coordination of Benefits) records among senior Medicaid members in CSP Facets using the following algorithms: • Generalized Linear Model • Linear Discriminant Analysis • Naïve Bayes • Neural Network • Random Forest
UnitedHealthcareSenior Application Developer
Dec. 2016 - Mar. 2018Telecommute/Work From Home• Designing, coding, testing, documenting and supporting ETL operations • Developing pioneering approaches to emerging industry trends • Contribute to development team and help to achieve key business objectives • Contribute to large, complex projects to achieve key business objectives • Solves unique and complex problems with broad impact on the business • Translates highly complex concepts in ways that can be understood by a variety of audiences • Troubleshoot MS SQL issues as they arise • Work with the business in the development of new technology • Develops innovative approaches • Sought out as expert Accomplishments April 2017 EDI 834 Proof-Of-Concept. This program, written in C#, parses a state EDI 834 enrollment file, pushes member information into the UPI database. This POC forms the codebase for the rest of UPI's 834 projects including Arizona, California, Florida, Hawaii, Mississippi, Missouri, and Washington. June 2017 Deployed the CAV (Cost Avoidance) Staging Pipeline, an SSIS package that: • Automates the validation/processing of member data imported daily into CSP Facets. • Sets COB (Coordination of Benefits) flags in CSP Facets that average $360,000 saved for the Medicaid program per month. • Is part of a process that establishes an end-to-end data lineage for imported member data. September 2017 Deployed the CAV Results Summary, an SSIS package that emails an HTML-formatted summary of the previous day’s (or Friday’s) CAV Data Load. October 2017 Deployed the Oxford Medicare Anticipation package that pulls Oxford member data from the source system and makes it available for reporting from the UPI database. December 2017 Deployed the CAV Recon 2017 Dashboard, a Tableau-based dashboard that presents a visual summary of COB (Coordination of Benefits) flags set in CSP Facets and allows a drill-down by actual numbers (bar chart), date (timeline), or state (U. S. Map). January 2018 Deployed the CAV Recon 2018 Dashboard.
OptumSenior EDI Business Analyst - Telecommute
Aug. 2015 - Dec. 2016Telecommute/Work From HomeResponsible for implementing various EDI (Electronic Data Interchange) interfaces along with receiving support calls to troubleshoot any customer service issues. IT support point of contact for electronic communication of employee health insurance data via EDI between the Optum Market application, the 834Clearinghouse application, and employee benefit providers. Participate in system design and quality assurance activities. Responsibilities and Duties: •Implement and maintain existing data interfaces including ANSI X12 834, FSA, COBRA and similar carrier data feeds •Create lightweight, custom applications in the UNIX environment to automate data exports out of Plansource. •Research and resolve data discrepancies from interfaces. Recommends and implements corrective actions •Works closely with project team and to ensure project deliverables are met in an efficient and timely manner •Develops and documents internal processes •Communicate/coordinate with carriers and internal parties related to interface projects Accomplishments January 2016 - March 2016 Delivered UHG’s 2015 monthly ACA enrollment report from data contained in the benefit administration system Optum Market; report generated by a Java .exe running on a Linux server and retrieving data from a MySQL database. February 2016 - May 2016 Delivered UHG’s 2016 monthly ACA enrollment report from data contained in the benefit administration system Optum Market; report generated by a Java .exe running on a Linux server and retrieving data from a MySQL database. June 2016 Created an automated tool for determining COBRA coverage eligibility for dependents of divorced subscribers. The Windows form application was coded in C# to query the Optum Market MySQL database for subscriber/dependent data, as well as an Access 2010 database containing data for COBRA coverage. The code employs asynchronous operations using the C# “await” and “asynch” keywords to handle long-running processes.
Robert Half TechnologySoftware Engineer (consultant to San Joaquin General Hospital) -Telecommute
Aug. 2014 - Aug. 2015Telecommute/Work From HomeExternal consultant to the information systems department of a 196-bed general acute care and trauma facility in Stockton, CA. that provides a full range of inpatient services including General Medical/Surgical Care, High-Risk Obstetrics and Neonatal Intensive Care, Pediatrics and Intensive Care. Responsibilities Responsible for systems integration, application support (clinical laboratory), system architecture, server architecture, data server/database management. Accomplishments • November 2014. Coordination of activities in support of the installation of Data Innovation’s Instrument Manager on three HP Proliant Servers in SJGH’s clinical laboratory. Supported the production go-live integration (including diagnostics/troubleshooting) of two Abbott Architect analyzers with Instrument Manager and SJGH’s laboratory information system NTT Data Optimum Lab. • January 2015. Production go-live of SJGH ADT feed with Medisas’ cloud-based patient management workflow software via integration of SJGH's hospital information system, a Mirth Connect channel, and an encrypted, mutually-authenticated service hosted on Amazon Web Services. • February 2015. Completed SJGH laboratory Instrument Manager failover simulation, switching order/result routing from the primary to the shadow (secondary) server, then rolling back to the original configuration. Created failover documentation. • April 2015. Completed production QA and go-live of SJGH ADT feed from Mirth Connect outbound to Inland Empire Health Information Exchange. • May 2015. CAP inspection of St. Agnes Medical Center Clinical Laboratory in Fresno, CA.; responsible for LIS evaluation. • June 2015. Production go-live of SJGH ORU feed with Medisas’ cloud-based patient management workflow software: integrated source data from SJGH clinical laboratory, radiology, and Quest Diagnostics. Skills: HL7: ADT, ORU, RDE Mirth Connect JavaScript SQL Server 2008/T-SQL Networking Technical Documentation Application Support/troubleshooting
TEKsystemsProject Engineer (consultant to Siemens MobileMD) - Telecommute
Sep. 2013 - Jun. 2014Telecommute/Work From HomeResponsibilities I was responsible for all the technical aspects of delivering custom configured HIEs that meet the customer’s goals and deadlines. • Modified existing HIE code and configured to support addition of new feeds, new features being implemented, customer enhancements, internal and external upgrades, ongoing ambulatory EMR rollouts • Unit tested entire HIE as required for deployment of new installs, upgrades and customer specific enhancements • Documentation of interface designs and HIE configuration and code • Tracked issues, through follow up and resolution • Provided production support for escalated issues Accomplishments As the project engineer, I built and delivered health information exchanges for the following health systems: • Northwest Hospital (ADT only), Seattle, WA - April 2014 • Sacred Heart Health System (ADT only), Allentown, PA - April 2014 • Ingalls Health System (ADT only), Chicago, IL - May 2014 • Union Hospital Health System (ADT only), Terre Haute & Clinton, IN - June 2014 • Kaweah Delta Healthcare District (ADT only), Visalia, CA - June 2014 Also created engineering documentation for setting up the development environment, building a new/existing HIE, moving an HIE project from the development to testing environment. Skills Used • HL7 • Visual Studio 2010 • Visual Basic.NET • ASP.NET • SQL Server 2008 • XML/XSLT/XPath • Corepoint Integration Engine • Technical Documentation
OptumSenior Business Analyst/Microsoft .NET Developer - Telecommute
Mar. 2012 - Sep. 2013Telecommute/Work From HomeResponsibilities I was responsible for Windows client/server software and database development (Visual Studio 2010/SQL 2008 & Oracle 10), business intelligence (reporting) development, and support of the eDTS ETL (Extract, Transform, and Load) custom application for the Solutions team, Data File Management group of Care Solutions in Optum. Accomplishments • Created console application (VB.NET) to read HL7 2.x files, recognize and parse header, patient, event, patient visit, and observation request/result segments and persist to database. Proof-of-concept to be used to demonstrate future capabilities for DFM group. • Design production console application (VB.NET) that serializes metadata from XML files and persists to SQL Server database. • Created multiple daily metric reports pulling data from SQL Server and Oracle databases for inbound biometric data files. • Developed multiple console applications and configured with SQL Server 2008 and Windows 2008 Task Scheduler to create automated 24/7 file monitoring processes (email, network, FTP/SFTP). • Created Windows-based application to monitor automated processes. • Created Windows-based reports system. • Mentored and train team members in writing, testing, and debugging SQL queries. • Managed the DFM Sharepoint site: completed site redesign in May 2012. Creating customized graphics for site branding. Skills Used • Visual Studio 2010, .NET, ASP.NET • Visual Basic.NET • T-SQL • SQL Server 2005/2008, SSRS, SSIS • Oracle 10 • Sharepoint • ETL • Business Analysis/Requirements Gathering
Diamond Communications, Inc.Information Technology & Systems Security Specialist
Jun. 2006 - Jul. 2007Madera, CA.Responsibilities Network administration and desktop user support for local alarm/security company. Duties included both internal user support and client support. Accomplishments • Successfully managed network infrastructure through transition from ATT/SBC DSL and analog trunk lines to Time Warner Telecom T1 for voice and data service, including configuring access control lists for a Cisco 2600 border router. Six months later, managed the retrograde of three lines back to ATT/SBC analog. • Also set up Intrusion Detection System using Snort and SQL Server, as well as installed and configure digital surveillance video and hospitality systems. • Spearheaded the effort to export and produce customer data in an effort to sell 400 residential and commercial alarm monitoring accounts to Safe Security. Skills Used • Windows Desktop Support • Technical Support/diagnostics/troubleshooting • TCP/IP Networking • Cisco Router Configuration • Windows Server installation/configuration • Digital Surveillance Video installation/configuration • Access Control installation/configuration
Robert Half TechnologyConsultant - Telecommute/Part-Time
Sep. 2004 - Mar. 2005Telecommute/Work From HomeWeb application and database programming using ASP.NET, C#, and SQL Server 2000. Implemented new features for http://www.users-edge.com, an online information organizer site.
Self-employedConsultant – Telecommute/Part-Time/Freelance
Apr. 2004 - Jun. 2007Telecommute/Work From HomeResponsibilities Web application and database programming Accomplishments Designed and architected online video dictionary, toy catalog, and informational pages for a site by BabyHands, a publisher of a DVD that teaches basic American Sign Language to babies: http://www.mybabycantalk.com. Skills Used • Visual Studio, .NET, ASP.NET • SQL Server 2000 • Visual Basic. • T-SQL
BrightcodeProgrammer/Analyst
Aug. 2002 - Apr. 2004Fresno, CACustom application development for Fresno-based software engineering firm using classic ASP, SQL Server 2000, Access, and Excel. Projects included: Debug/deployment/maintenance/feature enhancement of Web applications (database, e-commerce/real-time encrypted credit card authorization, shopping cart, UPS shipping integration via XML) and client-side validation scripting in JavaScript.
Self-employedConsultant – Telecommute/Part-Time
Jun. 2002 - Dec. 2003Telecommute/Work From HomeResponsible for managing, maintaining, and supporting an enterprise-level decision support/data intranet reporting system based on Crystal Enterprise 8.5, deployed on a Win2000 Advanced Server using IIS 5.0. Maintained and supported SupportMagic, Financial Technical Systems division’s mission-critical help-desk software (using a Sybase SQL AnyWhere database); users located remotely in Pleasanton, Torrance, Turlock, CA., and Portland, OR. Supported using Windows 2000 Terminal Server and VNC.
NetsWork, Inc.Database Administrator/Programmer
Dec. 2001 - May. 2002Fresno, CAManaged, maintained, and supported enterprise-level decision support/data reporting system based on Crystal Enterprise 8.5, deployed on a Win2000 Advanced Server using IIS 5.0, and delivered via NetsWork’s intranet. Maintained, and supported SupportMagic, NetsWork Financial Technical Systems division’s mission-critical help-desk software (using a Sybase SQL AnyWhere database); users located remotely in Pleasanton, Torrance, Turlock, CA, and Portland, OR.
NetsWork, Inc.Programmer
Jan. 2000 - Sep. 2001Fresno, CAConverted NetsWork's mission-critical in-house dispatch/invoice/invoice software, Service Response System (SRS) from Visual Basic 6/Access to SQL Server 2000, which was used to generate weekly billing with an average grand total of over $40,000. Deployed SRS v.8 over corporate VPN to Fresno Branch and 8 other NetsWork branches in California and Oregon via Microsoft Terminal Server, Citrix MetaFrame and NFuse.
Central Unified School DistrictMicrocomputer Specialist/Programmer
Jun. 1998 - Dec. 1999Fresno, CACustom programming, database management/support (student attendance and library automation applications), network administration (Novell Netware 4.11 and Windows NT 4.0), and user support for the business and finance office of medium-size school district with 10,000 students.
Squarerigger CorporationProgrammer
Jan. 1998 - May. 1998Sonora, CASoftware construction for developer of Windows 95 vehicle tracking, maintenance, and inventory software. Participated in the successful conversion of existing code from Clarion to a Visual Basic 5 front-end, with an ODBC data source. Under supervision of project lead, examine behavior of existing DOS product and hard copy of existing Clarion code; write algorithms, build, test, document and debug code in Visual Basic. Created/manipulated classes, objects. Heavy usage of SQL queries against multiple tables using RDO (Remote Data Object. GUI design/forms construction using native and 3rd party controls/add-ons such as Sheridan panels, VideoSoft flex grids, and VBAssist
Intch is a Professional Networking App for the Future of WorkSee more people like Dwayne on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
1027651 people
17
Application Developer @ Nile27
16
Manager Solution Consulting @ Alkami Technology
16
Program Manager @ DISH Network
169091 people
17
Business Analyst
19
Manager @ Epic Force
15
Data Scientist