SUMMARY

• Over 7+ years of experience in MS SQL Server 2016,2014, 2012, 2008, 2005 and 2000 in Production, Test, Development and Replication.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, Rules, Defaults, User Defined Functions, views, indexes, user profiles, Relational Database models, query writing and SQL joins.
• Expertise in Writing SQL Queries and Stored Procedures to validate the data
• Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
• Having Good knowledge of SQL server Integration Services, SQL server reporting Services and SQL server Analysis Services.
• Excellent report creation skills using Microsoft SQL Reporting Services (SSRS).
• Expertise in report generation (automating, managing and security of reports) using SQL Server Reporting Services (SSRS).
• Created, designed and deployed Tabular, Matrix, Chart, Drill-down and Ad-Hoc reports on report server.
• Expert in Performance Tuning, Handling Indexes, and Query Optimization
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations in the development of SSIS packages.
• Identified and resolved problems encountered during development and release of the SSIS code.
• Developed, Monitored and Deployed SSIS Packages from Development environment to Production environment.
• Developed ETL packages using SQL Server 2008/2012 Integration Services to populate data from different sources like flat files/CSV Files to Staging Databases. The packages include wide variety of transformations like Look Up, Aggregate, Derived Column, Conditional Split, Multi Cast and data conversion, Script tasks.
• Actively involved in different stages of Project Life Cycle.
• Participated in gathering Business Requirements and System specifications.
• Worked on script components is SSIS using VB.NET scripts and schedule Jobs and Alerts using SQL Server Agent.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations
• Experience in Deploying the created SSIS packages in Development and Testing environments.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas
• Expert in creating cubes and dimensions, handling multi-dimensional reports
• Generated the Reports with all the subcategory Information to Business users.
• Strong communication skills when working with stakeholders, developers, project managers, system implementers, and application end-users.
• Good team player, extremely adaptable and a fast learner.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), Teradata SQL Assistant

Reporting Tools: SSRS (2016/2014/ 2012/2008/2005/2000 ), MS Access, MS Excel,, Tableau DesktopDatabase: MS SQL Server 2012/2008/2005/2000 , MS Access, Oracle 11g/10g/9i

Programming: T-SQL, PL/SQL

Operating Systems: Windows 2003/2008 Server, Windows XP, Windows 7,Windows 8,Windows 10

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), ERWIN, Toad

Web Servers: Microsoft IIS, Apache, Apache Tomcat

PROFESSIONAL EXPERIENCE

Confidential, Detroit MI

Sr. MSBI/SSRS/SSIS Developer

Responsibilities:

• Involved in analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed automated scripts in T-SQL and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Created Tabular reports , Matrix reports , List & Chart reports , Parameterized reports , Sub reports , Ad-hoc reports , Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Experience in building BI applications in Cloud Environments Microsoft Azure .
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Formatted dashboards, multiple chart types, trends , and KPIs with Power View to support analyses.
• Developing a scalable architecture for staging and loading data using SQL Server database.
• Handled Multiple Projects at a time and successfully met several intersecting deadlines to yield Business Deliverables and conducted JAD and JAR sessions with Business and Other project stakeholders to understand the Business Requirement.
• Developed Tableau data visualization using Cross tabs , Heat maps , Box and Whisker charts , Scatter Plots , Geographic Map , Pie Charts and Bar Charts and Density Chart .
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS .
• Designing and implementing a variety of SSRS reports such as Parameterized , Drilldown , Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with dynamic sorting, defining data source and subtotals for the report.
• Created different types of reports such as Cross-Tab , Drill-down , Drill Through , OLAP and formatting them using both SSRS 2016 / 2014 .
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.
• Helped manage risk analysis and mitigation plans, status reports, and client presentations, defined milestone deliverables, and established critical success factors.
• Worked on Deployment of packages into Production servers and managed scheduled SQL jobs .
• Created stored procedures, Cursors, Joins in T-SQL .
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.

Environment: SQL Server 2016/2014/2012/2008 /2005 , SQL Server Reporting Services (SSRS), MS Excel, Team Explorer, Scheduler, Management Studio 2012,Visual Studio 2012, SQL Server Integration Services (SSIS) 2014/2012/2005 , Business Intelligence Sprint, BI Scrum.

Confidential - Charlotte, NC

MSBI/SSRS/SSIS Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions , stored procedures and triggers .
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Created SQL scripts for tuning and scheduling. Performed data conversion from flat file into normalized data structure.
• Written with Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2012 / 2014 .
• 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.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula Writing/editing in reports, Report Administration and performance tuning of reports.
• Created and modified SQL*Plus , PL / SQL and SQL*Loader scripts for data conversions.
• Wrote SQL , PL / SQL , SQL*Plus programs required to retrieve data using cursors and exception handling and Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Develop complex MDX (Multidimensional Expressions) , Stored procedures, Function table and views to generate various Drill-through, Drill-down reports, with Dynamic grouping capability, Parameterized dynamic Dashboard/Scorecard and link and pass the selected parameter values it to its sub-reports using SSRS.
• Performed Negative testing and Out- of- box scenario testing based on BRD (Business requirement document) and FRD (functional requirement document).
• Installation, Upgrade and Migration of SQL Server 2014, 2012 2008 R2 and 2008
• Worked on XML along with PL / SQL to develop and modify web forms.
• Developed and optimized Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and User Defined Functions.
• Ensure database integrity, indexing, segmentation and recovery and update database design over time.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Developing various reports - Drill Down, Cascading, Drill through, Parameterized, Sub-reports and Charts using Global Variables, Expressions and Functions using SSRS .
• Deployed and generated reports on to the server using the Reporting Services Report Manager .
• Performed DBA functions, installing, configuring and supporting SQL Server based database systems.

Environment: SQL Server 2016/2014/2012/2008 R2/2008/2005Windows Server XP/NT2008, Microsoft Reporting Services, Toad, T-SQL, Oracle 10g, Visual Source save (VSS), WIN NT, Erwin and SQL Server Integration Services.

Confidential - Waltham, MA

MSBI/SQL Developer

Responsibilities:

• Created and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and technical specifications.
• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Wrote different T-SQL scripts for automated execution of the tasks.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Extensively used SSIS to move data from heterogeneous data sources Oracle and SQL Server 2008 to SQL Server 2012 .
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup , Term Extraction, Pivot, Multi-Cast, Derived Column, Audit and Data Conversion etc .
• Worked with different Control Flow elements like For Loop Container, For each Loop Container etc.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS .
• Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files.
• Responsible for creating and maintaining the documentation for implementation and for future changes.
• Used different transformations ( Derived Column, Data Conversion, Condition Split, Lookup transformation, multicast, and script component transformation ) under Data Flow Task while pulling and loading data from one source to another source to makes the data clean and consistent.
• Creating Indexes and used Scan and Seeks for performance tuning .
• Created subscriptions to provide a Daily / Monthly / Quarterly basis reports.
• Involved in performance tuning of T-SQL queries and Stored Procedure .
• Formatted the report layout for the requirement of the end users.
• Created indexes on selective columns of patient records for the faster retrieval of data in SQL Server Management Studio .

Environment: MS SQL-Server 2012/2008, MS Visual Studio 2012/2008, Erwin, SQL Server Management Studio, SSIS, SSRS, SSAS,, C#, Windows 2008 R2 Server, MS Access, T-SQL, MDX, DTS.

Confidential, New York, NY

MSBI/SQL Developer

Responsibilities:

• Worked with business stakeholders, application developers, and productions teams and across functional units to identify business needs and discuss solution options
• Gathered requirements from business users
• Actively participated in interaction with users and technical managers to understand the requirements of the system
• Monitored the data ware house structure and developed it using the Erwin tool
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and Materialized views for remote instances.
• Providing solutions to improve the existing processes and production support for various batch processes and also Created the schedule for newly incorporated batch programs and processes.
• Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports , Cross Tab Reports , Sub Reports .
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container , Execute Package task , Execute SQL Task , Sent Mail task , Lookup , Fuzzy Lookup , Derived Columns , Condition Split , CDC Control Task , CDC Splitter, CDC Source and Slowly Changing Dimension .
• Implemented Event Handlers and Error Handling in SSIS packages
• Involved in Production support with Deployment of the SSIS Packages and schedule SSIS packages using SQL Server Agent Job.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete
• 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.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Created indexes both non-clustered and clustered indexes in order to maximize the query performance.
• Modified queries and stored procedures to improve the performance.
• Created and maintained versions of SQL Scripts for Tables, Indexes, Constraints , and Views etc. for the entire project.
• Built effective queries for high-performance reporting and rendered them to HTML , XML , PDF and Excel format using SSRS .
• Designed different kinds of reports like Linked , Cascaded and Parameterized Reports and Worked on Drill Down and Drill-through Reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS .
• Performed data transfers using BCP and BULK INSERT utilities.
• Wrote stored procedures for report generation in SQL Server 2008 .
• Performed performance tuning by studying Execution Plan, Analyzing Indexes.
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.

Environment: MS SQL Server 2008, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer