Himanshu is a Data Analyst with 5+ years of experience in data visualization and analytics. He specializes in creating interactive dashboards using tools like Power BI and Tableau, and has a strong background in SQL and database management.
Created customized dashboards for major automotive clients like BMW and Ferrari.
Implemented high availability solutions for mission-critical SQL Server databases.
Increased target market by 20% through data analysis in a manufacturing setting.
Migrated reports from Tableau to Power BI, enhancing reporting capabilities.
Proficient in advanced Excel functions for data processing and reporting.
Successfully created customized dashboards for major automotive clients including BMW and Ferrari.
Increased target market by 20% and contributed to extra monthly sales through data analysis in a manufacturing setting.
Overview: This project involved creating customized reporting and dashboard solutions for large automotive clients. Responsibilities: Developed customized Dashboards for clients such as BMW and Ferrari. Communicated with the Database team to optimize performance. Involved in requirement gathering and client communication during data collection. Assisted in migrating reports from Tableau to Power BI. Documented processes for new employee onboarding.
Key outcomes:
Created customized dashboards for major automotive clients.
Facilitated the migration of reports between visualization tools.
Overview: This project focused on providing comprehensive Data Management, Cleansing, Visualization, and Analysis services to banking clients. Responsibilities: Recommended operational improvements based on tracking and analysis. Mapped current processes and proposed recommendations for improvement. Generated quarterly and annual reports and interactive Dashboards to provide business insights and manage client budgets. Documented each data analysis process for future reference.
Key outcomes:
Identified and recommended operational improvements.
Delivered quarterly and annual reports and interactive dashboards for business insights and budget management.
Overview: This project provided intuitive and insightful information to management to understand current performance and assist in crafting future strategies for a manufacturing plant. Responsibilities: Analyzed online statistics and identified new markets for hiring, increasing the target market by 20%. Analyzed a consumer panel of 2,500 employees, defined by A/B testing, which resulted in extra monthly sales. Imported data from MongoDB to create Tableau Dashboards. Generated reports using Microsoft Excel and Tableau to highlight behavioral patterns and employee quality.
Key outcomes:
Increased target market by 20% through online statistics analysis.
Contributed to extra monthly sales by analyzing consumer panel data.
Overview: This project focused on processing raw data and implementing high availability solutions for an investment bank. Responsibilities: Processed raw data using advanced Excel functions and MS SQL. Implemented high availability solutions for mission-critical SQL Server databases using clustering and mirroring. Created, modified, and refreshed pivot tables and charts using various data sources. Performed requirement gathering and analysis, preparing specification documents for the application.
Key outcomes:
Implemented high availability solutions for mission-critical SQL Server databases.
Developed and managed pivot tables and charts for data analysis.
Himanshu
Power BI Developer