Skill:- Data Entry,Pivot Table Development and Management, Process Improvement, Reporting ,Team Leadership ,Quality Assurance, Time Management.
Description:-
• Compile and generate spreadsheets capturing key data related to company active contracts.
• Research, update, and validate data underlying spreadsheet production; strategically fill gaps.
• Create pivot tables and modify spreadsheets to achieve analytical goals.
• Manage spreadsheets and maintain data currency to ensure accurate data availability for managers and decision-makers.
• Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions.
• Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.
• Designed, recorded, and executed macros to automate data entry inputs.
• Formatted spreadsheets and workbooks for print, document reproduction, and presentations.
• Collected, organized, and documented infrastructure project attributes, data, and project metrics.
• Processed data load requests, manually entered data, reconciled data conflicts, and created data extracts and reports.
• Performed data manipulation, transformation, and cleansing.
• Prepared routine and ad hoc status reports.
• Sorted rate card data into Excel to facilitate management and exporting.
• Cleaned old financial data and upl