QUALIFICATION SUMMARY

• 25 years professional IT experience as Internet/ Web site/ Computer application program developer, data analyst, and production support for computer system
• Implemented 80 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, and financial institutions banks .
• 5 years DBA role for production support of Oracle DB from v. 6 to 8, maintenance and data modeling form 6 to 11g
• Tools: MS Visual Studio 2013, MS Sql server 2008, IIS v. 6.1, mRemoteNG v. 1.72, 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 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, Maestro, Mataphase 3.1, Ab Initio, Visio PVCS v. 5.2 CVS source control, and IBM Lotus Notes v.8.5.
• Operating Systems: SUN-Solaris, Digital Unix v. 4.0E, VMS VAX v. 6.2 Windows v. 3.x/9.x/2000/XP/Vista/7/8 OS/2 v. 1-3 NOVELL NetWare v. 2-4 and DOS v. 3-6
• Languages: C/C /C, JavaScript, Ajax, jSon, jQuery, JSP, HTML5, PHP, Java, XML, Transact-SQL, PL/SQL, SQL Plus, Unix-shell scripts, Pro C, Pro-code, Mainframe DCL, Fortran, and PL1.
• 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, 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.

EXPERIENCE

Confidential

position: Software developer/ Program analyst

Address Repository Storage web site.

• Analyzed the structure and functionality of the Address Repository Storage web site.
• Compiled, installed and configured web site new release. Cording and modifying web forms, utilizing C .
• Provided MS SQL and Oracle database production support.
• Modified, tuned, and optimized T-Sql and PL/SQL procedures, packages, DB structures.

Environment and Tools: .NET v.4, MS Visual Studio 2013, C, IIS v. 6.1, PL/Sql, T-Sql, MS Sql server 2008, Oracle DB v. 11, Oracle SQL Developer v.4.0, Total Commander, mRemoteNG v. 1.72.

Confidential

position: Software developer/ Program analyst

• Conversion of Logistic application from Delphi into Apex.
• 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

position: Web application developer/PC hardware construction

• Musical website development
• 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 Aldarrgo.com website.
• Installed the MySQL data base. 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.
• Environment and Tools: Java, Swing, JavaScript, J2EE, AJAX, Oracle JDeveloper v. 11.1.2.2.0, ADF 11g release 2, Glassfish, Spring, Hibernate, MySQL, HTML5, PHP, XML, CSS, Linux.
• Mobile computer OS/application/electronics design and development
• 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

position: Java application implementation

Citibank Regulatory Reporting Application Initiative RRAI

• 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, JRuby, 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

position: Software selection, installation, configuration and development

• ALLTRAX and PakTrakr software/electronic applications
• 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

position: Software developer/ Program analyst

Caradigm Health Net Computer System

• 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

position: Web developer/ Program analyst

• Naval Facilities Engineering Command NAVFAC Integrated Data Store web application
• 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

position: Web developer/ Program analyst

• RETEK Information System v7
• Coded and modified reports according to new specifications, utilizing Java/JSP, ASP, and HTML technology.
• Modified API 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, Java/JSP, ASP, HTML.

Confidential

position: Computer system/application implementer and configurator

• Oracle APPS 11i installation and configuration:
• 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

position: Program developer/analyst/production support

• Customer Manager System CMS and Account Batch System ABS Production Support:
• 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

position: Software developer/ Program analyst

• Circuit Audit Reconciliation Tool CART Application:
• 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

position: Software developer/ Program analyst

• Analyzed the business structure of the Credit Card Department in CapitalOne Bank 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

position: Oracle Specialist Sr. Consultant on contract

• 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 training including creating training manuals .

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

Confidential

position: Oracle/Java/Website developer

• Internet online store with shopping cart
• 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

position: Program analyst/developer/application conversion

• Enhanced and Upgraded Output Request System ORS
• 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

position: Oracle developer/database conversion

• Oracle application data conversion and implementation
• 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: -- Customers GL, AP, FA, AR, HR and Inventory modules -- Sales order OE, PO, OM, Quote to cash modules . -- EDI protocol transfer EDI Gateway, E-suite and Manufacturing module
• 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

position: Oracle/C developer

Laboratory Information Management System LIMS project

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

Environment and Tools: Digital Alpha Unix v.4.0E, PL/SQL, Oracle RDBMS v. 8.5, Oracle/2000 Forms/Reports, and PVCS.

Product Data Management System PDMS application project

PDMS controls products data and user access to data, maintains relationships among product data, enforces rules that describe data flow and processes, and performs notification and messaging functions. Project includes: customization definitions, customization implementations, and migration legacy data.

Responsibilities:

• 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

position: Oracle developer

IMHC ETL Project

• 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.

Conversion Program

• Modified conversion program for identifying data problems, such as overlapping dates, violation of tier pricing, improper identification in single and multiple pricing, and duplication in records
• Wrote program specification for identifying data errors.
• 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

position: Software developer/ Program analyst

• Research Animal Management System RAMS
• 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

position: Software developer/ Program analyst

• 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: -- Accounting including screen forms -- Proofreader's applications catalog of brand names, directory of abbreviations and special terms, and a listing of grammar and syntax rules . -- Manager's applications e.g. catalog of company agents with name, addresses and telephone numbers, list of company agent services, work schedule including holidays, vacation time, etc. and salary information including bonus percentages .
• Upgrade screen forms and reports from TEXT into GUI mode.
• 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.

Confidential

position: Software developer/ Program analyst

• 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

position: Software developer/ Program analyst

• 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.