Sunny Darediya

Enterprise Data Architect with 20+ years of experience delivering data warehouse and analytics solutions across IBM Cognos, SQL ecosystems, Microsoft Azure, and modern Fabric Lakehouse platforms, including 8+ years focused on data modeling and data architecture design. Proven track record of leading end-to-end data architecture modernization — from legacy system migrations and metadata-driven ETL frameworks to cloud-native Medallion Architecture — cutting development cycles by 70-80% through AI-assisted development. Brings 10+ years of experience leading technical teams and data governance initiatives across onshore and offshore organizations, including direct management of 6-7 person teams across multiple countries and time zones, translating complex business requirements into scalable, governed data architectures.

Recognized for reducing the rate of client-reported production issues by 80% during a critical Azure cloud migration while maintaining full data integrity. An early adopter of AI-assisted development, actively leveraging GitHub Copilot, Microsoft Copilot, and Claude within VS Code to accelerate delivery, shorten troubleshooting cycles, and raise team productivity for products involving Fabric, Lakehouse with notebooks and pipelines with python.

Experience in Spec-driven development which improves code reproducibility and architectural consistency. Equally effective as a hands-on technical contributor and a cross-functional delivery leader — bridging the gap between business stakeholders and engineering teams to turn complex requirements into measurable results.

IT Data Warehouse Manager at Wolters Kluwer ELM (2011-01 – Present)

• Led the modernization of legacy ETL workflows into a unified reporting platform using Medallion Architecture in Microsoft Fabric Lakehouse (built on OneLake), building Python/PySpark notebooks and pipelines to load, refine, and transform data across the Bronze, Silver, and Gold layers, reducing development and testing cycles by 70-80%.
• Designed metadata-driven ETL frameworks and data governance standards, including source-to-target data mappings, that dynamically generate data warehouse load files from the transactional model, standardizing ingestion logic and reducing manual load-script maintenance.
• Implemented Change Data Capture (CDC) pipelines against the Passport transaction database over 9 years, capturing and loading incremental data changes into the enterprise data warehouse to keep it synchronized with source activity.
• Designed ETL and dimensional (star schema) data models, including LegalVIEW Benchmark capabilities and custom date-dimension solutions, to support enterprise semantic layers and high-value reporting use cases.
• Drove adoption of AI-assisted engineering practices in VS Code using GitHub Copilot, Microsoft Copilot, and Claude, iterating on prompt design and workflows to accelerate development and testing of new functionality, reduce troubleshooting time by 65%, and improve issue resolution for Azure pipelines and Cognos workflows.
• Led the team responsible for stabilizing issues from the enterprise Azure migration, including hiring and formal performance reviews for team members, architecture reviews, and data quality assessments to identify risks and define mitigation roadmaps, troubleshooting ETL data issues and performance bottlenecks across Cognos and Data Warehouse architectures, and reducing the rate of client-reported production issues by 80%.
• Directed migration of BI assets to Cognos Analytics 11.1.7, improving reporting performance and platform reliability.
• Partnered with business, technical, and data stakeholders to gather and translate requirements into technical specifications, bridging the gap between functional and technical teams to align solutions with business needs.
• Led and mentored onshore and offshore teams of 6-7 direct reports across multiple countries and time zones, converting business requirements into actionable development plans, removing blockers, and tracking deliverables across release cycles.
• Defined data architecture standards and best practices while driving release planning, sprint execution, backlog management, product requirement analysis, and software acceptance criteria definition to improve delivery predictability and cross-team alignment.
• Mentored and onboarded new team members on architecture, tools, and delivery standards, developing clear documentation and templates that improved ramp-up speed and team productivity.
• Developed complex Cognos Active Reports and dashboards to strengthen out-of-the-box reporting adoption, track KPIs, and translate analytical findings into clear, business-friendly insights for end users.

Cognos Report Developer at Toyota Financial Services (2011-01 – 2011-12)

• Requirement Architecture: Collaborated with business users to gather, analyze, and translate complex requirements into detailed technical specifications for reporting and data workflows.
• ETL Architecture: Designed and deployed ETL workflows and data mappings to execute historical data loads into target marketing data marts with high accuracy.
• Database Optimization: Developed complex SQL stored procedures and shell scripts to automate fact-table loading and routine background processing tasks.
• Testing & Delivery: Led System Integration Testing (SIT) and User Acceptance Testing (UAT) cycles with client teams, resolving critical data workflow issues and improving release readiness.
• Resource Allocation: Coordinated daily task assignment across team members and supported QA hiring activities to maintain delivery quality and timelines.

Sr. Software Engineer & Team Lead at Capitol Records (2008-01 – 2010-12)

Sr. Software Engineer & Team Lead at GMAC (2005-06 – 2008-10)

Sr. Software Engineer at Fullerton Financial Holdings (2007-07 – 2007-10)

Software Engineer Trainee at Nucleus Software Exports Ltd (2005-01 – 2005-06)

Bachelor of Technology in Electronics & Communication – Jaypee Institute of Information Technology