Trijit Moulik
Sandhya apartment 1 floor , Ajaynagar st South Dumdum, Kolkata
Summary
Results-driven MIS Executive with 6+ years of experience in data analysis and reporting within utility and retail sectors. Expertise in VBA and Excel, proficient in managing large datasets and delivering actionable insights. Strong leadership and communication skills enhance team collaboration and project outcomes. Committed to leveraging analytical capabilities to drive organizational success.
Overview
9
9
years of professional experience
Work History
MIS Reporting Analyst
TATA CONSULTANCY SERVICES
Kolkata
09.2021 - 09.2024
- Advanced to MIS Analyst; gained proficiency in VBA and advanced Excel for reporting and automation projects.
- Partnered with Advanced Analytics Reporting team to design automated reports utilizing VBA and Power BI, improving reporting accuracy and decreasing turnaround time by 30%
- Mentored project team leads on streamlined reporting dashboards and methodologies, enhancing overall team performance through implementation of structured data visualizations.
- Facilitated data mapping and analysis to maintain compliance with high-risk clients, elevating service delivery metrics for project management by fulfilling KPI & KRA
- Developed and maintained executive-level MIS reports for senior management.
- Performed root cause analysis on discrepancies between source systems and target systems.
- Mitigated risks by leading and auditing international subsidiaries and operational processes.
Associate - MIS and Dashboard Reporting
TATA Consultancy Services
Kolkata
03.2019 - 08.2021
- Analyzed complex datasets to extract actionable insights for stakeholders.
- Created detailed documentation for reporting procedures and system usage.
- Identified areas for improvement in existing reporting processes and implemented changes accordingly.
Customer Service Representative
TATA CONSULTANCY SERVICES
Kolkata
01.2016 - 02.2019
- Delivered customer support for Australian utility compliance processes, ensuring timely resolution of queries.
- Managed front office operations and provided accurate solutions to client issues.
- Handled SAP transactions across the utility and retail domains.
- Responded promptly to customer inquiries, improving satisfaction levels.
- Coordinated with teams to resolve escalated issues effectively.
- Maintained customer interaction records in CRM tools.
- Analyzed data to support process improvements.
- Created MIS reports to track performance metrics.
Education
Bachelor of Science - Science
University Of Calcutta
India07-2016
Skills
- Advanced Excel
- Excel analytics
- Agile practices
- VBA macro proficiency
- Statistical analysis and insights
- RCA-based process enhancement
- Effective communication
- Mentorship and training
- Analytical thinking
- Process optimization
- Data visualization (Power BI)
- Client relationship management
Languages
Bengali
First Language
English
Proficient (C2)
C2
Hindi
Upper Intermediate (B2)
B2
Accomplishments
- Report Automation: Automated major reports using VBA, Excel, and Power BI, reducing manual effort by 40% and improving decision-making accuracy in operations reporting.
- Data Compliance Initiative: Mapped and streamlined customer service processes in the utilities domain to ensure 100% regulatory compliance, boosting satisfaction to 98%.
- Escalation Matrix Dashboard: Built a VBA-based escalation matrix linked with Outlook for the telecom domain to automate follow-ups and minimize reporting errors.
- Adjustment Dashboard: Created a VBA-powered adjustment file automation tool for the automotive retail sector, saving 40 hours annually.
- Stock Maintenance Tool: Developed an inventory calculation tool using VBA for the automotive domain, saving 28 FTE hours per month.
- Productivity Bonus Tracker: Built a monthly performance and incentive tracking dashboard for the energy and utilities sector.
- Audit Tools: Designed a quality audit randomizer and data screening tool for the hospitality and customer service domain, reducing error probability by 10%
Timeline
MIS Reporting Analyst
TATA CONSULTANCY SERVICES
09.2021 - 09.2024
Associate - MIS and Dashboard Reporting
TATA Consultancy Services
03.2019 - 08.2021
Customer Service Representative
TATA CONSULTANCY SERVICES
01.2016 - 02.2019
Bachelor of Science - Science
University Of Calcutta
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
ASWINI KUMAR SHARMAASWINI KUMAR SHARMA
Associate General Manager – Procurement at AMPIN Energy Transition Pvt. Ltd.Associate General Manager – Procurement at AMPIN Energy Transition Pvt. Ltd.