Hi, I’m
Niharika Awasthy
Data Administrator
Gurugram
Summary
OBJECTIVE:
To be in the responsible position within an organization where I can apply and utilize
my skill towards the growth of the organization and enhance my personal capacities as well. Learn from exposure and initiatives within structured work framework.
· Goal-oriented and hardworking team-worker eager to apply for a challenging role with technical aspects in a fast paced, open cultured organization.
Advanced Excel: Lookups (1D,2D, reverse, fuzzy), conditional calculations (sumifs, countifs, if),
Pivot Tables (Grouping, Calculations, Slicer), Array formulas (Ctrl Shift Enter),
Advanced data cleaning tricks, Basic excel Dashboard for senior management.
Excel VBA Macros: Object Properties and Methods, Cell and range objects, loops ,forms.
SQL Server: Worked on various operational queries, updating database, fetching the required
Information through data manipulation query.
Python: Worked on various modules like numpy , pandas, seaborn etc.
Area of additional expertise includes: Data Analysis and automation, VBA (visual basic for applications),
Development, Data Management and Extraction, Data Mining.
Power Bi : Query editor, Data modelling, DAX formulas ,calculated columns and measures.
Overview
4
years of professional experience
5
years of post-secondary education
Work History
Rockford Softsol Computer Academy & Training Center Rockfoard AcademyJabalpur
Data Collection Specialist
07.2018 - 03.2022
Job overview
- Establish the needs of users and monitor user access and security
- monitor performance and manage parameters to provide fast responses to front-end users
- map out the conceptual design for a planned database
- consider both back-end organisation of data and front-end accessibility for end-users
- refine the logical design so that it can be translated into a specific data model
- further refining the physical design to meet system storage requirements
- develop, manage and test back-up and recovery plans
- ensure that storage and archiving procedures are functioning correctly
- carry out capacity planning
- work closely with IT project managers, database programmers and multimedia programmers
- communicate regularly with technical, applications and operational staff to ensure database integrity and security
- commission and install new applications and customise existing applications in order to make them fit for purpose
- manage the security and disaster recovery aspects of a database.
Education
Bharat Jyoti Vidhyalaya, Mandla
High School Diploma
06.2002 - 07.2003
Globus Engineering College, Bhopal, Bhopal
BE from Computer Science
07.2001 - 06.2005
EXCLER ACADEMY , Gurgaon
Diploma from Data Analytics And Data Science
11.2022 - 04.2023
Skills
Computer Skills
Timeline
EXCLER ACADEMY
Diploma from Data Analytics And Data Science
11.2022 - 04.2023
Data Collection Specialist
Rockford Softsol Computer Academy & Training Center Rockfoard Academy
07.2018 - 03.2022
Bharat Jyoti Vidhyalaya
High School Diploma
06.2002 - 07.2003
Globus Engineering College, Bhopal
BE from Computer Science
07.2001 - 06.2005
Similar Profiles
Catherine GeethaCatherine Geetha
Computer Instructor at PROLABS - COMPUTER TRAINING ACADEMYComputer Instructor at PROLABS - COMPUTER TRAINING ACADEMY
Nandini BhatiNandini Bhati
HR Manager at Academy for Computer Training (Guj) Pvt. Ltd (Brand Words Worth English Language Lab)HR Manager at Academy for Computer Training (Guj) Pvt. Ltd (Brand Words Worth English Language Lab)
Kylee MortonKylee Morton
Counselor's Assistant at Rockford Lutheran AcademyCounselor's Assistant at Rockford Lutheran Academy