PROFESSIONAL SUMMARY:

• 8+ years of IT experience in database design, development and support of Microsoft SQL Server for Production/Development environments.
• Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.
• Good knowledge of Database Administration operations like Backup, Restore and excellent knowledge in Transact - SQL (DDL, DML, DCL).
• Experience writing T-SQL scripts, dynamic SQL, creating indexed views, cursors, indexes, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experienced in transforming complex business logic into Database design, Migration and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, Data Modeling and DTS.
• Experience in designing and developing Data, Data Marts using multi-dimensional data models such as Star Schemas and Snowflake Schema.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Expert in database creation, maintenance, monitoring, backups and recoveries using SQL Server Agent, Import/Export Wizard and Maintenance Plans.
• Good in code migration, database change management and data management through the various stages of the development life cycle.
• Well versed with Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services project
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Good exposure in writing MDX queries while creating and customizing Cubes using SQL server Analysis Services (SSAS).
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• In-depth knowledge of working and implementation of SSRS Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports.
• Hands-on experience in development of strategic and complex reports using most of the features and tools included within the report builder (list, matrix, graphs, sub-reports, t).
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services (SSAS).
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources and Tableau servers for maintaining DB schemas.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources. Experience with R Integration in Tableau to identify patterns, build practical models for a deep statistical analysis and accomplish forecasting of those statistical models.
• Worked on Power BI service by publishing the Power BI reports onto Power BI server and collaborated team using Power BI service to create the dashboards.
• Configure security, organizational content packs, Data Gateways, refresh schedules for Power BI service.
• Good in creating aggregates, hierarchies, charts, filters, quick filters, table calculations with Power BI.
• Experience working in Agile and Waterfall model working methodologies.

TECHNICAL SKILLS:

RDBM/Databases: MS SQL Server 2016/2014/2012/2008 R2 MS SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016, Oracle Azure SQL DB, CosmosDB

Database Tools: Business Intelligence Development Studio, SQL Server Integration, Services (SSIS), SQL Server Reporting Service (SSRS), SQL Server, Analysis Service, SQL Server Management Studio.

ETL Tools: SQL Server Integration Service (SSIS), DTS

Programming Languages: C, Java, HTML,MDX, T-SQL,PL/SQL,C#

Reporting Tools: SQL Server Reporting Service (SSRS), Power BI, Tableau

Application Tools: MS Office Suite(MS WORD, MS EXCEL, MS VISIO, MS Power Point), SharePoint

Operating Systems: Windows XP /Vista /7 /8 /10, Windows NT Server, Windows 2003 /2008R2 /2012 Servers.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

MSBI Developer

Responsibilities:

• Created SSIS packages for data integration from various data sources like Access, and SQL Server 2012 into the operational SQL Server and deployed them by using configuration tools.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Creating SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Developing reports and dashboards using Power BI stack, Power Pivot, Power View, Power Query.
• Using various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created/modified complex store procedures to fit to changing requirements and enhance performance and developed custom functions, indexes to ensure accuracy, quality and consistency of the database.
• Created databases and schema objects including tables, indexes, views and applied constraints.
• Wrote complex stored procedures to get data from different servers and generated reports on that data.
• Built the report models, created a wide variety of interactive reports for business users in SSRS and deployed the reports in various formats depending on the user requirements.
• Worked on Power BI on how to import, shape (info graphics) and transform data for business intelligence (BI), Visualize data, and author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.

Environment: MS SQL Server 2012, Git, MS SQL Server Reporting Services 2015, MS SQL Server Analysis Services 2015, T-SQL, MS SQL Server Integration Services, Visual Studio 2015,T-SQL, Agile Methodology.

Confidential, New Jersey

SQL Server Developer

Responsibilities:

• Actively involved in the user requirement gathering process.
• Design and write elastic queries to access data across database and Migrate an existing SQL Server Database to use Azure SQL Database.
• Created database objects such as tables, views, indexes, stored procedures, and functions per requirement. Established joins and created indexes whenever necessary based on requirements.
• Worked on SQL Server backup, recovery scenarios and SQL Server security management.
• Created multiple complex queries for data profiling and auditing purposes utilized in the ETL process.
• Performed a multitude of ETL, data operations to support data loads and transformations with SSIS.
• Improved the performance of SSIS packages with non-blocking transformations and row transformations.
• Implemented event handlers, loggings, breakpoints, and data viewers to debug packages.
• Utilized SSIS transformations such as Conditional Split, Derived Column, Fuzzy Grouping, and Fuzzy Lookup to validate data during staging before loading into data mart.
• Configure database replication from on premises to Azure SQL, data sync and migration of database to and from Premise/Azure SQL DB Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery, troubleshoot performance.
• Utilized SSIS to implement the Slowly Changing Transformation along with checksum technology, to maintain historical data in data marts.
• Created incremental refreshes for data sources on Tableau server. Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Implemented robust error-handling techniques through event handlers, precedence constraints (control flow level) and error data pipeline (data flow level) per business requirements for sending emails to corresponding individual. Optimized SSRS reports with snapshots, caches, execution log views, embedded queries, and stored procedures.
• Scheduled report deliveries to multiple users utilizing subscriptions (standard/data driven).
• Created several drill down, drill through, sub, linked, cached and snapshot reports using SSRS and deployed them in Native mode.

Environment: SQL Server 2012, SQL Server Management Studio (2012), SSAS, SSRS, SSIS, T-SQL, SQL Profiler, Visual Studio 2012,C#.Net

Confidential, New jersey

MSBI Developer

Responsibilities:

• Developed stored procedures for loading data with open queries into SQL Server.
• Data conversion process from legacy systems into SQL server.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Created/modified Tables, Stored Procedures for Application Developers and some User Defined Functions.
• Created ETL packages with different data sources ( SQL Server, Flat files, Excel source files) and loaded the data into target tables by performing various kinds of transformations using SSIS
• Used Team Foundation Server as Source Control to store Packages, Reports and SQL Scripts and share it among team members.
• Responsible for developing, monitoring and deploying SSIS packages.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Created Cross-Tab, Drill-down, Drill-thru and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Data visualizing using Tableau created and published Tableau Dashboards into Tableau Server.
• Tested the process how the data is loaded and how the reports are representing data accurately.
• Developed extract process to load excel files and emailing to business users.
• Used different Source like EXCEL, CSV, and ORACLE and loaded files .Used Sequence containers, FOR EACH LOOP containers for loading multiple files.
• Implemented SSIS packages to import data from MS Access, Oracle10g, text files and Excel files.
• Used Share point server to deploy SSRS reports and integrated reports to Share point. Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using RDL.
• Created Ad Hoc and parameterized various Reports using SSAS and SSRS.
• Created queries for generating drill down reports in SSRS 2012. Formatted the reports using the Global variables, expressions and Functions.

Environment: SQL Server 2008, 2008 R2, T-SQL, MS Excel, MS Access, Visual Studio 2008, MS SSIS, MS Reporting Services (SSRS), Windows 2008 Server

Confidential

SQL Developer

Responsibilities:

• Requirements gathering from Business users to perform technical design, development and testing.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions
• Worked on designing databases according to industry standards and make tuning recommendations.
• Designed the Data warehouse and done the mappings from Source to the Target tables.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Identified the dimension, fact tables and designed the Data-Mart using Star schema.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008R2 Analysis Services.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008R2.
• Generated multi parameterized reports in MS SSRS 2008R2 allowing users the ability to make selections before executing reports; thus making them user friendly.
• 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 using SSRS
• Created Ad Hoc and parameterized various Reports using SSAS and SSRS.
• Assisted in handling escalating billing issues and propagating bug fixes in production environment.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.

Environment: SQL Server 2008R2, DTS, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Query Analyzer.

Confidential

Software Engineer

Responsibilities:

• Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
• Worked with DDL, DML, and DQL in T-SQL using CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, FROM, WHERE, ORDER BY, and GROUP BY.
• Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Worked with DDL, DML, and DQL in T-SQL using CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, FROM, WHERE, ORDER BY, and GROUP BY.
• Responsible for quick response of SQL statement and connectivity from front application to the database servers.
• Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created SSIS packages to populate data from various data sources.

Environment: MS SQL Server 2008R2/2008, MS SQL Server Management Studio (SSMS), MS SQL Server Integration Services (SSIS), MS Excel, T-SQL.