Data Analyst

Lohit Palle

Herndon, VA ***** 571-***-**** *******@*****.***

EDUCATION BS in Mathematics, UNIVERSITY OF MARY WASHINGTON, Fredericksburg, VA December 2020

Major: Mathematics Minor: Actuarial Science

Coursework: Data Science, Numerical Analysis, Theory of Interest, Applied Probability and Statistics

Associate of Science in Mathematics, NOVA, Sterling, VA December 2017

SKILLS ● Software: RStudio, Python, SQL, Tableau, PostgreSQL, Advanced MS Excel, SAS, MS Office

●Soft Skills: Attention to detail, Organizational Skills, Problem Solving, Logical, Can-do attitude

● Statistical Analysis: Clustering (hclust, k-means), Bootstrap Estimates, ANOVA Testing, Regression Tools

EXPERIENCE Data/Business Analyst Intern, NAVIZ ANALYTICS, Redmond, WA June 2020 – Present

●Worked with clients to understand business needs and translate into actionable reports using Tableau. Saved 16 hours of manual work each week

●Created visually impactful dashboards for COVID rates in Tableau and reduced team incorporated work by 10 hours per week

●Implemented open-text analysis utilizing pivot tables and time functions to increase customer feedback and retention by 3%

●Provided administrative help to a team of 12 IT members to increase workflow

Business Analyst Intern DIGI INFOTECH, Herndon, VA Sept-Dec 2019

●Simulated UML Modeling, user stories, activity diagrams and use case scenarios with real-time clients

●Applied agile methodologies to practical scenarios (Kanban, Scrum) Utilized JIRA to storyboard Kanban and Scrum

●Presented research findings in hotel customer retention using Tableau, Excel pivot tables, and open-text

Retirement Actuarial Intern, WILLIS TOWERS WATSON, Arlington, VA May – Aug 2019

●For a “mock” client and later for a “real-world” client, reviewed benefit statements, performed benefit calculations, produced Expense Valuation report and Funding Valuation report

●Worked alongside consultants and analysts on project teams, analyzing data, running valuation reports, processing cost components, filing government forms, and creating final documents given to clients

●Performed research and created multiple presentations using PowerPoint presented to clients by consultants

Assistant Lead - Tutor, MLS EDUCATIONAL CONSULTANTS, McLean, VA March 2017-2018

●Tutored Mathematics and Physics to 5-6 students daily in required schoolwork

●Organized and created weekly work schedules for 5-6 students

●Created specialized student groups to match each tutor’s skill set

Private K-12 and College Tutor, WYZANT, Northern Virginia Spring 2015-2020

●Tutored 50+ students in mathematics and physics

●Created lesson plans and worksheets to optimize learning

PROJECTS Watershed Data Analysis, UMW, Fredericksburg, VA

●Lead a team of 4 classmates to identify, cleanup, and predict watershed nutrient data

●Utilized automated clustering to increase predictability efficiency 8-10% and reduce manual clustering

●Used hierarchical and agglomerative clustering to group segments of data in preparation of predictive analysis

●Presented a full 30-page comprehensive report to project manager and professor

LEADERSHIP President/Treasurer/Practice Coordinator

UMW Club Tennis, Fredericksburg, VA

●Coached and led a team of 35 students

●Organized practice plans and implemented them 5 days a week

●Directed and hosted 3 tournaments for 16 school teams. Approximately 160 athletes

●Budgeted and forecasted costs for a 5-year plan to ensure club financial stability

●Increased tournament profit margins by 25% by changing vendors and adjusting budget

Contact this candidate