We provide IT Staff Augmentation Services!

Pega Business System Analyst Resume

Norfolk, VA

PROFESSIONAL SUMMARY:

  • Over 8 years of professional experience as a Business Analyst/Business System Analyst/Scrum Master in Variety of projects under Healthcar e/Capital Market and Investment Banking and strong understanding of Business Requirement Gathering, Business Process Flow, API documentation, development, Business & Data Analysis.
  • Certified Scrum Master with over 4 years of experience working with self - organizing and cross functional teams. I have expertise in SAFE (4.0) and Agile scrum environments. In depth knowledge of Software Development Life Cycle (SDLC) process which includes Waterfall, Kanban, and Waterfall-Scrum Hybrid methodologies.
  • Exposure to regulations & compliance such as FINRA, ERISA, IRS, SEC, GAAP, FINMA, Investment Advisers Act, The Investment Company Act, Securities Exchange Act, Securities Investor Protection Act.
  • Knowledgeable in area of the various types of Medicare plans/ health insurance programs Medicaid, Medicare (Part A, B, C and D), PPO (Preferred provider organization), HMO (Health maintenance organization), and POS (Point of Service).
  • Widespread knowledge of EHR/EMRs Electronic Medical Records, HL7 and its Patient Protection and Affordable Care Act PPACA .
  • Excellent Business writing skills in writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications, Systems Requirements Specification (SRS), Data Requirements and Workflows.
  • Great understanding and knowledge of Scrum framework including Scrum Ceremonies, Artifacts, various Prioritization and Estimation techniques viz. Kano, Moscow, Planning poker, Relative mass, T shirt sizing.
  • Assisted Project Managers in preparing Project Plans, Project Schedules, establishing Milestones, Work Breakdown Structure (WBS), maintained RACI chart to manage overall project risks and mitigation plans.
  • Conducted Impact Analysis, Cost Benefit Analysis, GAP analysis, Root Cause Analysis, Feasibility Study, As-Is and To-Be business analysis, Risk Analysis, SWOT analysis.
  • Involved in Business Process Automation with Pega Systems Smart BPM suite - Pega Rules Process Commander (PRPC)
  • Experienced in using PEGA PRPC 7.1v/7.3V for creating Application Profile and conducting DCO sessions
  • Excellent knowledge in dataflow analysis of the system using use case diagrams, dataflow diagrams, state diagrams, activity diagrams, flowchart diagrams, sequence diagrams, and collaboration diagrams.
  • Worked extensively with the team to meet business requirement and analyzing workflow and Worked with project teams and architects to develop business process models.
  • Experience in using zeplin and great knowledge on React Native framework.
  • Maintained a structured approach in organizing requirements to ensure that critical business rules and requirements are met with the help of Requirement Traceability Matrix (RTM).
  • Strong experience in Data Profiling, Data Migration, Data Conversion, Data Governance, Data Integration, Data Modeling, Data Warehousing, Metadata Management Services, Master Data Management and Configuration Management.
  • Experience in Relational Databases like Oracle 11g/12c, PostgreSQL, SQL Server, MS Access, Dynamo DB and very efficient in tuning the SQL Queries. Utilized Joins, NVL statements, Union, views, functions, procedures, cursors, triggers in creating complex SQL and PLSQL queries
  • Extensive experience in Data Warehouse and ETL processes using Informatica Power Center and used it to extract the data from source systems, transform it according to business rules and load it into the DWH.
  • Expert in Data Conversion, Normalization, Denormalization, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
  • Hands - on with creating solution driven views and dashboards by developing different chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in Tableau Desktop.
  • Cultivated experience in working with different web services such as HTML, WSDL, SOAP, UDDI, REST, JSON under various architectures like Three-Tier Architecture and Service Oriented Architecture (SOA) for efficient information transfer and mapping for the application.
  • Performed API testing using Postman to check if the API’s are returning the data in JSON, XML format as defined in the API documentation and required by workflow.
  • Well versed in conducting various types of testing including Unit Testing, User Acceptance Testing (UAT), Black Box Testing, Stress Testing and Regression Testing and helped in designing and developing test plans and test scripts.
  • Managed requirements, tracked defects and documented performance reports. Determined the priority of defect along with developers and managers based on business value of the functionality and helped in resolving it by efficient tracking in JIRA.
  • Experienced in Creating Operational Dashboards to monitor frequently changing business processes, Strategic Dashboards to track the KPIs across organization and Analytical Dashboards to analyze large volumes of data using Informatica and Tableau, and good knowledge on Microstrategy and IBM Cognos
  • Involved in maintaining product backlog, writing PBIs, sizing user stories. Managed open issues, removed impediments, & worked with cross-functional teams to improve software quality & test coverage - JIRA.

SKILL:

SDLCWaterfall, Agile: Scrum, Scrum/Waterfall Hybrid, Scrum/Kanban Hybrid, Scaled Agile Framework.

Project Management: Rally, JIRA, HP ALM, MS Project, MS SharePoint

BI tool: Tableau, Power BI, Adv. Excel., Micro Strategy, IBM Cognos

ETL tool: Informatica Power Centre

Database: PostGreSQL, Oracle 11g/12c, SQL Server, PL/SQL, NoSQL, Teradata.

Data Warehousing: Data Modeling, Data Marts, Data Mapping, OLTP, OLAP, ETL

Business Modeling Tools: MS Visio, Balsamiq, Lucid Chart.

Technology/Reporting TOOLS: Pega 7.1V, 7.3V, Tableau, IBM Cognos

Defect Tracking: JIRA, HP ALM, Rational clear quest

Testing Tools: Postman, SOAP UI

Operating Systems: Windows 7, Windows 10, Mac OS

Web Development: XML, REST, SOAP

Miscellaneous: MS Excel, MS Word, GoToMeeting.

WORK EXPERIENCE:

Confidential, Norfolk, VA

Pega Business System Analyst

Responsibilities:

  • Gathered and analyzed business requirements from stakeholders (Subject Matter Experts (SME) Business Users and translated into system requirements. worked directly with vendors/partners, and scheduling meetings and gathering the specific requirements
  • Created user stories, use cases, test cases, end to end workflows, interface diagrams and mapping documents.
  • Converted the business requirements into Epics, features and user stories.
  • Documented the user stories using INVEST Criteria following (AS a user……., I want……, So that……….) and Acceptance Criteria using Gherkin format.
  • Assisting the Product Owner to prioritize the sprint backlog user stories using MoSCoW model in JIRA
  • Worked with Product Owners and Business Users to demonstrate the changes in the system to ensure all relevant business needs are addressed
  • Created mock ups and wireframes by using Balsamiq, M.S. Visio.
  • Worked on Identifying the RCA of the issues by using ishikawa fishbone diagram
  • Maintained and updated the documentation in confluence and SharePoint.
  • Used SQL queries for reporting/data validation. Also, used Joins, Unions, Outer Joins, and Group by, Order by, and Aggregate functions to extract data.
  • Experience in Defining the Routing Rules to automate the business processes and handle the electronic documents
  • Captured User Role based Dashboard views, Workbaskets and Worklists requirements to identify the work assigned
  • Worked on creating new workflows, Urgency, SLA for Claims, Complaint etc using Pega application.
  • Involved in Upgrading 7.1v to Pega 7.3v provides an opportunity to automatically enhance existing Pega applications by taking advantage of underlying capabilities available in the Pega 7.3V platform.
  • Worked on API to integrate between two Pega based applications.
  • Used SoapuI to perform unit testing on integration components and testing web services.
  • Involved in maintaining product backlog, writing PBIs, sizing user stories. Managed open issues, removed impediments, & worked with cross-functional teams to improve software quality & test coverage - JIRA.
  • Involved in all the Scrum Ceremonies such as Sprint Planning, Daily standup, Sprint Review, Sprint Retrospective.
  • Involved in all phases of Software development life cycle by using SAFe agile Methodology.
  • Worked with Product Owners and other business system analysts in PI planning session to identify the PI objectives, goals, timelines, dependencies, and risks involved with other cross functional teams
  • Collaborated closely with the developers, testers to implement the requirements.
  • Writing SQL queries to extract and analyze data from FACETS Database
  • Performed Acceptance Test Driven Development (ATDD) practice, assisted in writing Test cases and Test Scenarios. Also performed Black-Box testing.
  • Used SOAP UI for testing Web services.
  • Performed User Acceptance Testing (UAT) to make sure the developed system functionality meets the defined acceptance criteria

Environment: Agile, Pega 7.1V, 7.3V, MS Excel, MS Word, MS Visio, Zeplin, Balsamiq, Jira, SQL, REST API, SOAP API, SOAP UI, Postman.

Confidential, Rockville, MD

Sr. Business Systems Analyst

Responsibilities:

  • Facilitated various Agile-Scrum ceremonies including daily stand-up, sprint planning, backlog grooming, sprint review and retrospective and instill Agile principles and best practices into daily activities to ensure smooth functioning of the team.
  • Collaborated with TFS admin to configure TFS 2015 Environment with Default Project Collections, Build Definitions, Work Items, SharePoint Services, and Reporting Services and customize Work Item templates and workflows.
  • Leveraged limited risk-based accounting ABOR data to calculate the backup NAV.
  • Actively engage with the Solution Architects and Tech leads to develop cloud based Contingent NAV solution leveraging Xceptor, Snowflakes data warehouse, .Net framework, Workflow service, BizTalk orchestrations and SQL Server.
  • Used Xceptor to Extract, Transform, Layer (ETL) and map data to the central Data Mart and created data stores for Holdings, Trade, Price, Corporate Action, Cap-stock and Sec Master.
  • Lead efforts to develop complex reports including dynamic calculations involving hierarchies, custom LOVs, local variables, derived tables, alerts, ranking, cascading prompts and index awareness using Tableau.
  • Gained experience in trade lifecycle of various financial instruments like Stocks, Commodities, Bonds, Repos, Corporate Bonds, Fixed Income, Options, Total Return Swaps, Interest Rate Swaps, Credit Default Swaps, Mortgage Backed Securities, Collateral Mortgage Obligations, Forward Contracts among others.
  • Worked with the Transfer Agency team to capture required Capstock data for all mutual funds.
  • Coordinated with the Middle Office Valuation (MOV) team to set up new pricing processes and bring changes to existing Sec Master and Corporate Actions processes.
  • Leveraged Bloomberg Terminal to analyze valuation of Total Return Swaps. Used Bloomberg Data license to automate the data pull using SFTP.
  • Assisted in developing Morningstar report, Mutual Fund Quotation Service (MFQS) report and Research Invest Committee (RIC) report and other downstream reports for Fund Admin team.
  • Developed Unified Modeling Language (UML) models such as Activity Diagram, Sequence Diagram and Data Flow Diagram (DFD) along with working prototypes and wireframes using Microsoft Visio for SMEs to determine pros and cons of different proposed solutions.
  • Groomed and maintained a forced prioritized backlog with product owner by conducting JAD sessions and one to one/group interviews with SMEs, product owner, business operations staff, compliance group, and related stakeholders.
  • Executed complex SQL queries and Stored Procedure on SQL Server Management Studio (SSMS). Performed complex SQL joins in order to understand the data patterns and derive possible solutions from the analysis
  • Drafted and updated the sprint burn down charts and tracked the velocity and the sprint progress through the same. Provided project level matrices to higher management through Daily and Weekly Status reports
  • Worked closely with the Product Owner, Business Analyst and Solution Architects on Data Analysis, Feasibility Analysis, and performed SWOT to check the compatibility of the existing system infrastructure with new business requirements.
  • Prepared conceptual and logical data models as per the business requirements. Coordinate with the Database engineers and gather requirements for mapping specifications.
  • Performed System Integration Testing (SIT), User Acceptance Testing (UAT), and Functional Testing, engage in regression testing, performance testing, and load balancing to ensure the applications are stable and responsive and fast. Took a leading role in triaging bug/defect list on MS SharePoint.

Environment: TFS 2015, Smart sheet, MS Visio, MS Project, MS Office 2013, Redgate 10.2, Jenkins, MS SharePoint, Visual Studio Hadoop, kafka, XML, BizTalk, SQL Server, Access Database, SSMS, Xceptor, Snowflakes data warehouse, Invest One, FTP, FPS, tableau, Alooma

Confidential, Minneapolis, MN

Sr. Business Systems Analyst

Responsibilities:

  • Studied existing business application and processes, current source system, collected end user requirements by using interviews, requirement workshops, brainstorming sessions and suggested the improvised business process model.
  • Worked closely with product owner to develop user stories and acceptance criteria to build an incremental business values using Agile, Scrum and in JIRA.
  • Performed Document analysis, and GAP analysis to analyze As-Is business process and the To-Be system and assisted in fixing the scope of the project and to check the compatibility of the existing system infrastructure.
  • Conducted thorough analysis of the Business Requirements and created design specifications to accomplish and achieve business needs related to Healthcare EDI X12 transactions such as 835 and 837.
  • Worked on claim life cycle/Medical bill process.
  • Experienced in tracking the workflow and the data transfer of the Encounter life cycle and Submissions and Response.
  • Worked with FACETS Team for HIPAA X12 837 Claims Validation and Verification Process (Pre-Adjudication), Conducted claims validation and pending/denied Claims Analysis for the Health plans Medicaid programs.
  • Participated in the walkthroughs and meetings specifically for Claims filing processing, weekly status meetings to present status and in corporate any digressions from the original scope.
  • Responsible for identifying and documenting business rules and creating detailed Use Case and requirement document.
  • Captured process flows by preparing Use Cases, Activity Diagrams and Sequence Diagrams and other UML diagrams for a clear understanding of the project vision by using MS VISIO.
  • Involved in creation of Mock-Ups and Wireframes of user interface using Balsamiq for client verification.
  • Functioned as the primary liaison between the business line and the technical areas throughout the project cycle.
  • Writing SQL queries to extract and analyze data from FACETS Database and produce weekly and monthly reports and also Performed Data analysis and Data validation by writing SQL queries.
  • Analyzed requirements for various reports, dashboards and created them using Tableau desktop server.
  • Set up Server based data sources and Mentored business power users to create reports/dashboards using tableau desktop.
  • Created customized Table Calculations, Conditions and Filters for various analytical reports and dashboards.
  • Helped the testing team to successfully conduct User Acceptance Testing (UAT), based on the Design Document and User Requirement Document for the Functional and Performance Testing.
  • Helped the team in building Data marts, created conceptual, logical, and Physical data modeling.
  • Used SQL and Teradata to extract and analyze the data.
  • Used SOAP UI for testing REST and Web services calls also performed manual testing to test the functionality.
  • Worked with Informatica Power center for ETL to map the code sets according to the implementation, the companion guides and reported the claims statues using Tableau and Splunk Enterprise.
  • Used JIRA for issue tracking, user story management and requirement traceability, Used Bit Bucket as the version control repository for pulling and push code.

Environment: Agile (scrum), MS Excel, MS Word, MS Visio, Balsamiq, JIRA,java,Tableau, Oracle, Axway, Ultraedit, Spyglass, SQL,Teradata.

Confidential, Weston, FL

Business Systems Analyst

Responsibilities:

  • Elicited requirements from Business users and stakeholders by interviewing and asking them detailed questions, by JAD sessions, Focus Groups, Brainstorming, Prototyping and recorded and documented the requirements in a format easily understood and reviewed by both business and technical people.
  • Developed and Maintain Business Requirements document (BRD) and Software requirements specification (SRS)
  • Develop and maintain Functional Specification Document (FSD)
  • Performed Impact Analysis to derive and document requirements for the new Data Warehouse. Performed AS-IS and TO-BE business process analysis to check the compatibility of the existing system with the new business requirements.
  • Created UI screen mockups and prototypes for the proposed system, using Balsamiq, to provide a user-friendly front end for the proposed system.
  • Developed Use Cases, flow diagram, sequence diagram, using UML diagrams in MS Visio.
  • Worked on data integration, data migration, and data modeling. Worked with Informatica power center for extracting, transforming, loading, and maintaining the data.
  • Helped the data warehouse team with information to support th0e analysis of the data requirements for reporting and in defining the source to target data mappings, business rules and data definitions.
  • Helped translate Business processes into Informatica Mappings for building Data marts and used transformations of Informatica for various types of data conversions, and logical data modeling.
  • Assisted the data analyst with trigger functions like Insert, Update and Delete to maintain the data integrity and set specific procedures for the data flow in the data warehouse.
  • Executed SQL Join queries like outer join, inner join and cross join to pull data from multiple tables and validate the data for its accuracy and data integrity.

Environment: Waterfall, Informatica, MS Word, MS Excel, Outlook, MS Visio, MS Project, HP ALM, SQL,REST API, SOAP UI.

Confidential

Business Analyst

Responsibilities:

  • Performed Business Process re-engineering and Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
  • Elicited the business requirements for the project using One-One Interviews, Document analysis, Surveys, JAD sessions and used the standard template of the organization to develop requirements.
  • Used wireframes and screenshots for the application to easily communicate it to the users using MS Visio.
  • Conduct project related Presentations periodically to the management and end users during various phases of SDLC.
  • Used DDL, DML and DCL SQL queries to perform data analysis, data validation and data manipulation.
  • Working with Data warehouse team and source systems in preparing Data mapping documents and data models to procure the required data feeds into the Application.
  • Involved in data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse (EDW).
  • Used API’s to integrate various service providers through RESTful API services. Performed the API documentation and completed the API testing using POSTMAN.
  • Identified bugs during the test phase and reported using JIRA. Assisted the Testing team in creating Test Plans, Test Scenarios, Test Cases and collect Test Data for successful completion of Integration and Functional testing.
  • Conducted User Acceptance Testing with UAT cases and resolved issues with the users.
  • Generated different reports for predictive and exploratory analysis using IBM Cognos reporting tool.

Environment: Waterfall, MS Excel, MS Word, MS Visio, Lucid Chart, Test Manager, UAT, MS Project, SQL server, Cognos, HTML, CSS.

Continental

Business Analyst

Responsibilities:

  • Conducted formal interviews, Live Meetings and JAD sessions with business users Subject Matter Experts (SME's) to gather the requirements and transformed those into Business Requirement Document (BRD).
  • Prepared detailed Business Requirement Documents (BRD) to in corporate high-level business requirements, and Software Requirements Specification (SRS) for functional, non-functional requirements.
  • Monitored and assisted in designing and development of Use Cases, Activity Diagrams, Sequence Diagrams, using UML.
  • Worked on interface requirements for the Patient Appointment feature in the system that allowed the user to check the Doctor's availability & their schedule before finalizing the patient's appointment.
  • Maintained a Requirement Traceability Matrix to ensure that all Functional Requirements are addressed.
  • Worked with the Doctors & other Medical staff to understand the requirements for new features.
  • Worked on Capturing requirements for EHR/EMR from Physicians, Nurses, Diagnostic and Billing team.
  • Documented & validated the requirements for Patient Care Module which includes the IPD & OPD modules. The main components of IPD & OPD modules were Patient Appointments & Hospital visit history, as well as patient Admission details.
  • Worked on capturing the requirements for generating solutions for patient appointment & hospital visit history required a unique Patient MRN (Medical Record Number) to be generated so that these details could be tracked accordingly. It also needed the search feature so that a patient could be searched on MRN, Name & DOB.
  • Conducted User Acceptance Testing with UAT cases and resolved issues with the users.
  • Worked in close coordination with the QA analyst and testing team, reviewed and validated test plans, test cases and test scenarios.

Environment: Waterfall, MS Access, MS Visio, Sharepoint, MS Project, Windows XP, MS-Office, RTM, SQL.

Hire Now