SUMMARY

• Senior Oracle Developer with over twenty two years of computer programming experience, including extensive Oracle database, Oracle Forms 10g/9i/6i/6, Oracle Reports 10g/9i/6i/6, Oracle PL/SQL, Microsoft SQL Server Database, Quest Toad, Unix, PSP, JSP, Java, Java Script, and HTML, and XML experience.
• Solid background in E - Commerce development, Client Server applications, Web application development, and custom Oracle applications development
• Capable of data modeling and performing Database Administration tasks, skilled in writing stored procedures and triggers, and preparing functional and technical documentation
• Experienced in all phases of the software development life cycle using SDLC process.
• Self-starter who can work independent, but who also possesses the interpersonal skills to facilitate collaboration, knowledge sharing, mentoring, and team efforts

TECHNICAL SKILLS

Databases: Oracle 10g/9i/8i/8/7, Microsoft SQL Server Database 2000/2005, MS Access

Programming Languages: Oracle PL/SQL, Oracle SQL, XML, PL/SQL Server Pages ( PSP), Java, JSP, EJB, HTML, MS Visual Basic, JavaScript, JSP, PowerBuilder 3/4/5/6/6..5/7, PowerBuilder Foundation Class 7.0 (PFC), Unix Shell Script

Development Tools: Oracle Forms 10g/9i/6i/6, Oracle Reports 10g/9i/6i/6, Oracle 10g/9i J Developer, Oracle Graphs, Oracle Portal, Oracle AS, Oracle SQL*Plus, Oracle SQL*Loader, Oracle Developer 2000, Quest Toad, Quest SQL Navigator, Win FTP, Web Logic, Dreamweaver, Visual Café, Rational Rose, PowerBuilder 3/4/5/6/6..5/7, PowerBuilder Foundation Class 7.0 (PFC), Microsoft Visual Studio, Microsoft Visual Foundation Class Library, Visio, Microsoft SQL Server Management Studio

SCM Tools: Team Foundation Server (TSF), StarTeam, PVCS

Data Modeling Tools: ERWin, Power Designer 6, Oracle Designer 6i

Business Intelligence: Business Objects (BO), Oracle Discoverer

Content Management: Documentum, Lotus Notes

Operating Systems: UNIX, AIX, MS Windows 3.x/95/NT/XP/7 Premium, MS-DOS, Novell

Oracle Applications: Oracle Financial General Ledger

Client Applications: Confidential Financial Service Oracle Commission and Registration Application, Confidential ’s Budget Analysis System, Confidential ’s Gold Points Plus Reward Incentive Application, Confidential ’s Medical Device Registration and Inventory System, Confidential ’s Call Tracking Application, Confidential ’s Event Analysis System, Confidential ’s Sales Advantage Portal System, Confidential ’s Retail Online Stores (Plasmavision.com, USGA.com, Uproar.com, ScanSoft.com, etc…), Xcel Energy’s Document Control System

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Senior Oracle Applications and PL/SQL Developer

Responsibilities:

• Worked on several projects such as AXA, Admin Fee Reimbursement, process NSCC commission’s files, Affiliate Entities, Data Suppression, Job User Group, Account Receivables Aging Flag system.
• As part of the Oracle team, provided production support and implemented enhancements to the existing Commissions and Registration system.
• Modified existing Custom Commissions system by creating 30 new custom Oracle Forms and Oracle Reports, and Oracle SQL Reports to manage pending commissions, commission payouts, commissions splits, commissions overrides, and commissions fees for the new broker dealer.
• In an existing Oracle custom Registration system, converted 120 existing Oracle Forms and Reports to enable handling of multiple corresponding broker dealers.
• Created functional and technical specification document, created a data model, tables, views, triggers, sequences, Oracle roles, new custom Oracle Form to setup reimbursement rates and admin fees participating product groups and 8 Oracle Reports, and developed automatic SQL loader file to load monthly text file into Oracle database.
• Wrote proposal document and redesigned, modified, and tuned existing Oracle stored procedure to process and split large complex NSCC trades/commissions text files by corresponding broker dealers.
• Wrote 10 Oracle conversion PL/SQL scripts to terminate 3800 AE’s Rep IDs and registered them as Confidential advisors. This mass conversion scripts included loading of large prospect data, reps, branches, advisor’s continuing education data, and advisor’s license and state registration text data file.
• Modified rep statement stored packages to hide rep commission’s payout and payout percentages. Two new Oracle Forms were created for the Job User Group project. One form allows creation of group and defines users in the group. The second form allows setting of user preferences to query the submitted job by login user or by job user group.
• Created a new custom Oracle application to manage the collection of aged account receivables, wrote functional specification, system design specification, and software design specification, created data model, tables, materialized views, triggers, sequences, 3 new Oracle roles, Oracle Forms, and Oracle Reports.
• Developed an Oracle Process Control Forms for the 24 by 7 data center operators and Oracle DBA to monitor nightly cycle processing and scheduled commissions payout processing. Supported urgent calls and provided defect resolutions to Confidential Financials Services Data Center and Commissions and Registrations users.
• Developed a custom Oracle Rep Advance Forms, stored packages, stored functions, and view to allow Commissions department users to pay Confidential ’s advisors commissions in advance and manages approval and reject work flow process.
• Developed a view to interface with Oracle Financial Application General Ledger application and modified all custom Oracle Forms and Oracle Reports to display or select a valid GL account codes in Oracle GL. Developed PL/SQL script to load commission payout data into Oracle Financial GL.
• Developed a health check PL/SQL stored package along with Oracle Form User Interface to allow Oracle DBAs and developers to setup up to 10 SQL queries to check the health of the database or application. This application will email multi tabs Excel health check report to alert developers or users or DBAs if health check failed.
• Developed an interface PL/SQL stored packages to pull, and process daily incoming BETA trade commission settlement data from multiple Microsoft SQL Server databases and loaded into Oracle Commissions and Registration database using Oracle database link.
• Developed a PL/SQL job to extract data from Oracle Commissions Registration database and create a pending and paid commission’s file in tab delimited format and XML format. These pending and paid commission files are deliver to external client such as AXA Equitable, Wealth Enhancement Group (WEG), and Affiliated Entities.

Confidential, Shoreview, MN

Senior Oracle Applications Developer

Responsibilities:

• Developed a new custom Oracle (Forms, Reports 9i/6i with Oracle 9i DB) web-based application called Confidential ’s Enterprise Product Registration (EPR) system based on a functional and technical specification documents which was originally developed in Oracle Forms, Reports 4.5 with Oracle Database 7.3.
• The new EPR were developed to get it a new look and feel. This Oracle Forms/Reports 9i application used following objects: hierarchical tree, tabs, drop down List box, drop down calendar, external progress meter, mail, and complex graphs and also implemented single sign on technology.
• The following tasks were implemented to move this application to production: data conversion, forms migration, setup user and application security roles, setup right version of J initiator, modified Forms configuration files to setup this application to run on UNIX.
• Converted all Oracle Applications from Oracle Forms 6i, and Oracle Reports 6i to Oracle Forms 9i and Oracle Reports 9i.
• The following tools were used to developed these applications: Oracle Forms 9i/6i, Oracle Reports 9i/6i, Oracle Designer 9i/6i, Oracle Graphs, Oracle Web Services 9iAS, Oracle 9i Database, HTML, Java Script, UNIX, Oracle SQL*Plus, and Toad.
• Application took 5 months to code, test, and deploy to production, last 2 months spent developing enhancements for existing Oracle Forms, and Oracle Report web based applications and developed enhancement to EMAS web application using Java, JSP, EJB, HTML, Java Script, UNIX, and Oracle 9i Database.
• This application runs on IPlanet Application Server on Windows NT

Confidential, Eden Prairie, MN

Senior Oracle Web Developer

Responsibilities:

• Worked in conjunction with the database administrator to design and finalize the data model for the Sales Advantage Portal schema
• Researched, analyzed, investigated, and resolved issues encountered using Oracle Portal to build the Web site
• Wrote common PL/SQL procedures and packages to display dynamic HTML pages. These procedures and packages were called from Oracle Portal during the creation of dynamic page creation, and were added as a portlet in Oracle Portal.
• Trained Confidential ’s developers to assist, support, and maintain Web site that was created in Oracle Portal, Oracle 9i, PL/SQL, HTML, and JavaScript
• Developed all Web pages for Sales Advantage portal, including top navigation menu and side navigation menu used throughout the Web pages
• Also developed Welcome, Learn, Itinerary, Itinerary Calendar, Reinforcement and Resources, Practice, Simulation, On the Job Activity, Implementation Guide, Tools, Plan, Evaluate, Job Aids, Development Analyzer, Improvement Plan, Test, Research, and Financial pages. Development tools included Oracle 9iAS, Oracle Portal, Oracle 9i, PL/SQL, HTML, and JavaScript

Confidential, Shoreview, MN

Senior Oracle Applications Developer

Responsibilities:

• Developed custom oracle applications web-based applications using Oracle Forms 9i/6i, Oracle Reports 9i/6i, Oracle Designer 9i/6i, Oracle Web Services 9iAS, Oracle 8i Database, HTML, Java Script, Unix, Oracle SQL*Plus, and Toad. These applications were used in U.S., Europe, and Tokyo
• Custom Oracle Web Form Applications included Neuro Registration System, Neuro Business Registration System, MIT Strategic Framework, Call Tracking of Confidential, Neurological Prior Authorization Tracking Form, Enterprise Registration System, Electronic Records System Inventory, and Data Planning, Enterprise Field Action System, and CROC
• Neuro Registration System allowed entry of registration information, such as Hospital, Physician, Equipment, Equipment Therapy, and Physician Specialty. MIT Strategic Framework System allowed tracking of Confidential MIT purchased products and licenses, and installation of products at Confidential business units and sub-business units.
• Wrote Oracle PL/SQL scripts, stored procedures, stored functions, packages, and triggers to support the applications
• Performed analysis and tuning of SQL
• Worked with business areas and IT personnel to gather requirements, to write the design document, and to develop and test the implementation
• Data Modeling was done using Power Designer and Oracle Designer
• Oracle databases were created using DDL script produced from Oracle Designer
• Maintained Oracle databases using Oracle Enterprise Manger, Security Manager, SQL worksheet, Oracle SQL*Plus, Toad, and Unix
• Upgraded several exiting PowerBuilder applications to PowerBuilder version 7.0

Confidential, Minnetonka, MN

Web Developer / Software Consultant

Responsibilities:

• Developed Rooster’s invoicing system using Oracle, Oracle PL/SQL, JAVA, JSP, EJB, LDAP, BEA Visual Café, Dreamweaver, BEA WebLogic, Ariba Dynamic Trade, and Rational Rose. Maintained, supported, and setup the WebLogic server for Confidential

Confidential, Eden Prairie, MN

Senior Oracle Web Developer / Software Consultant

Responsibilities:

• Developed a Web Site for Fujitsu General of America (Plasmavision.com) using Oracle PL/SQL, Oracle 8i, Web Server, HTML, JavaScript, JSP, Unix, and PVCS
• Worked on various new projects, such as an enhancement development for ScanSoft.com, Uproar.Com, and USGA.com. Added search capability before displaying the shopping basket to ScanSoft.com
• Extracted specific Uproar cookie information from Uproar.com, and stored data in an Oracle database for reporting
• Wrote design and functional specifications to develop new functionality that handled pricing for products that had multiple attributes, such as an extra large T-shirt that was priced higher than a small T-shirt
• Maintained and supported existing E-Commerce system.

Confidential, Shoreview, MN

Senior Software Consultant

Responsibilities:

• Developed an Event Analysis System (EARS) using PowerBuilder 6.0 and Oracle 7.3 database and migrated the system to PowerBuilder 6.5 and Oracle 8.0 database
• Analyzed business requirements and wrote detail requirements for the project
• Used Power Designer to create and maintain the data model of the EARS system
• Migrated the data model to Oracle Designer 2000
• Wrote Oracle PL/SQL stored procedures, packages, and triggers for EARS database
• Used Exceed, Unix, Oracle SQL*PLUS, and Oracle Designer 2000 tools to maintain and create triggers, stored procedures, packages, and data definition language (DDL)

Confidential, Eden Prairie, MN

Senior Software Consultant

Responsibilities:

• Developed a Sales Analysis Budgeting System using PowerBuilder 5.0 and an Oracle 7.3 database
• Analyzed business requirements and wrote detail requirement.
• Developed integration testing procedures, user acceptance testing procedures, and was responsible for production deployment.
• Wrote Oracle PL/SQL stored procedures for Budgeting calculations, which were accessible from PowerBuilder’s data window.
• Performed Oracle 8.0 development for the new database design of the Sales Analysis Budget System
• Wrote common Oracle objects using stored procedures, stored functions, and packages
• Wrote insert, update, and delete triggers on all the operational tables that maintained the data in the Data Warehousing table.
• Wrote Oracle PL/SQL and Unix shell scripts that utilized Oracle SQL*Loader to export and import data
• Wrote PL/SQL load scripts to load data from the old database to the new database
• Database Administration responsibilities included creating tables, indexes, and constraints; setting roles; and granting permissions to users.
• The environment consisted of PowerBuilder 5.0, PFC, Oracle 8.0, Oracle 7.3, UNIX, Exceed, MS Windows NT, and Lotus Notes.

Confidential, Plymouth, MN

Senior Software Consultant

Responsibilities:

• Developed Gold Points Plus Call Center application against an Oracle database on PowerBuilder 5.0
• Implemented the conversion from PowerBuilder 4.0 for MS NT/MS SQL Server to PowerBuilder 5.0 using PowerBuilder Foundation Class (PFC) against the Oracle database
• Converted existing MS SQL Server stored procedures to Oracle stored procedures using Unix and Oracle SQL*Plus tools. Modified the PFC security applications to be used for all Gold Points Plus GUI applications
• Developed Gold Points Plus Call Center application against the MS SQL Server 6.0 using PowerBuilder 4.0 for MS NT 32 bits.
• Designed the data model for the Gold Points Plus database using LBMS data modeling tool.
• Wrote stored procedures to process daily transactions extracted from Stratus Point-of-Sales system. to calculate bonus points earned and export them back to Stratus Point-of-Sales system and to retrieve information for the Gold Points Plus Voice Response Unit (VRU).

Confidential, Minneapolis, MN

Senior Systems Analyst/Operating Systems Analyst/ Programmer / Analyst

Responsibilities:

• Migrated a mainframe Drawing Documents Control system written in Natural to PowerBuilder 4.0 and MS SQL Server 6.0. The application managed millions of detailed engineering drawing documents.
• Participated in all phases of system development life cycle.
• Used ERWin to build the database schema for MS SQL Server and PowerBuilder.
• Built and wrote the MDI framework for the application containing reusable objects, such as invisible share data window, tab folder user object, drop down calendar objects, data window object, customized save as function, and select columns. Wrote a search routine similar to MS Windows 95 Find command. Worked on reports and other utility screens.
• Designed and programmed the graphical user interface based on standards developed by NSP.
• Wrote a non-visual mail session object to enable e-mail from within an application.
• Used TCP/IP utilities to download data from the MVS system, manipulated those using Visual C++ programs, and uploaded to MS SQL Server using Bulk Copy Utility.
• Customized and enhanced Certification Management and Report System (CMARS), which was written in PowerBuilder to replace the Welders Qualification System on the mainframe VM system.
• Improved the performance of the system by redesigning the database structure using Erwin data modeling tool. Developed a MS Visual Basic application, Edison Electric Institute Online System.
• Migrated a Timely Attention Reminder System written in Clipper 5.0 to MS Access 2.0
• Developed a Trailer Tracking System using MS Access 2.0 to track the amount of fuels, wastes, and other unprocessed materials that would be transported to and from power plants.
• Conducted training sessions on the application at each power plant.
• Worked with the infrastructure team to implement MS Mail system to communicate with other mail systems at NSP. Maintained, enhanced, and supported mainframe VM applications, which provided power supply reports and daily status reports of power plants.
• Migrated NSP's VM/HPO to VM/ESA operating system and VM/HPO from 3081 CPU to 3090 CPU.
• Successfully migrated all software on the VM system to run on VM/ESA operating system.
• Wrote technical programs to set up development environment for programmers.
• Migrated PROFS to Office Vision/VM and wrote MS Windows 3.1 installation standards.
• Provided technical support to mainframe programmers and troubleshot mainframe operating system.
• Installed TCP/IP 2.0 on multiple mainframes, MVS/ESA, and VM/ESA operating system.
• Developed a corporate file transfer application using TCP/IP and REXX.
• Wrote utilities to automate startup and shutdown of the operating system for daily backup.
• Implemented and supported Disaster Recovery procedures.
• Developed an Inside Advisors application on VM/SP HPO operating system.
• Developed a Corporate Directory application on VM/SP HPO operating system.
• Developed a Personnel Directory application on VM/SP HPO operating system.
• Developed a Power Supply Status Reporting application on VM using REXX, DMS, and EMS database.