Vipul Sharan Email & Phone Number

New Delhi, Dl, In

Noida, Uttar Pradesh, India

Analysing collections data using SQL and excel to identify trends, resulting in a 15% increase in quarterly revenue.Developing interactive dashboards using Excel, ppt and PowerBi to visualize key performance indicators for management.Collaborate with cross-functional teams to streamline data collection processes, reducing report generation time by 30%.Assisting in the development of predictive models using statistical techniques to forecast sales trends.Cleaning and preparing large datasets for analysis, ensuring data integrity and accuracy.Creating detailed reports summarizing findings from data analyses for stakeholders.Participating in team meetings to discuss project progress and present analytical results.Coordination with all Process Team Leaders, Asst. Managers and Managers.Day to Day reporting according to the reports generated by the Debthor application, Convox Application and manual excel sheet reports by all process Teams.Team Management - WFM and MISAssistant to Manager AnalyticsReport Management - Excel & Advanced ExcelUsed Functions:VLOOKUP, HLOOKUP, INDEX, MATCH, IF with AND/OR, SUMIF, COUNTIF, AVG,SUM, COUNT, MIN, MAX, LEN, TRIM, CONCATENATE etc. Report Management - SQL using advanced Query functions:SELECT, FROM, WHERE, INSERT, UPDATE, DELETE, GROUP BY, ORDER BY, SUM, AVG, CASE WHEN, EXTRACT, COUNT, DISTINCT, JOIN etc.LEARNING GOING ON: TABLEAU, ML with PYTHON for future development.

Patna, Bihar, India

As a Data Analyst, my primary responsibility was to assist in data collection, analysis, and reporting to support decision-making processes within the organization.My Key Responsibilities includes:Data Collection and Preparation:Gather data from various sources including databases, spreadsheets, and external datasets.Clean and preprocess data to ensure accuracy and consistency for analysis.Data Analysis:Utilize Excel for basic data analysis tasks such as sorting, filtering, and summarizing data.Apply advanced Excel functions like VLOOKUP, HLOOKUP, INDEX-MATCH, SUMIF/SUMIFS, AVERAGEIF/AVERAGEIFS, and pivot tables to derive insights from complex datasets.SQL Querying:Write SQL queries to extract relevant data from relational databases for analysis.Perform operations such as SELECT, WHERE, FROM, ORDER BY, GROUP BY, Aggregate functions like COUNT(), SUM(), AVG(), MAX(), and MIN() statements with JOINs to combine data from multiple tables.Reporting:Create visualizations using Excel charts to present findings clearly.Prepare reports summarizing key insights and recommendations based on data analysis.Collaboration:Work closely with senior analysts and other team members to understand business requirements and deliver actionable insights.

Patna, Bihar, India

As a Junior Data Analyst, i was responsible for developing automated reports using Excel that improved reporting accuracy by 30%. Also, i utilized SQL queries to extract and analyze data from relational databases, enhancing efficiency in data retrieval.I became Proficient in advanced functions, pivot tables, VLOOKUP, and data visualization tools such as charts and graphs. Experienced in automating repetitive tasks using macros.Also in SQL, i became skilled in writing complex queries to extract, manipulate, and analyze large datasets from relational databases. Familiar with database design principles and optimization techniques.

Patna, Bihar, India

As a Data Associate i played a crucial role in supporting data management and analysis within this organization. I have proficiency in Excel, advanced Excel functions, and basic SQL to manipulate and analyze data effectively.My Key Responsibilities in this organisation as a Data Assistant was:Data Entry and Management:Accurately input and maintain data in spreadsheets and databases.Ensure data integrity by performing regular audits and validations.Data Analysis:Utilize advanced Excel functions such as VLOOKUP, HLOOKUP, INDEX-MATCH, pivot tables, and conditional formatting to analyze datasets.Generate reports that summarize findings and present actionable insights to stakeholders.Database Querying:Write basic SQL queries to extract relevant data from relational databases.Assist in the development of database queries for reporting purposes.Collaboration:Work closely with team members to understand data requirements and provide support for various projects. Communicate findings clearly through visualizations or presentations using Excel charts or other tools.Documentation:Maintain documentation of processes, procedures, and methodologies used in data handling.Create user guides for team members on how to utilize Excel tools effectively.

Patna, Bihar, India

Analyzed large datasets using Excel to identify trends and patterns that informed strategic planning initiatives.Created interactive dashboards utilizing Excel charts and graphs to visualize data for senior management presentations.Trained team members on advanced Excel techniques, enhancing their data manipulation skills and improving team productivity by 20%.

Kolkata, West Bengal, India

Assisted in developing web applications using PHP and MySQL.Collaborated with senior developers to troubleshoot issues and optimize code.Gained hands-on experience with PHP programming and XAMPP & LAMPP servers.

Data Science Placement Guarantee Course, Data Science

Bachelor Of Technology - Btech, Computer Science And Engineering