SUMMARY

• 9 years 7 months of extensive experience in as a Business System Analyst with expertise in Finance, Treasury and life Insurance.
• Hands on experience in analyzing Business Requirement, Functional Requirement, Design specification documents and developing Test plan and Test scenarios
• Proficient in gathering requirements and developing Business and Functional Requirement Documents (BRD and FRD).
• Extensive experience in analyzing Business Requirement Documents (BRD) by gathering Business Requirements and Expectations from Subject Matter Experts (SME) and defining business processes, identifying risks, Feasibility Analysis and Impact analysis.
• Experienced in facilitating Joint and Rapid Application Development (JAD and RAD) Sessions, workshops and requirement elicitation sessions. Organizing project meetings, reviews, walkthroughs, and customer interviews.
• Experienced with all the phases of SDLC throughout the project life cycle in Rational Unified Process (RUP) environment and the creation of artifacts and management of various roles.
• Experience with Waterfall & Agile methodologies, Responsive Web Design, Change Management, Web Content Management, Release Management
• Experienced in development and design of reports and dashboards for supporting the business analysis in a corporate wide reporting using Quality Center
• Good experience in documenting existing process, analyzing business requirements, working with requirements traceability matrix and re - engineering business processes.
• Have the knowledge on Bar code technologies
• Proficient in creating Use Case diagrams, Class diagrams, State Transition Diagrams and Activity Diagrams using UML methodology in MS Visio.
• Knowledge of Project management skills such as time estimation, task identification, risk analysis and scope management and resource management.
• Outstanding communication skills and the ability to work effectively with technical teammates in order to translate business requirements into an effective technical solution and serve as an effective communication channels between the key IT and business contacts.
• Involved in maintaining Traceability Matrix and performing GAP analysis
• Experience in performing end-to-end User Acceptance Testing (UAT).
• Extensive experience on MS Office, Visio & Quality Center.
• Experience in developing Requirements Traceability Matrix to map requirements to test cases to achieve requirement coverage and change management
• Expertise in writing simple and complex SQL queries using TOAD, SQL Navigator
• Experience in testing/validating the Source, Stage and Target (End-to-End) data systems
• Expertise in Defect Tracking, Defect management and Bug Reporting using tools like Clear Quest, Test Director, Quality Center
• Experience in testing/validation of Actuate reports, Business standard and ad hoc reports
• Highly motivated team player with excellent analytical, problem solving, interpersonal and communication skills
• Having the working experience on Version Controllers VSS, CVS and Orbi-Valut.A

TECHNICAL SKILLS

Databases: Oracle7/8i/9i/10g/11g, DB2, SQL Server 2005/2008

Operating System: Windows

Scripting: VB Scripting

Database Tools: TOAD 7.6/8/9.5/9.7, SQL Developer

Office Applications: WinSCP, Putty, MS Office Suites including Excel, Word, Access, Outlook, Visio

Test Management: Test Director, Quality Center, VersionOne, HP ALM

Testing Tools: Quick Test Professional (QTP) 10.0, HP ALM 11.5, TFS, Quality Center 10.0, Microsoft Project

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Business Analyst

Responsibilities:

• Expanding Self Service (SS) options for the following treasury products via online channels: ACH, ARP, Image Services, Wire, Lockbox, EDI, RDS, TradePro
• Enable Straight Through Processing (STP) capabilities for ACH, ARP, Image Services, Wire, EDI
• Creating client self-service option to update Authorized Client Contact List (ACCL)
• Creating a self service File Validator tool so clients can self test input file formats
• Enable the Associate experience through accessibility of the Self Service Portal
• Enables the user to evaluate life insurance decisions by evaluating whether the Liquidity risk adjusted return on investment (RAROC) yields its anticipated Shareholder Value Added (SVA) with Regulatory Capital reporting capabilities. Maintains the asset categories based level categorization across the LOBs. Enables the user to generate the below reports:
• Credit Facility Details Report: to view all field inputs for the selected transactions and the calculated values
• Define and generate the Basel III Advanced/ Basel III Standardized metrics
• Generate the Basel III report on Time frame basis form Year 1 to Year 5.relevant docs.
• It stores treasury related images/user owned docs and security submission of
• Generate the Product wise treasury components which included Risk calculation and expenses which excludes the fess and additional cost of derivatives.
• Credit Facility Summary Report: displays scenarios side by side and with the Summarized Information of transaction details of clients.
• Relationship summary Report: display output views of the data for relationships
• Year by Year Report: allows the user to import 12 months data
• Comparative Pricing Report: multi-field search screen which can be used to narrow down to particular transactions
• Gather requirements by conducting meetings and brainstorming sessions with senior management of the Research Group and SMEs and document them.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Working with clients to better understand their needs and present solutions
• Developed the Project Scope and Vision document in assistance with the Project Manager.
• Lead Business Intelligence reports development efforts by working closely with Micro strategy, Teradata, and ETL teams
• Extensively used MS Visio to develop the solution concept, business timeline and wireframes.
• Design, development, implementation and roll-out of Micro strategy Business Intelligence applications
• Performed User Acceptance Testing (UAT) for various web based and database related applications.
• Developed prototype, prepared the test data and checked for the feasibility of the system.
• Interacting with the development and testing teams to improve overall quality of the software.
• Extensively use Microsoft Project or similar tools such as Open Workbench to document project plans.
• Created UI specifications Used IRISE Studio 5.3 for designing and simulation of web applications
• Created screen-mockups and provide feedback on the screen design. Also, used Microsoft Paint to create ad-hoc screen mock-up to review with the users.
• Designed the UI of the application, prototyping and wire framing in MS Visio for better illustration of the application.
• Performed extensive requirement analysis including Data analysis and Gap analysis.
• Defined Functional Test Cases, documented, Executed test script in Facets system.
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, Metadata, Data Profiling.
• Have been working on exploring different software systems and databases in order to design a possible solution and identifying vital data points/elements.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Developed small applications with Teradata at the backend.
• Responsible for managing the migration of the department's website using Web Builder and ensuring that there are no broken links on the intranet.

Environment: HP ALM 11.5, Java, HTML, Windows7, ORACLE,XML,SQL,Java script,HTML

Confidential, TN

BA Lead

Responsibilities:

• Participated in the research and development of business opportunities and ideas within the scope of the project.
• Conducted interviews with key business users to collect requirements and business process information.
• Performed extensive requirement analysis including data analysis and GAP analysis.
• Developed business requirement specification documents as well as high level project plan.
• Designed and developed project document templates based on Agile methodology.
• Created Use case Models using Rational Rose to indicate Actors and Use cases in various Business Processes.
• Gain the Treasury factors for each product of lines of business to evaluate the product capital details.
• Set up definitions and process for test phases including product test, integration test, system test and User Acceptance Test (UAT).
• Worked on the impact of changing requirements on the mainframe application during change management procedure.
• Analyzed operational procedures and methods to recommend changes for improvement, with an emphasis on automation and efficiency.
• Prepared project reports for management, assisted project managers in the development of weekly and monthly status reports, documented process flows, policies and procedures.
• Created Traceability Matrix to reflect how the Business Requirements, at a high level, will be satisfied throughout the lifecycles (Requirements, Design, Build and Testing) of the project.
• Understood core processes of the department to provide input on reverse-engineering and to develop new blueprints for the process flow
• Closely worked with development team to make sure whether the software application fits within the architecture and has the required behavior
• Overseen change control to ensure that all system revisions, upgrades, and enhancements are thoroughly tested and documented to ensure business as usual.
• Translated insurance analysts and surveyors requirements into functional specifications for the development of insurance online system & managed changes to those specifications.

Environment: Quality Center 10.0,, SQL Server, PL/SQL, Toad, MS Access,, Bugzilla, Windows 7/2000/NT/XP, UNIX., ASP.Net

Confidential

Business Analyst

Responsibilities:

• Performed extensive requirement analysis on life insurance products including data analysis and GAP analysis.
• Developed business requirement specification documents as well as high level project plan.
• Designed and developed project document templates based on Agile methodology.
• Created Use case Models using Rational Rose to indicate Actors and Use cases in various Business Processes.
• Gain the Treasury factors for each product of lines of business to evaluate the product capital details.
• Set up definitions and process for test phases including product test, integration test, system test and User Acceptance Test (UAT).
• Worked on the impact of life insurance changing requirements on the mainframe application during change management procedure.
• Analyzed operational procedures and methods to recommend changes for improvement, with an emphasis on automation and efficiency.
• Prepared project reports for management, assisted project managers in the development of weekly and monthly status reports, documented process flows, policies and procedures.
• Created Traceability Matrix to reflect how the Business Requirements, at a high level, will be satisfied throughout the lifecycles (Requirements, Design, Build and Testing) of the project.
• Understood core processes of the department to provide input on reverse-engineering and to develop new blueprints for the process flow

Environment:, Visual Basic, JavaScript, Websphere, C++, Oracle, Quality Center, Flat Files, MS Excel, PL/SQL, Toad, Clear Quest, Windows, UNIX,C#