Scroll To View More
Kristina Cannon Fratus

Kristina Cannon Fratus

Dallas, TX, United States
Member since September 27, 2017
Kristina spent nearly ten years as a management consultant working on a wide range of projects, mostly dealing with large data sets. She spent two years working at a startup building out the platform. Kristina can't wait to get started on her next freelance projects during her time off as a university professor.
Kristina is now available for hire
Portfolio
Experience
  • Microsoft Office, 20 years
  • SQL, 15 years
  • JIRA, 2 years
  • Ubuntu, 2 years
  • GitHub, 2 years
  • Vagrant, 2 years
  • Asana, 2 years
Dallas, TX, United States
Availability
Part-time
Preferred Environment
SQL, GitHub
The most amazing...
...project I've worked on was calculating damages for over charging of payment protection insurance for millions of claimants.
Employment
  • Director of Operations & Development
    2015 - 2016
    iuzeit
    • Oversaw daily operations and platform development.
    • Designed and implemented architecture of platform.
    • Maintained production and development servers.
    • Reviewed data quality for inconsistencies and found areas needing improvement.
    • Performed daily code reviews and mergers and weekly production code pushes.
    Technologies: SQL, PHP, GitHub, Ubuntu
  • Director
    2006 - 2016
    AlixPartners
    • Managed and allocated resources for a team of 20 with highly diverse skill sets covering communications, data entry, advanced data modelling, accounting and finance.
    • Solved highly-analytic and quantitative problems for large, multinational corporations utilizing a disciplined, data-driven approach for the Information Management Services practice area.
    • Analyzed company's financial and sales information to perform cost allocations, cost reductions, and logistics sourcing.
    • 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.
    • Saved the client over $270 million by eliminating the need for millions of man hours by fully automating over 3,000 claims per week.
    Technologies: SQL, VBA, VB.Net, SSIS, Microsoft Office Suite
Experience
  • Payment Protection Insurance Claims Automation (Development)

    • 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

  • Mortgage Backed Security Litigation (Development)

    • 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

  • Pharmacy Ad Sales Reporting and Analysis (Development)

    • 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

  • Publishing Company Bankruptcy (Development)

    • 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

  • Oil Spill Cleanup (Development)

    • 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

  • Food Manufacturer Cost Allocation (Development)

    • 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

  • Request for Proposal Website Development (Development)

    • 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

Skills
  • Languages
    SQL, C++, Visual Basic for Applications (VBA), PHP, R, VB.NET, HTML, CSS
  • Tools
    Microsoft Office, JIRA, Asana, GitHub, Vagrant
  • Paradigms
    Agile
  • Platforms
    Ubuntu
  • Storage
    PostgreSQL, SQL Server 2008, SQL Server Integration Services (SSIS), Phinx, MongoDB
  • Frameworks
    AngularJS
Education
  • Master of Science degree in Engineering Management
    2005 - 2006
    Southern Methodist University - Dallas, TX
  • Bachelor of Science degree in Computer Engineering
    2001 - 2005
    Southern Methodist University - Dallas, TX
I really like this profile
Share it with others