DEEPTHI

SQL Server BI (SSIS/SSRS/SSAS) Developer

aceq6c@r.postjobfree.com

Contact: 248-***-****

Professional Summary

> 7.2 years of IT Experience in Database Design, Development, Unit

Testing using Microsoft SQL Server Business Intelligence (SQL Server,

SSIS, SSAS, SSRS) and various business domains like Financial,

Insurance and manufacturing etc.

> Insightful experience in BI Development & implementation, Reporting &

Analytics, Operations and support function of mission critical

business solution using IT as a tool.

> Experience with different phases of project life cycle (Analysis,

Design, Implementation, Testing, and debugging new and existing client-

server based applications).

> Well developed skills in SQL Server, MSBI Stack (SSAS, SSIS, and

SSRS), and MDX Script.

> Expertise in creating complex SSIS packages for ETL purposes using

various transformations and control flow items in SSIS 2008/2012

> Experience in Source to Destination mapping using SSIS.

> Creates master and child packages, package configurations and logging

> Good Experience in writing Stored Procedure, User Defined Function,

Query optimization methods.

> Supported team in resolving SQL Reporting services and T-SQL related

issues and Proficiency in creating different types of reports such as

Cross-Tab, Conditional, Parameterized, Drill-down, Top N, Summary,

Form, OLAP and Sub reports, and formatting them.

> Experience with adhoc reporting, Parameterized, Custom Reporting using

SSRS for daily reports and SSAS projects.

> Experience in Developing Dashboard & Scorecard KPI Report using SSRS

> Good experience in using Multidimensional Expressions (MDX) for

querying and manipulating the multidimensional data stored in OLAP

cubes.

> Experience in DWH Designing the Dimensions Model (Dimension Tables,

Fact Tables) with star and snowflake schema using SQL Server Analysis

Services (SSAS).

> Created groups,measures and KPIs

> Support & Maintenance of OLAP DB, SSIS Packages, SSRS Reports and

ability debug the code.

> Knowledge on SharePoint.

> An effective communicator with strong team management, leadership,

analytics and interacting with clients & Customers

> Leveraging business best practices to deliver high-quality solutions

Technical Skills

> SQL Server 2012 /2008/2005/2000

> MSBI Stack (SSAS, SSRS & SSIS), MDX, T-SQL, Performance Tuning, Query

Optimization

> Excel, MS-Access, VBA, MS Visio

> SharePoint, VB.Net, C#, HTML, CSS, Erwin 4.0

> C/C++, XML, Visual Studio,,PL/SQL, MDX

Academic Qualification

> Bachelor of Technology, Jawaharlal Technological University,

Hyderabad, INDIA

Professional Experience

CVS Caremark, Woonsocket, RI

Jan 2013-Till Date

Senior BI Developer

Responsibilities:

. Involved in requirement gathering and Development phase.

. Gaining an insight into client's infrastructure, with the aim of

contributing effectively to the project as well as giving appropriate

solution to the business needs.

. Designing SSIS packages - and Implemented UPSERT, SSIS Logging, Event

handler - Error Handler and SSIS Package Deployment and Configuration,

SSIS Scheduling, Automated ETL operations

. Worked on SSIS Package to import data from CSV, TEXT File, Oracle to

SQL Server Destination

. Implemented UPSERT SSIS Package for Slowly Changing Dimension.

. Modified the Existing SSIS Packages and added more audits and alerts

in case of package failure

. Worked on SSIS Package to load data incrementally (Delta Load) SSRS

reports

. Deployment & Configuration of the SSIS packages

. Worked on Complex SSRS reports like Tablix, Drill through, Drill down,

Chart, and Parameterized Report.

. Worked on Dashboard & Scorecard

. Involved in Publish the SSRS Reports and Subscribing SSRS report

. Report Admin activities like granting permission to users, creating

roles etc.

. Design & Develop OLAP Cube and Staging Tables

. Worked on SSAS Cube with Snowflake schema

. Calculated measures and dimension members using multidimensional

expression (MDX), mathematical formulas, and user-defined functions

. Created groups,measures and KPIs

. Taking complete ownership for projects execution and interacting with

customer and Business stake holders.

. Optimizing SQL Queries Involved in Report Performance activities.

Environment: SSAS, SSRS, MDX, SSIS, SQL Server 2012, Excel

Microsoft Corp Seattle,WA

July 2011-Dec 2012

BI Developer

Responsibilities:

. Gathering requirements from the business users and created the

Functional Specifications, Technical Specs, Design documents and

Approach documents.

. Involved in daily loads (Full & Incremental) into Staging and ODS

areas, troubleshooting process, issues and errors using SQL Server

Integration Services (SSIS)- Frequency Weekly, Monthly

. Design SSIS packages - to perform ETL operation, created ETL Jobs

using SQL Server Agent.

. Developed Complex SQL Queries, Stored Procedure and Function to meet

the report requirements

. Worked on various SSRS reports like Action based Report, Parameterized

and Slice-Dice Report.

. Generated periodic reports based on the statistical analysis of the

data using SQL Server Reporting Services (SSRS).

. Able to perform Functional testing of the code ensuring that it meets

project requirements

. Gaining an insight into client's infrastructure, with the aim of

contributing effectively to the project as well as giving appropriate

solution to the business needs.

. Designed OLAP cube using SSAS.

. Responsible for the deployment of the Cube on the SSAS.

. Understanding the OLAP processing for changing and maintaining the

Warehousing, Optimizing Dimensions, Hierarchies and adding the

Aggregations to the Cube.

. Created multiple partitions on measure groups to improve cube

performance.

. Working with Customers and stake holders to identify their business

requirement & need to clarify their needs

. Worked on creating Indexes for Tables, Optimizing Queries

. Scheduled job using SQL Server Agent for SSIS Packages and Store

Procedure as per requirement.

. Involved in backup and recovery strategy planning.

. Co-ordination of Onshore team

Environment: SSAS, SSRS, SSIS, MDX, SQL Server 2008, Excel

Martiz Research, Fenton,MO

Jan 2010-June 2011

SQL Server/BI Developer

Responsibilities:

. Planned, Defined and Designed database based on business requirement

and provided documentation.

. Creation of SSIS packages to load fact and dimension table's data.

. Creating jobs for scheduling the SSIS packages.

. Created the mappings using transformations such as the Derived Column,

Aggregate, Merge joins Conditional Split and Audit transformation.

. Created SSIS Package to meet slowly Changing Dimension using Lookup &

OLDEB Transformation and Execute SQL Task Control Flow Item, Used the

FTP task to download the files and Implemented the automated E-mail

notification using Execute SQL Task- DB Mail to all users to refresh

their reports.

. Involved in creation of Tabular reports, chart reports, Drill through

reports and Parameterized reports and publishing the Reports to target

server

. As per requirements developed the reports in the form of Matrix, Table

and Chart Using SQL Server 2008 Reporting Services.

. Analyzing the traditional database (OLTP) of the client, Loading

appropriate dimensional tables as well as Fact tables for constructing

the Data warehouse.

. Worked Indexes, Stored Procedure optimizing

. Performed maintenance of Stored Procedures to improve Performance of

different front end Applications.

. Demonstrate can do attitude, promote best practice in team, sharing

business knowledge & debating technical solutions.

Environment: SQL Server 2008, SSIS, SSRS, SSAS, MDX, T-SQL, Windows 2003

/XP

UW Foundation, Madison, WI

Nov 2008-Dec 2009

SQL Server/BI Developer

Responsibilities:

. Involved in Requirement Gathering, Database Design and Report

Development

. Creating Stored Procedure and Functions

. Worked SQL Queries, Derived Queries, T-Sql Programming

. Worked on SSIS Packages to extract data from external source like CSV,

Text file, XML, MS-ACCESS DB.

. Deployed SSIS packages and Reports to Production Servers.

. Created cubes and dimensions and measures and calculated measures

according to the business requirements.

. Created SSRS Report using Shared Data Source, Shared Dataset and

Managed Report Server

. Created Audit Report using SSRS

. Publishing the reports and granting permission to users

. Encapsulated frequently used SQL Statements into stored procedures and

reduced the execution time

. Work with the end users to ensure that the reports are working as per

the Business requirements specified.

. Help the testers to prepare Test Cases in testing the reports as per

the specified requirements.

. Programming, documentation and implementation.

. Deploy OLAP Database to Production server and Deploy SSRS reports

. Excellent Communication and interact with customers & other teams.

Environment: SSAS, SSRS, MDX, SSIS, SQL Server 2008R2

Broad ridge Solutions, Hyderabad, India

April 2007-Oct 2008

SQL Server Developer

Responsibilities:

. Involved in various stages of SDLC like gathering User requirement and

System Specification. System Analysis, Design, Development, Testing

and Implementation

. Involved in developing E-R diagrams, logical & physical data modeling,

development and implementation of the system.

. From one standard database for loans created diversified destinations

for auto loans, student loans, home loans using SSIS packages.

. Calculated loan details for existing customers applying for a second

loan based on payment history and remaining amount of loan and used

SSRS to generate ad hoc reports

. Extensively used SQL server reporting services to generate reports on

a weekly basis for a particular loan type. Created report models for

ad hoc reports when the end user wants to see the reports.

. Developed complex T-SQL code for the application.

. Created Database Objects - Tables, Indexes, Views, User defined

functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.

. Administered interface to organize reports and data sources, schedule

report execution and delivery, and track reporting history using SSRS

2005.

. Maintained the physical database by monitoring performance, integrity

and optimized SQL queries for maximum efficiency using SQL Profiler.

Established backup and recovery of SQL reporting services.

Environment: MS SQL Server 2005, MS Server Integration services, DTS, SSRS,

and SQL Server Profiler.

Contact this candidate