GERALD R. GOFF
**** ******* ***** • Concord, CA *4521 • 925-***-**** • ys0ttj@r.postjobfree.com
________________________________________
Database / Financial Analyst
Detail-oriented information technology professional with expertise in the creation, implementation and maintenance of database systems for the finance industry. Adept at configuration design, troubleshooting, maintenance and support management. Strong understanding of financial reporting requirements and creation of financial reports to enhance management information system distribution. Create data processes which improve speed and accuracy of data distribution channels, as well as responsive applications and strategies that decrease costs and increase revenue. Consistently recognized for effective communication skills combined with top quality technical ability. Proficient in a wide range of state-of-the-art computer systems, languages, tools and testing methodologies, including Access, Raddon-MCIF, FOCUS, SQL, Paradox, Dbase, and Foxpro. Prepare Excel spreadsheets, Word documents, tables, and charts to supplement reporting requests.
PROFESSIONAL EXPERIENCE
MECHANICS BANK, Hercules, CA 2005-2012
Financial/Marketing Database Analyst
Assisted with design and production of bank segment dashboard reporting program
Directed ASA vendor with dashboard programming design and tested new system
Analyzed and reported on quarterly dashboard data results via EXCEL spreadsheets
Implemented and administered new Raddon Marketing Customer Information File (MCIF) system
Mapped MCIF database and tested system; tested and debugged data source file conversion
Administered and maintained bank-wide Sales Opportunity database
Generated branch portfolio reports within sales database; Developed Decile, Distribution, Crosstab, and Product Tracking data variance reports
Coordinated bank Direct Mail campaigns and monitored campaign results
Directed government mandated annual Privacy Mailing effort for Compliance unit
Prepared data enhancement specifications for IT and vendor due diligence write-ups
Monitored new account on-boarding process, which led to a yearly 20% increase in bank deposits
Developed ad-hoc queries and reports in Access and SQL; created customer and product profitability reports
Collected and documented end user requirements on heavy volume bank wide data projects
WEST AMERICA BANK, Fairfield, CA 1999-2005
Financial Analyst/Programmer
Maintain sales tracking databases for retail sales Incentive program
Developed and programmed financial reports in Foxpro
Coordinate employee quality survey rating process
Maintain branch general ledger databases for profitability reporting
Create ad-hoc queries and reports in support of general ledger team
Provide support in budget and plan variance reporting
Assist with merger and acquisition reporting
BANK OF AMERICA, Concord, CA 1996-1999
MIS Consultant
Key team member for planning and testing of costing and billing data system conversion
Fulfill NOMAD database programming requests for general ledger financial reporting
Marketing team representative for Year 2000 data conversion testing
Prepare consumer lending monthly reports for marketing senior managers
EDUCATION
BACHELOR OF SCIENCE IN BUSINESS MANAGEMENT
San Francisco State University, San Francisco, CA