Senior Data Analyst
(Dec, 2013 - Jun, 2018) at aon hewitt
Experience including analysis, modeling, design and development of Tableau reports and Dashboards for analytics and reporting applications.
Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, filters, Calculated fields, Sets, Groups, Parameters etc. in Tableau.
Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
Acquire data from primary and secondary sources and maintain databases.
Experience in Big Data Analytics with hands on experience in Data Extraction, Data Analytics, Data Loading, Data Visualization.
Manupulating, Cleaning & processing the primary and secondary data using Advanced Excel, VBA (Macros), Data Science- R and SQL.
Data Management using Microsoft SQL – Tables, Queries, Stored Procedures, Functions, Views, etc.
Data Mining - Filter and clean the raw data to get the relevant information out of big data.
Preparing project setups of the companies as per client’s usage and requirements in the organization and also responsible for MIS reporting by using MS Excel and VBA.
Meeting with different key users to determine system and reporting requirements.
Developed many software modules that are used to convert raw data into reports and Automate regular reports and generate custom reports as needed.
Prepare different trackers like Production tracker, In-Progress report, Variance report, Leave Planner and Seat Utilization report through VBA.
Deliver projects by maintaining quick TAT and highest quality standards execute it in MS Excel and MS SQL.
Managing and design Monthly, Weekly Dashboards & Daily Report Creating in MS-Excel, PowerBI and Tableau through analysis and producing the actionable information.
Extensive usage of VBA (Aggregate functions, Lookup, Pivot table, Macros).
Develop strong working relationships with the business and other technology team members to deliver high quality technology solutions.
Work on Financial & Compensation and Database environments – MS SQL Server and Share Point.
Experience in R Programming Language, Data extraction, Data Cleaning, Data Loading, Data Transformation, Predictive Modeling and Data Visualization using R, PowerBI and Tableau.