At Ferrier Solutions, we help clients just like you find insights hidden within their own data. It’s our ability to work together with clients to solve problems that make our data solutions process unique. Over the years, we have delivered insightful sets of reports that highlight critical business information. After engaging with Ferrier Solutions for the first time, companies can often increase efficiency right away, using data that allows for quick decision-making and rapid corrections to standards and procedures. Based in Oklahoma City, OK, we serve businesses of all sizes but specialize in taking medium-sized operations to the next level in data strategy and data solutions. Sample of Professional Projects:• Delivered insightful set of reports that highlighted for the client which vendors provided flawed products most often. Within a month of receiving the reports, the client used supporting documentation from the reports to get a $5,000+ credit with a vendor. Even more, the vendor was motivated to research their own process and figure out what was wrong with the process so they could no longer provide products with the same flaw.• Developed data loads in SSIS on a tight deadline to speed up client’s recovery from a ransomware attack. Their data loads, previously, written in DTS were lost during the ransomware attack and they needed someone to come in quickly and rewrite the data loads.• Developed Power BI reports to show which products are more profitable. Client, previously, had someone come in for 3 months who was unable to provide any usable reporting. Within a week I was showing data results that made sense to the client.• Developed SSRS reports to show slowdowns in their workflow process. Their operations system didn’t have a way to provide this information, so I dug into the details of their backend database and determined where this data was stored and how to report on it. I then developed the corresponding reports.

• ThunderPlains Developer Conference - So MANY databases, which one do I pick? (Nov 2018)• SQL Saturday Oklahoma City - Demystifying JSON in SQL Server (August 2018)• SQL Saturday Oklahoma City - 3D Geospatial Visualization Using Power Map (2013)• SQL Saturday Dallas - Introduction to SSAS OLAP 2008 (May 2010)• SQL Saturday Dallas - Visual Studio 2010 Database Functionality and Projects (May 2010)• OKC Visual Studio Launch - Visual Studio 2010 Database Functionality and Projects (August 2010)• Tulsa TechFest - Intermediate SSAS 2008 - Developing Time Calculations (November 2010)• Tulsa TechFest - Introduction to SSAS OLAP 2008 (November 2009)

C#, SSIS, and T-SQL development to customize SolArc RightAngle (SRA) application. • Developed custom Lower Cost Model (LCM) module on a tight deadline to be ready for 2016 audits. • Developed SSIS packages to import multiple sources of deals, prices, movements, and automatcher rules into RightAngle system. The first of the automatcher rules interfaces allowed the business to update 55,000 automatcher rules in 10% of the anticipated time for manual updates. • C# development spanning many projects including SRA scheduled tasks, SRA editable screens, and SSIS script tasks.• Developed SSIS packages to perform automated deployments of new customizations of SRA to multiple servers. • Created and enhanced TFS automated build definitions.

• Designed star schemas for enterprise data warehouse using ERwin Data Modeler. Table design includes fact tables, type 1 dimensions, and type 2 dimensions. Latest fact table design is for accumulating snapshot tables. • Developed Informatica Data Quality Scorecard proof of concept. Development includes IDQ physical data objects, logical objects, profiles, mapplet rules, and scorecards.• Developed T-SQL SME tests to automatically test ETL loads and database object deployment.• Created functional design specs, including complicated transformation logic, for ETL developers to use when developing Informatica ETL to load the data warehouse.• Analyzed SAP and other source system data to determine rules necessary to transform the data into the data warehouse. Analysis typically performed using T-SQL, PL/SQL, and IDQ Profiling.• Obtained familiarity with SAP Hana due to possible upcoming implementation.• Developed Power Map demo for presentation to multiple Devon teams. • Collaborated with small Agile Focus Group to analyze feasibility of using Agile methodology within Devon IT and also educate others on Agile methodologies.

• Developed enhancements and deployment plan for a mission critical application. We successfully deployed early, ahead of schedule within the deployment window, and there were no issues with the deployed application.• Got a backup system quickly up and running during a catastrophic hardware failure so that mission critical work could continue. • Architected, designed, and developed C# Application Framework for rewrite of a major web application.• Developed ASP.Net web applications using C#, jQuery, jQuery UI, XML, and AJAX Control Toolkit with Oracle 10g / 11g database layer.• Supported and enhanced both ASP.Net and Classic ASP web applications.• Engineered PL/SQL stored procedures, packages, and merge statements within Oracle 10g / 11g database system.• Converted VB.Net data loads into PL/SQL stored procedures run using Oracle Scheduled Tasks.• Interfaced with government users to scope and gather requirements for various web application projects.• Utilized TFS 2010 to manage work items, control source code, and peer review code.• Collaborated with Configuration Management and Quality Assurance team to improve processes.• Attended Certified Scrum Developer Training. Additional class is required to obtain official certification.

Business Intelligence Analyst (2007 - 2009)• Developed, enhanced, and maintained multi-gigabyte-sized SSAS 2005 cubes. Data was sourced from a 200 GB cube mart.• Improved processing performance of the two largest SSAS 2005 cubes by 50%. • Engineered complex SSIS packages. • Designed aggregate fact tables and complex stored procedures for the EDW. • Analyzed a variety of data differences between old data warehouse and new EDW to determine causes. • Enhanced and documented Flash Reports .Net application.• Saved company several thousand dollars by leading a 2 day class on SSAS 2005 development for three of my peers. • Provided Subject Matter Expert knowledge for the new Enterprise Data Warehouse (EDW). Software Developer (2006 - 2007)• Enhanced performance of Weekly Sales application by 40%. • Saved company $20,000 in SharePoint 2003 license fees.• Developed ASP.Net 2.0 pilot web portal framework. • Engineered complex stored procedures and SSIS packages. • Customized, implemented, and administered SharePoint 2003. • Developed and enhanced Crystal XI Reports. • Mentored fellow developers on .Net web development.

• Developed complex T-SQL stored procedures, table alteration scripts, and DTS packages.• Administered primary SQL Server databases for the Hertz Fleet System software development environment.• Developed timely enhancements and bug fixes for Hertz Fleet System using ASP, VB, and VBScript.• Interfaced with user base to gather requirements for major revision to Hertz Fleet System.• Selected as team member to travel to France to gather requirements in person.

• Administered SQL Server 2000 databases for company-wide development and production environments.• Developed dynamic Web Forms applications and XML Web Services using ASP.NET, C#, ADO.NET, JavaScript, and HTML.• Designed SQL Server database tables.• Developed T-SQL stored procedures.• Performed IIS 5.0 and Windows 2000 Server administration.

• Developed T-SQL stored procedures for Microsoft SQL Server 6.5 and 7.0.• Developed enhancements and bug fixes for the scheduling system for SolArc RightAngle, a commercial energy trading application, using PowerBuilder, SQL Server, and XML.• Performed object-oriented programming from requirements analysis through acceptance testing.