CRMpeople.com

Presents

Resume 775.

Knowledge Summary

This Consultant has thirteen years of technical and functional professional experience in information technology, management consulting and engineering. He is cross-trained and certified in multiple CRM and ERP product suites. He has played pivotal roles as a technical lead/architect and an expert resource on numerous enterprise projects. He has a broad multidisciplinary background with thorough exposure to several industries and technologies. His recent work experience includes implementing Siebel, Oracle and Clarify projects for enterprise clients. He also has hands-on expertise and proficiency with Unix, Oracle and SQL Server database systems and tools, legacy interfaces, enterprise data migrations, and data quality management. Additionally, he has six years of experience in mathematical modeling, operations research techniques, numerically intensive research computing and teaching in an academic environment including several publications and conference papers/presentations.

Education & Training

• TDWI Data Warehousing Fundamentals: A Roadmap to Success, Parts I & II
• TDWI Data Cleansing: Delivering High-Quality Warehouse Data
• TDWI Data Modeling: Data Warehousing Design and Analysis Techniques, Part I and II
• TDWI Data Acquisition: Techniques for Extracting, Transforming, and Loading Data

• Masters in Implementing Oracle Applications Rel. 11. Comprehensive Instructor Led Training from Oracle in 14 modules in manufacturing and financials, examination and masters certification.
• Clarify Certified Consultant. Partner intensive training, examination and certification.
• Other Software Tools and Language Skills Proficiency Summary: Visual Basic, Application DBA for Oracle with SQL & PL/SQL, SQL*Loader and data modeling tools including ERWin; SQL Server with Transact SQL & BulkCopy/BCP, Unix Shells and utilities (Awk, Sed, Perl) on multiple hardware platforms including HP, Sun, Cray/Silicon Graphics, IBM. Proficient wih DataJunction, I.D. Centric, DataFlux, Crystal Reports, FileNet Imaging and Visual WorkFlow, JetForm, F3Forms, Attachmate, International Mathematical & Statistical Libraries (IMSL), Aspen Plus, Fluent/Fidap, Tecplot, SAS/Graph and Statistical Analysis. Also have working understanding of data quality management tools and technologies such as Axiom, First Logic (I.D. Centric), DataFlux.
• M.S./PhD. Candidate Chemical Engineering, University of Missouri, Rolla specializing in Computational Fluid Dynamics and high-performance computing.
• B.S. Chemical Engineering with minor: Operations Research, University of California, Berkeley

Professional Experience

• Schering Plough Animal Health Corporation - Siebel 7.5.100 Enterprise Server installation and database upgrade (SQL Server 7 to 2000) project involving redesign and testing of all data interfaces and new Visual Basic procedures. Liaison with management and implementing docking/visibility rule changes in consultation with Siebel expert services.
• Organon Inc., USA/Project (Siebel 7.5) - Technical specialist role implemented several custom docking and visibility changes in consultation with Siebel expert services.Implemented a process for generating custom identifiers for remote clients using Workflow and Business Services for multiple instances.
• Johnson & Johnson Vision Care, Inc./Project (Siebel 7.5)- Technical architect role for a phased Siebel upgrade project involving a dual environment approach. Assisted

• Boehringer Ingelheim Pharmaceuticals, Inc./Roadmap (Siebel 7.5) - Data specialist role on a CRM Roadmap project.

2002. Principal Consultant. Digital Consulting & Software Services, St. Louis, MO

• Applied BioSystems, Inc. - High profile enterprise project developing a custom bio-informatics application with complete ERP/MRP functionality for the company’s DNA sequencing and genomics research products using Oracle PL/SQL, Unix, ErWin 4, Mercator and SAP.

• Schlumberger – GeoQuest - Technical architect for team. Implemented Siebel 2000 Call Center following Siebel 2000 Sales including Assignment Manager, Workflow Manager, eMail Response and eService. Responsibility for design/deployment of all application and database servers, Product hierarchy and configuration, Workflow, State Model, setup of employees and users, some configuration and Actuate Reports. Designed and deployed Siebel Replication with a three-tier regional server hierarchy with servers and users spanning several countries. Legacy data was migrated from a Scopus/Swift application and an existing Siebel application. using DataJunction and Siebel EIM. Significant data scrubbing and transformation was performed using ETL tools prior to EIM loads. Performed all Oracle Application DBA functions to manage multiple database instances.
• H & R Block -Technical Architect for an extended Clarify ClearSales and Call Center implementation for financial services automation. Designed and implemented a opportunity import process including development of a complex high throughput batch data interface between an enterprise distributed data warehouse and Clarify. Provided expert technical support and all-round troubleshooting for production Clarify Applications and reviewed critical enhancements, application maintenance and lead special database projects. Platform was HP/UX and Oracle.
• SecurityLink from Ameritech - Conversion of a Data General based custom legacy application with Accounts Receivable, Payments Processing, Recurring Billing and Contact Management system to a custom Oracle Application on IBM RS/6000 platform. Technical lead responsible for all conversion processes and deliverables including business process and data mapping, legacy data extraction, migration, manipulation, loading and testing, balancing of accounts and reporting. The platform was IBM RS/6000 (AIX) and Oracle. Member of a conversion team for a customized billing system implementation responsible for business re-engineering, data extraction, migration, manipulation, loading and testing for three independent companies acquired by the client.
• GE Capital - Developed a business model and process flow and a logical data model for a new web-based home mortgage loan origination system for brokers and lenders.
• Meridian - Developed strategy, data mapping, programming scripts, business rules and implementation for the extraction, loading and conversion of multiple databases

• State of Illinois (Teachers Retirement System) - Systems Review of a Year 2000 Planning and Client/Server Migration Project.

• Missouri State Government - Department of Revenue - Designed and developed a custom multi-user client/server customer service application using Visual Basic and SQL Server in a Windows NT environment. Developed real-time interfaces with a legacy mainframe based bookkeeping system using HLLAPI and tools from Attachmate. Crystal Reports, JetForm and F3 Forms were used for EDI forms printing and workflow. Document imaging, storage and retrieval were implemented using FileNet.

• Engineering Design & Consulting Firm. Responsible for technical proposal computerized design, development and simulation of heat recovery systems for combined cycle power generation and cogeneration projects. In-house applications were developed using Fortran, Visual Basic, and Excel in a ISO 9001 environment.

• Research Associate - engaged in projects involving numerically intensive computing on various hardware platforms: HP 9000, RS/6000 and Cray EL 92 with post-processing of data via UNIX utilities and automatic plotting/visualization using SAS/Graph and Tecplot graphic engines driven by shell scripts. Several published papers and conference presentations.
• Lecturer, Calculus to sophomore students in Mathematics and Statistics. Provided hands-on training to students working on UNIX and IBM mainframe environments.
• Trainer - Taught students to perform steady-state process simulation using Aspen Plus package. Designed and directed several complex computational research team projects, managing and seamlessly utilizing resources on heterogeneous systems, file transfers and conversions.

• Designed logic for automation and computer controlled material handling system for a continuous manufacturing process equipment manufacturer in Asia.
• Project management for a multinational petrochemical expansion project in Asia.
• Prepared feasibility report for a proposed grass-root petrochemical project in Asia, including marketing study and project finance proposals.
• Conducted an energy audit for a petrochemical complex and recommended improvements with substantial savings potential in utility costs.
• Provided technical expertise to facilitate investigation of plant damage and insurance investigation following an industrial accident.
• Negotiated multi-million dollar contract to design, manufacture and supply a process plant to a Government client in Asia after competitive bidding and formal presentations of bid.

Personal