Michael Deckman Email & Phone Number

Franklin Lakes, New Jersey, Us

Lead the architectural design and implementation of fabric-based systems, including compute, storage, and networking components.Provide guidance and expertise on best practices for deploying and managing fabric-based environments, including Azure Fabric, Azure Stack, and Windows Server technologies.Conduct performance tuning, capacity planning, and troubleshooting to optimize the performance and reliability of fabric-based systems.

Franklin Lakes, New Jersey, Us

Senior BI Developer | Advanced Analytics Spearheaded migration from QlikView to Power BI for user base of 2000Developed ETL Mapping from on premise systems to Azure Hive / Denodo via Databricks / Azure Data Factory-Architected Power BI Data Flow construction to feed 20 newly created analytical models-Designed optimized star schema models for operational and CX reporting-Created design patterns and best practices for a team 8 developers-Managed design with offshore developers to ensure performant design of 30+ migrated Qlik data models-Built analytics community of practice: implemented Power BI Office Hours - regularly have 20-40 attendeesStood up on premise Tableau Server and departmental SQL Server data mart with SSIS. Consolidated 10 enterprise and departmental systemsAuthored data integration from myriad sources via SSIS including Hive, SQL Server, Azure Data LakeDeveloped OLTP application to automate end to end NPS survey distribution for 20k contacts annually from Qualtrics to analysis in Power BI

San Diego, Ca, Us

Create analytics products that provide actionable insights into claims metrics across automotive and workers compensation lines of business.Develop statistical models to find deeper insights into business and industry trends. Develop data architecture and integration solutions to support operational and advanced analytics.

San Diego, Ca, Us

Member of the business intelligence group in corporate IT. Responsible for designing high level architecture and developing reporting schema to support Tableau Server and ad-hoc analysis. Additionally responsible for authoring custom data solutions to support emerging business needs. Collaborate on feature and functionality definition, conveying release visions and goals. Lead junior analysts and developers in solution design.• Designed and programmed a scalable SQL Server database platform that enabled the firm to bill customers internally versus a third party solution. (Won BU MVP Award) - Enabled revenue recognition three weeks earlier in each fiscal month closing. - Freed up $1.5 million in reserves monthly. - Reduced bill discrepancies by 5% ($200K) monthly.• Developed multi-tenant Tableau data mart and ETL routines to track financial metrics for Mitchell's Auto Causality book of business. - The solution integrates data from 60 discrete databases.• Created database program to support credit recapture for Mitchell's Decision Point product. - Program handles in excess of $80M annually in transactions.• Design database routines to project monthly revenue totals for the Finance Department.• Assist in database architecture by re-factoring outmoded and de-normalized database objects.• Authored custom SQL programs to manage SLAs for Mitchell’s Nurse Review Team.• Built audit program to randomly sample data entry quality for manually entered medical bills.

San Diego, Ca, Us

Wrote detailed descriptions of user needs, program functions, and steps required to develop and modify business.Conducted testing in accordance with test plans to ensure readiness criteria are met prior to software deployment.Provided advanced claims adjudication analysis and subject matter expertise related to the use of key business applications including multiple databases and software platforms.Worked collaboratively with internal and external business partners to develop and enhance applications, systems tools, and other systems solutions.Wrote and maintained detailed documentation of application user testing and validation activities including client specifications, expected outcomes, testing methodology and processes, test results, recommendations, version control, and configuration design.

San Diego, Ca, Us

Developed, quantified and evaluated the integration of internal and external information to support the ongoing development of SalesForce.com and Sales Operations BI platforms.• Developed SalesForce.com SAP, Oracle ERP data management strategies. (data acquisition, mining, analysis, data integrity management, metrics management and reporting.) ─ Developed functional specifications, data mapping and flow documentation for the migration of multiple ERP’s to single solution. Created ETL architecture for ERP, dB and SFDC integration.• Gathered requirements and design specifications for SAP Master Data Management implementation.• Authored specifications, oversaw implementation of interfaces to SalesForce.com from SAP ECC 6.0• Created data warehouse architecture, to support reporting through third party tools (BO, Cognos)

San Francisco, Ca, Us

Plan, design, implement, and maintain business intelligence solutions and enterprise database systems.Selected Achievements: • Reengineered corporate data warehouse and ETL process.• Created data warehouse architecture, as well as reporting platforms.○ Created and maintain Business Objects Universes.○ Authored and execute test scripts to ensure data integrity and consistency.

San Jose, California, Us

Developed requirements for database, applications, and operational system environment. Created reporting platform requirements and ETL solutions. Managed all aspects system implementation projects.Selected Achievements: • Worked with stakeholders to create, review and signoff on functional specs, review technical design specs, develop and deliver BI solutions for the Media Sales Groups.• Designed and implemented Business Objects Data Mart to measure efficacy of media sales.• Designed ETL programs and PL/SQL procedures to create data integration solutions.• Created MySQL (PHP) application to track six-sigma compliance.

Santa Clara, Ca, Us

Promoted to provide ERP, business intelligence, and application solutions in complex technical environment. Analyze business systems for global user base, spearheaded the development of integrated technologies. Directed multiple, large-scale projects. Gather and translate requirements into clearly defined IT project plans. Interact at all levels of the organization to facilitate architecture, system, and application improvements. Train employees. Manage budgets and timelines. Selected Achievements: • Developed and implemented SQL and Terminal Server platforms that significantly enhanced operations and led to a 40% labor cost reduction and “Employee of the Quarter” honors.• Received $500,000 additional budget to expand the platform, enabling high-speed data connectivity for corporate headquarters and the global development center in India.• Partnered in the design and implementation of a Product Installed Base database, a mission-critical application for Applied Materials Spares Inventory Planning Algorithm. • Created a data warehouse that is expected to grow to 10 terabytes within the next year; authored functional and technical specifications and procured the hardware infrastructure. ─ Designed ETL process utilizing DTS (SSIS), TSQL and PL/SQL procedures.

Santa Clara, Ca, Us

Earned promotion to coordinate and implement global enterprise and business intelligence initiatives from planning through launch. Managed and evaluated staff.Selected Achievements: • Expertly resolved operational issues and streamlined processes by overseeing Hyperion Data Mart implementation to monitor and control $50M in product inventory.• Personally tracked $20M in excess inventory and negotiated with eight distinct departments to secure funding for balance sheet write-offs.• Successfully implemented a customized n-tier global inventory management tool; designed functional specifications and PL/SQL and TSQL test scripts to sync data between the application and SAP.

Masters Of Science, Computer Information Systems - Bi Emphasis

Ba, Economics

Master Of Business Administration (Mba), Business Administration, Management And Operations