Sharlene Jordan
Sharlene Jordan
Sharlene Jordan
Summary
Professional Experience
Data Analyst II
Advanta Corporation
6/03 to 1/05Springhouse, PA
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.
9/99 to 11/00Horsham, PA
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.
10/98 to 9/99Wilmington, DE
•
Created, maintained, and enhanced SAS code used to implement long and short
-term cardholder reprice policies affecting as many as 38 million accounts.
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.
GE Capital Mortgage
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.
•
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.
MCI Telecommunications
4/97 to 8/97Atlanta, GA
Informed downstream data users of data availability and file updating issues that
may have affected their reporting.
Advanta Corporation
10/95 to 4/97Horsham, PA
Investigated credit card authorizations and credit line changes that did not reflect
company policies.
3/94 - 10/95Philadelphia, PA
Training