SUMMARY

• Over 5+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 R2/2005 in Development, Test and Production Environments with various business domains like healthcare, financial, retail and manufacturing.
• Expertise in writing T - SQL Queries using joins, Sub queries and Cursors in MS SQL Server 2014/2012/2008 R2/2005.
• Hands on experience on various SQL Server Services like Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Experience in .NET and SQL Server with Development, Build and Deployment and Production Support.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Expertise in complex SQL joins, data cleansing, data extracting, data migration and data integration.
• Used different Transformations for aggregating, filtering, joining and sorting the business data.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and extracts.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Expertise in designing and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Expertise in report writing according to the business requirement in SSRS.
• Expert in creating SQL Server Reports using SSRS 2014/2012/2008 in designing stylish report layout parameterized, performance, Chart Reports, ad-hoc reports.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Experience in different type of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports.
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables, and Physical and Logical data modeling.
• Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Strong analytical, administration and problem solving skills dedicated to maintain the high quality standards. Good communication skills, ability to work independently.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#,ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: Oracle, MS SQL Server 2014,2012,2008R2,2008,2005

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Informatica, Visual Studio, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball &Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, Microsoft Office(MS), Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Greene, NY

MS SQL/MSBI Developer

Responsibilities:

• Creating tables, indexes and designing constraints.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Responsible for identifying and defining Data Source and Data Source views.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service.
• Deployed all the reports to reporting server, SharePoint, Excel & PDF as informed by management.
• Provided documentation support on SSRS 2014/2012 as assigned.
• Developed Charts, Pie-Charts, Bar-graphs series on SSRS.
• Expertise in dealing with primary control for Tablix reports.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008r2/2012.
• Used Tableau to visually analyze data and create concise and actionable dashboards.
• Combine data sources by joining multiple tables and using data blending.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Involved in creating calculated members, named set, advanced KPI’s for theSSAScubes.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Created Logins, Scheduling Jobs.
• Performance Tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, cte’s, redesigning schemas and many more.
• Also, went through query execution plans, sql profilers and did query optimization.
• DDL Scripts for generating Tables, Views, Functions.
• Created indexes, Constraints and rules on database objects.
• Transformed the complex business logic and calculations into coding.
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database

Environment: SQL server 2014/2012/2008 R2, Windows Server 2012/2008R2 Enterprise Edition, Tableau, SSRS, SSIS, SSAS, SSMS, T-SQL, SQL Profiler, SQL Server Agent, VSS, SQL Diagnostic Manager.

Confidential, Stratford, CT

MS SQL/BI Developer

Responsibilities:

• Responsible for working with in-house development staff and functional analysts to review code and integrate SQL Reports with Oracle Systems using Web Services.
• Created and modified stored procedures, tables, views, indexes on various databases for critical data involving profit and loss, net revenue, forecasting etc.
• Tuned queries, T-SQL stored procedures to enhance the performance of applications.
• Created various reports using SSRS (Drill Down, Matrix, Sub reports and Navigating), Crystal Reports 10 and converted existing crystal reports to SSRS reports.
• Experience with the design and development of Tableau visualization solutions.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports in Tableau.
• Created and maintained SSIS and DTS packages and used most of the tools in SSIS like looping, data formatting, error handling, email notification, web service task.
• Developed SSIS packages to extract/transform data, developed Business Intelligence.
• Utilized extensively SSIS packages functionality to create and complete ETL process using scripts, stored procedures, functions, transformation of data.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services(SSAS).
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from dataset using SQL Server Analysis Services(SSAS).
• Experience in creating Multidimensional cubes with SSAS and designing DW Schemas.
• Worked on Clustered and Linked server environments.
• Used TFS (Team Foundation Server) for project management and source control.
• Created and modified custom applications using VB script and ASP.net.
• Deployed SSIS packages on the Production Servers and monitored the SQL Agent jobs, SQL logs, Application logs. Provided 24*7 production supports on shift basis.
• Worked with Network team on SAN to pull the dated backup and reload that on development database to test the application functionality.

Environment: SQL Server 2012/2008R2/2005, SSRS, SSIS, SSAS, SSMS, DTS, TFS, T-SQL, SQL Profiler, SQL Server Agent, SQL API, Tableau, Crystal Reports 10, VB Script, Windows XP, MS Access 97/2003, ASP.net 3.5, XML, Microsoft Office SharePoint Services (MOSS).

Confidential, Moline, IL

SQL Server/SSIS, SSRS and SSAS Developer

Responsibilities:

• Managed Tables, Views, cursors and optimizing queries using execution plan for tuning the database.
• Used Recursive CTEs while creating multiple complex stored procedures for various purposes like database maintenance, index maintenance.
• Created checkpoints and configuration files in SSIS packages.
• Implemented slowly changing dimension in SSIS packages.
• Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform and worked on Change Data Capture.
• Used SQL Server Reporting services to write complex formulas and to query database to generate different types of reports (Drill Down, Drill Through, Linked, Sub-reports, and Parameterized) for Business Intelligence.
• Created various formats of reports such as Tabular, Matrix, Charts reports to evaluate the aggregated data while using Global Variables and Expressions.
• Deployed Reports onto common server to make it accessible for the management team and application development team.
• Responsible for scheduling the Subscription of the reports with the Subscription Report Wizard and creating Snapshots of the report as per requirement. Also, implemented Security to the reports using Report Manager.
• Defining relationships betweenDimensionsandMeasure groups. Involved in the design and development of the SSAS cubes andMDXqueries.
• Developed OLAP model based on Dimension and Facts for efficient loads of data mainly based on Star Schema and Snowflake Schema.
• Held responsibility for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX queries, Perspectives and KPI’s.

Environment: MS SQL Server 2008R2/2008, SSMS, SSIS, SSRS, SSAS, Windows 2003 server, DTS, SQL Query Analyzer, SQL profiler, Crystal Reports, Visual Studio 2005.

Confidential

MS SQL / BI Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
• Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.
• Designed and developed custom .NET components and user controls using ASP.NET.
• Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQL Server 2005, 2008Integration services.
• Involved inrelational database modelinglike, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis,file-transfersfrom one location to other.
• Created complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage config files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to thelocal DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.

Environment: MS SQL Server 2008 R2, T-SQL, SSIS.

Confidential

Jr SQL Server Developer

Responsibilities:

• Interacted with Team in analysis, design and develop database using ER Diagram, involved in design, development and testing of the system.
• Developed SQL Server Stored Procedures, tuned SQL queries (using indexes ).
• Created views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling.
• Creating and automating the regular jobs.
• Involved in performing database backup and recovery.
• Worked on documentation using MS word.

Environment: MS SQL Server 2008 R2, T-SQL, SSIS.