TECHNICAL SKILLS

Programming languages: Delphi, C#, .NET, C++, Visual Basic, PERL, JAVA, SQL

ETL/ELT systems: MS SSIS, Matillion

Report writing: Crystal Reports, Microsoft SQL Reporting Services, ReportBuilder, RAVE Reports

Maintenance applications: Visual Source Safe, Track - It, PVCS, AccuRev, StarTeam, Microsoft TFS

Microsoft Office: Word, Excel, Powerpoint, Access, Visio

Relational database management systems: Oracle, Teradata, BTrieve, IBM DB2, Microsoft SQL Server, SnowFlake

Database application systems: Netezza, DBeaver, MS Management Studio

Data Modeling application: Erwin

Software Development methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential

Sr. Lead Data Warehouse Consultant

Responsibilities:

• Lead team of contract and full - time developers to implement projects to overhaul the corporate Policy Management System and Billing system for both commercial and personal lines
• Provide guidance to project managers to help facilitate the corporate projects for requirements and project timelines
• Develop documentation process to facilitate code merges into different environments, including production release
• Oversee all production releases
• Collaborate, troubleshoot and resolve all production errors
• Collaborate with leadership to help decide what cloud-base database management system to purchase
• Collaborate with leadership to help decide what web-based ETL/ELT products to purchase
• Convert SSIS packages to Matillion (web-based ETL/ELT product)
• Lead team of developers to implement corporate data warehouse transformation project
• Develop and maintain an enterprise profit sharing solution to distribute agent commission profit
• Architect and implement an automation process to provide information to accounting department on a monthly, quarterly and yearly basis for profit sharing information
• Develop and maintain an enterprise data warehouse quote system utilizing star schema design for both personal and commercial products
• Diagnose and implement DB changes to the enterprise data warehouse quote system to increase performance, reliability and efficiency
• Architect and implement an automated process to provide daily information from the enterprise data warehouse quote system for both personal and commercial products
• Provide re-design recommendations to the enterprise quote data warehouse for new products to be added
• Develop the logical and physical model for commercial line data for integration into enterprise data store for the data warehouse transformation project
• Develop the physical model for personal lines data in the enterprise data store for the data warehouse transformation project
• Develop and design the SSIS package templates and Matillion templates for loading data to the enterprise data store staging area
• Develop and design the SSIS package templates and Matillion templates for loading data into the enterprise data store
• Architect and model commercial and personal lines data for integration into the enterprise data store for data warehouse transformation project
• Develop data modeling standard naming convention, data type and keywords for enterprise data store data warehouse transformation project
• Develop and collaborated on data mapping documentation for all columns in the enterprise data store transformation project
• Architect and develop the process to provide business with constant data from the data warehouse
• Provide SQL advise to the report developers for data warehouse data to be reported on in MicroStrategy, QlikView and Tableau

Confidential

Programmer Analyst

Responsibilities:

• Maintain existing insurance policy system
• Design and develop the initial phase of new corporate printing services
• Create SQL scripts to change database table structures for corporate printing services
• Develop and maintain application to implement actuarial rate change
• Utilize MS Reporting Services report to create financial and actuarial reports
• Covert existing report applications to MS Reports Services reports
• Design and develop a distributed work system
• Diagnose and implement DB changes to increase speed and performance
• Developed corporate data warehouse utilizing data vault design
• Increased monthly accounting process three-fold utilizing data warehouse design

Confidential

Software Engineer, Contractor

Responsibilities:

• Develop and maintain existing proprietary software
• Implement UDP messaging between hardware system and software
• Develop utility programs for programming hardware system component
• Re-factor existing software code
• Produce HTM/HTML pages to report hardware system and components information
• Capture, interpret and ensure real-time data accuracy
• Utilize XSL to produce XML pages in reporting hardware component accuracy
• Utilize HTML to create and maintain software help system documents
• Develop and maintain small in-house programs (ie Serial Number generator, System Calibrations, Certificate of Calibration, etc)

Confidential

Crystal Reports Developer, Contractor

Responsibilities:

• Develop ledger reports for company Certified Public Accountant
• Develop company profit reports for Chief Technical Officer
• Develop ad-hoc quarterly reports for Chief Technical Officer
• Develop company quarterly project reports for Project Managers
• Train and assist in Crystal Reports development
• Implement and maintain Oracle tables for Crystal Reports

Confidential

Software Engineer

Responsibilities:

• Develop and maintain in-house accounting system
• Develop and maintain accounting system security program
• Utilize Crystal Reports 8.5 to create and maintain reports in accounting system
• Train new accounting system features to management and end-users both locally and outside offices
• Schedule new accounting releases with management
• Support Crystal Enterprise 9 administration regarding security rights, user accounts, maintaining and publishing reports
• Create ad-hoc reports using Crystal Reports 8.5, 9 and 10 for management and accounting users
• Provide customer service for 50+ accounting system users
• Provide technical support for over 100 users
• Utilize SQL to extract and post data to Oracle 8.5 database for the accounting system
• Generate SQL statement to produce ad-hoc accounting system reports in Crystal Reports 8.5
• Manipulate Crystal Reports generated SQL for efficiency and speed