Reporting Analytics

This role will be responsible for automation and delivery of Reporting services as part of a Shared Services team to large multinational clients.

Key tasks include: Timely error-free delivery of assigned reports, quick response to client queries Automation of reports using VBA macro and advanced excel

Execute Change requests for reports being delivered Assess reports for improvement opportunities and/or execute improvement ideas

Responsibilities Activities Description

Participate in business requirements discussions with the different operations teams

Experience in interacting with business users, self-starter ready to work with minimal inputs

Ability to design Excel applications that interact robustly with users

Develop maintain Dashboards using Advanced excel (Formula and charts) VBA (Visual Basics for Applications)

Develop and maintain Excel macros, Excel/Access-based, VB Script apps, web based macro and mainframe automation

Provide feasibility analysis for projects undertaken Document requirements post completion of projects

Provide support to end users once tools are deployed

Skills: Detailed knowledge of VBA / VB Scripts to be able to write modules from scratch, including ability to make user forms, objects and worksheets and all powered by VBA macros

Ability to write complex SQL queries like join, union, etc.

Proven record of working on multiple applications integration with excel Excel Excel Excel- Access Excel - MS Power Point Excel - MS Outlook Excel Internet Explorer/Chrome (Browsers) Excel MS SQL/Oracle/Teradata (Databases) Strong on Excel Charts, Pivots, Slicers, Excel formulae, Dashboard views, Index Match, Vlookup Hlookup, Offset, named ranges, Nested loops

Good understanding of client-server architecture

Good Interpersonal, analytical and written communication skills

Good Knowledge in RDBMS Access / SQL / Oracle etc.

Knowledge on Dot-Net would be an added advantage

Work Experience: 1-5 years experience in VBA Macros, SQL/Oracle/Teradata

Experience in Finance Accounting / Sales Marketing operations functional domains preferred