Summary:

• Sr. Business Analyst with 6 years of experience in business process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language UML using Rational Rose MS Visio.
• Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process RUP methodology in all areas of the software development life cycle SDLC
• Extensive experience in Risk Management and VB, VBA Macros, Software Quality Standards, Quality Metrics and Financial Services
• Expertise in using Microsoft Visual Studio Team System for requirement management and work item tracking.
• Experienced in conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models.
• Experience with designing and verifying databases on Oracle and SQL Server RDBMS using Entity-Relationship Diagrams ERD .
• Good experience of working with the QA methodologies and processes.
• Proficient in developing and executing Test Procedures, Test plans, Test scripts, test result validation, performing functional, usability, stress testing and ensuring that the software meets the system requirements.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Ability to gather business and Technical Requirements from both formal and informal sessions utilizing a variety of software methodologies including, Use Cases and the Rational Unified Process.
• Experience working as Joint Application Development JAD facilitator and meetings coordinator with excellent interpersonal skills.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Expertise and complete understanding of QA Life Cycle, which includes Designing, Developing, Execution and Documentation of the Test Cases, Automated Test Scripts and Test Plans.
• Expertise in data driven testing and setting parameters with the Performance Session Scripts.
• Expertise in Database Administration of Test Environment Databases, Data Pools and identifying the performance issues due to inefficient Database Administration.
• Strong Communication and Presentation Skills substantiated in past assignments with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.
• Creative and Enthusiastic Self-Starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILLS:

Professional Experience:

Confidential

Sr. Business Analyst

Responsibilities:

• Prepared Business Requirements Document BRD by gathering requirements from all the stakeholders translated BRD to Functional Specifications Document FSD and created prototypes.
• Developed Use Cases as well as flow charts based on the proposed enhancement for the system
• Developed training content related to LMS integrations.
• Developed Stored Procedures and views to generate various Drill-through reports, parameterized reports using SSRS.
• Experience working on windows 7 migration.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio
• Executing and deploying oracle database and queries for the output test of the cases.
• Developed training Modules for professional associations such as hospitals, Insurance agents
• Converted technical white papers and other raw materials into rich multimedia eLearning content
• Wrote and integrated online Help content
• Collaborated in writing a Reference Guide Technical Specification for the CICS enhanced software.
• Verified and validated data model with changes to business information and rules
• Extensively interacted with both user group and development team in coming up with structured charts, class and sequence diagrams
• Took on responsibility for executing Volume Testing, Compliance Testing, Data Quality Testin

Environment: Windows, MS Office MS Word, MS Excel, MS PowerPoint, MS Visio , windows 7, MS Access, MS Project, Rational Rose, MySQL, Oracle database Clear Case, RequisitePro.

Confidential

Business Analyst

Responsibilities:

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Performed Cost benefit, ROI and ROM studies
• Conducted user interviews and documented business and functional requirements.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Defined, developed specs for federal reporting specific to Medicare Advantage
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Upgraded HMO Medicare EDI and reporting.
• Completed the documentation of Claims Scenario's for the source system
• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Prepared for GAP Analysis identified and documented improving areas to meet capital requirement regulations.
• Documented Medicare claims processing.
• Designed High level design, for New process, integrating with legacy and Facets
• Involved in creating business processes and modeling diagrams using Rational Unified Process RUP .
• Organizing JAD sessions, personal interviews and surveys in the process of collecting requirements including that of G.M.'s and other higher management
• Exposed to Agile methodology.
• Involved in Service Oriented Architecture SOA of the claims processing system
• Created use case scenarios and documented work flow and business process using Rational Rose
• Involved in project management using MS Project
• Collaborated with External Auditors and documented SOX compliance requirements
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Wrote test cases and test scripts for the User Acceptance Testing
• Incorporated Rational Unified Process RUP to create Requirement Document Specifications using Visible Analyst.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Maintained benchmark controls to policies, company standards and contracts, performed vendor sourcing, pricing and contract negotiation, performed procurement, ensured compliance with service/joint interest contracts.
• Used Rational Clear case for version control
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Involved with all the phases of Software Development Life Cycle SDLC methodologies throughout the project life cycle.
• Served as conduit for managing system requirements between the business and the software development team.
• Queried database using SQL for backend testing
• Used Rational clear quest for defect management

Environment: XML, XSL, Rational Clear Quest, Rational Clear Case, Rational Requisite Pro, Rational Rose, UML,RUP, Microsoft Excel, Microsoft Word, Microsoft Power Point, Visio.

Confidential

Business Analyst

The Loan Origination System allowed users to complete their loan applications, which in turn would be gathered and verified by the system to allow the application to undergo the loan application, processing, underwriting and closing processes. This system allowed the company to collect and consolidate user data for verification and remediate failed applications, thus streamlining and increasing the efficiency of the company in dispersing loans to various clients.

Responsibilities:

• Conducted user interviews, gathered requirements, analysed the requirements using AGILE methodology and documented the requirements using DOORS.
• Worked with the SME's Financial Analysts, Risk Managers, and Project Managers to define business critical needs and analyse the possible technical solutions.
• Created Business Requirement Document BRD , Functional Requirement Specification FRS document, User Requirement Specification URS and Change Request CR document for system application development.
• Conducted joint requirements planning JRP sessions as a facilitator to gather requirements from the business area and to discuss different critical success factors of the project like Operational Feasibility Analysis, Technical Feasibility Analysis, Cost Benefit Analysis etc.
• Developed budget planning report timelines of the project by conducting walk-through sessions and meetings involving various leads from Development, QA and Technical Support teams.
• Assisted the PM in performing Risk Assessment, Management and Mitigation.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams DFD .
• Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.
• Developed and managed project plans, schedules, issues log created and business-technical conflicts.
• Coordinated various kinds of User Acceptance Testing UAT including regression testing, system testing, integration testing, functional testing, alpha beta testing.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Used Test Director which is a Mercury tool to help manage defects and issues log during the testing phase..
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
• Participated in Bug-Review meetings with software developers, QA engineers, managers, and suggested enhancements and solution to the existing application problem from business perspectives.
• Worked as a User/Customer advocate and negotiated with user as well as the technical team and management staff to resolve any outstanding requirement conflict during the whole SDLC process.

Environment: DOORS, Windows XP/2000, PL/SQL, XML, HTTP, MS-Project, MS-Office Suite, DB2, Documentum, MS Visio, Unix, Win Runner, Load Runner, Test Director Mercury Interactive , Java, Oracle, PL SQL

Confidential

Business Analyst.

Worked in the Multifamily Family Amortization Decentralized Accounting Unit of the Finance and Corporate BIS division in Freddie Mac. Project involved the design, development and implementation of system changes to Corporate Amortization Engine, a complex application used for amortization of fees related to single family and used for Tax, GAAP, and Management Information Needs. The main difference between the current system and existing process is that the AM project is not a redesign it entails the automation of processes, which are currently manual. The new AM accounting engine will provide the corporation's system of record for Prepayment/Bond/FIN45/FAS149/FAS91 journal entries.

Responsibilities

• Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Conducted user interviews and documented business and functional requirements.
• Performed Requirement Analysis and developed UML Use Cases, Activity Diagrams using Rational Rose to understand the requirements.
• Created use case scenarios and documented work flow and business process.
• Documented requirements, associated change requests with requirements and connected requirements with Use cases.
• Incorporated Rational Unified Process RUP to create Requirement Document Specifications using Visible Analyst.
• Involved with all the phases of Software Development Life Cycle SDLC methodologies throughout the project life cycle.
• Served as conduit for managing system requirements between the business and the software development team.
• Worked directly with users of the Multi-Channel Desktop to gather and document their business requirements. Followed up with the users to test the implementation, achieved sign-off and continued to move the system toward go-live.

Environment: MS Access, MS Excel, RUP, UML, Rational Rose, Requisite Pro, Clear Case, Rational Clear Quest, MS Office suite

Confidential

Role: Jr. Business Analyst

Responsibilities:

• Involved in requirements gathering with multiple project managers, in an effort to better customize, and utilize the full functionality of the Salesforce.com CRM solution.
• Worked on Business processes streamlining and processes re-engineering.
• Developed Test Plans, Test Cases, and Expected Results, and coordinated the tests with the QA team to verify implementation of new features and enhancements
• Provided the migration strategy from SAP CRM to Salesforce Cloud CRM platform in phase wise model.
• Created user Roles and Profiles, security controls and shared settings.
• Implemented mobile administration, field level security, profiles and audit trail setup.
• Created the Dashboard with key client data so that advisors could easily access it.
• Generated reports like standard, summary and matrix for quarterly and half yearly sales.
• Involved in preparation of the Training Manual for the releases.
• Used the sandbox for testing and migrated the code to the deployment instance after testing.
• Participated in the training sessions provided by the Salesforce team.

Environment: Java, APEX, Web services, SOSL, SOQL, Force.com IDE, Import Wizard, XML, Visualforce Pages, Workflows.

Confidential

Role: Jr. Business Analyst

Responsibilities:

• Worked side by side with Senior Solution Development Specialists to write, edit, revise and review documentation for user requirements, business process diagrams, training and handover documentation.
• Involved in interviewing, product and personnel screening and preparation of the user requirements documentation.
• Involved in describing current and future states of business processes, design and document workflows and made recommendations that impacted operational effectiveness.
• Involved in preparation of the Training Manual for the releases.
• Involved in Client calls for analyzing issues and problem solving approaches.

Environment: MS Analysis Services 2000, MS Access 2000 Windows 2000 platform, Reporting Services, DTS