Project Manager

RACHNA ARORA

*** **** ***** ***, ******, CA *****

******.***@*****.***, H: 916-***-****, C: 916-***-****

OBJECTIVE

Seeking a challenging position as a Business Analyst/Programmer Analyst

allowing me utilize my experience in Business Analysis, Software

development and design in developing and executing key business strategies.

SKILLS

Over six years of progressive & diverse IT experience with notable success

in leading a broad range of initiatives in Business Analysis, Software

development & design areas. Expertise and experience include:

> Experience in preparing USE Case & UML diagrams, Business Requirement

Documents (BRD) and Functional Requirement Documents (FRD)

> Extensive knowledge of all stages of Software Development Life Cycle

(SDLC)

> Experience in facilitating Joint Application Development (JAD)

sessions with stakeholders, management team and IT staff

> Experience in preparing Request for Proposal (RFP), conducting Benefit-

Cost Analysis, preparing cost estimates, and preparing RFP responses for

new projects

> Experience in conducting SWOT analysis for strategic business planning

> Experience in web-development using PHP, MySQL & Apache

> Experience in using SAS to perform Descriptive and Inferential

Statistical Analyses and using data mining techniques to conduct market

research

> Experience in applying HIPAA guidelines for health care projects, in

implementing change management strategies for IT projects

> Proactive team player with strong problem solving and analytical

reasoning skills

> Strong interpersonal, communication, presentation & business writing

skills.

TECHNICAL EXPERTISE

> Tools: Toad, Rational Requisite Pro, MS Visio, MS Project, Mercury ITG

> Methodologies: RUP, UML, Waterfall, Agile, SDLC

> Database: Oracle, MySQL

> Programming languages/Server: C, SQL, HTML, .NET, SAS, PHP, Apache

HTTP

> Operating System: Windows, UNIX

> MS Office Suite: Access, Excel, Power Point, Word

WORK HISTORY

MAXIMUS, Folsom, CA

Dec 2008- till date

Business Analyst

MAXIMUS provides IT program management and operations services to state and

local governments, as well as the federal government.

As a Business Analyst at MAXIMUS, worked on implementing several Change

Action Requests (CARs) and Gap Analyses for IT projects.

Major IT projects:

> CA State's Healthy Family Program (HFP) Project

(www.healthyfamilies.ca.gov)

Implemented several enhancements to the HFP website, including

developing a web-based user interface on the HFP website, including

HFP enrollee forms and applications in various languages, enabling

server-side processing and routing of each order to HF Mail Operations

team.

> Access for Infants and Mothers (AIM) Program Project (www.aim.ca.gov)

Implemented several enhancements to both English and Spanish versions

of AIM program website, including adding new tabs to the website

containing all downloadable items (Forms, Letter, Employer Statement

and Affidavit of Income) for users, reorganizing and adding new

content to AIM website.

> Federal Income Guidelines (FIG) 2009 Project

Implemented changes needed to the Enrollment Entities & Certified

Application Assistants (EE & CAA) tab of HFP & AIM and websites to

accommodate new FIGs for year 2009. Modifications included, updating

FIG tables (in MAXe2 and Health-e-App) in the Production System,

updating content of CAA web-based training site, and VIPP development

for the errata sheets for the HFP and AIM handbooks.

> Online Eligibility Verification System (OEVS) Project

(https://oevs.healthyfamilies.ca.gov:4446/hfdmt/cs_html_pkg.plan_search

)

Coordinated Analysis, Design, Testing and Implementation tasks for

development of new OEVS intranet website. This website was made for

external partnership entities (such as Health, Dental and Vision

Plans) contracted by Managed Risk Medical Insurance Board (MRMIB) to

support Health Families (HFP) and Access for Infants and Mothers (AIM)

program.

Roles and Responsibilities:

> Gathered business requirements and created Business Requirement

Documents (BRD's) for all CARs (Change Action Requirements) assigned

> Analyzed and translated the business requirement into System

Requirements Specification (SRS) using MS Word, MS Excel and MS Visio

> Created Gap Analysis for the management team and the developers to

better understand the current state and desired future state

> Developed AS IS and TO BE diagram for the projects using MS Visio

> Conducted JAD sessions with management, vendors, users and

stakeholders for open and pending issues

> Act as a liaison between the developers and the management team

> Functioned as a primary liaison between the business line, operations

and the technical personnel

> Created test scenarios for various projects

> Used SQL and Toad to run the queries and used the results for testing

> Tested the scenarios in the test, staging and production environments.

Environment: Windows, SQL, Toad, UML, RUP, Mercury ITG, MS Project, MS

Visio, MS Excel, MS Word.

Open Information Technology, Folsom, CA

Sep 2007-Dec 2008

Business Analyst

Open Information Technology (OIT) is a software consulting and systems

integration firm. OIT's major business is providing turnkey IT solutions

for its clients.

24X7 Real Estate Exchange project:

Responsible for performing Business Analysis & software design/development

functions for OIT's 24X7 Real Estate Exchange project. This project

entailed development of a real estate website that would mainly allow

foreclosure investors communicate and transact with the foreclosure

sellers. Involved in all the stages of the project: Analysis, Design,

Development, Testing and Implementation.

Roles and Responsibilities:

> Gathered business requirements by conducting interviews, organizing

conference call discussions and brainstorming sessions with the client

> Translated user requirements into functional and non functional

requirements

> Prepared Business Requirements Document (BRD) for the project

> Assisted the project development team in performing various software

development tasks, as needed, to meet project deadlines

> Designed Use Case Diagrams, Data Flow Diagrams (DFDs) and Activity

Diagrams in MS Visio to further refine the requirements

> Conducted several website module demo sessions for the client to

ensure that the requirements were adequately getting captured

> Conducted several JAD sessions with Project Manager, Client, and IT

staff to expedite the project

> Performed various testing tasks, as required for the project

> Used predictive analytics (data mining) techniques to identify target

customers for client's website

> Assisted in conducting SWOT (Strengths, Weakness, Opportunities, and

Threats) Analysis for this new business venture.

Environment: Windows, SQL, Rational Requisite Pro, UML, RUP, SAS, MS

Project, MS Visio, MS Excel, Apache, MySQL, PHP.

Indus Valley Consulting

June 2004 - Dec 2006

Web Developer

Worked on various web development projects. Designed websites integrating

text, audio, video and images for various corporate clients. Proficient in

using PHP, Apache, MySQL.

Roles and Responsibilities:

> Responsible for all stages of website creation for clients, from

initial design and architecture to development, deployment, and

management of websites.

> Created design documents for easy understanding of the

functionalities.

> Adept at successfully revamping websites to enhance user satisfaction

and retention time, streamline navigation, and increase ad revenue and

sales.

> Donated technical abilities and time to area not for profit entities

in creation of web pages.

Environment: PHP, Apache, MySQL, SQL, HTML, XML.

VMT International

June 2002 - Dec 2003

Associate Business Analyst

VMT International is a leading IT consulting, services, and business

process outsourcing organization.

Major projects:

Electronic Agents Sales Experience (EASE) project:

Worked on Capgemini's Assurant Health EASE project. Assurant Health

provides medical, small group, short term and student health insurance

products. Under the supervision of Senior Business Analyst, performed

detailed Business Analysis for this project. This project entailed

developing a portal solution that helped Assurant agents obtain accurate

quotes and process applications more quickly.

Online Learning, Testing, Evaluation and Reporting (OLTER) project:

The scope of this project was to develop Online Learning, Testing,

Evaluation and Reporting (OLTER) system for VMT's client, Aptech Computer

Education, Ltd. OLTER was a useful tool for Aptech's students and

professors, as it enabled them to participate in online classes and also

provided online testing capability.

Roles and Responsibilities:

> Gathered requirements by interviewing Client, key Aptech Instructors

and students

> Involved in all the stages of System Development Life Cycle (SDLC)

> Assisted in preparing Business Requirement Document (BRD) and

converting business requirements into System Requirements

Specification (SRS)

> Developed AS-IS and TO-BE process diagrams using MS Visio

> Prepared Use Case Diagrams, Data Flow Diagrams, Flow Charts and

developed Activity diagrams for the project using MS Visio

> Consulted with the Subject Matter Experts (SME) to understand the

interoperability aspects of the new system with existing business

processes

> Effectively communicated business requirements with the IT development

team and worked closely with them throughout the project

> Assisted in creating prototypes of the new system and provided screen

shots for better visualization

> Participated as required in system testing activities, including

preparation of test plans, cases, and scenarios.

> Prepared User Guide for OLTER system.

Environment: Rational Requisite Pro, SQL, MS Visio, MS Project, MS

Word, MS Excel, MS Access, UML, RUP.

Aptech Ltd, India June

2001 - June 2002

IT Instructor

Aptech Ltd's flagship brand, Aptech Computer Education, offers a wide range

of long-term and short-term IT courses which help individuals enhance their

IT skills, and provide them with an opportunity to achieve a globally

recognized IT Diploma.

In the capacity of an IT instructor at Aptech Computer Education's Roorkee

campus, I was responsible for training students in vast variety of courses

under the categories of Information Technology, Multimedia and Soft Skills

enhancement.

> Trained students in variety of software programming languages and

packages

> Conducted latest technology research & interviewed several current and

prospective students to prepare new training proposals for upper

management approval

> Guided a group of students in developing electronic train reservation

system using C.

EDUCATION

Golden Gate University, San Francisco, CA

Masters in Business Administration (IT)

Dec 2007

Garhwal University, India

Masters in Commerce (Marketing)

May 2003

C.C.S. University, India

Bachelors in Commerce (Accounting)

May 2001

Indira Gandhi National Open University (IGNOU), India

Certificate in Computing (CIC)

Dec 2001

Aptech Computer Education, India

Higher Diploma in Software Engineering (HDSE)

Aug 1999

COURSE WORK

> Economics for Managers, Managerial Analysis and Team Dynamics,

Managerial Finance, Marketing Management, Operations Management,

Management of Innovations and Technology, Developing strategies for

Competitive Advantage

> International Business and Strategy, Management Theory and

Communication, Data Analysis for Managers

> Enterprise Information Systems and Technologies, Systems Analysis

Design and Implementation, Business Data Analysis, Network-based

Systems.

ACADEMIC PROJECTS

> Used SAS to perform Descriptive Analysis of financial data for Rekha

Inc for MBA course project

> Prepared Request For Proposal (RFP) to build an Enterprise Wide

Network for an IT Education company as part of MBA Course Project

> Used Visible Analyst to design and implement an automation system for

payroll management division of Open Information Technology (OIT)

> Used Marketing Plan Pro to develop a marketing plan to sell home

furnishing products.

WORK AUTHORIZATION

US Permanent Resident (Green Card Holder).

Contact this candidate