Bennett Coleman Company Limited - Lead - Finance Automation

Position Objective:

- The Finance Automation Specialist is a key member of the Emerging Technology for Finance Team. The position will support multiple efforts of the Project Team, with specific focus on process identification, design, and evaluating use cases for ET in those processes.

- The Emerging Technology for Finance is a Finance led initiative in conjunction with IT to assess, test, develop and implement Emerging Technologies in the Finance function using technologies including Robotic Process Automation (RPA) and Data & Analytics

- Candidate should bring knowhow of various automation interventions across Finance & Accounts value chain including both non RPA tool led interventions and RPA led interventions.

- Common tools knowledge could be around tools below, expected to know functional aspects of few of the below and will be great if certified on anyone (or combination) below:

a) Accounts Payable tools: PRM364, Ariba, Expenzing, Zycus, or any other P2P software.

b) Travel & Expense tools: Concur, Happay.

c) RPA bots creation using Uipath, Automation Anywhere, Blue Prism.

Should be abreast of all common Finance & Accounting concepts & practices / procedures.

- The person will anchor Finance transformation projects from functional perspective, get trained on few of the above tools and act as functional consultant / SME on F&A tools deployment, perform requirement gathering and create functional specifications document and also support RPA led projects from functional stand point for projects across Finance and Accounting areas.

- Person should be hands-on to deliver small integrations using excel VBA and alike to impact and deliver low-hanging fruits of process automation

Roles and Responsibilities :

- Participate as an integral team member on multi-disciplined team seeking to assess, test, develop and implement approaches for introducing Emerging Technologies in the global Finance organization, with specific near-term focus on RPA.

- Act as a COP Finance resource to the RPA pilot consultants, learning methodology, best practices and automation coding requirements associated with specific tools piloted.

- Design framework for identifying the opportunity set for RPA across global Finance and characterization to enable prioritization for implementation.

- Prepare detailed process design documents in conjunction with Finance process owners and IT process experts that enable assessment of automation viability, scope and eventually detailed RPA coding.

- Work collaboratively with other Project team members and Finance/IT organization to establish business support model and governance framework for RPA in Finance/COP.

Automation Support Delivery:

a) Identify automation opportunities across business functions.

b) Work directly with stakeholders to capture business requirements and translate them into technical approaches and designs for implementation.

c) Provide guidance for process design and architecture.

d) Develop RPA bots, utilize other tools and technologies to deliver automation solutions.

e) Design, develop, and test automation workflows.

f) Support the launch and implementation of Automation Anywhere RPA solutions.

g) Assure the quality of the automation (QA processes).

h) Collaborate with development team members to ensure proper implementation and integration of the solutions.

i) Support deployments or troubleshoot production issues.

j) Ensures compliance to policies, procedures, and internal controls.

k) Stakeholder Engagement

l) Engage with business functions to identify automation opportunities.

m) Provide ideas for automation solutions and architecture.

n) Solve problems related to automation.

o) Ensure right SLAs for post deployment support to ensure customer satisfaction

Skills and competencies :

- Bachelors degree or higher in finance, accounting, economics, IT or related discipline

Building complex VBA scripts to automate Excel spreadsheet processes Manipulating data with complex Excel, VBA, Power Query Editors, Power BI, Google Tools (i.e., Spreadsheet, Forms, Data Studio etc), Uipath, Automation Anywhere, Blue Prism and SQL Coding

- Expert level Excel skills (Conditional Formatting, Data Validation Rules, Table Manipulation, Named Ranges, Creating/Modifying connections to external data sources, Workbook/Worksheet/Cell Data Protection) and graphing to streamline business processes

- Expert level Excel VBA skills (Ability to create complex forms/functions/subroutines, Experience using constants and visibility modifiers, Programmatic manipulation of objects/tables/data connections/formulas)

- Able to debug/code difficult functions/macros using VBA

- Strong analytical and problem-solving skills

- Strong process skills, including ability to summarize and present process flow, systems integration and control points in process design documentation

- Strong Microsoft Office skills, including PowerPoint, Excel, Word and SharePoint

- Strong interpersonal and collaborative skills working with financial, IT and management personnel