Tales of Wealth
Woven with Wisdom

Financial Modeling | DCF Valuation | Risk management
NISM Research Analyst(XV) Certified

VIEW RESUME

G

Growth of Mindset

A

Awareness

G

Gratitude

A

Analysis

N

Nirvana
KNow more aBout me

Here is something about how world see me Although I'm still finding myself....

Education

  • Bachelors of Commerce
    2019-2022 | 71.33%

Experience

  • Chhattisgarh Agricon Samiti
    Jan 2024 - Present

    Data Management Officer
  • Alco Food Private Limited
    Feb 2022 - Oct 2022

    Sales Representative

CORE DOMAIN/ SKILLS

valuation, security MARKET, INVESTMENTS

FINANCE

Financial Reporting: Proficient in preparing and interpreting financial statements, including balance sheets, cash flow statements, and profit & loss statements.
Project Financial Modeling: Skilled in developing comprehensive financial models for projects, assessing balance sheet impacts, profit and loss projections, and managing large financial datasets.
Risk Management: Expertise in analyzing financial health through key ratios such as current ratio, debt-to-equity ratio, and return on equity to inform strategic decision-making.
Valuation and Compliance: Experienced in calculating debt-service coverage ratio (DSCR) and ensuring compliance with lending guidelines for optimizing funding opportunities.

Project Report for Bank Loan (CMA Report)
Created a budgeted CMA report for a Dhaba restaurant operator, including financial performance assessment, projected cash flow, and maximum permissible bank finance (MPBF) calculation.Evaluated key financial ratios and developed projected balance sheets to support financial planning and reduce risks.

VIEW PROJECTS
data analysis, sql, python, power bi

DBMS

Data Retrieval and Manipulation: Proficient in SQL for querying large datasets and advanced Excel functions for data analysis, including Pivot tables, VLOOKUPs, and macros.
Data Visualization: Skilled in using Power BI and Tableau to convert complex financial data into intuitive visualizations that provide actionable insights.
Data Cleaning and Preparation: Expertise in cleaning and preparing data for analysis, ensuring accuracy and reliability of the data used for decision-making.
Analytical Tools: Experienced with data analysis libraries in Python such as pandas, NumPy, and Matplotlib.

PROJECTS

Instagram User Analytics
-Leveraged SQL and Excel to analyze user data, providing insights that boosted engagement by 15%.
-Experienced in querying large datasets (up to 1 million rows) to extract complex insights.
E-commerce Sales Project
-Built an interactive dashboard using Power BI, presenting data in a visually appealing and intuitive manner.
-Utilized advanced Excel functions for data analysis, providing comprehensive insights into business processes.

VIEW PROJECTS
figma, canva, wordpress, webflow

UI UX DESIGNING

Website Development: Proficient in WordPress, Webflow, and Elementor, with experience in designing and managing user-friendly websites.
Graphic Design: Skilled in creating infographics, case studies, newsletters, and social media campaigns using tools like Canva and Figma.
User Experience Design: Focused on enhancing user experience through intuitive design and functionality, ensuring websites and applications are accessible and engaging.
Content Management: Experienced in updating and managing content on websites, including blog posts, articles, newsletters, and case studies.

PROJECTS

Chhattisgarh Agricon Samiti (NGO)
-Enhancing user experience by designing and uploading blog posts, articles, newsletters, and case studies.
-Played a pivotal role in designing a user-friendly e-learning website on the Moodle platform, improving accessibility and engagement.

VIEW PROJECTS

PHILOSOPHY

Exploring the profound questions of existence, ethics, and knowledge, my interest in philosophy drives me to delve into the thoughts of great minds. Through critical thinking and introspection, I seek to understand the human condition, the nature of reality, and the principles that guide our lives.

GAMING

Gaming is a gateway to immersive worlds and captivating narratives. As an avid gamer, I appreciate the artistry, strategy, and innovation that shape the industry. I engage in diverse genres, from virtual reality games like pubg to strategy games like chess, valuing both the entertainment and the cognitive challenges they present.

COSMOLOGY

The vastness of the universe and the mysteries it holds captivate my imagination. My passion for cosmology involves studying the origins, evolution, and fundamental structures of the cosmos. I am fascinated by the scientific endeavors that unveil the secrets of space, time, and the underlying laws of nature.

Certifications

Testimonials

"I have had the pleasure of working closely with Gagan in our office, where he serves as a backend executive. Gagan's dedication and hardworking nature are truly commendable. He possesses a keen interest in exploring new technologies, particularly in the realms of AI tools and website designing.Gagan consistently demonstrates a proactive approach to learning, always eager to explore and delve into new concepts. His enthusiasm for discovering innovative solutions and his ability to grasp new ideas quickly make him an invaluable asset to any team.Furthermore, Gagan's proficiency in AI tools and website designing is impressive. His willingness to continuously expand his knowledge and skills sets him apart in the field. I have no doubt that Gagan's drive and determination will lead him to great success in his career.I highly recommend Gagan for any role where his passion for learning, coupled with his expertise in backend operations and technology, can contribute to achieving remarkable results."
:-Reetika Dewangan (Chhattisgarh Agricon Samiti)
Gagan Chandrakar is a dedicated professional with strong analytical skills and a deep understanding of both spatial and non-spatial data. With a background in commerce and finance, and his recent NISM Research Analyst Certification, he effectively bridges data and decision-making. Gagan is a proactive team player, and I highly recommend him for roles in data analysis, financial research, or development projects.:-Sanjay Kumar Yadav
Sr.Executive MIS & GIS
Chhattisgarh Agricon Samiti (NGO)