Rohit Bhola Email & Phone Number

Noida, Uttar Pradesh, India

1. Developed and maintained complex SQL queries to extract, analyze, and report data from various databases, resulting in [specific achievement, e.g., a 15% increase in reporting efficiency].2. Utilized Advanced Excel functions, including VLOOKUP, INDEX-MATCH, PivotTables, and complex formulas, to analyze and visualize large datasets for business stakeholders.3. Designed and implemented interactive dashboards in Power BI, leveraging Advanced DAX and Power Query to create custom metrics and KPIs that provided actionable insights for [specific department or project].4. Automated data processing tasks using Excel VBA, streamlining repetitive workflows and reducing manual effort by [X] hours per week, improving overall productivity.5. Managed MIS reporting systems, creating and maintaining Excel-based reports that tracked key performance indicators (KPIs), sales performance, and operational metrics across the organization.6. Created custom Excel VBA macros to automate data cleansing, data entry, and report generation processes, ensuring accuracy and consistency across multiple datasets.7. Collaborated with cross-functional teams to identify data needs, streamline reporting processes, and ensure data accuracy and integrity.

Gurugram, Haryana, India

1. Assisted in the development of SQL scripts and queries for data extraction and analysis.2. Performed data cleaning, validation, and analysis using Advanced Excel, ensuring high-quality data for reporting purposes.3. Supported the creation of Power BI reports and dashboards, gaining proficiency in DAX and Power Query to manipulate and visualize data effectively.4. Developed Excel VBA scripts to automate repetitive data entry and analysis tasks, improving efficiency and reducing errors.5. Created and maintained MIS reports, utilizing Excel and VBA to monitor and track business metrics, operational performance, and other key data points.6. Conducted ad-hoc analyses and provided data-driven insights to support business decision-making.7. Collaborated with team members to optimize data workflows, improving overall efficiency and accuracy.

Gurugram, Haryana, India

1. Data Analysis: Expertise in analyzing agricultural data, including crop yields, soil conditions, weather patterns, and market trends to support decision-making and optimize farming practices.2. MIS Reporting: Proficient in creating and maintaining MIS reports that track key performance indicators such as crop productivity, resource usage, and financial metrics.3. Excel & Advanced Excel: Advanced skills in Excel, including data manipulation, complex formulas, PivotTables, and advanced functions for detailed analysis and reporting.4. Excel VBA: Experienced in using Excel VBA to automate data collection, processing, and reporting tasks, improving efficiency and accuracy in data management.

Noida, Uttar Pradesh, India

1. MIS Reporting: Assisted in the preparation and maintenance of MIS reports for tracking property performance, lease agreements, and client interactions. Improved the efficiency of report generation by automating key tasks with Excel VBA.2. Excel VBA Development: Created custom VBA scripts to automate data processing tasks, such as cleaning and consolidating data from various sources, enhancing the accuracy and timeliness of reports.3. Market Research & Analysis: Conducted research on property market trends and client demographics, using Advanced Excel to perform analysis that informed marketing and sales strategies.4. Data Support: Provided data support to the sales team by generating reports and insights on property performance and market conditions, helping to drive strategic decision-making.5. Process Optimization: Contributed to the optimization of data workflows by implementing automated solutions, reducing manual data entry errors and improving overall reporting accuracy.

New Delhi, Delhi, India

1. MIS Reporting: Proficient in creating and managing MIS reports related to income tax data, including tax calculations, compliance reporting, and financial summaries. Experienced in generating accurate and timely reports to support tax planning and audit processes.2. Data Management: Skilled in managing income tax-related datasets, ensuring accuracy, completeness, and compliance with tax regulations.3. Excel & Advanced Excel: Advanced proficiency in Excel for tax data analysis, including complex formulas, PivotTables, and data visualization to track and report tax-related metrics.4. Typing Skills: Fast and accurate typing skills, essential for data entry and transcription of tax-related documents and financial records