SHAHIL SHARMA

Sr. Business Analyst

Email id: aca8um@r.postjobfree.com

Contact No:214-***-****

Summary:

. 7 Years experience in Business Analysis, Software Development and Project

Management

. Thorough understanding of SDLC and Rational Unified Process.

. Interacting with stakeholders, gathering business requirements from user

interviews and then converting requirements into technical

specifications.

. Extensive experience in gathering business requirements, business

processes, identifying risks, GAP analysis and UML modeling.

. Exposed to all phases of software development life cycle, including in-

depth knowledge of RUP and Six Sigma methodologies.

. Possess strong analytical, verbal, documentation and inter-personal

skills.

. Well-versed with MS Visio, MS Project, Rational and Mercury Interactive

tools.

. Elicitation techniques like interviewing, questionnaires, brainstorming,

focus groups, prototyping and facilitating JAD sessions.

. Dataflow analysis using use cases, data flow diagrams and activity

diagrams.

. Checking and Validating Requirements in conjunction with the

stakeholders. Tracing (using Traceability Matrix) and managing

requirements throughout the development process.

. Managing reporting, analysis and decision-making for a change request

using tools like ClearQuest and Excel.

. Used MS Project for project management and scheduling the deadlines of

the project.

. Experienced in UML modeling including Use Cases, Sequence, State,

Activity and ER Diagrams using tools such as Rational Rose and Microsoft

Visio.

. Highly motivated team player with excellent problem solving, team

building, judgment and decision making skills.

. Excellent communication, facilitation, mentoring and Technical writing

skills including drafting contracts, documentation and editing of user

manuals.

Technical Skills:

Modeling Tools Rational Rose, MS Visio, MS Project

Languages C, C++, Visual Basic, Java, PL/SQL, C#,

ASP.NET, MVC

Testing, Rational RequisitePro, ClearCase, ClearQuest,

Requirements/Defect Mercury Quality Center (TestDirector)

Tracking, Version Control

Tools

Web Technologies HTML, DHTML, ASP, XML

Methodology Rational Unified Process (RUP), Six Sigma,

Waterfall, RAD, Agile

RDBMS SQL Server, MS Access, Oracle

Operating Systems Windows 98/95/NT/2000/XP/Vista/Windows 7

Utilities MS Office, FrontPage

Professional Experience:

AXA Financial, New York, NY

Sep 2012 - Present Business System Analyst

Project Profile: AXA Financial employs Lincoln Underwriting System (LUS)

for their automated life insurance underwriting process. Automated

underwriting is becoming a key point of differentiation strategy and is

helping insurance companies to speed up life insurance underwriting while

also reducing issue / issuance cost. LUS was developed to automate and

integrate all the steps in the life underwriting process. There have been

several major releases of LUS software required to accommodate product

changes and user enhancements every year. For each release, the project

design was developed based upon exhaustive discussions with underwriters.

The application is being consistently enhanced to address and incorporate

changing underwriter needs. This changes result in creation of new

functionality, screens and reports on a periodic basis.

Responsibilities:

. Met with client groups to determine user requirements and goals. Acted as

a Technical Resource from a system requirement standpoint, to

both business users and the technical teams.

. Utilized Rational Unified Process (RUP) to configure and develop process,

standards and procedures

. Created Need Analysis Documents of the requirements gathered through

(Joint Application Development) JAD and individual elicitation sessions

using Rational Requisite Pro.

. Analyzed business requirements into high level and low level Use Cases,

Activity Diagrams / State chart Diagrams using Rational Rose following

UML methodology

. Involved in analyzing the key data for the data warehouse design as per

the information gathered from the SMEs to generate key reports. Re-

engineered the user interface of the application.

. Created Data structure and Data model diagrams associating myself with

Data Analyst using MS Visio.

. Created URS-User Requirement Specifications and FRS- Functional

Requirement Specifications documents

. Experience in conducting Conference Room Pilot (CRP) sessions, in order

to identify software gap workarounds, refine configuration of the

software as well as the organizational and policy requirements which need

to realize the vision of improved business processes.

. Provided management with the proof of concept, with a complete analysis

on key performance index metrics, reports and schedules as necessary and

participated in the design walkthroughs meeting using MS Project.

. Worked alongside with developers in tracking and resolving system defects

in Rational Clear Quest

. Conducted training sessions to familiarize users with system and obtained

deliverable sign-offs.

. Reviewed and incorporated enhancement to current functional testing

scripts.

. Designed and managed project plans and schedules. Managed resolution of

project issues and conflicts throughout the System Life Cycle.

. Attended meetings with management to discuss the status of project and

draft strategies for the near future.

Environment: Windows NT/XP/2000, VB, Oracle, PL/SQL, MS-Project, MS-Office

Suite, MS Visio, PVCS Tracker, Mercury Test Director

PNC Bank, Lakewood, CO Jun 2011

- Aug 2012

Business System Analyst

The PNC Financial Services Group is one of the nation's diversified

financial services organization providing retail and business banking;

residential & mortgage banking; specialized services for corporations and

government entities, including corporate banking, real estate finance and

asset-backed lending; wealth management; asset management and global fund

services

Responsibilities:

. Analyzed User Requirement Document, Business Requirement Document (BRD),

Technical Requirement Specification and Functional Requirement

Specification (FRS)

. Prepared and analyzed AS IS and TO BE in the existing architecture and

performed Gap Analysis.

. Developed requirement reports for day-to-day retail banking needs for

opening account, online banking

. Created workflow scenarios, designed new process flows and documented the

Business Process and various Business Scenarios and activities of the

Business from the conceptual to procedural level.

. Used the guidelines and artifacts of the Rational Unified Process (RUP)

to strategize the Implementation of RUP effort in different iterations

and phases of the Software Development Life Cycle.

. 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.

. Followed a structured approach to organize Requirements into logical

groupings of essential Business Processes, Business Rules, and

Information needs that insures any Critical Requirements are not missed

. Created UI specifications and Wireframes

. Managed and traced requirements using Rational requisite pro

. Followed the UML based methods using Microsoft Visio to create: Use Cases

Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and

Collaboration Diagrams.

. Prepared Logical Data Models that contains set of Entity Relationship

Diagrams and Data Flow Diagrams and supporting documents and descriptions

of the Relationships between the data elements to analyze and document

the Business Data Requirements.

. Worked extensively with the QA team for designing Test Plan and Test

Cases for the User Acceptance Testing.

. Responsible for providing analytical support in the Design, Development

and Implementation of Project.

. Verified the Business Scenarios on new builds to allow extended testing

by the QA team.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase,

ClearQuest), Visual Basic, SQL, SQL Server, Oracle, ASP.Net, WebLogic,

DOORS, HTML, Windows Forms, Web Forms, LoadRunner, WinRunner

Commerce Bank, Columbus, OH

May 2010 - May 2011

Business System Analyst

The project involved implementing a commercial online banking product that

offers an internet solution to cash management needs. Using this secure

online access accounts users can view up-to-date balances and transaction

detail, execute internal and cross-bank transfers, perform stop payments,

send domestic and international wire transfers, transmit and view Automated

Clearing House (ACH) batches, receive EDI notices, ACH returns, controlled

disbursement and BAI reporting

Responsibilities:

. Closely involved in defining project scope and identifying discrete

enhancement efforts as individual tasks or sub-projects and prioritizing

them.

. Responsible for analyzing and translating business requirements for the

development of business rules and system rules for Retail banking.

. Performed in-depth analysis and gathered business requirements for

National City website redesign project

. Documented existing business process using UML based activity diagrams.

. Authored various Use Cases and Activity diagrams, Sequence diagrams using

Rational Requisite Pro and used UML methodology to define the Data Flow

Diagrams (DFD)

. Analyzed web site usability using data gathered from the existing

website.

. Followed Iterative approach for the enhancement effort and divided the

requirements in two phases for phased development (as suggested in the

RUP)

. Created UI specifications and Storyboards

. Acted as a liaison between stakeholders: National City user Experience

Developers, Business Users and managers, from business side, and software

development team to gather requirements.

. Developed Prototypes and conducted requirement walkthroughs with

technical team to communicate requirements to them.

. Co-ordinated usability workgroups for the re-designed site prototypes,

conducted feasibility study and performed impact analysis for proposed

enhancements.

. Documented Requirement Traceability Matrix in Excel sheet for

traceability of requirements through test cases.

. Very closely involved in all phases of SDLC from gathering requirements

to testing.

. Created User Acceptance Test Plan and coordinated UAT for the site

redesign project

. Used Cognos BI for operational reporting.

. Worked closely with developers for analysis of the application.

Environment: Load Runner, Windows NT /2000, SQL, MS Word, MS Excel, Ms-

Visio, Cognos BI, MS Project, PHP, Clear-Quest, Rational Test Manager,

Lotus Notes R6 client, Notes SAS.

MIDFIRST BANK, Oklahoma City, OK May 2009-Apr

2010

Business System Analyst

MIDFIRST is a financial service company offering a variety of banking

products and financial solutions like personal banking, small business,

retail banking, home financing and equity loans, asset management, wealth

management, corporate and investment banking and credit card services to

its customers. Personal Banking involves opening and maintenance of

checking, savings, recurring deposit accounts and personal loans. The web-

banking project was developed in .NET environment. It is an online banking

application that enables customers to access their checking and savings

accounts, and credit card account using the Internet.

Responsibilities:

. Conducted one to one interviews with Portfolio Manager to gather Business

Requirements and was involved in the documentation of Business

Requirement Documents.

. Assisted the Project Manager in setting realistic Project expectations

and in evaluating the impact of changes on the organization and plans

accordingly and conducted Project related presentations.

. Identified internal and external system Requirements, design and

configuration set-up.

. Developed strategic partnerships with the Business units to develop a

solid knowledge base of the Business line, including the Business Plan,

Products, and Process.

. Constructed and maintained UML models using Visio and created use case

diagrams, class diagrams and sequence diagrams for all the use cases

. Translated the Business needs into system Requirements, communicating

with the Business on a broader scale and with an in-depth view.

. Designed and developed Project document templates based on AGILE

methodology.

. Developed Business Requirement Document as well as High-Level Project

Plan.

. Functioned as the primary liaison between the Business line, operations,

and the technical areas throughout the Project Cycle.

. Developed Functional Specification Document and Supplementary

Specification (non-functional) Document.

. Participated in the Logical and Physical Design sessions and developed

Design Documents.

. Worked with developers to make sure that they understood the Use Cases.

. Designed and implemented basic SQL queries for QA Testing and Report /

Data Validation.

. Partnered with the Technical Areas in the research and resolution of

System and User Acceptance Testing.

. Worked with Quality Control Teams to develop Test Plan and Test Cases.

. Develop User Manuals, and Training Manuals as per Project Specifications

and timelines.

Environment: Microsoft Office Suite, MS Visio, Windows XP, SQL, PLSQL, XML,

VB, ASP, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner,

LoadRunner

GMAC Mortgage Corporation, Plymouth, MI Sept 2007-

Apr 2009

Business System Analyst

Project Scope: GMAC Mortgage Group is a part of GMAC Financial Services.

The project aimed at creating a web-based application to enhance the

automated Mortgage loan origination process beginning from

origination/opening a mortgage application through funding/closing. The

system performs all the Business functions of the loan process such as set-

up Account information, New Loan set-up, Escrow Analysis, the Appraisal,

credit, and income.

Responsibilities:

. Facilitated Joint Requirement Planning (JRP) sessions with SME's in

understanding the Requirements pertaining to Loan Origination to Loan

Processing.

. Worked with AGILE methodology

. Extracted the Business Requirements from the end users keeping in mind

their need for the application and prepared Business Requirement

Documents (BRD) using Rational RequisitePro.

. Reviewed Design Documents, Requirements Analysis Specifications with

Project Lead, Business Owners and the Technical Lead

. Modelled the As Is and To Be business models using Casewise Modeller

. Created and managed Project Templates, Use Case Project Templates,

Requirement Types and Traceability Relationships in RequisitePro.

. Involved in creating automated Test Scripts representing various

Transactions, Documenting the Load Testing Process and Methodology.

Created meaningful reports for analysis and integrated the Performance

Testing in the SDLC.

. Developed and managed Project Plans and Schedules. Managed resolution of

Project issues and conflicts.

. Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and

supervised the development of User Manuals for customers.

. Worked as a User/Customer advocate and negotiated with user as well as

with developers and management staff to resolve any requirement conflict

to bridge the Gaps between IT and Business.

. Various versions of the documents generated during the project were

maintained and managed using Rational ClearCase and performed defect

tracking using Rational ClearQuest.

. Tested the final application for Usability testing to verify whether all

the User Requirements were catered to by the application.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase,

ClearQuest), Casewise modeller, IBM WebSphere, XML, Java, Unix, C++, J2EE,

JSP, Oracle, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick

TestPro

ICICI Bank, India

Sept 2006 -Jul 2007

Business Analyst

The bank provides services for both individuals and corporate entities. The

services provided include Mortgage, portfolio management, financial

consulting, securities accounting, bond and equity trading, derivatives

trading etc.

Responsibilities

. Conducted highly interactive JAD sessions with project stakeholders,

subject matter experts (SME's), users, QA analysts and project management

team for requirement gathering, and identifying and resolving issues.

. Implemented data access, storage and validation routines on the database

server using Procedural Language/Structured Query Language (PL/SQL).

. Analyzed business needs, created and developed new centralized back

office system for specific area including mortgage and lending.

. Gathered technical requirements, and compiled them to help the design the

system.

. Formulated logical statements of business requirements research and

evaluated alternative solutions to recommend the most efficient and cost

effective solution for system design.

. Established a business analysis methodology around the RUP (Rational

Unified Process).

. Analyzed existing system logic difficulties and revised them as they

needed.

. Assisted in building a business analysis process model using Rational

Rose and Visio.

. Designed and developed use cases, activity diagrams, and sequence

diagrams.

. Performed SWOT analysis to evaluate internal and external environment of

the bank

. Involved in developing test strategy and test plans to ensure that test

cases reflect user needs for the functional, user interface, performance,

usability and security requirements.

. Prepared and presented weekly and monthly business operations review to

the senior leadership team.

Environment: UML, RUP, JAD, Requisite Pro, Microsoft Suite (Access, Excel,

Word, PowerPoint, MS Project) Windows NT, MS SQL Server, Visual Basic.

Education & Certification:

. Master's of Business Administration in Management/Finance

Contact this candidate