Data Engineer Sql Developer

Sasa Draskovic

Aliso Viejo, CA ******@***.***

949-***-**** linkedin.com/in/sasa-draskovic

SQL Developer

Seasoned Data Engineer, Architect, and DBA professional with 20+ of experience in data engineering and database principles. Collaborative developer utilizes extensive knowledge in relational database technology, SQL queries, PL/SQL, programming languages, DBA administration, application tuning, and dashboarding. Strategist drives operational excellence to support data requests. Thorough analyzer implements innovative solutions that streamline processes, improve efficiency, and enhance service delivery. Coordinates with high-performing team members to drive IT solutions and analytical functions.

Core Competencies

Computer Programming Problem Solving Data Analysis SQL Analytical Functions Database Administration Performance Tuning User Queries Optimization Unix/Windows Command Line Scripting

Technical Tools

Applications: Data Warehousing Business Intelligence & Decision Support Systems Financial & Pharmaceutical Industries

DBMS: Oracle Vertica SQL Server T-SQL PostgresSQL PL/SQL MySQL GreenPlum

Tools: Python Jupyter Notebook Logical/Physical Modeling ETL Tools MS

Training: Big Data-Hadoop Data Science (ML, AI)

Professional Experience

Principal Data Engineer KDSS – Laguna Niguel, CA Mar 2019 – Present

–Designed and created analytical data sets using advanced SQL queries to support data scientists on-going data requests.

–Fixed performance issues by migrating from slow-running MySQL database system to GreenPlum to run reports faster.

SQL, PL/SQL, and Oracle Instructor (Contract) Learning Tree International – Reston, VA Sep 1995 – Present

–Certified Oracle professionals by teaching courses in Relational Database Principles, Data Modeling, Physical Implementation, Oracle 11g/12c, Backup and Recovery and Tuning of Oracle Servers, and PL/SQL Programming.

–Enriched courses with examples of real-life problems to help students solve similar issues in their company environments.

–Directed lessons and assignments, and resolved technical difficulties, to teach in-class and remote students concurrently.

Principal Data Engineer AFINITI – Washington, DC Oct 2019 – Sep 2023

–Resolved CRM file with data changed that would cause data model to score poorly by running data trend report to quickly make new training set to retrain model to see the data changes, resulting in model running successfully and seamlessly.

–Developed and installed new method approach to improve efficiency and accuracy of model validation procedure.

–Met with team members and new clients to clarify their needs and objectives to develop correct models and matrixes.

Data Engineer/Architect (contract) ADP – Costa Mesa, CA Jan 2018 – Dec 2018

–Created and scheduled SQL reports against Data Warehouse to support Marketing department, used analytic functions to improve performance, and utilized Unix and Window command-line interfaces for scripts and schedules.

–Redesigned data model to restructure tables for ease of maintenance, utilized Tableau for visual presentations when managing data analytics and critical business data, and formed reports using Talend to support executives and other business functions.

Oracle DBA/PL SQL Developer (contract) US Pharmacopeia – Rockville, MD Apr 2002 – May 2018

–Managed daily database administrative functions, including monitoring query performance, developing stored procedures, functions, packages, and triggers for power users, and analyzing and rebuilding indexes to improve response times.

–Maintained Oracle 9i and Oracle 10g database, utilized SQL*Loader to load data from external files to Oracle tables daily and weekly, and helped redesign backup and recovery strategies for major company applications.

–Served on team responsible for logical database design, physical implementation, and quarterly capacity planning.

–Provided daily performance and user queries tuning, including SQL queries tuning, using different diagnostic tools (such as TKPROF and Explain plan), and performed regular tables Exports/Imports to reduce fragmentation problem.

–Supported Oracle database growth from several Gb to over half a Terabyte by partnering with IT backup strategy teams.

Oracle DBA (Contract) Sanwa Bank – Monterey Park, CA

–Maintained Oracle 7/8i databases, rebuilt indexes to improve performances, and reduced space usage from frequent row deletes by allying with IT team on backup strategy design and implementation and ongoing database capacity planning.

–Handled account setup and access policy and led SQL optimization to cut query processing time from hours to minutes.

Education

MS in Computer Science, BS in Electrical Engineering University of Belgrade – Belgrade, Serbia

Contact this candidate