Senior Business Intelligence Manager Resume
Raleigh, NC
SUMMARY:
Senior - level business intelligence manager / business intelligence architect leveraging a career history of comprehensive data analysis, data governance, reporting, project management, systems integration and T-SQL development to allow a unique and broad perspective in using data to tell stories and introducing IT solutions to complicated problems. Strives to ensure that projects are completed quickly and with meticulous accuracy to ensure critical end-user satisfaction. Extensive experience integrating and administering a variety of business intelligence systems and reporting platforms.
PROFICIENCIES:
SQL Server | T-SQL | SSRS | SSIS | SSAS | PowerBI | Tableau | DOMO | Advanced MS Excel | MS PowerPoint | MS Visio
EXPERIENCE:
SENIOR BUSINESS INTELLIGENCE MANAGER
Confidential, Raleigh, NC
Responsibilities:
- Led a high-performance team of analysts/developers with a proven track record of measurable organizational improvements and successful data projects.
- Lead all aspects from architecture/design to go-live of a successful $1M+ corporate SDLC project to capture and provide vendor access to photos of damaged products leveraging a combination of BI platforms including Azure, SSIS, SSRS, PowerBI and IIS.
- Continuously develop and administer numerous mission critical SSIS/ETL integration processes that allow independent systems to operate cohesively.
- Established and drove corporate business intelligence strategy with key initiatives to monetize company data, improve corporate data integrity and ETL development for critical systems integrations.
- Designed and implemented a large data warehouse environment using ETL best practices and provided a proper platform for a variety of reporting and analytical tools.
FOUNDER / SENIOR SOLUTIONS ARCHITECT
Confidential, Raleigh, NC
Responsibilities:
- Founded a consulting company specializing in data analysis, ETLs, visualization.
- Primarily servicing healthcare analytics organizations.
- Transformed raw, complex patient/provider/claim csv datasets into structured SQL databases using secure and effective data modeling/transformation strategies.
- Extracted meaningful insights and built powerful visualizations/KPIs from raw datasets.
SENIOR BUSINESS DATA ANALYST
Confidential, San Diego, CA
Responsibilities:
- Drove a major data warehouse project that included consolidating several disparate data systems, migrating existing reports/visualizations and evaluating, administering and transitioning the organization to two new reporting platforms (SSRS / PowerBI).
- Solely administered all development, design, validation and security controls of the company’s reporting and analytics tools (PowerBI and DOMO) used daily by all product owners and executives in the organization.
- Led a major ETL data cleansing effort to update and validate millions of rows of transactional sales data by creating a series of SQL update scripts that identified and corrected fields with missing or incorrect product data resulting in improved data reporting reliability as well as defined a business process around product metadata.
- Drastically improved the accuracy and reliability of revenue forecasting by introducing a statistically-driven data model to the process -- this included developing SQL scripts and stored procedures that included linear regression functions to more accurately predict product line sales growth for future periods.
OPERATIONAL / FINANCIAL IT ANALYST
Confidential, Cleveland, OH
Responsibilities:
- Acted as an IT liaison interpreting business needs and providing analytical support for all levels of the organization through development of ad-hoc Oracle SQL queries, stored procedures, formal Crystal Reports and executive dashboards to support strategic initiatives for the finance and operations departments.
- Led a cross-functional group responsible for the evaluation, introduction and successful launch of a Microsoft SharePoint implementation to improve collaboration and project management among the company’s fifteen international subsidiaries.
- Developed SQL scripts for extracting large data sets used to conduct detailed analysis on manufacturing costing data to ensure that cost rolls were applied accurately.
INTERNATIONAL BUSINESS ANALYST
Confidential, Cleveland, OH
Responsibilities:
- Developed analytic cubes and pivot-style reports within ClickBase to allow multi-dimensional sales reporting and support Sales and Marketing initiatives.
- Worked directly with over a dozen international directors on numerous global budgeting/costing projects that improved the corporate measurability of worldwide subsidiaries, including gross margin, make/buy and labor costing analysis.
- Overhauled the consolidation process of worldwide subsidiary financial statements by introducing systems automation and VBA eliminating several hours of financial staff labor hours each month.