SUMMARY:

• Enthusiastic business intelligence (BI) professional, or “data geek,” with a passion for transforming organizations’ data into intuitive business insights that translate into process improvements, business insight, and competitive advantage
• Deep and broad understanding of data warehousing and BI architecture, as well as the techniques and strategies available to gather and leverage the organization’s data assets for best possible results at all organizational levels and across all functional areas
• Able to comprehend and convey how data flows through, and impacts, an organizations’ processes, procedures, and policies, with the inclusion of available partner data and leading/lagging economic indicators
• Life - long learner; areas of interest include technology (e.g., data visualizations, futurism, and AI), science, and economics

TECHNICAL EXPERIENCE:

• ASP.Net
• Business Objects 6.5
• Brio
• C#
• Crystal Reports
• Data modeling (relational and dimensional)
• DAX
• Executive Dashboard design
• HTML 5
• JSON
• JavaScript
• KPI Identification/Evaluation
• MDX
• MS Office Development
• MS SQL Server 2014
• MS SSAS 2014
• MS SSIS 2014
• MS SSRS 2014
• MVC
• Phocas 6.6/2016 (Cloud)
• PL/SQL
• Power BI
• PowerShell
• Python
• R Language
• Robo-FTP Scripting
• SharePoint
• SiSense
• SiteMinder
• Statistical Analysis
• Tableau
• Team Foundation Server
• Teamwork
• T-SQL
• VB.Net
• Visio
• Visual Studio
• VML
• Web services consumption
• XML

EXPERIENCE:

Confidential

Senior Business Systems Analyst/ Developer/Architect

Responsibilities:

• Collaborated with business teams and leaders to document reporting requirements and use cases
• Lead overall BI program; including technical and business requirements, architecture, and business logic
• Developed Kimball data warehouse star-schema utilizing the Microsoft BI Stack (SSMS, SSIS, SSRS, SSAS)
• Lead enterprise BI front-end tool evaluation and selection process
• Lead cloud-based Phocas 2016 implementation; including design, ETL development, database development, administration, user-training, creation of end-user training literature, and dashboard development
• Created system and project documentation using Visio, Excel, and Teamwork
• Configured Power BI and Tableau Server instances as part of evaluation/proof-of-concept (POC)
• Developed Power BI and Tableau dashboards and SSRS reports as component of POC and in order to encourage adoption of a robust BI solution within the organization
• Administered Oracle Hyperion Brio instances, including end-user support
• Developed stored procedures for data extracts, loads, cleansing, and ad-hoc reports

Confidential

Senior Business Systems Analyst/ Developer/Architect

Responsibilities:

• Designed, developed, deployed, optimized, migrated, and administered near-real-time business intelligence system utilizing the Microsoft SQL Server Business Intelligence Stack (i.e., SSMS, SSIS, SSRS, SSAS)
• Gathered business requirements and managed BI project throughout its lifecycle using MS Project and Team Foundation Server and utilized scrum project management framework
• Sourced, cleansed, and conformed disparate data sources to Kimball star schema structure
• Designed product and organizational hierarchies which simplified their structures, and were adopted throughout the enterprise
• Designed, developed, deployed, and administered SSRS reports to replace existing Business Objects and ASP reports; developed dozens of reports enabled by capabilities of new warehouse
• Developed stored procedures to support ETL, OLTP system interfaces, extracts, and reporting system
• Designed, developed, and optimized SSAS cubes to support the Sales, Operations, and Claims departments
• Developed and enforced design and naming conventions across system
• Devised method to launch SSRS subscriptions from SQL Server jobs
• Worked closely with DBAs and the Enterprise Architecture Team to migrate BI system from SQL Server 2005 to later versions residing on clusters and ultimately to SQL Server 2014 residing on the corporate private cloud
• Worked with business teams to benchmark, develop, and manage KPIs for finance, sales, and operations
• Designed, developed, optimized, and supported automated processes to support data extraction and OLTP system loads
• Worked with external organizations to coordinate receipt and delivery of automated data files and reports
• Designed and developed SQL Server indexes to optimize query performance of set based querying
• Trained end-users on the use of self-service BI tools, dashboards, and pivot reports
• Developed relational data model to support legal departments regulatory tracking system

Confidential

Business Systems Analyst

Responsibilities:

• Designed and developed multi-tier intranet BI applications supporting Finance, Human Resources, the Executive Management Team, and the Total Customer Experience & Quality Team using thin-client presentation layer tools atop star-schema data warehouses
• Developed formal business requirements, system designs, data-models, project plans, and guided the creation of technical documentation while managing several successful projects using project management tools including TeamPlayER and Microsoft Project
• Lead design and development of Finance Executive Portal (dashboard) using Brio presentation layer atop Oracle backend star-schema
• Developed interim enterprise balanced scorecard solution delivered directly to top HP Executive Team
• Lead creation of the Employee Stock Purchase Program worldwide compliance comparison tool during HP/ Confidential merger.
• Lead off-shore team of report developers by providing report specifications, technical advice, and guidance in support of Total Customer Experience & Quality Team using Business Objects atop Oracle backend star-schema data warehouse of my design

Confidential

Database & Systems Administrator/Report Developer

Responsibilities:

• Administered Primo Risk Manager 2.45, Altra GMS Confidential 5.1, and three Microsoft SQL Server 6.5 Databases
• Developed reports using Crystal Reports to run under Altra GMS 4.21 and GMS 5.1 Confidential
• Developed Sybase InfoMaker reports to run under Primo Risk Manager 2.4
• Designed and implemented backup, and emergency restoration, plans
• Setup and maintained staging environments for testing software updates and scripts
• Developed VB applications to enhance the usability of the main information systems
• Developed Access 97 applications, which aided in the administration of Altra GMS 5.1 Confidential