Resume Of Sharlene Jordan

Sharlene Jordan [email protected] 81 North Clinton Street Doylestown, PA 18901 H: 215-348-4373

Summary Motivated, experienced, and detail-oriented data analyst/SAS programmer enthusiastic to re-enter the workforce after raising a family. Areas of expertise include: •

7 years of SAS programming: reporting, report automation and application development in PC, UNIX and mainframe environments

•

3 years of data analysis: data-related procedures analysis and documentation, data definition mapping and validation, cardholder processing, mathematical analysis

Professional Experience Data Analyst II Advanta Corporation • • • • • • •

Served as an advocate and liaison for the relational database user community providing data mapping, validation, and documentation, and communicating to the data users how cardholder processing changes would affect the data warehouse. Served as the technical expert for the operations group providing recommendations and assistance regarding various MIS topics such as data quality and communication procedures. Supported the operations department with adhoc reporting and automated reports to be managed by junior SAS programmers. Collaborated with an application developer to automate an integral cross-departmental report using advanced SAS error-handling techniques. Regularly assisted others with SAS queries, system set-up and error resolution. Analyzed and co-created procedures for new data requests. Collected and managed a database of department reports.

SAS Programming Consultant Fleet Credit Card Services • • • •

•

9/99 to 11/00 Horsham, PA

Created reports, MS Excel spreadsheets and MS Access databases from multiple tables in Oracle relational databases, flat files, and production SAS datasets using PC and UNIX SAS and SQL PLUS. Automated SAS code using the SAS macro language so that novice SAS users could run the programs as production jobs. Assisted users with SAS questions and occasionally with general PC, system, and database questions. Created an MS Access database for the group to use for reporting and conducted a small training class on how to use it.

SAS Programming Consultant First USA Bank •

6/03 to 1/05 Springhouse, PA

10/98 to 9/99 Wilmington, DE

Created, maintained, and enhanced SAS code used to implement long and short -term cardholder reprice policies affecting as many as 38 million accounts. Applied reprice policy initiatives via mass FDR non-monetary transaction submissions and verified on the account level that they were successfully implemented. • Used UNIX and PC SAS/SQL and SQL Plus in an HP/UNIX environment to retrieve, combine and manipulate data from multiple tables in Oracle relational databases, text files and MS Excel files.

SAS Programming Consultant GE Capital Mortgage

10/97 to 10/98 Cherry Hill, NJ

• Responsible for updating and maintaining marketing data from various sources that existed as part of a departmental UNIX SAS data warehouse. • Resolved data quality issues with internal and external data suppliers. • Created adhoc and standard marketing reports with marketing and external mortgage data using PC Base SAS and SAS/SQL. • Used the SAS Macro language to create source code files in a departmental PC SAS/AF database query application that were used to incorporate user-selected report specifications into standard marketing reports. • Researched and implemented database expansion initiatives to meet changing marketing needs. • Modified existing SAS Frame objects and SAS/SCL code files to expedite the addition of a new marketing report to the application’s menu system. SAS Programming Consultant MCI Telecommunications

4/97 to 8/97 Atlanta, GA

• Utilized SAS and JCL programming in a TSO mainframe environment to support various analytical groups with call traffic reports and data files on a scheduled and adhoc basis. • Informed downstream data users of data availability and file updating issues that may have affected their reporting. Credit Policy Analyst Advanta Corporation

10/95 to 4/97 Horsham, PA

• Used PC SAS and SAS/SQL programming to perform analyses on competing account management strategies with data from multiple tables in Oracle and Sybase relational databases in a UNIX environment. • Created SAS reports for senior management relating to credit account management. • Investigated credit card authorizations and credit line changes that did not reflect company policies. • Implemented company-wide credit policies into the cardholder processing Adaptive Control System (ACS). • Responsible for documentation of changes made to ACS. Strategy Analyst Rosenbluth Travel Services

3/94 - 10/95 Philadelphia, PA

• Created mathematical models using linear programming and statistics to analyze long-term air travel costs of large corporations. • Served as a consultant to corporate travel managers for airline contract negotiations. • Created MS Excel macros with user-interfacing and conditional logic procedures to automate model creation. • Assisted in client presentations as a technical expert.

Education and Training THE PENNSYLVANIA STATE UNIVERSITY, University Park, PA

8/88 to 12/92

B.S. in Quantitative Business Analysis - Major G.P.A. 3.5, Dean’s List Training: SAS Programming, Decision Analysis Concepts and Techniques I, Adaptive Control System, Product Control File, Visual Basic