Kristina Cannon Fratus

• Developed, maintained and executed a system to automate the calculation of the redress that is due to the customers that purchased PPI
• Managed a team of 10 batch operators that were performing the day to day tasks of running the Automation tool
• Recruited, on-boarded, and allocated team resources to sub projects utilizing overall skill sets
• Worked directly with the internal development team to ensure implementations met business rules, batching team was trained and ensured delivery deadlines met
• Liaised with IT group to ensure that the data feeds were accurate and on time
• Led automation of data feeds to and from the client, initiated required changes to stored procedures and SSIS packages, ensured constant communication within our team and with the client IT counterparts
• Troubleshot all issues that arose within Automation including Automation errors in with code sitting in VB, VBA, SQL or SSIS, data validation failures, and invalid results as identified by the QC team at the client

• Received, maintained and produced loan documents in order to calculate the client’s losses for mortgage backed securities
• Determined the logic for calculating losses during direct communication with counsel
• Implemented processes for performing the loss calculations using SQL and Microsoft Access
• Updated millions of transactions on a quarterly basis to ensure completeness and accuracy via reconciliation
• Provided ad hoc analysis as requested by counsel
• Produced stored procedures to standardized document directory information

• Reduce costs and improve efficiencies across the board for the advertising department at a large national Pharmacy
• Collect historic sales figures and determine the sales lift associated with each weekly advertisement and identify winning products and layouts
• Design reports in their proprietary reporting system to make the lift analysis a long term useable solution for the management team

• Keep the company financially viable during the bankruptcy process while reporting mandated financial figures to the court
• Engaged with IT to identify and receive regular data extracts from all accounting and sales systems
• Generated a daily report in Excel of the company’s cash position that day that used VBA to automatically import the data from more than ten data feeds
• Automated the production of the Sofas and Schedules (Assets and Liabilities) using Microsoft Access and VBA for the 50 plus legal entities
• Prepared one central database containing the contact information for all potential claimants to the company

• Assist management in determining the length of time and the cost for decontaminating all the vessels used to stop the spill and clean up the spill once Operations has released the vessel
• Interviewed operations personnel to determine the number of vessels, their approximate dimensions, and the constraints that would affect the total time to clean each vessel
• Collected information regarding the available decontamination sites, including capacity and work flow constraints
• Developed a model in Excel to factor in the information gathered to provide estimated timelines, and costs
• Provided daily and weekly reports from the model to management based on the ever changing dynamic of the decontamination operations

• Allocate fixed and variable costs for the company to each product they manufactured such that products were identified that were not making the company money and could be either discontinued or revamped to become profitable
• Engaged with IT to receive data extracts from ERP system
• Worked directly with accounting, sales and manufacturing departments to determine the cost inputs and proper allocation methodologies
• Created a complex allocation model using queries in Access and VBA
• Presented results and recommendations directly to the management team
• Refreshed and updated the model on a quarterly basis to understand the impact of the changes that had been made based on the previous quarter’s recommendations

• Create a reusable website to assist in collecting and analyzing results from Requests for Proposals for various clients across multiple industries
• Worked with the client to determine the need for an online bidding tool and gathered the design requirements
• Oversaw the development, managed the team to set timelines and communicated project status with the client
• Performed the initial functionality testing based on my understanding of the project’s needs
• Arrange for end user acceptance testing and articulated the changes needed back to the development team