Project Manager Customer Service

Rohan Sharma

*****.*****@*****.*** (***) *** - **91

Summary

Business Analyst with 7 years experience in Banking, Insurance and Marketing industries.

Gather requirements, lead discussions and interviews between cross -functional groups of

stakeholders to resolve complex business problems.

Experience in Risk identification, risk assessment and risk mitigation planning.

Experience in transforming business requirements to Functional Specs and User Stories

for Web pages, Reports, Dashboards and Web Analytics.

Efficiently conduct impact analysis and manage chang e requests.

Experience with various methodologies such as Agile/Scrum, Rational Unified Process

(RUP), Test Driven Development (TDD) and Waterfall. Conversant with other SDLC

methodologies like Rapid Application Development ( RAD), Spiral, CMMI, etc.

Author User Stories and maintain Product Backlog, Sprint Backlog, Burn-down chart

and velocity chart.

Experience with Fixed Income instruments, Bonds, Derivatives and Commodities.

Conversant with the front, middle and back office of the trade order management systems

(TOMS) including the interfaces and message systems like SWIFT and FIX protocol.

Extensively work with database marketing engagements including loyalty marketing

programs, customer relationship management ( CRM) and marketing campaigns.

Effectively create, maintain and update the Requirement Traceability Matrix (RTM).

Facilitate Joint Application Development (JAD) sessions, reviews, and walk-through.

Strong knowledge of RDBMS Concepts and Data Warehouse Techniques – ETL process,

data modeling, performance tuning – and Business Intelligence (BI) Concepts.

Experience with Web Content Management Systems. Conversant with web services and

Service Oriented Architecture (SOA) and client server architecture.

PROFESSIONAL SKILLS

Create detailed Business Requirements Document (BRD), Functional Requirements Specs

(FRS), and Systems Design Specs (SDS). Maintain and update Product Backlog, Sprint

Backlog and Release Backlogs.

Develop several High-Level Design (HLD), Use Case Diagrams, Use Cases and User Stories.

Actively participate in sprint planning and sprint retrospect meetings.

Use Visio to develop site maps, Business Process Management (BPM) and work-flows.

Prepare Training manuals and Knowledge Transfer manuals.

Create wire-frames, prototypes, mock-ups to better comprehend functional requirements.

Assist the Quality Assurance (QA) team to develop and review test plans and test cases.

Effectively conduct User Acceptance Testing (UAT), acceptance metrics and resolve issues.

Write SQL queries for data analysis and testing bottlenecks.

Make use of MS Office Suite, MS Project and MS Visio extensively.

Conversant with Oracle 9i, 10g, Access, Teradata and SQL Server 2000/2005.

Experience with XML, widgets, Mercury Test Director, Quality Center ( QC), Hyperion, SAS,

Informatica, JIRA, Omniture and Google analytics.

Page 1

Rohan Sharma

*****.*****@*****.*** (516) 547 - 4591

PROFESSIONAL EXPERIENCE

Consumer Reports, Yonkers, NY Apr 2008 – Apr 2009

Sr. Consultant / Business Analyst

Work on multiple projects for – Online (CRO, Autos and Health), Ecommerce, Web Cont ent

Management and Back-end data projects. Actively contributed towards editorial, marketing, SEO

and database related web projects and enhancements.

Conduct requirement gathering and create user stories with Agile methodology

Analyze high-level business requirements. Prioritize and update the product backlog.

Create test cases for use in Test Driven Development (TDD).

Redesign the website and product landing pages from an editorial and SEO perspective.

Work with the Ecommerce team to establish new paymen t accounts and payment

procedures (Credit Card). Write several user stories for order-processing requirements.

Define page layouts, reports templates and dashboard layouts

Create wire-frames and work with prototypes to better understand the GUI’s for users.

Prepare Reports mock ups with interactive reporting tools (layout, definition of

dimensions, measures, drill down and roll up requirements) and review with stakeholders.

Work with offshore stakeholders and development teams.

Participate in design creation; Provide inputs and feedback to the SME and the Design team.

Gather specs for Hospital Database project. Analyze source feeds, validate transformation

and target mapping rules. Identify the variances and bad-match in quality issues using SQL

and MS Excel while performing the data integration from multiple sources.

Work on marketing projects for online promotions, surveys, email campaigns, campaign

analysis, loyalty marketing, sales and customer service.

Assist marketing team with web analytic functions and customer traffic reports.

Conduct impact analysis and manage change requests successfully during the project.

Closely work with QA testers to develop and review test plans and test cases which cover

functional testing, integration testing and data validation.

Play a key role in planning User Acceptance Testing (UAT) and implement system

enhancements and conversions.

Deutsche Bank, NY City, NY Mar 2007 – Feb 2008

Business Analyst (Consultant)

Deutsche Bank Index Quant (DBIQ) is Deutsche Bank’s site to publishing index data. It is used by

traders and users to make investment decisions in Euro and USD Fixed Income markets. The site is

data intensive, feature rich and has extensive graphing and reporting mechanism.

Define project scope and project plans. Prioritize and maintain the product backlog with

the stakeholders and communicate the same to project and technical team members.

Coordinate project activities to work in an Agile environment.

Page 2

Rohan Sharma

*****.*****@*****.*** (516) 547 - 4591

Populate DOORS with system and test requirements, create links, views, develop reports,

Requirement Traceability Matrix (RTM) and perform backups. Import requirements from

MS Word, Excel, or plain text file and share requirements data between tools.

Assist the project manager and PMO for updates and maintenan ce of project plans/charters

and project progress reports.

Participate in sprint planning meetings to commit requirements for the sprint backlog.

Evaluate internal procedures and participate in the sprint retrospect meetings. Identify

potential items which can be added to the product and sprint backlogs.

Define templates for product pages, custom reports using Hyperion Business Intelligence

(BI) Interactive Reporting Tools and define dashboards for performance tracking,

comparison, relative analysis of various financial instruments.

Assist the Project Manager to create and d esign velocity charts, burn-down

charts/graphs and quality metrics.

Profile data and conduct ‘Source System’ analysis. Extensively use SQL and MS excel

functions for data retrieval, data comparisons and data validations. Develop ETL Business

Rules.

Assist to implement the logic to calculate Yield, Duration, Volatility, Spread, Sharpe ratio,

Sortino ratio, etc for the Fixed Income products.

Facilitate requirement gathering by conducting user interviews with traders to understand

Trade Order Management Systems (TOMS) used for Fixed Income trading.

Use the marketing database to promote new products, improve customer loyalty and

increase subscriptions for the new products.

Successfully manage multiple key web initiatives, from requirements -gathering phase

through implementation.

Write SQL queries to retrieve data to perform Back End Testing and use excel formulas for

data testing and validations

Parallel testing and final user acceptance for go live decisions.

Adelphi University, Garden City, NY Aug 2005 – Dec 2006

Research Assistant

Assist professors in research and analysis of financial data.

Use MS Excel and SPSS functions to analyze data.

Derive various statistical ratios, percentages and identify variances & trends.

Assist professors in class and teaching

Tutor and counsel students

ICICI Bank Ltd, Mumbai, India Jul 2004 – May 2005

Business Analyst

The project was to offer rich content on mutual funds, bonds, stocks, etc as well as convenience of

banking to the customers of ICICI Direct and ICICI Bank. The customers can access their account

information, take advantage of the banking features and make stronger market decisions on their

investments, all through the same portal.

Page 3

Rohan Sharma

*****.*****@*****.*** (516) 547 - 4591

Assist the PM to set project expectations and evaluate the impact of changes on the

organization and plans accordingly.

Design and develop use cases using UML modeling techniques such as use case diagrams,

activity diagrams and sequence diagrams.

Collaborate with the development architects and the business to create high -level and

detailed application architecture to meet the business needs.

Translate the business needs into functional and system requirements.

Participate in sessions to identify, comprehend and document system requirements to

support new applications.

Prepare custom reports and performed SQL query, data analysis, data modeling and

verification.

Act as a liaison between business and the development team. Assist the business on

technological challenges and walk-through.

Assist the quality team to develop test plan and test cases and provide any support needed.

Trace and test if all requirements have been met.

Co-ordinate user acceptance testing (UAT). Log and resolve bugs found duri ng UAT.

E-FUNDS International, Mumbai, India Jan 2003 – Jul 2004

Jr. Business Analyst

Work on multiple financial application and pricing projects as a junior analyst. Assist to develop

business requirement, functional specification and data models for the project.

Gather and analyze business requirements from the users.

Draft workflow diagrams and processes.

Derive Functional Requirement from high-level business requirements.

Assist to maintain the Requirements Traceability Matrix document.

Design and implement basic SQL queries for QA testing and report/ data validation.

Work closely with the QA Team to convert Use Cases to Test Cases.

Develop and review test cases based on business requirements for the Acceptance testing.

Om Constructions Pvt. Ltd, Mumbai, India Sep 2001 – Nov 2002

Accounts & Marketing Analyst

Analyze quantitative and qualitative consumer research studies.

Assist seniors in field surveys.

Handle daily accounting and banking transactions.

Bank reconciliation.

EDUCATION

Masters of Business Administration (M.B.A.) in Finance, Adelphi University, NY, May 2007

Master of Commerce (M. Com) in Banking and Finance, Mumbai University, India, Nov 2003

Bachelor of Commerce (B. Com) in Accounts, Mumbai University, India, Apr 2001

Page 4

Contact this candidate