Power Bi Data Analysis
Resume:
Arpitha Settipalli - Resume
ARPITHA SETTIPALLI Mobile: +1-484-***-****
US CPA CA (INDIA) Email: *************@*****.*** LinkedIn- https://www.linkedin.com/in/ca-cpa-al-arpitha-s CAREER OBJECTIVE:
Experienced and detail oriented Certified Public Accountant and Chartered Accountant with a passion for technology and innovation. Strong knowledge of accounting, auditing, and finance processes. Skilled in data analysis and reporting. Adept at collaborating with cross-functional teams and stakeholders to deliver high quality audit reports and recommendations. Demonstrated ability to lead and mentor junior auditors, fostering a culture of continuous learning and development. To contribute to the achievement of organizational objectives which I represent and serve while concurrently upgrading my skills and knowledge. KEY SKILLS:
• Quick learner
• Hardworking nature, positive attitude and Goal oriented.
• Teamwork with utmost sincerity.
• Punctuality & completion of work on time.
• Remarkable patience, ready to face challenges and willing to take responsibility.
TECHNICAL SKILLS:
• MS OFFICE
• ALTERYX
• US GAAS and External Audit
• US GAAP and Financial Reporting
• AURA (Firm specific tool)
• Tableau
• Data Analysis & Interpretation
• Tally Prime
• Internal controls
• Power BI
• VISIO
• Risk Assessment/Management
• Oracle Fusion (AP, AR, CM, GL, FA BEM)
• Tax filing
• Budgeting & Cost Analysis
• Advanced Excel (VBA, pivot tables)
• Variance Analysis
• Financial Modeling & Forecasting
• SQL
WORK EXPERIENCE:
Company: NYS ITS (New York)
Period: June 2024 – Present
• Working as an IT Control/Accounting Analyst, testing the controls and conducting IT audit
• Design, execute and perform detailed testing of internal controls per professional audit standards, and within established deadlines.
• Evaluate internal controls, propose enhancements to controls, and investigate the cause of internal control weaknesses.
• Working with the Company’s external auditors to ensure proper alignment and leverage of management’s internal controls testing.
• Preparation of reports based on Business as per client specifications.
• Dashboard creation using Power BI, Tableau. (Financial modeling)
• Presented insights to senior management, aiding in strategic decision-making and increasing team efficiency.
• Analysis of data using Data Analytics tools like excel, power BI, Tableau, and Google Looker Studio.
• Conducted a comprehensive cost-benefit analysis to identify areas of potential savings, resulting in a reduction in operating costs.
• Coordinate and attend internal control walkthrough meetings with relevant individuals from each business unit and the external auditors.
Arpitha Settipalli - Resume
2
• Prepares accounting documentation for comparison of accounting alternatives using a variety of modern analytical techniques.
• Prepares narratives, schedules, charts, and graphs rendered in a form usable for evaluating the integrity of the accounting records.
• Filling Individual tax returns 1040.
Company: PwC Acceleration Center (India)
Period: January 2023 – May 2024 (Senior Associate) May 2021 – December 2022 (Associate)
Domain: Audit & Assurance Domain (External Audit).
• As a part of Acceleration centers, assisted in providing assurance services to consumer & industrial products sector audit engagements which are large ($8 billion, $4 billion revenue companies) and mid-sized US based private and public clients in accordance with US GAAP and US GAAS
• Preparation and review of lead schedules by using Alteryx and business mapping file, which helps to save 50% of time compared to manual process for various financial statement line items.
• Proposed year end adjustment entries for provisional items, income tax etc. and proposed audit adjustments as needed.
• Performed substantive audit procedures such as revenue 5 step approach, inventory target and accept-reject testing as a part of testing, count to sheet, floor to sheet testing, accounts payable and accounts receivable reconciliation sub-ledgers testing, foreign currency receivables and payables testing, property, plant and equipment verified for opening balances, additions, sales to tally with closing balances and profit & loss items etc. Also performed non-statistical sampling, random sampling as part of testing.
• Assisted in substantive testing and analysis for different financial statement line items, which includes testing mathematical accuracy, internal consistency checks and prior year checks.
• Reviewed the financial statements to ensure compliance with applicable reporting framework US GAAP and preparation of audit disclosure checklist according to IFRS.
• Analyzed financial data for accuracy and completeness.
• Conducted a comprehensive cost-benefit analysis to identify areas of potential savings, resulting in a reduction in operating costs.
• Prepared Budgeting, Actuals, Forecasting and Variance analysis reports.
• Performed analytical procedures to detect unusual variances in financial statements.
• Verified financial statements and related disclosures to relevant supporting documentation which includes financial statement review tie-outs etc.
• Evaluated the operating effectiveness of the controls identified by the management.
• Streamlined operational efficiency by identifying areas for improvement and proposing. actionable solutions.
• Effectively managed multiple competing priorities while maintaining focus on delivering exceptional results for clients and the organization.
• Implemented process improvements that led to critical time savings and increased accuracy in deliverables.
• Consistently maintained strong relationships with the engagement team and clients, ensuring clear communication and timely updates on project progress.
• Led the team of associates and delivered high quality work on time and coordination on various engagement tasks.
• Received personal feedback and rewards for delivering quality work from the onshore Team. Audit and Tax Intern:
• Worked as an Audit Intern from March 2015 to March 2018.
• Where I have good exposure in finalization of financial statements, Internal and External Audit, Taxation matters.
Assignments managed during Audit Intern:
• Preparation of financial statements in Tally prime like posting journal entries to ledgers, trial balance and finalization of financial statements.
• External audit assignments of product and service sector. Arpitha Settipalli - Resume
3
• Engaged in the Internal audit assignments as per the scope defined and process reviews of various departments like Inventory, payroll etc.
• Computation and filing of individual tax returns and performed tax audits of various clients. Education:
• Certified Public Accountant (US) – AICPA - 2023
• Chartered Accountant (India) – ICAI - 2021
• Bachelor of Commerce - Sri Venkateswara University - 2014 Awards & Certifications:
• Digital Acumen - PwC - July 2021
• Spotlight Award - PwC - 2021
• Spot Award from PwC ET – 2023 – for two bigger clients
• Communication Foundations – LinkedIn - April 2021
• Preparing Data for Analysis with Microsoft Excel
• QuickBooks Online Essential Training – LinkedIn – August 2024
• Intuit Academy Tax Exam Level 1
• Data Analytics and Artificial Intelligence
Contact this candidate