Dipanshu

Please contact Kishore for further details

973-446-2645/tkishore@rapidwebglobal.com
Email: dipanshu.ba@gmail.com

Professional Summary:
7+ years of extensive experience as Business Systems Analyst, having worked in projects
in as diverse sectors as Mortgage, Insurance, Credit card processing Call
Center/Telecommunication, and Retail. Possess extensive knowledge of system analysis
and business analysis techniques, along with excellent written and oral communication
skills, analytical and problem-solving skills, decision-making skills, proven ability to
manage small and large-scale projects, and to interface with stakeholders.
 Proficient in business scope definition, cost/benefit analysis, conceptual design
analysis.
 Excellent Business writing skills in writing Business Requirements Document (BRD),
Use Case Specifications, Functional Specifications Document (FSD), Systems Design
Specification (SDS) and Systems Requirements Specification (SRS). 
 Conducted data analysis to analyze and review current records for consistency and
communicated any inconsistencies to the stakeholders. 
 Conducted System Integration Testing and facilitated User Acceptance Testing
(UAT) to provide a smooth transition to the new system/application.
 Experience in extracting data from raw data files, Excel spreadsheets and external
RDBMS tables (databases like SQL and MS Access) 
 Creating functional and technical specifications, creating business and application
use case documentation, leading business and technical analysis sessions,
supporting development and testing teams throughout the Software Development
Life Cycle (SDLC), and building exceptionally well client relationships.
 Excellent exposure to the business workflows of the Mortgage, Call
Center/Telecommunication, Credit Card Processing, Insurance, and Retail
industries.
 Expert in Assessing current state trust business and operations.
 Strong presentation and documentation skills, proficient in PowerPoint, Visio,
Word and Excel
 Skilled resource utilization identifications, Skill gap analysis and close functional
gaps. 
 Expert in identifying upcoming challenges in functional areas and product
interfaces. Inclination to take initiative, set strategic priorities, take ownership in
identifying enhancements of existing functionality and new functionality for
existing systems; Initiative and independently drive for results. 
 Ability to work independently as well as in a team. Self-motivated and disciplined
professional.
Technical Skills:
Windows, Unix, DOS,SQL, RapidSQL, MS Access, HTML, DHTML, XML, XSLT,Visual Studio
UML, RUP, Rational Tools Suite, MS Visio, MS Project, CMM, ISO, IEEE.TCP/IP Suite, UDP,
Telnet, DNS, POP, SMTP, FTP, HTTP,MS Office, Microstrategy, Call Center Performance
Management, Forecasting.

Education:
Masters in Business Administration

PROFESSIONAL EXPERIENCE:

Deutsche Bank, NY Apr2010-Nov2010

Sr. Business Systems Analyst
Deutsche Bank is a leading global investment bank with a strong private clients franchise.
Its businesses are mutually reinforcing.. I worked towards developing and implementing a
Performance Measurement and Management System (PMMS) for the Call Center
Application.
Responsibilities
 Met with client groups to determine User Requirements and Goals, thus converting
User Requirements into Business Requirements and User and Functional Requirement
Specification.
 Prepared Logical Data Models that contained set of diagrams and supporting
documents containing the essential business elements, detailed definitions, and
descriptions of the relationships between the data elements to analyze and document
Business Data Requirements.
 Interviewed the customers and end-users in walkthroughs, and converted the user
requirements into functional and technical specifications.
 Used Rational Requisite Pro to create and manage requirements.
 Utilized RUP to configure and develop processes, standards, and procedures, to
provide technical leadership and expertise in reorganization of a complex End-to-End
Testing effort, and to perform System analysis and organizational review of existing
QA processes.
 Involved in development of Business and Technical Requirements in preparation of
System Architecture, Information Strategy, and Detailed Design documents for
Business Needs and Processes.
 Developed Data Flow, Work Flow, Process Flow, and Entity Relationship Diagrams in
Rational Rose / MS Visio, and analyzed them to create AS IS and TO BE scenarios.
 Involved in the Requirement Analysis and Strategy Design for implementing the
PMMS including designating criteria for statistical performance measures.
 Applied Six Sigma Approach to track and trace flaws in the existing system, used  the
Six Sigma DMAIC process (define, measure, analyze, improve, control) system for existing
process.
 Prepared Business Process Models that included all the business process flows, from
conceptual to procedural level.
 Conducted JAD sessions to allow different stakeholders to communicate their
perspectives with each other, resolve any issues and come to an agreement quickly.
 Followed the UML based methods using Rational Rose to create Use Case,
Activity/State Chart, Sequence, and Collaboration Diagrams.
 Involved in the GUI Design Sessions with end-users.
 Extensively wrote SQL Queries to test data between back-ends of various systems to
ensure integrity.
 Performed extensive testing of table mappings and stored procedures used to
populate and migrate data between different environments
 Wrote user defined reusable/parameterized functions using SQL.
 Performed data validation using SQL in SQL Sever Database by executing various
select, insert, update, order by, group by and various sub queries.
Environment:
SQL, Rational Tools Suite, Rational Requisite Pro, UML, RUP, Rational Rose, Unix,
Windows, HTML, MS Office, Tomcat, Apache, XML, DOM.

CNA INSURANCE, NJ Apr2009 – Mar2010

Sr. Business Analyst
The primary business focus of CNA is to provide commercial property and casualty
insurance to businesses and professionals. CNA markets its products and services
primarily through independent agents and brokers. The project involved integrating the
existing system with PeopleSoft Financial modules to meet the organizational
requirements and needs.
Responsibilities:
 Gathered and analyzed the Business and User Requirements from walkthroughs with
the users and stakeholders, converted User Requirements into Business Requirements
and User and Functional Requirement Specification, and hence used Rational
Requisite Pro to create the requirement analysis and specification documents.
 Developed prototype of new information processing application to meet current and
projected business needs.
 Utilized RUP to configure and develop processes, standards, and procedures, to
provide technical leadership and expertise in reorganization of a complex End-to-End
Testing effort, and to perform System analysis and organizational review of existing
QA processes.
 Involved in development of Business and Technical Requirements in preparation of
System Architecture, Information Strategy, and Detailed Design documents for
Business Needs and Processes.
 Prepared Logical Process and Data Models that contained set of diagrams and
supporting documents containing the essential business elements, detailed
definitions, and descriptions of the relationships between the data elements to
analyze and document Business Data Requirements.
 Prepared Business Process Models that included all the business process flows, from
conceptual to procedural level.
 Analyzed Business Requirements from Black Box Testing perspective, Business
Process, and System Architecture/Design.
 Was responsible for continuous process improvement and for identifying and
maintaining a clear and measurable Development Process that is deployable
throughout the enterprise.
 Conducted JAD sessions to allow different stakeholders to communicate their
perspectives with each other, resolve any issues and come to an agreement quickly.
 Created the unit, integration, functional, performance, and acceptance test plans,
scenarios, and procedures using Rational Test Manager, and made sure that the final
product could be traced back to requirements.
 Lead business and technical analysis sessions, and worked as an Interface between
the users and the different teams involved in the application development for the
better understanding of the business and IT processes, and thus converting business
needs into elegant, quality solutions.
 Followed a structured approach to organize requirements into logical groupings of
essential Business Processes, Business Rules, and Information Needs, thus ensuring
that Critical Requirements are not missed.
 Followed the UML based methods using Rational Rose to create Use Case,
Activity/State Chart, Sequence, and Collaboration Diagrams.
 Coordinated the Functional and Performance Testing of the PeopleSoft GL, AR, and
Billing Financial Modules with the QA team.
 Performed Defect Tracking and Change Control Procedures using Rational Clear
Quest, and Configuration Management and Version Control using Rational Clear Case.
Environment:
Rational Tools Suite, Rational Rose, Requisite Pro, UML, RUP, Clear Quest, Rational Clear
Case, Oracle, Windows, XML, SQL, PeopleSoft Financials, MS Office

Gander Mountain Inc., Minneapolis, MN Jan 2008 – Feb 2009

Sr. Business Systems Analyst
Gander Mountain Inc. is one of the leading retail stores in the state of Minnesota.
Worked on a project involving implementation of a retail business solution to provide
functionalities including Price Management, Promotion, Purchase Order, Inventory,
Shipping, and Receiving. In the process, developed and implemented a Performance
Management Platform for the retailers to streamline the Forecasting and Budgeting
process, thus reducing associated costs.
Responsibilities:
 Was responsible for defining the scope of the project, gathering Business
Requirements and documenting them textually or within models.
 Developed prototype of new information processing application. Met with client
groups to determine User Requirements and Goals, thus converting User
 Requirements into Business Requirements and User and Functional Requirement
Specification.
 Interviewed Business Area Experts, asking detailed questions and carefully recording
the requirements in a format that could be reviewed and understood by both
business people and technical people.
 Followed the RUP guidelines and thus created RUP artifacts and Documented the
requirements in Rational Requisite Pro.
 Analyzed business requirements and segregated them into high level and low level
Use Cases, activity diagrams / State Chart Diagrams and Robustness Diagrams using
Rational Rose according to UML methodology, thus defining the Data Process Models.
 Grouped the Use Cases and other diagrams into Sequence and Collaboration
Diagrams using Rational Rose based on UML methods, thereby defining the Business
Process Model.
 Prepared Business Process Flow models that covers. How business processes are
accomplished. Prepared Workflow diagrams to analyze AS IS and TO BE scenarios,
designed new process flows and documented the business process and various
business scenarios.
 Led technical and business sessions, and acted as a liaison between user and
stakeholders, converting business needs into software solutions of the highest quality.
 Documented Test Plans that contains test scripts, test cases, test data and expected
results for the Integration, Functional, Performance, and User Acceptance Testing,
using Rational Test Manager.
 Used Rational Clear Quest as the defect tracking tool, and Rational Clear Case for
Version and Configuration Management.
Environment:
Unix, SQL, , Windows, ASP, Rational Tools Suite, Rational Clear Quest, Rational Clear
Case, Rational Rose, Rational Requisite Pro, RUP, UML, MS Office, RETEK Merchandising
System.
Providian Financial Inc., San Francisco, CA Nov2006 – Dec2007
Business Systems Analyst
Providian Financials is one of the leading financial institutions of the nation, offering
broad range of financial services like lending, deposit and membership based products. It
offers online services such as 24-hour online account access to credit card accounts,
instant online account opening for deposit accounts, and instant decisions for credit
cards. The project involves implementing the 24-hour online access to credit cards, where
customers could login and view their account information, make online payments, change
their contact information, and contact customer service representatives for questions.
Responsibilities:
 Gathered Business Requirements, analyzed data/workflows, and defined the scope,
financial projections and Cost/Benefit analysis.
 Developed the business case for the proposed Performance Management Platform.
 Facilitated collection of Functional Requirements from system users, and prepared
Business Requirement documents using Rational Requisite Pro.
 Applied the RUP model throughout the entire development and testing process.
 Involved in development of Business and Technical Requirements in preparation of
Architecture, Strategy, and Design documents for Business Needs and Processes.
 Developed Data Flow Diagrams and Entity Relationship Diagrams.
 Followed the UML based methods using Rational Rose to create Use Case Diagrams,
Activity and State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
 Analyzed Business Requirements from Black Box Testing perspective, Business
Process, and System Architecture/Design.
 Supervised the Functional and Performance Testing of the PeopleSoft GL, AR, and
Billing modules along with the QA team.
 Used Rational Clear Quest for Defect Tracking and Change Management purposes and
Rational Clear Case for Version Control and Configuration Management.
 Interviewed Business Area Experts, asking detailed questions and carefully recording
the requirements in a format that could be reviewed and understood by both
business people and technical people.
 Led technical and business sessions, and acted as a liaison between user and
stakeholders, thus converting business needs into software solutions of the highest
quality.
 Documented Test Plans that contains test scripts, test cases, test data and expected
results for the Integration, Functional, Performance, and User Acceptance Testing,
using Rational Test Manager.
 Used Rational Clear Quest as the defect tracking tool, and Rational Clear Case for
Version and Configuration Management.
Environment:
SQL, Windows, RUP, UML, MS Office, Rational Tools Suite, Rational Clear Case, Rational
Requisite Pro, Rational Rose, Rational Clear Quest.

Unity Inc., Milpitas, CA Sep 2004- Nov 2006

Business Systems Analyst
IP Unity delivers carrier grade services platform for enhanced voice and telephony
applications over ATM, TDM and VoIP Networks. Worked on an Unified Messaging Suite
that offers standard voicemail features with a familiar interface, but lets subscribers
choose to integrate voicemail with email, receiving voice messages as WAV files in their
email inbox and accessing emails through a telephone using text-to-speech technology
Responsibilities:
 Understood problems pertaining to development of new information systems to meet
present and future business needs.
 Met with client groups to determine user requirements and goals. Utilized RUP to
configure and develop process, standards, and procedures.
 Analyzed business requirements and segregated them into high level and low level
Use Cases, activity diagrams / State Chart Diagrams and Robustness Diagram using
Rational Rose according to UML methodology, thus defining the Data Process Models.
Used Rational Requisite Pro to document the requirements.
 Created Use Cases, Collaboration, Object Sequence, Object Interaction and State
Diagrams for new features using Rational Rose.
 Understood and articulated business requirements from user interviews and then
converted requirements into solutions.
 Provided system analysis and support to the development team throughout the SDLC.
 Conducted Functional requirement specification and User requirement specification
reviews and walkthroughs with the designers, developers and stakeholders.
 Set up definitions and process for test phases including integration test, functional
test, performance test, and acceptance test using Rational Test Manager.
 Updated the requirement and defect status as per the current status of the testing
project using Rational Clear Quest.
Environment:
Windows, SQL, Java, JDBC, Rational Requisite Pro, Rational Tools Suite, JavaScript, Rational
Clear Quest, Rose, UML, RUP, MS Office, Struts, Ant, XML

TATA Capital Group May 2002-July 2004

Business Analyst
The TATA Capital Group is one of India s premier Investment Advisory and Financial Planning
companies. We are also SEBI-approved Category. We offer personalized Investment Advisory
and Financial Planning services to individual investors, corporate houses, institutional
investors, Non-Resident Indians (NRIs) and High Net worth Clients, among others.
Responsibilities:
 Prepared Summary Revenue MIS for Management Review on Daily Basis.
 Tracking of the Business Plan on Monthly Basis along with Variation from budget.
 Designed and Developed of Various Summary MIS on different parameter for
management review.
 Shared Profitability report with the Region, providing inputs & details to Regional
Heads.
 Helped different Channels & Units to prepare business plan as per management
instruction.
 Prepared Business Plan for Fund Raising in close co- ordination with the external
advisors.
 Developed Business Plan for Fund Raising & compiling various qualitative inputs to be
incorporated information memorandum in close co- ordination with management.
 Prepared of the Annual Budgets for the company & monitoring the actual
performance. Conducting Variance Analysis.
 Identified & monitored the different key parameters important for implementation of
the business plan & Budget.