Candidates About

Sasidhar Kota

Experience Summary:

·         14+ years of experience as Techno-Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite of Applications using Fusion technology stack which includes Oracle Data Integrator 10g/11g/12c,OBIEE 10g/11g, SOA Suite 11g, and WebLogic server 10.3.

·         Experience in leading small and medium teams and also extensive experience in onshore coordination.

·         Experience in Analysis, Design, and Development including Implementation of Business Intelligence BI solutions using OBIEE/Siebel Analytics.

·         Worked along with business analysts, developers, management professionals and with business users from various locations of customer to gather requirements.

·         Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.

·         Worked on ODI 11g and ODI 12c studios.

·         Using Data Warehousing DWH tools like OBIEE, ODI and Jdeveloper.

·         Exclusively worked on OBIEE Administration Physical, Business Model Mapping, and Presentation Layers , Answers, Dashboards, Catalog Manager.

·         Configured the Oracle Data Integrator ODI software tool in a three-tier Environment and performed periodic upgrades, performed source-to-target mappings, storage capacity planning, developing ETL

·         Developed and delivered ETL scenarios in the context of Services Oriented Architecture SOA

·         Worked on Bulk data loading on Oracle EBS environments and involved to resolve the production issues.

·         Extensive experience in developing the load plans, packages and job scheduling. Good knowledge in installing ODI11g, ODI12c and to create Master and work repositories in different RDBMS products like Oracle11g on different platforms like UNIX, Linux and windows servers.

·         Gathering requirements from users to develop interfaces and packages.

·         Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Navigator.

·         Sound knowledge on knowledge modules like RKM, LKM, CKM, IKM, and JKM.

·         Sound knowledge on Standalone agent and Java-EE agent creation and configuration.

Technical Skills:  

Professional Experience:

Responsibilities:

·         Responsible for taking care of all Production issues, mini-projects and change requests in Managed Support client accounts

·         Delivering complete solution with requirement analysis, mapping, solution design and configuration

·         Drive and execute testing phases during the project lifecycle

·         Working with Project Lead/Project Manager on various Functional and Delivery aspects

·         Liasoning with Oracle, customer, third party vendors and other Velocity support functions

·         Delivering client trainings, demo and Proof-Of-Concepts on areas of module expertise

·         Mentoring junior Functional team members

·         Debugging codes and technical objects required for issue resolution

·         Supporting technical streams on project and client deliverables Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.

·         Extensively involved in production issues.

·         Gathering requirements from users/business to develop interfaces, packages, Load plans.

·         Used Yellow Interfaces Reusable mappings in ODI 12c for developing most complex interfaces.

·         Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.

·         Experience in configuring ODI Agent on UNIX server and creating new agents and test them in ODI 11G.

·         Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.

·         Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.

·         Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.

·         Extensively used ODI to load data from Oracle, XML files and flat files

Professional Experience:

Responsibilities:

·         Involved in architecture/technical design and prepared the Software Project Design document (SPDD).

·         Involved in components technical build with adherence to the application performance and prepared Program Specification document.

·         Involved extensively in Unit testing, System testing and performance testing. Coordinated with business for functional gaps and performance and design issues.

·         Scheduled the jobs and scripts for smoothen the data flow with in the EDW architecture. Working on Incentive and Rewards Phase III design.

·         Involved in functional design discussion and did technical designing for different components.

·         Helped team members by explaining them the technical specifications and resolving their issues.

·         Guided them on better approach towards the technical development of objects.    

• Developed UNIX script to migrate objects without manual intervention.

·         Responsible to collect & analyze technical data to identify any trends and issues or areas of improvement for the delivery model or capability. Find out various plans and alternatives to identify the source of the problem. Performed a root cause analysis and suggested the best possible solution or work around. Performed and owned the tasks to completion and help out other team members.

Professional Experience:

Responsibilities:

·         Developed the interfaces for business validation (AEMP16 Validation).

·         Design and build the interface tool called ‘Chart of Accounts Mapper Program’. The tool which converts the POD account code combination (Legacy Account) to POA account code combination (Oracle Account) and vice versa.

·         Involved in Unit testing, System Integration testing, User acceptance testing and Go-Live activities as business system Analyst.

·         Involved in the warranty support at client site.

·          Coordinating with the business functional head and end users to identify and fix the bug.

·         Managed RICE development Managing delivery schedules and quality of deliverable.

·         Foster an environment where best practices are identified and constantly applied on the project deliverables.

·         Helped team members by explaining them the technical specifications and resolving their issues. Also guided them on better approach towards the technical development of objects.      

• Interaction with functional person to understand the client’s requirements and functional design document (MD050)
• Helped team members in the technical issues they have faced. Participated in deployment of objects on different instances as a part of Integration Testing and User Acceptance Testing using custom LDT’s and UNIX Shell Scripts.

Professional Experience:

Responsibilities:

·         Worked on Auto Invoice Interface Program to validate and load credit memos, debit memos and invoices from legacy system.

·         Developed AUTOLOCKBOX Interface to load data that is received from bank into interface tables (AR_PAYMENTS_INTERFACE_ALL), from interface table to the Base Interim tables and finally to the base table.

·         Developed an outbound interface for open Payable Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts, etc. from legacy system to Payables.

·         Customized various transactions in Account Receivables like Invoice ,Receipts, Credit Memos and Debit Memos etc. Customizations of Requisition Approval, PO Approval& Auto Create Workflows.

·         Loaded the vendor’s information from legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.

·         Responsible for Journal Imports from all other modules like Accounts Payables (AP) and Account Receivables (AR) into General Ledger (GL).

·         Implemented several custom logics for Form Personalization using ZOOM Functionality.

·         Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated.fmx executable file to $AU_TOP on forms server of client.

·         Designed and implemented custom Summary Billing Utility in AR with integration to Trading Community and Receivables. Implementation involves design and development of various objects using Oracle SQL & PLSQL, Oracle Forms, Oracle Reports and Oracle Discoverer.

·         Developed Cash flow summary report, Cash flow detail report, PA_rev_monthly report, PA_rev_monthly_budget report, and Inventory aging report and Asset register report.

·         Customized AR-CE Bank Reconciliation Batch Info Report.

·         Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.

·         Created Workbooks based on the custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop.

·         Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL).

·         Zoom feature is enabled using custom.pll, and whenever user in sales order form clicks the zoom button. Its displays the discount amount calculated for that order basing on the payment terms of the order.

Professional Experience:

Responsibilities:

·         Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target datastructures.

·         Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIXShellscripts to automate repetitive databaseprocesses.

·         Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’s like Java, .Net and Hierarchical databases like Oracle and Access.

·         Created SQL Server tasks, wrote script for heath check, backup, and installed and supported transactional replication

·         Helped increase the efficiency of Bradford White's EBS by improving queries and reducing user's resource load.

·         Identified and reduced LTL damages and shipping errors with the creation of a damage tracking system that linked directly both into their EBS and quotation systems.

·         Served as technical point of excellence for many company-wide projects. Successfully lead the development of a terminal manager system (part of a larger system) that streamlined load list, discharge list for vessels. Played a crucial role during application architecture and system design.

·         Developed, reviewed, and recommended systems and procedures for developing applications using Computer Aided Software Engineering (CASE).