Uploaded File
add photo
Aleks
Alex.Kaydanov@gmail.com
908-420-3683
17 Purcell Rd
Bridgewater, NJ 08807
908-420-3683
Sr. Database Developer
25 years experience W2
0
Recommendations
Average rating
36
Profile views
Summary

  • Broad experience in design and analysis of application systems. Involved in all phases of the Software Development Life Cycle, including system analysis, design, development, testing, debugging, documentation and implementation
  • Experience working as Team Lead with Business Analysts and QA Analysts, Offshore / onsite development and production teams
  • Experience working with complex large databases with many tables and large data volume, resolved extensive Debugging and Troubleshooting problems
  • Experience in solving performance analysis and tuning issues
  • Extensive working experience with Oracle 11g and PL/SQL (writing packages and procedures, database triggers, etc.), experience in writing complex queries for the purpose of Data Analysis using ANSI Oracle SQL
  • Hands on experience working in Linux environment including writing of Shell scripts

Experience
Sr. Database Developer
Information Technology
Aug 2014 - Apr 2016
Nyc, NY
  • Designed, coded, tested and implemented processes, stored procedures, functions and data base triggers for the Saks Inventory and Merch OPS Systems by using Oracle PL/SQL, Linux Shell scripts
  • Involved in all phases of the Software Development Life Cycle, including system analysis, design, coding, testing, debugging, documentation and implementation
  • Maintenance and production support different parts of Saks Inventory and Merch OPS Systems by using Oracle, DB2 and Linux tools
  • Developed and Implemented reports by using Oracle SQL, SQL*Plus, PL/SQL
  • Submitted corresponding batch processes and reports by using UC4 software, Linux Shell scripting
  • Designed Ad-Hoc and On-Line Reports by using Oracle tools
  • Resolved extensive Debugging and Troubleshooting problems of the systems
  • Fully responsible for performance analysis and tuning of applications
  • Fully responsible for Bulk Update and loading data
  • Designed, coded, tested and implemented processes for PIM (Product Information Management - Informatica) by using Oracle SQL, SQL*PLUS, PL/SQL and Linux Shell scripts
  • Provided support for over 30 end-users
  • Fully responsible for Root cause analysis (RCA)
  • Created documentations for the Saks Inventory and Merch OPS Systems
  • SMTD and Understanding documents
  • User Interface
  • Designed and created Data Flow Diagrams
  • Entity Relationship Diagrams and narrative of procedures
SQL Database Design Stored Procedure DB2 Oracle PL/SQL Triggers Shell Scripts Linux Scripting
Remove Skill
Sr. PL/SQL Developer
Information Technology
May 2013 - Feb 2014
Bedminster, NJ
  • Technical Leader on Inventory Management System
  • Designed, coded, tested and implemented programs, stored procedures and data base triggers for the CATS Inventory management System by using Oracle PL/SQL
  • Involved in all phases of the Software Development Life Cycle, including system analysis, design, coding, testing, debugging and documentation
  • Maintenance and production support different parts of the CATS Inventory management system by using Oracle and Linux tools. Provided support for over 100 end-users
  • Developed and Implemented On-Line programs for VerizonWireless by using Oracle SQL, SQL*Plus, PL/SQL
  • Submitted corresponding batch processes by using Autosys and Linux Shell scripting
  • Designed Ad-Hoc and On-Line Reports by using Oracle SQL*PLUS, and MS Office tools
  • Resolved extensive Debugging and Troubleshooting problems of the systems
  • Researching interface transaction errors between PSFT and CATS, pulling report data from the application using SQL and PL/SQL and working with the System Administration team and the vendor to resolve code defects
  • Fully responsible for performance analysis and tuning of applications
  • Provided support for over 200 end-users
  • Fully responsible for Root cause analysis (RCA)
  • Created documentations for the CATS & PSFT Inventory management system
  • SMTD and Understanding documents
  • User Interface
  • Designed and created Data Flow Diagrams
  • Entity Relationship Diagrams and narrative of procedures
  • CATS & PSFT objects
SQL Stored Procedure Oracle Triggers SQL Developer Linux Production Support Shell Scripts System Administration System Analysis Scripting PL/SQL
Remove Skill
Sr. PL/SQL Developer
Information Technology
Sep 2011 - Jun 2013
Boston, MA
  • Team leader on all applications involved in
  • Designed, coded, tested and implemented programs, stored procedures and data base triggers, functions and materialize view for COTT, OMAC, SOLAR Systems by using Oracle PL/SQL, MS SQL Server, DB2
  • Maintained and supported different parts of the client system (COTT, OMAC, Solar Systems) and provided support for over 100 end-users
  • Developed and Implemented On-Line and Batch programs by using Oracle SQL, SQL*Plus, PL/SQL
  • Submitted corresponding batch processes by using Oracle DBMS_JOB package, Linux Shell scripting and AutoSys
  • Designed User Interface as well as Ad-Hoc and On-Line Reports (Tabular, Master Detail, Form, Form Letter, Matrix reports) by using Oracle SQL*PLUS, Oracle Reports 10g
  • Resolved extensive Debugging and Troubleshooting problems of the systems
  • Fully responsible for maintenance and production support by using Oracle, DB2, MS SQL Server and Linux tools
  • Worked closely with offshore team to provide production support
  • Fully responsible for performance analysis and tuning of applications
  • Fully responsible for loading data
  • Fully responsible for Root cause analysis (RCA)
  • Provided support for over 150 end-users
  • Coordinated and performed Disaster Recovery test on all applications involved in
  • Designed and created Data Flow Diagrams, Entity Relationship Diagrams and narrative of procedures, SOP, and Understanding documents, Disaster Recovery test documents for each application involved in
SQL Stored Procedure DB2 SQL Server Oracle Triggers SQL Developer Disaster Recovery Linux Production Support Shell Scripts Scripting PL/SQL
Remove Skill
Sr. Programmer Analyst
Information Technology
May 1997 - Dec 2010
Edison, NJ
  • Team leader on all the projects involved in since 2001
  • Involved in all phases of the Software Development Life Cycle, including system analysis, design, development, testing, debugging and documentation
  • Migrated old version of Oracle to new one (twice) in 2001 and 2008
  • Converted Pro*C programs into PL/SQL
  • Fully responsible for design and coding of Billing, Import, Documentation, Wharfage, Brokerage, AMS applications
  • Fully responsible for maintenance and production support by using Oracle and Linux tools
  • Designed, coded, tested and implemented programs, stored procedures and data base triggers for a shipping company
  • Resolved extensive Debugging and Troubleshooting problems of the systems
  • Developed several shell scripts to schedule batch processes
  • Loaded Mainframe’s data to ORACLE database by using Oracle SQL* Loader, Oracle Export/Import utility, FTP, and developed Ad-Hoc reports
  • Developed Import, Documentation, Billing, Wharfage, Brokerage, AMS, and Archive projects:
  • Developed background processes for corresponding projects by using Oracle SQL, SQL*PLUS, PL/SQL (Created Oracle PL/SQL Packages that include Oracle PL/SQL Procedures and Oracle PL/SQL Functions)
  • Submitted corresponding batch processes by using Oracle DBMS_JOB package
  • Developed reports (Tabular, Master Detail, Form, Form Letter, Matrix reports) for corresponding projects by using Oracle 6i, Oracle 9i, Oracle 10g, Oracle 10g Reports
  • Developed front ends for corresponding projects by using Oracle 6i, Oracle 9i, Oracle 10g, Oracle 10g Forms
  • Performed Y2K modification on 50% of all existing applications in the system
  • Fully responsible for design and coding of more than ten background processes that include numerous data base packages
  • Fully responsible for performance analysis and tuning of applications
  • Designed, developed, coded, and maintained security for all applications
  • Fully responsible for loading data
  • Worked closely with offshore development team on all projects involved in
  • Provided support for over 100 end-users
  • Designed and created Data Flow Diagrams, Entity Relationship Diagrams and narrative of procedures, SMTD, SOP, and Understanding documents for all applications involved in

SQL System Analysis Stored Procedure Oracle Triggers Linux Production Support FTP
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Computer Science
Kharkiv State Polytechnic University
Skills
Linux
2016
18
Oracle
2016
17
SQL
2016
17
Stored Procedure
2016
17
Triggers
2016
17
Production Support
2014
16
System Analysis
2014
14
FTP
2010
13
Scripting
2016
5
PL/SQL
2016
4
Shell Scripts
2016
4
DB2
2016
3
Disaster Recovery
2013
2
SQL Developer
2014
2
Database Design
2016
1
SQL Server
2013
1
System Administration
2014
1
Data Analysis
0
1