SUMMARY:

• Business Intelligence, BI Reporting, Data Validation
• Motivated, results - focused professional with over 17 years of experience in the business intelligence arena.
• Industry experience includes working in the healthcare and telecommunications domains.
• Analytic oriented in both the business and data analysis for the enterprise.
• Microsoft Certified Professional (MCP) in Data warehousing and Data Management and Analytics; reviewing for MCSE for Power BI and Power Pivot.
• Hands on experience with all major reporting tools; experience as Business Analyst on multiple projects.

CORE COMPETENCIES:

• Tableau, Power BI (DAX), Excel (Macros and Pivot Tables) & Power Pivot, SAP Business Objects (Crystal Reports) and Cognos.
• Dashboarding
• Report Requirements Gathering
• Data Mapping
• Data Validation
• Unified Data Modeling
• Kimball Methodology (Denormalized Model)
• Lead “Deep Dives”
• Document analysis and revising
• Individual and group interviews
• Process Mapping
• Reversed engineering
• SQL Server Integration Services (ETL)
• SQL Server Upgrades, AWS and Azure
• SQL Server, SQL Server Integration Service, SQL Server Reporting Services, SQL Server Analysis Server
• SQL Server, Oracle, and Informatica Data Tools

PROFESSIONAL HIGHLIGHTS:

Confidential

Data Analyst

Responsibilities:

• Create data dictionary from Informatica document database objects being used currently and identify those tables outdated and should not be migrated
• Using Tableau Server, identify reports being utilized by which business groups and individuals and the frequency (demand) for which reports.
• Determine the reports that should be used with AWS
• Determine relevant fields in Informatica and Tableau and map.

Confidential

Report Migration and Development

Responsibilities:

• Migrating reporting from SQL Server Reporting Services (SSIS) to Tableau
• The development of new Tableau Reporting for Epidemiology Department based on current end user needs
• Extensive development of data visualizations
• Development of data extracts using TSQL and Stored procedures

Confidential

Business Analyst

Responsibilities:

• Worked closely with business units to gain an in-depth understanding of business strategy, processes, services, roadmap, and context in which the business operates
• Worked with BI to create data governance for Behavioral Health.
• Develop business case for new BI solutions Business Requirements and Analysis
• Provided analytic support for performance measures in business areas critical to Confidential Behavioral Line of Business and Providers.
• Extensive hands on creating T- SQL and PLSQL queries to create extracts as data sources to be used for analytics and purposes.
• Migrated Business Objects Universe to SQL Server for use in more recent tools.
• Extensive use of Reporting and Analytic tools (Tableau, PowerBI and Business Objects)
• Report Visualizations included:
• Heat Maps, Deviation Charts, Calculated Fields, Data Blending and Dashboard Interactivity.
• Created data models for Power BI based on a Operational Data Store (ODS) that created a denormalized schema for Fact and Dimension tables for drill downs.
• Used the principles of ETL to create automation for extract for Tableau and Power BI.
• Interfaces with high level internal and external contacts and providers.
• Identify, collect and research specific requirements, gathers workflow data and basic system and reporting specifications for projects.
• Develop a high level of reliable and credible information with all who use and rely on the reporting produced by the position as well as preparing reports for the appropriate level of management.
• Produce monthly analytical reports requested by management.
• Define business requirements and present analyses/reports in clear and useful format to other departments.
• Exercise initiative in exploring and discovering opportunities to improve corporate or program performance through data analysis.
• Complete business cases in support of projects; participate in and/or facilitate business modeling.
• Serve as critical liaison between business, Quality Assurance and technical, program and support teams and created UAT scripts.

Confidential

Software Developer

Responsibilities:

• Migrated multi source data into LMS
• The use of the .Net Framework (Web Applications with VB.Net) with SQL Server Backend.
• Microsoft Access Integration with Microsoft Excel (VBA)
• Dashboards created with Tableau.

Confidential, Denver, CO

Enterprise Analyst

Responsibilities:

• Interfaces with high level internal and external contacts and providers.
• Identify, collect and research specific requirements, gathers workflow data and basic system and reporting specifications for projects.
• Develop a high level of reliable and credible information with all who use and rely on the reporting produced by the position as well as preparing reports for the appropriate level of management.
• Produce monthly analytical reports requested by management.
• Define business requirements and present analyses/reports in clear and useful format to other departments.
• Data integration of CRMs (PeopleSoft, Seibel, Salesforce.com) and ERP (Oracle V12), SharePoint
• Worked with outside vendors (People Soft, Salesforce)
• Create PL/SQL scripts and Microsoft Access (Query and VBA) and Excel as testing tool for data evaluation.
• Documented user reporting requirements- for Crystal Report migration to OBIEE.
• Create Scripts for UAT.
• Work with various stake holders across the organization to coordinate efforts and Identify data requirements.
• Define KPI’s
• Utilized toad with Oracle for querying.

Confidential, Denver, CO

Business Intelligence Developer

Responsibilities:

• Created data warehouse from data store using the Kimball Method.
• Coordinated with stakeholders and end users to create BI value
• Created Data Dictionary using System Stored Procedures from SQL Server 2008 R2 to create comprehensive METADATA to establish possible relationships in data tables to create data mart from ODS
• Created SSIS packages to migrate secured data from client SFTP site with a complete ETL processing for data store
• Used multifile connection managers to connect to multiple files on SFTP site to load flat files for ATT.
• Used UPSERT to update and insert unique field data selected tables for to add data.
• Used scripting (SSIS 2008) for SFTP files using WinSCP
• Provide advanced Microsoft Excel reports for project stakeholders (Data Analysis).
• Used Sharepoint to collaborate on reporting and validation

Confidential, Tempe, AZ

Business Intelligence Developer

Responsibilities:

• Evaluated current SSAS Data Cubes against best practices for cube design.
• Review all MDX, hierarchies, and attributes and made revisions if needed.
• Used SQL Server 2008 Profiler to evaluate MDX.
• Documented best practices for proper modeling and cube performance

Confidential, Denver, CO

Business Intelligence Analyst

Responsibilities:

• Automated data validation.
• Migrated data from a shared SQL Server Db dedicated to a new ODS. SQL Server 2008)
• Created comprehensive data dictionary using system stored procedures to find potential relationships between dissimilar tables for the business.
• Business Collaboration and Drive BI Value for Business Partners
• Maintained reporting on SharePoint.

Confidential, Broomfield, Colorado

Report Developer

Responsibilities:

• Created daily extract of switching information into SQL Server (10 million rows)
• Used multifile connection manager to load files from SFTP site.

Confidential, Denver, Colorado

Business Intelligence Developer

Responsibilities:

• Redesigned existing SSIS packages to automate data migration from file server.
• Used SharePoint, Tableau and Crystal Reports for reporting.

Confidential, Greenwood Village, Colorado

Business Analyst

Responsibilities:

• Responsible for migrating data and ETL from enterprise systems (DRUM, CSG)
• Reversed engineer existing system to highlight the task and data flows.
• Published reports to SharePoint for each KMA.
• Modified SSIS package to improve reliability and functionality for data migration.

Confidential

Business Intelligence Analyst

Responsibilities:

• Responsible for migrating data from existing database/application to a fully normalized schema in a SQL
• Modified SPROCS for existing reports from prior system.
• Assisted in determining KPIs.
• Recreated reports on the new SQL Server Data source

Confidential, Lone Tree, CO

Integration Analyst Data Modeling

Responsibilities:

• Created TriMaps from source system to destination via Ergate.
• Utilized Tableau and Crystal Reports for reporting.

Confidential

Web Content Provider

Responsibilities:

• Content included information on all national and state parks
• “Places along the way” recommended by other readers.
• Videos and pictures
• Use of Google tools (Site Search, Google Tools)
• Monetization: AdSense and affiliates

Confidential, Denver, CO

Business Intelligence Developer

Responsibilities:

• Created presentation reporting layers for data cubes using Microsoft SQL Server 2008 R2 Report Builder and ProClarity 6.3
• Business Collaboration and Drive BI Value for Business
• Worked with Toad in conjunction with Crystal Reports for duration metrics on claim processing.
• Created a process map for schedule operations.

Confidential, Lone Tree, CO

Data Analyst - Technical lead

Responsibilities:

• Team lead for data migration process for over 60 hospitals (MBO’s and JOA’s) nationwide.
• Used MS Access and VBA for data validation.
• Created systematic approach for data validation from discrepant data files. (Created MS Access to create a automated validation tool)
• Used SharePoint to maintain all project documents.
• Worked with Toad in conjunction with Oracle in validation process- Validation reports created in Crystal reports.

Confidential, Denver, CO

Business I Analyst and BI Analyst

Responsibilities:

• Data Modeling: Designed extensive ETL method to pull data from Micros and Open Table applications SQL Server 2005 Staging area. (Logical and Physical DM)
• Used SQL Server Integration Services to extract, load and transform data to centralized database.
• Through end user feedback, designed and implemented a new POS system.

Confidential, Denver, Colorado

SQL Developer

Responsibilities:

• Designed and coded complete (T-SQL) SPROC to extract and load data from DB2 relational database to SQL Server 2005 Staging area.

Confidential, Denver, CO

Data Migration Specialist and DW Architect

Responsibilities:

• Developed reports with Crystal Reports
• Collaborated with Outpatient Pharmacy area to added value to Business Intelligence.
• Created Proof of Concept using SSAS (Outpatient Data- Star Schema with 5 dimensions and Fact
• Table 5,000,000 + rows.
• Utilized Integration services (2008) to consolidate data from SQL Server 2000 database.
• Collaborated with various PMs using SharePoint.