SUMMARY:

Decades of experience at Fortune 500 companies, including Confidential, Washington Mutual and 20th Century Fox. Specialize in Confidential SQL Server, T - SQL, PL-SQL, SSIS, SSRS, SSAS. Expert in database Confidential and relational design.

TECHNICAL SKILLS:

Hardware: PC; Macintosh; server; mainframe

Software: MS-SQL Server 2000 - 2012; SSRS; SSIS; SSAS (tabular);Power BI; FileMaker Pro 2.0 - 15.0, MS-Access 95 - 2016; MS-Visual Studio 2010; Business Objects, ERwin; ERStudio; Windows 2000-Win10; MS-Excel 2016; Mac OS X; MS-Word 2016; MS-Project; Visio Professional; MS-PowerPoint 2016; Visual Studio; TFS; OnBase; JIRA; Confluence

Languages: VBA, T-SQL, PL-SQL, Visual Basic.Net, Javascript

PROFESSIONAL EXPERIENCE:

Senior FileMaker Developer

Confidential, Renton, WA

Responsibilities:

• Sole developer in charge of major Hasbro product
• FileMaker 15 Advanced, Server, interface with external systems
• Release Manager - escalate bugs and resolve in JIRA

Database Specialist

Confidential, Seattle, WA

Responsibilities:

• Exposure to Salesforce platform
• Created new Confidential Access/VBA operational databases
• Research and analysis of web-based non-profit system

Database Consultant

Confidential, Seattle, WA

Responsibilities:

• Revision of Excel templates using VBA
• Use of Confidential Sales & Dynamics
• Ad hoc SQL queries

Business Analyst III

Confidential, Seattle, WA

Responsibilities:

• Project lead on migration of thousands of documents to OnBase
• Creation of MS-Access/VBA database to record fields, calculations, and SQL queries for all Mortgage Loans SSRS reports

Contract Database Developer

Confidential, Culver City, CA

Responsibilities:

• Performed Discovery with client, The Promotional Edge.
• Created new Confidential Access database to handle clients’ needs.
• Includes all tables, forms, 15 reports, relational graph, and VBA.
• Frequent WebEx sessions with client to demo new features.
• Full documentation of system including screen shots.
• On-site training of personnel

Contract Database Analyst

Confidential, Agoura, CA

Responsibilities:

• Conversion of 80+ ETLs from SSIS 2005 to SSIS 2012.
• SQL Server 2012, Oracle, creation of SQL Reporting Services reports (SSRS).
• In charge of monthly iOriginate (Home Loans) database releases, including instructions.
• Technical documentation: creation of LLD’s.
• Unit testing on lower environments.
• Troubleshoot production issues.
• Defect resolution in HP system.
• Creation of new ETLs in SSIS 2012

Senior Database Analyst

Confidential, Pasadena, CA

Responsibilities:

• Creation of ten new Access databases, many with SQL 2008 backends, for Data Production, including Vendor Assignments, Forecasts, Backlog Tracking, A&R, and Field Collections. In corporation of VBA & Jet SQL.
• Automation of formerly manual reporting processes, including AAT Reports, Vendor Assignments, Forecasts, and County Tracking.
• Creation of SSIS routine which consolidates data from eight Access tables into SQL for Acquisitions.
• Creation of SQL Server 2008 databases
• Upsize Access tables to SQL 2008 using Confidential SQL Migration Assistant
• Analysis of existing relational database structure and creation of links
• Analysis of business requirements - meetings with Business Owners to evolve specs for databases
• Training of new employees in APEX scope & software (B.A., Vendor Management)
• Technical support for APEX, including replacement of corrupt files, establishing ODBC connections, etc.
• Training in SSRS for future reporting requirements

FileMaker and MS-Access Developer

Confidential, Torrance, CA

Responsibilities:

• Discovery with business units
• Creation of ERDs and technical documentation
• Database design in FileMaker 10 Advanced using FMS 10
• Creation of new databases in MS-Access with SQL backend and VBA scripting
• User training
• Interface with .Net and SSIS

Technical Architect

Confidential, Seattle

Responsibilities:

• Sole tester for new credit engine to be used by all lines of business
• Develop MS-Access testing tools
• Lead Developer for QRS system: migrated MS-Access backend to SQL; led Team meetings and UAT effort; build management; VBA coding, relational analysis in SQL.
• Utilize Business Objects to generate reports for Consumer Lending from data warehouse
• Normalized Loan Servicing Access database and suggested complete rewrite to remake as a vital tool

Lead FileMaker Developer

Confidential, North Hollywood

Responsibilities:

• Designed and built FileMaker Pro databases for clients such as The Television Academy (Emmys), Terry Hines Advertising,
• Fixes applied onsite to existing systems at GameWorks & Christie’s Post
• Taught FileMaker and relational classes.
• Participated in design/discovery meetings with clients, including ERDs.

Technical Business Systems Manager

Confidential, L.A.

Responsibilities:

• Developed, tested, and deployed Confidential Access databases for CID Pipeline and CRA reporting.
• Developed MS Access Corporate Compliance databases so the Bank could maintain its Outstanding rating.
• Technical support for offices in L.A., Irvine, Dallas, Seattle, and New York.

Manager

Confidential

Responsibilities:

• Managed seven-person staff, including performance evaluations, hiring, and promotion
• Supervised and audited creation of profit participation statements for feature film and television product.
• Use of Access, Excel, and mainframe systems in creating participation statements.