Oracle PL/SQL Developer

Vasily Tarasov

Redmond, WA • 650-***-**** • ************@*****.***

https://www.linkedin.com/in/VasyaTarasov

http://www.linkedin.com/in/vasyatarasov

Oracle Developer

SUMMARY OF QUALIFICATIONS:

10+ years of experience working with Oracle 8i/9i/10g/11g including physical and logical database design, creating database objects, and PL/SQL programming.

Expertise in Client/Server technology using Delphi as front-end and Oracle as back-end.

Extensive experience with data migration.

Excellent skills in understanding, debugging and fixing other people's code.

Ability to work both independently with limited general supervision and be a part of a team.

Strong analytical and problem-solving skills, quick learner.

Excellent verbal and written communication skills.

TECHNICAL SKILLS:

RDBMS: Oracle 8i/9i/10g/11g, Interbase/FireBird, MS Access

Languages: SQL, PL/SQL, Pascal/Object Pascal/Delphi, XML, HTML

Platforms: Win 9x/XP/7/8 (user), Linux (user)

Applications: PL/SQL Developer, Embarcadero RAD Studio, Subversion(SVN), Erwin, MS Office

RELEVANT WORK EXPERIENCE:

Senior Software Developer 03/2008-08/2015

SGB BANK, http://www.severgazbank.ru/

Responsible for self-dependent creating client and server parts of the banking software according to the business requirements to provide the services for retail customers, such as bank deposits, remittances, accounting, foreign exchange, cash transactions, as well as exchange of information with tax authorities etc.

Merged retail banking software with a third-party system for online banking.

Merged the banking software with different third-party systems of money transfers.

Created, modified and tested the PL/SQL stored procedures, packages and other Oracle objects, such as tables, views, synonyms, database links, sequences etc.

Wrote and tuned complex SQL queries using joins, unions, subqueries and analytical functions to retrieve data from the database.

Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.

Explored the subject area and chose the best way of resolving a problem.

Acted as adviser to engineers of support service and developers of lower levels.

Prepared scripts, tested them and finally performed data migration between separated servers in connection with the consolidation of the bank branches.

Utilized expert-level knowledge of relational database concepts, including interacting with databases from client applications using stored procedures.

Software Developer 12/2005-03/2008

SGB BANK, http://www.severgazbank.ru/, outsourcing at SBS Project Ltd.

Created and modified the PL/SQL stored procedures, packages and other objects according to the business requirement

Created tables, views, synonyms, database links, sequences etc.

Involved in analysis, design, coding and testing.

Involved in creating Database Design (physical and logical) as per the requirement given by business.

Exhibited experience working with relational databases

Designed systems and programs to meet complex business needs.

Prepared detailed specifications from which programs are developed and coded. Ensured programs meet standards and technical specifications.

Created and processed XML-, TXT-, DOC-, XML-files for exchanging information with different organizations

Developed forms, reports, and algorithms for front-end.

Technical support engineer 05/2005-12/2005

SGB BANK, http://www.severgazbank.ru/

Installed and supported the banking software.

Analyzed managers’ claims to the functionality of the software and took measures to eliminate errors.

Prepared user manuals and technical documentation.

Tested the banking software developed by programmers.

Worked at the hotline for the users of banking software.

Trained users to use banking programs and provided technical assistance.

Installed and tested programs at user sites.

Expert in automation of banking processes 12/2001-05/2005

Industrial and Construction Bank

Developed reports according to the business requirements

Wrote and tuned SQL queries and worked with Oracle objects including tables, views, triggers, stored procedures, packages, and jobs.

Developed user interfaces with Delphi.

EDUCATION:

Cherepovets State University, Russia

Bachelor’s degree in Computer Science (1998)

Engineer’s degree in Computer Science (1999)

Contact this candidate