Talent.com
This job offer is not available in your country.
Senior Analyst – Reporting Services (VBA Developer)

Senior Analyst – Reporting Services (VBA Developer)

Infosys BPMBengaluru, Karnataka, India
25 days ago
Job description

Greetings from Infosys BPM

We are hiring for Sr. Analyst – Reporting Services (VBA Developer) for Bangalore / Pune Location.

Job Description :

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 :

  • Must have 5+ years of Reporting & Analytics experience of which at least 3+ year hands-on experience in Power BI in developing dashboards using multiple data sources (DBs, Excel, SharePoint, etc.).
  • Working knowledge of Advanced Excel graphs (dynamic graphs, 3 axis charts, Waterfall chart, etc.)
  • 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.
  • Hands on with Python, JavaScript will be added advantage
  • Proven record of working on multiple applications integration with excel
  • Excel
  • Access
  • MS Power Point
  • MS Outlook
  • Internet Explorer / Chrome (Browsers)
  • 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

    • Work Experience :

  • 5+ years’ experience in VBA Macros, SQL / Oracle / Teradata
  • 5+ Years of experience in Power BI
  • Experience in Finance & Accounting / Sales & Marketing operations functional domains preferred

    • Education :

  • Graduate (BE / BCA / BSc), Postgraduate (MCA / MSc)
    • Create a job alert for this search

    Reporting Analyst • Bengaluru, Karnataka, India