HARIHARAN N

Planned and designed system improvements to meet changing demands

• Data Warehouse Development: Successfully designed and implemented a comprehensive data warehouse to consolidate sales order, sales billing, and other critical business data, providing a unified platform for analysis and reporting to support business operations.
• KPI Framework: Developed and implemented a robust KPI tracking system to monitor sales performance, identify trends, and support data-driven decision-making.
• Financial Analytics: Created detailed financial analyses, including stock analysis, creditors management, and purchase order tracking, to optimize financial operations and control costs. Identified patterns and trends in large data sets and provided actionable insights.
• Customer Relationship Management: Developed a customer database to enable in-depth customer analysis, identify key segments, and drive targeted marketing initiatives. Leveraged my vast experience with Salesforce to create detailed reports, set goals, and perform advanced data slicing and dicing, ensuring comprehensive insights for strategic decision-making.
• Business Intelligence Reporting: Designed and automated comprehensive sales and operational reports using Microsoft Excel, Power Query, VBA, and Macros, providing actionable insights to stakeholders. Updated and developed scripts and queries to extract and analyze data from multiple sources. Collaborated with upper management to drive strategy and implement new processes.
• ERP Implementation: Extensive experience in working with ERP platforms such as Tally and Syscon (internally implemented), streamlining processes and optimizing data management for improved business outcomes. Played a pivotal role as a coordinator in the successful migration of our company's data to a new ERP system, collaborating with various departments to ensure a smooth transition.
• Sales Analysis and Data Transformation: Successfully transformed and cleaned historical sales data that was previously disorganized, structuring it into a refined and elegant format. Implemented advanced data-cleaning techniques to ensure accuracy and consistency, enabling more reliable analysis. I currently maintain and manage the company’s sales analysis, using this transformed data to provide actionable insights and drive business growth.
• Data Collection System Development & Process Optimization: Developed and implemented a data collection system utilizing Advanced Google Forms, in collaboration with the R&D team to gather critical inputs. Automated the data flow by linking Google Forms to Google Sheets, then transformed, cleaned, and structured the raw data into actionable insights. This process significantly enhanced the data quality and statistical efficiency, providing the R&D team with accurate, organized inputs, which streamlined their day-to-day operations and improved workflow efficiency.

• As a Data Analyst within the Product Management team, I successfully managed the creation and maintenance of comprehensive Management Information Systems (MIS). My responsibilities involved providing robust support across various data-related functions and ensuring timely and accurate visibility of critical information to support the entire team.
• Proficient in Microsoft Excel(VBA), PowerPoint, PowerBi, Power Query, Power Pivot, and SQL database management systems, I leveraged these tools to extract, analyze, and present data effectively.
• Successfully automated the daily stock report generation using Python in Spyder, streamlining the reporting process and ensuring real-time data availability. This automation improved accuracy, reduced manual effort, and provided stakeholders with up-to-date stock insights for more efficient decision-making.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources. Collaborated with stakeholders to identify business needs and data sources.
• Produced monthly reports using advanced Excel spreadsheet functions. Developed automatic tracking and reporting systems using VBA and Proficient in creating insightful and visually appealing dashboards using Microsoft Power BI. Utilizing a keen eye for design and data visualization best practices, I transform complex datasets into intuitive and interactive visualizations, enabling data-driven decision-making.
• Created dashboards to monitor and track key performance indicators (KPI).
• Analyzed data to identify root causes of problems and recommend corrective actions.