Advanced Excel Accounting with MIS Specialist Job Description: Utilized advanced Excel skills to streamline financial reporting processes, ensuring accuracy and efficiency in data analysis and interpretation. Developed and maintained complex spreadsheets, including financial models, budget trackers, and variance analysis reports. Created and automated financial reports using PivotTables, VLOOKUP, INDEX/MATCH, SUMIFS, and other advanced Excel functions to facilitate decision-making. Conducted detailed financial analysis and provided insights to management through graphical representations and charts generated in Excel. Managed and optimized large datasets from multiple sources to compile and analyze financial information for forecasting and strategic planning purposes. Implemented data validation techniques and ensured data integrity by setting up error checks and validation rules in Excel spreadsheets. Collaborated with cross-functional teams to gather requirements and deliver customized reports and dashboards using Excel and MIS tools. Implemented and maintained MIS systems to track key performance indicators (KPIs) and financial metrics, providing actionable insights to stakeholders. Provided training and support to team members on advanced Excel techniques and MIS tools to enhance departmental efficiency and productivity. Achievements: Successfully reduced financial reporting time through automation of repetitive tasks using Excel macros and VBA. Implemented a new MIS dashboard that improved visibility into financial performance metrics, resulting in more informed decision-making. Received recognition for accuracy and reliability in financial data analysis, contributing to improved budget forecasting accuracy by.

Active Involvement in implementation of SAP B-One. Handling accounts payable for the company, including vendor reconciliation on regular basis. Preparing data for GSTR-1, reconciliation of GSTR-2B and GSTR-3B filling. Preparation of TDS return working. Cash/Bank reconciliation. Inventory Reconciliation & Valuation on Monthly basis. Monthly/Quarterly book closing activities. Master updating and approval of Accounts master and item master in ERP. Team Management - Leading the team for data extraction, analysis and system testing, summarizing results in standard quality control reports and documents and further sharing it with business partners. Talent Development - Identify training opportunities for the team and managing the same for continuous skill upgrade/development within the team. Teamwork - Develop cross-site relationships to enhance understanding; visioning synergies within SIS activities and implementing value added enhancements to the process.

Involvement in in-depth testing of data integrations product upgrades from time to time. Ability to understand the business, develop data-driven solutions to address business problems and independently manage end-to-end project communication with business partners. Self-motivated individuals who are comfortable working in teams with high growth potential and involved in transitioning the highly complex and critical projects. Understand the campaign objective, requirement gathering on the data needs/system needs, etc. Code, test and execute the campaign requests as required. Design and development of campaign data files – regular and ad hoc. Work closely to create all targeting/channel/fulfillment files as required. On-time delivery and quick TAT, multitask and manage multiple projects independently.

Prepare Requirement Traceability Matrix (RTM). Responsible for project assignment and perform regular status checks. Very good knowledge of MS Excel. Liaise with clients and manage relationships. Experience in reporting and/or data management. Responsible to deliver Human Capital reporting to HR (primary business partner), Global Functions, and other businesses in a seamless and efficient fashion via SAP Business Objects, MS Excel and Accounting Software ERP. Deliver standard HR reporting to global stakeholders.