We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

4.00/5 (Submit Your Rating)

New York, NY

SUMMARY

  • Accomplished Business Analyst with 8 years of experience in Requirement Gathering, Analysis and Communication; Process Analysis Planning and Monitoring; Enterprise Analysis; Solutions Assessment and Validation; Enterprise - wide Systems Implementation; Testing and Maintenance.
  • Strong domain knowledge and work experience in Finance (Mortgage, Loan, and Insurance) and Banking (Retail, Private, Commercial, and Investment) and Telecom.
  • Excellent skills in analysis, design, development, and implementation of ETL and reporting components.
  • Professional experience in all phases of System Development Life Cycle (SDLC) methodologies including Scrum, Waterfall, Spiral, and Rational Unified Process (RUP).
  • Extensive experience in conducting Risk, SWOT, PESTLE, Impact, GAP, Feasibility, and Cost-Benefit Analyses.
  • Expertise in designing visual models such as Activity, Business Process, Cause-and-Effect, Class, Pareto, Data Flow, Sequence, and State-Machine diagrams, using Unified Modelling Language (UML).
  • Accomplished in Software Testing Life Cycle (STLC) and in User Acceptance Testing (UAT), Sanity, Performance, Usability, Integration, Regression, Graphic User Interface (GUI), System, Load, Unit, and White Box Testing.
  • Expertise in developing artifacts such as Use Cases, Test Cases, Business Requirements Documents (BRD), System Requirements Specifications (SRS), Risk Register, Prototypes, Requirements Traceability Matrix (RTM), Wireframes, Mockups, and Workflow and State Models.
  • Experience in conducting Joint Application Development (JAD) and Requirement Gathering Sessions, Scrum Framework Meetings, Structured Walkthroughs with end users, developers, Subject Matter Experts (SMEs).
  • Expertise in generating DDL, DML, DCL, and DCL queries in SQL and developing database objects such as Views, User Defined Functions, Triggers, Indexes, Cursors, and Stored Procedures using T-SQL.
  • Expertise in creating Tabular, Drill Down, Drill Through, Chart, Ad Hoc and Cross Tab reports using SSRS and Tableau.
  • Good knowledge in designing and implementing OLAP cubes, Dimensions, and Fact Tables for snowflake/ star schemas using SSAS and in developing Dashboards and Scorecards using multiple KPIs using SSRS.
  • Strong project management skills including planning, project scheduling, work breakdown structures, resource estimation and allocation, monitoring and reporting.
  • Extensive Knowledge of Financial Analysis, Forecasting, Valuation, Planning and Budgeting.
  • Excellent communication, problem-solving, critical thinking, conflict resolution, facilitation, and documentation skills
  • Proven track record in producing high quality work under tight deadlines and in multi-tasking to meet business goals

TECHNICAL SKILLS

Microsoft: MS Excel, MS Word, MS Power Point, MS Outlook, MS Project (w/ Gantt Charts), MS Visio, MS SharePoint 2007/10/13

Business Intelligence/ ETL: Cognos 10 BI Tools (Report and Query Studio), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Tableau, QlikView

Database: MS SQL Server 2005/2008/R2/ 2012, MS SQL Server Management Studio

Languages: Visual Basic 6.0, T-SQL, PL/SQL, UML

Testing: QuickTest Professional (QTP), LoadRunner

Technologies: IBM Rational RequisitePro, IBM Rational Rose, Rational ClearQuest, Rational ClearCase

Operating System: Windows 1998/ 2000/ 2007/ XP/ 7/ 8, UNIX (Solaris, Linux)

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Business Analyst

Responsibilities:

  • Developed UML diagrams, including Use Case Diagrams, Activity Diagrams, Class Diagrams, Data Flow Diagrams, BusinessProcess Diagrams, Wireframes, Sequence Diagrams, using MS Visio and Rational Rose.
  • Created Requirement Traceability Matrix (RTM) to keep stakeholders informed of the project status.
  • Created Problem Statement Matrix and conducted GAP Analysis to identify business opportunities and problems.
  • Reviewed current Service Level Agreements (SLAs) to develop Interim Business Impact Analysis (BIA), Feasibility Analysis, and To-Be Use-Case diagrams.
  • Conducted User Interviews and Joint Application Design (JAD) sessions to understand client business processes.
  • Gathered high-level requirements through brainstorming and requirements workshops. Developed Business Requirements Documents (BRD) and Functional Specifications Documents (FSD) for third-party integration.
  • Assisted Product and Channel Managers, Development and Operations teams to build efficient roll-out strategies
  • Adopted Agile (Scrum Framework) methodology of System Development Life Cycle (SDLC) to collect and document requirements and facilitate project planning and meetings.
  • Facilitated Daily Scrum Meetings to improve the efficiency of each sprint and assisted Scrum Product Owner in creating and updating Sprint Burndown Chart.
  • Developed Work Breakdown Structure (WBS) using MS Project to allocate resources and estimate project schedule.
  • Developed Test Cases, Test Plans, and Test Scenarios and performed Unit Testing and User Acceptance Testing (UAT) for cloud-computing business requirements and technical specifications.
  • Conducted value chain analysis to determine Critical Success Factors (CSFs) and interacted with Business Process Owners to ensure that requirements support the attainment of CSFs.
  • Developed Business and Process Flow Diagrams to analyze the As-Is and To-Be models of business processes.
  • Created different reports such as Cross Tab and Parameterized reports, using SSRS and delivered the reports to concerned business users and internal stakeholders.
  • Performed Systems Study and developed Entity Relationship Diagrams and Table Structures.
  • Developed User Manuals & Training Guides for User Acceptance Testing (UAT) and deployment for end clients with step-by-step instructions and appropriate UI screenshots.
  • Developed Tables, User-Defined Functions, Triggers, Views, Indexes, and Stored Procedures to perform different computations on the integrated data using T-SQL.
  • Created Project Charter defining project objectives, business needs, critical to quality (CTQs), scope, impacts, constraints, assumptions and dependencies.
  • Created Logical Data Models, Business Requirement Document and Functional Specifications Documents.
  • Designed and analyzed OLAP cubes in SSAS using Snowflake and Star Schema designs.
  • Created SSRS and MS SharePoint 2010/2013 reports including, Drill Through, Tabular, and Ad Hoc Reports.
  • Analyzed and executed various reporting objects, including Facts, Attributes, Hierarchies, Filters, Prompts, Groups, Transformations, and Parameters in Tableau.

Environment: Windows 7.0, Mockup Screens, MS SQL Server 2012, T-SQL, IBM Requisite Pro, IBM Rational Rose, SSRS,MS Visio, MS SharePoint 2010, MS Access, MS Excel, MS Project, SQL Profiler, MS Visual Studio 2010, QTP, UML, Agile Methodology, Visual Basic 6.0, HP Service Desk, Tableau, Teradata Database.

Confidential, New York City, NY

Sr. Business Analyst

Responsibilities:

  • Gathered business requirements through review of existing artifacts, prototyping, job shadowing of Account Agents and served as a liaison between Claims Approval and IT team in analyzing and documenting business needs.
  • Assisted testers in planning test strategies and performing defect tracking, using Rational ClearQuest.
  • Performed Smoke (Sanity) Testing to test the basic functionality of POBMS application.
  • Formulated high level business needs and performed Gap analysis between the "As-Is" and "To-Be" model.
  • Developed Risk Register/ Risk Log to perform project risk assessment by capturing and prioritizing risks, and supported the Program Manager in developing effective risk mitigation plans.
  • Designed Business Use-Case diagrams to identify the business processes and actors impacted by the web system.
  • Reviewed and analyzed the Business Requirements Document (BRD) to derive the Functional Specifications Document (FSD) and System Requirement Specification (SRS).
  • End-to-end experience in designing and deploying data visualizations using Tableau.
  • Conducted structured walkthroughs of BRD and FRD documents to Business Process Owners and obtained sign-offs.
  • Designed Graphical User Interface (GUI) screen designs in MS Visio, conducted screen reviews with development team for determining usability and technical approval, and finally updated the designs as per recommendations.
  • Worked closely with the Internal Auditors to review the compliance requirements and ensured appropriate documentation was in place.
  • Created Cause-and-Effect Graph to identify high priority areas of Property Owners Claims, for process improvement.
  • Prepared and updated System Change Request (SCR) form, assisted Project Manager in developing Change Schedule, and conducted steering meetings with Change Advisory Board (CAB) to obtain their approval.
  • Designed Project Scope & Need Analysis documents from requirements gathered through JAD and observations.
  • Worked with UX team to finalize user interface elements and screen behavior to ensure uniformity across the product.
  • Performed SQL queries, Unions/Joins, Stored Procedures, Triggers to retrieve and validate data, using PL/SQL.
  • Created Activity diagrams, Sequence diagrams, Process Flow diagrams, and Mock Screens in MS Visio.
  • Reviewed the UX screens and final prototypes to envision the indicative UI screen.
  • Prepared UAT Test Scripts and worked closely with Quality Assurance Lead to perform UAT Testing.
  • Provided analytical insights to senior management regarding KPIs and performance metrics analyzed using Cognos Report and Metric Studio.

Environment: MS SQL Server 2008/R2, MS Project, MS SharePoint 2010, Tableau, MS Access, MS Visio, LoadRunner 9.10, IBM Rational Rose, MS Visual Studio 2010, Windows XP/7.0, HP Quality Center 9.2, IBM Requisite Pro, Rational ClearQuest.

Confidential, Champaign, IL

Business Analyst

Responsibilities:

  • Designed Mockup Screens and Use case diagrams using MS Visio to present a better view of the system and enable the technical team to identify the key processes
  • Created project execution roadmap identifying project structure, outlining project phases, project prioritization and project kick off.
  • Supported Architects in the creation of Rough Order of Magnitude (ROM), developed the Project Requirement Documents (PRD), Functional Specification Document (FSD) and Non-Functional Requirement Documents.
  • Developed Interaction diagrams, Communication diagrams, and Process Flow diagrams using MS Visio.
  • Conducted Focus Groups of users to elicit user requirements for enhancement of the billing monitoring application.
  • Created Project Functional Specifications (PFS) detailing software requirements using Context diagram, System Use Cases, and detailed featured requirements.
  • Created Use Cases and Business Use-Case Models after analyzing the project scope and the business processes.
  • Established Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace the completeness of requirements in different SDLC stages.
  • Assessed risks and opportunities associated with product life cycle, using Porter’s 5 forces, SWOT analysis, TOWS Matrix, and BCG Industry Attractiveness Matrix.
  • Coordinated the execution of Unit Testing, System Integration Testing (SIT), Performance & Service level testing and User Acceptance Testing (UAT).
  • Utilized Unified Change Management tool to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects and to streamline the defect/change tracking process.
  • Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right Joins to update the database and retrieve data for data analysis and validation.
  • Reviewed the application with Branding and Legal teams to ensure adherence to set corporate guidelines.
  • Created Dashboards and Scorecard reports involving KPIs using SSRS and MS SharePoint.
  • Developed SSIS packages using Fuzzy Lookup, Pivot Transformation, and Derived Column to cleanse data.
  • Worked with the QA team to create Test Plan and Test Cases and conduct Unit, Integration, and System testing.
  • Documented Test Plans, Test Scripts, Log Defects, and Requirements and uploaded to HP Quality Center for future follow up and bug fixing purposes.
  • Participated in weekly Conference Room Pilot (CRP) sessions, to identify software workarounds.
  • Designed and deployed rich graphic visualizations with Drill Down options and prepared Dashboards, using Parameters and Calculations in Tableau.

Environment: MS SQL Server 2008/R2, Oracle 10g, MS Project, MS SharePoint 2010, HP Quality Center, Crystal Reports, SSRS, SSIS, Windows XP, QTP, MS Visio, UML, Agile Methodology, RUP, Rational ClearCase, PL/SQL, QlikView, Teradata.

Confidential

Business Analyst/ Jr. Finance Manager

Responsibilities:

  • Created Use Case Diagrams, Class Diagrams and Interaction Diagrams using MS Visio and Rational Rose.
  • Prepared Process Flow Diagrams, Mockups and conducted Gap Analysis to compare the current and proposed functionalities of the system
  • Designed Meeting Work Plan and facilitated virtual project meetings to validate requirements with the concerned Subject Matter Experts (SMEs) and IT Team during the entire project.
  • Extensively used MS Excel (Vlookup, Macros, Pivot Tables, etc.) for data validation and creation of Mock-up reports
  • Reviewed test results and prepared Test Scenarios and Scripts for Performance, Usability, and Regression Testing.
  • Conducted JAD, RAD and Interview sessions with the management and users to gather and communicate business requirements and understand the problems and challenges.
  • Identified major problems and constraints of the existing business system using Problem Statement Matrix and ensured they are accurately documented and traceable to the Business Requirement Document (BRD)
  • Developed Business Case Document highlighting the need for a new system and its impact on the project scope.
  • Conducted requirements gathering sessions with the business user to collect Business Requirements, Data Requirements, and User Interface Requirements.
  • Managed UAT Testing and developed and reviewed QA Test Strategies and Test Plans for appropriate test coverage.
  • Incorporated Rational Unified Process (RUP) to create Business Requirement Specifications using MS Visio.
  • Analyzed and mapped the As-Is business processes, compared them to the To-Be state to define the Gap, and then created new Process Flow Diagrams.
  • Assisted the Program Manager in defining, documenting, and implementing success milestones for the project's critical path and determining target dates for the complete SDLC.
  • Facilitated Sprint Planning as Scrum Master for multiple Scrum teams to ensure successful completion of sprints.
  • Identified and documented Functional and Data Requirements, and User Stories as per the Scrum framework.

Environment: MS SharePoint 2007, MS Visio, MS Project, Rational Rose, Rational Requisite Pro, Windows 2000/XP, MS Visual Studio 2008, MS SQL Server R2, UML, Agile, RUP, Oracle 10g, LoadRunner 9.10, Siebel Web 8.0.

Confidential

Business and Data Warehouse Analyst

Responsibilities:

  • Prepared SWOT, Cost Benefit analysis and Problem Statement Matrix to identify the business challenges and risks.
  • Used UML guidelines to prepare Use Cases and Activity Diagrams from the gathered requirements, using MS Visio.
  • Worked closely with QA lead to solve testing issues while conducting Unit and System testing.
  • Created and documented deliverables including requirements definitions, hosting and maintenance agreements, RFPs, engagement contracts, strategy decks, style guides, creative briefs, wireframes and project post-mortems.
  • Created Drill Down, Cross-Tab, and Bar Diagram reports using SSRS and deployed reports to MS SharePoint 2007.
  • Analyzed functional requirements and created Use Cases, high and low level Sequence and State Chart Diagrams.
  • Created User-Defined Functions, Triggers, and Stored Procedures to meet business requirements, using T-SQL.
  • Facilitated JAD Sessions with the System Architects, Developers, Database Administrators, and QA team through for defect resolutions during development and testing phases.
  • Involved in the analysis and design of functional specifications to identifytestrequirements and design Test Cases, Test Scripts, andTest Datawith expected output.
  • Designed Functional Decomposition Chart to be used as input for the initial design of the web architecture.
  • Assisted Project Manager/ Scrum Product Owner in facilitation of Spring Review and Retrospective meetings.
  • Conducted Joint Application Design (JAD) sessions to gather and review domain models, process flows, requirement timelines, and component delivery milestones.
  • Monitored the Estimations and User Stories in Scrum Product Backlog through the iterations and scrum sprints.
  • Coordinated with Business Partners to review the status of the project throughout the phases of Load Testing, UAT, Regression Testing, Soft Code Freeze, Hard Code Freeze, and Implementation.

Environment: SQL Server 2005, SSIS, T-SQL, SSRS, SSAS, MS Visual Studio 2005, Windows 2000/XP, MS Excel, MS Access, Cognos BI 8.0 (Report and Metric Studio), Java, Agile, RUP, Crystal Reports, HP Quality Center 9.2, MS Project, C++

Confidential

Quality Assurance Analyst/ Tester

Responsibilities:

  • Executed SDLC cycle from inception to deployment with regards to testing (Requirement Analysis, Test Planning, Test Cases, Script Development, Test Execution, Test Reporting, Test Result Analysis and Defect Retesting)
  • Developed complex SQL scripts to validate data integrity in the application, using various DML and DDL commands.
  • Used JIRA to track and follow-up on defects with the QA and SAP teams in different builds.
  • Participated in Requirement Review Meeting with Business, Development Team Manager and SMEs. Worked closely with the end users and technical team to ensure best practices in testing methodologies.
  • Assisted Sr. QA Manager in conducting informal sessions with testing team to resolve open incidents and issues.
  • Create Test Cases to conduct White Box Testing, Positive and Negative Testing of the application.
  • Conducted analysis for change requests and requirement walkthroughs and advised concerned Project Managers and Business System Analysts on the impacts of the changes in migrating data solution.
  • Write detailed Test cases detailing the step by step navigation, data input, and expected results, for Load Testing.
  • Logged system defects in Rational ClearQuest and tracked the issues identified during Functional Testing.
  • Participated in various meetings and discussed enhancement and modification request issues and constraints.
  • Assisted Lead Business Analyst in the creation of Use Case Diagrams, Process Plow Diagrams and GUI designs.
  • Participated in brainstorming sessions on Quality Analysis, Manual and Automated Testing and defect tracking tools.
  • Created Logical Data Models, Business Requirement Document and Functional Specifications Documents.
  • Assisted the Project Manager in organizing meetings with Developers and Quality Analysts to discuss business requirements, test planning sessions, resource allocation, project sizing, business approvals and release dates.
  • Gathered functional requirements and created vision, scope, and other artifacts during the inception phase.
  • Participated in Business Requirement Definition (BRD) workshops along with clients and Subject Matter Experts.

Environment: LoadRunner 8.0, QTP, MS Office (SharePoint 2002, Visio, Excel, Access, Project), HTML, XML, Agile Methodology, UML, Windows 2000/XP, SQL Server, HP Quality Center 10.0, Oracle 9i/ 10g.

We'd love your feedback!