Professional Summary

Vincent has over 20 years of systems integration and development, including 13 years true consulting experience. Vincent has experience in all phases of systems design, development and integration, and specializes in Business Intelligence and Data Warehousing Architecture. Vincent has provided assistance and consulting services through excellent client relations, effectively using the latest technologies, applications and methodologies. Vincent thrives on challenges, takes pride in his analytical and problem solving skills, and has lead technical teams on many of his projects.

Professional Expertise

specializes in Data Warehousing Architecture: modeling, design, build and ETL sourced from Oracle E-Business Suite and PeopleSoft Financials/HRMS. Vincent has experience in system integration services through business analysis, requirements gathering, process workflow, and business process re engineering. Vincent has experience in all phases of Business Intelligence, including design and development of web based KPI/Dashboard and analytical (OLAP) reports. Vincent has experience as an Oracle E-Business Suite technical specialist in customizations, interfaces, and system API reporting. Vincent has experience as an Oracle development DBA with expertise in database installation, database design - configuration and tuning, and SQL performance tuning. Vincent has moderate contract proposal writing skills.

Application

Enterprise Applications: Oracle Applications/Financials/E-Business Suite, PeopleSoft Financial/HRMS; Databases: Microsoft SQL Server, Oracle 11g; Enterprise Management: Oracle Enterprise Manager; Languages: Oracle SQL, Oracle SQLPlus, Oracle PL/SQL, PeopleSoft SQR, various UNIX shell programming languages, the VI editor; Operating Systems: MS Windows Server, UNIX (various), LINUX; Development tools: Oracle Forms, Oracle Reports, Oracle Application Server, and Quest TOAD; BI Tools: Oracle Discoverer, Oracle BI/XML Publisher, IBM Cognos, and SAP Business Objects; ETL Tools: Oracle Warehouse Builder and Informatica; SOA Tools: Oracle SOA Suite, Oracle BPEL Manager; Modeling/Design Tools: Oracle Designer, MS Visio, ERWin, and SilverRun; Version Control/Development Management: Serena PVCS, Tortoise SVN, Numara Track It!, CVS, and Quest STAT.

Education

B.S. Computer Information Processing, Minor Business Administration

Professional Experience

Company: Confidential,, Covington, LA.
Employed November 2010 to September 2011
Position: Senior Engineer, Business Software Systems

Major Responsibilities: Oracle E-Business Suite 11i BI/Reporting and Technical Lead, supporting GL, AR, AP, FA, INV modules. Company-wide Oracle E-Business Suite administration, technical support and end user financial report development, including XML/BI Publisher, FSG development of GL account hierarchy structures and company trial balance and financial statement of operations. Administration and end user support of Discoverer financial reporting repositories and installation and administration of Noetix views. Custom analytical report development and support of LHS BSCS (Business Support & Control System) billing and customer care system for telecommunication operations.

Company: Confidential,Baton Rouge, LA.
Employed February 2010 to October 2010.
Position: Oracle Applications Technical Consultant

Client: Confidential,New Orleans, LA.
Project: BDS data legacy conversion, August 2010 - October 2010. Responsibility: Conversion of Tulane\'s payroll and budget system\'s MicroFocus COBOL based data conversion process to a total Oracle based (Windows cilent/UNIX DB) solution, eliminating hundreds of mainframe based COBOL programs. Tools/Products: Oracle 11g DBMS, Oracle SQL*Loader, SQL*Plus, PL/SQL, SQL Developer, and Windows batch scripting.

Client: Confidential,Baton Rouge, LA.
Project: Oracle Applications 11i Eastern Hemisphere Integration, February 2010 - July 2010. Responsibility: Oracle Apps 11i custom reports development for Payables and Receivables modules, including usage of multiple currencies using Oracle Reports, and Oracle XML Publisher (BI Publisher) RTF and XML data templates. Exposure to process development of interface from custom legacy systems using Oracle SOA, JDeveloper, BPEL Process Manager. Full life cycle development of GL JE Oracle 11g data warehouse prototype using Oracle Warehouse Builder 11g Enterprise Edition.

Company: Science Applications International Corporation (SAIC), San Diego, CA.
Employed October 2007 to January 2010.
Position: Chief Software Systems Engineer - Data Warehousing Architect.

Project: SAIC SmartGrid Distribution Monitoring System (DMS), August 2009 - October 2009. Role: Development DBA. Responsibility: Installation of Windows based Oracle 10g and 11g enterprise database instances, maintenance, support, and monitoring of all database performance and data file capacity, database tuning, table tuning and indexing, and SQL tuning, and development of Windows based SQLPlus DMS system database and schema installation DDL scripts for customer sites. Tools/Products: Oracle Database 10g/11g, Oracle 10g/11g Enterprise Manager, Oracle SQLPlus, Windows Server 2003.

Client: Confidential,New Orleans, LA.
Project: PeopleSoft HR Ethnic Group Changes, July 2009 - August 2009. Role: Lead HR Analyst. Responsibility: Analyze and gather system requirements to update ethnic groups in PS HR 8.3 and eRecruit (8.8) to be in compliance with current EEOC Guidelines, standardize the ethnic groups across both environments. Produced work request estimates and analysis/requirement documents. Tools/Products: PeopleSoft HR 8.3 and 8.8, PeopleTools Application Designer.

Client: Confidential,New Orleans, LA.
Project: Regulatory Reporting Initiative - Phase 1, October 2008 - July 2009. Role: Technical Lead. Responsibility: Report requirements gathering, and Data Warehouse modeling, design, build and ETL of Entergy’s Regulatory Reporting System, including stored process design and external system interfaces. Tools/Products: Oracle Database, PeopleSoft Financials, PeopleTools Application Designer, Oracle PL/SQL.

Client: Confidential,New Orleans, LA.
Project: Entergy/EquaGen HR System Conversion, April 2008 - October 2008. Role: PeopleSoft SQR Programmer. Responsibility: Conversion of Entergy Corporate Employee HR System processes, including external HR vendor interfaces, for Entergy’s EquaGen company spinoff. Tools/Products: Oracle Database, PeopleSoft Apps HRMS, PeopleTools Application Designer, PeopleSoft SQR, Quest STAT.

Client: Confidential,Irvine, CA.
Project: Clinical and Development Data Warehouse, Research and Development Portal. October 2007 - April 2008. Role: ETL Expert and Data Warehouse Architect. Responsibility: gathering of technical architecture, infrastructure and design requirements, and integration strategy, and DW design, ETL, and implementation plan for Pharmaceuticals Clinical and Development Data Warehouse and Research and Development Portal for international pharmaceuticals company. Tools/Products: Oracle 11g Database, DW and ETL. Tools TBD.

Client: Confidential,New Orleans, LA.
Project: Supply Chain Scorecard/Data Warehouse. November 2007 - January 2008. Role: ETL/Data Warehouse Architect. Responsibility: ETL and dimensional star schema design of scorecard based data warehousing systems used for IBM Cognos OLAP based reporting, sourced from various spreadsheets and in-house Oracle, SQL Server, and Access database systems. Tools/Products: Oracle 10g Database, Microsoft SQL Server, Informatica 8.

Client: Confidential,New Orleans, LA.
Project: Customer Service Scorecard/Data Warehouse. October 2007 - December 2007. Role: ETL/Data Warehouse Architect. Responsibility: ETL and dimensional star schema design of scorecard based data warehousing systems used for IBM Cognos OLAP based reporting , sourced from various spreadsheets and in-house Oracle, SQL Server, and Access database systems. Tools/Products: Oracle 10g Database, Microsoft SQL Server, Informatica 8.

Company: Confidential,New Orleans, LA.
Employed February 2007 to October 2007.
Position: ETL/Data Warehousing Modeler.

Client: Confidential,New Orleans, LA.
Project: Navy Standard Integrated Personnel System (NSIPS)/CIMS Analytics Data Warehouse. Role: ETL/Data Warehouse Architect. Responsibility: Maintenance, ETL and Design of full lifecycle of analytical personnel data warehousing system, sourced from PeopleSoft HR using Business Objects OLAP based reports. Tools/Products: Oracle 10g Database, Oracle Warehouse Builder 10gR2, Oracle Designer 10g, Oracle Enterprise Manager and PL/SQL.

Company: Confidential,Littleton, CO.
Employed September 2003 to February 2007.
Position: Oracle Applications Specialist - Data Warehousing.

Client: Confidential,Germantown, MD.
Project: DOE I-MANAGE Data Warehouse, September 2003 - February 2007. Role: Data Warehouse Architect. Responsibility: Star schema design, ETL and full lifecycle development and maintenance of 15 fact/50 dimension integrated data warehouse and OLAP based reporting system, implemented within an Oracle Application Server 10g Portal environment for U.S. Department of Energy Office of Management, Budget, and Evaluation (OMBE). Sources include Oracle Applications 11i, PB Views, and various custom systems. Tools/Products: Oracle Applications 11i, Oracle 9i/10g, Oracle Warehouse Builder 9i/10gR2, OMB*Plus, Oracle Discoverer 9i/10g, Oracle Application Server 10g, Oracle Portal 10g, Oracle Designer 9i/10g, Oracle Enterprise Manager and PL/SQL.

Company: Confidential,New Orleans, LA.
Employed April 2002 to September 2003.
Position: Senior Business Intelligence Consultant.

Client: Confidential,Lockport, LA.
Project: NBI/EAC Oracle Portal Implementation, December 2002 - September 2003. Responsibility: Development and design of custom database to be accessed though integrated Oracle Portal environment, centralizing the collection and distribution of critical actual project information from Oracle Projects and estimated project information from various data sources including MS Access Databases and Primavera Project Accounting software. Tools/Products: MS Access, Oracle Applications 11i, Oracle 9i, Oracle Discoverer 9i, Oracle 9iAS,Oracle Portal, Oracle Forms Builder 9i, and PL/SQL.

Client: Confidential,Orleans Parish Public Schools, New Orleans, LA.
Project: Oracle Applications 11i - OPSB Custom Implementation, October 2002 - December 2002. Responsibility: Conversion of custom forms, modules and objects from Oracle Applications 10.7SC to Oracle Applications 11i Tools/Products: Oracle Forms Builder 9i, Oracle 9i, and PL/SQL.

Client: Confidential,Marksville, LA.
Project: HR/Payroll Data Mart, September 2002. Responsibility: Converted and tested HR/Payroll Data Mart from test instance to production, including all data mart build and load scripts. Tools/Products: Oracle Discoverer 4i, Oracle 9i, Perl Language, and PL/SQL.

Client: Confidential,New Orleans, LA.
Project: LAHIDD Data Warehouse - Inpatient Encounter Data Mart, April 2002 - July 2002. Role: Data Warehousing Architect. Responsibility: Design and full lifecycle development of custom LAHIDD data warehouse. Tools/Products: Oracle Designer 6i, Oracle 9i, Oracle Warehouse Builder 9i, and PL/SQL.

Company: Segundo, L.L.C., Reston, VA.
Subcontracted February 2002 to April 2002.
Position: Independent Consultant.

Client: Confidential, Eagan, MN.
Project: Custom Oracle 11i Recievables Reporting/Implementation, February 2002 to April 2002. Role: Oracle Applications/Tech. Responsibility: Apps 11i Implementation custom reports development Receivables Module. Development included custom schema and reporting for Recievables Accounting Statements, Invoices and Dunning Letters with interfaces, custom print generation to Mainframe systems using UNIX Shell scripts, and Apps 11i object migration and concurrent manager setup. Tools/Products: Oracle 8i, Oracle Applications 11i AR/Sys Admin, Oracle Reports 6i, PL/SQL, and UNIX Shell.

Company: Oracle Corporation, Redwood Shores, CA.
Employed June 1996 to January 2002.
Position: Senior Principal Consultant.

Client: Confidential,Kansas City, MO.
Project: NCMS Apps 11 Implementation, June 2001 - December 2001. Role: Applications Technical Lead - Responsibility: Apps 11 Implementation w/ customizations and development of several interface modules including Receivables, Order Entry and Inventory. Development included order tracking and reporting, custom invoice generation, and Order Entry/Inventory interfaces to and from Oracle Apps 11 for U.S. Postal Service Order fulfillment system for consumer distribution of all U.S. Stamps. Tools/Products: Oracle Applications 11 - OE, INV, AR, and GL. Oracle8, PL/SQL, Oracle Forms, Oracle Reports, Discoverer R3.

Client: Confidential,Stockton, CA.
Project: Oracle Business Intelligence System (BIS) 11i Production
Implementation, May 2001. Responsibility: Implemented Oracle Business Intelligence System 11i with Oracle Applications 11i, and Oracle8i. Intelligence areas included Financial, Operations, Human Resources, Purchasing, and Process Manufacturing. Developers: 1. Tools/Products: Oracle Business Intelligence System 11i, Oracle PL/SQL, Oracle Alerts, Oracle Workflow, Oracle Reports, Discoverer R3i.

Client: Confidential,OH.
Project: IDM - Inventory Data Mart Implementation, April 2001. Role: Data Warehousing Consultant. Responsibility: Assessed performance and loading issues for Oracle Applications 11i, Oracle8i, OWB, and developed custom inventory data mart. Reviewed physical data mart design, ETL process, Discoverer reporting requirements, and Oracle Portal issues. Debugged PL/SQL load scripts, and produced assessment and recommendation documents. Tools/Products: PL/SQL, SQL*Plus.