VBA Job Vacancies in Noida

Develop and maintain daily, weekly and monthly operational analysis as it relates to volume, efficiencies, cycle time, quality, and serviceReport on operational metrics, conduct data and business analysis, and present summary of findings to management in a clear, concise, convincing, and actionable formatCreate and maintain daily operational scorecards to track and report on KPIs; assist in volume forecast and capacity planning as neededProvide support and maintenance to existing management information systems (MIS).Generate and distribute management reports in accurate and timely mannerDevelops MIS documentation to allow for smooth operations and easy system maintenanceProvide recommendations to update current MIS to improve reporting efficiency and consistencyPerform data analysis for generating reports on periodic basisDevelop MIS system for customer management and internal communicationProvide strong reporting and analytical information support to management teamGenerate both periodic and ad hoc reports as neededUnderstand customer problems and provide appropriate technical solutionsAnalyze business information to identify process improvements for increasing business efficiency and effectiveness.Participate in cross-functional meetings to resolve recurring customer issues.Establish a strong relationship with Team Managers and management through a demonstration of industry knowledge and of the business issues at handAnalyze current business processes and make recommendations for improvementsMaintain thorough understanding of data and information resourcesMaintain a status on all projects and proactively communicate with management and customers

Need VBA Developers who can work on Excel applications and adapts it to the specific needs of a challenge or requirements to automate repetitive tasks and accelerate the workflow of a business. Good Experience with Advance Excel and VBA is needed.

This position is for a role of an Automation and Digitization expert within Procurement department to create and maintain automated solutions leveraging Advanced excel, Macros, VBA, SharePoint and other BI tools. Individual needs to work closely along with internal & external data in opportunity identification for automations, value creation and digitization.The desired candidate must have 1 - 4 years of relevant experience in the area of Automation, Digitization and providing solutions leveraging below skill set. Prior working knowledge in Sourcing & Procurement domain will be an advantage. Advanced Excel and VBA macros development & support Identifying automation opportunities within Procurement to support business teams to eliminate manual interventions Should be able to understand & explain critical excel formulas. Adherence to Client standards for developing code for respective processes Ensure 100% adherence to framework of automation with complying with all necessary documentation, approvals and data storage & maintenance of the developed solutions Adherence to organizational policies and prescribed Framework (RADAR) for digital solutions Tracking, Maintaining and Recertification of excel macros/ solutions on a regular basis / agreed frequency Create standard dashboards to highlight updates, issues and risks SharePoint skills Design and maintenance of SharePoint pages / subsites. UI path /automation anywhereSKILLSTechnical: Proficiency in Advanced MS Excel & MS PowerPoint applications Strong knowledge VBA macros excel formulas Strong knowledge of MS Office Products, Power BI and SharePoint Data Analysis and preparing management presentations and presenting to them Excellent in identifying automation scope and should be able to understand problem statement and provide appropriate solutions. Good Dashboard and Report creating skills Prior knowledge of P2P tools or ERP systems will be an adv