This repository showcases multiple data-related projects developed by Harshal Ramesh Mohite, focusing on SQL development, ETL processes, and Power BI reporting.
Each project demonstrates real-world problem-solving through database optimization, report automation, and data visualization.
- Developed an interactive dashboard using Power BI to visualize regional and product-wise sales performance.
- Integrated SQL Server data sources and designed DAX measures for dynamic KPIs.
- Enabled management to track monthly sales growth and top-performing products.
- Analyzed slow-running SQL queries and implemented indexing and query optimization.
- Improved ERP report generation time by 20%.
- Used stored procedures for efficient data retrieval and automation.
- Designed a sample SSIS package to extract, transform, and load sales and inventory data.
- Implemented data cleansing, merging, and conditional transformations.
- Automated the daily process using SQL Server Agent scheduling.
- Customized ERP reports using SQL Server and Visual FoxPro.
- Collaborated with clients to identify reporting needs and built dynamic reports for finance and production modules.
| Folder / File | Description |
|---|---|
/SQL Scripts/ |
SQL queries, stored procedures, and optimization examples |
/ETL Packages/ |
SSIS package files and ETL transformation logic |
/Reports/ |
Power BI .pbix dashboards and Crystal Reports files |
/Documentation/ |
Project explanations, process notes, and PDFs |
- SQL Server, MySQL
- SSIS (SQL Server Integration Services)
- Power BI, Crystal Reports
- Visual FoxPro, Excel, T-SQL
- Query performance tuning and optimization
- ETL process design and automation
- Report creation using Power BI and Crystal Reports
- ERP data management and customization
Harshal Ramesh Mohite
📧 Email: mohiteharsh7@gmail.com
💼 LinkedIn: [www.linkedin.com/in/harshal-mohite-5b63a1157]
- Clone or download this repository
- Review SQL scripts for database logic and performance examples
- Explore ETL folder for SSIS practice packages
- Open
.pbixfiles in Power BI Desktop to view dashboards - Read documentation for project notes and learning references
This repository serves as a personal portfolio to showcase SQL, ETL, and Power BI expertise, combining practical experience with self-driven learning and continuous skill improvement.