Ciana Chastain

Finance Manager @Paysafe

Actively worked on DataMart project to aggregate financial data to be distributed to MasterDataServices (MDS) to map data points, Oracle system for processing, and establish residual calculations for agent contracts.* Spearhead design and setup of Oracle to implement residual calculation process and Accounts Payable program reporting to correct GL.* Analyze partner/merchant hierarchy relationship across numerous CRMs and combine into MDS as one residual hierarchy.* Perform monthly residual variance analysis checks per SOX Compliance protocols.* Mapped CRM hierarchy and platform data (Omaha, TSYS, North) fields for partner contracts, reports, and statements.* Composing query statements in SQL Server Management Studio to complete monthly variance analysis and generate ad-hoc reports.