Raagavendran Ganesan

Experienced Analyst with a Bachelor Degree in Software Engineering and MSc in Digital Transformation Computer Science. A strong background in emerging technologies. Skilled in BI, PHP, JavaScript, and database design, currently managing web contents at Dell Technologies.

• CCNA ROUTING AND SWITCHING (08/2017)
• CISCO NETWORK COMPETENCY (08/2017)
• PRESENTING WITH PROFESSIONALISM AND POISE (11/2023)
• LEVEL 1 TRIZ PRACTITIONER (07/2023)
• BLOCKCHAIN FOUNDATION (04/2024)
• PHYTON FUNDAMENTALS (10/2022)
• AI BEST PRACTICES (06/2024)
• GETTING STARTED WITH SALSIFY (08/2024)

• Dell Technologies, Team Building Lead, 2022
• AIMST, Facilitator of Yale Convention 2017
• UMP, Participant of UMP Triz Innovation Exposition 3.0 2018
• High School, Participant of Star-NIE’s National Level Contest
• High School, Tale Spin 2013
• Ministry of Education, Participant of Camping Rukun Negara National Level 2013
• High School, Participant of Malaysian National Chemistry Quiz 2014

Built a complete end-to-end internal auditing application in Microsoft PowerApps to digitalize and automate Supplier Verification Visit (SVV) processes for Celestica Penang, replacing manual data entry and spreadsheet-based workflows.

• Designed and developed a multi-page PowerApps system with separate Admin and User workflows, improving audit data entry efficiency for the Supplier Verification team.
• Built 7 fully functional interfaces (Homepage, Supplier List, Add Supplier 1–2, Edit Supplier 1–2, Verification Questions Admin Panel).
• Digitized 100% of Supplier Verification visit forms, allowing staff to submit, edit, and track supplier audits directly in the app.
• Designed a Supplier List gallery with search, status tracking, and dynamic count labels, enabling staff to filter and manage all existing supplier entries in real time.
• Implemented role-based data control:
  “Saved” entries = editable
  “Submitted” entries = locked for final viewing/deletion
• Integrated Google Drive document linking, enabling users to attach and validate supporting files from shared drives.
• Built a full audit-question engine allowing Admins to:
  View, edit, and update verification questions
  Add new questions dynamically
  Manage 100+ RBA compliance questions without developer support
• Created multi-step supplier submission flow (Details → Remarks → Corrective Action), including skip-to-last and next/back navigation to improve usability.
• Reduced manual audit cycle time by an estimated 30–40% through automated data population, streamlined navigation, and status-driven workflows.
• Implemented validation and safety controls, including:
  Read-only fields to prevent data corruption
  Warning prompts before deletion
  Prefilled original values during edit mode
• Produced full system documentation (40+ pages) covering UI, workflows, data rules, and developer guidance for future maintenance.

1. Inspiron Consolidation Project (2021)

• Consolidated Inspiron LOB Model Splitter structures across multiple regions.
• Created new Model Splitter categories for 2-in-1 products and deprecated outdated series globally.

2. E-Support Structure Cleanup – Monitors & Accessories (2021)

• Reorganized the outdated monitor hierarchy where all products sat under a single parent node.
• Built new LOB-specific categories (e.g., C-Series, Legacy Monitors) and migrated products based on customer requirements.

3. Monitor Deals Launch (2021)

• Supported weekly monitor-deals launch and collaborated with IT to troubleshoot the new 8225 → monitor-deals custom deals ID implementation.

4. OC Attribute Cleanup (2021)

• Project Manager for global OC Attribute cleanup.
• Coordinated with India (EMEA) team to clean ~1 million records — the largest table in CPV.

5. Sales Application / Configurator Globalization (OSC/DSA) (2021)

• Project Manager for OSC/DSA Globalization across APJ & EMEA (12 countries).
• Completed PROD & G4 setup across 3 phases; Phase 4 scheduled for rollout.

6. OptiPlex Redesign (2022)

• Created new category and Model Splitter nodes for the redesigned OptiPlex structure.
• Added 4 new Model Splitter nodes to Sales Category tables for Content Studio mapping.

7. Product Studio Migration – Wave 9 & Wave 11 UAT (2022)

• Led UAT for 9 frequently-used tables related to DSC/DSA, including:
  Gateway Templates, Dynamic Scripting, Backfeeds, Dashboard Filters.
• Wave 11: Executed test cases for active-record toggles and missing-column defects requiring Dev Console cache clearing.
• Migration size: 55 screens/tables and 3M+ records.
• Identified 1,111 issues, with 95.6% resolved during migration.

8. Product Studio & GVT DDS 2.0 – Pilot & Launch (2023)

• Conducted pilot testing for multiple key tables:
  Product Variants, Products, Catalog Products, Customer Set AMER/EMEA, API, etc.
• Performed full functional/Gateway testing.
• Reported 49 UAT issues, committed 124 hours, and supported the transition to DDS 2.0.
• Total project outcome: 254 issues reported; 89% resolved by development, enabling a smooth global transition.

9. Inspiron Plus Structure Update (2023)

• Added new Inspiron Model Splitter structures for Inspiron 14 7440 & 16 7640 NPL across 14 global profiles (APJ, EMEA, BR, US, CA, JP, KR, CN, HK, IN, MY, NZ, SMB variants).
• Completed in 2.5 hours.

10. Global Validation Tool – Automation Testing (2023)

• 128 automation rules created for G4 GVT; assigned 7 modules for UAT:
  WRNTY_DURTN_YR, OS_BIT_COUNT, VID_BRAND, VID_MODEL, KEYBRD_TYPE, HD_CAPACITY_GB, FORM_FACTOR.
• Logged 49 defects resolved by Developers.
• Contributed 31.5 hours to the testing cycle.

11. Desegmentation Cleanup – Consumer (2023)

• Cleaned Featured SNA SKU table in Product Studio Workbench.
• Removed ~2,500 obsolete records.
• Total effort: 4 hours.

12. OptiPlex Restructure (2023)

• Created 12 new OptiPlex product categories and deployed them across APJ and BR_SMB structures.

13. SnP Tech Specs Automation (2023)

• Managed tech spec assignments for 460 Spare LCD & Keyboard records × 4 country profiles (FR/CH/LU/BE).
• Built a VBA macro to automate data entry and significantly improve processing speed.
• Total commitment: 34.5 hours.

14. Consolidate US catalogs 18 and 08 - PROD (2024)

• Weekend support and Pre-setup for Customer Set and on the day setup for PAC and PS
• Customer Sets impacted are usac1f and usglob1f where setup includes and below
• Mapping the following segments to catalog 8 / US_SMBR:
  [ 39 - OFFLEG500 ] Offline LE Global 500
  [ 58 - OFFUSAC ] OFFUSAC
• Mapping the above segments with US_SMBR to the global product tree/structure OSC_GLOBAL.
• Moving the following 2 customer sets from catalog 18 to 8 in Catalog tools and PAC:
  usac1f (segment 58 - OFFUSAC)
  usglob1f (segment 39 - OFFLEG500)
• Map the customer sets to US_SMBR with the above segments.
• Cleanup of old customer sets that will no longer be supported (like g_18 and others).

15. Product Studio FY25 0503 Angular Launch (2024)

• Supported Angular Launch UAT test in G4, Pilot and PROD to identify issues and reporting to Dev and complete each G4 and Pilot in 1 week time, and PROD testing within 7 hours for Collections below.
• Product Sales Alias
• Product Variant Sales Alias
• Component Type Chassis Modules
• Catalog OC Attributes
• Customer Sets AMER
• Customer Sets EMEA/APJ
• Sales Catalog
• Sales Catalog Customer Sets
• Sales Catalog Segments
• Sales Catalog Structure

16. EMEA Spare parts attribution setup (2024)

• Setup is done in Content Studio which includes LCD and Keyboard Spareparts for over 450 Q-codes as below
• Spent 29 hours for both LCD and Keyboard attributes as below
• LCD - DisplaySurface, PanelInterface, BLU(backlightUnit), ViewingAngle, MechType, AspectRatio, PixelType, Brightness(nits), NTSCColorGamut(%), Type, SpecialFeatures, Size(in), ResolutionType, *FCC#, TouchPanelType
• Keyboard - Localization, Keycoating, Marketing Code Name, NumberOfKeys, Backlit, Type, Connection, Height(cm), Width(cm), Battery WH Rating, Multimedia, Wireless