Wipro
Location
Gurgaon | India
Job description
Detailed Responsibilities Deliver ongoing / scheduled reports / dashboards effectively on daily/weekly/monthly/quarterly basis Identify areas of optimizing ongoing steps / techniques used to delivery ongoing reports / dashboards through knowledge of adv. Excel , VBA & SQL. Derive problem statement from ambiguous data Provide view & support clients as required in areas like Productivity & Cost Reduction Effective coordination with onshore/offshore data consultants & business stakeholders Good data visualization skills using tableau, excel or other visualization tools.
Role-specific Technical Skills & Knowledge 1 – 3 years of overall experience in Adv. excel, VBA, Access, SQL and Tableau etc. Understanding of basic functions and features like Find & Replace, Sheet Navigation, auto filter, Sorting, VLOOKUP, PIVOT, basic application of conditional formatting, along with basic formatting knowledge, page setup to organize and format dataset. Basic understanding of VBE module, variable declaration and scope, loops, logical statement, various objects like menu bar, windows available and keyboard shortcuts. Basic knowledge of macro recording, editing and assigning short cuts. Understanding of basic DDL/DML statements (like Create, Select, Delete, Update, Alter, Truncate commands) with complete syntax. Also familiar with basic RDBMS concepts including keys and data integrity rules (like Primary Key, Foreign key, unique constraints) Proficient in using existing Tableau in-built charts with pre-loaded data or using flat files. Strong problem solving ability & learning agility Good communication and presentation skills Education & Certification Graduation with diploma in computer / B Tech /MCA/MBA (IT)/M.Sc.(IT)/ M.Sc Maths/Stats/OR with excellent database knowledge, preferred additional PGDCA, Database certification with exposure to given tools & techniques.Job tags
Salary
