Analyst Knowledge Services

Responsibilities 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 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 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 skillsWork 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 preferredEducation :
• Graduate(BE / BCA / BSc), Post Graduate(MCA / MSc) Educational Requirements Graduate