Vikhram Natraj D

VIKHRAM NATRAJ- - vikhram-natraj-38b965231 WORK EXPERIENCE Envirotech Systems Integrated Project Associate July 2024 - Present • Drafted 10+ plan and log type documents, ensuring seamless planning process. • Tracked project activities, maintaining 95% visibility on all aspects of project work. • Conducted in-depth market research on 20+ competitors, identifying a $5M revenue opportunity and delivering actionable insights to executive leadership. • Managed client engagements for a $10M project, achieving 100% retention through proactive communication and swift response to feedback, resulting in a 15% increase in client satisfaction. • Supported management in the governance and oversight of all project related collections and expenses, ensuring 100% compliance with company policies. Deloitte Analyst April 2023 - June 2024 • Analyzed and provided insights on 100 MB+ data using Advanced Excel operations, improving the data processing time by 25%, enabling data-driven decision making and reducing the risk of inaccurate conclusions. • Spearheaded stakeholder engagement and gathered requirements from 15+ senior leaders (Partners & Directors), driving the successful delivery of 10+ high-impact strategic research projects on time. • Devised an intricate analytics dashboard using Power BI which saved over 3 hours weekly for individual analysts by automating repetitive data entry tasks and increasing overall operational efficiency across teams. EDUCATION Rajalakshmi Engineering College, Chennai B.E Electronics and Communication Engineering - 8.29 CGPA August 2018 - May 2022 Don Bosco Matriculation Higher Secondary School, Chennai 12th - 84.33% 10th - 90.60% - PROJECTS Airline Database May 2024 • Developed & optimized 30+ SQL queries to analyze airline operations, covering flight efficiency, passenger behavior, and revenue trends. • Executed complex SQL operations including joins, CTEs, window functions, and aggregations to extract key insights on flight delays, cancellations, and seat allocation. • Optimized SQL query performance through indexing, partitioning, and query tuning, improving execution speed by 40%. • Leveraged SQL for deep data analysis, identifying high-revenue passengers, ticketing patterns, and airport performance metrics. • Automated SQL-based reporting, enabling data-driven decision-making for airline scheduling, refund processing, and operational enhancements. ShopNest Analysis April 2024 • Designed a dynamic Power BI dashboard leveraging DAX measures and Power Query for advanced analytics, resulting in 25% faster reporting and 15% improved data accuracy. • Optimized sales insights by identifying top 10% product categories and tracking 20% of delayed orders across segments, leading to a 12% reduction in inventory costs. • Elevated operational efficiency by obtaining greater clarity of on-time versus delayed orders with drill-through analytics; this strategic insight resulted in a significant reduction of order fulfillment time by 10%. • Enhanced decision-making by analyzing payment trends (40% digital payments) and state-wise sales distribution, leading to a 5% increase in sales and a 3% increase in customer retention. • Delivered a data-driven solution, uncovering seasonal sales patterns (Q-o-Q) and 15% YoY revenue growth trends, resulting in a 12% increase in revenue and a 5% increase in market share. SKILLS • Technical Skills: Advanced Excel, SQL, Power BI, Big Query, Looker Studio, MS Office • Soft Skills: Astuteness, Business Story Telling, Project Management, Expense Management CERTIFICATE Certificate in Data Analytics • Demonstrated expertise in applying advanced analytical techniques, acquired through the hands-on training at SkilloVilla with a distinguished certification in data analytics. Certificate in Strategic Management • Successfully completed the two-credit course on Strategic Management with a consolidated score of 77% offered by IIM, Bangalore. LANGUAGE English, Tamil, Telugu, Hindi AWARD Best Paper Award EDGE 2022 Conference • Won the Best Paper Award for the paper titled “Garbage Monitoring System using Microcontroller” in the EDGE 2022 Conference held on April 22 at Rajalakshmi Engineering College, Chennai. Best 4WD Team BAJA SAE INDIA • Secured Best 4WD Team 2nd Prize – eBAJA category in BAJASAE INDIA 2022, organized by SAE INDIA under the aegis of NATRAX facility, Pithampur from 1st to 5th June 2022.