Oracle PL/SQL Developer

BELLA BECHUTSKY

Sr. Oracle/ETL/PL/SQL/Application Developer

301-***-**** ********@*****.*** https://www.linkedin.com/in/bella-bechutsky-345b458/

Oracle PL/SQL Developer with extensive experience designing, developing, and maintaining enterprise database applications, ETL processes, and reporting solutions. Skilled in Oracle Database, PostgreSQL, SQL, PL/SQL, Informatica PowerCenter, and Oracle APEX. Experienced in database performance tuning, data analysis, application support, and production deployments throughout the software development lifecycle. Proven ability to collaborate with cross-functional teams to deliver reliable, scalable solutions supporting complex business and regulatory requirements.

SUMMARY

Databases: Oracle Database, PostgreSQL

Programming: Oracle SQL, PL/SQL

ETL: Informatica PowerCenter

Web Development: Oracle APEX (Application Express)

Reporting Tools: Oracle Reports 11g/12g, Oracle APEX

Software: Oracle Forms and Reports 11g/12.2.1.3/12.2.1.4

Tools: SQL Developer, DBeaver, TOAD, SQL*Plus, JIRA, TortoiseSVN, Git, Gitlab, FileZilla

WORK HISTORY

Senior Oracle/Application Developer

SYSTALEX Corporation in support of U.S. Environmental Protection Agency (EPA) U.S. Department of Commerce, Rockville, MD

07/2022 – current

Developed and maintained database solutions for multiple projects within the U.S. Environmental Protection Agency (EPA), Office of Ground Water and Drinking Water (OGWDW), supporting regulatory compliance and business operations.

Contributed to the analysis, design, development, and maintenance of the Safe Drinking Water Information System (SDWIS/STATE) using Oracle and PostgreSQL databases.

Designed, developed, and optimized Oracle database objects, including PL/SQL packages, stored procedures, functions, triggers, views, and complex SQL queries to support business processes and reporting requirements.

Improved database and application performance by tuning SQL queries, optimizing PL/SQL code, and implementing efficient database design practices.

Developed, maintained, and supported ETL workflows using Informatica PowerCenter to extract, transform, and load data from multiple source systems, improving ETL runtime while ensuring data accuracy, consistency, and integrity.

Enhanced Oracle APEX applications by implementing database enhancements, modifying application components, creating interactive and dynamic reports, and improving application usability and reporting capabilities.

Collaborated with business analysts, developers, QA engineers, and stakeholders to gather requirements, design scalable database solutions, and deliver high-quality software releases.

Participated in code reviews, unit testing, defect resolution, production deployments, and post-release support to ensure application stability and data integrity.

Supported the full Software Development Life Cycle (SDLC), including requirements analysis, design, development, testing, deployment, maintenance, and production support.

Worked in Agile/Scrum environments, participating in sprint planning, daily stand-ups, backlog refinement, and release planning to deliver iterative software enhancements.

Senior Oracle/ETL/Application Developer

PSI (Planned System International) in support of National Oceanic and Atmospheric Administration (NOAA) U.S. Department of Commerce, Silver Spring, MD

11/2006 – 07/2022

Played a key role in the development and maintenance process of NOAA wide Web-based financial Management and Reporting System (MARS) and multiple reporting applications for NOAA Fisheries.

Analyzed, designed, and developed high complexity, government business rule driven Oracle applications.

Good knowledge on logical and physical Data Modeling. Experience with Data flow diagrams, Data dictionary, entity relation modeling and the design the conceptual, logical, and physical data models necessary to support the analytic data requirements for the project reports.

Built ETL architecture and whole data loading process for Data warehouse database.

Effectively created Tables, Materialized Views, Views, and Indexes with system and custom PL/SQL objects.

Developed complex database objects like Stored Procedures, Functions (including pipeline functions), Packages, and Triggers, Types.

Expertise in debugging Oracle PL/SQL with built in Oracle database objects, building complex SQL queries by using advanced PL/SQL functions including Performance Tuning and debugging for large amounts of data.

SQL query analysis and tuning optimization to improve their performance of slow running queries.

Performed unit and system tests for all phases of development.

Performed data migration into Oracle database to the higher versions.

Expertise in Oracle Fusion Middleware, development, and deployment using Oracle 11g/12c/19c, PL/SQL, SQ*PLUS, TOAD.

Developed Oracle Forms and Reports. Performed many migrations of Forms and Reports to the higher versions.

Lead developer in the effort to migrate reporting platform from Oracle Reports to SAP Business Objects.

Created static and dynamic reports using SAP Business Objects.

Wrote and maintain functional documentation and user manuals.

Provided direction and mentoring to project teams, and effectively influences customer leadership on key decisions.

Responsible for functional analysis, enhancement, maintenance, and support resolution of production issues as they occur and daily customer support of the business users.

Senior Technical Consultant

ZAK SYSTEMS DOD, Fairfax, VA

06/2006– 10/2006

Supported conversion of Enterprise Online (EOL), Perot Systems’s DOD Resource Management (RMT) solution from SQL Server/ASP architecture to an Oracle 10G/.Net architecture.

Performed detailed analysis of current application to extract business rules and system requirements and participated in development of data model for several of the application modules, including Budget Execution, ManPower, and System Administration.

Created various DB objects and prepared deliverable scripts.

Wrote dozens of PL/SQL packages and SQL reports utilizing latest PL/SQL features.

Optimized PL/SQL packages and SQL statements.

Prepared the test scripts and documentation to be used by .Net team.

Used Oracle 10g, PL/SQL, SQL* Plus, TOAD, VSS.

Senior Oracle/Application Developer

SYSTALEX Corporation, CAMS Support Center, U.S. Department of Commerce, Gaithersburg, MD

02/1999 – 05/2006

Played a key role in the development process of Core Financial System (CFS) Data Warehouse project and various reporting applications for Department of Commerce.

Participated in requirements definition, analysis, and full system development life cycle for over ten DW applications and created prototypes.

Participated in design and coding of the DW database load processes and administrational screens.

Optimized the code, applied database security, and table partitioning using Oracle 9i new features

Developed the new data mart that refreshes via an automated update process.

Provided the impact analysis of DW applications for the various CFS projects that modified the existing data elements to accommodate new reporting and processing requirements.

Created the Budget and Expenditures reporting application.

Migrated Data Warehouse application from Oracle 8i to Oracle 9i.

Wrote technical documentation, including Detail Designs, User Manuals, Data Dictionary, and DW Administration for DW refresh and applications, and Testing Plans.

Participated in preparing application Demo and User Training documentation for clients.

Provided customer support for Census, EDA, NOAA, and NIST users.

Used Oracle Warehouse Builder, PL/SQL, SQL* Plus for Oracle 9i, TOAD, SQL optimization, database security, and table partitioning, Oracle Forms and Reports 6.0

EDUCATION

Leningrad Technological Institute of Paper Industry, Leningrad, USSR

Bachelor of Engineering, Graduated in 1984

Engineering, Computer Science, Graduated in 1986

PROFESSIONAL TRAINING

2012 Informatica Data modeling/Tuning

2006 Informatica PowerCenter 9.x Developer

2000 Oracle Database 10g: Performance Tuning

1998 Oracle Database 8i: Performance Tuning

Contact this candidate