SUMMARY:

I am a result focused IT Professional with in - depth Database Management, Data Architecture and application integration/support experience. I have strong technical skills, problem solving skills and the ability to conceptualize other ideas and provide a vision; that enables businesses to derive value and improve decision-making from their data. I enjoy taking ideas and developing them into reality.

EXPERTISE AREA:

• Data Architecture and Modeling
• Data Warehousing
• Integration Salesforce/Oracle CRM
• OBIEE Analysis/Dashboard Creation
• OBIEE Repository Design
• OBIEE Systems Management
• Oracle E-Business Suite/Apps DBA
• Database Administration
• Unix/Linux Administration
• VMWare Administration
• EMC Disk Array Administration
• Coordinate 3rd party Hosting
• Coordinate 3rd Party DBA’s
• Coordinate with 3rd Party ERP Teams
• System Infrastructure Planning
• Software evaluation
• Sarbanes-Oxley remediation
• Project Management
• Supervisory, Technical and Team Leads
• Crosby Quality Council - member

PROFESSIONAL EXPERIENCE:

Confidential, Hamburg, NY

Sr. Oracle/SQL DBA, DW/BI Architect

Responsibilities:

• Responsible for Data Architecture and script based ETL Development to Oracle Data Warehouse(DW), for multiple Subject Areas within OBIEE and data integration to Salesforce.
• Designed and developed Jitterbit on-prem to Cloud Data Integration between existing the DWH and Salesforce. Participated in POC and selection of Data Integration tools replacement Strategy. Currently leading an implementation of Dell Boomi Cloud iPASS ETL integration.
• Responsible for Oracle OBIEE Administration, design and development utilizing Oracle BI Answers Ad-hoc query and reporting (analysis and agents), Oracle BI Interactive Dashboards, Oracle BI Administration including Repository, catalog and job scheduling.
• Project Lead for Migration Oracle Global Transportation Management and OBIEE Systems to Off-premise Data Center; including integration between On-Premise AS400 ERP systems and Salesforce.com
• Responsible for planning and execution of all technical tasks for the maintenance of OBIEE, Oracle Global Transportation Management, Multiple ERP systems and Great Plains Financial systems including Oracle and SQLServer database administration

Confidential, Williamsville, NY

Lead Data Architect

Responsibilities:

• Designed and captured data into the Enterprise Data Warehouse from Oracle’s CRM Integration and created Sales Trend Analysis for North American Operations.
• Provided OBIEE Data Architectural support during initial stage of implementation.
• Provided guidance and support for Vendor Analysis system for North America.
• Participated in the integration of a Remote Hyperion Financial Management (Paris, France) to a localized Global Financial data warehouse.
• Participated in the development of an Arcplan Based Financial Global Dashboard Implementation for Global Web based reporting of financial data and KPI’s
• Participated in the development of a Global Integration of loading of Financial and KPI data for Integration and loading of the Hyperion Financial Management System
• Designed specifications and worked with the Informatica ETL group for the loading of the Data Warehouse environments.
• Responsible for planning and execution of technical tasks for the implementation and maintenance of an in-house Supply Chain Management Integration System including: Oracle database administration, cloning, data conversion cutovers, performance tuning, PL/SQL recommendations and reviews, backup and recovery management.

Confidential, Clarence, NY

Sr. Infrastructure Analyst

Responsibilities:

• Implemented of Oracle E-Business suite 11.5.8 at a remote Hosting Facility in New York City. The major modules implemented were Financials, Order Management, Procurement, Discrete Manufacturing, Intelligence(Discoverer), Human Resources. This implementation included 8 manufacturing facilities; one located in Tijuana Mexico, and received a special recognition by Oracle for the speed and impact on our Organization.
• Upgraded the Oracle environment to 11.5.10.1 (CU1), and eventually 11.5.10.2 (CU2). During the 11.5.0 CU1 upgrade the database was also upgraded from 8.1.7 to 9i 64 Bit, and converted the database to NLS language set of Western European. This was necessary to provide for a Mexican subsidiary which required the NLS/MLS addition of the Latin American language to the ERP application. New functionalities included Daily Business Intelligence, XML Publishing, and PO Workflow enhancements. The modules included were Financials including newly implemented Fixed Assets Modules, Order Management, Procurement, Discrete Manufacturing, Intelligence (Discoverer and DBI), and Human Resources. During the CU2 upgrade, the database component was upgraded to 10Gr2.
• Implemented the Oracle’s newly deployed Demantra forecasting system which includes Global Demand and Advanced Supply Chain Planning, and Order to Promise functionalities, integrated with the E-Business Suite
• Coordinated with and mentored Confidential ’s new 3rd party DBA support group, to migrate and manage day to day activities to free up time to work on more strategic projects
• Coordinated and worked with 3rd party offshore group from India to integrate newly acquired plants into Oracle E-Business Suite

Confidential, Buffalo, NY

Oracle Database Administrator

Responsibilities:

• Performed the duties of a Senior Oracle Database Administrator in the support of Client Server and Mainframe based Application systems.
• Duties included evaluation, installation, upgrade, maintenance, and backup/recovery of 105 operating, and data environments, including applications in: Intranet Application Development, Supply Chain (I2), ERP (QAD), Payroll (Cyborg), Document Management (Onbase), Data warehousing, Financial Analysis, (Oracle Financial Analyzer)

Confidential, Buffalo, NY

Oracle Database Administrator and Business Objects Implementer

Responsibilities:

• Evaluated, recommended, and implemented new E-Commerce Applications Data model.
• Installed Business Objects software and repository, designed the Business Objects End User Layer and developed 41 Business Objects reports with no training or support.

Confidential, Buffalo, NY

Oracle Database Administrator

Responsibilities:

• Duties included evaluation, installation, upgrade, maintenance, and backup/recovery of 105 operating, and data environments, including applications in: Intranet Application Development, Supply Chain (I2), ERP (QAD), Payroll (Cyborg), Document Management (Onbase), SPC (PMIS). Data warehousing, Financial Analysis, (Oracle Financial Analyzer) and legacy Mainframe DB2.
• Contributed to the outsourcing of Confidential Client Server based application support activities to CTG.
• Instituted the usage of Oracle Enterprise Management Software to monitor and resolve issues in 70 concurrently running Oracle RDBMS environments. I also maintained 3 main and 32 subordinate OLAP environments in the Financial Analysis Area, and was primary on call for the mainframe DB2 RDBMS.
• Recovered the Clients new Oracle based SAP ERP system during a major system outage with no previous SAP database administration training or experience.
• Participated in numerous Data Warehousing projects in the Financial Analysis area, including, P&L reporting, Customer Ordering Pattern, Customer Order Compliance and the presentation of Sales Analysis and Food Spoilage data to the Clients Intranet.
• Created and presented a Sales and Recruiting seminar on Oracle Technology and Applications for CTG to aide in the matching of resources to Customer requirements for the corporate sales force.

Confidential, Buffalo, NY

Oracle Database Administrator

Responsibilities:

• Performed systems administrative duties to support the CODA Financial system including: installation, upgrade, problem resolution between the customer and the software vendor.
• Participated in the implementation of the new CODA Financial application system.
• Designed and developed of a Visual Basic based Accounts Payable and Accounts Receivable reconciliation system.

Confidential, Lackawanna, NY

Oracle Database Administrator

Responsibilities:

• Performed the duties of a project consultant assistant for the implementation of a new MES including: the design and integration of a PROMIS MES system with existing legacy mainframe, process control, and new plant floor scheduling systems in a 24/7 manufacturing environment.
• Participated in project implementation team that oversaw the implementation of the new MES system.
• Designed a character based, RF touch screen terminal system utilizing Oracle* Forms 4.0, an in-process material cross application system, a Metallurgical testing facility and sample tracking system. Designed and developed an Order Entry/Bill of material explosion system which fed the
• MES part specification system, an Order Status/Plant floor material adjustment system which fed the MES system and Shipping interface system between the legacy shipping system and the PROMIS MES system.
• Assisted management in the new account startup, transfer of ownership of production systems and installing methodology for development. Participated in planning and the implementation of a data center consolidation and migration project. Other responsibilities included: function point counting and process modeling.

Confidential, Lockport, NY

Advanced Systems Engineer

Responsibilities:

• Participated in a Philip Crosby training and was a member of a Quality Council that promoted building of an ideal development and customer support environment that utilized, mind-mapping, affinity diagramming and other newer management techniques.
• Provided new employee interviews, career development, training plans, compensation recommendations and performance evaluations.

Confidential, Dayton, OH

Systems Engineer

Responsibilities:

• As a systems engineer duties included remote technical support with production support team, technical specification reviews, project estimation, module construction, module testing and user acceptance testing.
• Applications included: Dealer Consignment and Sales Reporting for Retail and Fleet operations for all of North America.