SUMMARY:

• Extremely talented, self - motivated and enthusiastic Computer Engineer and Microsoft Certified Professional with a great background in Data Analytics and Business Intelligence.
• Committed to superior service with the ability to quickly learn new business operations and translate them to system objects; poised in interactions with individuals, resourceful in completing projects and able to multi-task effectively.

TECHNICAL SKILLS:

Business Intelligence: Microsoft Certified Professional ( MCP ), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft BI Management Studio, MS Team Foundation Services (TFS), MS Power Pivot, SharePoint Foundation 2010, Jasper Intelligence, Crystal Reports, MS Excel Power Tools.

Database Management and Administration: MSSQL and Oracle

Programming: Visual Basic Macro for MS Applications, Visual Basic .Net. T-SQL, PL-SQL, DAX

Electronic Health Records: Data Quality, PCHM & HEDIS Reporting and Analytics, PT at Risk and Management Analytics, CPT Coding Stats, Usage and Billing

PROFESSIONAL EXPERIENCE:

Sr. Data Analyst / Electronic Health Records

Confidential

Responsibilities:

• Responsible of the development and maintenance of database objects such as Data Marts, Reports, ETL and Data Warehouse for Health Care Analytics.
• Responsible of the development of Excel Ad-Hoc reports to help the department of EHR perform Quality Assurance and Data Analytics.
• Assisting with the development of custom templates for NextGen EHR with the development of database objects such as Stored Procedures and Views needed to render data for the templates.
• Working in the development of a Data-Mart and a Cube holding the data needed to perform analytics and produce reports for Quality of services and reports for PCMH .
• Assisting the department of EHR with the development of advanced NextGen templates for Practice Management, Alerts, Data Logs and Interfacing with SSR to allow the execution of reports via NextGen.

Confidential

Responsibilities:

• Designed and developed a Business Intelligence solution such as ETL and Reports needed to evaluate data transfer and transformations between Staging, Transform and DW database layers and consolidate metadata in each layer to compare and consolidate the calculated totals.
• Working as the lead ETL Developer in a next generation project providing solutions for Migration/Integration of data from Application Systems to MS PDW ( Teradata ) and Parallel Data Warehouse. Was responsible for coordinating the development efforts with an offshore team of five ETL developers.
• Worked in the deployment of a Database Management Framework to Improve the functionality of SSIS ETL’s with a database custom database layer that works in parallel with SSISDB to enable detailed transaction logging during the execution of an ETL Package. Deployed a custom File Tracking script to keep provide a secured log of the database files been processed, transaction failures, number of records read and number of records with errors.

Data Analyst

Confidential

Responsibilities:

• Worked in the design and Implementation of a Data-Mart server with MS SQL 2012 with Its Business Intelligence package SSIS, SSAS and SSRS. Designed and developed Incremental ETL packages and scripts to extract data and create Information from a EHR system database and import it into the Data-Mart to be used for Reporting and Analytical Review without affecting production
• Designed and Implemented Incremental ETL Packages to extract patient information from two different systems, PACS for Imaging and NextGen for EMR and Import this data into a Data-Mart server to create statistical reports needed to manage Radiology.
• Worked in automatization of numerous NextGen Templates with advanced database objects such as stored procedures or ETL’s to help improve workflow processes.
• Worked in the design of many Ad-Hoc reports and dashboards with SSRS and Power Pivot.
• Writing complex SQL Queries to pull and analyze data via Excel or Power Pivot.
• Designed numerous packages and script to merge patient data from external providers such as Emblem with SIPP EHR system in order to create reports for Analytics.

Business Intelligence Analyst

Confidential

Responsibilities:

• Developed an ETL script to Import Scarsdale Patients data from White Plains Hospital ( Hospital In/Out, ER and MD Visits ) Into NextGen to improve analytics and provide Hospitalization History on each patient chart.
• Responsible of the development of the reports that helped Confidential to achieve PCMH recognition from NCQA.
• Developing database objects or scripts for NextGen templates to define custom business rules.
• Installed and configured an SQL 2008 R2 Data mart Server used to host information from different applications for reporting and data analysis.
• Installed and configured MS SQL 2008 R2 environment for BI with SSRS, SSIS and SSAS servers.
• Developed Incremental ETL Routines to extract data from Shoretel application server and import it into a data-mart server to develop call center log and performance reports.
• Created Global/Shared Calendar and Contacts list with MS SharePoint Services compatible with MS Outlook

Confidential

Responsibilities:

• Responsible of the development of the reports that helped PHP receive PCMH LVL 3 recognition from NCQA.
• Maintaining and Administering MS SQL 2008 Database and Data-Mart.
• Designing database objects (Views & Stored Procedures), ETL Scripts and Routines to extract data from NextGen HER/EPM and import it into PHP Data-Mart for OLTP.
• Evaluating and optimizing database resources or objects with SQL Tools like Tuning Advisor, Execution Plan Analyzer and Nexus.
• Workload Reports in order to identify database processes or objects that may be affecting the performance of the database server.
• Designing database tables for extracts and maintaining their integrity with PK and Indexing for optimal performance.
• Designing and Implementing Progressive and Incremental ETL packages with MS SSIS.
• Designing and Developing web reports with MS SSRS 2008.
• Designed and participated in the development of an Interactive Web Interface used as a presentation layer from SSRS
• Admin server to allow users to review and execute all the reports developed by the department of System Analytics.