sandeep nayal
Reporting Analyst
Gurgaon,Haryana
Summary
- A detail-oriented Sr.Executive having around 5+ years of professional experience in Microsoft Excel / Access and 1+ year professional experience Power Bi/Tableau development & SQL.
- More than 4 years of experience developing databases and applications for data transformation and validation projects for real estate.
- Automating, modifying, and optimizing reports in Excel.
- Experience in redesigning, maintaining and supporting existing applications and tools especially in Microsoft Excel.
- Experience in Advanced Excel and its features like Pivot Tables, Charts, Functions, Conditional Formatting, Formulas etc.
- Experience in migration of databases to MS Access utilizing tables, queries, forms, reports, macros, and modules.
- Experience in SQL statements, stored procedures using SQL server 2008.
- Experience in extracting, transforming and exporting data between different RDBMS and from flat file to Excel and vise-versa.
- Used MS Excel to send system generated e-mails, manage and report embedded Excel documents.
- Created Dashboard in MS Excel/ Power BI.
- Prepared program level and user level documentation.
- Experience working according to internal standards and external audit standards.
- Excellent team co-ordination, organizational and interpersonal skills with result oriented approach. Experience in Power BI:
- Sound knowledge on creating Power BI reports & Dashboards.
- Good knowledge on developing various visualizations.
- Working in Power BI Desktop, Power BI Service and Power Query to convert the data in desired format and creating visualizations.
- Worked on all types of transformations that are available in Power bi query editor.
- Involved different type of charts like Pie, Bar stacked bar and column, line, area and donut charts and filter conditions as per the requirement in power bi.
Overview
8
8
years of professional experience
Work History
Sr.Executive
Bharti Airtel Ltd
Gurgaon
07.2022 - Current
- Generated reports and obtained data to develop analytics on key performance and operational metrics.
- Worked with internal teams to understand business needs and changing strategies.
- Assisted with efforts to track, evaluate and report on impact of programs using multiple data sources.
- Collected, tracked and reviewed data to evaluate business and market trends.
- Recommended metrics and models based on observed trends.
- Audited initial datasets to confirm validity of imported data, corroborating changes against updates in data tapes.
- Interacted with non-technical stakeholders to deliver analyses and answer questions on deliverables.
- Synthesized business intelligence or trend data to support recommendations for action.
- Optimized existing database structures for better performance on analytics tasks.
- Provided data-driven solutions to support decision making.
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Managed large datasets using Excel, SQL, and other data tools.
- Developed dashboards with Tableau to monitor key performance indicators.
Quality Analyst
Orion Realtors
Gurgaon
02.2021 - 07.2022
- Migration of whole data from ZOHO(CRM) to Lead squared(CRM)
- Data processing, data cleaning, data correlation, data enhancement foremost in Microsoft Excel/Power-BI/ SQL Server
- Prepare reports based on word, excel or power point
- Pivots creation and Dashboard creation (POWER-BI/ Excel).
- Worked with team members to create efficient workflows, resulting in high productivity.
- Communicated regularly with management to discuss quality trends.
- Conducted internal audits to measure adherence to established QA standards.
- Used quality monitoring system to compile and track individual and team performance.
- Prepared and analyzed internal and external quality reports for management staff review.
- Developed corrective and preventive action plans to resolve non-compliance issues.
- Utilized client satisfaction surveys to improve service quality.
- Recommended improvements to systems and procedures for increased productivity.
- Managed onsite testing for customers as required by project's specifications.
Quality Analyst
360 realtors
Gurgaon
06.2019 - 01.2021
- Worked with team members to create efficient workflows, resulting in high productivity.
- Communicated regularly with management to discuss quality trends.
- Conducted internal audits to measure adherence to established QA standards.
- Used quality monitoring system to compile and track individual and team performance.
- Trained and led staff on proper QA standards.
- Maintained policy, procedures, work instructions, and projects for quality and continuous improvement agendas.
- Prepared and analyzed internal and external quality reports for management staff review.
Senior Executive Operations
Big Foot retails Solutions
Delhi
09.2017 - 06.2019
- Work on a variety of data entry and administration-related tasks
- Responded to customer inquiries, complaints, and requests in a timely manner.
- Created weekly reports detailing call volume and average handle time.
- Identified opportunities for improvement in customer service processes.
- Utilized CRM systems for accurate record-keeping and tracking interactions.
- Navigated multiple software applications while assisting customers.
- Improved product knowledge on continuous basis to provide optimal service and achieve sales quotas.
- Determined accurate prices for customer services, consistently searching for deals and best prices.
- Resolved customer complaints, ensuring a positive experience.
- Maintained up-to-date knowledge of company policies and procedures.
- Collaborated with sales team members to stay current on inventory levels and resolve item issues.
- Mentored junior team members and managed employee relationships.
- Managed high volume of inbound customer calls with professionalism.
- Strengthened customer retention by offering discount options.
- Supported sales team members to drive growth and development.
Sr.Executive
Aegis Pvt Ltd
09.2016 - 09.2017
- Responded to customer inquiries, complaints, and requests in a timely manner.
- Created weekly reports detailing call volume and average handle time.
- Identified opportunities for improvement in customer service processes.
- Developed training materials for new call center agents.
- Monitored team performance metrics on a daily basis.
- Conducted regular quality assurance checks on agent calls.
- Participated in meetings to discuss process improvements or changes in procedures.
- Analyzed customer feedback data to identify areas of improvement within the department.
- Resolved customer complaints quickly and efficiently.
- Provided technical support for both internal staff and external customers.
- Tracked customer orders from start to finish using order management systems.
Education
M.Tech -
Graphic era university
01.2011
B.Tech -
Uttar Pradesh Technical University
01.2009
Skills
- MS EXCEL
- SQL SERVER
- POWER BI
- TABLEAU
Timeline
Sr.Executive
Bharti Airtel Ltd
07.2022 - Current
Quality Analyst
Orion Realtors
02.2021 - 07.2022
Quality Analyst
360 realtors
06.2019 - 01.2021
Senior Executive Operations
Big Foot retails Solutions
09.2017 - 06.2019
Sr.Executive
Aegis Pvt Ltd
09.2016 - 09.2017
M.Tech -
Graphic era university
B.Tech -
Uttar Pradesh Technical University
Similar Profiles
Yacouba SoireYacouba Soire
Inventory Manager at Airtel Burkina, Bharti AirtelInventory Manager at Airtel Burkina, Bharti Airtel
Ranjit PanikarRanjit Panikar
Account Manager - B2B Business Development at Bharti Airtel Limited (Airtel Business)Account Manager - B2B Business Development at Bharti Airtel Limited (Airtel Business)
Yagyaval Singh RajputYagyaval Singh Rajput
Young Leader Program at Bharti AirtelYoung Leader Program at Bharti Airtel
Sufyan KhanSufyan Khan
NOC Engineer at Bharti AirtelNOC Engineer at Bharti Airtel
LAKSHAY JAKHARLAKSHAY JAKHAR
Freelance Data Analyst at Deva Swimming InstituteFreelance Data Analyst at Deva Swimming Institute