| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidate Candidate's Name
Indianapolis, IN | EMAIL AVAILABLE | PHONE NUMBER AVAILABLE | Linkedin | Portfolio
Skills
Technical: Excel(Macros, VBA, Pivot-table, All Advance Functions), Power BI (Power Query, DAX, Dashboard
Visualizations, ArcGIS, Relationships), SQL, Python (NumPy, Pandas, Seaborn, Scikit-learn, Matplotlib, Pyspark),
Tableau, R/R-Studio, ERP/CRM Management (SAP, ZREO, Salesforce, Oracle Netsuite)
Professional Experience
Data Analyst, Consultant January 2023 - Present
Bridge Builders Strategies Indianapolis, Indiana
Led a team of two to efficiently resolve client issues by executing AGILE SCRUM with JIRA/Trello utilizing tools
such as Power BI and SQL, significantly improving operational effectiveness.
Employed Python libraries for predictive modeling on financial and employment data, uncovering insights into
state homelessness with a focus on individuals, and showed a 10% increase over the last year.
Proposed data enhancement strategy to streamline manual data processes using Power BI and MS SQL, yielding
$60,000 in revenue and extending contracts by 4 months. Created documentation for extended use.
Developed a metric and created a metric-driven report which played a pivotal role in redefining budget
allocation strategies, achieving a remarkable 30% enhancement in resource allocation efficiency.
Further Experience
Technology Oracle Netsuite Consultant Intern June 2023 - August 2023
Crowe LLP Chicago, Illinois
Implemented Oracle NetSuite ERP system for private equity companies sized $50-300 million to help clients
manage their Order to Sales, Procure-to-Pay(P2P) processes, and organize their trial balances.
Successfully programmed and automated financial workflows using VBA streamlining processes and reducing
manual errors by 40% while enhancing data analysis capabilities.
Standardized the data migration process of clients' CSV files to organized dashboards on Netsuite using Excel
Macros/VBA to improve efficiency by 150% and save time in every project going forward.
Business Development Intern August 2022 - January 2023
Fusion Education Group Grand Rapids, Michigan
Automated 54 files for new school opening data tracking processes with MS Excel Macros, VBA, and advanced
Excel functions and merged data with Salesforce/SQL into Power BI to automate graphing.
Collaborated across accounting and information systems teams to create 100+ logic models and conditional
statements with Excel formulas to automate the annual award ceremony process.
Mapped zipcodes on Power BI ArcGIS to identify errors and increase lead conversion rate by 22%.
Pricing Intern May 2022 - August 2022
Owens Corning Toledo, Ohio
Identified $11M of invoice errors by implementing a Power BI dashboard that finds outliers with 98% accuracy
using z-score analysis and sends them to 50+ pricing analysts to enforce bill blocks.
Set confidence intervals for outlier detection depending on business units and customer loyalty.
Research Analyst May 2018 - May 2019
University of Hawai i at M noa Honolulu, Hawaii
Conducted groundbreaking research on Melanthera Integrifolia propagation, focusing on rooting hormones.
Performed statistical analyses, including p-tests, synthesized results into an informative poster, and presented
findings at the American Society for Horticultural Sciences in Orlando (2020).
Education
Bachelor s in Mathematics, Magna Cum Laude (3.7 CGPA) August 2020 - May 2024
DePauw University Greencastle, Indiana
Study Abroad: University of Oxford, Grade: A
Relevant Coursework: Statistical Machine Learning, Introduction to Data Science, Regression Analysis, Statistical
Computing, Operations Research and Algorithms, Linear Algebra, Multivariable Calculus
|