Helen Adebayo
SQL Developer, Microsoft SQL Server and PostgreSQL
Atlanta, GAhelen.adebayo@example.com(404) 555-0126Summary
SQL developer with six years of experience designing schemas, writing stored procedures and tuning queries for databases holding several terabytes of claims and shipment data. Rebuilt an insurer's nightly claims load so it finishes in 40 minutes instead of five hours, and cut the slowest customer-facing reports from minutes to seconds. Careful about data integrity, and fluent with the analysts and developers who depend on the database.
Experience
SQL Developer, Sentinel Ridge Insurance
– Present
Atlanta, GA
- Own about 200 stored procedures and 30 SSIS packages behind the policy administration and claims systems on SQL Server 2019, covering roughly 4 terabytes of data.
- Redesigned the nightly claims warehouse load with incremental change tracking and partition switching, bringing the run from five hours to 40 minutes and ending the morning report delays.
- Tuned the fifteen slowest agent-facing reports through indexing and query rewrites, with the worst dropping from four minutes to under three seconds.
- Built the data model and procedures for a new pet insurance product, working from the actuaries' requirements to a schema that launched on time.
Database Developer, Greenmark Logistics Analytics
–
Marietta, GA
- Developed PostgreSQL schemas and functions for a shipment tracking platform ingesting about 2 million location events a day.
- Wrote the deduplication and late-arrival handling for carrier feeds, cutting duplicate shipment records reported by customers by more than 90 percent.
- Created the reporting views and scheduled extracts used by 40 customer analysts, replacing hand-written queries that had produced inconsistent totals.
Education
Bachelor of Science in Computer Information Systems
Altamaha State University, Statesboro, GA
Skills
- T-SQL and PL/pgSQL
- Microsoft SQL Server 2016-2022
- PostgreSQL
- Query tuning and execution plans
- Indexing and partitioning
- SSIS and SSRS
- Stored procedures and functions
- Data modeling and normalization
- ETL and incremental loads
- Azure Data Factory
- Git and database version control
- Power BI
Certifications
- Microsoft Certified: Azure Database Administrator Associate, Microsoft,