Michael Simon Email & Phone Number

Jacksonville, FL, US

Jacksonville, FL, US

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.

Jacksonville, FL, US

• 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

Fleming Island, Florida, US

• 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.
• 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.
• Provided tier 2 support to customers for Microsoft SQL Server BI Stack complimentary software: BI Documenter, BIxPress, Task Factory, and DTSxChange

• 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.
• 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.
• 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