Senior Oracle Developer/Analyst
SUMMARY OF EXPERIENCE:
11 years of applications development experience, including:
â?¢ Over 6 years as an oracle Developer and System Analyst;
â?¢ 1 year as an oracle HTML DB Applications developer;
â?¢ Experienced in full life-cycle application development;
â?¢ Extensive experience in application analysis, design, maintenance, and testing;
â?¢ Superior organizational, analytical, and problem solving skills;
â?¢ Strong SQL and PL/SQL skills.
SCSI 06/06 - Present oracle Subject Matter Expert
SYSTALEX Corp. 07/01 - 05/06 Senior oracle Developer/Analyst
Re-Certify.com 05/00 - 06/01 oracle Developer
Algorithm 10/94 - 07/97 Programmer/Analyst
GIPROSTAL 04/85 â?? 09/94 Software Engineer
Client Server and Web Applications development: oracle PL/SQL, SQL*Loader, oracle Designer 6i, 9i, oracle Forms 4.5, 5.0, 6.0, 6i, 9i, 10g, oracle Reports 2.5, 3.0, 6i, oracle HTML DB 1.6 and 2.0.
oracle Database Server: oracle 7, 8, 8i, 9i, 10g, SQL Tuning, Generating and Managing Database Schema Objects.
Systems Analysis: Logical Data Modeling, Functional Modeling, System Full Life Cycle.
Project Management: Microsoft Project. Project task and level of efforts estimating, scheduling, and weekly status/progress reports.
Operating Systems: MS Windows XP
Others: McAfee HelpDesk 32, TOAD (V 8.5.1), ClearCase Attache (V.4.0) and Rational ClearCase, Microsoft Office 2003 (Excel, Visio, PowerPoint), SecureCRT/SecureFX (Version 5.0.1), Lotus Notes 7.0.1.
June 2006 â?? Present
Employer: SCSI, Washington, DC
Title: oracle Subject Matter Expert
o Currently assigned to the US Mint Independent Verification and Validation (IV&V) project, which goal is to ensure that all elements of Mintâ??s Manufacturing, Accounting/Finance, and Procurement systems successfully migrate from PeopleSoft to oracle E-Business Suite.
o Responsible for Requirements and Design analysis, Data Conversion monitoring, providing functional and technical expertise to support the development team through the project lifecycle, identifying risk areas and mitigation plans.
July 2001 â?? May 2006
Employer: SYSTALEX Corp., Rockville, MD
Title: Senior oracle Developer/Analyst
o Participated in the EPA Grant Reporting and Tracking System migration from Lotus Notes-based system to a GRTS-oracle application using oracle 10g HTML DB as the web application development tool. Analyzed user requirements and developed functional navigation and sub-navigation diagram for the application using oracle Designer 9i; created more then 40 HTML pages for Grants, Regions, Projects, and Tasks; developed and maintained documentation of existing and potential issues.
o As a team member contributed to Account Receivable (AR) and Reimbursable Agreement Upgrade (RAU) projects at U.S. Department of Commerce. Worked on new requirements implementation for AR, RAU, and RA Transfer modules. Performed Functional Requirements Analysis, design, coding, testing, and final product delivery to the client. Created ERD and generated tables using oracle Designer, created new forms and packages using oracle Forms and PL/SQL.
o Was responsible for the requirement analysis and coding for Billed and Unbilled Collections, IPAC Collections, Refunds, Non-Sufficient Funds, Negative Receipts processing, and Batch processes packages within AR system, which supports establishment and tracking of receivables, calculation, generation, and posting of customer bills in accordance with agency program requirements. Was involved in database design changes to accommodate database structure to the new requirements. Created and modified Detailed Design Documents for AR modules, and prepared drafts for the requirements documents working directly with the client.
o Worked as a Team Lead during the RA Transfer project providing the project/resources planning, guidance for coding/testing, and was responsible for the contacts with the client.
o Provided technical support of Account Receivable, Account Payable, and Reimbursable Agreements parts of the Core Financial System (CFS) application. Submitted multiple technical assessments and proposals for the system enhancement.
o Was responsible for Maintenance CM and supported implementation of Capability Maturity Model Integration (CMMI) processes, tools, methodologies, and procedures.
o Developed various types of documentation, such as High Level and Detail Level Design, Technical Assessments, Level of Effort estimation, Scheduling, Testing Cases, Delivery Logs, Delivery Instructions, Release Notes, Weekly Status and Monthly Reports.
May 2000 â?? June 2001
Employer: Re-Certify.com, Kensington, MD
Title: oracle Developer
o As a team member was responsible for design, development, implementation and maintenance of the Re-Certify.comâ??s Credential Management Database System, which provided records on individualâ??s education and certifications, and e-Education online service offering comprehensive education via the Internet.
o Responsible for data loading into the database using SQL*Loader and SQL scripts.
o Actively used oracle Designer. Performed database design, created function hierarchy diagrams, generated menus, templates and programmed navigation between applications. Designed, generated and tested oracle Forms modules using oracle Designer and oracle Forms. Deployed Forms modules to oracle Application Server.
o Involved in defining and developing PL/SQL code for Forms and database triggers using Repository Object Navigator and Schema Manager.
o Maintained data and database structure synchronization between production and development databases.
October 1994 â?? July 1997
Employer: Software Center â??Algorithm', Kharkov
o Contributed to the development of Inventory Management System, which allowed users to maintain records for inventory of raw materials, consumables, and also parts and finished products.
o Responsible for design and development of oracle database for the system as well as the design and development of application reports and libraries.
o Demonstrated the system to the customers and provided customer support.
April 1994 â?? September 1997
Employer: Metallurgy Research Institute, Kharkov
Title: Software Engineer
o Contributed to the design and implementation of a large-scale project for testing equipment used in metallurgy (MS-DOS and later Windows based application written in Pascal programming language).
o Developed different levels of block-diagrams and logic flowcharts for miscellaneous testing procedures.
o Responsible for collection and analysis of the test result data.
o Involved in software quality assurance and software re-engineering in compliance with applicable standards.
o Designed CAD software to produce technical drawings of the industrial boilers and pipelines (the software was written using Fortran for minicomputers PDP-11 and the system contained add-on components to calculate carrying capacity of pipelines for compressed air, oxygen, carbon dioxide, and nitrogen on industrial objects). Also created all project drawings in compliance with federal regulations.
08/1978 â?? 03/1984
M.S. in Applied Mathematics, Diploma with Honor.
Kharkov Polytechnic Institute, Kharkov, Ukraine
o SYSTALEX Corporation Presidentâ??s Award for 2004 â??Most Productive Employeeâ??
o SYSTALEX Corporation Presidentâ??s Award for 2003
o Department of Commerce Certificate of Appreciation for 2003
o Letters of Commendation from CBS Support Center for AR and RAU projects
1. NACI background investigation
2. High Risk - in process.