SUMMARY

• Having 7+ Years of experience in Database, Data Warehouse Development,Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2016, 2014, 2012 in Production, Testing and Development.
• Deep understanding and working experience of SQL Server (SQL 2008/SQL 2008 R 2/2012/ 2014/2016 ) and Clustered Servers Active/Active and Active/Passive Cluster Design .
• Proficient in software development life cycle (SDLC), Agile - Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Experienced in developing and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Proficient in Relational Database systems (RDBMS), Data modelling and Data normalization.
• Setup of Log Shipping, Database Mirroring (Disaster Recovery) and Database Transactional Replication.
• Designed, implemented and maintained SQL Server databases including security, back-up, logging, reporting, and recovery procedures.
• Experience in supporting Very Large OLTP Databases of size 15 TB and troubleshooting the performance bottlenecks.
• Proficient in SQL Server programming using T- SQL (DDL and DML), constructing Tables, Normalization/ Denormalization Techniques on database Tables.
• Implemented third normalization form in OLTP Database modelling and Star, Snowflake Schemas in OLAP Dimensional modelling.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experienced in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using SQL Server 2016/2014/2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.
• Strongly experienced in designing ETL data flows by creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server Integration Services - SSIS.
• Implemented ETL Workflows to handle late arriving dimensions and late arriving facts using the Surrogate Key Pipelining concept.
• Good Knowledge of snowflake, Snowsql and Cloud Platforms.
• Experience in creating webpages in Asp.net, Worked extensively with Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database.
• Expertise in analytical and documentation skills accompanied by problem solving skills in ASP .NET.
• Hands on experience in functional testing, unit testing, creation of test conditions and test scripts.
• Performed in web applications using OOPS.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2008 R 2/2012/2014/2016/2019

Languages: T-SQL, PL-SQL, C#, Asp.Net,ADO.Net,Java Script

Operating System: Windows 2008/2008R2/2012

Other Skills: Cloud Datawarehouse: Snowflake Web Framework: Asp.NET, VB, IIS, XML, HTML, JavaScript

Business Modeling Tools: Microsoft Visual Stdio, MS Word, MS Excel, MS PowerPoint, Outlook express, MS Project

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQL Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Interacted with Business Analyst, Subject Matter Experts and Stakeholders to understand the business needs and documented the complex business requirement into simpler one and automate the process by writing complex scripts and scheduling on the jobs.
• Optimized performance of T-SQL stored procedures and queries by using execution plan, SQL profile and engine tuning advisor.
• Defined check constraints, rules, indexes, and views based on business requirement.
• Developed the Stored Procedures, Views, User Define Functions and Complex Queries.
• Created Temporary Table and Common Table Expression (CTE) for query Optimization.
• Programmed Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types and Package Logging that stores the Logging results in SQL table and flat files.
• Interacted with program managers and test engineers to contribute and review functional Specifications and test cases.
• Worked on developing tables, indexes, views, creating complex stored procedures, triggers, functions.
• Automated DBA activities and upgraded existing databases.
• Prepared automation scripts and developed PostgreSQL database architecture.
• Maintain data warehouse architecture.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases.
• Developed reports using complex TSQL queries, UDF, store procedures and views.
• Designed a new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.
• Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to Staging database in SQL Server using Business Intelligence Development Studio.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with the front-end for implementing logic in stored procedures and functions.
• Created clustered and non-clustered indexes on tables for new databases to faster retrieval of data for the Reports.
• Designed reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading parameters for Sales and Management teams.

Environment: SQL Server 2012/2008R2/2005, Windows Server, SQL Server Management Studio, T-SQL,SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor.

SQL Developer

Responsibilities:

• Worked with the PO in gathering requirements, Business Analysis and QA team to validate the requirements, designing, Administration, Maintenance, Installation and Configuration of Microsoft SQL Server SQL Server.
• Developed SQL scripts to load the custom data into Development, Test and production Instances using Import/Export. Created scripts to create custom Tables and Views.
• Programmed highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used TSQL to manipulate and architect to produce results for business users.
• Defined multiple join statements to retrieve data from multiple tables.
• Involved in analysis, design and development of sales module, project management module,resource management module.
• Responsible for developing backend business and persistence logic.
• Responsible for linking backend logic to user interface.
• Tracked and managed developing team and assist in technical support.
• Performed Data Analysis and Data profiling using complex queries on various source systems.
• Modeled new tables and added them to the existing Data Model as part of Data Modeling.
• Performance tuning of SQL stored procedures and ETL packages.
• Took responsibility in creating the Relational Database design. Composed T-SQL queries to help various transactions in order to implement Performance tuning and optimization of T-SQL queries used different logics with Stored Procedures, Joins, CTE and Recursive CTE.
• Extensively used joins and sub-queries for complex queries involving multiple tables from different database.
• Dividing information into tables, turning information into columns, and setting up table relationships
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Developed custom Views to use as source for Power BI reports to hide important business logic.
• Developed time intelligence calculations to forecast trends in different project engagements over time for strategic business development.
• Monitoring locking/blocking and space management issues
• Scheduling jobs and monitoring and troubleshooting them.
• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods.
• Created a website in Asp.net. Made database connections and access the db using ADO.Net.
• Created the data adapter and data sets to load the tables from db to the application.

Environment: Windows Server 2016, SQL Server 2016, SQL BI Suite 2016 SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Windows Server, SQL Server Report Builder, Data Warehouse,Microsoft Visual Stdio

Confidential

Jr.SQL Developer

Responsibilities:

• Developed SQL scripts to load the custom data into Development, Test and production Instances using Import/Export. Created scripts to create custom Tables and Views.
• Programmed highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used TSQL to manipulate and architect to produce results for business users.
• Defined multiple join statements to retrieve data from multiple tables.
• Developed stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Developed T-SQL queries and stored procedures to perform Data Cleansing to eliminate dirty reads.
• Developed Star schema modelling in Data Warehouse and extended same in SSAS multidimensional cubes (Dimension, Hierarchies and Measure Groups).
• Responsible for testing to optimize the procedures and triggers to be used in production. Involved in project planning and also scheduled for database modules with project managers.
• Tuned the performance of SQL queries and stored procedures using SQL Profiler. Involved in database and log backups & restoration, backup strategies, scheduling.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes, and views.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Deployed and scheduled packages using SQL Server Agent Job in Management Studio.
• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Worked with DBAs to create a best fit physical data model from the logical data model using forward engineering
• Widely used Normalization methods and have done different normalizations (3NF).
• Created web pages in Asp.net for a product. Used Oops concepts for creating a functions for the tools.
• Made database connections and access the db using ADO.Net.

Environment: SAS, SQL Server 2008, MS-Excel, Power BI, Windows, SQL Loader, Oracle, SQL Server, Microsoft Visual Stdio.