SUMMARY

• Over 7+ years of extensive experience in requirement 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.
• Expertise in SOX IT General Controls compliance in the areas of Change management, User access management and technology operations
• Excellent documentation of Business Requirements gatheird using Interviews, Brainstorming Sessions, Surveys and Questionnaires; Evaluating Data Sources, Translating Requirements into Specifications and Application Design.
• Strong expertise in Business Data Analysis, Data Profile, Data Mapping, Data Integration and Meta data 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 wif Business User Groups, conducting Joint Application Development (JAD) sessions wif 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.
• Extensive experience in writing Business and Functional require documentation using Rational DOORS, HP ALM, JIRA.
• Worked extensively on methodologies such as Agile, Waterfall and EDM.
• Competent in creating Unified Modeling Language (UML) diagrams for Business Process Modeling like Use Case Diagrams (UCD), Activity Diagrams (AD), Sequence Diagrams (SD), Data Flow Diagrams (DFD) and Wireframe Prototypes
• 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 knowledge of creating knowledge articles and standard operation procedures.
• Excellent organizational and time management skills.
• Participated in Post-Production Validation and worked wif 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 TEMPeffectively and efficiently in a diverse team environment.
• Excellent knowledge of change management and tracking defects using BMC Remedy 8.1

TECHNICAL SKILLS

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

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, SharePoint 2010-2013

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Responsible for working wif business SME’s and identified project stakeholders to develop detailed requirements related to Data warehouse and Unix utility/Scheduling (functional/non-functional/operational/data quality).
• Conduct requirements walkthroughs wif project team and project stakeholders and documented all requirements and User stories.
• Supported project management tasks defined by the Project Manager, which included preparing project charter and project schedule using MS Project.
• Developed scope statement including business case and stakeholder analysis, communication plan (RACI matrix), risk management plan/matrix, change management plan.
• Developed business process models in both Agile & Waterfall environment.
• Worked on Requirements Traceability Matrix (RTM) by integrating business requirement to test cases in Rational Doors and HP QC systems and collaborated wif development team to create detailed design document and operational readiness documents.
• 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 and Oracle database using complex SQL through Rapid SQL 8.1.1 for DDL validation, data analysis, data retention, setting up proactive checks and data validation and Worked wif developers, data modelers, testers and business area SME’s to support development, system testing and User Acceptance Test.
• Translated data models in business requirements wif information like entities, attributes, definitions and transformation rules.
• Assisted the scrum master to prepare weekly schedule report and conduct daily/weekly scrum meetings to summarize wat has been done, plan wat needs to be done, and recognize impediments.
• Performed Root cause analysis to remediate P1,P2 issues in the existing system and documented the impacts caused by the operational issues.
• 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 wif the project roadmap.
• Created Unified Modeling Language (UML) diagrams for Business Process Modeling like Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, and Flow Charts.
• Worked wif project team to define product and sprint backlog.
• Facilitated project planning sessions wif users and project team to capture user stories, size user stories (effort estimation) and prioritize user stories.
• Worked wif users to define acceptance criteria for each story.
• Created explanatory prototypes, UML Use cases and scenarios to elicit required functional requirements and to support application development.
• Performed Unit testing, system integration testing and document test results by validating the test data in DB2 tables on Mainframes
• Performed Data mapping, logical data model generation, created class diagrams and ER diagrams and used SQL queries to filter data
• Maintained and stored all the project related artifacts on SharePoint 2013 wif proper version history.
• Tracked all the changes and bugs requested/ reported by users by created tickets on BMC Remedy (Change Management)
• Received multiple appreciation on completing tasks and Projects on time and wifin the budget.

Confidential

Business Analyst

Responsibilities:

• Responsible to work wif 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 wif 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 wif 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.
• Tracked all the changes and bugs requested/ reported by users by created tickets on BMC Remedy (Change Management)

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 wif 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.
• Gatheird 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 wif 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.