PROFESSIONAL SUMMARY:

• Focused, proactive and result oriented Sr. Business Systems Analyst with 9+ years of experience in business Requirements Gathering and analysis, Object - Oriented Design (OOD), Change management, application development, maintenance and IT service management.
• Experience working on all the phases of Software Development Life Cycle (SDLC) methodologies and techniques with expertise in Requirements Gathering, Analysis, Development, Release management and change management of various applications. Good experience in software methodologies like Agile/Scrum and Waterfall and RUP
• Business writing skills in creating Business requirements document ( Confidential ), Use-Case Specifications, Systems Requirements Specification (SRS), High level and Low level documents (HLD/LLD) using UML
• Domain experience: Banking & Finance and Manufacturing/automobile.
• Well versed with facilitating Joint Application Development (JAD), brainstorming and conducting interviews for in-depth requirement elicitation sessions with stakeholders.
• Expertise in tracing requirements throughout the development process and verifying adherence to Requirement Traceability Matrix (RTM).
• Excellent communication and interpersonal skills, capable of communicating with highly technical engineering teams.
• Comprehensive understanding of the Organizational Framework that help to map the Confidential and Confidential model using the GAP Analysis and plan and monitor effective approach to build/buy solutions to the business problems/needs/opportunities.
• Used SQL queries to extract, transform and load data in data warehousing.
• Experience in assisting with development and testing teams during construction phase and creating test cases, test plans and performing User acceptance testing (UAT), Regression testing.
• Experience in coordinating and handling onsite-offshore teams including during off-shore work hours.

SKILL SET:

Tools: Visio, Rational Rose, Requisite Pro, ClearCase, ClearQuest, Test Director, Primavera, MS Project

Operating Systems: Windows XP / / 95, Linux

Office Tools: MS Office (MS Access, MS PowerPoint, MS Excel, MS Word)

PROFESSIONAL EXPERIENCE:

Confidential

Lead business analyst

Responsibilities:

• Interacted with the Client for requirements gathering and analysis
• Performed JAD sessions with the concerned stake holders of servitrax interface project
• Analyzed Functional requirements by interacting with users and created business requirement documents
• Confidential and made lucid Confidential using UML methodologies
• Developed project plan and i nvolved in the complete life cycle of Oracle interface with third party software named servitrax
• Lead and mentored the team of technical developers
• Prepared technical design and documentation for software development
• Developed packages with multiple stored procedures that validates the data and imports data to the base tables
• Designed and developed custom packages, triggers and procedures using PL/SQL.
• Worked closely with the DBA to improve the performance of the system by tuning and optimizing the conversions routines by studying the explain plan, and restructuring PL/SQL program units for optimum performance.
• Created the database schema objects like tables, views, synonyms, indexes
• Involved in code review, Code walk through, Unit testing, Integration Testing etc.

Environment: Oracle E-Business Suite R12 (AP, AR, GL, OM, INV, WIP, WSH), TOAD, SQL Developer, SQL, PL/SQL, Reports11g, Workflow Builder, XML Publisher

Confidential, Columbus, OH

Sr. Business Systems Analyst

Responsibilities:

• Led facilitation process to drive out requirements from all levels of business and technical clients using group and collaborative methods-Used RUP Modeling methodology.
• Analyzed Business Requirements, reviewed Test Strategy, Traceability Matrices and Test Plans to ensure that test cases reflect user needs for the functional, performance, usability and security requirements.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram in Rational Rose.
• Was responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans.
• Worked with the data entry requirements of the users forms and screens
• Conducted JAD sessions to get SME’s input and the sales team on how to implement the application for core credit card production and billing.
• Used SQL, Toad, Data Warehousing and Data Cleansing for the arrangement of customer data
• Created Test Plans, Test Cases, Test Scenarios and Test Strategies to ensure Quality Assurance and to test all the business requirements.
• Performed Data Analysis and Data validation by developing reports and by writing complex SQL queries using TOAD against the ORACLE database .Worked closely with Quality Assurance and SQL and PLSQL development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to solve the defects
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensured the critical requirements were not missed.
• Worked on LPS applications such as MSP, Director, Desktop and Passport.
• Followed the UML based methods by using Visio to create Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Delivered informative and well-organized documentation & presentations.
• Performed requirement analysis including data analysis and gap analysis.
• Created and maintained end-to-end data mapping and data conversion spreadsheet.
• Extensively worked on MS Excel, MS PowerPoint, MS Project, MS Visio and MS Word.
• Assisted in developing Work Breakdown Structure, project schedule, project status reports and attended project progress meeting to report on project progress.

Environment: MS-Office, MS-Visio, MS Project, Oracle (9i/10g), TOAD, SQL*Loader, MS-SQL Server 2000, SQL, UNIX, Windows NT, QTP, Test Director, Rational Requisite Pro

Confidential, St Louis

Business Analyst/ Project lead/manager

Responsibilities:

• Performed requirements gathering and analysis and documented business requirements using Agile methodologies
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams, using UML
• Performed data mapping of source and target systems and prepared data mapping documents
• Analyzed Functional requirements by interacting with users and created design and technical documents.
• Developed project plan and i nvolved in the complete life cycle of Oracle Order import conversions
• Designed and documented the technical specifications of Oracle Order Import from different order sources of Confidential .
• Lead and mentored the team of technical developers
• Developed packages with multiple stored procedures that validates the data and imports data to the base tables
• Designed and developed custom packages, triggers and procedures using PLSQL .
• Worked closely with the DBA to improve the performance of the system by tuning and optimizing the conversions routines by studying the explain plan, and restructuring PL/SQL program units for optimum performance.
• Created the database schema objects like tables, views, synonyms, indexes
• Involved in code review, Code walk through, Unit testing, Integration Testing etc.

Environment: Oracle Applications R12 OM, Purchasing, WIP, Shipping, AR, GL, FA,AP,INVQTP, Test Director, Rational Requisite Pro

Confidential, Erlanger & Lebannon, KY

Business analyst/technical lead

Responsibilities:

• Interacted with the users/stakeholders for requirements gathering and analysis and prepared business requirement documents.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams, using UML
• Communicated the Business Requirements to the technical team
• Analyzed Functional requirements, interacted with users and created design and technical documents
• Designed the custom ASN(Advanced Shipping Notice) for TBA bumper business .
• Mentored and lead a team of offshore technical developers
• Designed and developed custom packages, triggers and procedures using PLSQL
• Performed code review, Code walk through, Unit testing, UAT etc.
• Tested the entire application keeping in mind the requirements of the system.

Environment: MS-Office, MS-Visio, MS Project, Oracle (9i/10g), TOAD, SQL*Loader, MS-SQL Server 2000, SQL, UNIX, Windows NT, QTP, Test Director, Rational Requisite Pro

Confidential

Technical Business Analyst

Responsibilities:

• Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams and prepared Requirements Documentation using Requisite pro based on Agile model.
• Created business process flow diagrams, Integrated process flow diagrams to show end-to-end business model and process mapping exercise including swim lanes
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams, using UML
• Participated in status meeting and requirement walkthroughs
• Developed project plan for the complete life cycle of system development of LAC interface with AEM
• Developed inbound and outbound interface of Oracle with AEM.
• Designed and documented the technical specifications of LAC interface with AEM using the available functional specification
• Performed GAP analysis to meet the end state requirements
• Developed business process models in Agile to document existing and future business processes.
• Performed Data Analysis and Data validation by developing reports and by writing complex SQL queries using TOAD against the ORACLE database .Worked closely with Quality Assurance and SQL and PLSQL development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to solve the defects
• Participated in System Test reviews, development design reviews & usability studies
• Analyzed Functional requirements by interacting with users and creating design and technical documents.
• Worked closely with the DBA to improve the performance of the system by tuning and optimizing the LAC interface extraction procedure by studying the explain plan, and restructuring PL/SQL program units for optimum performance.
• Involved in code review, Code walk through, Unit testing etc..
• Tested the entire application keeping in mind the requirements of the system.

Environment: MS Sharepoint MS-Office, MS-Visio, MS Project, Oracle (9i/10g), TOAD, Oracle 11i EBS SQL*Loader, MS Dynamics CRM, XML,SQL, UNIX, Windows NT, QTP, Test Director, Rational Requisite Pro

Confidential, Boston, MA

Technical Business Analyst

Responsibilities:

• Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams in the finalization of the User Requirement Documentation using waterfall.
• During business requirement gathering, conducted personal and telephonic user interviews.
• Participated in status meeting and requirement walkthroughs
• Identified, researched, investigated, analyzed, defined and documented business process
• Performed GAP analysis to meet the end state requirements
• Developed business process models in Agile to document existing and future business processes.
• Created business process flow diagrams, Integrate process flow diagrams to show end-to-end business model and process mapping exercise including swim lanes
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams, using UML
• Prepared the System Requirement Specifications (SRS) for the requirements. Involved in code review, Code walk through, Unit testing etc
• Resolved production support tickets as desired by users..
• Performed unit tests considering all the unit tests scenarios
• Designed the deal form using forms 6i and designed form personalization
• Developed reports in OM/BOM/INV modules using reports 6i

Environment: Oracle Applications R12 AR,PA, FA,GL, INV, OM,Adv Pricing, Quoting,Shipping, BOM, Forms 6i, Reports6i, XML Publisher,TOAD, SQL, PL/SQL,Unix

Confidential, Columbus, OH

Sr. Business Systems Analyst

Responsibilities:

• Led facilitation process to drive out requirements from all levels of business and technical clients using group and collaborative methods-Used RUP Modeling methodology.
• Analyzed Business Requirements, reviewed Test Strategy, Traceability Matrices and Test Plans to ensure that test cases reflect user needs for the functional, performance, usability and security requirements.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, and Sequence Diagram in Rational Rose.
• Was responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans.
• Worked with the data entry requirements of the users forms and screens
• Conducted JAD sessions to get SME’s input and the sales team on how to implement the application for core credit card production and billing.
• Used SQL, Toad, Data Warehousing and Data Cleansing for the arrangement of customer data
• Created Test Plans, Test Cases, Test Scenarios and Test Strategies to ensure Quality Assurance and to test all the business requirements.
• Performed Data Analysis and Data validation by developing reports and by writing complex SQL queries using TOAD against the ORACLE database .Worked closely with Quality Assurance and SQL and PLSQL development teams to clarify and understand the functionality to resolve issues and provide feedback in terms of the test matrices and to solve the defects
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensured the critical requirements were not missed.
• Followed the UML based methods by using Visio to create Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Delivered informative and well-organized documentation & presentations.
• Performed requirement analysis including data analysis and gap analysis.
• Created and maintained end-to-end data mapping and data conversion spreadsheet.
• Extensively worked on MS Excel, MS PowerPoint, MS Project, MS Visio and MS Word.
• Assisted in developing Work Breakdown Structure, project schedule, project status reports and attended project progress meeting to report on project progress.

Environment: MS-Office, MS-Visio, MS Project, Oracle (9i/10g), TOAD, SQL*Loader, MS-SQL Server 2000, SQL, UNIX, Windows NT, QTP, Test Director, Rational Requisite Pro

Confidential, CA

Business Analyst

Responsibilities:

• Acted as liaison between the business and the development team.
• Customized the RUP framework for the project and executed it all through the lifecycle.
• Gathered requirements from clients/user groups and analyzed workflows.
• Conducted user interviews with critical users and arranged JAD sessions at both domestic and client locations.
• Collected, documented, and managed business requirements using RequisitePro.
• Analyzed UI documents and verified them with the user groups.
• Conducted Gap analysis to derive requirements for existing systems enhancements.
• Involved in driving technical decisions and providing rationale for these decisions. Identified and documented different significant architectural aspects/views of the system.
• Conducted iterations and communicated results and milestone achievements to stakeholders while keeping the developers directly updated on all documented modifications.
• Created test plans and Test Cases iteratively to guarantee application meets the requirements.
• Performed GUI testing on various screens and verified functionality of objects on various screens.
• Organizing, and managing tasks and resources, allocating tasks and estimating timelines, feedback and control using but not limited to tools such as MS Project.
• Conducted User Acceptance Testing (UAT) and verified performance, reliability and fault tolerance issues.
• Interacted daily with the project team resolved issues to make enhancements based n the change requests.
• Involved in weekly walkthroughs and assessment meetings to verify the status of testing effort and the project as a whole.

Environment: Requisite Pro, Rational Unified Process (RUP) using Rational Rose, MS Word, MS Access, MS Excel and MS Project, Test Director, J2EE, Oracle, SQL Server