Results oriented Statistical Data Analyst Professional with experience in statistical modeling, market segmentation, direct response market using credit bureau data, SAS programming and financial report generation, with broad background in managing data from various platforms.
Possess working experience with Business Objects (Has worked with more than 100 business object oriented tables and extracted pertinent information using SAS, SQL).
Business methodology is customer-centered focus, with the ability to implement best practical
Initiatives through the use of advance statistical methodologies and computer skills.
Offer excellent quantitative and analytical ability, and an expert command of complex issues.
Possess diverse strengths, including a love of responsibility and challenge.
Areas of expertise are the following.

Software: SAS v9: (SAS/Base, SAS/Macros, SAS/Proc, SAS/STAT, SAS/SQL), SPSS, SPSS/CHAID, SAS Enterprise Guide v4.0, Excel Pivot Tables, PowerPoint, Microsoft Word, Word Perfect, Oracle SQL, FTP, Teradata, JCL.
Hardware: Mainframe, Pentium PC, UNIX.
Operating Systems/Environments: IBM Mainframe, MVS/TSO/ISPF, Windows.

ACCOMPLISHMENTS

Confidential: Pioneered in generating the first dependable Marketing & Portfolio Risk Reports for the new loan products in the year 2007.
Confidential: Received Client Recognition Award for outstanding service in the year 1998.
Confidential: Received rating of exceeded expectations and monetary bonus for work Performance.
Confidential: Created models that reduced cost of direct marketing and increased
Business revenue.
College: Graduated with Honor

PROFESSIONAL EXPERIENCE

03/11 - 06/11 Contractor - Consultant
Confidential

• Within 90 days timeframe, developed the Automated Reporting Application (ARA) for CPG reporting that reduce human labor, resources, and time. Increased Reporting accuracy.
• Created, designed, and implemented ARA which included testing, additions, and enhancements by collaborating with the Consumer and Shopper Marketing Executive VP of Symphony IRI.
• Modified existing SAS codes to decrease running time and increase efficiency in the backend process of ARA.
• Implemented SAS jobs into production.
• Gave PowerPoint presentations in regards ARA to EVP and Senior VP.
• Provided training to off-shore and onsite team members in using the new developed application.
• Made documentations on ARA usages, functions, and process.
• Taking the role of the administrator for ARA and transitioned the duties of the administrator to team member.

04-10 - 12/10 Contractor-SAS Application Developer Expert
Confidential-Risk Department

• Responsible for maintenance of statistical model performance tracking reports and processes.
• Develop application to generate the model performance tracking reports for government compliance.
• Automate financial models tracking process through SAS and Visual Basic.
• Works with complex data summarization techniques
• Gathers and researches project requirements through interaction and collaboration with business partners
• Coach offshore contractors
• Design dynamic reporting capability
• Enhance model inventory database
• Extract data across different systems, databases and platforms
• Modify and rectify existing codes to achieve efficiency and accuracy
• Design and create reporting templates
• Design data marts

08/09 - 12/31/09 Contractor-SAS Consultant
Confidential, Marketing Analytics Department

• Developed and introduced different methodologies in enhancing the revenue forecast model.
• Implemented new methodology in enhancing revenue forecast model.
• Identified data issues.
• Generated reports and graphs that give insight to the fleet.
• Provided SAS programming to support and generate the revenue forecast model.
• Wrote SAS macros to enhance the functionality of the programs.
• Decreased running time of the SAS program that generates the forecast model.
• Performed data investigations and metric reconciliation between different forecast models.
• Created the whole process of automating the generation of the reports.
• Educated Senior VP and staff on the new methodology used in the forecast model.
• Trained employee on different SAS programs usages.
• Resolved coding issues and rectified erroneous coding in the existing programs.
• Provided testing to ensure the accuracy of the forecast model.
• Modified SAS codes to reflect new business requests.
• Provided work-related adhocs.

01/09 - 03/09 SAS Reporting Consultant
Confidential, Collection Department

• Investigated data issues in Teradata.
• Resolved data issues in the Collection files.
• Investigated and reconciled data between different data systems.
• Decoded multiple complex languages codes into SAS codes.
• Acquired pertinent information related to the project.
• Wrote SQL codes to check and validated the integrity of the data.
• Wrote SAS programs to generate Collection Reports.
• Wrote SAS programs to generate historical files.
• Automated the generation of the Collection Reports.
• Wrote SAS Macros to enhance functionality and efficiency.
• Designed the structures of the programs to produce the Collection Reports.
• Generated automated Excel templates for the Collection Reports.
• Checked the accuracy of the computer codes written by another consultant.
• Created subscriptions in pulling daily files from the Data hub to automate daily ftps.
• FTP files from the Unix Server.
• Worked with relational databases across systems and extracted data information.
• Made documentation.
• Trained consultant in execute data source process and report generation process.

06/07 - 11/07 SAS Reporting Consultant
Confidential, Risk Department

• Pioneered in generating the first Marketing & Portfolio Risk Reports for the new launch of the loan product.
• Designed and planned the overall process of daily and monthly Risk Reports generation.
• Designed the structures of the Risk Reports templates.
• Implemented the design of the execution process of the Risk Reports which includes archival file storage, file utilization, SASdbs, and output files.
• Simulated marketing and portfolio data to be used in developing the sample protocol risk reports.
• Wrote UNIX script program to schedule jobs.
• Used Mainframe TSO/ISPF utilities to check flat files and assured correctness of file layouts.
• Read files from Teradata in SAS.
• Used Teradata tables for report development and testing.
• Automated the FTP process from the UNIX to the PC interface through writing scripts in Hummingbird Exceed.
• Planned and coded the structures of the CSV files to be implemented into excel pivot tables.
• Investigated data anomalies from the Reporting Database due to malfunction of the Application System.
• Report data issues and monitor the accuracy of the functionalities of the Application System.
• Informed outside vendor and across departments in regards to data issues, system failures, and erroneous documentations made by vendor.
• Worked with more than 100 object oriented tables and extract relevant information for reporting usage.
• Reported malfunctions of the Decision Manager System due to discrepancy of the scores.
• Communicated to Senior Managements concerning application tools needed to further advance the understanding of the new application system and the new Reporting Database.
• Wrote SAS programs to acquire pre-screen scores from the mail file.
• Wrote SAS programs to acquire post screen scores from the Reporting Database.
• Wrote SAS programs to validate the mapping of the Reporting Database for the credit scores.
• Wrote SAS SQLs to appropriately join tables according to the architectural design of the database.
• Enhanced and macrotized existing SAS programs and new programs to decrease lengthy codes.
• Chaired meetings to present my SAS programs, report designs, and the usages of the risk /marketing reports.
• Wrote SQLs to extract object-oriented variables from the Capstone Reporting Database.
• Wrote SAS programs to validate the accuracy and parallelism of the structural design of the Teradata tables to the Reporting Database tables.
• Manipulated data from variety of sources with different data formats/structures to conform into uniform structure for data processing.
• Created excel templates for the Risk Reports and implemented an automated process for these templates.
• Validated the accuracy of the data structure in the Application Process System.
• Met with clients to discuss their needs and requests.
• Wrote and modified SAS programs to reflect client’s new requests.
• Designed and Wrote SAS Macros to enhance functionality and efficiency of the programs pertaining to the Risk Reports.
• Managed and coordinated the timeliness of the data/files deliverables associated with the Risk Reports.
• Investigated and resolved data issues and anomalies.
• Provided ad-hoc reports as requested.
• Provided SAS codes and SQL codes for data extraction to other departments.
• Provided the DPL Risk Reports for other departments.
• Worked with various departments and outside vendor to obtain pertinent information related to the project.
• Worked with outside vendor to learn about the new application process system.
• Made presentations regarding to the Risk Reports and their usage to the Senior Management.
• Made documentation on the Risk Reports and instructions on their maintenance.

05/00 - 06/07------- stayed home mother.

03/00 - 05/00 SAS Programmer Consultant
Confidential, Customer Information Group.

• Modified existing programs to achieve efficiency.
• Converted existing SAS programs in Mainframe environment to UNIX.
• Generated Ad-hoc reports as needed.
  

07/98 -10/98 SAS Programmer Consultant
Confidential, Customer Information Group

• Wrote programs to provide performance reports on all campaigns for the Private Issue Cost Per Receivable Project.
• Wrote programs to produce the behavior reports for the Provisional Pricing Specification Project.
• Produced Loss/Profit reports to determine the performance of past mailings.
• Generated Lift Curve for the statistical scoring model.
• Constructed and updated the Promotional Database.
• Wrote programs to automate all reports for the Potential Merchant Studies and created front Interface screens for user\'s selections of the reports.
• Modified and increased efficiency of existing programs to suit new business needs.
• Generated monthly Closed Account Reports, Activation Reports, New Accounts Cash Reports and Tracking Reports.
• Wrote programs to produce the Universal Spencer Store Promotion Weekly and Monthly Reports and established selection screens for users\' usage.
• Provided adhocs, validations of data, and mail lists as requested.
• Enhanced credit bureau program by labeling all variables.
• Updated format libraries as needed.
• Made documentation.

02/98 - 05/98 SAS Programmer Consultant
Confidential, Data Warehouse Division.

• Created programs to provide statistical reports on the medical data and the eligibility data.
• Produced validation reports for the Hedis studies.
• Re-designed the Medical Service Procedure logic and algorithm for the Medical Service Project.
• Created SAS programs and SAS MACROS for detecting invalid data and for data
  extraction.
• Modified and enhanced programs to increase efficiency and to reflect undergoing business changes.
• Wrote programs to create format libraries.
• Composed data for program testing.
• Resolved data issues and corrected programming logic.
• Wrote SAS programs to fix file distortion.
• Created open jobs to prevent existing files and programs from migration.
• Made documentation.
  

09/97 - 11/97 Confidential
Project duration: Statistical Consultant

• Converted marketing, promotional, pricing, and sales files into appropriate format for data manipulation.
• Created and formulated SAS databases for statistical modeling purposes.
• Constructed and generated flat delimited files from numerous diversified sources; this process of construction involved data aggregation, appending, merging, and validation.
• Created and coded marketing variables for statistical modeling.
• Investigated data anomalies.
  Ensured the integrity and reliability of data.
• Redefined database structures to reflect the change of business and/or analytical needs.
  Developed SAS programs to resolve insufficient space issues.
• Supported the generation of the Baseline models.
  Transferred files from the UNIX platform to the PC environment.
• Provided consultative advice, suggestions, and solutions to issues pertaining to database formulation, construction, and structures.
• Invented procedure to automate the generation of flat delimited files.
• Made documentation.
• Performed ad-hoc analysis and generated ad-hoc files.
  

04/96 - 09/97 Confidential, Database Group.
Senior Programmer/Analyst

• Provided program support for OTS (Office Thrift Supervision) audit of the bank;
  Created delinquency and reconciliation reports.
• Created standard performance reports for the quarterly CRA (Community Reinvestment Act) process of the Low/Moderate Income and Minority loans.
• Incorporated compliance tapes and modified key statistic reports.
• Updated the Approval Exception reports to reflect new loan underwriting parameters.
• Created micro market version of the key statistic reports for marketplace analysis.
• Investigated and corrected logical and syntax errors in the standard monthly and quarterly process; corrected the delinquency counts and dollars on the demographic performance reports, corrected segmentation problems in the monthly key statistic reports.
• Created macro processing to rationalize the quarterly demographic reports, increasing the efficiency and improving the printed version page usage.
  Provided support for the recapture and backup of the historical tapes on the (Testing Environment)(MVS, ISPF, TSO) T-SYS machine; helped create generation data sets.
• Created flat files containing Checking Plus product information in support of the CASA portfolio management model development project.
• Updated central format libraries to incorporate additional processing requests.
• Provided general support of all Database initiatives; created JCL programs to prevent file migration, supported data administrators during monthly process by debugging programs and resolving JCL issues, investigated data anomalies and created ad-hoc programs to respond to management inquiries/requests.
• Corrected erroneous database information caused by system conversion.
• Redesigned Checking Plus SAS databases for all national markets; converted Checking Plus files into 72 months format to achieve file format consistency across all products, incorporated new codes and additional file information to enhance accuracy, modified logic to reflect new information process and system integration, and adjusted all associated reports programs to the new design.
• Created programs that produce early delinquent reports and charge-off reports containing characteristic profile information.
• Redesigned programs to decrease running time.
  

03/96 04/96 Confidential
Marketing Research Analyst

• Set up Segmentation Modeling protocol.
• Wrote technical instructions, explanation, and documentation concerning the usage of CHAID
• and its applications.
• Produced standard marketing statistical report.
  

04/95 02/96 Confidential
Research Analyst

• Developed response models using credit data to increase the response rate of direct mail marketing.
• Built persistent model using credit information to discriminate prospect customers who will be more likely to keep their policies.
• Experienced in Marketing Segmentation Modeling using CHAID.
  Experienced in Logistic Regression, Cluster Analysis, Factor Analysis, Discriminate Analysis, Linear Regression, and Multiple Regression.
  Credit Scoring.
• Researched on new innovative methods to enhance the predictability power of different kinds of models.
• Investigated the correlation of credit data to insurance data and other types of data.
• Verified the effectiveness of the created models through Retrospective Analysis and other testing.
• Provided consultative suggestions, ideas, and strategic plans.
• Trained new employees.
• Generated reports for instructing the use of the implemented models.
• Prepared, fixed, and analyzed data sets.
• Provided distributions and other statistical reports.

EDUCATION

Master of Science: Probability and Statistics.
Date of Graduation: December 1994.
Grade Point Average: 4.68/5.00.

Bachelor of Science: Statistics and Operations Research.
Date of Graduation: May 1992.
Grade Point Average: 4.50/5.00.

Related course work: Survey Sampling, Statistical consulting, Multivariate Analysis, Nonparametric Statistical Methods, Statistical Theories and Methods, Quality control, Math Optimization Techniques, Decision Analysis, Game Theory, and Stochastic Modeling.