Mickey Shaffer Email & Phone Number

New York, Ny, Us

Atlanta, Ga, Us

Atlanta, Ga, Us

- Acted as Lead Technical Consultant on several projects for two local enterprise Atlanta retailers - Designed & implemented Enterprise ITSM Executive Reporting Platform- Supported new platform with data warehouse in Oracle, self-designed & built- Hosted all new actionable reporting thru internal Microstrategy cluster- Designed & implemented Financial modeling process for generating forecasts for major supply chain- Led team of 4 consultants to deliver modeling process build-out with agile scrum development- Implemented full Alteryx analytical application for model execution & management- Perform subject matter expert oversight for all Business Intelligence projects for consulting practice

Atlanta, Ga, Us

- Acted as Lead Technical Consultant on several projects at a local enterprise Atlanta retailer- Designed & implemented Enterprise HR Data warehouse for internal reporting & analytics - Built all data pipelines to keep the warehouse governed & up-to-date for privacy and governance- Architected & built many data aggregation processes for automating reporting outputs for leadership- Adhered with strict international & domestic regulations around moving, storing, & reporting on highly sensitive PII & SPI data (GDPR included)- Led full Agile Scrum development process with a total team of 8 members: St&-ups, Sprint Planning, Sprint Reviews & Demos, Retrospectives, Analysis of Team Performance- Worked with internal stakeholders to determine business requirements for KPI & exploratory reporting

Atlanta, Georgia, Us

Atlanta, Georgia, Us

- Acted as Lead BI Developer for the two BI agile scrum teams - Coordinated reporting implementation of ERP migration to new ERP and multi-3rd party software integration- Helped design Cloudera big data solutions in HDFS & Apache Kudu for reporting data sources- Re-created legacy PHP reporting in Tableau from legacy ERP - Deployed custom embedded Tableau reporting in new business ERP web application- Managed 5 business Tableau Servers - Development, QA, Test, Blue-Green Production (Azure)- Supported back office end-to-end and parallel testing efforts for new ERP release- Demoed reports to C-level executives and Sales leadership regularly - Formulated style guides, best-practices, and documentation for enterprise reporting suite

- Managed large scale multi-day monthly aggregation packages for business KPIs - Designed and implemented data sources for business Tableau Web Edit application - Served as Interim Team Leader during period of time (Jan 2018-Feb 2018), managed 1 BI Developer - Ran JIRA board for team strategy, support, and report enhancements - Oversaw and managed the business Tableau Server, servicing over 200 users

- Performed SQL Development for BI Tableau, SSRS, and Excel reports - Supported business reporting tools primarily for sales force and account management - Maintained and updated BI SSIS aggregation packages and ETL processes - Managed automated business reporting process for financial institution engagement data - Provided live business intelligence tool trainings for sales, account management, analytics, and I.T. - Acted as Product Manager for business data dictionary development, deployment, and support

- Performed personal and commercial website and database development and maintenance - Created web application clock-in system for Atlanta-based elder care group - Maintained direct contact with client via email/phone with personal follow-up appointments and progress updates

- Formulated and monitored web server with compatible server-side data storage database - Integrated school survey forms and data into a sortable, editable database - Utilized PHP processing with MySQL to store data on the server - Used PHP to extract MySQL database data into a workable Excel spreadsheet

Atlanta, Georgia , Us

Designed composite sandwich material impacter

Bs, Mechanical Engineering

Education record