Pavan Kumar B Email and Phone Number
At Corporate Image Dining Services (CIDS), I leverage my data modeling and reporting skills to enhance the dining experience for corporate clients. Using Python, SQL, Power BI, and Tableau, I analyze and visualize data from multiple sources, such as customer feedback, inventory, sales, and costs, and provide insights and recommendations to improve customer satisfaction, efficiency, and profitability. I also collaborate with cross-functional teams to implement data-driven solutions and monitor their impact.I hold a Master of Science degree in Business Analytics from the University of Bridgeport, where I honed my analytical prowess and business acumen. With a previous MBA in Accounting and Finance and over six years of experience in market research, data analysis, and project management at top companies like Deloitte and Global Data Plc, I have a solid foundation in data management, financial analysis, and stakeholder communication. I am passionate about using the power of data to foster data-driven decision-making and drive business performance.
Corporate Image Dining Services
View- Website:
- cidining.com
- Employees:
- 14
-
Business AnalystCorporate Image Dining ServicesNew Haven, Ct, Us -
Data EngineerCorporate Image Dining Services Sep 2023 - PresentStamford, Connecticut, United States• Gathered data requirements from business/user groups, analyzing, designing, developing, and implementing solutions to meet client requirements, with a particular focus on migrating data from local databases to Amazon Cloud Services.• Employed Power BI to create dashboards assessing the performance of 18 locations within the corporate dining services company. Identified top-performing and underperforming locations to target for improvements.• Collaborated effectively with cross-functional teams and conducted rigorous data quality audits. Identified and rectified anomalies in forecast data, resulting in enhanced data reliability and reduced errors in the transition to Amazon Cloud Services.• Automated the generation of weekly and monthly regional sales reports, streamlining the monitoring of key performance metrics. This automation effort resulted in significant time savings, reducing manual report generation by an average of 10 hours per week.• Conducted data quality audits and rectified anomalies, ensuring reliable data in the transition to AWS.• Actively engaged in process automation initiatives, integrating various systems and streamlining data uploads into an SQL database. In the current role, this involved transitioning from local databases to Amazon Cloud Services, utilizing AWS services like Kinesis Data Streams, Firehose, and Athena for data querying and analysis. -
Data EngineerFoot Traffic Stats Jan 2023 - Apr 2023Bridgeport, Connecticut, United States• Collaborated with Foot traffic Stats, a startup, to analyze foot traffic in a university using their sensing device.• Utilized Power BI and data extraction from the cloud to gather and process data.• Conducted in-depth analysis of foot traffic patterns during rush hours and provided insights to different university departments.• Applied SQL and R to analyze extensive datasets, leading to the discovery of critical insights that enabled a library café to optimize staffing based on foot traffic, resulting in a remarkable 20% increase in sales.
-
AnalystDeloitte Dec 2021 - Apr 2022Hyderabad, Telangana, India• Analyzed and derived insights from project management data using Python and SQL, leveraging tools like Power BI to transform data and visualize key findings.• Utilized Python and SQL for in-depth analysis of audit data and independence reports, with data transformation and visualization carried out using Power BI, resulting in actionable insights.• Collaborated closely with clients and onshore project managers, providing project oversight, coordination, and stakeholder management support.• Leveraged Tableau and Power BI to design and implement impactful dashboards and data visualizations, enabling data-driven decision-making and enhancing business performance. -
AnalystGlobaldata Plc Apr 2021 - Nov 2021Hyderabad, Telangana, India• Led and motivated a team of 8 members, overseeing the extraction of data from websites using web scrapers, cleaning and transforming data with Power Query Editor in Power BI, and ensuring seamless data storage in DBMS and S3.• Successfully managed the "Disruptors" project, achieving a remarkable 66% increase in the database size from 300,000 to 500,000 companies within just one month.• Implemented various partition services in S3 using Firehose and data streaming services, optimizing data storage and retrieval processes.• Created unique and impactful dashboards that significantly contributed to a 5% increase in sales revenue for the sales team.• Collaborated with cross-functional teams to understand and fulfill data needs, ensuring customer satisfaction for data-related requests.• Developed strategies to automate and streamline data processes, improving data quality and accuracy. Provided training to colleagues on automation tools, reducing manual data entry. -
Associate AnalystGlobaldata Plc Aug 2019 - Mar 2021Hyderabad Area, India• Extracted, transformed, and loaded data from web sources into the SQL Server and S3 using various tools and techniques, ensuring data integrity.• Transferred data objects and queries from various sources to the SQL Server for further analysis and reporting.• Created different KPI dashboards in report studio using a combination of the list, crosstab, graph and map reports.• Successfully automated the manual data updating process for company information in our database management system, resulting in a significant time savings of 20 hours per week for the team.• Analyzing qualitative data and creating thematic reports for disruptive tech companies based on client requests.• Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and VLOOKUP. Extracted, interpreted, and analyzed data to identify key metrics and transform raw data into meaningful, actionable information• Knowledge of statistics and experience in using statistical packages for analyzing datasets.• Proficient in advanced SQL queries to retrieve and manipulate data from databases, ensuring efficient data retrieval and analysis for informed decision-making. -
Financial AnalystKarvy Stock Broking Feb 2017 - Jul 2019Hyderabad Area, India• Performed fundamental and technical research on securities, including analyzing financial statements, corporate filings, and earnings reports.• Conducted financial analysis, forecasting, and modeling for trading.• Synthesized and analyzed financial statements and forecasting, while considering the company’s goals and predicted, analyzed, and managed risks to its operations and financial stability. discrepancies.• Minimized clients loss by 80% through various techniques such as derivative futures & option writing.• Coordinated with brokers and underwriters on executive financial plans including the purchase of insurance, equities, bonds, mutual funds and exchange traded funds.• Created stock reports in Power BI and Tableau providing leadership with actionable insights, contributing to a 55% improvement in data-driven decision-making accuracy.• Diagnosed equity price charts to determine trends, support and resistance.
Pavan Kumar B Education Details
-
Business Analytics -
Accounting And Finance -
Business/Commerce, General -
Accounting And Finance
Frequently Asked Questions about Pavan Kumar B
What company does Pavan Kumar B work for?
Pavan Kumar B works for Corporate Image Dining Services
What is Pavan Kumar B's role at the current company?
Pavan Kumar B's current role is Business Analyst.
What schools did Pavan Kumar B attend?
Pavan Kumar B attended University Of Bridgeport, Gandhi Institute Of Technology & Management (Gitam) University, Visakhapatnam, Sir C.r.r. College, The Institute Of Chartered Accountants Of India.
Not the Pavan Kumar B you were looking for?
-
Pavan Kumar B
Alpharetta, Ga -
-
Pavan Kumar B
Hicksville, Ny -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial