Headline

Data Analyst | SQL | Power BI | Python | Excel | Data Visualization | Business Analytics

About

I’m a Data Analyst with a background in finance and business, focused on using data to uncover insights, identify patterns, and support better business decisions. I work with: • SQL — data extraction, joins, CTEs, subqueries, window functions and analytical queries • Power BI — interactive dashboards, DAX, KPI development and data visualization • Python — Pandas, NumPy, data cleaning, exploratory data analysis and feature engineering • Excel — data analysis, reporting and business analysis Recently, I completed an end-to-end Customer Shopping Behaviour Analysis project using Python, SQL and Power BI. I analyzed 3,900 transactions to understand customer segments, product performance, promotional behaviour and repeat-purchase patterns, and translated the findings into business recommendations. My background in finance and business gives me an additional perspective when analyzing data — I’m interested not only in finding what happened, but also in understanding why it happened and what action a business can take. Currently looking for opportunities as a: Data Analyst | Business Analyst | BI Analyst | Junior Product/Data Analyst I’m particularly interested in roles where I can work with SQL, BI tools and business data while continuing to grow toward product and advanced analytics.

Location

Gurugram

AI stack

claude code

claude

gemini

ChatGPT

Work experience

Self Employed at E-commerce Website, Sep 2023 - Aug 2024 · 11 mo, Gurugram, • Built and managed an e-commerce business, handling 20–30 orders and customers daily across product research, procurement, logistics, customer support, and order fulfillment. • Analyzed sales and order data using Excel to monitor business performance and support operational decisions, generating approximately ₹70K–₹1L per month in revenue. • Tested 8 products and managed ₹3K–₹6K daily in advertising spend, analyzing campaign performance through Meta Business Suite • Monitored order fulfillment and a 10% RTO rate, identifying operational issues and improving order-management processes

Associate - Portfolio Management (Sales) at Investors Clinic Infratech Pvt. Ltd., Feb 2022 - Jul 2022 · 5 mo, Gurugram, Haryana, India, • Managed 100–200 customer calls daily, qualifying leads, understanding requirements, and follow-ups throughout the sales cycle. • Coordinated 5–8 site visits each weekend, handling customer interactions, negotiations, and follow-ups through to deal closure. • Closed 8 deals in 6 months while consistently meeting assigned monthly sales targets.

Education

Data Science, Data Processing and Data Processing Technology/Technician, Analytixlabs

Digital Marketing Master Course, Digital Marketing, Digital Vidya

Public links

github: https://github.com/yadavlalit6844