543 Second Street
Hermosa Beach, CA, United States of America 90254 |
Home Phone: (310) 372-2189 |
|
SQL Database Developer, Data Integrity Specialist and Management Consultant
|
PROFESSIONAL
SUMMARY |
| |
Innovative, creative and results-oriented SQL Database Developer and Data Integrity Specialist, offering expertise amassed from 20+ years of Key Business undertakings as a Database Developer, Senior Business Analyst, Process Analyst and Data miner. Delivering clients streamlined Access Workflows and Automation to their Key Business Information, necessary for reporting past results, supporting critical decision making on current initiatives, and securing their roadmap for future success.
Mitigates risk by the creation of exception reporting that identifies missed tasks and data anomalies and reduces operational costs through automation. Utilizes a holistic approach to development, taking into account company-wide processes impacted or improved by each project undertaking. Implemented a company-wide standard methodology for development and communication of operational reporting.
|
CORE
COMPETENCIES |
| |
Microsoft SQL Database Development - Over 17 years experience programming in MS SQL Server including database design, and the creation and optimization of stored procedures and views. Possesses the ability to quickly and accurately grasp database designs largely without outside assistance or data dictionaries and is constantly in pursuit of optimized queries to assist in performance.
Reconciliation and Data Analysis - Unique ability to reconcile, analyze and troubleshoot data discrepancies between multiple systems, reports or applications
Microsoft SQL Server Reporting Services - Over 5 years experience designing and publishing complex SSRS 2000 and 2005 reports.
Crystal Reports - Over 15 years of experience designing and creating complex reports utilizing crystal reports (all versions).
Communication - Able to quickly understand the business drivers behind a technical opportunity and frame alternative solution paths.
Once the various solutions are identified, I can then effectively communicate the alternatives to Senior Management or the Business Users in business terms to arrive at the optimal path prior to any technical development.
Integration - I specialize in blending the IT World with the Business World to ensure that what I develop meets the needs of the business I am supporting while also meeting the needs of Senior Management and IT to maintain efficiency.
|
EXPERIENCE |
| |
Dec 1998 to Present
|
SQL Architect, Developer, Reporting and Data Integrity Specialist. OneWest Bank, Pasadena, CA and Financial Freedom, Office of the CEO, Irvine, CA
Hired by IndyMac Construction Lending division for a 4 week contract developing Crystal Reports, this 13 year consulting engagement has delivered exceptional value-to all management levels of the Bank, including simultaneously reporting directly to the EVP of OneWest and CEO of Financial Freedom.
Developing SQL-based Crystal Reports with data derived from complex SQL Databases, the approach supporting the Mortgage Loan Originations and Servicing divisions became a corporate-wide practice and methodology for analyzing workflow processes and creating automated reporting. Work products enabled senior management the agility to delegate time-sensitive work, mitigating Portfolio Risk by prioritizing resources on at-risk processes ensuring compliance with regulatory organizations.
Instrumental in supporting the Bank's strategic direction of Cognos Impromptu, converted reports from Crystal Reports to Cognos Impromptu, assisting in the creation of a complex SQL Job/DTS Package/Cognos infrastructure.
Through various acquisitions by IndyMac bank, the take-over by the FDIC, and subsequent sale to OneWest Bank, fielded requests from FDIC and Operational organizations for critical portfolio data.
Special Projects include reconciling Financial Freedom data to MERS (Mortgage Electronic Registration System) and IACS (system utilized by HUD) to ensure that all systems reconcile on key data points and that Financial Freedom remains in compliance with both organizations.
Additional contributions and responsibilities include providing standardized reports requested by internal and external audits, as well as the FDIC and other regulatory organizations. Most reports are still in use and continue to be an invaluable resource throughout both OneWest Bank and Financial Freedom.
| |
Aug 1994 to Dec 1998
|
Visual Basic Programmer and Crystal Reports Writer. Various Consulting Clients
Previous clients include:
QAVantage, Inc., Red Bank, NJ
UtiliSource (Eastern Pacific Energy), Brea, CA
KPMG Peat Marwick, LLP, Los Angeles, CA
First Consulting Group, Long Beach, CA
Transamerica Financial Services, Los Angeles, CA
The Holden Group, Los Angeles, CA
Nelson & Quillin, Los Angeles, CA
| |
Sep 1989 to Aug 1994
|
Manager, Programmer/Analyst. Transamerica Life and Annuity Corporation, Los Angeles, CA
Managed the Control Accounting department responsible for ensuring that the general ledger was balanced properly; created an application to maintain records and record payments for TSA Loans; assisted the company in transitioning from a mainframe environment to the SQL Server environment; developed several Visual Basic/SQL Server applications.
|
EDUCATION |
| |
Sep 1989 to Present
|
Various
Self-taught and became highly proficient in:
MS SQL Coding, Query Optimization, DTS and SSIS Package Creation
SQL Server Reporting Services 2000 and 2005
Cognos Impromptu
Crystal Reports
| |
Dec 1993
|
SQL Server Developer Course
| |
Sep 1979 to May 1983
|
Boston University, Boston Massachusetts, Bachelor of Science, Business Administration-Finance
|
REFERENCES |
| |
References are available on my LinkedIn Profile
http://www.linkedin.com/in/merylmeyer
|
|