Craig Sommerman
San Diego,CA
Summary
Thorough SQL Developer with expert grasp of SQL code generation, analytics, reporting and business intelligence. Diverse knowledge of complex T-SQL coding instances. Conversant in up-to-date and legacy programming languages, standards and tools. Adept in leading all stages of software development and troubleshooting.
Overview
13
13
years of professional experience
Work History
Database Analyst
Plaza Home Mortgage
San Diego, California
09.2014 - 03.2021
- Design SQL Database for onboarding of loan operations system
- Created optimal technical solutions to user needs with in-depth system analysis.
- Devised high-quality database solutions ranging in size and complexity, increasing productivity and improving data sharing.
- Design and implement automated reporting via SQL Server Reporting Service(SSRS) and Power BI
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Worked closely with business users in project requirement gathering, testing and QA.
- Utilized Joins, sub-queries, CTE's and Temp Tables to simplify complex queries involving multiple tables while optimizing procedures and triggers in production.
- Created store procedures, functions, views, tables, triggers, keys, and indexes and cross apply to optimize day to day data maintenance and reporting functionality.
- Involved in creating Jobs, SQL Mail Agent, Alerts, and Scheldule SSIS, DTS Packages
- Lead Analyst is conversion of all legacy crystal reports onto PowerBI platform
Business Systems Analyst
Union Bank Of California
San Diego, CA
01.2008 - 09.2014
- Organized system operating procedures to strengthen controls.
- Identified needed business improvements and determined appropriate systems required to implement solutions.
- Trained business personnel in use of systems.
- Analyze and re-engineer business processes to increase efficiency and cut costs
- Coordinate with technical staff to maintain software lifecycles and security
- Act as single point of contact for end-users with technical/functional issues with regard to the Intellimatch application.
- Provide an effective IT consultancy service that identifies and promotes best practices
Education
Bachelor of Arts - Economics
SUNY At Buffalo
Buffalo, NY05.2000
Skills
- Languages: SQL MySQL, MS SQL Server 2016/14/12/08, DB2 v81
- Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server
- Operating System: Windows 08/07/05/NT/XP
- Tools: MS Visual Studio, MS Office (Word, Excel, PowerPoint, Access)
- Database Optimization
- SQL Server Database
- Microsoft Power BI
Timeline
Database Analyst
Plaza Home Mortgage
09.2014 - 03.2021
Business Systems Analyst
Union Bank Of California
01.2008 - 09.2014
Bachelor of Arts - Economics
SUNY At Buffalo
Similar Profiles
Dawn L SeatonDawn L Seaton
Mortgage Loan Processor at Plaza Home MortgageMortgage Loan Processor at Plaza Home Mortgage
Hamid ShahHamid Shah
Van Driver/ Salesman at Plaza Home MortgageVan Driver/ Salesman at Plaza Home Mortgage
Bryana JarboeBryana Jarboe
RESPA Specialist at Plaza Home MortgageRESPA Specialist at Plaza Home Mortgage