Sql Server Data

Harry Jaj

********@****.***********.*** 510-***-****)

Professional Summary:

Over 3 years of experience in the IT industry as a SQL Server Developer.

Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2008

Experienced in SQL Server Analysis Services OLAP Cubes, and Data Mining

Strong experience in defining Referenced relationships in SSAS

Possessed excellent skills in Data Modeling to create Star and Snowflake Schemas using Erwin

Expert in defining data source and building data source views and recognizing fact and dimension tables.

Expert in identifying KPIs in SSAS 2008

Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on

OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix

dynamics reports and other features of reporting service.

Adept in creating Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL.

Experienced in promoting RDLs to Reporting Service Server.

Good working knowledge in deployment of reports to the share point server for business user/information

user to access based on there roles/permission.

Created various DTS packages for data transfer and migration from OLTP to OLAP.

Experienced in using tools like Bulk Copy (BCP) and Data Transformation Services (DTS).

Expert with ETL tools such as DTS and SSIS.

Experienced in creating many complex SSIS packages with complicated transformations.

Experienced in data loads, database integration/conversions, performance tuning and optimization.

Worked on administrative tasks such as data loading, batch jobs, data unloading, backup & Recovery, user

and application table management, upgrades, creating databases/File groups/files/Transaction log-

shipping.

Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries,

develop and debug Stored Procedures and Triggers.

Capable of forming and maintaining positive and productive working relationships in internal, external and

team environments.

Education Qualifications:

Master of Science in Industrial Technology

California State University, Fresno, CA

Post Graduate Diploma in Business MarketingAnalysis

George Brown College, Toronto, Canada

Bachelor of Technology in Mechanical Engineering

Punjab Technical University, India

Technical Skills:

RDBMS/DBMS: SQL Server 2008/2005/2000, SQL Server 7.0, 8.0, 9.0, MS Access, and SQL Plus

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence

Development Studio, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), OLAP,

OLTP

Reporting Tools: Crystal Reports, SQL Server Reporting Services (SSRS), MS Excel

Analysis Services: MS SQL Server Analysis Services 2005/2000, SQL Server Integration services (SSIS)

Data Modeling: Visio 5.0

Projects Summary: Jan 2009-Present

Verizon Wireless, Grapevine, TX

MS SQL Developer

Verizon is a global leader in delivering innovation in communications, information and entertainment. Recently,

Verizon offloaded around six million broadband and voice customers in 13 states to Frontier Communications. The

project named PARS (Performance Analysis Reporting Services) used to deal with migration of data from Verizon

server to Frontier Communication server. Involved in creation and customization of reports for various perspectives

to the managers to help in their decision making process

Environment:

MS SQL Server 2008, MS SQL Analysis Services 2008, Share Point Server, MS Excel, Windows Server 2003

Responsibilities:

Migrated customers data related to FIOS (Fiber Optic Services), FTTP (Fiber to the Premises) and wireline

telephone services offered by Verizon from Verizon server into the server of Frontier Communication

Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing,

data validation checks during Staging, before loading the data into the Data warehouse

Created Tabular reports, Matrix reports, List & Chart reports, Cascading Parameterized reports, Sub

reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in

time restricted environment using SSRS for the customers data being sold to Frontier Communication

Comparing data that was with Verizon to that of migrated to Frontier Communication by extracting reports

based on each and every year

Maintaining data accuracy and integrity and used to investigate a lot on Data Discrepancy's

Developed dimensions and fact tables based upon the requirements and based on these facts and

dimensions, designed SSAS cubes

Optimized the database by creating various clustered, non-clustered indexes and indexed views

Designed and developed matrix and tabular reports with drill down, drill through and drop down menu

option using SSRS

Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.

Scheduled the monthly/weekly/daily reports to run automatically

Client: Peerless Financial Solutions, India Jan 2008 – Dec 2008

Role: SQL Developer

Peerless is an emerging financial firm in the private sector in India. The project called PDS (Peerless Database

System) deals with creating customer database from scratch of around five thousand newly acquired customers.

This project also deals with checking the referential integrity of the newly constructed database with the older

database.

Environment

SQL Server 2000, SQL Server 2005, SSIS, Excel, Access, SSAS, SSRS

Responsibilities

Extensively involved in designing (Logical and Physical) of customer database

Installation, configuration and maintenance of MS SQL Server 2000

Identified the data source and defining them to build the data source views

Implemented constraints like Check, Primary Key, Foreign Key on tables

Designed and implemented stored procedures and triggers for automating tasks

Responsible for transferring the data using SSIS packages

Migrated the DTS packages to SSIS packages

Designed, developed and deployed reports, Sub Reports, Drill down reports, Drill through reports and

Parameterized reports in MS SQL Server environment using SSRS 2005

Created reports to retrieve data using T SQL queries and Stored Procedures that accept parameters using

SQL Server Reporting Services (SSRS).

Developed reports using SSRS and used data driven subscriptions to publish the developed to the end

users as PDF, Excel, and CSV formats

Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports using SSRS

Migrated the Data from SQLServer 2000 to SQL Server 2005 using SSIS

Developed Cubes using SSAS

Created Dimensions with cube wizard and also individually.

Refreshing the cube to get the latest information updated.

Deployment of cubes to production serve

Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time

horizon and stored in script.

Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server

Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Contact this candidate