Kajal Darbari Trivedi Email & Phone Number

Burbank, California, United States

Senior Manager, FCRA Data Policies Management & Operations• Lead design and implementation of process, procedures, and controls to execute month-end close activities required to interface and manage studio’s SAP financial data used to calculate and issue contingent compensation payments totaling over $2B per year to Hollywood talent and stakeholders.• Manage and oversee identification, root cause analysis and resolution of close critical issues related to master data, accounting, data integrity, and system issues.• Shortened FCRA’s Month-End close cycle by 50% (24 days to 12 days) and successfully met all close targets 8+ consecutive years. • Manage hiring and retention strategy for the department.• Supervise, train, and coach assigned staff with execution of month-end close and other related activities. Collaborate with the team to ensure each process owner has a backup for the month-end close process and helped in staff’s career development ensuring induvial and department’s ongoing growth and success.• Responsible for the company wide SAP S4 Hana Migration Project and its underlying system enhancements.• Co-ordinate and execute FCRA’s monthly master data maintenance process and dispositioning of the new master data attributes to include or exclude in Sylvester Paris System for accurate Participations and Residuals reporting.

Burbank, Ca

Manager, FCRA Data Policies Management & Operations• Responsible for the planning, execution, and Coordination of FCRA’s (Financial Contracts Reporting and Administration) Participations and Residuals Month-End Close Activities which includes communicating with month end stakeholders, executing Automated Interface, Business validations, preparing manual uploads, coordinating with various Business units, and performing data reconciliations. • Responsible for the preparation of policies and procedures related to the Month-End Close process, as well as the management of required close documentation and metrics.• Identified and implemented many process improvements including system enhancements, automation and analytics using Robotics Process Automation (RPA), Advanced Excel, Lumira, and Dashboard Reporting. Executed user acceptance testing, including writing user requirements, use cases, test scripts and executing test scripts, identifying, and documenting defects. Prepared and presented project updates to senior management.• Assist in research and documentation of any data related issues and questions from various teams (e.g., Audit, Residuals, Participations reporting or other Business units like Worldwide Television, Consumer Products, Games, Home Entertainment etc.) and provided a resolution.

Burbank, California, United States

Lead, FCRA Data Policies Management & Operations

Burbank, California, United States

Senior Data Analyst, FCRA Data Policies & Management

Greater Los Angeles Area

Reconciliation Analyst in Accounting Group• Assisted in preparing the Historical Cash Reconciliation Analysis for Domestic & Foreign Currency high volume Bank Trust Accounts of Creative Artists Agency manually on Excel Spreadsheet using advanced excel formulas.• Created consolidated Monthly and Fiscal Year files for accounting purpose after identifying and resolving variances.

Greater Los Angeles, California, United States

Senior Financial Analyst, Finance Entertainment Group• Prepared operating metrics of FOX businesses spanning the Cable, Broadcast and Film Segments on the News Corp Executive Management Dashboard.• Created/Updated Profit and Loss statements of Fox businesses using Company’s Financial Management System (Hyperion).• Responsible for the Daily upload of the Live +Same Day Nielsen Rating Fast National Highlights on Newsroom.• Prepared the complete Widget Training Manual Document explaining the daily workflow/processes for future department training and reference.

Greater Los Angeles Area

Senior Accountant, Theater Accounting Group • Responsible for the Daily Box Office Manual Uploads of the General Ledger into Yardi Accounting System for all the Pacific Theaters and Arclight Cinemas after collecting and verifying various reports from Vista Application Portal used for Cinema Reporting.• Escalate and resolve the cash variances with the Theater Manager and Operations team to avoid false reporting of cash shorts/overs.• Responsible for the Credit Card and Inter Company Cash Reconciliation of various Depository and Disbursement Accounts on Blackline Reconciliation System.• Worked with the Accounts Payable/Receivable team to post the required re-class, zero balance transfer entries and ensured proper month end closure of all the uncertified accounts.

Newark, Delaware

Analyst/Fixed Income Controller, Global Credit Hybrids Group • Provided daily balance sheet analysis, substantiation & PNL reporting, monthly General Ledger Reconciliation (GLRS), manual adjustments and monitoring of key accounts• Responsible for the daily reconciliation of traders books with the actual trades, reclassification of incorrect journal entries to the correct general ledger area and completion of the monthly GLRS process• Worked with the businesses and product control to ensure understanding and sign off of monthly profit and loss and validation of balance sheet• Ensured closure of outstanding trades on monthly basis by continuous follow up with the relevant teams • Interacted with Middle Office teams ( Trade Support), Product Controllers, CFO’s and settlements teams to understand the operational impact of trading strategies and settlement practices for the business globally• Supported Cash, FX/Loans, Derivatives, Issuance and Exchange Traded Products• Researched, escalated and cleared cash settlement exceptions in a timely manner

Rosemead, California, United States

Financial Analyst Level 2, CAISO Settlements Operations• Analyzed, managed, and reconciled CAISO (California Independent System Operator) Settlements Allocations data which includes account reconciliation and billing• Provided Allocated charges by Contract Accounts to Energy Accounting for three Scheduling Coordinators up to three trade billing cycles for each. Ensure accurate allocation of revenue and billing expense items• Supported CAISO validation process, data requests, ad-hoc and month end reporting• Responsible for the entry, validation, and reconciliation of Disputes from CIDI (Customer Inquiry Dispute & Information) to PCI (Power Cost Inc) systems for dispute closeout and reporting purposes.• Coordinated with the system vendor and IT group for calculation/configuration of California’s Market Redesign Technology upgrade updates and changes ensuring accurate GL posting• Responsible for the upload of CAISO Statements into Settle Core System for data warehousing & financial reporting purposes• Created Month End Reports on Micro Strategy through data stored in Power Procurement Data and Reports fact tables.• Developed Excel Pivot tables / Macros to manage and analyze large volumes of data with high level of accuracy and attention to detail• Analyzed data in XML files to determine source of error, created/uploaded Manual Imports through CSV files and proposed solutions to Management / IT• Actively participated in the Planning/Analysis, Design, Development, UAT/System Testing, and deployment of the new Allocations process from PCI (Power Cost Inc) to CYCG (Czarnecki-Yester Consulting Group) and met the project deadline

Rosemead, California, United States

Financial Analyst Level 2, CAISO Settlements Operations• Analyzed, managed and reconciled CAISO ( California Independent System Operator) Settlements Allocations data which includes account reconciliation and billing• Provided Allocated charges by Contract Accounts to Energy Accounting for three Scheduling Coordinators up to three trade billing cycles for each. Ensure accurate allocation of revenue and billing expense items• Supported CAISO validation process, data requests,ad-hoc and month end reporting• Responsible for the entry and reconciliation of Disputes from CIDI ( Customer Inquiry Dispute & Information) to PCI ( Power Cost Inc) systems.• Coordinated with the system vendor and IT group for calculation/configuration of California’s Market Redesign Technology upgrade updates and changes ensuring accurate GL posting• Responsible for the upload of CAISO Statements into Settle Core System for data wearhousing and financial reporting purposes

Mumbai, Maharashtra, India

Assistant Manager, Finance Global Support Group• Managed a team responsible for development and design of Account Reconciliation Models• Managed the design, development, and implementation of mission critical projects regarding the International Account Reconciliation Systems (Smart Stream Reconciliation System and Transaction Life Management System)• Managed communication with all key business partners, clients, project sponsors and technology partners regarding project progress, issues, development, testing and implementation• Improved the International Account Reconciliation process resulting in more efficient data processing and increased automation• Responsible for developing, documenting, implementing, and testing Business Process Financial Accounting controls around Sarbanes-Oxley and General Accounting Processes• Developed Test Scripts and Scenarios based on Business Requirements for UAT Testing around the Account Reconciliation process

Mumbai, Maharashtra, India

Team Lead, Global Cash and Reconciliation • Managed team responsible for Global Accounting Reconciliation• Prepared Monthly Accounting reports such as the Line of Control, Accounting Exceptions, Client Scorecards and KPI (Key Performance Indicators) • Performed Nostro Accounts Reconciliations for clients from Investment Bank, Treasury and Securities Services, Institutional Trust Services and Global Treasury and Business Services• Responsible for Investigating and Resolving outstanding accounting exceptions• Managed Communication and Relationships with all business partners, corresponding banks regarding outstanding accounting exceptions, reconciliations, and daily account transactions• Managed Sarbanes-Oxley (SOX) Controls and Documentation Change Process working with the Group Controller to review and facilitate changes• Facilitated Sarbanes-Oxley (SOX) Audit with external auditors and responsible for resolving all issues and deficiencies with Business Partners• Main approver of debit instructions for erroneous credits in JPMorgan's Accounts with external banking partner averaging $10M• Ensured adherence to the Service Level Agreements and Operating Procedures regarding the various international JP Morgan Accounts• Trained new staff on the Accounting Reconciliation tools and processes• Special Recognition:o Specially Recognized for the implementation of the Back Up Continuity Initiative between the Mumbai and London offices resulting in a more robust BCP process for JP Morgan Clientso Recognized for gaining efficiencies around the Auto Match and Auto sourcing process on the Smart Stream Reconciliation system resulting in a reduction of client accounting exceptions o Achieved significant cost savings by reducing the amount of paperwork and courier expenseso Achieved additional cost savings and production efficiencies by the streamlining of the Ledger Rejects Process

Mumbai, Maharashtra, India

Customer Associate, Delta Airlines• Managed Airline Reservations, Sky Miles Inquiries and other Customer Relations Responsibilities outsourced to Wipro from Delta Airlines

Mumbai, Maharashtra, India

Junior Accountant, Shared Services Finance Center, a subsidiary of Swissair• Performed account reconciliations, income and expense analysis and month-end/year-end journal ledger accounts closing• Data entry into financial and revenue accounts for various Asian, African, and Middle Eastern countries• Specially selected for Advanced Accounting System training in Zurich, Switzerland resulting in production efficiencies allowing for increased account processing

Sion, Maharashtra, India

Junior Accountant, Chartered Accountant firm • Prepared Corporate Income Tax Returns and income and balance sheet statements.• Performed External Audit on Clients

 Masters Of Commerce, Management

 Post Graduate Diploma In Advertising & Public Relations, Media Planning

Topped the college in Media Planning

 Bachelor Of Commerce, Accounting And Economics