Leader of BI Cloud MigrationArchitect of Decision Engine App Architect of NoSQL app solutionsArchitect of Cloud Data CentersAPI Gateway, Lambda, RDS, Dynamodb, VPC, Subnets, Route Tables, VPN, Security Groups, EC2, S3.

• Automated complex pharmaceutical process involving clinical, billing, and accounting components • Transformed Analytics for C Level Executives by leading 5 direct reports in implementing new data structures and sliceable/interactive dashboard with Breakouts by Core Business Areas • Enterprise Project Manager: SharePoint Intranet, Implementation of Workday HRIS including all aspects of projects from planning to vendor management • Empowered Two Team Members to Overcome Resistance and Consolidate 150 Manual Reports into 20 Automated Self-service Style Reports. •SQL Server Business Intelligence Stack (SSMS, SSIS, SSAS, SSRS); MDX

• Sales Dashboard and Margin Loss Identification Projects• Create, Deploy, Performance Tune PerformancePoint 2013 Dashboards (with MDX) within SharePoint 2013: Use of Dashboard Designer to create and deploy: Data Sources, Charts, Filters, Excel Services, SSRS, Dashboard Pages.• SQL Server Analysis Services (SSAS) 2008R2 – create and deploy Calculated Measures, Add Attributes to Dimensions, Cube deployment, creation and deployment of a development sub-set of data for development environment.• SQL Server Integration Services (SSIS) 2008R2 – ETL, extract data from source systems, utilize business logic to transform, load to: Staging, Operational Data Store, Data Warehouse Relational Database. • SQL Server Reporting Services (SSRS) 2008R2– report development and deployment, actions on fields to call sub-report drill in and drill through, embedded TSQL and stored procedure, MDX. • SQL Server Management Services (SSMS) 2008R2– creation of tables, addition of fields, stored procedure creation and modification, functions, triggers, ad hoc queries• User integration enhancing – created Data Warehouse Quick Start-up Guide to assist new users with connecting to cube through Excel, examples of PivotTable and PivotChart creation, Matrix illustrating which fact tables are connected through which dimensions, field definitions;trouble-shooting issues (review MDX behind query).

• Manage the activities of the software support team including - guided software support team to increase output by 300% to meet sudden growth in monthly case load without adding additional staff. Accomplished this while improving customer experience and satisfaction as measured by customer surveys.• Trained in SSIS, SSAS, SSRS & TSQL• Team lead on software that extends ETL tasks in Microsoft SQL Server Integration Services (SSIS) including reproducing and troubleshooting customer issues in SSIS.• Co-Taught SQL Server Analysis Services• Collaborate with Sales Team to demonstrate software usage to clients and answer questions related the full Microsoft Business Intelligence Stack (SSAS, SSIS, SSRS, and SQL Server Management Studio) as it relates to company software.• Provided tier 2 support to customers for Microsoft SQL Server BI Stack complimentary software: BI Documenter, BIxPress, Task Factory, and DTSxChange• Led demos of software to customers

• Project leader for enterprise-wide primary database conversion project: facilitated and collected requirements from stakeholders; managed group dynamics among project team; negotiated needs and expectations of stakeholders; database solution alternatives research and recommendation; vendor pricing negotiation; data extraction and clean up; field mapping; integration, acceptance testing and staff training.• Analyzed business reporting process related to under performing revenue initiative at request of Vice President. Mapped and identified problems with reporting as related to data entry and data acquisition for reporting resulting in improved process and accurate reporting - true revenue results were equal to 3X that of original projections.• At direction of chairman of Board of Directors sub-committee devised and completed constituent segmentation into 7 key groups with targeted messaging and solicitation.• Translated business requirements into queries, reports, and data exports into Excel for further drill down• Consulted on complex process, solving IT implementation roadblock for VP, IT, and Communications staff for targeted annual communications project that resulted in a 25% reduction in costs.• Developed policies and procedures for maintaining data accuracy • Researched trends among 5 business lines over 5 years, drilling down one business line and extrapolating a target 15% increase by month and by quarter. Generated a 7 level strategy to achieve revenue goals. Implementation of strategy resulted in 13% increase in revenue for this business line over previous year.