- Certification: OCP—Oracle
Certified Professional Database Administrator – 2001
- Clarkson University, Potsdam, NY
M.S. Management Information Systems
- University of Illinois, Champaign-Urbana,
IL
B.S. Microbiology
- Part of TEWLS (Theatre
Enterprise-Wide Logistics System) application team.
- Experience using graphical mapping
and adapter technologies to translate data between remote systems.
- Developed services to transfer
Oracle data between various other systems using SAP XI middleware,
- Installation/Configuration of
Oracle 9i database on Windows NT.
- Developed PL/SQL credit card
transaction batch processing scripts.
- Responsible for design,
development, coding, testing, interaction with bank personnel.
- Production DBA and support/maintenance of telecom
billing and other systems in a Windows NT/Unix/VMS environment, using
Oracle Parallel Server, Oracle 8i.
- Continuous 24/7 on-call duty
- Responsible for daily production jobs involving more
than 800,000 records each.
- Performed backup & recovery using RMAN and
scripts.
- Performed maintenance of Perl and PL/SQL processes,
BRIO reports and BRIO server.
- Performed SQL statement tuning and database tuning
- Wrote extensive system documentation using Visio and
MS Excel.
- Development DBA (Unix environment) on JAVA broadband
workflow software team
- Designed new module schemas (Data Modeling) using
Oracle Designer 2.1, ERwin, and Oracle Enterprise Manager on Oracle 8.0
and 8i databases using object-oriented methods.
- Performed Unix shell scripting (Korn shell scripts)
for database creation, population and integration of data using Sun Unix,
ETL (extract, transform, and load) procedures, Sql loader, import/export
and PL/SQL.
- Developed Java Server Pages for metadata.
- Gained exposure to Vitria, Toplink and BEA Weblogic Server
products.
- Gained database tuning and SQL statement tuning
experience.
- Lead Developer for a large (800+ tables), complex
integrated commercial software product using Oracle Forms, Reports,
Designer 2.1 and Oracle 8.0.
- Provided debugging, troubleshooting and tuning for
existing reservation modules.
- Migrated code from client side Forms to database
side PL/SQL packages, database triggers, and stored procedures.
- Participated in the requirements and documentation
phase of new modules.
- Participated in all software life-cycle stages in a
highly structured environment, using PVCS and Test Director as QA tools.
- As lead developer, brought new financial module from
concept to integration with existing suite of products.
- Member of DBA team
- Designed and developed security application for a HR
data warehouse DSS.
- Designed back-end security application in Designer
2000, developed application in Forms 4.5
- Wrote and maintained PL/SQL scripts for data
warehouse daily loads.
- Developed Oracle PL/SQL and Pro*C programs and
stored procedures for legal research databases in a Unix environment
- Developed and integrated Pro*C modules into existing
Lexis/Nexis application.
- Developed child processes for Pro*C modules using
PL/SQL, sed, awk and Perl scripts.
- Developed Oracle Forms module to
be used for Colorado Prepaid Tuition Fund using Forms 4.5 in a WIN95,
BANNER Financials, DEC ALPHA environment
- Developed module for Science &
Computers in Technology (SCT) commercial product
- Gained exposure to Banner
Financials
- Part of Project Accounting team for an Oracle
Financials project using Developer2000, (Forms 4.5, Reports 2.5),
SQL*PLUS, and Procedure Builder in WIN95 environment.
- Designed & developed custom Project Accounting
application as enhancement to Prod 15, to mimic Prod 16 functionality
(Data modeling and PL/SQL programming).
- Created & maintained tables, indexes, scripts,
triggers, stored procedures, & views
- Gained broad exposure to table structures of Oracle
Financials in Prod 15, Prod 16.
- Developed DBA database monitoring applications using
Forms 4.5 and PL/SQL.
- Part of Oracle programming team for a large-scale
configuration management system, using Oracle Developer/2000(Forms 4.5,
Reports 2.5)
- Cross-platform Oracle Forms development in Windows
NT and HP-UNIX
- Responsible for integration of Oracle with
middleware (n-tiered) and legacy systems.
- Gained strong experience with Oracle Designer/2000
- Oracle Programmer for a commercial manufacturing
software company, using Oracle Developer/2000 in Windows/Unix environment
- Programmed EDI modules of manufacturing product.
- Responsible for Oracle Forms 4.5 and PL/SQL stored
procedures.
- Individual and team programming assignments
Download Resume Format
0 comments:
Post a Comment