Ashish RANJAN
ETL/DWH Data architect
Pune
Summary
Adept Data Warehouse Architect with a proven track record at _VOIS, enhancing decision-making through real-time analytics and leading teams towards continuous learning. Expert in SQL and masterful in fostering a culture of innovation, significantly improved system efficiency and data quality, aligning with strict regulatory standards and fulfilling specific stakeholder needs through customized solutions.
Work History
Data Warehouse Architect
_VOIS
PUNE
01.2015 - Current
- Implemented real-time analytics solutions, providing decision-makers with up-to-the-minute insights into critical business metrics, enabling data-driven decision-making.
- Designed and implemented scalable data warehouse architectures, increasing query performance by 10%.
- Optimized 10 ETL processes, accelerating data ingestion by 10% and significantly improving overall system efficiency.
- Successfully migrated multiple legacy/on prem systems to Cloud (GCP/AWS )technologies, resulting in a 20% reduction in costs and a 20% improvement in computational efficiency.
- Ensured data quality and integrity through strict validation protocols to minimizing errors and enhancing data reliability.
- Mentored and trained over 30 team members on advanced data warehousing techniques, cultivating a culture of continuous learning and enhancing team capabilities.
- Collaborated with BI teams to deliver customized dashboards and reports that met specific stakeholder requirements, maintaining optimal system performance.
ETL Test Lead
Cybage Software Private
PUNE
04.2011 - 01.2015
- Optimized over 30 ETL pipelines through streamlined SIT processes and the implementation of advanced automation techniques, improving overall efficiency and reducing testing time.
- Significantly improved the performance of over 10 ETL pipelines by identifying and addressing performance bottlenecks.
- Provided mentorship to junior team members on effective ETL testing methodologies, fostering a culture of continuous learning and enhancing the team's overall testing capabilities.
Game Tester
Gameloft
PUNE
07.2007 - 04.2011
- Delivered over 50 high-quality games to market, ensuring rigorous testing and comprehensive documentation to meet quality standards
- Identified and reported approximately 200 critical and high-priority bugs, providing detailed descriptions, replication steps, and severity assessments to facilitate efficient resolution.
- Guaranteed cross-platform compatibility by conducting thorough testing on a wide range of devices, operating systems, and configurations, ensuring a seamless user experience
Education
Master of Science - Computer Science And Programming
06.2004 - 06.2007
Skills
SQL Expertise
Master Data Management
Database Design
Data Migration
Requirements Analysis
NoSQL Databases
Data Warehousing
Dimensional Modeling
Data Analytics
Report Generation
System Architecture Design
Timeline
GCP Database Engineer
01-2024
Data Warehouse Architect - _VOIS
01.2015 - Current
ETL Test Lead - Cybage Software Private
04.2011 - 01.2015
Oracle Certified Professional
10-2009
Game Tester - Gameloft
07.2007 - 04.2011
Sinhgad College , Pune University - Master of Science, Computer Science And Programming
06.2004 - 06.2007
Overview
17
17
years of professional experience
3
3
years of post-secondary education