Pavan Kumar B Email & Phone Number

New Haven, CT, US

Stamford, 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.
• 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.
• 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.
• 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.

Bridgeport, 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.

Hyderabad, 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.

Hyderabad, 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.
• 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.

Hyderabad 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.

Hyderabad 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.

Master'S Degree, Business Analytics

Activities and Societies: Deans List

Master Of Business Administration (Mba), Accounting And Finance

Bachelor Of Commerce (Bcom), Business/Commerce, General

Ipcc, Accounting And Finance