Headline

Data Analyst | Sql | Python | Powerbi | Advanced Excel | Numpy | Panda | Data Cleaning Visualization | ETL | Data

About

Hi there! I'm Aniket Kumar. I'm a Data Analyst with 3.5+ years of experience leveraging SQL, Python, Power BI, Tableau, and Excel to transform data into actionable business insights. I specialize in data analysis, dashboard development, reporting automation, and business intelligence, helping organizations make data-driven decisions and improve operational performance. I'm passionate about solving business problems through data and building impactful analytics solutions that drive measurable results. ⚒️ My Analytics Stack SQL — Data extraction, cleaning, joins, subqueries, CTEs, window functions, query optimization, indexing, performance tuning, and data validation. Power BI — Data modeling, DAX, Power Query, KPI dashboards, interactive reports, drill-through analysis, business intelligence, executive reporting, and dashboard optimization. Python — Pandas, NumPy, Matplotlib, data preprocessing, exploratory data analysis (EDA), automation, statistical analysis, and data transformation. Excel — Advanced Excel, Pivot Tables, Power Query, Lookup Functions, conditional formatting, dashboards, reporting automation, and data validation. Tableau — Interactive dashboards, business reporting, visualization, and data storytelling. 📌 Featured Projects • Customer Churn Prediction & Retention Analysis Analyzed 250,000+ customer records using SQL, Python, and Power BI to identify churn trends and high-risk customers. Built interactive dashboards with DAX and Power Query, improving customer retention by 18%, prediction accuracy by 22%, and reducing reporting time by 45%. • Inventory Optimization for E-Commerce Used SQL, Python, and Power BI to analyze inventory data, optimize reorder points, and build KPI dashboards. Reduced stock-outs by 25%, lowered holding costs by 18%, and automated reporting to support faster inventory decisions. 🚀 What Sets Me Apart I combine strong analytical skills with technical expertise to transform data into actionable business insights. I enjoy optimizing SQL queries, building interactive dashboards, automating reporting, and solving business problems through data-driven solutions. I'm currently open to opportunities as a Data Analyst, Business Analyst, BI Analyst, Reporting Analyst, or Power BI Developer and am available for onsite, hybrid, or remote roles. Let's connect and turn data into smarter business decisions! 🚀

Location

Greater Bengaluru Area

AI stack

claude code

gemini

openai

Work experience

Data Analyst at HCLTech, Nov 2022 - Present · 3 yrs 11 mos, Lucknow, - Analyzed business data using SQL, Python, and Excel to identify trends, generate actionable insights, and support data-driven business decisions. - Developed interactive Power BI dashboards with DAX to monitor KPIs, automate reporting, and improve business performance visibility. - Wrote optimized SQL queries using joins, CTEs, and window functions, while cleaning, transforming, and validating data using SQL and Python (Pandas). - Collaborated with cross-functional stakeholders to gather reporting requirements, ensure data accuracy, and deliver automated reports and visualizations that reduced manual effort and improved reporting efficiency.

Data Analyst at OnGraph Technologies Limited, Jul 2021 - Feb 2022 · 8 mos, Noida, - Leveraged SQL, Python, and Excel to analyze complex datasets, identify key business trends, and deliver actionable insights to support strategic decision-making. - Designed and developed Power BI dashboards using DAX and Power Query to track KPIs, visualize performance metrics, and enable data-driven business reporting. - Developed and optimized advanced SQL queries using joins, CTEs, and window functions to extract, transform, and analyze data efficiently from multiple data sources. - Performed data cleaning, transformation, validation, and exploratory data analysis (EDA) using Python (Pandas, NumPy) and SQL to improve data accuracy and reporting reliability. - Partnered with stakeholders to understand business requirements, automate reporting processes, create analytical solutions, and improve operational efficiency through data-driven insights.

Education

B.Tech, Cooking and Other Domestic Skills, Dr. Ambedkar Institute of Technology for Handicapped kanpur

Data analyst, data analyst, Bosscoder Academy