Pratik Bele

Experience

• 

  Accenture in India

  Jun 2017 - Feb 2022

  The objective of the project was to create a Data Warehouse to enable and support BI activities using AWS and utilized it to consolidate large amounts of data to build reports & dashboards depicting KPI using IBM Cognos as analytics tool.• Designed & derived Agency/Vendor facing KPI’s under different categories like Volume, Cost, Quality, Cycle Time and Performance with different visualizations like Box & Whisker Plot, Stacked & Grouped graphs, etc.• Being a Functional Expert provided Dev team with the right set of Tables and key data points from backend to build the Reporting tables which then were used to build KPI’s on Front-end using IBM Cognos.• Built and reviewed high-level dashboard test scenarios for KPI’s and was actively involving in test planning and preparation activities with Testing Team.• Built SQL Queries to take extract of data from PROD and built reports and KPI’s in MS Excel which was then used as a benchmark while testing the KPI’s on dashboard.• Received “Shared Catalyst Award” for effectively collaborating with clients, senior management, stakeholders, & end users to define project scope, business goals, objectives, requirements and implement & deliver cost effective solutions.• Assisted client in the development of business requirements, including identification of opportunities for improvement and optimization of business processes by building as-is & to-be diagram for GAP analysis for three complex financial modules in Procurement.• Led and Managed a team of 3 Business Analysts in preparing and reviewing all business analysis artefacts and coordinated with clients, senior management and important stakeholders for quick approval of change requests over change log meeting.• Prepared Business Requirements Documentation (BRD), Functional requirement Documentation (FSD) followed the UML based methods by using MS Visio to create use cases, activity diagrams, sequence diagrams, and collaboration diagrams. Show less • Translating prioritized initiatives into detailed feature plans to deliver product that is stable in production and satisfying scalability, reliability, performance, and business goals.• Building & maintaining relationships with cross-functional internal teams & external customers to understand user needs, translating findings to actionable feature planning artifacts, and prioritizing feature/defect backlog.• Managed a team of 3 Analyst/Senior Analyst in automating 60% of manual TC’s of smoke & regression suite for UI/Non-UI, Database/API testing using TOSCA and built complex SQL queries used for data driven testing.• Worked on DevOps transformation and CI/CD pipeline implementation using TOSCA and Jenkins for the clients and saved 30% of the budget by streamlined processes for easy replication and faster delivery on production environment.• Built Productivity Dashboard using Power BI for managing/forecasting Business/Dev/Test deliverables. Show less • Built detailed and comprehensive business analysis artefacts with lead/senior BAs, clients, stakeholders and end users, to identify system and operational requirements and improvements in two complex and critical modules for both Internal/External releases.• Reviewed and wrote high level quality assurance QA artefacts to maximize the coverage and prioritize scenarios and requirements, which led to identify 60% of the total defects logged across SIT cycles in the first cycle. • Acted as a liaison between the Dev & QA team over triage/change log call to assure faster resolution to conflicts & understanding gaps, as a result only 10% of the total change log/defect were logged under my modules.• Built an automation process for routine check of all testing environment using TOSCA, which not only reduced the acknowledgement time of a critical issue by 20% but also decreased the monitoring cost by 10%. Show less

  • Senior Business Analyst

    Jun 2020 - Feb 2022

  • Business Analyst

    Jun 2019 - May 2020

  • Associate Software Engineer

    Jun 2017 - May 2019
• 

  Capgemini

  Feb 2022 - Apr 2023

  Consultant | Senior Business Analyst

  Client - Barclays• The project objective was to create a Data Lake and Data Warehouse on Granular Trail Balance dataset fetched from multiple data sources using Apache Hadoop to drive BI activities by consolidating data into Data/Reporting Marts and build Webforms and Reports based on Financial Control team’s requirements.• Built Mapping documents for different staging layer in Hadoop to cater to different attributes requirement for Auto-Balancing, Auto Defaulting/Enrichment and Stitching which also included custom attributes that needed derivation logic.• Built detailed and comprehensive business analysis artefacts like BRD’s, EPIC & User Stories to identify system and operational requirements for multiple releases in conjunction with Financial Controller’s team. Show less

• 

  Iris Software Inc.

  Apr 2023 - now

  Senior Business Analyst

  Client - Citi• Built Data Analysis and Mapping documents for source to target and reporting layer mapping and preparing data model to cater to adding custom attributes that needed derivation logic on existing data mart.• Conducted weekly Requirement Gathering sessions with business stakeholders at career level VP, SVP and Directors to prepare BA artefacts like BRD’s, EPIC & User Stories.• Ran scrum calls for every sprint to make sure DB/UI/Product teams are in sync and on track with respect to current sprint deliverables and address any roadblocks.• Acted as a product owner to build dashboards roadmap and precisely planed sprints by tracking all the prioritized items on Product/Sprint Backlog. Show less