Artificial Intelligence and Information Technology
Priyanshu Shaw
Data Analyst
Kolkata
Summary
Detail-oriented and analytical MIS Executive with expertise in Advanced Excel (VLOOKUP, PivotTables, Power Query, Macros) and Data visualization , honed at Rapid Accounts And Tax Solution Co. Skilled in automating reporting tasks and tracking KPIs to enhance business strategies. Strong communicator adept at managing sensitive information and ensuring data integrity through effective data handling and summarization. Now seeking to leverage data skills to drive operational efficiency and business growth.
Overview
3
3
years of professional experience
5
5
years of post-secondary education
2
2
Languages
Work History
MIS Executive
Rapid Accounts And Tax Solution Co.
Kolkata
04.2023 - 10.2024
- Produced tables, pivot reports and charts for use in key decision-making processes.
- Collect, compile, and analyze large volumes of data from various departments.
- Prepare and maintain daily, weekly, and monthly MIS reports and dashboards.
- Use Advanced Excel functions such as VLOOKUP, XLOOKUP, PivotTables, Power Query, and Macros to automate and streamline reporting tasks.
- Identify and report on key performance indicators (KPIs) to support business strategy.
Administrative Assistant
Education Department
Kolkata
04.2022 - 01.2023
- Answered multi-line phone system, routing calls, delivering messages to staff and greeting visitors.
- Maintained confidentiality of sensitive information by adhering to strict privacy policies and implementing secure filing systems.
- Ensured accurate record-keeping with diligent data entry and database management for vital company information.
Education
Bachelor's Degree - Accounting And Finance
University of Calcutta
Kolkata, West Bengal 08.2019 - 08.2022
Higher Secondary - Commerce
West Bengal Council of Higher Secondary Education
Kolkata, West Bengal 01.2018 - 02.2019
Matriculation -
West Bengal Board of Secondary Education
Howrah, West Bengal 01.2016 - 03.2017
Skills
MIS expertise
Advanced Excel
Arithmetic functions
Logical functions
LOOKUP functions
Conditional Formatting
Date and Text functions
Data Handling
Data Visualization
Data Summarization
Pivot Table, Power Pivot
VBA and Macros
Dashboard and Report
Power Query
Power BI
Visualization
Modelling
KPI tracking
ETL Process
Data Validation
Data Mapping
Ms Office 2021
MS Word
MS PowerPoint
Effective communication
Interests
Timeline
MIS Executive
Rapid Accounts And Tax Solution Co.
04.2023 - 10.2024
Administrative Assistant
Education Department
04.2022 - 01.2023
Bachelor's Degree - Accounting And Finance
University of Calcutta
08.2019 - 08.2022
Higher Secondary - Commerce
West Bengal Council of Higher Secondary Education
01.2018 - 02.2019
Matriculation -
West Bengal Board of Secondary Education
01.2016 - 03.2017
Similar Profiles
MARINA BALANIUCMARINA BALANIUC
Trainee Accountant at Accounts Tax GroupTrainee Accountant at Accounts Tax Group
Karent DiazKarent Diaz
Tax Preparer at Rapid Tax Solutions & MoreTax Preparer at Rapid Tax Solutions & More
ERICA DOVERERICA DOVER
Tax Professional at RAPID TAX DBA HR BLOCKTax Professional at RAPID TAX DBA HR BLOCK
Supriya AdhikarySupriya Adhikary
IT Analyst (O365, Exchange Online and On-prem, Teams and Skype Admin L2) at Tata Consultancy ServicesIT Analyst (O365, Exchange Online and On-prem, Teams and Skype Admin L2) at Tata Consultancy Services
Swati Parvatham GhoshSwati Parvatham Ghosh
Marketing Lead – SEO, Content & Social Media at No Nirvana DigitalMarketing Lead – SEO, Content & Social Media at No Nirvana Digital