We provide IT Staff Augmentation Services!

Senior Consultant Resume

Dallas, Tx

SUMMARY:

  • As an R12 Oracle Certified Specialist I have 11 Years of Extensive Experience in Functional/Technical domains of Oracle E - Business Suite 11i & R12.
  • Involved in Design, Development, De-bugging and Testing of various oracle application modules.
  • Customization and implementation of Oracle Applications 11i & R12 Finance,SCM,CRM Modules.
  • Techno-Functional experience in various EBS processes like O2C, P2P, Manufacturing and Financials.
  • Involved in more than three End-to-End 11i & R12implementations,Support and Upgrade projects.
  • Experience in development of Oracle applications using Forms/Reports 6i&10g, SQL*Loader,XML Publisher,SQL, PL/SQL, Discoveror,UNIX Scripting.
  • Experiance in Development, Personalization and Extension of OA Framework
  • Experiance in customizing and building custom Workflows.
  • Extensive experience in AOL concepts like Concurrent Programs, Request Sets, Key Flex Fields and Descriptive Flex Fields. Creating users, Responsibilities, menus, Request Sets, Request Groups, Profile Options, form functions, and function security
  • Extensive experience in advance features of Oracle 11g for PL/SQL programming like Using Records,Collections, Bulk collect, Ref. Cursors, Nested tables, Regexp, Dynamic SQL and Hints.
  • Experienced in handling, installing, and effective troubleshooting of EUL Discoverer 10g.
  • Experience in design, development and testing repository and dashboard reports on OBIEE (11.1.1.7).
  • Good Exposure to Data warehouse concepts and ETL tool Informatica, Oracle Fusion
  • Converting the client requirements into functional specs(MD50) and designing the technical specs(MD70).
  • Technical Design and Development of Conversions, Interfaces, Extentions, Reports using AIM methodologies,API’s.
  • Strong collaboration and team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
  • Having required functional knowledge to solve the functional/technical issues.
  • Ideal combination of Technical, Functional and Communication skills, creative problem solver, able to think logically and pay close attention to detail, proficient at gathering user requirements and customizing software solutions as per business need.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite 11.5.9/10, R12,Fusion

Domain: SCM,CRM,Finance

Application Modules: AOL,PO,INV,OM,BOM,WIP,OPM,FA,AP,AR,GL,HR,Payroll, InstallBase, Service Contracts, Tele-Services, Field Services,iProcurement

Database: Oracle8i/9i/10g/11g/12c

Data warehouse: Informatica

Reporting Tools: OBIEE, Oracle Discoverer

Operating System: Windows 95, 98, 2000, NT, XP, MS-DOS and UNIX

Programming Language: Java,SQL Loader,SQL, PL/SQL,Unix Shell Scripting

Tools: OAF,Forms/Reports 6i&10g, XML,BI Publisher, Putty, Merant FTP,Winsap

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX.

Senior Consultant

Responsibilities:

  • As a technical lead I had to Interact with solution architects and work closely with Key users for requirement gathering, understand the current EBS system integration.
  • Coordinating with the solution architect and development teams.
  • Designing and development of interfaces from legacy system into EBS.
  • Performed SQL tuning using Hints like Index,Parallel, Used DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
  • Designed and developed various custom packages and procedures using various advanced pl/sql concepts like Regexp functions,Execute Immediate.
  • Providing daily, weekly development status to project management Team.
  • Creating Unit test cases, Migration shell scripts and reviewing TE20.

Environment: SQL, PLSQL, Work Flow, Forms/Reports, XMLPublisher, Unix

Senior Consultant

Responsibilities:

  • As a technical lead I had to Interact with solution architects and work closely with Key SME users for requirement gathering, understand the current EBS system integration with external 3rd party IMA system.
  • Coordinating with the solution architect and development teams
  • Designing technical specs MD70’s for custom work bench development.
  • Designed custom packages and procedures using various advanced pl/sql concepts like Regexp functions,Execute Immediate.
  • Designing custom database objects AOL objects like custom Tables registrations in FND, DFF setup .
  • DFF Attributes are used for Dynamic generation of Item Descriptions.
  • Providing estimations on various RICEW components.
  • Design and development of custom Approval workflow process for Item work Bench in EBS.
  • Designing and development of interfaces to import Items, Item categories, Assignments, Attachments data into EBS from Item work bench.
  • Performed SQL tuning using Hints like Index,Parallel, Used DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
  • Involved in development on OA Framework pages related to Item Work Bench to enhance Inventory functionality.
  • Prototype walk through to SME users.
  • Providing daily, weekly development status to project management Team.
  • Creating Unit test cases, Migration shell scripts and reviewing TE20.

Environment: SQL, PLSQL, Work Flow, XMLPublisher, Unix, OAF

Confidential, Austin, TX

Senior Consultant

Responsibilities:

  • As part of VAS to ERP Integration i was responsible for designing the online solution to integrate with various Oracle E-business modules.
  • Interacted with VAS team and work closely with users for requirement gathering and providing business solutions.
  • Was Handling offshore team and working on various development activities in parallel.
  • Developed various complicated scripts for VAS - Oracle ERP integration.
  • Various touch points involved in integration activity was Customer Master, Supplier Master, Item master, Carrier Master, Sales Orders, Delivery processing and Delivery Acknowledgment to VAS system
  • Developed XML outbound/inbound data generation scripts for VAS-Oracle EBS system using XMLElement utility.
  • Responsible for Designing of MD50’s, MD70’s for new Enhancements and coordinate with offshore team on enhancement requests of various RICE components.
  • Responsible for Development of Forms and Reports in OM, PO,AR,HRMS modules.
  • Responsible for Development of OTL Interface enhancement for HRMS payroll system using advanced pl/sql collections, object type, bulk collect concepts
  • Worked on Extensions RICE Components in Accounts Receivable (AR),AP like payment formats, reports.
  • Customized standard reports such as AR Customer Invoice Report, Receipt Register, Pack Slip Report, Purchase Order Report.
  • Extended and Personalized various standard OA Framework pages in Payroll and TCA modules.
  • Imported items to iProcurement using Catalog Extract and Bulk Load Requests.
  • Involved in fixing various existing production issues.
  • Preparation of MD 120, TE020 document
  • Unit Test cases preparation and Unit Testing

Environment: SQL, PLSQL, Forms10g, Report10g, Work Flow, XML Publisher, OAF,Unix

Application modules: Payroll,HR,Order Management, AR, AP,Purchasing, iProcurement, General Ledger

Confidential Dallas, TX

Senior Consultant

Responsibilities:

  • Interacted with IT teams and work closely with Key SME users for requirement gathering and understand the current EBS system integration with external systems.
  • Coordinating with the solution architects.
  • Analyzing the customizations and integration systems with EBS.
  • Providing solutions to retain the synchronization with external system.
  • Analyzing the legacy data through extracting sql queries data using connect by prior, connect by partition
  • Providing risk analysis of current EBS system migration to Oracle Cloud.
  • Providing estimations on rebuilding possible interfaces through FBL, reports in Oracle Cloud.
  • Documenting the analysis, recommendations and risks.

Environment: SQL, PLSQL, Forms and Report10g, Work Flow, XML, Unix

Confidential, NJ

Senior Consultant

Responsibilities:

  • As part of R12 upgrade was responsible for modifying the customizations to function in R12 environment
  • Providing user support for daily production issues.
  • Responsible for Designing of MD50’s,MD70’s for new Enhancements.
  • Responsible for Development of Interfaces, Extensions and Reports in OM,BOM,WIP,Quality,AP
  • Worked on AR Auto Invoice .
  • Developed new payment format program for Finland, Germany, Denmark, Sweden.
  • Developed Quality interface which has huge volume data to be cleansed and processed using advance pl/sql concepts like bulk collect, collections,table and pipelined functions with ref cursor,
  • Developed new Multilingual XML,XSL,XML Bursting reports
  • Customized many standard reports like Dunning letters, Packing slip, Invoice Print Reports
  • Customized various cheque printing reports
  • Involved in OAF customization & Personalization
  • I Was SPOC for Integration of OBIA with R12 and Co-ordinated with OBIA team for successful implementation.
  • Providing technical inputs from Oracle EBS to OBIA Team
  • Developed and customized various reports in OBIEE various subject areas Sales, Inventory, Production Costing.
  • Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool.
  • Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
  • Customized and Personalized the Quality Collections Form.
  • Developed shell scripts & FTP programs
  • De-bugging existing components, code fixing on day to day production issues.
  • Providing user support for month end closings.
  • Preparation of MD 120, TE020 document
  • Unit Test cases preparation and Unit Testing
  • Interacting with Oracle support on production issues by creating SR’s,following up with oracle, internal DBA’s on patching activities and Cloning schedules.

Environment: SQL, PLSQL,OAF, Forms10g and Report10g, XML publisher,Work Flow, Unix, OBIEE, BI Publisher,OBIA

Application modules: BOM,WIP,Payables,OM, AR, AP,Purchasing,General Ledger,Quality

Confidential

Senior Consultant

Responsibilities:

  • Providing user support for daily production issues.
  • Responsible for Designing of MD50’s,MD70’s for new Enhancements.
  • Responsible for Development of Interfaces, Extensions and Reports in AP,PO,FA
  • Developed new payment format program for Netherlands.
  • Developed Payroll Journal Interface.
  • Developed various new XML publisher reports
  • Developed new and customized Discoverer reports.
  • Custom Discoverer reports migration for OPM, Planning and PO modules.
  • De-bugging existing components, code fixing on day to day production issues.
  • Providing user support for month end closings.
  • Preparation of MD 120, TE020 document
  • Unit Test cases preparation and Unit Testing
  • Interacting with Oracle support on production issues by creating SR’s,following up with oracle and internal DBA’s on patches.

Environment: SQL, PLSQL, Forms6i and Report6i, Work Flow, XML Publisher,Unix,Discoveror,EDI

Confidential, New York City, NY

Senior Consultant

Responsibilities:

  • Responsible for Designing of MD50’s,MD70’s for Financial Modules
  • Responsible for Development of Interfaces, Extensions and Reports in AP,PO,FA,PA
  • Developed new payment format program for Netherlands.
  • Developed Supplier interface.
  • Customized existing AP Invoice form using Custom.pll and Forms Personalization.
  • Generating new KPI reports
  • Developed new XML publisher reports and PL/SQL Reports.
  • Developed new and customized Discoverer reports.
  • Providing user support for daily production issues.
  • De-bugging existing components, code fixing on day to day production issues.
  • Designing and Customizing Web ADI Layouts.
  • Providing user support for month end closings.
  • Providing extracts as per user requests for analyzing the progress of business.
  • Preparation of MD 120, TE020 document
  • Unit Test cases preparation and Unit Testing
  • Interacting with Oracle support on production issues by creating SR’s,following up with oracle and internal DBA’s on patches.

Environment: SQL, PLSQL, Forms6i and Report6i, Work Flow, Unix,Discoveror

Confidential

Senior Technical Consultant

Responsibilities:

  • Responsible for Designing MD70’s for SCM,Financial Modules
  • Responsible for Development of Conversions, Interfaces,Extentions and Reports
  • Development and Testing of Stored Procedures and Functions.
  • Development of conversions like Employee Interface,Open Sales Order, Open AR Invoice
  • Customized reports like Invoice Print report, Sales History Report
  • Preparation of MD 120, TE020 document
  • Unit Test cases preparation and Unit Testing
  • Registration of custom Applications, SQL files, control files, Reports .

Environment: SQL, PLSQL, Forms9i and Report9i, Work Flow,Unix

Application modules: Purchasing,Inventory,Receivables,Payables,General Ledger, Order Management

Confidential, MA

Senior Technical Consultant

Responsibilities:

  • Responsible for Designing MD70’s for CRM,SCM Modules
  • Responsible for Development of Conversions, Interfaces,Extentions and Reports in OM, INV,PO,CRM
  • Customized PO Re-approval workflow as per the client requirement.
  • Preparation of MD 120, TE020 document
  • Unit Test cases preparation and Unit Testing
  • Development of MD70’s and coding for conversions like PO Quotations, Default Receiving Sub-Inv,Price List etc
  • Development of extensions in Tele Service and Field Service like Deleting Charge Lines etc
  • Development of Reports using Zebra Printing Language.
  • Development and Testing of Stored Procedures and Functions.
  • Registered of AOL, SQL files, control files and Customization and Registering of Reports in Oracle Applications using Reports 6i.

Environment: SQL, PLSQL, Forms6i and Report6i, Work Flow,Unix

Confidential, NY

Senior Technical Consultant

Responsibilities:

  • I was responsible for interacting with Onsite coordinators and business for analyzing requirements.
  • Responsible for Designing MD70’s for CRM Modules
  • Involved in Development, coding, testing and preparation of AIM documents of CRM Modules (Install base, Service contracts, Field service)
  • Responsible for Design/Development of Conversions, Interfaces,Extentions and Reports in CRM
  • Developed code for Install base and service contracts conversion
  • Provided solution to achieve a requirement on Service Request form without customizing the oracle standard form.
  • Developed the code for above requirement which can be executed using forms personalization for deleting the FS Debrief Charges.
  • Developed various Inbound and outbound interfaces in CRM modules
  • Developed new reports and customized standard reports
  • Preparation of MD 120, TE020 document
  • Unit Test cases preparation and Unit Testing

Environment: SQL, PLSQL, Forms6i and Report6i,workflow,Unix

Application modules: Service contracts, Install Base,Field Service, Purchasing,Inventory

Confidential, PA

Technical Consultant

Responsibilities:

  • Interacting with Onsite coordinators as a Developer
  • Involved in more the 100 reports development using Reports 6i
  • Involved in building complex Sql queries and layouts
  • Developed custom PCL reports.
  • Responsible for Development of New Custom Report in AR, AP,FA,GL,OLM
  • Preparation of MD 120, TE020 document
  • Unit Test cases preparation and Unit Testing
  • Monitoring Bugs and fixing the defects

Environment: SQL, PLSQL, Forms6i and Report6i,Unix

Hire Now