SUMMARY:

• Skillful and dynamic business intelligence professional with demonstrated capacity to deliver BIDW solutions that enable organizations to achieve and maintain a strong competitive advantage.
• Proven record of improving and enhancing BIDW capabilities by understanding business requirements, articulating a clear vision, evaluating risks, and defining processes, leveraging proficiency in numerous BI tools and advanced visualization applications to design and implement innovative BIDW solutions.
• Adept at cultivating strong relationships with key stakeholders, including executive leaders, peers, direct reports, and external clients and partners, to promote collaborative program management and productive work processes.

PROFESSIONAL EXPERIENCE:

Confidential, Clearwater, FL

SQL Server Developer

Responsibilities:

• Production support for Florida State Reporting database application. Implemented fixes and enhancements per customer requests. Automated SSIS processes to enable customer self service.
• Turned around and managed contentious client relationship.
• Contract was renewed. Developed second generation FSR application from scratch.
• SQL Server, Advanced T - SQL, SSIS, XML SPY, Red Gate tools

Confidential, St. Pete, FL

SQL Server Developer/DBA

Responsibilities:

• Built DWH and ETL to load data from cloud based ASP. SOAP. xquery, TSQL, SQL Server 2016, XML Spy
• Built DevOps CI/CD POC process and environment with Redgate and APEX tools, GIT, Jenkins, Octopus, BitBucket and Bamboo
• Built SSIS packages and SQL Agent jobs to automate business processes and data acquisition
• Introduced SSRS to the company

Confidential, Walnut Creek, CA

Business Intelligence Director

Responsibilities:

• Directed the implementation of an enterprise DW with aim of centralizing data from three separate policy processing systems, including developing ETL in SSIS
• Developed numerous SSIS packages and managed data mapping initiative to extract data from legacy systems, including drafting complex T-SQL queries, scripts, SPs, etc.
• Debugged/redesigned SSRS reports and infrastructure

Confidential, San Francisco, CA

Program Management Consultant

Responsibilities:

• Created PM processes and tools to establish a web analytics framework across Wholesale Internet channel application portfolio, resulting in significant planning and risk management improvements for the program
• Managed vendor selection process for new Project Portfolio Management (PPM) tool

Business Intelligence Consultant

Confidential

Responsibilities:

• Designed and implemented multiple upgrades and tools, including:
• A solution for the Banking Supervision group based on Excel services/SharePoint/.NET to replace an outdated Excel-based capital-at-risk modeling tool
• SSRS reports and database for a Federal Reserve system-wide internal network monitoring application
• A risk monitoring dashboard and risk database in SSRS leveraging SQL Server, T-SQL, and SSIS

Risk Management Consultant

Confidential

Responsibilities:

• Augmented IT audit activities of risk weighted assets regulatory submissions in response to Federal Reserve audit findings.
• Examined underlying databases and SQL scripts/ETL to document regulatory reporting controls

Business Intelligence Consultant

Confidential

Responsibilities:

• Drove business-critical technology and process improvements, including, but not limited to, rewriting ETL processes in SSIS, redesigning SQL Server reporting databases, and developing SSRS reports

Confidential, San Francisco, CA

Senior Manager, Business Intelligence

Responsibilities:

• Reconfigured the BI program to improve insights and program productivity.
• Directed all activities of the BI organization, including managing over 30 BI professionals and offshore developers
• Architected the restructuring of the entire BI stack including DW, ETL, operational reporting, report portal, and executive dashboard layers
• Designed a reporting strategy and program plan to migrate five proprietary reporting applications onto a unified SSRS platform, achieved by programatically generating SSRS RDL for 400+ reports and implementing a report portal POC

Confidential, San Francisco

Vice President

Responsibilities:

• Conceived and constructed the BI function for the Confidential Advisors call center sales channel from the ground up by developing a focused strategy to meet program structure and delivery objectives
• Developed a sales and marketing DW from scratch, integrating 18 upstream systems using SSIS for total visibility of all call center sales operations and customers for three lines of business
• Designed and executed a customer segmentation A/B experiment using DW data which examined the effects of a Customer Profiling Model script in the call center, resulting in script deployment to all 800 representatives to improve customer service interactions, fundamentally changing how WFA interacted with customers through the call center
• Implemented all layers of the Microsoft BI stack, including SSIS, SSAS, SSRS, PowerPivot cubes, and a SharePoint portal to manage report distribution

BI Application Manager

Confidential

Responsibilities:

• Led the BI application development team to support the rebuild of a cross-sell BI reporting application and database, employing Scrum processes to effectively manage development projects, team, and work queue
• Built a cross-sell valuation model to quantify program value, resulting in the justification of subsequent program funding for projects including the “Gold Rush to Cross Sell” incentive compensation program