Sr. Business Systems Analyst Resume
Seattle, WA
SUMMARY
- International SCRUM Institute Certified SCRUM Master and Business Systems Analyst with 8+ years of experience working across various domains ranging from Telecom, Insurance, Finance, and Banking sectors.
- Expertise in implementing various phases of SDLC methodologies such as Waterfall, SCRUM, and hybrid methods.
- As a SCRUM Master adept in leading cross - functional and self-organizing teams. Skilled in facilitating SCRUM process and SCRUM Ceremonies including Daily SCRUM, Sprint Planning, Sprint review, Sprint retrospective and Backlog Refinement to improve teams’ performance and dynamics.
- Skilled in conducting and facilitating Requirement Gathering Activities using diverse elicitation techniques including, but not limited to Requirement workshops, Interviews, Prototyping, JAD Sessions, Brainstorming, and others.
- Proficient in preparing, authoring/reviewing different requirement artifacts like Business Requirement Document (BRD), Functional Specification Document (FSD), Software Requirement Specification (SRS), and Graphic User Interface (GUI) and Requirement Traceability Matrix (RTM) using tools like Rally.
- Described and documented critical cross-functional business process flows like As-Is/To-Be processes, Business Process Re-engineering (BPR), Business Process Modelling (BPM) using techniques such as GAP Analysis.
- Strong experience in Application Design including Prototyping, Screen Mock-ups, Wireframes, UI design. formats and Unified Modeling Language (UML) diagrams such as Use Case diagrams and Sequence Diagrams.
- Experienced in SOA, Web Services, XML, REST, JSON, API, client side, and server side validation. Have extensive knowledge on SOAP, REST (GET, POST, PUT and DELETE) methods, XML and JSON.
- Knowledge of Data Warehousing architecture, implementation approaches, schemas, and dimensional modeling. Experience in Data Analysis, Data Mapping, Data Modeling, Entity Relationship, and other diagrams.
- Strong knowledge of SQL, data analysis and data validation using SQL.
- Assisted with the development and execution of detailedsystemand user acceptance test plans, test cases, and test scripts for manual and automated testing and documented defects using HP QC and HP ALM/UFT and other tools.
- Extensive exposure to End-to-End testing, Black-Box testing, Smoke testing, and User Acceptance testing (UAT).
- Acted as a liaison between the Business teams, Architecture Boards and all technology teams and facilitated cross functional interaction on Business Rules and logic.
TECHNICAL SKILLS
SDLC Methodologies: Waterfall, Agile-SCRUM, Rational Unified Process (RUP), Waterfall-SCRUM Hybrid
Business Skills: Change Management, Impact Analysis, JAD sessions, and SWOT analysis, Project Planning Scheduling and Budgeting, HLD, LLD, Business Process Modelling.
Operating Systems: Windows XP, Vista, 7,8,10, Mac OS, Linux, UNIX.
Languages: C++, .NET, JAVA, SQL, HTML, XML.
Business Modelling Tools: MS Visio, Rational Rose, Mockup Screens, UML
Project Management: MS project, MS Excel, MS SharePoint 2007/10/13
Requirement Management Tools: JIRA, Version one, MS Office, HP ALM 11.5, Rational Clear Quest, Rally
Business Intelligence: Tableau, SAS, XL miner, Business Objects, IBM Cognos
Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, ETL, Slicing/Dicing, Drilldown/ Roll Up, SSIS, SSRS, SSAS, Informatica Power Center
Databases: MYSQL, Oracle 9i and 10g(PL/SQL), MS SQL Server
Testing Tools: HPQC, HP ALM, Rational Clear Quest, Load Runner
Web Services: XML, Rest, JSON, API, AJAX, Client Side Validation, Server Side Validation
Other Tools: Data Stage, Business Objects, Web Methods, MS Office Suite, Share Point 2013
PROFESSIONAL EXPERIENCE
Confidential, Seattle, WA
Sr. Business Systems Analyst
Responsibilities:
- Handled two different SCRUM teams working on a common set of requirements as a SCRUM Master.
- Acted as a SCRUM Coach to educate and reinforce Agile-manifesto to team members and key stakeholders.
- Decomposed the scope from the BRD into user stories by conducting a story writing session with the Product owner and then coming up with acceptance criteria for all the PSPIs (Potentially Shippable Product Increments)
- Created User Stories and used Planning Poker to estimate them in Sprint Planning and Backlog Grooming meetings.
- Incorporated SCRUM events Backlog grooming, Sprint Planning, Stand up meeting, Sprint Review and Retrospective.
- Helped in estimating and prioritizing of the user stories using Relative Mass Evaluation and MOSCOW Techniques.
- As SCRUM master tracked team velocity and Sprint progress using Sprint Burn down Chart and Product Burn down Chart, conducted time boxed daily SCRUM meeting. Supported the development team by resolving impediments.
- Involved in Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
- Defined Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans, Test Scripts, and Test Scenarios to perform Functional Testing, and Regression Testing. Logged defects using JIRA.
- Handled Requirement churn during the project by performing Impact Analysis and checking and analyzing the feasibility in maintaining the Triple Constraints and discussing them in Daily Standup meetings.
- Worked on service oriented architecture SOA, REST, SOAP, XML, API.
- Logged and tracked the defects using JIRA and created an error repository, coordinated testing with the QA team.
- Assisted in the creation of deployment flow chart in conjunction with development, infrastructure, and network teams containing information for maintaining Application.
- Planned and organized team engagement activities to encourage self-organization among the team. Proven record of Team Management and Leadership skills.
Environment: Agile - SCRUM, MS Office Suite, MS Visio, MS Project, Cognos BI, Java, Apache Tomcat, HP ALM/UFT, Oracle 11G, JIRA 6.3, SOA, HTML, XML, Web Services (SOAP), Jscript/JQuery, Informatica.
Confidential, Baltimore, MD
Sr. Business Systems Analyst
Responsibilities:
- Conducted information elicitation sessions with users to better understand and evaluate the current and proposed system.
- Involved in designing business requirement collection approach based on the Agile SCRUM SDLC Methodology.
- Conducted SCRUM Workshops to familiarize the team with SCRUM as a concept and process skeleton, so that the team can start the sprints and helped them deliver higher quality, higher value software faster using SCRUM.
- Conducted User Story Writing Sessions to decompose high level requirements into User Stories fitting INVEST criteria and determined Acceptance Criteria for Potentially Shippable Product Increments (PSPIs).
- Coached the team to be self-organizing while also helping the team to plan and estimate user stories accurately.
- Aided Product Owner in creating effective and understandable product backlog.
- As a SCRUM Master facilitated various SCRUM ceremonies, the backlog refinement meeting and the sprint planning meeting, daily standup, sprint review meeting and sprint retrospective meeting.
- Tracked team velocity and Sprint progress using Sprint burn down chart and Release burn down chart and conducted time boxed Daily SCRUM meeting and resolved impediments with assistance of Product Owner.
- Protected development team from outside distractions, impediments or team conflicts and maintain focus of product backlog and project time lines.
- Handled Requirements Churn. Conducted technical training sessions regarding Agile development methods and participated in meetings, technical discussions, and reviews. Provided assistance to resolve everyday impediments.
- Ensured that development teams are practicing Agile Principles.
- Authored progress and completion reports, which were submitted to program manager on a weekly basis.
- As a Scrum Master, acted as a Servant Leader to guide the team in becoming self-organized to optimize productivity.
Environment: Agile - SCRUM, JIRA 6.3, SharePoint 2013, MS Office Suite, MS Visio, XML Spy, Tableau, Java, Apache Tomcat, HP ALM/UFT, Oracle 11G, HTML, XML
Confidential, St. Paul, MN
Business Systems Analyst
Responsibilities:
- Interacted with users and stakeholders to Identify business needs, evaluated solutions for business problems.
- Gathered business requirements by participating in JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.
- Understood problem definition through one to one meetings with Data architects, and Enterprise architects.
- The methodology used for the project was Waterfall-SCRUM hybrid and had a deep understanding about the requirement gathering. Provided clear and consistent information about project status across stakeholders.
- Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. Understood the AS-IS system, developed the TO - BE system concepts and also prepared the System Process Maps.
- Prepared Business Requirement Document (BRD/HLD) and Drafted Systems Requirement Specification (SRS).
- Performed Data Analysis and created Data Mapping template and assisted in creating Data modeling.
- Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models.
- Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
- Assisted in Designing data models and conducted normalization and de-normalization of data to fit OLTP and OLAP frameworks, slicing and dicing of data marts for analytical decision making support.
- Identified Source systems for financial data profiling of Billing and Budget processes.
- Integrated various OLTP to the OLAP by using SSIS/SSAS as an ETL tool and used SSRS as reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms.
- Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data.
- Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
- Played a key role in the planning, testing, and implementation of system enhancements and conversions.
- Used ETL to map data and assemble data repository and created data marts.
- Used Data Center for Integrating Legacy systems and supporting in decision making.
- Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity.
- Assisted in the implementation of Enterprise Data Warehouse with individual data marts to address areas of business.
- Assisted with SNOW-flake schemas in the Dimensional model architects to providing business rules.
- Maintained Bill Inman and Ralph Kimball Paradigms.
- Understand the Software Development Life Cycle and experience in system architecture mapping.
- Designed and developed all Use Cases and UML models using MS Visio.
- Proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
- Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes.
- Establish Incident Reporting and Change Control procedures.
- Developed timelines for project delivery, and managed projects and resources to successful completion.
- Managed and coached consultants about the department’s processes.
- Authored progress and completion reports, which were submitted to program manager on a weekly basis.
Environment: Waterfall - SCRUM Hybrid, MS project, MS Office (Word, Excel, PowerPoint and Visio), MS Project, MS SQL 2008, SSIS, SSRS, SSAS.
Confidential, Rochester, MI
Sr. Business Analyst
RESPONSIBILITIES:
- Conducted information elicitation sessions with users to understand and evaluate current and proposed systems.
- Decomposed the scope from the BRD into user stories by conducting a story writing session with the Product owner and then the acceptance criteria for the PSPI (Potentially Shippable Product Increment)
- Involved in designing business requirement collection approach based on the Agile SCRUM SDLC Methodology.
- Conducted SCRUM Workshops to familiarize the team with SCRUM as a concept and process skeleton, so that the team can start the sprints and helped them deliver higher quality, higher value software faster, by maximizing the benefits received from SCRUM.
- Conducted User Story Writing Sessions to decompose BRD into User Stories and determine Acceptance Criteria for Potentially Shippable Product Output.
- Elicited and documented Functional requirements, business requirements AS-IS and TO-BE business process models.
- Analyzed and gathered requirements for preparation of Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS).
- The methodology used for the project was Waterfall. Communicated clear and consistent information about project status among stakeholders.
- Responsible for creating UML diagrams (Use Cases, Activity Diagrams, and Sequence Diagrams) in order to capture the dynamic behavior of different applications.
- Designed Test Plans and Test Cases for User Acceptance testing (UAT) with the help of QA teams.
- Prepared Business process models; used Visio to create process flow diagrams for management and mapping the logical aspects of the process.
- Created Mapping and Modelling process in reference to Data center for reporting.
- Created the following types of documents mainly: Functional Requirement Specification (FRS), Functional Test Summary, Chance Control Documentation and Validation Specification.
- Prepared Requirement Traceability Matrix and interacted with QA team to ensure quality of software
- Assisted in the creation of deployment flow chart in conjunction with development, infrastructure, and network teams containing information for maintaining Application.
- Planned and organized team engagement activities to encourage self-organization among the team.
- Proven record of Team Management and Leadership skills.
Environment: Waterfall-SCRUM hybrid, MS Office Suite, MS Project, MS Visio, HTML, UML, AJAX, JAVA EE 6, Oracle 11g, JIRA, Eclipse
Confidential
Quality Analyst/ Jr. Business Analyst
RESPONSIBILITIES:
- Gathered business, system, and functional requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME’s). Assisted in defining the scope of the project.
- Followed the UML methodology to create UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams (DFDs), ER Diagrams using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model.
- Development of a detailed conversion plan and timetable, creating of client notification letters, emails, web updates, and statement inserts.
- Facilitated meetings with developers, system analyst, and testers to collaborate resource allocation and project completion using MS Project.
- Worked on E2E Testing (Manual & Automated) pertaining to multiple products of Confidential ’s Global Services.
- Achieved 100% testing coverage within given critical deadlines.
- Tested various features in Voice - UKB, wrote functional test plans, functional test specifications and executed them in time giving the development team enough time to rectify all the issues.
- Documented manual testing procedures for entire application with emphasis on Regression and Integration Testing.
- Performed Data-Driven Tests by using different sets of data and checked whether the information entered is updated into the database.
- Reported the defects in HP Quality Center and coordinated with the QA Lead and developers.
- Developed Test Analysis Reports and Master Test Plans for each testing effort.
- Updated testing procedures according to the changes in the application.
- Participated in triage calls to better understand the architecture of the system.
- Worked with development and support teams to get defects fixed in time.
Environment: Waterfall, Manual Testing, Load Runner, PL/SQL, Java Script, MS Office, HPQC, UAT Testing.
Confidential
Jr. Software Developer
Responsibilities:
- Participated in complete Software Development Life Cycle (SDLC) for proper analysis, development, testing, deployment, and enhancement of the code.
- Designed User Interface Screens using Views and Widgets.
- Used fragments to build small re-usable pieces that are easier to manage and allow for a more fluid visual design and also can adapt to tablet and phone resolutions.
- Used Android NDK to create the library files to be used by services to access Native Applications.
- Involved in writing application logic using Eclipse IDE and Android SDK
- Used subversion for branching and merging new features without disrupting mainline development or trunk.
- Involved in debugging and porting the application on various mobiles.
Environment: Android SDK, Eclipse IDE, Java, Subversion, XML, J2EE, JQuery, SOAP, REST, GUI, AJAX, Soap UI, SharePoint 2010
Confidential
Jr. Software Developer
Responsibilities:
- Worked with Business Analysts and Project Managers to drive out requirements and implemented an elegant solution.
- Developed Web Forms, C# Class libraries and Business Logic.
- Worked extensively with AJAX and JavaScript to achieve rich User Experience.
- Identified, tuned, and eliminated .Net and DB performance bottle necks to improve application performance.
- Developed XML Web Services to expose data to other applications.
- Implemented XML Web Services in C# based on SOAP protocols using XML and XSLT extensively for data transfers.
- Involved in developing Web Services and invoking them by using XML SOAP and WSDL tool for creating proxy classes.
- Used ADO.Net to build Data Access Layer Classes.
- Worked closely with the testing team to make sure there were no bugs in the application.
Environment: ASP.Net, AJAX, Web Services, Visual Studio.Net, ADO.NET, UML, SQL Server 2000, Windows 2000, SharePoint 2007
