Financial Data Analyst
- Developed an Excel macro to look through the financial month-end closed and award reporting process. Cross-referenced awards across multiple sheets, automatically populating descriptions for matched awards to keep records precise and up-to-date, reducing reporting time by 75%
- Baselined 500+ top offset awards and verified accurate date alignment, maintaining 100% data accuracy for financial planning.
- Leveraged Oracle Financials Accounts Receivable, Grants Accounting, and General Ledger modules to identify and document revenue discrepancies by object code.
- Worked closely with the Accounting Department to resolve issues and provide clarity on the causes of variances, reducing financial planning errors by 80%.
- Designed and created 100+ reports and dashboards for Purchase Order numbers, facilitating quick Purchase Order data retrieval for informed financial decisions, saving 20 hours monthly.
As a Financial Data Analyst Intern, I was able to use tools such as Excel macro and Oracle Financials to improve accuracy, optimize reporting, and improve financial planning. This experience taught me how to apply data analysis and my technical skills to reduce inefficiencies and solve business challenges. This connects directly to my MIS major by showing how technology and information systems can create smarter processes and support better decision-making.