Oracle Developer Resume
SUMMARY OF QUALIFICATIONS
- Customer Relationship Management (CRM) expert with over 9 years of experience creating and implementing eBusiness solutions utilizing Siebel products.
- Demonstrated proficiency in diverse facets of business analysis, including Business Process Mapping, Technical Architecture, Workflow Analysis, and eCommunication solutions.
- Extensive experience with Siebel applications and verticals, including Server Administration, Sales Automation, Call Center, Workflow Manager, Order Manager, and Marketing Applications.
- Background managing all aspects of project lifecycle in wide range of organizations.
- Excellent computer skills, with expertise in Oracle, MS SQL Server, and other databases.
- Goal-oriented team leader adept at building strong relationships with coworkers and clientele.
TECHNICAL SKILLS
Applications:
Siebel 8.0/7.8/7.5, eCommunication, Consumer Goods, Sales, Marketing, Tools, Configuration, EAI, VB, eScript; MS Office Suite
Server Components:
Workflow Manager, Communications Manager, MQ Series Server Adapter
Web Technologies:
VB Script, Java Script
Languages:
C, C++, Visual Basic (VB), eScript, Oracle PL/SQL, HTML, XML
Databases:
Oracle 10G/9i/8.0, MS SQL Server7.0, MS Access
Operating Systems:
Windows 2000/NT/XP, DOS, UNIX
PROFESSIONAL EXPERIENCE
Responsibilities:
- Created the Functional Specification Documents/Software Requirement Specifications from the Business Requirements Document
- Created the Requirements Traceability Matrix which map the Business and Functional Requirements
- Created Scope Document, Vision Document for multiple projects
- Hired resources for multiple projects
- Involved in scheduling projects and assigning various tasks to resources
- Collaborated directly with business units to assess the technical impact of business requirements and to reach consensus on alternative solutions
- Allocated resources to various modules of the projects
- Coordinated between the technical teams to get some issues sorted
- Created Technical documentation
- Created user manuals/training documents for many modules
- Performed budget analysis and budget forecasting for multiple projects
- Extensive usage of Enterprise Data Warehouse to test and analyze the data and also to perform data mining
- Used Informatica for ETL
- Created many stored procedures that ensured the successful completion of nightly batch jobs.
- Involved in performance tuning of Oracle instances
- Documented meeting minutes during various JAD sessions
- Detected many severity one issues and resolved them before being detected by conventional tools
Application: Siebel 8.0, eCommunications
Configuration: EAI, eScript, workflows, web services, Screens, Views, Applets, BC, BO, VBC, Picklists, MVG,Pick Applets
Server Components: Workflow Process Manager, MQ Series Server Adapter
Databases: Oracle 10G
Operating System: Windows NT
Project Architect Feb 2006 – Sep 2007
Confidential
Responsibilities:
- Created the Functional Specification Documents/Software Requirement Specifications from the Business Requirements Document
- Created the Requirements Traceability Matrix which map the Business and Functional Requirements
- Hired resources for multiple projects
- Involved in scheduling projects and assigning various tasks to resources
- Designing and implementing the framework of a technical infrastructure translating functional requirements into systems specifications
- Designed, built, and tested core Siebel applications
- Extensively worked in configuring workflows, server components like siebel MQ adapters, dispatch services, eScripts and web services and Siebel EAI.
- Configured Business Objects, Business Components, Applets, Views, Screens , Pick Lists, Multi Value Groups in Siebel tools
- Configuration using State Models, User Properties and e-Scripting
- Developed Automation Scripts/Code to automate various business scenarios.
- Performed integration of automation scripts with the Test Management Repository, Test Director and also implemented source control using Visual Source Safe.
- Involved in SIT (System Integration Testing) and E2E (End to End testing).
- Involved in application tuning.
Application: Siebel 7.7.2 eCommunications
Configuration: EAI, eScript, Tools, Screens, Views, Applets, BC, BO, VBC, Picklists, MVG,Pick Applets, Product Configuration using eConfigurator
Server Components: Workflow Process Manager, MQ Series Server Adapter
Databases: Oracle 9i
Operating System: UNIX
Module Lead Jan 2006 – Feb 2006
Confidential
Responsibilities:
- This was an upgrade project which involved an up gradation from 6.3 to 7.7
- Analysis of Scripts at Applet, Business Component, Application and Business Service level to enable the business logic to remain the same after upgrade.
- Helped in preparing HLDs for Order Management.
Application: Siebel 6.3, 7.7 eCommunications
Configuration: eScript, Tools, Screens, Views, Applets, BC, BO, VBC, Picklists, MVG, Pick Applets
Databases: Oracle 8i, 9i
Operating System: Windows NT
Project Lead Jan 2005 – Jan 2006
Confidential
Responsibilities:
- Involved in configuration, scripting related issues at all three level i.e. User Interface, Business layer, Data layer.)
- Configured business objects, applets, views, screens, and adapt business components, fields, joins, links, business component user properties, drilldowns, and visibility configuration using Siebel Tools
- Set multi-value links, joins, user properties, and pick-lists (dynamic and static)
- Maintain the Siebel Database objects like tables, columns, relationships (1:1, 1:M and M:M), extension tables, and extension columns
- Add, modify, and delete pre-defined queries(PDQ’s)
- Prepared Test Cases, Release Notes and updated Low Level Design Documents.
- Extensively involved in eScripts in various modules.
Application: Siebel 7.5.3 eConsumer Goods
Configuration: eScript, Tools, Screens, Views, Applets, BC, BO, VBC, Picklists, MVG, Pick Applets
Databases: Oracle 9i
Operating System: Windows NT
Project Lead Apr 2004 – Jan 2005
Confidential
Responsibilities:
- Configured business objects, applets, views, screens, and adapt business components, fields, joins, links, business component user properties, drilldowns, and visibility configuration using Siebel Tools
- Worked on the design and development of workflows to implement eMail Response functionality in Siebel.
- Configured Assignment Manager rules for automatic assignment of trouble tickets to IAMS Work force.
Application: Siebel 7.5.3 Call Center
Configuration: eScript, Tools, Screens, Views, Applets, BC, BO, VBC, Picklists, MVG, Pick Applets
Databases: Oracle 9i
Server Components: Communications Outbound Manager, Workflow Process Manager
Operating System: Windows NT
Module Lead Aug 2003 – Apr 2004
Confidential
Responsibilities:
- Design and Development of the ITA Out bounds team which aimed at updating of data Real-time. Sales and inventory data will provide clients and other integrated applications with more effective/accurate liability ownership, increased guest satisfaction and improved vendor relations
- Involved in the design and development of COBOL programs and maintenance of DB2 tables.
Configuration: COBOL programs, JCL
Databases: DB2
Operating System: MVS
Module Lead
Confidential Jan 2003 – Aug 2003
Responsibilities:
- Design and Development of the Fraud Database which aimed at creation of a Systematic approach to manage fraudulent usage of its In-house Credit cards.
- Involved in the design and development of COBOL programs, stored procedures and maintenance of DB2 tables.
Configuration: COBOL programs, JCL
Databases: DB2
Operating System: MVS
Module Lead Apr 2001 – Jan 2003
Confidential
Responsibilities:
- I was involved with all the enhancements, and handled on call support for all the applications and subsystems of Plan One.
- Besides I also had to co-ordinate the work distribution between offshore and on-site.
- Involved in the development of COBOL programs, maintenance of VSAM files, GDG\'s.
Configuration: COBOL programs, JCL
Databases: DB2
File System VSAM
Operating System: MVS
Configuration Management Panvalet, CMN
Module Lead Nov 1999 – Apr 2001
Confidential
Responsibilities:
- I was involved with development of the Customer Marketing History Database which houses information of the spending habits of all the AMEX credit card customers.
- Involved with the creation of COBOL programs to maintain 12 months of customer spending details in the DB2 tables.
Configuration: COBOL programs, JCL
Databases: DB2
Operating System: MVS
EDUCATION
B.E – Electrical and Electronics
AWARDS / RECOGNITION
- Honoured with the TCS Hats Off award which recognises the high performers
- Honoured with the Excellent Team Player award for successfully interacting with all the stake holders for the WLR3 Implementation
PROFESSIONAL TRAINING
- Siebel eCommunications and Product Configuration training from Oracle.
- EAI at TCS
- Siebel Essentials – Configuration, Scripting, Workflows and EIM (Internal) at TCS.