Hi, I’m
Pragya Gupta
Reporting Analyst
Bangalore,India
Summary
Analytics Expert with 8+ years of rich experience in creating compelling reports and dashboards using advanced Excel. Highly adept in analyzing business needs using technical skills to provide data and information analysis to achieve continuous improvement. Proficient in advanced MS Excel formulas and functions to produce data-driven reports. Looking to work with an esteemed organization that gives me an opportunity to utilize my existing analytical skills and help make better business decisions.
Overview
9
years of professional experience
5
years of post-secondary education
Work History
ANZ Operations And TechnologyBangalore, Karnataka
Technical Consultant
08.2019 - 05.2023
Job overview
- Involved mainly in generation of browser, non-browser-based certificates, and POS certificates internally and externally
- Experience in Data Analysis, understanding trends and patterns in data.
- Developed date visualizations and reports using Advanced Excel.
- Developed ad-hoc reports using Advanced Excel for management team.
- Created SSL certificate tracker dashboard.
- Assisted customers with certificate related issues.
- Helped in installation of certificates on servers.
- Maintained guidelines for all aspects of creation, distribution, and use of digital certificates on web, including policies for certificate expiration and certificate revocation.
- Generated digital certificate for applicant and digitally sign that certificate.
- Resolving incidents that are SSL related and restore business service to reduce time.
- Supported any Changes that are SSL related and ensured business service is up and running with minimum down time.
- Performed testing of SSL end user forms on UAT environments before going live into production.
- Developed test scenarios and test cases from requirements and design specifications.
Capillary TechnologiesBangalore, Karnataka
MIS Analyst, Quality Check, Image Analyst
05.2016 - 06.2019
Job overview
- Responsible for making reports on different processes running in organization.
- Receiving and downloading data from different - different sources, Cleaning and Formatting data using EXCEL.
- Removing duplicate numbers from Data through Excel (Tools and formula).
- Analysis and forecasting for upcoming profit and loss of brands including advice on how to improve them.
- Handling multiple reports, working with formulae, pivot tables, pivot charts, and various other Excel sheet components for accurate data.
- Extracting report for agent productivity report on daily basis sharing MIS to seniors.
- Updating Data Tracker and MIS Dashboard on daily and weekly basis.
- Creating Agent reports break and log in / log out report.
- Updating attendance dashboard and sending agents allocating report.
- Ensure deliverables (Daily, Weekly, Monthly MIS Reports, Dashboard) are prepared.
- Excellent in MS Excel (HLOOKUP, VLOOKUP, lookup, Pivot Table, PivotTable Chart, Charts).
- Making Advanced presentation in MS PowerPoint to present MIS & other related important reports.
- Annotating Image for Computer Vision for improving machine learning object recognition with quality training data.
XL Health CorpBangalore, Karnataka
Associate Appeals Analyst
09.2014 - 05.2016
Job overview
- Resolve Claim disputes. Claims may be denied by an insurance company for a patient's failure to obtain a referral to see a particular provider or failure to get prior approval for a certain procedure, such as an X-ray or surgery. Other common reasons for claim denials are benefit exhaustion or having no coverage on the date of service.
- Handle disputes regarding the refusal of the insurance company to approve payment for a future procedure.
- Reviewing an applicant's contract, summary of benefits, claims history, enrolment status and sometimes, medical records to make an informed decision.
- Investigating complaints by contacting the source of the complaint and reporting the incident to them.
- Investigating complaints from insured members regarding their treatment during a doctor's visit. Grievances can be filed about the cleanliness of the doctor's office, the behavior of the staff, the time they spent in the waiting room, difficulty obtaining an appointment or the demeanor of the doctor.
Education
Amity School Of Computer ScienceNoida
Master of Computer Applications from Computer And Information Sciences
09.2011 - 06.2014
Shri Krishna Institute of Management & ScienceChandausi
Bachelor of Computer Applications from Computer And Information Sciences
09.2008 - 06.2011
Skills
Advanced Excel
MIS Reporting
Data Validation
Data Sorting
Pivot Chart, Pivot Table
SSL Certificates
Conditional Formatting
Microsoft PowerPoint
Microsoft word
Data Analysis
Timeline
Technical Consultant
ANZ Operations And Technology
08.2019 - 05.2023
MIS Analyst, Quality Check, Image Analyst
Capillary Technologies
05.2016 - 06.2019
Associate Appeals Analyst
XL Health Corp
09.2014 - 05.2016
Amity School Of Computer Science
Master of Computer Applications from Computer And Information Sciences
09.2011 - 06.2014
Shri Krishna Institute of Management & Science
Bachelor of Computer Applications from Computer And Information Sciences
09.2008 - 06.2011