SUMMARY:

• Over 15 years of experience in providing data analysis, data validation, data integration/ETL, data mining, predictive and risk model development/implementation/validation/monitoring, project management, business requirements gathering, technical design and solution architecture, business intelligence(BI) and risk management reporting, development and support of analytical data marts, application development, unit/SIT/UAT test support, production support in the financial, healthcare and P&C insurance industries.
• Strong skills in providing development and analysis of various data using statistical methods and creating analysis reports to give better insight to business partners.
• Expertise in programming using the Python(Anaconda), R, SAS (GRID v9.4 and down), BTEQ and various RDBMS which includes DB2, Oracle, Teradata on UNIX, Windows and mainframe platforms. Proficiency with Base SAS and SAS Enterprise Guide. Solid experience with other software including COBOL, JCL, UNIX shell scripting, Gupta/Centura SQL Windows, PL/SQL and Informatica Power Center.
• Experience use of version control management GITHUB at an enterprise level. Experience working in an Agile environment and using Kanban methodology and VersionOne software to manage and prioritize work and deliverables.
• A very efficient, effective, self - motivated team player who is known for methodical analysis and problem-solving skills, ability to discuss reasoning and giving comprehensive answers and arguments, initiative, creativity and attention to detail, ability to communicate effectively through all levels of the organization and different business units, high desire to develop and learn, ability to deliver high quality critical projects from inception to transition on time. A very good mentor to team members who are junior to the team or someone from the business side.
• Completed the Python Programming and Data Scientist courses from Coursera and Google and COU Big Data Academy (2015, 2016)
• Completed the SAS Platform Administration Fast Track, SAS Business Intelligence Fast Track and SAS Data Integration Fast Track training courses at SAS Institute. SAS Tools learned are the DI and BI suite of products like Data Integration Studio, DF Power, Information Map Studio, SAS OLAP Cubes, Web Report Studio, Management Console, SAS Enterprise Guide in BI Platform and SAS Microsoft Add-Ins. Learned how to manage the Metadata Server environment thru SAS management console. (2011)

SKILL:

SAS:: BASE, GRID, PROCs like MEANS /SUMMARY/ TABULATE/ SQL/ REPORT/ UNIVARIATE/ FREQ/ PRINT /GCHART/ GPLOT, DATA STEP, HASH TABLES, ARRAYS), GRAPH, Macros, Functions, SQL, SASIntrnet, ODS, SAS Connect, SAS Enterprise Guide, SAS Studio, Parallel Processing SAS Data Integration Studio, DfPower, SAS Information Map Studio, Web Report Studio, SAS OLAP Cube, SAS Microsoft Add-Ins

RDBMS:: DB2, Teradata, Netezza, Oracle, Informix, Sybase, MS Access

Others:: GITHUB, Centura SQLWindows, MS Office Products, Rational ClearCase, ClearQuest, Visio MicroFocus/Merant COBOL, COBOL II, JCL, MVS TSO, VSAM, FileAid, SYNCSORT, Expediter, AbendAid, ENDEVOR

EXPERIENCE:

Confidential, Richmond, VA

Consultant, Data Analyst

• Work as member of the AML Data Infrastructure and Analysis team responsible for the development and maintenance of AML daily and monthly processes that includes over 30 models and controls reporting that are used to detect any suspicious activities of Confidential customers, identify High Risk Customers which require further investigation and other AML compliance initiatives using Python, SAS, Oracle, BTEQ, Teradata, Tableau and GitHub in a Unix environment.
• Developed and established automated processes used to monitor and control the AML DIA team’s utilization in development and production environments in Teradata and SAS Server with over 50 active users.
• Worked with the Customer Risk Rating business managers and investigators to help analyze data that are related to Consent Order and Internal Audit investigations. Help establish and develop and implement resolution.
• Validate, identify issues from the model process or data and work with the Model Development and Business and Technology team to work on a resolution
• Identify areas in the Model process including business validation where efficiencies can be gained through automation and make recommendation and develop a solution
• Tools used are SAS9.4, Oracle and Teradata SQL, BTEQ, Shell and Python scripting for data and process analysis. Enterprise Github for version control and code management.

Confidential

Lead Data Specialist/Scientist Contractor

• Work as part of the Science team responsible for the design, development, testing and documentation of data mart that bring together data from disparate sources which makes it available to other data scientists, front end developers and claims processors using SAS, Python, R and Oracle and DB2 and Netezza SQL for the ETL process
• Responsible for the development and implementation of predictive models which drives the capabilities within P&C to improve claims processing and operations, reduce losses, development of a reliable data mart used to build predictive models and frontend process on
• Responsible for the conversion from Oracle to Netezza for all Claims source queries and its successful integration into the ETL process. Worked with Netezza DBA to make the process IDs work in the new Netezza datamart.
• Collaborate with actuarial, claims, operations and technology teams to develop new ways to improve analysis and use of existing data and exploration of new data sources be it internal or external. Work with the more senior data scientists in the team to work on the improvement of predictive modeling within the P&C
• Responsible for analysis of new data sources, architecting the in corporation of such sources into existing ETL process and providing data insights to business units and their respective management

Environment: SAS, SAS Enterprise Guide, SAS Studio, SAS ODS Graphics Designer, Python, R, SAS 9.4 (GRID, Parallel Processing, Macros, PROCs, ODS, Graph, STAT, Base, Hash Tables, Connect, Access, SQL, PC, UNIX), Netezza, Aginity Workbench, DB2, Oracle, Putty, WinSCP, SQL Developer, DB2 Data Studio, MS Excel

Confidential

Solutions Delivery Manager

• Worked as the project lead/technical lead for Health Information Exchange (Healthcare Analytics)
• Involved in the full SDLC of Information Management (IM) Healthcare Information Exchange Affordable Care Act implementation projects within Anthem.
• Responsible for implementation of the predictive model - Risk Adjustment Scoring Algorithm (RASA) that predicts the risk of an enrolled member and will be used by various Actuarial groups within Anthem to drive their pricing strategies and provide insight of what risk scores are expected from the Department of HHS.
• Worked with the Actuarial management and Anthem lead to understand the business requirements. Attended HHS/CMS REGTAP conferences to understand the Risk Adjustment Score algorithm better.
• Developed high level and detailed technical design including a solution process flow of the application process.
• Worked as the lead developer for the project responsible for the development and implementation of the application consisting of SAS and SQL programs using SAS Enterprise Guide 6.1, BASE SAS, PROC SQL, DB2, BTEQ,Teradata SQL, SAS Connect, SAS Access, macros and functions
• Performed data profiling and data mapping and work closely with the EDW team involved in the ACA project to identify the new data elements and values for the ACA data.
• Managed the delegation and status of tasks and deliverables assigned to a group of SAS and ETL developers
• Developed unit test case document, executing test scenarios and scripts that address areas such as application scenarios, integration and regression testing, negative testing, error or bug retests, or usability
• Responsible for the creation of the project timeline and cost estimation using a Confidential internal project management tool and work with Anthem management and PMO as adjustments are made due to delays
• Provided support to the SIT and UAT teams to resolve issues or defects discovered while testing.
• Performed deep dive analysis of the data and processes in relation to the requirements and issue(s) discovered by the SIT and UAT and provide insights on possible scenarios and resolution.
• Provide support to the Informatica/ETL team during their SIT and UAT test by running and monitoring some of their workflows
• Continue to develop professionally by taking courses available within Confidential like Informatica PowerCenter 9.1 and Project Management Study for Certification program.

Environment: Informatica Power Center, BTEQ, SAS Enterprise Guide, SAS 9.4 (Macros, PROCs, ODS, Graph, STAT, Base, Connect, Access, SQL, PC, UNIX), DB2, Teradata, Teradata SQL Assistant, ReflectionX, MS Excel, VBA, Windows XP/2008

Confidential, Richmond, VA

Consultant, SAS Application Architect

• Responsible for providing data analysis, programming and business intelligence reporting to support the Statistics Infrastructure BASEL Team at Confidential
• Develop, implement and maintain SAS programs using SAS Enterprise Guide 5.1, BASE SAS, SAS GRAPH, PROC SQL, BTEQ,Teradata SQL, SAS Connect, SAS Access, macros and functions to support the statistical modeling and metrics report generation in the development and implementation of forecast models used for BASEL II.
• Worked with data steward and data warehouse teams to identify and document gaps and to perform data analysis based on requirements for the forecast model against the BASEL data warehouse. Created lists of gaps discovered and worked with data warehouse to prioritize the changes to be done
• Perform analysis of the model to identify issues and work with the statisticians to understand the intent and work on resolution
• Identify and document the requirements for the BI report to monitor the performance of the models as a whole and by segmentation and its attribute

Environment: SAS Enterprise Guide 5.1, SAS 9.2 (Macros, Procs, ODS, Graph, STAT, Base, Connect, Access, SQL, PC, UNIX, mainframe), BTEQ, Teradata, JCL, TSO, InfoConnect, Teradata SQL Assistant, MS Excel, VBA, IBM mainframe, Solaris, Novell, Windows XP

Confidential, Richmond, VA

Credit Metrics Analyst/SAS Analyst

• Responsible for the development, management and maintenance of the ETL process that produce data feed (presentation layer) into a centralized repository called the Datashare that is currently used by the Credit Risk Department and other departments like Audit, Finance, Quality Control, Default. These data feeds include mortgage, economic data, credit card and student loans. The ETL processing is done in SAS and input sources varies from SQL (DB2 or SQL Server) to flat files (vendor sourced or mainframe) to excel files and it’s pushed into SQLServer.
• Part of the SAS Admin team responsible for developing and maintaining the metadata environment in the group. Provides technical assistance to the analytics users when using the metadata in the SAS EG. Some of the tasks include adding new users or groups, libraries, SQL connection to the metadata; working with the SunTrust central SAS COE group to test new product installs like the Microsoft Add-Ins or the SAS EG 4.3.
• Responsible for providing data analysis and reporting support to the Credit Risk department for Mortgage and Student Loans LOB that involves some intensive data research and simulation
• Build reports used in the monthly earnings deck for the Credit Risk.
• Build automated SAS modules used to extract data from various sources, perform data quality checks, perform various transformations, and loads to SQL Server.
• Develop and maintains SAS programs using SAS Enterprise Guide 4.2, BASE SAS, SAS GRAPH, PROC SQL, SQL Server2005, DB2, SAS Connect, SAS Access, macros and functions to generate additional monthly reports needed for credit analysis of the mortgage portfolio.
• Provide data analysis support to different LOBs like QC, Finance or Audit or teammates as needed performing adhoc requests.

Environment: SAS Enterprise Guide 4.3, SAS Management Console, SAS Microsoft Add-Ins, SAS 9.2 and SAS 9.1.3 (Macros, Procs, ODS, Graph, STAT, Base, Connect, Access, SQL, PC, UNIX, MVS Mainframe, JCL), SQL Server 2008 and 2005, DB2, Oracle, MS Access, MS Excel

Confidential, Richmond, VA

Consultant, Sr SAS Data Analyst

• Responsible for providing data analysis, programming and business intelligence reporting support to the Small Business Statistics Team at Confidential
• Develop and maintains SAS programs using SAS Enterprise Guide 4.2, BASE SAS, SAS GRAPH, PROC SQL, Teradata SQL, SAS Connect, SAS Access, macros and functions to retro-score credit bureau data for different predictive and decision-based models used by Small Business and perform dual validation process for these models for Small Business to satisfy Model Governance requirement
• Develop SAS programs using SAS Enterprise Guide 4.2, BASE SAS, ODS, SAS GRAPH, PROC SQL, Teradata SQL, SAS Connect, SAS Access, macros and functions to pull production data and produce HTML based reports that shows trend and performance by monitoring the population stability index and validity of the different predictive and decision-based used in Small Business Card and Lending.
• Responsible for providing monthly analysis/trending of delinquency and charge-offs in the Small Business account portfolio in relation to the models used for decisioning.
• Develop SAS programs, JCLs and shell scripts to validate data produced by the 3 credit bureaus and model scores that the outside vendor produced for the risk model for Small Business
• Develop various SAS programs, JCLs and shell scripts that extract data from different sources like data warehouse that is Teradata environment, mainframe, and Unix platforms using SQL-pass-thru, SAS Access LIBNAME, PROC CIMPORT and DOWNLOAD, JCL and Unix scripts.
• Provide data analysis and data management support from development to post production phase to all the statisticians in the Small Business Lending group as various risk or response models are developed. This is to ensure the correctness and quality of the data used in the models.
• Provide programming support to the Small Business and Solutions(Lending) team and other Credit card team members (i.e. a total redesign of all the model monitoring report process for the Lending which included development of a more efficient data pull code and conversion from a manual (Excel/Pivot tables) to automated (html based graphs) process of producing the reports).
• Provide SAS support to different Line of Business groups as needed
• Provide technical and business mentoring to team members who are junior to the statistics team or to someone from the business side whether it’s SAS related or some business process.
• Provide assistance to the SAS manager as the need arises (i.e., she’s on vacation) to manage assigned projects effectively making sure each milestones are met on time, delegate business adhoc requests effectively to other 2 team members so as not to impact major projects’ timelines
• Provide data management support to the Small Business and other LOB analysts such as creating SAS datasets, Teradata tables and/or flat files and develop various distribution reports using SAS scripts for their risk analysis use.

Environment: SAS Enterprise Guide 4.2, SAS 9.1.3 and SAS 8.2 (Macros, Procs, ODS, Graph, STAT, Base, Connect, Access, SQL, PC, UNIX, mainframe), BTEQ,Teradata, JCL, TSO, InfoConnect, Teradata SQL Assistant, KEA X, MS Access, MS Excel, VBA, IBM mainframe, Solaris, Novell, Windows 2000

Confidential, McLean, VA

Consultant, SAS Technical Analyst

• Analyze and gather data requirements based on TAS conversion requirements.
• Prepare technical documents including Business Requirements Specification, Rational Model (Activity) Diagram, Unit and UAT Validation test cases and scripts and Deployment diagrams supporting TAS conversion from development through testing to production.
• Develop technical design of process based on use cases.
• Develop SAS programs using BASE SAS, SQL-pass-thru, LIBNAME, PROCs, macros and functions and scripts (JCLs or UNIX shell) to extract from DB2 UDB tables, then transform and load these data back to the data warehouse.
• Develop SAS programs using BASE SAS, SQL-pass-thru, ODS, macros and functions to generate reports that are delivered in HTML and CSV formats.
• Execute unit testing and technical support for Test Team ensuring standards are met.
• Liaison with Corporate Tax group endorsing integrity of design and technical requirements.
• Design and develop UAT Reports for Corporate Tax group validation of data accuracy and integrity.
• Perform initial technical OLAP analysis reporting requirement mapping on old and new system.
• Develop SQL queries to extract, insert or update tables and generated data reports for the Securitas Operations Redesign project.

Environment: SAS 8.2 (Macros, Procs, ODS, Base, Connect, Access, SQL, mainframe), DB2 UDB, JCL, TSO, Hummingbird, DB2 Command Center, ClearQuest, Visio, Rational Rose, DOORS, MS Access, IBM mainframe, Solaris, Novell, Windows 2000

Confidential, Richmond, VA

Consultant, Senior IS Analyst

• Responsible for all data requirements gathering and technical analysis for the GF financial reporting process and producing the technical requirements used for development. Performed data mapping of the old system with new SHAW system by working closely with business users.
• Performed analysis and created technical documentation to support production of financial reports used by Corporate Accounting, other global finance teams and various business groups.
• Provided analysis and programming support for development and implementation using SAS (BASE SAS, ODS, PROC SQL, Macros and functions) and MS Access.

Environment: PC SAS 8.2 (Macros, Procs, ODS, Base, SQL), Oracle, SQL, MS Excel, MS Office 2000, MS Outlook, MS Excel Pivot Table, Novell, WindowsXP

Confidential, McLean, VA

Consultant, Senior Technical Analyst

• Developed data mining, ETL process and BI reports to monitor mortgage loan performance over 15 year period that is used for submission to Office of Federal Housing Enterprise Oversight. Designed
• Worked closely with a business analyst to develop prototypes and data model diagrams for each historical report submitted
• Performed analysis to identify the data needs for each reporting to the regulatory.
• Developed SAS programs (BASE SAS, ODS, PROC SQL, SAS Access, SQL Pass-thru, Macros and functions) and shell scripts, implemented processes, including data extraction from various sources ( corporate data warehouse DB2/UDB environment, mainframe, Sybase, SAS datasets and text files) of final data and report production migration for each submission.

Confidential, San Francisco, CA

Sr SAS Programmer/Analyst

• Provided technical design, analysis, program development using SAS programs (BASE SAS, STAT, ODS, PROC SQL, SAS Access, SQL Pass-thru, Macros and functions) and shell scripts and production support for ARM campaign (Direct Mail/Inbound Balance Transfer, Unsecured Line Increase, Point Programs).
• Supported development of modeling stage for each marketing campaign product list pool using SAS, Informix and Sybase.
• Operated and interacted with all business units involved including Marketing, Credit Risk and Targeting and QA/Audit team ensuring timely, accurate handling of marketing campaign fulfillment.
• Completed, interpreted and supported unit and systems tests creating technical documentation.
• Performed process and data analysis; created ad-hoc reports on production data.
• Built predictive models for marketing group’s effective decision-making. Designed and analyzed initiatives/experiments testing various marketing strategies. Performed customer profiling and segmentation for effective targeting and ROE calculations.

Confidential, Richmond, VA

Sr. IS Analyst/Lead Mainframe

• Responsible for the development and support of production programs that are used for direct marketing campaigns in the US Card
• Worked with the Marketing Analytics and vendor ACXIOM for new monthly direct marketing efforts
• Created monthly and adhoc reports to support Marketing Analytics
• Provided unit and integration test support and QA through pre- and postproduction of test case/test scripts, data integrity and technical documentation for solicitation/marketing promotion projects.
• Developed methodology and macro build variables utilizing solicitation history for accurate response prediction, including key variable definition capturing individual response behavior and transaction history.

Confidential, Pleasantville, NY

Senior Programmer Analyst

• Created production, modification and file error reports on schedule for client delivery. Provided production status reports identifying issues and pending resolutions to project managers. Mentored junior team members providing technical and system knowledge support.
• Developed, analyzed, tested, maintained and documented production environment including specification requirements, project requests, program changes, data processing analysis/investigations, program/system walkthroughs and system issues.
• Supported production system including pre- and post production problems (system set-up, preparation, compilation, pre-production test), system abends, erroneous applied transactions analysis, detailed static error causes and resolutions.
• Team coordinator for section test and production releases; special clean up runs, wind-downs and copybooks/dictionary changes.
• Performed group requests for master and transaction file and control cards review. Coordinator of user requests supplying file extracts in report format.
• Designed data error (issues, resolutions) specifications for code changes and data re-entry/manipulation). Completed proposed program code changes. Performed unit and system tests. Wrote technical documentation and program walkthroughs.
• Processed special pre-release runs. Tested outsourced vendor special inputs ensuring data integrity.
• Reported weekly to IT and client’s marketing management team. Provided IT Manager with detailed analysis and resolution of production data errors.

Confidential, San Ramon, CA

Programmer Analyst

• Responsible for the development and production support for the Message Ready system modules of the Pacific Bell’s Billing System.
• Perform module enhancements, identify and fix production issues, impact analysis on new enterprise wide projects affecting the application
• Worked directly with the interexchange carriers including AT&T, Sprint, MCI to resolve data issues and when working on new projects
• Create daily status reports for management to keep track of the interexchange carriers volumes and issues

Confidential, City of Manila

Senior Programmer

• Worked as a Senior Programmer responsible for the development and support of front-end and back-end modules for the COMPASS 2000 application following the full SDLC cycle.
• Provided support for the QA and Integration testing of the application based on test cases and scenarios provided by QA team
• Developed and maintained technical documents for front-end and back-end modules (program specification changes, unit test document)..