MELANIE FERNANDES

Key Responsibilities & Achievements:

• Data Automation & Solution Design:
  Collaborated with internal stakeholders to design and implement data-driven solutions, enabling end-to-end automation across various business processes within Portfolio Insights, HR Analytics, Markets, and Indirects SAPCo Reporting.
• myData & Databricks Integration:
  Led the transition from manual data inputs to myData Databricks for the Execution and Delivery segment of Portfolio Insights. This initiative significantly reduced manual intervention, minimized human errors, and enhanced data reliability.
• Unified Workflow Implementation:
  Streamlined fragmented reporting by consolidating multiple dashboard outputs into a single, unified workflow. This reduced maintenance overhead and improved process scalability.
• Strategic Impact & Recognition:
  Recognized as a CIB Champion Winner in June 2025 for outstanding contributions to automation and data consolidation efforts.
• Award-Winning Performance:
  Consistently acknowledged for high-impact work with multiple internal recognitions, including:
  Excellence Awards
  Step Up Awards
  Champion Winner (across multiple years)

Project Title: Profitability Analysis for NOV (National Oilwell Varco)
Domain: Oil & Gas
Technologies: Alteryx, Tableau, R

Project Overview:
The objective was to evaluate NOV’s profitability by analyzing key financial drivers such as revenue and Cost to Serve (CTS) across specific segments and business units (BUs) at a granular level. A Client Profitability Model was developed by conducting hypothesis testing to isolate direct and indirect cost impacts. The project delivered data-driven insights and actionable recommendations to improve financial performance and strategic planning.

Key Responsibilities:

• Developed and maintained a detailed Sprint Plan to ensure agile delivery.
• Liaised directly with the client to gather requirements and align on business goals.
• Managed and distributed daily tasks among team members to maintain delivery momentum.
• Oversaw the end-to-end delivery of use cases, ensuring timely completion and stakeholder satisfaction.
• Utilized Alteryx for data cleansing and construction of a centralized data model to standardize inputs across segments.
• Designed and built interactive dashboards in Tableau to support strategic decision-making.
• Evaluated outcomes for each use case and presented recommendations based on empirical data analysis.

Project Title: Sales Performance & Promotion Analysis – Pfizer
Domain: Pharmaceuticals
Technologies: Tableau Desktop 9, Tableau Server, Oracle Toad 11g

Project Overview:
Pfizer aimed to analyze and benchmark the performance of various pharmaceutical products across multiple pharmacy chains. Accenture supported this initiative by building a suite of visual analytics solutions that tracked key metrics—such as sales (weekly, monthly, yearly), budget adherence, shipment costs, and sales forecasts—enabling Pfizer to optimize promotional strategies and improve decision-making processes.

Key Responsibilities:

• Interacted with stakeholders to gather and understand business requirements for different performance metrics.
• Designed and developed interactive dashboards in Tableau Desktop to visualize product performance, sales trends, and promotional effectiveness across pharmacy chains.
• Conducted unit and integrated testing of reports and data workflows using Oracle Toad 11g to ensure data accuracy and consistency.
• Scheduled workbook refreshes to ensure up-to-date reporting on key performance indicators.
• Published dashboards and visualizations to Tableau Server for real-time access by business users and executives.
• Documented reporting processes and ensured adherence to data governance and quality standards.