Anchal Rattan

Office Assistant

NJIT Reslife•  January 2019 - May 2020

Reviewed and analyzed quarterly reports reducing manual intervention by implementing procedural changes accounting for improved efficiency by 30% using functionalities in Excel and Google spreadsheets.

Data Analyst Intern

V-ETS•  July 2019 - July 2019

Performed extraction and transformation of query using SQL and analyzed data for trends and anomalies using Pivot Tables- Excel, Power BI, to interpret insights and solutions for data models in order to increase performance by 20%. Validated % accuracy and efficiency between data systems to support new technical integrations using Excel.

Lead Implementation Analyst

Mercer•  November 2014 - July 2018

Analysed and managed large data sets stored in relational database using SQL queries for analysis & measuring customer data. Performed analysis for customer data in Excel using advance functionalities (VLOOKUP, Pivot Tables, Macros) & created visualization reports for outliers, typos, identifying association, detailed insights and variation analysis. Built Tableau visualization report providing elucidate tracking of industry specific KPI’s for senior executives. Individual contributor worked with onshore team performing descriptive analysis, developing solutions to complex problems, tracking accuracy of novel software, creating formulated Excel worksheet to reducing manual intervention & increasing efficiency by 20%. Collaborated results of analysis, performed root cause analysis & crafted solutions to communicate in story form to key stakeholders and business data SME’s -Australian clients, operational teams and cross functional Agile team members- for effective course of action As a Lead Analyst was entailed interacting with customers and stakeholders –Business SME’s, clients- defining system requirements with business, organizing scrum meetings, handling ambiguity & prioritizing test activities, tracking KPI & SLA for team. Involved in Database and Risk Based Testing – Sanity/Smoke, Database, Regression, Verification/Validation, User Acceptance. Implemented Exploratory Data Analysis, Risk & Defect Management activities involving analysing, tracking and prioritizing.