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 teamsExperience in interacting with business users, self-starter ready to work with minimal inputsAbility to design Excel applications that interact robustly with usersDevelop & 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 automationProvide feasibility analysis for projects undertakenDocument requirements post completion of projectsProvide support to end users once tools are deployedSkills :
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 macrosAbility to write complex SQL queries like join, union, etc.Hands on with Python, JavaScript will be added advantageProven record of working on multiple applications integration with excelExcelAccessMS Power PointMS OutlookInternet 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 loopsGood understanding of client-server architectureGood Interpersonal, analytical and written communication skillsWork Experience :
5+ years’ experience in VBA Macros, SQL / Oracle / Teradata5+ Years of experience in Power BIExperience in Finance & Accounting / Sales & Marketing operations functional domains preferredEducation :
Graduate (BE / BCA / BSc), Postgraduate (MCA / MSc)