SUMMARY:

• Lifecycle development of enterprise Oracle applications/systems. Major leadership resource for Motorola (Radio Solutions Division), Confidential, Confidential, Confidential, Confidential & Co., Confidential, Worldcolor, NITS Solutions and Allant Group. Broad expertise in large - scale project implementation, Oracle database object creation, customer relationship management, requirements gathering, workflow analysis and reporting. Highly skilled in Oracle Developer, PL/SQL, SQL*Plus and stored procedures/triggers.
• Record of in project management, accurately defining and transforming broad technical requirements into workable step-by-step solutions. Consistently deliver projects ahead of schedule and under budget.
• Analytical problem solver, assessing complex application and system issues and implementing creative solutions that are “right the first time.”
• Uncompromising commitment to client satisfaction. Natural ability to build strong, trusting relationships with clients and end-users.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, SQL*Plus, Visual Basic 6.0, .NET, HTML, JavaScript, PowerBuilder

Platforms: AS/400-OS/400, DOS, Windows XP/2000/9X

Databases: Oracle 11g, Oracle 10g, Oracle 8i (8.1.7)/7.0, Oracle 9i Database Functions, SQL Server 2000, Watcom RDBMS

Utilities/Tools: Toad for Oracle 10.5, Oracle Warehouse Builder, PL/SQL Developer, PVCS, Oracle Developer 6.0/2000, Oracle Application Express (APEX) 1.6/2.0/3.2.1/4.0.2, Clarify CRM, JAM 7.36, Satellite Forms 3.1.5, Panther, Wise InstallBuilder 8.03, SalesLogix 4.0, Brio 6.6.4, Symantec AntiVirus Enterprise Edition 7x

PROFESSIONAL EXPERIENCE:

Programmer/Analyst

Confidential

Responsibilities:

• Successfully met all project objectives in build of an Application Express (APEX) Web application to create Projects (new products), create the Features for these Projects and add the Customer Commitments of the Features attached to the Projects (the Customer Commitment was the date that a Feature of a Project would be available to the marketplace).
• Application enabled a Record Change tracking email to be sent to users, determined by Project creator when a new record was produced or updates made.
• Ensured Record Change Information was displayed on the pages where updates could be made, showing who made the change, when it was made, what fields were changed and showing new/previous values.
• Provided automation to close any Customer Commitments that might be attached to a Project when the Project was closed. The functionality created displayed a message asking the user if they want the Customer Commitments closed automatically or not; if they don't want the Customer Commitments closed automatically they are reminded to close them manually.
• Built in critical security features, including multiple Authorization Schemes that enable different access to pages/fields on a page based on identification of a user (Super Admin, Admin, Advanced, Basic, Basic Internal). Authentication Schemes were based on LDAP and Active Directory entries.
• Took initiative to also create new tables and update all existing tables.
• Deployed to production on time, with all parameters met.

Environment: Oracle 11g, Application Express 4.0.2.00.07, PL/SQL Packages, Triggers, SQL, JavaScript

Confidential

Responsibilities:

• Paved the way for this business to purchase food items from various vendors when price increases were announced, by managing design/development of an Application Express (APEX) Web application. Worked with Project Managers, Data Architect and Business Analyst to integrate the data access layer of the application.
• Developed interface that enabled the upload of recommendation spreadsheets for obtaining various food items.
• Created PL/SQL Package to perform parsing, validation and transmission of emails.
• Built VBA application to parse a Word document into an Excel spreadsheet.

Environment: Oracle 11g (11.1.0.7.0 ), Oracle APEX 3.2.0.00.27, PL/SQL Procedures

Confidential

Responsibilities:

• Drove build of an Application Express (APEX) Web application that gave Confidential dealerships the ability to enroll in a Wholesale Parts Reporting Tool, enabling them to track Wholesale Mechanical Parts sales.
• Worked with Data Architect and Business Analyst to ensure design discrepancies were resolved.
• Innovated 2 interfaces that gave dealers new business-critical capabilities:
• An interface that enabled Direct Mail campaigns to customers promoting the purchase of parts.
• An interface that allowed dealers to manage their profiles.

Environment: Oracle 11g (11.2.0.1.0 ), Oracle APEX 4.0.2.00.06

Confidential

Responsibilities:

• Central technical resource for this marketing firm, developing database views/SQL scripts in a data warehouse environment to generate vital client reports with sales, call volume, contacts and call disposition metrics (Oracle 11g).
• Worked with Data Architect and Business Analyst to resolve design discrepancies.
• Completed performance tuning and SQL optimization.

Environment: Oracle 11g, Database Views, SQL scripts

Confidential

Responsibilities:

• As Lead Developer, built an Intranet application for this printing company’s Human Resources Department using APEX 3.2.1 and Oracle 10g. Application enabled complete employee and asset management, ensuring new hires had everything they needed when reporting for work the first day.
• Delivered full support to end users in defect resolution and data integration.
• Created innovative email distribution process to send supervisors/managers emails when a new asset was needed for an employee or consultant.

Environment: Oracle 10g, Oracle APEX 3.2.1, JavaScript, PL/SQL Procedures

Confidential, Lake Zurich, IL

Programmer/Analyst

Responsibilities:

• Skillfully worked with Data Migration team to take data from different source tables and create data migration maps (Oracle Warehouse Builder). Utilized spreadsheet tofilterdata, thenprovide code conversion and validation rules for each column in each table migrated. Moved data to staging tables and applied validation rules.
• Fulfilled project goals by subsequently developing PL/SQL packages to apply business and transformation rules to the data and move it into production tables.

Environment: Oracle 10g (10.2.0.3.0 ), Oracle Warehouse Builder, PL/SQL Developer, PVCS, PL/SQL packages and procedures

Confidential, Wood Dale, IL

Programmer/Analyst

Responsibilities:

• Saved company $thousands by designing/developing Intranet reporting system to track productivity of customer service agents.
• Enhanced customer satisfaction by creating reports that enabled management to communicate job status to internal/external clients.
• Facilitated daily revenue tracking by producing financial accounting reports.
• Designed and built Internet application that gave vendors the ability to generate additional revenue, by selling products at a nationwide hardware store chain.
• Supplied comprehensive support to point-of-sale, order information and purchase order systems. Systems were configured to use 4D as front-end GUI application. Skillfully debugged, compiled and distributed interpreted 4D code base to all offices.

Environment: Oracle APEX, HTML, JavaScript, PL/SQL, 4D

Confidential, Naperville, IL

SQL Server Developer

Responsibilities:

• Streamlined processes for the Network Administration and Data Processing departments by writing VB6 automation applications.
• Automated tracking of call center record distribution with a VB6 application, enabling the call center to maintain a sustained call schedule while reducing spreadsheet processing time by 30 minutes per sheet.

Environment: VB6, SQL Server 2000, Dynamic Stored Procedures

Confidential, Itasca, IL

Programmer/Analyst

Responsibilities:

• Led the successful upgrade, customization and support of an Oracle-based catalog maintenance & pricing system.
• Efficiently administered a CRM application supporting over 1500 sales representatives, using SalesLogix 4.0 with a MS SQL Server 7 back-end.
• Enabled a 30% sales increase by developing numerous stored procedures that read multi-source flat files to verify and validate data.
• Saved $100K for the Marketing Dept, by building an Oracle application to import new, reactivated and deleted catalog items from an AS/400-based flat file.
• Developed stored procedures using PL/SQL to:
• Populate AS/400 files (real-time) and Oracle tables by accessing AS/400 files and flat files from other sources.
• Supply data to Clarify CRM application and manage marketing promotions/pricing through e-mail.
• Read flat files created from the mainframe (Race), AS/400, Boise's Website and Clarify CRM to verify and remove duplicate records.

Environment: Oracle Developer 2000/6.0, PL/SQL, AS/400, Clarify CRM, SalesLogix 4.0, MS SQL Server 7, Oracle RDBMS