PROFESSIONAL SUMMARY:

• Having 8+ years’ experience in Oracle EBS/DW. Proficient in Oracle EBS R12, ETL/BI(ODI/OBIEE), OBIA, BI Publisher, SQL, PL/SQL, Procedure/Package, Cursors, Triggers, Forms, Reports, XML Publisher, SQL*Loader, Workflow, OBIEE, SOA, OAF, RICE Development, Interface, Conversion as well ADF, WebLogic, JAVA/J2EE, .Net, Web Service(SOAP/REST), Web Development, Testing.
• Having hands on experience in Requirement gathering, Analysis, Design, Data Modeling, Development, Testing, Support and User .
• Highly experienced in using Oracle Data Integrator (ODI) to develop processes for extraction, cleansing, transforming, integrating, and loading data into Enterprise Data Warehouse (EDW).
• Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.
• Expert in installing and configuring the Oracle Data Integrator (ODI) software tool in a three - tier environment and performing periodic upgrades, performing source-to-target mappings.
• Experience in architecting data-related solutions, developing data warehouses, developing ELT/ETL jobs, Performance tuning and identifying bottlenecks in the process flow.
• Experience using Dimensional Data modeling, Star Join Schema modeling, Snow-Flake modeling
• Responsible for Design, Develop and implement multiple ODI Interfaces, Mappings, Packages, Scenarios.
• Experience in designing and developing end-to-end BI solutions according to standard OLAP methodologies using Oracle Business Intelligence (OBIEE).
• Exclusively worked on OBIEE Administration (RPD) (Physical, Business Model & Mapping, and Presentation Layers), Answers, Dashboards, Catalog Manager
• Experience in creating KPIs, KPI watch lists and creating agents to deliver reports to end users.
• Highly experienced in creating Oracle BI publisher report templates to publish the reports as per user requirements using BI Publisher Desktop Edition.
• Experience in implementing Write back functionality for Insert and Update operations
• Experience in data level and object level security implementation.
• Managed production deployments and post implementation support for ETL & OBIEE code.
• Hands on experience in Oracle apps modules, Technical architecture, Apps Tables, Oracle apps APIs, Data Flow Between Modules, Set-ups, Design, RICE Components, Data Mapping, Data Migration/ Conversion, Integration/Interfaces, Customizations, Reports/Forms, Workaround solutions, AIM Methodology, Multi org, Performance tuning, Debugging, Data Extraction, O2C, P2P.
• Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle *Forms, Oracle *Reports, Workflow, Discoverer and modified the formats using XML publisher for customizations as per client specification.
• System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Expertise in creating stored procedures, functions, packages, triggers, collections and bulk collections using PL/SQL.
• Good knowledge and trained in Oracle SOA Suite 11g: Build Composite Applications
• Good team player, independent and excellent communication skills.

TECHNICAL SKILLS:

Oracle Database: Database Oracle 9i/10g, MS SQL Server, pgAdmin4

Oracle Financials: General Ledger GL, Receivables AR, Payables AP, Sub ledger SLA

Oracle SCM: Inventory INV, Order management OM, Purchasing PO

Oracle Development: SQL, PL/SQL, TOAD, Developer, Sql*Loader,XML Publisher

Reports Development: OBIEE, OBIA, BI Publisher, Discoverer, IBM Cognos, Tableau

ETL Tool: Informatica, ODI

Web technology: SOA,OAF, Weblogic, Java/J2EE, JDeveloper, Eclipse, SOAP/Restful Web services

Programing Languages: C, C++, .Net, C#, JAVA, VB Script, JAVA Script, HTML, CSS, MVC

MS Tools: Microsoft SharePoint, MS Access, MS Excel, MS outlook, MS SQL Server

Others: UNIX/LINUX, Python, PGAdmin4, EDW, Erwin, HP ALM, HP UFT

WORK EXPERIENCE:

Confidential

Oracle Developer

Responsibilities:

• Analysis, Design, Development, Implementation, Testing and Support of DW and data integration solutions.
• Designed Architectural Model/diagram using SQL Developer - Data Modeler,Erwin
• Installed, configured ODI 12c on windows environments and setup with Oracle, MS SQL Server and Flat files.
• Created New Server, Physical/Logical schemas and Context into ODI Topology Manager Tool.
• Reverse Engineered Source and Target Data Stores using Reverse Engineering Knowledge Modules.
• Implemented mappings in ODI 12c using Aggregate, Expression, Filter, Dataset, Join, Lookup and Split components.
• Created ODI Variables and used it into ODI interface, Procedure and Packages
• Created ODI Interfaces/mappings using LKM, CKM & IKM Knowledge Modules.
• Created Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables
• Implemented Performance tuning techniques to optimize ODI ELT objects to make them run faster with high throughput.
• Optimized the Knowledge modules for increasing the efficiency of jobs as a part of performance tuning.
• Created ETL source to target mapping documents, ETL implementation document, unit test plans, Oracle Implementation document, Deployment and Rollback scripts for code migration.
• Created scripts for doing data cleaning process against defined business rules and used those scripts in ETL process.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer for OBIEE metadata repository.
• Designed and developed the OBIEE/ Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer.
• Created new connection pools in physical layer for new schemas, Imported new tables and created alias table.
• Created a new business model by joining fact table to dimension tables by performing inner and right outer joins in BMM layer.
• Created the star schemas, Logical dimensional hierarchies, Aggregations, Fragmentation in BMM layer.
• Created initialization blocks and variables using variable manager.
• Used time series functions like AGO, TODATE and PERIODROLLING for creating time series measures.
• Created new subject areas, presentation tables and presentation columns in presentation layer.
• Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector using Oracle BI Presentation Service.
• Setup Bi Publisher Scheduler and applied patches to fix Bi Publisher bugs.
• Created KPIs and KPI watch lists according to end user demands.
• Performed the required setup for write back at RPD level: disabling cache on the physical table, making logical columns writeable and enabling read write permission for presentation columns
• Implemented OBIEE Security in Object Level and Data Level Security in the OBIEE Repository and Answers using Repository Variables, Session Variables and Initialization Blocks
• Created various user groups, application roles and assigned them appropriate permissions and privileges.
• Setup and configured active directory with OBIEE default Oracle weblogic LDAP Security.
• Quickly resolved and troubleshot AD issues in production so that users can have access reports continuously without disruption.
• Migrated the OBIEE code across different environments by leveraging SVN as centralized repository to maintain the code migration documents.

Environment: Oracle EBS R12.2.4, Oracle Developer, Discoverer, OBIEE, OBIA,BI Publisher, DAC, Oracle Data Integrator (ODI) 12c, Cognos, HPALM, HPUFT

Confidential, CA

Oracle Developer

Responsibilities:

• Gathered ELT requirements from Business team and design, modified its high level documents.
• Responsible for data modeling using, Star Schema Modeling and Snow flake modeling, Fact and Dimension tables, physical and logical modeling.
• Created repositories, agent, contexts and both of physical & logical schemas in topology manager
• Reverse Engineered Source and Target Data Stores using Reverse Engineering Knowledge Modules.
• Implemented mappings in ODI 12c using Aggregate, Expression, Filter, Dataset, Join, Lookup and Split components and ImplementedODI12c mapping to load multiple target tables.
• Debug the mappings using debugger to resolve code issue.
• Designed Interfaces to load data from Flat files, CSV files in to staging area (Oracle) and load in to Oracle data warehouse.
• Generated scenarios and deployed them using ODI Operator for code migration from one environment to another environment
• Involved in developing packages for implementing business logic through procedures and functions.
• Implemented ODI procedures to execute pre and post process commands such as disable and enable Indexes.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Designed and developed data level security on various reports by creating session variables in the repository.
• Implemented CDC through ODI Journalization Knowledge Modules
• Designed and developed data level security on various reports by creating session variables in the repository.
• Responsible for creation of new users and setting up privileges and policies for protection of data.
• Developed, executed on demand Adhoc reporting SQL Query to support user data reconciliation
• Depending on the requirements created and modified SQL and PL/SQL database objects like tables, indexes, views, stored procedures, functions, packages, Triggers, synonyms, Materialized views, analytical functions to make new enhancements or resolve problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Used OBIEE Administrator tool to develop and enhance Data model.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Server administration tool by considering the Standards of the company
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed and developed schemas using fact, dimensions, and tables like logical, physical, alias, and extension and made relationship between them by declaring Keys.
• Created Measures, Dimension Hierarchies, Aggregates, Variables, Time series Measures in RPD
• Used Analytics to create reports using queries, format views, charts and added user permissions.
• Worked extensively with dashboard prompts to filter dashboards and populate variables.
• Involved in assigning roles/privileges to Users and Groups in EM.
• Used Security setting in OBIEE to set up authorization and authentication for users.
• Extracted back end queries from Manage sessions in Administration.
• Involved in merging & migrating from development to production for deployment.
• Involved in troubleshooting and debugging of report errors and metadata inconsistencies.
• Migrated reports from DEV/UAT to Production by archiving and unarchiving objects and inheriting properties.
• Prepared the OBIEE deployment document, RPD for UAT/PROD deployment and managed using SVN version control.

Environment: Oracle ODI 12C, TOAD, SQL/PLSQL,, HP ALM, OBIEE, Form Builder, Report Builder, Workflow builder, XML Publisher, UNIX, JAVA/J2EE

Oracle EBS Techno-Functional Consultant

Confidential

Responsibilities:

• Provided production trouble tickets support, interface maintenance and month end close support
• Core team member for Oracle EBS: Financials (GL, AP, AR) and SCM (Inv, OM and purchasing) etc
• Implementation and support of OM, INV, Advanced Pricing, Purchasing and Account Payable Module.
• Worked closely with the onsite team on High level analysis of current Order Fulfilment processes;
• Developed several enhancements to the Business Processes on the Order to Cash side and Worked on the entire Order to Cash cycle.
• Worked on Back to back order, drop shipment order, RMA etc
• Worked on the setups of Positional Hierarchy Approval Hierarchy in Oracle Purchasing.
• Worked on defining the Purchasing and Receiving Option in Oracle Purchasing.
• Defined Buyers and setup their roles in Oracle Purchasing.
• Design & Delivery of user requirements workshops covering Oracle Order Management, Shipping, Advanced Pricing, Inventory, Bill of Materials, & Configuration
• Developed scripts, queries, and reports in SQL and PL/SQL for data extraction and manipulation
• Created new databases, users, roles, tables, views, triggers, packages, procedures, functions, materialized views, directories
• Used SQL*Loader to import third party data from CSV files to staging tables for further analysis and processing.
• Debugged and developed various inbound and outbound interfaces to send files to other practices
• Modified SO Line workflow to add notifications and supported PO Approval customization
• Configured & scheduled various Concurrent Programs, Value sets and alerts
• Validated developed PLSQL Packages and procedure for Inventory and PO Transaction Interface
• Analyzed SQL statements and designed indexes to improve response of queries.
• Performance Tuning done by using Explain plan and query optimization techniques and created necessary indexes.
• Performed the form personalization, OAF personalization for Order management and EAM.
• Prepared Test Scenarios and test Script for Order Management, Purchasing and Inventory
• Executed test script with end user as part of Unit/CRP/UAT testing
• Provided user system support for data loader, interfaces clean up, concurrent program executions, testing
• Developed materials to assist end user in new functionalities of Purchasing, Supplier and Order-to-cash modules.
• Logged testing defects, worked with developers/DBA for fixes, code change approvals and code promotion
• Supported multiple environments (development QA and production).
• Migrated data between system(s) upon a system upgrade and software upgrade.
• Prepared design documents to share among the group to facilitate knowledge sharing .

Environment: Oracle R12, SQL Developer, SQL/PLSQL, HP ALM, OBIEE, Form Builder, Report Builder, Workflow builder, XML Publisher, UNIX, JAVA/J2EE

Confidential

Oracle Technical Consultant

Responsibilities:

• Designing Technical Specification, Build, Unit Testing, Customization and SQL/PLSQL Tuning of Oracle Applications R12 Procure to Pay Modules (Account Payables (AP), Account Receivables (AR), General Ledger (GL), Purchasing (PO), Inventory (INV), Order Management (OM).
• Converting Functional Documents into Technical Documents using AIM methodology and Client specific methodologies.
• Customized and modified the existing forms using Form builder according to the requirement of the Business user.
• Responsible for Form Personalization, Reports Customization, RTF/XSL-FO template creation.
• Developed the XML Publisher reports on the Inventory module for Packing Slip and PO Vendor Invoices.
• Developing Inbound and outbound Interface codes to interact between Legacy and Oracle Apps systems
• Loading data into interface tables and running the standard import programs to push the data into standard tables from interface tables
• Creating Lookups and Value sets where ever needed which avoids hard coding in the PL/SQL coding
• Worked to improve the performance of the system by tuning and restructuring PL/SQL units for optimum performance.
• Used FTP to transfer the files into different servers as needed by the business users.
• Created temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Ensures that all the assigned deliverables are completed on time and with impeccable quality.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Initiating RFC (Request for change) process of change management for any kind of change in production application and implementing the changes as approved in RFC.
• Resolving production support process / methods, troubleshooting and proposing solutions using a change management process in Production Environment
• Informing and supervising monthly down time of applications at time of reconciliation or any change implementation.

Environment: Oracle 10G/11G, TOAD, SQL/PLSQL, HP ALM, OBIEE, SQL Loader, XML Publisher, UNIX, JAVA/J2EE, MS SQL Server