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