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