SUMMARY

• Highly motivated, hard - working individual with 6 years of experience in IT industry and domain focused on Microsoft SQL Server 2008/2008R2/2012, SSIS/SSRS
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS)
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance
• Expertise in writing T-SQL Queries using Joins, Sub queries in MS SQL server 2008/2012
• Strong experience in writing stored procedures, functions, triggers in MS T-SQL building the packages, testing and implementing on production server
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process
• Involved in designing DTS/SSIS Packages to extract, load data into database, archive data file from different legacy systems and Data Mining in SSIS
• Migrated data from external system including flat files, excel, MS Access and oracle into SQL Server 2008 using SSIS packages
• Extensive experience in Extract Transform Load (ETL) process using Microsoft SSIS
• Developed SSIS packages using various Control Flow and Data Flow tasks like Derived Columns, Condition Split, Execute SQL Task, Bulk Insert, Send email, FTP Task
• Good experience with SSIS package Configuration, Deployment
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, and Logging using SSIS
• Expert in performance tuning, query optimization and running database
• Experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production
• Responsible for development, implementation and maintenance of application software.
• Good interpersonal and Communication Skills.
• Good analytical skills with problem solving capabilities, sense of responsibility, creative and soft-spoken
• Having concentrated knowledge in SQL Server, VBA and SDLC.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using VBA Macros and SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)

TECHNICAL SKILLS

Microsoft Technologies: .NET 3.0,ADO.NET

Web Technologies: XML, HTML, CSS

Languages: VB.NET, SQL, Transact SQL, PL/SQL

Database: SQL Server 2008/ 2008 R2/2012, Oracle 10g

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Operating System: Windows XP, Windows 7, Windows 8, Windows Server 2003/2008/2010

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management StudioSQL Server 2008 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

Other Tools: HP Quality Center, Sabre Movement Control

PROFESSIONAL EXPERIENCE

Confidential, New York City

SQL Developer

Tools: used Microsoft SQL 2012, Sabre Movement Control, HP Quality Center

Responsibilities:

• Analysis of developed SQL data model & code
• Creation of SQL Stored procedures to analyze and verify the correct data population
• Writing T-SQL queries, temporary tables, SQL jobs
• Creation of SSIS packages to migrate Ad-Hoc Extract file data to SQL server
• Involved in validating various flight events using Sabre Movement Control

Confidential, Tampa FL

Sr. SQL Developer / Module Leader

Tools: usedMicrosoft SQL 2010, SSIS

Responsibilities:

• Development of SQL Database structure & data model
• Migration of data from Oracle to SQL server using SSIS Packages
• Co-ordination with client on daily basis to meet the functionality requirements
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent
• Imported data from text files and excel spreadsheets into SQL Server 2010 database using SSIS package.
• Involved in scheduling the backups and SQL jobs
• Lead the module of offshore team

Confidential

SQL Developer

Tools: usedMicrosoft SQL 2008, MS Excel

Responsibilities:

• Involved in and creating the database structures and data model
• Automation of processes by creating SQL jobs and stored procedures
• Involved in Preparing Process/design documents, Data Model and Requirement documents.
• Involved in coordinating with Client to synchronize the requirements that meets the functionality requirements
• Wrote queries to generate reports for analysis of data using SQL Server, Report Builder

Confidential

SQL Developer

Tools: usedMicrosoft SQL 2005, MS Office 2003 VBA Macros

Responsibilities:

• Involved in writing the SQL procedures and creating the database structures.
• Developed User Interface using Excel Forms and VBA Macros
• Involved in Preparing Process/design documents, Data Model and Requirement documents.
• Client co-ordination to meet the functionality requirements

Confidential

SQL Developer

Tools: usedMicrosoft SQL 2008, MS Office 2007, VBA Macros

Responsibilities:

• Involved in writing the SQL queries to fetch the data for reports according to the client’s requirements.
• Automated reports using VBA Macros to tune the performance of report generation.
• Delivered the reports on the timely basis to clients, Client interaction on daily basis
• Preparing process & project documents and Traceability Matrix.

Confidential

.Net Developer

Tools: usedVB.Net, Microsoft SQL 2005, Winforms, Subversion

Responsibilities:

• Development of code using VB.NET
• Involved in Business Logic Layer creation
• Development of SQL objects - tables, views, stored procedures
• Prepared Design documents such as High Level document, Low-level document, unit test scripts and Traceability Matrix.