Ajeet Pal

Experience

• 

  Diverse Lynx

  Feb 2021 - Apr 2024

  Data Analyst

  • Collected and analyze large sets of structured and unstructured data from various sources using SQL queries including internal databases, market research, customer surveys, and more.• Clean and transformed raw data into useful formats for analysis, utilizing tools like SQL, Python, and Excel.• Created and maintained HR databases and data warehouses.• Supported the development of BI solutions to enhance data accessibility and decision-making processes.• Conducted ad-hoc analyses and provided insights to support various HR initiatives and automated report generation processes to improve efficiency.• Used Excel's advanced functions like VLOOKUP, LOOKUP, Pivots charts and pivot tables to analyze data and statistical plots in Python to enhance analysis and storytelling. • Collaborated with cross-functional finance, accounting teams to understand business requirements and provide data-driven recommendations.• Responsible for creating basic schema model to built relationship between different entities of a database in Power BI/Tableau.• Developed KPI, metrics such as hiring trends, employee performance, and retention rates. • Developed and maintain reports, dashboards, and visualizations to facilitate data-driven decision making.• Designed and maintained interactive Tableau dashboards to provide real-time insights into key employee turnover, recruitment effectiveness, employee engagement.• Developed risk mitigation strategies based on data insights.• Conducted regular audits of the data to ensure compliance and identify risks.• Utilized advanced Excel functions, including VLOOKUP, pivot tables, and macros, to analyze and visualize data.• Built models and forecasts to support budgeting and financial planning. • Automated repetitive tasks using Excel macros and SQL scripts. Show less

• 

  Isekai Tech

  Apr 2024 - now

  Data Analyst

  • Utilized SQL server, SQL queries to extract relevant data from databases efficiently. Cleaned and preprocess raw data using Excel or spreadsheet and VBA software to ensure accuracy and consistency.• Developed business architecture using requirements such as scope, processes, alternatives, and risks. • Conducted integrity checks on processed data to ensure accuracy.• Extracted large datasets from multiple databases Snowflake, SQL using simple and complex SQL and NoSQL tools.• Developed and executed complex SQL queries to extract and manipulate data from relational databases.• Developed key performance indicators (KPIs) and dashboards to monitor supply chain performance metrics such as inventory levels and utilizations, Fill rates, lead times, and supply chain costs.• Explored various metrics and methods for analysis and organized raw data to comply with specifications.• Imported data from various resources like different on-premise data, Relational databased or data warehouse.• Maintained existing Python scripts and develop new scripts for automation of repetitive tasks and workflows.• Performed exploratory data analysis using Tableau, Excel, or Python to identify trends, patterns, and outliers. • Created interactive dashboards and visualizations in Tableau to present insights to stakeholders.• Performed scripting in VBA to extract insights from large datasets through techniques such as data mining, pattern recognition, and predictive modeling. Generating reports summarizing the analysis results.• Extract, transform, and load (ETL) data from multiple sources into a centralized database for analysis.• Prepared comprehensive reports and presentations summarizing key findings, insights, and recommendations. Customized reports to meet the needs of different stakeholders, highlighting relevant metrics and KPIs. Show less