PREETI BHATKHANDE

SUMMARY:

. Project Manager and Business Analyst with total 12 years of IT

experience.

. Result oriented and delivering cost effective performance solutions to

meet challenging business demands.

. Extensive hands-on experience to lead multiple projects including some

in the hybrid

(onsite-offshore) model.

. Core expertise includes Business Analysis, Technical documentation,

Client User Coordination, analyzing functional gaps in the system,

data audits and validation, defect management and product demos to

business users.

. Excellent Communicator: Leverage Technical, business and financial

details to communicate effectively within different team members.

CAREER HIGHLIGHTS:

. Currently working as Project Manager from Dec 2007 till date for

Development Project which involves .NET and Crystal Reports for

Reporting module.

. Current Technical Roles and Responsibilities are: Business Analysis,

Requirement gathering, Impact analysis, effort estimation,

coordination with diverse teams, testing and Implementation process.

. Successfully led multiple complex projects. Involved in mentoring and

training a team of 15 members. Well versed with working in the hybrid

model.

. Project management responsibilities work for Resource planning and

forecasting process and project estimation and scope analysis and

project schedule maintaining and tracking. Effective Onsite Offshore

Team coordination.

. Efficiently co-coordinated with various team members and stakeholders

(e.g. Project manager, business users, development team, other test

leads, database administrators) in order to drive successful results.

. Expert in Client Management and Team Management Skills.

. Exposure to basics of VB.NET, Crystal Reports, database concepts and

QA strategies.

. Exposure to IBM DB2, SQL and performance tuning using EXPLAIN utility.

. Experience in understanding and translating the business requirements

into technical specifications.

. Experience in drafting system specification design document, technical

specification design document, and test cases for projects.

. Excellent Analytical skills.

. Experience of using various Tools like JIRA to maintain issues.

. Experience in manual testing and good exposure to Test Director for

test case management and defect tracking.

TECHNICAL SKILLS:

Project Management : SDLC concepts, Estimation, Project Plan and

tracking, Execution and Control

Operating Systems : Windows 2000 Professional, Windows NT,Windows

XP,OS/400

Languages : Basics of .NET 1.1, 3.5,PL/SQL,CLLE,

RPGLE

RDBMS : IBM DB2, Oracle 8i/ 9i, DB2/400

Tools and Utilities : Crystal Reports, SQL/400, MS Project,

ACMS

EDUCATION:

Bachelor's Degree in Engineering (BE), Industrial Electronics, Pune

University, INDIA - 2000

ACCOMPLISHMENTS:

Received Excellent Performance Award for 2009 (Above and Beyond

Performance), across 10000+ employees of Cognizant Technology Solutions.

Received Excellent Performance Award for 2006 (Above and Beyond

Performance), across 10000+ employees of Cognizant Technology Solutions.

Received many Client Appreciation emails for Best Performance

Worked in different roles as :

System Analyst: - Requirements gathering, analysis and functional

specifications creation.

Designer: - Design Document creation based on Functional Specification.

Developer: - Initial 6 years of AS400, RPG400 Development, Unit Testing.

Project Lead: - Project kickoff meeting, Creating Design Document, Creating

Project Plans, Schedules, Coordination with Testing Team for System Test

Plan. Defect Management.

PROFESSIONAL EXPERIENCE:

Project Manager / Business Analyst December 2007

- Present

Very large Global Bank (Bank of New York Mellon), NY

Department: Trade Banking Services

Project Name: Global Trade Banking System

This is the principal system in the Trade Applications. It is a client

server based system for entry and verification of import and export letters

of credit. GTS also provides for processing of acceptances and

for doc examination and payment processing.

Gather Business Requirement for Reporting Project

Gather requirements for Reporting enhancements or new Advices creation for

Global Trade System under Trade Finance and Banking Division. Main Role is

to discuss report/advice requirements with Subject Matter Experts in New

York, Product Management team at New York and Business User team located at

New York as well as Utica. All these reports are installed on INFORM

platform and using Trade Internet Query Tool. Technology used is .NET

Crystal Reports.

Responsibilities:

. Migration of Documentary Credit System (old legacy system) operational

reports to new Inform Platform.

. Development of Accounting and General Posting Reconciliation Reports

for Daily and Monthly Batch System in the Windows based system.

. Development of various Payment, System notification Advices during LC

Issuance and Payment process.

. Development of Collection processing related reporting tool which

gives Collection Volume, Transaction Detail, Revenue Information.

. Development of Referral Fee Processing Reports which provides Monthly

Referral adjustment handling across NY and Asia region.

. Development of Monthly Revenue and Volume information of Trade Banking

Products for Relationship Managers and Product Management Team.

. Development of Profitability Reports which includes Revenue and Cost

Information posted to Bank's centralized database system.

. Development of new Advices for Tokyo region to replace existing Access

DB system.

. Development of Customer Specific requirements related reports for

CIBC, Swedbank clients of BNYM.

. Migration of Export Collection system reports to new Inform platform

Onsite Coordinator for Client side Development Project:

. Focused teams on business objectives and tracked progress to ensure

project milestones were completed on time and with desired results.

. Tracked weekly and monthly status dashboard with required details with

client and offshore teams.

. Mitigated risk factors by analyzing the statistical data.

. Anticipated and managed changes effectively in rapidly evolving global

business environments.

. Participated in different test inspection cycles and tracked test

score records.

Project Administration and Management:

. Cognizant representative at Global Trade group of BNYM Client.

. Weekly and Monthly Client meetings to discuss Project Status and risks

if any.

. Responsible for Resource Management of Cognizant team and rotations

within different locations.

. Maintaining Monthly Billing Plan and Invoice checking.

. Managing Client side Yearly Resource Forecasting Plan and maintaining

it Monthly with

Actual efforts data. This Resource Plan helps Client Department

manager for future resource reallocations to various projects.

. Managing Weekly Project Status Dashboard and Consolidated Project List

for Client.

. This is excel based project database which includes various milestones

for regular, mandatory and custom level projects and task. Weekly

report provides real time project health check for

all the PMs.

. Communication of Monthly Project Status and Project Cost reports with

Stakeholders.

Environment: Front end:.NET3.5, Backend = AS400

Team Lead / Onsite coordinator July 2004 -

November 2007

J. P. Morgan Chase-Bank of New York Mellon

Department: Treasury Services

Project Name : Enhancement and Support of Advanced Billing System

Responsibilities:

. Worked as an Onsite coordinator to facilitate the clients requirements to

offshore. Also responsible for deliveries.

. Worked as a Team Lead and he was responsible for the requirement study by

interacting with the client (Business Users) for various change requests.

. Involved in requirement gathering, design & analysis phase.

. Also involved in testing, quality control process.

. Responsible for the quality related aspects of the project confirming to

the quality guidelines of the organization.

. Involved in complete Offshore Support for this Application.

. Estimation.

. Impact analysis.

. Preparation of Technical Specification document and Test Cases.

. Development and customization of different components.

. Testing and debugging.

. Defect Prevention activities.

. Timely Delivery of the Work products.

. Post Implementation support.

. Preparation of documents required for the Project Management.

Currently this system is going through Advantage Conversion and my role is

1. Involve in basic data mapping process.

2. Design and Development of Conversion Programs

3. Functional Testing

4. Provide various data reports to User using queries.

Environment : AS/400

Team Member July 2003 - July 2004

HSBC, INDIA

Responsibilities:

This is mainly Enhancement project under Credit Card Services group.

Credit Card automated system enhancements are applied to HKG and SNG branch

and tested out fully for their performance and efficiency.

As a Team member:

. Analysis

. Design

. Peer Review

. Testing

Banking Software: HUB internal Tool of HSBC.

Environment : IBM AS/400, RPG/400, CL/400, DB2/400,ILERPG, ILECL.

Team Member February 2003 - July

2003

Secom Pvt Ltd, INDIA

Responsibilities:

This is mainly maintenance and development project.

2.Software Solutions and Consultancy company:

This project is to modify existing programs on ASM and PKTS software

products

3. Knowledge Bank: Creation of Knowledge Bank for Internal use.

As a Team member:

. Analysis

. Design

. Peer Review

. Testing

Banking Software: Using ACMS and ICBS tools

Environment : IBM AS/400, RPG/400, CL/400, DB2/400,ILERPG, ILECL.

Team Member January 2001 - Jan 2003

Yukti Softech Pune, INDIA\

Responsibilities:

Module 1:

This project is useful to determine the forecast based upon the history

information. This forecast information is useful for manufacturing

department, to order the items and for stocking the items in Warehouses.

Our role is to test the related programs, find out the bug and report it to

the client.

Module 2:

The idea behind this project is to Upload the file from PC to AS/400, parse

the data, audit the data and then post is to appropriate files.

Module 3:

This project is used for transfer of data between two heterogeneous

platforms via MQ series. MCII wants to out source thier one warehouse to

third party called CAT and they have their own SAP interface on UNIX.In

this project I learned new concepts like MQ Series, conversion of

interactive program to batch, RPGLE and Utility DBU.

Email Id : abpq70@r.postjobfree.com

Phone : 201 - 220 - 8735

Phone : 848-***-****

Phone Number: 862 - 668 - 3529

Contact this candidate