Praveen Gopinathan

MIS & Business Analytics Team Lead (PQM-Operations)

• Designed and implemented scalable data repositories and data lakes, transitioning the organization to advanced Power BI solutions.
• Developed actionable insights from bureau scrub reports, aiding strategic decisions, and operational improvements.
• Produced investor presentations and Board-level dossiers showcasing company performance and aligning with strategic goals.
• Partnered in high-level business review meetings, providing advanced analytics, and data presentations to drive strategic outcomes.
• Successfully managed award event presentations, and other critical corporate communication materials.

Key Achievements

• Team Leadership: Successfully hired as the first Team Lead for the MIS/Analytics team, growing the team from 3 to 8 skilled members across 4 verticals, leveraging state-of-the-art technologies.
• Data Transformation: Spearheaded the transformation of the data ecosystem from Microsoft Excel to Power BI, building robust data repositories, data lakes, and advanced big data models for decision-making solutions.
• Investment Support: Played a pivotal role in the successful Due Diligence (DD) of GPC, providing accurate and timely data insights, resulting in a ₹600 crore investment.
• Strategic Insights: Developed high-level business models, including Static Pool Analysis and Fresh Flow decks, to enhance management's decision-making.
• Reporting Excellence: Revolutionized reporting frameworks with advanced Power BI dashboards and Excel, earning recognition from the Board for exceptional presentations and timely insights.
• IPO Support: Acted as a key contributor to IPO activities, providing comprehensive data solutions, bureau scrub reports, and investor presentations aligned with strategic goals.
• Team Development: Groomed team members with leadership skills, enabling them to take on critical responsibilities as needed.
• Regulatory Compliance: Managed data requirements for regulatory, external, audit, and internal stakeholders, ensuring compliance and operational excellence.
• Field MIS Team: Established regional MIS teams to ensure timely and accurate local data feeders, enhancing operational efficiency.

• Company Overview: UAE Exchange is a leading global money transfer and foreign currency exchange brand trusted by millions of customers and partners, across the world
• Expertise in Analytical presentations (infographics & dashboards) for different product verticals, making the same more appealing and easy to understand
• Prepare a global dashboard consolidating all business of UAEExchange and provide indicators on transaction counts, volume and revenue from these transactions
• Analyze RPTs for products and corridors and provide trend analysis on the same
• Segment wise pestle analysis in terms of Business Units, Products & Customers
• Digital/Online Performance Report with detailed analysis on country wise and corridor wise transactions
• Analyze the average ticket sizes for transactions done to each corridor, Study and report the customer acquisitions and average number of transaction done for each month
• Track and report the performance of Corporate and Individual transactions
• Analyze & report the variance and the reasons for variance against Yearly and Monthly Budgets
• Report the monthly and yearly income and expenses for the segment
• Relate the transaction counts with revenue and report RPT movements
• KPI driven report on performance of Arab Corridor remittances with detailed analysis on country wise and corridor wise transactions
• Study the customer behavior i.e
• Bankwise and product wise preferences of customers and frequency of transactions
• Report the inactive customers for the purpose of reviving the relationship
• Research, Generate & Circulate Quarterly report on Market Share of UAE Exchange from & to different corridors and geographies
• Generate report on upselling and cross selling of products/services
• Identify opportunities of cross selling and upselling in different geographies of UAEExchange Business with valid reasoning
• Generate report on the effectiveness of marketing promotions/campaigns, identify the revenue from the same and report the profitability of the activity
• Reporting the monthly MIS for key business areas viz
• Remittances, Foreign Currency Exchange, Smart Pay Solutions (Salary disbursals), Prepaid Cards (Smart Pay & Go cash multicurrency travel cards powered by Master card) & Allied products (Cash Collection services)
• Generate and report the performance of Dubai Metro Branches aligning the same to the Market info relating to the increase in commuters, to identify further opportunities and study on customer acquisition
• Competitive analysis on major players in this segment to further analyze on the cannibalization effect
• Generate Customer Analytics reports for the product & business verticals to study the customer demographics, behavior, preferences enabling cross selling opportunities and focused Marketing campaigns
• Generating & reporting Travel, Capex, and Opex costs for the Business Units and Central & Shared departments across the company to identify the effectiveness of the costs incurred and curtailing the same
• Involved heavily in creating a marketing strategy and conducting extensive research in order to find new contractual business ventures
• Generating & reporting Bank Wise performance analysis on the Bank Transactions done from UAE Exchange for all Service Providers
• In depth analysis on the average ticket sizes and frequency of transactions done by customers, inactive customers
• Study on the newer banking relations and transactions done to these banks
• Growth over the period, analytics regarding the revenue, profit and cost of transactions and maintaining relationship
• UAE Exchange is a leading global money transfer and foreign currency exchange brand trusted by millions of customers and partners, across the world
• Got a Special Thanks and Recognition Award for successful implementation of one page presentation style which is known as Infographics to give the receiver an easy understanding of the performance of the business
• Successfully completed a complete revamp on monthly review reports/ performance dashboards using info-graphics visualization/ Innovative presentations
• Developed a one page presentation for all the product segments/verticals

• Company Overview: Reliance Communications & Alcatel-Lucent enter long term billion dollar contract to further improve network performance and customer experience
• Over 6 Years of experience in Excel macro VBA Coding
• Accountable for assisting in MIS Reporting & Project Management
• Conceptualize, design and implement MIS reports as required by management information needs
• Day to day follow up and coordination with different teams to ensure timely flow of MIS
• Responsible for Preparation & maintenance of the MIS Reports on Daily, Weekly, & Monthly metrics
• Providing information in a concise and simple way to Senior Management and the wider audience
• Thorough, diligent and executing the tasks with a high level of accuracy
• Analysis of raw data to identify new performance metrics
• Weekly & Monthly Quality analysis of the process
• Good hands on with Excel tools like V-Look up, H-Lookup, Pivot charts and Graphs
• Analyze the data and help the business use the same for decision making
• Generating reports on a weekly/monthly basis as per customer requirements
• Generation and distribution of daily, weekly and monthly reports as per agreed standards and timelines
• Understand requirements, design formats, deploy formats; follow up with Business development Team
• Creating and designing template for the Meeting
• Gathering the feedbacks from the Managers and Assessors and preparing reports as per the updating
• Ability to work in fast-paced environment either independently or in team
• Daily Performance Report updating for the team
• Preparing a Local websites for quick access to the performance reports
• (Using HTML) It helps the field engineers to easily view and download the performance data
• Reliance Communications & Alcatel-Lucent enter long term billion dollar contract to further improve network performance and customer experience
• Got a recognition award for the successful contribution of EMF implementation project
• Successful creation of a macro for Annexure H
• 35 sites report by MACRO, updating which took hardly 5 minutes
• Successful creation of a macro for EMF project
• This macro helps the team to complete the EMF project in 1/3 of its actual completion time
• An automated tool made in MS Excel for updating & circulating daily performance reports to the team members

• Company Overview: Ericsson is a world-leading provider of telecommunications equipment and services to mobile and fixed network operators
• Receiving and downloading data from BO, Cleaning and formatting data using MS Excel
• Cleaning and uploading data in Server for field engineers on date and priority basis, Sharing all data disposition with all cluster heads
• Removing duplicates from data through MS access & MS Excel
• Creating and updating Dashboard MAPA report and share it with the circle leads
• Handling multiple reports, working with formulas, pivot tables & pivot charts and various others excel sheets and its components
• Updating data tracker & Monthly MIS Dashboard on daily and weekly basis
• Interacting with cluster engineers through scheduled daily or weekly business conversation
• (Email)
• Ensure deliverables (Daily, Weekly, Monthly MIS reports & MAPA Dashboard) are prepared to satisfy the project requirements cost & schedule
• Excellent in MS Access & MS Excel (Hlookup, Vlookup, Pivot table, Pivot chart, Charts, Macro, Data validation & Scenarios)
• Prepared proactive checklist for database & important work to avoid future downtime
• Making advanced presentation in MS PowerPoint to present MIS related important reports
• Preparing supporting reports for month end signoffs
• E-mailing Recognized decision making MIS reports to higher staff of company with data visualization details using charts like Bar charts & Pie Charts
• Preparing & Analyze reports & other statements with a view to apprise management of process operations and assist in critical decision-making process by using MS Excel
• Implementation feedback as per queries given by the customer
• Perform quality checks whenever required
• Providing assistance to other team members in MS Excel
• Ericsson is a world-leading provider of telecommunications equipment and services to mobile and fixed network operators
• Successfully implementing macro automation to all working reports in MIS purpose and reduce the time lagging
• Speed up the whole working process because of systematic data downloads and report updation
• This make a drastic change in Time keeping

• Company Overview: Industrial Training Institute, Kayamkulam
• Teaching MS Office, C Programming, C ++ Programming, MS-Dos, Photoshop, HTML & Linux
• Checking & troubleshooting on various system issues (Software/ Hardware)
• Industrial Training Institute, Kayamkulam
• Teaching gives me a deep knowledge in MS Office and I realize the various phase of MS Office

• Company Overview: Fertilisers and Chemicals Travancore, is a fertilizer and chemical manufacturing company in Kochi, Kerala, India was incorporated in 1943
• Fertilisers and Chemicals Travancore, is a fertilizer and chemical manufacturing company in Kochi, Kerala, India was incorporated in 1943