Data Sql Server

Sandeep Punreddy

****************@*****.***

Contact no: 571-***-****

Summary

. Around 11 years of experience as a Business Intelligence Developer in

analysis, design, development, implementation, testing, and

maintenance of BI Applications.

. Experience with MS SQL Server 2000, 2005, 2008/R2 worked extensively

on Reporting services (SSRS), Integration services (SSIS) and Analysis

services (SSAS).

. Extensive knowledge and Experience in dealing with Relational

Database Management Systems including Normalization, Stored

Procedures, Constraints, Querying, Joins, Keys, Indexes, Data

Import/Export, Triggers and Cursors.

. Experience in delivering OLAP solutions by developing Corporate

Dashboard Reports using SQL Server Reporting Services (SSRS), Report

Model and Ad Hoc Reporting using Report Builder 1.0/2.0 and 3.0.

. Experience with troubleshooting existing issues with reports and

implementing performance tuning of T-SQL and Design of the report to

improve the overall end user experience

. Experience in designing and maintaining Intuitive Reports, Dashboards,

KPIs and Scorecards using SSRS BIDS, Crystal Reports XI,

PerformancePoint, ProClarity and Excel 2007/2010.

. Proficiency in delivering Business Intelligence Solutions using

Microsoft SharePoint Server 2007/2010 and other BI Tools like Business

Objects.

. Exposure to .NET, HTML, C Sharp, JAVA development.

. Developed ETL process using SSIS with Various Control Flow, Data Flow

tasks and Store Procedures for Work Order Validation process. .

. Experience in Data Warehouse Dimensional Modeling for SQL Server

Analysis Service (SSAS)

. In depth understanding of Microsoft Reporting Service (SSRS) with

Report authoring, Report management, Report formatting, Report

distribution, Report delivery and Report security.

. Experience working with Multidimensional databases and data mining in

SQL Server 2008 Analysis Services.

. Experience in training end users to build their own reports using

Report Builder and Excel (Pivot Tables/Power Pivot) using report

models and SSAS Cubes.

. Self-motivated and possess ability for critical thinking, analysis,

good interpersonal and communication skills. Team-oriented,

technically motivated and creative. User oriented with a desire to

learn client's business requirements. Ability to create and understand

Business, Functional requirements and design documents.

Skills:

Databases : MS SQL Server 2000/05/08/08R2, MS Access

Reporting : Crystal reports XI, Report Builder (1, 2 and 3), SQL Server

Reporting Services(2005,2008/R2 and 2012) and Excel

BI Tools : Performance Point Dashboard Designer 2007/2010, MS

SharePoint Server 2007/2010, Business Information Development Studio

2005/08/08R2(SSRS,SSIS & SSAS), Business Objects and ProClarity and Excel

ETL Tools : SQL Server Integration Services, DTS, Data Integrator,

11.7.2, Designer, Admin Console, Repository Manager

Other Tools: Visual Studio 2003/05/08/10, Adobe Dreamweaver, MS Web

Expression 2, MS SharePoint Designer 2007/2010

Programming: Experienced in T-SQL Queries, Knowledge of C Sharp, VB. Net

and JavaScript

Professional Work Experience

Organization: Xerox Education Solutions

Designation: Lead SSRS Consultant

Tenure: July 2012 - Till date

Environment: SQL Server 05/08/08 R2/2012, Business Intelligence Development

Studio (SSRS, SSIS & SSAS)

Key Responsibilities

. Lead a team of 5 for Reports Development for multiple projects using

SQL Server Reporting Services 2005/2008 & 2008 R2

. Conduct interviews with business users to understand their business

need for data and provide guidance on writing Business Requirement

Documents(BRD)

. Writing Detailed Design Documents (DRD) to document the design before

starting the development. Guide and review team members to do the

same.

. Building Very Complex reports using BIDS and Report Builder 3.0.

Including Financial, Operational and Business Reports.

. Design and Build SSRS Report Models and train users to use the Models

via Report Builder 3.0 to build their own Ad-hoc reports.

. Maintaining 350+ SSRS reports and troubleshooting the reports as and

when needed. Implement performance tuning for badly performing reports

and Queries.

. Lead the whole development process of the reports and guide team

members as and when needed.

. Deploying and maintaining SSRS reports via SSRS Report Manager and

BIDS

. Implement Item level security for the reports and report models.

. Creating a complete testing plan including unit tests, SAT, UAT and

performance testing.

. Set up T-SQL and SSRS Report Design standards for the team to assure

quality of the Reports, Queries and Stored Procedures.

. Writing Complex SQL Scripts to migrate Data between several databases.

. Provide well-tested, detailed deployment documentation in compliance

of existing Configuration Management policies for reports and T-SQL

scripts.

. Conducting post deployments interviews with end users to make sure the

reports are performing as expected and make any changes to improve the

overall UI.

. Conduct training sessions to educate client side developers about the

Database Schema, BIDS capabilities and Building Ad-hoc reports using

Report Builder and Excel.

. Conduct performance reviews yearly for all the team members to fill in

any gaps with in the team

. Conduct and lead knowledge sharing sessions with technical team and

business users to improve the overall process.

. Conduct Technical interviews to hire Reports/ETL/SQL professionals and

Admins

Organization: VIPS

Designation: Senior Consultant

Tenure: July 2011 - July 2012

Environment: SQL Server 05/08/08 R2, Business Intelligence Development

Studio (SSAS, SSRS & SSIS)

Key Responsibilities

. Analyze complex external database schema and scenarios to create,

deploy, enhance and maintain Reporting Services Reports and

Dashboards.

. Checking Application Performance and statistics using SQL Profiler, DB

Commands and Activity Monitor(SSMS)

. Maintaining SQL Database Back-ups and Replication Process. Creating

and maintaining data dictionaries for databases.

. Design and Build Report Models and train users to use the Models via

Report Builder III

. Writing Complex SQL Scripts to migrate Data between several databases.

. Complete Reports and T-SQL scripts development by coordinating

requirements, schedules, and activities.

. Design and conduct Testing of Databases, Reports and reporting models.

. Provide well-tested, detailed deployment documentation in compliance

of existing Configuration Management policies for reports and T-SQL

scripts.

. Troubleshoot development problems across multiple environments and

operating platforms.

. Communicate with clients to understand requirements for reports and

SQL scripts.

Organization: Affiliated Computer Services

Designation: Senior BI Consultant

Tenure: Oct 2005 - July 2011

Environment: SQL server 2000/05/08/08 R2, OLAP Cubes, Business Intelligence

Development Studio (SSAS, SSRS & SSIS), BO Crystal Reports XI, SharePoint

2007/2010, Performance 2007/2010, SharePoint Designer 2007

Key Responsibilities

. Delivering useful Information/data to business leaders and clients

using complete set of Business Intelligence Suit to help them make

decisions for betterment of the Business.

. Building and extending Data Marts and Data warehousing.

. Building, Maintaining and extending OLAP Cube Dimensions and Measures

using BIDS 2008/05.

. Extracting data from Cubes using Report Builder III, MS Excel and

PerformancePoint 2007/2010 dashboard Designer.

. Creating, maintaining and scheduling SSRS Reports using Business

Intelligence Development Studio 2008/05 and Report Manager

. Rewriting all the existing Crystal reports to SSRS as a part of

Crystal Reports Migration project.

. Building, Deploying and maintaining SSIS packages for Data transfers,

Loading Dimensional Data Warehouses and automating SSAS Cube

processing.

. Creating and maintaining SQL Views, Stored Procedures in SQL Server

2008/05

. Creating Dashboards, Key Performance Indicators, Scorecards,

Analytical Grids & Charts using PerformancePoint 2007/2010 and

publishing them over to SharePoint 2001/2010 Intranet.

. Maintain Internal SharePoint Intranet using SharePoint Designer 2007.

. Developing and maintaining Database back-up procedures

. Writing Database Documentation, Procedures and Meta data management.

. Building and maintaining customer portals in SharePoint for clients.

. Training end users to use Business intelligence suit Via SharePoint,

Report Builder III, intranet and MS Excel 2007/2010.

. Writing complex T-SQL Queries to query data from SQL Server Database.

Organization: Verizon Communications

Designation: BI Consultant

Tenure: Sep 2003 - October 2005

Environment: SQL server 2000, Crystal Reports XI, SSRS, SSAS, C Sharp, .Net

Key Responsibilities

. Coordinating with Stake Holders for Business process improvements,

providing Presentation Statistic reports to help them make decisions.

. Involved in Data Modeling, Dimensional Data Warehouse Designing for BI

Implementation across the board for data analytics.

. Providing overall leadership to Setup a Business Intelligence project

. Building and maintaining Crystal reports using Crystal XI, Object

Manager, Crystal Info view and Info Scheduler

. Maintaining Different servers and Data Sources for Crystal reports

using Central Management Console.(CMC)

. Creating and maintaining SQL Views, Stored Procedures in SQL Server

2000/05

. Building and Maintaining OLAP Cube Dimensions and Measures using BIDS.

. Writing complex T-SQL Queries to query data from SQL Database.

. Writing Reports in SSRS using Report Builder to access the data from

Marts OLAP Cubes

. Training end users to Extract Data from OLAP Cubes using MS Excel and

Microsoft ProClarity for visual Analysis of data and Preparing.

. Organizing workshops and seminars for end users and clients to

demonstrate the importance of the Business Intelligence suit and

training them to use it.

. Assist in Building Small C Sharp. Net Applications.

Education:

Masters In computer Science

References:

. Will be provided on request.

2

Contact this candidate