Raja Jeganathan

Dynamic and detail-oriented Data Warehouse Engineer with over 14 years of experience in designing, implementing, and managing data warehouse solutions. Proficient in creating optimized data models and ETL processes, resulting in improved data accessibility and analytics capabilities for business decision-making.

Clients: Wells Fargo, Honeywell, Public Transport Victoria (Australia) 

• Architected and delivered scalable data warehouse solutions for Fortune 500 clients, including Wells Fargo and Honeywell.
• Led full SDLC Delivery—requirement gathering, design, ETL development, UAT coordination, and production deployment—ensuring timely delivery of high-impact BI systems.
• Engineered complex ETL pipelines using SSIS, Informatica PowerCenter, and Snowflake; optimized integration of structured and semi-structured sources (Oracle, XML, and HBase) with Hive on Hadoop for large-scale analytics..
• Developed and tuned advanced SQL stored procedures, functions, and complex queries and ETL workflows, resulting in an 85% improvement in processing efficiency and reduced infrastructure costs.
• Designed high-performance dimensional models and fact schemas to improve data accessibility and reporting speed by 30%.
• Developed and deployed advanced SSRS and PowerBI reports featuring drill-downs, matrices, parameters, and charts to support operational and executive dashboards.
• Orchestrated job scheduling and automation through Autosys, Airflow, and Redwood, enabling reliable batch and real-time data operations.
• Implemented CI/CD pipelines using Jenkins for automating ETL deployments, testing, and rollback protocols.
• Managed source control using Git, Visual Studio, and TFS, enabling efficient branching, versioning, and peer-reviewed code collaboration.
• Championed data governance and regulatory alignment through stakeholder collaboration across business, QA, and compliance teams.
• Created technical documentation, deployment playbooks, and support guides to enhance maintainability and knowledge transfer.
• Mentored junior developers in best practices, agile methodologies, and technical upskilling, fostering a high-performing BI team.
• Delivered cross-border BI implementations in India and Australia under global delivery models, consistently exceeding client expectations.
  

The above statements declared by me are in full conformation with my personal and professional details and academic. Place: Hyderabad (RAJA JEGANATHAN)

Microsoft Certified : AZ-900 Azure fundamentals

Dremio Verified Lakehouse Associate