David Sonnet Email & Phone Number

Jamison, Pa, Us

Paris, Paris - Issy-Les-Moulineaux, Fr

• Developed and maintained data pipelines using technologies such as AWS S3, Snowflake, dbt, Airflow, Github, Jenkins, Snowpipes, and Streams, processing terabytes of data daily leveraging various Snowflake features for Tableau reports. • Optimized SQL queries and data models for performance and scalability, reducing query times by 17%. Increased throughput, security, and response times by 90%.• Designed and implemented data warehouse solutions on Snowflake, including schema design, data loading strategies, and performance tuning.• Collaborated with cross-functional teams to design and implement real-time and batch data processing solutions for business intelligence and reporting.

Dublin, Ie

• Led a team of data engineers in building scalable data infrastructure on Snowflake, enabling efficient data processing and analytics for METYS, an integrated platform that provides industry-leading insights and delivers timely market pharmaceutical intelligence measurement.• Collaborated cross-functionally with data scientists, analysts, and product teams to identify data requirements and develop solutions to meet business needs.• Implemented best practices for data governance and security, ensuring compliance with industry regulations and company policies.• Mentored junior engineers and conducted training sessions on data engineering principles and technologies.• Cost Savings: Reduced Snowflake Spend by 5% • Key Project: Internal BI application. Improved performance and reduced cost by tuning application queries and environment configurations ensuring operational efficiency.

Durham, North Carolina, Us

Deliver world-class and globally scalable technology platforms and analytics applied to complex and large-scale clinical data sets, to support IQVIA's ongoing and rapid growth in real-world analytics solutions. The solutions are delivered to a variety of clients across life-science, government, payer or provider organizations. Develop and maintain OMOP data conversion ETL code based on ETL business rules RWAS Technology & Data Science.The RWAS team also curates the largest collection of de-identified real-world data in the world, from different patient care settings in 18 countries worldwide – the RWAS Tech team is at the forefront of "Big Data" in healthcare.●AWS ● Amazon Redshift ● Jenkins● Big Data ● Scrum Agile ● OMOP ●Jira● SQL Server ● Postgres ● S3 ● SQL● Subversion ● Linux ● Medical and Pharmaceutical patient level data ● Develop and maintain data conversion ETL code based on ETL business rules● Work with data analysts on refining ETL business rules● Work with QA to resolve defects found during the validation of converted data● Participate in scrum agile meetings – sprint planning, retro, backlog grooming, daily stand-ups, sprint demo● Work with data analysts to prepare demo material for each sprint

Eindhoven, Netherlands, Nl

Database developer designing stable, reliable and effective databases. Responsible for testing, optimize and maintaining new and existing databases. As part of IT/SCRUM/AGILE team, liaisons with developers to improve applications and establish best practices, solve database issues and malfunctions and provide data management support to users. In addition, collaborate with administrators and clients to provide technical support, gather user requirements and identify new features. Ensure database systems run effectively and securely. Furthermore, research and suggest new database products, services and protocols.

Fort Belvoir, Va, Us

Led team of IT professionals in the design, development, and maintenance of tailored database solutions. Assessed client needs, translated business requirements into technical specifications, and supplied user support. Delivered wide range of IT services, including database maintenance, SQL, PL/SQL programming, software product management, code and data model reviews, and guidance regarding the Oracle product set. • Leadership: Served as key member of Database Technology Group and ensured efficient operations throughout System Life Cycle, from initial analysis and design to construction and delivery.• Key Project: Appointed to serve as Team Lead for Contract Shortfall application due to subject matter expertise; headed all database activities.• Cost Savings: Auto-generated 80% of database data definition code and PL/SQL, resulting in significant reductions in development time and corresponding savings in labor costs.

Valley Forge, Pa, Us

Headed large, multi-year database implementation project for financial investment institution. Oversaw all project phases, from database design and data modeling to the construction of physical database schemas. Developed strategic plans of action to overcome obstacles to success utilizing a variety of technical tools, including several Oracle database features. • Key Project: Facilitated successful implementation of exchange traded fund (ETF) pricing database; provided technical expertise and leadership in a wide range of areas, including PL/SQL programming and ETL scripts.

Blue Bell, Pa, Us

Facilitated efficient operations by providing comprehensive IT support, including the continual assessment and maintenance of the Portico Software Suite. Encouraged professional growth and development of junior team members, and advised cross-functional personnel via presentations of database use and best IT practices. • Key Contribution: Facilitated new client acquisition through the design and deployment of reusable PL/SQL packages to streamline outside vendor data load processes. • Risk Mitigation: Engineered innovative recovery strategy utilizing RMAN and oversaw implementation for all Hosted Customer Databases.

Directed database development and maintenance projects and served as an Oracle Database Developer and DBA for 1K+ users on varying operating systems across geographic locations. Monitored system performance, troubleshot issues, and coordinated the implementation of patches and upgrades. Ensured regulatory compliance by personally completing audit tracking, and served as key technical resource to users and IT staff. • Leadership: Appointed to serve on Oracle 9i and 8i migration teams tasked with certification of new Oracle database software; presented key features to information system community.• Performance Improvement: Sparked 70% increase in database performance through the creation of reusable cost-based optimizer strategy.• Key Contributions: Minimized development time by generating 98% of the database code using Oracle Designer CASE tool and decreased database size requirements by 60%. • Cost Savings: Secured $128K in savings through the negotiation of group purchase of software tools.

Master Of Library & Information Science (Mlis), Data Modeling/Warehousing And Database Administration

Bachelor Of Arts (Ba), English Language And Literature/Letters