SUMMARY

• Over 8+ years of experience as a Business Analyst with successful delivery of multiple projects.
• Have a detailed and thorough understanding of various domains including Financial and Insurance sectors.
• Proficient in gathering and defining the Business Requirements (BRD); translating them into technical specifications and functional requirements (FRS).
• Extensive experience in Software Development Life Cycle (SDLC) and process methodologies like RUP, UML, Agile, SCRUM, feasibility analysis, gap analysis, scope and impact analysis of the software systems throughout the different phases of SDLC.
• Experience in developing detailed functional specs through JAD sessions, interviews, on site meetings with business users & development team.
• Developed Use Case Diagrams, Class Diagrams, Sequence Diagrams, Collaboration Diagrams, State Diagrams and Activity diagrams using UML to make users and developers understand the system.
• Knowledge of Financial products and services such as Fixed Income Instruments, Equities, Derivatives, and Hedge Funds.
• Efficient in writing requirements at different levels like use case, high level and low level implementation and analyzing the requirements.
• Thorough Understanding and ability to apply Rational Unified process (RUP) to software enterprise initiatives.
• Knowledge of RDBMS concepts and exposure to various databases systems like Oracle and MS SQL Server
• Gathered User and Business level Requirements from SMEs from various departments like accounting, Finance and Information Systems and designed the business requirement collection approach based on the project scope using RUP.
• Expertise in project management tools like MS - Project for status reporting and planning.
• Involved in revising existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, scheduling, multitasking of functions, tasks input/output requirements and storage.
• Expertise in Analyzing Business specifications, designing and developing strategic Test plans, Test Cases, Test Scenarios, Test Reports for both manual and automated tests

TECHNICAL SKILLS

Business Analysis Tools: RUP, Rational Requisite Pro, MS Visio

Testing Tools: Rational Clear Quest, Test Director, Quality Center.

Databases: Oracle, MS Access, MS SQL Server

Methodologies: SDLC, RUP, AGILE, Water Fall

Office Tools: Microsoft Office (MS Excel, MS Word, MS Power Point, MS Project, MS Outlook), MS SharePoint

Languages: HTML, SQL

Operating Systems: Windows XP/NT/2000/98/95,Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential, MN

Sr. Business Analyst

Responsibilities:

• Involved in gathering and analyzing business requirements from existing and proposed models.
• Conducted user interviews, gathered requirements, and analyzed the requirements using Requisite Pro.
• Met with client groups to determine user requirements and goals.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document.
• Worked closely with business partners to realize the full capabilities of Salesforce.com CRM.
• Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization
• Worked with various Salesforce.com objects like Accounts, Contacts, Leads, Campaigns, Reports, and Opportunities
• Created various Reports (summary reports, matrix reports, pie charts, dashboards and graphics) and Report Folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the organization’s need.
• Worked extensively on Relational database and wrote SQL Queries.
• Coordinated work plans between project manager and client using MS Project.
• Interacted with the different SMEs deciding about the design and format of the reports.
• Gathered User and Business level Requirements from SMEs from various departments like accounting, Finance and Information Systems and designed the business requirement collection approach based on the project scope using RUP.
• Prepared BRD and FRD for the gathered requirements.
• Conducted JAD sessions to allow different stockholders to communicate their perspective, resolve any issues and come to an agreement quickly.
• Developed use cases, workflow and screen mock-ups.
• Provided thorough documentation of all Business Intelligence applications and processes to be used in the event of equipment or system failure.
• Created and executed Complex SQL Queries to generate Expected Results for UAT per the data requirements
• Modeling the Central Data Warehouse tables and documenting the table requirements on the Project.
• Did Test coverage by adding new test actions from iteration to iteration according to the test strategy.
• Worked on Execution Tracker, Test Design Tracker & Defect Metrics.
• Involved Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Independently designed and developed project document templates based on SDLC methodology
• Written Test Cases for ETL to compare Source and Target database and Tested records with logical delete using flags
• Tested multi-dimensional cubes using models and implemented incremental updates for power cubes
• Created Test input requirements and prepared the test data for Data Driven testing.
• Written several complex SQL queries for data verification and data quality checks.

Environment: Rational Requisite Pro, RUP, UML, SQL, PL/SQL, MS Office Suite, Windows, Crystal Reports.

Confidential, Philadelphia, PA

Business Analyst

Responsibilities:

• Responsible for Business Analysis and requirement understanding, development and data modeling.
• Gathered requirements, defined specifications by interviewing the business user group. Agile software methodology was implemented on this assignment.
• Translated business requirements into functional specifications for communication to technology team.
• Responsible for creating UML modeling plans, Use cases, process flows, and business requirements documentation using Visio.
• Involved in creating Class and Sequence Diagrams from Business Requirements.
• Performed gap analysis and created Gap analysis document.
• Managing sessions with the stake holders for requirements analysis and timely status reporting on the project.
• Performed data analysis on the data extracted with the help of SQL queries data in the claims databases
• Evaluated the financial market outlook and financial status of the company
• Conducted Data analysis, Trend analysis, Impact analysis and Gap analysis of business processes and requirements and identified technology enabled improvements.
• Facilitated User Acceptance Testing (UAT) and test strategies with developers and testers.
• Testing and Reporting the Bugs in product releases and performed the Root Cause Analysis for the Defects raised.
• Extensively used Rational Clear Quest to track defects and managed them.
• Performed negative and positive testing using SQL Queries
• Involved also in Configuration Management of the Projects in Test Director
• Manually executed test cases for the functionality testing and security testing using Test Director.
• Documented the modification requests and defects using Test Director.
• Maintained the bug reports for internal evaluation of the product using Test Director

Environment: Windows, UML,, Use Case Analysis, SWIFT messaging,MS Office - MS Word, MS Excel, MS Power Point, MS Visio, Rational Rose, Business Objects, Rational Clear Quest,SQL, UAT.

Confidential, Westchester, IL

Business Analyst

Responsibilities:

• Involved in requirement gathering, analyzing the information, documenting the functional and non-functional requirements.
• Worked with the Project Manager on various Project Management activities like keeping track of Project Status, Deadlines, JIRA and Compliance Issues.
• Coordinated team in bringing about Business Requirements, Architectural Specifications, Corporate Priorities and Functional Specifications.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Developed Use Case diagrams, business flow diagrams, Activity State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Used MS Project and assisted project manager in making Project Plan with necessary modifications.
• Worked extensively through Agile development methodology by dividing the application into iterations and working on each iteration through full SDLC.
• Interacted closely with End users from Underwriting & Claims teams and SMEs to understand and gather the business needs and requirements.
• Made Screen Mockups Definitions and Dependencies using Excel.
• Defined testing objectives and verify requirements are testable.
• Designed and implemented basic SQL queries for QA testing and Report Data Validation
• Participated in User Acceptance Testing on the Business-to-Business Transaction testing.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Worked directly with business users to gather, document and implement requirements to improve Marketing campaign delivery •
• Worked with the testing team to analyze the test results of the application.
• Participated in user acceptance testing and worked on data analysis and database management.
• Worked independently with minimum supervision as part of a dynamic IT team.
• Provided regular verbal and written status reports to IT management and business community; published meeting minutes and maintained project plans.

Environment: JAD, MS-Visio, RUP, Scrum, Agile development, JIRA, UML, Use Cases, MS-Office-Excel, Word, PowerPoint, Quality center, MS Visio, Requisite Pro, ETL, Oracle, Java, PL/SQL.

Confidential, Port Washington, NY

Business Analyst

Responsibilities:

• Gathered requirements and Developed Use Cases for the application as per the business requirements and technical specifications.
• Participated in feasibility study and requirement analysis session and prepared the software requirements specification document for the responsible areas of the application.
• Involved in creating Test Plan and Test Cases to test the application
• Worked on Automating the builds and deployments for the Applications Using Microsoft Visual Studio Team Foundation Server.
• Interacted with various users during the testing phase and analysis.

Environment: Eclipse IDE, Oracle database, Team Foundation Server 2012, Windows Power Shell IDE.

Confidential

Business Analyst

Responsibilities:

• Analyzing various failures and Processes (Paid & Unpaid) the Warranty Claims of Confidential product & part make on Highway Truck Engines.
• Reviewing of Warranty claim information, which substantiates the failure & the repair completed by the dealer submitting the claim.
• The review involves technical expertise in understanding of diesel engine & Earth moving Equipment’s operation, failure models and the proper means of repair as per Confidential warranty.
• Evaluating claims submitted, involves analysis of the associated parts, labor and miscellaneous items that were used in completing the repair by accessing various Confidential websites like-:
• SMCS (service management control system) - In SMCS we are using codes of the failed component, types of the job required,
• SIS (service information system) - In SIS we are identifying the failed part location, verifying correct part number as per complete schematic engine specifications, etc.
• TRG (time requirement guide) - we are using TRG for managing the time for the enhancement as per the failure frequency and same will be submitted to the Clint.
• Maintaining productivity and quality through daily interaction with Onsite Co-coordinator and Clients & maintaining Quality Documents, Six Sigma Reports etc.
• Implementing systems, processes and procedures to facilitate smooth functioning of overall resource and service & warranty operations and enhance operational efficiency.
• Auditing the processed claim for every engineer (team member) to improve the team quality & based on this quality, rendering the performance rating to the each & every engineer.