Pranjal Shukla's
Data Portfolio

Love telling stories and learning how to work with data to make them even more convincing.
@pranjalshukla98

Pranjal Shukla

Hi, I’m Pranjal. I am currently pursuing Master of Science in Business Analytics at George Washington University.I am a highly motivated individual with strong foundation in technical skills and real-world experience in data analysis,business intelligence, and project management. Proficient in leveraging tools like Python, SQL, Tableau, and AWS to drive impactful solutions.

Skills

Programming: Python (Pandas, Spark, Numpy, TensorFlow, Keras, pytorch, Scikit-learn), SQL, R, HTML, CSS Databases & Bigdata : AWS (Data lakes Redshift), Databricks, Snowflake, Microsoft SQL Server
Tools & Platforms : JIRA, Azure DevOps, Tableau, Linux, Git, Docker, Kafka
Machine Learning & Analytics: Linear & Logistic Regression, Decision Tree, Random Forest, SVM, K-Means, Gradient Boosting, CNN, ANN, LSTM, Time Series Forecasting (ARIMA), Predictive Modeling, MS-Excel Certification: Business Analyst Nanodegree, AWS Cloud Practioner Essentials, Tableau Analyst Badge.

Experience

DataLink Software

Business Analyst Intern (May'23 - Aug '23')                                           Tempa, Florida
  • Led successful utilization of the in-house health intelligence tool, driving 30% increase in data-driven decision making in a span of 12 weeks
  • Designed and executed the Medical Adherence Scorecard Tab, for three chronic conditions with 10 dispensing metrices achieving a remarkable 35% cost reduction on medication expenses, highest amongst all interns
  • Enhanced reporting efficiency by optimizing Snowflake database queries, resulting in a 5% improvement in query execution times
  • Managed and tracked 12 Feature Enhancement Requests for clients via Azure DevOps, ensuring transparent communication and timely updates
  • Resolved 15+ complex healthcare data issues on SQL, improving data quality by 20% through innovative solutions for the product team
  • Exemplified customer-centric product development by seamlessly translating strategic objectives into user stories and requirements steering development efforts and precisely align with customer needs.

    • Intellexs Investment Solutions

    Technical Associate (Jun'20 - Aug '22')                                                 Noida, India
  • Performed testing and analysis in Tableau integrated with python code of data collected from pipelines saving 30mins per operation cycle
  • Analyzed financial data for 6+ projects, improving data quality and measuring key performance indicators, led to a 10% increase in ROI and a 5 % cost reduction through actionable financial strategies.
  • Developed operational process flow for analyzing transaction processing of 6 client cloud accounts
  • Automated pipelines for Finance team to track customer journey using tools like retool for UI, Postgres for database, and ETL jobs for transformation jobs
  • Visualized past financial data of 3 companies and devised client management strategies improving retention rate by 10%

    • HCL Technologies

    Data Analyst Intern (May'19 - July'19)                                                 Noida, India
  • Leveraged Apache Spark to drive transformative initiatives within US streaming sector, spanning critical domains like Product Innovation, Resource Utilization, Enterprise Function, and Marketing
  • Ideated and executed “Location-based Real-time Credit Card Fraud Detection project” increased sales through personalized offers by 25%
  • Set up AWS Aurora SQL database, centralizing data for streamlined analysis in the TMT space
  • Implemented a comprehensive AWS infrastructure, leveraging services such as EC2, DynamoDB, S3, and Redshift, resulted in 18% improvement in data analysis and reporting efficiency.