Personable business professional bringing successful 3 year career in financial roles within large and fast-paced corporations. Release-planning specialist trained in advanced Excel and Python modeling. Creative solutions architect with real-time problem-solving flexibility.
Overview
3
3
years of professional experience
Work History
Data Analyst
R1RCM
Noida
10.2021 - Current
Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
Produced monthly reports using advanced Excel spreadsheet functions.
Extracted and interpreted data patterns to translate findings into actionable outcomes.
Writing SQL Queries using DDL, DML and DCL commands
Working closely with business and engineering teams to encourage statistical best practices with respect to experimental design, data capture and data analysis.
Automate Excel report in Python.
Performing cleaning of data which includes understanding & removing unnecessary & repetitive data. Interacting with the client for requirement gathering and on-time reporting so as to ensure timely deliveries
Coordinating with doctors for data cleaning and variables selection to ensure data is clinical, meaningful and analysable.
MIS & Research Analyst
Chrome Data Analytics & Media
Noida
11.2018 - 07.2021
Planned and designed system improvements to meet changing demands.
Preparing MIS reports on daily, weekly and monthly basis Collect and complies statistical quality data.
Receiving data from Data Collection Team via mails. Fetching data from company’s portal. Compilation of data collected on Excel sheet from various sources
Cleaning of data and validating them using various formulas such as Trim, Data Validation, Substitute, Find, Left, Mid, Right, Text, and Len etc.
Interpreting and Analyzing data to find new logics and ideas.
Preparing and updating excel sheets related to different reports using Excel tools like V-Lookup, H-Lookup, Countifs, Sumifs, Averageifs, Conditional Formatting, Pivot Table, Charts, Graphs, Nested-Ifs etc. from gathered data.
Lead a team of Data entry for Chrome News Track.
Education
Bachelor of Science - Science
Kumaun University Nainiral
Nainital
08.2012 - 07.2015
Master of Science - Biotechnology
Doon Group of College
Dehradun
08.2015 - 02.2018
Skills
Advance excel ,SQL, MS Office, Power, BI, Python(Pandas & Numpy), Data Modeling, Data Cleaning, Statistics, Data Automation
undefined
Quote
The way to get started is to quit talking and begin doing.