SUMMARY:

• Over Ten years of IT experience including 7 years of Oracle CRM / TCA / TeleSales / Customer Care / Order Management / Advance Pricing / Manufacturing / Distribution / Supply Chain Applications Implementation Experience.
• Enrich experience as ERP analyst, software designing, analyzing, configuring, setups, testing, GAP analysis, upgrade, development, delivery and deployment in supply chain, manufacturing and service industries.
• Extensive exposure in ERP implementation using Oracle Applications (through 10.7 - 11.5.10 ) comprising functional areas in CRM, TCA, Customer Data Hub (CDH) and Data Quality Management (DQM), Master Data Management(MDM), Order Management, Oracle Inventory, Oracle Purchasing and Oracle iProcurement.
• Experience in Business Requirements gathering, GAP Analysis, Test Plan Preparation, Unit Testing, Functional Architecture, System Integration testing, UAT.
• Configuring the application based on solution design, performed gap analysis and designed workaround solutions. Excellent knowledge on Functional Analysis and Implementation, Functional analysis on Interfaces/Legacy conversions, Views, Reports.
• Training the client’s Super Users and Users on the application and conducting pilot testing, integrated testing, design validation and setups of the Distribution ERP application.
• Functional documentation for Configurations (Setups), User Training Documents and Customization Documents.
• Exposure to preparation of high-level functional design documents like AIM docs for forms, reports extensions, CV docs of Conversion from Legacy systems to Oracle Applications.
• Experience in writing SQL scripts and extensively used TOAD and SQL Navigator during Implementation and Support.
• Experience in Functional Designing of Oracle Reports & Discoverer reports.
• Vast experience in using Metalink. Worked extensively on Oracle TAR’s via Metalink. Also assisted the R11i technical teams through various CRP’s stages, provided guidance in the development of customizations and interfaces to suffice business requirements, supported and resolved problems during systems integration tests, and assisted in planning production migration tasks.
• Has technical knowledge, which gives an edge over others to understand the problem, process flow better and troubleshoot it fast and work with Oracle efficiently.

TECHNICAL SKILLS:

Operating Systems: Windows (9x, NT, 2000, XP), RedHat 9, UNIX, and MS-DOS

Applications: Oracle Applications 11.5.x, 11.0.3, 10.7

Modules: Accounts Receivables, Accounts Payables, Cash Management, Order To Cash, Order Management, Inventory, Purchasing, Shipping Execution(WSH) and CRM (TCA, Trade Management, AMS, Install base, CDH, DQM) along with System Administration and AOL.

FrontEnd Tools: OWB, Developer 2000, Forms 6i, Reports 6i & SQL * Loader.

RDBMS & Tools: Oracle 9i/ 8i / 7.x (stored procedures, triggers, functions and packages), Toad and Sql Navigator, ITG Kintana, ClearCase and WinCVS.

Reporting Tools: Oracle Discoverer 10g/9i/4i/3i.

Data Modeling Tools: ERWIN, MDM, Dataflux.

Languages: JavaScript, VBScript, HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential

Functional Analyst/Sub-Architect

Responsibilities:

• Assist business in definining functional and non-functional requirements.
• Work with team to map functional requirements to technical requirements.
• Mobilization - Work on mobilization initiatives to access technical changes to application and risks, document options analysis and high level effort estimates.
• Review estimates with Delivery Manager.
• Analyze and document the Service Incidents, suggesting the new solutions based on the Incidents, thus minimizing the numbers of Incidents faced by technical resources.
• Resolving the Customer Care Applications issues related to Customer Care, Oracle Telephony, Oracle Softphone, CT Connect Server, Right Fax Server.
• Working jointly with Application Production Manager to maintain environment map for Application platform.
• Act as a mentor for Application Support Team.
• Participation in Industry Forums related to Energy & Utilities industries.
• Identifying and separating Business configuration tasks from IT Configurations/customizations and guiding Business on new functionality available within the Vendor Product.
• Steam-lining the Customer Data Hub between Oracle Applications & its Spokes, using CIM Industry standards.
• Primary expert on the technology and products used for Oracle CRM, IVR & Bill Presentment solutions.
• Defining new solutions with Solution Architects within the IT domain and defining new Technology plans as part of IT Strategy.

Environment: Oracle Applications 11.5.10, WebMethods 6.5, Oracle Telephony. CTI, RightFax. Modules: TeleSales, UWQ (Media Items), TCA, Customer Care Application, CRM Foundation, Install Base, AIM.

Confidential,Santa Clara, CA

Techno-Functional Consultant

• Involved in the Solution Designing for new Deployments at Confidential .
• Worked with Cross Functional teams to integrate the process flow from Customer Creation to Service Contracts to Order Management to Invoicing.
• Assist program/project managers lead broad-based/cross functional changes to implement the operational aspect of a new (or modified) service program, with a focus on optimizing efficiency and increasing customer satisfaction. Come up with recommendations to support the program requirements by deep diving in process or system areas
• Assist with increasing adoption and awareness of new programs within EBS by providing support on resolving sub-optimal operational processes/systems/policy. Educate and document the operational components of these launched programs. Provide feedback into future foundational systems on specific detailed requirements.
• Defining the Customer Data Hub & Spoke systems and processes.
• Involved in defining Business Processes for Service Contracts, Quoting and Opportunity Management.
• Involved in defining Business Processes for doing Party & Account Merges.
• Involved in defining Business Processes for de-dup of Parties, locations and Contacts.
• Defining Relationships for various usages of Customers for different types of deals
• Defining 3rd Party Adapters for Duns & Bradstreet for DUNS & SIC Codes.
• Identifying the Business events related to inserts and updates of Parties, locations, Org Contacts and Contact Point entities.
• Capture & document business requirements and identifying Gaps.
• Responsible for identifying opportunities for process improvement & optimization.
• Gathering requirements and defining logic for Siebel Customer Conversion. Writing CV40 and test scripts for verifying the Conversion.
• Supporting teams for Customer conversion attached to Siebel and Web-desk Quotes.
• Defining Source Systems and profile options for DQM jobs.
• Defining logic and identifying gaps for Siebel to TCA and TCA to Siebel Interfaces. Writing MD50s for inbound and outbound interfaces.
• Pre & Post Go-live support for Customers (TCA), Install Base and Service Contracts Modules.
• Defining Recon Reports for Customers conversions, including all the Customer attributes at various levels.

Confidential,Hartford, CT

Techno-Functional Consultant

• Configured the new party relationships effectively, so that they can be used in the Quotes, Contracts and parent-child account management. This process involved the creation of new relationship type, relationship phrases, relationship roles, and relationship groups.
• Defined the Attributes to be used by the DQM Matching Rules. Defined the Weightage on the transformations (Exact & Cleanse) for DQM process.
• Configuring and cleaning the Custom Party Relationship Types using customers online.
• Interaction with Party Validation Team (End users) and discussed about the enhancements they requested in the system
• Functional Specification for ADVO TCA Relationships cleanup and creating correct relations and roles based on the business requirements (These programs involve importing legacy data, cleansing and process using TCA API)
• Functional Specification for ADVO TCA Customers Accounts cleanup
• Functional Specification for ADVO TCA Client Service Managers cleanup which consists of deactivating the parties, relationships, roles and creating correct parties, relationships and roles.
• Interacted with Sales Compensation users and collected the requirements, functional specification, Technical Design, Build, Unit testing for a program which identifies all the orders where sales person is invalid. This program helped Sales Compensation team for calculating the correct incentives.
• Designed and delivered the reports, which display the Customer Accounts with Inactive Roles related to CS Rep and Managers and Suspect Parties
• Extensively used the TCA API for uploading/correcting the party, account and sales rep’s information.
• Writing Functional Specifications MD.050 for using Oracle Applications API’s to convert the data into HZ Parties, HZ Cust Accounts, Cust Sites, and Cust Site Uses. Did the same for Employees, Addresses, Phones, Assignments & Contacts tables.
• Writing Functional Specifications MD.050 for Converting Sales Data from Legacy System into CRM Sales & Marketing using standard Oracle API’s.

Environment: Oracle Applications 11.5.10. Modules: TCA, Order Management, Advanced Pricing, Sales Online, Sales Contracts and Install Base, AIM.

Confidential,Keene, NH

Supply Chain /Business Intelligence Consultant

• Review of the existing business processes in the different operations of the Organization.
• Carrying out requirement analysis to identify the major business processes for various operations.
• Carrying out a mapping with Oracle Inventory, Oracle Purchasing and Oracle Order Management to identify the gaps.
• Preparation of functional design documents for bespoke development including:
• Design of forms for additional functionality with detailed validations
• Interface design
• Reports with layout and data mapping.
• Preparation of a detailed Solution Design including the additional functionality through bespoke developments and presentation of the same to the implementation core group.
• Presentation of the Solution Design to the Core User Group for obtaining their concurrence for the business process flows.
• Customization of Uniform Requisition Module specific to Confidential .
• Managing the team of core business users for System Acceptance Testing for Core Applications as well as the bespoke development.
• Carrying out migration activities for go-live of Bill of Materials module.
• Set up of Order Management with Order Cycles, Order Types, RMA Types, Price List Setup and Shipping Methods etc.,
• Modifier & Qualifier Setup for Freight Charges.
• Configurator Setup for Sub Assembly Items.
• Functional Design for Discoverer 4i Reports related to Shipments, Deliveries, Customers, Items and Orders including developing of Business Areas.
• User Training.

Environment: Oracle Applications 11i(MSC, MSD, OM, INV, BOM, WIP & TCA).

Confidential,Hartford, CT

Techno-Functional Applications Consultant

• Primarily responsible for Preparing Functional and technical Requirement Specifications based on the Business Requirement Documents.
• Responsible for Developing Functional specifications and Technical specifications for OPE Operational Reports.
• Developed Oracle Reports for various stages of Order Process and Execution, including Inventory and Invoicing.
• Gathering the specs and preparing the technical specs for new reports.
• Generated the extract report for the Price List changes in different organization.
• Conversions of legacy sales orders utilizing Data Loader Professional
• Analyzing, designing, and formatting data related to conversion and reporting

Environment: Oracle Applications 11i(OM, INV, Install Base & TCA).

Confidential,Pittsburgh, PA

Applications /Data Warehouse Consultant

• Functional Consultant for the Rapid implementation of Oracle 11i (Oracle Order Management, Oracle Purchasing and Oracle Inventory).
• Current state and future state analysis for Oracle Order Management, Oracle Purchasing, Oracle Cost Management and Oracle Inventory.
• Designed the entire tasks needed for implementing Oracle Order Management, Oracle Purchasing and Oracle Inventory on Oracle 11i.
• Set-up Oracle Purchasing, Oracle Order Management and Oracle Inventory on Oracle 11i new install.
• Designed and implemented complex Approval and Positional Hierarchy in Purchasing. Approval process varies to 5 different layers and categorized by product family.
• Implemented RFQ’s, Requisitions (creation and approval), Purchase Orders (Standard/ Blanket/ Releases) and Receiving (3/4 way matching, Direct Receipts, Inspection for Returns).
• Implemented Standard costing with multiple sub-elements as well detail variance capture.
• Successfully implemented Order Management (Stock and sale, Drop Shipments, Advance Replacement and Internal Orders) using workflow and Shipping (Trip and Contained Management). Used complex formulae for doing advanced pricing calculation.
• Successfully implemented the Auto-Invoice in Oracle AR as well Inventory Interface for Inventory control from Order Management. Costing entries properly designed for COG’s and Sales Accounting.
• Successfully did two CRP’s for Modular and Integrated testing of Oracle Purchasing, Oracle Order Management and Oracle Inventory.
• Responsible for documentation of the Requirement, Process flows, Set-up documentation (Oracle AIM Methodology) and Training Materials.

Environment: Oracle Applications 11.5.6. Modules: Oracle Inventory, Oracle Purchasing and Oracle Order Management .

Confidential,Midway, IL

Technical Consultant

• Writing MD50 and MD70 document for the business requirement. Comprehensive Documentation of the work carried out.
• Involved in the review process of all the documents and code.
• Writing SQL*LOADER programs to dump the data from Excel sheet into the Staging tables.
• Writing Programs using Oracle Applications API’s to convert the data into HZ Parties, HZ Cust Accounts, Cust Sites, and Cust Site Uses. Did the same for Employees, Addresses, Phones, Assignments & Contacts tables.
• Interacting with business and developers in the process of testing the process.
• Also involved in creating Test documents for all the environments.
• Converting Sales Data from Legacy System into CRM Sales & Marketing using standard Oracle API’s.

Environment: Oracle Applications 11i, Oracle 9i, PL/SQL Server Pages, TOAD.

Confidential,Federal Way, WA

Technical Consultant

• Supporting the Business users in fixing any issues related with Oracle Applications. Worked in business team in response center. Interacting with business and understand the business requirements. Aggressively worked on Accounts Receivables, Inventory and Order Management and many other modules.
• Writing MD50 and MD70 document for the business requirement. Comprehensive Documentation of the work carried out.
• Also worked with Development Team in India for doing the transition of work to India Development Center.
• Involved in the review process of all the documents and code.
• Writing programs to updates data using Oracle Applications API’s and also writing wrapper program for calling API's.
• Data cleaning of large volume, taking into consideration the performance issues.
• Interacting with business and developers in the process of testing the process.
• Worked as a Core Team Member on AR, CRM (Install Base, TCA, Sales) and Web Reports.
• Core member for customizing the Party Merge & Customer Merge. Confidential has added many customizations to the extent that Standard Merge procedure fails to merge all the respective parties/accounts. Identified all the objects which needs to copied/merged following the standard Merge. Wrote the code to extend the Standard Customer Merge. Also managed the Party Merge Dictionary. Removed few of the entries from Dictionary which were causing the Party Merge to run for a longer period of time. Also Managed TARs caused by Standard Party & Customer merge. Developed additional tables to store the Merge history. And wrote triggers on standard tables to populate the custom tables.
• Developed PL/SQL Server Pages (PSP) for web reporting. Wrote the wrapper functions on HTP package to create customized packages for web reporting. Now other developers just pass the SQL statement with parameters, so that they need not worry about HTP package.
• Conversion of Employee, Addresses, Phones, Assignments, Salary, Contacts, Contact Addresses, Contact Phones data using standard Oracle API’s. Confidential buys the Data (prospects) from third party. This data has to be imported into standard TCA tables.
• Converting Sales Data from Legacy System into CRM Sales & Marketing using standard Oracle API’s.
• Also involved in creating Test documents for all the environments.

Environment: Oracle Applications 11i, Oracle 9i, PL/SQL Server Pages, TOAD.

Confidential, NJ

Technical Consultant

• Supporting the Business users in fixing any issues related with Oracle Applications. Worked in business team in response center. Interacting with business and understand the business requirements. Aggressively worked on Accounts Receivables, Inventory and Order Management and many other modules.
• Writing MD50 and MD70 document for the business requirement. Comprehensive Documentation of the work carried out.
• Also worked with Development Team in India for doing the transition of work to India Development Center.
• Involved in the review process of all the documents and code.
• Writing programs to updates data using Oracle Applications API’s and also writing wrapper program for calling API's.
• Data cleaning of large volume, taking into consideration the performance issues.
• Interacting with business and developers in the process of testing the process.
• Worked as a Core Team Member on AR, CRM (Install Base, TCA, Sales) and Web Reports.
• Core member for customizing the Party Merge & Customer Merge. Confidential has added many customizations to the extent that Standard Merge procedure fails to merge all the respective parties/accounts. Identified all the objects which needs to copied/merged following the standard Merge. Wrote the code to extend the Standard Customer Merge. Also managed the Party Merge Dictionary. Removed few of the entries from Dictionary which were causing the Party Merge to run for a longer period of time. Also Managed TARs caused by Standard Party & Customer merge. Developed additional tables to store the Merge history. And wrote triggers on standard tables to populate the custom tables.
• Developed PL/SQL Server Pages (PSP) for web reporting. Wrote the wrapper functions on HTP package to create customized packages for web reporting. Now other developers just pass the SQL statement with parameters, so that they need not worry about HTP package.
• Conversion of Employee, Addresses, Phones, Assignments, Salary, Contacts, Contact Addresses, Contact Phones data using standard Oracle API’s. Confidential buys the Data (prospects) from third party. This data has to be imported into standard TCA tables.
• Converting Sales Data from Legacy System into CRM Sales & Marketing using standard Oracle API’s.
• Also involved in creating Test documents for all the environments.

Environment: Oracle Applications 11i, Oracle 9i, PL/SQL Server Pages, TOAD.

Confidential,Fremont CA.

Applications Consultant.

• Involved in integrating third party WMS (Warehouse Management Systems) viz., USCO and E-Stamp to integrate with Oracle OE/OM and Shipping Modules.
• Extended the standard Oracle APIs for populating the TCA tables. Developed Discoverer reports for reporting on Oracle data warehouses (both Financials and external).
• Implemented system on HPUX, Web servers and PC clients and involved in designing, writing and testing Forms, Reports, SQL Plus, P/L SQL and Unix shell scripts for modifications, customizations and enhancements of the Oracle base system. These included two-way interfaces to legacy systems, data conversion and transfer using UNIX scripts and SQL Loader.
• Created new and modified custom forms, reports, menus, packages, procedures, SQL scripts, APIs, PL/SQL and Unix shell scripts as well as System Administration. Used PVCS to migrate modifications. Used Forms 6i/4.5/2.3, Reports 6i/2.5/2.3, TOAD and other SQL tools.
• Did system set up/system administration and installation for customizations using Oracle approved customization processes. Monitored TARS and worked with Oracle support on TARs, patches and upgrades.
• Developed Optio based Canadian Invoice and pack slip. Involved in devising test strategy for various modules of Oracle Applications and to prepare detailed test plans / test cases. To prepare test data and execute test cases and also helped in documenting test results and track defects.
• Developed interface programs to import Orders from Legacy System to OE/OM. Also developed programs to import Ship confirmed Data coming from USCO and E-Stamp into Oracle Shipping.
• Developed Optio based reports (1) For printing Canadian invoice with country code and tariff code information, which will be used at the end of day for UPS to report to Customs and Immigration Department. (2) Report to list all the items going to Canada per day basis (3) Report to list the orders, customer information per day basis. (4) Pack slip (5) Gift Card Printer report that gets printed automatically when a delivery has a gift that prints the gift message to receiver from the sender and is wrapped with the pack slip.
• As a Discoverer manager, responsible for the initial implementation of discoverer system and ongoing administration and maintenance of the discoverer system. Discoverer system setup and End User Layer (EUL) setup. Administering Oracle Discoverer end users, End User Layer (EUL) and Business Areas creation and maintenance. Administer, Design, develop and maintain Financial reports for the company using Oracle Discoverer 9i/4i with the backend being Oracle Applications.
• Prepare and maintain Monthly, Quarterly and annual company budget for all entities and departments. Design budget reports, conduct budget research, establish budget projections, and derive and load budget data in Oracle Applications 11.0.3 (GL) Forecasted Budget versus Actual margins and their profitability (i.e. profit and Loss) using Access and Discoverer 9i/4i Drill down, and conducting monthly research for Sales, Cost of Goods Sold, and Operating Expenses (Opex) reporting.
• Deployed the reports on Web with the integration of Oracle 9iAS portal and displayed the reports as static pages and Web Portlets.
• Involved in End-User training by taking sessions for them and also trained subordinates & co-workers on Oracle 9i reports and 9i discoverer.
• Logged TARs and documented issues.

Environment: Oracle 8i, Forms 6i, Reports 6i, Oracle Discoverer 4i, Toad, HP-Unix, Windows NT, Oracle Applications 11.0.3 (OE, Shipping, WMS, BOM, AR, PO, GL, AP, ALR and INV), Optio Design Studio 1.1.1, PL/SQL, SQL*Loader.

Confidential,Evanston, IL

Data Warehouse Consultant

• Worked as a system administrator for oracle Discoverer 4i.
• Responsible for creation and maintenance of the End User Layers and Business Areas in Oracle Discoverer.
• Worked as a Report Developer using Discoverer desktop created and maintained the work sheets.
• Scheduled the reports for automatic refresh and maintained the accurate data to display.
• Core member for writing the Extraction the Logic for Dimensions & Facts from AR & OM modules.

Environment: Oracle Warehouse Builder 3i Oracle Discoverer 4i, SQL Database Navigator, HP-Unix, Windows NT, Oracle Financials 11i (AOL, OM, TCA, INV, GL, AR), Oracle 8i, PL/SQL, SQL*Loader

Confidential,Thornton, CO

Technical Consultant

• Worked closely with super users to capture requirements.
• Managed production support for all Oracle Financial Application modules such as GL, AP, AR, FA and provided cross-functional support for Oracle Application Modules, managed Tars.
• Managed ongoing modification of AP check printing using Evergreen cartridge.
• Created new users and customized responsibilities as a part of security maintenance.
• Successfully completed a project involving clean up of corrupted data in Oracle sales tax tables saving the company penalties from multiple state taxing authorities, and billing customers the correct sales tax.
• Managed and created set up for using multiple currencies in OE and AR transactions. Analyzed, designed, and developed Oracle reports using SQL*Plus, Developer 2000 Reports 6i
• Modified and registered reports in Oracle Application, tested, and verified with users.

Environment: Oracle Applications 11.5.3, Oracle8, PL/SQL 8.0.5, Sql*Loader SQL*PLUS 8.0.5 and UNIX

Confidential,St.Paul, MN

Data Warehouse Consultant

• Responsible for Administration of Oracle Applications Data warehouse.
• Responsible for Daily Warehouse collection from Oracle Applications 10.7.
• Responsible for Administration of Oracle Discoverer 3i.
• Involved in the Design and implementation of sales analysis data mart for SIMS Deltec US.
• Responsible for design of the ETL process.
• Responsible for Tuning the ETL Process.
• Responsible for design of the daily refresh strategy of the data mart.
• Responsible for developing daily adhoc reports using Discoverer 3i.
• Controlled user access to the EUL.
• Created a usable relational structure in the EUL with joins and complex folders.
• Created conditions and drills for end-user dada analysis.
• Created summary tables to improve the performance.

Environment: OWB, Discoverer 3i, ERWIN, HP-Unix, Oracle 7x, SQL*Loader, Oracle Applications 10.7.

Confidential

Developer

• This project POSS (Point Of Sale System) mainly deals with the Retail Automation where POSS meets the requirements of the customer in fast transactions and accurate maintenance of all the information of Super Market. Modules covered under this POSS project are Maintenance of Master files viz., Items, Customer, Bank, Credit Card, Salesman, Tax, and Supplier etc.,
• Maintenance of Transaction Files viz., Sales Billing, Sales Returns, Bill Cancellations, Purchases, Purchase Returns, Receipts, Payments and Bank Realization. Reports viz., Cash In Drawer, Item wise Sales Report, Date wise Sales Report, Purchase Reports, Customer Reports, Termination Reports, User Audit Report, Item Discount Report, Salesman Performance Report, Shift wise Item Sales Report, Supplier Information, Report of special Schemes which are currently in operation. All these reports are taken daily, monthly, yearly or on need by basis.
• Maintenance of Customer Status Levels so that the Item discounts can be categorized accordingly in Billing. Providing Utility feature so that Administrator can change the settings of the project according to his requirement. Maintenance of Shift wise Operations of the users so that the owner can keep track of all the transactions with respect the Operator.
• Shift can be extended to more than 24 hours as per Administrator's requirement. Maintenance of Security Options such as Privileges and Passwords for the user was part of this project. End of the day the data was extracted to a Data Warehouse System.

Environment: Oracle 7x, D2K, PL/ SQL 2.3, Windows NT, UNIX.

Confidential

Developer

• Armour Pharmaceuticals will get the orders to manufacture pharmaceutical products from companies like Confidential, Confidential, and Confidential etc. The client is going to send the raw materials, as it reaches Armour the raw material info is entered into main inward entry (MIE).
• After entering into main inward entry the material receipt voucher (MRV) is raised. MRV No is generated based on the company-id, raw material-id and serial no. For each raw material unique id is maintained, after raising MRV, Quality control test (Q.C) is conducted. Depending on the QC test the raw material is included Into Receipts database (Ledger). The current stock of raw material is updated, now the raw material is ready to release for production. Once the product is finished it is put to QC test again, which is ready for dispatch to their respective clients.

Environment: Oracle 7.x, PL/SQL, Developer/2000 (Forms 4.5 & Reports 2.5), Windows NT.