PREETI GUPTA
Noida
Summary
Enthusiastic individual having 4+ years of experience interested in data manipulation and BI reporting and automation, wanting to be a part of developing data analysis and data discovery solutions that help organizations in making better business decisions.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Buisiness Analyst
Wipro Ltd
12.2021 - Current
- Performed data analysis using advanced Excel functions to generate comprehensive reports and insights.
- Wrote and modified SQL queries to retrieve and analyze data, including complex joins, subqueries, and procedures based on business requirements.
- Designed and created interactive dashboard, filters, and calculations in Tableau to visualize key data metrics.
- Scheduled and automated workflows to improve process efficiency and reduce manual data manipulation.
- Managed Wipro's Service Agreement (SLA) with clients, ensuring all key metrics were consistently tracked and met.
- Maintained high data quality standards, ensuring reliable insights for business decision making.
- Support business teams by handling ad-hoc data requests, delivering accurate and timely reports for decision making.
Executive
Lenskart Solutions Pvt. Ltd
04.2021 - 11.2021
- Maintaining the acquisition report, I use to prepare a dashboard by which the decision-making team understands the business needs for different parameters.
- Preparation of required PAN India MIS reports to management, as per prescribed timelines.
- Managed and prepared daily, weekly, monthly, and annual reports.
- Designing and formulating new reports, and creating Dashboards as per requirement.
- Collected raw data daily from SQL server and utilized MS Excel and Power BI for processing and visualization.
Relationship Officer
Canara HSBC OBC Life Insurance
05.2019 - 11.2020
- Analyzed multiple daily reports to assess activations from various sources, including branches, website, and direct channels.
- Created daily and weekly reports, categorized by channel and category.
- Recorded monthly revenue using data analysis tool to identify qualified leads.
- Manipulate data using spreadsheets, including charts and tables.
- Compiled monthly data and reported revenue comparison to management by using Excel.
- Provided investment suggestions to clients for effective wealth management.
Education
MBA - Finance & Business Analyst
GLA University
05.2019
BCA -
GLA University
05.2017
Skills
- MS SQL Server
- Advance Excel
- Power BI(Learning stage)
- Analytical Skills
- Tableau
- Alteryx
Awards
- Got appreciation to onshore side for completing the project before time.
- Got R&R for best performer in team
- Got appreciation RP points for best performance in the team
- Best Performance of the year award, Canara HSBC OBC Life Insurance
Certification
- SQL- Mysql for Data Analytics and business intelligence
- Tableau data Analyst/Specialist desktop Certification
Timeline
Buisiness Analyst
Wipro Ltd
12.2021 - Current
Executive
Lenskart Solutions Pvt. Ltd
04.2021 - 11.2021
Relationship Officer
Canara HSBC OBC Life Insurance
05.2019 - 11.2020
MBA - Finance & Business Analyst
GLA University
BCA -
GLA University
Similar Profiles
Tania KhandakarTania Khandakar
GIS Consultant at Wipro LTDGIS Consultant at Wipro LTD
Neelima GuduruNeelima Guduru
Project Manager at Wipro LtdProject Manager at Wipro Ltd
Deanna WilliamsDeanna Williams
Prior Authorization Configuration Audit SME/Prior Authorization Analyst at Wipro LTDPrior Authorization Configuration Audit SME/Prior Authorization Analyst at Wipro LTD
Aneesh AbrahamAneesh Abraham
Principal Consultant- Retail Banking at Wipro LTDPrincipal Consultant- Retail Banking at Wipro LTD
Mukesh Singh RawatMukesh Singh Rawat
Manager- Appian at Cognizant TechnologyManager- Appian at Cognizant Technology