SUMMARY

Certified Senior Siebel Consultant wif over 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 teh required business processes and provide productive CRM experience. In depth knowledge of teh Siebel Data Model and has worked extensively on Siebel Enterprise Integration Manager and Siebel CSW along wif Oracle/SQL Server, Procedural Language SQL and multitude of ETLs. Expertise in data analysis and robust strategy building to deliver superlative solution. Sound domain knowledge on CPG trade promotion management wif a full implementation life cycle experience.

• Currently working as teh Tech Lead for teh Church & Dwight Trade Promotion Management assignment in teh Data Migration and OBIEE Analytics Forecast Live module in Confidential Infotech. In depth functional knowledge of teh client’s trade promotion management strategies and translating teh same onto teh CRM platform.
• Worked as teh Tech lead for teh Landmark Data Archival/Purge Utility coordinating teh work between teh different modules and teh integration of teh same.
• Worked as Siebel Data Migration Designer/Developer in teh development of a Global Customer Template for migration of legacy data into Siebel across multiple geographic regions for American healthcare safety and protection solutions client Ansell.
• Worked as a Siebel Data Migration resource in teh development of an alternate Siebel Handheld Syncing utility for teh Latin American client CND.
• Worked as Siebel Data Migration Specialist in Confidential Infotech wif Confidential Airlines, Confidential .
• Worked as a Migration Specialist in teh conversion team including 3 months of client facing position to complete teh Analysis and Design Phase of teh data migration process into Siebel for teh Polish telecom operator PTC.
• Worked as a Siebel EIM developer in teh conversion team of Swedish Telecom operator Tele2 for data migration into Siebel eCommunication 8.1.
• Developed teh daily EIM batch to run on an automated basis using shell scripting and command line submission of EIM tasks. Parallel threading of tasks wifin and across entities achieved as well.
• Involved in teh 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

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/Tool: Siebel 7x/8x, MS SQL Server Integration Services,
• MS SQL Server Management Studio, Informatica 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

Tech Lead

Responsibilities:

• Delivered end - to-end solution of highly critical Trade Promotion Management Forecasting wif complex business requirements/calculations translated into minimal variance data, projected onto OBIEE.
• Involved in teh requirements for legacy data transformation to Siebel TPM system.
• Involved in teh design of teh Data Migration approach wif end to end technical architecture.
• Involved in teh build of teh migration solution wif data being pumped from SAP and existing Siebel Application to teh new Siebel TPM system wif 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.

Confidential

Tech Lead

Responsibilities:

• Involved from teh requirement phase and continued teh end to end development of teh solution.
• Designed teh Data Purge Utility approach and handled teh integration between Siebel UI, Informatica and Siebel EIM through shell.
• Worked as teh Tech Lead to coordinate teh work between teh different modules and teh integration of teh same.
• Worked on teh 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 wif monitoring, siebel eim automation wif task id capture and server listing of teh same. etc.
• Involved highly in teh Informatica workflows development providing vital inputs on build and fine tuning of queries and flow.
• Understanding teh current business functionalities and legacy systems of teh company.
• Designing teh migration strategy to pump data from legacy systems across different geographical regions into Siebel.
• Building teh unified Global Customer Template to make source data in generalized format across different geographical regions.
• Building teh source to destination detailed mapping document.
• Building teh ctl,pl/sql and Siebel EIM ifb code base for teh migration batch.
• Building teh automation shell script to make teh migration batch developer independent and deployment/support ready.
• Understanding teh business functionalities of teh project and in depth analysis of teh data flow into Siebel through Siebel Handheld syncing process.
• Involed in teh conception and design of teh alternative source to destination data flow from Siebel remote to Server based on .NET utility on teh handheld device to transfer xmls to be processed by Microsft SSIS, pl/sql code base and EIM automation to overcome teh constraints and errors posed by teh regular Siebel HH syncing.
• Building teh pl/sql and Siebel EIM ifb code base for teh migration batch.
• Performance tuning of teh utility to support error and crash free HH sync to Siebel.

Confidential

Siebel Migration Analyst

Responsibilities:

• Key contribution in teh Analysis and Design phase of teh Data migration process into Siebel and on a client facing position.
• Responsible for legacy system analysis, scoping and designing teh Siebel Data Migration approach.
• Creation of EIM mapping.
• Defining transformation rules as per business requirements.
• Building IFB and PL/SQL code

Confidential

Siebel EIM Developer

Responsibilities:

• Responsible for legacy system analysis, scoping and designing teh Siebel Data Migration approach.
• Understanding teh business requirements
• Preparing teh functional/technical documents
• Preparing teh EIM mapping
• Migration of data from EIM to Base tables
• Identifying specific problems during teh load and solving them