SUMMARY:

• Web Design, HTML, VB.NET XSL, XML, SharePoint 2010, 2013 and 2015.
• Ektron CMS (Content Management System).
• Oracle 9i, 10g (SQL*plus), Oracle reports, Oracle Forms 6i, Crystal Reports.
• Microsoft SQL server 2000 - 2016. Azure Sql Database. Microsoft Access\VBA, DB2, DTS Packages.
• SSRS 2005 - 2016. SSIS 2005 - 2016 and SSAS 2008R2 - 2016.
• T-SQL, PL/SQL. SQL Developer Tool.
• TOAD, WinSQL, SQL Advantage and Informatica v7.1.2.
• Microsoft Office Products including MS Project. Visio. Microsoft Visual Source Safe 2005.
• Microsoft Visual Studio 2015.
• Team Foundation 2015.
• Microsoft Dynamics CRM 2011 & 2013 On-premise and Dynamics 365.
• Azure, PowerBI.
• SQL Server (PDW) Parallel Data Warehouse.
• JD Edwards
• VSTS git.

PROFESSIONAL EXPERIENCE:

Confidential, Winter Park, FL

Senior BI Developer

• Gathers and analyzes business requirements.
• Architect and design Data Warehouse infrastructure and solutions.
• Develop technical specifications and design documents.
• Develop, enhance, and integrate Data Warehouses/Data Marts and Business Intelligence Solutions.
• Test Data Warehouses/Data Marts to ensure data accuracy.
• Develops strategies for warehouse implementation, data acquisition and access, and data archiving and recovery.
• Created data models and defines the structure, attributes and nomenclature of data elements.
• Helped to successfully migrate our on-premise solution to Azure cloud.
• Creates and designs SSRS reports and dashboards
• Creates and designs Power-BI Executive dashboards.
• Creates and designs SSIS packages to pull data from multiple sources including but not limit to CRM, JDE, Flat file sources, API access points etc. into a central location.
• Leads the strategic design and maintenance of business intelligence applications.
• Identifies, researches, and resolves technical problems.
• Ensures that the use of business intelligence applications enhance business decision-making capabilities.
• Participates in daily scrum meetings, back log grooming and sprint planning.
• Develops or modifies procedures to solve complex database design problems, including performance, scalability, security and integration issues.
• Performance tune slow running queries, views, functions and stored procedures.
• Implemented temporal tables in our data warehouse.
• Created a database backup strategy for our mission critical systems.

Confidential, Eden Prairie, MN

Data Analytical Consultant

• Gathered and analyzed business requirements.
• Architected and designed Data Warehouse infrastructure and solutions.
• Developed technical specifications and designed documents.
• Developed, enhanced, and integrated Data Warehouses/Data Marts and Business Intelligence Solutions.
• Tested Data Warehouses/Data Marts.
• Deployed and maintained Data Warehouses/Data Marts in SQL Server and SQL Server PDW.
• Developing and implementing ETL solutions necessary to move data from various client, partner and internal data sources into the data warehouse.
• Helped implement Azure Proof of Concept capability by created a Data Warehouse using non-PHI dummy data in Azure. Using ETL solutions to test performance by loading 17 million records and dataset run capability.
• Writing stored procedures, functions, views to support SSIS and in-house applications.
• Worked in an Agile\Kanban Development environment.
• Processed and analyzed health care data using Confidential impact standard warehouse methodologies and software.
• Reviewed and analyzed client data via quality control processes for anomalies or other issues which could compromise product functionality.
• Communicated data issues and discoveries with clients during the implementation process via written documentation, conference calls and occasional on-site meetings.
• Acted as a data consultant to our impact suite clients during implementation.
• Anticipated customer needs and proactively develops solutions to meet them.

Confidential, Sarasota, FL

BI Developer

• Requirements gathering, analysis, design, development, implementations, testing and deployment for all management reports and dashboards that utilize SSRS, SSIS and SSAS.
• Ensured that reports are developed to meet quality goals and are completed within establish timelines and budgets.
• Worked as DBA to ensure that the necessary reporting fields, indexes, data types and structures are available within the data warehouse architecture, and make recommendations for additions.
• Listened to customer needs and make recommendations as to what reports should be used or could be developed to meet the needs of the customer.
• Developed customer satisfaction measurements that gauge the effectiveness of the business intelligence organization and the usefulness of any production reports and dashboards provided by the group.
• Designed, developed and published client & internal facing reports.
• Developed, test and supported SSRS, SSAS, SSIS packages and or jobs in CRM environment.
• Writing stored procedures, functions, views to support SSRS and SSIS.
• Performance tune SSRS, SSIS and SSAS.
• Developed and implemented ETL solutions necessary to move data from various client, partner and internal data sources into the data warehouse.
• Designed and developed multi-tenant solutions for common BI platform.
• Help implement Azure Proof of Concept capability by created a Data Warehouse using non-PHI dummy data in Azure. Using ETL solutions to test performance by loading 17 million records and dataset run capability.
• Worked in an Agile Development environment.
• Worked on migration projects, converted clients from our legacy system to Dynamics CRM solution.
• Created and maintain SQL DB purging tool for legacy system.

Confidential, FL

Senior Business Intelligence Developer

• Requirements gathering, analysis, design, development, implementations, testing and deployment for all management reports and dashboards that utilize SSRS, SSIS and SSAS.
• Ensured that reports are developed to meet Digital Risk quality goals and are completed within establish timelines and budgets.
• Worked with the DBA to ensure that the necessary reporting fields and structures are available within the data warehouse architecture and make recommendations for additions.
• Listened to customer needs and make recommendations as to what reports should be used or could be developed to meet the needs of the customer.
• Developed customer satisfaction measurements that gauge the effectiveness of the business intelligence organization and the usefulness of any production reports and dashboards provided by the group.
• Designed, developed and published client & internal facing reports.
• Developed, test and supports SSRS, SSAS, SSIS packages and or jobs.
• Writing stored procedures, functions, views to support SSRS and SSIS.
• Performance tune SSRS, SSIS and SSAS.
• Developed and implemented ETL solutions necessary to move data from various client, partner and internal data sources into the data warehouse.
• Designed and developed multi-tenant solutions for common BI platform.
• Worked in an Agile Development environment.

Confidential, Orlando, FL

Report Developer

• Created and maintained reports in SSRS 2005 and 2008.
• Created and maintained stored procedures, views in SQL Server and Oracle.
• Created and maintained SSIS 2005 and 2008 packages using various data sources.
• Written reports from Oracle and SQL Server Data Warehouse.
• Evaluated reporting needs and recommends solution to problems.
• Developed, test, supported, and modified reporting systems.
• Developed, test and supported SSIS packages and or jobs.
• Provided end user support for reporting applications.
• Worked in an Agile Development environment.
• Developed ad-hoc reports from a variety of data sources.
• Developed, tests and documents new reports and enhancements to existing reports.
• Assisted project teams in all phases of the SDLC.
• Documented all report programming and system changes.
• Conducted end user training in an individual and group setting.
• Worked with main clients and project and business leaders to identify analytical requirements.
• Provided report server software administration.
• Interview users and determine informational needs and sources of required data.
• Queried, reviewed, and prepares test data.
• Tested, debugged, and managed implementation of reporting systems.
• Supported reporting package applications and enhancements.
• Evaluated existing components or systems to determine integration requirements and to ensure final solutions meet organizational needs.
• Successfully converted Cerner and Data General Legacy databases to Sql Server.
• Created ETL packages for Cerner and Data General Databases.

Confidential, FL

SQL Server DBA

• Created and maintained databases in SQL Server 2005 and Microsoft Access.
• Created and maintained reports in Microsoft Access, Excel, SSRS 2005 and 2008.
• Point of contact for BI (Business Intelligence) Development.
• Written stored procedures, functions, triggers and DML statements daily.
• Created interactive, tabular, graphical and free-form reports from relational data sources using SSRS.
• Maintained and created SQL Server backups.
• Documented and developed requirements for databases, applications, and operation systems environment.
• Worked with main clients and project and business leaders to identify analytical requirements.
• Created and maintained SSIS packages.
• Data integrated (ETL) legacy systems to SQL Server data warehouse.
• Monitored the performance and created maintenance plans in SQL Server 2005.
• Monitored SQL Server jobs daily.
• Developed report solution design.
• Created sales, cost analysis, and ad hoc reports in both SSRS 2005 and 2008.
• Gathered report requirements from key personnel.
• Configured and unit tested reports in a test environment before deployment (SDLC).
• Reused components when possible and assisted management in buy/build decisions.
• Utilized TFS (Team Foundation Server) for all our SSRS and SSIS source control needs.