SUMMARY:

Highly - skilled and detail-oriented analyst - software engineer professional bringing more than 20 years on complex database driven web and client server applications. Has a thorough understanding of the SDLC process, performed multiple roles, self-driven, initiative, dependable and worked either as a team-player or autonomous depending on the project.

TECHNICAL SKILLS:

• PL/SQL
• Stored Procedures
• MS SQL
• Oracle DBA
• IIS
• Oracle Forms & Reports 6i
• JDeveloper 11g
• C#
• ASP.NET
• Visual Studio
• MS VISIO
• MS Project
• Visual Basic 6
• HTML
• MS Access
• SSIS

PROFESSIONAL EXPERIENCE:

Senior Software Engineer

Confidential, Miami, Florida

Responsibilities:

• Create web UI pages and maintaining existing pages to enhance the booking engines and create and integrate SOAP web services.
• Design, develop, and maintain database structures, stored procedures, and sql queries in Oracle and SQL server database, using Toad, SQL Developer.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SSIS services.

Technologies : Visual Studio, C#, ASP.NET, MVC, SQL Server.

Senior Software Engineer

Confidential

Responsibilities:

• Developed and maintained PL/SQL stored procedures, ETL and triggers for supporting either bank’s new requirement or credit card’s mandates.
• Advanced experience with use of tools such as PLSQL Developer, TOAD, SQL Server Management Studio and Razor SQL.
• Performed oracle database administration and provided 24x7 production database support.
• Familiarity with client-server applications and Windows ODBC in the context of establishing and supporting connectivity and database interaction with Oracle.
• Development and monitoring of data migration/transfer processes utilizing Oracle, flat file manipulation, SFTP utilization.
• Designed and developed over 5 web services using VS 2015, C# and Oracle.
• Developed Windows based applications using WinForms technology utilizing C# and Oracle.
• Architected and developed over 15 web UI pages and maintained existing pages to enhance the POS terminal’s functionality and to resolve any bug fixing issues for the Terminal Management System provided by Mellon using VB6, HTML, IIS, and Oracle.
• Architected and developed a core system for the EFT POS Business Unit and the integration of the system with other core systems of the company including the POS factory, the Business and the Accounting department using VS 2015, C# .NET Framework 4.5.
• Delegated and supervised coding tasks.
• Received new requests and provided the analysis, design and time estimation for each project and produced high quality requirement specifications.
• Provided regularly management, statistical reports and KPIs for the CEO, the BU, the Accounting Department, and the customers (data extracted from SQL Server and Oracle).
• Collaborated with developers and test engineers to enhance existing functionality and performed extensive testing based on test data and scripts.
• Provided 3rd level support to Mellon's FLM and to customers for over 100,000 POS, this included troubleshooting, code fixes and enhancements to the products and applications.

Technologies : Oracle 11g, PL/SQL, SQL Server, Visual Studio, C#, ASP.NET, MVC, Stores Procedures, Visual Basic 6, IIS, HTML, XML, MS Access, VISIO.

Senior Software Engineer

Confidential

Responsibilities:

• Performed database programming on Oracle SQL / PL/SQL, including Cursors, Procedures, Functions and Packages, Triggers and Table Indexing.
• Creating oracle objects, including tables, views, synonyms, triggers, indexes, constraints.
• Maintained and improved an existing system on Oracle forms 6i and Reports.
• Analysis, architectural design, development and testing for the migration of the existing system from Oracle forms 6i (client/server) to Java/J2EE technologies and specifically to JDeveloper 11g, JAVA, ADF, and Oracle.
• Developed complex reports and queries to support business needs and customer requests.
• Team Leader for a group of 4 software developers.
• Produced high quality requirement specifications.
• Performed analysis, design and code reviews for small-mid size teams and bug fixes.

Technologies : Oracle 11g, Oracle Forms & Reports, Crystal Reports, JAVA, JDeveloper, PL/SQL, ADF, J2EE

Software Engineer

Confidential

Responsibilities:

• As a database programmer, created database objects in Oracle. The objects consisted of tables, views, stored procedures, triggers, indexes, and functions, used PL/SQL with TOAD.
• Developed new Software Systems, maintained and improved existing ones using Oracle Forms & Reports, JDeveloper, JAVA, ADF and Oracle.
• Familiarity with client-server applications and Windows ODBC in the context of establishing and supporting connectivity and database interaction with Oracle.
• Analysis, architectural design, development,, and support for the Information Systems constructed by ACE for the computerization of the Public Services like the Court of first Instance Athens, Administrative Court of first Instance Athens, District Judge of first Instance Athens, Justice of Peace Piraeus, Organism of Agricultural Insurance.

Technologies : Oracle Forms & Reports, Oracle, PL/SQL, JDeveloper 11g.