Abhay Prasad Email & Phone Number

Pune, MH, IN

• Led a team of BI analysts and developers in designing and implementing data-driven solutions to support strategic decision-making.
• Oversaw the creation of interactive dashboards and reports using Power BI, resulting in a 20% increase in data accessibility and user adoption.
• Establish and monitor key performance indicators (KPIs) relevant to business objectives, delivering regular reports on performance against targets.
• Develop and maintain tailored reports and dashboards using Dynamic, Salesforce, HubSpot, Jira, and Google Analytics to provide real-time insights into key business metrics.
• Collaborate with cross-functional teams, especially Sales, Marketing, and Operations, to understand their data needs and deliver insights that support their strategic goals.
• Established and enforced data governance policies, ensuring data quality, security, and compliance with industry regulations.

Bengaluru, Karnataka, India

• Lead and manage end-to-end analytics projects, including planning, execution, and delivery.
• Develop and maintain robust data models in Power BI, ensuring accuracy and efficiency.
• Utilize VBA (Visual Basic for Applications) to automate repetitive tasks and streamline data processes.
• Integrate data from various sources into a unified and cohesive dataset for comprehensive analysis.
• Collaborate with cross-functional teams to understand business requirements and translate them into analytical solutions.
• Ensure adherence to best practices in Power BI development, SQL coding, and VBA scripting.

Bengaluru, Karnataka, India

• Automating MS word report using VBA.
• Automating ESG (environmental, social and governance factors) models using VBA.
• Codes in VBA MS Access and SQL, develops, tests, debugs, implements, and documents programs. Assists in the modification of existing code.
• Developed and maintained complex data models, enabling efficient data analysis and reporting for key stakeholders.
• Created interactive and visually appealing dashboards using Power BI and SQL Server Reporting Services (SSRS), improving data-driven decision-making processes.
• Conducted data profiling and cleansing, resulting in a 15% increase in data accuracy and reliability.

Pune, Maharashtra, India

• Support Existing Access DB developed for Australia, UK and Canada Reporting.
• Develop Existing Access DB for changes in Business Requirements.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Codes in VBA MS Access and SQL, develops, tests, debugs, implements, and documents programs. Assists in the modification of existing code.
• Undertake business analysis required to make business changes to the Access DB.
• Facilitate User Acceptance Testing for changes to the Access database.

Gurgaon, India

• Developed, deployed, and monitored SSIS Packages.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Created Excel tool which automatically converts.xls to.xlsx using VBA code.

Pune

• Created Excel Report which get data from HP QC tool using VBA code.
• Created VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Extensively use Excel functions in development, focusing on read/write integration to databases.
• Developed Word forms using VBA to conduct various surveys to optimize monthly reports based on team usage.
• Generating code for automation of report/exporting data to Excel and deployment.
• Developed excel template for exporting report data with formatting for daily leadership meeting.

Noida Area, India

• Generated daily and monthly basis of Reports using VBA.
• Generated many reports through VBA coding in EXCEL.
• Worked on PowerPivot along with EXCEL.
• Processing the obtained data in Advance Excel using features like PIVOT GRAPHS, FORMULAS, etc., and generating reports based on certain Key Performance Indicator metrics.
• Monitor day-to-day stock transfer details.
• Preparing advanced formulas, VBA macros, and reports required by management.