Siebel Architect - contractor- Perform review and analysis of Siebel installation to insure compliance with contractual requirements- Install multiple Siebel development environments- Design interfaces between Siebel and third party systems- Train employees on system processes and methodologies- Install Oracle OBIEE

- Provide Architectural and business analysis support to insure OTB installation of Siebel.- Review and analysis of N. America and UK implementation designs for consistency and uniformity.- R&A of Customer Master and Siebel database interface designs for suitability and compatibility- Analyze customer facing business and design solutions for compatibility with new implementation.

- Design, develop and implement data integration solutions.- Perform data mapping and EIM migration solutions from legacy systems to Siebel tables.- Design and implement EIA solutions to receive data from external systems.- Run PL/SQL queries to troubleshoot precess methodologies.- Coordinate and discuss SME requirements and issues

New Siebel Implementation at Scottrade.- Perform business process review and analysis - Design, develop and implement real time EAI data transfer Solutions between Siebel CRM and UCM - Provide EAI support for Siebel UCM data integration - Design, create and test Workflows for data transfer and error handling capabilities- Design and create new Integration Components and mapping documents

Implementation of Siebel Clinical Trial Management System (CTMS) MI- Perform review and analysis of business processes- Support definition, documentation and prioritization of existing business requirements- Perform gap analysis and align business strategies with technology solutions- Conduct design sessions, review meetings, and oversee other efforts of integration team members- Analysis and design clinical payments integration with Oracle Finance - Ensure compliance with appropriate state and federal regulatory authorities

- Perform ETL of data from legacy systems to Siebel tables.- Perform EIM data migration for Development, Test and Production environments.- Support installation of Oracle OBIEE 10g test environment and configure to customer requirements.

- Provide ETL support for data integration- Perform data analysis and create mapping documents- Utilizing Informatica, perform ETL from legacy systems to Siebel- Perform EIM migration from legacy systems to Siebel- Provide data analysis and migration support to overseas subsidiaries

Resolve interface conflicts between Siebel and third party software i.e. Delphi, Mercury, Trillium, etc.- Review and analysis of automated batch processes used to initiate EIM jobs- Resolve linking problems with data files sent to Mercury processing system- Prepare and execute SQL queries against the Siebel database to extract data for reporting purposes- Utilizing Informatica and EIM, perform ETL from legacy systems to Siebel EIM tables- Responsible for design, development and configuration of OBIEE Dashboards, Repositories, and Answers- Perform EIM data mapping, conversion, and migration- Support upgrade utilizing batch Integration, Shell Scripts and Oracle PL/SQL- Perform database performance tuning and indexing- Perform developmental tasks utilizing Siebel Tools, Workflow, EAI/Assignment Manager- Develop and update design requirements documents for finance and insurance divisions- Design and develop user interface for new Insurance division- Design, configure and implement changes to Siebel GUI- Test and debug data transfers using Oracle SQL*Plus - Create Workflow design and Assignment Manager- Perform configuration modification and updates using Siebel Tools and Siebel eScript

Accenture Consulting , IL (as Siebel Corp. employee)- Performed project manager duties in association with upgrade of Siebel CRM software- Manage and support major upgrade from Siebel 98 to Siebel 2000 running on Oracle database- Perform business analysis of existing system and develop implementation methodology- Perform configuration modifications required to support business requirements- Develop and utilize kornshell scripting- Prepare data and configuration files for upgrade- Upgrade servers, developer workstation, and repository- Resolve duplicate EIM mappingsDura Pharm Pharmaceutical Company, CA - Siebel ePharma (as Siebel Corp. employee)- Review and analysis of configuration and EIM data migration requirements- Perform data migration of legacy data into Siebel ePharma database using EIM- Review and analysis of logs generated during migration (error logs etc.)- Verify and test new records in Siebel database using SQLInternational Business Machines (IBM), NC Siebel Sales (as Siebel Corp. employee)- Support major EAI data migration initiative at IBM Corporation as part of a corporate process reengineering- Coordinate efforts to generate huge data files from D&B database for input into Siebel EIM tables- Responsible for development/support of methodology required to feed D&B database into Siebel- Work closely with IBM dB administrator and Siebel consultants to resolve problem areas and anomalies- Transition EIM responsibilities to IBM corporate employees (knowledge transfer)