Home

Pranavi K - DATA ANALYST

[email protected]

Location: Jersey City, New Jersey, USA

Relocation: YES

Visa: OPT EAD

Resume file: Achyutha_Pranavi_Kollimarla_Resume_1758119426656.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

ACHYUTHA PRANAVI KOLLIMARLA Jersey City, NJ 07304 | 201-565-4424 | [email protected] http://www.linkedin.com/in/pranavi-k-917ab2356 BUSINESS ANALYTICS GRADUATE | DATA ANALYST PROFESSIONAL SUMMARY: Business Analytics graduate with hands-on experience in data analysis, business intelligence, product insights, and operations optimization across manufacturing, retail, healthcare, and urban development. Skilled in SQL, Excel, Python, Tableau, Power BI, PySpark, and Databricks, with proven ability to build dashboards, predictive models, and A/B testing frameworks to support data-driven decisions, product strategy, and operational efficiency. Strong at stakeholder communication, requirements gathering, and cross-functional collaboration. Seeking roles in Data Analytics, Business Analysis, Product Analytics, or Operations Analytics where insights drive measurable impact. EXPERIENCE: Data Analyst Intern, ESOA Technologies Inc, New Jersey, United States February 2025 June 2025 Developed a Python-based churn prediction model (88% accuracy) and evaluated using A/B testing scenarios, enabling improved customer retention strategies. Cleaned and transformed large Excel datasets using Python (Pandas) and SQL, reducing manual prep time and enabling faster reporting. Designed and deployed Power BI dashboards to monitor customer health and order fulfillment, used weekly by sales and leadership. Built automated validation scripts and Excel templates to reduce reporting errors across sales and operations. Partnered with sales, engineering, and operations stakeholders to optimize pipelines, cutting reporting cycle time by 30%. Translated business requirements into functional dashboards and reporting workflows for leadership decision-making. Business Analyst Intern, St. Catharines Downtown Association (SCDA), Canada April 2024 August 2024 Developed an economic model for Downtown St. Catharines, improving economic insight accuracy by 40% using 10K+ public data points. Built predictive models to forecast GDP, employment, and tax revenue, supporting a 30% improvement in budget planning. Designed 3D geospatial visualizations (Python, Tableau, QGIS) to map population density, income distribution, and infrastructure. Identified underutilized zones and recommended 25% reallocation of investments, aiding urban revitalization. Delivered data-driven reports influencing 2+ city policy proposals and strategic development projects. Collaborated with planners and stakeholders to gather requirements and refine models, ensuring alignment with city goals. Agriculture Intern, RARS (Regional Agricultural Research Station) - ANGRAU, Guntur, India March 2023 April 2023 Collaborated with senior scientists in the cotton research division on varietal improvement, pest and disease resistance studies, and crop physiology research. Participated in hands-on cotton breeding activities including emasculation, artificial pollination, and varietal trials across randomized block designs. Conducted field data collection and statistical analysis to evaluate boll weight, lint-seed ratio, and yield potential of multiple cotton genotypes. Learned and applied seed processing techniques including boll picking, ginning, acid delinting, defect removal, and chemical seed treatment for quality improvement. Assisted in the preparation and packaging of breeder seeds for distribution to farmers and research trials. Documented cotton production practices, breeding methodologies, and experimental results into structured reports and presentations for academic use. Observed and gained insights into advanced agronomic practices, high-density planting systems, and integrated pest and disease management strategies. ACADEMIC PROJECTS: Process Optimization Using Celonis (Capstone) - Celonis, SQL, Power BI Analyzed production and accounts payable workflows using process mining tools. Identified $4M+ potential cost savings and achieved 32-day throughput reduction. Built dashboards and conformance reports to support process optimization. Amazon Product Sales Analysis Tableau, SQL Analyzed sales data across 10K+ products to uncover trends and revenue drivers. Built dashboards to compare sales vs. discounts and mapped wants vs. needs. Identified a 30% growth in Home & Kitchen category sales through discount strategies. Real Estate Appraisal Regression Modeling Python, StatsModels Built predictive regression models (R =0.82) using 500+ property records. Identified housing value drivers through forward/backward regression analysis. Supported real estate investment and appraisal decisions with model outputs. Air Quality Monitoring with Predictive Analytics Python, Scikit-learn Developed ML models to forecast air quality metrics (PM2.5, O ). Identified key pollution drivers using correlation heatmaps and decision trees. Improved AQI monitoring accuracy by 30% and proposed real-time alert systems. Predicting Medical Costs Using PySpark PySpark, Azure Databricks, Mllib Built regression model (R =0.74) on 1,338 patient records to predict insurance charges. Identified smoking, age, and BMI as primary cost drivers. Delivered healthcare pricing optimization insights using PySpark dashboards. Road Traffic Route Prediction Python, ML Modeled travel routes to predict bottlenecks and alternate paths. Applied analysis to optimize journey planning and reduce travel time. SKILLS: Analytics & Modeling EDA, Predictive Modeling, Regression, Clustering, Time Series Forecasting, A/B Testing, Causal Inference, Statistical Analysis Tools & Technologies SQL, Excel (Pivot, VLOOKUP, Macros), Python (Pandas, NumPy, Scikit-learn, Seaborn), R (basic), PySpark, Azure Databricks, Tableau, Power BI, Qlik, SSIS, SSRS, Alteryx, StatsModels Data Management & Engineering Data Cleaning & Wrangling, ETL Pipelines, Data Warehousing, SQL Query Optimization, Report Automation Business Knowledge Business Intelligence, Product Analytics, Economic Forecasting, Supply Chain Analytics, Healthcare Cost Analysis, Operations & Process Optimization Collaboration & Communication Stakeholder Communication, Requirements Gathering, Functional Documentation, Cross-functional Collaboration, Technical Report Writing CERTIFICATIONS: Academic Process Mining Fundamentals Celonis - Certificate Data Analytics Virtual Experience Program Deloitte Australia via Forage - Certificate Career Essentials in Data Analysis by Microsoft and LinkedIn - Certificate Power BI Essential Training (2024) - Certificate EDUCATION: Montclair State University (MSU), Montclair, NJ Master of Science in Business Analytics Sep 2023 - Dec 2024 GPA: 3.8/4.0 Relevant Coursework: Database Systems for Analytics, Data Wrangling and Analysis, Applied Statistics for Business Analytics, Data Visualization, Introduction to Data Mining for Business, Optimization Methods for Business Analytics, Analytics Practicum, Advanced Data Mining for Business, AI for Business, Business Process PDM University, India Bachelor of Science in Agriculture Aug 2019 May 2023 GPA: 8.25/10 Keywords: artificial intelligence machine learning business intelligence rlang New Jersey