DINESH RANGARAJU
Kingsville,USA
Summary
Dependable consultant with track record of success in field, attention to detail and proactive mindset. Seeks opportunities to improve processes and workflows for team benefit. Conscientious, hardworking and excels at multitasking in fast-paced environments. Goal oriented professional with 4+ years of experience in Software & Finance Industry.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Business Analyst - Anaplan
Hinduja Global Solutions
Hyderabad, India
02.2021 - 05.2023
- Involved in development of Planning and Analysis platform using Anaplan for Kellogg Asia Pacific Region
- Data extraction and modelling from different sources like Oracle, SAP, CCA, KTIE etc
- Into Data Hub
- Implementation of functionality for Budgeting, Planning and Forecasting and doing necessary allocation to base level
- Setting up actual and forecast P&L reporting at various levels like Legal Entity, SKU etc
- Implemented currency conversion for reporting in USD/Regional Currency or Local Currency
- Build functionality to export the data to BPC system in the required format
- Implemented ALM
- Developed a Financial Planning and Analysis system for Kellogg Asia Pacific Region based on the inputs from business and end users
- Complete Development of FP&A Model for one of the specified Sub-Region with in Kellogg APAC Region right from building hierarchies, interfaces, Allocation Logic and Final Reporting dashboards
- Co-ordination with data services team for interfacing data from source systems to hub and data hub from individual models
- Implementing the ALM set up towards the end of development for provisions to the production model for end users
- Delivering Show cases to end users after each phase to exhibit the functionalities
- Implemented functionality to clear working version numbers before every forecast cycle
- Implemented functionality to stop BPC forecast refresh for the business units who have already signed off
- Enhanced actual reporting dashboards to display UFC numbers individually
- Worked on mapping and logic issues on the fly while period closure.
Business Analyst - Finance
OSI Systems
Hyderabad, India
04.2019 - 02.2021
- Worked in Processing of Invoice's using Navision for Rapiscan Systems Entity
- Working end to end on purchase to pay process
- Preparing unmatched report daily to view how many GRN's are received
- Doing PO's and NON - PO's daily of different vendors
- Maintain Copies of Vouchers, Invoices or Correspondence Necessary for Files
- Dealing with invoice issues like unit prices, quantities, credit notes etc
- Contacting suppliers and buyers regularly through emails and resolving issues
- Reconciliation of vendor statements and making the balance Zero
- Review of aging report on a daily basis and resolve the issues in consultation business
- Doing Quality check of the invoices of other team members
- Creating Logs for the invoices for accrual purpose
- Maintaining cordial relations with other staff and assisted them in resolving their issues.
Education
Master of Science - Computer Science
Texas A&M University
12-2024
Master of Business Administration - Finance
Bhavans Vivekanada College
03-2019
Bachelor of Technology - Computer Science
Vignan Institute of Technology and Science
05.2016
Skills
- Anaplan
- Forecasting and Reporting
- MS Office
- SAP BPC & SAC
- Python
- SQL
- Client Requirements Assessment
- Reports and Documentation
- Business and Financial Planning
- User acceptance testing
- Data Analysis
- Quality Assurance
Certification
- SAP FI/CO
- Anaplan Model Builder (Level 1 & Level 2)
- SAP Analytics Cloud
- SAP BPC
Languages
- English, Full Professional
- Telugu, Native/ Bilingual
- Hindi, Full Professional
Timeline
Business Analyst - Anaplan
Hinduja Global Solutions
02.2021 - 05.2023
Business Analyst - Finance
OSI Systems
04.2019 - 02.2021
Master of Science - Computer Science
Texas A&M University
Master of Business Administration - Finance
Bhavans Vivekanada College
Bachelor of Technology - Computer Science
Vignan Institute of Technology and Science