SUMMARY:

• 28 years professional IT experience as Internet/ Web site/ Computer application program developer, data analyst, and production support for computer system
• Implemented 100 plus Software Development Life Cycles (SDLC) of the Web applications and program scripts for several businesses and companies including retail, publishing, manufacturing, telecommunication, and insurance and logistic companies; pharmaceutical laboratories, militaries, postal and financial institutions(banks).
• 6 years DBA role for production support of MS SQL 2008 and Oracle DB v. 6 - 8, 10; maintenance and data modeling Oracle v. 6-11g, PostgreSQL 9.4.4 and MS SQL 2008.

TECHNICAL SKILLS:

Tools: and Frameworks: MS Visual Studio 2015, MS Sql server 2008, IIS v. 10, .NET, Zabbix v. 2.4.3, Developer Express v. 13.2, mRemoteNG v. 1.72, Crystal Reports, Spring tool suite v. 3.7.3, Apache Tomcat v.8, Nginx, APEX v. 4.2, Oracle JDeveloper v. 11.1.2.2.0, ADF 11g release 2, Glassfish, BC4J, Oracle 9i DS, Oracle Developer/2000, Oracle APPS 11i, Oracle financials, SQL*Forms v. 2.3,3.0,4.5,5,6i,9i; SQL*Reports v. 1.1,2.5,6i,9i; SQL*Plus; Oracle utilities; SQL*Graphics v.2.5; Uniface v.5,6; SQR v. 3,4; TestDirector 8.0; Silverrun-RDM v. 2.4; Oracle SQL Developer v.4.0; TOAD v. 6.3; Putty; Chameleon 3.0,Remedy v5.01, ERwin, Power Designer v. 16.5, Maestro, Mataphase 3.1, Ab Initio, Visio; PVCS v. 5.2; CVS source control, Far manager v3.0, and IBM Lotus Notes v.8.5.

Operating Systems: CentOS v. 7.2, SUN-Solaris, Digital Unix v. 4.0E, VMS VAX v. 6.2; Windows v. (3.x/9.x/2000/XP/Vista/7/8/10) ; OS/2 v. (1-3); NOVELL NetWare v. (2-4); and DOS v. (3-6)

Languages: C/C++/C#, JavaScript, JSP, HTML5, PHP, Java, Transact-SQL, PL/SQL, PostgreSQL, Unix-shell scripts, Pro-code, Mainframe DCL, Fortran, PL1 and Assembler.Libraries, web services and data type formats: jQuery, React, Backbone, jSon, Ajax, XML, Pro*C, DBF.

Hardware: iPod, Smartphone, Notebook, PDA, Tablet, Sun (V880, V890, V490), PC models (286,386,486,Pentium Dual-Core), PS/2, HP Compaq 8000 Elite SFF PC, HP-UX B.11.11 server, Alpha server 2100, VAX VMS 4500, Roland Edirol R-O9HR Recorder, HP bd340 Blu-ray drive, and Nikon Coolpix 990 camera.

Application Programs: Microsoft Office, MS Project, TeamViewer v.10, Jira, Confluence, Stash, Adobe PhotoShop, Dinolite Digital Microscope v. 3.2.0.5, Sequoia v.7.22, ArcSoft ShowBiz, CyberLink Blu-ray Disc Suite, Nikon view v. 6.2.1, and pyro Audio Creator LE from Cakewalk, etc.

PROFESSIONAL EXPERIENCE:

Confidential

Software developer/ Program analyst

Responsibilities:

• Analyzed the structure and functionality of the “ Confidential /alarm/cloud/BI” application.
• Fix DB model, schema and the script to install and configure PostgreSQL or MS Sql database. Utilizing Sybase Power Designer v. 16.5
• Web form bugs and errors fix, utilizing C# and Visual Studio 2015.
• Translated documents, e-mails and phone conversations into English.
• Modified, tuned, and optimized PostgreSQL procedures and DB structures.
• Converted the T-Sql procedures into PostgreSQL.
• Modified reports according to the request. Utilizing Crystal Reports, C#, PostgreSQL and T-Sql.
• Installed and configured Web application. Utilizing Windows 10, MS Sql, IIS v. 10, PHP v. 5.6.8, Bootstrap.js, jQuery v. 3,
• Designed the algorithm and methodology for web site testing. Installed all necessary packages and applications. Coded, tested and moved it into production usage by utilizing Selenium WebDriver API .NET v 3.4, SpecFlow v1.5.2, Chrome/Phantom/FireFox drivers, C# and Visual Studio 2015.

Environment: and Tools: . NET v.4, MS Visual Studio 2015, Team Foundation Server(TFS) v.15, C#, IIS v. 10, T-Sql, MS Sql server 2016, PostgreSQL 9.5.2, pgAdmin v 1.22, Total Commander, Crystal Reports, Bootstrap.js, jQuery v. 3, IBM Lotus Notes v.8.5, Far manager v3.0

Confidential

Software developer/ Program analyst

Responsibilities:

• Compiled, installed and configured web site new release. Cording and modifying web forms, utilizing C# and Visual Studio 2013.
• Translated application into English. Utilizing ASP.NET, C#, jQuery, CSS technology.
• Provided MS SQL and Oracle database and application production support. Utilizing Zabbix v. 2.4.3, MS SQL Server management studio v. 10.50, Oracle DB Manager, Jira, Confluence, Git, Stash and TeamViewer v.10.
• Wrote servlets and applets to control the traffic and data validity between web and data server, and user API. Worked on a proposal to modernize bulletin board. Wrote method to get accurate geographical position coordinates. Coordinated work with Yandex.ru and Google.com. Created Restful APi for restoring user password.
• Modified, tuned, and optimized T-Sql and PL/SQL procedures, packages, DB structures.
• Converted the PL/Sql packages into T-Sql procedures.
• Wrote reports according to the specification. Utilizing Crystal Reports, C#, PL/Sql and T-Sql.
• Wrote technical specification for Regression test of the Oracle and MS-Sql database. Corded, tested and moved it in production use.
• Worked on analysis of the IIS log. Created the script to fix the system and database error.
• Worked on a plan and implemented it to replace alien software on domestic made one.
• Installed and configured Web applications and DB servers, granted network access, created user accounts. Utilizing CentOS v. 7.2, PostgreSQL 9.4, Nginx, Apache Tomcat v.8, Backbone.js, jQuery v. 5, React v. 0.14
• Tested and configured Java servlets. Utilizing Spring tool suite v. 3.7.3, JUnit and Tomcat.
• Wrote technical specification and program for monitoring critical network, OS and DB cluster synchronization and functional problems. Implemented it by utilizing standard and custom-made templates in Zabbix v. 2.4.3, JDK v. 1.7 for CentOS and Unix-shell.
• Upgraded the PostgreSQL 9.4.2 into 9.4.10, and BDR 0.9.1 into 1.0.2.
• Converted reports from .NET/ASP/C#/ISS/T-sql technology into HTML/Java/Tomcat/PostgreSQL environment. Utilized Spring Tool Suite v. 3.7.3, Eclipse Mars.2 v. 4.5.2, Maven v. 3.3.9, Tomcat v. 8.0, JDK v. 1.8, PostgreSQL v. 9.4.10.

Environment: and Tools: .NET v.4, MS Visual Studio 2013, C#, IIS v. 7.5, Developer Express v. 13.2, PL/Sql, T-Sql, MS Sql server 2008, Oracle DB v. 11, PostgreSQL 9.4.10, Oracle SQL Developer v.4.0, Total Commander, mRemoteNG v. 1.72, TeamViewer v.10, Crystal Reports, CentOS v. 7.2, Zabbix v. 2.4.3, Spring tool suite v. 3.7.3, Apache Tomcat v.8, Nginx, JDK, v. 1.7-8, Backbone.js, jQuery v. 5, React v. 0.14

Confidential

Software developer/ Program analyst

Responsibilities:

• Analyzed the structure and functionality of Logistic application, which included Administrator, Finance, Logistic, 1C and e-mail notification modules.
• Converted Logistic application from Delphi into Apex. Utilizing APEX v. 4.2, JavaScript, Ajax, jSon, jQuery, HTML5.
• Provided production support and remote error/bug fixing for clients.
• Translated application into English. Utilizing Language Localizator v.6.
• Participated in company meeting to make decisions for strategic plans and concept design.
• Modified, tuned, and optimized PL/SQL procedures, packages, DB structures.

Environment: and Tools: APEX v. 4.2, JavaScript, Ajax, jSon, jQuery, HTML5, Windows 7, Oracle 11g, PL/Sql, Language Localizator (Localize), Delphi, IBM Lotus Notes v.8.5, Oracle SQL Developer v.4.0.

Confidential, Tampa, FL

Web application developer/PC hardware construction

Responsibilities:

• Analyzed the modern website development methods and design styles.
• Designed all sketches for the API by deriving them from business rules functionality.
• Utilized Internet search engine and other famous websites for gathering the information needed to build the website.
• Installed the MySQL database. Designed all necessary tables, attributes, columns and configured DB connection.
• Worked on e-mail script, e-mail server configuration and multilingual capabilities.
• Worked on recording of the music, pictures, sound tracks, and note sheet compositions. Utilized Roland Edirol R-O9HR Recorder, HP bd340 Blu-ray drive, Nikon coolpix 990 camera, Sequoia v.7.22, ArcSoft ShowBiz, CyberLink Blu-ray Disc Suite, Nikon view v. 6.2.1, and pyro Audio Creator LE from Cakewalk.
• Copyrighted the song in the US Patent and Trade Marc office in Washington DC.
• Resolved website problems and issues and made it work on Mobile units with iOS, Android, Blackberry, and Windows 8 platform. Performed responsive web design.
• Analyzed and reviewed the modern OS configuration, electronic microscope and PC hardware components.
• Utilized Internet search engines for researching current information needed to build the Mobile computer for Lathe/Mill electronic microscope and electric car motor controller performance monitor.
• Installed and configured Dinolite Digital Microscope v. 3.2.0.5 application.
• Constructed and assembled the mechanical parts, soldered necessary components, and installed the OS and associated programs.
• Configured, tested, and moved the Mobile computer into production usage.

Confidential, Tampa, FL

Java application implementation

Responsibilities:

• Analyzed the structure of Citibank RRAI internet application.
• Worked on ETL plan for uploading the data file from Genesis into Analytical Server environment. Utilizing the Unix shell scripts, PL/Sql, and Ab Initio.
• Tested the hardware/software for the migration into Windows 7 environment. Analyzed the performance inconsistency between same OS image buildup work on deferent hardware.
• Examined the IBM Web Sphere based Java application (Analytical Server) for installation, configuration and production usage purposes.
• Analyzed the API Java source code for the purpose of production compatibility, usefulness and efficiency in relation with the business functionality.
• Prepared the development environment for migrate from Red Hat Linux into Cloud. Worked closely with system, network and database administrators.

Environment: and Tools: Java, J Ruby on Rails, UltraEdit v16.20, Cloud, AIX v6.1, Genesis, Oracle DB 11g 64bit, SSH Tectia v. 6.2, Ms Office Communicator v. 3.5.6907.221, Citrix, Avaya OneX Softphone, SQL developer v.3.0, PL/Sql

Confidential, Santa Barbara, CA

Software selection, installation, configuration and development

Responsibilities:

• Analyzed the vehicle structure, sales, manufacturing, and distribution business.
• Utilized the search engine of the Library of Congress and Internet for gathering information necessary for the project development.
• Made the decision to buy appropriate software application and electronic equipment: ALLTRAX motor controller and PakTrakr batteries monitor.
• Installed ALLTRAX electric motor controller application. Configured it for optimal vehicle performance for the high speed and safe regime. Wrote ETL process to extract information about voltage and current usage, brake pedal response, and throttle pedal position.
• Installed necessary equipment and software for PakTrakr batteries monitor. Wrote ETL script to extract information about batteries voltage and current usage. Made it available for Java swing, HTML5, XML and flat file output format.
• Designed, created and installed electronic and mechanical components for the vehicle.

Environment: and Tools: Java, Swing, J2EE, Oracle JDeveloper v. 11.1.2.2.0, ADF 11g release 2, Windows XP, Glassfish, HTML5, XML.

Confidential, Santa Barbara, CA

Software developer/ Program analyst

Responsibilities:

• Analyzed the structure and functionality of Caradigm.
• Created 2D diagram of program logic, which includes time line, business rules, table structure, script components and functional dependencies. Utilized Visio work flow, MS Office and graphical tools.
• Executed trouble shooting and diagnostics of the system to eliminate program errors, wrote recommendation report for system enhancements.
• Worked on business and technical plan for modifying Caradigm for expansion in the city of Ventura CA, to be utilized later as a national standard for Health insurance computer systems nationwide.
• Wrote programs utilizing multilingual capabilities (Spanish & English) and different output format: XML, HTML, PDF, TXT, DOC, CSV, XLS, direct printing and e-mailing.
• Modified, tuned, and optimized PL/SQL procedures, packages, DB structures, forms and reports.

Environment: and Tools: TOAD v.9, Oracle DB 10g, Oracle Tools, Oracle Developer/2000 v.6i, Oracle AS 10g, Windows XP, PL/SQL, Korn-shell, HP-UX B.11.11, Unix 9000/800, ReflectionX v.14.0.2

Confidential, Port Hueneme, CA

Web developer/ Program analyst

Responsibilities:

• Analyzed and studied structure of NavyieFACMAN integrated data store.
• Created 3D diagrams of several modules of NavyieFACMAN application, which included application functionality, network components, OS of servers and workstations, Oracle DB, and procedures and batch processes. Utilized Visio work flow, MS Office, and AutoCAD 2006.
• Executed trouble shooting and diagnostics of the system to eliminate program errors and wrote recommendation report for system enhancements.
• Modified and coded reports according to new standard utilizing Java/JSP, AJAX, ASP, HTML, CSS, and Struts technology.
• Modified, tuned, and optimized PL/SQL procedures, packages, DB structures, and reports.

Environment: and Tools: TOAD v.8.6, Oracle DB 10g, Oracle Tools, Oracle DS 10g, AutoCAD 2006, Windows XP, PL/SQL, Visio work flow, Citrix, Java/JSP, AJAX, ASP, HTML, CSS.

Confidential, Saint Petersburg, FL

Oracle developer/ Program analyst

Responsibilities:

• Coded and modified reports according to new specifications, utilizing Oracle developer 6i (Forms, Reports) technology.
• Modified API (Forms, Reports, Pro*C) according to new standard.
• Modified and tuned PL/SQL procedures and packages.

Environment: and Tools: TOAD v.8.6, Oracle DB 10g, Windows XP, PL/SQL, Oracle developer 6i (Forms, Reports, Pro*C).

Confidential

Computer system/application implementer and configurator

Responsibilities:

• Analyzed and studied the science idea and business side of the plant growth.
• Specified the technical characteristics for server: CPU type and speed, motherboard type, RAM capacity, HD read/write speed, information bus type, OS version.
• Installed and configured Oracle APPS 11i application.
• Loaded data into the GL, HR, and Projects modules.
• Coded program for financial forecast of project profitability. Utilized PL/SQL and Oracle OLAP features capability.
• Trained personal for modules usage.

Environment: and Tools: Oracle APPS 11i, Oracle DB 10g, Oracle Tools, Oracle DS 10g, TOAD v.8.6, Windows XP/NT, PL/SQL, Visio work flow, Java, JSP, HTML, CSS.

Confidential,, NC

Program developer/analyst/production support

Responsibilities:

• Analyzed and studied CMS and ABS applications and the how the system works according to business rules of GSK pharmaceutical.
• Maintained CMS and ABS systems in 24x7 availability for customer needs by utilizing “In-Process Manager”(IPM) tool, Unix, and Korn shell.
• Supervised and coordinated the activity of DBA, developers, communication and system personal to eliminate errors/problem-solve to ensure a smoothly running system.
• Advised management of appropriate methodology for system’s pager notification process based on every day statistics and IPM daily activity.
• Reported system errors and status of errors solved by utilizing Mercury TestDirector 8.0, Remedy(Action Request System) v5.01, and Chameleon v3.0.
• Participated in conversion of CMS system from Unix/Korn shell into IPM GUI/Internet/multi lair environment and modified Korn shell scripts.

Environment: and Tools: TestDirector 8.0, Chameleon 3.0, Remedy v5.01, SQL-Navigator 4.5, Oracle DB 9i, Oracle Tools, Windows XP, SUN-Solaris 5.8, Korn shell, PL/SQL, Putty, Lotus Notes 6, and Maestro.

Confidential, Clinton, MS

Software developer/ Program analyst

Responsibilities:

• Analyzed and studied CART application and the how the system works according to business rules of MCI
• Wrote technical specification for packagers and CART application.
• Coded PL/SQL procedures and functions.
• Wrote Unix-shell scripts
• Tested CART application and implemented its release for production.

Environment: and Tools: Visio, Erwin, SQL-Navigator, Oracle DB 9i, Oracle Tools, MS-net meeting, Windows XP, SUN-Solaris, PL/SQL, PVCS, and Putty.

Confidential, Washington, DC

Software developer/ Program analyst

Responsibilities:

• Analyzed the business structure of the Credit Card Department in Confidential by using Visio Work Flow v5.0c.
• Created the conversion plan for merging the new purchased San Diego City and Plano City subdivisions by using MS Office suite and MS Project
• Created ETL Unix-shell scripts and procedures to migrate data and programs by using AB Initio, TOAD, PL/SQL, and k-shell languages.
• Tested, verified, and deployed programs in production use.

Environment: and Tools: Ab Initio, TOAD, Oracle DB 9i, Oracle Tools, Windows XP, PL/SQL, Visio work flow v5.0c, HP-Unix, CVS, and Putty.

Confidential, New York, NY

Oracle Specialist - Sr. Consultant

Responsibilities:

• Provided development and support for WEB/DW/OLTP/OLAP computer systems.
• Worked on auto-creation of backup scripts, database structure re-creation/re-engineering, development of monitoring scripts/modules and graphical (GUI) tools in Oracle Developer 6i/9i DS for monitoring, and presentation of current database information.
• Worked on a creation of portlets(forms, reports, LOV, charts) for several companies’ web sites by using Mod PL/SQL for generation of the web applications.
• Customized development of Oracle-based 3-tiers Intranet/Internet and Client/Server applications, and DB maintenance(including export-import operations, data files maintenance, etc.).
• Installed and turned Oracle database servers and applications upgrades(v.8.1.5, 8.1.6, 8.1.7, 9i).
• Tuned physical DB structures, Oracle memory structure, and applications queries/SQL statements.
• Planned and executed system testing and users (including creating manuals).

Environment: and Tools: Oracle 8i/ 8.1.5/.6/.7/9 i; Oracle 9iAS Portal; Oracle 9iDS(Forms, Discoverer, Reports, SCM, JDeveloper, OWB, PL/SQL, XML, OC4J); PVCS; TOAD, and various scripts.

Confidential, Chicago, IL

Oracle/Java/Website developer

Responsibilities:

• Created plan for all website developing phases.
• Worked on multilingual capabilities and administration API
• Modified and evaluated the API architecture and design patterns for website
• Designed and maintained Oracle database used in website
• Resolved website problem and issues.
• Implemented and wrote quality control procedures, programming standards, and user documentation for website.

Environment: and Tools: Java, Swing, BC4J, JSP, JavaScript, J2EE, Oracle JDeveloper, Oracle DB 8i/9i, HTML, XML, CSS, and CSV.

Confidential, Chicago, IL

Program analyst/developer

Responsibilities:

• Analyzed business rules and functional relations of the Risk Management department to understand business requirements
• Created complete release #3 of the entire ORS OLTP/DW application.
• Installed security system for employees (Oracle users) and ORS application menu.
• Wrote ORS system upgrade plan.
• Managed all processes involved in moving the new release of ORS application into production use according to plan.
• Coordinated DBA activity for installing security system, modifying database model, and scheduling job in the Unix environment.
• Controlled the process of installing OS and tool-set on PCs, and prepared the system specifications for computer configuration.
• Reverse engineered DB using the ERwin tool.
• Converted data from one instance of Oracle to a new schema using Ab Initio.
• Extensive use of data partitioning, transforms, extract, and data loading components in Ab Initio.
• Created plan for remodeling and implementing enhancements in ORS application.
• Coded, altered, and unit tested the custom build forms and reports
• Managed the activity of ORS application users during testing phase.
• Coordinated programmer work to create program for the automatic installation of ORS application on SMS Department and Quality Assurance Group computers.

Environment: and Tools: Oracle Developer/2000 6i, Ab Initio, Visio Work Flow, PVCS, Windows 95/NT on work station, HP-Unix on server site, PL/SQL, Korn-shell, Oracle RDBMS 9i, and Erwin.

Confidential, Chicago, IL

Oracle developer/database conversion permanent

Responsibilities:

• Analyzed the code and structure of EMISTM (legacy system) application created by ESI/Technologies company.
• Examined the database layout (e.g. conversion tables, relations, default values, stored procedures, and functions)
• Analyzed screen forms’ data processing, filtering and derivation rules for loading Open Interface tables.
• Prepared conversion documentation for data loading in Oracle Financial modules:
• Modeled algorithm for “Upload Program Logic”, including table and view usage, calling arguments, module logic (pseudo code), validation logic, incompatibility, and performance.
• Created ETL graph using Ab Initio tool for data migration.
• Fixed database errors (e.g. incorrect address style, inconsistent tax territory code, and discount usage).
• Created “Conversion Process” test plan and implemented it in production database.

Environment: and Tools: ERwin, Oracle Developer/2000 v.1.6, PVCS, Windows 98 on work station, HP-Unix release B. (N4000) on Oracle sever site, Ab Initio, PL/SQL, Perl Unix-shell script, Oracle RDBMS 8.0.5.1.0, Oracle APPS 11i, Visio Work Flow.

Confidential, Round Lake, IL

Oracle/C++ developer permanent

Responsibilities:

• Designed and developed the form layout, functionality, data entry validation, and processing rules for coding of PL/SQL triggers and procedures
• Created data model definition and layout design
• Analyzed business rules, functional hierarchy, and entry relations for LIMS application.
• Designed transfer parameters between Oracle Forms and Oracle Reports.
• Tuned programs (e.g. PL/SQL procedures and triggers)
• Wrote technical specification for customization.
• Defined business rules, function relations, and constraints
• Utilized C/C++ SDRS/Metaphase library and Pro*C for programing PDM software.
• Validated and inspected source code according to technical specifications.

Environment: and Tools: C/C++, Pro*C, CVS, C-Shell, Digital Alpha Unix v.4.0E, Mataphase 3.1, Windows 95.

Confidential, Deerfield, IL

Oracle developer permanent

Responsibilities:

• Created new database layout for archived, temporary, and production data warehouse tables.
• Created data-flow diagrams for data feed routine.
• Analyzed programs for data feed routine.
• Analyzed program and data “loading” errors.
• Designed program to determine data errors by using PL/SQL, terminal application, DCL language, and the scheduling tool.
• Created special screen forms for testing input and output data by using SQL-Form v.4.5.
• Wrote the Process Modification Request(PMR) form and moved routines into production environment.
• Tested the ETL routine, executed initial load, maintained the production support of the daily increment (load) routine.
• Prepared test example of input and output data.
• Coded routine (programing filter) and moved it in production by using PL/SQL, terminal application, and Mainframe’ DCL language.

Environment: and Tools: VAX VMS v.6.2, PL/SQL, Oracle RDBMS 8, SQL-Form v.4.5, Oracle Developer/2000 v.1.6, and Windows 95.

Confidential, Amhurst Lake, IL

Software developer/ Program analyst

Responsibilities:

• Performed modification of the following screens: study and protocol maintenance, vendor maintenance, order entry screens, animal transfer module, and health monitoring module.
• Assisted users in understanding functionality of the system and handled bug fixes.
• Worked on the initial stages of system redesign, including data migration from the old database model into a new model by using the Silverrun database engineering tool v 2.4.
• Converted system screen form character mode into GUI interface by using Uniface v.4.
• Enhanced and converted reports by using SQR tool.
• Maintained the database(e.g. tested the database triggers and functions, enhanced the e-mail notification functions).

Environment: and Tools: VAX VMS, PL/SQL, SQR v.3/4, Oracle RDBMS 8, Uniface v.4, PVCS, Windows 95, and Silverrun v.2.4.

Confidential

Software developer/ Program analyst

Responsibilities:

• Prepared organization for migration from Paradox v.5.0 into Oracle RDBMS v.7.1.12 and Oracle front-end environment.
• Hired and managed consultant activity for execution of the specific jobs( system design, computer configuration, technical specification).
• Documented all company objectives, designed all processes, and wrote all of the specifications for the new OLTP/DW system.
• Created logical and physical DB structure by using ERwin.
• Developed applications for company departments:
• Administered Novell Net Ware, Unix, and Oracle DB 7.1.
• Developed an OLAP application to provide economic analysis of the current market environment, calculation of poverty level, etc.

Environment: and Tools: Oracle DB 7.1.12, Oracle Tools, Unix, Novell, ERwin, Oracle Developer/2000 (Forms, Reports, Graphics, Menus), PVCS, SQL*Plus, PL/SQL, DOS, and Windows 95/NT.

Confidentia

Software developer/ Program analyst

Responsibilities:

• Managed the work of consulting firm hired for the purpose of modeling and building OLTP/DW computer system for the bank.
• Set up and configured Novell v.3.12 and OS/2 v.2.1.
• Installed Oracle RDBMS v.6.1 and updated later into v.7.1.12.
• Developed loan application using Oracle CDE v.5 (included printing contracts, agreements, bills, checks and purchase orders).
• Designed and coded OLAP application to forecast the bank’s financial situation to help the loan department.
• Designed, developed, and updated screen forms and reports for every aspect of the bank’s daily routine.
• Designed and developed an ETL application for electronic payments between the operation department and the central bank. The system followed the ESKIR protocol(developed by Unisys) and contained the following modules: encoding and decoding payment information, log of client’s account, transaction log, and a handler for verification of data integrity.

Environment: and Tools: Oracle DB 7.1.12, Oracle Tools, Unix, Novell, OS/2, Oracle CDE v.5 (SQL*Forms, SQL*Reports, SQL*Menus), PVCS, SQL*Plus, PL/SQL, DOS, and Windows 3.x/95.

Confidential

Software developer/ Program analyst

Responsibilities:

• Designed, developed, tested, and deployed OLTP/DW application for an aircraft radar manufacturer
• Wrote technical specification and documentation for manufactory application(HR, AR, and manufacturing modules).
• Provided maintenance, administration, and tuning of the Oracle RDBMS.

Environment: and Tools: Oracle DB 6, Oracle Tools, Novell, OS/2, Oracle CDE v.5 (SQL*Forms, SQL*Reports, SQL*Menus), PVCS, SQL*Plus, DOS, and Windows 3.11.

Confidential

Programmer Analyst

Responsibilities:

• Commanded real-time ADF Defense system.
• Created reports used by the industry to improve the quality of the military equipment.
• Analyzed and corrected mathematical algorithm and software for tracking satellites.
• Maintained system integrity.

Environment: and Tools: embedded system, Assembler, custom designed and made equipment, weapons and software.