Data Analyst
Resume:
Catherine M. Wilson
*********.*.*.******@*****.***
SKILLS SUMMARY:
I have a strong background in data mining, data migration, report writing, procedural automation, data trend analysis and data analytics.
EXPERIENCE:
BigFix/IBM
1480 64th Suite 200 Street Emeryville, CA 94608
DSS Catalog Analyst
04/2008 – present
Maintain the DSS SUA catalog that contains software application information for endpoint detection. Collecting and converting 3rd party data to incorporate into that software catalog data. Create SQL scripts to automate data imports from external sources for monthly deliverables of catalog publishing. Manage database integrity, backup procedures and reporting. Supporting customers with software catalog content issues and customization.
Responsibilities include but not limited to: Oversee third-party data enhancements to the DSS SUA database.
Data mining and database analysis to ensure data integrity.
Ensure that recently released software titles are current and published in the monthly catalog.
Assist customers in customizing data content.
Create/maintain SQL scripts to perform monthly updates and merges into catalog database.
Oracle Corporation 10 Twindolphin Drive Redwood Shores, CA.
(IPS – International Programming & Systems, INC)
DATABASE MARKETING ANALYST
03/07 – 12/07
Responsibilities include but not limited to: Oversee third-party data enhancements to the campaign database, direct marketing modeling and reporting, and optimization modeling for key terms.
Assist in data mining and database analysis to build databases that are accurate, predictive and actionable.
Ensure that the sales and marketing data and client information is up to date and accurate
Importing correcting third-party data using MS Access to add to the campaign, direct marketing modeling and reporting database.
Using Oracle SQL creating marketing campaign lists using customer data for direct mail, email, phones and any request for adhoc reports or database updates.
Ensure that the sales and marketing data and client information is up to date and accurate.
11/00 – 01/06
E*TRADE Financial 4500 Bohannon Dr. Menlo Park, CA
DATA ANALYST
Generate reports from customer data for SQL for online and offline promotions.
Collect data for measurement of success rate of campaigns.
Assist in data mining and database analysis to build databases that are accurate, predictive and actionable.
Ensure that the sales and marketing data and client information is up to date and accurate
In Teradata/ Using Queryman:
Using SQL, developed lists from customer data for marketing campaigns for email, directmail and phone.
For Analytics and reporting I used mortgage, bank and brokerage data of customer behavior and demographics to assist the marketing managers on determining their customer targeting for future campaigns.
Created reports using Teradata SQL and MS Access to show campaign success rate using tranactional data.
Using Teradata SQL wrote procedures to check for data integrity by cross referencing different data sources (importing/exporting data from different systems for cross referencing).
Part of the planning team when selecting 3rd party data to improve our customer data base (met with Axciom when we where selecting/procuring demographic data)
Using SQL wrote procedures to monitor web page navigation of potential customers on an ETF website
Using SQL and Access created all adhoc reports for marketing and/or analytics.
06/99 – 11/00
E*Trade, 4500 Bohannon Dr. Menlo Park, CA.
MAC ANALYST
Coordinating all computer related and office needs for installation, moves, adds and changes.
Participate when necessary, in setting up and making workstations network ready.
Coordinate initial pc equipment, office and operational needs for all local new hires.
07/96 – 06/99
E*Trade, 2400 Geng Rd. Palo Alto, CA.
LEAD COMPUTER OPERATOR
Monitoring systems in a VAX/VMS cluster and UNIX/AIX multi-platform environment for online brokerage.
Providing first level system support, tracking production processing, communications, network services, in-house applications and incident management.
03/96 - 05/96
Acer America 2641 Orchard Pkwy San Jose, CA.
(TAD Technical Services)
DATABASE PROGRAMMER
Rebuilt database in Microsoft Access for data entry and automated report writing in the marketing division for price listing updates.
08/95 - 02/96
Hewlett Packard, 935 McLaughlin San Jose, CA.
PROCESSING SPECIALIST
Created automated reports for product management. Designed relational database for automation of special report writing.
Created automated spreadsheet for product slotting.
03/89 - 02/95
GTE Government Systems, 100 Ferguson Ave. Mountain View, CA.
INFORMATION MAMAGEMENT III
Designed and created relational database for equipment tracking, data entry and automated report writing using Access 2.0.
Moved large database application from mainframe to PC.
Created programs to automate the import and export of data to different system applications between mainframes and desktops.
Wrote programs, procedures and documentation for clerical support and user interface.
06/87 - 03/89
GTE Government Systems, 100 Ferguson Ave. Mountain View, CA.
SR. COMPUTER OPERATOR
Monitored system in a VAX/VMS environment.
Performed daily system backups.
Maintained user accounts and monitored system security.
Assisted users with network and system problems.
06/77 - 04/87
Stanford Linear Accelerator Center (SLAC), 2575 Sandhill Rd. Menlo Park, CA.
SR. COMPUTER OPERATOR
Monitored systems in an IBM environment.
Isolated system problems using diagnostics and troubleshooting.
Wrote command files for computer operations optimization.
Acted as Lead Operator in the absence of supervisors.
Co-authored manual for computer operations and the use of editors.
SOFTWARE:
OS/SVS, ASP, MVS, DOS, VM/SP, CMS, VMS, DCL, TSO, ISPF, JCL, Datatrieve, PASCAL, Visual Basic, SQL, Fortran, MS Word, Excel, MS Access, Cognos Powerhouse Quiz, Foxpro, UNIX/AIX, Teradata and DB2.
HARDWARE:
IBM; 3081, 3033, 370/168 and 360/91. VAX 11/780, 11/785 7000 series, 8650, 8700, Alpha 8400 servers. PC's and Unix servers.
Education
1972 - 1976 Woodside High School, Woodside, CA.
1979 - 1989 Technical courses in computer operations for VAX and IBM mainframes. Basic, Fortran programming languages and relation database management.
Contact this candidate