Data Analyst
RGTS
Total years of experience :18 years, 1 Months
Assist the Program Manager in providing total inventory support at the RSAF F-15 Programmed Depot Maintenance (PDM) facility which includes purchase, stocking, issuing and tracking parts required to support the F-15 PDM program by using “Microsoft Business Solutions - Great Plains10”.
Plan, Schedule, Procure (submit orders) where necessary of all materials needed to meet our current and projected customer demand (forecasted, tab and firm) and maximize productivity i.e. effective replenishment and inventory planning, minimization of stock-out conditions, etc.
Maintain all master data pertinent to planning, scheduling, Tracking and inventory management including but not limited to consumption reports, average lead times, reorder points, lot sizes, Economic Order Quantities (EOQ), time fences and safety stock levels.
Prepare monthly sales forecasts based on such parameters as firm requirements, forecasted requirements and tab level requirements.
Track actual consumption and compare to the forecast and measure the rate that we are consuming the forecast.
Planning and Analyzing operational data and reports to ascertain the degree of conformity with established policies, standard and procedural directives.
Analyzes logistical data and the computation of stock control levels, while ensuring consideration of all applicable factors.
Handling all project accounts using financial accounting software “Microsoft Business Solutions - Great Plains 8.0”.
Review and approving the work of staff accountant, cash & credit sales invoices and journal transactions for data entry
Maintaining Stock Inventory for more than 6, 000 line items
Preparation of Bank Reconciliation Statements
Reconciliation of Accounts Receivable & Payable
Providing Analysis for the outstanding balances of all the Inter Companies
Preparing Sales Analysis Reports for the branch and Inter Companies as well
Preparing the Inventory reconciliation for the month end and to make sure that all accounts are in the proper cost center and then pass the journal entries
Performs other tasks as assigned by the Finance Controller & Chief Accountant from time to time
Trained new employees to administer the order entry functions.
Assisting in preparation & presentation of financial statements
Reconcile the Ageing report
Monthly closings and financial reporting
Academic Qualification: High School: Secondary School Certificate, Hyderabad, India Intermediate: Board of Intermediate, Hyderabad, India Graduation: Osmania University, Hyderabad, India