Job Description

Key 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 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

Preferred Skills:

---------------------


Analytics->Reporting -> VBA Automation