(Senior SQL Server SSIS/SSRS/SSAS, Data Warehouse ETL Developer)

PROFESSIONAL SUMMARY

More than 6 years of Excellent IT Experience in design, development and testing of business/commercial applications using MS SQL Server 2012/2008 R2/2008/2005/2000in healthcare, manufacturing and Retail industries.

Experience in Database Development, Modeling, Data Warehousing, Design and Technical Management. Good understanding of Normalization /De-normalization, Normal Form and database design methodology.

Experience in design of Data Warehouse Components like Data Marts.

Highly proficient in the use of T-SQL for developing complex creating Database, Tables, Indexes, Views, Triggers, Stored Procedure, User Defined Function, relational database models and data integrity, SQL joins and query writing.

Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting, DTS and Jobs.

Good Experience in various packages of SSIS, SSRS and SSAS designing, constructing and deployment.

Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Worked on Extracting, Transforming and Loading (ETL) process to load data from Excel, Flat file to MS SQL Server using SSIS.

ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.

Using SSRS, Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports, Cross-Tabbed Reports.

Extensively worked in SQL server Reporting services (SSRS) to create reports that draw content from a variety of data sources.

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Expertise in designing ad-hoc reporting for different level of end user using Report Builder 3.0.

Defined relationship between dimensions and measures groups, calculated slowly changing dimensions, KPI for different OLAP cubes.

Experience in creating KPI's, Aggregation, Perspectives in CUBE using SQL Analysis Services.

Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.

TECHNICAL SKILLS

Languages

SQL, T-SQL, C.

Databases

SQL Server 2012/2008R2/2008/2005/2000, Oracle 11g.

Reporting Tools

SQL Server Reporting Service (SSRS)

ETL Tools

SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Import Export Data, Bulk Copy Program (BCP).

OLAP Tools

SQL SERVER Analysis Services(SSAS)

Database Tools

SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Query Editor, Solution Explorer, Analysis Manager, Reporting Server, SQL profiler, SQL Mail.

Operating Systems

Windows 7/XP/2003/2000, Red hat Linux.

Design Tools

MS Office 2012/2010/2007/2003

EDUCATION:

Bachelor of Technology in Electronics & Communications Engineering

PROFESSIONAL EXPERIENCE

Project Name: Vendor Link

Client : Love’s Travel Stops, USA 07/2014 -09/2015

SQL Developer/SSRS/SSIS

ARC streamlines the way retailers gather, analyze, share, and act upon business data, by providing the power to automatically and seamlessly transform operational data into business intelligence. ARC is the reporting tool for retailers to take decisions and analysis of the business. The ARC product portfolio spans the entire spectrum of retail decision making with role-based, pre-built applications, and includes products for merchandising analytics, financial analytics, customer analytics, supplier portal & analytics, mall analytics and enterprise retail BI. These award winning products provide a significant edge to an organization's analytical capability and maturity, and are proven to deliver unmatched business benefits in a remarkably short timeframe. Manthan's experience spans a wide range of retail segments and formats, having transformed decision making for some of the biggest names in retail across the globe.

Responsibilities:

Involved in various stages of SDLC like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation

Creation, manipulation and supporting the SQL Server Database.

Created Stored Procedures, User-defined Functions to take care of back end validations when transferring data to Production Server.

Gathered user requirements. Responsible for Analysis and implementation for DB changes requested by users. Developing reports using efficient data retrieval techniques.

Used SSIS to create .dtsx packages to validate, extract, transform and load data from different source’s and mapped them onto destination.

Extracted data from different sources like Oracle, SQL Server, Flat Files, Teradata, and Composite View and transformed, loaded onto required database through SSIS.

Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.

Developed various operational Drill-through and Drill-down reports using SSRS.

Developed different kinds of reports such a Sub Reports and Charts, Matrix reports.

Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports, charts reports and linked reports using SSRS.

Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.

Developed Analysis Services Project. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.

Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.

Tools & Technologies:

MS SQL Server 2012, SQL server Reporting Services 2012, SQL Integration Services 2012, MS Visual Studio 2005/2008/2012, SQL Developer, Arc Application.

Project Name: ACO Implementation for Barnabas Healthcare

Client : Barnabas, NJ USA 03/2013 -07/2014

SQL Developer/SSRS/SSIS

Barnabas Healthcare with over 12000 members needed the ACO implementation for its Medicare Community. The IGI Orbit platform was implemented which enabled consent management, GPRO (Group Practice Reporting Option) reporting and beneficiary maintenance management. Analytics and predictive modeling also provided to Barnabas which help to analyze the Patient care.

Barnabas Health offers a broad depth and breadth of services and is one of the leading health care systems in the nation, receiving widespread recognition for clinical excellence and patient safety.

Responsibilities:

Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. using T-SQL 2008/2012 to store data and to maintain database efficiently.

Responsible for data analysis, loading data from Data feed to Data Warehouse tables.

Redesigning the ETL process from the existing legacy DTS packages into SSIS Packages.

The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column and For Each Loop.

Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server 2008 R2 Integration Services (SSIS).

Scheduled the ETL Package (Daily) Using SQL Server 2008 Management Studio.

Implemented Configurations, Logging, Checkpoints error handling.

Implemented the Master/Child Packages model so that only the master package has to be scheduled which will in turn fire the other packages.

Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports, charts reports and linked reports using SSRS.

Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.

Developed scorecard Dashboard and KPI’s indicators reports generated the Reports weekly and Monthly basis as per the Client Requirements.

Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.

Identified the dimension, fact tables dimension, fact tables and designed the data warehouse using star schemas.

Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.

Constructed Cubes based on data volumes mostly adhering to Star Schema.

Created ad-hoc reports using SQL server 2008 R2 Reporting Services (SSRS).

Tools & Technologies:

MS SQL Server 2012, SQL server Reporting Services 2012, SQL Integration Services 2012, MS Visual Studio 2005/2008/2012, SQL Developer,

Project Name: ADVantis ACO

Client : ADVANTAGE Health Solution Inc., NJ USA 03/2012 - 02/2013

SQL Server/SSIS/SSRS Developer

ADVANTAGE Health Solution (AHS) Inc. is network of community-owned health care system and their physicians. The system here includes modules like patient registration system, doctor scheduling, lab track system, discharge system billing system, and deposit system. It is a multi-user system with great search facility. It has a dynamic facility for adding the registration type for each patient. An advanced search facility has helped clients, patients and doctors to search their desired records easily.

Responsibilities:

Analyze the source map documents and creating packages to move the data from source to destination.

Creating packages for implementing ETL by using various control flow items for each loop, for loop and data Flow transformations execute SQL, conditional split, multicast, derived column, lookup, sort, union all etc.

Implemented the Master/Child Packages model so that only the master package has to be scheduled which will in turn fire the other packages.

Process the cube with analysis and ddl task’s in SSIS

Involved in Scheduling and deploying packages.

Develop Error Handling process for each SSIS Package.

As per requirements developed the reports in the form of Matrix, Table and Chart Using SQL Server 2008 Reporting Services.

Building parameterized reports and returning subsets of the data with query parameters, mapping report parameters to query parameters.

Prepared Unit Test cases as per the business logic.

Developed Cubes using SQL Analysis Services (SSAS)

Created multiple partitions on measure groups to improve cube performance.

As per requirements developed the reports in the form of Matrix, Table and Chart Using SQL Server 2008 Reporting Services.

Designed parameterized reports and returning subsets of the data with query parameters, mapping report parameters to query parameters.

Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.

Tools & Technologies:

MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL.

Project Name: Med Connect

Client : Trans Union 01/2011 -02/2012

SQL Server /SSIS/SSRS Developer

TransUnion Med Connect payer-provider portal offers a single, integrated solution for managing claims and encounter data. MedConnect combines best-in-class intelligence reporting with enhanced web-based functionality to offer a streamlined solution for trading partners.

Med Connect is one of many TransUnion Healthcare solutions that satisfy the unique needs of healthcare organizations. As a company dedicated to providing healthcare clients with intelligence in an instant, TransUnion Healthcare will continue to grow the Med Connect solution. To learn more about TransUnion Healthcare solutions, visit transunionhealthcare.com.

Revenue Cycle Transactions

Claims: CMS 1500, UB04

Encounters

Electronic attachments

Online error correction

Online auditing and tracking

Customizable reporting

4010/5010 transaction capabilities

New Features Coming Soon

Insurance eligibility and benefits verification

Claim status inquiry

Responsibilities:

Created/Updated database objects like tables, views, stored procedures, function, packages.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).

Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.

Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.

Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).

Involved in monitoring and tuning report performance by analyzing the execution plan of the report.

Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.

Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.

Automated and enhanced daily administrative tasks including database backup and recovery.

Helped create process logging and new monitoring tools, integrity reports, and mapping tools.

Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Tools & Technologies:

MS SQL Server 2008R2, T-SQL, SQL SSIS, SSRS, SSAS, BIDS, Windows server 2003 Visual Source

Project Name: TVS Automobile ETL Solution

Client : TVS & Sons, Madurai 08/2009-12/2010

SQL Server /SSIS/SSRS Developer

TVS_ETL was an application developed for TVS & Sons. The TVS Madurai had a complete manual process where the Source files are loaded into the 3rd Party applications or .NET application or Custom Component Interface to generate the AXAPTA formatted files. An ETL tool was developed so as to reduce this manual intervention. The complete application was developed on Micro Soft SSIS platform. In this project we are using database MSSQL and for Integration SSIS. We are doing complete automation of their current manual DPG(data processing group) activity and handling all three module (HONDA,ALCC,TASC) through SSIS its complete an ETL work, Incorporating with error handling log maintaining etc.

Responsibilities:

Analyzed the business requirement and functional specifications provided by the data specialist

Created packages in SSIS Designer using Control Flow Tasks and Data Flow Transformations to implement Business Rules.

Creation of mappings using transformation such as the Derived Column, Data Conversion and Conditional Split using data Flow Tasks.

Worked on control Flow Tasks like For Each Loop Container, Sequential Container, Executive SQL Task, File System Task and data Flow task.

Creating Logging to manage the packages information.

Worked on Send Mail Task to send the error records for particular recipient.

Implemented the Master/Child Packages model so that only the master package has to be scheduled which will in turn fire the other packages.

Scheduling the ETL Packages (Monthly & Daily) Using SQL Server 2008 Management Studio.

Responsible for creating Reports using SQL Server Reporting Services (SSRS) and created various types of reports like table, matrix and chart report, web reporting by customizing URL Access.

Created Cubes for reporting in SSAS as per the requirement along with calculated members and required hierarchies.

Automated CUBE processing through SSIS

Involved in Testing such as White Box Testing

Tools & Technologies:

MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL Analysis Services 2008,Microsoft Visual Studio, SQL Server Management Studio, MS Excel-SQL.

Contact this candidate