Sql Server Data
Resume:
Sonam Duseja
Mo. 541-***-****
Email: *****.******@*****.***
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