Rupsa Dey
Kolkata
Summary
Results-driven RPA Business Analyst with experience in automation strategy, solution design, and RPA platform administration. Ability to lead end-to-end automation initiatives, manage bot ecosystems, and deliver scalable solutions across SAP-integrated procurement processes. Experience in stakeholder leadership, governance, and driving measurable efficiency gains.
Overview
7
7
years of professional experience
1
1
Certification
Work History
RPA Business Analyst
Tata Consultancy Services
Kolkata
01.2022 - Current
- Implemented procurement automation bots to enhance operational efficiency and streamline processes.
- Conducted root cause analysis to identify system issues and implemented long-term fixes.
- Enhanced system performance and user experience through cross-functional collaboration.
- Identified automation opportunities to optimize procurement workflows and spearheaded bot implementation initiatives.
- Optimized procurement workflows to enhance process efficiency and drive business outcomes.
- Defined business requirements to ensure alignment with project objectives and stakeholder expectations.
- Collaborated with developers by delivering precise functional specifications and implementation guidance.
- Collaborated with IT specialists to design and refine system specifications for business applications.
- Developed and implemented data analysis methodologies to support strategic decision-making.
- Helped clients enhance internal structures and improve handling of current and potential problems.
- Executed end-to-end testing deployment and provided post-production support for automation solutions.
- Spearheaded end-to-end documentation processes, encompassing process flows, business requirements documents, and user guides.
- Led user acceptance testing to validate functionality and performance against business requirements.
- Monitored current systems and staff activities to compile detailed and current information.
- Utilized advanced Excel functions to manipulate large datasets for insightful reporting.
- Conducted market research to inform product development strategies and competitive positioning.
Process SME/ Analyst
Tata Consultancy Services
Kolkata
05.2019 - 12.2021
- Acted as Subject Matter Expert (SME) for end-to-end utility complaint management processes within regulatory timelines.
- Managed and led a team of, ensuring performance, quality, and SLA adherence.
- Conducted training and upskilling sessions to improve team capability and process accuracy.
- Developed L2 process maps and SOPs to standardize complaint handling and improve efficiency.
- Handled client and stakeholder interactions, providing insights on process improvements and regulatory compliance.
- Advised clients on alternative process approaches to optimize complaint resolution within the 28-day window.
- Managed critical escalations and ensured timely resolution to avoid regulatory risks.
- Performed root cause analysis and implemented process improvements to reduce complaint volumes.
- Identified process inefficiencies and automation opportunities, forming the foundation for transition into RPA.
- Domain Expertise: Purchase Requisition (PR) to Purchase Order (PO) Generation, Vendor Management, LPP (Last Purchase Price) Analysis, Quality Control, Outlook Report and Analysis and Utilities.
Education
B.Com (Honours) - Accounting & Finance
Heramba Chandra College
Kolkata, WB01-2018
Skills
- Requirement gathering
- Agile methodologies
- Data analysis
- End to End automation implementation
- UAT & Release management
- Process optimization & automation
- Stakeholder engagement & leadership
- Documentation processes
- Root cause analysis and resolution
- Advanced MS Excel (VBA)
- MS PowerPoint Expertise
- Performance monitoring & Reporting
- Stakeholder relationship management
- Process improvements
- Leadership effectiveness
- Quality Control Analysis
- SAP ERP SAP systems
- Technology integration planning
- Software debugging
- Technical troubleshooting & support
- L2 Decision Tree design
- Complaint resolution optimization
- Automation implementation
- User acceptance testing
- MS Excel Expretise
- MS Powerpoint Expertise
- Performance monitoring
Certification
- Contextual Master Certification
- Advanced Microsoft Office
Accomplishments
- Led cross-functional teams ensuring seamless delivery of automation projects
- Eliminated manual errors by implementing automated validation checks
- Identified and optimized project workflows, improving turnaround time
- Designed end to end project based automation solution integrating SAP, cybersecurity and approval workflows
- Designed and implemented L2 decision framework (Utility domain) to streamline complaint handing within regulatory timelines
- Reduced client complaint inventory by 7.5% improving operation performance
- Avoided potential regulatory penalties through proactive resolution mechanism
- Successfully completed Contextual master
Custom Section
- Visual Basic for Application
- VB.Net
- Python
Hobbies and Interests
- Dancing
- Cooking
- Meditation
Projects
- Vendor Panel Creation, Automated vendor panel creation., VB. Net, SAP, ECM and MS Excel, 250, 2025-05-01, 30000 min/month
- Source List Update and RFQ Float, Automated RFQ creation and maintenance of source list of the vendors., VB, SAP, EProc and MS Excel, 250, 2025-10-01, 21200 min/month
- Auto Tabulation, Provide the quotation detail in a tabular format for further negotiation., VBA, SAP, EProc, DNF portal and MS Excel, 250, 2021-08-01, 60000 min/month
- Auto PO Generation, Developed a suite of bots to automate the creation of repeat and fresh Purchase Orders in SAP., VB, SAP, MS Excel, 250, 2022-03-01, 38000 min/month
- PDF to Excel Converter, Captures the data points from the designated PDF and converts the same to excel column., VBA, PDF, MS Excel, 130, 2022-03-01, 23200 min/month
- Outlook Manager, Automating Reporting and Managing outlook., VBA, MS Outlook, VBA and Excel, 150, 2026-04-01, 20500 min/month
Timeline
RPA Business Analyst
Tata Consultancy Services
01.2022 - Current
Process SME/ Analyst
Tata Consultancy Services
05.2019 - 12.2021
B.Com (Honours) - Accounting & Finance
Heramba Chandra College