Joyce Green Email and Phone Number

Managed month-end ETL process for numerous mainframe production processes to ensure successful execution and balancing from mainframe down to datamart server.Chaired a monthly coordination meeting to inform team of any changes or potential impacts to the upcoming monthly ETL process.Contributed in complete life cycle of business initiatives, from requirement gathering, documenting, flow charting, testing quality assurance, code reviews, scheduling and implementing to production.Maintained and supported a product table, a key driver for monthly product reporting, communicated changes/updates to customers as the table is used by downstream applications.Committed to delivering accurate and timely data to hundreds of customers and consistently meeting deliverables.Monitored numerous mainframe production processes, ensuring jobs executed error free and troubleshoot if errors occur.Key point person in reviewing impact requests to ensure they are responded to, acted upon, and communicated to broader term for further coordination and planning of implementation when our applications are impacted.Supported reengineering saves of approximately $300K by identifying duplicate tape files and old obsolete files no longer needed.

Consistently delivered timely and accurate monthly reporting to senior leadership.Developed, enhanced, and maintained multiple tables used in reporting.Developed, and maintained monthly balancing of source files processed.Created/documented procedures to support backup processes and business continuation plans in case of disaster.

Managed and controlled the Interest Rate database for lending portfolio to ensure the appropriate interest rates are applied based on cardmember agreements.Conducted and verified average daily balance and finance charge acceptance testing on new business initiatives to ensure cardmember system is working properly before new products are implemented into production.Headed and administered weekly call to discuss the high priority issues on the problem log to ensure corrections are made timely to abide by compliance regulations.Approved and aged monthly reconciliations for internal and external audit examinations and reporting requirements.

Prepared and verified daily settlement and month-end financial activity timely and accurately by creating general ledger vouchers and supporting analysis schedules used by upper management.Monitored and reconciled general ledger accounts to identify discrepancies. Generated correcting entries to resolve differences and to ensure integrity of the general ledger balances.