Martin Bryan Email and Phone Number

• Redesigned Sales Commissions process to improve reliability and restore confidence of the business users (Sales and Finance).• Developed Subrogation and PBM Eligibility files for vendors.• Contributed to building of organization's data warehouse. • Developed a dynamic table driven ETL framework file exports.• Became Subject Matter Expert for eligibility related data.• Mentored junior team members.

• Developed a table driven ETL framework in SSIS.• Created Data Mart for Sales/Operations to centrally report from.• Developed and maintained Sales, Financial, and Operational reports from ERP (QAD) system.• Implemented ERP Replication to SQL Server.

• Developed a table driven ETL framework in SSIS which retrieved data from over 2400 databases.• Created Data Mart for Document Ingestion application (IPRO Allegro) to centrally report from.• Developed reports from Document Ingestion (IPRO Allegro) and Review (kCura Relativity) applications and Workflow application for finance teams to be able to bill clients.

• Created Data Model for reporting projects. • Took ownership of Business Analyst role for designing phone data points and working with development teams to implement.• Built metadata layer (Cognos Framework Manager Models) for reporting project.• Built Cognos reports and dashboards for multiple reporting projects.• Built ETL using Talend to load data from Mongo databases.

DSHS Children's Administration Data Warehouse• Evaluated vendor’s proposed data warehouse design, made recommendations, and participated in the building of the SSIS ETL packages.• Worked with business users for various data requests for social worker and foster care children information. This included gathering requirements, performing analysis, consolidating data, identifying data issues.• Developed complex queries in T-SQL Stored Procedures, User Defined Functions, and other adhoc queries.• Trained team members how to use a dimensionally modeled data warehouse.

Database Developer II Retail Bank Technology, Seattle, WA 06/2008 – 06/2009• Developed Web Intelligence Reports, Crystal Reports, cubes using SSASSenior Data Warehouse Analyst Card Services Technology, Seattle, WA 01/2008 – 06/2008• Developed strategy for migrating legacy reporting database from SQL Server 2000 to 2005.• Trained & coached junior team members & contractors on database design & ETL development.Database Developer II Card Services Technology, Seattle, WA 01/2007 – 01/2008• SSIS Development• Architected & led implementation of new reporting database.• Established department standards for reporting database & ETL development.• Redesigned & automated legacy Customer Service reporting.Business Systems Analyst III Card Services Technology, Pleasanton, CA 07/2006 – 01/2007• Evaluated Business Intelligence applications, & made recommendations to management.• Implemented Business Objects XIR2, SQL Server 2005, & Oracle 10g which became the Card Services Technology SIMS (Strategic Information Management System) reporting platform.Software Engineer II Card Services Technology, Pleasanton, CA 12/2004 – 07/2006• Performed requirements gathering around Customer Service employee performance tracking.• Implemented Merced Systems platform to deliver data directly to employees allowing them to monitor their own results against goals as well as their rankings.Software Engineer I Providian Enterprise Technology, Pleasanton, CA 03/2003 – 12/2004• During ACD conversion from Nortel Meridian MAX to Nortel Symposium server insured continuous reporting for combined call centers despite mixed source systems.• Took over support of Customer Service mission critical Call Center Rep Productivity FoxPro/Excel report.MIS Analyst Providian Customer Service/Enterprise Technology, Salt Lake City, UT 03/2000 – 03/2003• Integrated & automated existing manual Customer Service Call Center MIS reporting using MS Access.

Data Analyst 09/1998 – 03/2000• Increased end-user satisfaction and enabled accurate staffing levels by developing a tracking database to identify call center trends.• Cut workload by three full time equivalents by developing a program that connected to remote sites, downloaded necessary data, and automatically produced and distributed reports.• Produced and tracked call volumes, answer times, abandon rates, efficiencies, handle times, paid hours vs. productive hours, and cost per call.Call Center Supervisor 04/1998 – 09/1998• Oversaw three departments (Directory Assistance, Operator Services, and Specialized Operator Services) comprised of 30+ team members.• Monitored performance, evaluated calls for quality control, and coached representatives. Performed job reviews, took corrective actions including warnings, write-ups, and terminations.WorkForce Coordinator 09/1997 – 07/1998• Monitored representative’s adherence to their scheduled shifts.• Monitored call center service levels, and made appropriate adjustments when necessary such as letting voluntary time off when representatives are idle and requesting that they work overtime when the call queues were extremely high.• Develop and distribute representative schedules based on historical call volumes and staffing levels.Directory Assistance Operator 03/1997 – 09/1997• Answered customer calls for directory assistance.