sql developer

SUSHANT YADAV

A seasoned IT professional with about 6 years of industry experience, Sushant has a rich experience working on the strategic and mission critical projects. He has worked on all the stages of Software Development Life Cycle (SDLC). Sushant has extensive experience on SQL Server Databases in almost all the fields, e.g. Design, Development, Administration, Migration, Tuning, Integration, Reporting, Clustering, High Availability, Failover Scenarios, Backups, Restore and Recovery, etc. He has also worked on Mainframe systems for DB2 databases and COBOL language.

Technical Skills :

Operating Systems Windows Vista/XP/NT/XE 98, MS-DOS, IBM mainframes.

Programming Languages C, C++, SQL, PL/SQL, T-SQL, COBOL, VB/.NET, ASP, JCL, XML, HTML.

Databases MS SQL server 2000/05/08, Oracle 9i 10g, MS Access, IBM DB2 RDBMS.

Tools MS Dynamics, Citrix, SSMS, DTS, SSIS, SSRS, SQL profiler, Query analyzer, Visual studio 05/08, XSLT, XSD, ADO.NET, ETL, Crystal reports, Informatica 8.1, BI tool- Web intelligence Rich client.

Architectures Internet, LAN, WAN, OSI, TCP/IP, HTTP, CDMA, GSM.

Summary :

• SQL Server Developer having more than 5 years of experience in the Database Design, support and implementation.

• Expert in installation, upgrade and configuration of MS SQL Server database.

• Expert in migrating XML scripts into SQL server 2008.

• Good command in writing complex queries, stored procedures in SQL Server 2005, 2008, proficient in migrating the data from SQL Server 2005 to SQL Server 2008.

• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.

• Experience in data warehouse design and analysis of various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.

• Experience with SQL Server 2000 and MS SQL Server and worked extensively on BI tools (Integration services (SSIS) and Reporting services (SSRS)) and Analysis services (SSAS).

• Transformed data from one server to other servers using tools like Data Transformation Services (DTS) (2000) and Sql Server Integration Services (SSIS) (2005).

• Transformed database objects from one server to others server using SSIS.

• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.

• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and u\sable business information using SSAS.

• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages.

• Experience in using tools like Database Engine Tuning Advisor 2005 Experience in report writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.

Professional Experience :

1. XPRODATA, Chicago, IL (Aug’07 – Present)

Role: SQL DBA

 Worked on MS Dynamics GP on the front end and SQL SERVER 2005 on the back end.

 Performed backup and restoring of database frequently.

 Implemented joins and queries (T-SQL) for the business analyst to make reports.

 Monitored the performance of the database using SQL server profiler using traces.

 Designed projects involving SSIS and Informatica power center 8.1(ETL).

 Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.

 Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.

 Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services 2005/2008(SSIS).

 Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

 Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using BI tool (SSRS).

 Performed Migration of SQL servers from SQL Server 2000 version to SQL Server 2005/2008 Edition.

 Setting up and Automatic/Forced fail over for the production servers using Log Shipping, Mirroring, Replication and Clustering.

 Additionally, designed and implemented a disaster recovery system.

 Involved in SQL security and planning; administrating and creating user accounts for proper access, SQL/Server system databases and tables, SQL Profiler and Enterprise Manager/Management Studio, and Server monitoring to ensure adequate CPU, disk space, and memory on all SQL servers.

 Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server 2005 with high volume data.

 Implemented SSIS for data transformation logic process.

 Designing and building data load procedures, using MS SQL Server.

 Created packages using Integration Services for data extraction from Flat Files, Excel Files OLEDB etc to Access etc.

 Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.

 Working with Different methods of taking Database Backup and Recovery procedures.

 Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

 Generated database SQL scripts and deployed databases including installation and configuration

 Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.

 Working with different types of Replication Models like Snapshot, Merge and Transactional.

2. TATA CONSULTANCY SERVICES (TCS), India ( Mar ‘07- Aug ’07)

Role: Assistant Systems Engineer

 Worked on OS IBM Mainframes including COBOL, JCL & IBM DB2 elementary.

 Implemented the waterfall and spiral model. Gained hands on in CICS, VSAM, MVS, REXX, TSO.

 Developed the different phases of SDLC and testing at the end of each deliverables. The testing involved Black box, white box, alpha and beta testing.

 A project on Library management system

The objective was to demonstrate the skills learned in training of IBM mainframes. This application covered the aspect of Add/Update/Delete of Books in a particular Branch, Add/Update/Delete of Branches in Library, Issuance/Submission of books, Calculation of late fees & Report Generation. It included the Documentation, Analysis, Design and Software Testing.

3. SHANT MARKETING, India (Jan ’04 - Feb’07)

Role: SQL Developer & DBA

 Installation, configuration and up gradation of server, tools and applications.

 Implemented T-SQL, PL/SQL scripts, triggers, procedures, packages.

 Created and managed database objects (tables, views, indexes, etc.) per application specifications. Implemented database procedures, triggers and SQL scripts for development teams.

 Monitoring, tuning, troubleshooting and optimizing databases. Performing data mirroring, backup, recovery and migration.

 Performance tuning of SQL statements using SQL server profiler.

 Worked on Informatica, transforming the data sets and then loading them onto the server.

 Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

 Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

 Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.

 Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.

 Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs

 Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

 Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

 Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.

 Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.

 DDL Scripts for generating Tables, Views, Functions.

 Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.

 Scheduling Jobs, Backups and Restore database

 Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

 Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database.

 Performance tuning, query optimization and execution plan of queries for better performance.

 SSRS installation and report server configuration.

 Configured IIS and Deployed Reports and Analysis Project in to server.

 Extended Data to XML and Excel Spread Sheet.

 Developed reports using BI tool SSRS 2005 and Crystal reports, used table control, matrix control for cross tab reports.

 Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.

 Designed and created Report templates, bar graphs and pie charts based on the financial data.

 Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.

 Writing and testing stored procedures.

 Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

 Created SSIS packages to capture the daily maintenance plan scheduled jobs status (success / failure) with a status report daily. Also created SSIS package to list down the server configuration, database sizing, non-dbo owned objects, public role privileges necessary for the Monthly report as per the audit requirement.

 Extensively used the ETL Design skills for aggregations, lookups, transformations and expressions.

 Created and developed Stored Procedures and Functions in PL/SQL for the front end.

 Creating Tables, Synonyms, Views. Wrote database triggers. Created Cursors using PL/SQL.

 Performed all aspects of database administration, including data modeling, backups/ restoration and recovery

Certification:

Microsoft Certified Technology Specialist (MCTS) in SQL Server 2005 Implementation and maintenance. Cleared exam with 100% marks.

Education:

B Sc. Enggineering ( Electronics & Communication )

Contact this candidate