SUMMARY:

• 6 years of IT experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Testing, Implementation and Deployments using SQL Server 2016/2014/2012/2008/2005.
• Hands on experience in Software Development Life Cycle (SDLC) including Agile/Scrum and waterfall project management methodologies.
• Experience in providing 24x7 production support.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Proficient experience in T - SQL in designing and creating Tables, Views, Stored procedures, Triggers, User defined Functions, indexes, data dictionaries, and data integrity constraints.
• Expertise in optimizing database objects by choosing appropriate indexes and analyzing performance of queries captured by database engine tuning advisor and SQL profiler.
• Strong experience in designing and developing different Business Intelligence solutions using Visual Studio.
• Extensive experience in data migration and conversion between homogenous and heterogeneous systems using tools like SSIS, DTS, BCP, Bulk Insert and Import and Export wizard.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Understanding and Knowledge on Azure SQL and services including Azure Data Factory, storage technologies and migration of on-Premise databases to Azure.
• Experienced in designing and developing Dimensional Data Modeling, Star Schema, Snow-Flake schema,Data Marts, OLAP cubes, Facts, dimensions and KPIs.
• Proficiency in SQL Server jobs automation, Backup and Restore, High availability Disaster recovery technologies.
• Excellent communication skills, analytical skills, understand business requirements in various domains.
• Effectively manages time spent on multiple projects to meet deadlines.
• Ability to work in a fast-paced environment, being good team player and with ability to work independently.

TECHNICAL SKILLS:

Databases Tools: SQL Server Management Studio (SSMS), SQL server data tools (SSDT), Business Intelligence Development Studio (BIDS), SQL Profiler, Query Analyzer, Perfmon, Database Engine Tuning Advisor

ETL Tools: Data Transformation Services (DTS), Export/Import, SQL Server Integration Service (SSIS), Visual Studio 2010/2013/2015/2017

Analysis and Reporting Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting Services (SSRS), Tableau, MS Excel, PowerBI

Databases: MS SQL Server 2016/ 2014/ 2012/2008/2005 , MS Access

Modeling Tools: Microsoft Visio, SQL Diagrams, ERWIN 7.2

Programming: T-SQL, PL/SQL, VB.Net, XML, HTML, C#, PowerShell, C++

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS

Operating Systems: Windows server 2016/2012/2008 R2/2003/2000 Server (64/32 Bit), Win 10/8/vista/Windows NT 4.0/3.5. Unix, Linux

Other Tools: MS Office Suite (Word, Excel, outlook, Power Point, MS Visio), MS Project, Team Foundation Server, Citrix, VDi, VMware, HP QC, Jira, Diagnostic Manager, IBM WebSphere (One Run, CMU), TWS, Service Now, Ultra Edit, One Note, SOAP UI.

PROFESSIONAL EXPERIENCE:

MS SQL Server Developer

Confidential, Rockville, MD

Responsibilities: 

• Designed, developed and implemented DDL scripts to create databases, schemas, table and views on SQL server 2016/2014/2012.
• Created complex Stored Procedures, Triggers, Functions, Indexes, DML scripts to implement business requirements.
• Designed SSIS Packages in SSDT and BIDS to extract and load data from various data sources such as MS Access, Excel and flat files into SQL Server 2016/2012/2008 .
• 24x7 Support for Application Development team with any production database issues, updates and new releases.
• Involved in migrating databases from SQL server 2008 to SQL 2012/2014.
• Install and configure SQL server 2012 on development and test environments.
• Troubleshoot I/O and CPU bottle neck issues on production system along with the DBAs.
• Converted Data Transformation Services (DTS) packages to SQL Server Integrated Services (SSIS) packages as assigned.
• Created Error handling, Debugging and logging for production support in SSIS.
• Troubleshoot and monitor Productiondatabases on daily basis.
• Created report using SSRS for different users based on requirement for customized and ad-hoc Queries.
• Developed and maintained multiple Power BI dashboards/reports and Visualizations.
• Involved in Designing and deploying cubes in SSAS environment and writing MDX queries to retrieve data from the cubes.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in SQL server agent jobs.
• Worked on performance tuning and query optimization by analyzing data from database engine tuning advisor, perfmon and execution plan.

Tools: MS SQL Server 2016/2012/2008 , SQL Server Reporting Services (SSRS), MS Access, Datawarehouse, MS Excel, SSIS, BCP, T-SQL, Tableau Desktop, Power BI, Team Foundation server, HP Service Manager, Win 2016/2012/2008 , PowerBuilder 5, Erwin v7.2, C#.

SQL/BI Developer

Confidential, Columbia, MD

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.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• 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.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.

Tools: SQL Server 2012/2008/2005 Enterprise Editions Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), TSQL, MS Visual Source Safe and Windows Server 2003.

SQL Developer

Confidential, NYC

Responsibilities:

• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Understanding of Application Architecture, Application Design, implementation of proper Isolation levels, analyzing T-SQL Code and suggesting performance improvements.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Provided 24x7 support for all Production, Development and Clustered Servers.

Tools: MS SQL Server 2014/2012, Visual Studio 2013,2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) Microsoft SharePoint, MS Project, VBA, MS Office , Erwin 9.2 Data Modeling, ALM for QA testing and Software Development Life Cycle (SDLC)