Database Developer

• Oct 2020 - Present

Software Engineer (Contract)

• Jan 2019 - May 2020

Designed and developed integration solutions for systems: Oracle Retail Merchandising System (RMS), Oracle Retail Predictive Analytical Server (RPAS), Oracle Retail Sales Audit (ReSA), Oracle Retail Price Management (RPM), FlexPLM Developed Labeling interface for data-exchange between LLL databases and clients. Analyzed and modified code for problem resolution and performance optimizations. Improved the interface performance by 4 times. Environment: Oracle RDBMS 12c/11, SQL Developer, TOAD, AWS services, WebLogic Server 11g, TomCat, Linux / PS scripts, Jira, Confluence, GitHub, Kafka Show less

Software Developer (Contract)

• Nov 2017 - Nov 2018

- Full stack development of the pension and benefits platform modules using Oracle APEX. (PL/SQL, JavaScript, HTML, CSS, AJAX, JQuery) - Created data changes audit mechanism. Developed backup procedures for AWS. (Shell scripts) - Integrated ClubHouse project management tool and in-house version control system (REST, JSON, APEX) -Supported and migrated legacy systems (JDeveloper and Oracle Forms) Environment: Oracle RDBMS 12c, Oracle APEX 5.x,18.1, Oracle Forms&Reports, JDeveloper 11g/12c, SQL Developer, TOAD, AWS services, WebLogic Server 11g, TomCat, Linux / PS scripts, ClubHouse Show less

IT Consultant/Independent Contractor

• Jan 2017 - Aug 2018

Analyzed data consuming processes. Redistributed applications, Rescheduled Oracle job and OS tasks. Optimized SQL queries. Redesigned index and data storage strategy (Oracle). Performed review of source code (PL/SQL, Java, Bash). Analyzed data consuming processes. Redistributed applications, Rescheduled Oracle job and OS tasks. Optimized SQL queries. Redesigned index and data storage strategy (Oracle). Performed review of source code (PL/SQL, Java, Bash).

Software Developer

• Nov 2013 - Jun 2016

- Developed modules (Oracle forms and reports, PL/SQL, JSP, Java SE/EE) for offender management system created by Syscon Justice Systems for use by correctional agencies - Developed dashboard (HotPage project) for offender’s key information (Business logic as PL/SQL, Oracle 11g/12c, Frontend-JSP, CSS, HTML, Java, WebLogic) - Created interfaces between different banking/payment systems and ELITE. Logic was implemented on Java SE and managed by shell scripts for Linux and Windows. (PL/SQL, Java, scripts) - Created program interfaces with different Lab/healthcare systems (PL/SQL, scripts, HL7, Lua, Integration Engines - Iguana, CorePoint) - Developed bidirectional XML based dataflow interface between ELITE and remote Video Visitation centers with AQ as messaging engine (XML, Oracle AQ, JMS, MQ) - Participated in application architecture activities and data modeling - Performed code reviews; reviewed results and taken necessary corrective action - Educated team regarding Oracle/Java capabilities Environment: Oracle 10XE/11g/12c, Oracle Forms&Reports 6i/10g/11g/12c, APEX, JDeveloper 11g/12c, Eclipse, (JSP, JSTL), Drools, Guvnor, SQL Developer, WebLogic Server 11g, Linux scripts, Acccurev, HPQC, Iguana, NeoIntagrate Show less

Lead Database Developer

• Dec 2007 - Sep 2012

- Developed and maintained legacy in-house information system (~50 tables in Oracle database and ~100 Oracle forms and reports on client side) - Created new forms (Oracle Forms in character mode for Linux thin clients), reports and data queries according to changing requirements - Monitored, tuned, analyzed database performance to allocate server resources or redesign logic of stored procedures and database model to achieve optimum performance - Developed data synchronization mechanism and procedures (Oracle exp/imp utilities and automated shell scripts) between clubs and head office database - Designed and developed web solutions (Oracle APEX, VBA, Shell script) for internal company needs o Created system to support marketing campaigns allowing to track marketing letters and email postings and then analyze recipients’ answers. o Created system to gather information about existing company documentation flow and to show relationships between tasks, documents and departments o Developed sales commission tool to eliminate errors in commission calculations - Performed migration project from Oracle legacy system to new system. Designed migration strategy. Created procedures and scripts for all steps of ETL process. All data from legacy system was successfully migrated and validated. Created additional analytical reports based on SSRS as per management requests Environment: Oracle 8i/10XE/11g, Oracle Forms&Reports, APEX, Oracle ADF and JDeveloper 11g, TOAD, PHP, imp/exp , SQL*Loader, PostgreSQL, Linux shell scripting, VBA Show less

Oracle Developer

• Jun 2007 - Oct 2007

- Developed Employee Benefits Software for Multi-Employer Groups (Unions, Associations) o Analyzed system requirements and performed database design o Created new forms and reports o Supported existed system, tested it, fixed bugs. Redesigned some programming logic to improve system performance Environment: Oracle 9i/10g, Oracle Developer Suite 6i/10g, TOAD - Developed Employee Benefits Software for Multi-Employer Groups (Unions, Associations) o Analyzed system requirements and performed database design o Created new forms and reports o Supported existed system, tested it, fixed bugs. Redesigned some programming logic to improve system performance Environment: Oracle 9i/10g, Oracle Developer Suite 6i/10g, TOAD

Director of IT production and technology

• 2004 - 2006

Multi-Agent System for Region Management based on Social Passports and Smart Cards of Samara citizen (developed within federal program "Electronic Russia") - Ontology-based Internet Portal for providing socially unprotected citizens with personalized information about federal, local government and municipal social laws. o Interacted and worked with users to gather system requirements and change requests; performed system requirements analysis o Designed top-level architecture and database structure. o Performed data requirements analysis for development data transformation and migration solutions of heterogeneous complex data problems o Developed T-SQL/DTS scripts for large scale data conversions and data loads from various databases and file structures - Developed on-line compact disk print design system o Analyzed project domain and customers’ requirements, prepared technical specifications and wrote detailed design documents o Created system design, database architecture; estimated work and managed project o Developed and optimized stored procedures, tables, triggers, queries and views etc. - Prototype of resources scheduler based on multiagents technologies for www.airbus.com o Optimized MS SQL database search operations by selecting and testing out best indexing scheme - Performed steps for standardization of planning and development of information systems in Company. Applied contemporary methodology of designing (based on RUP) and Enterprise management system (MSP+MSPP) Environment: MS SQL Server 2000/2005, Oracle v9i, Oracle Developer 6i, JDeveloper, J2EE, JSP, ErWin, Rational Rose, MS Share Point, Ms Project Show less

IT Consultant

• 2003 - 2004

- Designed examination of technical development’s plans for SOK Group’s enterprises - Supervised projects which dealt with creation of information systems for corporation - Developed policies and standards in field of informational technology - Prepared reports, analyzed data and data structures from enterprises of group - Converted data and data loads from various databases and file structures Environment: DBMS MS SQL Server 2000, DTS, ErWin, MS Project, Crystal Report - Designed examination of technical development’s plans for SOK Group’s enterprises - Supervised projects which dealt with creation of information systems for corporation - Developed policies and standards in field of informational technology - Prepared reports, analyzed data and data structures from enterprises of group - Converted data and data loads from various databases and file structures Environment: DBMS MS SQL Server 2000, DTS, ErWin, MS Project, Crystal Report

Project manager / Database Analyst

• 2000 - 2003

• Developed the e-commerce solutions - Analyzed business requirements, designed and created database structures. - Programmed libraries, stored procedures and designed HTML templates. - Developed software modules, T/SQL and DTS scripts for data exchange between e-commerce site and vendors sites ( www.ingrammicro.com and www.techdata.com ). - Supported application development team in understanding the data model. - Assisted the database administrator in maintaining the databases, creating new database objects and enhancing the system performance. Environment: MS-WINDOWS NT/2000, MS BackOffice Server 4.5, MS SQL Server 7.0/2000, Delphi 5.0, CVS, ClearCase, RUP, HomeSite 4.5, ISAPI, MS.NET, C#, MS Project Show less

Project manager / Database Analyst / Programmer

• 1994 - 2000

Information system for social insurance and pension authorities of Samara region - Corporate system is based on client/server and multi-tier architecture, with Oracle RDBMS as back-end and Oracle Forms applications as front-end. system keeps and processes data about >2 million people of Samara region. - Carried out project management - Full application development cycle - Analyzed business requirements and prepared design documents by converting business requirements into technical specifications. Performed CASE development using Designer/2000. - Established conceptual design. Developed functional and information models - Designed database objects and distribution and replication rules - Designed OLAP Warehouse and tools for data analysis - Developed and programmed client/server and WEB solutions using Developer/2000 and Oracle Web Server (OWS) - Created PL/SQL stored packages. Developed plans for testing SQL performance - Tested applications. Trained end-users and provided technical support. Prepared system documentation Information system for the Samara Region Department of Building and Construction - Information system for investment management in the construction industry. Checking on distribution and using the cash flows. The corporate RDBMS system was based on client/server architecture with Oracle v 6.0 RDBMS on UNIX platform as back-end, and Forms, Report runtimes on MS-Dos platforms as front-end. - Developed front-end applications using Forms v3.0 and ReportWriter v1.1 - Performed application testing and debugging. - Prepared documentation. Trained end-users and provided technical maintenance. Environment: MS-WINDOWS 95/NT, SCO UNIX, ORACLE RDBMS v7,v8, Oracle Web Server 2.1,4.0, S-Designer, ERWin, TOAD, SQL Navigator, SQL Loader, DESIGNER/2000 v1.32,2.1, DEVELOPER/2000, DISCOVERER/2000 v.2, Context Cartridge , SQL*Forms v3.0; SQL*Menu v5.0; SQL*ReportWriter v1.1 Show less