Project Sql Server

Deepika J

Name Deepika K Jadav

Address Mumbai, India

Telephone +918*********

Personal Email *******.*********@*****.**.**

ID

Visa H1-B USA valid till Sep 2015

Nationality India

Current KPIT Cummins Info Systems

Employer

Work duration Since July 2011 till date

[A] Summary

. H1-B Visa Status : Ready and Valid till Sep 2015

. Overall 3 years of experience in SSIS,SSRS, SSAS

. 6+ months of experience in Informatica, Data Manager and Cognos 8

. Knowledge of Database and Data Warehouse

. Knowledge and expertise on JAVA, VB 6.0,, ASP.NET,, C#.NET, VB.NET

. Currently learning Tableau Data visualization Tool

. Self-motivated, organized, team player and quick learner

. Have good team leading capabilities

. Exposure to project documentation processes

. Excellent written and verbal communication

. Customer centric and flexible enough to mould myself against changing

requirements, strict deadlines and challenges

[B] Skill Sets

Databases: Oracle-10g, MS SQL Server 2000,

MS SQL Server 2005, MS SQL Server 2008, MS Access

Operating Systems: Windows 2003/XP, UNIX

Reporting Tools SSRS, COGNOS 8, COGNOS 10

ETL Tools SSIS, Informatica, Data Manager

Analytical tools SSAS, Cognos Framework Manger

Data visualization Tableau Desktop

Tool

Languages & Tools: C, C++, Java, HTML, JavaScript, VbScript,

ASP-3.0 XML, ASP.NET,

AJAX, JSP, Servlets, C#,

Other Software MS-Office, VSS, MS-Project, HTML, Servlets,

Microsoft Visio 2010, StarUML

[C] Project Experience

Praxair

> Project details

Work Duration: 1sth Oct. 2013 - Till date

Project: Data warehouse and BI support for their existing data

warehouses being developed for different regions

Role: As an ETL developer, I am responsible

. For providing level 2 & 3 support meaning

support for low and high priority issues

. Weekly work updates to client on call

. In assisting team mates in providing 2nd

level support if issues are not solved by

them

. For developments and enhancements both in

Data Manager and SSIS

Environment: OS: Windows XP

ETL Tool: SSIS 2008, Data Manager

Reporting tool: Cognos 10

Database: SQL Server 2008, Oracle 11g

Covidien/ Esmart Financials

> Project details

Work Duration: 19th Feb 2013 - 31st August 2013

Project: Client wanted to load financial data of shipments to the

existing shipment data primarily to show the same

through Cognos reports using Query studio.

Role: As an ETL Lead,

I was responsible

. To drive all the phases of project starting

from requirement gathering till go live.

. For sending weekly status report s to client

. For sending BRD, FSD, TSD to client

. For maintaining project doc repository with

KPIT on server. Liaison with quality team on

all the reviews of project documents and making

changes accordingly

. For proposing solutions as per SSIS best

practices, need to lead problem solving for

ETL,

. For timely delivery of deliverables through

one or more ETL consultants.

. In a nut shell was responsible for driving

project success on ETL front.

Environment: OS: Windows XP

ETL Tool: SSIS 2008

Reporting tool: Cognos 10

Database: SQL Server 2008

Jubilant

> Project details

Work Duration: 8th Jan 2013 - 31st Jan 2013

Project: It is a Cognos planning based project.

Role: As an ETL Developer,

. I was responsible to get data through SSIS for

all the stores (located in all cities and

states of a country) containing the financial

figures in a flat file which was not possible

to get through Cognos planning tool.

Environment: OS: Windows XP

ETL Tool: SSIS 2008

Planning tool: Cognos

Database: SQL Server 2008

OBIA Implementation for BE Aero Space

> Project details

Work Duration: Nov 2012 - Dec 2012

Project: Require to populate some reports in OBIEE through OBIA

implementation which uses Informatica as an ETL tool

Role: My role was

. To implement and customize Mappings, execute

mappings through Informatica tool. Scheduling

ETL flows through DAC.

Environment: OS: Windows XP

ETL Tool: Informatica Power Center 9.0.1

Database: Oracle 11g

Data Migration, Integration, Integration Documentation for JDIrving Limited

> Project details

Work Duration: Feb 2012 - Jan 2013

Project: It is a project which had two modules Data Migration and

Integration. It was a project to migrate data from

JDE worldsfot to E1 version through ETL tool namely

SSIS

Role: My role on this project was of ETL Consultant.

. Initially I documented many existing SSIS

packages then was part of Data migration and

then Data Integration

. An ETL developer in both the modules.

. Was working on Data Integration Initially and

have Good team leading capabilities.

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

. Worked with complex T-SQL in SSIS.

. Worked on complex XML files and performing XSLT

operations through Script as well as XSLT

transformation.

Environment: OS: Windows XP

ETL Tool: SSIS 2005, SSIS 2008

UML Tool: Microsoft Visio 2007

Database SQL Server 2005, SQL Server 2008

ETL Support (Changes and Enhancements) for Vestergaard Frandsen Project

> Project details

Work Duration: July 2011- Feb 2014

Project: It is a support project for ETL and Cognos.

Role: As an ETL Developer, I was responsible

. To handle the entire ETL part of the project

single handedly using SSIS.

. Monitor SSIS jobs

. Troubleshooting and fixing issues

Environment: OS: Windows XP

ETL Tool: SSIS 2005

Database SQL Server 2005.

Developed SYSTIME Resource Management System (SRMS) as a part of internship

assignment with SYSTIME Global Solutions.

> Project details

Duration: January 2011-June 2011(6 months)

Project: Developed a 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 COGNOS 10.

Role: Developer

Environment: OS: Windows XP, Windows 2008R2

Tools: C# with ASP.NET, IBM COGNOS 10, SSIS

Database SQL Server 2008.

[D] Other Experience

MTNL

> Project Details

Duration: Jan 2008-May 2008

Role: Developer

Environment: HTML, ASP, Java Script

Database SQL server 2000

Team size: 2

> Project Description

. Project was part of 6 months internship program during Final year of

BSC(IT)

. Designed & developed the clients website

. Developed a web-based application where admin can track the employee

information

. Developed a web-based application which shows the information about

the company

College website

> Project Details

Duration: 4 weeks

Role: Developer

Environment: ASP 3.0, HTML, VBSCRIPT

Team Size: 6

> Project Description

. Data was collected from the various departments of college

. Representation of this information on website in an organized way

> Project Role :Developer

Mobile Store

> Project Details

Duration: Aug-2010 -Sep 2010

Role: Developer

Environment: HTML, ASP.NET,C#,

Database SQL server 2005

Team size: 6

> Project Description

. Project was part of Software Testing subject in MCA(SEM-5)

. Designed & developed the website which stores the information of

mobiles

. Developed a web-based application where user can purchase mobiles

. Developed a web-based application which helps admin to manipulate with

mobile

Information such as adding, deleting and updating mobile information

> Project Role :Developer

[E] Training and Education

1

. Master of Computer Application passed with distinction

. Bachelor of Science-Information Technology passed with distinction

. Self-learning over Tableau visualization tool

. Trained on .NET technology includes ASP.NET, ADO.NET, Networking etc

Contact this candidate