Rachana T S
Bangalore
Summary
Dynamic finance professional with experience at Dotdash Meredith, excelling in financial planning and analysis. Successfully supported budgeting processes and identified cost optimization opportunities, enhancing financial performance and decision-making. Eager to contribute to a dynamic team and support organizational goals.
Overview
1
1
Certification
4
4
years of professional experience
Work History
Financial Analyst -
Dotdash Meredith
Bangalore
10.2022 - 11.2024
- Supported monthly financial close through accrual analysis, revenue recognition journal entries, and variance review.
- Analyzed spend report data, facilitating informed financial review and decision-making.
- Provided cost insights to finance business partners, enabling effective spend monitoring and identification of optimization opportunities.
- Assisted with budgeting and bonus plan model development.
- Uploaded forecast numbers into Hyperion and compared forecast against actuals each month.
- Prepared open headcount report, headcount report, flash report, and forecast report.
- Uploaded and downloaded financial journals in Oracle system.
- Performed financial planning and analysis using MicroStrategy and Workday data.
- Worked on cash reports, cash reconciliation, and BlackLine reconciliation.
- Maintained Excel models for cash flow, accruals, and management reporting.
- Assisted month-end close through journal entries, account analysis, and variance explanations.
- Prepared monthly balance sheets, income statements, cash flows statements, budgets.
- Drafted presentations summarizing key findings from financial analyses.
Associate Content Analyst -
London Stock Exchange Group
Bangalore
12.2020 - 09.2022
- Executed partial data queries to facilitate data analysis and reporting. SQL and FNC SQL queries daily, researched credit ratings through Moody's, Fitch, and S&P sites to enhance data integrity and analysis.
- Gathered trustee reports and prospectus documents to support BlackRock project work related to Rule 3C7, facilitating compliance and project objectives.
- Added newly issued ABS, MBS, CDO, and CLO bonds using CUSIP feed and IFR data, and maintained portfolio updates.
- Supported collateral mortgage obligation processing for fixed income structured products, including ABS, MBS, corporate actions, and related security updates.
- Entered deal data, backfilled from prospectus details, and updated factors and coupons based on bond payment frequency to ensure accuracy.
- Calculated and checked principal and interest components to reduce discrepancies.
- Verified entries across multiple applications and coordinated with the service team to respond to client questions in a timely manner.
- Assessed fallback provision requirements to ensure compliance with regulations. requirements and implemented updates.
Education
Master of Business Administration - Finance and Human Resources
Dayananda Sagar College of Arts, Science And Commerce
Bangalore11-2020
Bachelor of Commerce - Accountancy and Taxation
PES Degree College
Bangalore07-2018
Skills
- Financial modeling
- Data analysis
- Oracle database management
- Hyperion reporting
- Oracle database management
- SQL proficiency
- MicroStrategy analytics
- Microsoft Office suite
- MicroStrategy analytics
Title
Financial Analyst
Certification
- Star Performer Award – Q2 2023
Recognized for consistent performance, accurate reporting, timely reconciliations, and allocation entries. - Best Team – Q4 2022
Recognized for improving reporting accuracy, and successfully delivering cash reports within strict reporting timelines.
ACADEMIC PROJECTS
- A study on Employee Pension Obligations and their funding patterns in Public Sector Banks.
- A study on Effectiveness of Social Media Recruitment in IT companies.
LANGUAGES
English, Kannada, Hindi and Telugu.
Timeline
Financial Analyst -
Dotdash Meredith
10.2022 - 11.2024
Associate Content Analyst -
London Stock Exchange Group
12.2020 - 09.2022
Master of Business Administration - Finance and Human Resources
Dayananda Sagar College of Arts, Science And Commerce
Bachelor of Commerce - Accountancy and Taxation
PES Degree College