Business Analyst Process

JYOTHIRMAI ADUSUMILLI

Business Analyst ******************@*****.*** +1-614-***-****.

LinkedIn: linkedin.com/in/jyothirmai-adusumilli

PROFESSIONAL SUMMARY

Having strong 10+ yrs Experience as a Business Analyst & Project coordinator work experience in domains like Financial, Banking, Petroleum, Health Care, Manufacturing and Agtech (Agricultural Technology) projects with solid Expertise of Business Requirement gathering, Business Process flow, Business Process Modelling and Business Flow Diagrams.

I've worked on various methodologies like Agile, Waterfall, Kanban, UML with strong project management skills.

Participated in all phases of Software Development Life Cycle SDLC (Agile, SCRUM, RUP, and Iterative).

Extensive experience in analysing and requirements gathering and writing system functional specifications including use cases.

Business analyst with the strong ability to gather and document Business Requirements, proficient in SDLC, understand the workflow concept, ability to gather and document the 'As-Is' and 'To-Be' processes.

As a BA worked on preparing the documentations, worked in documenting the best practices for the client and ensured that the document is shared with all the stakeholders who are actively part of development.

Part of client discussions and ensured to respond to any client queries regarding the project.

Worked on CSAT scores for the project and ensured to take the key take aways from the project being delivered.

Proficient in ETL (Extract, Transform, Load) techniques, ensuring seamless data integration from various sources for enhanced operational efficiency and data accuracy."

Expertise with Microsoft SQL Stack including SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).

Developed critical thinking skills to analyze problematic solutions, seeking relevant data; diagnose information to solve problems and find the best solution while collaborating with stakeholders.

Responsible for a variety of tasks related to data analysis, such as data preparation, data cleansing, and data modeling part of that worked with large datasets and use various tools and techniques to extract insights and make data-driven decisions.

Extensive experience in executing GAP analysis, SWOT and PESTLE analysis, RCA, Impact Analysis, and many more to scrutinize business growth opportunities and verify the compatibility of the system infrastructure.

Proficient in creating business cases, user stories, wireframes, and technical documentation.

Skilled in managing requirements, coordinating with stakeholders, and overseeing end-to-end project lifecycles in both Agile and Waterfall environments.

Experienced in using tools like JIRA, Confluence, SOAP UI, and Postman for project management and API validation.

Extensively worked with the MS Office suite, especially Word and Excel, and I am highly proficient in using SAS programming or similar statistical programming languages. I have also planned, studied, researched, and evaluated current information and data systems and recommended changes as needed.

Developed Power BI dashboards for the target audience in the form of aesthetic visuals with the goal of compelling story telling.

Experienced in leveraging Databricks for advanced data analytics and Pega for streamlined business process management, driving efficiency and innovation across diverse industries.

Strong analytical and problem-solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies.

EDUCATION

University of Houston – Master of Business Analytics-USA-Graduated.

Gitam University – Bachelor of Business Administration (in Business Analytics)-IN-Graduated.

TECHNICAL SKILLS

Methodologies: Agile/Scrum, Waterfall, Hybrid Project Management

Database & Data Analysis Tools: Python, MySQL, MS Access, Excel, Power BI, Power Query, Databricks

Web Services and APIs: REST, SOAP, WSDL, Swagger

API Testing Tools: Postman, SOAP UI

Documentation: BRD, FRD, SRS, Use Case Diagram, Wireframes, Mock-ups, UML Diagrams, API documentation (Swagger, WSDL)

Project Management Tools: Trello, Jira, Kanban, Confluence, Release Burndown Charts, Task Board

Visualization Tools: Excel, Power BI, Tableau, MS Visio, Lucid Chart

Tracking Tools: Rational ClearQuest, JAD, RTM, PEGA, UAT, SQL

Analysis Skills: GAP Analysis, RCA, SWOT, Risk analysis, Cost-benefit analysis

Soft Skills: Communication, Analytical Thinking, Listening, Negotiation, Problem-solving, Team Management, Leadership, Attention-to-detail

PROFESSIONAL EXPERIENCE

Client: PayPal, Austin, TX. Oct’2022-Present

Role: Sr. Business Analyst

Industry: Financial and Banking.

Responsibilities:

Involved in the GAP analysis and documentation of the as-is and to-be process flow of the existing Quoting functionality documentation.

Evaluated options, risks and benefits associated with changes as it relates to system and service processing and analysed, designed, and developed complex business solutions and changes to administrative systems and interfaces.

Led requirement gathering sessions and documented business requirements, user stories, and acceptance criteria for ERP system implementation.

Developed and maintained detailed test scripts and cases, overseeing UAT to ensure quality standards.

Conducted business process analysis to optimize workflow efficiency and support system integration.

Managed project scope and communicated changes effectively across development, QA, and business teams using JIRA and Confluence.

Validated API services using Postman and SOAP UI, ensuring compliance with business requirements.

Assisted project manager with other in-progress project documentation like Project Plan, Scope Document, Issue Tracking report, etc.

Facilitated work-sessions with process users, developers, architect to elicit requirements to better understand their needs and present solutions using a Waterfall approach.

Extracted requirements from discussions with the stakeholders, refined and documented them into Business Requirement Documents (BRD) and Functional Requirement Documents (FRD)

Involved in documenting customization requirements, business rules and data migration requirements for the COTS implementation.

Conducted GAP analysis and documented process flows for Quoting functionality, employing Waterfall methodologies.

Utilized Python frameworks for back testing trading strategies and extracting financial data.

Leveraged Databricks for real-time monitoring of financial data streams and anomaly detection.

Integrated Pega systems to automate dispute resolution processes and enhance customer satisfaction.

Developed and implemented risk management strategies for capital market activities. Conducted risk assessments, identified potential risks, and devised mitigation plans to safeguard investments and portfolios.

Utilized statistical models, stress testing, and scenario analysis to evaluate and manage market, credit, and operational risks effectively.

Knowledge of Python frameworks and tools used for back testing trading strategies, such as back trader or zipline, to assess their performance using historical data.

Proficient in developing and deploying web scraping scripts in Python to extract financial data from websites and online sources for analysis and research.

Utilized Databricks platform for data processing and analysis tasks related to financial transactions.

Integrated Pega systems for streamlining customer onboarding processes and improving service delivery.

Leveraged Databricks for real-time monitoring of financial data streams and detecting anomalies.

Implemented Pega case management to automate dispute resolution processes and enhance customer satisfaction.

Conducted daily team review meetings to provide status and progress update to the project team.

Documented and refined underwriting rules to be utilized by the automated underwriting rules engine.

Proficient in analysing market trends, economic indicators, and financial news to assess market conditions and make informed investment decisions.

Familiarity with financial valuation methods such as discounted cash flow (DCF), price/earnings (P/E) ratio, and dividend discount model (DDM).

Client: Pacific Gas and Electric Company (PG&E), CA. Nov’2020–Sep’2022 Role: Sr. Business Analyst

Industry: Petroleum.

Responsibilities:

Gathered business requirements from end users and management.

Created high-quality functional requirement specifications for business systems.

Gathered and documented requirements for ERP modules, including AR, AP, and inventory management, aligning with business needs.

Developed business cases and performed gap analysis to support the implementation of new ERP features.

Coordinated with stakeholders to validate system changes and manage requirement modifications throughout the project lifecycle.

Oversaw the creation and validation of test plans, test cases, and QA activities to ensure system integrity.

Established and maintained positive business relationships with IT managers and clients.

Interpreted business objectives for the implementation of technical software applications.

Created and updated a weekly Natural Gas Storage/Withdrawal & Pricing Piece.

Facilitated Scrum Ceremonies, including Sprint Planning, Daily Sprint, Iteration review, release planning, Retrospective, and Backlog Refinement.

Documented end-to-end QA Test plan for Residential Rate Mailer project, including smoke testing, QA Validation, Verification, and Production testing.

Gathered business requirements and created functional specifications for business systems.

Utilized Databricks for analysing large datasets related to energy consumption and production.

Integrated Pega BPM solutions to automate workflows for pipeline maintenance and inspection.

Implemented predictive maintenance strategies using Databricks to optimize operational efficiency.

Documented the end-to-end billing process flows for Rate Mailer Onsert in Oracle CC&B.

Managed status reports on project issues and risks in JIRA for the Rate Mailer Project.

Prepared and updated Tableau Daily Dashboard and Metrics for the Residential Rate Mailer project.

Documented project closeout efforts, including a Lessons Learned initiative.

Employed Databricks for analysing large datasets related to energy consumption and production.

Integrated Pega BPM solutions to automate workflows for pipeline maintenance and inspection.

Utilized Databricks for predictive maintenance of petroleum infrastructure, optimizing operational efficiency.

Implemented Pega decisioning to streamline resource allocation for maintenance tasks based on real-time data analysis.

Worked with IT and Marketing teams to manage data validation and verification for data files sent to Targetbase and Salesforce for Pricing Products at PG&E.

Conducted sprint retrospective and followed up on action items for continuous improvement.

Actively involved in Pre-Analysis of projects with Subject Matter Experts (SMEs) and Development teams.

Actively involved throughout all steps of the Software Development Life Cycle (SDLC), including gathering Business/Functional Requirements, and managing internal R&D and client-sponsored web-based projects.

Client: Humana, Houston, TX. Dec’2019 – Oct’2020

Role: Business Analyst

Industry: Health Care.

Responsibilities:

Implemented SDLC for application development, adhering to standards and ensuring a systematic development life cycle.

Conducted requirements analysis for healthcare applications, developing detailed BRDs and FRDs.

Led workshops with stakeholders to capture business requirements and translate them into actionable tasks for the development team.

Created wireframes and user workflows to facilitate the design of user interfaces for new system features.

Managed testing activities, including UAT, to ensure alignment with business objectives and regulatory standards.

Interacted with healthcare clients to gather requirements, objectives, and input/output specifications.

Developed and executed front-end test cases manually, ensuring expected results and data accuracy during the data loading process.

Created Use case, Functional, and Mongo systems Object diagrams using MS Visio.

Reviewed design documents and business requirements to understand application function and scope.

Conducted X12 mapping for member and provider, including loops, segments, and elements.

Managed Procedure code mapping process and demonstrated expertise in Healthcare EDI Files (ANSI X12 - 270, 271, 837, 835, 834, 999).

Utilized Electronic Data Interchange (EDI) codes for patient eligibility verification, insurance benefits, and healthcare claims processing.

Leveraged Databricks for analysing healthcare data to identify trends and improve patient outcomes.

Integrated Pega customer engagement solutions to enhance member experience and streamline claims processing.

Implemented SDLC for application development, ensuring systematic lifecycle management.

Leveraged Databricks for healthcare data analysis, identifying trends and improving patient outcomes.

Integrated Pega solutions for enhanced customer engagement and claims processing automation.

Utilized Databricks for predictive analytics to identify potential healthcare fraud and abuse cases.

Implemented Pega robotic process automation (RPA) for automating repetitive tasks in claims processing, reducing processing time.

Led Daily Standup meetings, enforcing quality standards as per the build-release schedule.

Collaborated with business professionals to understand operational risks and risk reporting processes.

Developed detailed test strategy, plan, and cases covering all requirements.

Created Flowcharts and process diagrams using Microsoft Visio.

Facilitated communication with developers to resolve technical issues.

Extensive experience in Healthcare Payer - EDI, specializing in transactions like 837 Claims, 835, 997 Acknowledgements, 834 - Member Eligibility, 270/271 Eligibility Inquiry, 276/277 - Claims Inquiry.

Worked on claims and configuration to resolve provider issues, analysing Medicare and Medicaid guidelines.

Generated Business Requirement documents (BRD) and Functional Specification design documents.

Reporting Analyst responsible for gathering reporting requirements, developing reports in SQL Teradata, and creating dashboards.

Managed technical documentation of the website's content design using advanced formatting features.

Developed business requirements for FACETS batch process and conducted data mapping using the Facets data model.

Conducted JAD sessions, presented functional requirement reviews, and wrote SQL scripts for performance evaluation reports, demonstrating expertise in HIPAA-compliant ANSI X12 834, 837 formats.

Client: Atlas Copco, Pune, India. June’ 2015 –Dec’ 2018

Role: Business Analyst

Industry: Manufacturing.

Responsibilities:

Defined and managed requirements for Client Applications creating workflows for core components, essential features for new User ID registration and verification process, account management setup, consolidated delivery preferences and message center for all client communications.

Provided product support for development of a new Apigee Software API platform implementation that required documenting project requirements.

Gathered and documented business requirements for supply chain management modules within the ERP system, ensuring alignment with operational needs and business goals.

Led the creation of detailed technical documentation, including BRDs and FRDs, to support ERP system enhancements and integrations.

Facilitated cross-functional meetings with stakeholders to refine requirements and manage changes throughout the project lifecycle.

Developed test scripts and executed UAT to validate ERP system upgrades, focusing on modules like inventory management and procurement.

Conducted API validation using tools like Postman to ensure seamless integration between the ERP system and external vendor management systems.

Managed project scope and delivery timelines using JIRA and Confluence, ensuring all requirements were met on time and within budget.

Technical specifications manual, standard operating procedures, workflows to engage client-side end to end API integration.

Presented to senior business team and is now used as a standard.

Detailed use case scenarios and centralized work process flows to help resolve Trade Order ticket status issues.

Collaborated with cross-functional teams to streamline supply chain processes, resulting in a notable reduction in production lead times.

Defined and managed requirements for client applications, streamlining supply chain processes.

Employed Databricks for analyzing manufacturing data to optimize production processes.

Integrated Pega BPM solutions for automating manufacturing workflows and quality control.

Implemented predictive maintenance using Databricks to reduce downtime and maintenance costs.

Developed and maintained detailed reports on key performance indicators (KPIs), enabling real-time monitoring of production processes and facilitating data-driven decision-making.

Conducted regular audits and assessments to identify areas for improvement, leading to a significant decrease in defects and production errors.

Employed Databricks for analyzing manufacturing data to optimize production processes and reduce downtime.

Integrated Pega BPM solutions for automating manufacturing workflows, including supply chain management and inventory control.

Utilized Databricks for predictive maintenance of manufacturing equipment, reducing maintenance costs.

Implemented Pega case management for handling quality control incidents and product recalls in real time.

Implemented vendor performance evaluation metrics, enhancing accountability, and fostering long-term partnerships.

Facilitated communication and collaboration between various departments, ensuring seamless integration of business processes for enhanced overall efficiency.

Authored and maintained detailed documentation, including user manuals and standard operating procedures, to ensure a standardized approach to manufacturing processes.

Client: Syngenta, Pune, India. July’2013–May’2015

Role: Business Analyst

Industry: Agtech (Agricultural Technology).

Responsibilities:

Created and delivered weekly management reports for project planning and implementation activities on all project initiatives for both onshore and offshore resources.

Lead Facilitator between offshore and onshore teams, leading design review sessions, with project and delivery managers.

Captured and analyzed business requirements for agricultural technology solutions integrated with ERP systems, focusing on improving data management and process efficiency.

Developed wireframes and process flows to visualize user interfaces and system workflows, aiding in the development of new ERP functionalities.

Collaborated with business units and IT teams to ensure the successful implementation of ERP modules related to supply chain and inventory management.

Conducted UAT and regression testing to ensure ERP system enhancements met business needs and maintained data integrity.

Used Swagger for API documentation and performed validation using SOAP UI to ensure reliable data exchange between ERP and IoT systems.

Managed stakeholder communication and project progress tracking through regular updates and status reports, using Confluence and JIRA for effective project management.

Partnered with Risk and Audit to ensure Client Onboarding system meet all compliance requirements.

Lead Developer utilizing Lotus Notes to design and develop numerous applications across Finance, Worldwide Securities and Treasury Services.

Created and defined requirements and workflow documentation for a new Letter of Credit and Expense Management Application.

Collaborated with cross-functional teams to create and implement comprehensive project plans, ensuring seamless project execution.

Leveraged data analysis skills to extract actionable insights, contributing to informed decision-making processes.

Fostered effective communication and collaboration with stakeholders, including farmers, suppliers, and internal teams, to gather insights and address business needs.

Collaborated with legal and regulatory teams to integrate compliance requirements into system design and implementation processes.

Utilized Databricks platform for analysing agricultural data to improve crop yield and optimize resource usage.

Led project planning and implementation activities, ensuring alignment with business objectives.

Utilized Databricks for agricultural data analysis, improving crop yield and resource optimization.

Integrated Pega decisioning solutions for personalized agricultural recommendations based on real-time data.

Collaborated with IT teams to integrate cutting-edge technologies for precision farming and IoT applications.

Integrated Pega decisioning solutions for personalized agricultural recommendations based on real-time weather and soil data.

Leveraged Databricks for predictive analytics to forecast crop diseases and pest infestations.

Implemented Pega customer service solutions for managing farmer inquiries and complaints in real time.

Collaborated with IT teams to integrate cutting-edge technologies for precision farming, data analytics, and IoT applications.

Conducted regular reviews of existing systems, recommending, and implementing changes to increase operational effectiveness.

Led cross-functional teams in the development and execution of projects, ensuring alignment with business objectives and timelines.

Negotiate contracts and service level agreements to optimize vendor performance and deliverables.

Contact this candidate