Ed Confer Email & Phone Number

Mount Pleasant, Sc, Us

• Develop analytical solutions in SAS using Data Step, PROC SQL and Macro language to automate error-checking and email notification of reconciliation or issues with SAS production jobs.• Oversee all SAS daily and monthly processing and leverage SAS knowledge to convey to business analysts the methodology required in new enhancements to current production jobs.• Partner with business and technical architects within Agile front-end development to disseminate complex SAS production code for conversion of SAS ADHOC reporting to new software tool for business and offer areas where improvements could be made. • Collaborate closely with cross-functional teams to ensure data quality of reporting from SAS jobs run on LINUX. • Modify and update 75+ Stop/Loss Insurance SAS programs in order to reclassify claim payment data for Non-Independent Blue Cross clients.• Unit test development code and deploy programs to Test and Production environments through CI/CD pipeline.

Coastal Analytics and Programming, LLC has been consistently providing quality SAS Software solutions and quantitative services focusing on automation, macro designed end to end systems, reporting, analysis, macro engineering, large volumes of data extraction from database systems and systems testing. As Owner and principal, Ed Confer has 25 years of SAS software experience in a variety of industries and has provided SAS solutions to numerous Fortune 500 clients.

Herndon, Virginia, Us

• Created Vizio schematic diagrams and data integration workflows derived from SAS production jobs in support of conversion from SAS to DataStage software for existing OPM health care claims programs. • Programmed SAS Proc IML interface to R using SAS Macro Language to create multi-facet R software time-series plots using R GGPLOT for National Mortgage Database (NMDB) for FHFA. • Utilized Microsoft SQL Server Studio to program complex table joins and utilized temporary table construction to create left-join template of total summarized categorical data for OMWI reporting within FHFA.• Developed and implemented SAS code in Viya 3.5 for revisions to FHFA Housing Price Index algorithm incorporating X12 Census Bureau seasonal adjustments modeling.• Designed and implemented SAS Graph bar charts and box plots for FHFA on-line dashboard.• Developed code in Python to create FHFA housing analytics and reporting tools for economists.

• Refactored 20+ individual SAS programs to streamline ETL and data transformation of Disney Theme Park admissions and promotions data into one SAS program resulting in delivery of reports to upper management in minutes versus hours • Developed an automated and dynamic SAS program using SAS Macro, PROC SQL and Data Step to extract and process daily Disney Cruise Line customer survey data from SQL Server database to quantify and publish metrics of all survey results directly to Excel worksheets.

Lincoln, Nebraska, Us

• Lead effort and participated in conversion (prior to acquisition by Nelnet), of Great Lakes Student Loan’s 400+ Mainframe SAS programs into Python.• Utilized Jira software to construct agile development project plans in order to organize tasks, workflows, and reports for ongoing conversion.• Developed code in Python and collaborated with business to ensure understanding of new software systems.• Designed and coordinated testing and regression analysis for rigorous file and report comparisons on Windows and Mainframe.

• Developed SAS programs to generate oncological/statistical analyses (e.g., tables, listings, figures, graphs and other statistical output) to illustrate longitudinal patterns of cancer drug therapy.• Extracted and ensured data quality of oncological metrics pulled from data sources including clinical study databases with IMS prevalence and incidence, CMS Medicare and Wolters Kluwer drug information using Base SAS software.• Produced benchmarking metrics integrating such factors as physician specialty, drug volume, incidence, prevalence, and various demographic classifications in order to validate plots and table illustrations.• Ensured the validation and quality assurance of the output by independent programming of SAS Macro code to generate dynamic QA results thereby eliminating the time-consuming and error-prone manual checks.• Built an extensive Macro library to create efficiencies in the process of writing multiple SAS PROC GPLOT graphs.• Utilized SAS Graph software to construct Kaplan-Meier Box and Waterfall plots detailing patient progression through multiple lines of therapy.

Charlotte, Nc, Us

• Delivered SAS Macros and provided technical assistance to analysts at Bank of America who supported the marketing campaigns of customer retention vis a vis attrition.• Built and optimized multiple joins of account and demographic data using SAS/Teradata Pass-Through SQL to extract specific information associated with marketing initiatives from tables containing 500 million plus rows of data. • Responsible for confidentiality of account information per operational guidelines for privacy of sensitive information.• Created Excel waterfall reporting for determining the universe of accounts included or excluded in marketing outreach.

New York, Ny, Us

• Delivered an end-to-end Model Risk Management MRM (Dynamic Scoring Engine) utilizing SAS Software and SAS Macro language on a UNIX platform in support of a G-SIFI CCAR/CECL mandate for Consumer Credit Cards.• Provided technical documentation, validation, and inventory control for all Transitional Matrix Model development.• Developed independently a “glass-box” front-end driver to bundle efficient SAS Software source programs.• Built automated predictive model, dynamic transition matrix formulas, compound, and dynamic transformations of macro-economic variables, scoring programs and automated conditional probabilities on multinomial and binomial distributions.• Constructed SAS Macros in order to automate and facilitate the calculations of forecasted data based on current and future economic metrics including Housing Price Index, Unemployment Rate, GDP. • Guided SAS programming in CCAR model development toward construction of dynamic transformation of economic data and probability factors to enhance model efficiency and quality.

Washington, Dc, Us

• Optimized process for calculating GDP, employment metrics and coastal economic reporting for census tracts and geographic areas by developing and building automated and dynamic parameter-based SAS code.• Collaborated with NOAA Office of the Chief Economist and Bureau of Economic Analysis (BEA) to create a prototype Ocean Economy Satellite Account (OESA) to better track creation of income, revenues, wealth, and other economic factors that depend on the resources of the oceans and Great Lakes.• Constructed SAS programs to build American Community Survey data through the refinement, translation, and revision of existing programs.• Developed complex process utilizing SAS to dynamically create reports based on file contents of Microsoft Excel look up files and mapping of economic data across file structures in effect reducing manual lookup and data entry.• Built workflow documentation of all input files, output files, SAS Macros and other processes used in macro development.• Contributed to the conversion of all Coastal and Oceanic Economies SAS programs into Python.

Developed SAS automated report process to replace Business Objects system on UNIX / AIX Platform.Created methodology to allow flexibility in report parameters among 900+ reports on a monthly basis. Designed and coordinated all facets of SAS Software automated reporting process.Built front-end matrix tool utilizing Microsoft Access software.Programmed ad-hoc reports for Major Accounts Consulting Group (MACG) and agents of Blue Cross / Blue Shield of Florida.Maintained Monthly / Quarterly Production cycle and submitted reports to staff via Mainframe and UNIX platforms.