Sr. Business Analyst Resume
Cleveland, OH
SUMMARY
- Over 7+ years of professional experience as a Business Analyst
- Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
- Extensive experience with Business - to-consumer (B2C) sales of tangible goods/online services and Business-to-business (B2B) scenarios.
- Excellent in Developing and evaluating business process Models.
- Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
- Strong experience in RUP Business Modeling process.
- Expertise with Microsoft servers like Microsoft Office SharePoint Server 2010 and Microsoft PerformancePoint server.
- Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
- Solid understanding of Business Process definition, Risk Analysis and Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
- From the Agile scrum meetings, Prepared/Maintained overall project plan with tasks at a level that the project to be actively managed and tracked.
- Excellent in Developing and evaluating business process Models.
- Professional experience in business analysis, operations management and development, design, documentation and testing.
- Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
- Effective in executing multiple tasks and assignments ahead of schedule. Created and maintained effective budgets.
- Excellent in Business proposal Risk Assessment. Highly effective management and organizational skills with ability to prioritize.
- Exposure to Client/Server, Web Application developmental tools and Software development and design.
- Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage (Multiple) project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
- Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed. A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
- Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
TECHNICAL SKILLS
- OOAD (OOA/OOD)
- RUP
- UML
- SDLC
- UAT/BAT
- Waterfall
- QA
- WAP
- CVS
- TEAMMATE
- MS Access
- SQL Server
- MySQL
- PL/SQL
- Oracle DBA
- DB2.
- Windows 98/2000/XP basic UNIX
- HTML basic DHTML basic XML
- MS Office Suite-Excel Macros
- Project
- Visio
- Adobe Photoshop
- Flash
- Rational- Rational Rose
- Rational XDE
- DOORS
- Cobol
- RequisitePro
- CaliberRM
- Crystal Reports various NIKU products
- C
- C++
- MS SharePoint
- MS SharePoint Designer
- BASIC
- Intermediate level-Visual Basic
- Agile
- Scrum.
PROFESSIONAL EXPERIENCE
Confidential, Pittsburgh, PA
Sr. Business Analyst
Responsibilities:
- Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
- Part of Application Data Model design and implementation, developed SQL scripts and Stored Procedures as a part of Data Validation and verification along with Technical Architects and Technical leads on Oracle database.
- Written customer functions and triggers for various database tables for the application.
- Provided Data model and mapping sheets for various UI components to backend Oracle database tables.
- 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.
- Managing simultaneous projects with multiple clients, through full system development life cycle, ensuring delivery success using Agile/Scrum methodology and Team Foundation Server (TFS).
- Focusing on core consumer banking and Worked throughout the SDLC, which included requirements, specifications, design, analysis and testing utilizing AGILE methodology.
- Closely working the Product owners and Scrum Master of the different teams in Scrum & Agile Software.
- By using Agile scrum methodology, create and maintain data model/architecture standards, including master data and change management
- Assigned tasks among development team, monitored and tracked progress of project following Agile methodology.
- In depth knowledge of Oracle 9i based application database tables, schemas, views in DML, DDL & DCL statements.
- Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
- Served as conduit for managing system requirements between the business and the software development team.
- Conducted user interviews and documented business and functional requirements.
- Contributed to the (Enterprise Content Management) ECM migration project, encompassing architecture, development and implementation.
- Completed the documentation of Claims Scenario’s for the source system
- Was responsible for the hardware, software, upgrades, and patching of SharePoint equipment.
- Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
- Created use case scenarios and documented work flow and business process.
- Documented requirements associated change requests with requirements and connected requirements with Use cases.
- Understood the requirements of the Sales and Marketing team
- Done the setups required for sales quoting.
- Updated the impacted MS Access tables.
- Responsible for implementing restricted access to claims data.
- Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
- Developed the systems implementation project management plan with milestones and steps from procurement of vendors to project implementation and maintenance.
- Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing.
Environment: Windows XP Professional, Oracle9i, MS Access 2000, MS SharePoint, MS Excel, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, UAT/BAT, MS Office suite, MS Visio 2003, Agile.
Confidential - Cleveland, OH
Sr. Business Analyst
Responsibilities:
- Prepared the project release schedule, and detailed project plan specifying the timeframe for requirement gathering, documentation, development and testing and identify the key deliverables.
- Written complex SQL queries involving joins, functions and pre compiled stored procedures on Oracle database.
- Experienced with the procedures of Banking & Regulatory Compliances - Anti-Money Laundering (AML), Customer Identification Program (KYC/CIP), CCAR Regulatory Reporting, Dodd-Frank Act.
- Coached inexperienced team members transitioning from waterfall techniques in Agile concepts and processes, and mentored new Scrum Masters on other teams. Maintained contact with other Scrum Masters for exchange of ideas, best practices, and continuous improvement in Agile practices.
- Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
- Managed changes to baseline requirements through effective application of change control processes and managed the overall test process, according to the Agile Scrum methodology.
- Analysed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
- Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
- Wrote Business Requirements, analyzed them and tested them.
- Worked with ECM (Enterprise Content Management), that allows everyone in the company to access, manage, and review documents, templates, media, and other information assets.
- Implement SharePoint for team collaboration and Document Management.
- Performed in-depth testing of the service development system by documenting requirements and specifications for a world-wide deployment of SharePoint personal sites, workgroup portals and shared data repositories.
- Clear understanding of oracle database schemas and application’s tables and its constraints.
- Designed the process flow diagrams for flow of information and report creation process.
- Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
- Conducted RAD sessions for the report users, requestors, and the developers.
- Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
- Documented all the changes in the initial templates and was responsible for Release Management.
- Reviewed Requirements & deliverables for delivery timeline.
- Worked on following applications Enterprise Architect, Toad, PlanView (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project)
- Involved in the formulation of Business Requirements Document (BRD) after all business requirements were defined clearly.
- Clear understanding of application field level mapping to corresponding oracle database tables and corresponding columns for various user screens.
- Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on Ms Access.
- Worked on Report Re-engineering Project and made enhancements to the system flow.
- Modified System flow diagrams using SDLC.
- Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
Environment: MS SharePoint, Windows, MS Access, Oracle, UAT/BAT, Mantis Defect Tracking, UML, MS Office, MS Visio, Scrum, Agile.
Confidential, NYC, NY
Sr. Business Analyst
Responsibilities:
- Gathered user requirements and directed developers for practical deliverables.
- Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market and reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
- 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.
- Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint. Used the ODBC/SQL to migrate all data to one database before uploading it into the Knowledge Base.
- Designed workflows and allocated permissions within MS SharePoint.
- Gather final requirement and draft the BRD and Business Data Flow Diagrams
- Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
- Worked with the software architects / developers to ensure that the applications conform to customer requirements.
- Used Rational Unified Process (RUP) for streamlining the team’s development activities.
- Followed the UML based methods using Rational Rose to create: Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
- Worked extensively with insurance brokers
- Participated Testing and Evaluation of projects at established integration points to assess progress and identify key functionality issues.
- Tracked UAT issues/bugs and prepared reports.
- Performed job of contact point for all stakeholders (business, legal, compliance, development).
- Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project
Environment: UNIX, MS Power Point, MS Excel, MS SharePoint, Rational Rose, System Analysis, Load Runner, Crystal reports, SQL, Agile, Scrum.
Confidential, CHARLOTTE, NC
Business Analyst
Responsibilities:
- Prepared the Process flows, Activity Diagram, Business Requirement Documents (BRD) and Functional Requirement Documents
- Worked on the Performer functionality which interacts with the major life cycle
- Prepare Business Requirement Document and supporting documents.
- Conduct through impact analysis of the new requirements on the existing system.
- Breaking down the requirements of the Business partners into Functional Requirements
- Continuous interaction with the end users of the system - the Business Partners to understand the business aspect of the system.
- Extensively executed Complex SQL queries to perform data validation and check data integrity.
- Build up SQL queries to get data from both source and destination and to compare them in the test bed.
- Attend test conditions and test cases review sessions organized by the testing teams.
- Updated the test cases based on the recommendations from the development team
- Performed UAT regression testing after the defects were fixed.
- Worked closely with the senior tester and Project Manager and discussed the scope of testing activities.
Environment: MS Office, Visio, SharePoint, UNIX, Windows, Load Runner, OBIEE, Oracle, My SQL, SQL, FS Pro, Adobe Pro, Windows, Unix, XML, HTML, Clear Quest.