Pavan R

Bellevue, WA

accift@r.postjobfree.com - 215-***-****

I am a Senior SQL BI Developer and Analyst specializing in delivering Microsoft applications (SQL, BI

Reporting, Data warehousing, Database, Big Data and .NET applications)

I have 10+ years of extensive experience in Software application Analysis, Design, Development, Support,

Client interaction, Offshore-onshore coordination, and Team Management and Planning

Employers:

- Pactera Technology International Ltd, Bellevue, WA (October 1, 2011 to Till Date)

- ACCENTURE (July, 2003 to September 30, 2011)

Summary of experience:

. I have worked for client Microsoft, Redmond, USA, in the role of SQL BI Developer and Analyst. I have been

working on SQL, BI Reporting Tools and Data warehouse solutions since last 5 years for Microsoft. Dates:

Feb 2008 to Feb 2009, and Jan 2010 to Sep 2013

. I have worked for client Independence Blue Cross, Philadelphia, USA in the role of Systems Analyst. I have

worked on analyzing, building and supporting Web Reporting Applications. Dates: Mar 2009 to Dec 2009

. I have worked for client CUNA Mutual, Madison, USA in the role of Senior Software Engineer. I have worked

on analyzing, building, supporting .Net and Reporting Applications. Dates: Apr, 2007 to Oct 2007

. I have worked for client Lloyds TSB Registrars, Worthing, UK in the role of Senior Software Engineer. I have

worked on analyzing, building SSRS Reporting applications and ASP.Net C# Web application. Dates: Jun

2005 to Jan 2007

. I have worked for client Harley Davidson in the role of Software Engineer. I have worked on analyzing, building

Windows Forms applications using C# and MS SQL. Dates: July 2003 to May 2005

WORK EXPERIENCE

Senior SQL ETL BI Developer

Pactera Technology International Ltd - Bellevue, WA - October 2011 to Present

Senior SQL ETL BI Developer

Microsoft Corporation (through Pactera and Accenture) - February 2008 to September 2013

MS EDS/CFIT Plan Cast (40 Months)

MS Online Operations BI (6 Months)

MS BIE Mercury (13 Months)

Objective of projects is to build a data warehouse, and reporting applications supporting budget planning and

forecasting, Finance reporting and Partners Incentive payments.

Responsibilities:

• Performed roles of SDE and Analyst.

• Analyzed the requirements. Created Technical design documents

• Designed and Developed the Data acquisition/Integration and Distribution systems

• Designed and Developed Data validation systems.

• Designed and Developed the Reporting Solutions for Business Analysis

• Designed and Implemented Reporting Security. Created a framework to import User Security data on regular

intervals of time, and then apply/ refresh the Reporting security.

• Designed and Implemented a File Import Framework for Data Acquisition which is Metadata and Event Driven

Processing. It provides a flexibility of adding new Files and making changes to the existing Data Import process

without engineering effort. It has detailed Email Notification and Logging.

• Designed and Created a Domain Data Validation Framework. It is a solution to perform a Data validation check

of imported data against the Domain/Dimension tables. This framework is designed to use across projects

without changes to the code but require just a metadata change.

• Setting up MSRA (Microsoft Reporting Analytics) environment and its Metadata. I have got a very good

knowledge and understanding about MSRA Tool and its trouble shooting. It is a Reporting Tool used to create

an Excel based Ad-hoc Reports. It is a light weight, easily maintainable and customizable tool used across

many internal Microsoft projects.

• Designed MSRA Metadata population. I have created reusable solutions to setup the MSRA metadata to

provide an easy way of setting up the metadata for MSRA Reporting subject areas. It required strong T-SQL

skills, understanding of tool's metadata and knowledge of .NET Service Broker. This reusable framework was

also presented to other Microsoft teams having similar requirements and the solution was appreciated for its

simplified nature of metadata population task.

• Designed and Built a Data Feed Out program to facilitate the Data export feature for external sources to

consume data.

• Experience in Importing Fact and Domain Data from external sources, validate the data, transform the data

and merge with the existing data.

• Experience in Database Synchronization/Publish Programs to backup and restore the Datamart from Factory

server to Reporting server and refresh the Reporting servers

• Experience in Database Mirroring, Database Snapshot and Change Data Capturing features of Microsoft

SQL Server to pull changed data from Source systems.

• Experience with Job batches, Job Chaining and Job scheduling in Batch framework. It requires understanding

of the complete Data flow and dependencies between all components of a project.

• Experience in Query Optimization.

• Experiencer with Handshake mechanism to implement Data integrity when multiple data sources/program

components trying to either consume/provide data among themselves.

• Experience in Designing and Creating the Reporting Data marts which need an understanding of data

granularity, Reporting requirements and Business calculations.

• Handled Build activities including creating Build Installers using Microsoft Database Professional and MS

DOS batch file programming. Prepared Installation documents for deploying the Build drops.

• Experience handling Bug Triage Meetings and Functional Requirements Analysis. Experience in Coordinating

with multiple teams.

• Designed the databases. Experience in Database Modeling and ER Diagram presentations.

• Involved in Project Planning. Familiar with Microsoft Project tool.

• Involved in various phases of Solution implementation (Requirements gathering, Analysis, Designing,

Development, Bug triage, Defect fixing, Building deployments, releasing the fixes)

• Created SSAS Cubes for MSRA Usage Analysis. Created SSIS packages to import MSRA usage metadata

from Production MSRA servers.

Technologies:

Microsoft SQL Server 2008/2012, SSIS, SSAS, MSRA (Microsoft Reporting Analytics), TSQL, ETL, Data

warehousing solutions, Visio, Visual Studio Tools, MS DB Pro

Development and Support

Independence Blue Cross (through Accenture) - Philadelphia, PA - April 2009 to December 2009

IBC Informatics BICOE

Independence Blue Cross is Philadelphia (USA) region's largest health insurers. IBC Informatics is a division

responsible for providing the reporting applications for analysis and business decision making.

This project involves creation of new reporting applications, supporting the current applications in the

Production, analyzing and fixing defects, and implementing change requests. I was Offshore-Onshore

coordinator where my work involved is communicating with client and coordinating Offshore for various tasks

involved in Reporting and C# applications Development, Maintenance and Testing.

Responsibilities:

• Onshore-Offshore Teams Coordination. I was at Client site representing the Offshore Teams and handled

the Requirements gathering, Development, Testing, Support and Release Management activities.

• Planning Resources and Project Deliverables.

• Architecting, Designing, Building and Delivering Reporting Applications

• Production support. Defects Fixing, Root cause analysis and Bug Triaging.

• Training Offshore Team. Preparing Training Plans and Documents

• Setting up Infrastructure and Handling Application Approval Access for Offshore Team.

• Client Interaction, Requirements analysis, Daily calls with offshore teams and direct interactions with client

teams.

• Release management activities involving Planning Drops and Preparing Release Documents.

• Handing Functional Change Requirements and Change Requests Impact Analysis and Implementation

• Performed Code reviews and System Improvements

Platform:

Microsoft SQL Server 2008, SQL Server Reporting services (SSRS), C#, Information Builder Web Focus

reporting tool, Teradata.

Development and Support

CUNA Mutual Group, Madison, USA (through Accenture) - April 2007 to January 2008

Member CONNECT Campaign Management System

CUNA Mutual Group is US based leading provider of financial services to credit unions and their

members worldwide, offering lending, protection, financial, employee and member solutions through strategic

partnerships, technological innovations and multiple service channels.

Member CONNECT Campaign Management System is a marketing solution to sell its Insurance products.

This Project involved maintaining the existing production system and making system enhancements.

Responsibilities:

• On call Production Support addressing the issues arising from Production Environment and providing support

to Business users.

• I was Offshore-Onshore Coordinator with responsibilities including setting up the offshore team, Training

them, Managing offshore work by interacting with them daily, Allotting work to them, Gathering requirements,

and acting as a coordinator between Client and Offshore teams.

• Handled System support which involved addressing issues arise from production system run.

• Handled System enhancements which involved adding and changing systems functionality.

• Enhancements also included redesigning the existing application for performance improvements. Both the

activities involved lot of client interaction for requirements gathering, issue resolution, functional and technical

analysis, time estimations, documentations, code implementation.

• Extensively involved in monitoring and addressing the issues from Production environment. Provided

24/7 on call support to the customers. Involved in setting up and managing offshore team, preparing

Training documents, giving them the training, monitoring the team, allotting work, requirement issue resolving,

coordinating between onshore and offshore

• Development of Reports. Handling SSRS reporting issues. Generating reports using SQL queries, improving

the report SQL queries and redesigning the reports.

• Continuous interaction with customers to understand and resolve the issues.

• Analysis, time estimations and implementation of Change requests. Also involved its requirements gathering

and documentation.

• Database programming - Stored procedure creation. Performance tuning

• Technical analysis of functional requirements and its documentation. And also time estimations.

• Design, Coding and Unit testing of all the enhancement activities.

• Time estimation for the enhancement and support activities.

• Extensively involved in preparing KT (Knowledge transfer) plans and training new joiners for offshore project

setup.

• Acting as first functional and technical point of contact at Offshore.

Platform:

.NET, C#, Microsoft SQL Server, SQL Server Reporting services (SSRS), MS DOS Batch file programming

Development

Lloyds Trustee Savings Bank Registrars, UK (through Accenture) - June 2005 to March 2007

1 Year 10 Months)

Project: LTSB RRP (June 2005 to March 2007)

LTSB RRP (Lloyds TSB Registrars Re-engineering Programme)

Lloyds TSB Registrars is the UK's leading provider of share registration services, employee share plans

administration and corporate actions expertise.

LTSB RRP (Lloyds TSB Registrars Re-engineering Programme) is a major process re-engineering project of

Lloyds TSB Registrars existing system. The business need of this project is to automate extensive manual

processing & establishing technological leadership as a source of competitive advantage for LTSB Registrars.

Responsibilities:

• I have involved in the development of Reporting and Web based applications. Also involved in the

Maintenance releases to support the production environment.

• I was at onsite to speed up the development process by interacting directly with client teams on requirements,

defect resolutions, change control implementations. I was domain expert.

• Designing, Coding and Unit testing of Reporting applications and C# components

• Defect fixing and Change Requests implementations. Performing Defect Root Cause Analysis

• Interaction with the clients

• Change Requests Analysis, Impact Analysis and Time Estimation

• Code Reviews

• Addressing Functionality Issues of team

• Acted as Functional Point of contact for some of the modules

• Taking induction to the new joiners to explain project architecture and project development processes.

• Conducting knowledge sharing sessions on technical and functional topics.

Platform:

Microsoft SQL Server, Microsoft SQL Reporting Services, ASP.NET with C#, Web services, ACA.NET,

Windows services, Tech Genome, Service Oriented Architecture, NUnit, NCover, IIS, and Microsoft Visio.

Development

Harley-Davidson Motor Company, USA (through Accenture) - Harley, WV - July 2003 to May 2005

1 Year 11 Months)

Project: Talon.Net (July 2003 to May 2005)

Harley Davidson Dealer Systems - Talon.Net (Development and Support)

Harley-Davidson Motor Company is an American manufacturer of motorcycles based in Milwaukee, United

States.

Talon.Net is a dealer management software system for the Harley-Davidson Motor Company, US. Harley-

Davidson has over 400 dealers all over the world, who are currently using a dealer management system

developed using Clarion. The existing Clarion systems are going to be replaced with Talon.Net application.

Talon.Net application provides all the functionalities that a Harley-Davidson dealership requires, like selling

vehicles, managing customers, and handling service, accounting and vehicle inventory.

Responsibilities:

• Talon.Net Build worked involved the End-to-End development of the application. Involved in the development

of User Interface, Business Layers, Data Layers and Database Stored procedures.

• Handled some of the most complex builds in Harley-Davidson project and interaction with Onshore team on

requirements issues and Defect fixes.

• Talon.Net Warranty involved the maintenance of all the modules released. Supported production

environment.

• Coding and Unit testing

• Involved in End to End development from User Interface to Database programming.

• Defect fixing and Change Requests implementations

• Interaction with the clients for resolving issues

• Acted as Point of contact for some of the modules

• Involved in performance tuning of stored procedures.

• Defect Root Cause Analysis

• Functional Design Analysis and Onsite interaction

• Change Requests Analysis, Impact Analysis and Time Estimation

Platform:

Microsoft SQL Server, Windows Forms with C#, .Net Framework, ACA.NET, NUnit, NCover, Microsoft Visio.

EDUCATION

Master’s Degree in Computer Applications in Computer Science

Bangalore University

MCSD.NET in Computer Science

Microsoft Certification

Certified Apache Hadoop 2.0 Big Data Developer in Computer Science

Hortonworks University

SKILLS

Microsoft Specific Skills • Microsoft SQL Server 2005, 2008, 2012 • MSRA (Microsoft Reporting Analytics Tool)

• Data warehouse solutions Design and implementation • ETL (Extract Transform and Load) Implementation,

Microsoft SQL Server Reporting services (SSRS), SQL Server Integration Services (SSIS), SQL Server

Analysis Services (SSAS) •Database Modeling, Performance tuning and Administration • Information Builder’s

Web Focus reporting tool •.Net, C#, VB.NET, ASP.NET, .NET Service Broker, Windows Forms •MS DOS

batch file programming • MS Visio, Windows Services, Web Services . Big Data

ADDITIONAL INFORMATION

Other Skills

. Hadoop 2.0

. Unix/Linux

• Planning, Requirements gathering, Analysis, Design and Code Delivery

•Visual Studio Team Foundation (Source control, Defect Tracker, Change requests management)

• Offshore-Onsite coordination skills, Client interaction skills,

• UAT & Production support and Incident Management

•Release management

•Change Requests analysis, time estimations and implementation.

•Infrastructure setup planning and implementation

. Java

Contact this candidate