PRATHMESH ZAREKAR

Project: Vistra Corp - Enterprise Advanced Analytics - Energy Domain

• Designed and managed ETL workflows using Python and Apache Airflow, automating ingestion, transformation, and scheduling for large-scale data pipelines.
• Built and optimized Snowflake data warehouses, improving query performance, schema design, and storage efficiency.
• Queried and managed large datasets in Microsoft SQL Server, implementing query optimization, indexing, and performance tuning to enhance data processing.
• Improved data pipeline scalability and automation, enabling faster insights and stronger business intelligence capabilities.
• Utilized Git for version control, ensuring code reliability and effective collaboration within distributed teams.
• Secured and monitored remote servers using PuTTY in Linux/Unix environments, executing administrative and data tasks.
• Developed and tested analytics workflows in JupyterHub, collaborating with cross-functional teams to implement advanced data strategies.
• Contributed to data visualization workflows in Tableau, enabling data-driven decision-making across business units.
• Provided mentorship to junior engineers and authored SOP documentation, enhancing team knowledge sharing and onboarding efficiency.
• Delivered clear communication of complex findings through reports, visualizations, and dashboards, driving improved organizational decision-making.

Project: Mapp Cloud – Email Marketing System

• Developed Python automation scripts, leveraging pytest for testing and framework implementation.
• Created file handling scripts and executed automation suites on AWS EC2 instances via PuTTY, ensuring reliable system operations.
• Designed and maintained automated workflows to streamline email marketing processes, improving customer engagement and campaign efficiency.

Project: Hitachi Ltd. - Service Now Automation

• Collaborated with cross-functional teams to gather requirements, define project scope, and align deliverables with business needs.
• Developed Java automation scripts using the JUnit framework, implementing attributes for robust and reusable test cases.

Project: MaritzCX – Customer Feedback Management

• Developed test automation scripts to validate functionality in a customer feedback management platform.
• Utilized Block Object Model (BOM) for test design, ensuring modularity and reusability of automation scripts.
• Executed multiple automation test suites, maintaining and enhancing scripts to support continuous integration and quality assurance.

• Project: Hitachi Ltd.
• Collaborated with cross-functional teams to gather requirements and define project scopes.
• Developed Java scripts using the JUnit framework, implementing various attributes for automated testing.

• Enterprise Feedback Management
• Description: A customer experience (CX) and market research company providing real-time consumer data analysis.
• Developed scripts for testing functionality in a feedback management system.
• Utilized Block Object Model to design test scripts and executed multiple automation suites, maintaining and updating scripts as needed to ensure continuous integration and testing coverage.