Data Sql Server

Deepak Rawat

Cell: 862-***-**** email: ************@*****.***

Page 1

SUMMARY

● 15+ years of IT industry experience, involving in database design, development & support of MS SQL Server 2007,2008,2000,2010, 2012, 2014 for development as well as production.

● Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.

● Experience in implementing business logic using Triggers, Indexes, Views, Stored procedures and User defined functions (UDFs).

● Hands on experience of performance tuning and query optimization.

● Experience in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.

● Experience with tools like SQL Server management studio and SQL Server 2005/2008 integration (SSIS) and reporting services (SSRS).

● Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.

● Good working knowledge in creating Packages using SQL Server Integration Services (SSIS).

● Transformation of data from one server to other servers using tools like bulk copy program (BCP), Data Transformation Services (DTS), data conversions from legacy systems to SQL server.

● Experience in gathering requirement and estimation with client.

● Experience of working with .Net 1.0/ 2.0 and web services.

● Good working experience on Sybase ASE 12.5 database with UNIX.

● Extensive working experience on PowerBuilder 6.0 / 7.0 with Sybase and SQL Server as Database.

● Experience on Excel VBA programming.

● Experience on Katalon Studio 5.7.1 to automate Web sites.

● Good Knowledge of MS Project 2000.

● Sound Knowledge of version control tools like VSS, VTFS and MKS Integrity.

● Experience on all phases of the Software Development Life Cycle (SDLC) including requirement gathering, analysis, design, development, integration & maintenance.

● Experience of Onsite / Offshore model.

● Experience of working in Agile mythology.

● Having knowledge of EU Regulations & BNFS.

● Involved in business enhancements discussion, resource management and technical reviews.

● Possess excellent communication skills with strong work ethics and have consistently demonstrated strong teamwork and ability to make a long-term commitment to projects.

● Enthusiastic about learning new concepts in emerging technologies.

• Leadership qualities for inspiring and leading a team of professionals and ability to work independently. TECHNICAL SKILLS

Languages

SQL, T-SQL, PL /SQL, No-SQL

C#, VB.NET, LINQ

Java, Python

JavaScript, PowerBuilder 6.0 / 7.0, Excel VBA

Databases

MS SQL-Server 2000/2005/2008/2010/2012/2014

Sybase 12.5, Toad for Oracle.

MS Access 2000/ 2007

MySQL, MongoDB

Cloud

Azure, Azure AI / ML, AWS

ETL & Reporting Tool

SSIS, SSRS

Tools & Document Management System

VS 2005/8/10/13, VSS, TFS, MS Visio

GIT, JIRA

Tortoise SVN, UML

SharePoint, Maven

Frameworks

.NET Framework 1.1/2.0/3.0/4.0, WCF

Entity Framework

Design Patterns

MVC

Database Connectivity

ADO.NET, ADO, ODBC, OLEDB, JDBC

GUI

PowerBuilder 6.0 / 7.0, Dot Net, Eclipse, IntelliJ Web Programming

ASP.NET, Regular Expressions, XML, Web Services

Web Forms, HTML, DHTML, XML, XSLT, CSS

Methodologies

Waterfall, Agile/SCRUM

Web Server

IIS 5.0/6.0/7.0

Page 2

PROFESSIONAL EXPERIENCE

Sr. Database Developer May 2018 – Present

D.F. Young New York, NY

Accounting System

Upgrading and maintaining the old accounting systems of client. Planning and estimating to move database as well as migrating from SQL server 2005 to SQL Server 2012 / 2014 using DTS. Responsibilities:

Coordinating directly with Vice President of Information System and gathering requirements.

Creating all the required documents for DTS of accounting system like technical, non- technical, Visio diagram and flow chart etc.

Created / Modified and updated SQL Objects such as Stored procedures, Triggers, Views and UDF’s.

Managed indexes, statistics and optimized queries by using execution plan for tuning the database.

Manage physical database design, implementation and responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.

Created an Excel VBA program to fetch, pivot and convert data into report as per client requirement.

Migrating 2005 DTS packages to 2012 SSIS packages.

Creating a Meta-data repository for database.

Working on creating a blue-print with higher level as well as lower level diagram.

Automated two different Website for testing using Katalon Studio 5.7.1.

Used JUnit and Mockito for unit testing Java Applications.

Reviews and improves query plans.

Optimizing the SQL Query as well as Stored procedures. Technologies: SQL Server 2005 / 2014, SSIS 2012, MS Visio 2013, MS Word 2016, MS Excel 2016, MySQL Workbench 8.0, Katalon Studio 5.7.1, Junit 5, Mockito

Sr. Database Developer / Admin Mar 2016 - April 2018 Bank of America New York, NY

The objective of the project is to develop forecasting strategies based on input from various trading desk. This project is an effort to standardize different wind down strategies followed by trading desk at various geographic locations. This is a part of CCAR regulation for holding companies having assets more than $50 Billion. This is a vigilant project where senior management has high interest and commitment, and time lines are very stringent. Responsibilities:

Coordinating directly and taking requirement from Director of Marketing, stakeholder and business analyst.

Design the new database, tables, views and User defined functions (UDF’s) as per the requirements.

Designed and Created SSIS packages to get data into SQL Server from shared location as well as different data sources such as excel, text file and oracle for data analysis and reporting.

Experience in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.

Scheduled and executed SSIS Packages using SQL Server Agent.

Developed a complex business logic stored procedure.

Created a stored procedure which gets data from Oracle database to the required SQL Server database using linked server.

Created a Meta-data repository for database.

Obtained business requirements through user interview and examining VBA code.

Rewrote Excel business process to use SQL objects rather than VBA code.

Working on bi-weekly sprint cycle.

Created a deployment scripts for QA and successfully deployed in QA environment.

Storing the SQL script in Team Foundation Server 2013.

Training the new team members on the process and project details. Technologies: SQL Server 2014, SSIS, SSRS, SSDT, Toad 12 for Oracle, MS Word 2013, MS Excel 2013, TFS 2013, HPDMA Project Manager Jan 2016 - Mar 2016

Takata Corporation Auburn Hills, MI USA

Takata is automotive parts company manufacturing the different products such as seats, seat belt, air bags and other different part related to automobile.

This is in-house project which involve migration of VB 6 to VB.NET 2012 as well as database from SQL server 2007 to 2012. Responsibilities:

Directly working with Client Manager and Managing and interacting with onsite and offshore teams.

Taking requirement from Client and providing time and resource estimation based on the analysis done. Page 3

Coordinating with Syntel Management team and Client management teams.

Managing weekly meeting with Client and Syntel.

Solving production support issues and development task. Technologies: SQL Server 2012, VS.NET 2012, SSIS, SSRS, MS Word 2013, MS Excel 2013 Sr. Database developer July 2013 - Dec 2015

Moody’s Investors Service New York, NY

Moody's is an essential component of the global capital markets, providing credit ratings, research, tools and analysis that contribute to transparent and integrated financial markets. Project 1: This project involves on quarterly bases updating a HR tables and generate reports automatically twice a day of APAC, EMEA and US region users.

Responsibilities:

Analysis, design and development of HR database. Extensively used ER diagram and normalized tables.

Developed a SQL server tables, stored procedures, UDF's.

Actively involved in design, development and testing of system.

Created Detailed, Summary and reconciliation reports for APAC, EMEA and US Users in SSRS.

Created Matrix, Sub reports and complex reports with multi value parameters to better understanding of data.

Created a SSIS packages so that above reports consume the data mart.

Created a SQL Agent Jobs to schedule it twice on weekdays.

Created a SQL Agent Jobs for Automatic backups, re-indexes the database on weekly/ monthly bases. If any failure occurs then it fires a mail to administrators and managers.

Experience in unit testing, preparation of analysis and unit test document.

Created various documentation for knowledge base using MS word and excel.

Provides process and knowledge transition to the team members and coordinated with project stakeholders. Technologies: SQL Server 2008 R2, VS.NET 2008, SSIS, SSRS, MS Word, MS Excel Project 2: This project involves the data migration from SQL Server to salesforce.com. We extracted the data of one company from salesforce.com and applied some business rules and moved back to saleforce.com in Moody's. Responsibilities:

Extracted the data from data loader to excel to massage the data. Applied some business rules to excel sheet.

Moved data to the salesforce.com in Moody's salesforce.com.

Actively involved in design, development and testing of system.

Developed SQL server tables, stored procedures, UDF's.

Unit testing, preparation of analysis and unit test document. Technologies: SQL Server 2008 R2, VS.NET 2010, MS Word, MS Excel, salesforce.com Project 3: This project involves identifying the mapping fields used by MIS applications across different servers and different applications and creating a catalog. After creating a catalog, we need to find the required fields or objects from the legacy databases then design architecture to do the mapping. Responsibilities:

Developed SQL server Stored procedures using SQL Server meta-data object.

Experience in writing a Dynamic query using system objects or meta-data objects to find out the dependencies between objects and columns used.

Created and automated the regular jobs as per the client requirements.

Created database stored procedures, Views, User-defined functions

Experience in preparation of analysis and unit test document.

Experience in unit testing application.

Technologies: SQL Server 2008 R2, VS.NET 2008, SSIS, SSRS, MS Word, MS Excel Project 4: We have created an application in MS Access which gives reports after fetching the data from the SQL Server. All the logics are written in the SQL Server database. The base data for reports is coming from different sources such as database of internal system; excel file and text files from third party vendors. This application gives regulatory a flexibility to check the data which come from the different sources which we are doing ETL and importing in one database to generate the different reports required for Regulatory. While doing the ETL we are running all the required validation which will accept / reject data from the external vendor. User will see the exception occurs while importing data and another interface where they can generate the required report between the given data range in simple UI. They can drill down the report from the total amount to micro level of the amount.

Responsibilities:

Gathered requirements with BA’s and worked with Enterprise Architect team to develop physical data models

Created ER diagram in MS Visio and created a technical document from functional document.

Created new tables, stored procedures, user defined functions for development team.

Involved in performing data conversions from flat files into a normalized database structure.

Developed source to target specifications for Data Transformation Services. Page 4

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.

Provided disaster recovery procedures and policies for backup and recovery of Databases.

Performance Tuning in SQL Server 2008 using SQL Profiler.

Created different reports in SSRS.

Creating an ETL jobs using SSIS & Pantaho.

Technologies: SQL Server 2008 R2, VS.NET 2008, SSIS, SSRS, MS Word, MS Excel, Pantaho, Excel VBA, MKS Integrity Sr. IT Lead Dec 2012 - June 2013

CUNA Mutual Groups Wisconsin, USA

Web Marketing System

CUNA is a mutual insurance company. It provides financial services to cooperatives, credit unions, their members, and other customers worldwide. The project involves migration of .Net application from 2.0 to 3.5. Converted legacy ASP .Net pages with MVC architecture.

Responsibilities:

Handled 3 projects from onsite (USA) with team size of 6 resources.

Independently worked on database of the project.

Handled a team who worked web-based projects using ASP.NET, VB.NET, SQL Server 2008 R2, MVC, JQuery, JavaScript.

Created / modified database object such as Stored procedures, views and UDF's.

Created / modified SSIS packages as per client requirement.

Created / modified SSRS reports as per client requirement.

Gathering task requirements from the client. Daily Interaction / calls with Offshore team to sync up on tasks. Technologies: SQL Server, SSIS, SSRS, MVC 3.0 (Razor)/ 3.5, VB.Net, ASP.Net, WCF, Web Services, HTML5, CSS3.0, JQuery. Sr. Project Lead July 2007 - Dec 2012

Moody’s Investors Services ODC Mumbai, India

Rast Phase II Development and M&E/Support portfolio, Global Scale Rating – Structure Finance Group (GSR-SFG), SFG Differentiation, Generic Indicator, Dodd Frank – Rating Affirmation, Bond Funds, Host System with UI The project involves providing maintenance, enhancement, support and quality assurance (M & E, Support and QA) services for Moody's information technology's applications. Syntel is carrying out this project for Moody's with teams working both at onsite and offshore.

Responsibilities:

Developed N-tier architecture for presentation layer, the Business and Data Access Layers.

Worked on SQL Server 2008 R2 and Sybase to create / modify and fine tuning the different stored procedures, UDF’s and tables.

Migrated DTS packages to SSIS.

Created new SSIS package as per Functional requirement document (FRD).

Database scripts development as per business specification.

Gathering Task requirements from the client.

Preparation of analysis and unit test document. Coordinating the rollouts for all Tasks.

Provides process and knowledge transition to the team members. Co-ordination with various project stakeholders. Technologies: DTS, SSIS, SQL Server 2005/ 2008, SSIS, SSRS, Sybase 12.5, MKS Integrity Senior Software Engineer Apr 2006 –June 2007

Satyam Computer Services Limited (Microsoft Ltd) Hyderabad, India 1. Microsoft Certification:

Microsoft Learning Platform Group manages Microsoft Certified Professional (MCP) and Microsoft Certified Trainer (MCT) program applications, and also has two external examinations Microsoft Office Specialist (MOS) and Microsoft Business Solutions (MBS).

2. Readiness Requirement Management System (RRMS): The Readiness Management Solution is a distributed application which provides solutions to various courses through Role Guide by integrating the Requirements and Solutions. Microsoft Visual Studio .NET XML Web services and SQL Server 2005 technologies are used to provide role-based security, scalability and performance. Responsibilities:

Created database objects such as tables, stored procedures, user-defined tables (UDF's).

Involved in functional testing of the modules developed by the Team Members.

Development of Business Rules and Data Access Layer using Web Services, C#.

Development of SQL Server Objects (i.e. Stored Procedures, views etc.).

Written the front-end code using C# and ASP.NET. Written & Executed Test Cases in Product Studio.

Reviewed other member’s database scripts and stored procedures. Page 5

Database scripts development as per business specification. Deployment of scripts to End to End Environment. Technologies: SQL Server 2005, DTS, VSS.

Technical Consultant Aug 2004 - Mar 2006

Dreaming Code Inc., (TNM Realty, Piggy Bank, Amy Draper) Mumbai, India 1. piggybanc.com:

Piggybanc.com has a tie-up with the local bank. This site enables parents of the new born baby to email to their friends & relatives asking them to contribute for their Childs future. They can make online payments through the online check, credit or debit card. This also shows the content on website using Content Management System. 2. TNMRealty.com

TNMRealty gives user the detail of rental & sales listing with content Management. User can search the required Rental and sales properties listed & available in the system. User can request for the available property by filling the Request List form. The Content, Rental and Sales are managed by the Real Estate Management System. Technologies: SQL Server 2000 / 2005, VSS.

.Net Developer Dec 1999 - July 2004

eCom Technovation (Metro exporter Ltd) Mumbai, India 1. Code Generator:

Code generator can be used by any organization that has their development platform as dot net. By using this project, the user can define any form, which is the main building block of any project with just a few mouse clicks. This project generates the ASPX code and corresponding VB or C# code with core functionality of Add, Edit, Delete, Search Paging etc. By using this project any organization can reduce the development time of their projects and thus can increase the profit. 2. Content Management System

Content management system manages the content, which is visible on the web pages for various links associated to a particular web site. User can add, edit or delete records under each topic or content part. Along with content, the administrator can give rights to particular user to manage with respective logins to view the detail of a particular page. 3. iERP

This project is a net development. This is one of the modules of Enterprise Resource Planning. This is a full fledge Inventory Management System which is the very important need of any organization having multiple business activity, locations can implement This project to increase the overall performance efficiency of their organization by multifold. Responsible for Production planning control in any manufacturing industry which constitutes generation of sales order, Composition master for particular product and its estimation, production indent to fetch the required RM from Inventory. Based on this the customized report is made to get the batch wise RM consumption and its details. Responsibilities:

Created database objects such as tables, stored procedures, user-defined tables (UDF's).

Optimize the required queries, stored procedures and UDF's.

Database scripts development as per business specification.

Worked on PowerBuilder 6.0 / 7.0 as Client / Server Application with SQL Server and MS Access as back-end.

Created a new database with all objects such as tables, views, stored procedures etc.

Gathering Task requirements from the client.

Provides process and knowledge transition to the team members.

Co-ordination with various project stakeholders.

Coordinating the rollouts for all Tasks.

Technologies: PowerBuilder 6.0/ 7.0, SQL Server 2000 / 2005, DTS, MS Access, ASP.NET, C# EDUCATION

Bachelors from University of Mumbai (India), Year 1996 Certifications:

dNIIT from NIIT Ltd., Mumbai (India)

Oracle 8i from Aptech Ltd., Mumbai (India)

Microsoft Certified Professional (MCPS - SQL Server) in Nov 2016.

Microsoft Certified Azure Fundamentals in June 2019.

Microsoft Certified Azure AI Fundamentals in August 2020.

AWS Certified Cloud Practitioner (Issue Aug 2020 – Aug 2023).

Contact this candidate