ASHISH RANJAN
Data Management Senior Technical Lead At Arisglobal
Bangalore,karnataka
Summary
Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.13 years in Product planning, architecture, and delivery of multi-site, Strategic programs with cross – functional & multi -cultural teams majorly in Life Sciences (Safety Pharmacovigilance), & Health Management System.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Senior Technical lead
Arisglobal Software Pvt Ltd
04.2016 - Current
- Constructing a real-time data pipeline that harnesses Extract, Load, and Transform techniques alongside parallel processing is indispensable for efficiently handling data within a data lake house architecture
- I played a pivotal role in the enhancement of our ETL processes
- This encompassed the creation of a Java-based ETL tool tailored for multi-tenant support and the facilitation of concurrent batch processing
- I significantly boosted data processing speed via multithreading and parallelization
- Furthermore, I adeptly managed diverse data structures, including JSON, XML, CLOB, and BLOB, and enacted robust error handling protocols
- Additionally, I optimized efficiency by designing reusable components (Joblets), adeptly managed job dependencies, and established a comprehensive ETL audit system
- These endeavors collectively elevated data integration, scalability, and quality, thus underpinning the triumph of data-driven initiatives.
- Ensured data privacy compliance across all technical solutions by implementing industry-standard security measures and adhering to best practices.
- Championed continuous integration practices within the team by automating build processes and deploying effective version control systems.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Utilized advanced query optimization techniques to enhance database performance and reduce latency issues during high-traffic periods.
- Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
- .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Contributed significantly towards organizational cost savings by optimizing storage and data processing resources in the cloud environment.
- Designed scalable ETL pipelines for improved data ingestion, processing, and storage.
Technical lead
Capgemini
04.2014 - 04.2016
- I streamlined data operations by automating dynamic XML reading, migrating to Greenplum, and automating validation scripts
- Utilized Talend for efficient ETL, implemented robust error handling, and managed job dependencies
- Established ETL auditing, introduced Change Data Capture, and automated job scheduling
- Enhanced data flexibility by reading various file formats and utilized Talend Administration Centre for efficient job management and deployment
- These efforts collectively boosted data quality, efficiency, and supported data-driven initiatives.
Senior Software Engineer
Arisglobal Software Pvt Ltd
11.2011 - 04.2014
Software Engineer
iSOFT A CSC Company
01.2010 - 11.2011
- I mapped data from legacy systems to ODS, developed complex ETL mappings in Oracle, and implemented daily updates with SCD Type-II
- Applied SCD schemes for dimensions, established naming conventions, and created materialized views for BI
- Optimized SQL queries, handled bulk and incremental data loads, wrote dashboard queries, and built OLAP reports for top management using cubes and summary tables.
Education
Electronics and Telecommunication
University of Pune
Pune 04.2001 - 2009.04
Skills
HL7,R3 Protocols
undefinedWebsites
Scm Tools
- GitHub
- SVN
Project Management Tools
- JIRA
- MS Office
Certification
Snowflake
Snowflake
Completed the snowflake fundamentals Training in May 2022
Timeline
Senior Technical lead
Arisglobal Software Pvt Ltd
04.2016 - Current
Technical lead
Capgemini
04.2014 - 04.2016
Senior Software Engineer
Arisglobal Software Pvt Ltd
11.2011 - 04.2014
Software Engineer
iSOFT A CSC Company
01.2010 - 11.2011
Electronics and Telecommunication
University of Pune
04.2001 - 2009.04
Snowflake
Similar Profiles
Banashankari B SBanashankari B S
Test Lead at Arisglobal Software Pvt LtdTest Lead at Arisglobal Software Pvt Ltd
SUPRAJA CSUPRAJA C
Quality Engineer - Performance Testing at ArisGlobal Software Pvt LtdQuality Engineer - Performance Testing at ArisGlobal Software Pvt Ltd
KRISHNA ATREYAKRISHNA ATREYA
Team Lead – Quality Engineering and Scrum Master at ArisGlobal Software Pvt Ltd., MysoreTeam Lead – Quality Engineering and Scrum Master at ArisGlobal Software Pvt Ltd., Mysore