Sql Server Manager

Deepti R. Satpute

E-mail: ******.*******@*****.*** Phone: 714-***-****

SUMMARY

3+ years of experience in analysis, design, development and management of databases/Data warehouses,

extraction/transformation/loading (ETL) design & implementation, report development as well as troubleshooting

and performance tuning using the Microsoft SQL Server stack. Managed testing, UAT sessions, logs and heading up

meetings.

TECHNICAL SKILLSET

Experience in Data modeling for designing Logical and Physical models of various Relational Databases as well as data

warehouses along with solid understanding of dimensional modeling as well as normalization.

Expertise in writing T-SQL queries and stored procedures, creating various database objects as well as optimizing T-SQL

code for faster performance.

Designed ETL processes using SSIS.

Highly experienced in all aspects of system development life cycle such as requirement analysis, design, development,

testing, implementation, deployment & maintenance of projects.

Extensive experience in developing, managing and delivering various complex SSRS reports.

Worked with Team Foundation Server (TFS)

Created database documentation for table and column dictionaries and other reference material.

Worked closely with Business users to gather requirements and performed UAT sessions for different applications.

Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the

ability to think outside the box.

PROFESSIONAL EXPERIENCE

McKesson Corporation, San Francisco, CA SQL Server Developer July 2013 to Current

http://www.mckesson.com/

Projects involve ‘Fee for Service’, ‘Price Assurance’ and ‘Price Protection’ applications development with monthly and

Prior Period Adjustments processes development and reporting features.

Responsibilities:

Developed and optimized SQL queries using SQL Server profiler, indexed views and indexes.

Developed complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and

reports.

Involved in performing ETL process using SSIS for populating data store in SQL Server 2008/2012.

Analyzed data and complete technical designs for assigned applications.

Maintenance and enhancement of the daily process for sales data consumed by several downstream applications.

Working on developing a SQL Server 2008/2012/Share Point based rebate calculation application using SQL skills to

create stored procedures, functions, views, SQL agent jobs and packages.

Interacting with the design consultants and technical leads to create design document off the requirement

documents.

Created stored procedures to efficiently handle the migration of legacy rebate application data into the Data

Warehouse.

Modularized packages into a Master Child Package model and scheduled them using SQL Server Agent.

Designed and implemented ETL processes to make data available for reporting purposes.

Developed the required SQL code to create the summary and invoices for the rebates processed.

Built various reports using SSRS running on top of relational databases and uploading them to Share Point via SSIS.

Knowledge of XML and Experience working with XML in SQL Server 2008

Integrated SharePoint with SQL environment using SQL Integration Services.

Performed UAT sessions with business users and worked closely with them.

Providing production support for different applications.

Daily interaction with offshore QA team.

Created technical documents

Environment: SQL Server 2008/2012, Visual Studio 2008/2012, SSRS, SSIS, Agile Lifecycle, Team Foundation Server (TFS).

DriveCam Inc. San Diego, CA BI Developer Feb 2012 to Aug 2012

http://www.drivecam.com/

Project scope involves writing the optimized SQL scripts for the reports against new schema and database structure. It

also involved writing Deployment scripts and creating ETL packages.

Responsibilities:

Coordinated and communicated with business analyst, DBA and project manager to identify and understand the

business requirements.

Created complex T-SQL stored procedures, Functions, Views, Indexes, CTEs and scripts for the ETL process as well as

for generating data sets for business reports (SQL SERVER 2012) as per the new schema.

Profiled data using SQL Server profiler, stored-procedures and SSIS task. Based on the results, created a data

dictionary which was being used by all the stakeholders.

Used different Optimization techniques and created proper Indexes for better execution plan to improve the

performance of queries.

Efficient use of synonyms, Temporary tables, Table variables, derived tables, CTEs and other database objects for

performance tuning of reports.

Monitoring of SQL server performance using tools like SQL server profiler, database tuning adviser and command

line tools.

Debugging and unit testing of different database objects and reports in development, staging as well as production

environment.

Designed ETL packages and implemented using SSIS by using various available tasks and transformations along with

ensuring proper error handling through Event handlers, Checkpoints, Logging and performance for ETL load.

Delivered data from operational database to data mart by mapping, cleansing, profiling in the source databases and

files as well as creating a staging database to ensure the accuracy of the data pushed to the relational warehouse.

Used Team Foundation Server for deployment of the Reports, scripts and ETL packages.

Involved in writing deployment scripts for deployment of created Stored Procedures and Repots to the Staging

Server.

Created report models from cubes and data warehouse to generate ad-hoc reports, and complex Enterprise reports

(drill down and drill through reports, Parameterized reports, cascading report) using report builder and report

manager in SSRS.

Generated on-demand(ad-hoc) and scheduled reports for business analysis using SSRS. Utilized Report Manager to

secure the reports with windows user groups and roles for individual reports and also reports folders.

Environment: SQL Server 2008/2008R2/2012, Visual Studio, SSIS, SSAS, SSRS, Team Foundation Server (TFS), Agile

lifecycle

California State University, Fullerton, CA SQL Database Assistant Jun 2010 to May 2011

http://www.fullerton.edu/

Maintenance of Admissions and Records department of California state university, Fullerton

Responsibilities:

Developed and maintained documentation of all software/application installations, configurations and usage.

Developed different database objects like Stored Procedures, Functions, Triggers and Views using T-SQL in different

environments using SQL Server 2008.

Updated contents of multiple sections of Admissions and Records department website and also inspected and

improved code by efficiently using joins, Temporary tables, Table variables, CTEs etc.

Identified and fixed security issues, SQL Injection by using Dynamic SQL (DSQL).

Created different on demand reports which provide descriptive representation of information using Excel, SSRS like

drill through reports, linked and sub reports.

Took daily backups of database to protect against accidental loss, corruption, system crashes etc.

Report writing using SSRS.

Participated in ongoing development and optimization of databases.

SQL Server 2008 database maintenance.

Environment: SQL Server 2008, Visual Studio, SSRS, SSIS

R.B.Electronics, India SQL Trainee Engineer Nov 2007 to May 2008

Responsibilities:

Developed and optimized SQL queries using SQL Server profiler, indexed views and indexes.

Wrote complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and

reports.

Involved in performing ETL process using SSIS for populating data store in SQL Server 2005 and also designing the

overall data warehouse architecture and the individual data marts in the data warehouse.

Modularized packages into a Master Child Package model and scheduled them using SQL Server Agent.

Built various reports using SSRS running on top of relational data warehouse.

Environment: SQL Server 2005, SSRS, SSIS, Windows Server 2000/2003.

EDUCATION:

Master of Science in Computer Engineering

California State University, Fullerton, CA Jan 2009 to May 2011

Contact this candidate