SUMMARY:

• Siebel Certified Core Consultant and Oracle 9i Certified DBA with 9 years of CRM experience on Siebel 6.0/7.5/7.8/8.1
• Domain experience in Pharma, Healthcare, Sales, Banking, Financial and consumer goods industry.
• 9 Yrs of profound/extensive Data Conversion/Migration/Batch Interface Development Using Siebel EIM, EAI, VB Com, SQL PLSQL, ETL Tools experience.
• Designed and developed entire process of migrating data from Pfizer's CCTR clinical system to Siebel CTMS Clinical Trial Management System
• Excellent SQL, PLSQL, ETL and Unix/Linux skills.
• Excellent Siebel Server Administration Skills.
• Extensive experience with creating oracle packages, stored procedures, functions, triggers and tuning time consuming queries.
• Designed and developed Interface for Migrating lease data from Mainframe to Siebel PRM for GE European Equipment Finance .
• Designed and developed the complete process to Migrate Account, Contacts, Opportunities, Revenues, Activities, Products, Inventory Location, and Inventory transactions from DB2 system to Oracle.
• Developed Data Loader and Parent Account Customer Hierarchy Interfaces while working with Hewlett Packard.
• Worked on Implementation of multilingual German, French, Japanese and Chinese Siebel Sales and Call center application.
• Part of data management team at GE Commercial Finance that handled Siebel Upgrade from Version 6.0 to Version 7.5.3.
• Extensive experience in Bulk Data Inserts, Bulk Data Updates, Data Delete Logical and Physical , Data Reassignment, Application Administration Tasks etc using Siebel EIM, VB Com.
• Imparted Siebel End user training to GE Commercial Finance Australasia users.
• Sound knowledge of J2EE

WORK EXPERIENCE:

Confidential

Role: Siebel Developer

Responsibilities:

• Design Develop Interfaces for integrating sales data from foodservice distributors such as Sysco, Colabor, ITWAL etc into Siebel consumer goods application.
• Develop solutions for integrating Invoice data from SAP into Siebel Application.
• Develop Extract, Transform, Load routines
• Perform Unit System testing.
• Co-Ordinate with business partners, stake holders, DBA team, Unix Admin teams.
• Impart knowledge transfer to Offshore support team.
• Manage Siebel Servers

Confidential

Role: Siebel Developer

Responsibilities:

• Review and refine requirements, review functional design documents, and develop technical design document.
• Migrate Pfizer's clinical trial management systems data from multiple sources into a single global CTMS system, using Oracle's Siebel CTMS.
• Review oracle objects such as Tables, Views, and Indexes structure to ensure they are compliant with legacy systems.
• Develop Informatica Mappings, Workflows etc to migrate data from multiple systems into Siebel CTMS, as per business requirements.
• Develop Oracle Functions, Stored Procedures, Triggers etc
• Prepare Source Legacy -Target Siebel Mapping Sheet.
• Prepare ifb files.
• Design and develop process to migrate data from one Siebel System to another Siebel System using Siebel EIM.
• Implement Audit Trail to conform to Federal Regulatory Laws.
• Consult with SME's in numerous departments to develop lists of values for all fields in the new system.
• Perform Unit Testing.
• Support downstream systems.
• Support Siebel Systems

Confidential

Role: Siebel Developer

Responsibilities:

• System design and development for 35 Siebel Batch Interfaces.
• Peer review of technical specifications for Siebel Interfaces.
• Defect remediation.
• Maintenance of technical design document.

Confidential

Role: Siebel Data Analyst

Responsibilities:

• Assist in translation of business data requirements into conceptual, logical and physical data models.
• Identify and document data standardizations to be performed, data enrichment operations, data validations, data security requirements and data exceptional handling process.
• Assigning Hospitals/Clinics/Physicians data to territories based on Zip codes using Siebel EIM.
• Worked closely with life sciences/health care vendors Such as C3i, IMS Healthcare to integrate DDD Drug Distribution Data and Syndicated/prescription data into Siebel.
• Integrated hospital/professionals into Siebel and its related data provided by McKenzie consulting data group as part of sales force effectiveness project.
• Created a Job to merge duplicate accounts as part of account planning exercise. Created SQL scripts to determine the winner/loser record by taking multiple business scenarios into consideration.
• Created monthly job using SQL and Shell scripts to extract data from Siebel and transfer to a network location to be used by data warehousing team.
• Data extraction and generating call reports.
• Analyze production data issues, prepare data feed, create Assistance request for c3i. Test, validate and approve the results.
• Created a monthly job using Siebel EIM to keep account and contact team members in sync.
• Created an interface to build account hierarchies. Created oracle package, procedures to achieve the same. Used oracle best practices such as bulk collect, fine tuned sql queries etc.
• Created weekly/monthly excel call reports Using VBA and oracle stored procedures .
• Created recurring data jobs for Accounts Insert, update, delete, account address update, account address delete, professional insert, update, employee/position insert/update using Siebel EIM.
• Created complex SQL Scripts to answer end users Regional Sales Director, District Manager, and National Sales Force Adhoc requests.

Confidential

Role: Siebel Data Management /EIM Specialist

Responsibilities:

• Developed batch Interface between Legacy System Banking and Investment, Portfolio Opportunity Management and Siebel Application.
• Developed daily Employee Load batch Interface between CAIS Central Associate Information System and Siebel application.
• Fine tuned existing EIM jobs running jobs in parallel, tuned ifb file parameters etc , improved the performance by 70
• Fine tuned long running queries and stored procedures.
• Designed and developed Audit Trail on sensitive data.
• Fine tuned EIM Merge process.
• Develop informatica mappings, mapplets and workflows. Fine tune existing mapping issues.
• Co-Ordination with OLAP and Autosys Team
• Provided Knowledge transfer to Support team.
• Involved in joint application development meeting.
• Develop technical design documents, peer review code.
• Prepared unit test cases and performed unit testing.

Confidential

Role: Siebel EIM and Data Migration

Responsibilities:

• Data Migration from Legacy System into Siebel using Siebel EIM.
• Prepare Assignment Rules using Assignment manager.
• Perform root cause analysis and prepare high level technical design documents.
• Perform requirement gathering, Coordinate with development team, peers to design , configure and customize system
• Prepare knowledge transfer documents and impart training to team members.

Confidential

Role: Siebel Designer

Responsibilities:

• Perform requirement Analysis, Identify root causes of data issues and recommend application, process, and education changes to eliminate each data issue.
• Identifying, prioritizing, and developing proposed solutions for any Siebel related issue. Creating SQL queries to identify problems. Analyzing migration tables and customer information in the database. Analyzing logs from Account Sweeps which identify problems with sweep data getting loaded into the CRM database.
• Construct detail design document for Synchronizing Opportunities and Revenues data from Global Partner Portal to Siebel CRM.
• Designed and developed Batch Jobs using Siebel EIM to migrate bulk data from IBM acquired company, Internet Security Services, to Siebel CRM.
• Design and developed data cleansing jobs to delete obsolete Account and Contact by taking various business scenarios into consideration using Siebel EIM.
• Preparing Unit test cases and resolve defects that arise during testing phases.
• Review design documents prepared by team members.
• Working with the Business Lead's, Data Architects and Stake Holders on any data related solutions.
• Communicating the Data Change Control process to all CRM Business lead's WW data reps.
• Worked with User Preference Files SPF Files , Co-Ordinate with FIVT and CRM Admin Team, deployment of SPF Files on AIX Boxes. Approve FIVT test report.
• Designed and developed a utility to track Users Session Information. Users session information Include capturing Login Name, Start Time, End Time, Locale,
• Object Manager and Language.
• Worked on Contact Denormalization concept of Assignment Manager.
• Worked on consuming a Siebel web service in a web center application.

Confidential

Role: Siebel EIM and Oracle9i Developer

Responsibilities:

• Development of Parent Account Hierarchy Interface using Siebel EIM and other technologies. This interface works on million of records.
• Tune Oracle Stored Procedures.
• Prepare IFB Files for running EIM tasks.
• Review of Functional Design Documents.
• Construction of Technical Design Document TDD .
• Preparing Requirement Traceability Matrix RTM and Functional Point.
• Preparing Unit Test Cases and Unit Test Scripts.
• Resolving the defects rose during Testing Phases Unit, System Integration, Performance and User Acceptance .
• Creation of Installation Package and Operational Manual.
• Imparting Knowledge Transfer to parent Account Hierarchy support team.
• Perform application testing.

Confidential

Role: Siebel EIM and Oracle Developer

Responsibilities:

• Working with Architects to understand and finalize the FDD and TDD specs.
• Construct SQL and PLSQL procedures to perform and validate business functions.
• Prepare and modify IFB Files for running EIM Jobs.
• Optimize/Tune slow performing Stored procedures and SQL Statements
• Preparing Requirement Traceability Matrix.
• Preparing Unit Test Case and Unit Test Scripts.
• Construction of Scoped Service Requests Enhancement and Known Issues in Interface .
• Updating TDD, Unit Test Case Review Logs.
• Coordinate Code Sync Related issues.
• Resolving defects rose during Test Phases Unit, Baseline, System Integration, Performance and User Acceptance Testing .
• Performed application testing.

Confidential

Role: Siebel EIM and VB Com Developer

Responsibilities:

• Responsibilities involved study of EEF, CEF and VFS Business Process and Siebel Application, providing support to Siebel users spread across 9 countries in Europe and US. Worked as Data Management Consultant for Support and Maintenance purpose.
• Worked on various maintenance related issues including Server Administration, Database extraction/ synchronization problems and User/Group Administration.
• Data management activities like Bulk Data Import, Bulk Data cleanup, Data extraction, Bulk Data reassignment, Bulk Data Updates Using EIM and VB Com Server Program called Data fix.

Confidential

Role: Siebel Batch Interface Developer

Responsibilities:

• Owned the complete process of migrating Lease data from Mainframe system to Siebel PRM application.
• Develop the Interface, document standard operating procedure.
• Prepare data mapping design and technical document.
• Load delimited text data into Siebel interface tables using SQL Loader.
• Prepare SQL Loader control file and batch file to invoke SQL Loader.
• Prepare SQL and PLSQL scripts to perform data validation, transformation and apply business rules.
• Prepare configuration files for EIM tasks.
• Prepare command line task to invoke EIM to load the data from Interface tables to Siebel base tables.
• Prepare MS DOS Scripts to move the Input files from Shared location to Siebel server and archive the old input files.
• Automate the process using Appworx scheduler.
• Troubleshoot errors if any during the ongoing loads.

Confidential

Role: Siebel Developer

Responsibilities:

• Created Standard Access Template, Standard Operating Procedure, Control File and Configuration File for loading Lovs and MLovs as Per Business Requirement.
• Deleting Views and associating new views with Responsibilities using EIM.
• Inserted Sales Methods, Sales Stages, Pre Defined Queries, Industries and other Application related tasks Using EIM.
• Worked on Re-Organizational Activities within Siebel which includes creating or modifying Organizations, Divisions, and Positions. This then involves setting the Hierarchy and addressing the Organizational requirement issues.
• Import Positions and Employees using EIM.
• Maintenance tasks like Database Extracts, Synchronization, Server Administration, Communication Administration and Application
• Siebel configuration using Siebel tools Created screens, views, applets, business components, joins, links, picklists and drill downs .
• Work experience with eScripting and Browser Scripting.