SUMMARY

• 5 years of IT experience in the Analysis, Design, Development, Administering, Implementing and testing Client/server application using Microsoft SQL Server and BI suite in healthcare and other industries.
• Experience in creating complex SSIS packages using proper control and data flow elements for complex data warehouse.
• Worked on tuning SSIS packages and SQL queries.
• In - depth knowledge of, SSAS, SSRS, SSIS, Reporting and Analytics.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical management.
• Significant knowledge in Health Plan operations like Membership, Enrollment, Providers, Claims, Part A and B Reporting, Health care EDI/CMS formats and Healthcare models like HMOs, PPOs, ACOs and emerging trends.
• Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
• Designed dimension and fact tables using Ralph Kimball methodology.
• Worked in Tabular and Multi-Dimensional modeling, creating star and snowflake schemas in SSAS.
• Created DAX formulas to create measures in SSAS.
• Created Variables and Expressions in SSIS in order to deploy packages from staging to production environment.
• Wrote SQL queries for verifying data integrity in Dimension and Fact tables.
• Excellent in Data Extraction, Transforming and Loading (ETL) Using SSIS, DTS, Bulk Insert and BCP.
• Expert in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models using SSRS based on client requirement.

TECHNICAL SKILLS

Languages: SQL, Transact SQL, PL/SQL, C#, HTML

Databases: Oracle, SQL Server 2012/2008R2, MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Performance Point Server 2007.

ETL Tools: Business Intelligence Development Studio (BIDS)

Web technologies: ASP.Net, Silver light

Data Modeling Tools: Visio 2012

Other Software: MS Office- 2012/2007/2003 , MS Excel- 2012/2007/2003 , Adobe Professional.

Operating Systems: Windows server 2012/2008R2/2003

Database Tools: SQL Server Management Studio, SQL Server Query Analyzer,, SQL Profiler, Oracle 11g

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

Sr. DW/BI Developer

Responsibilities:

• Created Extract, Transform and Load (ETL) packages using SSIS to load source data provided by Center for Medicare and Medicaid Services (CMS) from flat files to database tables.
• Created various fact and dimension tables in data warehouse like Member Dimension, Provider Dimension, Assignment Fact, Enrollment Fact tables using SSIS 2012.
• Developed slowly changing dimension SCD-Type2 in SSIS to update the old data in dimension tables when the new source data is loaded.
• Created complex views in order to build tabular models in SSAS.
• Built tabular models in SSAS. Defined measures, created hierarchies and deployed cubes.
• Created reports in Performance Point using cubes created in SSAS as per BRD’s.
• Created ad hoc and custom reports based on client requests using SSRS 2008.
• Created performance point dashboards and deployed on SharePoint 2013.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy lookups using SSIS tasks.
• Experience in performing Unit Testing, Regression Testing on Member Dimension, Provider Dimension Assignment Fact and Enrollment Fact tables by writing SQL Queries.
• Developed Test Plans, Test Cases, and Test Scripts for creating Member Dimension, Provider Dimension, Assignment Fact and Enrollment Fact Tables.
• Generated batch scripts to run SSIS Packages.
• Creating various types of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Mapped the data in Flat file provided by ACO to requirement document and loaded into tables using SSIS.
• Performed data archiving when the SSIS packages runs the second set of data.
• Created OLAP cubes in SSAS2012 using tabular model.
• Designed and created tables and views in order to display and update patient information.
• Created views and stored procedures to display data in Patient Management Application.
• Designed the Relational Database.
• Performed full backup and restoring of the databases to protect data from data lost.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Performed Regression and User Acceptance testing to check the data accuracy.

Confidential

Jr. Database Developer

Responsibilities:

• Analyzed data and prepared analysis documentation.
• Created fact and dimension tables for data warehouse like Member Dimension, Provider Dimension, Date dimension, Assignment Fact, Enrollment Fact tables.
• Designed logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Defined constraints, rules, indexes and views based on business requirements.
• Created SSIS Packages using Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, and CSV files.
• Created SSIS package for follow up hospitalization details and created Access Form to view and update patient details keeping all the tables in the SQL Server.
• Created mirth channel to read HL7 message and import to SQL Server table.

Confidential

Jr. Database Developer

Responsibilities:

• Worked with non-technical colleagues and provide them SQL 2008 queries and store procedures to make their task easy and less time consuming.
• Created complex SQL join queries, views, and store procedures.
• Write Stored Procedures, ad hoc queries, join operations, dynamic SQL to extract the data in smoother and quicker manner out of Database.
• Used SSIS to process the text file data into Database and clean up the file system folders for next day's processing.
• Created SSIS Packages that Transfers Databases from One SQL Server instance to Another Instance
• Worked on data cleansing techniques using look-ups, conditional split, and fuzzy lookup.
• Provided efficient error handling to SSIS packages.
• Prepared the reports using SSRS 2008 from scratch.
• Created parameterized, drill down reports and Changed old reports as per requirements using SSRS 2008.