Pavan Pathivada
Orlando,FL
Summary
Worked in the diversified roles of Project Manager/ Scrum Master and Lead Business Analyst for multiple clients. Has more than 15 years of exceptional work experience in providing product owner, business, and system analysis services for clients such as ABC Supply Co., Emblem Health, Centene, Aetna, Swiss Re, Nationwide, AllState and MetLife through Cognizant US Corp., and Infosys Ltd employers. Extensive experience of working as a Project Manager/ Scrum Master– Planned for business objectives in program increment (PI) meetings, hosted and drove product roadmap planning, product design planning and execution; helped identify dependencies and risks; helped prioritize program objectives based on business value; created user stories and helped document acceptance criteria, DOD, DOR; created working agreement; shared weekly and monthly Say/do, velocity and burn down charts with the management. Additionally gained proficiency as Lead Business Analyst for Broker and Consumer Salesforce products, FACETS application services, Oracle R12/ 11i apps modules and Enterprise Content Services' processes specific to IBM Datacap product for Claims, Medical Management, Enrolment, Correspondence applications. As Oracle ERP Analyst - significantly worked on Module tables based on Oracle apps (R12) such as General Ledger, Account Receivables, Order Management, Inventory, Account Payables, Purchase Order. Additionally, extensively worked on various business flows such as Order to Cash (O2C), Plan to Profit (P2P), Quote to Cash (Q2C) Worked as Business Analyst to capture requirements for generating book of business (BoB) reports based on Account Receivables and Payables. Worked on Snowflake Datawarehouses, Dbeaver, Informatica, Tableau, BitBucket, and powerBI tools. Experience of working on Oracle Applications/ E-business suite as Business Analyst in financials of Oracle applications. Certified CBAP – Certified Business Analyst Professional by International Institute of Business Analysis (IIBA). Official CBAP ID - CBAP36984. Certified SAFe 5 POPM by Scaled Agile Inc. Official Certificate ID – 12883415-6821 Certified CSPO - Certified Scrum Product Owner by Scrum Alliance. Official CSPO ID - C000713664. Certified SAFe 4 Agilist by Scaled Agile Inc. Official Certificate ID – 75394801-6562 Certified CSM - Certified Scrum Master by Scrum Alliance. Official CSM ID - C000713664.
Professional manager with significant expertise in overseeing complex projects and ensuring timely delivery. Skilled in strategic planning, budget management, and risk assessment. Strong focus on team collaboration, fostering results-driven environment, and adapting to changing needs. Known for reliability, leadership, and effective communication.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Lead Business Analyst/Project Manager
ABC Supply Co.
Chicago, IL, USA
06.2022 - 02.2025
- Objective is to generate the End of Month (EOM) P&L and General Ledger reports from different source systems and load them into Enterprise Analytics Hub for making them available to 800+ branches across multiple districts and regions across the enterprise.
- Contributed significantly as a R2R Business Analyst capturing requirements on EOM reporting for PLs and GL Trial Balance reports.
- Gained experience on multiple systems and their respective capabilities – Agility (R2R dashboards, CyberQuery reports, job schedulers, Pro2SQL DB); OneStream (Direct Connect capability); Mulesoft (Integration Jobs, APIs); Enterprise Analytics Hub (pipeline jobs) etc.
- Worked on delivering requirement documents, functional design documents, design review documents, project runbooks, process flow diagrams, UAT test scenarios on multiple occasions at the project level.
- Actively contributed to tasks corresponding to P2P (POs), Inventory adjustment w/i Locations, Branches, Districts, Supplier and Customer rebates, O2C (Credit Back, Invoice verification, Sales Order) etc.,.
- Working in the role of Lead Business Analyst - Engaging business and various project stakeholders to elicit, capture and document requirements, pain points, hidden needs and expected outcomes.
- Supported stakeholders with UAT testing for 800+ branches on generating the PL and GL files from multiple source systems (JDEdwards, Agility ERP, OneStream) and loading them into Enterprise Analytics Data Lake.
- Tools: Agility ERP, MS Project, PowerBI tools, OneStream, Mulesoft Integrations job, Enterprise Analytics Hub, SQL server management Studio, Outlook, One Note, SharePoint, MS PowerPoint, Excel, Word, and Visio.
Senior Consultant – Project Manager
Emblem Health
New York, NY, USA
01.2021 - 05.2022
- Objective is to transform and enhance Shop & enrol, QLE, Renewals work flows of subscribers and dependents in Broker and Consumer portals. The key goal of the project is to transform the business functionalities from legacy systems onto freshly built portals based on Salesforce platform and enhance their capabilities in response to emerging industry business needs and trends.
- Helped elicit and capture business requirements based on functional flows – Q2C, P2P and related flows.Supported the team by setting up principal/ non-principal users, buyers and assigning responsibilities to users.
- Setting up profile options, value sets for Account receivables and payables.
- Captured requirements for generating book of business (BoB) reports based on Account Receivables and Payables.
- Responsible for extracting data from legacy system using spreadsheet and uploading to Oracle system via WebADI.
- Experience of working on Module tables based on Oracle apps (R12) such as General Ledger, Account Receivables, Order Management, Inventory, Account Payables, Purchase Order.
- Working in the role of Lead Business Analyst - Engaging business and various project stakeholders to elicit, capture and document requirements, pain points, hidden needs and expected outcomes.
- Working on Salesforce applications – specifically Broker and Consumer portals to capture enhancement requirements on Shop & Enrol, QLE, & renewal business workflows for multiple LOBs (Individual & Family, Small Group, Large Group, Medicare Advantage and Medicare Supplement).
- Working on INSPIRE, FACETS, EDL systems – perform impact analysis for different upstream/ downstream systems especially for broker and consumer email communications, data load and transform between Salesforce, Facets and EDL systems
- Working on analyzing Sales Cloud/ Service cloud systems to capture requirements on Cases/ Opportunities created by the salesforce applications triggered by Shop & Enroll or QLE user processes.
- Supported stakeholders with UAT testing on Oracle modules for GL, INV, OM, AR, AP & PO.
- Tools: JIRA, MS Project, Salesforce, Oracle, Facets, Sales Cloud, Service Cloud, INSPIRE, EDL, Outlook, One Note, SharePoint, MS PowerPoint, Excel, Word, and Visio.
Consultant – Oracle ERP Analyst/ Scrum Master
CTS Corp.
Woodland Hills, CA, USA
03.2015 - 12.2020
- Worked on multiple projects which encompass a diversity of Infrastructure and Portfolio projects. One of the projects is specifically based on Account Receivables and General Ledger due to New Business and post issue. Through this project, I elicited AS-IS business processes from Auditors, documented requirements as user stories in JIRA for the Scrum Master to groom and prioritize for the sprints.
- Captured requirements specific to different module tables based on Oracle apps (R12) such as General Ledger, Account Receivables, Order Management, Inventory, Account Payables, Purchase Order.
- Worked on Dbeaver (Oracle DB – OnPrem); Snowflake (Cloud) analyzing ERP data and capturing transformation rules (STTMs) as part of data migration project.
- Wrote queries in Oracle & SQL to analyze patterns; profile data; understand and capture associations in replication databases etc.
- Analyzed Data Models to capture STTMs, Data Quality rules for reviewing with Enterprise Data Governance teams and Data Stewards.
- Worked on Cash management interface from various banks such as BoA, and JPMC.
- Worked on various interfaces involving SOA and BDD use cases.
- Elicited and captured requirements based on different business flows – O2C, P2P.
- Worked in the role of Scrum Master hosting various scrum ceremonies – daily scrum, backlog grooming, refinement & prioritization, sprint planning, review & retrospective.
- Also worked in the role of BSA, eliciting and documenting requirements in the form of user stories. Assisted product owner with burn down and sprint velocity charts.
- Assisted business in UAT and system testing of the deliverable BOTs using Pega Robotics Runtime. Documented AS-IS and TO-BE system and business process models using MS office suite and Visio. Assisted business by review and walkthrough of different deliverables during design, test and UAT phases.
- Performed the role of UAT test lead - documenting UAT test plans, hosting daily status calls, following defect management process, leading, and working with UAT test team till we got the sign-off from business.
- Tools: Oracle R12/ 11i ‘18, JIRA, MS Project, Confluence, Pega Robotics Studio (OpenSpan Suite), Pega Robotics Runtime, SQL Developer, SharePoint, Outlook, Visure, Quality Center, HP ALM, Lotus Notes (Mailbox and Database migrations), Alfresco, MS PowerPoint, Excel, Word, and Visio.
Senior Associate Consultant – Business Analyst
Multiple Clients
USA & India Locations
06.2009 - 03.2015
- Worked on multiple projects ranging from data migration projects, Infrastructure projects, Business LOB projects (claims, membership) etc., Data migration project, for instance, is targeted to enable a common data platform for multiple locations across the globe. Through this global-scale project, the data from source applications for each region is mapped and migrated to that of the target application in phases. Each Phase is broken down to iterations split b/w components of the target application.
- Elicited, gathered, and documented Business needs, Requirements, and User Stories from the client. Captured and documented Product and Sprint backlog items using themes, epics, and user stories.
- Hosted JAD sessions, Sprint planning, review, and retrospective discussions. Key Liaison between the Dev. team, Testing team and the Business Owners of the projects.
- Performed data analysis by running SQL queries via TOAD or SQL Server Mgmt. Studio.
- Captured tech debt user stories for the technical and testing teams to build on.
- Scheduled and hosted meetings to resolve any project impediments, dependencies.
- Hosted and facilitated Sprint review and retrospective as part of process improvement.
- Tools: MS Visio, IBM RTC, JIRA, SharePoint, MS Excel, MS Word, Windows, TOAD for Oracle 12.1, SQL Server (Data Analysis/ Data migration), Outlook
Education
Bachelor of Technology - Computer Science & Engineering
Jawaharlal Nehru Technological University
Kakinada, Andhra Pradesh, India05-2009
Skills
- Expertise of working in diversified roles as a project manager, and lead business analyst always guiding teams to better comprehend the stakeholder needs in the form of epics and user stories
- Develop and maintain Product roadmap and backlog to capture business themes, epics, and stories while collaborating with stakeholders to prioritize the highest impact work to be delivered soonest
- Ensure product deliverables meet business requirements by actively participating in identifying, designing, and testing solutions
- Expertise in JIRA – creating Features, creating/ maintaining product & sprint backlogs, creating/ updating user stories, exporting/ customizing agile scrum charts such as Cumulative flow chart, Burndown and Velocity charts
- Expertise in UML modelling through Use Case, Sequence and Activity flow diagrams
- Expertise in documenting and reviewing requirements, functional and design specifications, and test scenarios Experienced in hosting and actively participating in user story and backlog grooming sessions for various projects end-to-end
- Experience in Data analysis, Data mapping and querying Data Warehouse Worked with Data modelling tool to retrieve and analyse the key elements and table structures as part of a Data Migration project
- Proficient in performing data analysis using complex SQL and DB2 queries
- Working knowledge of Data extraction/ translation/ transform/ load (ETL) processes
- Played a significant role in supporting SIT, Regression and UAT testing of integrated modules prior to implementation
- Actively involved in UAT and helped users with test case and test scenario execution
- Experienced in performing GAP analysis, UAT, ROAM, SWOT analysis, Cost benefit analysis and ROI analysis
- Experienced in Module tables based on Oracle apps (R12) such as General Ledger, Account Receivables, Order Management, Inventory, Account Payables, Purchase Order
- Experienced in Tableau, APIWizard, WebADI and SplashBI tools
- Experienced in Oracle Applications/ E-business suite, as Business Analyst capturing requirements for financials of Oracle applications
- Excellent documentation, communication, and interpersonal skills
- Data & Process Modelling: MS Visio, MS Office PowerPoint (Smart Arts) Tools, PEGA Robotics Studio
- Methodologies/Frameworks: SAFe, SDLC, AGILE Scrum, PDLC (client SDLC)
- Database Tools: Snowflake cloud EDW, Netezza, Oracle, SQL Server, DB2, SQL Developer, MS Access
- Tools: Agility ERP, PowerBI tools, OneStream, MS Project, Enterprise Analytics Hub, Mulesoft, Oracle EBS 12R/ 11i apps, Snowflake, APIWizard, Dbeaver, WebADI, SOA, JIRA, Confluence, IBM Datacap Studio, Pega Robotics Engine (OpenSpan Suite), Visure, IBM Rational Team Concert (RTC), MS Office Suite, MS Visio, SharePoint, Outlook
- Project management
- Project planning
- Project planning and development
- Project scheduling
- Team collaboration
- Project tracking
- Relationship building
- Strategic planning
- Schedule management
- Client relations
- Stakeholder communications
- Staff management
- Work flow planning
- Advanced problem solving
- Budgeting and forecasting
- Risk management
- Project scope
- Budget control
- Coaching and mentoring
- Conflict management
- Agile methodology
- Performance improvements
- Resource allocation
- Forecasting
Accomplishments
- Supervised team of [Number] staff members.
- Achieved [Result] by introducing [Software] for [Type] tasks.
- Saved the company $[Amount] over [Number] years by implementing a successful productivity improvement plan.
Certification
- Title: POPM Governing Body: ‘Certified SAFe Product Owner/ Product Manager' by Scaled Agile Official ID#: 12883415-6821
- Title: CSPO Governing Body: ‘Certified Scrum Product Owner' by Scrum Alliance Official ID#: C000713664
- Title: CBAP Governing Body: ‘Certified Business Analyst Professional' by International Institute of Business Analysis (IIBA) Official ID#: CBAP36984
- Title: CSM Governing Body: ‘Certified Scrum Master' by Scrum Alliance Official ID#: C000713664
Timeline
Lead Business Analyst/Project Manager
ABC Supply Co.
06.2022 - 02.2025
Senior Consultant – Project Manager
Emblem Health
01.2021 - 05.2022
Consultant – Oracle ERP Analyst/ Scrum Master
CTS Corp.
03.2015 - 12.2020
Senior Associate Consultant – Business Analyst
Multiple Clients
06.2009 - 03.2015
Bachelor of Technology - Computer Science & Engineering
Jawaharlal Nehru Technological University