John Markham Email & Phone Number

Louisville, Ky, Us

Fort Knox, Ky

Design and write queries against large and complex Army databases to obtain data. Design and write complex and advanced code to analyze and report information. Design and produce high level summary reporting for Army leaders to facilitate decision making. Perform ad-hoc analysis and reporting to answer questions from customers and stakeholders.

Dallas/Fort Worth Area

Produced standard reporting to guide loan origination, credit risk and operational risk business decisions for auto loans portfolio. Performed ad-hoc analysis to answer questions from business owners and stakeholders to mitigate credit risk and loss, and improve business performance of loan portfolio. Made changes to standard reports using complex and advanced SAS and SQL code. Collaborated with team members, other business units and stakeholders.

Cincinnati, Ohio Area

Maintained and improved risk-adjusted financial models and cash flow models used to calculate interest rates on consumer loans. Assessed risk, credit quality, underwriting characteristics and performance of consumer loan portfolios. • Estimated portfolio credit loss and delinquency for use in hold for sale decisions and loss reserve adequacy.• Analysis of loan performance led to sale of portfolio with ROI of 12%.• Reduced processing time 75% for standard reporting by conceiving and developing new process. • Queried large, complex relational databases.

Cincinnati, Ohio Area

Provided professional services to clients to deliver business solutions and improve business performance. Collaborated with clients, team members and other business units to define and achieve business goals. Developed and managed strong professional relationships with external clients. Selected, recommended and applied most appropriate analytical and statistical methodologies to achieve objectives of client project.• Designed, developed, validated and managed enhanced reporting system for client that reduced expenses $175,000 annually. • Developed customer relationship management analysis for client which increased revenue $32 million annually. • Conducted multivariate analysis, quantitative methodologies, sampling techniques, experimental design and predictive modeling. Queried large, complex relational databases. • Created and presented standard and ad-hoc reports, summarizing results and recommendations to non-technical, managerial and executive audiences to facilitate business decision-making.

Indianapolis, Indiana Area

Performed analysis, data mining and reporting of health insurance issues. Developed, programmed and executed complex analyses concerning patient, hospital, physician, claims and reimbursement issues. Analyzed large, complex relational databases to distinguish patterns, trends and relationships. • Reduced processing time 50% for standard healthcare reporting by conceiving and developing new process.• Established and maintained knowledge of data warehouse database design, metadata, data definitions, measures, metrics, calculations and data integrity issues. • Designed and built queries for standard and ad-hoc reports.

Greater Chicago Area

Provided professional services to clients to deliver business solutions and transform clients into high-performance businesses. Collaborated with team members, other business units, and clients to define and achieve business goals. Selected, recommended and applied most appropriate analytical and statistical methodologies to achieve objectives of client project.• Designed and conducted analyses using predictive modeling, multivariate analysis, probability, sampling, inferential statistics and other quantitative methodologies to provide services to clients. • Increased client revenue $18 million through determination of key drivers of business.• Designed, developed, tested, and implemented new process for standard reporting system. Reduced processing time 50% per report, increased accuracy and reduced errors.• Wrote ad-hoc and standard reports. Presented results and recommendations of reports to non-technical, managerial and executive audiences to guide decision-making.• Queried large, complex relational databases. Ensured data integrity and data quality, resolving data issues.

Certificate Program In Accounting, Accounting, 3.7

Activities and Societies: Beta Alpha Psi

Bachelor Of Arts, Political Science