We provide IT Staff Augmentation Services!

Oracle Developer Resume

2.00/5 (Submit Your Rating)

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.

We'd love your feedback!