SOUMYA SEKHAR SAMANTA
Skype: soumya.sekhar.samanta
Cell – +260960993786 (Zambia)
SUMMARY
Currently working as Principal Consultant – Siebel CRM with 10+ years of industry experience.
Well versed with implementation as well as support project.
Extensive experience in system design and development required for business process. Specialize in working with technical staff to create, interpret, and implement business requirement into technical specifications.
Experienced preparing and attending Project Implementation Committee, Project Steering Committee meeting.
Excellent Client managing and Problem solving skills.
Ranger in Salesforce Administrator.
PROJECTS – In Details
Project: Contribution and Benefits System
Client: NATIONAL PENSION SCHEME AUTHORITY, LUSAKA, ZAMBIA
Capacity: Principal Consultant (Siebel Financial Services)
Main Responsibilities:
· Migration – Legacy data to Siebel using Siebel EIM technology for various entities (Employer, Member, Beneficiary, Returns, Contribution, Collection, Payments).
· Integration – Co-ordinating and testing integration for various modules (Employer Registration, Member Registration, Returns Upload, Collections).
· Tender – Analysing and replying various Siebel related RFP’s
Project: Enterprise Wise Data Management (Claims Management) – Support
Client: Motor Vehicle Fund Association, Windhoek, Namibia
Capacity: Team Leader (Siebel Public Sector)
Main Responsibilities:
· Working as Lead for various engagements
· Building and Managing a Siebel team of 4
· Techno Functional Assistance on Siebel Application, Siebel EBS Integration
· Assistance on Siebel Upgrade from 8.2.2 to 8.2.2.4
· Developing new functionalities using Siebel Tools
· Migrating legacy data using Siebel EIM
· Developing Reports using BI Publisher Report
· Planning for Siebel Change Request Analysis, Development, Testing , UAT and Deployment in Production
· Reporting to Project Steering Committee on monthly basis for Support Related Activities/ Change Request Completed and Planned for upcoming Month.
· Analysing and replying various Siebel related RFP’s
Project: Siebel Branding
Client: Internal (Tata Technologies, Mumbai)
Capacity: Team Leader
Main Responsibilities:
· Creation of Siebel Environment for Siebel Branding with the aim of Presenting Readymade Solution to prospective customer
· Revamping Siebel Login Screen with the inputs from internal customer
· Developing/ executing migration plan for Siebel Sample Data to be available in Siebel Server instance
· Assisting team members in developing / customizing Siebel Application as per request from internal customer
· Providing Solution for bringing in new Module within Siebel
Project: Enterprise Wise Data Management (Claims Management) – Implementation
Client: Motor Vehicle Fund Association, Windhoek, Namibia
Capacity: Solution Developer
Main Responsibilities:
· Managing Siebel Server.
· Studied the High-Level Design document to convert it into Low-Level Design document in order to configure the changes using Siebel Tools
· Worked on Siebel to Oracle EBS integration for Service Provider Payments, Claims Payments
· Demo to client how EIM works with sample data loading.
· Creating fields mapping according to Entity.
· Template Finalization according to data available based on the Entity
· Data File Preparation According to Template
· Loading Prepared Data into Staging Table (EIM Table) using Oracle SQL Loader Utility.
· Developing PL/SQL to Populate User keys, populating any other information (if needed), Updating Position etc.
· Developing Interface Batch File based on the entity to Load data from staging table to Siebel base table
Project: Crime Occurrence Tracking System – Implementation
Client: Mauritius Police Force, Port Louis, Mauritius
Capacity: Lead – Migration
Main Responsibilities:
· Preparing development plan for Data Migration
· Gathering requirement from the authority
· Assigning task to team members
· Technical help to team members as and when required
Project: Crime Occurrence Tracking System – Implementation
Client: Mauritius Police Force, Port Louis, Mauritius (Onsite)
Capacity: Lead – BIP Reports
Main Responsibilities:
· Preparing development plan
· Gathering requirement from the authority
· Assigning task to team members
· Technical help to team members as and when required
Project: CRM – Dealer Management System
Client: Tata Motors Ltd., Mumbai
Capacity: Lead – BIP Reports
Main Responsibilities:
· Prepare development plan, coordinating with Business, Tester (Testing in three different environments viz. DEV, QA, and Sandbox)
· Coordinated with server team for issues/queries, made roll out plan for Production all across India with the Business.
· Migrating Actuate Reports into BIP Reports
· Converting Siebel Report Objects into Integration objects using BIP utility tool
· Converting & designing Actuate report template into BIP report template (RTF template) using BIP utility tool
Project: CRM – Dealer Management System
Client: Tata Motors Ltd., Mumbai
Capacity: Siebel Configurator
Main Responsibilities:
Business requirement gathering from SME
Review of Analysis on Technical specifications based on Business requirement
Review of Designing Technical System Design of the process
Review on Coding and Unit Testing of the process
Coordination on QA testing with Business Analyst and Business Users
Project: Clinical Trial System
Client: Warner Chilcott
Capacity: Siebel EIM Developer
Main Responsibilities:
Understanding business requirement from Business Analyst and planning out for bulk data load into Siebel. Proper study for field’s mapping using EIM mapping document.
Developed following EIMs (includes SQL Loader, PL/SQL, IFB)
Project: Clinical Trial System
Client: Siro Clinpharm Pvt. Ltd
Capacity: Siebel EIM Developer
Main Responsibilities:
Understanding business requirement from Business Analyst and planning out for bulk data load into Siebel. Proper study for field’s mapping using EIM mapping document.
Developed following EIMs (includes SQL Loader, PL/SQL, IFB)
Project: CRM – Dealer Management System
Client: Tata Motors Ltd.
Capacity: Siebel EIM Developer
Main Responsibilities:
Understanding business requirement from SME, Analyst and/or EIM lead. Based on requirement, enhance existing EIM or change existing EIM or to develop new EIM. Study the field mappings using the EIM mapping document.
Preparing Technical Specifications and actual development starting from making Control File using SQL Loader, developing PL/SQL program and preparing IFB files.
Organization set up activities (VBCOM & EIM): Setup of 1800+ dealerships locations (Siebel Organizations & Divisions) covering Divisions, Positions, Users, Price, Costs & Rate lists, Accounts, Contacts & Assets relationships, Spares Stock.
User Provisioning: Creating new users in the application.
Assigning responsibilities and appropriate position to the users, enabling them to view data. Activating and synchronizing login ids on database.
Resolving user id related issues.
EIM Operations: Vehicle (Asset), Receiving Line Items (for Spares), Order header details – Updates (Spares), R/3 Partner Functions (Accounts), Product – Master data updates. Price List Header & Items (Spares). To set up appropriate configuration parameters to ensure better performance.
EDUCATIONAL BACKGROUND
MS in Advanced Software Technology from International Institute of Information Technology, Pune, India in 2008
CERTIFICATIONS
Team Leadership from Tata Technologies, Harvard Publishing in 2012
Brand Ambassador by Tata Technologies in 2009
Quality and Process Assessment by Tata Technologies in 2009
Information Security Awareness by Tata Technologies in 2009
Tata Code of Contact by Tata Technologies in 2009
Oracle Certified Professional training from SQL Star International under Oracle University in 2005-2006
WORKSHOPS
Oracle Database Administration : 10g by Oracle University in June 2010
Team Building workshop by Tata Technologies in 2010
BIP Workshop by Oracle Europe in 2010
DBA day by Oracle India in 2009
Oracle Identity Manager training by Tata Technologies in 2008
SAP ABAP OOPS by Tata Technologies in 2008
Basic Sales & Service process in Siebel Automotive by Tata Technologies in 2008
Campus to Corporate, Induction Program by Tata Technologies / SIBM in 2008
PROFESSIONAL EXPERIENCE
Current Employer
Smartlink Emirates, Lusaka, Zambia
Duration
Dec 2016 – Present
Past Employer
SILNAM IT Solution Pty Ltd, Windhoek, Nambia
Duration
Feb 2013 – Dec 2016
Past Employer
Tata Technologies, Mumbai, India
Duration
Aug 2008 – Dec 2012