Nitesh Prakash

Client – Hyundai.

• Designed and developed interactive dashboards for sales, marketing, and service teams by integrating SQL-based data sources, providing actionable insights.
• Developed visualizations using Tableau features such as parameters, calculated fields, dynamic sorting, and filters to enable parameter-driven analysis.
• Implemented advanced functions and user-defined parameters to enable customized and dynamic data exploration.
• Collaborated with department heads to identify key performance metrics, ensuring dashboards aligned with business objectives.
• Presented performance dashboards to sales, marketing, and service leaders, highlighting trends and actionable insights.
• Tech Stack: SQL, Excel, Tableau.

Client – Dr. Reddy's Labs.

• Contributed to Dr. Reddy’s Labs project involves developing and deploying machine learning models to analyze complex datasets and uncover valuable insights.
• Conducted extensive data preprocessing and feature engineering, including handling missing values, normalization, encoding, and feature selection, to improve model accuracy and robustness.
• Evaluated and optimized multiple models using techniques such as hyperparameter tuning, cross-validation, and performance metrics to ensure optimal results.
• Utilized advanced algorithms, including regression, classification, and clustering, tailored to project-specific requirements.
• Collaborated with cross-functional teams to align models with business objectives, ensuring actionable insights were effectively delivered.
• Integrated visual analytics tools (Tableau) for stakeholders to easily interpret predictions and insights derived from models.
• Contributed to a significant reduction in data analysis time and improved decision-making accuracy across key business processes.
• Tech Stack: SQL, Excel, Tableau, Python, Machine Learning.

Client – Galaxy Data (SAP).

• Designed and implemented multiple Alteryx workflows to automate repetitive tasks previously performed in Excel, resulting in significant efficiency gains.
• Integrated multiple tables to create a comprehensive dataset for analysis.
• Automated processes for SAP Data Objects, including GL Open Items, WP, SD Pricing, Customer Master, and Vendor Master, reducing manual effort and increasing accuracy.
• WIP and SD pricing: We designed an automated process for work in progress (WIP) calculation and sales and distribution (SD) pricing, ensuring accuracy and consistency in SAP data handling.
• Developed robust workflows to manage complex data integration and cleansing, ensuring data consistency for SAP migration.
• By taking care of boring, repetitive tasks for business teams, they can concentrate on more important tasks. This helps them get projects done faster, and make fewer mistakes.
• Tech Stack: SQL, Excel, Alteryx.

Client – Assam government.

• Created a detailed performance tracking tool (KPI dashboard) for a major government office in Assam, using Power BI, specifically designed to fit their unique work and data needs. And I did it all on my own.
• Simplified monthly reports by adding dynamic calculations, making the process faster, and reducing the need for manual updates.
• I led the way in using business intelligence technology, which cut down on manual work and made things run more smoothly overall. Plus, I set up guidelines for Tableau dashboards to ensure they look good and are easy to understand by choosing the right charts, colors, and layouts.
• Tech Stack: SQL, Excel, Power BI.

• Client: Citi Bank
• Leveraged analytical and technical expertise to perform data preprocessing and data mining using Alteryx and Python, ensuring clean and accurate datasets for analysis.
• Developed interactive and insightful Tableau visualizations to present key findings and trends, supporting strategic decision-making.
• Implemented web scraping techniques to extract data from Tableau reports, integrating it with Python for advanced data analysis and automation.
• Tech Stack: Python, Tableau, Alteryx, Excel.

Client: Korea Hedging Client - USA

• Demonstrate knowledge and execution of application programming.
• Interface development and testing.
• Worked with business users and SMEs to design.
• I worked on the testing and debugging of the code.
• Tech Stack: Python

Payment Behavior Analysis Client - Bypl.

• Worked in data preprocessing and model building using Excel, R, and.
• Python.
• The final goal of this project was to predict the next bill payment date.
• Which consumer will be submitting the electricity bill?
• Tech Stack: Python, R, Alteryx, Tableau, Django, and Excel.

Payment Behavior Analysis Client - BSES.

• Engaged in data preprocessing and model building using Excel, R, and.
• Python
• The final goal of this project was to predict the next bill payment date.
• Which consumer will be submitting the electricity bill?
• Tech Stack: Python, R, Alteryx, Tableau, Django, and Excel.

Solar Modeling Analysis Client - ACME.

• Worked in data preprocessing and model building using Excel, R, and.
• Python.
• The final goal of this project was to predict the solar plant getting more.
• Efficiency and the one getting low efficiency of consumption.
• Tech Stack: Python, R, Alteryx, Tableau, Django, and Excel.