Technical Consultant Resume
SUMMARY
- 7 years of Information Technology experience in application development which includes strong 5years of hands-on experience in Siebel CRM as a Siebel Developer / Technical Consultant.
- Experience in different phases of Software Development Life Cycle, namely Analysis, Design, Implementation, Testing plus production support.
- Experience in requirements gathering, designing, implementing and supporting Siebel Enterprise applications for Siebel 7.x and 8.X
- Proficient in Siebel Configuration, Siebel Scripting (Server & Browser), EIM, EAI, Workflows, Assignment Manager, Server Components, Siebel Data model and testing.
- Extensive hands-on experience in Siebel Product configuration, Siebel Pricing models and custom built-ins.
- Experience in Integration of Siebel Application with other legacy applications using Siebel Integration Tools - EAI, EIM, eScript, Integration objects, IBM MQ-Series, Web Services and HTTP.
- Strong knowledge and experience in Siebel EIM - developing Configuration (IFB) files and EAI. Working knowledge in SQL, PL/SQL and UNIX & Windows.
- Expertise in Siebel EIM (IMPORT, EXPORT and DELETE) for Siebel 6.x and siebel7.x.
- Experience in Siebel Call Center, Siebel eChannel, Siebel Partner Manager, Siebel Partner Community, Siebel Field Service, Siebel Sales and Marketing.
- Very good experience on Siebel Order Management.
- Highly proficient in PERL script, Windows batch programming and MS SQL DTS packages.
- Experience in configuring workflows, policies, policy conditions and troubleshooting workflows.
- Experience in Web Services, Assignment Manager, and communication/email management.
- Experience in SQL Server 2000/2005 and Oracle 9i.
- Worked extensively on Business Requirements Elicitation, Process Modeling, Gap analysis, Risk analysis and development of Functional Specifications.
- Proficient in Application and System support (Tier 2 and Tier3) with one-to-one customer interaction.
- Have a high degree of ability to interact with end users with proven ability to understand end-user requirements and translate them into Siebel technical components.
- Extensive experience in project management, which includes project planning, leading technical teams for over four years now, writing Request for Proposals (RFP), Statement of Work (SOW) and resource allocation.
- Cohesive team player with strong consulting, interpersonal, writing, communication and techno-functional skills.
Siebel CRM: Siebel 7.0, 7.5, 7.7 and 8.1, Tools Configuration, Siebel eScript/VB Script, EIM, EAI, IBM MQ Series, Workflows, Assignment manager, Server Administration
Languages: PERL Programming, Windows Batch Programming, MS SQL DTS packages
Operation Systems: Win NT/2000/XP, UNIX, MS-DOS
Data Bases: SQL Server, Oracle
Web Technologies: XML
MS Office Tools: Word, Excel, PowerPoint, Project, Visio
- Master of Science
- Numerous client appreciations and commendations in all projects that I worked.
- Commendations from Xerox client team for maintaining/creating design & process documents for each change request and also for day-to-day production support issues.
- Commendations from Xerox client managers, for completing the Project from Requirement gathering till implementing into Production, solving the Post Production issues and for making application stable for users.
- Commendation from Xerox Client, for reducing their yearly Software License cost of $30K, by removing the IBM’s SyncSort Application, and SyncSort’s operation performed through Perl Script.
- Excellent communication skills and rich onsite experience.
- Ability to work in groups as a Lead as well as individually.
- A fast learner and quick in adapting to newer technologies.
- High patience level, self-confidence and hard working nature.
- Ability to work hard and to take challenging projects.
PRM and Falcon Maintenance and Enhancement April 2011 Till Date
Client: Confidential,NY Feb 2008 - May 2010
The objective of the project is to maintain and enhance Siebel applications for Xerox - the Siebel Partner Relationship Management application and Siebel Field Services Application (Falcon). PRM Application is used to cater the business need of managing all the Partners and Dealers of Xerox across North America and also to place orders for their Equipments, Supplies and Parts. It has complex real time integrations with Mainframes, Oracle SOA thru MQ Series & HTTP.
Falcon is the application used by Xerox Managed Services division to manage all the Inventory Control needs of the business, which includes both the internal and external supplies done by Xerox. Falcon has real time integrations with Mainframes using Web Services.
Responsibilities:
- Leading Tier 2 and Tier 3 Application so also System Maintenance/Support team where I am looking after escalations from Tier 1 Helpdesk. I report directly to the clients.
- Leading the team which takes care of major enhancements to the application as per business requirements/requests.
- Prepared the Estimations, Technical Design Documents & Unit Test Cases.
- Responsible for Impact analysis of various Requirements in real-time production environment.
- Worked on Complex product configuration, catalog and pricing administration.
- Worked on Order management.
- Worked on Contracts (Agreements and Asset) data load thru MQ series.
- Worked on integration of Siebel Application data with Legacy systems like IBM Mainframe using MQ Series as middleware.
- Developed Windows batch jobs with PERL, FTP to load data from flat files to Siebel database.
- Created internal and external Integration Objects and wrote eScript code to transform incoming customer codes data from external systems in to Siebel Data.
- Developed EIM batch jobs (creating and modifying IFB files), to retrieve data from back end for import, export jobs and for record level changes.
- Configured Agreements, Entitlements and assets.
- Created new Business Objects, Business Components, business services, applets, views, MVG’s, joins.
- Configured Applet, Business Component and Field Level User Properties to meet the requirements.
- Developed batch interfaces to execute SQL DTS packages.
- Responsible for analyzing areas in application affected by the change requests and Enhancements.
- Involved in unit testing, System Testing, Integration testing and Performance testing of the changes affected.
- Coordinating Onsite-offshore teams and assigning work.
- Coordinating reviews and sign-offs with customer and initiating weekly status meeting with the client manager.
- Preparing Weekly/Monthly metrics and the status reports.
- Taking care of the Job failures, data loads and support during weekends maintenance activities.
- Experience on email response like triggering and sending email whenever there is an activity approval is needed involving WF and scripts.
- Designed workflow to send out emails to Channel partners if there is new service request, equipment order creating. Used Outbound Communications Manager for e-mail notifications.
Environment: Siebel 7.0.5.6 eChannel, Partner Portal, Partner Manager, Siebel 7.5 Field Service, SQL Server 2000, MQ-Series, Configuration, Workflows, EIM, EAI, Web Services, FTP, SFTP.
Client: Confidential,NY June 2010 March 2011
Role: Siebel Technical Consultant cum Business Analyst
PRM Parts Chaining
PRM Parts Chaining project is an enhancement to the existing Siebel 7.0.5.6 PRM application w.r.t Order management, catalog administration, product administration. PRM Application is used to cater the business need of managing all the Partners and Dealers of Xerox across North America. PRM has one partner manager application used by the Xerox internal users and 8 portal applications used by its partners and dealers.
The main objective of this project is to enable Parts Chaining to the Xerox Customers. Upon ordering a part through PRM, if the ordered part or an appropriate alternate part cannot be found in the PRM system, the entire part order is put on hold. With the parts chaining, customer can get parts without any delay or manual intervention as it integrates with Oracle SOA for inventory availability and for chained products on real-time basis.
Responsibilities:
- Involved from the inception of the project, playing a role of a System Business Analyst, framing out both functional and technical requirements in accordance with business rules and in tandem with representatives of PRM user community.
- Involved in designing solutions for the project from a functional side so also from an Integration point of view. The scope of this project covers around 10+ integration touch points, both existing and new ones to be introduced to achieve the objectives of this venture.
- Maintained minutes of meeting during all client level and project management level meetings.
- Created Integration Objects. Created Inbound Integration with Workflow and Scripting to insert data into Siebel from the Oracle SOA system thru MQ series & HTTP.
- Designed the Catalog and Product Administration, Pricing logics and Complex product configuration.
- Created Outbound Integration with Workflow to pull data from Siebel and send as XML to Oracle SOA.
- Development of Siebel Workflow for customer specific requirements. Creating new RCR/ Workflow policies for Workflow process.
- Created new batch interface for data loads using EIM, batch scripting, Perl
- Debugging and Maintaining of Siebel Workflows.
- Troubleshooting MQ Series issues.
- Creating new Joins, Links, MVGs, Picklists, Pick Applets, Business Component User properties.
- Creating new Business Services for the implementing new business requirements using Siebel eScript.
- Involved in Requirement Analysis.
- Conducted Gap Analysis to show the current and proposed functionalities of the system.
- Preparation and updating of Technical Design Documents.
- Customization using Siebel Tools Involved in design and development of User interfaces Layers like Applets, Views, and Screens etc. and modified certain applets.
- Worked on Business Component user properties & List Of Values.
- Worked on calculated fields and field validations.
- Maintaining and troubleshooting system issues by coordinating end users and business users.
- Developed training documents for the project and involved in training the end users.
Environment: Siebel 7.0.5.6 eChannel, Partner Portal, Partner Manager, SQL Server 2000, MQ-Series, HTTP, Configuration, Workflows, EAI, Web Service, FTP, SFTP.
Client:Confidential,NY Oct 2007 Jan 2008
Role: Siebel DeveloperFalcon Siebel Enhancement and Support
The objective of the project is to enhance and support Siebel 7.5 Field service application for Xerox. Falcon is the application used by Xerox Managed Services division to manage all the Inventory Control needs of the business, which includes both the internal and external supplies done by Xerox. And also to provide daily service transactions to managed service customers of Xerox. It is a technology used to support job activities and Supplies (Order management) by integrating legacy systems like IBM Mainframe using MQ series, voyageur (another middleware application in Xerox) using Web Service.
Responsibilities:
- Responsible for setting up the development environment at the beginning of the project, participating in the Knowledge Acquisition Phase from the Team of Architects of the Client’s Development Team and documenting the same in the form of a SMTD document and Inducting new members in to the team by providing proper KT sessions.
- The responsibilities handled during the stable phase of the project include Analyzing and Mapping the Business processes which are required to be mapped as an enhancement to the System, Providing Mock-up solutions and Estimations for the proposed implementations, Designing and Configuring the implementation solutions and managing the offshore team to meet the milestones.
- As a member of the configuration team, configured and customized the Siebel UI. Designed Applets, Views and Screens. Enabled the applets to display on web in different modes. Created pick lists, drill downs and Toggle Applets
- Made major contributions in terms of improved maintainability and by incorporating newer features or value additions in the following business areas/process - Account management,Order management, Service request management, Inventory Management and Product Management.
- Worked on Contracts (Agreements and Asset) data load thru MQ series.
- Worked with Workflows, XML, and MQ Series as the transporting agents to achieve integration.
- Developed Windows batch jobs with PERL, FTP to load data from flat files to Siebel database.
- Used Vanilla Business Services as well as created Custom Business Services using eScript language.
- Developed EIM batch jobs (creating and modifying IFB files), to retrieve data from back end for import, export jobs and for record level changes.
- Involved in unit testing, System Testing, Integration testing and Performance testing of the changes affected.
- Taking care of the Job failures, data loads and support during weekends maintenance activities.
- Provided production support and responsible for implementing the enhancements for major releases.
Environment: Siebel 7.5 Sales, SQL Server 2000, MQ-Series, Configuration, Workflows, EIM, EAI, Web Services, FTP and SFTP.
XNA inside Sales Call Center Application Oct 2006 Sep 2007
Client: Confidential, NY
XNAIS Siebel Maintenance & Enhancement project is a maintenance and enhancement project which involves supporting the current Siebel environment, integration with various other environments and enhancing the application as per the client\'s requirements and roll out enhancement release in every quarter. This Siebel Call Center Application, used in Xerox Corporation to help its Sales Representatives to track the Xerox’s Customer details and the future plans like marketing the new products, and follow up the old marketed items and many.
Responsibilities:
- Provided Offshore support to the XNAIS Siebel Application by analyzing the requirements and provided the solutions.
- Reviewed Quality parameters and taken corrective actions on any Quality Issues.
- Interacted with Client and Onsite Team members to review the project progress and to check the status of each issues, risks and Change Requests.
- Requirement Analysis, Coding and Testing.
- Created Shell script for receiving data from the Siebel base tables, using the script, data is moved to the EIM table and the data is archived and purged.
- Created the SQL file for moving the data into the EIM table.
- Created IFB file for purging the data from the table.
Environment: Siebel 6.2.1 Call Center & Tools, Shell Scripting, Unix and Oracle 8
Inbound EAI Testing Tool July 2006 Aug 2006
Client: Confidential,
This was intended to establish Inbound EAI Testing Framework for one of our client. The framework involves the setup of Server, creation of Workflow and Business Services, and usage of the EAI testing tool. This tool is meant for sending Siebel Formatted XML file from the Local System to Siebel Server. This tool invokes a workflow process through a business service method. This tool accepts the XML file from the local system, then passes it to the Siebel Server, receives the response and display it to the user.
Responsibilities:
- Involved in Requirement gathering, designing and testing.
- Created Workflow for receiving XML file from the Local System.
- Created Business Service for copying the XML file from server to the local machine in the text format.
- Developed eScript code to display a message, when the XML file is copied in the server.
- Configured Siebel Server with Named Subsystems in the Server Manager Command Line.
Environment: Siebel 7.5 Client & Tools, eScript and Java
Layout Builder Tool V1.0 March 2006 June 2006
Client: Confidential,
In many CRM engagements Wipro enters the engagement in a role of upgrading old version of Siebel CRM to a new version of Siebel CRM. In some cases it was found that while migrating from Siebel 7.5 or older version to Siebel 7.8, if applet is customized then layout of applet does not retain its original version and position of control goes for toss. The Layout Builder tool is expected to retain layout of applet from previous version with minimum changes.
Responsibilities:
- Involved in Requirement gathering, designing and testing.
- Understanding of Siebel Web Templates and Grid Form Layout.
- Revising algorithms to programmatically adjust the placement of controls in the Grid Layout.
- Analysis of Web Templates, Item Identifiers and their behavior in different versions.
Environment: Siebel 7.5 & 7.8 Web Client and Tools, Visual Basics 6.0