Marketing Analyst Resume San Rafael, CA - Hire IT People

SKILLS:

Microsoft SQL Server: database design & administration (table normalization, db tuning, managing user permissions, installing and updating software), SQL querying (query optimization, ODBC connectivity with programs and apps like Excel and Access, SSIS and SSRS coding.

Microsoft Office: Word & PowerPoint - average user; Excel & Access - power user (writes macros and small apps in VBA; connects to external databases and OLAP cubes; understands pivots, lookups, and string manipulation functions)

Programming languages: Visual Basic.Net, C++, C, Pascal, Lisp, FORTRAN, Avenue, ASP.Net

Statistics and math packages: some experience with SAS, R, Mathematica, MATLAB, and SPSS

WORK HISTORY:

Confidential, San Rafael, CA

Marketing Analyst

Responsibilities:

Performed analysis of marketing campaigns to help determine future marketing strategies; worked with contractor databases and analytic results; produced tables, graphs, or maps for presentation of analytical results; and helped to design future directions of data accumulation to generate better analytic results.
Used Tableau to generate reports and dashboards.

Confidential, Fairfield, CA

Sr. Risk Business Analyst

Responsibilities:

Maintained a historical database of the company’s policy data.
Designed business rules surrounding this database - wrote specifications for data loading and for reporting, developed standard procedure guidelines, and provided user training.
Worked with others in the group to make this data available for their use as well.
Wrote ETL procedures using Access VBA applications, DTS procedures, and SSIS packages to load policy data from the production database system.
Designed queries and reports (SSRS) to generate management-level reports describing the company’s performance in measures such as in-force policy counts over time, renewal retention, binder to quotes ratio, earned premium, and loss ratios.
Reports were shared with management recipients via SharePoint.
Developed rates for our products, based on modeled catastrophe losses, industry loss data, and our company’s performance; adjusted by comparison with our major competitor’s rates for similar products in the same market area
. Learned standard actuarial procedures, but worked on non-admitted product lines.
Developed guidelines for our rater development program, including our on-level rater tool.
Our performance in generating new rates went from one rater change developed over eight months to being able to develop more than one rater change per month, using the tools and templates I helped to bring about.
Maintained the SQL Server databases used by these models as our group’s system administrator.
Also worked to validate new versions of these programs - what changes in the model affected our picture of our book’s losses and how we would plan to in corporate the new model’s results in our rating analysis.
Helped to develop predictive models of our losses such as fire, theft, water damage, and liability types of claims using SAS and VBA programming.
My work involved using the procSQL section of SAS to extract data from outside sources and to do table manipulation within the SAS environment.

Confidential, Petaluma, CA

Sr. Programmer/Analyst

Responsibilities:

Took over existing Ingres database system that was used to track chemical analysis results of various soil, water, air, and biological samples collected at contaminated sites.
Performed data loads, queries and backups to support the various projects. Converted database to Microsoft SQL in 2002.
Developed front-end application in Access (VBA) to provide end users with form-based access to their data and to reporting features.
Developed several reports using Crystal Reports.
Helped develop a Web-based reporting application using ASP.Net.
Helped design systems to pump out contaminated groundwater, treat it, and return the treated water to the aquifer.
Used a variety of groundwater flow and transport modeling software packages, including Atlas, Modflow (with Modpath), HEC, HST3D, Solute, and Sutra.
Wrote software to track sample results for an in-house soil laboratory. Developed a program to track time used on a PC in order to bill computer usage to each project.
Developed a generic business graphing application and another one specialized to generate ternary diagrams for rock classification.
Wrote applications within ArcView and AutoCAD to make custom graphics easier to generate and more user-friendly to edit.
Developed a Fourier transform analysis program for the use of our geophysics group.
Modeled several scenarios for a proposed storage facility to be located in the Mojave Desert.
Attempted to show that the natural conditions of the desert soils would prevent the transport of potentially hazardous material into drinking water aquifers, even in extreme conditions.

We provide IT Staff Augmentation Services!

Marketing Analyst Resume

San Rafael, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship