PROFILE:

Software Engineer, senior programmer-analyst who involved in all stages of the project’s life cycle from analyzing, database design, programming, testing through data conversion, implementation, version upgrade, production support and troubleshooting in different project, responsible and cooperative team player with high individual productivity.

• 10+ years of experience in Banking and Financial area.
• Various experiences in SQL and Oracle databases which perform on Unix, Linux or Windows platforms.
• Oracle SQL, PL/SQL developer.
• Oracle ETL experience through SQL Loader, Oracle UTL files, DBMS_SQL, TEXT_IO packages and SQR.
• Oracle version upgrades (from 8.0.6 to 10g.) in financialapplications.
• Oracle version upgrades (from Oracle 8i to 9iAS.) in bankingapplications.
• Oracle Forms developer in different versions of Oracle Forms Builder.
• Reports Developer in Oracle Reports Builder, SQR, Access, and Excel with Macros.
• Data conversion from Computron to Lawson accounting system.
• Electronic Data Transfer from/tothe banks and governments FTP sites.
• A/R, EFT Debit file, Cash App. file creation in Oracle Financial Applications.
• Data warehousing in SQL server 2000.
• Web application development in Oracle APEX and Iron Speed.
• Shell scripting experience in EFT bank returns file process.
• PeopleSoft version upgrades from 8.4 to 9.1
• PeopleSoft, App. Designer and PeopleCode experience in V8.4 and V9.1.
• Oracle PL/SQL, Oracle Forms and Reports Builder instructor.

Databases

Oracle 7.0 / 8.0.6 / 8i / 9i / 10g, 11g, SQL Server 2000 / 2005 / 2008

Database Tools

Sql*Plus, SQL*Loader, PL/SQL Developer, Oracle Designer, Procedure Builder , SQL Navigator, Toad Data Modeler

Network Systems

Ipswitch WS_FTP Professional, Telnet, TCP/IP

Operating Systems

Windows XP / 2003 / 2000, HP Unix, Linux, Ms-Dos

Development Tools

Oracle APEX , Oracle Reports (3.0, 6i, 9i, 10g), Oracle Forms(5.0, 6i, 9i, 10g), Oracle Designer, Brio SQR Report Builder, Korn Shell, Jdeveloper, Iron Speed, PeopleSoft App Designer.

Languages

PL/SQL, SQL, SQR, PeopleCode, Java, Corn shell, Visual Basic, Cobol

PROFESSIONAL EXPERIENCE

2011 – Present

Senior programmer/Analyst – PeopleSoft Developer
Confidential,MA

Conversion and Production support team member in PeoplSoft Development Group.

Achievements

• PeopleSoft conversion from V8.4 to V9.1.
• Production support on AR, AP, OM, PO, AM modules.
• Conversion of the custom PL/SQL and SQL Queries.
• Resolving ODBS connection problems between Oracle and Access databases.
• Development and support on the SQR reports.
• Custom pages design and development in PS.

(Oracle11g, PL/SQL, SQL, PeopleSoft 9.1, PeopleSoft 8.4, Application Designer, Pl/SQL Developer, Liquid Planner, Access)

Senior programmer/Analyst – Oracle Developer
Confidential,Braintree, MA

I have participated in all stages of the project’s life cycle of the new CMB Project.
Achievements

• Financial Application upgrades from Oracle 8.0.6 to 10g.
• Oracle ETL experience through Electronic Data Transfer from RCAB to The Citizens Bank.
• Oracle ETL experience through A/R, EFT debit and Cash app. file creations for Lawson Accounting system.
• Data conversion from Computron to Lawson accounting system.
• Financial reports developments for Treasury management, Parish Finance and General insurance.
• Invoice creations in various formats in Health Benefit, Clergy Medical, and General Insurance.
• Data transfer from Lawson to CMB system.
• Separation of RLF monthly process from CIF and FIF and modification of financial Statements in Treasury Management.
• Oracle Forms and Reports builder instructor.

(Oracle10g/ 8.0.6 / 8i, Oracle-Developer2000 - Reports and Forms 10g / 9i / 6i / 5.0, Oracle APEX , Iron Speed, Brio - SQR report builder, SQL loade, PL/SQL (Olewrap, DBMS_SQL, UTL_FILE packages for ETL), PL/SQL Developer, SQL Navigator 4/5, SQL*Plus, HP Unix, Windows XP/2000/NT/98, WS_FTP95)

I involved in all stages of the project’s life cycle of the new Banking Project.

• Data modeling in Oracle Designer
• Database design.
• SQL and performance Tuning
• Writing relevant PL/SQL packages, functions and procedures.
• Forms and Reports Developer for the following applications;
• Cheque Operations
• Electronic Data Transfer for the Central Bank of Turkey
• Researching Reports of the Central Bank of Turkey
• Security and Core Banking Transactions
• Production support.
• Oracle 8i Instructor.
• DataWare House projects for Retail Banking and Corporate Banking Dept.

(Oracle 9iAS, Oracle 8i, MS SQL Server 2000, Oracle Designer 6.0, Oracle Reports 6.0, Oracle Forms 6.0, PL/SQL (Text_IO, UTL_FILE packages for data transfers) SQL Navigator,, Procedure Builder, Jdeveloper, SQL*Plus, BizTalk Server 2002, Visual Basic, Ms-Visio 2002, HP Unix, LINUX, Windows XP/2000/NT/98)

1994 – 1999

Analizing business resuests, writing functional specs, program testing, implementation and production support of the follow up and security systems.

(Visual Basic, Microsoft applications (Access, Word, Excel, PowerPoint)

B.Sc. in Mathematics Engineering

AWARDS

2004 Appreciation Certificate – Boston, MA

For exceptional services provided from Jewish Vocational Service Call Participant