Sr Business System Analyst Resume
Cincinnati, OH
SUMMARY
- Business Analyst with over 8 years industry experience in business data modeling, software requirement analysis, process modeling, process flow and quality assurance skills using different methodologies, mainly OOA, OOAD and UML.
- Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative Rational Unified Process (RUP)
- Worked alongside the Project Management to establish the resources (resource estimation exercise) required from Informatica on - site for Nike.
- Worked with the project team to accomplish quality assurance and process improvement initiatives.
- Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and testing various methodologies.
- Sound understanding of Object Oriented Analysis and Design OOAD and proficient in documentation of As-is and To-be business processes.
- Strong experience in design and development of ETL process from Staging to Data warehouse and to Data Mart
- Worked in an AGILE delivery model involving multiple scrum teams and daily stand-up meetings
- Familiarity and use of (RITS) multiple technology administrative/service tools, such as LiveLink, Clarity/NIKU, Alert Find, Problem Coordinator Console (ARS).
- Extensive experience with Business-to-consumer (B2C) sales of tangible goods/online services and Business-to-business (B2B) scenarios, such as e-procurement
- Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
- Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group.
- Provided mapping of XML from Auto Web to policy management system.
- Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
- Developed complex queries with the team, to extract, manipulate and transform data from several databases (SQL, Oracle & Teradata).
- Performed extensive data modeling to differentiate between the OLTP and Data warehouse models
- Extensive experience in modeling the AS IS and TO BE ecommerce solutions
- Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
- Undertaking the requirements from Business requirements document (BRD)
- Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification and Business Process Flows.
- Proficient in using UML in behavioral, structural and architectural modeling - in creating Use Case, State, Activity, Class and Sequence diagrams using Rational Rose.
- Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
- Extensive experience in configuring data mapping between different Databases.
- Extensive experience with Content Management tools such as Interwoven, Filenet, Sharepoint and Documentum
- Used ERwin 4.0 to capture data by creating Entity-Relationship and Use Case diagrams.
- Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
- Well-versed in project management tool (MS Project) for status reporting, planning and resource allocation.
- Experience in conducting GAP analysis, User Acceptance Testing (UAT). SWOT analysis, Cost benefit analysis and ROI analysis.
- Experience testing implemented systems and system changes including liaising with QA teams to develop test cases, test plans, test scenarios, and generating test data; and conducting manual testing (regression, end-to-end, functional)
- Strong communication, problem solving, organizational, interpersonal, and presentation skills.
TECHNICAL SKILLS
Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, DoorsErwin Data Modeler 4x, Business Object (Crystal Reports)
Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Business Environment and Market Research Analysis
Methodologies: RUP, OOAD, AGILE, UML & Business/Data Modeling
Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker
Operating Systems: Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux
Databases: Oracle 8i/9i; SQL Server 7.0 & 2000; Access 2000, MS SQL Server, MySQL, DB2
Content Management Tools: Documentum, Sharepoint, Interwoven, Filenet
Languages: UML (Use case, activity diagram, sequence diagram, data flow diagram, component diagram), C, C++, HTML, Java, SQL, PL/SQL, ASP.NET
PROFESSIONAL EXPERIENCE
Confidential, Cincinnati, OH
Sr Business System Analyst
Responsibility:
- Analyze B2C and B2B web properties and create new business plan, business requirements, and staffing requirements
- Interacted with Business as the Project Management or Lead of BI reporting for the projects in BI scope
- Responsible for analysis of derivatives, futures & options, foreign exchange and securities risk management.
- Extensive documentation skills and proficiency in utilizing Quality Center as a test management and defect tracking tool
- Trained and hands on experience in using Business Objects XI R2 and Oracle Business Intelligence Enterprise Edition (OBIEE)
- Reviewed and Analyzed Business Requirement Document - BRD
- Good understanding of Software Development Methods such as the Waterfall&Iterative models and AGILE methodology
- Maintained records and statistical information for E-Commerce managers, E-Commerce personnel, other departments and outside vendors.
- Writing complex SQL Queries to test the Data Stage ETL process.
- Conducted Product reviews for Stakeholders and reported During PMO sessions to the Project management
- Responsible for support reports using Cognos BI interpreting user requests, documenting requirements.
- Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
- Developed XML Schemas and DOM parser for all the XML documents used for data transfer and also developed XSLT code for them.
- Used the guidelines and artifacts of the Agile Process to strategize the Implementation in different sprints of the Software Development Life Cycle.
- Create Mapping documents, ETL technical specifications and various documents related to data migration.
- Created test cases for the new data warehouse objects and managed defect tracking using HPQC (QualityCenter).
- Trained and managed developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
- Determined project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e-commerce web site Testing.
- Gathered requirements for both B2B and B2C parts of the project.
- Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
- Gathered requirements for the integration of Point-Of-Sale (POS) system with the supply chain system
- Assisted with the BRD for the Point-Of-Sale (POS) implementation project.
- Applied research and process development techniques in synthesis of vitamin derivatives for health, cosmetic, and industrial applications.
- Excellent understanding of the Software Development Life Cycle (SDLC) and worked on various life cycles like Waterfall, Iterative, V-Model, Agile (Scrum) models.
- Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient Microsoft Word, PowerPoint, Access and Lotus Notes.
- Worked alongside the Project Management to establish the resources (resource estimation exercise) required from Informatica on-site for Nike.
- Defect management using Quality Center 9.2& HP ALM 11.0
- Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
- Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
- Planned and defined system requirements to WireFrame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
- Played key role in defining test automation procedure and standards, creating Win Runner and Quick Test Professional scripts for all the modules, which reduced the regression cycle drastically and improved the testing efforts for daily builds.
- Analyzed the complete Supply Chain, from receiving an order in OMS (Order Management System) and complete processing till final delivery to customer
- Implement Agile Iterative Process (Scrum/Rational Unified Process/ Extreme Programming)
- Designed conceptual and logical data models of Data Warehouse and tables
- Allocate project resources and time constraint, usingNiku/Clarity database.
- Created Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams thus defining the Data Process Model and Business Process Model.
- Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
- Wrote Test plan and Test cases for the Integration testing and system testing.
- Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
- Created business requirement documents and integrated the requirements and underlying platform functionality.
- Design and Architecture using BEA Weblogic’s latest features like Portal, Page Flow, Process Control, Java Control and Web-Services using Weblogic development IDE Workshop on Oracle database
- Worked with systems area to translate business needs into system requirements.
- Involved in Configuration Management, Requirement management and analysis
- Worked closely with the vendor to define work rules for different types of exempt and non-exempt employees.
- Produced metrics which provide management insight into the requirements process, to include, status, size, volatility, quality, effort, etc.- Visio, Rational Tools, Traceability Matrixes.
- Performed after Action/Post Milestone Reviews and quality reviews to ensure that developed software products met the business needs and are in compliance with RUP and CMMi 3.
Environment: Windows XP/2000, Oracle, PL/SQL, MySQL, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, SSIS, Cognos, Tableau, Clear Quest, JavaScript, MS Visual Source Safe, AGILE, Quick Test Pro (QTP)
Confidential, Detroit, MI
E-Commerce Business Analyst
Responsibility:
- Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
- Responsible for writing and maintainingFunctional Requirement Specifications (FRD) and Requirements Traceability.
- Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.
- Collaborate with systems developers, business analyst and product owners to provide Quality Assurance Agile practices
- Participated in the testing effort at all the stages of SDLC (Agile model) and executed test cases and documented the test results using HP Quality Center.
- Worked with end users to design business requirements of a Business CRM System and manage B2B processes of distribution across the region.
- Analyzed the system for the effectiveness of the E- commerce operations
- Responsible for all web development, E-commerce and optimization and web strategy and corporate website and self-service intranet site.
- Created Informatica mappings with SQL, PL/SQL procedures and Functions to build business rules to load data.
- Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
- Responsible for identifying, documenting and testing the data mapping feeds from several reference data systems, to risk applications
- Provided recommendation for use of ATG Commerce for B2B and B2C business.
- Develop, maintain and publish project plan & scheduled project deliverables using Niku/Clarity resource database as well as MS Project.
- Performed Quality Assurance review and testing for New Business and Contract Date Page outputs.
- Analyze the Business Requirement Document (BRD), Functional Specification Documents to prepare Test Cases based on Test Plans
- Worked in both SDLC and Agile (Iteration) software development models
- Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
- Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
- Responsible for applying object oriented analysis and design (OOAD) principles to create domain models using UML
- Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
- Generated XML documents using the XML Output Stage.
- Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
- Worked with developers and designers of BPM System to make sure development understands business process and detailed technical requirements.
- Designed and developed workflow templates and lifecycles for process involving creating content to publishing product information on web.
- Worked in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
- Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.
- Created wireframes Mockup and storyboards
- Produced and maintained Functional Requirements Specifications (FRD/FRS) and Requirement Traceability Matrix (RTM) for various Releases of the project.
- Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
- Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
- Used Test Director which is a Mercury tool to help manage defects and issues log during the testing phase.
- Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
- Planning and creating test scenarios to ensure that the system modification will meet the specified business requirements.
- Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
- Implemented Web Services (SOAP, UDDI and WSDL) to integrate different applications.
- Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
- Worked as a User/Customer advocate and negotiated with user as well as the technical team and management staff to resolve any outstanding requirement conflict during the whole SDLC process.
Environment: Rational Suite (Rose, Requisite Pro), Windows XP/2000, SQL, XML, HTTP, MS-Project, MS-Office Suite, Sharepoint, MS Visio, Win Runner, Load Runner, JavaScript, Test Director (Mercury Interactive), Java, Oracle
Confidential, Chicago IL
Business Analyst
Responsibility:
- Performed requirement gathering & analysis by actively soliciting, analyzing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
- Participated in the testing of B2B and B2C websites, including creating test plan and test cases, executing test cases(including regression and ad-hoc testing), and defect management
- Documented the processes of Regional Distribution for the B2B and B2C System.
- Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
- Gathered Functional and Data Requirements, analyzed workflows and created Use Cases, Requirement Specifications, Report Specifications, Data Requirements, Data Mappings and Data Flow Diagrams.
- Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
- All the test scenarios which have been satisfied with the functionality are moved to automation testing using Quick Test Professional.
- Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture).
- Writing XML test files to run against XSD schema, testing C# application, backwards compatibility testing.
- Worked in a RUP environment using Rational Requisite Pro for requirement management
- Created various mockups to indicate the changes to the current receipts as a result of the enhancements.
- Determined the functional requirements through conducting user interviews, and created the business requirement document (BRD) and traceability matrix, and thus develop the standardization of processes.
- Created RUP activity diagrams and sequence diagrams to analyze the requirements and recommend solutions.
- Prepared scenarios, Use Cases & UML State Diagram for scenarios using Rational Rose.
- Prepare presentation slides in MS Project, which was extensively used in different JAD sessions and to track progress.
- Assisted the technical team in translating application functionality into application architecture.
- Organized meetings to discuss outstanding issues with QA and developers.
- Wrote test scripts for User Acceptance Testing (UAT).
Environment: Rational Suite (Rose, Requisite Pro), Rational Unified Process (RUP), Windows NT/XP/2000, UML, UNIX, MS-Project, MS-Office Suite, MS Visio, Mercury, XML, Javascript, WinRunner, Test Director
Confidential, Jersey City, NJ
Business Analyst
Responsibility:
- Researched the various steps in the lifecycle of Agency Appointment and Audit process and then facilitated to construct the System
- Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
- Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
- Used Rational Rose to designed and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams, OOAD using UML
- Analyzed data in Microsoft Excel by creating advanced Pivot tables and looking up data from other sources by the use of the VLOOKUP functionality
- Involved in designing business use case scenarios, use case realizations diagrams, and workflow charts for documenting the requirements.
- Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
- Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology.
- Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
- Creating, Process Flow Diagram, Context Diagram and Activity diagrams using UML.
- Designed and developed Use Cases using UML and Business Process Modelling.
- Designed and developed Use Cases, Work flows and Activity Diagrams using UML
- Responsible for writing Test cases to cover overall quality assurance using Test Director
- Developed & executed several Optimized queries in SQL on this data.
- Reviewed test plans, test cases for testing the project
- Facilitated UAT (User Acceptance Testing) with Business Users.
Environment: Uml, MS-Project, MS-Office Suite, MS Visio, MS Visual Source Safe (VSS), Web Sphere, XML, SQL Server 2000, Agile, Windows 2000