Sonam Duseja

Mo. 541-***-****

Email: acbuoz@r.postjobfree.com

SUMMARY

• 7+ years of professional experience in design, analysis & development of SQL Server

****/****/****/**** *** SQL Server Business Intelligence tools in OLTP and OLAP (Data

Warehousing) environments.

• Excellent in MS SQL Server 2008/2012 suite of products like SSIS, SSAS and SSRS.

• Proficient in T-SQL queries using Store Procedure, Dynamic SQL, joins, Views, User

defined functions, Triggers, Cursors, CTE, DML, DDL and etc.

• ETL experience across Oracle, Access, MySQL and Excel.

• Expertise in writing MDX Query in OLAP Databases.

• Good Understanding of Isolation Level, MOLAP, ROLAP, HOLAP, Normalization, De

Normalization,Partitioning, ACID Property, Data Warehouse, Bill Inmon methodology, Ralph Kimball

methodology, Star flake schema, Snowflake Schema, SSAS Dimension Attribute Properties and etc.

• Expert in Data Modeling tools like ERWIN, SQL Server Database Diagrams.

• Experience on TFS(Team Foundation Server) for code sharing.

• Experience in making formal and informal presentations to technical and nontechnical staff.

• Experience in monitoring SQL Server Performance, troubleshooting using SQL Profiler,

Index Tuning Wizard and database engine tuning advisor.

TECHNICAL SKILLS

RDBMS : MS SQL Server 2012/2008 R2/2008/2005/2000, MS Access 2000, 2003, Oracle

9i/10g.

SQL Server Services : SQL Server Analysis Services(SSAS), SQL Server Integration Services (SSIS),

SQL Server Reporting Services (SSRS), SQL Server Developer.

SQL Server Tools : SQL Server Profiler, Database Engine Tuning Advisor, Index Tuning Wizard,

SQL Server Management Studio, Business intelligence development studio, SQL

Server Surface Area Configuration, Query Analyzer.

Programming Languages : T-SQL, PL/SQL, C#.Net, Visual Basic 6.0, HTML, XML, JavaScript, VB

Script.

Tools : MS Excel, Titan, Apropos, Jupiter, SFS, TFS, Remedy, Dundas Charts, Crystal

Reports, Toad, Jupiter, Visual Studio.NET 2005, Erwin.

EDUCATION AND CERTIFICATIONS

• Bachelors in Science (Information Technology), India.

• Microsoft Certified Technology Specialist(MCTS) (Exam 70-432 SQL Server 2008 Implementation

and Maintenance.)

• Microsoft Certified Developer(MCD) (Exam 70-452: Design DB Solutions and Data Access using

SQL Server 2008.)

PROFESSIONAL EXPERIENCE

Department Of Education, NY Jan 2013 to Current

BI Developer

Responsibilities:

• Created ETL packages using Heterogeneous data sources ( SQL Server, ORACLE, Flat Files, Excel

source files etc.) and then loaded the data into destination tables by performing different kinds of

transformations using SSIS.

• Developed the packages with monitoring features and logging so that audit information of the packages

and their execution results are loaded in to the audit table.

• Performed Performance Tuning by using unblocking Transformations and row transformations for

better Performance of SSIS packages.

• Set package configuration in SSIS to redirect path from test environment to production environment.

• Prepared the Technical and Function specifications based on the project requirements.

• Involved in Planning and Designing databases.

• Designed, Implemented and maintained Database Schema, Tables, Stored procedures, Constraints,

Indexes, Schemas, Views, and complex SQL statements

• Developed and deployed SSIS(ETL) packages for ETL from OLTP and various sources to staging and

staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term,

Slowly Changing Dimension and more on daily basis

• Used scripts and variables, email notifications for ETL process using Data Integration in SQL Server

Integration Services

• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports &

Parameterized Reports using SQL Server Reporting Services (SSRS) . Developed reports using SSRS

and published as PDF, Excel and CSV formats

Environment:

SQL Server Management Studio 2012/2008/2008 R2, Query Analyzer, SQL Profiler, Index Tuning

Wizard, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) 2008/2008

R2/2012, MDX

Hewlett Packard, Sunnyvale, CA Oct 2012 to Jan 2013

Lead SQL Developer

Responsibilities:

• Involved in Planning and Designing databases.

• Designed, Implemented and maintained Database Schema, Tables, Stored procedures, Constraints,

Indexes, Schemas, Views, and complex SQL statements

• Created the stored procedures to populate the Fact tables by mapping with the dimension tables.

• Designed measures and dimensions to develop SSAS cube for data analysis and reporting.

• Experience in writing MDX queries for report data set.

• Developed and deployed SSIS(ETL) packages for ETL from OLTP and various sources to staging

and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split,

Term, Slowly Changing Dimension and more on daily basis

• Used scripts and variables, email notifications for ETL process using Data Integration in SQL Server

Integration Services

• Developed reports using SSRS, also generated result sets for the Qlikview reports.

• Worked in the Agile methodology using Scrum which has its primary focus on the management part of

the software development.

• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports &

Parameterized Reports using SQL Server Reporting Services (SSRS) . Developed reports using SSRS

and published as PDF, Excel and CSV formats

Environment:

SQL Server Management Studio 2008/2008 R2, Query Analyzer, SQL Profiler, Index Tuning

Page 2 of 5

Wizard, SQL Server Analaysis Services 2008/2008 R2, SQL Server Integration Services (SSIS), SQL Server

Reporting Services (SSRS) 2008/2008 R2, MDX

Symantec Corporation, Springfield, Oregon Mar 2009 to Sep 2012

Senior SQL Server /BI Developer (ETL Developer)

Project: Symmetrics

The term SymMetrics refers to a particular Web site maintained by the BAR team, reports that are available

on that site, and the tools and processes that are used to produce those reports

Responsibilities:

• Generated SSIS packages to upload database from different data sources such as SQL server, Excel, MS

Access, Oracle and flat file. Hands on experience in using different transformations like fuzzy lookup,

derived column transformation etc using SSIS.

• Designed measures and dimensions to develop SSAS cube for data analysis and reporting. Primary

data warehouse was based on SQL Server 2005 and Data mart/SSAS cubes were based on SQL Server

2008.

• Experience in writing MDX queries for report data set.

• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports &

Parameterized Reports using SQL Server Reporting Services SSRS. Developed reports using SSRS

and published as PDF, Excel and CSV formats and deployed on web portal.

• Optimized the performance of queries with modification in T-SQL queries, eliminated redundant and

inconsistent data, established joins and created indexes wherever necessary. Developed ER Diagram

using Microsoft Visio.

• Involved in the design of Data warehouse using Snowflakes schema.

• Involved in Data Modeling using Erwin Data Modeler while designing database for application.

• Involved in Perfomance Tuning and troubleshooting of SSIS packages.

• Monitored flat file loads using SSIS packages and identified data issues.

• Developed & maintained scripts, utility jobs or implement needed software for database

maintenance.

• Wrote complex T-SQL stored procedures, Functions and Triggers to carry out various tasks. Used SQL

Profiler for tracing and debugging of the T-SQL scripts & efficient report generation.

• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for

maximum efficiency using SQL Profiler.

• Monitored performance of databases using advanced tuning methods and customized scripts.

Environment:

SQL Server Management Studio 2008/2008 R2, Query Analyzer, SQL Profiler, Index Tuning

Wizard, SQL Server Analaysis Services 2008/2008 R2, SQL Server Integration Services (SSIS), SQL Server

Reporting Services (SSRS) 2008/2008 R2, MDX

Cybage Software, India Feb 2006 –

Mar 2009

SQL Server Developer

Project: Capacity Planning

The Capacity Planning Data Monitoring System is initiated to ensure the correctness of Capacity Planning

data and identify anomalies in data collected from DREAM & DREAM mail. CPDMS generates reports

regularly to highlight the integrity of the capacity planning data and to report any discrepancies found during

data collection/summarization process.

Page 3 of 5

Responsibilities:

• Designed Database schema for Capacity Planning.

• Extensive T-SQL Development for evolving business requirements, enhancement to existing procedures.

Creating Databases, Tables, Views. Writing complex stored procedures, Triggers, Functions

• Performed backup/restore, created database objects such as tables, procedures, triggers, constraints,

indexes and views, user security management.

• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and

indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and

SQL Server backup strategy and automation.

• Involved in Performance tuning, query-inventory, analysis and optimization.

• Performed Data transfer (Import & Export) using DTS packages.

• Migrated SSIS packages to SQL Server 2005 Integration Services and modified the existing packages

accordingly by using the advanced features and tools such as Script Component, Script Task, Lookup,

Derived Columns, Condition Split, Union All, Copy Column, Aggregate, Audit Transformations etc.

• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports &

Parameterized Reports using SQL Server Reporting Services (SSRS) . Developed reports using SSRS

and published as PDF, Excel and CSV formats.

Project: EZBill

EZBill is an application for unification of billing process that is being used in all Epsilon business units.

Peoplesoft is a system of choice as unified application where Epsilon Business units will report their billing

data for invoicing their end customers. Epsilon customers are billed as per their signed contract items and

volume of goods delivered through Epsilon deployment systems.

Responsibilities:

• Designed DB schema for eZBill database.

• Database Maintenance of SQL Server on Windows 2000 advanced server.

• Created groups, roles, users and assigning access privileges to users.

• Scheduled the backups for Databases and Transaction log. Performed restoration operations Suggested

backup strategies.

• Managing the SQL Servers in Clustered Environment.

• Extraction, transformation and Loading (ETL) of Data using DTS Packages.

• Exported and imported data from text files and Excel to SQL Server database using BULK insert and BCP

utility.

Page 4 of 5

• Successfully implemented indexes on tables for optimum performance of OLTP database. Performed

Index analysis for tables and came up with more efficient solutions to use Clustered and Non Clustered

Indexes for significant performance boost using Index tuning wizard.

• Developed utility programs for data extraction, transformation, and importing/exporting with SQL Server

DB.

• Implemented database consistency and security by creating groups, roles, users, and triggers on views

Page 5 of 5

Contact this candidate