Akanksha Kushwaha

Akanksha Kushwaha

Associate Software Engineer
India

نبذة عني

Associate Software Engineer with experience in Snowflake initiatives, ETL data pipelines, database optimization, and analytics reporting. Skilled in Python, SQL, NoSQL, AWS, Apache Spark, Apache Airflow, Databricks, and …

الخبرة

Associate Software Engineer

Innovaccer Analytics Pvt.Ltd
Sep 2021 - حتى الآن · 4 سنوات 9 أشهر

• Led multifaceted Snowflake initiatives encompassing security policy enhancements, cost optimization strategies, resolution of operational issues (incidents and service requests), and refined access management protocols, ensuring robust data governance and operational efficiency.
• Ingested and prepared business-ready data by constructing ETL data pipelines using Databricks (utilizing Spark and Python).
• Established a pipeline using Apache Airflow to access historical data stored in Delta Lake. achieving efficient query response times of 5-10 minutes for historical data analysis, enhancing overall data accessibility and usability.
• Implemented MongoDB performance optimization strategies, including fine-tuning indexing for enhanced query performance and implementing cache size limitations that improved the scalability and efficiency of the company's analytics system by 40%.
• Created and maintained a suite of dashboards using JQL and eazyBI that provided data with real-time insights into ticket metrics i.e. volume of tickets, track the progress of individuals, SLA tracker for each client and datastore and performance indicators, resulting in data-driven decision.
• Conducted complex SQL queries to extract, transform, and analyze large datasets on MySQL and PostgreSQL, providing valuable insights
and actionable recommendations leading to a 30% reduction in decision-making time for senior management.
• Successfully orchestrated and executed seamless version upgrades for Amazon RDS database instances, including MySQL and PostgreSQL ensuring minimal downtime and uninterrupted service for critical applications.
• Implemented database migration and data transformation projects using SQL scripts and ETL tools, ensuring seamless data transfer and compatibility between different systems and platforms.
• Implemented proficient execution of MongoDB dump and restore operations, ensuring efficient data management and system reliability increasing efficiency by 25%.
• Collaborated in the development of scalable ETL processes for over large chunk of data daily, improving data ingestion efficiency by 30%

Associate Software Engineer

Innovaccer Analytics Pvt.Ltd, Noida

Led multifaceted Snowflake initiatives encompassing security policy enhancements, cost optimization strategies, resolution of operational issues (incidents and service requests), and refined access management protocols, ensuring robust data governance and operational efficiency.
Ingested and prepared business-ready data by constructing ETL data pipelines using Databricks (utilizing Spark and Python).
Established a pipeline using Apache Airflow to access historical data stored in Delta Lake, achieving efficient query response times of 5-10 minutes for historical data analysis, enhancing overall data accessibility and usability.
Implemented MongoDB performance optimization strategies, including fine-tuning indexing for enhanced query performance and implementing cache size limitations that improved the scalability and efficiency of the company's analytics system by 40%.
Created and maintained a suite of dashboards using JQL and eazyBI that provided data with real-time insights into ticket metrics, including volume of tickets, progress of individuals, SLA tracker for each client and datastore, and performance indicators, resulting in data-driven decision-making.
Conducted complex SQL queries to extract, transform, and analyze large datasets on MySQL and PostgreSQL, providing valuable insights and actionable recommendations leading to a 30% reduction in decision-making time for senior management.
Successfully orchestrated and executed seamless version upgrades for Amazon RDS database instances, including MySQL and PostgreSQL, ensuring minimal downtime and uninterrupted service for critical applications.
Implemented database migration and data transformation projects using SQL scripts and ETL tools, ensuring seamless data transfer and compatibility between different systems and platforms.
Implemented proficient execution of MongoDB dump and restore operations, ensuring efficient data management and system reliability, increasing efficiency by 25%.
Collaborated in the development of scalable ETL processes for over large chunk of data daily, improving data ingestion efficiency by 30%

المهارات

لينكس ماي إس كيو إل بايثون (لغة برمجة) قاعدة بيانات SQL أباتشي هادوب جيت (GIT) نوسكوول كاوتش ومونجو (أنظمة قواعد بيانات) باي سبارك سبارك خدمات أمازون ويب (AWS) مونجو دي بي باور بي آي SQL NoSQL C++ PL/SQL PostgreSQL Snowflake Amazon RDS AWS Lambda S3 EC2 IAM Athena eazyBI Apache Spark Hadoop Shell scripting Python scripting SQL scripting Apache Airflow Databricks Spark SQL MS Excel JQL Jira Git CI/CD pipeline Flask Bootstrap HTML5 CSS3
الإبلاغ عن هذا الملف الشخصي؟