SUMMARY

• Over 20 plus years of experience in Information Technology industry working in various roles as a Technical Architect, Team Lead, IT Analyst with Leading Multinational Technology, Manufacturing, Pharmaceuticals and Financial organizations.
• Working with Oracleleading Information Technology for last 10 years in a Customer facing role as a Siebel Architect with experience in Design, Deployment, Integration, Infrastructure Administration, Overall Expertise in Siebel CRM Infrastructural Design and Data Model Architecture and Siebel Administration, Root Cause Analysis and troubleshooting.
• Previous experience included working on Oracle ERP products for 12 years. This included Real time Functional, Development, Customization, Conversion of Manufacturing, Financial, Internet Applications for Oracle Fusion/Oracle Applications 12/11i (11.5.10)/11/10.7 NCA Implementations. Worked on multiple projects related to converting Legacy Mainframe applications to 10.7NCA/11i/12 and 10.7 NCA to 11i Conversions and also to the Fusion environment.
• Worked extensively on Order Management, Inventory, BOM, Account Receivables, Account Payables, General Ledger, and Fixed Assets. Worked on Scheduling Concurrent Reports/SQL based Interfaces and also understands the Error reporting capability for Concurrent runs, Familiar with Apps Schemas/Views related to Applications for easier retrieval for Data.
• Working knowledge of industry standard SDLC methodologies, tools and techniques: Familiar with AIMS methodology for documentation (MD60 - Functions specs/MD70-Technical specs); Conducting End User Interviews to gather software specifications; Design Software Specification document for user review/program development; Presented prototypes of programs and modify specifications based on user feedback; Develop programs based on the specifications; Updated existing documentation to maintain existing programs based on User Requirement Changes.

PROFESSIONAL EXPERIENCE

Senior Siebel Architect

Confidential

Responsibilities:

• Working as a Siebel Enterprise solution Architect for the last 10 years with experience in Design, Deployment, Integration, Infrastructure Administration and Support.
• Job role includes expertise on Analyzing and Migrating to Latest IP2018/IP2017 versions, Siebel Enterprise Servers installation, Automate Release Migration Process. Hands-on experience to design and deploy 24/7 on-call support and maintenance process for Enterprise and Mid-Market production CRM systems. Also provide expertise for Full Migration, Incremental migration and Parallel development on latest versions.
• Assessing Performance Gaps, System Stability analysis with review of Crash/Memory Leaks and providing root cause solutions with documentation related to Script changes, and Memory/CPU parameter recommendations,. Also recommendations and review provided for performance tuning of Siebel components and database connections for maximum performance throughput, optimum response time and High-Availability.
• Enterprise Application Integration solutions using Integration Objects, EAI, EIM and SOA (Service-Oriented Architecture).and implementing Business Process Automation using Siebel Workflows, Business Services, BIM, Assignment Manager and Transport adapters and connectors. Experience in server-side development using eScript, Jscript, JDBC and XML (FIXML).

IT Consultant

Confidential

Responsibilities:

• The need was to have an Application/Database for creating Product/Services Contract related Discounts and repository of all history discount transactions in one place.
• Creating an Approach document for the starter DSSOT database by reviewing the existing systems which had discounts transactions and proposing a new single source system. Review signoff had to be done from boundary Business and IT teams.

IT Consultant

Confidential

Responsibilities:

• The need was to have an Oracle 10G DataWarehouse Database to support Daily reporting and Management need for Finance information based on SAP/R3 transactions.
• Created a document to map SAP/R3 Orders/Invoices/products information to Oracle 10G database.
• Recommended and Implemented Structures based on Current Business Processes.
• Coordinated with Reporting team on training and access related processes.

IT Consultant

Confidential

Responsibilities:

• The need was to update the benefits of the employees from a Legacy system into Oracle Employees.
• Worked on loading benefit information currently in legacy into Oracle HRMS after mapping all the legacy elements to core and custom Oracle benefit elements.
• The need was to have a Web based interface which was allow the customers to enter their Co-op claims and check the status of Claims and get documentation of the claims filed.
• Also Approval/Rejection screens were required for the internal administrator to process the claims. This was achieved by adding an additional menu option to the standard IReceivables menu.
• This portion had Data entry screens, Summary screens, Print confirmation screens, Approval/Rejection screens, and Data modifications screens for Customer budgets.
• The analysis was done on the existing customer Coop claim system, which was manual and then developed using Oracle Web Toolkit, XML, Java, J2EE, PL/SQL, EJB, JSP, LOB data type’s components.
• The need was to collect history data from the existing Oracle OLTP system to a Data warehouse database.
• This was achieved by using Oracle Datamart, and ETL process.
• The need was to have custom Hierarchy for Approving Purchase Orders and email the appropriate approval levels with custom messages.
• This was achieved was customizing the PO Approval Workflow and giving custom messages to the user when they login into PO responsibility.
• The need was to have a batch method to load suppliers in Account payables.
• Developed a Vendor interface program to import vendors in a batch mode. This program would allow the AP user to see the supplier in Oracle AP and allowed users to transact for Purchasing and Payables.
• The need was to have a Web based interface which was allow the customers to enter their Labor Claims and check the status of Claims and get documentation of the file filed.
• The analysis was done on the existing Labor claim system, which was manual and then developed using Oracle Web Toolkit, XML, Java, J2EE, PL/SQL, EJB, JSP, LOB data type’s components.
• The client had multiple needs to enhance the standard Invoice /Account summary page.
• Display discounts which the customer has taken.
• Adding buttons for additional Invoice checks (Reconciliation).

IT Consultant

Confidential

Responsibilities:

• Worked on identifying data considered to be bad in the system because of missing child/parent links. Coordinated with development team for coding and with business users for verification
• Coordinated in restoring a Purge/Archive which had stopped running in production. Analyzed existing code and dependencies identified the amount of data lost in the Archive database and coordinated with DBA for restoration of data from tape backups.
• Analyzed Cisco internal programs for Order migration and documented modifications in standard Oracle import program to be used for validation and importing orders.