Project Management

KUMAR D PANDAY

Lynnwood WA – *****, Ph - 562-***-****, *********@*****.***

PROFILE

Goal-oriented, results driven, analytical and innovative IT/Business Consultant, with over nine

(9) years of Business Analysis experience in Hospitality, Health Care and Education industries.

Successful at evaluating existing business processes to identify and recommend key improvement

areas. Expert at scheduling and maximizing workforce productivity while delivering on time

business results.

Core Strengths:

Leading/Motivating Technical Support Teams Operational Management

Program & Project Management Team Management & Mentoring

Resource Planning Supply-Demand Analysis

Process Optimization SDLC Implementation

Cross Functional Communication IT Best-Practices & Methodologies

SKILLS & ACCOMPLISHMENTS

• Over 9 years of expertise in performing ad hoc business analysis, data modeling and

resource management.

• Hands on experience in full Software Development Life Cycle (RUP, Waterfall, Spiral,

Agile & other SDLC implementation) and Project Management Life Cycle (PMLC).

• Strong research, analytical and problem solving skills and experience working under and

meeting critical deadlines.

• Experienced in managing resource and staffing requests in an environment with rapidly

changing project needs

• Possess excellent communication and interpersonal skills to conduct large meetings and

presentations to stakeholders, business and technical teams.

• Experience gathering requirements for enhancing ecommerce websites including search and

checkout functionality.

• Experience in updating base copies while the changes in configuration occur in development

process and properly document and report the changes to the management.

• Utilized Sharepoint tool to set up regular communications channels for disseminating project

status reporting, schedules and resource allocations.

• Competitive and resourceful with a multi-faceted experience in this global era of

international business, ecommerce, online analytics, and resource management.

• Arranged and prioritize each project according to its strategic value.

• Developed install plans, notified users of system maintenance and associated downtime,

issued release notes.

• Create the Release calendar for the applications.

• Coordinated software upgrades and releases for test and production environments.

• Scrum Master for major Release, Agile and Software Configuration Management (Source

code version control, automatic building and gathering strategies).

• Actively involved in project management, new products release campaign, application

development, team mentoring and staff management.

• Excellent Team Lead with good planning, mentoring and relationship building skills.

• Demonstrated experience in managing relationships with key clients, vendor management

by developing tailored business proposals (RFPs), interacting with clients simultaneously in

user feedback sessions through the various phases of the project life cycle, and assisting in

user training.

• Applauded for the ability to effectively facilitate the process of knowledge transfer between

business, technical and development teams.

TECHNICAL SKILL SET

Operating Systems Microsoft Windows 95/98/2000/NT/XP, Unix

Databases MS SQL Server 2000, MS Access, Oracle 9i/10G XE, IBM DB2

Statistical Tools SAAS, SPSS, Advanced Excel (Pivot Tables)

Languages PL/SQL, UML, HTML, XML

SDLC Methods Agile, RUP, Waterfall, V-Model, Spriral, SOA

MS Office Suite, MS Project, MS Visio, IBM Lotus Notes,

Software

SharePoint

Application Servers BEA Weblogic 6.1/8.1, Apache Tomcat 5.0, Websphere

Modeling & Designing Tools IBM Rational Rose, MS Visio, Toad, Erwin

Requirements Gathering &

TFS, IBM Rational Requisite Pro, IBM Rational ClearCase, Clarity

Version Control Tools

Quality Center 10.0, Load Runner 9.1, Mercury (Now HP) Quick Test

Testing Tools

Professional 9.0

Change/Quality IBM Rational ClearQuest, Bugzilla, Mercury (Now HP) Quality

Management Tools Center

PROFESSIONAL EXPERIENCE

Premera Blue Cross Sep 2011 - Present

Sr. Business Analyst (Web Applications)

Company: Premera is a health benefits company serving 1.6 million people, from individuals to

Fortune 100 companies. They provide health, life, vision, dental, long-term care coverage, and

other related services. E-biz department of PBC is chartered to replace the current PBC website

(ehealth) with an entirely new web application which will handle the customer through a single

point of sale instead of different line of business.

Project: This Project has been chartered by the E-biz department of PBC to replace the current

PBC website (ehealth) with an entirely new web application which will handle the customer

through a single point of sale instead separate LOB websites.

Responsibilities:

• Created Project Plan and assess work-effort estimates required to accomplish various phases

of the Project.

• Gathered analyzed, documented business and technical requirements from both formal and

informal sessions and validate the needs of the business stakeholders.

• Conducted user interviews and documented business and functional requirements.

• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using

Rational Rose

• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and

used SQL queries to filter data

• Completed the documentation of Claims Scenario’s for the source system

• Analyzed the existing claims process and specific business rule logic will be applied in the

ACP model.

• Involved in creating business processes and modeling diagrams using Rational Unified

Process (RUP).

• Created use case scenarios and documented work flow and business process using Rational

Rose

• Involved in project management using MS Project

• Create technical design documentation for the data models, data flow control process,

metadata management.

• Developed and maintained programs in SAS for UNIX in a user support environment.

• Created SAS programs that are used for data validation, statistical report generation and

program validation and automated the Edit Check programs using Macros

• Developed UNIX Shell scripts to automate repetitive database processes.

• Extensively involved in the modeling and development of Reporting Data Warehousing

System.

• Lead multiple project teams of technical professionals through all phases of the SDLC using

technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and

Cognos.

• Created source table definitions in the Data Stage Repository by studying the data sources.

• Generated Surrogate ID’s for the dimensions in the fact table for indexed and faster access of

data.

• Gathered requirements and modeled the data warehouse and the underlying transactional

database

• Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications

using Visible Analyst.

• Created Graphical representation of reports such as Bar charts, Pie charts etc as per the End

user requirements using Business Objects and Crystal reports.

• Assisted front-end development teams in integrating Crystal Reports in the .NET application

using SDK.

• Worked closely with the Enterprise Data Warehouse team and Business Intelligence

Architecture team to understand repository objects that support the business requirement and

process.

• Used Crystal Reports to design a complex, on the fly, report that displayed complete charts

based on the parameters.

• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse

data models

• Identified/documented data sources and transformation rules required populating and

maintaining data warehouse content.

• Used Rational Clear case for version control

• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies

throughout the project life cycle.

Marriott International (E-Biz) Mar 2011 – Aug 2011

Sr. Business Analyst

Company: Marriott International is a leading Hotel management and ownership group with

more than 3,400 lodging properties in 68 countries and territories. Marriott International operates

and franchises hotels under their brand names. It also develops and operates vacation ownership

resorts under the Marriott Vacation Club, The Ritz-Carlton Destination Club, and Grand

Residences by Marriott brands.

Project: Loyalty program enhancement (LPE) project was chartered to provide addition

features to Marriott Brand guests in order to get a competitive edge in the market. Scope of

project included various discounts on Stays, rewards, upgrades and its integration to the

reservation system across the globe.

• Responsibility: Requisite Pro for the Requirement Documents Preparation and

Prepared Business Process Models that includes modeling of all the activities of the

business from the conceptual to procedural level. Followed top down, leveled technique

for building Business Process Models.

• Played a substantial role in the process definitions and business and functional

requirements gathering, in an effort to develop a practical technology solution for

automating sales methodology.

• Created Use Cases / Activity Diagrams / State Chart Diagrams, Sequence Diagrams,

and Collaboration Diagrams thus defining the Data Process Model and Business Process

Model.

• Converted Business Requirements to the Functional Specification and Conducted

JAD Sessions to develop an architectural solution that the application meets the business

requirements, resolve open issues, and change requests.

• Provide business intelligence analysis to decision-makers using an interactive OLAP

tool

• Worked closely with the Enterprise Data Warehouse team and Business Intelligence

Architecture team to understand repository objects that support the business requirement

and process.

• Lead multiple project teams of technical professionals through all phases of the

SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Web

sphere and Edge (CRM)

• Performed extensive data modelling to differentiate between the OLTP and Data

Warehouse data models

• Automated Shell scripts to pull and load data from operational resources into the

Data Staging Area and Data Warehouse for business intelligence reporting.

• Defined Functional Test Cases, documented, Executed test script in Facets system.

• Identified/documented data sources and transformation rules required populating and

maintaining data warehouse content.

• Implemented and monitored Individual Development Plans focusing on total

performance, including both quality and productivity and validated technical designs

created by IT developers against functional specifications.

• Extensive experience in all phases of RUP and SDLC processes

• Monitored client expectations through client involvement and communication

throughout the lifecycle of the project; educate clients and stakeholders on the benefits

and risks associated with the project.

• Evaluated the Rational comprehensive approach to software development, featuring

seamless integration between tools, services and best practices, enables the organization

to successfully deliver high quality software while deriving impressive business benefits

for their customers.

Environment: VB 6.0, Oracle, Db2, SQL, VBA, Windows, Rational Enterprise suite, MS Office,

MS Project.

SAGE Hospitality, Providence, RI Nov 2010 – Mar 2011

Asst Manager – Event Operations

Company: SAGE Hospitality is one of the largest hotels and ownership groups in United States

with a management history of over 450 hotels on behalf of a wide variety of clients under global

brands. SAGE is currently managing over 60 hotels in 26 states and our proven track record

includes 2009 year-end results with 75 percent of Sage hotels gaining market share.

Responsibilities

This position was a part of Optional Practical Training granted to International students in United

States. I have been involved with Renaissance Hotel, Providence a premium lifestyle Brand by

Marriott managed by SAGE Hospitality. As an Asst. Manager of Event operations my duties

included but not limited to the following.

• Managing various events ranging from corporate meetings to wedding etc. Liaising

with clients to ascertain their precise event requirements.

• Producing detailed proposals for events (e.g. timelines, venues, suppliers, legal

obligations, staffing and budgets) as required by the business.

• Securing and booking a suitable venue or location if multiple locations are involved.

• Ensuring insurance, legal, health and safety obligations are adhered to.

• Co-coordinating hotel management team, kitchen, bar, restaurant, stand designers,

contractors and equipment vendors for a smooth functioning.

• Planning room layouts and the entertainment program, scheduling workshops and for

servers and other staff members.

• Organizing facilities for car parking, traffic control, security, first aid, hospitality and

press.

• Identifying and securing speakers or special guests;

• Co-coordinating staffing requirements and staff briefings through daily stand-ups.

• Selling sponsorship/stand/exhibition space to potential exhibitors/partners;

• Arranging accommodation for exhibitors and/or delegates;

• Preparing delegate packs and papers;

• Creating, implementing and monitoring marketing and PR plans.

• Liaising with clients and designers to create a brand/look for the event,

• Writing press releases or briefs in order to gain maximum exposure for the event;

• Organizing the design and production of tickets, posters, catalogs and sales

brochures;

• Co-coordinating everything on the day of the event to ensure that all runs smoothly;

• Handling client queries on the day and troubleshooting exhibitor and visitor problems

on the day;

• Overseeing the dismantling and removal of the event, and clearing the venue

efficiently;

• Post-event evaluation (including data entry and analysis and producing reports for

event stakeholders).

• Responsible for soliciting banquet business and ensuring customer satisfaction with

all functions booked.

• Coordinates and supervises the execution of all banquet functions to ensure clients'

specifications are adhered to

• Make sure that the function runs smoothly and efficiently.

• Posting charges on DELPHI sales & Catering system, and communication with

Night Audit team for any differences in posting charges.

• Helping management for staff orientation, running payroll and scheduling using ADP

• Possesses knowledge of food production and service

• Should have the ability to perform all position in banquet operations in order to

supervise, direct, and train all banquet personnel.

• Oversees management, budget, and operation of the food service outlet, catering

services, and kitchen, and maintains liaison with sales department to ensure maximum

profitability

Environment:

Johnson & Wales University (On Campus) Sep 2008 – Nov 2010

Teaching Assistant /Fellow

Company: Johnson & Wales University is one of the finest school for Hospitality & Culinary arts

students in United States. With over 2000 international students who come to pursue hospitality

education this university offers on campus internship through their practicum properties,

Radisson Airport Hotel and Johnson & Wales Inn.

Responsibilities

I have been working as a teaching Assistant in the practicum property this University. I have

trained student in F&B, Housekeeping, Night Audit and Front Desk operations. As a trainer my

duties included as follows;

• Ensuring proper University teaching protocols is adhered, while interns are on property.

• Ensuring Interns are provided guidance on the job without sacrificing goodwill of

Radisson brand.

• Evaluating students at the end of their rotation in each department and sending the grades

to the concerned department.

• Making sure that the interns gets maximum exposure of OPERA Property management

system and evaluating their practical skills, based on their on the job performance

• Ensured that each and every guest is treated with utmost care by interns and other staffs

on duty.

• Checking mediallia

Make My Trip, Gurgaon, HR Feb 2005 – Aug 2007

Business Analyst

Make my trip is India’s Leading online travel company, a global leader in the marketing, travel,

and hospitality industries. The project was a web based travel services project, which offers

largest owned and controlled travel services to corporate clients in the travel industry. This project

involves enhancement & testing of the web based reservation system for various transportation

services like Air, Car, and Hotel & Rail as well as the Client Server side of the Application

developed on Java Software.

Responsibilities

•Solely responsible for handling complex Business Requirements and translate them into

functional requirements according to the good requirements standard that Web

Architecture team has embraced.

•Serve as a liaison to the business community. Participate in user and task analysis to

maintain the business community's perspective.

•Experience in understanding specific business needs and overall business strategy of the

business customer.

•Analyze the impacts of any new releases going into effect to minimize effects on

corresponding systems.

•Gather requirement and process the same in the systems by SharePoint.

Work with the Business/Functional Architect and other planners to assess current

capabilities and identify high-level requirements.

•Identified/documented data sources and transformation rules required populating and

maintaining data warehouse content.

•Worked with source systems to prepare Joint Interface Agreement (JIA) documents across

multiple applications.

•Worked with the Senior Business Analyst to develop test plan and test cases for (UAT)

Performed UAT and exposure to User Certification Testing (UCT) and Operational

Readiness Testing (ORT)

•Created/Reviewed data flow diagram to illustrate where data originates and how data flows

within the Enterprise Data warehouse (EDW).

•Created Use Case Models, Analysis Models, Design Models, Use Case Diagrams, Behavior

Diagrams and Class Diagrams based on UML methodology using MS Visio 2003.

•Participate in transitioning and to ensure a clear and complete understanding of requirements

to the development team.

•Assist in translating requirements and use cases into test conditions and expected results for

product, performance, and user acceptance testing.

•Work with the leadership, architects, and other team members to define metrics and

performance goals.

•Review project deliverables for completeness and quality and compliance with established

standards.

•Responsible for collaborating with Team Leads to coordinate project schedules, budgets,

request management, and work authorization.

Environment: PHP, MYSQL, XHTML, CSS, e2 Framework and CMS back end supporting

WYSIWYG editing of HTML content.

EDUCATION

MBA – Hospitality, Johnson & Wales University Providence – RI, USA

MBA - Finance, Symbiosis School of Business management – Pune - MH, India

Masters Diploma in Internet Architecture, SSI, Delhi, India

Bachelor of Commerce, Delhi University, Delhi, India

Diploma in Quality Management

Yes I can Certification

Carlson Brand Training on O PERA P roperty Management System

DH &R Host t raining on S MS Property Management system

Mar r iott FSPMS t raining on M ARSHA

REFERENCE

Available upon request

Contact this candidate