Welcome!
About me
Data is the new currency, and I'm here to help you invest wisely.
As a forward-thinking professional with a proven track record from ZS to Prediction Guard, my career is dedicated to transforming complex data into scalable and strategic business solutions. My passion for data-driven results fuels my approach to developing innovative and efficient data systems.
With extensive expertise in SQL (Spark SQL, MySQL), Python, AWS, Azure, and Hadoop, I excel in creating robust data pipelines that not only streamline operations but also lead to substantial business growth.
Pursuing a master's in Business Analytics and Information Management from Purdue University, I merge academic insights with industry experience to tackle the most challenging data problems.
Given my steadfast dedication to my responsibilities, I am ready to take on the challenging and exciting role that awaits me next!
Pratik Merchant
765-694-5246
pratik.merchant@outlook.com
EDUCATION
Purdue University, Daniels School of BusinessWest Lafayette, IN
Master of Science in Business Analytics and Information ManagementAugust 2023 - August 2024
Coursework:
- Advanced Databases (SQL)
- Applied AI for Business
- Business Analytics
- Change Management
- Cloud Computing (AWS)
- Consumer Behavior and Marketing
- Data Mining
- IT Project Management
- Industry Practicum
- Launching Global Leaders
- Management of Organizational Data (SQL)
- Negotiations in Organizations
- Spreadsheet Modeling and Simulation
- Team Performance
- Using R for Analytics
- Visual Analytics (Tableau, Excel)
University of Mumbai, K J Somaiya College of EngineeringMumbai, India
Bachelor of Technology, Information TechnologyAugust 2017 - May 2021
Key Coursework:
EXPERIENCE
Prediction GuardLafayette, IN
Analytics Consultant - InternJanuary 2024 - April 2024
- Engineered an autonomous Large Language Model (LLM)-powered marketing agent to identify relevant trends and generate social media post ideas specific to target platforms in real-time, boosting engagement by 25% over four weeks.
- Constructed prompt-chaining and RAG (Retrieval Augmented Generation) pipeline to enhance agent’s context awareness and scalability across industries, achieving significant brand alignment with a semantic similarity score of 0.8.
- Presented project poster at the Analytics Poster Competition held at INFORMS Analytics Conference 2024.
- 1st Place among 23 teams at Poster Presentation Competition at Analytics Experience held at Purdue University.
- Future Edelman Impact Competition Finalist - LLM-Powered Autonomous Marketing Agent (LAMA).
- Co-authored the paper "Harnessing LLMs to Build an Autonomous Marketing Agent," scheduled for presentation and publication at the 20th International Conference on Data Science (ICDATA'24) in July 2024 in Las Vegas.
ZSPune, India
Associate Consultant, Business Technology SolutionsJune 2023 - July 2023
- Championed development and optimization of data pipelines, substantially enhancing data integrity and flow while reducing integration errors by 50%.
- Partnered with cross-functional teams to navigate project phases from requirements gathering to roll-out, attaining a 93% on-time project completion rate through meticulous planning and execution.
- 1st Prize winner among 15 teams at the inaugural Codify Hackathon held at ZS.
Associate, Business Technology SolutionsJuly 2021 - June 2023
- Crafted comprehensive business cases, solution blueprints, and go-live strategies, resulting in a reduction in project ambiguities while accelerating delivery timelines by 13% through effective planning and risk management.
- Pioneered rollout of a robust user-level security system, integrating AWS Lambda for process automation, thereby increasing task execution speed and achieving a 10% cost reduction due to reduced manual operations.
- Orchestrated the Analytical Workbench for User Acceptance Testing (UAT), with a strategic focus on AWS solutions leveraging AWS AppStream and AWS Redshift, enhancing system efficiency by 30% and boosting client satisfaction.
- Spearheaded client account management by independently leading team onboarding and delivery processes to sustain and strengthen established client relationships.
Associate - Intern, Business Technology SolutionsJanuary 2021 - June 2021
- Co-led operational strategies for an emerging US pharmaceutical firm, devising deliverable timelines and service level agreements, maintaining a 100% on-time report delivery record.
- Streamlined change requests process, accomplishing an uplift in system performance via optimized SQL code.
SKILLS
Core Competencies
- Healthcare Analytics
- Data Engineering
- Extract, Transform, Load (ETL)
- Database Design and Management
- Data Warehousing
- Business Intelligence
- Reporting and Analysis
- Data Pipelines
- Data Modeling
- Data Visualization
- Data Analytics
- Optimization
- User Acceptance Testing (UAT)
Tools & Technologies
- Amazon Web Services (AWS)
- Amazon Redshift
- AWS Glue
- Azure
- Hadoop
- Presto
- Apache Spark
- Tableau
- Power BI
- Excel
- Git
- Jira
- Microsoft Project
- NoSQL
Programming Languages
- SQL (Spark SQL, MySQL, PostgreSQL)
- Python
- R
- C++
- C