Sql Server Data

Angad Pun Sr SQL Server Consultant

Phone: 443-***-****

: abosq9@r.postjobfree.com

Resumes ID: 49120

Location:, Maryland

Posted: 05.01.2012

Resume Details:

Professional Summary

7+ years of IT experience in developing and administration on MS SQL Server 2008 R2/2008/2005/2000 including 3+ years of experience in Business Intelligence.

Extensive experience in Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS).

In-depth knowledge of RDBMS concepts with expert knowledge of constructing Relational Database according to business requirement.

Expert in T-SQL concepts with expertise in Database design, Entity Normalization, Data Monitoring, Performance Tuning and Troubleshooting.

Expert in installation, upgrade and configuration of databases and MS SQL Server 2008/2005/2000.

Extensive experience in ETL process (Extraction, Transformation and Loading) in an Enterprise Data Warehouse Environment

Extensive experience in creating Facts and Dimension Tables in EnterpriseData Warehouse (EDW) and loading them using Slowly Changing Dimension Transformation of SSIS

Experience in Migration of SSIS Package, Package Deployment and Packages Configuration.

Expert in using DTS packages and SSIS packages to Extract, Transform and Load (ETLprocess) data in homogenous and heterogeneous systems.

Extensive experience in Data Massaging, Data Cleansing, and Data Scrubbing using different SSIS Transformations e.g. Fuggy Lookup, Lookup, Derived Columns, Conditional Splits, and Execute SQL Task.

Experience in Event Handling using Precedence Constraints, Logging, Breakpoints and Checkpoints.

Extensive experience in Migrating and Upgrading DTS packages to SSIS.

Expert in using all the Control Flow Tasks and Components of Data Flow Tasks for the Extraction, Transformation, and Loading of data.

Extensive experience in creating and using effective Views/Indexed Views, Functions, Cursors, Triggers and Stored Procedures at different stages of Data Extraction, Transformation, Validation, Loading and Reporting.

Experience in creating different kind of Indexes using Clustered and Non-Clustered Indexes to improve the slowly running queries.

Experience in implementing Disaster Recovery using database Backup, Restore and Replication.

Extensive experience in creating Basic, Drilldown, Chart Based, Linked, and SubReports and Dashboards using SQL Server Reporting Services and Crystal Report 9 and laying down scheduling/delivery mechanism in SQL Server Reporting Services.

Experience in creating Cubes, MDX queries, Calculated Measures, Rollup Tables and loading of cubes in SQL Server Analysis Services.

Knowledge of programming language like Visual Basic, ASP and .NET Framework.

Technical Skills

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

Database Technologies and Tools: SQL Server Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Client Configuration Utility, Data Transformation Services (DTS), Integration Service (SSIS), Analysis Service (SSAS), Reporting Service (SSRS), ODBC, ADO, Data warehouse

Operating Systems: Windows 7, Vista, XP, 2003, 2000, NT, 98, 95, MS DOS

Programming Language: T-SQL, C, C++, Visual Basic, JavaScript, XML, Visual Studio

Business Tools: Word, Excel, Power Point, Outlook, Visio, Flash, Acrobat

Additional Software: DTSxChange, BIxPress

Professional Experience

Blue Cross Blue Shield of Michigan, Detroit, MI Oct 11 – Present

Role: SQL, SSIS, SSRS and SSAS Developer

Project Name: SQL Server 2008 R2 Upgrade Project

The project was to upgrade and migrate the DTS packages to SSIS packages and upgrade and migrate SQL Server 2000 databases and servers to SQL Server 2008 R2.

Responsibilities:

Perform detail analysis on server in terms of databases, DTS packages, drivers, files and applications, etc

Setup Test Environment/Databases in Testing server

Perform analysis for Customer Database/Database Objects if needed

Prepare Analysis Documents

Design ETL Flow and Server Migration

Design Report Part

Prepare Source To Target Mapping Documents, Design Document, etc

Upgrade DTS Packages to SSIS Packages

Fix Issues with the Packages

Automate processes in the SSIS Packages

Setup connection to Oracle and DB2 to import data

Work with DB2, Mainframe, Oracle, and Informatica Team to fix different issues

Upgrade DTS packages pertaining to other applications or users if needed

Copy/Construct Reports in BDR Test Folder in Reporting Server

Create Test Cases for Unit Test

Perform Unit Test

Migrate the databases of production to QA environment and prepare for SIT Testing

Set up Jobs to run from SQL Server Agent for SIT

Prepare Test cases and Unit Test Results Documents

Support SIT/UAT

Load the code/Database Objects/SSIS Packages into CA-SCM

Migrate Production databases to new production server after SIT/UAT completion

Promote SSIS Packages along with other necessary files/applications to Prod

Perform database integrity check and post migration validation for all the objects migrated (files, folders, applications, etc)

Set up Jobs to run from SQL Server Agent/Tivoli for Production Run

Set up Access for the new production server in the Reporting Server if needed

Set up Tivoli Client in Test Environment to run batch/job files from QA Tivoli Server

Perform additional analysis of batch files and Tivoli Jobs pertaining to the DTS Packages

Create/Modify the batch files for the new/upgraded SSIS packages and Prepare the Job Docu Text and other necessary files for Tivoli

Project Name: MI Tax Field Project

A new field, MI Tax Amount, was needed to be added in the CHCQES tables which should be mapped to MI Tax Amount field in OSCAR.

Responsibilities:

Review Business Requirements

Requirements and System analysis

Design system changes

Document System requirements

Create SAD and Use Case Documents

Review of System Requirements, Analysis Results and Design Documents

Coding

Create Unit Test Cases and Unit Testing

Code Review and Approval

QR SAD and Use Case Review

Set up test environment and Support Test Team in SIT/UAT

Promote to Production

Fix and Reload January and February CHCQES Data

Add the Fields to History Tables

Verification and Validation

Environment:

Microsoft SQL Server 2000, Microsoft SQL Server 2008 R2, SSIS, SSRS, SSAS, Windows XP, Visual Studio 2008

QVC.COM, West Chester, PA Aug 10 – Sep 11

Project Name: Customer Relationship Management System

Role: SQL, SSIS, SSRS and SSAS Developer

QVC.com, the Internet division of QVC, is the leader in multi-channel retailing which attracts more than 6 million unique visitors each month. Virtually every item presented on QVC can be viewed and purchased through the Internet at QVC.com.

The project was to build a system that will support e-commerce point-of-sale application and enables the company to gather the relevant information of all their customers and generate real time reports and analysis to help in strategic decision making understanding customer behavior and product trends.

Responsibilities:

Worked together with Stake holders and Development Teams to evaluate and analyze business requirements.

Outlined technical specification based on the business needs and requirements.

Engaged in data assembling with requirement Team and identifying the source systems.

Used SSIS Data Flow Task to extract data from various sources like CSV files, Flat files, Excel files and other databases like Oracle, DB2.

Created several Stored Procedures and User Defined Functions and used them in staging phase to massage data and cleansing of data.

Created SSIS packages for ETL process to load data into enterprise level data warehouse.

Developed, maintained and monitored all import/export and Data Transformation into the Staging, Production and Data Warehouse environments.

Used Derived Columns to get handle of null values and invalid data.

Used different SSIS Transformations like Fuzzy Grouping, Fuzzy Lookup, Lookup to transform data and data type conversion.

Designed packages for Rollup tables based on the business rules used by the reports.

Applied SSIS Transformations like Conditional Splits, Multicast to integrate Business Rules.

Inserted data into Fact and Dimension Tables using Slowly Changing Dimens

Contact this candidate