David Misner Email & Phone Number

Peforming contract SAS and Health Actuarial Development work.

• Trained under senior plex developer for 3 months prior to assuming full responsibility for all the plex modifications, enhancements, and bug fixes for our payroll, recording, and security applications.• Assisted Service and Support in troubleshooting and resolving all customer issues with the software including being on call 24/7 to resolve payroll posting issues for our county customers to ensure the county employees received their paychecks on time.• Coded and Alpha tested five major versions and eighteen ptf’s for our payroll application.• Coded and Alpha tested three major recording versions and four ptf’s for our recording application.• Coded and Alpha tested one major version and one ptf for our security application. In addition, coded and alpha tested 3 versions of our web security application.• Maintained all applications within the plex model framework ensuring that all group models were kept up to date and that other class libraries accessed by my application updated by other developers were extracted when needed and assimilated into the local plex models.• Utilized the CM First diagramming tool, Evolve IT, provided to diagram our payroll model to help understand and document program flow and key processes including the payroll creation, payroll posting, and PERSI retirement contribution calculations. Also, used Evolve IT to ascertain what tables were being updated in the financial model from the post payroll process in the payroll model.• Created and maintained all the SQL Scripts to update all tables/views associated with each version and ptf deployed.

New York, Ny, Us

Primarily lead risk model validations and support other model governance tasks for the Auto and Student Loan Business. The role requires expertise in methods and metrics used for performance assessment of various types of risk models used in loan originations, loan pricing, loss forecasting, and collections. Responsibilities:• Conduct ongoing performance assessment of models and ensure adherence to the firm-wide model risk policy.• Provide critical support in migrating model management and governance processes to a new generation model management platform.• Document, streamline, and automate model validation codes and processes.• Participate in cross-business efforts to ensure adherence to model control and compliance requirements• Provide project management support to modeling teams to ensure timely response to requests from regulators, internal audit, model governance and control groups.• The incumbent will validate various data processes and sources that can affect model performance. • Provide reporting on model inventory and issue tracking.

Toronto, On, Ca

Tutoring High School and College level Algebra, Geometry, Trigonometry, Calculus, and Statistics.

Providing Actuarial and Analytical services for local businesses.

Minneapolis, Mn, Us

Developed enterprise wide weekly production application to identify purchase and participation in core financial products, determine eligibility, match those clients to any clients in the household owning a master card of debit card and prepare transactional file to deliver to 3rd party service to post rewards points to client rewards accounts to reward them for their non-spend behaviors.

Seattle, Us

Evaluated existing customer segmenting model written SAS Enterprise Guide and modified this model to be run on a monthly basis as opposed to annual.

Minneapolis, Mn, Us

Provided training and support to list campaign team in India to implement Enterprise Rewards Production Application.

Developed and operated online/onsite computer repair business with my son as partner to service local clients in the Treasure Valley. Responsibilities included planning, marketing, customer service, and actual technical work on windows based pc’s and small home and business networks. Currently, my son and another partner continue to operate this business.

Minneapolis, Mn, Us

Developed automated process to generate Bank Opportunity List Engine data mart from existing corporate data warehouse and various Bank data feeds. Data Mart used extensively corporate wide by other analysts greatly enhancing their productivity as the restructured and highly summarized data greatly reduced amount of coding and run time necessary to complete typical corporate analytical requests.Developed enhanced SAS/AF Bank Opportunity Report application to include opportunity reports for lending, trust, and credit card products either on a individual financial advisor level or at various reporting levels within the financial advisor reporting hierarchy such as Branch Manager, Vice President, etc. Included ability to produce reports to view opportunities by geographical region such as state and marketing regions. Developed advanced SAS/AF application to summarize Ameriprise Client Personal Trust Information from Account to Client and Advisor Level to be utilized for identifying and targeting Financial Advisors and their Clients with various types of sizeable Personal Trusts in place or those with sizeable Non-Qualified Assets with the potential to convert to a personal trust. System could generate ODS presentation style tabular and graphical Opportunity reports at Marketing Region, Area Office, Group/Field Vice President, or at single Financial Advisor Level.Developed SAS system to analyze successful captive financial advisors hired in relation to demographical data collected during hiring process to develop a profile of candidates/applicants that would be most likely to succeed as a financial advisor to enable the company to reduce the cost of acquisition of new financial advisors.

Developed data cleansing and conforming procedures applied to customer and address table data which was implemented as MS SQL Stored Procedures, Triggers, and DTS jobsModified existing storefront.net VB.NET source code business logic such as application of coupon discounts, free shipping rules, etc. to correct original developer’s in business logic dll modules Conceptualized and initiated work on E-Commerce Business Intelligence system to ETL data into warehouse with star schema design, using SAS, MS SQL 2000, and Data Transformation Services. Back end ETL system was built with SAS to extract, cleanse, and conform data from ms sql data base to populate data warehouse. Warehouse was refreshed on weekly basis with new customer and order information. Installed, configured, and maintained back end MS SQL 2000 data for online store front. Included utilization and mastery of tools such as Enterprise manager, Analysis Services, and Data Transformation Services to maintain database and support BI reportingPlanned, designed, built, configured, and maintained company website complete with integration of 3rd party .NET shopping cart application.Implemented and maintained numerous marketing channels to drive business to company website, such as Google and Overture pay per click ad campaigns, web page optimization for top ten natural placement in search engines, and opt-in email marketing campaigns.Performed daily operational tasks including order processing/fulfillment, purchasing/receiving, customer service including answering customer phone calls, emails, and order inquiries, resolving any customer issues, etc.Installed, configured, and maintained two Windows 2003 Servers for conducting E-Commerce business.Founded XylitolStore.com and set up all E-Commerce operations to online retail business venture of selling dental health products on the internet

United Heritage, Gem State, and Twin Falls Mutual Clients:Served as Opining Actuary for several Property and Casualty client companies certifying adequacy of loss reservesMaintained and utilized MS Excel Loss Reserving model for Property/Casualty insurance clients to perform estimation of IBNR (Incurred but not reported) liability, reviewing trends and making adjustments as necessary.Developed complex model in MS Excel to perform property/casualty actuarial loss reserving on a traditional paid and reported basis for P &C ClientsDeveloped complex SAS code to read detail property and casualty claims data in ascii text and excel spreadsheet format. SAS code developed cleansed and conformed data to populate ms excel spreadsheet containing P/C loss reserving model replacing manual method of input and reducing data errors and delivery time of IBNR estimatesBlue Cross of Idaho Client:Installed and configured SAS/CONNECT running on 3-Tier architecture(mainframe, windows NT server, windows 2000 clients) to complete populating of SAS Data Warehouse residing on windows NT Server from mainframe warehouse data store and to enable actuarial and business analysts to take advantage of SAS client/server architecture to run their SAS ad hoc reporting jobs against the data warehouse and have them execute more efficiently on the NT server where the data repository residedPioneer Financial Services Client:Developed web enabled thin client OLAP front end for remote actuarial users to access rating and loss experience business measures and explore these measures across business dimensions such as geographic location, insured demographic info and plan definitions. Utilized SAS Business Intelligence Tools for development, specifically SAS, SAS/MDDB Server, SAS/INTRNET, SAS MDDB Report Viewer, and SAS Application Dispatcher. Project included design and implementation of MDDB cubes including definition of fact and dimensional layout and all drill down hierarchies.

Managed staff of two actuarial assistants and directed them in their efforts to provide analysis in support of the company pricing, financial reporting, and experience monitoring functionsDirected project to develop initial Business Intelligence specifications for company wide Data Warehouse for Small Employer Group Major Medical business, directing a staff of AS400 programmers to develop ETL system in RPG to extract data from legacy systems and populate the data warehouse on a monthly basisCoordinated project with IT Services Director to research and review various group major medical admin software systems made purchase recommendation to upper level managementResponsible for summarizing actuarial items such as policy and claim reserves and working closely with accounting department to ensure all information was provided on a timely basis to complete Exhibits 8-11 for financial reportingDeveloped numerous complex spreadsheet analysis applications in Quattro Pro to perform summary of loss experience to support consulting actuaries pricing of the small group major medical productProject leader to perform major system conversion of company life insurance administrative and reserve valuation systems from IBM Mainframe to AS5400 platform

Math/Statistics

Bachelor Of Science (Bs), Math/Statistics