Credit Risk Analytics Consultant Resume
5.00/5 (Submit Your Rating)
New, YorK
TECHNICAL SKILLS:
Languages: VBA, MATLAB, SAS (Unix and Windows), SQL, HiveQL, Unix and Linux Shell Scripting, STATA, C++, R, FTP, SFT, and SQL
Databases: Oracle, M.S Access, M.S Excel. DB2, Teradata and Sybase
Reporting Tools: COGNOS and Tableau
PROFESSIONAL EXPERIENCE:
Confidential
Credit Risk Analytics Consultant
Responsibilities:
- Creating and updating SAS and Oracle credit risk data marts that supports data elements needed for BASEL, CCAR, loss forecasting modeling, and business reporting for the Confidential - indirect/direct/reliable auto portfolios.
- Monthly analysis and reporting for auto loan portfolios for strategic initiatives and portfolio performance updates.
- Creating models that utilizes credit bureau, origination and loan data to identify high risk loans and applications.
- Designing and developing automatic SAS processes that transforms logistic regression models for consumer originations built in SQL into SAS equations to calculate likelihood of default and generate scorecards.
Confidential
Senior Level SAS Programmer
Responsibilities:- Developed, maintained and supported International marketing campaign production processes primarily based in SAS, running on UNIX/LINUX and mainframe environments.
- Developed automated daily data quality check processes, regressing testing in SAS and UNIX to remove data consistencies and fix data integrity issues in for some of the very sensitive - high priority marketing processes and emails a daily Excel report to the marketing team and developers.
- Evaluated intermediate data sources, created data mappings and variable derivation logic to aid the Extraction, Transformation and Load (ETL) strategy, design and implementation. Includes ETL across different platforms, Sybase to Teradata databases and flat files.
- Created project deliverables such as: project charter, project management plan, project scope, status reports, risk management plan, project schedule, system integrated testing reports and user acceptance testing reports
- Used Agile Project Management Methodology and Scrum to regularly translate business requirements into conceptual, logical, and physical data models.
- Built data pipelines to ingest customer data into Cornerstone, Confidential ’s big data platform and provided unstructured data mining utilizing Pig, Python, and Hive with custom UDFs on Hadoop.
Confidential
Business Statistics Graduate Assistant
Responsibilities:- Tutored over 80 undergraduate students in statistics fundamentals, more specifically multivariate statistical analysis, hypothesis testing, confidence intervals, and utilizing SAS and Excel in computing and analyzing data.
- Helped students understand SAS topics such as: PROC SQL, SAS/GRAPH, SAS MACRO facility and error debugging.
Confidential, New York
Actuarial Analyst Intern
Responsibilities:- Built a product crosswalk mapping process for all State and Federal products to help analysts work more efficiently.
- Identified and analyzed State, Federal and Medigap large claims trends in SAS and developed a dashboard in COGNOS that allows management to quickly populate large claim analysis.
- Regularly developed data gathering and analysis procedures using SAS, SQL, COGNOS, Excel and Access.
Confidential
Marketing Graduate Assistant
Responsibilities:- Designed marketing and recruitment strategies, including online media and on-campus booths, increasing enrollment by over 50%.
Confidential
MATLAB Programmer
Responsibilities:- Wrote computer MATLAB programs to extract numerical data from digital images and built a matrix model to mathematically process the image data to produce digital images with a high resolution.
- Presented the project and won 3rd place prize at the Confidential
Confidential
Mathematics and Computer Science Teaching Assistant
Responsibilities:- Assisted faculty with grading homework and tutoring students (Calculus, Differential Equations and C++).