AKSHAY MOGARKAR
Pune
Summary
Business Analyst with proven expertise in SQL and advanced Power BI, successfully automated reporting processes at Pine Labs, achieving a 40% reduction in manual work. Proficient in API testing and documentation, facilitating effective collaboration through JIRA and Confluence. Delivered actionable insights and solutions that enhanced operational efficiency.
Overview
4
4
years of professional experience
Work History
Business Analyst
Pine Labs
Pune
07.2024 - Current
- Automated reporting using SQL & Excel; reduced manual work by 40%.
- Conducted API testing with Postman and Swagger for POS integrations.
- Managed logic for pricing & EMI options. Created dashboards with Power BI.
- Documented UAT, used JIRA and Confluence for collaboration.
Functional Business Analyst
Paytm
05.2023 - 04.2024
- Developed Power BI & Excel dashboards; analyzed onboarding funnels with SQL.
- API testing with Postman; created BRD, FRD, and user stories.
- Used JIRA and Confluence for agile tracking.
Junior Business Analyst
NoBrokerHood
02.2022 - 04.2023
- Created visitor & incident dashboards with Excel; analyzed data with SQL.
- Tested payment APIs via Postman; supported automation efforts.
- Used Trello for coordination.
MIS Executive
OLX HR / Assanjob Pvt Ltd
12.2018 - 06.2020
- Created Excel-based dashboards; handled SQL data queries.
- Streamlined daily reports and automated manual tasks.
Education
Bachelor of Engineering - Mechanical
SGBAU
Amravati01.2018
Skills
- Power BI and Excel (advanced)
- SQL database management
- API testing with Postman
- Documentation with Swagger
- Salesforce (basic) usage
- SAP (basic) knowledge
- SharePoint collaboration
- Project management with JIRA
- Team collaboration in Confluence
- Task organization using Trello
- Project tracking in Smartsheet
- Business requirements documentation (BRD)
- Functional requirements documentation (FRD)
- UML modeling techniques
- BPMN process mapping
- Lucidchart diagramming
- Miro brainstorming tools
- ChatGPT integration
- Notion AI productivity tools
- Figma AI design tools
- Microsoft Copilot assistance
Languages
- English
- Hindi
- Marathi
Tools And Technical Skills
- Analysis & Reporting: Power BI, Excel (Advanced), SQL
- API & Integration: Postman, Swagger
- CRM & ERP: Salesforce (basic), SAP (basic), SharePoint
- Project Management: JIRA, Confluence, Trello, Smartsheet
- Documentation: BRD, FRD, UML, BPMN
- UI/UX Tools: Lucidchart, Miro
- AI Tools: ChatGPT, Notion AI, Figma AI, Microsoft Copilot
Project Highlights
- Seamless Payment Integration, Pine Labs, Integrated POS with dashboards; tested via Postman. Built Power BI dashboards.
- Merchant Business App, Paytm, Built onboarding and analytics dashboards using SQL & Power BI.
- Community Operations, NoBrokerHood, Built Excel dashboards; automated incident tracking and analyzed payment APIs.
Timeline
Business Analyst
Pine Labs
07.2024 - Current
Functional Business Analyst
Paytm
05.2023 - 04.2024
Junior Business Analyst
NoBrokerHood
02.2022 - 04.2023
MIS Executive
OLX HR / Assanjob Pvt Ltd
12.2018 - 06.2020
Bachelor of Engineering - Mechanical
SGBAU
Similar Profiles
Sujit TapkirSujit Tapkir
Tember Technical Staff-1-Engineering at Pine LabsTember Technical Staff-1-Engineering at Pine Labs
Mahek KarnikMahek Karnik
Senior Business Analyst at Pine LabsSenior Business Analyst at Pine Labs
Arun K ValliappanArun K Valliappan
Senior Manager - Global Events & Field Marketing at Pine LabsSenior Manager - Global Events & Field Marketing at Pine Labs
ANUPAM ADHIKARIANUPAM ADHIKARI
Senior Product Manager (B2B) at Pine LabsSenior Product Manager (B2B) at Pine Labs
Amol Dilip WaniAmol Dilip Wani
Senior Specialist – Client Services Project Manager at NICE Interactive SolutionsSenior Specialist – Client Services Project Manager at NICE Interactive Solutions