Resume

Sign in

Sql Server SSIS

Location:
Rockaway, New Jersey, 07866, United States
Posted:
May 30, 2017

Contact this candidate

Sapna Brahmbhatt

Cell No # 201-***-****

Email: ac0jy7@r.postjobfree.com

Rockaway, NJ

Professional Summary

5+ years of experience in development, design and support of Microsoft SQL Server 2000/2005/2008R2

Proficient in transforming data from various sources to SQL Server using SSIS. Extensively used C#.net language in script task.

Expert in creating SQL objects like tables, stored procedures, views, indexes, triggers, user defined functions

Knowledge of SSAS for developing cubes, SSRS as analytical tool and complete software development lifecycle

Worked extensively on Excel and Excel VBA to generate and automate analytical reports

Excellent analytical, interpersonal and communication skills. Fast learner, hard working and versatile team player

Education

Master of Science in Computer Science

Stevens Institute of Technology, Hoboken, NJ

Bachelor of Science in Electrical Engineering

M.S. University, India

Technical Skills

Database : SQL Server 2000, 2005 and 2008R2

Languages : T- SQL, C#.net, VB.net, PHP, JavaScript

ETL Tools : SSIS

Operating Systems : Windows family (2003, 5, 7, 8, XP)

Reporting Tool : MS Excel, SSRS

Work Experience

Volt Consulting Group, Parsippany NJ Nov 2011 to Present

Role: Business Intelligence Developer

Created Databases, tables, Cluster/ Non Cluster Indexes, views, Stored Procedures, Functions, Joins to retrieve data from different SQL tables

Extensively involved in the full life cycle analysis, design, building, documenting, deploying and testing of ETL project using SQL Server Integration Services in both Production and Development environment

Worked on creating dynamic SSIS packages to transform data from various sources like SQL Tables, MS Excel files, Flat files, CSV files to staging area in SQL DB using user variables, Expressions and Script Task

As part of enhancement of ETL project, which loads various CSV files into SQL table, worked on loading multiple files for same client for the same source in the same table depending on the availability of files

Used various SSIS transformations and tasks such as Execute SQL Task, For Each loop container, Data Flow Task, Data Conversion, Scrip Task

Extensively worked with different VMS Systems like IQN, Field Glass, PeoPleFluent by creating and scheduling CSV reports, then uploading those reports to SFTP server, using windows script bring reports from SFTP server to production server and finally load those into SQL DB

Excellent experience in maintaining batch logging, Error logging with Event Handlers and configuring connection manager using SSIS

Experience in backing up and restoring databases, creating and scheduling SQL Server Agent jobs for running various SSIS and DTS packages

Experience in creating ad-hoc reports depending on client requirements

Worked on automating various monthly reports using SSIS and Excel VBA

Experience in creating custom Ribbons using Excel VBA

Worked on delivering Excel scorecards which provides different analytical stats to the client regarding their Suppliers

Also got an opportunity to train Junior Business Intelligence Developer on all Data Warehousing existing processes

Got some exposure to Wanted Analytics tool to pull some market rates for market analysis

Certificates

Six Sigma Yellow Belt

Academic Project in Stevens Institute of Technology

Created a website for students to post any events, sell their books, electronics etc using PHP and JavaScript. Used phpMyAdmin as a database system to store records of users

To do so they have to create an account and all the posts were monitored and accepted/rejected by an admin



Contact this candidate