PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

SAS UAT Programmer/Data Analyst

Responsibilities:

• Transition data from Legacy Financial platform to SAP eLedger platform working with Operational Risk Group. Develop processes for testing, using SAS Enterprise Guide SAS/SQL, MSSQL, MS Excel and eLedger tools EBIR/EPM to determine the impact of upstream data changes.
• Responsible for validating existing financial data against changed data.
• Modify and create documentation. Write SAS Code to extract data from Legacy data sources.
• Use SAS to analyze data and write SQL queries for data analytics.

Technologies: eLedger Tools, SAS, Excel

Confidential, Charlotte, NC

SAS Programmer Analyst

Responsibilities:

• Restructured SAS 9.2 programs for conversion to TSYS using SAS Enterprise Guide for Credit Card applications. Accessed Credit related customer and account data on the DB2 database from the UNIX server. Manipulated data using SAS and DB2 and downloaded data to UNIX server. Developed SAS in Enterprise Guide. Wrote SAS Code to extract data from DB2 Database. Used SAS to analyze data and writes SQL queries for data analytics as well.
• Presented test and processing data as EXCEL spreadsheets, EXCEL pivot tables and SAS generated reports and tables Worked independently, with credit strategy owners, execution partners, change managers, data providers, lines of business and control partners to determine the impact of upstream data changes .Responsible for validating existing credit strategies against changed data.Coordinated associated strategy coding changes, modifies and creates documentation and implements strategy revisions.

Technologies: SAS/EG, TSYS, SAS, DB2

Confidential, Oakland, CA

Programmer/Analyst

Responsibilities:

• Developed SAS DI processes and Enterprise Guide project to support QOS tasks using SAS server, Mainframe TSO, JCL, SAS/SQL Excel, VBScript, DB2 Database and SAS Data Step and Procedures. Resolved processing tasks and problems using SAS/Mainframe programming solutions.
• Accessed and manipulated data across multiple platforms. Accessed data on the DB2 Database from the Mainframe using TSO, JCL and SAS/SQL. Downloaded data to a desktop PC. Accessed and stored data on the SAS/UNIX platform. Manipulated data using SAS DI tasks. Received data from the client in the form of ASCII text files, Microsoft EXCEL spreadsheet documents . Transformed data into SAS format and exported it into shared repositories. Presented data as delimitted text files, EXCEL spreadsheets, EXCEL pivot tables, Graphs or SAS generated reports and tables.

Technologies: SAS/DI SAS/EG coding to deliver data from the Mainframe and DB2 databases

Confidential, Salinas, CA

Programmer/Analyst

Responsibilities:

• Developed SAS (ver 9) programs to support production and pricing tasks using Mainframe TSO, JCL, SAS/SQL DB2 Database and SAS Data Step and Procedures. Resolved processing tasks and problems using SAS/Mainframe programming solutions.
• Accessed and manipulated data across multiple platforms. Accessed data on the Teradata Database from the Mainframe using TSO, JCL and SAS/SQL. Manipulated data using COBOL and DB2 on the Mainframe and downloaded data to a desktop PC. Accessed and stored data on the UNIX platform. Manipulated data using UNIX commands, SAS and VI. Received data from the client in the form of ASCII text files, Microsoft EXCEL spreadsheet documents and Oracle or ACCESS database tables. Transformed data into SAS format and loaded it into the Teradata database for processing using SQL. Presented data as delimitted text files, EXCEL spreadsheets, EXCEL pivot tables, Graphs or SAS generated reports and tables.

Technologies: SAS/SQL coding to deliver data from the Mainframe and DB2 databases

Confidential, San Francisco, CA

Programmer/Analyst

Responsibilities:

• Used Unica Affinium to develop marketing target list for direct mail and email campaigns. Completed marketing tasks using Teradata Database and UNIX Script programming solutions.

Technologies: Unica Affinium, UNIX scripts and Teradata SQL assistant.

Confidential, Phoenix, AZ

Programmer/Analyst

Responsibilities:

• Developed SAS (ver 9) programs to support conversion validation tasks using DB2 Database and SAS Procs. Resolved processing tasks and problems using SAS/UNIX Script programming solutions.

Technologies: SQL coding to deliver data from DB2 databases

Confidential, San Francisco, CA

Project Manager

Responsibilities:

• Managed the project to develop SAS (ver 9) programs to convert and automate desk top database applications in support of enterprise marketing tasks using Teradata Database and SAS Proc SQL. Ported processes to Unix and developed execution and reporting through SAS Enterprise Miner. Resolved processing tasks and problems using SAS/UNIX Script programming solutions.

Technologies: SAS Enterprise Miner, UNIX scripts, SAS and VI. Transformed data using SAS data step processing to merge and format data and output into SAS format. Loaded data into data repositories. SQL coding to deliver data from Teradata databases.

Confidential, San Francisco, CA

Programmer/Analyst

Responsibilities:

• Developed SAS (ver 9) programs in support of acquisition tasks using SQL, Teradata and Oracle Database. Extracted transitional data and created Reporting tools using SAS and MS Excel. Resolved processing tasks and problems using SAS/UNIX programming solutions, Oracle SQL navigator, Exceed and Tableau.

Technologies: ETL processing techniques to Extract data using UNIX commands, UNIX scripts, SAS and VI. Transformed data using SAS data step processing to merge and format data and output into SAS format. Loaded data into data repositories for presentation as delimited text files and Excel spreadsheets. SQL coding to deliver data from Oracle and Teradata databases.

Confidential, San Francisco, CA

Project Manager

Responsibilities:

• Managed project to develop SAS (ver 9) programs in support of Marketing Analytics using SQL and Oracle Database. Created Customer Segmentation and CRM Analysis and Reporting tools using SAS and MS Excel. Monitored and resolved processing tasks and problems using SAS/UNIX programming solutions.

Technologies: ETL processing techniques to Extract data using UNIX commands, UNIX scripts, SAS and VI. Transformed data using SAS data step processing to merge and format data and output into SAS format. Loaded data into data repositories for presentation as delimited text files and Excel spreadsheets.

Confidential, Concord, CA

Project Manager

Responsibilities:

• Managed project to develop SAS(ver 9) programs in support of Data Mart Development using Teradata and DB2. Monitored and resolved processing tasks and problems using SAS/UNIX programming solutions.

Confidential, San Jose, CA

Programmer/Analyst

Responsibilities:

• Developed and Maintained SAS(ver 9) programs in support of Product Development, Risk Management and Fraud Detection. Monitored and resolved processing problems using SAS/UNIX programming solutions.

Technologies: ETL processing techniques. Accessed and stored data on the UNIX platform. Manipulated data using UNIX commands, UNIX scripts, SAS and VI. Transformed data into SAS format. Presented data as delimited text files and Excel spreadsheets and pivot tables.

Confidential, San Francisco, CA

Programmer/Analyst

Responsibilities:

• Developed and Maintained SAS(ver 9) programs in support of Online Merchant Services. Monitored and resolved processing problems using SAS/UNIX programming solutions.

Technologies: ETL processing techniques. Accessed and stored data on the UNIX platform. Manipulated data using UNIX commands, UNIX scripts, SAS and VI. Accessed Mainframe data. Transformed data into SAS format. Presented data as delimited text files.

Confidential, Denver, CO

Project Manager

Responsibilities:

• Managed project to use SAS(ver 9) processing to extract and manipulate data for Consumer and Small Business Marketing projects in Product Penetration, Retention, Marketing Tracking Studies and Marketing Strategy development.

Technologies: ETL processing techniques. Accessed and stored data on the UNIX platform. Manipulated data using UNIX commands, UNIX scripts, SAS and VI. Accessed Oracle database tables. Transformed data into SAS format using SQL. Presented data as delimited text files. EXCEL spreadsheets, EXCEL pivot tables and graphs or SAS generated reports and tables.

Confidential, San Francisco, CA

Project Manager

Responsibilities:

• Managed project to capture data and provide descriptive statistics and regression and correlated statistical analysis for the Banks Analytical modelling projects. Used the Banks database tables (the W)to extract and report customer segmentation, lifestages and demographic data for project analytics.
• Generated Telemarketing and Direct Marketing lists to support the Banks efforts to attract and retain customers. Performed testing and validation of database development projects using SAS(ver 9) to establish comparison data. Used SAS(ver 9) processing to extract and manipulate data for Consumer and Small Business Insurance projects, Product PenetrationMarketing Tracking Studies and household identification projects.

Technologies: ETL processing techniques. Accessed and manipulated data across multiple platforms. Accessed data on the Teradata Database from the Mainframe using TSO, JCL and SAS/SQL. Manipulated data using COBOL and DB2 on the Mainframe and downloaded data to a desktop PC. Accessed and stored data on the UNIX platform. Manipulated data using UNIX commands, SAS and VI. Received data from the client in the form of ASCII text files, Microsoft EXCEL spreadsheet documents and Oracle or ACCESS database tables. Transformed data into SAS format and loaded it into the Teradata database for processing using SQL. Presented data as delimitted text files, EXCEL spreadsheets, EXCEL pivot tables, Graphs or SAS generated reports and tables.

Confidential, San Francisco, CA

Programmer/Analyst

Responsibilities:

• Reporting and data services for Marketing and Deposit Risk applications in Unix, IBM MVS and Microsoft environments. Developed production and adhoc programs to facilitate client requirements. Defined and formatted data and reports using Unix, Mainframe and Microsoft tools

Technologies: JCL, SAS(ver 8), ISPF, VI editor, OS Utilities, COMPAREX, Endevor, EXCEL and WORD as tools.

Confidential, Concord, CA

Programmer/Analyst

Responsibilities:

• Reporting and data services for Marketing, Credit Risk and Credit Card Customer Services applications in IBM MVS, UNIX, and Microsoft environments. Developed production and adhoc programs to facilitate client requirements. Defined and formatted data and reports using Mainframe, UNIX, and WORD/EXCEL input.

Technologies: JCL, SAS(ver 7), ISPF, OS Utilities, VI, EXCEL, WORD, ACCESS as tools.

Confidential, San Francisco, CA

Programmer/Analyst

Responsibilities:

• Year 2000 compliance renovation of COBOL programs for Customer Service and Human Resources applications in an IBM MVS environment.

Technologies: JCL, SAS(ver 6), ISPF, OS Utilities, INSYNC as tools.

Confidential, Santa Clara, CA

Programmer/Analyst

Responsibilities:

• Year 2000 compliance modification of COBOL programs for Apogee Order Entry System applications in an HP3000 environment.

Technologies: MPE, QEDIT, SCOMPARE as tools.

Confidential, Pittsburg, CA

Programmer/Analyst

Responsibilities:

• Developed and Maintained SAS(ver 6),COBOL/IMS programs for Steel Processing and Shipping System applications in an OS/MVS environment. Use Transform code generator.

Technologies: TSO, ISPF, COBOL, IMS and JCL as development tools.

Confidential, Novato, CA

Programmer/Analyst

Responsibilities:

• Developed and Maintained SAS(ver 6) programs for Insurance System applications in an OS2 environment.

Confidential, San Francisco, CA

Programmer/Analyst

Responsibilities:

• Developed and Maintained SAS(ver 6) /Oracle programs for Marketing System applications in a Unix environment.

Technologies: VI editor as development tool.