Financial systems, data warehousing, PL/SQL, Oracle 8 / SQL*Plus 3.3
Extensive experience in information systems,
financial systems, data warehousing and manufacturing systems.
Strong analysis / design/ coding /computer systems and troubleshooting abilities. Effective technical, communication, and problem solving skills.
* IBM 370, 390
* UNIX System V Release 4
* ERwin_ERX 3.0
* PDP 1140, 1134
* RPG II, III
* Data Warehousing/Mart/Extract
* OS/MVS, DOS/VSA
* C (Borland C)
* SPFPC 4.0
* VSAM, CICS, DB2
* MS FoxPro 2.6
* Lotus Notes Release 5.0.12
* JCL, UTILITIES
* oracle SQL*Plus 3.3
* MS Windows 95/ 98/NT
* TSO ISPF, FILE-AID
* Novell Netware 3.x
* COBOL II
* P/L 1
* Rumba V3.2
* Micro Focus COBOL
* RBASE / DBASE III +
* TOAD 7.4
* Visual COBOL
* oracle Discoverer 4
* FTP 5.1, WS_FTP Pro 6.01
* oracle PL/SQL
* Developer 2000 / Forms 4.5 5.0/6.0/6i, Reports 3.0/6i
* Reflection 5.21 for Win 95
* oracle Financials(AR, AP, INV, OM, QP, GL) 10.7, 11, 11i
* Seagate Crystal Reports 7
* HTML 4
* Informatica 5.1
Image Entertainment, Inc.
Chatsworth, Ca (June 2006 - present)
Senior Developer (Contractor)
Developed extension for OM to calculate customer rebate. Developed packages for migrating data between oracle Applications and Excel. Developed new forms in Order Management, modified forms in Inventory. Utilized oracle PL/SQL, oracle Forms 6i, TOAD, oracle 11i Applications (Inv, OM).
Compton, CA (August 2005 - March 2006)
Senior Developer Analyst
Developed and modified oracle forms and reports. Developed and modified Discoverer Reports. Supported oracle Application users(AR, AP, INV, OM, QP, GL). Worked with interfaces. Participated in preparing legacy MAS-90 data for conversion and loading into oracle database. Participated in preparing files to install E-Commerce. Utilized oracle PL/SQL, oracle Forms 6i, Reports 6i, oracle Discoverer, TOAD, ASP.
CSC (BAE Systems)
San Diego, CA (September 2004-Present)
Modifying oracle forms and reports(6i). Supporting oracle 11i Applications (FA). Responsible for upgrading, installation of Enterprise Facility Management System (FAMIS) applications. For that provided data analysis, plan for upgrading old modules and installation new modules. Providing daily support for end users. Utilizing oracle PL/SQL, Developer 2000, oracle 11i Applications (FA), oracle Procedure Builder V6.
Costa Mesa, CA (June 2004-Present)
Monitoring daily oracle Applications production. Troubleshooting, analyzing data, providing end users with ongoing support. Utilizing oracle PL/SQL, Developer 2000, Discoverer 4, oracle 11i Applications (AR, AP, GL), Toad 7.4.
Los Angeles, CA, New York, NY (November 2003-February 2004)
Independent consultant / oracle Applications Developer
Created testing infrastructure for the company development efforts. Expanding possibilities of not only serving A&M consulting needs but to become a liaison between international clients. Created documentation and provided guidance for oracle Applications users including verifying database integrity, and making necessary customization to enable continuity of service to client. Utilized oracle PL/SQL, Developer 2000, oracle 11i Applications (AR, AP, GL).
Los Angeles, CA (November 2002-April 2003)
Analyzed financial information, designed, coded, tested and implemented Inventory, A/P, and A/R system. Project included functional and technical analysis. Developed reports, solved data problems. Provided financial consulting. Utilized Microsoft Access 2000.
SARA LEE BAKERY
Vernon, CA (May 2000 - May 2002)
Senior oracle Developer/oracle Applications Developer
Participated in design and development of new Order System. This involved gathering business requirements,
analyzing financial information in accounting and sales areas, evaluating possible uses, designing Data
Warehouse for new system using Informatica 5.1, identifying and solving ETL related requirements, analyzing the findings and writing design documents. Participated in design, analysis, development and implementation of Preliminary Orders System, Finalized Orders System using PL/SQL. Created user manuals, trained business users. Developed Unix shell scripts to import data into oracle database. Monitored and corrected database. Created and modified various reports and forms for Accounts Receivable, Accounts Payable and Sales using Developer 2000 Reports 3.0 and Forms 5.0, Forms 6.0. Utilized UNIX HP, oracle8, oracle Applications 11, 11i (GL, AR, AP), ERwin_ERX 3.0, WS_FTP Pro 6.01, Reflection 5.21, Cognos, Informatica 5.1.
Universal City, CA (June 1999 - May 2000)
Lead Applications Analyst
Responsible for payroll conversion which involved data analysis, formatting, testing and troubleshooting.
Proposed and implemented a new TimeClock system. Defined and provided requirements for programming
conversions to facilitate use of TimeClock data in new payroll system.
Provided end users with ongoing support. Developed Project Tracking System, Employee Status Change System using oracle Forms 4.5, created triggers and PL/SQL scripts. Created HTML Request for Time Off for intercompany use. Created documentation and provided guidance for business users. Managed multiple client databases, including verifying database integrity, troubleshooting potential problems associated with database corruption, and making necessary corrections to enable continuity of service to client. Developed variety reports for Human Resources and Payroll Department using Crystal Report 7. Utilized oracle8, oracle Applications 10.7 (GL, AP, AR, PO, FA), Developer 2000 / Forms 4.5, FTP 22.214.171.124, Crystal Reports 7, HTML 4, Excel, Access
SONY PICTURES ENTERTAINMENT
Culver City, CA. (June 1998-February 1999)
Responsible for conversion current Mainframe Sony's Theatrical Film Distribution System (COLTS) to
a new client server Distribution System (SPIRIT).
Participated in conversion analysis, design, ETL development, and development Booking / Billing and Payment applications, oracle table conversion design. Participated in analysis and design Data Warehouse for converted system using Informatica 4.6. Developed mapping conversion standards.
Utilized OS/MVS COBOL II, JCL, TSO, ISPF, FILE-AID, oracle 7.2, PL/SQL, SQL*Plus.
oracle FINANCIAL SERVICES
Santa Monica, CA. (1995-1998)
Senior Consultant (August1997-June1998)
Senior Programmer / Analyst (July1995-August1997)
Provided design, analysis, technical consulting, support, integration, and custom development for various oracle clients. Assignments included functional and technical analysis, I/O programming, data extracts,
mapping, troubleshooting, and problem solving. Supported proprietary oracle code generator, WinRapid, that is used in portfolio management systems. Developed customized Micro Focus COBOL and COBOL II
(mainframe) routines, PL/SQL stored procedures, and SQL*PLUS scripts to perform non-trivial operations.
Participated in design Data Warehouse for loading and analysis legacy data. Created and reviewed functional specifications, logical design specifications. Participate in code reviews.
Senior Analyst - GMAC, SouthTrust, Signet Bank, Washington Mutual. Analyzed and designed the process flow and data loading system that allowed merging multiple heterogeneous data sources into a single relational database. Remotely support cash flow systems for these major financial institutions. Enhance application performance through query optimization and load analysis. Utilized COBOL II, DB2, Micro Focus COBOL, RUMBA v.3.2, JCL, UNIX SVR4, oracle 7.2/SQL*Plus 3, Developer 2000 / Forms 4.5.
Trained and mentor new programmers and technical support personnel.
STARCREST PRODUCTION OF CALIFORNIA, INC.
Perris/Riverside, CA. (1992-1995)
Senior Programmer / Analyst (September1992 - May1995)
Analyzed, designed, coded, tested and implemented A/P supply system. This involved interfacing and interviewing various functional and managerial members of the accounting team at Starcrest in order to find
the sources of data coming from the legacy system, analyzing the findings and writing design documents to map the legacy data to new structure. Analyzed and produced variety of financial reports for accounting system. Programming involved use of COBOL II, Visual COBOL, RBASE, RPG II, CICS, BASIC routines using UNIX OS. Utilized Tempus-Link to maintain PC to Mainframe communications link for uploading, downloading and processing files over the Mainframe.
ELECTRONIC EQUIPMENT PLANT
Kishinev, USSR (1986-1990)
Programmer / Analyst (August1986-January1990)
Responsible for analysis and design Payroll, Accounts Payable, Accounts Receivable, General Ledger, Inventory, and Financial/Budget projection program. Generated monthly productivity reports. Processed data and developed major changes in existing programs using MUMPS, COBOL, CICS.
ADDITIONAL WORK EXPERIENCE
Programmer, Department Automated Control Systems and Design, USSR (1981-1986)
Computer Operator, Electronic Equipment Plant, USSR (1978-1981)
1981 - 1986 Bachelor of Science from Kishinev University, Moldova
with major in Computer Science and minor in Accounting and
1996 - 2002 oracle Financials Functional Foundation Release 11i.
MicroAge Education Center, Diamond Bar, CA.
oracle Financials Functional Foundation Release 11.
oracle Education, San Jose, CA.
Advanced SQL and SQL*Plus
oracle Education, Los Angeles, CA.
Developer/2000 Forms 4.5
oracle Education, Los Angeles, CA.
oracle Design & Development - Developer/2000
UCLA Extension, Los Angeles, CA.