A data systems computer professional with demonstrated competencies in managing and developing complex projects requiring the application of specific technical knowledge utilizing broadly defined work direction and a high level view of systems, data warehouses, business contexts, and organization strategies with an emphasis on customer satisfaction and quality assurance. A very experienced hands-on Oracle application developer with many years of designing, modeling, building, loading ETL and maintaining and creating Oracle data warehouses and PowerBuilder GUI Applications. Very proficient in PL/SQL and all its components as well as Oracle utilities. Provides work direction and technical guidance to team members. Effectively assesses alternate system solutions to business problems to control cost and quality. Self-motivated. Takes initiative. Flexible. Risk taker. Fast tracker. Contributes positive influence and impact through effective communication and high yielding productivity. Manages project costs and diverse technical staffs consisting of highly skilled employees and/or consultants.

To secure a consulting or permanent employee position as a Senior Developer and/or Project Leader in a PowerBuilder v11.0 / Oracle v9i/10g Rapid Application Development RAD environment.

ORACLE v5-10g, PowerBuilder v2 11, DB2, Teradata, SAP, SQL Loader, SQL Net, Performance Tuning, Object Management, TCP/IP, PL/SQL, ETL, Oracle Intermedia, XML, XSL, HTML, JAVA, Business Object v3-5, ERWIN 4.0, HP Intelligent Warehouse, COGNOS, XCOM LU6.2, WATCOM, MVS, SQL Forms, Web Access Assistant WAA Data Warehousing Web Tool, VB v5, EAServer, Power Dynamo, Jaguar, Web Targets, Sybase Central, Adaptive Server Anywhere, PFC, ActiveX, Unix, Linux, CICS, COBOLII, TSO, JCL, VSAM, Assembler, IBM Utilities, Word, Excel, MS Project, FTP, Maestro Job scheduling with Conman and Composer

IBM30xx Mainframe, RS6000/UNIX, AIX, HP, AS400, Amdahl, Novell 3.12, Pyramid 7000, Sun Microsystems, Solaris, AIX, HP-UX, Amdahl, Windows NT/95/98/2000/XP/Vista/7/8

Contracts, Rebates, Pricing, Claims, Physician Key Opinion Leaders, Physician Therapeutic Analysis, Marketing Tools, Sales Forecasting and Production Planning, Inventory Control and Accounting, Credit Card Administration, Application Tuning and Development, Production Turnover Reviews, Production Library Control, Integrated System Testing and Quality Assurance, Field Sales Force Automation, Corporate System Interfaces, Data Warehousing, Supply Chain Management, Web Development, Voice Activated Applications, Transportation Decision Support, Sales Objectives

Oracle Database Administration, PL/SQL Developer, Web Developer, Oracle Web Search Engineer, Data Warehouse Modeler, Project Manager, Project Leader, Technical Leader, Business and Systems Analyst, PowerBuilder GUI Application Developer, Sales Representative, VP General Manager, H.S. Teacher

Legal Profession, Pharmaceuticals, Retail Food Manufacturing, Veterinary and Agricultural Products, Information Technology, Hospital Services, Tele-Communications, Consumer Products, Lighting Industry, Pipeline Construction, Oil and Gas Industry, Education, Publishing

Confidential

Developed database models and support documentation in order to meet business requirements for reporting and analytic databases. Analyzed data sources and requirements and business rules, performed logical and physical data modeling, wrote prototype PLSQL to prove data transformations, and wrote specs for ETL development, implement and test database design. Coordinate data models across marts and warehouses, manage dictionaries and other documentation across multiple data marts and data warehouses.

Skill sets utilized: Data Analysis, Data Warehousing, Oracle 10g Data Modeling, SQL, PL/SQL, Erwin R8, TOAD Data Modeler, and TOAD SQL Optimizer.

Confidential

• Short term contract for international pharmaceutical company. Performed PowerBuilder V11 and Oracle
• 10g database development work to reposition Impromptu Excel spreadsheet reports into an Oracle database audit repository. Built new facility in PowerBuilder to execute, display, filter and sort data and save reports. Built new discount pricing tier movement evaluation and reporting process for a new drug within an SAP customer contracted sales reporting system that analyzed historic sales data and moved contracted customers to new pricing discount tiers based on quarterly sales performance.

Confidential

Short term contract for SAIC defense contractor . Performed Oracle 11g database development and architecture work for various Federal Air Marshal Service .Net websites and portals. Unable to give more details because of security restrictions. Utilized Master Data Management standards to cleanse and uniquely identify master data elements within database model such as airports, hotels, air marshals, weapons and training classes. Currently hold Government Confidential/Public Trust security clearance.

Confidential

Short-term assignment to performed Oracle SQL performance tuning and PL/SQL development on a new

product Confidential being launched in China.

Confidential

Oracle 10g and PowerBuilder v10 consultant and developer for law firm and lawyer .NET websites and API's that contain search engines and biographical information in a data warehouse environment. Developed a PowerBuilder v10 data comparison tool to compare upstream database Lawyer and Law Firm ratings from the ratings system with the downstream database warehouse ratings that service the websites to ensure that the ETL processes between the two were functioning properly and to aid in customer problem resolution. The Client Service Center Appl. provides ratings, articles, peer reviews, profiles, blogs and customized website dev. It provides data services to other Lexis-Nexis websites like Confidential and confidential. Provided business community enhancement requests to various components within the Appl.. Designed and build Oracle backend component for external and internal API calls that produced complex XML/XSD outputs using Erwin r7 data modeling tool. Documented all Oracle databases via Erwin r7 for off-shore outsourcing partners. Conducted analysis for multi-lingual database architecture. Performed analysis to validate the business requirement to make this company a truly multi-lingual company. It required me creating a stand-alone database that is multi-lingual compliant AL32UTF8 . It had two different types of data type columns, single byte varchar, clob and double byte nvarchar, nclob so I could test how each of these data types behaved in a universal language set database when data was ETL'd from a non-universal language set database. Created a custom language translation process Oracle function that sent HTTP requests to Google's language translation API. This process took English lawyer and law firm profile data from a production database, sent Oracle-based translation requests to Google to convert the data into foreign languages for both the single byte French, Spanish and double byte Chinese, Korean columns and then loaded it into the AL31UTF8 database table structures. Performed data type comparisons between the English database and the new database columns to determine if any character translation errors had occurred.

Confidential

Lead team to maintain and develop upgrades to the Oracle 10g back-end of a Java application that provides the pharmaceutical industry with a user-friendly mechanism for calculating prices and managing claims for their products with government Medicaid and Medicare agencies. Maintained and developed Oracle PL/SQL. Used Oracle DBA skills to create databases. Tuned Oracle backend processes. Applied tools, techniques, and methodologies appropriately to increase project efficiency and effectiveness. Led a segment of a large project to a successful outcome. Facilitated workshops and interviews with clients. Identified and escalated issues to appropriate authorities. Gained understanding of services and relevant industry processes. Developed a strong working relationship with Director-level client staff. Participated in client meetings and presentations. Created portable flash memory PB v10 database tool that imports, exports, updates and reports on Oracle data on client servers for data migration purposes.

Confidential

Responsible for collecting, housing and analyzing world wide physician survey information for Merck Co. located in their world headquarters in Whitehouse Station, New Jersey. Physicians nominate key opinion leaders within their therapeutic areas of expertise. This data warehouse and the related object-oriented applications interact with Merck subsidiaries and the web-based survey management system on a daily basis. They ensure that accurate reporting and analysis capabilities are provided to the worldwide marketing organizations. The data warehouse contains information for over 40 countries having many different languages. I have also built an Oracle 9i data warehouse and Powerbuilder v10 data maintenance application for Merck's marketing organization that provides a mechanism for executing various marketing tools like their Buying Process.

Confidential

Senior Powerbuilder Developer v8 using Oracle v8i. Responsible for designing, building and deploying: Travel and Expense Application, Procurement Credit Card Application, Bank Interfaces and Human Resources Expense Approver Hierarchy Application.

Confidential

Project leader for back-end support of a Lawyers and Law Firms Search Engine Web application. Maintained and enhanced Oracle 8i Intermedia search engines that supported Web app. Created Web user statistics repository in Oracle 8i and Powerbuilder v8.0 reports. Created Powerbuilder v8.0 app to create and maintain XML and Oracle 8i Web search engine database. Oracle v8i - 1.6, Powerbuilder v8.0

Confidential

For a major food manufacturer -Supply Chain Management, Transportation Decision Support, Sales Objectives, Powerbuilder Project leader and Oracle DBA for GUI Rapid Application Development projects. Created and maintained the test, staging and production Oracle v7.23 instances and environments for the following projects: 1 PowerBuilder 6.5 Windows NT application development environment for multi-developer /user change management/version control. 2 Designed and developed Oracle / PowerBuilder 6.5 applications that create, maintain and analyze company owned and copacker distribution center and manufacturing facility Inventory Replenishment shipments, Production Schedules and Transportation data. Data is synchronized with a SAP R3 application where warehouse shipment maintenance and analysis are done at the local and headquarters levels. 3 Created Oracle / PB 6.5 application to maintain transportation attributes. 4 Created Business Objects 4.0 Universe, Class and Objects in Oracle database to analyze transportation data. 5 Created Oracle / PB6.5 app to track all project enhancements and bugs. 6 Create DB2 / PB 6.5 app to maintain field sales representative's Sales/Marketing baseline and final objectives. 7 Designed and maintained all Oracle databases using ERWin/ERX modeling tool. 8 Leader of small team of experts, using Rapid Application Development RAD , Object Oriented application development methodologies, PowerSoft Foundation Class Libraries, ERWIN modeling tools and Oracle stored procedures, functions, triggers, SQL Plus scripts and Database Administration skills completed all projects on time and under budget. Trained employees in Oracle / PB 6.5 / Client-Server Technology and PowerSoft Foundation Class Library implementations PFC . And much more...Oracle 7.3, RS6000/UNIX, Bus Objects 4.0, PB/PFC 6.5, ERWIN/ERX 2.6.1, PL/SQL

Confidential

Project leader for Powerbuilder / Oracle Sales Force automation. Designed objects to search, find and analyze drug sample drop forms that are in error in order to conform to FDA audit requirements. Created FDA audit reports to track drug sample inventory and distribution discrepancies. Oracle v7.23, Powerbuilder v6.5.1

Confidential

Web Access Assistant WAA Data Warehousing Web Tool. Oracle DBA for development team that built the Web Access Assistant tool which allows companies to easily access Oracle and other RDBMS data and provide to the end users a Web-based reporting and data warehousing and maintenance tool. Created instances for testing, staging and production for the Web-based Application Demonstration environment. Created and maintained all system support level functions like backups, recoveries, space management and tuning parameters. Created all tables, indexes, PL/SQL, Triggers, Views and Sql Plus scripts. Continue to give off-site support. Oracle 8i, Windows NT, Oracle DBA GUI Tools

Confidential

For a major pharmaceutical corporation - Sales Force Automation. Performed all Oracle DBA and Project Leader functions for GUI development for an Oracle / PowerBuilder 4.0 Windows NT application development environment for multi-developer change management control. Designed and developed an Oracle / PowerBuilder 4.0 laptop application that maintains Agriculture and Veterinary Industry data gathered by 150 field sales reps. Using Sales Vision Class Libraries and Base Class Framework Libraries and TDS Communications technology developed entire user interface and all user objects that maintain Calls, Contacts, Orders and Marketing data. Data is synchronized with an Oracle v6 Repository where Global Sales Organization Marketing Analysis is done and sharing of data is provided. Using Rapid Application Development RAD methodology, completed project in less than 8 months. Trained all project employees in PB 4.0/Client-Server Technology. Environment: Oracle 6 , PowerBuilder 4.0

Confidential

Data Warehousing/Decision Support. Designed and developed a PowerBuilder application that maintains product structure hierarchical relationships Parent/Child used in marketing and sales analysis of prescriber/payer prescription sales data for field sales forces. Users can group products into physical or logical groupings cross-referenced to vendor product numbers and sales data with timestamp sensitivity and audit capabilities that allow for historical analysis. Created and maintained all Oracle table and index structures as well as Stored Procedures and Triggers and Functions. Provided PowerBuilder and Oracle expertise to other internal departments. Helped tune PB4.0 applications and Oracle extract programs that process very large amounts of data. Performed Evaluation and implementation of Business Objects as a front end user tool for accessing data in a very large 1 Terabyte Oracle decision support data warehouse database. Created prototype database, all classes and objects, joins and canned queries for on-the-road presentations. Oracle data is accessed through Hewlett Packers' Intelligent Warehouse metadata or virtual tables that are mapped directly to Oracle tables. Created PowerBuilder front-end access tool as user interface to Business Objects canned queries. Gave users the ability to store and manipulate B/O queries outside of B/O and to send the output to external software packages for further manipulation. Environment: Oracle 7.0.18, UNIX, Business Objects 3.0, PowerBuilder 4.0, HP/IW

Confidential

Data Warehousing Technical team leader for team of eight mainframe, UNIX, Oracle and PowerBuilder rapid applications development specialists responsible for designing, building and maintaining an In-Market Repository, or, Data Warehouse for profit and loss analysis, field sales force automation and market share enhancement decision support capabilities that spanned three major corporate sub-divisions and business entities. Developed project plans for all future releases. Tracked progress against plans. Tracked work effort and cost of project resources. Managed resource work assignments. Managed resource development and performance assessment. Developed production and testing capacity plans. Developed system test plans for future releases. Conduct formal walkthroughs and system tests. Report technical development status weekly to functional and technical managers. Review and present system architecture designs for approvals. Conduct formal production turnover procedure. Coordinated efforts to move application development group off-sight to vendor location. Developed PowerBuilder 30a Change Management/Trouble Ticket reporting and tracking application. Environment: Oracle 7.0.16, SCO UNIX, PowerBuilder 3.0a, XCOM LU6.2

Confidential

Decision Support System. Rapid application development of decision support system for profit and loss analysis of contracted sales data, pricing, rebates, claims, returns and cost of goods data. Created all process and data models using ERWin/ERX and designed and implemented Oracle database and all on-line PB3 maintenance screens. Users could extract data into their Excel/TM1 spread sheets for dimension and aggregation analysis and reporting. Environment: Oracle 7.0.16, PowerBuilder 3.0a, UNIX, Novell 3.12

6/1992 - 4/1994 J J Hospital Services, Piscataway, NJ

Data Modeling and GUI Application Development Designed logical and physical models for conversion from Advanced Revelation database to a WATCOM/PowerBuilder client/server database design for the Integrated Field Sales Force IFIS project for the laptop presentation application. Environment: WATCOM, PB 3., ERWin/ERXDesigned, developed and implemented POWERBUILDER application to interface with IFIS to maintain Extract/Export parameters for the companies and the sales reps to control the batch extracting processes, govern the volume of data and the data selection criteria for the extracts that are downloaded to the LANS and subsequently to the laptops. Created logical/physical models and performed all DBA functions. Environment: Powerbuilder v3.0, ORACLE V6.5.37, Novell 3.12

Confidential

For a custom built Contracts and Rebates CARS application called Interact: Created Application Tuning and Production Turn-over Reviews. Developed Oracle V6.5 Batch Tuning Guidelines for MVS/COBOLII modules. Developed ORACLE SQL Forms V2.3 Tuning Guidelines for MVS. Created and administered internal corporate application tuning classes for ORACLE V6.5 to teach developers proper query design, index usage and TKPROF and EXPLAIN PLAN analysis and tuning processes. Developed Application Review Process ARP for internal DA/DBA reviews of all applications and modules bound for production environment. Field Sales Force Automation: Designed, developed and implemented ORACLE/MVS application - Integrated Field Information System IFIS . It dynamically creates, via PowerBuilder interface parameters and dynamic SQL, ORACLE extracts and exports from one of world's largest ORACLE databases. Efficiently distributes the data, via XCOM LU6.2, to company LANs which then distributes either the Full Refresh or Net Change data to both the field sales reps laptops via dial up or the local ORACLE databases. Provides a common view of the customer sales, products, prices, contracts, rebates across all companies and divisions to all field reps and synchronizes data on all platforms. Provides disaster recovery capabilities should laptops or databases be corrupted. Environment: Oracle V6.5.37, PB 3.0, COBII, MVS/TSO/JCL, XCOM LU6.2

Confidential

Integrated System Testing and Quality Assurance Designed and implemented an Integrated System testing environment and Quality Assurance process for MVS CICS/Oracle and IMS on-line and batch applications. It provided production support capabilities, production simulation, base-line/regression testing and user acceptance testing and training for all areas of application development spanning three data centers in different areas of the country. Included data modeling and database design and implementation. Environment: CICS, Oracle, MVS, SQL Forms 2.3, UNIX, Pyramid 7000Sales Forecasting and Production Planning. Designed a sales forecasting and production planning system to help sales channels, production, distribution and purchasing planners and marketing analysts shorten the order-to-delivery cycle and provide more dependable material replenishment controls for each strategic business unit. Included Oracle data modeling and database design and implementation. Environment: CICS, Oracle, MVS, IBM30xx, Amdahl. Inventory Control and Accounting. Created Daily and Annual Physical Inventory Control systems to keep accurate balances on a day-to-day basis and at fiscal year end. Used by all warehouses to report inventory to internal and external corporate auditors. Included reconciliation processes and audits. Included Oracle data modeling and database design and implementation. Environment: CICS, Oracle, MVS, IBM30xx, Amdahl

Confidential

Corporate System Interfaces Provided operative interfaces between application software, operating systems, hardware and communications by redesigning efficiently integrated system architecture between the internal systems and external corporate systems. Participated on a quality assurance team formed between corporate systems to address and rectify this issue. Environment: Too many to mention Project Management and Production Library Control. Designed and implemented a system for managing application development, project life cycles, integrated system testing and updates to all libraries and modules across multiple environments. It included change requests, trouble tickets, project management tracking and reporting and job and program documentation maintenance. It provided abending and restarting instructions to data center support groups. Environment: CICS, Oracle, MVS, SQL Forms 2.3, UNIX, Pyramid 7000Database Administration. Administered the Finished Goods Management System FGMS and Material Replenishment databases for all application support groups in the Distribution Resource Planning project that managed all customer orders, shipments and production cycles. Created all physical models, tablespaces, tables and indexes. Administered tuning, performance and space management techniques. Developed disaster recovery process, automated monitoring and reporting system to support DBA analysis and maintenance. Environment: CICS, Oracle, MVS, IBM30xx, Amdahl

Confidential

Application Programming. Designed and implemented programs to determine the fill ratio at customer primary stocking location and to move available stock from other overstocked locations into those locations requiring replenishment in order to maintain a low volume of customer backorders. Maintained Billing and Audit Exception Reporting systems written in assembler. Prepared physical inventory operations procedures. Maintained product pricing. Wrote CICS customer maintenance program. Environment: CICS, COBOL, MVS, IBM30xx, TSO/JCL, VSAM