Ø MS Office: - MS Word, Advance Excel and Power Point.
Ø SQL Developer, MySQL, PostgreSQL, Data Analysis, Redash & AWS Services.
Ø T-SQL (Group By, Having, Create Table, Constraints, Keys, Function).
Ø Good working knowledge in writing SQL queries and able to understand the database, database relation.
Ø Data Visualization using Metabase.
Ø Knowledge of Data Sorting, Data Filtering, What-if-Analysis, Data Consolidation, Grouping, and Validation rules.
Ø Well versed in using Reporting tools like Pivot Table, Pivot Charts, Dashboards, Graphs, etc.
Ø Ensure timely preparation of MIS Reports on daily, weekly and monthly basis.
Excellent in Advance Excel functions like If, Countif, Sumif, Sumifs, Count, V-lookup, H-lookup, Index- Match, Date time, etc