SUMMARY OF QUALIFICATION:

• 11 + years of work experience in various domains ranging from Insurance, Banking, Pharmaceutical, Retail and Oil & Gas.
• Worked as a Sr. Business Analyst, PM Coordinotor and Business Intellengence (SME)
• Implemented Data Warehouse, Business Intelligence, CRM Projects.
• Extensive experience as a Subject Matter Experts (SME’s), performing Requirements Gathering Documentation, Business Analysis , Data Analysis .
• Interaction and coordination with Technical and Non - Technical clients
• Comprehensive knowledge of Waterfall SDLC , AGILE ( Epic, User Stories for Backlog) software development process framework,
• Complete understanding of UML Artifact.
• Very proficient in 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 JAD sessions 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
• Exceptional ability to visualize and develop fully integrated solutions by assessing current situations and business issues from people, process, and technology perspectives
• Strong understanding of Business Process Management , Business Process Reengineering , Business Process Modeling, Business Analysis and System Analysis
• 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 US GAAP, General Ledger Accounting, and Asset Accounting
• Knowledge of Financial and Management Reporting, Forecasting and Capital Budgeting , and KPI reporting for the business
• Very proficient in MS Excel. (Advanced Calculations, Pivot Tables, vlookups)
• Knowledge 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

TECHNICAL COMPETENCIES:

Application Packages: MS Word, MS Excel, MS Access

Concepts: Data Warehousing, Business Intelligence,MS-CRM

Business Analysis: IBM Cognos, SAP BI, Crystal Reports, Web Intelligence Report

Reporting Tools: Crystal Reports, Web Intelligence, IBM Cognos, Tableau, MS SSRS.

Project Tools: MS Project, IBM Rational RequisitePro, MS Visio, Wireframe

Testing Tools : HP Load Runner, HP Win Runner, Jira,

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

ETL Tools : Informatica 7.2.1, SAP BODS 4.1

Languages : SQL

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

PROFESSIONAL EXPERIENCE:

Confidential

Tampa, FL

Sr. Business Analyst/PM Coordinator

• Worked as a Sr. Business Analyst/SME to 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 Design, high level Business Requirement Document.
• Discussed and analyzed Team status, Progress, Risks , and issues with senior management.
• Agile 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.
• Daily Scrum process used for Epic user stories (Product Back Log and Sprint Back Log)
• Conducted meetings and workshops to discuss high level requirements and developed User Requirements Specification Document (URD).
• Extensively worked on Business Requirement Document (BRD) and Functional Requirement Document (FRD) supporting documents containing essential business elements, detailed definition and description of the relationship between the stakeholders.
• Extenslive used Wireframe which allows to determine the information hierarchy of the design.
• 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.
• 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.
• Extensivley used MS Excel for creating Pivot Table, vlookups and Advanced Calculations as per business requirement.
• Queried Oracle Databases to verify Test Case results. Randomly executed test scripts developed by Quality Analyst team to check main functionality of application.
• Interacted with Development and QA Team to ensure overall Quality and Scalability of the software.

Environment: SDLC, Agile, UML, MS Project, MS Visio, MS Excel, MS PowerPoint, Oracle 11g, SQL Server 2012, Jira,Test Director, Wireframe

Tampa, FL

Sr. Business Analyst

• Worked as a Sr. Business Analyst to design 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 .
• 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
• Focused on continuous process improvement strategies with a clear and measurable Development Process that is deployable throughout the enterprise
• Controlled project resources, planning and implementation using MS Project, SharePoint.
• 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 RequisitePro 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
• Used Wireframe for translating application functionality
• 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
• Analyzed Business Requirements from Black Box Testing perspective, and developed efficient IT solutions and stable Process Designs using SDLC.
• 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
• Coordinated the Functional and Performance Testing with QA team
• Extensivley used Pivot Table, vlookups in MS Excel.

Environment: SDLC, Agile Methedology, Windows XP, Microsoft Office, Microsoft SharePoint, SQL Server 2008, DB2, IBM Cognos, Tableau, RequisitePro, Rational Test Manager, Wireframe

Dallas TX

Sr. Business Analyst/PM Coordinator

• 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 to set up new accounts, manage teams and issue resolution.
• 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 SAP BI system.
• Created Product Back Log in Agile Methedology .
• Participated JAD Sessions to develop an architectural solution and ensure that the application meets the business requirements, Resolve Open Issues , and change requests.
• Involved in writing Business Rules to support recommendations for resolving business and technical issues
• Extensively worked on Business Requirement Document (BRD) , supporting documents containing essential business elements, detailed definition and description of the relationship between the stakeholders
• Participated in JAD Sessions to develop an architectural solution and ensure that the application meets the business requirements, resolve open issues, and change requests.
• Worked from FSD (Functional Specification Documents) to make changes to the mapping document based on a CR (change Request) or Defects for QA.
• 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
• Created Use Case Diagrams , and Activity Diagrams , using MS Visio according to UML methodology and in compliance with RUP standards
• Conducted GAP Analysi s 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.
• Conducted User-Acceptance Testing before the release of the product to Business.

Environment: MS Project, MS Visio, UML, SDLC, Waterfall & Agile Methedology, MS Office, Microsoft SharePoint, SQL Server 2012, SAP BI.

Minneapolis, MN

Sr. Business Analyst

• 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
• Gathered requirement for User interfaces from 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 CRM
• Co-ordinate between the various project teams (Data Acquisition, Reference Data, CRM 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: MS Project, MS Visio, UAT, UML, SDLC, MS Dynamic CRM, SQL Server 2008, Microsoft SSIS, MS SSRS

Houston, TX

Sr. Business Analyst/CRM

• 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 Energy Distribution 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: SDLC, UAT, UML, MS Office, MS projects, MS Visio, Rational Rose, SQL Server 2008, MS Dynamic CRM

Chicago, IL

Sr. Business Analyst

• 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.
• Analyzed and documented Business requirements and Business Process Models to create BRD for 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 byusingVisio 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.
• Used Excel to create the data mapping documents which is used by the Development & Testing team, I 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.

Environment: MS Access, Excel, Word, PowerPoint, SharePoint, I-Rise, MS Visio, Oracle 8i, Rational Requisite Pro, Rational Clear Quest.

Dallas, TX

Business Analyst

Responsibilities:

• Conducted meetings/interviews and JAD sessions with stakeholders to collect businessrequirements. 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 (DFD’s)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,Waterfall Methodology,MS Excel, MS Visio, SQL.