Sql Developer Oracle Database
Resume:
Sergey Prohorenko
*** ******* ***, ***** ****, NJ 07087
201-***-**** mobile
**********.******@*****.***
Executive Profile
Seeking for a challenging position where my experience and knowledge can be efficiently utilized for the growth of the company and myself as a specialist. Oracle Database SQL certified expert (Oracle Certification Program, 2011). Experienced and talented specialist with the sense of responsibility and leadership. Good team-player. Comprehensive knowledge of PL/SQL with expertise in development of triggers, tables, collections, functions, user defined datatypes, procedures etc. Goal-oriented with ability to self-education and handle multiple tasks. Not afraid to work under pressure and complete work within limited time period. Work
Authorization
US Citizen
Technical
Knowledge
• Oracle Database 19c, 11g, 10g, Oracle DBaaS
• PL/SQL, ETL Processes, UNIX Shell scripting
• TOAD, Oracle SQL Developer, PL/SQL Developer,
• Oracle Application Express (APEX), Oracle Forms, Informatica
• Dataiku, ServiceNow
• SQL*Plus, SQL*Loader, Autosys
• GIT, SVN, Jenkins, Java Script, HTML, CSS, XML
• Mathematical packages – Maple, Mathematica, MathCAD, MATLAB Work Experience
May 2019
to present
BNY Mellon
New York, NY (https://www.bnymellon.com)
Position: Lead DB Developer
Summary:
As a Lead DB Developer at BNY Mellon, I have been responsible for leading several critical projects, focusing on the design, development, and optimization of database solutions to support various business functions. My role involved migrating codebases, implementing new functionalities, and ensuring the reliability and efficiency of financial systems. Throughout my tenure, I have played a key role in enhancing data management processes, supporting financial transactions, and providing comprehensive support and training to the team.
Primary Responsibilities:
• Database Design and Optimization:
− Designed and optimized database structures for various projects.
− Addressed performance issues and optimized execution plans to improve system efficiency.
• System Migration and Enhancement:
− Managed the Greenfield migration to Exadata, focusing on data validation and maintaining parallel environments.
− Led the migration of the codebase from Harvest to GIT, enhancing version control and collaboration.
• Coordination and Release Management:
− Coordinated communication between cross-functional teams to align tasks and complete projects on schedule.
− Managed comprehensive release preparation and deployment activities using ServiceNow.
− Submitted RFCs, gathered approvals, prepared scripts, and coordinated deployments.
• Support and Troubleshooting:
− Provided post-deployment validation and ongoing application support to ensure system reliability.
− Developed use cases and initial objects for entitlements management, ensuring scalable solutions.
Sergey Prohorenko
– resume continues –
• Training and Documentation:
− Conducted KT sessions to train team members on new functionalities and best practices.
− Prepared detailed documentation for processes, procedures, and system functionalities. January 2012
to May 2019
UBS
Weehawken, NJ (https://www.ubs.com)
Position: Senior DB Developer
Summary:
As a Senior DB Developer at UBS, I played a pivotal role in developing, enhancing, and maintaining critical applications for trading and risk management. My responsibilities spanned across multiple high-impact projects such as Bookstore NG, the old version of Bookstore, and Trading Mandates. These projects focused on controlling trading books, maintaining the authoritative source of book status, and enforcing internal controls to prevent unauthorized trading. Primary Responsibilities:
• Database Development and Management:
− Developed and handled PL/SQL Packages, Procedures, Tables, Views, Indexes, Synonyms, Triggers, Functions, Materialized Views, and Sequences.
− Created and managed ETL processes to transform and load data from different sources.
− Performed bulk data loads into database tables using SQL*Loader.
• Application Development and Enhancement:
− Led the complete application development cycle for various projects, including designing and implementing new functionality.
− Set up environments and deployed applications, ensuring seamless integration with existing systems.
• Performance Tuning and Technical Support:
− Conducted performance tuning, analysis, troubleshooting, and provided technical support to optimize database performance.
− Developed complex reports to support business operations and decision-making.
• Internal Controls and Risk Management:
− Developed systems to enforce internal controls and prevent unauthorized trading.
− Created and managed database objects and scheduled processes to support system functionality.
− Implemented bulk data upload functionality and outbound data feeds generation.
• Business User Communication and Documentation:
− Interacted with business users to gather and analyze business requirements.
− Prepared detailed documentation for processes, procedures, and system functionalities.
− Developed business user notification systems to keep stakeholders informed of system updates and issues.
• Comprehensive Support and Problem Solving:
− Provided comprehensive support and problem-solving for complex issues.
− Ensured the reliability and efficiency of financial systems through meticulous development and maintenance.
Sergey Prohorenko
– resume continues –
September 2008
to May 2011
ScienceSoft, Inc. (http://www.scnsoft.com/)
Minsk, Belarus
Position: Oracle DB Developer
Project name: Optima. Data Access Layer
(November 2010 to May 2011)
Summary: Creation of a Data Access Layer to transfer data between database and calling environment. Primary Responsibilities:
• Remote database deployment, setup and configuration
• Scripts creation for database deployment, including scripts for packages, tables, procedures, functions, triggers, sequences. Documentation creation
• Export data from production database to development database (Imp/Exp Data Pump)
• Communication with customer. Collaboration with PHP-team members to perform common tasks Project name: Heinz Scorecard. Application Modernization
(September 2008 to May 2011)
Summary: The main idea of the project is modernizing of an existing application that was created with Oracle Forms and its migration to Oracle Application Express (APEX). Migration should be done without changing of database structure and functional features. Primary Responsibilities:
• Client connections customization
• Deployment of development environment
• Modification and maintenance of packages, triggers, complex stored functions, procedures
• Database deployment and setup. Step-by-step app modernization and migration to APEX
• Problems detection, troubleshooting and bug fixing. Program documentation creation June 2006
to September
2008
Engineering and Technical Department
of Belarusian Railway (http://www.rw.by/)
Minsk, Belarus
Position: Software Engineer
Company Activity: Development, implementation and maintenance of software, manufacturing of related equipment.
Primary Responsibilities:
• Implementation and support of railway logistic software
• Training users of distributed software
• Development and maintenance of electronic information board
• Multimedia support and information support of company activities
• Support and information content management of the Belarusian Railway official website Education • Belarusian State University – Mathematics, master's and bachelor's degrees, 2002-2007
• Belarusian State University – Economics and finance, 2004 – 2007 Certificates and
Trainings
• Oracle Database SQL Certified Expert – Oracle Certification Program, 2011
• Professional Certificate in “The development of dynamic Web-pages with a help of JavaScript”, 2007
• Professional Certificate in “Using of CorelDraw in graphic design”, 2007
*References are available on request
Contact this candidate