SUMMARY:

• Specializing in Microsoft SQL Server - Design, Development, Performance Tuning, ETL
• Now moving into cloud database work - Amazon, Google, Azure
• Also, blockchain development with Hyperledger Fabric

PROFESSIONAL EXPERIENCE:

Confidential, New York NY

Senior Cloud Database Architect

Responsibilities:

• Finding ways to merge multiple data sources in the cloud for integrated reporting.
• Developed new database architecture transposing hundreds of columns into thin optimized data store
• Built JSON extraction in Python, batch jobs on EC2 to load RDS, then set up Lambda for real-time data
• Comparing performance and usability between RDS, Aurora PostgreSQL and Redshift
• Astor Services for Children & Families Rhinebeck NY

  Non-profit center for children’s mental health and family services

  Senior Database ConsultantSQL Server 2014, Pentaho, Tableau

  Developed data mart structures and complex stored procedures to transform data from dozens of user-defined tables with hundreds of columns in numerous historical versions into a well-designed structure for institution-wide reports. Created BI reports using Tableau and PowerBI.

• Created a coherent data-set from previously inaccessible tables.
• Enabled reporting on state-approved metrics required for multi-million-dollar grants.

Confidential

Senior Database Developer

Responsibilities:

• Created a system for tracking patient HHC scores.
• Created a system for finding possible insurance underpayments.
• Wrote optimized code for determining third next available appointments.
• Made it possible to archive healthcare data from purposely obscure vendor data format.

Confidential, NY

Senior Database Analyst

Responsibilities:

• Created simple tool for querying patient data originally stored in obscure vendor format.
• FocusVision - Completed a database redesign for a company that provides real-time video streaming services for product focus groups around the world. Transformed a legacy database into an efficient, fully normalized OLTP schema with complete ETL code.
• Preferred Mortgage Services - Redesigned data models for mortgage payment processing. Wrote complex ETL to move data from old models to new.
• Flare Online - Developed a workflow system for wind mitigation property inspections in Florida. SQL Server backend, ASP.Net/Silverlight frontend. Created and managed an offshore team to assist in the development effort (6 developers, 2 QA, 2 graphic designers).

Confidential, NY

Senior Database Architect

Responsibilities:

• Created a software system to analyze the marginal impact of property reinsurance treaties on a worldwide portfolio. Loss data was imported from the AIR modeling tool (CATRADER). Each treaty and submission was analyzed to determine its profitability and its impact on the portfolio according to risk measures such as EPD and PML. Database exceeded 60GB.
• Developed a Portfolio Report reviewed daily by the Senior Property Cat Underwriter and the Chief Operating Officer during the renewal season to determine which treaties to accept or renew. This report listed every treaty in our portfolio with key profit/risk metrics including marginal impact.
• Built report into a comprehensive Portfolio Tracking system. Overnight jobs updated our “future” portfolio and provided detailed reports including history, losses by zone at various exceedance levels, occurrence limit aggregation by zone, ranking by marginal impact of various risk measures, contribution by treaty to worst years and events, and capital pricing allocation.
• Created a system for disaster loss tracking, combining underwriter's estimates, modeling estimates, and claims data for specific Cat events as they affected each individual treaty. This application was run every quarter to determine IBNR.
• Created a data warehouse of location data from RMS RiskLink files and AIR CLASIC files. Stored multiple data points including state, county, zip code, construction class, occupancy type, distance from coast and geocoding This allowed modelers and technical underwriters to quickly sift through millions of insured properties to locate any data anomalies that could affect pricing.
• Created a data conversion tool to import RMS EDM files (exposure data) directly into AIR databases using set-based imports. This was much faster than the vendor’s tool (from AIR), which required export to text files and line-by-line processing.

Confidential, NY

Senior Database Engineer

Responsibilities:

• Reduced query response time from 5 minutes to 5 seconds.
• Rewrote trade processing code using set logic.
• Reworked a complex stored procedure batch job to use joins instead of cursors. Reworked ASP code while rewriting queries to optimize performance (reducing joins, fixing index structure). Also filled in as production DBA, creating & modifying data structures, maintaining data diagrams, tracking down locking problems, etc.
• Reduced run time from hours to minutes.
• Designed back end databases for multiple web sites.

Confidential

SQL Server consultant

Responsibilities:

• For an ecommerce company, reviewed database design, wrote queries, developed multi-stage download scripts for batch jobs using ftp, bcp & dts (including email notifications), selected indexes based on query patterns, wrote triggers, constraints, and stored procedures, did type conversions from flat file data, generated DDL scripts, worked with visual data models to create referential integrity constraints, and produced complete documentation.
• Helped redesign all computer systems for the Department of Parks & Recreation. Lead data analyst and data modeler. Interviewed client extensively and redesigned their financial databases (from old Prime platform). Used Microsoft SQL Server 7.0 to import & restructure data. Created various custom reports.
• Optimized performance for a high-volume OLTP database. Tutored client on various technology issues.
• Wrote database app for a Voice-over-IP firm using SQL Server & Delphi.
• Created a database application to keep track of all contract data for an international reinsurance firm. Analyzed existing Lotus Notes application and rewrote in Delphi 3.0. Redesigned flat-file database into a normalized relational database in SQL Server 6.5. Performed complex data port. Maintained existing functionality and added new features.

Confidential

Founder, President, Principal Developer

Responsibilities:

• Have helped hundreds of people grieve their property taxes.
• High success rates, with customers frequently saving 20-30% per year.
• Currently have data on over 2 million homes in upstate New York; plan to expand nation-wide

Confidential

Inventor, Developer

Responsibilities:

• Built a large full-featured “meta-IVR” script which enabled users to build their own voice apps.
• Created a SQL Server backend and began front-end development in Python and Lua.
• The idea proved redundant eventually as internet-enabled cell phones became more available.