C A R E E R S U M M A R Y

International award-winning SAS System Architect with an established track record of creating high-performance robust analytic systems to support strategic, tactical, and operational decision making. Creator of innovative and elegant solutions. Trouble-shooter, fixer, trainer, and team multiplier. Works accurately and effectively with little supervision.

E X P E R I E N C E

Confidential

Business Analysis and Reporting Manager, Global Security and Investigation, Investigative Services, Fraud Analysis

• Performing and supporting analysis to detect fraud committed by or with the assistance of employees. Supporting analysis and ranking of alerting using historical alerts, resulting cases, and missed cases. Working on an Alert Workflow app to better close the loop on alert prioritization.
• Credit Memo analysis and alerting produced 15 terminations its first year
• Systems work
• Unix role KeON and production ID creation to enable proper segregation of our data in the SAS Farm
• SAS macros to text upon completion or only on error
• Korn scripts to better monitor and report on batch processes
• Automatic SMS notification from PC SAS jobs without using Outlook
• Data Warehouse role creation and monitoring
• Tested SAS DDE with Excel 2010
• Created of a SAS program for a workaround to the SELECT /COUNT issue that results from Teradata's implementation of column level security
• Recalled in summer 2013 to help with stand-up and migration of new SAS servers to support CCAR

Data Analysis Manager, Customer Data Initiative

• Worked to create and deliver the corporate SAS Farm
• Sized Power7/AIX LPARs to match existing SPARC/Solaris and Intel/Windows servers
• Designed the security architecture for over 1000 users exploiting the unique interaction between Unix and JPMC's version of KeON user classes and access, host group delineation, functional ID scope and restrictions
• Installed, configured, tested, and maintained ODBC drivers on the AIX servers
• Created the server naming convention
• Productionalized batch processes
• Made processing more robust by coding to automatically retry failed queries within specified time windows
• Sped up execution through parallelization of code flow
• Added automatic notification of job failure
• Other Projects
• Performed file transformations for Customer Profitability analysis related to Durbin amendment effects
• Assisted in loading Suspicious Activity Management SAM data into Aster cluster for proof-of-concept
• Organized training for SAS Enterprise Miner
• Supported Income-Asset Estimation
• Created the Customer Data Accuracy Project's Data Hub

Risk Principal Analyst, Confidential

• Primary System Architect for two generations of Consumer Risk's SAS/EBI Futrix reporting system
• Supported Chase Auto Finance, Chase Card Services, Chase Home Lending, Chase Business Banking, Consumer Risk Modeling and Analytics, Chase Commercial Banking, and the Corporate Internet Group
• Analysis using this system is credited with reducing Card fraud over 20,000,000 in the first year avoiding almost 7,000,000 in unprofitable auto loans in the first year and creating an auto loan pricing system where a lost sale is an unprofitable sale for our competitors
• Used to generate OCC required credit risk model validations and was privately described as best-in-class by the OCC.
• Developed the architecture selected the hardware designed the security for Windows and AIX
• Created techniques to allow users to access the cubes for all but the last 5-30 minutes of updating build regardless of how long the build takes functionality deemed impossible by the vendor
• Maintained and enhanced SCL code for additional statistical measures in Futrix.
• Other Projects
• Requested by IT to be on every SAS server project starting in 2007
• Trusted to perform data cleansing and transformation of WaMu home lending data for the March 2008 bid and the September 2008 FDIC offer
• Trained line-of-business administrators to design and create cubes using Futrix
• Taught modelers how to leverage SAS formats for flexible binning of independent variables in logit models a colleague received the second Big Brain award for extending this idea
• Taught modelers about resampling for confidence intervals of the Kolmogorov-Smirnov d-statistic and Point-to-Double-the-Odds statistic a colleague received the fifth Big Brain award for developing this idea
• Managed data transfers with all three major credit bureaus
• Optimized Oracle tables and indexes for cube reach through of 5-10 seconds
• Ad hoc analysis: Effects of Katrina on FICO Vintaged performance metrics
• Created automated cross-platform cube builds for OCC model validation
• Managed automated scoring for Personal Checking account management
• Managed the AIX server used by CRMA statistical modelers

Confidential

Decision Analyst

• Primary Architect for 1TB Risk Management Datamart: logical design physical design metadata design ETL architecture resulting in a high performance metadata driven ETL and reporting architecture using only SAS/Base, SAS/Macro, SAS/Access for Oracle, and Perl.
• Trained analysts on SAS
• SAS/MACRO for iterative and flexible programming
• Creating custom persistent picklists with PROC FORMAT
• Extraction strategies for our multi-terabyte DW exploiting physical layout
• Team lead for Oracle questions and issues
• Designed views in Oracle normal and materialized to enhance performance and circumvent limitations of the standard corporate reporting tool
• Optimized and designed queries for use in the corporate reporting tool
• Trained analysts on SQL topics such as correlated sub queries and Oracle's DECODE function
• Handled whatever couldn't be handled in the common tools
• Checked statuses of a picklist of 2m accounts across multiple business units
• Investigated accuracy of current householding algorithms on 24m accounts
• Complete householding of 8m accounts on a dozen link variables
• Estimated the effects of discrete policy changes on 140m transactions over a three month period
• Designed and constructed OLAP cubes measuring Call Center effectiveness Loss/Fraud tracking
• Created pilot cubes using Applix iTM1, Cognos Transformer, Hyperion Essbase, and Microsoft Analysis Services were also examined.

Confidential

Data Warehouse Analyst

• Data Modeling Star schema design Excel , creation Oracle Schema Manager , and maintenance Oracle, SAS . Loaded via automated SAS programs.
• Created a metadata driven automated daily process to extract call records as many as 69m records denormalized against ten tables including account, sales hierarchy, origination costs, termination costs, and location. The average number of records processed increased 50 while processing time dropped 20 .
• Implemented parallel processing using the Knapsack algorithm for load balancing and Oracle for interprocess communication.
• Automated and maintained 12 OLAP cubes plus recurrent flat reports plus ad hoc reports covering subjects from network routing to sales to finance
• Audit reports exceptions automatically emailed led to recovery of over 100k/mo in unbilled revenue
• Automated and maintained OLAP cubes covering historical invoice information, marketing campaign tracking customer signups, and revenue by campaign sales tracking auditing switch traffic records through conversion, rating, and billing ledger and product activity
• Recurrent flat reports included fraud auditing, customer activity, and ledger activity reports
• Ad hoc reports covered A/R, Ledger, sales performance, win-back campaign selection, responses to subpoenas, and regulatory reporting.
• Employed through 95 layoffs as company went into Chapter 11

Graduate Coursework: Decision Support Systems and Data Mining, Business Systems Analysis and Design, Database Design and Management, Business Computing Systems, The Philosophical Basis of Information Systems 4.0 GPA