SUMMARY

• CFA, MBA and BS in Engineering
• Advanced skills in programming & automation using SQL, SAS & Macro, Shell Scripting
• Worked wif Oracle, DB2, Teradata & SQL Server and SAS on PC, UNIX & Mainframe

PROFESSIONAL EXPERIENCE

Data Migration Specialist

Confidential, Fort Washington, PA

Responsibilities:

• Convert SQL query from old database to new normalized data base
• Compare query results using SAS and research data discrepancy
• Optimize SQL query and SAS programs for Auto Valuation Team
• Work wif Database team to improve database design for better performance
• Identify customers impacted by process break based on not so well defined criteria
• Determine financial impact to customers (Finance charge, Fees and Reward Points)
• Use SQL to process data and run SAS on UNIX
• Worked on Late Fee Refund project where customers were charged LF due to return payment causing minimum pay requirement changes
• Worked on Finance Charge Refund project where customers were charged higher rate due to erroneous change in contractual terms on rate and fees

SAS Programmer/Data Analyst (Contractor)

Confidential, Philadelphia

Responsibilities:

• Extract and process enrollment & claims data from Teradata EDW and SQL Server Datamart
• Maintain and run Risk Score Model to calculate risk of members for ACA healthcare plans in SAS
• Risk Model incorporates ICD - 9 & ICD-10 and use SAS array and macro extensively
• Works on Ad hoc query to generate reports and investigate data issues
• Developed SAS programs to track risk score components for QA purpose
• Developed SAS programs to determine risk adjustable claims for analytical projects
• Developed SAS programs to crosswalk diagnostic codes to conditional category for QA & Reporting
• Developed SAS programs to rank rejected claims for Error Correction Team

SAS Programmer/Testing Analyst (Contractor)

Confidential, Wilmington, DE

Responsibilities:

• Created & Automated Small Balance Write - off project using SAS Macro to pull & process data & generate audit reports for daily adjustment of qualified accounts prior to their cycle date
• Developed SAS & SQL programs to convert, compare and validate pricing data in future data warehouse using SAS EG & on UNIX platform & DB2 database for C3PM project
• Acted on my own initiative to develop reverse status code mapping which greatly helped ensuring data quality of pricing projects during migration & transition period
• Collaborated wif business and technology teams to identify data conversion errors using conversion mapping logic which is both complex and often work-in-progress itself
• Converted SAS & SQL programs of current projects from processing old data to processing new data
• Worked on NEA & FBPR De-conversion projects which remove sold accts from production system
• JCL & Mainframe SAS are used for Simplification & De-conversion projects
• Presented data of recurring & Ad hoc projects in on-line Walk-through meeting for review & approval

SAS Programmer /Data Analyst (Contractor)

Confidential, Wilmington, DE

Responsibilities:

• Work wif Business Owner and PM to research data and modify Business Requirement for marketing campaign projects and internal action projects (Rewards Fulfillment, Card Options Maintenance and Product Upgrade) for both consumer and business accounts
• Write detailed Design Document wif implementation specifics for Business Requirement Document
• Develop SAS and SQL programs to extract data, process business requirements and generate marketable list files and batch files for internal action projects
• Use SAS and SQL to generate detailed and meaningful auditing presentation including frequency, data range, samples, tabular reports and waterfall illustration to help Business Owners and QA Analysts to understand data and perform proper testing to ensure job quality and legal compliance
• Develop UNIX Shell scripts and SAS Macros to improve efficiency and ensure quality
• Work wif TSYS application to load batch files and conduct sampling research for QA purpose

List Management Programmer (Contractor)

Confidential, Wilmington, DE

Responsibilities:

• Work wif Business Analyst to research data and write List Specification for marketing projects
• Develop SAS and SQL programs to generate marketable list files and business action files
• Use relational database (Oracle and Teradata) on UNIX platform (AIX) and Tivoli Work Scheduler
• Apply selection criteria and suppression files to suppress and /or exclude accounts appropriately
• Create waterfall analysis illustrating where records are included or excluded

Sr. Business/Data Analyst

Confidential, Fort Washington, PA

Responsibilities:

• Participated in prepayment and default analysis including trend and roll - rate analysis for different types of mortgage loans and provided data for analysis & investment decision
• Worked on Cash Flow models to evaluate mortgage loans and servicing rights
• Process data according to business logic to generate Ad Hoc analysis and reports
• Extract data from Oracle database using SQL and SAS on both UNIX and Windows platform
• Developed many standard production programs using SQL, SAS, Excel and Access for internal reporting on mortgage loan performance
• Developed and maintain Par Reporting project, which is teh graphic presentation of loan performance (CPR and CDR) by loan age and time series utilizing SAS and intranet
• Worked on Auto-Decision Project which use statistical modeling to speed up loan application approval process for certain qualified loan applicants
• Developed and maintain databases in both SAS and Access for internal use

Database Marketing Analyst / Database Developer

Confidential, Wilmington, DE

Responsibilities:

• Perform statistical analysis to determine teh effectiveness of overall & segments of marketing campaigns (World Points) using control group for comparison
• Automate leads generation and transaction profile process using SAS Macros, Shell Scripting and general modularized programs
• Develop programs to transform and load data (ASCII and binary) into Oracle database, using SAS, SQL, PL/SQL, SQL*Loader and Unix Shell Scripts
• Write wrapper scripts using Unix Shell to automate database production jobs. Teh wrapper scripts eliminate manual steps to increase productivity and add safety check to avoid human errors.
• Use relational database (Oracle 9I) and data manipulation tools (SAS and SQL on UNIX platform)
• to generate leads and conduct analysis from departmental database, both recurring and one - time.
• Apply selection criteria and suppression files to suppress and /or exclude accounts appropriately, using and enhancing established methodologies