Emily Koechel Email & Phone Number

Consultancy and training for University customers on Dimensions and Altmetric applications and datasets. Support their use of Google BigQuery data sets and Python API interfaces from a technical and analytical perspective. Example analyses include finding grant opportunities, benchmarking publications bibliometrics vs. peer organizations and customizing automation for all technical abilities and a variety of BI tools from Excel, GoogleSheets, Python, PowerBI, Tableau, DataStudio and more.https://app.dimensions.ai/discover/publicationhttps://www.altmetric.com/

Boulder, Colorado

Research and build Business Intelligence reports, dashboards and datasets with SQL, PowerBI and Cognos. Support the financial analytics and grant reporting requirements of the organization by bridging business needs and technical skill. Develop and execute BI strategy for the organization. Train and support end users of budgeting tool and reports.

Westminster, Colorado

• Project manager leading multiple transformational change efforts relating to increased incorporation of data science in pricing decisions and better collaboration with salesforce.• Extensive data analysis using SAS and SQL to optimize customized pricing for 100K+ mid-sized customers. Sales-facing role requires counseling regarding importance of pricing to bottom line, A/B testing of programs to increase profitability and sales, quantitative forecasting and preparation of clear reporting and tracking metrics. Business intelligence using Power BI. • Portfolio management of various programs; customer segmentation to optimize program placement; regression analysis using SAS to identify outliers for additional pricing review.

Fort Worth, Texas

Fort Worth, Texas

Freelance data analytics consulting for businesses and non-profits: reporting, automation, data-mining, database design and build. Expertise in Excel, SQL and SAS.

Fort Worth, Texas

• Managed a staff of portfolio risk analysts and SAS programmers to oversee customer acquisition channel portfolios for “Lead Generation” and “Direct Mail” channels within Think Finance, an online-only consumer lender offering short-term loans.• Used extensive quantitative analysis with SAS, SQL, and Angoss Decision Trees to design underwriting strategies that minimized defaults and acquisition costs while maximizing loan volume. Monitored performance and implemented needed changes. Ensured strategies fell well within ethical and legal parameters.• Supported data scientists as they built custom logistic regression models for assigned channels; set score cut, line assignment and verification strategies using proprietary scores and knockout rules. Forecasted impacts of changes and tracked performance against expectations; presented findings regularly to C-level executives.• Worked closely with Marketing, Legal, IT and Product departments within Think Finance to ensure that underwriting policies promoted company-wide goals in addition to managing defaults. Recommended changes in other departments to promote lower default rates and/or acquisition costs. • Drafted change controls and business requirements for IT implementations of credit policy changes and product changes; strategic planning for IT priorities.• Served as lead recruiter for Think Finance’s Risk Management MBA internship program.

Fort Worth, Texas

• Analyzed and recommended credit policies and policy changes for New Product Portfolio Management team; launched Line of Credit, Pre-Paid Debit Card and Rent-to-Own products and Lead Generation acquisition channel. • Originated and maintained analytic data marts and automated reporting using SAS, SQL and Excel.• Monitored performance and constantly sought out opportunities to reduce defaults and new customer acquisition costs. Designed, forecasted and recommended A/B testing of new underwriting policies.• Monitored for performance variances and researched root causes using SAS and SQL.• Attended industry conferences and 2-day SAS training course titled Statistics and Logistic Regression.

Fort Worth, Texas

• Maintained, reported, organized and analyzed all key performance metrics for Inventory Management & Distribution department. Presented to senior management on performance drivers and made recommendations for improvement.• Combined strong analytical and technical skills to design and implement in-depth reports, analyses and models to ensure proper allocation and distribution of spare parts and inventory for aircraft maintenance and repair. Tools include COGNOS, Excel, SAS and SQL. Independently developed SQL proficiency within 4 months.• With input from internal customers, such as demand planners and supply managers, designed and developed automated cubes and reports in COGNOS to improve decision making without time-consuming reporting processes. Established COGNOS Development proficiency within 6 months; trained other department members to perform analysis using COGNOS cubes.• Streamlined several multi-day reporting processes into one-click automated reports.

Fort Worth, Texas

• Found, investigated and recommended opportunities to increase profitability and revenue for Cargo business by working with regional sales people and performing quantitative analysis using SAS and Excel. • Increased Cargo revenues by 25 percent on Miami-to-Europe flights by analyzing profit opportunities and recommending an optimized allocation of space for different customers and freight types. Served as Business Analyst on a team developing a web application to automate this process for all flights.• Reworked standard monthly reports to streamline data for Cargo Revenue Management and Sales departments. New reports included a profitability component to enhance prior revenue-only reports.

Fort Worth, Texas

• Responsible for determining pricing for all cargo shipped from assigned markets. Worked with regional sales to maintain or increase profitability and revenue. Quantitative analysis in SAS and Excel to make decisions on pricing changes. Developed SAS data mining and manipulation proficiency within 3 months.

Fort Worth, Texas

Develop and teach MBA-Level courses in "Pricing Strategies and Tactics" and "Integrated Marketing Communications"

Recruit new online and offline partners to offer co-branded online dating websites, powered by the Match.com database, to their users. Track performance and negotiate financial terms.

Dallas, Texas

Bellwood, Ill.

Greater Chicago Area

Freeport, Ill.

Freeport, Illinois

Mba, Marketing, Strategy

Activities and Societies: Cox Distinguished Scholar (Full-tuition, Merit-based scholarship) Student Government Representative (Elected).

B.S., Journalism

Activities and Societies: Student Government Representative-at-Large (Elected) Alpha Phi Omega