Commodity trading platform

o Cloned an existing office database setup and customized it for a new office

o Designed and implemented configured table partitioning archiving functionality

o Built data reconciliation reports

o Found and fixed business-logic bugs

o Analyzed AWR reports and proposed improvements for the most resource consuming queries

• Created internal, generic and custom reports for multiple clients
• Automated system-wide collection creation process so it takes much less time and is validated
• Improved DB model to store more dimensions for extensive reporting.
• Simplified system reports maintenance and support by having analyzed tens custom versions of system reports and created a generic version of the reports.
• Integrated GitHub repository for DB objects
• Monitored DB processes

o Created and developed dozens of PL/SQL packages to re-factor and consolidate business-logic from hundreds of stored procedures and functions used for user registration, payment processing, and site niches calculation.

o From scratch designed relational database model: tables, indexes, triggers, views and developed PL/SQL packages for user search, partner commission calculation, events & communities.

o Developed PL/SQL packages for Java and PHP applications.

o Data schemas design and optimization to make them comply with third normal form by removing duplicated data into new tables and adding foreign keys. Applied denormalization when performance was critical.

o Created and modified Oracle DB schema objects to improve already existed features and add new features.

o Based on Oracle XML DB created a reporting tool for Text, HTML or Excel data presentation.

o Implemented and applied data encryption for sensitive data

o Performance tuning of OLTP and DW SQLs (CBO, hints, TKPROF, Explain plan)

o Developed ETL PL/SQL packages for bulk loading of millions of rows from external tables using multi-table, direct-path inserts.

o Introduced Oracle Advanced Queuing and improved Oracle Jobs usage in the application.

o Collaborated with end-users and business analysts to design business-logic and convert it into physical design.

o Monitored DB performance and workload using own stored procedures, Oracle Enterprise Manager, Cacti.

Data Feeds & Reports platform

o Improved functionality for download data feeds in existing PL/SQL packages, automated data feeds configuration in web UI

o Designed functionality for upload data feeds from back-end to front-end in implemented PL/SQL packages

o For hundreds of clients created hundreds of data feeds, as SQL queries plus system configuration

o Created reports for in-house SQL reporting tool

o Performance tuning of SQL queries on partitioned, multi-server DB

Billing system "Automation system of complex calculations"

o Created algorithm and program units for tariffication of long-distance calls.

o Modified many existed PL/SQL packages to correct errors or change the business-logic or tune performance.

o Created or modified many program functions that are used to control behavior of the program system.

o Created or modified many reports (forms of statistical accounting).

o Created PL/SQL packages to optimize report performance (statistical accounts). Report preparation time is decreased from 12 hours to 15 minutes.

o Performed DBA activity

o For the client-side of the application on the base of existent classes' structure made some new UI windows with DB access and some common objects for the application.