Pooja Nadubettu. Email: cj6dpl@r.postjobfree.com

Tower 801, Pine Street, Phone: 206-***-****

Seattle 98101

SUMMARY:

• Around 5 years of IT experience with extensive expertise in SQL Server technologies like MS SQL Server 2005/2008 suite of products like SSRS, SSAS,PPS,ProClarity including development, deployment, testing and support.

• Secondary skills include C#. NET development and Sharepoint development.

• Experience with software development life cycle (SDLC) and Project Management Methodologies.

• Experience in Analysis Services and Reporting services 2005/2008.

• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2005/2008.

• Experience in SQL reporting to SharePoint server dashboards

• Involved in logical design of database using ERWIN.

• Specialized in working with Source Code Version Controls such as Team Foundation Server 2008(TFS)

• Extensively worked with TFS to keep track of all changes made in the project, also used to get the latest project version from VSS to the staging server.

• Maintaining Version control for T-SQL, SSRS, SSAS using TFS.

• Experience in providing technical support to internal developers and external clients

• Excellent Communication, Analytical skills and Interpersonal skills. Versatile team player with proven problem solving skills. Proven ability to quickly learn new technologies.

TECHNICAL SKILLS

Business Intelligence Tools: PPS 2007, ProClarity 6.3, SSAS, SSRS.

Data bases: SQL Server 2005, SQL Server 2008, SQL Server Enterprise Manager, SQL Server Management Studio, Query Analyzer, SQL Profiler, SSAS, SSRS, BIDS,VSS, ERWIN

Languages: SQL, C#.

Web Technologies: ASP.NET 2.0, HTML, MOSS 2007.

Platforms: Windows 98, 2000 and XP Professional, Windows Server 2003.

PROFESSIONAL HISTORY

Client: Cisco, Georgia Pacific, Simplex- Grenell Oct 2008 – Nov 2011

Project: Supply Chain Visibility

Role Sr. SQL Developer (SSAS/SSRS)

Description: This product aims to build an active community of supply chain decision makers, professionals and

Experts. It envisions a forum where the community shares supply chain trends, issues, and ideas to help leaders to leverage their business process expertise and technology capabilities for insights and ideas on supply chain issues. It integrates function specific Business workbenches on a common Performance Management platform. It provides data and intelligence for supply chain professionals to manage performance of after-sales service, procurement, and inventory, demand management functions using best-in-class performance metrics and key performance indicator scorecards tailored for specific supply chain roles. It handles functionalities like:

• Creating alerts and initiatives based on the KPI values.

• Personalization of User dashboard to view scorecards and chart reports.

• Messaging for collaboration.

• Centralized security module.

• Workflows

Responsibilities:

• Participation in design discussions.

• Creation and implementation of canned reports in SSRS 2008.

• Creation of scorecards, charts and dashboards in PPS.

• Creation of content for demos and POC's.

• Involved in writing MDX queries and manipulating the multidimensional data in OLAP cubes.

• Development support, production support, and design review in a complex environment.

• Analyzed the existing application programs and tuned SQL, MDX queries using SQL performance Monitor, SQL Profiler, Query Analyzer.

• Participated in Quality processes such as design reviews, code reviews, version control and documentation.

• Generated the weekly, monthly, and quarterly reports by using SSRS.

• Creation of OLAP cubes (Dimensions, facts, relationships, perspectives) using Analysis Service 2008.

• Creation of technical feasibility document for implementation.

• Writing test cases and doing unit testing.

• Personalization of User dashboard to view scorecards and chart reports.

• Used TFS (Team Foundation Server) for project management and source control.

ENVIRONMENT: SQL, MDX, SSAS and SSRS 2008, SSIS,T-SQL, Visual studio2005, MS Excel PPS, ProClarity, Erwin, ASP.Net, MOSS 2007,TFS.

Client: British Telecom, India Feb 2008 – Aug 2008

Project: IB+ Portal

Role Developer

Description: The International Billing Portal is a portal to provide secure content (business documents)/repository management for BTGS and Tech Mahindra through a web browser. The basic function of the portal is to provide a centralized view of documents to the users, where in the users can upload, modify or delete documents The key features apart from authorization include the search feature to access the desired document. Also the users can be directed to 3rd party links through the portal. The users will be in sync with the latest version of the documents. The requirements include content management, management of multiple versions of documents, content approval, user management with appropriate roles and rights.

Responsibilities:

• Requirement gathering, client interaction.

• Responsible for conducting weekly meetings with development team.

• Creation of web-parts and integration of the same in the portal.

• Participated in re-design and development of back-end SQL Server database, wrote queries, and stored procedures.

• Used TFS (Team Foundation Server) for project management and source control.

Client: Microsoft, India Apr 2007 – Dec 2007

Project: Microsoft Enterprise cube – Customer Segmentation and Profitability, Resource management

Role SQL Developer (PPS/SSRS)

Description: Microsoft Enterprise Cube is the only packaged end-to-end BI offering at Microsoft and provides the framework for pain-point-specific BI solutions for industry verticals. MEC framework enables modularity, quick installation, and quick-to-time market and by which an organization can leverage the Microsoft BI product stack to report, analyze, trend and forecast business data without affecting live business support system.

The proposed solution for MEC processes the data into a mart, loads it into cubes and presents it in a SharePoint portal for KPIs and reports. Since KPIs are threshold driven one can set the targets to segment the customers based on their geography, demographic values, behavior, product, past business history and LOB. The purpose is to display the customer segmentation, profitability and resource management with respect to different scenarios. This application will display Scorecards, Reports, and Heat maps hosted at the UI.

Responsibilities:

• Creation of Scorecards, chart reports and Dashboards in PPS.

• Creation and implementation of canned reports in SSRS.

• Extensively wrote T- SQL codes for the project.

• Created Stored Procedures for Batch Processing.

• Delivered SQL server reports to SharePoint to enhance team collaboration

• Created monthly reports using reporting wizard with Visual Studio

• Created indexes to improve the performance of the queries

• Created backups and restore of the databases.

• Used data conversions to convert different data types

• Created Views for Extracting Data using TSQL.

• Used TFS (Team Foundation Server) for project management and source control.

•

.

ENVIRONMENT: SSIS, SSAS, SSRS, Pro Clarity Desktop, Performance Point Server 2007, MOSS 2007

Client: Tech Mahindra, India Dec 2005 – Mar 2007

Project: CSAT

Role Application Developer

Description: CSAT (Customer Satisfaction Automated Tool) project is an automated website for customer feedback. This website is designed and implemented for the top level management of Tech Mahindra. It works on how the feedback is initiated, approved and sent to the customer. After the feedback is received from the customer, depending on the CSAT score received for the project it is decided whether any action is to be taken for the project and Project Manager, if the score is not satisfactory.

Responsibilities:

• Requirement gathering, client interaction.

• Creation of webpages.

• Designed and developed the databases

• Participated in logical design of database to meet new product requirements.

• Wrote and modified stored procedures to implement complex business needs.

• Created user reports using SSRS 2005

• Writing test cases, doing unit testing for respective modules and integration testing.

• Used TFS (Team Foundation Server) for project management and source control.

ENVIRONMENT : SQL Server 2005, SSRS 2005, ASP.NET

TRAINING PROGRAMS ATTENDED

1. BizTalk Training by Synergetic

2. Business Intelligence Training by Synergetic

3. Initial Training Program by Tech Mahindra.

4. MOSS 2007.

5. SharePoint 2010.

EDUCATION

B.E (ISE) passed with [69%] from Dr.Ambedkar Institute of Technology, Vishweshwariah Technological University

PUC passed with [78%] from MES SSMPU College, Karnataka Pre-University in April, 2002.

SSLC passed with [85%] from Educare Academy Model School, Karnataka Secondary Board in March, 2000.

Contact this candidate