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
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
Similar Profiles
SNEHA PATILSNEHA PATIL
Scrum Master at _VOISScrum Master at _VOIS
Ankit DhupareAnkit Dhupare
Senior Manager(Service Delivery) at _VOISSenior Manager(Service Delivery) at _VOIS
Anastasia Price ChilimentAnastasia Price Chiliment
IT Project Manager at _VOISIT Project Manager at _VOIS