We provide IT Staff Augmentation Services!

Business System Analyst Resume

Fort Worth, TX

SUMMARY:

  • Proactive highly organized and result - driven Certified Scrum Master, Business Analyst / Business System Analyst with over seven years of professional working experience with the ability to identify, analyze and transform the data into a meaningful form, with the strong understanding of Finance (Banking), Insurance, Retail, Telecommunication and Security operational system
  • Hands on experience in BVAT (Business Validation Acceptance Testing), PAT (Production Acceptance Testing), user acceptance testing (UAT) and system integration testing (SIT)
  • Equipped with strong analytical, detail orientation and communication skills which enabled me to perform exceptionally in all stages of Software Development Life Cycle (SDLC) in both waterfall and agile/scrum methodologies
  • High level of expertise in asset and portfolio management, derivatives (Swaps, Options, and Futures), fixed income, Trade Life Cycle and Investment Banking
  • Possess excellent communications skills to carry out both one-on-one and focus group interviews with SME’s and different business unit teams on eliciting detailed requirements
  • Experience in facilitating Joint Requirement Planning (JRP) sessions with Business Users, conducting and gathering requirements through Joint Application Development (JAD) sessions
  • Ability to analyze and document the business requirements in the form of Business Requirement Document (BRD), Functional Requirement Document (FRD) / Functional Specification Document (FSD), Requirement Traceability Matrix (RTM), Request for Proposal (RFP)
  • Facilitated Scrum events such as Backlog Grooming, Sprint Planning, Daily Scrum Meeting, Sprint Review and Sprint Retrospective Meetings for every Sprints as a Scrum Master
  • Ability to train/coach customers, teams on Scrum Artifacts and Scrum Techniques.
  • Proficient in Unified Modeling Language (UML) diagram for creating Use Case Diagrams, Activity Diagrams and Sequence Diagrams using MS Visio
  • Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis
  • Demonstrated robust User Interface (UI) and User Experience (UX) knowledge, and ability to manage and develop wireframes, and working prototype using Axure and iRise
  • Ability to understand the requirements for complex SQL queries and procedures and can write complex SQL queries on SQL Server Management Studio.
  • Excellent project management skills with solid hands on experience on Project scoping, Resource Allocation, Scheduling, Budgeting and Drafting Remedy Procedures using MS Project.

TECHNICAL SKILLS:

SDLC Methodologies: Waterfall, Agile, Agile-Scrum

Business Skills: UML, Gap Analysis, SWOT Analysis, BRD, FRD, RFP, RTM, User Stories, Prototyping, JAD sessions, Requirement gathering

Front End Tools: JIRA, SharePoint, ServiceNow, MS Project, MS Office, SFDC(Salesforce)

Modeling Tools: MS Visio, Wireframes, Mock-Up Screen

Databases: My SQL, SQL Server 2008 R2/2008/2005, Microsoft Access

Data Warehousing: Data Modeling, ETL Mapping, Pivot, Reporting

Operating Systems: Windows XP/Vista/7/10, UNIX

Languages: HTML, JavaScript, XML, T-SQL, PL/SQL, C/C++

Design Tools: Adobe Photoshop, iRise, Axure, MS Visio

Testing Tools: HP ALM, HPQC, SOAP UI, TopTeam

Other / Reporting Tools: Salesforce CRM, Google Analytics, MS Excel 2003/2007, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Business System Analyst

Responsibilities:

  • Communicated with business partners in weekly meetings, collected deliverables for key milestones, updated test scripts on scope changes, analyzed test plans from PMO work streams and manipulated large data
  • Drafted and updated slide decks, mapped governance and process flows diagrams for future testing and measuring project progress utilizing Excel spreadsheet
  • Writing detailed UAT plan documents for several projects related to meeting regulatory reporting requirements
  • Improved the organization’s quality business goals and service key performance indicators through monitoring, analyzing, and facilitating improvements to processes and procedures
  • Developed and maintained quality databases, collected, analyzed related data, and presented reports to the Quality Management (QM) Committee
  • Advised the performance of the quality management system, produce data, and report on performance, measured against set standards
  • Used Salesforce and market research data to generate insight about client activities
  • Made the lists of impediments where team were facing from the Daily Scrum Meeting and notified PO in timely manner. Also helped the scrum team to solve any conflict resolution after the Daily Scrum Meeting
  • Conducted Gap Analysis of the AS-IS and TO-BE processes to identify and validate the requirements
  • Developed work process flow charts, tabulate the data, and make recommendations for process improvements based on outcomes.
  • Analyzed and reported on Company financial performance relative to competitors and benchmarks in the industry
  • Analyzed client portfolio/investment performance trends and made recommendations based on available options
  • Produced various ad hoc and financial reports for internal and external users.
  • Responsible for drafting high level requirement documents (BRD) for industry wide distribution detailing system requirement and modification required
  • Worked on QA Team to ensure that requirements were met: Developing thorough test plans, such as Acceptance, Regression and Performance testing

Environment: Windows, Gap Analysis, SOAP UI, JIRA, MS Office Suite (Excel, Word, Power-point, Access), MS Project, SharePoint, Salesforce, SQL & SQL Server, SDLC, Agile, Waterfall, Object Oriented Design, Visio

Confidential

Sr. Business Analyst / Scrum Master

Responsibilities:

  • Worked on Reporting, Manual Adjudication and Retail Operation (RO) in Lending, Credit Card, OSFI, and Mobile Banking Application to articulate business requirements to project stakeholders
  • Gathered and analyzed the requirements by interviewing business teams, users and from Project Definition Document (PDD) which helped me to understand the specifications and service level requirements
  • Created, verified and validated Gap Analysis to ensure streamline communication and achieved the objectives within the organization
  • Analyzed the root cause of each individual issues / bugs and navigated to the proper team using ServiceNow
  • Wrote Use Cases and embedded traceability using TopTeam to create user friendly systems for all the SMEs and stakeholders to save time
  • Created User Stories and led the Planning Poker game to estimate them in Sprint Planning and Backlog Grooming meetings. Also, helped product owner to prioritize user stories based on business value
  • Developed several prototypes to demonstrate the functionalities of newly build system to the business
  • Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio
  • Made the lists of impediments where team were facing from the Daily Scrum Meeting and notified PO in timely manner. Also helped the scrum team to solve any conflict resolution after the Daily Scrum Meeting
  • Analyzed data from different systems such as mortgage data, various loan data, line of credit data from database extracts along with the customer data information and developed the mapping document for the ETL process
  • Worked with and handled SSI (System to System Integration), UX, Developer and QA (onsite and offshore) team to validate the conceptual concept of stakeholders from every perspective
  • Prepared deck to facilitate JAD sessions and provided meeting minutes immediately to share the objectives and next steps of the project to the key stakeholders
  • Created and updated action log in SharePoint immediately following the session for internal review to be aware of project status and any outstanding task of errors
  • Analyzed queries and handled change request, risk as per requirements determining the needs
  • Provided and tested scenarios in SIT, UAT for Test Cases to accelerate testing process for the system and delegated the analyzed defect to QA and developer teams
  • Mitigated risk factors through careful analysis of financial and statistical data. Anticipated and managed change effectively in rapidly evolving business environment

Environment:: Scrum, Gap Analysis, UML, ServiceNow, HP ALM, HPQC, Google Analytics, Axure, MS Office Suite (Excel, Word, Power-point, Access), MS Project, SharePoint, MS Visio, JIRA, SOUP UI

Confidential

Sr. Business Analyst / QA Analyst

Responsibilities:

  • Interviewed Subject Matter Experts (SMEs) to understand the goal, customer segments, and priorities to enhance the application system
  • Communicated with Claim management team and underwriting team to understand the risk factors, trends, client profile and develop the Business Requirement Document (BRD)
  • Analyzed large-scale data coming from different sources such as Claims Data Warehouse, Salesforce, Home Office Data Repository to identify the trends and risks
  • Led teams across the technical prospect and defined scopes, processes and tools best suited to each project
  • Developed KPI’s and ad-hoc metric for different types of reporting including matrix reporting allowing the business to understand their status resulting in time and cost savings while increasing revenue
  • Conducted Gap Analysis of the AS-IS and TO-BE processes to identify and validate the requirements
  • Worked in Agile environment using JIRA, attended sprint plan meetings, daily standup meetings
  • Involved in analyzing Business Requirements (BRD) and Functional Design Documents (FDD), user stories to develop Test strategy, Test Plan, Test Scenarios and Test Cases
  • Achieved correctness and completeness of test cases, conduct Test Case Walkthroughs as well as collaborate with business analysts to eliminate ambiguity and inconsistency
  • Reviewed and analyzed Business Requirement Documents (BRD), functional and eligibility specifications and converted business requirements and specifications into a QA test plans, cases, and test scripts. Reviewed test results and report defects in Quality Center
  • Developed and maintained test plans for manual and automated test scripts for integration, functionality and daily validation testing to assure quality of the deliverables
  • Performed Unit testing, regression testing against different layer of databases to perform analysis and business reporting
  • Prepared and reviewed functional and integration test cases on production fixes and project related fixes to assure quality of the deliverables
  • Developed and executed software test plans and wrote SQL queries for gathering test data from database and delegated to onsite and offshore team
  • Performed backend testing using SQL queries to check backend data and involved in testing using SOAP UI tool
  • Provided progress and daily status reports to the project manager utilizing MS Excel application for reporting
  • Followed up with Developer team to make sure defects raised in ALM are fixed based on priority

Environment:: Scrum, Gap Analysis, ServiceNow, UML, HPQC, SOAP UI, JIRA, MS Office Suite (Excel, Word, Power-point, Access), MS Project, SharePoint, MS Visio, Salesforce, SQL Server Management Studio 2008 R2

Confidential

Business System Analyst / Data Analyst

Responsibilities:

  • Created workflow diagrams in Visio to show the data/process flow in the system and documented
  • Led teams across the technical prospect and defined scopes, processes and tools best suited to each project
  • Created data mapping documents for different SQL database tables vs. columns, declared variables
  • Developed effective working relationships with the client’s team to understand the support requirements resulting in meeting the client’s needs
  • Developed user stories after gathering and validating system requirements from the team members
  • Defined the system potentiality and functionality to monitor and control over the physical environment of global datacenters, including cameras, personnel screening, fences and barriers and multi-factor authentication for physical access
  • Performed Identity and behavioral analysis to highlight abnormal activity to ensure that potential threats were assessed
  • Developed and maintained quality databases, collected, analyzed related data, and presented reports to the Quality Management (QM) Committee
  • Conducted and facilitated backlog refinement session and assisted product owner to prioritize user stories based on business value
  • Led sprint planning session during planning and product demonstration after completion of sprint
  • Maintained and updated customer database and tracked their expense report
  • Maintained positive and clear communication with all the stakeholders to ensure team cohesiveness
  • Conducted gap analysis between the present system and the target system to determine the needs of future process and implementation
  • Created several SQL scripts and testing queries to perform data analysis and functionality testing
  • Developed KPI’s for different types of reporting including matrix reporting allowing the business to understand their status resulting in time and cost savings while increasing revenue
  • Created business cases to maintain cost/benefit, probability/impact matrix

Environment:: Gap Analysis, UML, HPQC, Google Analytics, Axure, MS Office Suite (Excel, Word, Power-point, Access), MS Project, SharePoint, MS Visio, SQL Server 2008 R2 (SSMS)

Confidential

Sr. Business Analyst / QA Analyst

Responsibilities:

  • Conducted Gap Analysis of the AS-IS (Current State) and TO-BE (Future State) processes to identify and validate the requirements.
  • Facilitated effective internal/external team collaboration and generated enthusiasm among team members and other stakeholders
  • Prepared graphical depictions of Use Cases, Use Case Diagrams, Activity Diagrams and creation of technical design (UI screen) using Microsoft Visio
  • Prepared well-designed test cases based on analyzed product requirement documents, functional, eligibility specifications and performed the execution of test cases, reviewed test results and report defects in Quality Center
  • Developed and maintained test plans for manual and automated test scripts for integration, functionality, daily validation testing to assure quality of the deliverables
  • Conducted integration testing focused mainly on the interfaces & flow of data/information between the module and led Defect Triage calls and delegated to onsite and offshore team
  • Created and updated action log, Test Plan in SharePoint immediately following the session for internal review to be aware of project status and any outstanding task of errors
  • Analyzed queries and handled change request as per requirements determining the needs

Environment:: Gap Analysis, UML, HPQC, Google Analytics, MS Office Suite (Excel, Word, Power-point, Access), MS Project, SharePoint, MS Visio

Confidential - Paramus, NJ

Business / Data Analyst

Responsibilities:

  • Conducted various SMEs from different departments by one on one or by group settings to elicit requirements as per their prioritization and documented in BRD, SRD and IRD
  • Performed Gap Analysis of the AS-IS (Current State) and TO-BE (Future State) processes to identify and validate the requirements.
  • Analyzed data from different systems such as mortgage data, various loan data, line of credit data from database extracts along with the customer data information and developed the mapping document for the ETL process
  • Led high level requirement gathering activities involving elicitation practices such as JAD sessions, focused groups, one-to-one Interviews, and document analysis
  • Synthesized all the business requirements in phases and based on that developed the functional and non-functional requirement documents to develop the automation process
  • Developed use data-flow diagram, activity diagram, and state transition diagram using MS Visio and prepared the use case document
  • Created requirements traceability matrix (RTM) and tracked solution validation to requirement matrix
  • Analyzed different situations in the processes to identify improvement areas and scope of automation to reduce the manual errors and to add value to the reporting
  • Developed strategies with Quality Assurance group to implement test cases in Rational Quality Manager for stress testing

Environment:: Waterfall, MS Office (Excel, PowerPoint, Word), MS Project, Quality Manager, SQL Server Management Studio 2008 (SSMS), MS Visio, SharePoint 2010

Hire Now