PROFESSIONAL SUMMARY:

• 8 years of IT experience in the Analysis, Design, Development, Administering, Implementing and testing Client/server application using Confidential SQL Server and BI suite in healthcare and other industries.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical management.
• Experience in creating complex SSIS packages using proper control and data flow elemen ts for complex data warehouse in SQL Server Integration Services (SSIS).
• Good Experience in creating Tabular and Multi - Dimensional modeling using star and snowflake schemas in SQL Server Analysis Services (SSAS).
• Expertise in creating various type of reports, Charts and dashboards using SQL Server Reporting Services (SSRS) .
• Experience in Creating MDX for querying in multidimensional cube and DAX formulas to create measures in SSAS.
• Experience in complex dashboards, reports and visualization on Tableau.
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Supported team in resolving SQL Reporting services and T-SQL related issues.
• Created ASP.net applications using C#, HTML, CSS, JavaScript.
• Experience in Hosting, configuring and managing ASP.NET applications through Internet Information Services (IIS).
• Automated SSIS Packages by generating batch scripts.
• Wrote Complex SQL queries for verifying data integrity in Dimension and Fact tables and created and have In-depth knowledge in various RDBMS concepts.
• Designed dimension and fact tables using Ralph Kimball methodology.
• Worked on complete Software life-cycle (SDLC) projects including Design, Analysis, Development, Quality Testing and deployment.
• Gained Intensive Knowledge in Medicaid, Food Stamps (SNAP), Cash (TANF), Child Care etc.
• Significant knowledge in Health Plan operations for Medicare like Membership, Enrollment, Providers, Part C and D Reporting, RAPS, PQRS, Health care EDI/CMS formats etc.
• Extensive subject matter expertise (SME) in Healthcare and good understanding of Healthcare models like HMOs, PPOs, ACOs and emerging trends.
• Worked on creating Technical Design Documentation (TDD) in many domains.
• Developed test plans, test cases and test scripts for Dimension and Fact Tables.
• Worked on taking backup and restoring the databases and having good knowledge on Disaster Recovery Scenarios.
• Experience in SSIS (SQL Server Integration Service) package design, constructing, and deployment.
• Hands-on working experience in populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Excellent in creating SSIS Packages from multiple sources Excel, CSV, flat file, Text Format Data by using multiple transformations provided by SSIS.
• Extensive knowledge of using System and User-Defined Variables, creating Property Expressions, Script Tasks for SSIS Packages.
• Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating SSIS Packages.
• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
• Wrote Complex Queries from the Control flow using SQL Execution Task.
• Used multiple Transformations like Aggregate, Conditional Split, Data Conversion, Derived Column, Lookup, Fuzzy Lookup, Merge, Multicast, Percentage Sampling, Slowly Changing Dimension, Pivot and UnPivot Transformations etc.
• Experience in creating automated administrative functions such as backing up and restoring databases, copying SQL Server databases and the objects they contain, copying SQL Server objects, and loading data using SSIS.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Confidential .NET framework for SSIS packages.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert and Data Replication in SQL Server Integration Services (SSIS).
• Expertise in merging data from various Heterogeneous Data sources.
• Experience in Administering SSIS packages such as Scheduling package execution, backing up and Restoring packages.
• Generated batch scripts to run SSIS Packages and Reports in Dev INT, INT and SIT Environment.
• Expertise in SQL Server Analysis Services (SSAS) CUBE design, development and deploying
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Experience in Creating, Modifying Cubes, Measures, Dimensions, Attribute relationships and Hierarchies.
• Expertise in Creating Perspectives, Partitions, KPI’s and Design Aggregations in cubes using SSAS.
• Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
• Created DAX formulas to create measures in SSAS
• Worked on OLAP Storage modes in dimension tables like ROLAP/ MOLAP/ HOLAP.
• Implemented Role based and user based subject selection.
• Worked on deploying SSAS package to different environments.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports using SQL Server Reporting Services (SSRS).
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Created various expression and complex calculations based on the required data in SSRS.
• Experience in creating dashboards, scorecards and building reports using performance point server 2007 and deployed the report in SharePoint 2013
• Good knowledge in RDBMS concepts, Data warehousing concepts, Data Modeling (Logical and Physical Design of Databases), OLTP & OLAP.
• Expert in all areas of SQL Server development including tables, user defined functions, views, Indexes, CTE (Common Table Expression), stored procedures, triggers, clustering, constraints,
• Good experience on Writing Transact SQL (T-SQL) Queries for implementing Stored Procedures, Functions, cursors and views.
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
• Good knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Created linked servers to retrieve the source data from different environments.
• Good Knowledge on OOPS (Object Oriented Programming Structure) Concepts.
• Created User Interface web forms using ASP.NET Framework 3.5 for Provider Quality Reporting System (PQRS) and House Calls Applications.
• Implemented business logic for above applications using C#.Net and developed .ASPX Pages using HTML, CSS and JavaScript
• Good Experience in accessing and storing data using OLEDB provider from the database.
• Hosted, Configured and managed ASP.NET web applications in Windows server 2008R2 using Internet Information system (IIS).
• Created a replica of Production Servers to create SNAT Servers by configuring IIS web Applications in Windows Server 2008R2/2003.
• Worked on taking backup and restoring the databases
• Good knowledge on Disaster Recovery Scenarios like Replication, Log shipping, Mirroring and clustering.
• Good Experience in Creating and Configuring Custom Objects, Custom Fields, Page Layouts and Custom Tabs as per the Client Requirements in Salesforce.com(SFDC)
• Good Knowledge on creating Reports, Roles, Profiles, Workflows in SFDC.
• Created Custom list Forms in InfoPath 2013 and Configured user related settings using SharePoint configuration manager.
• Performed Unit, Regression and User Acceptance testing for various modules in different environments.
• Created Technical Design Documents (TDD’s), Test Plans and checklist for generating reports
• Created Documentation for Use Cases and Test Cases in different domains.

TECHNICAL SKILLS:

Languages: SQL, Transact SQL, PL/SQL, XML, C, C#, HTML, CSS, JavaScript

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

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

ETL Tools: Business Intelligence Development Studio (BIDS)

Web technologies: ASP.Net, Silver light

Data Modeling Tools: Visio 2012

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

Operating Systems: Windows 2012/2008R2/2003, UNIX

Database Tools: SQL Server Management Studio, Oracle SQL Developer, DB Visualizer, SQL Server Query Analyzer, SQL Profiler

WORK EXPERIENCE:

Confidential, Harrisburg PA & Orlando FL

Sr. SQL BI Developer

Responsibilities:

• Designed 27 OLAP cubes using Multidimensional model in SSAS 2010.
• Created multiple dimension Tables and created hierarches and relationships for the attributes based on requirements.
• Created Measures from fact table and also Named Queries and Named Calculations for multiple dimension and fact tables in SSAS.
• Created Partitions and Aggregations in SSAS to improve the performance of the cube.
• Developed MDX Scripts to retrieve the data from SSAS analysis services Engine and to generate reports in SSRS 2010.
• Gained good experience in creating Roles with access level and assigning specific users or each role.
• Gained good knowledge in understanding in creation of KPI’s (Key Performance Indicators), Actions, Translations and Perspectives in SSAS cube design part.
• Good Understanding on Build, deploy and processing the cubes and also on storage modes like MOLAP, ROLAP and HOLAP in Dimension tables.
• Deployed the SSAS Packages from Dev Environment to SIT Environment.
• Created 64 ad hoc, Parameterized and custom reports in SSRS 2010 based on client requests
• Generated Sub Reports, Charts, Drill-through and Drill-Down Reports
• Created Cascading Parameters in reports using the different datasets.
• Designed and maintained Tableau 8.1 reports used to graphically analyze business data.
• Created Non-clustered indexes to enhance the performance of complex queries and views.
• Created Complex Expressions in Tablix and Matrix Reports based on business scenarios.
• Created SQL Jobs to retrieve the Performance Review Forms(PRF) information on daily basis using the SQL Server Agent
• Written and executed complex T-SQL queries for back end data validation testing.
• Created Complex Queries, Stored Procedures, Views and User Defined Functions according to the requirements.
• Tuned the queries which are running slow using the SQL Profiler and responsible for query performance tuning
• Generated the Technical Design Documents (TDD) based on the Business Requirement Document which specified the client requirements
• Generated batch scripts to run SSRS Reports in Dev INT, INT and SIT Environment
• Developed Test Plans, Test Cases, and Unit Test Check list for the Report generated in SSRS 2010.
• Involved in performing Unit Testing for the Dimension and Fact Tables for Different Modules
• Involved in Designing Data Flows, Work Flows and Test Scenarios for client Eligibility and Renewal Process
• Worked on assigned tasks, fixing issues and reported it to the testing department through Jira Issue Tracking tool.

Environment: Windows Server 2012, SQL Server 2012,Oracle SQL Developer 4.1, Confidential Business Intelligence Development Studio, Tableau 8.1, DB Visualizer 9.2.3,Excel 2010, Word 2010, Confidential Visio 2010,Jira-Issue Tracking tool, Jama 4.2.7, Tortoise SVN 1.8.4

Confidential, Hartford, CT

Sr. SQL 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 2008.
• 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 Scorecards and KPI’s in Performance Point to display provider performance.
• Created ad hoc and custom reports based on client requests using SSRS 2008.
• Created DAX formulas to create measures in SSAS 2008.
• Created performance point dashboards and deployed on SharePoint 2013.
• 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.

Confidential

Sr. SQL BI Developer

Responsibilities:

• Created SSIS packages to load the members data and its discharge information from Flat files to database tables
• Created variables and expressions in SSIS packages to deploy packages in different environments.
• Designed and created tables and views in order to display and update patient information.
• Involved in creating the Relational Database design.
• Created TSQL queries and stored procedures to convert Provider quality data in SQL tables to XML format.
• Created complex views to generate the Numerator and Denominator values for calculating Performance rate of each and every provider to generate SSRS reports.
• Created Non-Clustered Indexes to keep up the SQL Server Performance.
• Created adhoc and Parameterized Reports in SSRS to calculate the Performance of providers.
• Created ASP.Net application for providers to enter the services provided to their members.
• Created SQL jobs and SQL Mail Agent to copy the database on day-to-day basis.
• Performed Regression and User Acceptance testing to check the data accuracy.

Confidential

Sr. SQL BI Developer

Responsibilities:

• Performed ETL operations using SSIS 2008 to load the patient diagnosis information into database tables.
• Mapped the data in Flat file provided by Confidential 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 SSAS2008 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

Sr. SQL BI Developer

Responsibilities:

• Created ASP.Net application using C#, HTML, CSS and JavaScript to track the members (patients) information.
• Loaded Prefilled data into the designed tables provided by CMS.
• Created complex views and stored procedure to create datasets in SSRS for generating reports.
• Created expressions in matrix and cell based reports in SSRS 2008.
• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2013.
• Configured the Member information data in Excel 2013 to SharePoint 2013
• Created scripts to automate the SSRS reports and generate reports for all the providers assigned to Confidential .
• Hosted, configured and managed the ASP.Net web application in Windows server 2008R2 using Internet Information system (IIS).
• Involved in designing relational database.
• Performed Regression and User Acceptance testing to check the data accuracy.

Environment: Windows Server 2012/2008R2, SQL Server 2012/2008R2, Confidential Business Intelligence Development Studio, SharePoint 2013, Excel 2013/2010, Confidential Visio 2013. ASP.Net, C#, DHTML, SQL, TSQL, JavaScript.

Confidential, Dublin, CA

Sr. SQL BI Developer

Responsibilities:

• Worked on designing the database architecture for tracking the serialized products
• Actively involved in Normalization & De-normalization of database
• Performed ETL process using SSIS 2008 to transfer the source Information in excel and tables into different databases with proper mapping.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
• Created reports, dashboards, KPI’S and scorecards using Performance point server 2010.
• Good understanding of Data Marts, OLAP, Snow-Flake Modeling, Fact and Dimensions Tables .
• Created linked servers to retrieve the source data from different locations.
• Created complex Stored Procedures to validate and process the incoming data.
• Created Tables for Loading the Inventory, Patients, Locations, Transaction Information
• Enhancing and deploying the SSIS Packages into production environment.
• Created Stored Procedures using TSQL for generating Transferred Patient equipment’s data based on patient implant and explant status.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created views for retrieving data and generating cubes based on business requirements.
• Created SQL Server Jobs to Load the Transaction Information using the SQL Server Jobs.
• Wrote queries to validate the data in database tables and in Thoratec Connect portal.
• Performed Regression and user acceptance testing on Thoratec Connect portal and load the bugs in ‘Rally’ defect tracking system.

Environment: Windows Server 2008R2, SQL Server 2008R2, Confidential Business Intelligence Development Studio, Confidential Excel 2010, Confidential Word 2010,Rally ticketing system.

Confidential, Redmond, WA

BI Developer

Responsibilities:

• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Worked on Manipulating the SSIS Packages to change the existing process based on business requirements.
• Created views and stored procedures for removing Personal Identity Information (PII)
• Created cubes in SSAS using multi-dimensional model based on business requirements and also created measures.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Created Adhoc and Parameterised reporting in SSRS based on the business request.
• Responsible for updating ACL(Access control lists) by taking Backup and adding IP’s to whitelist for giving access to the agents around the world
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services .
• Worked in removing the PII (Personal Identity Information) of the clients by retrieving information from Database servers.
• Created SQL jobs for loading the user access information into tables on data-to-day basis.
• Created a replica of Production Servers to create SNAT Servers by configuring IIS web Applications in Windows Server 2008R2/2003.
• Responsible for handling over ‘Request for Change (RFC’s) ‘in Staging and Live of all INT, Training and Production Environments.
• Involved in taking Backup and Restoring the Database in 2008R2.

Environment: Windows Server 2008R2/2003, SQL Server 2008R2, Confidential Business Intelligence Development Studio, Confidential Excel 2007, Confidential Word 2007.

Confidential

BI Developer

Responsibilities:

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
• Experienced in creating complex SSIS packages using proper control and data flow elements.
• Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Generated Audit keys to capture the data information performed in SSIS.
• Responsible for gathering business requirements, developing and reviewing of design documents
• Created fact and dimension tables in data warehouse like Employee Dimension, Product Dimension and various fact tables using SSIS 2005.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS
• Migrated and recreated existing Dimensions and Cubes using Star schema to achieve the efficiency of SQL Server Analysis (SSAS).
• Created variables and expressions in SSIS to deploy package in staging and production environment.
• Created views and stored procedures to get the status information about the internal employees.
• Developed the Functional specification documentation for the modules to be developed.
• Generated Ad hoc Reports using SSRS for displaying the employees and the assigned product tracking.
• Worked on SSIS configuration and trouble-shooting.
• Involved in the designing, development, modification and enhancing the database structures and database objects.

Confidential

Sr. SQL BI Developer

Responsibilities:

• Involve in Agile Methodologies to produce high quality results
• Expertise in managing the existing SSIS Package and modified based on the business rules.
• Created views and stored procedures to create datasets in SQL Server reporting services (SSRS).
• Responsible to create customized reports in SSRS with different type of properties like Chart Controls, filters, interactive sorting, SQL Parameters.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Created Expressions to classify the different ranges in the reports generated in SSRS.
• Created tables for loading the device information and its status.
• Wrote complex queries to validate the data in different tables.
• Developed the Functional specification documentation for the modules to be developed.

Environment: Windows Server 2005/2003, SQL Server 2005, Visual Studio 2005, Confidential Excel 2007/2003, Confidential Word 2007/2003.

Confidential

SQL Programmer

Responsibilities:

• Involved in providing information to functional segments of the organization using Data marts.
• Involved in database design process and data modeling process using Confidential Visio 2003.
• Involved in creation of data modeling techniques.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Data Migration from the source files in Text and Excel format to SQL database.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Created clustered and non-clustered index in order to improve performance of tables.
• Built table relationships and wrote stored procedures to clean the existing data.
• Coordinated with the front-end developer to put in the business rules
• Generated test scripts to validate data in different tables.

Environment: Windows Server 2005, SQL Server 2005,, Confidential Excel 2003, Confidential Word 2003, Confidential Visio 2003,SalesForce.com