PROFESSIONAL SUMMARY:

• A total of 22+ years of experience in Business Intelligence in the banking, financial services, healthcare and Time - Share and Gaming Industries
• I have proven experience to architect, design and develop feasible, cost-effective, scalable and secure Business Intelligence applications, scorecards, dashboards, KPI’s, etc. using a wide variety of protocols, technologies and best practices.
• I possess extensive knowledge of relational databases, web technologies and Microsoft certifications.
• My excellent verbal, written and organizational skills enable me to communicate effectively and present prototypes to stake holders and development teams.
• I am self-motivated to manage solution delivery in a fast-paced team environment.
• I am able to quickly spot obstacles or risks to product development; and provide solutions and constructive direction using the diverse skills I possess.

SKILLS:

• SQL Server 2012/2014/2016 Data Modeling C# Dynamics CRM
• Azure SQL SQL Agent Jobs ASP.Net MVC SCRIBE
• SSIS, Azure Logic Apps Azure Data Factory v2 SOA, Web Services InRule
• SSAS Tabular, MDX, DAX Resource Governor WCF, REST, WebAPI Great Plains
• T-SQL, Stored Procedures SQL CLR RedGate Crystal Reports
• PowerBI CDC, Triggers TFS, SVN, Perforce, GIT SQL Master Data Service

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Sr. Cloud Business Intelligence Architect Consultant

Responsibilities:

• Architect, Design and Develop ETL and Datawarehouse solutions using Azure Data Factor ADF2, Azure Git Repository, Visual Studio 2017 Database Projects.
• Utilize SSAS Tabular to transform source data and requirements from the client into a deliverable and deployable solution via Database modeling, relationships, hierarchies, etc.
• Creating quick prototype models of deliverable Dashboards, KPI’s, etc., using PowerBI.
• Azure SQL database model created to establish relationships and stage imported data from Salesforce and custom sources and to facilitate parameterized full or incremental data loads.
• Dashboards created to indicate Sales Performance, Promotions History and Performance, Client Demographics, Performance of Regional Centers among others. Identify Azure SQL Performance bottlenecks and perform server tier upgrades and downgrades as required.

Confidential, Orlando, FL

Sr. Business Intelligence Engineer Consultant

Responsibilities:

• Architect, Design and Develop ETL solutions for the Central Development Analysis Services Team at Confidential in Orlando to collaborate with the Quality Assurance (QA) team members focusing on our portfolio of sports titles.
• Develop a highly extensible framework in SSIS to scale horizontally and vertically in order to reap data in the billions from globally positioned servers which would be fed into the cube and analytics environment.
• My proposed ETL, Data Warehouse solution was successfully architected, designed, developed and deployed to Production.
• Solution delivered performs in a highly scalable environment reducing ETL execution times to conform to < 15 hours
• Focus on enterprise analysis, identifying opportunities in business process, tools, and data.
• Extract data from multiple sources, SQL Server, PostGreSQL, MySQL, ORACLE, etc.
• Utilize Visual Studio and C# to develop an ETL toolset (Schlep) to enable internal engineers to develop high capability, low cost, rapidly developed, highly configurable BI solutions and provide an alternate path to SSIS
• Develop and deploy to an environment consisting of 120 instances of SQL Server (2012+) (3300 databases, 24 TB), including 3 SSAS instances, 6 SSRS/SSIS instances, located in 19 sites throughout the world from Vancouver to South Korea.
• Collaborate with teams in Romania and Vancouver within a SPRINT cycle to meet deliverables

Confidential, Kissimmee, FL

Enterprise Data Architect Consultant

Responsibilities:

• Led the team of database developers to architect, design and develop customizations to the TimeShareWare database using Agile practices and a 2-week SPRINT cycle
• Represented the database team and reported progress to the Sr. Director via Scrum-of-Scrums
• Created ETL SSIS packages to migrate data from multiple source databases into the customized database. Utilized SQL Native CDC to capture data to sync back
• Utilized VS2012 SQL Server Database Projects for database upgrades
• Deployed to DEV, QA and UAT environments using customizable profiles
• Wrote SQL CLR C# routines for specialized routines
• Incorporated proprietary business logic into T-SQL stored procedures, view and SSIS Packages
• Created SQL Agent Jobs to automate package execution and data migration
• Validated schema and data using the RedGate SQL Developer Bundle
• Created RESTful Web Services to read from the CDC Audits and sync back to the legacy database

Confidential, Lake Mary, FL

Software Architect

Responsibilities:

• Design, develop and manage large relational databases and the data warehouse.
• Collaborate with DBA’s, Purchasing, Accounting, Claims & Billing and Medical Economics departments to facilitate the building of the data warehouse.
• Develop SSIS ETL packages to build Data Marts to act as the source for further analysis & BI
• Created Visio product architecture diagrams to present to stake holders, management, developers, QA and operations.
• Design & prototype innovative solutions using the Microsoft stack of products, ASP.Net, MVC, C#, SQL Server, WebAPI, etc. for the Healthcare industry.
• Co-develop with vendors across multiple departments such as IT, Accounting, Operations, etc.
• Build and mentor a team of developers that can deliver sustainable product cycles
• Created a customizable secure web based BI Dashboard portal for all the major payers such as AETNA, CIGNA, Humana, WellPoint, Anthem, BCBS TX, etc.
• Utilized SOA patterns to obtain and present BI cubes
• Provided a selection of business metrics, KPI’s, charts and graphs to be included within the dashboard.
• Imported, analyzed and processed 60+ million records of paid claims data from Humana every month.
• Optimized SQL processes and windows services by 70% to improve user experience and data integration from CRM to Great Plains at record speeds.
• Developed web services to integrate with ZirMed, the medial claims clearing house
• Led the ICD10 conversion team to migrate systems from ICD9 to ICD10

Confidential, Muncie, IN

Senior Software Engineer/Business Intelligence Architect

Responsibilities:

• Advised members of the Enterprise Architecture team regarding efficient and cost-effective options
• Acted as the technology expert for data processing and Business Intelligence
• Worked with various in-house and outsourced development teams
• Provided hands-on expertise to the development team
• Maintained applications and provided support during business hours and off hours to meet service level commitments.
• Coordinated escalation requests of unresolved trouble tickets to higher management.
• Delivered 4 customized Business Intelligence cubes using SSAS
• 6 million+ accounts were profiled, 13 million payments imported, $113 billion dollars of debt was analyzed
• Created a multi-threaded ETL solution using SSIS to import and process data
• Designed the schema and structure for the data warehouse and cubes
• Created dashboards, scorecards, KPI’s, etc to present the cube data using ZAP BI

Confidential, Maitland, FL

Software Architect

Responsibilities:

• To architect, design and develop customized desktop and web UI applications, services, reports and Business Intelligence offering for the banking and financial services industry using Microsoft Tools and Technologies such as C#, SSIS, SSAS, Classic ASP, Silverlight, etc.