Vedika Kshatriya
Data Analyst Intern at Data Glacier- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Data Visualization: Empowering Business with Effective Insights
Tata GroupAug, 2023- Nov, 2024
Experience
-
Data Glacier
-
India
-
IT Services and IT Consulting
-
100 - 200 Employee
-
Data Analyst Intern
-
Aug 2023 - Present
-
-
-
ORMEC ENGINEERING LTD.
-
India
-
Mining
-
1 - 100 Employee
-
Business Analyst
-
Jan 2022 - Dec 2022
1. Prepared reports, analysis, and explanations for monthly accounting and finances. 2. Reviewed the cash flows for accuracy, if necessary, regenerated and saved the cash flows. 3. Developing financial reports and briefing binders covering accounts receivable payments and accounts payable payment receipts using MS Excel. 4. Analyzed monthly and quarterly financial reconciliation reports in elective services for quality assurance and provide accounts’ status in the revenue cycle to senior management. 5. Interpreted data from primary and secondary sources and make them to a single report. 6. Prepared daily, weekly, monthly and quarterly reports and provided data to executive officers. 7. Created analytical data mining and analysis based upon existing performance and data reports. 8. Analyzed and reported actual operation performance vs. Plan and identify causes for variances. 9. Performed monthly balance sheet, income statement and variance analysis in financial position/budget. 10. Responsible for monthly close activities, including journal entries, variance analysis, and reconciliations. Show less
-
-
-
S B Joshi & Associates
-
Mumbai, Maharashtra, India
-
Senior Account Executive
-
Dec 2018 - Jun 2021
1. Bank reconciliation. 2. Audit work on various accounting elements. 3. Cash Inflow and Cash Outflow records and reports analysis. 4. Scrutiny work on various accounting elements. 5. Income Tax, ROC Compliances. 6. Analysis of draft financial statements including notes to accounts. 7. GST returns, Income tax returns and Tax Audit Forms, TDS returns, Service Tax returns, PTRC returns, ROC filings. 1. Bank reconciliation. 2. Audit work on various accounting elements. 3. Cash Inflow and Cash Outflow records and reports analysis. 4. Scrutiny work on various accounting elements. 5. Income Tax, ROC Compliances. 6. Analysis of draft financial statements including notes to accounts. 7. GST returns, Income tax returns and Tax Audit Forms, TDS returns, Service Tax returns, PTRC returns, ROC filings.
-
-
-
SRM & Company
-
India
-
Accounting
-
Business Accountant
-
Nov 2014 - Mar 2018
1.Responsible for monthly close activities, including journal entries, variance analysis, and reconciliations. 2. Performed monthly balance sheet, income statement and variance analysis 3. Used advanced excel functions to generate spreadsheets and pivot tables. 4. Adding advanced functions like HLOOKUP, VLOOKUP, Sumif, Countif, Nestedif, Round, Proper, Lower and Upper. 5. Verified accuracy and compliance of healthcare, logistic, retail, sales and purchases and etc. data for an annual corporate audit. 6. Gathering, combining, and processing the member data to create insightful reports which focus on developing holistic perspectives of membership trends by translating data into ready-to-use tools for executive decision-making for clients. 7. Aged Debtors and Aged Creditors analysis. 8. Preparation of Computation of Income and Income Tax Returns for various kinds of assessees. 9. Projecting tax liability and calculation of advance tax payable. 10. Tax planning. 11. Statutory audit of Private Limited companies engaged in trading and manufacturing businesses. 12. Tax audits for Private Companies, individuals and firms Internal Audit, Vat Audit, Stock Audit Show less
-
-
Education
-
The University of Texas at Austin
Postgraduate Degree, Data Science and Business Analytics -
B.Y.K. Sinnar College of Commerce - India
Bachelor of Commerce - BCom, Accounting -
Rachana vidyalaya,nasik,maharashtra.