OBJECTIVE

Information System/Technology Software Engineer position performing full life-cycle system application development activities including problem domain analysis, requirements definitions, designs, implements, and tests systems, etc.

QUALIFICATION

• Over 18 years full lifecycle web applications im plementation, development experience as an Oracle Developer.
• Full lifecycle E-Business ERP/CRM planning, implementing, customizing, integrating, troubleshooting, performance tuning, user training and upgrading using Oracle Applications 12r, 11i, 11.x 10.7
• Full lifecycle Data Warehousing Data Mart, OLAP, BI plan, requirement analysis, back-end data model and front-end reporting design and development, extraction/transformation/loading ETL , prototyping, testing, evaluation, production deployment and support, performance tuning, and user training using Oracle 12c/11g/10g/9i/8i , APEX, Designer, Developer, Warehouse Builder, Express Server, Oracle Text, Oracle Application Express, Discoverer 10g/9i/4i/3.x , BI Publisher, Informatica, ERWIN
• Designing, customizing applications using Forms, Reports and OA Framework
• Building Applications open interface, using SQL and PL/SQL, UNIX shell scripts and APIs
• Data warehousing using ETL and OLAP tools Informatica, Business Objects, OWB and Discoverer
• Designing, building and customizing web applications using HTML, XML, HL7, XForm, JAVA Script and Cold Fusion

COMPUTER SKILLS

• ORACLE RDBMS 7.x, 8.x, 8i, 9i, 10g, 11g, 12c :
• E-Business Suite 10x, 11i, 12r , Financials GL, AP, AR, FA, ADI, PO, OM, PA, Workflow, SSWA, OFSA , HRMS
• SQL, SQL Plus, PL/SQL
• Oracle Developer Forms 4.0, 4.5, 5.0, 6.0, 6i, 9i, 10g, Reports 2.0, 2.5, 3.0, 6.0, 6i, 9i, 10g
• Oracle Application Express 3.0, 4.0, 4.1, 4.2
• Oracle Text 11.1
• Oracle Designer 6i, CASE tools, Erwin
• Oracle DBA OEM, Oracle Net Manager, Tuning, SQL Load, Export/Import, OWB, RAC
• Oracle Applications Server 9iAS, 10g, WebDB/Portal, Discoverer 3.x, 4.x, 9i, 10g

Operating Systems and Languages:

• UNIX, VAX/VMX, Cold Fusion, HTML, XML, JavaScript, Power Builder, Visual Basic, C/C
• MicroStrategy, Informatica, Microsoft Office, Visio, Quest TOAD, Rational ClearQuest, ClearCase

JOB EXPERIENCE

Sr. Application Developer

Confidential

• Performing database development and APEX web application development functions in Fairfax County Public Schools environment to support Data Services' projects.
• Created APEX application: Public School Performance Profile which has sixteen pages and graphs included: Safe and Secure, SAT, School Selection, Accreditation, School Staffing, Technology Inventory, Demographic, Technologh App Usage, DRA, AP, IB, AP Forward, BI Forward and Mebership. Using JavaScript and Oracle BI Publisher integration with APEX pages.
• Created and rewrote Crystal reports to APEX reports. Created APEX application: Enrollment Marks Portal which included following web pages: Marks by Course, Marks by Ethnicity Gender, Review Mark by Course, Review Marks by Ethnicity Gender, Summary Mark by Course, Summary Mark by Ethnic Gender, Review Summary Mark by Course, Review Summary Mark by Ethnic Gender. Using JavaScript and Oracle BI Publisher integration with APEX pages.
• Created APEX application: Membership End of Year Report which included following web pages: School Demographic by County, School Demographic By Level, School Demographic by County Region, School Demographic By Level Region, School Demographic by Cluster and School Region, Review School Demographic by County Region, Review School Demographic By Level Region.
• Developing numerous SQL, PL/SQL programs for data extraction, transformation, data loading and implementing data validation process using stored procedures, functions, triggers, and packages.

Software Engineer

Confidential

• Performing database development and web application development functions in federal government development environment to support FDA Janus project.
• Installed Oracle 11g and Oracle APEX 4.1. Created APEX applications based on XML DB with XML data using with SQL, PL/SQL, HTML, JAVA script.
• Implementing and understanding Janus project information and HL7, XForm technology from documentation: HL7 V3 Guide, StudyDesignDAM, StudyParticipationDAM, Subject data, Clinical Data Interchange Standards Consortium XML, Xform tutorial, etc.
• Created XForm with HL7 schema on Single-Line Text Input, Multi-Line Text Input, Password Text Input, Submit and Reset, Buttons, Radio Buttons, Checkboxes, Single-Select Menus, Multiple-Select Menus, File Select, Hidden Controls, Object Controls, Labels and Legends, Access and Navigation.

Sr. Database Administrator/Developer

Confidential

• Performing database administration and application development functions in federal government production and development environments functions database maintenance, monitoring tablespace size and activities, performance tuning and trouble shooting user issues, backup/recovery to support Financial and Government Operations Business Unit for Payment Processing application systems.
• Developing numerous PL/SQL programs for data extraction, transformation and batch loading ETL , implementing data validation process using stored procedures, functions, triggers, and packages
• Creating /customizing Web application using Oracle Application Express APEX .Using check box, page links,web page items, validate items, list of values, Flash Chart, calendars, Logo and Home Page Navigation Lists on the web page.
• Creating web user interface using Oracle Application Express APEX . Building Web Tabular Form using Wizard. Adding form items, check boxes, LOVs, Save, Modify, Apply buttons and links to call other forms or report pages. Coding logic to control form layout.
• Build Oracle web report using Oracle Application Express APEX . Creating Parameterized Report to falter the report output.
• Creating master-detail drill down report. Creating links in report to call another forms or reports.
• Creating Access Control Page to control all forms and reports page access. Building authentication Functions.
• Installing and configuring Oracle database application software, applying system patches on Unix /Linux/Windows platforms
• Backup/Recovery database using RMAN and Unix shell scripts.Troubleshooting and performance tuning, user supporting, and testing.Scheduling and automating batch process jobs, assuring data integrity and quality.
• Processing ad-hoc requests for data changes to legacy applications by writing Clipper scripts to update database files.
• Using Oracle Text to create a medical thesaurus, and CONTEXT indexes

Sr. Oracle Applications Consultant

Confidential

• Performing Oracle Applications Developer/DBA functions to support implementation, customization and maintenance of Oracle Applications 11i Managing data loading program interfaces and executive management decision reporting systems for Medicare Medicaid.
• Applying patches to Oracle Applications 11i environments using AD utilities adpatch, adctrl, adadmin, adautocfg, etc. .
• Cloning Oracle Applications instances using Rapid Clone and Autoconfig.
• Backup / Recovery management including capacity plan, backup and restore technology infrastructure, on-site storage, off-site storage, backup scheduling, performance optimizing, troubleshooting, and tape retention policies.
• Technical architecture design and multi-tier internet computation architect implementation, client requirements and gap analyses, business process re-engineering BPR , capacity planning and sizing management.
• Using Autoconfig and OEM to maintain multiple database instance demo, development, test, training, and production , analyze, and monitor database growth, manage tablespace fragmentation, backup recovery using RMAN and Veritas Netbackup.
• Troubleshooting and resolving the problems, serving as the liaison with Oracle, logging tars, reproducing the error in the testing arena, searching and downloading patch files.
• Performance tuning by collecting performance statistics for various components, analyzing and implementing tuning recommendations using various applications AD and DBA utilities.
• Administer and customize application database security/responsibility, create user accounts and grant privileges, install configure printers, and monitor concurrent processing in Oracle Applications.
• Plan and perform migration and upgrading of oracle databases 8.1.7 to 9.2.0.6 to 10.2 and applications 11.5.4 to 11.5.10 using migration tools, Export/Import, PL/SQL API and SQL Loader cloning/refreshing ERP instance from production to testing or development environments, backup, server partition, and version compatibility.
• Customizing/extending oracle ERP applications system, build or modify window interface and reports using SQL Plus, PL/SQL, SQL Loader, Developer tools Forms 6i, Reports 6i and Discoverer develop open interfaces for data conversion and import from legacy system or other operational data system into oracle financial database, using sql, pl/sql, sql loader, unix scripts and concurrent programs, using pl/sql to implement business logic and data validation.
• Training, mentoring and documenting technical and operating procedures.
• Using Discoverer to setup EUL and business areas, and generate reports for management decisions. Integrate Discoverer with Oracle Applications and BIS.
• Wrote Unix scripts and cron jobs to schedule DBA daily activities and program interface functions.
• Managing application security, managing concurrent programs and reports, administering concurrent managers, managing profile options, incorporating custom programs, auditing system resources, managing system resources, printers, and folders, performing applications DBA duties, incorporating custom help files, managing document sequences, defining key flexfields and descriptive flexfields, using value sets and additional flexfield options, defining and using workflow, viewing and responding to notifications, identifying implementation issues and implementing oracle alerts.
• Coding form logic to comply with the oracle applications 11i coding standards and interface with oracle applications, building a form layout that adheres to the oracle applications user interface standards for forms-based products, using template form, setting up menus and function security, using oracle applications user interface standards, coding a form using oracle applications coding standards, controlling window behavior, implementing tabbed regions, adding flexfield calling routines to a form, calling oracle applications APIs from a form, building query find windows, adding calendars to date fields, using message dictionary, adding advanced function security features to forms, adding special menus and right mouse button menus to forms.
• Using oracle applications custom library CUSTOM.pll, building zooms, modifying field properties, hiding fields and changing colors, adding special menu entries, implementing function security, adding code for several event points, integrating custom components into oracle applications using recommended standards, isolating customizations, customizing applications forms, libraries and other components, implementing custom online help, customizing help navigation trees.
• Using SQL Loader, PL/SQL, SQL Plus and UNIX shell scripts to develop GL interfaces for importing journals from subledger source system. Developed AP, AR, FA and PO interfaces. Performed daily, weekly and monthly data loading.
• Used Oracle Report 6i, 9i and General Ledger Financial Statement Generator FSG to develop reports on balance sheet summary and detail actual, budget, variance , commercial and consumer loans construction, real estate, home equity , investment securities, money market assets, regular savings accounts, deposits, interest bearing liabilities, total liabilities and equity , margin analysis management report balance, direct income/expense, funds transfer cost/credit, net interest income , trial balance , income statement , general journal account, income statement and detail transaction analysis report.
• Developing and documenting unit, system, and acceptance testing cases.
• Prepared documents regarding High level technical design technical overview, extension component technical design,database diagram, module compont list Detailed design components program logic, table usage matrix Processing logic program specification .
• Providing requirement analysis and data modeling support for the enterprise data model, reports and query performance tuning and used database change control tools.
• Set up and administered Oracle Workflow Used Oracle Workflow to enable business process definition, automation, and integration Defined subscription-based processing for business events Designed workflow processes using Oracle Workflow Builder Monitored the status of runtime workflow processes and respond to notifications Implemented advanced workflow process design features and Wrote custom PL/SQL procedures for use in workflow processes.

Sr. Oracle Applications Developer/DBA

Confidential

• Performing Oracle Applications Developer/DBA functions and responsibilities to support implementation, customization and maintenance of Oracle Applications 11i Managing data loading program interfaces and executive management decision reporting systems.
• Used Rapid Install to install Oracle Applications systems, AD Administration and other AD utilities to maintain Oracle Applications, AutoPatch to automate the application of Oracle Applications patches, and Rapid Clone to clone Oracle Applications systems.
• Upgraded existing Oracle Applications installation to Release 11i using Rapid Install Monitored AutoUpgrade status and handled failed jobs Applied upgrade patches and 11.5.x maintenance packs Performed post-upgrade tasks.
• Wrote Unix scripts and cron jobs to schedule DBA daily activities and program interface functions.
• Managing application security, managing concurrent programs and reports, administering concurrent managers, managing profile options, incorporating custom programs, auditing system resources, managing system resources, printers, and folders, performing applications DBA duties, incorporating custom help files, managing document sequences, defining key flexfields and descriptive flexfields, using value sets and additional flexfield options, defining and using workflow, viewing and responding to notifications, identifying implementation issues and implementing oracle alerts.
• Coding form logic to comply with the oracle applications 11i coding standards and interface with oracle applications, building a form layout that adheres to the oracle applications user interface standards for forms-based products, using template form, setting up menus and function security, using oracle applications user interface standards, coding a form using oracle applications coding standards, controlling window behavior, implementing tabbed regions, adding flexfield calling routines to a form, calling oracle applications APIs from a form, building query find windows, adding calendars to date fields, using message dictionary, adding advanced function security features to forms, adding special menus and right mouse button menus to forms.
• Using oracle applications custom library, building zooms, modifying field properties, hiding fields and changing colors, adding special menu entries, implementing function security, adding code for several event points, integrating custom components into oracle applications using recommended standards, isolating customizations, customizing applications forms, libraries and other components, implementing custom online help, customizing help navigation trees.
• Using SQL Loader, PL/SQL, SQL Plus and UNIX shell scripts to develop GL interfaces for importing journals from subledger source system. Developed AP, AR, FA and PO interfaces such as MORTGAGE, TRUST, HOME BANKING, ON LINE BANKING, DEPOSIT, REALTIME and so on. Preformed daily, weekly and monthly data loading.
• Used Oracle Report 6i, 9i and General Ledger Financial Statement Generator FSG to develop reports on balance sheet summary and detail actual, budget, variance , commercial and consumer loans construction, real estate, home equity , investment securities, money market assets, regular savings accounts, deposits, interest bearing liabilities, total liabilities and equity , margin analysis management report balance, direct income/expense, funds transfer cost/credit, net interest income , trial balance , income statement , general journal account, income statement and detail transaction analysis report.
• Developing and documenting unit, system, and acceptance testing cases.
• Providing requirement analysis and data modeling support for the enterprise data model, database query performance tuning and used database change control tools.
• Set up and administered Oracle Workflow Used Oracle Workflow to enable business process definition, automation, and integration Defined subscription-based processing for business events Designed workflow processes using Oracle Workflow Builder Monitored the status of runtime workflow processes and respond to notifications Implemented advanced workflow process design features and Wrote custom PL/SQL procedures for use in workflow processes.
• Training and mentoring junior team members, documenting technical and operating procedures.

Sr. Oracle Applications Consultant

Confidential

• Performing Oracle Applications Developer/DBA functions and responsibilities to support Federal Financial Management System FFMS and Core Financial System CFS , using PL/SQL programming, Oracle forms and reports in Oracle Applications 11i environments Federal Financials and HRMS .
• Used Rapid Install to install Oracle Applications systems, AD Administration and other AD utilities to maintain Oracle Applications, AutoPatch to automate the application of Oracle Applications patches, and Rapid Clone to clone Oracle Applications systems.
• Upgraded existing Oracle Applications installation to Release 11i using Rapid Install Monitored AutoUpgrade status and handled failed jobs Applied upgrade patches and 11.5.x maintenance packs Performed post-upgrade tasks.
• Wrote Unix scripts and cron jobs to schedule DBA daily activities and program interface functions.
• Managing application security, managing concurrent programs and reports, administering concurrent managers, managing profile options, incorporating custom programs, auditing system resources, managing system resources, printers, and folders, performing applications DBA duties, incorporating custom help files, managing document sequences, defining key flexfields and descriptive flexfields, using value sets and additional flexfield options, defining and using workflow, viewing and responding to notifications, identifying implementation issues and implementing oracle alerts.
• Coding form logic to comply with the oracle applications 11i coding standards and interface with oracle applications, building a form layout that adheres to the oracle applications user interface standards for forms-based products, using template form, setting up menus and function security, using oracle applications user interface standards, coding a form using oracle applications coding standards, controlling window behavior, implementing tabbed regions, adding flexfield calling routines to a form, calling oracle applications APIs from a form, building query find windows, adding calendars to date fields, using message dictionary, adding advanced function security features to forms, adding special menus and right mouse button menus to forms.
• Using oracle applications custom library, building zooms, modifying field properties, hiding fields and changing colors, adding special menu entries, implementing function security, adding code for several event points, integrating custom components into oracle applications using recommended standards, isolating customizations, customizing applications forms, libraries and other components, implementing custom online help, customizing help navigation trees.
• Designing, building and maintaining Oracle Form applications such as Budget Execution, Commitment and Obligations, Funds Control 'Obligation Transaction Screen', 'Allotment Transaction Screen' Payment Management Payee Invoice Data Entry Receipts Management 'Payroll Error Correction Screen' . General Ledger Management 'General Ledger Transaction Lookup Screen', 'Accounting Period Maintenance Screen', 'Process Preliminary Yearend Closing' Cost Management 'Manual Payment Transaction Report' , etc.
• Designing, building and maintaining Oracle Report applications such as Budget Execution, Commitment and Obligations, Funds Control 'Cumulative Overtime Report' Payment Management Payee Invoice Data Entry Report Receipts Management 'Report: Cumulative Payroll Interface Error Report'. General Ledger Management 'Status of Funds Report' Cost Management 'Manual Payment Transaction Report' , etc.
• Designing, building and maintaining Oracle database objects such as table, index, sequence, view, stored procedure, function, trigger, package and library using SQL and PL/SQL implementing complex business logic into applications such as Package: 'pkg inr120.sll' to create a temp table and insert data to the temp table, 'pkg pm101.sll', etc
• Participating CMM level 2 and 3 practices. Training and mentoring junior team members, documenting technical and operating procedures.

Oracle Applications specialist

Confidential

• Managing application security, managing concurrent programs and reports, administering concurrent managers, managing profile options, incorporating custom programs, auditing system resources, managing system resources, printers, and folders, performing applications DBA duties, incorporating custom help files, managing document sequences, defining key flexfields and descriptive flexfields, using value sets and additional flexfield options, defining and using workflow, viewing and responding to notifications, identifying implementation issues and implementing oracle alerts.
• Coding form logic to comply with the oracle applications 11i coding standards and interface with oracle applications, building a form layout that adheres to the oracle applications user interface standards for forms-based products, using template form, setting up menus and function security, using oracle applications user interface standards, coding a form using oracle applications coding standards, controlling window behavior, implementing tabbed regions, adding flexfield calling routines to a form, calling oracle applications APIs from a form, building query find windows, adding calendars to date fields, using message dictionary, adding advanced function security features to forms, adding special menus and right mouse button menus to forms.
• Used Oracle Report Builder to develop and maintain different styles of reports. Included Matrix, Form-like, Group left above , Tabular. Incorporated summary data and graphics in reports.
• Laid out and formatted data to suit user reporting requirements. Designed and developed Oracle reports about 'Financial Status Report from 1990 to 2000', 'Indian and Native American Programs Workforce Investment Act Grantee Activities', 'Department of Labor DOL Basis/Equity in SESA Real Property Summary', 'Waiver Management Report', and so on.
• Used Oracle Forms Builder to display form modules in multiple windows and variety of layout styles. Called Oracle reports from forms. Designed and developed Oracle forms about 'Budget Elements from 1990 to 2000', 'Job Corp Center Code', 'Performance Negotiation', 'Program Codes', 'Elements for Footprint', 'Regional Grant/Contract Number', 'Local Workforce Investment Areas' and so on.
• Implemented triggers to enhance functionality, supplement validation, control navigation and modify default transaction processing. Developed PL/SQL packages and stored procedures for generation of daily status reports for various projects.
• Used Oracle SQL, PL/SQL, SQL Load and Oracle Reports to find the missing data in several database tables, reload data to tables and display in 'Report of Invalid Transactions'. Mapped, converted and populated data using PL/SQL, SQL Loader.
• Actively involved in the system testing, debugging, integration testing and the new version releasing. Debugged program codes, tested applications, troubleshooting and SQL statements performance tuning.
• Used Cold Fusion 5.0, HTML, JAVA script 4.0 to design user web interface systems and develop 'ETA Automated Waiver System'. Participated in developing and testing web-based applications that enable user select years, regions and states to display the required Oracle 'Waiver Status Report' on web. Used JavaScript to perform client-side validation.
• Used ColdFusion Markup Language CFML and HTML, XML to store and output values. Built queries that publish, insert, and update data dynamically. Developed fully interactive, database-driven web applications.
• Gathered and analyzed database and data warehouse application requirements. Data modeling and data warehouse design Star Schema using Erwin and Oracle Designer, Generated and manipulated database tables using SQL and PL/SQL.
• Used Oracle Discoverer to generate ad-hoc query and create reports, setup business area and administer data warehouse metadata.

Oracle Application Developer/DBA

Confidential

• Used Oracle Developer/2000 Form 4.5, Report 2.5 to build the Hand Receipt Holder System forms and reports for NDU Logistics Department. Used Oracle Report 2.5 to create the Key Words Search reports for National Defense University Education Department. Implemented and generated various reports for different department using PL/SQL, SQL PLUS or Developer 2000.
• Participated in full process of database application development including converting different kind of raw data into fixed format or delimited files, splitting the source data and inserting them to different tables.
• Used PL/SQL creating stored procedures, database cursors and packages to maintain Database and update database.
• Debugged program codes, tested applications, troubleshooting and SQL statements performance tuning.
• Used FormFlow 2.1 to build the Personnel Vacation Information forms for National Defense University management.
• Y2K data conversion using Oracle PL/SQL procedure, function and package . Conducted Y2K testing databases.
• Actively involved in the system testing, debugging, integration testing and the new version releasing. Debugged program codes, tested applications, troubleshooting and SQL statements performance tuning.
• Gathered and analyzed database application requirements. Generated and manipulated database tables using Designer/2000, SQL and PL/SQL.
• Designed logical and physical data models using Designer 2000.

Oracle Database Programmer

Confidential

• Designed and developed user interfaces for NIH Drug Abusing data entry, modification, updating as well as querying and manipulating data using Oracle Developer/2000 Forms 4.5, Produced Build.
• Tested reports for NIH using Reports 2.5. Created PL/SQL package procedures, functions, triggers to replicate data from NIH database IMPACII to TYC database Commons. Developed PL/SQL programs to maintain Database and update database. Debugged program codes, tested applications, troubleshooting and SQL statements performance tuning.
• Modified ERD data models, redesigned and created databases Commons using Oracle Designer 2000.
• Converted data from IBM mainframe and loaded data into Data Warehouse using SQL Load, Oracle Export/ Import.
• Tested Sysbase software ExecDB. Tested normal program specific functions, missing command options on command line, missing control buttons on a screen, screen not initializing properly.
• Resolved inventory balance problems for NIDA project E-R diagram.
• Used Power Builder 5.0 to modify codes for NIDA projects.

Research Assistant

Confidential

• Tape data processing, data conversion and transformation among platforms.
• Oracle programming: SQL, PL/SQL, creating stored procedures, database cursors and packages to implement complete business functionalities and user requirements.
• Data manipulation and dealing with missing data using various imputation methods.
• Designed logical and physical data models using Designer 2000, modeling database entities and their relationships and interactions.
• Customer supported: complicated query writing and trouble shooting for the user groups.
• Gathered and analyzed database application requirements. Generated and manipulated database tables using Designer/2000, SQL and PL/SQL.

Computer Lab Administrator

Confidential

• Designed and implemented an ER model for Schedule of Classroom using Erwin and CASE Tools.
• Using stored procedures, package, functions, triggers and other database objects to manipulate and maintain the Oracle database.
• Used Oracle Forms to design training schedules and register forms.
• Provided SQL, SQL Plus and PL/SQL programming assistances to the users.
• Converted and populated data using PL/SQL, SQL Loader.