SUMMARY

• Over 9 years of IT Experience as MS SQL Server Database Developer with strong background in Data warehousing and ETL experience
• Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing/Client - Server and Software Development Lifecycle (SDLC).
• Experience Working in Agile, Scrum and Waterfall model
• Strong technical knowledge in MS SQL Server development including Integration Services, DTS, Microsoft Analysis Services, Performance tuning, Reporting, designing logical/physical databases and troubleshooting.
• Hands on Experience on Data warehouse concepts Normalization and Demoralization
• Proficient in creating Transact-SQL (DDL, DML, DCL and TCL), Indexes, Views, Cte, Complex Stored Procedures, User and System defined functions
• Key player in designing and developing relational database objects like tables, user defined functions, views, indexes, stored procedures, cursors and triggers and experience working with Big Data platforms like COSMOS and Hadoop.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Experienced with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports
• Efficient Experience working on OLTP and OLAP
• Created Cache Memory on WindowsAzure to improve the performance of data transfer betweenSQL Azureand WCF services.
• Designed and Implemented Database Schema, Imported data and build stored procedures on SQL Azure.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Extensive experience with SQL Server and T-SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
• Expert in writing T-SQL, working on DTS, SSIS, SSRS Data Cleansing, Data Scrubbing and Data Migration
• Experienced in creating Jobs, Alerts, SQL Mail Agent, and scheduling DTS Packages
• Strong understanding in installing MS SQL SERVER on both AWS and Azureenvironments. Good Knowledge on AWS services like EC2, Cloud Front, and Cloud Formation templates etc.
• Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Experienced in logical, physical, and dimensional data modeling, data mapping, and data normalization.
• Created Databases on SQL Azure and also experience in setting up SQL Azure Firewall.
• Heavy experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Experienced in creating various types of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Hands on experience with performing various SSIS data transformation tasks like Lookup, Conditional Splits and Event Handlers, Error Handlers etc.
• Experience in designing enterprise reports using SQL Server Reporting Services, generated drill down reports, drill through reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.
• Wrote parameterized queries for generating reports in SSRS.
• Built and partitioned cubes using SSAS with multiple fact tables.
• Proficient in designing and implementing SSAS Tabular & Multidimensional Cubes.
• Worked on DAX scripting to access data from Tabular Model and MDX for Multidimensional Cubes.
• Expertise in creating Row Level Security & Roles for SSAS Tabular Model & Multidimensional Cubes, as well as deploying them into SSAS.
• Experienced in creating complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Learning new trends in data management like Big Data and data analysis in Hadoopclusters, as well as getting to know NO SQLDatabases like Cassandra, Mongo db etc.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.

PROFESSIONAL EXPERIENCE

Confidential - NY

Sr SQL BI Lead Developer (SSRS, SSAS, SSIS, Power BI)

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business Projects across the organization
• Created various complex reports, Dashboards and manage them using SQL Server Reporting Services (SSRS 2012/2008R2/2008)
• Involved in process building and maintaining different platforms including SQL Azure 2012 servers.
• 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.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Cloud based report generation, development and implementation using SCOPE constructs and power BI. Expert in U- SQLconstructs for interacting multiple source streams with in Azure Data Lake.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client's need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
• Extracted the datafrom Hadoop Data Lakeusing the Hive connection and created Performance Analytical dashboard.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS and Power BI
• Created OLAP cubes using SSAS and created reports from the OLAP cubes using SSRS.
• Deployed SSRS Reports with SharePoint integration mode
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in SharePoint.
• Creating Data Lake Analytics account.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
• Designed ETL structures for data imports from various sources such as Oracle, Teradata, Excel, Access and DB2.
• Preparing the source data. Data Lake Analytic jobs can read datafrom either Azure Data Lake Store accounts or Azure Blob storage accounts.
• Created dashboards that displays key information for decision making purpose using Heat maps, Geo maps, Tree maps, Pie charts, Bar charts, Circle views, Line charts, Area charts, Scatter plots, and Bullet graphs.
• Utilized Data story telling in Tableau to provide more dynamic and more effective stories from the hidden insights locked in the data.
• Published the developed dashboards and reports on the Tableau Server so that the end-users having access to the server can view the data.
• Developed a conical map/reduce-like architectural pattern that that is designed to leverage theAzure platform.
• Scheduled frequency and time to refresh data when sources are published or extracted to server.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.

Environment: MS SQL Server 2014/2012/2008 R2, SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis services (SSAS), SQL Server Integration services (SSIS), Azure, SQL server Data Tools(SSDT), Tableau, MS Excel, Windows XP, SQL Server Management Studio (SSMS), TFS.

Confidential - NJ

Sr SQL BI Developer (SSIS SSAS SSRS)

Responsibilities:

• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Implemented different types of constraints on tables.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created pipelines in AzureData Factory to move the data from Azure SQLto On-Premise servers.
• Identified the data source and defining them to build the data source views.
• Looked at the reports and fixed bugs in stored procedures.
• Extensively worked on views, cursors, CTE's, schemas, permissions and performance issues with client/server database design.
• Monitored scheduled jobs and alerts.
• Designed and Implemented Database Schema, Imported data and build stored procedures on SQL Azure.
• Responsible for gathering/refining requirements from the customer for developing reports.
• Responsible for transferring the data using SSIS packages.
• Developed, monitored and deployed SSIS packages.
• Developed SSIS packages using various transformations such as conditional splits, fuzzy look ups, aggregations and multicasting.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Improved Report Performance and performed unit testing.
• Created SSIS packages to export data from text file to SQL Server Database.
• Created SQL Server Reports and developed query for generating drill down reports using SSRS 2014.
• Identified and worked with parameters for parameterized reports in SSRS 2014.
• Analyzed old reports designed in crystal reports and transform those reports into SSRS report with proper mapping and error handing.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client's workstation.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Created a cube using multiple dimensions and modified the Relationship between a Measure group and a dimension using SSAS.
• Implemented and enhanced existing reports like group by, drilldown, drill through, sub-reports, list, tabular, matrix, navigation reports, standard parameter, cascading parameter and multivalve parameters.
• Gather data from different data sources like MySQL, Excel.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Created Tabular Models as a source to Power BI dashboards and scheduled jobs to refresh it in a timely manner.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
• Provided production support on the existing Power BI dashboards and other ETL processes to resolve the issues quickly.
• Published Power BI Desktop reports created in Report view to the Power BI service.

Environment: MS SQL Server 2012/2008 R2, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS 2012), SQL Server Analysis Services (SSAS 2012), SQL Server Reporting Services (SSRS 2012), Power BI, Azure, Power Pivot, Windows 2010, MS Excel, SQL Server Profiler.

Confidential - New York

Sr. SQL/SSIS/SSRS/SSAS/Power BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Worked independently on a Project Called Back Order Relief Process for IPR (Inventory Planning and Replenishment) to build ETL process by gathering the requirements and pull data from multiple sources (flat files and Access DB) to SQL to provide Useful SSRS reports and Dashboard to the Business users.
• Also, worked on Order Age reporting project, which helps the business monitor the Order fulfillment process and use the calculated On-time percentage metrics to determine the performance within the distribution center
• Worked on Onboarding the WMS (Warehouse Management System) Oracle data and landed the data tables on our production SQL Server with process indexing and considering other constraints
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Created volatile tables and partitioning the tables and Responsible for supporting existing projects using Teradata SQL assistant tool.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Involved in Normalization of the database and bringing it to 3NF. Dealt with Fine-tuning Stored Procedures to improve performance with a Query plan using SQL Tuning advisor.
• Migrated data from Heterogeneous Data Sources to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed and responsible for development of Dashboards in Tableau
• Experience in creating reports and performing business analysis in Tableau
• Developed various operational Drill-through and Drill-down custom reports using .Net framework 3.5 within SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports. Used cascaded parameters to generate a report from two different Data Sets.
• Production support, troubleshooting and debugging in a high volume transaction processing environment.
• Support existing projects over the holiday season to ensure the business had all the data and reports available.

Environment: MS SQL Server 2012/2008R2, SQL Server Reporting Services (SSRS), SQL Server Analysis services (SSAS), SQL Server Integration services (SSIS), Business Intelligence Development Studio (BIDS), MS Excel, MS Access, Windows XP, SQL Server Management Studio (SSMS), TFS

Confidential - CA

SQL/SSRS/SSIS/SSAS Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Scheduling the SSIS packages and Jobs.
• Improved Performance by creating Clustered and Non- clustered Indexes and by optimizing the T- SQL statements using SQL profiler.

Environment: MS SQL Server 2008, T- SQL, Power pivot, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio,), Visual Source Safe (VSS) .

Confidential

.NET/ SQL Server Developer

Responsibilities:

• Developed and designed web interfaces, layouts and site graphics.
• Actively participated in gathering of User Requirement and System Specification.
• Developed database objects like tables, views, stored procedures in SQL Server 2005.
• Writing Stored procedure, Functions and Views.
• Involved in writing inline queries.
• Developed application logic using C#.
• Written Sql Queries using SQL in SQL SERVER 2005.
• Developed Web Forms using C# and ASP.NET.
• Documentation of all the processes involved in maintaining the database for future reference.
• Worked on Cascading Style Sheets, JavaScript.
• Extensively used Grid Views sorting and paging.
• Involved in writing Test Cases for Manual Testing.

Environment: ASP.NET (with C#), MS SQL Server 2005, Microsoft Visual Studio 2003, SQL Server Reporting Services (SSRS), Report Manager, Report Viewer, Sqlserver Integration Services (SSIS), MS Excel

Confidential

.NET/ SQL Server Developer

Responsibilities:

• Developed and designed web interfaces, layouts and site graphics.
• Written Sql Queries using SQL in SQL SERVER 2005.
• Developed Web Forms using C# and ASP.NET.
• Worked on Cascading Style Sheets, JavaScript.
• Extensively used Grid Views sorting and paging.
• Involved in writing Test Cases for Manual Testing.

Environment: ASP.NET (with C#), MS SQL Server 2005, Microsoft Visual Studio 2003, SQL Server Reporting Services (SSRS), Report Manager, Report Viewer, MS Excel.