United States Data Analyst

Swati Srivastava Contact: +1-206-***-**** E-mail: *****.************@*****.***

Address: **** ***** **** **, *********- WA 98296

Finance and Research Professional

A performance driven MBA professional bringing along business acumen and record of achievements developed over years, with a valid work authorization in United States. Holds multi-functional experience in Finance, Accounting and Secondary Financial Research with working knowledge of Microsoft excel v-look up, pivots, IBM planning analytics. Hands on experience and knowledge of working on Peoplesoft, Cognos, MS Access, Quick site, SQL, Quip and Salesforce.

PROFESSIONAL EXPERIENCE

1.Amazon.com – Seattle, WA (Contract)

Accountant 4 (Mar 2024 to Jan 17th, 2025)

Analysis and review of the primary and secondary ledger balances from Oracle with FERA UI tool launched to automate JE records for testing output, report anomalies and recommend solutions.

Worked on multiple financial software such as Alteryx, Oracle financial application, FERA UI tool, Redshift, Amazon BI, ETL queries, SQL Queries, Service now, Quip, SharePoint website, Google sheet and MSFT Suite to pull data and prepare dashboards and financial statement analysis.

Analyse and investigate significant FX variances between national bank rates and corporate rates over primary and secondary ledger accounts and resolve the SIMs with analysis and investigation.

Supported and collaborated with global and cross functional teams to drive alignment and desired results.

Prepared knowledge base and process documents to provide training to the existing and new team members as part of cross training and onboarding new hires.

Run Alteryx to pull and manage journal entries support program in compliance with GRC 2506 and request for the supporting document to analyse and validate the material journal entries.

Run ad-hoc analysis of different projects to support long-term goals of the FX Accounting team.

Prepared months end close of accounts reclasses Journal Entries in JEs reconciliation program to match the JEs balances updated in Oracle Financial Applications and Spursh tool.

Optimised and Implemented intake and sprint mechanism to prioritize projects and stakeholders based on impact.

2.Infinite Computer Solutions - Contract with client Fiserv

Financial Data Analyst (July 2023 to January 5th, 2024)

Creation and hosting of small and medium sector banks financial data from manual system to an integrated software ‘Prologue Financials’; to automate the financial statement preparation and reporting streamlining process.

Importing and converting client’s financial trial balance, general ledger, Profit and Loss statements and Balance sheet into SAP ERP-Prologue Financials, retaining all meaningful data points on SQL Server 2019.

Worked on multiple software tools, such as SQL Server (Microsoft SQL Server 2019.), MS Access,

SharePoint, Client’s On- Demand (for sharing confidential data), Clarity, Service Point

and Client 360 to pull and analyse the confidential financial data and building the database.

Import client’s general ledger, journal entries, match trial balance, balance sheet, and send the GL report to client for validation.

Upload Fixed asset and Accounts payable (With 1099 report) information with GL (in full suite implementation) into the Prologue financials ERP, calculate depreciation and getting it validated from the client for final database implementation.

Hosting the financial database built on SaaS Intelligent workplace, restoring the databases to the IW environment.

3.Starbucks Support Centre, WA

Accountant Analyst (May 2023 to June 2023)

Weekly analysis and reporting of Starbucks supplier’s invoices and verify bills with payments.

Prepared financial and aging models for Starbuck pest suppliers.

Worked on tools such as Salesforce, Tableau, Alteryx, and Oracle for reporting of monthly invoices and payments.

Worked on Compass ERP solutions

Prepare monthly analysis and analysis drill through report for pest suppliers credit management cycle.

Continuous support to Ask RM inbox and resolving tickets for payments and queries.

Identifies and implements key performance metrics and processes.

Provides management with information on general ledger account status, resolves issues and recommends solutions.

Serves as the subject matter expert on cross functional teams tasked with the design and implementation of enterprise initiatives that impact accounting processes.

4.Amazon.com - Seattle, WA

Financial Analyst (May 2022 to Mar 2023)

Team member of Amazon Expansion and Exports team looking into analysis and reporting of company's Core Exports and Global stores business development, industry trend and economic conditions for leadership reporting to make investments decisions.

Prepared monthly unit forecasting models and SaaS financial models for strategic planning of revenue on a global level.

Pulling data using SQL queries, ETL queries, Hubble, Red Shift, Oracle (Hyperion) etc. to prepare and review the business Profit and Loss statement, financial tables, KPIs, CAGR, Price yields, YoY & MoM trend analysis and cost drivers to analyse investment risks for monthly and quarterly business reviews with leadership.

Worked on software such as amazon BIs, Hubble, Cognos, Salesforce, Quip and Asana to extract desired data from databases.

Extensive use of MS Excel, Google sheets MS Access database, Macro, Pivot tables, Power BI, Tableau etc. for data, analysis, P&L statements, financial tables preparation, comparison, and reporting.

Worked with cross functional teams to support them with business metrics and monthly/quarterly analysis and reporting of financial performance.

Support the team's international expansion initiatives with forecasting and reviews.

Leverage 3rd party data sources to make informed business decisions.

5.TEK Systems Global Services Private Limited

Financial Analyst (Feb 2020 -Sep 2021)

Quarterly review customer accounts to verify the burdens placed on fees/discounts as per contract terms and ensure appropriate funds in accounts at the time of accrual/payment.

Worked on MS InfoPath to prepare Burden Approval Form to submit the calculated weighted average burden to be placed on contractor’s account basis service fee and volume discounts.

Weekly preparation of Burden Variance Report (Master file and office file), and Burden approval accrual report to update the incorrect /missing burdens to SMOS and field offices to review and correct all discrepancies in accounts.

Participate in Account Payable tasks from invoice entry to issuance of checks to vendor as per agreement.

End to end processing of volume/ tenure rebates request accrued (monthly, quarterly, annual), calculate and maintain fund in the client’s account and paid via cheque/EFT / Wire transfer upon due dates.

Hands on experience on software such as Oracle (Hyperion), Peoplesoft Oasis and People soft Financials, Contract Logix, MS Access, MS InfoPath, QuickBooks, Salesforce, SharePoint and Net Suite.

Successful learning and transition of burden process to India office. Prepared burden team SOP and trained team members on various tasks through meetings, shadowing, and review, discuss questions and concerns.

6.Amazon Development Centre (India) Private Ltd.

Fee Integrity Specialist (Jun 2017-Apr 2018)

Weekly review of fees and commission charged to the Sellers as per standard and overlay rate, terms, and agreements.

Worked on software such as Feenix, Salesforce, Share point, Contract Logix, MS Access, SQL query editor.

Review and identify material fee errors, its financial impact and raise ticket/Issue/contacts to coordinate with Seller Fee technology team and/or internal partner teams through e-mails, conferencing/IM to facilitate remediation within SLA.

Preparation and analysis of Weekly Fee Change Dashboard and share it with Stakeholders, to discuss the discrepancies and their financial impacts and to take corrective actions.

Performed research and insight on the developing the process of reviewing fee changes accurately with minimum time and to improve the productivity of team.

Following up with Program Managers and Stakeholders for the approval documents and contracts to ensure the fee discounts or premium charged are accurate and authorised by the respective program owners.

Prepared Process SOPs and Checklists for the team to ensure the completion of tasks as per standards.

7.Deloitte Tax Services India Private Limited

Tax Consultant (Business Tax Services – West; Aug 2012-Feb 2014)

Preparation of Federal and State tax returns for U.S based Regulated Investment Companies/Partnership.

Worked on software such as One Source, CCH for tax reporting, Fixed asset accounting (FAS) for depreciation, Corp tax to prepare tax returns.

Clients include major Investment Management Companies operating in Mutual Funds, Hedge funds, Bonds and Trust Funds.

Perform research tasks to collect financial information as required for Tax return preparation.

Self-review of all work to minimize error and apply learning from one engagement to the other.

Collaborate with US tax teams for idea sharing, task and time allocation, discussions and solution development.

8.Ernst & Young Global Shared Services

Financial Analyst (Transaction Advisory Services; Jan 2011-Nov 2011)

Research and analysis of Industries, sector, companies using external databases and prepare company profiles covering business description and analysis report and provide pre-diligence support to onshore commercial due diligence team.

Research on Group companies and making Research Packs and Structure charts for clients and perform Complexity Analysis.

Preparation of Financial statements in EY format for calculation of KPI’s and ratio analysis.

Used databases such as OneSource, Experian, Fact set, merger market, GRS etc. to perform quality research.

9.Bank of New York Mellon, Pune

Operations Executive (Mutual Funds Custody; May 2009-Sep 2010)

Processing of trades and Foreign Exchange transactions involving high risk and accuracy for clients in deadline driven environment and resolving queries for day-to-day trade processing.

Worked on client ‘Çitrix’ software to process trade/transactions in real time US stock exchange market dealings.

Responsible for daily reporting and necessary action to be taken on deals/ payments.

Working on process efficiency ideas to reduce the time and maintain accuracy of the work.

Performed Transactions related to investments in capital market across various International Stock Exchanges.

EDUCATIONAL QUALIFICATION

Course

Institute

Batch

CA Foundation and Intermediate (I &II)

Institute of Chartered Accountants of India (ICAI), India

2003-07

MBA/PGDBM in Finance

ICFAI / ICFAI Business School (Noida), India

2007-09

Graduation (Bachelor of Commerce)

CSJMU, Kanpur, India

2002-05

Class 12th

Kendriya Vidyalaya, IIT Kanpur, India

2001-02

Class 10th

Kendriya Vidyalaya, IIT Kanpur, India

1999-2000

MBA INTERNSHIP

Analysis and Comparison of Mutual Funds with ULIP as Investment Options in Reliance Money Ltd. (Duration: February 2008 to May 2008).

AWARDS/RECOGNITION

Received appreciation email from leadership for efficiently managing multiple team’s tasks and taking ownership of tasks with high visibility in MBR, QBRs discussions.

Received appreciation mails and R&R in E n Y and Deloitte tax from clients for good and timely performance.

Secured scholarship of INR 240K during MBA.

Won 1st prize in group presentation of Finance club on Mergers & Acquisition in MBA College.

PERSONAL DETAILS

Date of Birth: December, 18

Gender: Female

Marital Status: Married

Languages Known: English and Hindi

I hereby declare that the all the information provided above is true to my knowledge and the same can be proved by furnishing relevant documents, on request.

Place: Washington Swati Srivastava

Date: 02/27/2025

Contact this candidate