Top Talent like Gunjan are on Pangea

Pangea, a YC company, connects companies with fractional talent. Fractional hiring allows companies to move faster and work with more specialized talent, while giving talent more flexibility and independence. If you are talent open to fractional work, apply here. If you’re a company looking for high-quality fractional talent, learn more here.

Gunjan Singh

Operations Manager •
PostgreSQL
Database Queries
Visual Basic
Qualitative Analysis
Business Analytics
Competitive Analysis
Data Cleansing
MySQL
Forecasting
Data Science
Analytics
Data Analysis
Database Management
Data Management
Data Formatting
Analytical Thinking
PowerBI
Google Sheets
Microsoft Excel
Available for hire fromNegotiable
Contracts
Data Analyst | Excel,SQL, PowerBI,Data Visualization | Transforming Data into Strategic Insights
As a passionate Data Analyst, I excel in turning complex data into actionable insights that drive strategic decisions. With hands-on experience in SQL, Excel, and data visualization tools like Power BI, I thrive on solving intricate data challenges and uncovering patterns that inform business strategies. My expertise spans data cleaning, statistical analysis, and predictive modeling, and Im adept at using tools to streamline workflows and deliver precise, data-driven solutions Beyond my professional work, I am committed to continuous growth and staying at the forefront of data analytics trends. I actively pursue learning opportunities and certifications to enhance my skills and stay updated with emerging technologies and methodologies. Outside of data analysis, I enjoy exploring data-driven projects, participating in hackathons, and contributing to open-source data initiatives. Im also passionate about mentoring aspiring analysts and sharing knowledge with the community. Looking ahead, my goal is to further develop my expertise in advanced analytics, and to leverage these skills to drive impactful business solutions and innovative strategies

Projects

Data Visualization and Analysis Using PivotTables in Excel

Developed an advanced data analysis project utilizing PivotTables and visualizations in Excel, emphasizing effective data summarization and presentation techniques. Key features of the project include: •PivotTable Creation: Constructed a PivotTable from the Orders Table, strategically placed on a new worksheet named "Shipping Cost." This facilitated organized data analysis and accessibility. •Data Summarization: Summarized total freight costs by grouping data based on the "SHIP VIA" field, employing the SUM function to provide a comprehensive overview of shipping expenses. •Advanced Calculation: Inserted the "FREIGHT" field a second time in the PivotTable, modifying the calculation to display the average freight costs for each shipping method, enhancing analytical depth. •Data Visualization: Created a bar chart based on the PivotTable to visually represent total freight costs by country, improving the interpretability of shipping data. •Chart Customization: Enhanced the chart's visual appeal by removing the chart title, legend, and field buttons, and resized and repositioned it for optimal layout. •Interactive Filtering: Incorporated a timeline filter set to years and a slicer for "SHIP VIA," allowing for dynamic data filtering and improving user interactivity in data exploration.See More

Sales & Profit Analysis Dashbord || PowerBI

• Developed a dynamic Sales & Profit Analysis Dashboard in Power BI with slicers for city/country-based analysis and drill-down functionality. • Created visuals including cards, charts (donut, pie, line, stacked bar), and a matrix to represent sales, profit, and quantity sold across various dimensions. • Enhanced data-driven decision-making by providing clear insights into sales trends, regional performance, and product category profitability.See More

SQL Database Management: Facility and Membership Analytics

• Comprehensive Data Analysis: Executed advanced SQL queries, employing all types of joins (INNER, LEFT, RIGHT, and FULL) to extract and analyze data from the facilities and members tables, focusing on facility costs, booking metrics, and member demographics. • Actionable Insights: Analyzed facilities with varying fee structures and usage patterns, highlighting those with lower-than-average costs and specific naming conventions, thereby facilitating informed decision-making. • Membership Trend Reporting: Created comprehensive reports on member sign-ups, produced unique listings of member demographics, and analyzed booking patterns to deliver strategic insights for optimizing facility management.See More

Work History

I

Junior Researcher

I-PAC (Indian Political Action Committee)Mar 2024 - Jun 2024 • 4 mosLed a team of 6 members in the Operations Management department to coordinate Lok Sabha 2024 campaigns across West Bengal, ensuring campaign smoothness and efficiency. Managed logistics for 300 vehicles, including 150 for transporting leaders and 150 LED vans, while addressing vehicle and driver-related issues throughout the campaign. Maintained detailed records of operational issues, routines, and cash transactions using Excel, and prepared daily reports to monitor campaign efficiency and status. Oversaw a campaign budget exceeding 1 crore contributing to a 69% (29 out of 42) seat occupancy rate, significantly surpassing the initial projection of 50%.

Education

I

IQ City United World School of Business- Kolkata

Bachelor of Business Administration - BBA, Business Administration and Management, General2021 - 2024

How Pangea Works

Effortlessly discover top talent

We’ve distilled the candidate search from endless hours down to just a few minutes. Using Pangea’s AI-powered search tools, you can find top fractional talent able to take on your next project. Our system looks at your company’s niche and your needs to find the perfect match faster than any traditional hiring platform.

Start working with talent today

The top talent on Pangea is ready to get started with you right now. You can message or hire a candidate right from their profile page and start assigning work as soon as they respond. And the best part? Pangea’s fractional contract structure lets you start small and ramp up as your needs change, keeping your costs manageable and your team’s capabliities flexible.

Track work and invoices in one place

Assign tasks, track progress, and complete invoices all on Pangea. We’ve combined every part of the hiring process into one platform to eliminate the miscommunication that’s unavoidable on other freelance platforms. We even send out 1099s to your contractors at the end of the year!

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.
Available Now
Book a Call
Data Analyst | Excel,SQL, PowerBI,Data Visualization | Transforming Data into Strategic Insights
As a passionate Data Analyst, I excel in turning complex data into actionable insights that drive strategic decisions. With hands-on experience in SQL, Excel, and data visualization tools like Power BI, I thrive on solving intricate data challenges and uncovering patterns that inform business strategies. My expertise spans data cleaning, statistical analysis, and predictive modeling, and Im adept at using tools to streamline workflows and deliver precise, data-driven solutions Beyond my professional work, I am committed to continuous growth and staying at the forefront of data analytics trends. I actively pursue learning opportunities and certifications to enhance my skills and stay updated with emerging technologies and methodologies. Outside of data analysis, I enjoy exploring data-driven projects, participating in hackathons, and contributing to open-source data initiatives. Im also passionate about mentoring aspiring analysts and sharing knowledge with the community. Looking ahead, my goal is to further develop my expertise in advanced analytics, and to leverage these skills to drive impactful business solutions and innovative strategies

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.
Available Now
Book a Call

Top Talent like Gunjan are on Pangea

Pangea, a YC company, connects companies with fractional talent. Fractional hiring allows companies to move faster and work with more specialized talent, while giving talent more flexibility and independence. If you are talent open to fractional work, apply here. If you’re a company looking for high-quality fractional talent, learn more here.

Gunjan Singh

Operations Manager •
PostgreSQL
Database Queries
Visual Basic
Qualitative Analysis
Business Analytics
Competitive Analysis
Data Cleansing
MySQL
Forecasting
Data Science
Analytics
Data Analysis
Database Management
Data Management
Data Formatting
Analytical Thinking
PowerBI
Google Sheets
Microsoft Excel
Available for hire fromNegotiable
Contracts

Projects

Data Visualization and Analysis Using PivotTables in Excel

Developed an advanced data analysis project utilizing PivotTables and visualizations in Excel, emphasizing effective data summarization and presentation techniques. Key features of the project include: •PivotTable Creation: Constructed a PivotTable from the Orders Table, strategically placed on a new worksheet named "Shipping Cost." This facilitated organized data analysis and accessibility. •Data Summarization: Summarized total freight costs by grouping data based on the "SHIP VIA" field, employing the SUM function to provide a comprehensive overview of shipping expenses. •Advanced Calculation: Inserted the "FREIGHT" field a second time in the PivotTable, modifying the calculation to display the average freight costs for each shipping method, enhancing analytical depth. •Data Visualization: Created a bar chart based on the PivotTable to visually represent total freight costs by country, improving the interpretability of shipping data. •Chart Customization: Enhanced the chart's visual appeal by removing the chart title, legend, and field buttons, and resized and repositioned it for optimal layout. •Interactive Filtering: Incorporated a timeline filter set to years and a slicer for "SHIP VIA," allowing for dynamic data filtering and improving user interactivity in data exploration.

Sales & Profit Analysis Dashbord || PowerBI

• Developed a dynamic Sales & Profit Analysis Dashboard in Power BI with slicers for city/country-based analysis and drill-down functionality. • Created visuals including cards, charts (donut, pie, line, stacked bar), and a matrix to represent sales, profit, and quantity sold across various dimensions. • Enhanced data-driven decision-making by providing clear insights into sales trends, regional performance, and product category profitability.

SQL Database Management: Facility and Membership Analytics

• Comprehensive Data Analysis: Executed advanced SQL queries, employing all types of joins (INNER, LEFT, RIGHT, and FULL) to extract and analyze data from the facilities and members tables, focusing on facility costs, booking metrics, and member demographics. • Actionable Insights: Analyzed facilities with varying fee structures and usage patterns, highlighting those with lower-than-average costs and specific naming conventions, thereby facilitating informed decision-making. • Membership Trend Reporting: Created comprehensive reports on member sign-ups, produced unique listings of member demographics, and analyzed booking patterns to deliver strategic insights for optimizing facility management.

Work History

I

Junior Researcher

I-PAC (Indian Political Action Committee)Mar 2024 - Jun 2024 • 4 mosLed a team of 6 members in the Operations Management department to coordinate Lok Sabha 2024 campaigns across West Bengal, ensuring campaign smoothness and efficiency. Managed logistics for 300 vehicles, including 150 for transporting leaders and 150 LED vans, while addressing vehicle and driver-related issues throughout the campaign. Maintained detailed records of operational issues, routines, and cash transactions using Excel, and prepared daily reports to monitor campaign efficiency and status. Oversaw a campaign budget exceeding 1 crore contributing to a 69% (29 out of 42) seat occupancy rate, significantly surpassing the initial projection of 50%.

Education

I

IQ City United World School of Business- Kolkata

Bachelor of Business Administration - BBA, Business Administration and Management, General2021 - 2024

How Pangea Works

Effortlessly discover top talent

We’ve distilled the candidate search from endless hours down to just a few minutes. Using Pangea’s AI-powered search tools, you can find top fractional talent able to take on your next project. Our system looks at your company’s niche and your needs to find the perfect match faster than any traditional hiring platform.

Start working with talent today

The top talent on Pangea is ready to get started with you right now. You can message or hire a candidate right from their profile page and start assigning work as soon as they respond. And the best part? Pangea’s fractional contract structure lets you start small and ramp up as your needs change, keeping your costs manageable and your team’s capabliities flexible.

Track work and invoices in one place

Assign tasks, track progress, and complete invoices all on Pangea. We’ve combined every part of the hiring process into one platform to eliminate the miscommunication that’s unavoidable on other freelance platforms. We even send out 1099s to your contractors at the end of the year!

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.
Available Now
Book a Call
Pangea empowers fractional work across the world for marketing and design roles.