New Page

Training

SAS Data Warehouse Administrator

Relational Database Design and Development

Expertise

Logical and physical relational modeling

Gathering business requirements and developing business rules and specifications

ETL process automation

Data scrubbing and cleansing algorithms

Tuning database structure to improve performance of extraction processes

Design of relational and multi dimensional databases for online analytical processing

Strong SQL skills

Projects

Intuit, Inc.

Developed architecture for a Oracle based Data Mart specific to analyzing marketing campaign data (sales, registration and promotion). Addressed issues related to data infrastructure and technical architecture

Developed data aggregation rules for a multidimensional Data Mart

Incorporated design changes to integrate easily with an enterprise-wide Data Warehouse

Used SAS Enterprise Miner for mining Data Mart

Wrote SAS & SQL programs to extract data from Data Mart for ad hoc reporting

Developed Pivot Table based reporting processes

Created and maintained detailed project plans for OLAP / analytical reporting initiatives.

Presented Data Mart proposal to executive management

Aetna Health Plans

Facilitated requirements gathering and data reconciliation sessions to map data from various Aetna providers into industry standard specifications such as NSF-1500 and UB-92

Wrote SAS macro programs for Extract, Transform, and Load (ETL) processes

Developed automated processes using CGI scripts for initial and incremental loads of data from Sun Server to a DB2 Data Warehouse.

Developed data cleansing algorithms for name and address matching and consolidation

Programmed automated processes to assure data quality and control of data.

Documented business requirements, technical specifications and test/data reviews

Pacific Bell

Participated in several Data Warehousing projects in Marketing and Billing departments in a SAS/ DB2 / CICS / MVS environment

Designed automated processes in SAS to read billing data and develop data marts for direct mail target marketing

Designed logical and physical data model to incorporate Census Block Variables, Microvision profiling, and related segmentation & distribution variables

Developed backup/restore and replication strategies using IBM utilities

Developed automated processes to transfer data to/from vendors such as Demographic scoring companies, mailing list houses and advertising agencies

Wrote several SAS programs for data cleansing, mailing list generation and studying the effectiveness of direct mail campaigns

Syntex Pharmaceuticals Inc.

Participated in the design and development of a migration plan to convert several distributed databases into an Oracle Clinical Data Warehouse
Reviewed databases/entity/relation structures and designed data dictionary to map Oracle column names to SAS variables
Provided data maps between Data Mart (SAS based) and Data Warehouse (Oracle/Clinical based)
Developed named standards and programming conventions
Wrote SAS/Access and SAS SQL and PL/SQL programs to access data from Oracle

Kaiser Permanente

Gathered required and developed logical and physical data model for a Data Mart to support interactive applications
Developed automated batch processes to refresh Data Mart from corporate Data Warehouse (DB2 & Tesseract)
Tuned SAS/Access to DB2 interface using SAS and MVS system options to improve response times of data extraction processes
Addressed network connectivity performance considerations

Consulting Psychologists Press, Inc.

Analyzed and mapped databases, tables and fields to convert from Paradox to SAS

Developed SAS macro programs along with third party tools like Data Junction, for data cleansing and ETL processes.

Designed and tuned SAS data structures by selection of keys and indices, to facilitate data extraction for statistical analysis and modeling.

Wrote several SAS & SQL programs for multivariate statistical analysis and reporting

Upgraded PC Hardware and Software platform to work with network