SUMMARY:

• 11 years of work experience in various domains ranging from insurance, banking, pharmaceutical and Information technology as a Business Analyst and System Analyst.
• Extensive experience as a Subject Matter Experts (SMEs), performing Requirements Gathering, Business Analysis, Data Analysis and Documentation.
• Extensive experience with Oracle SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and Validation.
• Very good understanding of Database concepts like Data Warehousing, Data Structures, Schemas, Data Marts, Data - Entity relationships and User Administration.
• Interaction and coordination with technical and non-technical clients.
• Comprehensive knowledge of Waterfall SDLC, Rational Unified Process (RUP) software development process framework, complete UML Artifact, scope definitions, and AGILE development framework with AUP, XP & Lean.
• Very proficient in Data Modeling, Data Flow Analysis, Transaction Flow Analysis, Alternative Path analysis, Data Security and Active Directory.
• Extensive experience in analyzing and documenting business requirements and system functional specifications including Risk analysis, conducting JADsessions with various stakeholders and the end users.
• Worked extensively on performing ‘AS IS’ and ‘TO BE’ analysis, GAP analysis and drafted Project Analysis documentations.
• Ability to work cohesively with all Stakeholders to formulate Functional models and prototypes to meet stakeholder expectations, and Workflow optimization.
• Strong experience in Requirement Management, Change Control and CRM systems.
• Extensive knowledge of Object Oriented Analysis, MS Office Suite, MS Project, MS Visio and gathering user requirements and technical documentation.
• Proficient in analyzing and creating use cases, activity diagrams, class diagrams and sequence diagrams using MS Visio, thereby helping the development team in understanding the requirements.
• Knowledge of Financial and Management Reporting, Forecasting and Capital Budgeting, and KPI reporting for the business.

TECHNICAL SKILLS:

Application Packages: MS Word, Excel, Access

Concepts: Data Warehousing, Business Intelligence

Business Analysis: IBM Cognos, Micro Strategy 7x/8x,SAP Business Object 3.x/4.1, Web Intelligence Report

Reporting Tools: Web Intelligence, IBM Cognos, SQL Server Reporting Services

Project Tools: MS Project, Rational RequisitePro, Rational Rose, MS Visio

Testing Tools: Load Runner, Win Runner, Rational ClearCase, Rational ClearQuest

Methodologies: SDLC, Waterfall, Agile, Scrum, JAD.

ETL Tools: Informatica Power Center 7.2.1, SAP BODS 4.1

Languages: SQL

Database: Microsoft SQL Server 2005, 2008, PL/SQL, Oracle 9i/10g, Teradata, DB2

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Sr. Business Analyst

Responsibilities:

• Worked as Business Analyst/SMEto deploy as targeted by working with team to move the excess requirements to the next release project.
• Hosted regular status meetings and obtained statuses from team members for System Requirements creation, Design, Test Case creation, and Test Case execution.
• Wrote complex Oracle SQL queries to resolve data issues in source system databases.
• Discussed and analyzed team status, progress, risks, and issues with senior management.
• Rapid Application Development (RAD) principle was used in acute functionalities to design, document and manage requirements throughout the life cycle of the project, including definition, design and testing phases.
• Conducted meetings and workshops to discuss high level requirements and developed User Requirements Specification Document (URD).
• Extensively worked on Business Requirement Document (BRD), supporting documents containing essential business elements, detailed definition and description of the relationship between the stakeholders.
• Conducted GAP Analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective implementation.
• Conducted feasibility study and performed impact analysis for proposed enhancements.
• Responsible for implementing the Key process areas and proactively working for Revenue Cycle improvements.
• Managed Version Control, each version of the application was stored in Clear case and necessary modifications, updates and analysis was done.
• Worked closely with Developers and User Representatives, participated in the product design process including specifications, end-user reviews and application walk-through.
• Developed business use cases in most instances, worked extensively on Rational Requisite Pro in gathering user Requirements, manage Workflows and elicit Communication plans.
• Generated Use Case diagrams using Visio to depict process flows, timelines and cost-benefit models.
• Analyzed ER diagrams for depicting entity relationships and mapped them to relational database.
• Worked with On-site and Off-shore teams for Development and Testing.
• Configured test environment for specific test cases, created test data, executed automated or manual unit tests, documented results and updated defect-tracking systems.
• Used Test Director to invoke the scripts, initially performed the baseline testing, organized all the scripts systematically and generated reports.
• Queried Oracle Databases to verify test case results. Randomly executed test scripts developed by QA team to check main functionality of application.
• Interacted with Development and QA Team to ensure overall quality and scalability of the software.

Environment: Oracle 11g, Report Studio 10.1, Framework Manager 10.1, SQL Server, Analysis Studio 10.1,Rational Requisite Pro V7.1, Rational ClearCase V7.1, Rational ClearQuest V7.1, MS Office, MS Project, MS Visio, UML2.2, RUP

Sr. Business Analyst

Responsibilities:

• Involved in development of Business and Technical Requirements in preparation of System Architecture, Information Strategy, Detailed Design documents, to satisfy the Business Needs and Processes for the core system.
• Devised system to generate automated Business Intelligence reports for the internal users.
• Controlled project resources, planning and implementation using MS Project, SharePoint and AGILE methodologies.
• Preparing technical manuals, policy terms and conditions, and meeting minutes.
• Developed and maintained legal documents as required by state and federal laws.
• Prepared project Documentation based on requirements such as Business Required Document (BRD).
• Collaborating with business partners and cross-functional teams and supporting system documentation.
• Communicating necessary changes and development to stakeholders in meetings.
• Utilized Unified Process to contribute to design standards, and provided technical leadership and expertise in reorganization of a complex End-to-End Testing effort.
• Performed System analysis and organizational review of existing QA processes.
• Prepared Business Process Models including business process flows from conceptual to procedural level, often applying BPR to optimize resource optimization.
• Trained users on the Micro strategy interface with particular focus on data drilling, report creation using public objects, data filtering, and grid/graph capabilities of the Dashboard.
• Focused on continuous process improvement strategies with a clear and measurable Development Process that is deployable throughout the enterprise.
• Analyzed Business Requirements from Black Box Testing perspective, and developed efficient IT solutions and stable Process Designs using SDLC.
• Modeled business architecture by gathering Business Requirements and creating Functional Documents, scheduled and monitored development process.
• Gathered and analyzed Business and User Requirements from walkthroughs with the users and business developers. Used Rational Requisite Pro to create the requirement analysis and specification documents.
• Assisted the technical team in translating application functionality into application architecture and the production of a System Functionality document.
• Conducted JAD sessions, initiated process improvements and worked as an interface between the users and different teams involved in the application development for the better understanding of the functional and IT processes, and thus converting business needs into proficient, quality solutions.
• Followed a structured approach to organize requirements into logical groupings of essential Business Processes, Business Rules and Functional specifications, thus ensuring that Critical Requirements are met thoroughly.
• Coordinated the Functional and Performance Testing of the ERP with the QA team.

Environment: SQL Server 2008, Oracle 10g, Crystal Reports XI, Micro Strategy 8i, Windows XP, Microsoft Office, Microsoft SharePoint, UML2.1, SDLC, Rational Rose, Requisite Pro, Rational Test Manager.

Sr. Business Analyst

Responsibilities:

• Extracted and gathered the business requirements like extensive search capabilities, sourcing tools from the business experts and architects, developed Functional Specifications and Use Cases.
• Worked Tremendously on SAP BI ERP to set up new accounts, manage teams and issue resolution.
• Wrote complex SQL queries in, aggravating and manipulating it to retrieve data from Oracle Database.
• Applied strong analytical skills and used techniques like brainstorming, and interviews to ensure that the marketing team and the recruiting team communicated properly.
• Defined logic for Extraction, Transformation and Loading of data into Warehouse and Marts.
• Involved in writing Business Rules to support recommendations for resolving business and technical issues.
• Designed the User Interface for better communication to developers.
• Managed reported change requests in Sales Force.
• Participated in SWOT meetings (JAD Sessions) to develop an architectural solution and ensure that the application meets the business requirements, resolve open issues, and change requests.
• Worked on Integrating and Synchronizing Front Office by generating Job alert notifications, tracking communications, and matching job orders against available candidates.
• Analyzed Software Requirements documents and Business Requirements documents to get a better understanding of the system on both Technical and Business perspectives.
• Analyzed business functional requirements and segregated them into Use Case Specifications.
• Worked closely with the client's developers to define the purpose and use of database tables and attributes in their existing systems where documentation was lacking.
• Created Use Case Diagrams, and Activity Diagrams, using MS Visio according to UML methodology and in compliance with RUP standards.
• Conducted GAP Analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective implementation.
• Involved in feasibility study and performed impact analysis for proposed enhancements.
• Created Test cases and Plans to accomplish the same and make them available to Business.
• Conducted and participated in walkthroughs to discuss certain issues with the development, design and QA team.
• Interacted with the Developers, QA and Engineering teams for resolving the report bugs and technical issues through Sales force CRM by SQL querying on “TOAD”.
• Conducted User-Acceptance Testing before the release of the product to Business.

Environment: Oracle 10g, DB2, SAP ERP, UML2.1, SQL, SDLC, MS Office, MS Visio, MS Project

Sr. Business Analyst

Responsibilities:

• Gathered business and technical requirements for the project.
• Analyzed the requirements and createdthe requirements document.
• Conducted Requirement Gap analysis by comparing the current and future system functionalities and understanding the rules and rates for the particular state in consideration.
• Responsible for development of interfaces from/to multiple Legacy systems.
• Interaction with Subject Matter Experts to get clarifications on the product.
• Created functional specifications from the Business Requirements Document.
• Designed the mappings to load the conversions data from source to target ERP.
• Co-ordinate between the various project teams (Data Acquisition, Reference Data, ERP team and Reporting teams) for a smooth data flow process.
• Involved in transmitting the code across different environments like development, testing and production.
• Provided clear and concise documentation regarding requirements management plans, functional requirements, supplemental requirements, test plans and test cases.
• Created and Executed User Acceptance Test scripts & Test plans.
• Involved in providing the support for the Application.

Environment: Informatica PowerCenter 7.1.2, Oracle 9i, Teradata, MS Project, MS Visio, UAT, UML2.0, SDLC

Sr. Business Analyst

Responsibilities:

• Interacted with Users and Stakeholders to identify business system needs, evaluated solutions for business problems.
• Worked with SME’s of different groups to gain detailed knowledge of Investments and Capital Market and also to understand the cross impacts of the system.
• Analyzed and documented information system requirements and the corresponding impact on business processes.
• Studied the Business Requirement Document (BRD), supporting documents containing essential business elements, detailed definition and description of the relationship between the actors.
• Designed and developed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams to define the Business Process.
• Analyzed the data entity relationships and worked on multiple short term projects in between.
• Worked as a team with other business analysts to make an object oriented model of the application and created use cases.
• Conducted JAD sessions to allow different stakeholders to communicate with each other, resolve problems at early stage.
• Worked on the Functional Requirements Document (FRD).
• Hands on experience in working with active directory, to give privileges and access to the users according to their roles and designations.
• Analyzed Business Requirements documents to get a better understanding of the system on both Technical and Business perspectives.

Environment: MySQL, Java/J2EE, Active Directory, Rational Rose, SDLC, UAT, UML, MS Office, MS projects, MS Visio

Business Analyst/ UI Data Analyst

Responsibilities:

• Used Excel to create the data mapping documents which is used by the Development & Testing team, worked very closely with them in order to make sure the correct data element is being passed from one system to another.
• Attended JAD Sessions in order to capture Business rules around Data elements on the User Interface system.
• Conducted walk through meeting in order to validate the accuracy of the mapping document with the Business and technical team.
• Worked closely with the Technical Analyst to study the UI Prototypes, USE CASEBAC (Business Acceptance Criteria document) and DRD (Data Requirements Document) in order understands how data is passed from one System to another and also how the system interacts with other systems.
• Worked from FSD (Functional Specification Documents) to make changes to the mapping document based on a CR (change Request) or Defects for QA.
• Was actively involved in Cross Platform meetings validating Data transfer accuracy & Data migration rules with different system.
• Conducted detailed and comprehensive business analysis by working with the client IT staff and end-users in order to identify system and operational requirements and improvements.
• Analysed and documented Business requirements and Business Process Models to create BRDfor better understanding of the business process.
• Create the business process model using Visio and present it to the SME for validation and getting the sign-offs.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Followed the WUP/RUP based methods byusing Visio to create UML Diagrams like Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams to author FSD (Functional Requirement Document).
• Track and maintain Stakeholder requested enhancements and changes using SharePoint.

Environment: MS Access, Excel, Word, PowerPoint, SharePoint, I-Rise, MS Visio, Oracle 8i, HTML, RequisitePro, Rational Rose, Clear Case, Clear Quest

Business Analyst

Responsibilities:

• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documents them textually or within models.
• Understood and articulated business requirements from user interviews and then convert requirements into technical specifications.
• Interacted with SME’s, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business people and technical people.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS) for the Web based application by following SDLC methodology.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro and Visio.
• Participated in the logical and physical design sessions, developing design documents.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, for OOD using UML.
• Performed requirement analysis, and detailed examination of all the use cases and issue logs.
• Performed extensive business process analysis including data analysis and GAP analysis.
• Documented and delivered Functional Specification Document to the project team.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Partnered with the technical areas in the research and resolution of system and User Acceptance Testing.
• Worked as a User\Customer Advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to BRIDGE the gaps between IT and Business Client.

Environment: Web Interface Definition Language, JSP, Oracle 9i, HTML, XML, XSL, Rational Rose, Rational ClearQuest, Rational ClearCase, Robot, Requisite Pro, MS Visio, RUP methodology, MS Project, Crystal Reports, RUP

Business Analyst

Responsibilities:

• Conducted meetings/interviews and JAD sessions with stakeholders to collect business requirements. This information along with the vision document was used to transform business requirements into System Requirements Specifications.
• Interacted with the stakeholders to review and baseline the design documents.
• Helped identifying reports for decision support system and was interacted with database designers and architect.
• Conducted milestones planning of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams.
• Responsible for defining and documenting System Requirement Specifications/feature requirements and supplementary requirements in RequisitePro.
• Created and managed project templates, use case project templates, requirements types and traceability relationships in RequisitePro.
• Created Sequence Diagrams, State Chart Diagrams andData Flow Diagrams (DFDs)using MS Visio.
• Created Use Case Model and detailed use cases in conjunction with the project team, to define the features of the application, to be used by the development team.
• Interacted with the QA team to design test cases from the detailed use cases and the use case diagram, using Test Director.
• Attended Change Request Meetings to document corresponding changes and implemented procedures for enforcing changes through defect tracking using Test Director.
• Collected test metrics weekly that reflected the current status of the test execution and the state of the defects, and presented weekly status report to management.
• Developed strategies/ solutions to resolve the supply chain issues while creating special cases for extremely important / critical functions.
• Developed new clients for the company while marketing the various services offered.

Environment: MS Access, Excel, Word, PowerPoint, SharePoint,Agile/Scrum,MS Excel, MS Visio, SQL