SUMMARY

• Over 8 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server 2014/2012/2008 R2/2005, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Visual Studio, SharePoint, Power BI, in various industries like Finance, and Healthcare.
• Strong technical knowledge in MS SQL Server development including SQL Server Integration Services(SSIS), DTS, MS SQL Server Analysis Services(SSAS), Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Expert in T - SQL. Strong technical knowledge in creating SQL Scripts, Stored procedures, Triggers, Indexes, Cursors, various constraints, views, function and variables.
• Experienced in SQL Server Integration Services (SSIS) package design and deployment
• Experienced in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools like DTS and SSIS Packages with proper control & data flow elements.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduling SSIS Packages.
• Experienced in using transformations like Aggregate, Lookup, Data conversion, Conditional Split, Merge Join.
• Developed SSAS Cubes, Aggregation, Calculation, KPIs, Measures, and deploying and Processing SSAS objects.
• Developed reports on SSAS & SSRS on SQL Server. Experienced with Parameterized, Custom Reporting using SSRS for daily reports.
• Experienced in logical, physical, and dimensional data modeling, data mapping, and data normalization, Proficient in creating Transact-SQL (DDL, DML, DCL and TCL), Indexes, Views, Table Variables, Complex Stored Procedures, User and System defined functions.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like Dashboards, Performance Point Server, Performed basic DBA activities.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables.
• Resolved SQL Reporting services and T-SQL issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experienced with the design and development of Tableau visualization solutions
• Created analytical reports and visualizations with Microsoft Excel 2013 Power BI tools (Power View, Power pivot and Mapping ) for exploratory analysis by data analysts
• Built Power View reports on a collaborative SharePoint 2013 environment.
• Experienced in creating indexed views, complex stored procedures, triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Extensive experience in Creating alerts for SQL Server Performance. Extensively worked on Active-Active and Active-Passive Clustering. Optimization and Maintenance tasks including Re-indexing, Updating Statistics, Shrinking Databases and Recompiling Stored Procedures.
• Extensive experience of Traces using SQL Profiler tool, Performance Monitoring& Tuning using Performance Monitoring Tool, Query Optimization, Client / Server Connectivity.
• Expert in creating weekly different types of reports like Tabular.
• Good Knowledge in ReportSubscriptions and Reporting Services Configuration Manager tool.
• Excellent knowledge of using variables and expressions in packages.

TECHNICAL SKILLS

• Microsoft SQL Server 2014/2012/2008 R2/2005
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• Oracle 10g/11g
• Teradata
• MS Excel
• MS Access
• Windows 2000/XP/7
• T-SQL
• DTS
• Performance Point
• MS Project
• Microsoft SharePoint 2007/2010/2013
• Power BI
• MS Team Foundation Server
• Tableau
• Oracle Business Intelligent Enterprise Edition

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

MS SQL Server BI Developer

Responsibilities:

• Created the package to import data from multiple sources to the staging environment.
• Deployed the packages on staging and production environment by copying the deployment folder into a target machine and proceeding to run the package installation wizard.
• Created SSIS packages using tasks like Sequence Container, Data Flow Task, Execute SQL Task, and Send Mail Task in Control Flow Task.
• Created specific packages, such as Email Notification in SQL Server 2008R2/2012.
• Upgraded packages from SQL Server 2008R2 to SQL Server 2012/2014.
• Performed data cleansing using various transformation components in SSIS and also cleared duplicate data using SSIS dataflow components.
• Developed the packages with multiple transformation components in SSIS like Conditional Split, Data Conversion, Lookup, Merge Join, Audit and Row Count.
• Created data mapping documents and designed multi- joins based on analyzing the requirement for populating the fact tables in the database.
• Performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Created variables and configuration files to make the package more dynamic and schedule jobs to run automatically using SQL server agent.
• Configured procedure constraints to send email messages if tasks in the package workflow succeed or fail, or send messages in response to an event that the package raises at run time.
• Used complex query statements like sub queries, Union All, Inner/Left/Right Join, Group By, CASE functions to insert the data depending on the criteria into the tables.
• Handled the exceptions with the help of SSIS by transferring the data into separate flat files or error tables.
• Created reports using SSRS and deployed them to the Report Server and Configured and maintained Report Manager.
• Modified existing report layout such as replacing the logo, adding parameters based on the requirements.
• Automated the Entire load processing for the weekly and monthly Process and created Report ranging from drill-down, drill through, Tabular, parameterized Reports.
• Modified existing queries as necessary to meet performance requirements.

Environment: MS SQL Server 2014/2012/2008 R2, Tableau, MS Visual Studio 2012, SQL Server Integration Services 2012, SQL Server Reporting Services 2012, SQL Server Analysis Services 2012, T-SQL, C# Script, Visual Studio,OLAP, Windows 7, SQL Profiler, Power BI.

Confidential, Brecksville, OH

MS SQL Server BI Developer

Responsibilities:

• Created the package to import data from multiple sources to the staging environment and to export data from the staging environment to the Data warehouse using SSIS.
• Deployed the packages on staging and production environment by copying the deployment folder into a target machine and proceeding to run the package installation wizard.
• Created SSIS packages using tasks like Data Flow Task, Execute SQL Task, and Expression Task in Control Flow Task.
• Performed data cleansing using various transformation components in SSIS and also cleared duplicate data using SSIS dataflow components.
• Developed the packages with multiple transformation components in SSIS like Conditional Split, Data Conversion, Lookup, Merge Join, Audit and Row Count.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created variables and configuration files to make the package more dynamic and schedule jobs to run automatically using SQL server agent.
• Handled the exceptions with the help of SSIS by transferring the data into separate flat file or error table and performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Configured the package to send email messages if tasks in the package workflow succeed or fail, or send messages in response to an event that the package raises at run time.
• Used complex query statements like sub queries, correlated queries, derived tables, Common Table Expression, CASE functions to insert the data depending on the criteria into the tables.
• Created reports using SSRS 2012 and deployed them to the Report Server and Configured and maintained Report Manager.
• Automated the Entire load processing for the weekly and monthly Process and created Report ranging from drill-down, drill through, Tabular, parameterized and Graphical Reports.
• Modified existing queries as necessary to meet performance requirements.

Environment: MS SQL Server 2014/2012, Tableau, MS Visual Studio 2012, SQL Server Integration Services 2012, SQL Server Reporting Services 2012, SQL Server Analysis Services 2012, T-SQL, C# Script, Visual Studio,OLAP, Windows 7, SQL Profiler, Power BI.

Confidential, Morristown, NJ

MS SQL Server BI Developer

Responsibilities:

• Created staging tables and SQL scripts to implement business logic loaded data from sources such as Relational tables, Flat files, MS SQL Server and DB2 tables to Data Warehouse and target tables.
• Worked closely with developers, end users and Administrator in designing database and gathered functional and business requirements and documented work.
• Schedule jobs to run automatically using SQL server agent and created variables and configured files to make the SSIS package more dynamic.
• Created email notification SQL task inside the package to send an email if tasks in the package workflow succeed or fail.
• Developed summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services.
• Performed performance tuning like sources, targets, mappings and SQL queries used in Source Qualifier to provide maximum efficiency.
• Performed Unit, Integration and Regression Testing of ETL jobs, applications and data in target tables and checked data integrity and any quality related problems.
• Organized the scorecards in creating objective KPI's at present, overall performance goals and group related KPI's under different score cards in Performance Point Dash Board designer.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Created Clustered and Non-Clustered Indexes for improved performance.
• Performed optimization of SQL queries in SQL Server.
• Implemented reporting packages involved Drilldown, Graphs, Sub reports, Shared Data sources, and parameterized reports.

Environment: MS SQL Server 2008R2, Visual Studio 2008, SSIS 2008, SSRS 2008, SQL Server Analysis Services 2008, T-SQL, Windows 7, SQL Analyzer, SQL Profiler, C# Script, MS Access and MS Excel.

Confidential, DENVER, CO

MS SQL BI Developer/SSIS/SSRS

Responsibilities:

• Created the package to import data from multiple sources to the staging environment and to export data from the staging environment to the Data warehouse using SSIS.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Responsible for migration of packages from SQL Server 2005 to SQL Server 2008 using SSIS.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created parameterized reports and ad-hoc reports using Report builder.
• Responsible for designing, creating and deploying the reports into the production server.
• Experienced in migration of data from various sources to SQL 2008.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Responsible for creating and implementation of data access stored procedures and triggers for automating tasks.
• Responsible for creating SQL Scripts, Complex stored procedures, Triggers, Indexes, Cursors, various constraints, views, function and variables.
• Reported data for different year and plotted a bar graph to compare the performance of the business.
• Created various geographical and time dimension reports of fiscal year, quarter, month, week and daily reports for all domains and published through ReportServer.

Environment: MS SQL Server 2008/2005, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Visual Studio 2008, SQL Server Management Studio, Power BI, Teradata

Confidential 

MS SQL Server Developer (SSIS, SSRS)

Responsibilities:

• Developed SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Responsible for creating SQL Scripts, Complex stored procedures, Triggers, Indexes, Cursors, various constraints, views, function and variables.
• Design, build and support real-time client reporting.
• Created parameterized reports and ad-hoc reports.
• Responsible for designing, creating and deploying the reports into the production server.
• Reported data for different year and plotted a bar graph to compare the performance of the business.
• Created various geographical and time dimension reports of fiscal year, quarter, month, week and daily reports for all domains and published through Report Server
• Created Report ranging from Snapshot, Cached, Ac hot, Sub Reports, drill-down, drill through, parameterized and Graphical Reports.
• Involved in Performance tuning and Query Optimization.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Scheduled jobs, alerts and designed and implemented user log in and security.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services 2008(SSRS), Analysis Services (SSAS), DTS.