Avinash Pawar Email & Phone Number

Seattle, Wa, Us

United States

- Led the development of scalable data pipelines and optimized custom ETL processes using Python and Apache Spark, increasing data processing efficiency by 60%. Automated CI/CD pipelines to handle up to 4TB of data daily from diverse sources.- Migrated legacy data systems to Snowflake, managing a secure data lake infrastructure that cut query times by 40% and ensuring data security with robust quality checks using Apache Airflow. Performed performance tuning and query optimization to enhance database efficiency.- Authored and updated comprehensive documentation for ETL processes, data pipelines, and system architecture; facilitated seamless handovers while enhancing team collaboration that contributed to a 30% reduction in onboarding time for new engineers.- Integrated five new data sources into the data ecosystem, providing insights that led to a 15% increase in actionable recommendations.

Bloomington, Indiana, United States

- Automated the digitization of invoice data from PDFs into a centralized database using SQL and Python, reducing processing time by 30%.- Enhanced data accuracy and integrity via robust validation and cleansing; presented analysis results via Tableau and Excel.- Collaborated with cross-functional teams to redesign database architecture, develop data templates, and improve data scraping methodologies.- Executed SQL queries to extract and analyze 1M+ financial transactions from multiple tables. Collaborated with stakeholders to identify data sources, improving accuracy by 20%. Utilized Excel (Pivot Tables, VLOOKUP, Macros) to ensure data compliance and integrity.- Developed interactive Tableau dashboards with calculated fields and KPIs, reducing manual data analysis efforts by 30%.- Enhanced metadata quality by performing ETL processes, involving data cleansing and preprocessing, utilizing Python and Excel.

Pune, Maharashtra, India

- Designed and maintained scalable database solutions for mission-critical applications, ensuring high availability and optimal performance.- Optimized SQL queries, achieving a 20% reduction in query execution time and improving overall database performance by 12%.- Integrated RESTful API web services for precise data retrieval and storage, optimizing external data source interactions.- Collaborated on developing web applications for a local grocery store and a hotel inventory management system using Django and MySQL. Implemented seamless e-commerce features including payment gateway integration, order tracking, and inventory management.- Architected a Python-based data pipeline using Selenium to automate data scraping, preprocessing, and modeling of utility data.

Master Of Science - Ms, Data Science

Coursework : STAT-S 520 Introduction to Statistics CSCI-P 556 Applied Machine Learning CSCI-B 565 Data Mining ENGR-E 511 Machine Learning.

Bachelor Of Technology - Btech, Computer Science And Technology

Coursework: - Data Structure - Network Engineering - Digital System and Microprocessor - Discrete Mathematics - Theory of Computation.

High School, High School/Secondary Diplomas And Certificates