Ankit Mehani

WORK HISTORY

EDUCATION

ABOUT ANKIT MEHANI

Leading data consultant with over 10 years of experience across diverse industries like insurance, overseeing projects exceeding $100M and managing teams of over 50. Proficient in ETL/ELT, metadata management, data modeling, and integration. Skilled in Python, SQL, AWS, Azure, Kafka, BigQuery, Tableau, Power BI, and Airflow. Experienced in CI/CD, data warehousing, cloud computing, and machine learning. Demonstrated success in automating processes, improving operational efficiency, and reducing system downtime. Seeking roles that leverage business acumen, analytical prowess, and enthusiasm for automation.I have led end-to-end projects, ensuring timely delivery and budget adherence, and engineered automation solutions to reduce manual effort and errors. My focus on operational efficiency has enhanced productivity and reduced costs, and I have reduced system downtime through anticipatory maintenance.I have engineered over 100 ETL pipelines, optimizing data extraction, transformation, and loading processes. I enhanced data quality and accessibility through metadata management, developing multidimensional data models and integrating diverse data sources. My technical proficiency includes Python for automation scripts and data analysis, SQL for complex queries and database optimization, and AWS for managing data storage, lifecycle policies, and ETL pipelines. I have leveraged Kafka for real-time data processing and integration and used BigQuery for large-scale data analysis and reporting. My skills in Tableau and Power BI have enabled advanced visualizations and interactive dashboards. My data warehousing experience includes designing and maintaining data warehouses, while my cloud computing expertise has optimized performance and cost. I have applied machine learning algorithms to drive insights and automation.I led requirement gathering and product development for over 100 insurance products, reducing post-release defects by 30%. I achieved a 25% faster processing turnaround through automation and process optimization and managed the integration of AS400 systems with Data Mart and Aptitude, migrating over of data to Redshift and S3. I developed Power BI dashboards, increasing data accessibility by 40% and decision-making speed by 25%, and spearheaded data initiatives that reduced claims processing time by 25% and increased market responsiveness by 15%.I seek roles that leverage my technical expertise and passion for data-driven innovation to deliver impactful results.