Candidates About

 

Michael Vega

 

Professional Summary:

 

·                            A goal-oriented professional with a solid background of Business Intelligence software development, Data Analysis, Data Architecture and Data Scientist skillsets. Highly organized with the ability to manage multiple projects and to meet deadlines. A strong work ethic combined with a commitment to excellence in all projects undertaken. A team player, working effectively with peers and senior management in accomplishing objectives. Exemplary communication and presentation skills.

·                            Extensive database, BI and application background, currently assisting customers to maximize on the investments in technology to solve real world business and integration problems. I have worked in various roles and projects involving development, migration, deployment, networking, architecture, testing, packaging, R&D for both service and product based companies.

·                            Extensive Data Scientist analysis experience utilizing the latest Big Data tools such as Qlikview, SQL SERVER SSAS, Multi-Dimensional Cube Analytics and Python

·                            Ability to Lead and Supervise Teams of Developers

 

Areas of strength:

Over 15 years experience in financial accounting / general ledger / p and l / balance sheet

Over 15 years experience designing / developing executive dashboards

Over 15 years experience using crystal reports database reporting software (all versions)

Over 15 years experience using ms SQL server enterprise software (2000 and 2005)

Over 15 years experience in business intelligence consulting

Over 15 years experience in systems business analysis

Over 15 years experience using Microsoft Access / Excel VBA / vb.net

Over 10 years experience as information architect

Over 10 years experience using SAP/Business Objects desktop intelligence

Over 10 years experience data modeling (conceptual, logic build, physical creation)

Over 10 years experience using oracle databases

Over 10 years experience using ms SQL server reporting services (SSRS)

Over 10 years experience using ms SQL server integration services (SSIS)

Over 10 years experience writing / maintaining complex data transformation packages (DTS)

Over 10 years experience using SAP/Business Objects all versions incl. 3.1 and 4.0

Over 10 years experience database administration

Over 10 years experience extract transform and load (ETL)

Over 10 years experience electronic data interchange (EDI)

Over 10 years experience writing business requirements and functional specifications

Over 8 years experience data modeling (conceptual, logic build, physical creation)

Over 8 years experience using ms visual studio / ms SQL Server reporting services

Over 8 years experience using SAP/BO universe designer (Versions2R through 4.1 Release)

Over 8 years experience using SAP/BO web intelligence (Versions2R through 4.1 Release)

Over 8 years experience using SAP/BO dashboard design (Versions2R through 4.1 Release)

Over 7 years experience using ms SQL Server analysis services (SSAS) both Cube and Tabular

Over 7 years experience working with EDI Healthcare 834 Enrollment / 837 Claims / 277 Claim Status  ANSI x12 File Processing

Over 6 years experience in mortgage industry

Over 6 years experience using SQL server 2008 enterprise software

Over 6 years experience using ms multi-dimensional expression language (mdx)

Over 6 years experience using Microstrategy BI tools

Over 6 years experience using MySQL Workbench Suite

Over 6 years experience in healthcare industry data

Over 5 years experience using SAP/BO data integrator

Over 5 years experience using IBM Infosphere Datastage

Over 5 years experience as Data Scientist with Big Data (Mortgage / Healthcare)

Over 4 years experience using SAP/BO excelsius dashboards/scorecards

Over 4 years experience using SQL server 2012-2014 SSRS, SSIS, SSAS

Over 4 years experience using Qlikview

Over 4 years experience using TIBCO jasper ireports (open source)

Over 4 years experience using COGNOS Report Developer

Over 4 years experience using TABLEAU Reporting Dashboard and Scorecard KPI / Predictive Analytics planning and development

Over 3 years experience using Microsoft excel “power pivot” module

Over 3 years experience using Azure Data Lake=>Azure SQL DB (DW, DMs)

Over 2 years experience using Google analytics

Over 2 years experience using Talend ETL

Over 2 years experience using PYTHON

Over 2 years experience using BIRT Reporting

Over 2 years experience using MS Power BI

 

 

 

 

Industry expertise:

·                            Business intelligence software development

·                            Conceptual to installation to implementation and maintenance

·                            Business intelligence executive dashboard analytics and informatics

·                            Complex universe design based on business logic

·                            Database modeling and implementation

·                            Multi-dimensional cube modeling and reporting using (Data warehouse / data mart modeling and implementation

·                            EDI – electronic data interchange / file transfer protocol

·                            Financial profit/loss and balance sheet/general ledger reporting

·                            Implementation and maintenance of reporting software

·                            Documentation of reporting requirements

·                            Documentation and training on best practices

·                            Creation of complex structured query language (SQL) logic for reporting stored procedures, triggers, functions

·                            ETL programming and processes

 

Education/certifications:

·                            Graduate Bryan Adams High School-DALLAS TEXAS - 1979-1983 – ACCOUNTING / COMPUTER SCIENCE

 

Certifications

·                            Training certification 2000 – intermediate crystal reports

·                            Training certification 2001 – advanced crystal reports

·                            Training certification 2005 – SQL Server database administration

·                            Training certification 2005 – advanced crystal reports

·                            Training certification 2007 – BO web intelligence

·                            Training certification 2007 – BO universe designer

·                            Training certification 2009 – SQL Server 2008

·                            Training certification 2012 – SQL Server Business Intelligence

·                            Training certification 2012 – Qlikview

 

Professional experience:

 

Cigna-Healthspring / REMOTE from Dallas to Nashville TN                                                            July2017-CURRENT

Sr Business Technical Analyst / Business Intelligence Software Solutions Consultant – LEAD DEVELOPER / ARCHITECT

•                     Medicaid and Medicare Healthcare Analytics for Member Services working to create solutions for identifying and monitoring of the  Complex Critical Care member group. Creation of complex algorithm processes used to identify member groups for reporting to government agencies for payment processes.

•                     SQL Server Analysis Services Planning, Development and Maintenance

•                     Healthcare Analytics

•                     Microsoft Business Intelligence Stack - SSRS, SSIS, SSAS. (Cube / Tabular)

•                   Excel Power Pivot.

•                   EDI Healthcare 834 Enrollment / 837 Claims / 277 Claim Status  ANSI x12 File Processing

•                   Data Warehouse Kimball Style design and development,

•                   Data Integration using SQL Server Integration Services,

•                   MDX Cube Development using SQL Server Analysis Services Technology.

•                     electronic data interchange (EDI)

•                     Predictive Analytics using Microsoft BI Stack (Data Scientist)

•                     Key Performance Indicator Analytics

•                     DB development using Access / Excel / VBA / vb.net

•                     Business Objects WEBI and CRYSTAL REPORTS AND UNIVERSE DEVELOPMENT

•                     Dashboard creation and maintenance

•                     SSAS Cube Design, Development and Maintenance

•                     Data Analysis and Trending (Data Scientist)

•                     Writing of Business Requirements

•                     Writing of all Functional Specifications

•                     SSIS Planning, Design and Development

·                    Qliksense – Dashboard Planning and Development

·                   Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development

•                     Oracle BI

·          Azure Data Lake=>Azure SQL DB (DW, DMs)

•                     JasperSoft Reports

Ad-Hoc Reports.

-       Domain for the database.

-       Customer administrative access On Jasper.

-       Schedule, define and save an ad-hoc report.

 

Embedded reports executed inside Web Site.

-       Created Access site, login, navigate to reports page, click, report as HTML/launch in browser.

-       Create Access to Jasper.

-       Filtering by the user type and organization of the user (what a user can see).

 

Customized Charts and Analytics

-                      KPIs – Key Performance Indicators

-                       Predictive Analytics

-                       Executive Summary

•                     Teradata

·                    Eclipse / BIRT Report Development

•                     Talend ETL development

 

 

Wells Fargo Banking Services / REMOTE from Dallas                                                                        May2017-July2017

Sr Business Analyst / Business Intelligence Software Solutions Consultant – LEAD DEVELOPER / ARCHITECT

·          Data Warehouse Planning and Development using SQL Server BI Stack- SSRS, SSIS, SSAS

·          Strategic planning for entire Server Centric Key Performance Indicators and Predictive Analytics

·          Extract Transform and Load Planning and Development

·          Creation of complex Business Logic for the creation of all reporting and dashboards

·          Writing of all Requirement Documentation

·          Writing of all Functional Specifications

·          Azure Data Lake=>Azure SQL DB (DW, DMs)

·          Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development

·          Planning and Creation of complex SQL Script Algorithms used to build ETL Stored Procedures

 

 

United Healthcare / OPTUM – REMOTE from Dallas                                                 July2016-May2017

Sr Business Analyst / Business Intelligence Software Solutions Consultant – LEAD DEVELOPER

·            Complex Care Analytics for Member Services working to create solutions for identifying and monitoring of the Complex Critical Care member group. Creation of complex algorithm to identify member groups for Diabetes, Asthma, Heart Disease and COPD using Claims Data, Lab Data and other member centric metrics.

·            SQL Server Analysis Services Planning, Development and Maintenance

·            Healthcare Analytics

·            Microsoft Business Intelligence Stack - SSRS, SSIS, SSAS. (Cube / Tabular) Excel Power Pivot. Data Warehouse Kimball Style design and development, Data Integration using SQL Server Integration Services, MDX Cube Development using SQL Server Analysis Services Technology.

·            electronic data interchange (EDI)

·            EDI Healthcare 834 Enrollment / 837 Claims / 277 Claim Status  ANSI x12 File Processing

·            Predictive Analytics using Microsoft BI Stack (Data Scientist)

·            Key Performance Indicator Analytics

·            Business Objects WEBI and CRYSTAL REPORTS AND UNIVERSE DEVELOPMENT

·            Dashboard creation and maintenance

·          DB development using Access / Excel / VBA / vb.net

·            SSAS Cube Design, Development and Maintenance

·            Data Analysis and Trending (Data Scientist)

·            Writing of Business Requirements

·            Azure Data Lake=>Azure SQL DB (DW, DMs)

·            Writing of all Functional Specifications

·            SSIS Planning, Design and Development

·          Data Analysis and development using MySQL Workbench 6.3

·            Oracle

·            Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development

·            Teradata

·            Eclipse / BIRT Report Development

·            Talend ETL development

 

United States Army / Camber Corp – REMOTE from Dallas                                  July2016 – November2016

Sr Business Analyst /  Business Intelligence Software Solutions Consultant – LEAD DEVELOPER

·          Microsoft Master Data Services development

·          Creation of customized MDS SQL Scripts used to Load Data into Master Data Services

·          Creation and maintenance of SSIS Packages use for Purge of data in Master Data Services

·          Creation and maintenance of Stored Procedures for Master Data Services

 

Anthem / Blue Cross Blue Shield – REMOTE from Dallas                                       March2016 –July2016

Sr Business Analyst / Business Intelligence Software Solutions Consultant / SSAS Developer / Information Architect – LEAD DEVELOPER

·            SQL Server Analysis Services Planning, Development and Maintenance

·            Healthcare Analytics

·            Microsoft Business Intelligence Stack - SSRS, SSIS, SSAS. (Cube / Tabular) Excel Power Pivot. Data Warehouse Kimball Style design and development, Data Integration using SQL Server Integration Services, MDX Cube Development using SQL Server Analysis Services Technology.

·            Predictive Analytics using Microsoft BI Stack (Data Scientist)

·            electronic data interchange (EDI)

·            EDI Healthcare 834 Enrollment / 837 Claims / 277 Claim Status  ANSI x12 File Processing

·            Key Performance Indicator Analytics

·            Talend ETL development

·            Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development

·            Writing of Business Requirements

·            Writing of all Functional Specifications

·            Dashboard creation and maintenance

·            SSAS Cube Design, Development and Maintenance

·          Data Analysis and development using MySQL Workbench 6.3

·            MS Power BI Development

·          DB development using Access / Excel / VBA / vb.net

·            Data Analysis and Trending (Data Scientist)

·            COGNOS Report development and maintenance

·            Eclipse / BIRT Report Development

·            Azure Data Lake=>Azure SQL DB (DW, DMs)

·            Business Objects WEBI and CRYSTAL REPORTS AND UNIVERSE DEVELOPMENT

 

MD Revolution – REMOTE from Dallas online to San Diego    January 2016 – March 2016

Sr Business Analyst / Business Intelligence Software Solutions Consultant / Jaspersoft Developer  / Information Architect – LEAD DEVELOPER

·            Healthcare Analytics System development

·            Jaspersoft iReports Studio development

·          Ad-Hoc Reports.

·          -       Domain for the database.

·          -       Customer administrative access On Jasper.

·          -       Schedule, define and save an ad-hoc report.

·           

·          Embedded reports executed inside Web Site.

·          -       Created Access site, login, navigate to reports page, click, report as HTML/launch in browser.

·          -       Create Access to Jasper.

·          -       Filtering by the user type and organization of the user (what a user can see).

·           

·          Customized Charts and Analytics

·          -                      KPIs

·          -                       Predictive Analytics

·          -                       Executive Summary

·          Business Objects WEBI and CRYSTAL REPORTS AND UNIVERSE DEVELOPMENT

·            Data Analysis and development using MySQL Workbench 6.3

·            Writing of Business Requirements

·            Azure Data Lake=>Azure SQL DB (DW, DMs)

·            Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development

·            Writing of all Functional Specifications

·            Report conversion from “R” Code application to Jaspersoft iReports Solution

·            Business Analysis for Medical Claims data, ICD-9 Codes and complex algorithms

 

TGI Fridays Corporate Headquarters –Carrollton TX                                     October 2015 – January 2016

Sr Business Analyst /  Database Administrator / Developer / Consultant / Data Scientist / Information Architect – LEAD DEVELOPER

·                       Microsoft Business Intelligence Stack - SSRS, SSIS, SSAS. (Cube / Tabular) Excel Power Pivot. Data Warehouse Kimball Style design and development, Data Integration using SQL Server Integration Services, MDX Cube Development using SQL Server Analysis Services Technology.

·                       Predictive Analytics using Microsoft BI Stack (Data Scientist)

·            Key Performance Indicator Analytics

·            electronic data interchange (EDI)

·            Writing of Business Requirements

·            Writing of all Functional Specifications

·                       Dashboard creation and maintenance

·                       SSAS Cube Design, Development and Maintenance

·                       Talend ETL Development

·                       Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development

·          Data Analysis and development using MySQL Workbench 6.3

·                       Data Analysis and Trending (Data Scientist)

·          DB development using Access / Excel / VBA / vb.net

 

 

Blue Cross Blue Shield of Texas – Richardson TX                                 December 2014 – October 2015

Sr Business Analyst / Database Administrator / Developer / Consultant/ Data Scientist / Information Architect (Remote) – LEAD DEVELOPER

<span style="font-size:8pt;font-family:Symbol;