Sr. Business Systems Analyst Resume
Cincinnati, OhiO
SUMMARY
- 8+ years of comprehensive work experience as Business Systems Analyst in Business Development Process and Information Technology with extensive work experience in Telecommunication, Mortgage, Retail Banking industry.
- Excellent Interpersonal skills to interact and work with Business Users, Key Business Stakeholders, Subject Matter Experts (SMEs), Project Managers, Scrum Product Owner, Testers, Developers, End Users, Project Stakeholders Architects and Deployment Analysts under tight deadlines to meet business goals in multiple projects.
- Experience and Knowledge in Telecommunications domain - NextBestOffers through Real Time Decisioning and Customer Journey through Case Management.
- Extensive domain knowledge in Fixed Rate Mortgage (FRM), Adjustable Mortgage Rate (ARM), Balloon Mortgage, FHA Loans, Auto Loans, Refinancing, Home Equity Line of Credit, Interest Rate, Reverse Mortgage, and compliances such as Dodd Frank Mortgage Compliances, Home Ownership Equity Protection Act, Sarbanes Oxley Act (SOX).
- Experience on Waterfall, Agile Scrum, Hybrid of Waterfall - Agile methodologies and working with self-managing, self-organizing and cross-functional teams with good knowledge of XP, RUP, Spiral Model, SAFe, Kanban.
- Designed and documented Business process re-engineering, business process modeling, accompanied by conducting and facilitating elicitation sessions such as survey/questionnaires, Interviews sessions, Brainstorming sessions, Focus group sessions, Requirement workshops, Interface analysis, Root Cause analysis, Document analysis, and Joint Application Development (JAD) sessions with internal as well as external stakeholders for gathering requirements based on SMART (Specific, Measurable, Attainable, Realistic and Timely) technique.
- Experience in conducting GAP analysis, Impact analysis, Strength Weakness Opportunity Threat (SWOT) analysis, Cost benefit analysis (CBA), Root Cause analysis, Feasibility study, Risk Analysis and drafting reports.
- Created User Stories along with the development team and breaking down Epics into User Stories and defining Minimum Viable Product (MVP) and Acceptance Criteria in rules Given-When-Then format together with the Scrum Team, Product Owner (PO) and Scrum Master and used prioritization techniques like MOSCOW Model, KANO Model, Business Value based, Value Stream Mapping, 100 Pointers Method, Technology Risk based.
- Facilitated Change Request Management and created and validated Business Requirements documents (BRD), Use-Case Specifications, System Requirements Specifications (SRS) and verified Requirement Traceability Matrix (RTM).
- Sound familiarity with development techniques in Agile such as TDD (Test Driven Development), BDD (Behavior Driven Development) and ATDD (Acceptance Test Driven Development) based on the specific businessneeds.
- Experience in building Unified Modeling Language (UML) diagrams including Use Cases, Activity diagrams, Sequence Diagrams, Class diagrams, Data Flow Diagrams, and transforming the requirements gathered into functional specifications focusing on workflow analysis and design, user interface design and ER Diagrams.
- Good understanding in building and maintaining Responsible, Accountable, Consulted, and Informed (RACI) Matrix.
- Experienced in writing User stories using INVEST technique and handling the Requirement Churn.
- Created Data Mapping Documents using Hypertext Markup Language HTML and Extensible Markup Language XML.
- Worked in the implementation of dimensional data modeling (Star & Snowflake schema), Dimension Tables, Facts Tables, Data Mapping, Data Integration and Migration, extensive implementation knowledge of Databases, Data Table structures, Schemas, Data Marts and OLAP operations such as Roll-up, Drill-down, Slice, Dice and Pivot.
- Experience working in Mainframe environment and deep understanding of database concepts like Data Warehousing, Data Structures, Schemas, Data Marts and User Administration. Worked extensively with Data warehouses by migrating data from various OLTP’s to OLAP cube using ETL tools such as Informatica.
- Worked with SQL queries like JOIN, UNION, INNER JOIN, OUTER JOIN, GROUPBY, HAVING, ORDER BY and aggregate functions for Data Analysis, retrieval, validation, modification, Data Profiling and used Data Manipulation Language (DML), Data Definition Language (DDL) syntax for respective queries.
- Coordinated with UX designers and developers to create web application using web services between the front and back-end systems that define the UI functionalities using HTML5/CSS3 and used HTTP as transfer protocol to display the data, SOAP/REST API; XML to store and carry the data between web and application servers.
- Understanding of HTTP request to the web service, to specify REST API operations having HTTP verbs GET, POST, PUT, DELETE with experience working in Three-Tier architecture, Simple API for XML Web Services (SOAP, WSDL), Client-Side Validation and Server-Side Validation and performed API Testing using Postman tool to check if the APIs are returning the data in Java Script Object Notation (JSON) and Extensible Markup Language (XML).
- Experience in Testing Life Cycle and supervising Black-box Testing, Functionality Testing, System Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing.
- Worked with QA team to design Test plans and Test Cases using HP QC/ HP ALM with experience in bug tracking and issue tracking in following up for successful maintenance & delivery of service tickets using JIRA.
- Generated reports, worked with non-technical users in understanding their requirements, interpreting it in concrete reports using Tableau and created interactive, analytical dashboards using Tableau for decision making.
- Good understanding of Flow Rules, Activities, Work Baskets, Access groups, Work groups, Decision rules, Decision Tables, SLAs in Case Management, and reporting functionalities in Pega Marketing.
TECHNICAL SKILLS
SDLC Methodologies: Waterfall, Agile Scrum, Hybrid (Waterfall - Scrum), SAFe, Kanban, Waterfall, XP.
Process Modeling Tools: MS Visio, Lucid Chart, Axure RP.
Reporting Tools: Tableau, MS Excel.
Project Management: Atlassian JIRA, Confluence, Sharepoint, MS Project, MS Office 365, iObeya.
Testing Tools: HP ALM v11.5, HP QC v10.0.
ETL Tools: Informatica.
Data Analysis / Reporting: Tableau, MS Excel.
Databases: Microsoft SQL Server, PostgreSQL.
Data Modeling: Logical/Physical/Dimensional, Star/Snowflake schema.
Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drill Down/Roll Up.
PROFESSIONAL EXPERIENCE
Confidential
Sr. Business Systems Analyst
Responsibilities:
- Conducted DCO Sessions with various stakeholders to capture the requirements to implement the Request Approval Process (RAP) in PEGA Case Management.
- Facilitated requirements gathering sessions with the stakeholder for StraightTalk, Tracfone, Walmart Family Mobile, Simple Mobile Brands to present the suggestions for the existing Offers in UNICA Platform by capturing the requirements in a Brief document.
- Participated in PI Planning Meeting for capturing the features, epics and deliverables in the Quarter and identifying the dependencies with other teams across the organization.
- Captured the requirements for the Flow Rules, Activities, Work Baskets, Access groups, Work groups, Decision rules, Decision Tables, SLA's for building the Request Approval Process (RAP) in Case Management.
- Worked with the Channel Managers to review the Keywords that can be used to present the Offers through the 611611 Channel and the scripting team to review the verbiage that can be used to communicate the Offers through the Agent Channel.
- Facilitated Grooming sessions with the team to discuss the user-stories to groom and estimate them and worked closely with the Project stakeholders which includes Developers, testers, business team and Project manager to plan how the work can be broken down into logical components to facilitate focused and efficient Requirements Gathering.
- Acted as a PEGA Business Liaison between the business and the technical team in the areas of Software Design and Development Life Cycle.
- Conducted requirements workshop, one-on-one sessions and collaborative meetings with the product owner and the business owners to determine the best features to implement for a better overall customer experience.
- Provided requirements and strategies for UX solution design which are typically impacting multiple channels, processes, services and/or brands.
- Transformed functional requirements into prototypes, GUI, UI using Axure RP for the better understanding of the requirement.
- Created Use Cases to help understand the process in MS Visio to represent the flow for New Request and Change Request Approval Process for various Channels and all the Approvers involved in the flow.
- Collaborated with the ETL team in identifying the attributes that are to be added to the customer spine table for capturing the specific details of the customers and events to communicate to the customer in Real Time.
- Entered the details in Fast Track Approval Process based on the requirements captured during the DCO Sessions to enable the Development Team to configure the Offers.
- Participated in Sprint Review meetings along with the PO to make sure the developed features are as per the requirements.
- Discussed the common goals during weekly meetings with core team members while measuring, tracking, and demonstrating the success of the project.
- Worked in the preparation of the Test Data that is required for writing the Test Cases and participated in the writing of Test Plans, Test Cases and created dashboards for reporting test analysis to the management AND assisted in performing Smoke tests, Regressions Tests, and end to end tests.
- Conducted User Acceptance Testing (UAT) in STG1 and Prod1 Mirror to ensure the developed features are as per the requirements.
- Experience in complete SDLC, which includes Requirement Gathering, Analysis, Design, Development, Implementation Enhancements, Maintenance, Support and Bug fixing.
- Created reports for the PO using the existing custom reports in the Pega Marketing Report Browser to see the Weekly Impressions, Acceptance Rates for the Offers across all Brands.
- Created training documentation for the RAP Process and Reporting capabilities to enable the stakeholders to access the RAP and Reports.
Environment: Agile-Scrum, Jira, Confluence, PEGA, Office 365 (Word, Excel, PowerPoint), SharePoint, iObeya, Visio, Axure RP.
Confidential - Cincinnati, Ohio
Sr. Business Systems Analyst
Responsibilities:
- Participated in Release planning and Sprint planning meetings with the SCRUM team for implementation of features, releases and delivery of Potentially Shippable Product Increment (PSPI) and participated in Product Grooming meetings where potential epics were discussed and helped estimate potential epics.
- Performed Gap Analysis to understand the existing system and what future state it is intended to be, to establish the significance of enhancement of the application.
- Performed document analysis and participated in brainstorming sessions for enhancement to supplement the pre-existing computer based and web-based applications, facilitating the session and documenting elicited requirements.
- Wrote user stories along with the development team and participated in the Demo meetings along with the Product Owner to make sure that the deliverables are meeting the requirements.
- Worked with technical team to convert functional requirements into specifications like prototypes, GUI, UI.
- Created Use Cases and Use Case diagrams to help understand the use of the system in MS Visio and Activity diagram to describe the dynamic aspects of the system to represent the flow of loan origination from processing to the closing.
- Created E-R modeling diagram with conceptual and logical data model using MS Visio.
- Analyzed the data and based on the requirements, I Performed CREATE, READ, UPDATE, DELETE (CRUD) operations on the data using SELECT and JOIN queries in SQL.
- Worked with the compliance team to understand the compliance requirements demanded by the new application for the Dodd Frank Mortgage Compliances and the Home Ownership and Equity Protection Act.
- Created and maintained custom reports, profiles, workflows, page layouts in SFDC.
- Customized Email, text messages and pop ups using email studio & mobile studio to track & optimize the performance and kept track on the entire journey of every individual customer using Journey Builder, a campaign planning tool.
- Written Sharing Rules in Salesforce to increase the Organization Wide Default (OWD) sharing settings by increasing the accessibility of the records based on the roles.
- Managed the Users, Security profiles in accordance with corporate policy via setting various permission sets.
- Experience in Salesforce Sandbox refresh & Post Refresh activities, Deploying from Sandbox to Production using Change Sets, Unit testing of changes deployed.
- Assisted the Testing/QA team with documentation of test results and maintenance of an issue report and conducted User Acceptance Testing before deployment in production environment, documented the overall process and created user manuals and created issues in JIRA for bugs during testing and reported them to the management.
- Used Bulk API, Streaming API, REST API and Soap API for the applications in the Salesforce Cloud.
- Used APIs that allowed the Data Aggregator to fetch the information from other financial institutes.
- Integrated various APIs and Web Services to communicate the data from multiple sources using RESTful Services and performed API Testing on the API’s that are used to communicate with the Salesforce Cloud using POSTMAN and checked their responses in JSON and XML and documented it with the help of Swagger Tool for the developer.
Environment: Agile-Scrum, Atlassian JIRA (v7.3), Atlassian Confluence (v5.10.6), Swagger API (v2.0.0), HP ALM v11.5, POSTMAN, MS Visio (v16.0), Office 365 (Word, Excel, PowerPoint), MySQL Server.
Confidential - Atlanta, Georgia.
Sr. Business Analyst
Responsibilities:
- Elicited requirements by using different techniques such as Interviews, Brainstorming sessions, JAD sessions.
- Reviewed high-level requirements business to prioritize and define scope of the project and worked closely with my Product owner in creating Scope Documents and Requirements Documents.
- Worked with the PEGA suite of tools to help design the web and mobile application platforms, developers used PEGA PRPC for development of the application.
- Used DCO (Direct Capture of Objectives) for capturing, organizing and sharing information using PEGA’s integrated solution, the PEGA platform.
- Worked closely with the Lead System Architect to ensure processes and designs suggested are PEGA compliant and scalable for future iterationsand conducted weekly/bi-weekly meetings with business leadership to resolve cross department issues impacting PEGA software or resources.
- By creating and monitoring KPIs in PEGA, I kept track of business performance to see whether business operations and processes are meeting desired criteria.
- Created diagrams, Mock-up Screens, Wireframes containing UI Components such as Drop-down list, check boxes for retrieving data from the user.
- Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which feature are DONE and satisfied using the Acceptance Criteria.
- Validated the database using various SQL queries like JOINS, GROUP BY, ORDER BY & SQL Aggregate queries.
- Involved in API Documentation and in the preparation of the Test Data required for executing Test cases and testing different web services on SOAP UI tool with XML and JSON response.
- Helped performed user acceptance testing to ensure that stories met with their acceptance criteria and worked with the Technical Analyst and development team to ensure that they understand the specifications.
- Extensively involved in coming up with test specifications, test cases in PEGA Designer studio for the application and managed and monitored requirements by developing Requirement Traceability Matrix against the test cases and used PMF (Project Management Framework) to triage, assign, track and resolve bug.
- Used JIRA and QC to maintain the project artifacts and kept the information radiators updated, track tasks and tickets for maintenance and deployment of system being developed.
Environment: Agile-Scrum, PEGA 7, Office 365 (Word, Excel, PowerPoint), SharePoint 2013.
Confidential - Phoenix, Arizona.
Business Systems Analyst
Responsibilities:
- Involved with all the phases of Software Development Life Cycle methodologies throughout the project life cycle.
- Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
- Analyze business requirements and segregated them into Use Cases and Activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models and coordinated in the creation of ER Diagrams, helping define entities, attributes and their relationships
- Identified and Documented data sources and transformation rules that are required to populate and maintain Data Warehouse content which is a designed DataStage ETL for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
- Reviewed Stored Procedures for reports and wrote test queries against the source system to match the results with the actual report against the Data mart and helped with Data Mapping between the Data Mart & Source Systems.
- Created a data mapping document and a data dictionary to analyze the data present in the various sources to consolidate all the data and integrate it before moving it to the AWS Simple Storage Service Data Lake.
- Helped facilitate the ELT (Extract, Load, Transform) process using Informatica Cloud, defining the sessions, workflow, the source and target information and the types of transformations that the data underwent. The operations included filtering, sorting, aggregating, ranking, update and expression transformations.
- Assisted with the definition of external schema and external lookup tables for the AWS Redshift.
- Assisted in the creation of API Documentation using POSTMAN for all the API's used in the project.
- Assisted with performing user acceptance testing to verify functionality of the reports and the API that communicated between the different client-side machines and the Amazon Redshift Data Warehouse.
- Assisted with blending and joining of data in Tableau to enable better analysis of incoming data.
- Generated reports, worked with non-technical users in understanding their requirements, interpreting it in concrete reports using Tableau and created interactive, analytical dashboards using Tableau for decision making.
- Created snapshots and story points in Tableau for better overall views of data and key performance indicators.
- Created Test Scripts & Test Scenarios to check report content, layout, and parameters and worked on Report Re-engineering Project, tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel.
Environment: Waterfall, PostgreSQL, Windows, Tableau 10.1, JIRA 7.0, MS Project, MS Office, Informatica PowerCenter, Confluence 6.0, Amazon Redshift.
Confidential
Business Analyst
Responsibilities:
- Interacted with clients, SME's in gathering business requirements and ensure that end deliverables meet client needs.
- Conducted Joint Application Development (JAD) sessions with key users, project sponsors, group representatives, SMEs' and technical personnel and documented the minutes of meeting and to make them understand the project scope and deliverables and to check the feasibility of the project.
- Participated in requirements workshop to gain a high-level understanding of additional functionality.
- Designed Business Requirement Document (BRD) and System Requirements Specifications (SRS).
- Created Mockups for the user interface for the better understanding of the requirement, and to resolve the issues.
- Performed Gap analysis to understand current state and future state study which included data collection methodologies, data quality and data integration problems, data storage and infrastructure related issuesby interacting with various business groups to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
- Wrote SQL queries to identify, test and update database configurations, created Test Cases & executed them in ALM.
- Interacted with various cross-functional teams on building Use Cases & understanding expenses and revenue stream.
- Performed SQL queries for analyzing data form the database and gathered data requirements for reporting purpose.
- Created Use case diagrams, activity diagrams and class diagrams using Lucid Chart for designing and developing.
- Participated in the development and preparation of the Test Plan with the testing team as well as ensuring testability, reliability, usability, maintainability, and performance of the application.
Environment: Hybrid (Agile-Waterfall), HTML, XML, CSS, Share Point, and Rational Rose, Lucid Chart, SQL Server, HP ALM(v11), Microsoft Excel (2013), Microsoft Word (2013), Microsoft PowerPoint (2013)