SUMMARY:

• Over 7+ years of IT Professional in Database Design, Development and business intelligence of Microsoft SQL Server 2008R 2/2012/2014/2016/2017/2019, SSIS/SSRS/ and OLAP as SQL Developer.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, logical/physical databases and Troubleshooting.
• Extensive knowledge and experience in dealing with Relational Database Management Systems Normalization, Stored Procedures, Constraints, Joins, Indexes, Data Import/Export, Triggers.
• Expert at data transformations like lookups, Derived Column, Conditional Splits, Sort, Data Conversation, Multicast and Derived columns, Union All, Merge Joins, Merge, Fuzzy Lookup, Fuzzy Grouping, Pivot, Un - pivot and SCD to load data in SQL SERVER destination.
• Experience using Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Highly experienced in DB server performance tuning and optimization of Complex SQL queries.
• Wrote Complex SQL queries for verifying data integrity in Dimension and Fact tables and created and have in-depth knowledge in various RDBMS concepts.
• Very good understanding and experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Familiar with Agile development and waterfall methodologies.
• Designed Power BI data visualization cross tabs, maps, scatter plots, pie, bar and density charts
• Experience in SQL Server DTS and SSIS package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Developed ETL process using SSIS with various Control flow, Data flow tasks and Stored Procedures for the work order validation process.
• Expertize in Data Modeling, Normalization and building Referential Integrity Constraints, Database Design and Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2012/2014/2016/2017 for both OLTP & Business Intelligence applications.
• ETL implementation using SQL Server Integration Services (SSIS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating several types of reports like Dynamic, Linked, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Document Map and Sub-Reports.
• Expert in designing Enterprise reports using SQL Server Reporting Services 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.
• Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Scheduled Automatic refresh and scheduling refresh in Power BI service 2
• Experience on migration from SQL server to oracle using SQL developer
• Worked on Scrum Methodology as well as on SDLC procedures in the implementation of Tableau and Spot fire.
• Has a very strong background in a well-organized software development life cycle (SDLC) process and has excellent analytical, programming and problem-solving skills.

TECHNICAL SKILLS:

• T: SQL, XML, HTML, C#.Net, ASP .Net.
• Data Application: SQL Server 2005/2008R 2/2012/2014/2016/2017/2019 MS Access (2013/2003) and UML.
• ER: Diagrams, Dimensional Diagrams, Star and Snowflake Schemas.
• Microsoft Visio 2007, Erwin Data Modeler 8/7/5
• DB Utilities: SQL Server Management Utilities, Query Analyzer.
• GUI: DTS Import/Export, SQL Server Integration Services.
• BI Tools: SSIS/SSRS/SSAS, SSBI Development Studio, Crystal Reports.
• Reporting Tools: MS Access, Excel, and MS SQL Server Reporting Services2005/2008 R2/2012/ 2014,2016 SSIS, SSAS and Share Point, Crystal Report
• Operating Systems: Windows10/8
• Version control tools: Visual Source Safe (VSS), Subversion (SVN), Team Foundation Server (TFS)
• ER: Win, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Malvern, PA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked with Software Development Life Cycle, RDBMS, and Data Warehouse & Data Modeling concepts.
• Created Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Worked with various tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
• Created various SQL objects such as schema, tables, field definitions and mappings, stored procedures, CTE, Triggers, views and indexes/keys. Developed ETL programs used to implement the business requirements.
• Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and UDF. Created reports which retrieve data using Stored Procedures that accept parameters.
• Developed and optimized database structures, Stored Procedures, Indexes, Views, and UDF, Common Table Expression (CTEs) to support Power BI and SSRS report.
• Created various SSRS reports like drill down, sub reports, parameterized, multi-valued and various adhoc reports through Report model creation.
• Created complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined Objects, aggregate aware objects, charts, and synchronized queries.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages. Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
• Built the automated ETL system for the Group Practice data mapping by utilizing the Lookup, slow changing dimension and developed C#/ VB.NET in script task and script component in SSIS.
• Performed transformations like Conditional Split, Sorting and included data about the environment using the Audit Transformation.

Environment: MS SQL Server 2017/2019, T-SQL, SSRS, SSIS, SSAS, Oracle 12c, Windows server, Visual Studio 2017/2019, Power BI, Erwin, Crystal Reports, C#/VB.NET, Windows 10

Confidential, Portland, OR

Sr. SQL Server/SSIS/SSRS Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for the clients.
• Transformed data from different data sources like Oracle to SQL Server 2017 using ODBC connection providers by creating various SSIS packages. Data is transformed from data warehouse to hub.
• Extensive T-SQL Programming using Views, Functions, Stored procedures, CTE’s and functions.
• Performed performance tuning by analyzing indexes, queries, and table size etc Database Engine tuning advisor and query execution plan tools.
• Developed and maintained various cubes using MDX complex queries using SSAS.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Working with various business groups while developing their applications, assisting in Database model design.
• Created package configuration in XML and used them to deploy packages across Test and production SQL servers.
• Designed and generated reports with different layouts using SSRS 2008R2 and exported them into Excel, PDF and HTML.
• Analysis and documentation of SharePoint architecture including central administration, SQL & Windows 2008.
• Involved in debugging the ASP.NET code and fixing the bugs.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Developed several REST web services supporting both XML and JSON to perform tasks such as
• Remote thermostat and demand-response management. REST web services leveraged by both web and mobile applications.
• Design and development for the Crystal Reports which work as a feed for the dashboard.
• Created Web reports for P2P/OTC and FI reports for base of the dashboard development.
• Implemented PowerShell scripts that automated creation of contacts from Active Directory users and updating of address books -increasing productivity and efficiency.
• Designed and developed various Service Management Reports like Cascading Prompts, Sales Reports, Portfolio Report, sub-reports, charts, and parameterized reports, conditional and dynamic reports and deployed various reports on Share Point Portal.
• Created report models for ad hoc reports when the end user wants to see the reports on fly.

Environment: MSSQLServer2017, SSIS, SSAS, SSRS, Windows Server 2008, SSIS/SSAS/SSRS, SharePoint, Crystal reports, Web Services, PowerShell, Tableau and MS access Excel.

Confidential, New Brunswick, NJ

SQL Server Developer

Responsibilities:

• Involved in new databases design and creation using Rational Rose.
• Created Database Diagrams using third party tool ER-Win in beginning of the project. Identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
• Worked on creation and improving the stored procedures and triggers performance.
• Experienced in Design of OLAP Data warehouse using Star Schema and Snow Flakes Schema.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions.
• Created Database Diagrams using third party tool ER-Win in beginning of the project. Defined relationship between tables and enforced the referential integrity constraints.
• Responsible for Query Performance tuning and Optimization.
• Created views, SQL joins DTS packages and statements for applications.
• Designed and implemented stored procedures and triggers for automating tasks.
• Generated T-SQL code for creating cursor and handling the data validations.
• Created SQL server Analysis Projects using MS SQL Server 2016.
• ETL packages are created to extract, transform and load data to data ware house using SSIS.
• Using SSIS the data is transferred to and from flat files, MS Excel, MS Access and SQL Server 2016.
• Implemented the calculations to aggregate physical measures using management studio.
• Involved in creation of Multi - Dimensional Cubes and Relational Cubes.
• Used BCP techniques, Stored Procedures, Triggers, Cursors and Transaction management, TSQL to convert data from various sources to MS SQL 6.5/7.0 databases.
• Developed and maintained MS Access database.
• Supported development of a speciation control documents for an MS Access Project Management Database.

Environment: SQL Server 2016, MS-SQL Server Management Studio, T-SQL, DTS, Replication, SSIS 2016, SSRS2016, Rational Rose, Windows 9x/Windows NT, MS SQL Reporting Services 2016, MS SQL Server Analysis Services 2016, MS SQL Server Integration Services 2016MS Access, Erwin, SQL Query Analyzer.

Confidential, Rochester, MN

SQL Server Developer

Responsibilities:

• Worked on Full life cycle development (SDLC) and was involved in all stages of development.
• Worked as a developer in creating complex stored procedures, Triggers, Functions, Indexes, Tables, Views and
• SQL joins for applications. Implemented different types of constraints on tables.
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Optimized queries tuned and monitored server performance using SQL Profiler.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using
• SSIS. Developed SSIS solution for developing a fully-fledged data warehouse solution.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
• Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc. Identified and defined Fact relationships in SSAS.
• Responsible for creating the reports based on the requirements using SSRS 2014.
• Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
• Worked with RDBMS objects such as tables, views, stored procedures, and functions in MS SQL Server Management Studio (SSMS) to make SSIS packages effective.
• Developed test-driven development (TDD) strategy guiding use of the Nunit testing framework.
• Expert within VBA, SQL Server SSIS, and SQL because test scripts included this information.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
• Deployed the generated reports directly on the client's workstation.
• Explored and used many enhancements of Power BI in current reports like Content pack and direct connection to databases like SSAS. Involved in writing scripts for the client’s requirements for reporting purposes.
• Assisted in production OLAP cubes, wrote queries to produce reports using SSAS and Power BI for reporting.
• Worked on building queries to retrieve data into Tableau from SQL.
• Analyzed the existing reports, cubes and dashboards and prepared the use cases for Tableau visualizations.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs. Implemented the calculations to aggregate physical measures.
• Involved in Data Modelling of variant Data and integrating the data into existing EDW models.
• Monitored mainframe production and test jobs, including the critical overnight ODS data exchange processes.
• Implementing Dashboards and Score Cards using Microsoft Performance point Server and integrated with share point. Monitored production and test jobs for Operational Data Store (ODS) distributed environment.

Environment: SQL Server 2014, SSIS, SSRS, SSAS, SSDT, Visual Studio, MS Excel, T-SQL, C#, Window 7, TFS.