SUMMARY

• Industry expert possessing keen understanding and hands - on exposure of all phases of Project / Program Life Cycle, which includes critical functions such as requirement gathering and analysis, project scoping, task allocation, resource optimization and timely project delivery, with focus on quality and costs
• Hands on experience on understanding Electronic Health Record (EHR) systems and applying different predictive models to cluster and predict
• Designed, developed & implemented datawarehousing solutions using MSBI tools (SSIS, SSAS, SSRS & PowerBI)
• Efficient Team Leader & Player, combining communication, interpersonal & problem solving skills with analytical, decision making and leadership capabilities to enhance organizational objectives

TECHNICAL SKILLS

Project Management tools: MS Project, MS office (word, excel, PowerPoint, MS Access)

Software: TSQL, vb.net, PLSQL, HTML, XML, R

DataBase: MSSQL, Oracle, DB2, MYSQL,MongoDB

Platform: Windows, DOS, UNIX, Linux

Tools: MSBI(SSIS, SSRS, SSAS), Shell, SAS Enterprise miner-14.1, Tableau, Power BI

Domain Expertise: Health Care, Banking, Insurance

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, North Carolina

Responsibilities:

• Experience using SQL Server database for creation of databases & stored procedures, MS SQL Server Analysis Service (SSAS) for creation of Cubes, Dimensions & MS SQL Server Integration Service (SSIS) for implementing ETL
• Gather specifications and requirements for the development/enhancement of HL7 data exchange.
• Develop web APIs to communitae health data using HL7 standards.
• Develop datawarehouse to store Electronic Medical/Health Records (EMR & HER) using MSBI tools such as SSIS
• Maintain the patient portal which access to their health records (CCD) and to ensure all the SLA’s are met
• Perform complex analysis and troubleshooting for various clinical and business applications and have a solid understanding of workflows
• Experience with HL7 (Health Level-7) standards
• Build the logic to accept the data from different vendors/clients in different HL7 formats (V2 & V3) and accept all the message types (ADT-A01, ADT-A04 etc)
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for secondary datasets
• Demonstrated ability to respond to internal and external customers’ business questions and/or requirements with succinct, accurate and timely informatics solutions with strong emphasis on a customer-centric final product.
• Participate in user meetings with management as a consultant to get a better understanding of user requirements and brainstorm improvement opportunities
• Expert in Managing the relation between Visualizations in Powe BI
• Created various database tables and procedures to update and clean the old data .
• Good at using Page level filters, Drill through filters and Report level filters in Power BI.
• Wrote various T-SQL queries, Stored Procedures and used them to build packages
• Created ETL process using SSIS Packages to populate data from various data sources
• Created packages using SSIS for Data Extraction from Flat Files, Excel Files, and OLE-DB to SQL Server
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder

Confidential, Dayton, Ohio

ETL Developer

Responsibilities:

• Work closely with business analysts to understand business requirements and deliver ETL / database solutions
• Responsible for Development and Maintenance of Revenue Cycle Business Intelligence Dashboard user SSRS/Power BI, that helps Health care providers to better manage their cash flow
• Hands on experience on developing, maintaining automation solutions using MSBI tools (SSIS, SSRS, SSAS) for Master Data Management (MDM)
• Creating user stories by interacting with highly demanding sales teams, proposing technical solutions, configurations and some basic on-need development activities
• Establish Master Data standards/procedures and matching rules
• Detail Design for application UI screens and views including application flows and business logic
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2
• Developed SSIS solution for developing a full-fledged data warehouse solution
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting
• Administered and enhanced SQL Server Integration Services (SSIS) data loads
• Created and Maintained Database Maintenance Plans
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created OLAP Dimensions, Measures and Cubes using SSAS.
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services (SSAS) and Power BI
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server
• Monitored Performance and Fine-Tuned the database objects and server to ensure efficient data retrieval

Confidential, Miami

ETL Developer

Responsibilities:

• Collaborate with developers, project managers and analysts in requirement gathering, testing and constructive feedback.
• Participate in user meetings with management as a consultant to get a better understanding of user requirements and brainstorm improvement opportunities
• Involved in dimensional modelling with Star &Snowflake schemas and created the Data Source Views Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues
• Involved in designing the physical databases model on SQL Server 2008R2 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing Constraints and Triggers for data integrity in development database
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity
• Collaborated with various business groups while developing their applications, assisting in Database design, creating E-R diagrams
• Wrote various T-SQL queries, Stored Procedures and used them to build packages
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables
• Implemented Performance tuning to optimize SQL queries using query analyzer
• Tested to optimize the procedures and triggers to be used in production
• Worked with Date/time manipulations in SQL Server built in functionalities as well as Data Integrator Date functions.
• Generated Parameterized/dropdown SSRS Reports
• Developed various charts/reports in Tableau which are not available in "Show Me " like Donut Chart, Alert Chart/Table, Lollipop Chart, Motion Chart, Population Pyramid, Waterfall Chart and many more.
• Create Parameterized SSRS Reports and ETL packages using SSAS Cubes
• Experience in creating XML files and XSD schema files.
• Conducted trainings on SQL 2008/2012 SSIS 2008/2012

Confidential

ETL Developer

Responsibilities:

• Created SSIS Packages to populate data from various data sources
• Created packages using SSIS for Data Extraction from Flat Files, Excel Files, and OLE-DB to SQL Server
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder
• Practice Kimball datawarehousing concepts for desgning developing and implementing the datawarehousing solutions
• Monitored Performance and Fine-Tuned the database objects and server to ensure efficient data retrieval
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports
• Implement the datacleansing system as per the guidelines in Kimball standards/framework
• Constructed Cubes based on data volumes mostly adhering to Star Schema
• Developed SSIS packages with Package Configurations
• Have implemented SCD type1, type2, and type 3 in SSIS Packages
• Developed a Tabular Reports, Ad-Hoc Reports using SSRS Report Designer