SUMMARY

• Over 8.5 Years of experience SQL Server BI Developer in Production, Development and Test Environment. Excellent experience in SQL Server Programming (T - SQL), Integration services (SSIS), Analysis Services, Notification Services and Reporting services (SSRS) in SQL 2005/2008 R2/2012.
• Expert in Tableau 8.x/9.x (Desktop, Server, Mobile, Public), Tableau Desktop, Tableau Reader and Tableau Server and Experience including analysis, modeling, design, and development of Tableau reports and dashboards for analytics
• Experience in generating ad hoc reports in Experience in MS SQL Reporting Services (SSRS). Generated tabular, matrix, drilldown, Drill through, summary Reports, sub reports, detailed reports, Parameterized and linked reports using SSRS.
• Developed several ad-hoc reports in Report Builder 3.0 for according to the customer requirement
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Migrated SSRS reports from SQL Server 2008 r2 to SQL Server 2016
• Experience in writing SQL Loader scripts for Extract, Transformation and Loading of Data.
• Experience in data Extraction, Transformation and Loading (ETL) processes.
• Familiarity in designing reports using SQL Server Reporting Services (SSRS) based on Report Models which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Familiarity in Data Modeling, Star Join Schema/Snowflake Modeling, FACT & Dimensions tables
• Experience in getting the requirements from business analysts for generating SSRS Reports.
• Experienced in different team projects with good project implementation experience, Team Skills, Troubleshooting, Presentation and Issue Resolution capabilities.
• Experience in Data Warehouse Development environment using Microsoft SSIS, SSAS and SSRS.
• Expert in Creating Views, Complex Triggers, effective Functions and appropriate stored procedures to facilitate efficient data manipulation and data consistency.
• Experience in writing SQL Loader scripts for Extract, Transformation and Loading of Data.
• Experience in data Extraction, Transformation and Loading (ETL) processes. Worked extensively on data extraction, cleansing and data integration, and loading from different data sources using SSIS.
• Very good experience in designing, development and deployment of SSIS packages.
• Designed SSIS Packages to Extract, Transform and Load data into Database, Archive data file from different legacy systems using SSMS on SQL Server 2005/2008/2012 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
• Experience in MS SQL Reporting Services (SSRS). Generated tabular, matrix, drilldown, Drill through, summary Reports, sub reports, detailed reports, Parameterized and linked reports using SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Developed Cubes using SQL Analysis Services (SSAS).
• Familiarity in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Very good exposure to Data Modeling including Dimensional Data Modeling, Star Join Schema/Snowflake Modeling, FACT and Dimensions tables, Physical & Logical Data Modeling, Visio.
• Experienced in different team projects with good project implementation experience, Team Skills, Troubleshooting, Presentation and Issue Resolution capabilities.
• Excellent Communication, Analytical skills and Interpersonal skills. Exceptional ability to learn new concepts.

TECHNICAL SKILLS

• SQL Server 2005/2008/2012 /2016
• Teradata
• Windows 7
• Windows Server 2008
• SSRS
• SSIS
• SSAS
• Power BI
• T-SQL
• PL/SQL
• HTML
• VB.Net
• BIDS
• SSDT
• SQL Server Management Studio
• Atana Suite
• MS SQL Integration Services 2005/2008/2012
• MS SQL Reporting Services 2005/2008/2012
• MS SQL Server Analysis Services 2005/2008
• C#
• Crystal Reports
• Ado.Net
• Oracle
• C
• C++
• C#
• ASP.Net
• Oracle
• Visual Basic
• HTML
• Unix
• Windows

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

SQL Server BI Developer

Responsibilites:

• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder 3.0 based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Creating Reports as per user requirements using MS Reporting Services 2008/2012.Written complex T-SQL queries and created Stored Procedures, Triggers, functions and Views
• Designed Ad-hoc Reports based on the business requirements
• Created Data-Driven/Timed Subscriptions for SSRS reports
• Developed Various Reports like Charts, Matrix, Tabular, and Cross Tab using SSRS.
• Developed reports involved in Passing parameters and cascading parameters using SSRS
• Built and Deployed reports on the server using SSRS Report Manager.
• Created reports withdrill downoption,Parameter fields, formulae, and heavy formatting.
• CreatedCross Tab Reports,Pie and Bar Charts, and Parameter Reports,Running totals,Sub Totalsandembedded linked and unlinked sub-reportsto separate and organize key information and to promote reusability in data reporting.
• Used the Report Manager to Create folder structures,modify data sources,Controlling access to Report Services resources.
• Developed crystal reports withparameters, sub reports, cross tabs, charts
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL,Command Objects,Selection Criteria, grouping,sub reportsetc.
• Created number of formulae,running totals conditional display of fieldsfor complex calculations and used them in sub reports.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Dashboard Visualization through Tableau BI application.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Involved in new KPI generation for Scorecards.
• Designed and Developed analytical reports from multiple data sources in Power BI
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, data blending, Hierarchies, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: SQL Server, Management Studio, Tableau (Desktop, Server)9.x,10.x, Atana Suite, Report Builder 3.0, SSRS, Power BI, Teradata, T-SQL, SSIS, Windows.

Confidential, Bridgeton, NJ

SQL Server BI Developer

Responsibilites:

• Involved in Planning, Defining and Designing data, based on business requirements and provided documentation.
• Enterprise reports using SQL Server Reporting Services (SSRS) and Excel pivot tables which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamic reports and other features of Reporting services. Built Drill Down, Drill through, linked and sub reports using SSRS
• Created Stored Procedures, User Defined Functions for databases using T-SQL.
• Developed complex T-SQL code for the application conversions.
• Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.
• Worked with SSIS to import, export and transform the data between the linked servers.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Identify new metrics and enhance the existing KPI's.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, data blending, Hierarchies, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Converted metric insight reports to tableau reports.
• Scheduled frequency and time to refresh data for the when sources are published or extracted to server.

Environment: SQL Server, Management Studio, Integration Services, Reporting Services, SSRS, Tableau Desktop 7/8, Tableau Server 7/8, Tableau Online, Tableau Public, Tableau Reader, OLAP, PL/SQL, Oracle, Data Modeling, Analysis Services, T-SQL, Windows, ETL, SQL Server Agent, Data ware Housing.

Confidential, Canton, MA

SQL Server BI Developer

Responsibilites:

• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results by using T-SQL.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Generated database monitering and data validation reports in SQL Server Reporting Service (SSRS).
• Designed and developed reports using SQL Server Reporting Services
• Developed Stored Procedures and Views used to supply the Data to the Reports.
• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot) Reports, Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SSRS
• Used Oracle, SQL, T-SQL and PL/SQL in test environment.
• Configured, built, deployed different reports in PDF, Excel, TFI formats according to the business requirement using SQL Server 2012 Reporting Services.
• Developed reports where the data extracted from SSAS cubes in SSRS.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications
• Built different types of chart reports using SSRS for the business requirement like Designed and deployed reports with Drill Down, Drill Through, Drop down menu options, Sub-reports in SSRS using BIDS.
• Report parameters included single valued parameters, empid, mgrid that also consisted of different parameter types like hidden, internal, default (queried and non queried parameters).
• Created complex stored procedures to use as the datasets for the Report Design, to generate Ad hoc reports using SSRS
• Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs, Bar charts, Column charts and Pie charts)

Environment: SQL Server, Management Studio, SQL, PL/SQL, Oracle 9i, ETL, Integration Services, Reporting Services, Analysis Services, SSRS, Data ware Housing, ETL, T-SQL, Windows

Confidential, Easton, PA

SQL Server BI Developer

Responsibilites:

• Generated database SQL scripts and deployed databases including installation and configuration.
• Design and Build Extract Transform Load procedures in SQL Server 2005 to import/export data feeds to/from data warehouse.
• Worked with SSIS to import, export and transform the data between the linked servers.
• Created and developed database objects such as tables, indexes, views, procedures, functions, triggers and T-SQL code with proper grants to all the users and roles using SSMS 2008 R2.
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures using T-SQL.
• Worked on Stored Procedures and Database Triggers and business analytical functions.
• Wrote various T-SQL stored procedures and Triggers to carry out various tasks
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
• Designed and implemented application using VB.Net, ASP.Net.
• Troubleshooted, monitored, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Used Microsoft Source Safe for version control and configuration management.

Environment: SQL Server, BIDS, SSMS, Windows, SQL Server Management Studio, T-SQL, SSIS

Confidential, Tewksbury, MA

SQL Server BI Developer

Responsibilities:

• Analyze client requirements and translate them into technical requirements.
• Created Stored Procedures, T-SQL, Triggers, Views and Functions for the database Application.
• Created various Tabular, Cross-tab, Matrix and Ad-hoc reports using SSRS.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Developed data access queries/programs using SQL Query to run in production on a regular basis.
• Created report snapshots to improve the performance of SSRS.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Performed ETL process by pulling large volumes of data using SSIS, BCP into the staging database from various data sources like Access, Excel.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa
• Defined the report layout and identified Datasets for the report generation. Built drill down reports, and also parameterized reports using SSRS.
• Extensively used Report Builder and Report Manager in SSRS.

Environment: Windows NT, Windows 2003, SQL Server 2005/2000, ETL Tools, DTS, SSIS, SSRS, T-SQL, SQL Profiler, Visual Source Safe, MS SQL Reporting Services.

Confidential

SQL Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Used MS access in test environment.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database.
• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (Stored Procedures and Views.
• Involved in developing the SQL code for the application
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Created and automated regular Jobs such as Daily/Weekly Report Generations.
• Managed and Monitored System Utilization. Managed Backup and Disaster Recovery of the systems. Managed the security of the servers as a part of administration duties.
• Managed and resolved design issues during development
• Modifying the database structure, as necessary, from information given by application developers
• Enrolling users and maintaining system security
• Ensuring compliance with database vendor license agreement
• Controlling and monitoring user access to the database
• Monitoring and optimizing the performance of the database

Environment: T-SQL, SQL Server 2000, MS ACCESS, SSMS, Oracle