Senior Analyst - Reporting Services

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)