Sql Server Business Intelligence

Michael Webster

*************@*****.*** linkedin.com/in/mike-webster-7793a18 +1-469-***-****

Columbus, OH 43201

PROFESSIONAL SUMMARY

Results-driven Business Intelligence Engineer with deep experience designing and delivering end-to-end reporting solutions across crop science, healthcare, finance, and education. Skilled at turning complex data into insights using Spotfire, Tableau, Power BI, and Apache Superset. Experienced in integrating data from cloud and on-premise sources including Google BigQuery, SQL Server, SQL Server Integration Services, and custom APIs. Proficient in automating workflows, customizing dashboards with IronPython and JavaScript, and promoting adoption through training and demos. Know for bridging technical and business needs, enhancing data accessibility, and enabling strategic decision-making for global teams. SKILLS

• Data Analysis and Visualization: Spotfire, Tableau

• Programming and Scripting: SQL, Python, IronPython, JavaScript, TypeScript

• Data Integration: Python, SQL Server Integration Services (SSIS), Pipeline Pilot

• Soft Skills: Bridging technical and business needs effectively, Team Player, Strong Communicator WORK EXPERIENCE

Data Engineer – BigQuery, Spotfire, Tableau, Power BI, Python Bayer Crop Sciences US Tech Solutions Remote October 2022 to Current

• Develop business intelligence reports to help users gain understanding of model predictions and measure effectiveness of the experiments, production pipelines and economic effectiveness

• Customize Spotfire visualizations and interactivity with Python, IronPython, JavaScript and Spotfire APIs

• Integrate diverse data sources into reports from JSON data via web API calls, Pipeline Pilot protocols, SharePoint image and data files and Spotfire information links

• Created and maintained Pipeline Pilot data protocols for processing and integrating data into reports supporting seed deployment decisions

• Gather requirements and feedback from the user community

• Give demonstrations, training and progress updates to the global user, management and leadership community

• Conducted ad-hoc data analysis using Power BI and executed proof-of-concept evaluations for Apache Superset Contingency Data Analyst - SSIS, Tableau, SQL Server Sheppard Pratt GHR Technology Remote July 2022 to October 2022

• Accelerated development speed 200% by providing beginning-to-end training on SQL Server Integration Services package development

• Provided technical expertise in developing, modifying and trouble-shooting multi-system data integration processes for billing and operational efficiency reports during incremental system migration Family Care and Travel Sabbatical February 2019 to July 2022

• Traveled the United States, Europe and Peru fostering cultural adaptability and personal growth

• Provided dedicated care for elderly parents during a year of significant health challenges, supporting their transition to a retirement home

Michael Webster

*************@*****.*** linkedin.com/in/mike-webster-7793a18 +1-469-***-**** Columbus, OH 43201

Senior Business Analyst, Financial Engineer – Spotfire, SQL, R, IronPython Fannie Mae Washington, DC September 2010 to February 2019

• Developed business intelligence reports with Spotfire using information links, R and SQL in SQL Server, Oracle, Netezza and Sybase DMBSs

• Managed code packaging and deployments to test and production environments

• Achieved 100% deployment success rate for the team by establishing best development practices

• Customized user experience and visualizations with Spotfire APIs via IronPython and JavaScript

• Trained and mentored managers, peers and contractors on Spotfire development best practices

• Streamlined data flows by extracting, transforming and loading data with NZload and 1010Data

• Produced, maintained and automated reporting processes with Tableau, SAS and Korn

• Mentored junior analysts in creating an Excel data validation workbook, recognized in the marketplace for its usability and effectiveness

Report Analyst Consultant – SQL Server, SSIS, SSRS, VB Script Education Futures Group Dallas, Texas March 2010 to September 2010

• Developed and deployed a comprehensive data warehouse and analytical reporting solution using SQL Server, SQL Server Integration Services and SQL Server Reporting Services Application Developer – SQL Server, T-SQL, Windows Server, IIS, C#, ASP.Net Chase Home Loans Fort Worth, Texas May 2005 to December 2008

• Conducted audits and user access reviews for SOX/GLBA-regulated applications

• Identified root cause and resolved phantom transactions in SQL Server-based processes, mitigating financial and regulatory compliance risk

• Completed due diligence requirements for the sale of WaMu business unit systems to Chase

• Modified and maintained performance management system to improve functionality

• Subject matter expert for disaster recovery assessments and led the re-writing/re-deploying of WaMu mortgage systems onto Chase’s platforms for security, wire, GL, and DDA systems

• Led UAT regression testing and coordinated enhancement rollouts

• Wrote global help desk procedures for application support and security management

• Gathered and wrote requirements for financial quality control reports

• Trained global support technicians on application support and security administration

• Additional Technologies and Applications: Promerit, Citrix, Crystal Reports, Microsoft Excel, VBA, Access, Visio, ODBC, and DOS batch files, IIS, Mercury Test Director, PL/SQL, Oracle Application Express EDUCATION

Bachelor of Science - Interdisciplinary Mathematics and Statistics Purdue University

• Course work in Linear Algebra, Numerical Methods, Partial Differential Equations and Statistics Certificate - Tackling the Challenges of Big Data MIT

Contact this candidate