Sql Server Project

G ayatr i V P hone: 225-***-****

E mail: *******@*****.***

Objective: To work in a challenging environment and add value to the business by utilizing

my educational and technical qualifications.

P rofile Summary

• Expertise in Data Warehouse and ETL development

• Extensive t raining in Data Warehouse development working with Data Migration,

Data Conversion and ETL using Informatica Power Center/Power Mar t with Flat

F iles, XML, Oracle, SQL Server.

• Expertise using Informatica tools such as Repository Manager, Designer,

Server/Workflow Manager, Data Explorer, and DVO.

• Extensive t raining in Analyzing the Dimensional Data modeling, Star

Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data.

• Knowledge in developing and implementing Business Objects universes and reports

• Good Team player with strong analytical, problem solving and communication skills.

EDUCAT ION

• Masters in Applied Information Technology,

Towson University, Towson, MD CGPA: 3.47 Jan 2013 – Aug 2014

• Bachelor of Arts in English Li terature

University Of Madras, Chennai, India CGPA: 3.45 Jun 2002 – May 2005

T ECHN ICAL SK I L LS

Informatica

E TL TECHNOLOGY

Mul tidimensional Model Design, Star Schema Development

DATA WAREHOUSE

MS Visio, Erwin

DATA MODELL I NG

MS SQL Server 2012/2008, MS Access

DATABASES

C, C++, T-SQL, PL/SQL, HTML,UNIX Scripting

PROGRAM M I NG

Business Objects, SSRS 2008

REPORT ING TOOLS

Windows, UN IX

OPERAT ING

SYSTEMS

T raining:

Valsatech Corp J une 2014 –

Sep 2014

G ayatr i V P hone: 225-***-****

E mail: *******@*****.***

T he company provides t raining to college graduates and anyone interested in learning ETL

tools and Reporting tools. The t raining was particularly focused on Informatica software.

T he objective was to educate t rainees in the basic functions of Informatica development.

T raining on basic functions of Business Objects Reporting tool was also provided. Real-t ime

scenario examples were provided to a group of 8 people to simulate a working environment

p roject and i t proved to be a great experience.

T raining topics:

• Design and development of mappings, mapplets and sessions from various sources (flat

f iles and Oracle) to target SQL Server database using Informatica Power Center.

• Connected, unconnected lookups and mapplets.

• Scheduling of sessions and batch process based on demand, run on t ime, run only once

using Informatica Workflow Manager.

• Basics of Windows Power Shell scripting and UN IX Scripting.

• Power Center Data Validation Option (DVO) and SQL code to enhance Data accuracy

and reduce Testing time.

• Performing data analysis and data profiling using SQL and Informatica Data

E xplorer on various sources such as Oracle and SQL Server

• Enhancement techniques in data t ransformation processing using Pushdown

Optimization option and SQL override.

• Development of complex SQL queries and simple PL/SQL procedures to perform

database operations based on business requirements.

• Developing mappings to load data in slowly changing dimensions.

• Basics of Business Objects Reporting tool

Environment:

I nformatica Power Center 9.1, Business Objects BI 4.1, SQL Server 2008/2012, Oracle 11g,

Toad, Windows PowerShell Scripting.

Academic Projects (Towson University, Towson)

Project Title: Designing a Database for Online Banking System

J an 2014 – May 2014

Master’s degree Project was focused on Database Design and development in a banking

environment. The goal of the project was to complete the database development process

s tarting from the database design phase to execution of user requirements phase. I t was a

good experience in covering the functions of Database Architect, Database Administrator,

and Database developer.

G ayatr i V P hone: 225-***-****

E mail: *******@*****.***

Tasks Performed:

• Developed Business requirements for the banking database system

• Developed Logical design for the database system using M icrosoft Visio and

E rwin

• Developed Physical design for the database system in MS SQL Server 2008

• Ut ilized T-SQL to wr ite Stored Procedures, T riggers, and Functions to

i mplement Business requirements

• Performed Database Maintenance tasks such as Backup & Recovery, Database

M i r roring

Environment: SQL Server 2008, MS Visio, Erwin

Project Title: Creating an Online Website for a Grocery Store

J an 2013 to May 2013

The Project was designed for System Development process course. The Project was a great

opportunity to understand the SDLC processes starting from user requirements gathering

a ll the way to Business Reports generation.

Tasks Performed:

• Gone through entire SDLC (system development life cycle) process.

• Submit ted system proposal for grocery store, performed feasibility analysis, Risk

assessment and cost-benefit

• Gathered all the functional, non-functional, system and database requirements for

t he project and writ ten the use cases.

• Created Data f low diagrams in Visio for the application and developed a web

application for the grocery store using HTM L, CSS, JavaScript, and SQL Server

2008.

• Followed the Usability and user-centered principles.

• Created the test cases for testing the application and stored the data in the data

d ictionary.

• Tested the application using Manual Testing.

• Created 5 different Summary reports for the project.

• Created a power point to market the web application.

• Have some experience working in Informatica cloud

G ayatr i V P hone: 225-***-****

E mail: *******@*****.***

E nvironment: MS Office Suite, MS Project, M icrosoft SQL server 2008, MS Visio.

Contact this candidate