× About Me Experience Projects Contact Me

Experience

Work Experience
  • April 2020 to Present

    Data Analytics Consultant (Associate Level)

    Axtria Inc. (Thousank Oaks, CA)

  • March 2019 to April 2020

    Data Analytics Consultant (Analyst Level)

    Axtria Inc. (Thousank Oaks, CA)

    • Utilized patient claims data to conduct a patient journey analysis for a specific disease. This required exploratory research into the disease and related drugs, development of business rules to determine patient universe and available paths, and the analysis of millions of patients’ data. Breakdown statistics on the patients and their journeys were provided to aid in outreach regarding early detection of the disease
    • Collaborated in the development of multiple automatically updating Tableau dashboard and master database to replace the client’s current weekly dashboards and separate sales data sources, decreasing the hours spent on manual calculation, analysis, and visualization
    • Acted as the point of contact on behalf of the client to an offshore team of 2-3 people to assign, delegate, clarify, and provide feedback on requests and tasks
    • Regularly queried and pulled data from Amazon Redshift databases into Databricks for further analysis/visualization using either Python or R both for ad-hoc requests and long-term analyses
  • May 2018 to Aug 2018
    WEC Logo

    Performance Engineering Intern

    WEC Energy Group (Chicago, IL)

    • Project lead in the development and presentation of a demo database using Microsoft SQL Server to introduce the benefits of utilizing databases within the Engineering Department, which resulted in approval from the department manager to begin designing a plan of execution and cleaning the necessary data sources to ensure data integrity
    • Designed VBA programs to rapidly pull data from thousands of sources in multiple directories that assisted in cost analysis for future consultant contract negotiations and budget forecasting
    • Initiated the process of automating and standardizing multiple procedures and data sources in the Engineering and Contracts department which led to an increase in quality of data storage and management
    • Examined proposed plans by other utilities submitted to Chicago’s utility regulatory office to determine possible conflicts with the company’s existing pipelines and facilities
  • Jun 2017 to Aug 2017
    WEC Logo

    Distribution Engineering Intern

    WEC Energy Group (Chicago, IL)

    • Designed and implemented an automated quality assurance VBA program for job-site measurements, saving hours of manual data entry and analysis
    • Walked through projects issued for construction in planned neighborhoods to determine if they complied with regulation
    • Ran gas flow simulations for proposed pipelines to determine if construction would be feasible and non-intrusive to area
    • Implemented pipeline retirements on the company's mapping software once new pipe was installed
    • Supervised job sites and gained real world experience in pipeline construction, layout, and implementation
Education
  • Aug 2015 to Dec 2018
    UIUC Logo

    University of Illinois At Urbana-Champaign

    B.S. in Engineering Physics; Specialization in Data Modeing and Analytics

    • GPA: 3.41/4.00
    • GPA (Last 60 Credit Hours): 3.57/4.00
    • Relevant Courses: Intro to Computer Science; Intro to Data Science; Intro to Databases; Applied Linear Algebra; Statistical Analysis
    • Member of Alpha Phi Omega, which is a national service based fraternity. Participated in 100+ hours of community servicce. Leadership positions include: Service Director, Pledge Training Assistant, and Pledge Project Facilitator
    • Capstone Project: Designed an online sports database demonstrating an understanding of inheritance, normalization, functional dependencies, and efficient SQL queries. Deliverables: ER diagram, DDL script, and sample SQL queries
Skills
  • Software/Tools:
    • Tableau
    • Git
    • Jira
    • Microsoft Excel
    • Microsoft Powerpoint
    • Microsoft Word
  • Databases:
    • Amazon Redshift (AWS)
    • Oracle
    • Microsoft SQL Server
    • Microsoft Access
  • Programming Languages:
    • SQL
    • R
    • Python
    • Visual Basic for Applications
    • MATLAB
    • HTML
    • CSS
    • Javascript
    • SQL
  • Languages:
    • English (Native Proficiency)
    • Hindi/ हिन्दी (Intermediate)
  • Certifications:
    • UC San Diego Data Structures course with distinction
    • Advanced Google Analytics
    • GTI Pipeline Safety Regulatory Compliance Course