Download PDF

Summary

6 years of experience with many large full cycle Siebel CRM Implementations with specialization in Siebel EIM data migration. A dynamic consultant focusing on Siebel Technical Consulting with roles of a Siebel EIM Developer handling & executing the development modules to successful implementations. Strong hands on skills in Siebel EIM, Informatica, Siebel Tools and Oracle PL/SQL

Overview of Expertise

  • With over 6 years in design, implementation and testing of Siebel CRM v8.0/8.1 Applications, understanding the architecture, scope and functionality with specialization in Siebel EIM data migration.
  • Good experience and knowledge in Requirements Gathering, Analysis, Siebel EIM Design, Testing & Data Migration for Siebel Enterprise
  • Strong knowledge in Siebel Architecture and Data Model and proficient with Siebel EIM concepts, Configuration (IFB) files, EIM jobs, SQL, PL/SQL, SQLLDR, writing Batch files, shell scripts etc. and basic working knowledge of Unix shell programming
  • Worked on data migration in Siebel UCM (Universal Customer Master/Oracle Customer Hub), populating SDH and Best version tables for master entities through EIM and BDM jobs.
  • Additional experience in formulating business and technical reconciliation scenarios, preparing and reviewing business and technical design documents, drafting detailed EIM mapping sheets, preparing and executing deployment and run sheet.
  • Expertise in debugging and resolving all kinds of EIM issues in Import, Delete, and Merge
  • 1 Year working experience in Informatica Power Center 9.1.0 (2012-2013)
  • Good knowledge in Informatica Concepts & Development, Informatica Mapping Designer, Workflow Designer and various Transformations
  • Oracle Partner Training completed for Oracle Sales Cloud R8 Implementation
  • Also worked on Siebel configuration module like applets, views, business components etc.
  • Experience in installing, configuring and administration of Siebel Innovation Pack 2016 (E2E)

Work History

Mar 2016Present

Siebel CRM Consultant

Computer Science Corporation

Responsibilities Overview:

  • Designing, executing and deploying E2E Siebel EIM data migration programs
  • Preparing technical design documents, E2E EIM mapping sheet, Run sheets, deployment guides etc.
  • Analysis, effort estimation, designing and development of production enhancements tickets
  • Installation, configuration and administration of Siebel Innovation Pack 2016
  • Experience in running Incremental Repository Merge (IRM) and Physical schema upgrade
Mar 2014Jan 2016

Siebel CRM Consultant

Capgemini India Pvt. Ltd.

Responsibilities Overview:

  • Designing Siebel EIM data migration approach
  • Preparing E2E EIM mapping sheet
  • Designing technical design documents
  • Writing complex transformation code in Oracle PL/SQL
  • Writing IFB files, shell and batch files for automation
  • Deploying and Executing the data migration code in production and leading it to successful implementations.
  • Formulating business and technical reconciliation scenarios
Nov 2010Mar 2014

Systems Engineer

Tata Consultancy Services

Responsibilities Overview:

  • Designing Siebel EIM data migration approach
  • Data analysis of legacy systems and siebel system
  • Designing and understanding technical design documents
  • Writing transformation code in Oracle PL/SQL
  • Writing IFB files and batch files for automation
  • Preparing unit test scripts and executing after each dry runs
  • Deploying and Executing the data migration code in production and leading it to successful implementations
Feb 2010Jun 2010

Internship

Tata Consultancy Services

Tasks Undertaken:

  • Usage of Mastercraft IDE tool to generate java code through Q++ scripts
  • Learnt Q++ Language (a TCS internal programming language)
  • Usage of utilities like SQL developer, Toad, WinSCP, PuTTY etc..

Education

Jul 2007Jun 2010

Master of Computer Applications (MCA)

Jamia Millia Islamia University

Distinction with 78%

Specializations:

  • Programming languages like C, C++, Core Java
  • Oracle database 10g (DBMS)
  • Computer Networks, Operating Systems, Business data processing
  • Artificial Intelligence and Machine learning
Jun 2003May 2006

Bachelor of Science (B.Sc) Mathematics

Ranchi University

Honors in Mathematics, 1st division with 68%

Training

Sep 2014Oct 2014

Oracle Sales Cloud R8 Implementation

Oracle Corporation
  • 5 days intensive Oracle Partner Training completed for Oracle Sales Cloud R8 Implementation
  • Training included practicals (Lab) in Administration and Simplified UI applications
  • One month self-training and practise in Oracle provided environments
Mar 2011Mar 2011

Siebel EIM and Data Management

Tata Consultancy Services

2 days intensive Siebel EIM training program

Feb 2011Feb 2011

Siebel Configuration

Tata Consultancy Services

5 days intensive Siebel Configuration training program

Skills

Siebel Administration
  • Installation, configuration and administration of Siebel Innovation Pack 2016
  • Experience in running Incremental Repository Merge (IRM) and Physical schema upgrade
Siebel EIM
  • 4.9 years in design, implementation and testing of Siebel CRM v8.0/8.1 Applications, understanding the architecture, scope and functionality with specialization in Siebel EIM data migration.
  • Good experience and knowledge in Requirements Gathering, Analysis, Siebel EIM Design, Testing & Data Migration for Siebel Enterprise
  • Strong knowledge in Siebel Architecture and Data Model and proficient with Siebel EIM concepts, Configuration (IFB) files, EIM jobs, SQL, PL/SQL, SQLLDR, writing Batch files, shell scripts etc. and basic working knowledge of Unix shell programming
  • Worked on data migration in Siebel UCM (Universal Customer Master/Oracle Customer Hub), populating SDH and Best version tables for master entities through EIM and BDM jobs.
  • Expertise in debugging and resolving all kinds of EIM issues in Import, Delete, and Merge
  • Additional Hands-on experience in data migration into Siebel UCM (Universal Customer Master)
Oracle PL/SQL
  • Expertise in Oracle 10g/11g, using SQL Loader, writing PL/SQL packages and procedures and creating other database objects
  • Automation done using Unix shell programming and windows batch programming
Informatica Powercenter 9.1.0
  • Well versed in Informatica Concepts & Development approach
  • Worked in Informatica Mapping Designer, Workflow Designer, workflow monitor and various Transformations such as Lookup, filter, aggregate, expression, constant transformations etc.
Siebel Domain
  • Siebel eService 8.1
  • Siebel ePharma 8.1
  • Siebel Financial Services 8.0/8.1
Others

Server Components:

  • Enterprise Integration Manager (EIM)
  • Workflow Process Manager

Operating System Platforms:

  • Windows
  • Unix

Others:

  • SQL Loader
  • SQL Developer
  • Toad 9.5
  • WinSCP
  • PuTTY

Projects Undertaken

Computer Science Corporation                                                                                        Mar 2016 - Present

-- Client: Ford Motors Ltd.
-- Role: Siebel EIM Developer/Siebel Admin
-- Project: ATLAS AD                                                                                                                   Mar 2016 – Present

  • Designing, executing and deploying E2E Siebel EIM data migration programs
  • Preparing technical design documents, E2E EIM mapping sheet, Run sheets, deployment guides etc.
  • Analysis, effort estimation, designing and development of production enhancements tickets
  • Installation, configuration and administration of Siebel Innovation Pack 2016
  • Experience in running Incremental Repository Merge (IRM) and Physical schema upgrade

Capgemini India Pvt. Ltd.                                                                                                    Mar 2014 – Jan 2016

-- Client: NRMA Motoring & Services, New South Wales, Australia
-- Role: Siebel EIM Developer
-- Project: Release3 Siebel Implementation                                                                    Sep 2014 – Present

  • Platform: Siebel Financial Application 8.1, Unix server, Oracle 11g database
  • Understanding the current legacy systems and designing the data migration for release 3
  • Detailed critical analysis of functional design document and designing the technical design document for Customer entity (Accounts, Contacts, Addresses)
  • Migrated legacy data in Siebel UCM, populating SDH and Best version tables for master entities through EIM and BDM jobs.
  • Formulated business and technical reconciliation scenarios, prepared and reviewed business and technical design documents, drafting of detailed EIM mapping sheets, preparing and executing deployment and run sheets.
  • Wrote complex transformation using PL/SQL scripts, packages and procedures, prepared IFB files
  • Automated the complete execution of code transformation and EIM jobs using shell scripts.
  • Migrated around 5 million Account records along with their details, Contact-Account association, Account-Address association and setting its primaries.
  • Transformed the legacy data into format used by other systems such as Oracle EBS including Cross-references load to and from various systems.

-- Client: Mylan Pharmaceuticals Inc., Morgantown, USA
-- Role: Siebel EIM Developer
-- Project: MySource Siebel Implementation Phase2                                                      Mar 2014 – Aug 2014

  • Platform: Siebel ePharma 8.1, Windows Server 2008 R2, Oracle 11g database
  • Prepared functional and technical design documents for various entities such as Products, Orders & Shipments, Accounts, Pricelists, and Competitors etc.
  • Suggested design changes due to existing flaws to onshore team to ensure robust and efficient design
  • Designed and developed unit test script documents
  • Modified and updated some of the existing EIM interfaces on test environment as part of POC development.

TATA Consultancy Services Ltd.                                                                                              Nov 2010 – Mar 2014

-- Client: Honeywell Corporation, Phoenix, USA
-- Role: Siebel EIM Developer
-- Project: SIA Upgrade 8.1.1.11/ Siebel Innovation Pack 2013                                    Dec 2013 – Mar 2014

  • Platform: Siebel eService 8.1, Windows Server 2008 R2, Oracle 11g database
  • Executed rigorous testing cycles both technical and functional in development and UAT environments
  • Modified and updated some of the EIM interfaces, automated jobs etc. in relation to SIA upgrade
  • Tested all the Report server DB views
  • Deployment done on production system successfully


-- Client: Honeywell Corporation, Phoenix, USA
-- Role: Siebel EIM Developer
-- Project: Recommended Spares & Products                                                                        Oct 2013 – Dec 2013

  • Platform: Siebel eService 8.1, Windows Server 2008 R2, Oracle 11g database
  • Requirement gathering done for product and product line load along with understanding the scope and its functionality
  • Designed the EIM interface for loading product, associating the new products to their respective parent products, for loading new product lines and updating product lines, developed automated job for it, wrote packages, stored procedures, CTL files, bat files etc
  • End to End technical testing done on DEV and UAT
  • Completed the deployment of the interface on production


-- Client: Honeywell Corporation, Phoenix, USA
-- Role: Siebel EIM Developer
-- Project: Siebel 8.1.1.10 SIA Upgrade and LDAP Authentication                                Jun 2013 – Sep 2013

  • Platform: Siebel eService 8.1, Windows Server 2008 R2, Oracle 11g database
  • Involved in data mapping of Siebel base tables to EIM tables for address entity
  • Modified and updated all the EIM interfaces, automated jobs etc. in relation to SIA upgrade
  • Modified and changed the database views in report server to be in synch with the new features of SIA
  • Loaded new responsibilities for Siebel Analytics users and associating these to the concerned users.
  • Loaded views and associated responsibilities to it
  • Prepared and implemented the design for updating the logins of all the users to their respective Employee IDs for implementing LDAP authentication
  • Executed rigorous testing cycles both technical and functional post deployment of SIA upgrade.
  • Debugging done for issue that surfaced after deployment


-- Client: Honeywell Corporation, Phoenix, USA
-- Role: Siebel EIM Developer
-- Project: GSM Service Implementation.                                                                                 July 2012 – May 2013

  • Platform: Siebel eService 8.1, Windows Server 2008 R2, Oracle 11g database
  • Involved in Data Mapping for loading the Customer data and prepared complex SQL queries, configured and optimized configuration (IFB) files to run EIM job for data load
  • Created CTL file for SQL Loader and load the data received from External system into the EIM Interface tables for further EIM processing
  • Executed EIM jobs and wrote Packages and Procedures using PL/SQL
  • Implemented EIM best practices in mapping Siebel data with external data through EIM tables, coding standards and develop the application considering performance impacts
  • Involved in creating Technical Design Documents, Unit Test case documents which are used for Designers to Review the Technical Implementation and to test various entities
  • Worked extensively on Informatica, Mapping Designer, Repository Manager and Workflow Manager Client tools
  • Used different type of Transformations like Lookup, Expression, Filter, Sequence generator, Constant etc
  • Executed 5 rigorous full-cycle Data Migration dry runs on five different environments in a period of 6 months, debugged for errors and data correction
  • Worked extensively with Master Data such as LOVs, positions, View-Responsibilities, Employee Data and many others
  • Worked with the Production support team to resolve the issues and with the implementation teams for successful SRF fixes and application level changes on UAT and production environments
  • Resolved EIM import errors like pick list value, Ambiguous, Not Allowed, foreign key issues etc. that occurred during EIM Import
  • Worked on fixing the issues faced by users in EIM Import due to the data errors in the file received from other systems and wrote pre-procedures to validate the data before loading into Siebel table to avoid those issues
  • Performed Troubleshooting (Debugging, Root Cause Analysis) of day-to-day UAT & Production issues.


-- Client: Kotak Mahindra Bank Ltd.
-- Role: Siebel EIM Developer/Configurator
-- Project: Siebel Financial Services 8.0                                                                                      Nov 2010 – Jun 2012

  • Platform: Siebel Financial Services 8.0, Oracle 10g database
  • Designed data mapping of external data to siebel EIM tables and from EIM tables to Siebel Base Tables for performing EIM imports.
  • Analyzed external data and wrote SQL queries, PL/SQL blocks for cleansing the data before populating it into Interface tables.
  • Executed EIM jobs and wrote Packages and Procedures using PL/SQL.
  • Implemented EIM best practices in mapping Siebel data with external data through EIM tables, coding standards and develop the application considering performance impacts.
  • Worked extensively on Master Data such as LOVs, Positions, and Responsibilities etc.
  • Resolved day-to-day production issues related to EIM failures, discrepancies etc. and preparing Issue Resolution documents to share with client.
  • Configured Siebel objects such as Business Components (VBC for Actuate Reports), Applets, Views, Screens, Toggle Applets, Link, Join, calculated fields, DVMs etc.
  • Analyzed and Customized Partner Portal Application directly from BRD (Business Requirement Document).
  • Gave TTT Training (Train The Trainers) for Partner Portal to Client IT Technical/Functional Team at onsite.
  • Hands on experience in Siebel Actuate Reports for Sales and Service Report generations.

Strengths

  • Good oral, written & presentation skills
  • A high tolerance of stress and enjoys responsibilities
  • Quick learner with good grasping ability
  • Action-oriented and result-focused
  • Lead & work as a team in an organized way
  • Great time management skill

Personal Details

Date of Birth:               30th August 1986

Address:                         A-204/1, 2nd Floor, Shaheen Bagh, Abul Fazal Part-II, Okhla, New Delhi-110025

Marital Status:            Married

Nationality:                  Indian

Passport No:                M5139193, Valid till 01/2025

Languages known:   English, Urdu, Hindi, Arabic

Websites:                       www.siebeleim.com, www.siebel-eim.weebly.com