Timothy Kalapala
Charlotte,NC
Summary
Enthusiastic and detail-oriented professional with a deep passion for leveraging data-driven insights to mitigate risks and drive business excellence. Aiming to contribute to an organization's success by enhancing risk management strategies and elevating customer experiences through meticulous analysis. Proficient in data mining, adept at uncovering patterns and trends that inform strategic decision-making. Skilled in data visualization and programming languages, with a demonstrated ability to translate complex data into actionable solutions for challenging business scenarios. Eager to bring a proactive and analytical approach to a dynamic risk role, combining passion with expertise to contribute positively to the organization's risk management objectives.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Pricing & Data Analyst Intern
XPO Logistics(RXO)
Charlotte, NC
05.2023 - 08.2023
- Created a PowerPoint project showcasing 7 Super Users of the RXO Extra Program
- Utilized BI-Reports to conduct C-Market Review, exporting data to Excel using V-lookup to analyze 2700 fuel locations
- Identified reasons for primary chain's underperformance in comparison to competitors
- Extracted, interpreted, and analyzed data to identify key metrics using BI Report and transformed raw data into meaningful, actionable clean data
- Evaluated 100+ Brokerage transactions daily in comparison to historical data, developing a database for artificial intelligence to use to assess the validity of transactions executed
- Collaborated with a team of 15 other analysts to evaluate pricing trends and brainstorm challenging tasks optimizing the machine learning functionality
- Imported data and created visuals in MS Excel for management reporting by using pivot tables and VLOOKUP functions.
Financial Intern
RippleMatch
New York City, NY
09.2022 - 12.2022
- Developed template deck to present to future clients: Created a visually appealing and informative template deck, resulting in an increase in client conversions by 25% within the first quarter
- Effectively communicated with clients and senior partners: Conducted regular meetings and status updates, resulting in a 90% client satisfaction rate and positive feedback from senior partners
- Intern Connection Program match program for interns; achieved 70% participation of interns.
Accounting Intern
Bank of East Asia
New York City, NY
05.2022 - 08.2022
- Worked on the Balance sheet asset transactions, responsible for analyzing incoming Interest and FASB amount for Commercial Real Estate loans
- For mortgage, conducted a meticulous analysis of over 118 financial transactions, ensuring a high accuracy rate of 98% and maintaining compliance with accounting principles
- Played a pivotal role in entering and maintaining financial data, contributing to the organization and accuracy of over 1000 financial records
- Supported the team in preparing monthly financial reports, contributing to a 20% reduction in reporting time
- Applied advanced knowledge of accounting software in daily tasks, leading to a 15% improvement in processing efficiency
- Collaborated closely with a team of 10 accounting professionals in reconciling and verifying financial data, contributing to a 30% reduction in errors.
Fast Food Representative
Moes
Piscataway, NJ
05.2022 - Current
- Ensured proper presentation and preparation of food products and beverages in an appealing way
- Swiftly and properly coordinated reservations for large groups and unique needs.
Fast Food Representative
Subway
Edison, NJ
05.2021 - 05.2022
- Ensured proper presentation and preparation of food products and beverages in an appealing way
- Swiftly and properly coordinated reservations for large groups and unique needs
- Rapidly washed and sanitized dishes
- Diced vegetables and meats.
Education
Bachelor of Science - Double Major Business Analytics And IT And Finance
Rutgers, The State University of New Jersey
New Brunswick, NJ05-2025
Skills
- Python, Risk Assessment,Data Analysis and Analytics, Quantitative skills, Investment Modeling with R, Risk Modeling, 0365 (MS Excel, MS Word, MS PPT,etc), Developing Databases, BI Tool and System Design, Excel Formulas, Price Testing and Analysis, , Dashboard Design, Trend Data Analysis, , HTML, CSS, SQL
Certification
- Bloomberg Market Concepts
- Bloomberg Finance Fundamentals
- Coursera: Risk Management Specialization
- edX: Introduction to Risk Management
- MIT OpenCourseWare - Risk Management
Affiliations
Leadership Experience
Rutgers Blockchain Club(Director of Events and Partnerships) September 2022-Present
- Led a team responsible for organizing and executing 15+ club events, workshops, and conferences related to blockchain technology.
- Developed and maintained strategic partnerships with 10+ industry organizations, guest speakers, and sponsors, increasing the club's visibility and resources significantly.
- Successfully coordinated and managed a series of events, attracting over 500 diverse attendees and fostering a thriving blockchain community on campus.
Rahway Intramural Club Soccer Captain 2017-Present
- Provided and demonstrated tactical aspects of the game.
- Maintained order, control, and effective discipline on the soccer field.
Languages
English
Full Professional
Telugu
Professional
Projects
Projects
- Conducted an in-depth analysis of the RXO Fuel Card Program to identify Super Users - carriers extensively utilizing key services, resulting in increased profitability and market share.
- Utilized advanced Excel skills to organize and analyze data, creating complex formulas and functions to identify Super Users, missing services, and service utilization trends.
- Successfully identified 7 Super Users from June 2022 to June 2023, helping RXO target and serve its most valuable customers more effectively.\
- Action Plan Development: Developed an action plan to grow in-network partners' market gallons, contributing to increased revenue and market share.(Submitted directly to CEO)
Timeline
Pricing & Data Analyst Intern
XPO Logistics(RXO)
05.2023 - 08.2023
Financial Intern
RippleMatch
09.2022 - 12.2022
Accounting Intern
Bank of East Asia
05.2022 - 08.2022
Fast Food Representative
Moes
05.2022 - Current
Fast Food Representative
Subway
05.2021 - 05.2022
Bachelor of Science - Double Major Business Analytics And IT And Finance
Rutgers, The State University of New Jersey
- Bloomberg Market Concepts
- Bloomberg Finance Fundamentals
- Coursera: Risk Management Specialization
- edX: Introduction to Risk Management
- MIT OpenCourseWare - Risk Management
Similar Profiles
Nicholas McColleyNicholas McColley
Operations Lead at XPO Logistics/RXOOperations Lead at XPO Logistics/RXO
KARISHMA SAWANTKARISHMA SAWANT
Lead, HR Workforce Analytics at RXO Logistics (Formerly XPO Logistics)Lead, HR Workforce Analytics at RXO Logistics (Formerly XPO Logistics)
MELISSA HELVESTONMELISSA HELVESTON
Director of Business Analysis and Integration at XPO/RXO LogisticsDirector of Business Analysis and Integration at XPO/RXO Logistics