Andy Wilson Email & Phone Number

Houston, Tx, Us

Currently leading software development and quality assurance for the following companies:Froala (Froala Editor)Sencha Ext JS (ExtJS Framework)FusionCharts (FusionCharts and FusionTime)apilayer (70+ APIs)Sembi (Xray, Xporter, XEA)Hexawise/DesignWiseUltraEdit (UltraEdit Studio, UltraCompare)Whole Tomato (Visual Assist)FilestackConducting technical due diligence on M&A activity and leading post-acquisition integration activities.

Peachtree Corners, Ga, Us

Led innovation of customer-facing analytics by incorporating customer needs while proactively integrating future CMS and insurance regulations, financial trends and technology evolutions. Served over 5,000 named users with average of 25-50 simultaneous users on Analytics Platform.• Delivered clinical analysis insights to evaluate clinical process and clinician performance. • Provided insights into infection management; enabling agencies to recognize trends and develop infection prevention proactive processes. • Maintained constant evolution of analytics roadmap through consultation with key customers.• Assured efficient, current and scalable platforms by researching industry trends/new technologies.• Collaborated with Marketing Team regarding prospecting (email marketing blasts, brochures, trade show targeting, market-based product gap identification).• Developed KPI formulas for patient outcome monitoring, outcome prediction and risk management along with dashboard creation, updating and deployment process.• Integrated data from a variety of sources (OASIS, HIS, PDGM).• Designed the core clinical data model (Kimball and snowflake designs).

New York, Ny, Us

As the data evangelist, I guided the development of the business intelligence platform (BI Platform) architecture on AWS using Hadoop and Elasticsearch. The analytics solutions explore medical process KPIs to discover trends pointing to needed improvements.• Innovative thought leader for the development of the new analytics platform architecture.• Managed the migration from Business Objects to the new AWS platform.• Developed the analytics budget for 2017-2018.• Designed data modeling solutions using standard Kimball dimensional methodologies.• Agile Project Management: Developed the project plan and managed a combination of outside consultants and in-house team members to design the BI Platform.• Technical Management:o Recruited outside consultants to deliver best-of-breed tools for the BI Platform design.o Mentored the SQL OLAP development team and assisted in the data warehouse modeling.o Mentored the development team in the use of the SQL Server OLAP tools: SQL Server Analysis Services (SSAS); Integration services (SSIS); Excel/Power BI.

From June 2005 through October of 2014, I worked as an independent consultant on a variety of projects as a developer and project manager. Consulting engagements included projects with • Health Management Associates• Optum360• CDC• Liaison Technologies• Georgia Hospital Association• The Home Depot • Advance Auto Parts

Naples, Florida, Us

As a contract consultant, I managed the end-to-end development of the Enterprise Data Warehouse. • • • Migration of applications to Sungard Cloud (involved over 25 applications and 7 project managers).• Implementation of the data warehouse including consolidation and archiving of data for all 25 applications. The BI platform is Business Objects and the database is Teradata. • Developed and managed the $2.5M budget for permanent and contract consultants and software.• Established the committee to drive data governance and archive rules.• Agile Project Management:o Managed a team of 8-10 business analysts, data analysts, data modelers and outside and offshore consultants (four week sprints).• Technical Management/Development:o Designed initial data model and ETL solution in early stages as development team was assembled.• Reporting and Analytics Review:o Recommended short and long term solutions for reporting and dashboards including migration off SAP Business Objects.Budget management $1M budget for permanent, contract and vendor consultants.$1.5M budget for software.

Alpharetta, Ga, Us

As a Contract Consultant, I designed the extraction of data from multiple ShaprePoint data sources into a single SQL Server data base. Pentaho Data Integration is the tool for source data extraction. The data store is a star schema database used as the base for a SQL Server Data Analysis Cube.

Global, Us

As a contract consultant, I managed the development of a Liferay web portal and claims processing application for the surviving victims of the World Trade Center disaster. The project is for NIOSH at the CDC and the architecture conforms to FEA and CDC standards.The portal incorporates:• Document management• Automated document workflow• Microstrategy ad hoc reporting (via remote portlets)• LDAP secure SSO• Secure SSL processing using Symantec Managed PKI and HHS PIV cardsPortal customization includes• Java portlets managing a central database of program enrollees • Medical condition certification and trackingEDI and claims processing development• Pre-processing of EDI transactions using SSIS packages/TSQL Stored Procedures

Atlanta, Georgia, Us

Led the redesign of the online research and information services for the member hospitals.• SQL Server Data Warehouse• SSAS• SSIS for transforming UB04 data to the data warehouse• SSAS Analytic Reporting Cube

Developed a Centralized Billing System for consolidating invoice processing for National Accounts for Uni-Select USA. Uni-Select supplies auto parts for large chain retail and repair shops. Invoices from individual franchise sites are consolidated into a single invoice, processed electronically via XML and EDI.Architecture is .Net with XML Web Services for SQL Server 2008.

Dallas, Tx, Us

Manage the upgrades or initial implementation of retail customers onto the AT&T CSI (Common Service Interface). Customers include Radio Shack and Ericsson.

Using Hyperion, SQL Server SSIS and Excel, researched new recommendations to stabilize the forecasting and scheduling applications.Data analysis and mining using SQL Server, MS Access and Hyperion against forecasting, scheduling and PeopleSoft.Outlined new application designs and data flows using Visio.Assisted technical team in translating business specifications into Java code.Resident Hyperion System 9 Interactive Reporting Expert• Trained the engineering team on all aspect of Hyperion query and report building.• Developed complex, multi-table queries with many joins.• Developed complex reports using multiple queries and including graphs.• Developed simple dashboards as a basis for future development and reports.

New York, Ny, Us

Raleigh, Nc, Us

Developed a Labor Standards Maintenance application using a .Net Architecture with XML Web Services, Ajax and Sql Server 2005.

Transformed mainframe based Revenue Cycle Management application to .NetAjax framework.

.Net Architect/Business Analyst in development of first generation web-based employee self service HR portal.

Nashville, Tn, Us