Summary:

• Over 7 years of IT experience in the design, analysis, implementation and administration of business intelligence solutions with different versions of Microsoft SQL server in the development, testing and production environment.
• Excellent hands-on experience with data modeling that includes the conceptual, logical and physical design of databases.
• Extensive experience in T-SQL programming in creating and using Stored Procedures, Triggers, Functions and complex queries on various versions of SQL server.
• Experience in creating Indexes for faster performance and Views for controlling user access to data.
• Experience in migrating databases from heterogeneous sources like Excel, Oracle, CSV files, and Flat files into SQL Server destination.
• Strong understanding of Data Warehouse, dimensions, hierarchies, facts in designing multi-dimensional schema with Slowly Changing Dimensions transformation.
• Expertise in the designing, developing and deploying SSIS packages using various control flow tasks and data flow transformations like conditional split, derived column, look up, merge, sort etc.
• Experience in Error and Event Handling using Precedence Constraints, Break Points, Check Points and Logging.
• Well versed with migrating crystal reports to SSRS reports.
• Expertise in creating Ad-hoc, Cascading Parameterized and Parameterized reports involving Drill down, Drill through features with Matrix, Chart and Sub reports using SSRS.
• Excellent knowledge in the cube development, partition, aggregation and optimization using SSAS.
• Excellent knowledge in implementing MDX queries in accessing cubes, and partition of cubes in OLAP.
• Good experience in creating Pivot Tables and Charts in Excel using data sources like SQL Server, MS Access and Power pivot.
• Good knowledge on Power BI features such as Power view for reports in Share Point, and Power Pivot for data models.
• Experience in Full Software Development Life Cycle SDLC including Analysis, Design and Review of Business and Software Requirement Specifications Development, Testing as per Agile software development methodology.
• Proficient in using SQL Server Profiler for monitoring the performance of an instance of the SQL Server Database Engine, Analysis Server and Integration Services.
• Extensive knowledge in creating dashboards, scorecards involving KPIs using MS Share Point.
• Exceptional versatility and adaptability, extremely diligent having excellent communication skills and ability to work both as individual and as a team member.

Skillset:

MS SQL Server 2012/2008R2/2008/2005, Visual Studio, Business Intelligence Development Studio, SQL Server Management Studio, SSIS, SSRS, SSAS, Share Point, Power BI, Power Pivot, SQLCMD, SQL Server Dashboard, Data Quality Services, Master Data Services, T-SQL, MySQL, C , VB.NET,C .NET, HTML, XML, JavaScript, Business Objects, Oracle 10g/9i, QNTX, EPIC, MS Office Suite.

Projects Summary:

Confidential

Confidential is a health organization that comprises of health plans, medical clinics and a health information management solution. The project involved the creation of new SSIS packages, modification of the existing packages and documenting them pertaining to the fee schedules of different states.

Responsibilities:

• Designed and created SSIS packages to extract, transform and load data from Excel and Text to SQL Server destination using various complicated transformations like conditional split, derived column, and data conversion for fee schedules from the existing QNTX database.
• Created SSIS packages to extract data from OLAP systems and scheduled jobs to call the packages and stored procedures and modified the existing SSIS packages to meet the changes specified by the users.
• Used various data flow transformations like conditional split, look up, derived column etc. in creating SSIS packages.
• Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.
• Involved in performance tuning for new databases and existing databases by using SQL profiler.
• Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS.
• Involved in error handling, creating package configuration and log details using SSIS logging.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report services SSRS .
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Created Alerts for successful and unsuccessful completion of scheduled jobs.
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Involved in troubleshooting, enhancing and creating new ones of claims retro report templates.

Environment: MS SQL Server 2008R2, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Business Intelligence Development Studio, Visual Studio 2010, Windows XP, SQL Server Profiler, SQL Server Management Studio, Excel, TFS.

Confidential

MS SQL Server/SSIS/SSRS Developer

Confidential comprises of 4 hospitals in which they are implementing Confidential electronic medical record software in all Oakwood hospitals. The project involved all the phases of report development, consultation and analysis of business requirements related to EPIC database and provided internal and customer support for the issues related to health insurance claims to the end users.

Responsibilities:

• Configured and installed SQL Server 2012 on Windows Server and migrated databases from different databases like Cache, Chronicles of EPIC to MS SQL Server 2012.
• Used Agile software development methodology in defining the problem, gathering requirements, development iterations, business modeling and communicating with the technical team of EPIC for the development of the system.
• Designed and created different ETL packages using SSIS from Oracle source, Excel, CSV Files, Text files, MS Access to SQL server as destination.
• Designed and provided Ad-hoc and Parameterized clinical reports using SSRS in SQL Server Data Tools for the internal use and client presentation.
• Created Subscriptions for the users to deliver the reports in a timely manner.
• Implemented Power view for the visualization of reports.
• Designed and maintained a web reporting environment including portal, dashboards and scorecards for the Insurance Claims using Share Point.
• Created Pivot tables in excel using data from various sources like SSRS and MS Access.
• Diagnosing and tuning the server and query optimal performance using SQL Server Profiler and Database Tuning Wizard.
• Created indexes on selective columns of patient records for the faster retrieval of data in SQL Server Management Studio.
• The evaluation of database performance and maintenance duties such as tuning, backup, restoration are performed by scheduling jobs using SQL Server Job Agent.

Environment: MS SQL Server 2012, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , SQL Server Data Tools, SQL Server Migration Assistant, Windows XP, SQL Server Profiler, SQL Server Management Studio, EPIC, TFS.

Confidential

MS SQL Server/SSIS/SSRS Developer

Confidential is a Health Organization that provides the most advanced and comprehensive healthcare with their branches in different places in New York. The aim of the project was to design, develop, implement and maintain EPIC database and provide executive operational decision support system using SSIS and SSRS.

Responsibilities:

• Involved in planning, defining and designing database based on business requirements.
• Created T-SQL queries, views, stored procedures and functions for faster retrieval of data and to display specific information.
• Involved in the design of Cancer data warehouse to integrate between the operational data base and medical files and therefore the analysis on data makes easy by using OLAP cubes and viewing multilevel of details from the data.
• Involved in the Population health intelligence platform to access clinical data from multiple sources in order to load into a data warehouse.
• Created ETL package for integrating data from heterogeneous sources like Excel, CSV, Flat file Text Format Data and applied various data transformation like slowly changing dimension, sort and multicast.
• Designed, developed and deployed Summarized, Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio BIDS as per client requirements.
• Involved in Full Software Development Life Cycle SDLC including Analysis, Design and Review of Business and Software Requirement Specifications Development, Testing as per Agile software development methodology.
• Scheduled the monthly, weekly and daily reports to run automatically onto the dashboard and configured the report viewing security for various users at various levels using report manager.
• Migrated crystal reports to SSRS reports using crystal report migration services.

Environment: MS SQL Server 2008 R2, T-SQL, SQL Server Reporting Services SSRS , SQL Server Integrating Services SSIS , Oracle 10g, Crystal Reports, Access, Excel, SQL Server Management Studio, Business Intelligence Development Studio BIDS , EPIC.

Confidential

MS SQL Developer/BI Developer

Confidential a commercial bank that operates its branch network and non-branch retail and commercial offices in about 40 states. The aim of the project was to analyze historical data and integrate data from different data sources to identify trends and to prepare in-depth reports using SSRS.

Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes for large scale Data Ware houses using SSIS.
• Created ETL packages to extract, transform and load data to data warehouse databases.
• Designed and developed SSIS packages and dynamically deployed them into Development, Testing and Production Environments using Package configuration.
• Used various SSIS transformations such as conditional split, derived column and look up for data scrubbing and data validation checks before loading the data into Data Warehouse.
• Used various data transformations in SSIS including importing data from files, moving data from one database platform to another, and building star schema data marts from OLTP.
• Used Bulk copy program BCP to import and export data in and out of tables into data files.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Creating Tabular, Matrix reports, Charts and graphs as per customer requirements using SSRS.
• Created a number of cubes, dimensions with business critical KPIs using SSAS.
• Involved in analyzing, designing, building testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Developed wind forms using C and .net.

Environment: Windows XP, MS SQL Server 2008 R2, Business Intelligence Development Studio, MS SQL Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, BCP,.Net, C .

Confidential

MS SQL SSIS/SSRS Developer

Confidential world's leading enterprise for business process and document management that provides document management solutions. The main objective of the project was to design and develop reports to analyze the sales and production growth of organization using SSRS.

Responsibilities:

• Wrote complex queries, stored procedures, functions and views to ensure data integrity, data consistency and to meet the business rules.
• Created SSIS packages to extract data from text files, Oracle, XML to SQL server.
• Used event handlers to capture the run time error messages by using send mail tasks in the background upon success or failure of a package in SSIS, carried out scheduling and administering of SSIS packages.
• Created and developed queries for Drill down and Ad-hoc reports using SSRS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports.
• Involved in deploying and executing SSIS packages and reports from development server to production server.
• Used Visual Source Safe to track the versions of the entire project.

Environment: MS SQL Server 2008, SSIS, SSRS, SQL Server Management Studio, MS Excel, T-SQL.

Confidential

MS SQL Server/SSIS Developer

Confidential is a financial services company. Through its subsidiaries and affiliates, the Company offers an array of financial products and services, including life insurance, annuities, retirement-related services, mutual funds and investment management. The aim of the project was to develop ETL packages using SSIS and the maintenance of the database system.

Responsibilities:

• Created Logical and Physical data models using ER-Win data modeling tool.
• Developed complex Functions, Tables, Views, Indexes and joins for applications.
• Involved in writing stored procedures to parse the full name and split it into First Name, Middle Name, and Last Name based on the business rules.
• Created Triggers to enforce data and referential integrity.
• Created views for the users according to their roles.
• Developed ETL specifications, data mapping and other documentation required for ETL development.
• Created ETL packages by extracting data from heterogeneous sources like Excel, Text files into SQL Server using SSIS.
• Scheduled jobs and alerts using SQL server job agent.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, SSIS, BIDS, SQL Server Management Studio, T-SQL, ER-Win