Greg Gerardis Email & Phone Number

Moorpark, California, United States

I write/modify/optimize SQL Server and Snowflake queries, stored procedures, tasks and functions for the Cash Management team. I also create and migrate database objects. Additionally, I create and modify Tableau, Report Builder and Excel reports for senior management.

Moorpark, California

Led project to convert SQL Server scripts, stored procedures, Report Builder reports, MS Access databases and Excel data connections from SQL Server to Snowflake syntax for the Investor Accounting departmentLed training of the Investor Accounting department for the conversion to the Snowflake database platform including SQL query design, interface functionality, ODBC configuration and connection to MS Excel, Access and Report BuilderDeveloped Microsoft SQL code, built automated MS Access databases and Excel pivot table reports for analysis, testing and validation purposes of our new in-house mortgage operations applicationBuilt new and modified existing Excel pivot table reports and corresponding Access databasesBuilt ad hoc SQL code, Access databases and Excel pivot table reportsBuilt and modified Report Builder reports for the Investor Accounting department

Moorpark, Ca

• Develop Microsoft SQL code, build automated MS Access databases and Excel pivot table reports for analysis, testing and validation purposes of our new in-house mortgage operations application• Build new and modify existing Excel pivot table reports and corresponding Access databases• Build ad hoc SQL code, Access databases and Excel pivot table reports• Create and modify reports using Report Builder

North Hollywood, Ca

• Took over lead responsibilities for the post-acute software migration from IPC Link to gEHRiMed• Created SQL Server stored procedures to identify providers who are not using app software for which TeamHealth is paying license fees which sends them SQL generated emails to either use the software or their license will be removed• Managed billing exceptions for providers, facilities, billing & CPT codes using a combination of Oracle, SQL Server and MS Access

Pasadena, Ca

I created a new SQL Server database for the Property Accounting department including the following objects: tables, views, indexes and stored procedures. I later created SSIS packages to ETL the data from text export files generated by Kaiser’s Web-based accounting system into the new database. I then created two OLAP cubes along with some pivot table reports for the end users in the Property Accounting department in order to help them identify and correct imbalances between their Project Costing Sub-Ledger and their General Ledger.I helped to normalize and optimize the Medicaid finance database by re-defining data types, adding indexes and defining primary key values. Later, I created SSIS packages to load the data from the planned partner ASCII source files into the newly normalized SQL Server tables in the Medicaid Finance database.

Los Angeles, Ca

I created SSIS packages to ETL data from the Oracle main database into the local Marketing SQL Server database.I converted a Microsoft Access solution used for importing, manipulating and reporting on Oracle source data in order to determine MROI (Marketing ROI) and the vertical lift of Marketing campaigns into a much more robust and efficient SQL Server stored procedure and a series of SSRS reports.I created a number of automated MS Access solutions to import data from the Oracle main database into the local Marketing SQL Server database.

Westlake Village, Ca

I wrote T-SQL code and created SQL Server stored procedures as well as created SSIS packages for reporting and analysis purposes.Created and maintained RDLC server side reports.Modified RDLC reports.Developed T-SQL code, stored procedures, tables as well as SSIS packages for theLarge Group Request for Quotes report which helped track quote requests made by large companies throughout the life cycle of the quote.Developed T-SQL code, stored procedures and tables for the Broker Production report which helped management determine the productivity of Brokers in the system.Developed T-SQL code to help resolve production report issues

Sylmar, California

I was responsible for SQL Server 2008 administration and database development. I created SQL code, tables, stored procedures, functions, indexes and other objects as well as SSIS packages and SSRS reports for various business related activities.

Moorpark, California

I developed SQL queries, stored procedures and functions, and well as created and modifed SSIS packages, SSRS reports for mortgage related servicing activities and reporting.

West Hills, California

Helped to build the new data mart for the mortgage department by developing SQL, stored procedures, functions, SSIS and SSRS packages for the appeals process and reporting. The data was normalized into third normal form into my dimension tables, and then denormalized into a central fact table which the business unit queries and uses as their main source for reporting.Built a front-end Excel interface and corresponding SQL Server tables which were used to track eligibility, status, remediation and Service Level Agreement (SLA) for HAMP loan modifications. Developed the Excel VBA Code and SQL code/stored procedures, and designed the front-end Graphical User Interface that Managers could use to query individual associate and/or team performance metrics as well as other metrics for HAMP loan modifications.Developed SQL Server stored procedures and functions, and assisted in the building the SSIS package for a large team project that was created to calculate interest, fees, loan balance and other key mortgage related data for HAMP loans.Created and configured a SharePoint home site used to link all other SharePoint sites in the Home Loan and Insurance department.

Woodland Hills, California

Developed Visual Basic scripts and configured the Serena TeamTrack application workflows for SDLC project tracking which resulted in an estimated savings of over $100,000 annually.Developed MS Access VBA code, SQL code and designed Access forms and objects for the policyIQ SOX compliance application.Wrote SQL and performed UAT testing for the new TrialWorks branch/corporate Legal application that was built in-house by the vendor.Provided production support for several of the applications that I helped build and configure.

Woodland Hills, California

Developed MS Word VBA code for the Case Manager legal document generation application which resulted in a significant reduction in user-entry errors and labor hours.Led a project to install, configure and validate an upgrade for the Oracle FIS/AutoDesk Map application that resulted in an estimated savings of $40,000 annually.Led a project to create a SharePoint Website for the Corporate Legal Department which saved the company an estimated $50,000 annually in penalties and late filing fees.