Project Management

Neha Sabharwal

*****, ** **** **., #****, Bellevue, WA 98007 520-***-****;

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

Professional Summary

. Advanced skills/expertise with MS Excel, SQL, data mining

. Extensive BI knowledge with developing balanced scorecards,

identifying KPI's, developing star schema, OLAP, ETL process. Strong

knowledge in designing, building, and maintain data warehouse.

. Proficiency with MS Office Tools (Word, Excel, Project,

PowerPoint, Visio).

. Strong analytical skills with extensive business and functional

background.

Education

. MS Management of Information Science (MIS) University of

Arizona- Tucson, AZ

Fall 2007- May 2009 GPA: 3.8

. B. Tech ECE Maulana Azad National Institute of

Technology (NIT), Bhopal, India

Fall 2001 - Fall 2005 GPA: 3.80, Top 5% in class.

Skill Set

. Languages : Java, Visual Basic, VB .Net, VBScript, PHP, SQL/PLSQL,

HTML

. Database : Oracle 9i, MS SQL Server, My SQL, MS Access

. Testing : Compuware Test Partner, QA Director, Track Record,

Reconcile

. Tools : Toad, Visual Studio, MS Visio, Microsoft project 05,

Dreamweaver, Photoshop, Drupal.

. BI Tools : Oracle warehouse builder, Microstrategy Reporting tools

. Concepts : OOAD, RDBMS, UML modeling, Database Design, ETL, Balance

scorecards, CSS, SOA

Relevant Coursework

Business Intelligence, System Analysis & Design, Project Management, IT

Strategy, Introduction to Enterprise Computing Environments, Business

Foundations for IT, Enterprise Database Management Systems, IT Security

Experience

Business Analyst, Microsoft,Redmond, USA

June 2009 - Till date

Role: Business Analyst

o Established criteria on the basis of registration trends to qualify

and approve/decline/remove existing and new program companies.

o Analyzed the daily registrations of program companies and determine

trends to decrease frauds.

o Produce a daily Business intelligence report for the field containing

the list of all suspicious or non eligible program members and

communicate with Field ongoing program membership status. Produce BI

reports on program downloads to eliminate abuse of the program.

o Launched the program camp nomination and organized camp nomination

reviews periodically to help the field increase the camps (technical

events for startups) in their areas. Facilitated fund transfer to the

local Microsoft champs in order to run local camp events thus managing

the IO/PO process.

Data/Web Analyst, University Library, University of Arizona, Tucson, AZ

Aug 07-May 09

Role: Database Analyst and Web Developer

o Identified that the existing database was becoming a bottleneck due to

increasing collections of data.

o Designed and developed a large database to store the common repository

functions and the metadata associated with these objects (journals,

articles etc).

o Focused on designing the system and testing it to ensure the

robustness by writing stored procedures and adding dummy data to

ensure the robustness.

o Developed a MS Access database to efficiently maintain a data

repository for the College of Medicine research center by analyzing

the requirement and translating those requirements into a database to

increase efficiency.

o Developed and managed a website in Drupal content management. Also

used HTML, CSS and Dreamweaver to ensure smooth flow of information to

the users.

Business Analyst, Freescale Semiconductors,Austin,TX, USA

June 2008 - September 2008

Role: Analyst in Product and Portfolio Management domain

o Led and facilitated efforts to create a process to ensure that the

market intelligence team makes informed decisions of their products

and portfolio of products for future considering their analysis from

market and customers. Used IBM's Focal Point as the backend for

process definition

o Gathered the relevant data by talking to different stakeholders and

translated the improved business processes into a CMS to improve

efficiency.

o Developed business rules for smooth flow of the process of creating

criteria's and performing priority analysis to assign ranks to the

various market sources and provided end-user training presentation.

Business System Analyst, AT&T and British Telecom Client, Tech Mahindra

Limited, India

June 05 - June 07

Role: Analyst/Test Developer in BT Test Automation team.

o Planned and prepared the approach used for the regression testing

automation of British Telecom (BT) applications. Analyzed testing

requirements from the functional specifications document and provided

estimations for various work items. Creation of Test Plans for the

items owned.

o Developed test scripts in Test Partner using VB 6 interfacing with MS

SQL Database and Oracle 9i with the help of ODBC and ADO connections.

o Analyzed and evaluated the advantages of QA director, Track Record and

Reconcile to be harnessed in the project. Also, managed the Test

lifecycle plan in QA Director.

Academic Projects

. Information Warehouse Office (IWO), University of Arizona(UofA)-

Business Intelligence Analyst

o Gathered and analyzed business requirements from IWO and other

stakeholders and translated them to develop the strategic linkages map

in balanced scorecard.

o Identified and documented KPI's like employee value index, complexity

and workload of a department for reducing the administrative overhead

of UofA after the new implementation of Kuali system.

o Developed a data warehouse schema based on strategic analysis and

identified sources to feed into it.

o Key outcome of this project was the increased transparency into the

performance of IWO operations to enable better decision making.

. Pima County JTED - Database and Project Management Analyst

o Analyzed current business processes and techniques for storage of data

and developed a Data flow diagram and Entity relationship diagram for

the 'to be' process. Created the database for efficient management of

data. Developed a prototype with integrated backend and the user

interface.

o Completed the Project management plan for the Pima County JTED project

by creating the work breakdown structure, Network diagrams, Critical

path analysis and Gantt charts for the project in Microsoft Project

2005.

o Performed scope, cost analysis, Quality and resource management for the

project. Developed a cost model that provided the clients with cost

estimation for the purchase of the software & hardware.

Tools/Tech: Work breakdown structure, N/w diagrams, Critical path

analysis, Gantt charts

Leadership & Honors

. Management Information Systems Graduate Association, Director of

Social Relations

-Initiated dialogue with alumni and invite them on campus to guide

students interested in consulting.

-Facilitated efforts to provide a platform to expose students to

cultural diversity.

. NSTISSI No. 4011 and CNSS No. 4012 professional certified, May 2008

. Earned the entry level Raytheon 6 Sigma training, December 2007

Contact this candidate