PROFESSIONAL SUMMARY:

• 10 years of experience as Techno - Functional consultant in Oracle E-Business Suite Applications
• Experienced in Oracle E-Business Suite applications R12/11i viz. Quoting, SCM (O2C), Accounts Receivables (AR), General Ledger (GL), Inventory (INV), Trading Community Architecture (TCA) and Customer Relationship Management (CRM)
• Designed and executed several customizations and setups in ERP as a part of Revenue Recognition. Supported various pre and post process programs to manipulate the date as part of AR and GL transaction creation
• Extensive experience in using Trading Community Architecture (TCA) APIs to create/Update parties and relationships
• Lead a complex migration effort from Oracle CRM (Oracle Services) to SFDC. In-depth knowledge about Oracle CRM Install Base and Service Contract
• Customized Order to Cash solutions using OM and AR modules. Migrated the customized solutions built in 11i to standard solutions in R12
• Skilled in creating and maintaining AOL objects, hands-on experience with Oracle Forms/Reports, BI/XML Publisher and Workflow Builder
• Experienced in configuration of critical setups to enable custom validations (form personalization, profile options, processing constraints, and defaulting rules, hold definition, hold sources etc.)
• Involved in the analysis and coordinating DBA for applying the patches released by Oracle to support the OOB functionality in R12
• Strong Oracle PL/SQL programming experience, developing stored procedures, functions, packages etc. Sound understanding of performance tuning of SQL queries.
• Experienced in gathering requirements from stakeholders, designing the functional and technical specifications and ensuring that the functionality is delivered in adherence to these specifications. Worked in both Agile and Waterfall methodologies
• Currently working in production support, coordinating with business users and IT teams to prioritize, plan and resolve production issues within the stipulated SLAs maximizing business value and customer satisfaction
• Good Knowledge on latest Design and Presentation of BI reports using Tableau
• Experienced in SQL Loader, Export and Import and enforcing security by creating roles, granting system and object privileges on the Tables and Stored procedures
• As part of IT support, gained extensive knowledge on the end to end business process, involving from quote creation, deal approvals, ordering, supply chain, item cost setups, pricing setups, global scheduling rules, item setups, invoicing and customized business tools
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi-tier and client/server architectures
• Developed an outstanding relationship with the client and received many accolades for the enthusiasm and commitment shown towards work. Became the SME (Subject Matter Expertise) for resolving high-priority production issues or taking up complex modules that required in-depth knowledge of the system

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Advance PL/SQL

Databases: Oracle 10g, 11g and 12c

Platforms: Windows

Applications: Oracle Applications 11i and R12, AOL

ERP: Oracle ERP R 12, 11i/ 11.5.9/10.7 Order Management (OM), TCA (Trading community Architecture), General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Purchase Order (PO), Inventory (INV), CRM (Teleservice, Service Contracts, Install Base), Application Object Library (AOL), Sys Admin.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Oracle Techno Functional Consultant

Responsibilities :

• Provide Data Analysis on the product as it is sold, its margins, new/repeat customers, Customer profiles and measuring customer success.
• Support System and Training issues on Business Operations - Backlog order Management, Supply Chain (Logistics and Shipping).
• Support Distributors and work with Finance Managers to get valid discounts approved and involved in design of automatic discounts based on the product amount margins.
• Design new fields in the invoice print transaction reports for customers to view the service contract dates as per the current changes.
• Understanding the issues in detail, discussing with various cross track teams to identify the root cause of the problem, offer work-arounds and solutions as needed and ensuring that these are delivered on time while communicating the progress to the business users and leadership team
• Based on the IT case analysis provided, new process changes are brought in to improve the test order processing and Global Scheduling Rules
• Schedule weekly meeting to go over the reported issues and suggest required enhancements and prioritize the issues by providing the frequency of occurrence and estimated monitory impact (gains/losses).
• Customized various reports like Supplier Payment History and Payables aging Report in Oracle Payables; Account Status Report and Trial Balance-Detail Report of Oracle Receivables Module; Print Purchase Order, Encumbrance Detail, Printed Requisitions reports of Oracle Purchasing Module.
• Based on the repeated issues reported and the analysis provided, discuss with UCS Biz and CPE teams on enhancement changes or system fixes and provide them with IT case figures and $ impact to prioritize the issues
• Get a high-level overview of existing and new functionalities and workflows across multiple tracks. This helps to swiftly identify the possible areas that might have caused the issue, if any arise

Environment: Oracle Database 11i, TOAD, E-commerce, SSH Tectia, Microsoft Power Point 2013, and BI Reports

Confidential, San Jose, CA

Oracle EBS Techno-Functional consultant

Responsibilities:

• Worked as techno functional lead in the complex migration of Oracle CRM to SFDC in the onsite-offshore model.
• Developed packages and procedures and table level triggers with new schema to synchronize the customer case creation from SFDC to CRM and vice versa.
• New web services were created to get the customer data from Oracle to SFDC.
• Involved in client meeting and business meetings and handled any last minute changes to the requirements without any hurdle.
• Discuss possible enhancements and gather new requirements to be implemented so as to make sure the system is robust without any issues
• Test the solution that has been implemented before moving to production and get sign offs from the business users
• Documenting the functional solution and reviewing it with all impacted cross track teams and Biz users to ensure that the solution being provided is in-line with the given requirements
• Architected and implemented the Concurrent jobs scheduling (Defined generic users, Special Concurrent managers, association of concurrent managers with users) by partnering with entire IT team and Operations team
• Initiated to conduct formal design reviews with the entire team, which ensured that business requirements got trickled down to various modules and those requirements got incorporated in various integrated modules
• Assisted DBAs on support needs and worked with development teams with loading and extracting data (ETL).Facilitated QA for developing test plans and test cases for unit, system and Enterprise testing.
• Collaborated on the data-mapping document from source-to-target and the data quality assessments for the source data
• Designed PL/SQL package to send mails with attachment to members of specified groups which are defined using Oracle Applications Lookups. 
• Explicitly used Workflow Builder to create Process Notifications and Messages for this implementation
• Defined validations for entering the Customer Profiles, Payment Terms and Payment Methods.
• Brought down the time taken for resolving the generic issues during each test cycle by 25% by documenting the step-by-step process for fixing most of the issues.
• Understood the Cisco Data Bus Process in short spam and developed a bug free code, to transfer the data from one database to another database.
• Customized the complete invoicing process from interface to revenue recognition with respect to Cisco 2-Tier Customers for specific services.

Environment: Oracle Database 11g, TOAD, UNIX, Kintana, PVCS, Quality Center, SSH Tectia and Oracle Reports

Confidential, San Jose

Oracle Technical Developer

Responsibilities:

• Designed the complex technical document for the subscription model items, in implementing the invoice to GL posting.
• Designed new Form to delay the revenue process for subscription SKU's wrt the different distributors, later revenue recognition date is processed, based on delay defined
• If customer wants to cancel the service in the “mid period” then the revenue for the rest of the periods will not be recognized. This revenue recognition process is implemented technically.
• Built a new API in the E-commerce to identify the revenue recognized and the amount yet to be recognized for different accounts.
• Involved in writing backend Packages extensively in PL/SQL. Created, debugged and modified Stored Procedures, Triggers, Tables, Views, User-Defined Functions, Pl/SQL tables, Bulk Binds and Bulk Collect.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards besides reviewing the code.
• Extensively involved in preparing Detailed Technical Documents from the functional specifications.
• Preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Actively Involved in Integration and Deployment in Production Environment.
• Involved in the Designed and extensively worked on Project Documentation.
• Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.
• Co-ordination between Development, Testing and Production teams, attending bridge calls, and technical discussions regarding future developments and releases.
• At offshore, lead the team in getting knowledge transition for new applications from onshore team. At onsite, provided knowledge transitioning to new members joining the team.
• Mentoring ELTs (Entry Level Trainees) on project specific technologies to bring them up-to-speed on the applications

Environment: Oracle Database 11g, TOAD, UNIX, Kintana, PVCS, Quality Center, SSH Tectia and Oracle Reports

Confidential

Application Developer

Responsibilities:

• Designed and build the database with schemas, tables, procedures and functions as per the client requirements.
• Communicated effectively and developed a good relationship with the team in the process of capturing the requirements from FE Java team, based on which the procedures, functions and triggers are created.
• Evaluated the Schedulers concept and implemented about 20 to 30 complex stored procedures for Confidential Blood Bank. Addressed the issues raised and implemented all the change requests with respect to the project.
• Testing (Preparation test plans, test cases). Development of technical Specification Document with respect to requirements.
• Due to cost constraints for the client we have implemented all the procedures, triggers & functions developed in MS SQL SERVER 2005 to MY SQL.

Environment: SQL Server 2005, MY SQL