Deepika

PROFESSIONAL SUMMARY:

 Extensive 7 years of experience in Database development for both OLTP (Batch Processing, Online
Processing); OLAP Systems (SSRS, SSIS, SSAS) using MS SQL Server.
 Strong SQL Server Developer Skills including writing Transact-SQL Queries, Stored procedures,
User defined functions, Views and Good understanding of Normalization /Denormalization, Database
design and Modeling (logical and physical).
 Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration
Services (SSIS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
 Experience in developing stored procedures, functions, Joins, triggers, views, materialized views,
optimizing queries, table normalization and demoralization, clustering, T-SQL, SQL Server
Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), RDBMS, data dictionaries,
and data integrity.
 Developed complex Stored Procedures, Triggers, Views, Functions, Indexes, Normalization, Data
types using MS SQL Server 2005/2008/2008R2/2012/2014/2016 and MS Access databases.
 Experience in creating jobs, alerts and scheduling DTS/SSIS packages in SQL Server Agent on
daily/weekly/monthly basis
 Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin,
normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging,
Testing, Deployment, Support and Maintenance of business applications using SQL Server, SSIS
and SSRS
 Worked on SQL Server Analysis Services (SSAS) including in building cubes.
 Expertise on RDBMS concepts as well as Data Modeling Concepts.
 Proficient in tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for
monitoring and tuning MS SQL Server performance.
 Knowledge in creating Basic Table Report, adding calculated Values, Using Document Maps, Tablix
Report, Adding Sub report to Parent Report, Reports with Interactive Navigation, and Display data in
Various Formats.
 Has very good experience in complete ETL cycle including data analysis, database design, data
mapping and conversion and data load.
 Experience in Data Modeling, Normalization, and Building Referential Integrity Constraints.
 In depth knowledge of developing complex stored procedures, views, efficient triggers, required
functions, and creating indexes and indexed views for speedy performance using SSMS and
SQLCMD.
 Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration
Services (SSIS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
 Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor,
SQL Profiler, Event Viewer, Index Tuning Wizard and Spotlight to achieve better performance,
accessibility and efficiency.
 Experience working with Very Large Databases (VLDBs) and Good knowledge of RDBMS and Big
Data Hadoop concepts.
 Having good experience of Microsoft SQL Server 2008, 2008R2, 2012, 2014,2016 with Production
support, Microsoft SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS),
SQL Server Integration Services (SSIS) using Business Intelligence Development Studio (BIDS) and
Crystal Reports 7.0/8.0.
 Good team player, Excellent interpersonal and communication skills combined with self-motivation,
initiative and the ability to think outside the box.
 Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005
to MS SQL Server 2008/2008R2/2012/2014 to MS SQL Server 2016.
 Understand C, C++, C#, JAVA languages and Networking concepts.
 A self -motivated Individual with exemplary analytical and problem solving skills.
 Experience with writing technical documentation at all levels.

Technical Skills:

Relational Databases/BI SQL Server 2016/2014/2012/2008/2005 / 2000 / 7.0, MS-Access

Database Tools SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS,
SSRS, DTS, BCP, ODBC,SQL OLEDB, DBCC, ADO, ADO.NET, Business
Intelligence Studio, Crystal Reports.

Languages SQL, TSQL, HTML, CSS, C,C++, JavaScript.

Operating Systems Windows server 2003/2008/2008R2/2012,2014, 2016

Scripting Shell Scripting

BI Tools SQL Server Integration Services (SSIS), SQL Server Reporting Services
(SSRS),SQL Server Analysis Services (SSAS)

Other Tools Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS Visual
SourceSafe, Source Control, MS Visio, NHibernate, Windows System Monitor,
CUBE

Professional Experience:

Client: Verizon, Madison, WI  Aug 2017 – Till Date.

Responsibilities:

 Upgraded SQL Server 2014 to SQL Server 2016 and migrated data from old systems to new
systems.
 Worked with Business requirements analyst to identify and understand source data systems and
Developed Mappings between source systems and warehouse components.
 Performed the role of Senior Database Architect for all SQL Server database environments.
 Involved in developing database objects such as procedures, triggers, constraints, indexes and views
using SQL Server 2016.
 Involved in development and implementation of SSIS, SSAS and SSRS application solutions for
various business units across the organization.
 Used SSRS to create Customized, Sub-Reports, Drill down/Drill Through, Summary Reports,
Parameterized, on-demand, ad-hoc reports and involved in analyzing multi-dimensional reports in
SSRS. Provided Ad-hoc queries and Reports for Company Wide users pulling data from Multi-
terabyte data warehousing systems.
 Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures
groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
 Involved in development and implementation of SSIS and SSRS application solutions for various
business units across the organization.
 Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data
Warehouse.
 Created various complex reports and manage those using SQL Server Reporting Services (SSRS
2014 to 2016) according to ERLC.
 Involved in migration and Conversion of Reports from SSRS 2014 to 2016.
 Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-
hoc reports, Drill down reports as well as interactive reports according to business requirements in
time restricted environment.
 Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled
Jobs to call the packages and Stored Procedures.
 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 reports using SSRS from OLTP and OLAP data sources and deployed on report server.
 Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
 Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
 Performed T-SQL tuning and optimization of queries for reports that took longer execution time using
MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were
sent to different Clients.
 Involved in Denormalization of existing tables for faster query retrieval.
 Documentation of Technical specification, business requirements, functional specifications for the
development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into
various tables.

Environment: SQL Server 2016/2014/2012/2008/2005, SSRS, SSIS, SSAS, BCP, DTS, , SQL Mail,
SQL Server Management Studio, T-SQL, XML, MS Excel and MS Access, Visual Team Foundation
Server, DTS, Crystal Reports, visual studio 2005/2008/ 2012, TFS 2008/2010

Client: American Family Insurance, Madison, WI  March 2016 – July 2017
Role: SQL Server /SSIS/SSRS/SSAS Developer

Responsibilities:
 Created tables, indexes, constraints and Views to facilitate easy user interface implementation, and
triggers on them facilitate consistent data entry into the database.
 Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into
SQL Server databases to maintain the consistency and data integrity.
 Actively monitored performances of queries on SQL server 2016 using SQL Profiler and optimized it
by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation
language.
 Good experience on working with Extract, Transform and Load (ETL) tool.
 Created SSIS packages to migrate data from Oracle DB to SQL Server 2016.
 Database and log backups and restoration, backup scheduling the backups. Backing up master and
system databases and restoring them.
 Developed SSIS packages to extract and transform data and Involved in Scheduling SSIS Packages.
 Using SQL Server Integration Services (SSIS) to populate data from various data sources using the
concept of OLE DB.
 Developed SSIS packages and deployed into Dev, Test and Production Environments.
 Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
 Managing the use of disk space, memory and connections.
 Performed software installation and upgrade, capacity planning
 Ensured developers coordinated their efforts in managing and maintaining different application
databases
 Eased administrative work through automatic script performing daily/weekly backups
 Reduced systems downtime risk through automatic offsite backup and recovery over
networkResponsible for database security of the operational and developmental application system
databases.
 Performed DBCC checks which will helps to maintain physical consistency of the database.

Environment: Microsoft Windows 2016, 2014, 2012, 2007 Server, Microsoft SQL Server 2016, 2014,
2012, 2008 R2, 2005, 2000, Microsoft Visual Sourcesafe, DTS, NHibernate, Viper, Office
communicator, Sharepoint server, Powerdesigner View, Change Control Manager.

Client: Liquid hub, India. Sep 2011 – Aug 2015

Responsibilities:
 Upgraded legacy 2000 databases to SQL server 2008.
 Created jobs to import/ export data, Involved in Database Backup and recovery.
 Created and maintained various logins and managed security based on the required access.
 Created various jobs to monitor resources on various servers and to mail the necessary information
when threshold was reached.
 Implemented high availability on the various servers using replication/mirroring.
 Tuned databases for better performance.
 Created and maintained various logins and managed security based on the required access.
 Studying the business requirement document, interact with the client and prepare the Report
Requirement Specifications document and changing the existing one as per Business Intelligence
Competency methodology.
 Developed SSIS (ETL) components.
 Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary
columns, eliminated redundant and inconsistent data ,normalized tables, established joins and
created indexes whenever necessary.
 Loaded the data into another data sources using SSIS.
 Created various SSIS packages based upon the requirement.
 Created various reports using SSRS.
 Monitoring regularly the production logs to ensure the data flow is going fine.
 Working on job fails on production/ acceptance servers.
 Working on the HPSD service.
 User Access Management – Granting/ revoking a user access to the VRT database on both the
acceptance and production environments.
 Monthly activity - Changing the new reporting month parameter in the VRT dashboards on both the
acceptance and production environments every month start.
 Discussions with customers on service call issues, if required.

Environment: Agile, SQL Server 2012, SQL Server Business Intelligence Studio SSIS, SSRS,
SSAS, Visual Studio, OLE DB, Erwin, Excel, Access 2010, SVN, GIT, Qlikview, Version one.