Experience

Jellyvision

• United States
• Software Development
• 200 - 300 Employee

• Lead Application Developer

  • Feb 2021 - Present



Verge Health

• Chicago, IL

• Lead Engineer / Architect

  • May 2016 - Oct 2020

  Lead Architect on multiple Scrum teams that generated data tagging system for vertical data store, redesigned patient database, developed front end Angular code, and managed data for cube reports; responsibilities included generating functional and technical documentation, application design and development, and performing code reviews. Principal architect responsible for SQL Server performance optimization. ● Redesigned SQL Server patient database, reducing search time by 50%, increasing Mirth HL7 import capacity by 100%, while increasing logging and allowing for point in time view of patient information. Patient database contained over 60 million patients. ● Lead Developer on Scrum team of 6 people that maintained Angular front-end website. Primarily responsible for design and architecture of the changes, database back-end and integration with external systems. Integrated Verge Health events application to allow for SSO login from EPIC and CERNER health systems. ● Developed SQL procedures to generate cube data for Sisense reporting system. Generic cube generation process pivoted vertical data store into MOLAP dataset using Cartesian product logic. Process calculated 21 full cubes (30 million records total) in 20 minutes and deltas for those same cubes in under 5 minutes. ● Redesigned permission builder system that took 36 hours to calculate 9 billion user permissions with updated routine that took approximately 25 minutes. Further enhanced the process to allow for delta generation in under 5 minutes to prevent overtaxing the system during normal business hours. ● Designed and developed solution to change vertical data store of unknown data into Entity-Attribute-Value data structure to enable intelligent use of questions and answers for surveys. Added fields to identity attributes and values for questions and answers, respectively. ● Responsible for generating SQL development standards and mentoring developers on improving SQL syntax and best practices. Show less



Rise Health, Inc.

• United States
• Hospitals and Health Care
• 1 - 100 Employee

• Lead Developer / Sr. Software Architect

  • Apr 2013 - Mar 2016

  Lead Architect of Scrum team that designed and developed data warehouse, combining EMR and claim data from any number of sources to provide a complete view of a patient; responsibilities included application design and development, generating functional and technical design documents, interfacing with clients and 3rd party companies, and performing code reviews. Principal Best Doctor’s architect responsible for reducing duplication across applications and integrating new applications/products. ● Designed general import ETL architecture, using Pentaho, to consistently import data from various formats, including flat file, XML, HL7, X12, and Excel. ETL imports are capable of processing 40 million claim lines 2 hours and 3.5 million patient records in 1.5 hours. ● Developed generic claims database structure and associated ETL load process, to store professional, institutional, and pharmaceutical data that handled revisions, regardless of whether an original claim ID was provided. In order to minimize file reloads, the structure was such that a claim record could be created without the associated patient; when the patient was subsequently created, it would be immediately linked to the existing claims. Database for the largest client has over 600 million claim lines. ● Enabled medical cost analytics by implementing HEDIS and PQRS measures, including yearly updates. ● Initiated code review effort that reduced bugs by over 80%. ● Architected a separate shared database to store configuration data and standard code sets (ICD-9, ICD-10, CPT, HCPCS, etc.). Utilized two copies of this database and synonym switching to ensure 100% up-time using SQL 2008R2 log shipping. ● Developed SAML 2.0 SSO Service Provider, using ASP.Net and C#, to allow clients to control access to patient reporting. ● Developed custom .Net base object library, using C# that allows for partial object updates, robust error handling via validation attributes, and transactions. Show less



Online Business Applications

• United States
• Software Development
• 1 - 100 Employee

• Manager .Net Development

  • Nov 2012 - Apr 2013

  Manager of 7 person development team responsible for developing web based version of core IRMS product; responsibilities included managing multiple concurrent development efforts, coordinating release schedule, generating functional and technical documentation, and mentoring developers.• Spearheaded effort to modernize code base and reduce future development efforts. Emphasized jQuery in custom web control library to consolidate custom code and object oriented design in base data object libraries to encapsulate business logic. • Reduced defects found by QA department by 75% through increased emphasis on unit testing and peer reviews of code.• Instituted formal functional design process to prevent discrepancies between client expectations and development efforts. Show less

• Lead .Net Developer

  • Jun 2012 - Nov 2012

  Lead developer for 6 person web applications team. Activities included generating technical design documents, troubleshooting client issues, and working with release manager to schedule and manage projects and resources. • Customized Telerik dropdown list control to allow multiple selections and improved performance through customized filtering. • Designed XML interfaces for 3rd party applications to retrieve and create IRMS case requests.



InterPark

• United States
• Real Estate
• 100 - 200 Employee

• Senior Web Developer

  • Apr 2007 - Jun 2012

  Functioned as systems analyst, programmer, DBA, and implementer within 9-person IT group; generally worked on multiple concurrent projects. • Developed time entry system used by Human Resources and location managers to record hours, bonuses, and vacation payouts for hourly employees. Developed web interface and reports using ASP.Net, Ajax, JavaScript, and Reporting Services. Designed and managed SQL Server database: data model, stored procedures, and Integration Services packages. Reduced errors by over 90% and user time commitment by 40%. Maintained application to ensure logic complied with changing company policies. • Developed Single Sign On application to simplify user access to internal web sites. Utilized HttpModule to encapsulate the login logic and simplify the deployment to all internal web sites. Validated user login information against Active Directory to eliminate the need for an additional password and to allow users logged into the corporate network to bypass the login screen. • Sole developer of a reservation and rewards system for airport garages that used mobile computers to validate bar codes at exit. Developed customer website utilizing ASP.Net and SSL and also developed mobile application using .Net Mobile Framework. Incorporated real time validation of bar codes, via local XML files, to reduce fraudulent activity by over 90%. • Mentored colleagues and provided technical guidance on .Net development, Object Oriented design, and SQL design and optimization. • Converted several ASP websites, Lotus Notes applications, and Microsoft Access applications to ASP.Net websites with SQL Server backend. Allowed for rapid development cycles and simplified the deployment process. Led user acceptance testing and successfully implemented applications into production environment with zero data loss. Show less



Vizioncore Inc.

• United States
• Software Development
• 1 - 100 Employee

• Senior Web Developer

  • Jan 2007 - Mar 2007

  Analyst on various projects enhancing the Company’s core software product. Activities included business object development, database design and optimization, development of setup wizards, and application testing. Analyst on various projects enhancing the Company’s core software product. Activities included business object development, database design and optimization, development of setup wizards, and application testing.



Crate and Barrel

• United States
• Retail
• 700 & Above Employee

• Lead Developer

  • Oct 2002 - Dec 2006

  Generally responsible for all aspects of the development process while working on multiple concurrent projects in support of the crateandbarrel.com website, the stores, and the corporate office . • Developed physical inventory tracking system used by over 150 stores and over 1000 employees that reduced man hours per store by 40%. Developed website, web services, and reports using ASP.Net, JavaScript, and Reporting Services. Designed, managed, and optimized SQL Server database to allow at least 2 million inserts in 6 hours. Developed custom scanner application and communication interface to allow employees to scan and submit product counts. • Designed and developed set of DLLs, used by multiple IT groups, to encapsulate frequently used logic and to reduce future development time. • Mentored colleagues and provided technical guidance on .Net development, Object Oriented design, and SQL design and optimization. Show less



Chicago Consulting Actuaries

• United States
• Financial Services

• Sr. Developer

  • Feb 2001 - May 2002

  Functioned as business analyst, database architect, and programmer on two person team responsible for new benefits enrollment website. Developed web application and reports using ASP and COM+ business objects. Researched federal and state regulations in order to properly handle open enrollment and life events. Designed, managed, and optimized Entity-Attribute-Value database model. Generated custom encryption routine to secure passwords and sensitive employee data. Designed export utility to provide clients with payroll deductions based on employee benefit elections. Show less



Art.com

• United States
• Artists and Writers
• 500 - 600 Employee

• Senior Developer

  • Apr 2000 - Feb 2001

  Functioned as systems analyst, programmer, database architect, and lead developer, supporting multiple eCommerce websites. • Redesigned shopping cart/ordering logic to reduce page load times by 85% and increased the number of distinct products a customer could order from 10 to 50. Increased reliability of moving customer orders to the invoicing systems by replacing MSMQ Service with a customized Windows NT Service. • Redesigned the framing studio to increase reuse of code, reduce future development time, and reduce page load time by 25%. • Sole developer on project to incorporate the 2000 Summer Olympics Picture of the Day purchasing into website. Worked with Kodak marketing department to re-brand shopping cart. Show less



Accenture

• Ireland
• Business Consulting and Services
• 700 & Above Employee

• Analyst

  • Jun 1998 - Apr 2000

  Functioned as business analyst, database architect, and developer within a team of 10 to maintain office hoteling system. Sole developer responsible for maintaining Windows NT Service and InstallShield setup utilities. Integrated SQL Server database with distinct phone systems used throughout the world via NT Service. Facilitated implementation in Italy, South Africa, and the U.S. Functioned as business analyst, database architect, and developer within a team of 10 to maintain office hoteling system. Sole developer responsible for maintaining Windows NT Service and InstallShield setup utilities. Integrated SQL Server database with distinct phone systems used throughout the world via NT Service. Facilitated implementation in Italy, South Africa, and the U.S.