Oracle Consultant Resume
SUMMARY:
- I have been working as an independent contractor for the past nineteen years. My application development experience includes Healthcare, Banking, Financial, Accounting, Payroll, Marketing, Manufacturing, and Engineering. As a programmer, system analyst, and a project leader, I have participated in all phases of development.
- As a Database Administrator
- I have been involved in all phases of installation, upgrade, and maintenance of Oracle 7 to 11g databases.
- I am also proficient in data modeling and database design. Below please find a short summary of my resume.
TECHNICAL SKILLS:
- Misc.
- Web
- UNIX
- PL*SQL
- Oracle 7 - 11
- Embedded SQL
- Adobe ColdFusion
- 4.5, 5.0, MX 6, 7, 8, 9
- Windows
- Oracle Forms
- 4.5, 5, 6i, 9i, 10g
- SQL Server
- Oracle Express
- Adobe Flex
- UNIX Shell Scripting
- Informix CISAM
- Oracle C/PRO*C/OCI
- Javascript
- C/C#
- Oracle Designer
- Java
- Oracle iLearning
- MongoDB
- Node.js
- Clients/Employers List
- AAR
- Chef Solutions
- RR Donnelley
- Abbott Labs
- CNA Insurance
- The Hill Group
- Allegiance Healthcare
- Galileo
- TravelClick
- Travelport
- American Digital
PROFESSIONAL EXPERIENCE:
Confidential
Oracle Consultant
Environment: Used ColdFusion 8,, HTML, DHTML, CSS, Javascript, XML, Dreamweaver, ColdFusion Studio 8, Adobe ColdFusion Builder, Adobe Photoshop 7, SQL Server 2000, T-SQL, Worked in the capacity of a remote developer
Responsibilities:
- Maintained and supported Oracle iLearning
- Augmented and enhanced the iLearning system by creating custom code in PL/SQL to support various business needs
- Wrote custom PL/SQL code that used global temporary tables, external tables, PL/SQL tables, cursors, and materialized views
- Worked with bulk loads and bulk binds
- Created batch routines for various data uploads
- Coded a new security system in KORN shell to secure access to mission critical information
- Designed new, re-designed, re-coded and consolidated existing load jobs via XML loads
- Debugged applications, packages, functions, procedures
- Designed and coded custom ETL solution (in PL/SQL) to migrate data out of Oracle
- Migrated all iLearning data to SumTotal LMS running on SQL Server
- Wrote custom reports using SSRS Report Builder
- Wrote custom reports housed on SharePoint server
- Wrote custom code in Java to scrape and auto-fill web forms
- Wrote custom code in Excel VBA to auto fill web forms
Confidential
ColdFusion Consultant
Environment: Used ColdFusion 8,, HTML, DHTML, CSS, Javascript, XML, Dreamweaver, ColdFusion Studio 8, Adobe ColdFusion Builder, Adobe Photoshop 7, SQL Server 2000, T-SQL, Worked in the capacity of a remote developer
Responsibilities:
- Developed multiple multi-tier real time object oriented ColdFusion applications for customers
- Technical lead on customer applications
- Led a team of seven developers
- Used object oriented methodology to design projects
- Designed projects in 3-tier architecture with totally independent data, application logic and presentation layers
- Broke down projects to small and manageable modules
- Delegated projects to team members
- Designed and developed SQL databases, database structures, and stored procedures
Confidential
Oracle Consultant
Environment: Used ColdFusion 8,, HTML, DHTML, CSS, Javascript, XML, Dreamweaver, ColdFusion Studio 8, Adobe ColdFusion Builder, Adobe Photoshop 7, SQL Server 2000, T-SQL, Worked in the capacity of a remote developer
Responsibilities:
- Coded over twenty new applications in Oracle Forms 4.5, and 6i
- Wrote multiple back-end applications in PL/SQL
- Created tables, views, indexes, packages, functions, procedures
- Fine-tuned SQL
- Debugged applications, packages, functions, procedures
- Synchronized multiple databases
- Created import/export routines
- Created batch routines for nightly data uploads
- Provided remote data syndication to external clients and systems
Confidential
Data Acquisition Analyst
Environment: Used ColdFusion 8,, HTML, DHTML, CSS, Javascript, XML, Dreamweaver, ColdFusion Studio 8, Adobe ColdFusion Builder, Adobe Photoshop 7, SQL Server 2000, T-SQL, Worked in the capacity of a remote developer
Responsibilities:
- Client had purchased two smaller companies and was in the process of installing SAP and merging data. Worked for the client in the capacity of data acquisition analyst.
- Designed and coded procedures to acquire data from multiple disjoint systems and Databases from multiple companies and multiple divisions.
- Coded a front end GUI system in VB and Oracle to allow employees to review, update, and clean their data. Wrote multiple systems in Excel, Excel Macro, and VBA to carry out small automated clean up procedures.
- Wrote backend C programs, PL/SQL packages and UNIX shell scripts to automate and batch modify terabytes of data.
- Merged data from three companies and over one hundred divisions into an Oracle SAP system.
Confidential
ColdFusion Developer
Environment: Used ColdFusion 8,, HTML, DHTML, CSS, Javascript, XML, Dreamweaver, ColdFusion Studio 8, Adobe ColdFusion Builder, Adobe Photoshop 7, SQL Server 2000, T-SQL, Worked in the capacity of a remote developer
Responsibilities:
- Developed a complete on-line real time ColdFusion application to manage a dealership business
- Included the following modules: Inventory, Sales, Accounting, Billing, Marketing, shopping cart and ecommerce with merchant account for on-line sales and down payment, Web advertising, Integration with eBay Motors for automatically listing dealer inventory to eBay, eBay management tools, and integration with PayPal
- In charge of Search Engine Optimization
- In charge of Overture Ad words and marketing
- Technical and project lead
Confidential
Oracle Developer
Environment: Used ColdFusion 8,, HTML, DHTML, CSS, Javascript, XML, Dreamweaver, ColdFusion Studio 8, Adobe ColdFusion Builder, Adobe Photoshop 7, SQL Server 2000, T-SQL, Worked in the capacity of a remote developer
Responsibilities:
- Setup Oracle Forms/Report server 4.5 for the client
- Wrote multiple accounting, customer, and project management applications in Forms
- Wrote a large number of PL/SQL routines
- Created database objects such as: tables, views, indexes, triggers, packages, functions, and procedures
- Fine-tuned SQL
- Debugged applications, packages, functions, procedures
- Created reports in Oracle reports and C language