Advance Excel
Ayan Dutta
Process Associate
Shibpur
Summary
Ambitious associate with a proven track record of prioritizing tasks and meeting deadlines under pressure. Specializing in risk management, corporate finance, and performance optimization, bringing over 3 years of experience in R2R & PTP. Proficient in Oracle and equipped with strong analytical abilities to drive organizational success.
Overview
3
3
years of professional experience
2021
2021
years of post-secondary education
3
3
Languages
Work History
Process Associate (FP&A Analyst)
Tata Consultancy Services
Kolkata
04.2025 - Current
- Reconciliation After Month End.
- Reporting Activities Quarter End And Month End.
- Uploading Reconciliation In Trintech.
- Maintain overtime accrual posting and reporting to the client.
- Reporting: Accrual and actual report preparation.
- Journal preparation & uploading in SAP.
- Quarterly budget report analysis.
- FP&A Analysts track key performance indicators (KPIs) and monitor business performance.
Process Associate (RTR & PTP)
Capgemini Technologies PVT. LTD
Kolkata
02.2022 - 01.2025
- Performed account reconciliation regarding company finance and payroll.
- Prepare & upload Journal Entries.
- Performed Fixed Assets Reconciliation.
- Handled month-end/ Year-end close activities, intercompany.
- Performed Bank Reconciliation.
- Revenue Generation & Reporting: Prepared reports (including missing bill rates, time, and expense reports).
- Project code Creation & Maintenance: Successfully managed project code Creation and amendments.
- Transfer Price Update in Oracle: Maintaining and updating transfer-pricing data in Oracle ERP for accurate.
- Power BI Report Preparation: Designing and developing Power BI reports to provide insights and enhancements.
- Up-skilling Team Members: Mentored and trained new hires on company financial procedures and software applications.
- Responsible for operation, maintenance, and efficiency tracking of invoices.
- Apply different methods of advanced excel formulas according to supplier bills.
- Invoice implementation of utility service's for continuous improvement process.
- Actively responsible for timely payments.
- High value invoice analysis and upload to the various client portals.
Education
Bachelor of Commerce -
CALCUTTA UNIVERSITY
04.2001 - 01.2015
HS -
WEST BENGAL COUNCIL OF HIGHER SECONDARY EDUCATION [WBCHSE]
Kolkata, India01-2015
Madhyamik -
WEST BENGAL BOARD OF SECONDARY EDUCATION [WBBSE]
Howrah, India 01.2013 - 01.2009
Skills
- Advance Excel
- Oracle
- Financial Reporting
- Process improvement
- Workflow management
- Process documentation
Personal Information
- Date of Birth: 07/26/93
- Nationality: Indian
- Marital Status: Married
Accomplishments
- Rising Star Award - For continuous learning and processing
improvement.
- Xtra-Mile Award - Awarded XtraMile for process improvements and smooth service delivery.
- Process Optimization - Optimized reporting processes, saving 10 hours per week and successfully managed project code amendments.
- Highlighted by management and client for being able to deliver quality services.
- Never got an escalation.
- Successfully Managed two transitions from client.
Software
GFS Oracle
SAP EC6
SAP reporting tool
Anaplan
Trintech
Orchard Portal
Timeline
Process Associate (FP&A Analyst)
Tata Consultancy Services
04.2025 - Current
Process Associate (RTR & PTP)
Capgemini Technologies PVT. LTD
02.2022 - 01.2025
Madhyamik -
WEST BENGAL BOARD OF SECONDARY EDUCATION [WBBSE]
01.2013 - 01.2009
Bachelor of Commerce -
CALCUTTA UNIVERSITY
04.2001 - 01.2015
HS -
WEST BENGAL COUNCIL OF HIGHER SECONDARY EDUCATION [WBCHSE]
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Rathijit DasguptaRathijit Dasgupta
Construction Manager (Survey) -GRADE-CM3 at AFCONS INSFRASTRUCTURES LIMITEDConstruction Manager (Survey) -GRADE-CM3 at AFCONS INSFRASTRUCTURES LIMITED