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.• Provide training and support to end-users on BI tools and best practices, and help build a data-driven culture within the organization.• Effectively manage BI projects, ensuring timely delivery of milestones and coordinating with relevant stakeholders for successful project outcomes.• Successfully migrated on-premises ETL processes to Azure Data Factory, reducing processing time by 40% and improving scalability.• Automated the GAPs processes between different systems using Azure Data Factory and Power Automate.

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.• Implemented ETL processes to integrate data from various sources, streamlining data access and analysis.• Collaborated with business users to gather and refine requirements, translating them into actionable BI solutions.• Assisted in the implementation of data warehousing solutions, optimizing data storage and retrieval.

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.• Improve the development process.

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.• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.• Created Excel tool which automatically zip the excel files in their respective folder.• Creating and updating unique and targeted graphs, tables, charts and reports for clients and prospective clients using various software applications.• Review the work of peers and Analysts; ensure accuracy and enforce compliance rules as applied to fund performance reporting.• Audit on respective client's data and provide them with correct data.• Provided training sessions on VBA and SQL to an internal team.

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.• Developed several VBA programs to export and import data to and from external systems.• Generated Reports for Offshore and Onshore users using Excel/Access/VBA on a day-to-day basis.• Created HELP prompts using MsgBox in Excel/VBA for making user-friendly applications. • Used ADOs to retrieve data from MS Access Database and display the same in Excel.• Prepared SQL Queries to validate the data in both source and target databases.

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.• MIS Reporting (developing reports using SQL, VBA, and advanced MS Excel).• Developed a utility module for data conversion and exporting to Excel workbooks and VBA programs simultaneously.