SUMMARY

• 10 years of Experience in Data Migration, Configuration and Application Maintenance of Siebel 7x/Siebel 8x applications in Consumer Good, Telecom, Pharma and Airlines Loyalty domains to cater to the required business processes and provide productive CRM Experience
• In depth knowledge of the Siebel Data Model and have worked extensively on Siebel Enterprise Integration Manager and Siebel CSW along with Oracle/SQL Server, Procedural Language SQL and multitude of ETLs
• Expertise in Data Analysis and robust strategy building to deliver superlative solution
• Recent experience in upgrade from Siebel 7.8 to Siebel 8.1. Also experienced in using Siebel 8 Tools for development and resolving upgrade issues
• Proficient in Siebel Tools configuration, Workflows, Business Services, Application Integration, Enterprise Integration Manager (EIM), EAI across the Siebel releases 8.1, 7.8, 7.7 and 7.5.3
• Automated batch EIM imports including auto loads from flat/csv files to EIM tables
• Developed the daily EIM batch to run on an automated basis using shell scripting and command line submission of EIM tasks. Parallel threading of tasks within and across entities achieved as well
• Involved in the development of import and export jobs and batches, according to client requirements, using DataStage Designer to put data into EIM tables which is processed by Siebel EIM
• Involved in Execution of Unit as well as System Tests
• Analytical mind with greater attention to details and proven problem - solving skills
• Punctual to the core, emphasizing on quality processes as well as time-bound deliverables

TECHNICAL SKILLS

Operating System: Windows XP/2K/7/8, Unix

Language: C, SQL, PL/SQL, Shell Scripting, VBScript

RDBMS: Oracle 9i/10g/11g/12c, SQL Server 2012

Software/Package/Tools: Siebel 7x/8x, MS SQL Server Integration Services, MS SQL Server Management StudioINFORMATICA 9, SQL Developer, TOAD, DataStage Director 7.1, DataStage Designer 7.1, Microsoft Office, Microsoft Excel, SQL PLUS, Macromedia Flash, Microsoft Visual Source Safe, Remedy, Tortoise SVN, Putty, WinSCP

PROFESSIONAL EXPERIENCE

Confidential, Ewing, NJ

Siebel Tech Lead

Responsibilities:

• Delivered end-to-end solution of highly critical Trade Promotion Management Forecasting with complex business requirements/calculations translated into minimal variance data, projected onto OBIEE
• Involved in the requirements for legacy data transformation to Siebel TPM system
• Involved in the design of the Data Migration approach with end to end technical architecture
• Involved in the build of the migration solution with data being pumped from SAP and existing Siebel Application to the new Siebel TPM system with complex entity transformation between source and destination
• Proactively involved in defect fixes and document provisioning
• Involved in a client facing role to mitigate risks involved in Data Migration and deliver a quality solution

Environment: Siebel 8.1.1.14, SQL Server 2012, Microsoft Azure

Confidential

Siebel Tech Lead

Responsibilities:

• Involved from the requirement phase and continued the end to end development of the solution
• Designed the Data Purge Utility approach and handled the integration between Siebel UI, Informatica and Siebel EIM through shell
• Worked as the Tech Lead to coordinate the work between the different modules and the integration of the same
• Worked on the challenging items of secure shell between different Unix boxes, password less secure shell, Siebel button click invoking shell scripts and Informatica processing in real-time with monitoring, Siebel EIM automation with task id capture and server listing of the same
• Involved highly in the Informatica workflows development providing vital inputs on build and fine tuning of queries and flow

Environment: Siebel 8.1, Oracle 11g, Unix

Confidential

Sr. Siebel Data Migration Specialist

Responsibilities:

• Understanding the current business functionalities and legacy systems of the company
• Designing the migration strategy to pump data from legacy systems across different geographical regions into Siebel
• Building the unified Global Customer Template to make source data in generalized format across different geographical regions
• Building the source to destination detailed mapping document
• Building the CTL, PL/SQL and Siebel EIM IFB code base for the migration batch
• Building the automation shell script to make the migration batch developer independent and deployment/support ready

Environment: Siebel 8.1, Oracle 11g, Unix

Confidential

Siebel Data Migration Consultant

Responsibilities:

• Understanding the business functionalities of the project and in-depth analysis of the data flow into Siebel through Siebel Handheld syncing process
• Involved in the conception and design of the alternative source to destination data flow from Siebel remote to Server based on .NET utility on the handheld device to transfer XMLS to be processed by Microsoft SSIS, PL/SQL code base and EIM automation to overcome the constraints and errors posed by the regular Siebel HH syncing
• Building the PL/SQL and Siebel EIM IFB code base for the migration batch
• Performance tuning of the utility to support error and crash free HH sync to Siebel

Environment: Siebel 8.1, Oracle 11g, Microsoft SSIS

Confidential

Siebel Migration Analyst

Responsibilities:

• Key contribution in the Analysis and Design phase of the Data migration process into Siebel and on a client facing position
• Creation of EIM mapping
• Defining transformation rules as per business requirements
• Building IFB and PL/SQL code

Environment: Unix, Siebel 8.1, Oracle 10g, PL/SQL