Michael Vega Email & Phone Number

Texas, United States

Hartford, Connecticut, Us

• Medicaid and Medicare Healthcare Member ID Card and Letter Analytics for Member Services Department working to create solutions for identifying, monitoring and correcting data information related to the Complex Critical Care member group. Monitoring, documenting and modifying of complex algorithm processes used to identify member groups for ID Card and Member Letter correspondence reporting to government agencies for payment processes.• Healthcare Analytics• Business Requirements Documentation creation• Internal Process Systems Updates• Data Analysis and Trending • Writing of Business Requirements• Writing of all Functional Specifications• Oracle BI

Eagan, Mn, Us

 EDI Healthcare 834 Enrollment / 837 Claims / 277 Claim Status ANSI x12 File Processing Planning, Research and Development of Data Extract Files to Vendors based on customized request Business Requirements Documentation ETL Field Mapping Research, Analysis and Documentation IBM DB2 Database Reporting and Analysis Tableau Dashboard to Power BI Dashboard Conversions, Research, Planning, Analysis and Development  Microsoft Business Intelligence Stack - SSRS, SSIS, SSAS. (Cube / Tabular) Excel Power Pivot.  Oracle Database Analytics Complex Stored Process Development and Maintenance. Python ETL Research, Development and Maintenance of ETL Processing Code Logic Key Performance Indicator Analytics  Complex Business Data Analysis for Creation of Internal SQL Code for Data Aggregations and Migrations Microsoft SSIS ETL development  SAS Data Analysis Data Field to Target Mapping Research, Analysis and Documentation HIVE SQL Database Reporting and Analysis Review medical records and documents to abstract clinical data for HEDIS reporting. Documenting findings in applicable HEDIS databases and on prescribed cloud-based platforms. Performing on-site facility audits for compliance with HEDIS measures. Preparing and presenting HEDIS compliance reports to health facility managers. Training and advising healthcare professionals and administrative staff on HEDIS compliance. Keeping abreast of HEDIS measures. Worked closely with the users and product owner to understand needs and expectations. Wrote detailed business requirements and functional specifications for Agile development teams. Managed the approval process for the requirements/stories. Became subject matter expert in the assigned company application portfolio including the underlying business logic and processes to help design solutions to new requirements and solving business problems.

Beaverton, Or, Us

 Tableau Dashboard development for Human Resource Global KPI Analytics and Predictive Analytics, Scorecard planning and development  Human Resource Analytics for Organizational Governance Global Reporting Snowflake Data Intelligence Microsoft Business Intelligence Stack - SSRS, SSIS, SSAS. (Cube / Tabular) Excel Power Pivot.  Complex Stored Process Development and Maintenance. Python ETL Research, Development and Maintenance of ETL Processing Code Logic Key Performance Indicator Analytics  Complex Business Data Analysis for Creation of Internal SQL Code for Data Aggregations and Migrations SSIS ETL development  SAS Data Analysis Google Cloud Platform Database Development and Analytics MS Power BI Dashboard Development and Maintenance Business Analysis to Define, Gather, Analyze, Document and Manage Business Requirements Writing of all Functional Specifications JIRA System Task Tracking and Reporting  Worked closely with the users and product owner to understand needs and expectations. Wrote detailed business requirements and functional specifications for Agile development teams. Managed the approval process for the requirements/stories. Became subject matter expert in the assigned company application portfolio including the underlying business logic and processes to help design solutions to new requirements and solving business problems. Ensured issues are identified, tracked, reported and resolved in a timely manner. Worked with customers and application developers to identify required changes. Assisted in delivery tracking and adherence to committed timelines. Evaluated and participated in solution alternatives with application development teams while ensuring business solutions meet corporate standards. Negotiated technical and non-technical solutions that satisfied the business users and conform to the technical architecture.

California, 94086, Us

 SQL Server Data Analytics Research, Analysis and Development for Global Reporting of Manufacturing of Surgical Robot Parts and Materials 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. Complex Stored Process Development and Maintenance. Python ETL Research, Development and Maintenance of ETL Processing Code Logic Key Performance Indicator Analytics  Business Requirements Documentation ETL Field Mapping Research, Analysis and Documentation Complex Business Data Analysis for Creation of Internal SQL Code for Data Aggregations and Migrations SSIS ETL development  Google Cloud Platform Database Development and Analytics MS Power BI Dashboard Development and Maintenance Business Analysis to Define, Gather, Analyze, Document and Manage Business Requirements Writing of all Functional Specifications MS Power BI Dashboard development and maintenance Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development SSAS Cube Design, Development and Maintenance Review medical records and documents to abstract clinical data for HEDIS reporting. Documenting findings in applicable HEDIS databases and on prescribed cloud-based platforms. Performing on-site facility audits for compliance with HEDIS measures. Preparing and presenting HEDIS compliance reports to health facility managers. Training and advising healthcare professionals and administrative staff on HEDIS compliance. Keeping abreast of HEDIS measures. JIRA System Task Tracking and Reporting

 SQL Server Analysis Services Planning, Development and Maintenance 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 Science) Electronic data interchange (EDI) Key Performance Indicator Analytics  SSIS ETL development  Business Requirements Documentation SAS Data Analysis Google Cloud Platform Database Development and Analytics ETL Field Mapping Research, Analysis and Documentation MS Power BI Dashboard Development and Maintenance Business Analysis to Define, Gather, Analyze, Document and Manage Business Requirements Writing of all Functional Specifications MS Power BI Dashboard development and maintenance Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development SSAS Cube Design, Development and Maintenance  Worked closely with the users and product owner to understand needs and expectations. Wrote detailed business requirements and functional specifications for Agile development teams. Managed the approval process for the requirements/stories. Became subject matter expert in the assigned company application portfolio including the underlying business logic and processes to help design solutions to new requirements and solving business problems. Ensured issues are identified, tracked, reported and resolved in a timely manner. Worked with customers and application developers to identify required changes. Assisted in delivery tracking and adherence to committed timelines. Evaluated and participated in solution alternatives with application development teams while ensuring business solutions meet corporate standards.

 SQL Server Analysis Services Planning, Development and Maintenance 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 Science) Electronic data interchange (EDI) Key Performance Indicator Analytics  SSIS ETL development  Data Vault analysis and setup Google Cloud Platform Database Development and Analytics Business Requirements Documentation ETL Field Mapping Research, Analysis and Documentation MS Power BI Dashboard Development and Maintenance Business Analysis to Define, Gather, Analyze, Document and Manage Business Requirements Writing of all Functional Specifications MS Power BI Dashboard development and maintenance Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development SSAS Cube Design, Development and Maintenance  Worked closely with the users and product owner to understand needs and expectations. Wrote detailed business requirements and functional specifications for Agile development teams. Managed the approval process for the requirements/stories. Became subject matter expert in the assigned company application portfolio including the underlying business logic and processes to help design solutions to new requirements and solving business problems. Ensured issues are identified, tracked, reported and resolved in a timely manner. Worked with customers and application developers to identify required changes. Assisted in delivery tracking and adherence to committed timelines.

Fort Collins, Co, Us

o SQL Server Analysis Services Planning, Development and Maintenanceo Marketing Analyticso 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.o Predictive Analytics using Microsoft BI Stack (Data Science)o Electronic data interchange (EDI)o Key Performance Indicator Analytics o SSIS ETL development o Business Analysis to Define, Gather, Analyze, Document and Manage Business Requirementso Writing of all Functional Specificationso Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and developmento SSAS Cube Design, Development and Maintenanceo Data Analysis and development using MySQL Workbench 6.3o MS Power BI Development and Maintenanceo Crystal Reports Development and Maintenanceo Analyzed, Planned and Developed Entire Product SKU Dimension for Enterprise Data Warehouse.o Mapping of all data fields for Source System to Target Systemso Creation of complex SSIS packages to load Staging and Production Data Warehouse.o Complex Exception Data Table Planning and Developmento Agile Source Systems, M3 Source Systems, SQL Server Source Systems, Oracle Source Systems.

Us

o HIVE SQL / Hadoop Big data analysis and development.o Medicaid and Medicare Healthcare Analytics for Member Services working to create solutions for identifying and monitoring of the Ohio Comprehensive Primary Care and Complex Critical Care member group. Creation of complex algorithm processes used to identify member groups for reporting to government agencies for payment processes.o SQL Server Analysis Services Planning, Development and Maintenanceo Healthcare Analyticso Data Warehouse Kimball Style design and development, o electronic data interchange (EDI)o Writing of Business Requirementso Writing of all Functional Specificationso Python development and maintenance of custom data applicationo JasperSoft software report development and maintenanceo JIRA project managemento PyCharm Software Development

Dallas, Texas, Us

Big Data Analytics:- colaborative work with Data Scientist Team to discover and analyze complex Predictive Analytics and Key Performance Indicators for the Blood Donation Industry.- Teradata SQL Assistant and Teradata Studio Development- SQL Server BI Stack planning and development- Big Data Analytics for Blood Donation Industry- Oracle Business Intelligence Suite Development- Data Analysis to discover new intelligence drawing on historical Blood Donation Data Points for historical data- Creation of complex SQL Scripts to provide innovation and insight Predictive Analytics into the Blood Donation Industry.- Collaboration with Data Scientist to integrate complex SQL Scripts Queries with "R" program for scientific analysis of trend data.- Microsoft Power BI Planning and Development

• 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. Excel Power Pivot. Data Warehouse Kimball Style design and development, Data Integration using SQLServer Integration Services, MDX Cube Development using SQLServer Analysis Services Technology.• electronic data interchange (EDI)• 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• 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• Oracle BI• JasperSoft Reports• Teradata• Talend ETL development

San Francisco, California, Us

• Complex Server Maintenance / Patch Upgrade analytics for entire Wells Fargo Branch Server Network. Working to create solutions for identifying and monitoring of the Complex Server Maintenance Algorithms for Critical Patch Updates.• SQL Server Analysis Services Planning, Development and Maintenance• Healthcare Analytics• Microsoft Business Intelligence Stack - SSRS, SSIS, SSAS. Excel Power Pivot. Data Warehouse Kimball Style design and development, Data Integration using SQLServer Integration Services, MDX Cube Development using SQLServer Analysis Services Technology.• electronic data interchange (EDI)• 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• 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• Data Analysis and development using MySQL Workbench 6.3• Oracle• Teradata• Talend ETL development

Us

Complex Care Management Analytics and Software Development. SQL SERVER Business Intelligence STACK (SSRS, SSIS, SSAS) Development. Planning, Designing, Developing and Maintaining complex ETL Processes, Predictive Analytics and Trending Data Models, Key Performance Indicators, Healthcare Analytics Dashboards and Scorecards. Healthcare Metrics and Data Mining Algorithms for Machine Leaning Processes and Big Data Analytics. SSAS Cube development. Kimball style data warehouse development. Oracle and Teradata database development.

Indianapolis, Indiana, Us

SSAS / SQL Server Analysis Services analysis, planning and development of MDX CUBE for Analytics for Anthem Blue Cross Blue Shield in North Carolina. Dimensional Modeling working with large data sets and conducting performance tuning. Healthcare Analytics, Membership and Provider Trending and Predictive Analytics.OLAP Cube Design, Development and Maintenance for large Teradata Enterprise Data Warehouse. ROLAP and MOLAP Cube Development.

Solana Beach, California, Us

Business Intelligence software development focusing on Jaspersoft iReports Studio with MySQL Database. Migrating reporting off of an "R" coded solution onto Jaspersoft. Data Analysis utilizing MySQL Workbench 6.3. Report Analysis, planning and development.

Dallas, Texas, Us

Business Intelligence Software Solution Development utilizing the Microsoft BI Stack Software SQL Server Reporting Services, SQL Service Integration Services, SQL Server Analysis Services. Key Performance Indicators's and Predictive Analytics. MDX Cube Creation Technology. Database Administration. Data Scientist analysis and statistics. Jaspersoft iReport Development.

Chicago, Il, Us

Providing SQL Server Business Intelligence Software Development and Consulting. Health-Care Industry Data, Creating Solutions in the Information Technology Group "New Development Center" for Data Integration issues using SSIS, Business Intelligence Reporting Solutions using SSRS, BIRT and Business Objects Web Intelligence. Creating complex Stored Procedures utilizing business KPI and Predictive Analytics and processes. SQL Server Development: SSIS, SSRS and SSAS development. Data Scientist analysis and statistics.Information Architecture, Predictive Analytics and Business Intelligence Key Performance Indicator Reporting for Healthcare Insurance Industry Data. HIPPA Regulatory Reporting Requirements. Planning and Analysis, Development, Migration and Deployment of final Business Solution. Teradata, Oracle and SQL Server Solution Specialist. Qlikview, Cognos and Business Objects, Crystal Reports, Jaspersoft iReport Development.

Pittsburgh, Pa, Us

Business Intelligence Software Solution Development for Case Western University utilizing SAP Business Objects XI, Oracle, BO Universe Designer, SQL Server 2012 SSAS, SSRS, SSIS technologies. Lead Developer, Prediction Analytics, Dashboards, Data Architecture and Integration. Qlikview, Business Objects XI, WEBI and Crystal Reports Development. Data Scientist analysis and statistics. Jaspersoft iReport Development.

Washington, Dc, Us

Providing Software Solutions Data Warehouse Consulting for the US Department of Veteran Affairs (VA, VHA) in Washington DC.Microsoft Business Intelligence Stack - SSRS, SSIS, SSAS. 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. Crystal Reports XI Server Development and Administration. Qlikview, Jaspersoft iReports, Crystal Xcelsius Dashboards and Scorecards. ICD9 to ICD10 Data Conversion Project. Legacy Data Mart Stored Procedures and Processes Refactoring to New Corporate Data Warehouse Stored Procedures and Processes using the Microsoft SQL Server 2012 Business Intelligence Stack – SSRS, SSIS, SSAS Technology. Development of Key Performance Indicators and Predictive Analytics for the VA Patient Tracking Dashboards and Analytics. Business Analysis using Healthcare Analytics Processes to identify areas for creation of Patient Trend Tracking Analytics and creation of new processes for the VA Daily Dashboard Analytics display for Executives. Data Information Architecture using Kimball Style Methodology. Agile Scrum Systems Development Life Cycle (SDLC). Specialized focus on Patient Centric Metrics that assisted the VA in isolating trends in Patient Care. Last Visit / Next Appointment Metrics, Patient Screening Analytics (Asthma, Cancer, Heart Disease, Diabetes, COPD). Creation of complex SQL Queries and Stored Procedures in both report analytics as well as Extract Transform and Load processes. Data Scientist analysis and statistics.SQL Server Reporting Services Report Development for data from both Data Warehouse and Data Cubes. Build entire processes based on Business Process for specific areas of the Veteran’s Administration Clinical Data Areas.

Roswell, Georgia, Us

Specialized Business Objects Report Analytics project. Creation of a complex analytics solution to help promote profitability based on Wine Industry Analytics. Business Objects Web Intelligence, Universe Designer, Qlikview, SQL Server Business Intelligence Stack (SSRS, SSAS, SSRS). Data Scientist analysis and statistics. Jaspersoft iReport Development.

Business Intelligence Software Solution Development for the premier Home-Healthcare Provider Accelion Health. BI Solutions utilizing the Microsoft BI Stack Software (SSRS,SSIS,SSAS) Healthcare Analytics, KPI's and Predictive Analytics. MDX Cube Technology. Qlikview Development. Specialized analytics for the Home Healthcare Industry. Business Intelligence SQL Server Reporting Services Report development. JasperSoft iReports Server Development Predictive and Key Performance Indicator Analytic design and creation. Data Scientist analysis and statistics. Jaspersoft iReport Development.

Chesterfield, Missouri, Us

Enterprise Data Warehouse Solution for the ETS Rental Services Corporation. Financial Reporting using SQL Server SSRS, SSIS, SSAS. Kimball Style Methodology. MDX Cube Solution Technology. Qlikview Development. Jaspersoft iReports Development. Data Scientist analysis and statistics.

Chicago, Il, Us

Supporting the Competitive Position of the Blue Cross Blue Shield of TX / Blue Care Connection Program which focuses on improving our competitive position in the marketplace and optimizing the clinical programs within the BCC. Programs Include: Utilization Case Management, Behavioral Health Care Advisor, Personal Health Manager (PHM), 24/7 Nurseline, Special Beginnings, Fitness Program.Information Architecture, Predictive Analytics and Business Intelligence Key Performance Indicator Reporting for Healthcare Insurance Industry Data. HIPPA Regulatory Reporting Requirements. Planning and Analysis, Development, Migration and Deployment of final Business Solution. Teradata, Oracle and SQL Server Solution Specialist. SQL Server, Qlikview Development, Jaspersoft iReports Development, Business Objects. Data Scientist analysis and statistics.

Menlo Park, Ca, Us

On-site at Wave Two. Business Intelligence Consultation. Enterprise Data Warehouse and Reporting Solutions. Working on the Dallas / Ft Worth Hospital Corporation (DFWHC) Data Warehouse Redesign project for Healthcare Analytics and Reporting. SQL Server Enterprise Software Development. SSRS, SSIS, SSAS. Business Intelligence - Qlikview Analytics. Business Intelligence SQL Server Reporting Services Report development. JasperSoft iReports Server Development Predictive and Key Performance Indicator Analytic design and creation specific to the Hospital Industry. Data Scientist analysis and statistics.

Glen Allen, Va, Us

Worked on the Cash Flow - Data Architecture project for Fiserv Data import using Mortgage Industry transactional data. SQL Server Enterprise Software Development. SSRS, SSIS, SSAS. Jaspersoft iReports. Data Scientist analysis and statistics.

Milwaukee, Wi, Us

Worked on the Supply Network Analytics project for VHA. I was responsible for full software development life-cycle of a Business Intelligence reporting solution utilizing the Microsoft SQL Server Reporting Services platform coupled with a customized front-end customer delivery application. Utilizing SSIS and SSRS. Building customized data mining analytic reports to be used by 1000's of Hospitals and Data Analysts across the nation. Business Intelligence SQL Server Reporting Services Report development. JasperSoft iReports Server Development Predictive and Key Performance Indicator Analytic design and creation specific to the Healthcare Product Supply Chain analytic industry. Data Scientist analysis and statistics.

Hanover, Md, Us

Technical Engagement Manager for an Enterprise Data Warehouse Development team at Saxon Mortgage (A Division of Morgan Stanley) in Irving. Develop BI Solutions using Microsoft SQL Server Reporting Services (SSRS). SQL Server Integration Services (SSIS), Informatica ETL. Project Planning using Agile SCRUM processes and documentation. Major tasks of migrating SSRS Enterprise Reporting System to SSRS Enterprise Data Warehouse. Business Intelligence SQL Server Reporting Services Report development. JasperSoft iReports Server Development Predictive and Key Performance Indicator Analytic design and creation specific to the Mortgage Industry Dashboards. Data Scientist analysis and statistics.

Responsible for complete [hands-on] oversight of the Business Intelligence Department. Responsibilities Include: Database / Data Warehouse Administrator, Crystal Reports Developer,Jaspersoft iReports Development, SQL Server Reporting Services Engineer, Data Architect, Business Analyst. Data Scientist analysis and statistics.

Plano, Tx, Us

Full Life-Cycle Software Development.Business Objects XI, Crystal Reports XI Software Development. Jaspersoft iReports Development. Universe Design and Maintenance. Oracle P/SQL scripts. SQL Server 2005 SSRS, SSIS, SSAS. Data Scientist analysis and statistics.

Dallas, Tx, Us

Business Analysis and Full Life-Cycle Software Development working to find areas for increased profitability creating and utilizing "Key Performance Indicators" to help Executive Team make fast business decisions. Software Developer. Business Objects XI Web Intelligence, Crystal Reports XI, SQL Server 2000, 2005. SSRS,SSIS, SSAS. Data Scientist analysis and statistics.

Minnetonka, Minnesota, Us

Oversite of the Financial Accounting Department. General Ledger, Profit/Loss - Balance Sheet Reporting, Customer Reporting, Group and Charter, Key Performance Indicator Analysis. Multi-million dollar travel company with large Group and Charter Department and specialized Airline Reporting Requirements.