PROFESSIONAL SUMMARY:

• Over 7 years of extensive experience in requirements gathering, analysis, planning and communication.
• Solid understanding of different business management strategies in Business Processes such as Business Process Automation, Business Process Improvement and Business Process Re - engineering.
• Excellent documentation of Business Requirements gathered using Interviews, Brainstorming Sessions, Surveys and Questionnaires; Evaluating Data Sources, Translating Requirements into Specifications and Application Design.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services
• Design, documentation and review of business documents like Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specifications (SRS).
• Experience in conducting Gap Analysis, in depth knowledge of the AS-IS and TO-BE business processes.
• Assisted QA team in generating Test Plans, Test Scenarios, Test Cases, and managed complete defect tracking life cycle using various defect tracking tools.
• Performed User Acceptance Testing (UAT) to guarantee all the business requirements have been fulfilled by the application.
• Experience in facilitating SCRUMS, Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups, SMEs and other project stakeholders.
• Excellent working knowledge of SAS analytics tools and Microsoft Office tools.
• Good foundation in conducting business analysis, market trend analysis and financial market analysis.
• In depth understanding of credit risk, market risk and calculation of value at risk.
• Good knowledge of competitive analysis in the insurance domain.
• Extensive experience in writing Business and Functional require documentation using Rational DOORS and JIRA.
• Worked extensively on methodologies such as Agile, Waterfall and EDM.
• Proficient in use case development and UML modeling using modeling tools such as Rational Rose and MS Visio to prepare use case diagrams, activity diagrams, sequence diagrams and Organizational Process Maps.
• Extensive knowledge of the System Development Life Cycle (SDLC) including execution and management of requirements gathering, business process design, development, QA testing and training of software applications.
• Excellent organizational and time management skills.
• Participated in Post-Production Validation (PPV) and worked with the Production support team for issues reported by the user group in the production environment
• Experienced in working as a team leader demonstrating the ability to multi task and manage effectively and efficiently in a diverse team environment

SKILLS/TOOLS:

Requirement Management Tools: Rational DOORS, Rational Clear Case, Requisite Pro

Project Management Tools: MS Project (Gantt Charts, RACI, WBS), Crystal Ball, FMEA

Analytical Tools: JMP, Node XL, SAS Enterprise Miner, R

Methodologies: Waterfall, Agile, RUP, EDM

Testing Tools: HP ALM, Jira

Database: Oracle 9i, 10g, MS Access, MySql, DB2

Programming Languages: Java 5/1.4.2, J2EE, JDBC, Adobe Flex, PHP, PL/SQL

Web/Application server: Web logic 10

Operating Systems: MS Windows XP/NT/2000/Vista

Database: MS SQL, MS Access, Oracle

Utility: MSOffice Suite Word, Excel, Visio, PowerPoint, Adobe Acrobat Suite

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Responsible for working with business SME’s and identified project stakeholders to develop detailed requirements (functional/non-functional/operational/data quality).
• Conduct requirements walkthroughs with project team and project stakeholders and documented all requirements into IBM Rational DOORS.
• Supported project management tasks defined by the Project Manager, which included preparing project charter and scheduling using MS Project.
• Conducted JRP sessions with SME and manager to understand business processes, functionality detail.
• Developed business process models in both Agile & Waterfall environment.
• Worked on Requirements Traceability Matrix (RTM), Architecture assessment document and collaborated with development team to create detailed design document.
• Developed business rules spreadsheets (BRSs) to define and document data movement/data transformation rules, define the source to target data mappings, business rules and data definitions.
• Queried the DB2 database using SQL through Rapid SQL 8.1.1 for DDL validation, data analysis, data retention, setting up proactive checks and data validation and Worked with developers, data modelers, testers and business area SME’s to support development, system testing and User Acceptance Test.
• Translated data models in business requirements with information like entities, attributes, definitions and transformation rules.
• Assisted the scrum master to conduct daily/weekly scrum to summarize what has been done, plan what needs to be done, and recognize impediments.
• Helped to create burn down charts to show remaining work in the sprint backlog.
• Identified “As is” process and “To be” process as parts of gap analysis for new functionality requirements, as well as prioritizing them based on actual business needs so as to align them with the project roadmap.
• Created Unified Modeling Language (UML) diagrams for Business Process Modeling like Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, and Flow Charts.
• Performed Unit testing, and document test results by validating the test data in DB2 tables on Mainframes and performed Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data
• Drove the effort of retirement of tables and performed intense analysis to identify the data load, usage, upstream/downstream dependencies, and criticality of the tables to be retired.
• Supported System Testing, End-to-End testing, and UAT
• Used the Remedy and ITSM ticketing system to provide reliable, and prompt support and follow-up.

Confidential

Business Analyst

Responsibilities:

• Responsible to work with business units/project stakeholders to develop detailed functional requirements
• Responsible for understanding business requirements and develop business processes using Tele logic DOORS.
• Analyzing existing system, identifying and defining project requirements, preparation of impact analysis document, provide input to technical design.
• Analyze the various processes and document the logic involved using requirements traceability matrix.
• Worked on test cases for regression testing, UAT and End-to-End Testing.
• Worked closely with developers and business product managers to build source to target mapping documents
• Performed risk analysis and developed risk mitigation plan for maintenance of the payroll system.
• Assist Business unit with problem analysis and resolution.
• Estimate and schedule projects, allocate and monitor resources.
• Analyzed existing reports and collected detailed requirements for the new reporting need.
• Involved in developing database schema and was involved in developing database to the payroll system using MS-Access.
• Involved in Data analysis, Web page design and Report generation using PHP and created code repository using GIT, a distributed version control system.
• Developed solid knowledge base of the business line which includes business plan, products and processes.

Confidential

Business Analyst

Responsibilities:

• Responsible for understanding business requirements and actively participating in design discussions and preparation of design document, UML diagrams, Use Cases using Enterprise Architect.
• Involved in creating process flow diagrams and process maps using MS Visio.
• Driving discussions with cross functional teams/ stakeholders to capture and translate data and requirements
• Identifying options for potential solutions and assessing them for both technical and business suitability
• Produce detailed and comprehensive software documentation, such as requirements specifications, design documents, and change logs.
• Involved in Estimate and schedule projects, allocate and monitor resources
• Conducted multiple walkthrough of the requirements and got approval from all stakeholders.
• Gathered requirements and designed the modules using Enterprise Architect design tool.
• Review of Integration Test Plan, UAT Plan, defects, testing guidelines, checklists and entry & exit criteria for different phases of the project during the project
• Responsible for reporting the Testing status (Weekly Status reports) of the project to the senior management
• Define Test Strategy, establish Test Plan, Requirements Traceability Matrix & provide inputs and guidance to testing teams and defect tracking
• Involved in development of web modules using Java 1.5,Adobe Flex 3,MS Access
• Actively involved in designing database structure. Developed procedures, Indexes and triggers to make the data retrieval and data access efficient.
• Lead complex initiatives and coordinated tasks with multiple team members.
• Played a key role in development of core service layer and DAO layer methods and implementations using Java API, EJB.
• Developed key modules like document upload to the server, Project task creation and handling.
• Developed interface to prepare working calendar for around 140 TCS work locations by imported existing data from excel sheets into Access Databases.
• Used SQL language and wrote procedures, created triggers and indexes to create relationships in database tables to establish data integrity.
• Provided 24/7 on-call supports through telephone and Ticket solution systems.
• Automated the manual reporting processes for the customer and contractor tracking reporting databases integrated MS Excel files that included complex formulas, Vlookup’s and other functions and MS Access databases.