JOHN ROSARIO FERNANDES

MIS Expertise: Over 8 years of experience in Excel, with proficiency in VLOOKUP, HLOOKUP, Pivot Tables, Slicers, nested IF statements, Macros, Visual Basics, Power Query, and dynamic dashboards

Software Proficiency: Advanced user of MS Office (Word, Excel, PowerPoint, Outlook) and Crystal Reports Expertise in PowerPoint includes graph automation, dashboards, and use of Macros and Visual Basics

Project Management Tools: Proficient in JIRA & Confluence for project and content management

Reporting & Analysis: Demonstrated ability in MIS reporting, automating Excel reports, and generating insightful analysis through pivot tables and custom spreadsheets

Project Management: Track record of ensuring timely project completion, adapting work based on evolving needs, and managing stakeholder relationships effectively

Team Leadership: Managed teams and shift operations, achieving key performance indicators and targets

Client Management: Proficient in understanding client requirements and offering tailored solutions, with experience in cross-selling to enhance company profitability

Technical Support: Offered extensive technical support across various roles, assisting customers with diverse queries

Administrative & Operations: Strong background in workforce management, real-time queue management, and maintaining shift adherence

Communication: Adept communicator with excellent oral and written skills, experience in crafting effective presentations, and handling customer queries

Interpersonal Abilities: Demonstrated excellence in interpersonal skills, able to collaborate with diverse teams and managers

Problem-solving: Proven analytical abilities and creative problem-solving skills