DEEPIKA JADAV

SUMMARY

SQL Server BI (SSIS, SSAS, SSRS) Developer

. Over 6 years of experience in IT, with primary

skill on the Analysis, Design, Development,

Implementing and Testing Client/server application

using Microsoft SQL Server and BI suite.

. Experience across all phases of SDLC from project

initiation to post-implementation

. Experience in installing, configuring, managing,

upgrading and migrating, monitoring and

troubleshooting SQL Server 2000/2005/2006/2008

R2/2012.

. Created SSIS Packages using Various Transformation

like Lookup, Derived Columns, Condition Split,

Data Conversion, Aggregate, Merge Join, Sort,

Execute SQL Task, Data Flow Task, and Execute

Package Task etc. to generate underlying data for

the reports and to export cleaned data from Excel

Spreadsheets, Text file, MS Access, SQL Server,

Oracle, FTP Server, XML files, CSV files.

. SQL Server development including DTS, Microsoft

Analysis Services, Performance tuning, Reporting,

Designing logical/physical databases and

Troubleshooting.

. Experience in Data Modeling (Logical and Physical Design of

Databases), Normalization and building Referential Integrity

Constraints.

. Very good knowledge in HIPAA compliance.

. Good Hands on experience dealing with On-

Site/Offshore model and worked with Development,

Production Support and Quality On-site/Offshore

experience.

. Experience in Data Warehouse Modeling with SQL

Server Analysis Service (SSAS).

. In-depth knowledge of T-SQL, SSAS, SSRS, SSIS,

OLAP, OLTP, Reporting and Analytics.

. Created SQL Server Analysis Projects (SSAS) and

proficient in Referenced relationships for

Business Intelligence applications using MS SQL

Server 2005/2008.

. Experience in writing efficient multi-dimensional

expression (MDX) as per the design requirements.

. Created OLAP Cubes and performed data mining on

the data using the fact table and the dimension.

. Expert in Cube Designer in Business Intelligence

Development Studio(BIDS) to edit various

properties of a cube, including the Measure

groups and Measures, Cube dimensions and

Dimension relationships, Calculations

. Experience in SQL Server 2000/2005/2008 R2/2012

RDBMS database development including T-SQL

programming.

. ETL skills, Data modeling, Dimensional Modeling

knowledge with experience in developing data

movement, data cleansing and data integrity

processes for the purposes of loading decision

support applications utilizing advanced knowledge

of DTS packages and Transact SQL, design and

support/enhancements/maintenance.

. Microsoft Reporting Service (SSRS) with Report

authoring, Report management, Report delivery and

Report security. Experience in developing User

reports and management reports using MS SQL Server

Reporting Services (SSRS).

. Designed complex SSAS solutions using multiple

dimensions, perspectives, hierarchies, measures

groups and KPIs to analyze performance of

Strategic Business Units as well as corporate

centers. Knowledge in Data modeling, creating star

and snowflake schemas in SSAS

. Supported team in resolving SQL Reporting services

and T-SQL related issues and Proficiency in

creating different types of reports such as Cross-

Tab, Conditional, Drill-down, Top N, Summary,

Form, OLAP and Sub reports, and formatting them.

. Experience in creating indexed views, complex

stored procedures, effective triggers, and useful

functions to facilitate efficient data

manipulation and consistent data storage.

. Expert in Extraction, Transforming and Loading

(ETL) data flows using SSIS; creating

mappings/workflows to extract data from Oracle,

SQL Server and Flat File sources and load into

various Business Entities.

. Experience in working on C#.NET and ASP.NET web

pages

. Extensive use of DTS in SQL Server, T-SQL, Stored

Procedures, Functions and Cursors and Triggers

etc. Extensive experience in data migration

between homogenous and heterogeneous system using

various tools (Data Transformation Services (DTS),

SSIS).

Technical Skills

. Databases: SQL server 2000/2005/2008 R2/2012,

MS Access, Informix, Oracle 11g

. Operating Systems: Windows XP/7

. OLAP/Reporting Tools: SQL Server Analysis

Service (SSAS), SQL Server Reporting Service

(SSRS), MDX, Cognos, Framework Manager

. ETL Tools: SQL Server Integration Services

(SSIS), SQL Server DTS, Informatica, Data Manager

. Other Tools: Microsoft Visual Source Safe,

Microsoft Office, MS Visio

. Data Modeling Tools: Microsoft Visio 2008/2010

. SQL Server Tools: SQL server Management Studio,

SQL server Query Analyzer

. Programming languages: C, SQL, PL/SQL, T-SQL,

C#, Asp.NET, C, C++, Java, VB 6.0, VB.NET

. Data Modeling: Star Schema Modeling, FACT,

Dimensions Tables, Physical and Logical Data

Modeling

. Data Warehousing & BI: SQL Server, Business

Intelligence Studio, SSIS, SSAS, SSRS (SQL Server

Analysis Services and SQL Reporting services),

DTS.

PROJECT EXPERIENCE

Client: MedAssets Inc

Saddle River, NJ

November 2014 Till Date

ETL (SQL/ C#/SSIS) Developer/

Data Programmer

MedAssets work with clients to identify

and sustainably reduce the primary drivers of the costs of delivering

healthcare. They team with clients to make sure they're achieving optimal

operational results

through best practices on

processes and the use and management of people and non-labor expenses. They

help providers define, implement and adhere to clinical processes and

standards that lead to measurable.

improvements in quality of

care and patient safety. They partner with clients to implement processes

and technologies that optimize capturing the reimbursement they've earned,

and to help them navigate evolving

healthcare business and

payment models

Responsibilities:

. It's a DTS to SSIS migration project wherein we

migrate DTS i.e. the old version of SSIS to

version 2008.

. It also includes all the conversions within the

existing SSIS packages wherein we covert the

VB.NET code to C#

. Extensive use of C# and VB.net scripts to parse

files, read files, extract data, performs

transformations and load the data.

. Created joins and sub-queries for complex queries

involving multiple tables.

. Creating hash keys using a user defined

function in SQL to accomplish unit testing of all

SSIS packages. This is done to ensure that the

packages are converted correctly and data matches

as per the transformations done in SSIS to the

transformations done in SQL stored procedure and

in a function

. Extensive VB.NET to C# code conversion for all

the hospital projects

. Created SSIS Packages using SSIS Designer for

export heterogeneous data from various text files, Excel Spreadsheet to SQL Server 2008 R2/2012.

. Experience in Extracting, Transforming and

Loading (ETL) data from Excel, Flat file to MS SQL

Server by using SSIS services.

. Designed and developed SSIS (ETL) packages to

validate, extract, transform and load data from

OLTP system and CSV Files and load into staging

tables and further those loaded into the warehouse

. Involved in migration of DTS Packages (2000) to

SSIS (2008) and troubleshoot migration issues

. Experience in creating SSIS packages using

different type's task and with Error Handling.

. Designed SSIS Packages to extract, transfer,

and load (ETL) existing data into SQL Server from

different environments

. Experience in creating complex SSIS Packages

with error handling using control and dataflow

elements.

. Optimization of procedures and queries.

. Migrated DTS packages and SQL Server 2005

packages to SQL Server 2008 R2

. Weekly work updates given to manager

Environment: MS SQL Server 2000,2005/2008 R2,

Management Studio, BI Suite, DTS, Data Modeling,

VB.NET,C#, OLAP, OLTP, T-SQL, ETL-SSIS

Client: UPS Capital, Atlanta,

GA

April 2014 to October 2014

ETL (SQL/ Data Manager/SSIS)

Developer/Production Support

UPS Capital, the financial

services business unit of United Parcel Service, offers traditional and non-

traditional financial services and insurance products

Responsibilities:

. Created joins and sub-queries for complex

queries involving multiple tables.

. Led the support for all the ETL related

technical issues related to global data warehouse

as well as Logistics (NALS &PALS) datamart

. Generated dynamic stored procedures for the

database development.

. Provided level 2 & 3 ETL support for low and

high priority issue using SSIS and Data Manager

ETL tools

. Created SSIS Packages using SSIS Designer for

export heterogeneous data from OLE DB Source

(Oracle), Excel Spreadsheet to SQL Server 2008

R2/2012.

. Experience in Extracting, Transforming and

Loading (ETL) data from Excel, Flat file to MS SQL

Server by using SSIS services.

. Designed and developed SSIS (ETL) packages to

validate, extract, transform and load data from

OLTP system and CSV Files and load into staging

tables and further those loaded into the warehouse

. Involved in migration of DTS Packages (2000) to

SSIS (2008) and troubleshoot migration issues.

Expert in generating drill down Reports in SSRS

2005/2008/2012.

. Experience in creating SSIS packages using

different type's task and with Error Handling.

. Designed SSIS Packages to extract, transfer,

load (ETL) existing data into SQL Server from

different environments for the SSAS cubes.

. Experience in creating complex SSIS Packages

with error handling using control and dataflow

elements.

. Optimization of procedures and queries.

. Experience in creating complex SSIS packages

using proper control and data flow elements.

. Created SSIS Packages to migrate slowly

changing dimensions. Scheduling the SSIS packages

and Jobs.

. Designed SSIS Packages to extract, transfer,

load (ETL) existing data into SQL Server 2000, SQL

Server 2008 and SQL Server 2005.

. Weekly work updates to client

. Developments and enhancements both in Data

Manager and SSIS

. Documentation for all the work done. The same

being shared with client

Environment: MS SQL Server 2005/2008 R2, Management

Studio, BI Suite, DTS, Data Modeling, VB6, OLAP,

OLTP, T-SQL, ETL-SSIS, ETL-Data Manager, Cognos

Client :Jubilant, Gurgaon,

India

February 2012 to March 2014

SQL BI (SQL/SSIS) Developer

Jubilant Food Works Limited

(the Company) is a Jubilant Bhartia Group Company. The Company was

incorporated in 1995 and initiated operations in 1996.

The Company & its

subsidiary operates Domino's Pizza brand with the exclusive rights for

India, Nepal, Bangladesh and Sri Lanka. The Company is India's largest and

fastest growing food service company,

Responsibilities:

. Analyzed the requirements and selected the

appropriate tables that is to be populated

. Migrated DTS packages from SQL Server 2005 to

SQL Server 2008 as SSIS Packages.

. Involved in migration from SQL Server 2005 to

SQL Server 2008.

. Experience in building and maintaining Data

marts.

. Wrote DTS packages to transfer data from

heterogeneous database & different files format

(Text File, Spread Sheet) to SQL Server.

. Created tables for data warehousing

applications and populated the tables from the

OLTP database using DTS packages

. Materialized views, dimensions and stored

outlines for optimal performance

. Wrote Triggers and Stored Procedures to capture

updated and deleted data from OLTP systems

. Published high-level technical documentation to

set standards, guidelines and best practices for

SQL Server Database Design, Coding Standards,

Periodic Data refresh, across the enterprise

Environment: SQL Server 2000/2005/2006/2008

Enterprise Edition, SQL BI (SSIS), XML, C#.NET,

Oracle.

Client:JDIrving, Canada,

St. John January 2011 to January 2012

SQL BI (SSIS/SSRS)

Developer

Founded in 1882, J.D. Irving, Limited

(JDI) has operations in Canada and the United States. They are a team

of 15,000 dedicated employees, with business units in:

Forestry & Forest, Products

Transportation Shipbuilding & Industrial Marine, Retail, Industrial

Equipment, Construction Services & Building Materials Consumer

Products.

It was a migration project

which had two modules Data Migration and Integration

Data Migration

Requirement was to migrate

the data for some of their companies from older version of JDE to

enterprise one version of JDE through SSIS

Data Integration

To integrate all the data

from third party sources using SSIS based on the business logic shared by

client

Responsibilities:

. Developed SSIS packages using SQL server

integration services version 2005, 2008 and 2012.

. Migrated JDE data from AS400/World soft to JDE

E1using SSIS packages

. Extracted data from heterogeneous systems like FTP

Server, Oracle, SQL Server, XML Files, CSV files

transforming them according to the business logic

and requirements gathered from client.

. Used many SSIS components like Execute SQL Task,

Conditional split, Data Flow Task, lookup,

. Sequence container, for each loop container,

Merge, Merge Join, Union all, Derived column, data

conversion etc.

. Involved in Optimization of SQL Server queries

. Reviewed and worked on Testing of SSIS packages

for the Team

. Proposed solutions to Team for complex client

requirements for the development in SSIS

. Played leadership role from and for the offshore

team on Integration module.

. Interacted customers weekly for sharing the

updates

. Documented design of SSIS packages using Visio

2007, 2010

. Reviewed design documents from peers

. Developed various operational Drill-through and

Drill-down reports using SSRS

. Developed different kind of reports such a Sub

Reports, Chars, Matrix reports, Linked reports

. Used cascaded parameters to generate a report from

two different Data Sets

. Actively involved as part of team for gathering

and analyzing the needs of end user requirement

and system specification.

. Guided team on the development of the requirements

that were received periodically from client

. Worked on scripting with Vb.NET and C# in SSIS

packages.

. Worked with complex T-SQL using SSIS.

. Worked on complex XML files and performing XSLT

operations through Script as well as XSLT

transformation.

. Created Stored Procedures, Triggers, Functions,

client specific Views for the Application.

Extensive testing on the Performance of the Stored

Procedures.

. Optimized SQL queries for efficiency and provided

queries and procedures for the front-end

application.

. Imported and exported data to and from various

heterogeneous sources using various techniques

like DTS.

. Extracted data using SSIS from OLTP to OLAP.

. Created ad-hoc queries and reports as requested

and provide on-going analytical support for these

requests.

. Migrated DTS packages from SQL Server 2000 to SQL

Server 2005.

. Used various advanced SSIS functionalities like

complex joins, conditional splitting, column

conversions etc. for better performance during

package execution.

Environment: SQL Server 2005/2008, OLAP, OLTP, MS

Excel, Visio 2005/2007, C#.Net, DTS, T-SQL, SSRS 2008

Client: Vestergaard Frandsen,

Mumbai,India

January 2009 to December 2010

MS SQL (SSIS) Developer

Vestergaard is an

international company dedicated to improving the health of vulnerable

people, most of who live in developing countries.

Responsibilities:

. Installed and configured SQL Server 2005

successfully

. Used the concepts of priority constraints,

looked up tables to validate data while dealing

with SSIS

. Developed and scheduled the SSIS packages to

perform the ETL tasks like creating a

datawarehouse

. Troubleshot SQL database transaction log files

related issues

. Performed ad-hoc analysis and reporting

. Generated daily, weekly and monthly reports for

the managers using Excel

. Developed and implemented the SQL Server

Integration Services (SSIS) packages to populate

the data into the Enterprise Data Warehouse from

various sources like Flat File Source, Excel

Source into OLEDB Destination (SQL Server)

. Transformed data from various data sources

using OLEDB connection by creating various DTS

packages

. Created SSAS cube and generated SSRS reports

out of it

. Client handling through calls and emails

independently

. Timely documentation on the work and to be sent

to client

. Client handling through calls and emails

independently

Environment: SQL SERVER Integration services, MS SQL

Server 2005 Enterprise Edition, T-SQL, MS Office

2003, MS Excel and Windows XP

Client:Systime Computer

Corporation, Mumbai,India

June

2008 to December 2008

C# Developer/ Programmer

SYSTIME Computer Corporation

provides systems integration and consulting services. Its solutions include

accounts payable process automation solutions that help customers to

identify

areas of improvement in the

accounts payable process; and invoice processing solutions. The company

also provides VersaPOS, an end-to-end retail management solution developed

for retailers.

Requirement was to develop web

application for resource management and analysis of metrics associated with

resources management operations, also integration between SRMS database

with

project management tool

PSA, reports and dashboards through SSRS 2008.

Responsibilities:

. Gathered requirements from the Resource

Management Group/RMG for developing the website

. Extensive use of C#.NET and ASP.NET to create

web pages using SQL SERVER 2008 as a backend

. Extensive use of AJAX controls to embed advance

features on the webpage

. Unit Testing, Integration testing to ensure

website works as expected

. Created OLTP design, establishing logical and

physical design for sql server data tables

. Created relationships therefore creating a Data

Model, Created tables and view

. Created SSAS cube so that the reporting can be

done on this cube.

. Developed reports in Cognos with meaningful

information that an end user would like to see

about the resource, Resource project allocation,

Project release etc.

. Developed various operational Drill-through and

Drill-down reports using SSRS

. Developed different kind of reports such a Sub

Reports, Charts, Matrix reports, Linked reports

. Created parameterized Reports

. Actively involved as part of team for gathering

and analyzing the needs of end user requirement

and system specification.

Environment: Windows XP, C#.NET, ASP.NET, MS SQL

Server 2008, SSRS 2008

Contact this candidate