James Napier Email & Phone Number

Pine, Az, Us

Phoenix, Arizona, Us

Operations audit, reporting, robotic process automation utilizing SSIS, SSMS, TSQL, PowerBI and Azure Data Studio Notebooks plus tracking FTE savings in SQL and PowerBI. Developed systems for Portfolio Risk Tracking, Bank Stress Testing, Data Governance, Enterprise Data Warehouse, Loan on-boarding, Banking Wire Limits, Treasury Management Services, Operations Risk Modeling (SAS and SQL), SAS administration, CECL configuration. Regularly attended and provided insights with our in-house user groups for SAS, Tableau and Analytics forum.

Tempe, Az, Us

Optimized and published simulated cancer tumor evolution via Stickbreaking Epistasis thru first detection, chemo and second detection events and analytics using Spark/Scala/Hive/bash, reducing compute time from weeks to minutes and allowing orders of magnitude larger tumors (https://bitbucket.org/ngcc/tumorsim). Animated visualizations of tumor growth with Tableau (https://public.tableau.com/profile/james.napier#!); static visualizations with Excel, Tableau, and Phylogenetic trees via Hive/json and d3.js. Co-developed Expression Quantitative Trait Loci genomic pipeline for breast cancer to a newly designed Hadoop Cluster utilizing bash scripts, python, MapReduce and Spark/Scala from initial TCGA downloads thru full statistical analysis, reducing time to complete from several months to one day. Enabled researchers to view and analyze various genomic formatted datasets with Hive, Hue, Ambari, SparkR, SparkSQL, PySpark. Acting manager of the Next Generation Cyber Capabilities development team: managed several contractor developers, vetted potential open source distributed software for cancer research and engaged multiple vendors for software, service and support. Developed analytics platform for World Health Organization and Nursing combining Excel and Redcap survey data into CouchBase. Developed social networked graph to identify highly correlated breast cancer gene candidates for further analytics, utilizing Hive and visualized with NodeXL. Supercomputer cluster utilization visualizations utilizing Tableau desktop/server, MySql and Linux scripting. Entry level experience with cloud Azure (Hadoop, Scala and Machine learning studio) , AWS and Penguin On Demand (HPC) via Research Computing cloud seminars. Optimized SAS code for several research projects.

Scottsdale, Arizona, Us

Trained entire team on Hive and SAS programming efficiencies. Standardized data transfer, storage, code documentation, merge key formatting and efficient processing utilizing SAS and Hadoop clusters saving orders of magnitude in compute time. Developed credit card Point of Compromise evolutionary model and multi-bank common point of purchase logics. Created Id Confidence score logic and variables for government programs (DOT, Dept. Labor payroll, tax fraud) and banking (new and existing accounts). Designed and developed new fraud network/graph encoding and identity matching framework. Visualizations via SAS and Excel.

Minneapolis, Mn, Us

Developed enhanced Financial Advisor Opportunity Manager data warehousing and tracking for analytical, modeling and ad-hoc executive scorecard. Provided ad-hoc analytics with SAS and Excel programming support for Ameriprise Information Management team. Designed and developed Auto and Home Insurance text mining and analytics for early warning and routing of damage severity and loss. Heat map visualizations of potential training and sales opportunities via Excel VBA/Pivots. Three month contract extended to 11 months.

Phoenix, Az, Us

Banking regulation required porting Student Loan modeling data and code from PC SAS to Enterprise Guide connected to Oracle servers over virtual secured Citrix connection. One month contract completed early.

New York, Ny, Us

Risk Information Banking / OPEN Decision Science / Customer Management ModelingSmall Business customer management risk modeling analytics and programmingBusiness Solutions: Designed and developed in-depth customer, geographic and industry risk and economictrend analytics and monitoring to bolster short term risk model scores (patent pending); developed utility solutions for modeling automation, missing replacement and variable selection as well as dependent variable creation from time series performance data; developed credit decline reason code logics to address legal decline letters; developed and optimized cost/benefit economics optimizations for point of sale authorizations for both small business and corporate systems; developed machine learning algorithms to optimize lending line assignment, case review triggers, risk probability confidence intervals; automated corporate collections and acquisition response models. Visualized optimal credit line assignment function development via 3D chemical modeling java classes and SAS.Technical Solutions: SAS programming support and mentoring, Monte Carlo simulations, swap-set analytics, trend monitoring, genetic algorithm optimizations, search algorithms, data mining, automated logistic bootstrap modeling, complex relational data merges and pattern matching.

Co-developed auto insurance finance package in CLIPPER linked to MAS90 accounting system, full banking audit reporting over 130 reports, full GUI data entry and reporting systems included Novel Networking, database administration, auto-db-error-correction, full printing solutions, bar code printing and scanning, AI fax colony. Additional finance packages developed for misc asset financing, auto financing, roadside assistance, selling contract pools to banks for additional revenue, sales commission tracking, and extensive systems documentation.