<ul><li>Learned SQL, Power BI, MS Excel during the certification.</li><li>Accomplished project on Zomato Restuarant Analysis, Asia Columbia Hospital Analysis and Capstone Bank Analysis.</li></ul>

Professional Data Analyst Certification

<ul><li>Cleared SAP FI Global Certification.</li><li>SAP FI Configuration.</li><li>Asset Accounting, GL Creation, Vendor, Customer and GST configuration.</li><li>Whole end to end SAP FI (ECC) configuration.</li></ul>

 SAP Certified Application Associate - Financial Accounting

<ul><li>Participated in Cricket Tournament in CA Student League.&nbsp;</li><li>Participated in Cricket league at Paperchase Accountancy India Pvt Ltd.&nbsp;</li><li>Loves writing and drawing.</li></ul>

Master of Commerce

Accounting

Bachelor of Commerce

Intermediate (Class XII)

Commerce

Matriculation (Class X)

Not Applicable

<ul><li>Prepared audit sheets and managed accrual entries for year-end procedures using the SAP TRM module, including ledger and dividend account reconciliation.</li><li>Executed user acceptance testing (UAT) for new SAP TRM functionalities and managed bank guarantee (BG) entries, including BG commission and cancellation refunds.</li><li>Handled accounting tasks for FLC, ILC, buyer's credit, and bills collection transactions, ensuring accuracy in financial reporting.</li><li>Conducted month-end procedures, including revaluation of treasury products, classification into current/non-current categories, and creating provisions for closing.</li><li>Skills: MS Excel, Macros, SAP FI, SAP TRM</li></ul>

Executive - Treasury (TRM)

<ul><li>Managed Employee Retention Credit processes for a US client, including payroll adjustments and expense reporting for various projects.</li><li>Performed monthly bank and credit card reconciliations, ensuring accurate ledger scrutiny and general ledger (GL) reconciliation.</li><li>Compiled and analyzed monthly financial statements, including balance sheet reviews, and provided detailed project-wise vouchers.</li><li>Conducted revenue reconciliation and prepared comprehensive reports such as the Statement of Activities and Statement of Financial Position.</li><li>Skills : MS Excel, Quickbooks Online, Quickbooks Desktop, Xero, &nbsp;Blackbaud</li></ul>

Sr. Account Executive

<ul><li>Managed daily transactions, including Accounts Payable and Accounts Receivable, ensuring accurate and timely financial processing.&nbsp;</li><li>Conducted bank and credit card reconciliations, as well as TDS and GST reconciliations, to maintain financial accuracy and compliance.&nbsp;</li><li>Performed detailed ledger scrutiny and supported internal audits to ensure financial integrity and adherence to regulations.</li><li>Handled various banking tasks, including the preparation and submission of financial documents and reports.</li><li>Skills: MS Excel, Shipmnts</li></ul>

<ul><li>Managed day-to-day transaction entries, including voucher and payroll entries, ensuring accurate financial record-keeping.</li><li>Conducted comprehensive bank and credit card reconciliations to maintain financial accuracy and detect discrepancies.</li><li>Processed debit card entries and ensured proper classification and recording within the financial system.</li><li>Assisted in the preparation and reconciliation of payroll data, contributing to efficient payroll management.</li><li>Skills : MS Excel, Acumatic, Quickbooks, DocManager</li></ul>

Account Assistant

<ul><li>Contributed to the development of Citi Commercial Cards Software, ensuring seamless deployment across global markets.</li><li>Prepared Functional Requirement Documents (FRD) to capture and address client-specific functional needs.</li><li>Developed and executed test plans and test cases for user acceptance testing, facilitating smooth project implementation.</li><li>Conducted end-user environment testing and reported software defects, raising tickets to track and resolve issues efficiently.</li><li>Skills: MS Word, PowerPoint, UAT &nbsp;</li></ul>

Process Associate - UAT

Gujarat University, Ahmedabad

India

Enthusiastic aspiring Data Analyst with a solid foundation in Excel, SQL, and Power BI. Currently building expertise through hands-on projects and online courses. Skilled in data cleaning, basic manipulation, and creating insightful visualizations. Seeking an entry-level role to apply my analytical mindset and problem-solving abilities while continuing to grow in the field.

<ul><li>Successfully completed Newton School's SQL module, culminating in a Capstone project focused on developing an Analytical CRM solution for a bank.</li><li>Utilized advanced SQL techniques, including CTEs and views, alongside Excel for data cleaning to ensure accurate analysis.</li><li>Prepared comprehensive documentation and presentations to effectively communicate project insights and recommendations.</li><li>Created interactive dashboards in Power BI to visualize key metrics, supporting data-driven decision-making for the bank.</li><li>Skills : MS Excel, Power BI , MySQL</li></ul>

Capstone Bank Analysis - SQL

<ul><li>Analyzed the Columbia Asia Hospital Project using data from Newton School and Power BI to generate insights on hospital revenue, doctor allocation, and patient demographics.</li><li>Provided recommendations on doctor allocation, patient discounts, and department revenues based on data-driven analysis.</li><li>Developed impactful visualizations, including trend lines and charts, to support informed decision-making and strategic planning.</li><li>Identified opportunities for strategic resource allocation and improvement initiatives to enhance hospital performance and patient satisfaction.</li><li>Skills : MS Excel, Power BI</li></ul>

Asia Columbia Hospital - Power BI

<ul><li>Conducted a comprehensive analysis for Zomato's new restaurant openings, leveraging advanced spreadsheet functions like lookups, charts, and pivot tables.&nbsp;</li><li>Developed a dynamic dashboard to support real-time decision-making for new restaurant locations.&nbsp;</li><li>Created detailed documentation with solutions and suggestions for optimal country and city selection.&nbsp;</li><li>Presented findings through a compelling presentation that outlined the problem statement, challenges, and solutions with effective storytelling.</li><li>Skills: MS Excel</li></ul>

 Zomato Restaurant Analysis- Excel

<ul><li>Work on the ERTC credit for the US clients.</li><li>ERTC credit calculation.</li><li>Prepared 941-X to claim ERC credit.</li></ul>

ERC Projects

<ul><li>Work on the software testing for Citi commercial card.&nbsp;</li><li>Prepared FRD from BRD as per the client requirements for functional testing.</li><li>Preparation of the test plan and test case scenario.</li><li>Execution of the test plan and cases scenario for the smooth implementation of the software.</li><li>Raising ticket for the bugs in software to the development team.</li></ul>

Vinay SharmaIndia

Social Accounts

Achievements

Projects

Capstone Bank Analysis - SQL

Asia Columbia Hospital - Power BI

Zomato Restaurant Analysis- Excel

ERC Projects

Citi Commercial Cards

Experience

Executive - Treasury (TRM)

Sr. Account Executive

Sr. Account Executive

Account Assistant

Process Associate - UAT

Education

Gujarat University

Gujarat University

Gujarat Board

Gujarat Board

Certificates

Professional Data Analyst Certification

SAP Certified Application Associate - Financial Accounting

Skills