Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
References
Timeline
Generic

Ambika Hemoji Rao

Cincinnati,USA

Summary

Results-oriented Data Analyst and Quality Assurance professional with 5 years of comprehensive experience across various domains, demonstrating proven leadership in diverse industries. Possessing strong analytical skills and expertise in data mining, statistical analysis, and process automation. A demonstrated problem-solver, skilled in driving operational enhancements and optimizing workflows through data-driven insights and innovative solutions. Self-motivated and adept at utilizing data to inform business decisions and improve overall performance.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Data Analyst/ Workflow specialist

TATA Consultancy Services
, USA
02.2023 - Current

Data Analyst and Information Process Enabler at Toyota Financial Services

  • Responsible for capturing and analyzing customer and automobile sales/lease data from Toyota's legacy systems.
  • Conducting data analysis to identify patterns and classify the current status of lease vehicles and customers.
  • Performing data quality checks to detect discrepancies in lease statuses, ensuring accurate data synchronization across systems.
  • Generating detailed reports to track inconsistencies and support seamless data alignment.

Freelancer

Amma's Technology Solutions
09.2021 - Current

Daily Sales Analyst and Web Design Lead

  • Analyzed daily sales data, generating detailed summaries for ToGo sales and providing insights for budgeting and forecasting.
  • Led the redesign of the menu book and branding to enhance customer engagement.
  • Spearheaded the development of a new website and mobile app to improve user experience and drive online sales.

QA Trainee

QualisGuard Solutions LLC
01.2022 - 02.2023

Quality Assurance Trainee

  • Conducted thorough requirement analysis to identify test objectives and ensure comprehensive coverage in test plans.
  • Developed and documented detailed test cases and test scenarios using industry-standard methodologies, while designing a custom test case template to improve efficiency and consistency across the QA process.
  • Executed a wide range of testing techniques, including functional, regression, integration, and user acceptance testing (UAT), ensuring alignment with business requirements and product specifications.
  • Utilized defect tracking tools to log, prioritize, and report issues, collaborating with development teams to facilitate quick resolutions and maintain product quality.
  • Actively participated in test case reviews, requirement walkthroughs, and sprint planning sessions to ensure alignment with Agile methodologies.

Banking Assistant

Cinfed Credit Union
02.2022 - 01.2023

Banking Operations and Customer Support Specialist

  • Provided comprehensive banking assistance, ensuring smooth daily operations and handling a high volume of transactions.
  • Logged, tracked, and reconciled daily transactions to maintain accurate financial records.
  • Delivered prompt and professional customer support, addressing inquiries, resolving issues, and ensuring a positive banking experience.
  • Tested and evaluated banking tools and processes to enhance system functionality and improve operational efficiency.

Assistant Accountant

Skol Breweries Ltd
01.2008 - 01.2009

Financial Data Analyst (Auditor)

  • Conducted comprehensive analysis and classification of organizational records related to goods received, ensuring proper alignment with applicable accounting standards (e.g., IFRS, GAAP). Utilized advanced data management techniques to ensure accuracy in the tracking and recording of inventory and procurement transactions.
  • Prepared meticulous reconciliations for capital expenditure creditors, ensuring that all entries were correctly matched to the corresponding capital projects and cost centers. This included the identification and resolution of discrepancies between ledger balances and supplier statements, ensuring accurate financial reporting in line with statutory and internal audit requirements.
  • Collaborated with finance teams to enhance reporting frameworks for capital assets and expenditures, improving the transparency of capital allocation and enhancing decision-making processes.
  • Utilized accounting software and ERP systems to streamline data processing, monitor outstanding liabilities, and generate real-time financial reports, contributing to better cash flow management and compliance with corporate governance.

Assistant Accountant

ASPN associates
11.2006 - 12.2007

Transaction Management and Tax Compliance (Chartered Accountant)

  • Managed end-to-end financial transactions, including sales, purchases, and payment processing, ensuring accurate entry and reconciliation in accordance with accounting standards (e.g., IFRS, GAAP). Oversaw the preparation of detailed financial records for both receivables and payables, improving efficiency in cash flow management and vendor/client relations.
  • Performed precise income and sales tax calculations, applying in-depth knowledge of tax laws, regulations, and applicable rates. Managed tax compliance by preparing and filing accurate returns for income tax, VAT, GST, or sales tax, ensuring adherence to statutory deadlines and minimizing tax liabilities.
  • Conducted thorough reviews of tax filings, ensuring all deductions, exemptions, and credits were properly applied, resulting in optimized tax outcomes.
  • Coordinated with tax authorities on audits, inquiries, or assessments, providing necessary documentation and resolving any discrepancies, ensuring smooth resolution of tax-related matters.
  • Provided strategic tax advice to management, ensuring proactive tax planning to maximize tax efficiency and reduce risk exposure, while maintaining compliance with both local and international tax regulations.
  • Leveraged accounting software and ERP systems to automate transaction recording and streamline the tax calculation and filing processes, enhancing both accuracy and operational efficiency.

Education

Post-Graduation in Data Science -

Purdue University
USA
07.2021

Bachelor of Commerce -

Bangalore University
India
04.2006

Skills

  • Python Programming
  • Data Visualization and Presentations
  • Tableau
  • Microsoft Power BI, Microsoft Access, Microsoft Excel
  • Data Exports
  • SQL
  • Software Quality Assurance
  • Test Plan Development
  • Compatibility Testing
  • Usability Testing
  • Defect tracking
  • Process Validation
  • Customer Relationship Management (CRM)
  • SAP software use
  • SAP Crystal Reports

Certification

  • Software Testing Certification/Training, QualisGuard Solutions, 2022
  • Graphics Designer Certification, Shaw Academy, 2020
  • Google IT support Certification, Coursera, 2018

Accomplishments

  • Star performer in the Toyota Project team (company: TATA Consultancy Services)

References

References available upon request.

Timeline

Data Analyst/ Workflow specialist

TATA Consultancy Services
02.2023 - Current

Banking Assistant

Cinfed Credit Union
02.2022 - 01.2023

QA Trainee

QualisGuard Solutions LLC
01.2022 - 02.2023

Freelancer

Amma's Technology Solutions
09.2021 - Current

Assistant Accountant

Skol Breweries Ltd
01.2008 - 01.2009

Assistant Accountant

ASPN associates
11.2006 - 12.2007

Post-Graduation in Data Science -

Purdue University

Bachelor of Commerce -

Bangalore University
Ambika Hemoji Rao