Sql Developer Oracle

IRINA TRUSH

Oracle Certified Senior Database Engineer / Senior PL/SQL Developer

*******@*****.*** · (LinkedIn: www.linkedin.com/in/Irina-Trush)

Qualifications Profile

Professional Oracle DB Engineer/Developer with over 20 years of experience in designing, developing, and maintaining database applications for private and government sectors. Expertise in database physical and logical design, creating complex queries, packages, procedures, functions, and triggers using Oracle technologies. Proven ability to deliver solutions for client/server and web-enabled applications with strong experience in PL/SQL, Oracle APEX, XML, JSON, SOAP/REST Web services, ColdFusion, HTML, CSS, JavaScript, PostgreSQL and T-SQL. Public Trust, US citizen.

Education and Training

M.S. degree in Computer Science, Applied Mathematics

National Technical University of Ukraine “Igor Sikorsky Kyiv Polytechnic Institute”, Kyiv, Ukraine

Certifications

Oracle Database SQL Certified Associate. Oracle

Oracle APEX 19: SQL, PL/SQL to Web Application Development Udemy, Online

Oracle Database Administration Workshop (12c, 18c, 19c). Udemy, Online

Oracle SQL Performance and Tuning Masterclass. Udemy, Online

Oracle 12c Advanced PL/SQL. Udemy, Online

Advanced ColdFusion Development, Fig Leaf Software, Washington, D.C.

Fast Track to JavaScript, Fig Leaf Software, Washington, D.C.

Java for Oracle Developers, Oracle Computer Training Center, Bethesda, MD

erwin Data Modeler training, onsite (DOL)

Technical Skills

Databases: Oracle 7 to 19c, PostgreSQL 9.0, SQL Server 2008

Development Languages: SQL, PL/SQL, Transact-SQL, PL/pgSQL, ColdFusion, JavaScript, XML, HTML, CSS

Development Environment: Oracle SQL*Plus, Oracle SQL Developer, Oracle SQL Developer Data Modeler, TOAD for Oracle, APEX 4.x,19, DBeaver, Microsoft SQL Server MS, Oracle Collaboration Suite 10g,

Oracle Forms 4.5 to 9i and Reports 2.5 to 9i, JDeveloper, 4.5 Macromedia Dreamweaver MX

Testing: CA Mercury Quality Center

Change Management: CA Service Desk, JIRA

Version Control: PVCS, CA Harvest Change Manager, GIT

Professional Experience

KMM Technologies/ SCI Group/ Leidos, Rockville, MD

Sr. DB Engineer, APR 2016 – NOV 2023

Supported National Cancer Institute’s (NIH) caDSR (metadata) project:

Mapped data elements from diverse data sources to enterprise data models, documenting relationships, constraints, and metadata for system consistency and traceability.

Analyzed, developed, and maintained logical and physical data models, ensuring alignment with evolving business requirements in a dynamic, high-volume environment

Created the process of data migration and verification from caDSR system to Oracle 19c DB.

Primarily responsible for database modeling and database object definitions. (Tables, Views, Indexes, PL/SQL stored procedures, packages, and database triggers, DB Jobs etc.)

Primary responsible for testing, data verification and DB compliance with upgraded version of Oracle 12c. Implementing developing procedures to enforce Data integrity.

Fully accountable for requirements gathering, design, code, and test of the new features and enhancements to backend of caDSR DB applications on Oracle 11g DB as backend.

Worked with System analysts and users to implement data strategies, build data flows and develop conceptual, logical and physical data model using TOAD.

Engineered design and functionality for XML generation process from CSV files.

Developed the automated process to call NCI thesaurus through REST web services and JSON, XML technology and load data to the caDSR DB for input data validation.

Writing and tuning complex SQL queries for performance and scalability.

Utilizing Extraction Transformation and Loading (ETL) techniques using SQL, PL/SQL and SQL Loader for everyday tasks.

iControl Systems USA, Bethesda, MD

Lead / Sr. DB Developer, FEB 2014 – APR 2016

Led the redesign and redevelopment of legacy Maintenance Request automation System for Product price catalog and data exchange between multiple retailers and vendors. The system interacted with Web (Harmony), EDI and data exchange applications.

Primarily responsible for back-end development and database design. Created various database objects (tables, indexes, materialized views, stored procedures and triggers), and implemented referential integrity constraints for enforcing data integrity and business rules.

Verified data for missing values and incorrect data, and then organized and structured the data according to the required formats.

Optimized ETL processes, reducing execution times by over 50%, enhancing data flow between the front-end application and backend databases

Additional duties included tasks analysis, data validation, and initial testing.

Astor & Sanders Corp., Rockville, MD

Lead / Sr. Software / Sr. DB Engineer, OCT 2011 – JAN 2014

Supported the DOL (Department of Labor) Performance and Technology Office:

Duties included all requirements and responsibilities as Application Lead/Sr. Software Developer on the E-Grants Management System. The E-Grants System is a complex web-based solution that automates the entire grant lifecycle from submission of application to award, to grant closeout, and to financial reconciliation. The system is comprised of internal and external applications, where a ColdFusion MX application server builds the front end and an Oracle 11g DB the back end. The external systems EPS, NCFMS, and grants.gov are integrated through web services (SOAP) and XML technology.

Engineered the framework for back-end development and logical database design across E-Grants application, creation of database schemas and tables, complex PL/SQL stored procedures, packages, and database triggers.

Primarily responsible for the development of numerous ad-hoc reports to support ongoing users’ needs. Contributions included tasks analysis, writing complex SQL queries, and initial testing.

Designed and implemented APEX4.0 applications for data entry, reporting, and administrative tasks for Grants GTS Pre-Award System.

Accountable for usability structure and design confirmation according to Section 508 of disability systems access compliance and information security rules.

Provided technical and system expertise to other members of the development team.

Strived to provide outstanding customer service for all DOL internal and external clients.

Closely collaborated with Quality Assurance team and end users by developing use/test cases and test plans.

Participated in writing and maintaining program and system documentation.

MANILA Consulting Group, Inc., McLean, VA

Oracle Expert Developer, OCT 2004 – SEP 2011

Supported the DOL (Department of Labor) Performance and Technology Office:

Managed the back-end development, logical and physical database design across E-Grants application, creation of database schemas and tables, complex PL/SQL stored procedures, packages, and database triggers.

Primarily responsible for the redesign, development, testing, and maintenance of a web-enabled PostgeSQL9.0 database the Job Corp Fund Allocation System application (JCFAS) which allowed running reports based on criteria selection, screens for data loading to DB from flat data files, upload different documents, and assigning them to various contracts.

Optimized a critical ETL process, reducing execution time from 8 hours to just 1 hour, resulting in faster data delivery to business stakeholders.

Led the maintenance of the Grant Tracking and Grant Electronic Management Systems which keeps track of the Grants GTS Pre-Award and Award Processes and provides the information of the actions that are taking place throughout the life of the grants.

Cherry Engineering Support Services, Inc., McLean, VA

Senior Developer, DEC 1998 – SEP 2004

Supported the DOL Employment Training Administration Office (Department of Labor):

Led the development of a web-enabled Oracle database application The application replaced the old Job Corp Fund Allocation System, which was running in a legacy program called FILEPRO. Primarily responsible for back-end development logical and physical database design; creating UI forms and reports, DB Objects (tables, views stored procedures, functions, and triggers).

Participated in development of ColdFusion Web of Workforce Investment Act WAIVER System integrated the input screens with reports (Oracle Reports 6i), e-mail, and file processing functionality.

Designed, developed, and deployed Web/DB applications for the Disability Employment Grant Program. Created tables and indexes, created stored procedures and functions used in Web pages (templates) to handle SQL queries, data insert/update, and data validations; created JavaScript functions to implement client-side data validations, form fields formatting, and calculations. Designed login process and implemented security control by session management, and integrated input screens with Oracle Reports.

Additional Experience:

R.O.W. Sciences, Inc., Rockville, MD

Programmer/Analyst, AUG 1997 – DEC 1998

Contact this candidate