Vigneshwar Vijayaraj

Utilized Python, VBA scripting, and advanced Excel to efficiently process and analyze large datasets, resulting in a reduction of data processing time.
Developed complex macros that automated tasks, leading to an increase in data manipulation efficiency.
Created interactive visualization dashboards and reports using Tableau to present findings to end clients and stakeholders collectively led to an average increase in stakeholder engagement and a reduction in the time taken for clients to grasp key insights, ultimately enhancing efficiency
Designed and implemented SSRS reports to provide key performance indicators (KPIs) and business metrics to management and teams.
Wrote DAX formulas to create calculated columns and measures for dynamic data analysis and reporting.
Performed data transformations, aggregations, and manipulations to support various analytical needs.
Curated and maintained datasets, ensuring data integrity and accuracy
Utilized SSRS for Analysis and reporting, hypothesis testing, and data exploration to extract meaningful insights from datasets.
Collaborated with cross-functional teams to understand data requirements and deliver insights aligned with business objectives.
Converted Python scripts of the Issue Matrix to Power BI to build models and visualizations, aiding the procurement department in understanding inventory and current procurement status of components, thereby ensuring timely and orderly progress for the manufacturing department
Redesigned and reorganized the database, utilizing SQL to transform column data types for optimal space and memory efficiency, reducing query execution time.
Created new columns based on the updated database schema to enhance data structure and accessibility.
Leveraged Power BI's data analysis capabilities to identify growth opportunities and trends within the organization's datasets.

Responsible for the planning, development, and management of data, and analytics solutions, particularly through Power BI
Designed, developed, and optimized the organization's data infrastructure, business intelligence, data analytics, and reporting capabilities to support the needs of development teams.
Created scalable and efficient data pipelines, and developed strategies for data collection, storage, analysis, and visualization to enhance business decision-making processes.
Worked closely with cross-functional teams, including product development, marketing, sales, and IT, to ensure that data projects are aligned with overall project goals and timelines. Acted as a liaison between technical and non-technical stakeholders to facilitate effective communication and project success.
Lead the effort in gathering business requirements from stakeholders for data visualization projects and the automation of data flows. Utilized various programming languages to meet the needs of Product Development teams, ensuring that all data solutions are tailored to support specific business objectives.
Utilized Power Query and Power BI to transform, clean, and integrate data from various sources, ensuring high levels of data accuracy and consistency
Utilized Power BI to design and maintain visually appealing and interactive reports and dashboards, combining data from various sources including SQL, Azure, and internal tools.
Created and maintained data integrations between various systems, including SQL databases, static data from Dropbox or Drive
Defined data relationships, hierarchies, and calculations to support complex reporting and analytics needs, enabling deeper insights into business operations.
Monitored and maintained automated data systems, performing manual tasks as necessary to guarantee the smooth operation of data management and reporting functions. Identify and resolve any issues that arise, ensuring the reliability and stability of data infrastructures.

Maintained database systems with high availability and quality, tailored to meet the specific needs and roles of each end-user, ensuring seamless data access and interaction.
Expert in query optimization and index management, significantly improving database efficiency and user query experience
Defined database user roles and permissions, ensuring data distribution is managed accurately, allowing the right users to access the appropriate data in the correct format and within the expected time frame.
Employed high-speed transaction recovery techniques and robust data backup strategies to minimize downtime and data loss, ensuring business continuity.
Managed and optimized operational databases with a focus on fine-tuning, alerting, and monitoring to ensure optimal performance and reliability.
Produced weekly, monthly, and quarterly performance reports for senior management, highlighting key insights and recommendations.
Created complex Excel models to analyze large datasets, enabling more accurate forecasting and budgeting
Conducted regular tests and evaluations to enforce data security, privacy, and integrity, implementing necessary measures to protect against unauthorized access or data breaches