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 2 years experience using Google analytics
• Over 2 years experience using Talend ETL
• Over 2 years experience using PYTHON
• Over 2 years experience using MS Power BI
• 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

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Sr Business Technical Analyst / Business Intelligence Software Solutions Consultant

Responsibilities:

• 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.
• 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
• Dashboard Planning and Development
• Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development
• Oracle BI
• 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
• Talend ETL development

Confidential, Dallas

Sr Business Analyst / Business Intelligence Software Solutions Consultant

Responsibilities:

• 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
• 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

Confidential, Dallas

Sr Business Analyst / Business Intelligence Software Solutions Consultant

Responsibilities:

• 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
• 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
• Talend ETL development

Confidential, Dallas

Sr Business Analyst / Business Intelligence Software Solutions Consultant

Responsibilities:

• 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

Confidential, Dallas

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

Responsibilities:

• 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
• Business Objects WEBI and CRYSTAL REPORTS AND UNIVERSE DEVELOPMENT

Confidential, San Diego

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

Responsibilities:

• 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
• 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

Confidential, Carrollton TX

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

Responsibilities:

• 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

Confidential, Richardson, TX

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

Responsibilities:

• Responsibility includes Lead Data Architecture planning and analysis in the Healthcare Industry. Tactical, Collaborative Team Planning and Development process.
• Healthcare Predictive Analytics for patient healthcare analysis. Microsoft SQL Server 2008-2012 SSRS, SSIS, SSAS. (Cube / Tabular) Business Intelligence Report Development.
• Key Performance Indicators and Dashboard Analytics. ETL Process Development. Complex Cube Development and Deployment. electronic data interchange (EDI)
• EDI Healthcare 834 Enrollment / 837 Claims / 277 Claim Status ANSI x12 File Processing
• SAP/Business Objects XI Version 4.1 Release Web Intelligence Report Development and Universe Design. Full Software Development Cycle. Oracle 10g Development. Design, develop and maintain all SAP/Business Objects XI Crystal Reports. Crystal Xcelsius Dashboards and Scorecards. Relational Database design and implementation. Data Warehouse Architecture using Ralph Kimball Method. Report Development Solutions using SAP/Business Objects 6.5 and Web Intelligence XI.
• SAP/Business Objects 3.1 / 4.0 and Crystal Reports. ICD9 to ICD10 Diagnosis Code conversion project expertise. Microsoft Excel POWER PIVOT BI Module Development.
• Big Data Architecture and reporting using Qlikview.
• Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development
• Writing of Business Requirements
• Writing of all Functional Specifications
• MS POWER BI development
• Jaspersoft iReports Development and Report Conversion from Crystal Reports and from SQL Server Reporting Services to Jasper iReports.
• 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
• Data Analysis and development using MySQL Workbench 6.3 electronic data interchange (EDI)
• COGNOS Report development and maintenance
• DB development using Access / Excel / VBA / vb.net
• MicroStrategy Version 8.1 BI Tool Architect, Report Development and Maintenance.
• ETL Development using IBM Infosphere Datastage
• Oracle DBA, Toad for Oracle
• ETL Development using Talend ETL
• Business Objects WEBI and CRYSTAL REPORTS AND UNIVERSE DEVELOPMENT

Confidential, Washington, DC

Sr Business Analyst / Business Intelligence Consultant / Data Scientist / Information Architect

Responsibilities:

• Microsoft Business Intelligence Stack - SSRS, SSIS, SSAS. (Cube / Tabular) Excel Power Pivot. Data Warehouse Kimball Style design and development, Data Integration using SQL ServerIntegration Services, MDX Cube Development using SQL Server Analysis Services Technology. Crystal Reports XI Server Development and Administration. 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 (Cube / Tabular) 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 Vist / Next Appointment Metrics, Patient Screening Analytics (Cancer, Heart Disease, Diabetes). Creation of complex SQL Queries and Stored Procedures in both report analytics as well as Extract Transform and Load processes. electronic data interchange (EDI)
• EDI Healthcare 834 Enrollment / 837 Claims / 277 Claim Status ANSI x12 File Processing
• Big Data Architecture and reporting using Qlikview.
• Jaspersoft iReports Development and Conversion from Jasper iReports to SQL Server Reporting Services
• 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
• Oracle DBA, Toad for Oracle electronic data interchange (EDI)
• ETL Development using IBM Infosphere Datastage
• ETL Development using Talend ETL
• Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development
• Writing of Business Requirements
• DB development using Access / Excel / VBA / vb.net
• Writing of all Functional Specifications
• COGNOS Report development and maintenance
• Data Analysis and development using MySQL Workbench 6.3
• Business Objects WEBI and CRYSTAL REPORTS AND UNIVERSE DEVELOPMENT
• SQLServer 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. Conversion of Jasper iReports to SSRS Reports.

Confidential, Cleveland, OH

Sr. Business Analyst / Data Scientist / Information Architect (Remote)

Responsibilities:

• Business Systems Analysis, SAP/Business Objects versions 3.1 and 4.1 Web Intelligences /Desktop Intelligence / Crystal Reports Report development.
• Creation of customized reporting for large College / University. Student Analytics, Faculty Analytics, Financial Income Revenue Analytics, Employee Recruitment Analytics and Predictive Analytics. Microsoft SQL Server 2012 Business Intelligence Stack- SSRS, SSIS, SSAS. (Cube / Tabular) Oracle Business Intelligence Database Administration. Crystal Xcelsius Dashboards and Scorecards.
• Big Data Architecture and reporting using Qlikview.
• Writing of Business Requirements
• Writing of all Functional Specifications
• Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development electronic data interchange (EDI)
• Jaspersoft iReports 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
• Create Design Documentation, Physical Creation and/or Modification of all Reports. Microsoft Excel POWER PIVOT BI Module Development. Data Warehouse Design and Development of Data Marts. Oracle SQL Development.
• Oracle DBA, Toad for Oracle

Confidential, NAPA, CA

Sr. Business Analyst / Business Intelligence Consultant / Data Scientist / Information Architect

Responsibilities:

• SAP/Business Objects Web Intelligence 4.0 and Crystal Reports specialized business predictive analytics project related to the Wine Industry.
• Writing of Business Requirements
• Writing of all Functional Specifications
• DB development using Access / Excel / VBA / vb.net
• Creating complex key performance indicators and Predictive Analytics to aid in optimizing profitability. SQLServer 2012 SSRS,SSIS and SSAS. (Cube / Tabular) SAP/Business Objects Universe Designer creating and maintaining Universes. Create / Modify /Maintain Crystal Reports. Crystal Xcelsius Dashboards and Scorecards. Create Design Documentation, Physical Creation and/or Modification of all Universes and Reports. Microsoft Excel POWER PIVOT BI Module Development.

Confidential, Plano, TX

Sr. Business Analyst / Business Intelligence Consultant / Data Scientist / Information Architect

Responsibilities:

• Responsible for Business Intelligence Data Warehouse Information Architecture and Healthcare Analytics, Solutions Development utilizing SQL Server 2012 SSIS, SSRS, SSAS (Cube / Tabular) Analytics. electronic data interchange (EDI)
• EDI Healthcare 834 Enrollment / 837 Claims / 277 Claim Status ANSI x12 File Processing
• Writing of Business Requirements
• Writing of all Functional Specifications
• Predictive Analytics for Premier Home Healthcare Market. Creation of Complex Key Performance Indicators and Predictive Analytics for Dashboard Trend Display. ETL Analysis and Development. SAP/Business Objects 3.1 / 4.0 and Crystal Reports. Crystal Xcelsius Dashboards and Scorecards. Full Software Development Life Cycle project development.
• Relational design, development and implementation. Data Architecture utilizing Ralph Kimball Methodology in addition to Data Mart Development utilizing Bill Inmon Methodology.
• Specialized analytics for the Home Healthcare Industry. Business Intelligence SQL Server Reporting Services Report development. JasperSoftiReports Server Development. Microsoft Excel POWER PIVOT BI Module Development.
• Specialized focus on Patient Centric Metrics that assisted the VA in isolating trends in Patient Care. Last Vist / Next Appointment Metrics, Patient Screening Analytics (Cancer, Heart Disease, Diabetes). Creation of complex SQL Queries and Stored Procedures in both report analytics as well as Extract Transform and Load processes.
• SQL Server Reporting Services Report Development for data from both Data Warehouse and Data Cubes.
• Big Data Architecture and reporting using Qlikview.
• DB development using Access / Excel / VBA / vb.net
• ETL Development using Talend ETL
• COGNOS Report development and maintenance
• Oracle DBA, Toad for Oracle
• Tableau Dashboard development for KPI Analytics and Predictive Analytics, Scorecard planning and development electronic data interchange (EDI)
• MicroStrategy Version 8.1 Architect, Report Development and Maintenance.
• Data Analysis and development using MySQL Workbench 6.3
• Jaspersoft iReports Development

Confidential, Richardson, TX

Business Systems Technical Analyst / BI Software Solutions Consultant / Information Architect

Responsibilities:

• Responsibility includes Lead Data Architecture planning and analysis in the Healthcare Industry. Tactical, Collaborative Team Planning and Development process.
• Healthcare Predictive Analytics for patient healthcare analysis. Microsoft SQL Server 2008-2012 SSRS, SSIS, SSAS. (Cube / Tabular) Business Intelligence Report Development. Key Performance Indicators and Dashboard Analytics. ETL Process Development. Complex Cube Development and Deployment.
• SAP/Business Objects XI Web Intelligence Report Development and Universe Design versions 3.1 and 4.1. Full Software Development Cycle. Oracle 10g Development. Design, develop and maintain all SAP/Business Objects XI Crystal Reports. Crystal Xcelsius Dashboards and Scorecards. Relational Database design and implementation. Data Warehouse Architecture using Ralph Kimball Method. Report Development Solutions using SAP/Business Objects 6.5 and Web Intelligence XI.
• SAP/Business Objects 3.1 / 4.0 and Crystal Reports. ICD9 to ICD10 Diagnosis Code conversion project expertise. Microsoft Excel POWER PIVOT BI Module Development. electronic data interchange (EDI)
• EDI Healthcare 834 Enrollment / 837 Claims / 277 Claim Status ANSI x12 File Processing
• Big Data Architecture and reporting using Qlikview.
• Writing of Business Requirements
• Writing of all Functional Specifications
• ETL Development using IBM Infosphere Datastage electronic data interchange (EDI)
• MicroStrategy Version 9.2 BI Tool Architect, Report Development and Maintenance.
• Oracle DBA, Toad for Oracle
• DB development using Access / Excel / VBA / vb.net
• COGNOS Report development and maintenance
• Data Analysis and development using MySQL Workbench 6.3
• Jaspersoft iReports 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

Confidential, Irving, TX

Senior Business Analyst / Business Intelligence Consultant / Data Scientist / Information Architect

Responsibilities:

• Responsible for complete SQL Server 2005 and 2008 software development. Building and maintaining SSRS reports, design, develop and maintain all SSIS ETL packages. Design, develop and maintain all SSAS (Cube / Tabular), Reports and Dashboards. Sr. Consultant for client Enterprise Data Warehouse build-out projects. Gather client business requirements, set project scope and cost analysis.
• Heavily involved in the sales process. Purchase and installation of SQL Server Enterprise Software. Lead Consultant for SAP/Business Objects XI 3.1 and 4.0 Software Development. Design, develop and maintain SAP/Business Objects XI Universes. Design, develop and maintain SAP/Business Objects XI Web Intelligence reports versions 3.0. Consultant for SAP/Business Objects XI Data Integrator. JasperSoftiReports Server Development. Design, develop and maintain all SAP/Business Objects XI Crystal Reports. Crystal Xcelsius Dashboards and Scorecards. MicroStrategy BI Tool Development. Relational Database design and implementation. Data Warehouse Architecture using Ralph Kimball Method.
• MicroStrategy Version 8.1 BI Tool Architect, Report Development and Maintenance.
• Jaspersoft iReports 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 electronic data interchange (EDI)
• EDI Healthcare 834 Enrollment / 837 Claims / 277 Claim Status ANSI x12 File Processing
• Writing of Business Requirements
• Writing of all Functional Specifications
• Data Analysis and development using MySQL Workbench 6.3
• Oracle DBA, Toad for Oracle
• DB development using Access / Excel / VBA / vb.net
• All software development handled by full life cycle software development. Agile Scrum method used where appropriate to project. Currently working with Hospital Patient Data designing, developing and implementing an Enterprise Data Warehouse which includes all SSIS, SSRS and SSAS (Cube / Tabular) software development. Data Analytics using Qlikview Analytic software. Microsoft Excel POWER PIVOT BI Module Development.
• Big Data Architecture and reporting using Qlikview.