Learn Data Skills
Beta
Ankit Mandal

Ankit Mandal

Analyst

Fluor Corporation | Gurgaon

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Course

Introduction to Python

Insights artist, painting vivid pictures of knowledge with data as the brush.

My Work

Take a look at my latest work.

course

Introduction to Python

github

GitHub - Ankitmandal999/Bank-Loan-Analysis: This bank loan report provides a comprehensive overview of loan applications, funded amounts, and received payments, with key metrics like interest rates and debt-to-income ratio. It analyzes trends across months, states, terms, employment lengths, loan purposes, and homeownership, offering valuable insights for financial assessments.

SQLSpreadsheetsPower BI
github

GitHub - Ankitmandal999/Customer-Segmentation-RFM-Analysis: This Power BI project delivers a dashboard with customer demographics, segmentation, KPIs, and drill-through features. It includes RFM analysis to classify customers by buying behavior, providing actionable insights to support strategic decisions.

SQLSpreadsheetsPower BI
github

GitHub - Ankitmandal999/Uber-Analysis: Uber Trip Analysis Project Analyze Uber trip data using Power BI to gain insights into booking trends, revenue, and trip efficiency. The project includes dynamic dashboards for overview, time-based analysis, and detailed insights, helping stakeholders make data-driven decisions to optimize operations and improve customer satisfaction.

SQLSpreadsheetsPower BI
course

Introduction to Python

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Data Camp Data Analyst in Power BI

Google Foundations: Data, Data, Everywhere

Vardhan Consulting Engineers Planning Engineering Solutions for Municipal Solid Wastes of Large Cities

Accenture Consultant Program

Cognitive Class SQL and Relational Databases 101

edX Analyzing Data with Excel

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Fluor Corporation | Jul 2022 - Present

Analyst

• Spearheaded the development, dashboarding and reporting of cost benchmarking tools for EPC projects, expanded the data set from 70 to 450+ projects, optimizing data-driven decision making and improving the success of project bidding by 25%. • Achieved an improvement of 60% in data processing, analysis, and quality for multibillion dollar projects by automating manual tasks, reducing data request turnaround time from 75 hours to under 30 hours, and improving decision-making and operational efficiency. • Developed and deployed an Advanced Excel and Power BI-based Schedule Benchmarking Tool, featuring automated schedule analysis and reporting, enhancing the efficiency of schedule development by 80% and allowing comprehensive project duration analysis and strategic planning. • Managed cross-regional projects, coordinated with global teams, delivered 15+ tool demos to senior leaders (boosting adoption by 40%), and mentored 5+ interns, improving team output and reporting accuracy by 30%.
Show More

Yehlo Software Solutions | Jul 2021 - Jun 2022

Graphic Designer

• Creating 6+ graphic design deliverables weekly using Adobe Illustrator and Adobe Photoshop. • Developed new designs that increased overall reach by 300% and enhanced customer satisfaction to 95%.

NSS NSUT CELL | Apr 2021 - Jan 2022

Graphic Design Head

• Directed a team of 5 highly creative designers in Photoshop and Illustrator and increased Twitter following by 200%, Facebook by 500%+ and Instagram by 500%. • Worked in 2 adopted villages and 20+ schools to serving the cause of society through survey and awareness. • Trained 20 volunteers on how to apply Voter IDs and achieved a target of applying 300+ IDs of villagers

Vardhan Consulting Engineers | Jul 2021 - Aug 2021

Engineering Intern

• Analyzed and Conceptualize engineering solutions for MSW of large cities in India (MSW collection < 500TDP) • Compiled a project report including the MSM Management, Challenges and recommendations.

Kyrion Technologies Pvt. Ltd. | May 2021 - Jul 2021

Summer Intern

• Compiled a project report on Regenerative Braking System using graphs and block diagrams. • Detected energy wastage and recommended alternative solutions to recover 30% of the energy delivered.

Mirage - The Western Dance Crew of NSUT | Jul 2020 - Jul 2021

Vice President

• Led a team of 25+ dancers, performing at various college events across DU with 60+ participants. • Ensured discipline and worked with the team to plan choreography, music and costume. • Participated in 40+ competitions, significant winnings: 2nd at NIIT Neemrana’19, 3rd at IIM Ahmedabad’19

My Education

Take a look at my formal education

Bachelor's degree, Manufacturing EngineeringNetaji Subhas Institute of Technology | 2022
High School Diploma Patrachar Vidyalaya | 2018
High School Diploma Green Valley International Public School | 2015

About Me

Ankit Mandal

Business Analyst with 3 years of experience in Power BI, data modeling, and cost benchmarking. Passionate about turning data into insights and exploring data science to solve real business problems.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free