SUMMARY:

• 8+ of experience in Design, Development and testing in enterprise Siebel e - Business Applications like Siebel Sales, Call Center, Field Service, e-Communication, Utilities etc.
• Expert in Design, Development and Testing of Siebel Applications in the areas of Configuration, Scripting, Workflows, EIM, and EAI.
• Experienced in full Software Development Life Cycle (SDLC) including System Analysis, User Requirements Determination, Data modeling, Coding, Implementation and Testing. Also Worked in Agile Methodology
• Experience in developing complex workflows for third party integration with Siebel EAI.
• Experience in configuring Applet, Business Components, Business Service, e-script, VB Script, Joins, Links, MVG, MVL, Pick Applets, Toggle Applets and User Properties.
• Experience in developing Runtime Events, Data Validation, eMail Integration, Symbolic URLs
• Experience in developing Workflows to handle the automatic business process such as sending an email on activity creation by Workflow Policies.
• Experience in developing and configuring Integration Objects (IO) and Integration Components (IC).
• Experience in developing IO maps and EAI Value Maps.
• Experience in using Siebel EAI HTTP Adapter, EAI Siebel Adapter, EAI XML Converter for Integration.
• Experience in developing VBC and VBC Applets to display the external data in Siebel Screens.
• Experience in writing complex queries & Stored Procedures using SQL.
• Experience in developing PL/SQL Procedures for data load and running IFB files.
• Experience is writing Unix Shell Scripts to load the data from a CSV/Test files and run the PL/SQL procedure to load the EIM tables.
• Experience in running the Window Batch files to run the IFB files for EIM upload.
• Handled a large EIM load during the Year Ending Accounts and Opportunity Sync with third party systems
• Experience in working with Business Analysts and Business Users to understand their requirements and provide simple optimized solution with less no of user steps. And also giving demos on application functionalities.
• Experience in preparing the Technical Specification, Deployment Plans and Production deployment support.
• Highly organized and dedicated, with a positive attitude and thrive on working in a challenging environment.
• Strongly self-motivated, willing to take responsibilities and can work independently or in a team environment.
• Good command on Oracle 9i and Oracle 10g for writing SQL Queries, Triggers and Stored Procedures.
• Experience to work as a Module Lead/ Technology Lead/ Architect and to manage team of 10+ members.
• Worked in a Onsite and Offshore model and with people of different time zones.
• Being a Technical reviewer for all the deliverables Requirements, Design documents, Coding, Test Specifications

SOFTWARE SKILLS:

Programming Languages: C, C++, Java, XML, HTML, CSS

Scripting Languages: JavaScript, VB Script, UNIX Shell Scripting.

Operating Systems: Windows 2000/XP/2003/7/8, LINUX.

Databases: Oracle 9i, Oracle 10g.

Packages/Tools: SQL, PL/SQL, MS-Office, Siebel Tools

EXPERIENCE:

Confidential, Shelton, CT

Siebel Technical Lead

Environment: Siebel 7.5.3, Oracle9i, Actuate

Responsibilities:

• Discussed with Business Analysts on all the upcoming requirements on regular basis.
• Prepared the Functional and Technical Design Documents.
• Design and provide technical solutions to all the new requirements.
• Handle and Help the Offshore team technically and functionally during the development phase
• Monitoring the Remedy Tickets (Issue raised by Business and users) on regular basis.
• Analyze and provide the resolutions for the tickets raised by the customer in Remedy
• Handling the outage calls. Coordinating with other towers and vendors to resolve the critical production issues.
• Participate in requirement walk-through and model the requirements to technical specifications.
• Participate in QA test case walk-thorough and providing QA support and defect fixes.
• Provide demos to Production Support teams, Business Analysts and Users.
• Deploying the application in DEV and QA environments and providing the deployment support for UAT and PROD environments.

Confidential, Chicago, IL

Siebel Technical Lead

Environment: Siebel 8.1.1, Oracle10g

Responsibilities:

• Discuss the Work Requests Submitted by the Business and provide Technical solutions.
• Participate in all the Daily Stand-Up Meetings.
• Worked On few Integrations Requirements like Adding new Fields to VBC, created a new Integration to public website.
• Created Workflows to send and receive data from the external systems by invoking ESB Web Services and display them on VBC Applets
• Worked on few very complex VBC requirements.
• Working on a Agile methodology, spited the requirements into tasks and completed them in time without any delay.
• User acceptance test specification is reviewed with business clients to get sign off.
• Co-ordinate and mentor the team to prepare the design document and review of the same.
• Co-ordinate and mentor the team to code as per the design and review of the code.
• Co-ordinate and mentor the team to prepare the test specification (System and Unit).
• Prepare traceability matrix to make sure all business requirements are tracked down i.e., Requirement - Design - coding and test cases.
• Plan and schedule milestone for execution of the tasks following the Agile Methodology.
• Utilized Rational Clear case tool for managing code and documents for source code control for version control.

Confidential

Onsite Coordinator, Design Analyst, Senior Developer

Environment: Siebel 8.1.1, Oracle10g

Responsibilities:

• Discuss with Client on all the requirements on regular basis.
• Participated in all the Design Workshops.
• Prepared the Data Model Design Document of Siebel. Prepared the Attribute Sheet of all the Siebel Entities.
• Coordinated and collected all the LOV’s required for the Project.
• Discussed and closed all the Data Mapping Documents with Client.
• Prepared the Functional and Technical Design Documents of the Entities like Account Creation, Account Modification, Customer Identification, Service Request and Query Handling
• Developed some critical requirements like Access Matrix and delivered.
• Created Workflows to send and receive data from the external systems by invoking ESB Web Services.
• Prepared and executed batch scripts to fix some critical issues during the production Go Live time.
• Prepared all the Test Cases for the requirements developed.
• Coordinating with Offshore team in clarifying and developing the requirements during the Development phase.
• Resolved some of the critical defects during the SIT and UAT Phases.
• Resolving some of the Production Defects after Go Live.
• Supporting Phase 1.1 in requirements gathering and clarifications.
• Provide demos to Business Analysts and Users during Design and Development phase
• Prepare traceability matrix to make sure all business requirements are tracked down i.e., Requirement - Design - coding and test cases.
• Review activity using Checklist as per the CMMI L5 process i.e., for requirement document, design document, coding and test specifications.
• Review process of Code would involve following coding standard document which includes variable scoping, naming conventions, Formatting, Code Commenting, Flow Control, Event and Delegate usage, Exception Handling, Best Programming Practice, Language Usage and many more standardization practices.

Confidential, Stamford

Siebel Senior Developer

Environment: Siebel 7.5.3, Oracle9i, Actuate

Responsibilities:

• Discussing with the Client on the requirement on regular basis.
• Involved in the Requirement Analysis, Design and development of the interface.
• Mentor the team member for the configuration UI changes of the project.
• Created Workflows to send and receive data to the external systems using HTTP Transport.
• Created Integration Test Scripts for the Interface.
• Created new BC,BO and IO’s as per the requirement
• Modified the PL/SQL procedure for the batch interface.
• Modified the script at various levels to satisfy the validations of the requirements
• Develop solution leveraging TDD process using Unit Test Framework.
• Gather requirements and document technical specifications.
• Review activity using Checklist as per the CMMI L5 process i.e., for requirement document, design document, coding and test specifications.
• Review process of Code would involve following coding standard document which includes variable scoping, naming conventions, Formatting, Code Commenting, Flow Control, Event and Delegate usage, Exception Handling, Best Programming Practice, Language Usage and many more standardization practices.

Confidential

Siebel Technical Developer

Environment: Siebel 7.5.3, Oracle9i, Actuate

Responsibilities:

• Discuss with the Onsite coordinator for the new requirements.
• Modified and Created new Applets, BCs as per the requirement.
• Created Static and dynamic Pick lists and MVG.
• Created Joins, links and Multi value links to achieve the requirement.
• Extensively worked on the EIM for the data loads.
• EIM work includes creation and modifications of the Control Files (to Load the data into EIM and Staging tables) and IFB Files.
• Supporting the application by resolving the tickets raised by the users.
• Provided the non-srf quick fixes for the tickets raised by the user.
• Created new SQL procedure required for the EIM validations.
• Created the Unix Shell scripts for the batch jobs.
• Extended the Base tables and EIM table for the EIM requirements.
• Importing the SIF’s into the Development server.
• Compiling the changes into the SRF and replacing the SRF.
• Created the Unit and System test cases for the enhancements.
• Modified Reports and fixed Report Issues
• Reflecting the Siebel data into the Verint ULTRA portal which is a speech analytics system.
• Customized the script in the BC level in the various BCs.
• Customized the business services using Siebel VB script to achieve the functionality of Verint integration.
• Prepared and executed the UTC and STC.
• Raised the defects in the Clear Quest.
• Prepared, updated and Executed the RT scripts in the RMT ( IBM Rational Manager)
• Helped the business team during the UAT.

Confidential

Siebel Offshore Technical Developer

Environment: Siebel 7.5.3, Oracle9i, Actuate

Responsibilities:

• Discuss with the Onsite coordinator for the new requirements.
• Monitor the Remedy Tickets on regular basis.
• Analyze and provide the resolutions for the tickets raised by the customer in Remedy.
• Created and tested the PDQ’s as per the business requests.
• Modify the scripts at BC level to fix the production issues.
• Worked on EIM to fix the production data issues raised by the users.
• EIM work includes creation and modifications of the Control Files (to Load the data into EIM and Staging tables).
• Provided the non-srf quick fixes for the tickets raised by the user.
• Created new SQL procedure required for the EIM validations.
• Compiling the changes into the SRF and replacing the SRF.
• Modified Reports and fixed Report Issues
• Monitoring the Jobs which handles the millions records every day of client services and its transactions.