Associate Analyst

Clarity Consulting
  • Pune
  • Confidential
  • 2-6 years
  • Views
  • 02 Jul 2018

  • Business Analytics

  • Other
Job Description

VBA Reporting Work Experience: 2-5 years experience in VBA . Report level knowledge: Intermediate 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.


Job Posted By

About Organisation

Clarity Consulting