We provide IT Staff Augmentation Services!

Oracle Soa Resume

Raleigh, Nc

Summary

  • 8+ years of IT experience and expertise in software design and development in Oracle FMW/SOA/ OSB platform based applications, projects and products.
  • Extensive experience in integration and process management Oracle products like Oracle BPEL, Oracle BPM, Oracle ESB, Coherence, Oracle BAM, OWSM.
  • Extensive development experience with Oracle SOA suite (10g, 11g) for integrations with Oracle ERP, Oracle Siebel, Custom applications using File Adapter, FTP Adapter, Database Adapter, AQ Adapter, JMS Adapter and Oracle APPS adapter.
  • Extensively used various integration patterns like Asynchronous messaging patterns, File transfer patterns, Remote database procedure invocation patterns to provide business solution in various domains.
  • Extensive development experience with Oracle Enterprise Service Bus (ESB 10g) in evaluating routing rules, perform transformations and invoke services.
  • Extensively used Oracle SOA 11g components BPEL, Mediator, Business Rules and Human Task to build complex composites.
  • Extensive service contracts development experience for Synchronous, Asynchronous and One-way webservices.
  • Extensively worked on Oracle Service Bus 11g to virtualize services, route to JAX-WS, SOA services, REST based services using http, soa-direct, sb protocols and GET, POST http methods.
  • Proficient in Oracle FMW components B2B, BAM, and ADF.
  • Expertise in installing, configuring and administering Oracle Application Server 10g, Weblogic (10g, 11g).
  • Expertise in configuring Persistent stores, JDBC, JNDI for JMS and Database adapters in Oracle Application Server and Weblogic Server.
  • Extensively developed Functions, Procedures, Packages, Triggers and other Database objects in Oracle (9i, 10g, 11g) databases.
  • Extensively worked on Sun Solaris, Oracle RHEL, HP Unix servers.
  • Experience with error handling frameworks using SOA 11g fault policy framework, custom Java error handling, JMS error handling queues.
  • Experience with Build and Deployments frameworks using ANT, WLST, Maven for OSB, SOA, Web and Enterprise applications.
  • Experience in building test plans and unit testing for Webservices and SOA applications (BPEL test suites).
  • Implemented best practices in OSB service development with VETO patterns and error handling.
  • Monitor and support load and performance testing, analyze connection pools, resources.
  • Work experience on Oracle Business Activity Monitoring (Oracle BAM) solution for building interactive, real-time dashboards and proactive alerts for monitoring business processes and services.
  • Knowledge on working with batching and de-batching EDI transaction sets in B2B.
  • Knowledge on Application integration Architecture (AIA, creating and extending PIPs and deploy to MDS.
  • Worked on extending Business Objects and Business Messages to build Application Connector Business Services
  • Development experience with SVN, CVS, ClearCase and other version control systems.
  • Development experience with Oracle XML gateway, Vor Confidential gateway, EDI gateways.
  • Experience in defect resolutions and configuration management change processes to support applications in PROD and integration testing environments.
  • Experience in working with offshore teams, and leading small teams
  • Highly motivated, detail oriented with excellent written and verbal communication skills, has ability to work independently and as a part of the team
Technical Skills
Mid Confidential eware : Oracle SOA (10g, 11g), E-Business Suite (EBS), Enterprise Service Bus (ESB), Oracle Service Bus (11g), Coherence,Application Development Framework (ADF),Oracle AIA, BAM, Oracle Web Service Manager (OWSM).
Application Servers : Oracle Application Server, Apache Tomcat, Web logic.
Languages/ Technologies : SQL, PL/SQL, Java, J2EE, C, C++, Unix Shell scripts.
Web services : SOAP, Restful and UDDI
RDBMS : Oracle 11g/10g/9i/8.x, SQL Server 2005/2008, MYSQL
Tools : TOAD, SQL * Plus, SQL Developer, Secure Shell Scripting ,Rational Rose for UML, Oracle JDeveloper 10g for Fusion Development.
Build Tools : Ant 1.4, WLST, Maven
IDE : JDeveloper (10g,11g), Net Beans, IBM Visual Age, Eclipse.
Markup languages : HTML, XML, XSD, XPath, XSLT
Web Applications : JSP, JavaScript
Operating Systems : RHEL, SunOS, HP-UX, Windows 2000/XP

Professional Experience
Confidential , Raleigh NC
Role: Oracle SOA/OSB Developer
  • Built SOA composites using BPEL/OSB/Mediator components that exposed some EBS sales order processing functions as web services accessible by all technology platforms in the enterprise through SOAP/WSDL interface.
  • Designed and built SOA composites and BPEL processes that polled the legacy system for incoming customer data, performed filtering and transformation operations on it before sending it to the end user. A robust workflow was built around the process to handle bad data being exposed in the form of validations and email messages to support/customer.
  • Work with File Adapter, Database Adapter, AQ Adapter, JMS Adapter and Oracle Applications Adapter for establishing connection with services in BPEL.
  • Built BPEL processes that subscribe to various EBS events around sales order processing functionality and participate in database and JMS transactions. Used the various activities available in BPEL to perform transformations and write business logic.
  • Designed and Implemented BAM Based Auditing and Error Framework with 11g Development.
  • Error handling was also done for handling the faults in BPEL Processes. Business faults were handled using the catch, catchall, throw, compensation and compensation handler activities. The system faults were handled by defining fault-policies in the fault management framework.
  • The database MDS repository was used to store all the common artifacts between composites like DVM, XSD, Fault policy and Fault Binding files. Abstract WSDL’s were also stored here and any call to a composite through a BPEL is made through abstract WSDL in-order to avoid dependencies problems during server start ups.
  • Implement business rules and set priorities for the incoming messages and integrate it with the BPEL Work Flow.
  • Worked with Oracle OSB to build service proxies for virtualizing that provided features like load balancing, fault-tolerance, dynamic transformation and dynamic routing to back-end SOA services which involves dealing with XQUERY and XSLT.
  • Extensively worked on Native format builder & MFL for creating complex schemas to process files using file and ftp adapter
  • Implemented end-end security for all the services by configuring two-way ssl in Weblogic
  • Implemented performance tuning strategies at both server level and process level to meet the SLA.
  • Ant scripts and configuration plans were used to move the code between the various development, test and production environments as part of the development life cycle.
  • Developed complex schemas and XSLT transformations in BPEL to read, enhance and process incoming data and map to external provider web service (Provider OSB)
Environment: Oracle OSB , Oracle SOA Suite 11g, Oracle Weblogic 11g, , Enterprise Manager 11g, Jdeveloper 11g, Oracle BPEL Process Manager 11g, BPEL, JMS Adapter, FTP Adapter, DB Adapter, XML, Java, JSP Oracle Database 11g.

Confidential , Austin TX
Role: SOA/OSB Developer
The project deals with developing an application for the federal client. The application includes integration with various applications like Siebel,DataPower ,EBS etc for communication . The process includes processing of orders from the Confidential l interface to the federal interface.
Responsibilities:
  • Worked on design and development and creating MD70,MD50 for the interfaces
  • Developed inbound and outbound interfaces for between the external clients and the federal interface.
  • Worked on communication to EBS using AQs in OSB .
  • Creating the Stored Procedures and Inserted the data into the stored Procedure
  • OSB picks the msg from AQ and calls the stored Procedure and fetch the invoice details
  • Send those invoice details to OCI which sends us the response and by using that response OSB calls the stored procedure which updates the Status to SIEBEL.
  • OSB calls the stored Procedure and in case if EBS is down then the message goes to JMS QUEUE.
  • When EBS is up the stored Procedure should invoke the DB and should send the data which is in QUEUE
  • Worked on the Integration from PIM to SIEBEL .
  • Instrumental in designing Architecting solution for the business process.
  • Worked on developing OSB services supporting various protocols including JMS , FTP ,DB.
  • Worked on creating OSB Services ( wsdl based, xml based , Message types )
  • Worked on XQuery Transformations in OSB 11g.
  • Involved in creating Adapters using JMS , AQ Adapters , Oracle Apps Adapter
  • Involved in creating customization files in OSB .
  • Involved in creation of Topic and Queues
  • Worked on both the Eclipse based IDE and on the console of the OSB .
  • By using the input WSDL we have to update and Insert the data into SIEBEL.
  • Created Persistence File Stores, Store-and-Forward Agents, Sequence Files.
  • Created JMS Servers, JMS Modules, SubDeployments , JMS Topics, JMS Queues, DataSource, ConnectionFactories.
  • Worked on different BPEL requirements like fetching the Data from Database using Database Adapter,
  • Worked on Handling Events using Oracle Apps Adapter and involved in Fault Handling.
  • Worked on creating webservices in osb and integration with DB.
Environment: WebLogic Oracle SOA Suite 11g, OSB, Oracle 11g DB, Java , Oracle EBS ,Subversion ,DataPower

Confidential ,McLean VA
Role: OSB/BPEL Developer/Java
Responsibilities:
  • Installed and Configured OSB 11g on Linux platform for DEV environment.
  • Created Persistence File Stores, Store-and-Forward Agents, Sequence Files.
  • Created JMS Servers, JMS Modules, SubDeployments, JMS Topics, JMS Queues, DataSource, ConnectionFactories.
  • Developed inbound and outbound interfaces for Authentication Providers application.
  • Developed JavaBeans and mapping files for Hibernate Object Relation Mapping for data persistence & storage
  • Used Spring ORM module to integrate with Hibernate.
  • Multithreading was used on the Server side to perform Database pooling of connections in Java on UNIX Environment.
  • using XML rules engine with java multi-threading.
  • Involved in developing the Application using Spring batch.
  • Developed proxy and business services using WSDL, Text, XML message payloads to expose services to consumers and route to backend services.
  • Developed OSB proxy services and exposed them as JMS, HTTP and REST based services for consumers.
  • Developed business services to route messages to backend JAVA webservices, SOA Composites, JMS services.
  • Configured Database adapter in Jdeveloper using JNDI to retrieve process status, and exposed service in OSB as business service using JCA protocol.
  • Developed proxy services with Java callouts for message conversions.
  • Implemented schema validation at OSB proxy level using Validate action and reported back error to client.
  • Developed services using Conditional Based Routing, Dynamic Routing and Routing tables to route messages to provider services.
  • Created complex service-level and operational-level pipeline pairs with multiple stage configurations to enable dynamic content-based and rule-based routing.
  • Developed JMS topics to support SAF application.
  • Developed proxy services to consume messages of JMS topics to initiate OSB service.
  • Implemented error handling at Stage level and Proxy level to handle business exceptions and faults, and published them to error reporting tables using Publish action and Reply action.
  • Implemented Security Policies and name-value token security for OSB services.
  • Developed complex XQuerys to transform data to meet partner services.
  • Developed build and deployments process to deploy sbconfig jars to OSB server using Maven repository and configuration plans to support deployment across multiple environments.
  • Source code management in Clear Case, supported configuration management process for code migration from DEV to PROD environments.
  • Developed test cases and performed unit testing using Soap UI.
  • Supported UAT and PROD environment release validations.
  • Developed SOA composite services using File Adapter, Database Adapter, B2B adapters.
  • Handled exceptions in BPEL process using Catch and Catch All activities and defined appropriate actions using Fault Policies.
  • Stored DVMs and Fault Policies in database MDS.
  • Configured B2B console in which Created Document Definition, Document Protocol Version and Listening Channel for both inbound and outbound transactions.
  • Configured Trading Partners and created agreements between parties.
  • Configured and deployed the agreements for both inbound and outbound transactions.
  • Configured B2B gateway for communication with trading partners.
  • Configured UMS driver to send out email notification from BPEL process.
Environment: Oracle SOA Suite11g(BPEL), Oracle Service Bus(OSB), Eclipse 10.8.0, JAXB, Oracle EBS, Seibel System, Technology adapters (File Adapter, FTP Adapter, DB Adapter and JMS Adapter), Oracle J-Developer, Java, Oracle Application Server, XSLT, XPath, Linux
Confidential , ShoreViewHills, MN
Role: Oracle SOA Developer
Responsibilities:
  • Implemented CacheManagement using Oracle Coherence that provides in-memory caching facilities for objects to improve lookup performance/reduce impact to DB.
  • Created Java Callout to call Java Services that load and update Cache data.
  • Used Mediator to route data in between the process throughout the design.
  • Defined WSDL for BPEL process, partner links, BPEL process templates and developed process logic definition.
  • Developed several XSD Schemas for XML validations.
  • Used Java Embedding activity for executing Java classes for complex business logic.
  • Used SOAP, XML, XPATH, and JMS to send and receive data.
  • Work flow was constructed using BPEL, Task Manager, ESB, Web Services and XPath.
  • Design and Implement error handling using the Fault handling framework.
  • Designed XSLT Transformation wherever needed.
  • Installation and Configuration of Oracle Web logic server, Oracle SOA Suite 11g and Oracle J-Developer.
  • Developed interfaces using Proxy and Process approach for SYNC and ASYNC services
  • Virtualized and exposed services via OSB with in enterprise and used Vor Confidential gateway for external services on top of OSB.
  • Used WS-Addressing and Reply-To parameters to hold callback address for ASYNC services
  • Developed java stubs using wsdl2java for unit testing
  • Developed UML mo Confidential ing flows in Visio for inbound and outbound interfaces.
  • Build SCA composites using BPEL, Mediator, Business Rules, Human Work flow and used OSB to provide business solution.
  • Used SOA CFG plans to support deployments to DEV/SYS/TST/STG and PROD environments.
  • Developed unit test cases in BPEL test suites.
  • Involved in performance tuning of BPEL and APP server.
  • Implemented XQs, XML, XPath, and XSLT’s to get the data and transform as per the requirements
  • Developed XSDs and WSDLs for services, implemented interfaces using OSB and BPEL
  • Implemented Email utility service using SMTP server and email protocol in OSB and exposed as webservice for enterprise consumer notifications.
  • Created Repository Creation Utility for Oracle 11g Database.
  • Used Java Embedding activity for executing Java classes for executing Java web services.
  • Used multi threading and synchronization process to handle clients.
  • Multithreading was used as well to call inside a call to do validity check for write back services.
  • Worked on conversion of some modules to be multithreaded.
  • Developed user interface using JSP, Spring Tag Libraries to simplify the complexities of the application
  • Documented how Spring Batch is useful for the current project.
  • Used XML, XPath, XSL to get the data and transform as per the requirements.
  • Used Assign activity to define the copy rules and add expressions in a BPEL process.
  • Developed business processes using DB Adapter, File Adapter, JMS Adapter, BAM adapter, WS Binding and Direct Bindings.
  • Developed AIA Exception handling architecture in BPEL for the whole project to handle all the exceptions and alerts.
  • Experience in unit testing of webservices and bpel processes using Soapui Mocks.
  • Involved in requirements gathering, component designing, deployment and testing of the application.
  • Interacting with the team for project analysis, Designing, Implementation and Documentation.
  • Created SOAP requests to test the BPEL processes using SOAP UI and performed the testing process.
  • Worked with BPEL activities like Java embedding, Transform etc.
  • Worked extensively with the testing team to test different modules that have been developed.
  • Used Tortoise SVN to check IN and check OUT the project code.
  • Shared the ideas and worked with all the team members who worked for this project including the team managers during the various phases of the projects.
Environment: Oracle SOA 11g,WebLogic 10.1.3.x,JDeveloper,Test Master Definition, JDE Provider, AIA Error Handling, Oracle Applications R12.1.3,Oracle EM Console, SOAP,JSP 2.0, XML, BPEL, Oracle 9i/10g, Windows XP.
Client: Confidential , Berkeley heights, NJ
Role: Sr. Oracle SOA Consultant
Responsibilities:
  • Confidential composites using BPEL/Mediator components that exposed some EBS sales order processing functions as web services accessible by all technology platforms in the enterprise through SOAP/WSDL interface.
  • Worked with File Adapter, Database Adapter, AQ Adapter, JMS Adapter and Oracle Applications Adapter for establishing connection with services in BPEL.
  • Built BPEL processes that subscribe to various EBS events around sales order processing functionality and participate in database and JMS transactions. Used the various activities available in BPEL to perform transformations and write business logic.
  • Used Mediator to route among different endpoints as alternate flow, health pages etc.
  • Preparing custom reports in Oracle BAM and integrated BAM with BPEL Sensors.
  • DB Adapter and Oracle Application Adapters are used for developing services related to the vending machine requirements.
  • Oracle Application Adapter is used to interface with the packages present in EBS.
  • DB Adapter is used to fetch the Distributors Details and Product availability SKU’s and other Services.
  • Involved in Migration of 10g ESB and BPEL to 11g composites.
  • Involved in design and development of the Oracle Fusion Project.
  • OSB (Oracle Service Bus) is used to create wrapper for the services developed in Jdeveloper.
  • Services developed for routing the data from one Database to another Database involved OSB.
  • Switch activity to create logical flow in BPEL processes for Order Reprocessing.
  • Configured File Adapter and directory structures for data load process in OS.
  • JMS adapter was used for Producing and consuming the messages.
  • Created JMS queue and topics for message transfers.
  • Fault Handling was built separately using BPEL processes. The main BPEL transfers the error/fault messages to the Fault Handling BPEL where exception handling is performed.
  • Developed various Web Services using WSDL and SOAP.
  • Performed Oracle Business Activity Monitoring (Oracle BAM) solution for building interactive, real-time dashboards and proactive alerts for monitoring business processes and services.
  • Creating gui Confidential ine files and schema files using B2B Document Editor.
  • Create ECS and XSD for 810, 812, 820, 850, 855, 880, 875, 940 EDI X12 documents using B2B.
  • Monitor express was associated with all processes developed using B2B.
  • Created data objects in BAM and configured reports to show lifecycle of both inbound/outbound documents from start to end capturing all states and errors using B2B.
  • Creating Proxies using WSDL and rest services using OSB.
  • Create Business Services for File, FTP , WS and DB Adapters using OSB.
  • OWSM Security policy implementation for Proxy and Business Services using OSB.
  • Reporting and BAM implementation using OSB.
  • Interacted with business analysts, customers, architects and team managers during the various phases of the projects.
Environment: Oracle SOA Suite11g(BPEL), Oracle Business Activity Monitoring (BAM), Oracle EBS, Seibel System, Technology adapters (File Adapter, FTP Adapter, DB Adapter and JMS Adapter), Oracle J-Developer, Java, Oracle Application Server, XSLT, XPath, Linux.
Confidential, Framingham, MA
Role: Oracle SOA Consultant
Responsibilities:
  • Extensively used Oracle EBS Adapter for the interface between Oracle Applications and OTM.
  • Design and developed Middleware solution for interfaces using SOA Suite and JDeveloper.
  • Defined WSDL for BPEL process to communicate with the Partner Links.
  • Developed technical mo Confidential ing and BPEL implementation best practices relevant to the client's environment and experience level.
  • Worked on improving the performance of 11g Purge Process.
  • Tuned Database Adapter performance for polling.
  • Enabled High Availability for Oracle File and FTP Adapters.
  • Used BAM for Business processing and Monitoring over the web applications.
  • Effectively used Technology adapters which include FTP adapter, DbAdapter,JCA Adapter.
  • Used XSLT mapper tool for creating mapping between source and target systems.
  • Implemented best practices such as error handling and file archiving.
  • Created database web service using JDeveloper .
  • Developed Java Web Service in JDeveloper 11g and deployed into Weblogic 10.1.3.
  • Developed different SOAP services and Web Services using WSDL, SOAP and Oracle JDeveloper.
  • Developed custom XPath functions to transform messages.
  • Deployed real-time operational dashboards, monitoring and alerting applications over the web using Oracle Business Activity Monitoring (BAM).
  • Preparing custom reports in Oracle BAM and integrated BAM with BPEL Sensors.
  • Implemented Exception Handling for the BPEL Process mo Confidential s to handle System, Business exceptions and used Compensation handlers to handle the transaction if an exception occurs.
  • Used OnAlarm branch to manage the timeout condition.
  • Putty is used to interact with the Middleware database to monitor data
  • Involved in creating XSDs, XSLs while developing the BPEL project.
  • Developed custom XPath functions to transform messages and used XSLT extensively.
  • Involved in the implementation of security to the webservices in Oracle Webservice Manager.
  • Developed various Synchronous and Asynchronous business processes using BPEL in JDeveloper.
  • Performed Editable Append Property With Dynamic File Name in File adapters.
  • Involved in 24X7 production Support and worked with on-site and off-shore mo Confidential .
Environment: Oracle SOA 11g,WebLogic 10.1.3.x,JDeveloper,Oracle Applications R12.1.3,Oracle EM Console, SOAP,JSP 2.0, XML, BPEL, Oracle 9i/10g, Windows XP.
Confidential Warwick, RI
Oracle SOA Developer
Responsibilities:
  • Gathered business requirements for the Item Integration and developed High Level Design Documents
  • Created BPEL Process for the ITEM Synchronization between two Applications (Oracle Apps-TCE, AGILE).
  • Created BPEL Process for the BOM, ECO Synchronization between two Applications (Oracle Apps-TCE, AGILE).
  • Developed BPEL process for tight integration of Oracle ERP – TCE, AGILE.
  • Interfaced with external systems by defining common XML schemas.
  • Defined WSDL for BPEL process, partner links, BPEL process templates and developed process logic definition.
  • Developed several XSD and DTD Schemas for XML validations. Used Oracle Rules Engine to configure Business Rules. Configured and Deployed web services security Policies using Oracle Web Services Manager.
  • Implemented a BPEL process by levering the existing conventional business flow mapping legacy system with Oracle E business suite
  • Developed Human Workflow using Oracle Task Manager Worklist Application for the Approvals of the ECO in Oracle Applications.
Environment: Oracle SOA Suite, Oracle JDeveloper, OC4J, PL/SQL, XML, XSD, TCE, AGILE.
Confidential , CA
Role: Oracle Fusion/SOA Suite Developer
Responsibilities:
  • Gathered business requirements for the Item Integration and developed High Level Design Documents.
  • Developed various Web Services using WSDL, SOAP and Oracle J-Developer.
  • Involved in using various BPEL Process Activities like Assign, Invoke, and Transform.
  • Involved in designing both the Synchronous and Asynchronous BPEL processes.
  • Developed and Registered Various ESB services.
  • Responsible for working over the Fault Handling using the catch and catchall block.
  • Designed SOA web service interface so that shipment orders can be placed automatically.
  • Designed and developed an ESB to route to a different procedure on Oracle EBS.
  • Used Oracle ESB for content based routing with synchronous/asynchronous messaging techniques.
  • Prepared XML schema's for Design Patterns.
Environment: Oracle SOA Suite 10g(BPEL, ESB),Oracle Financial Application, Siebel System, Oracle J-Developer, WSDL, SOAP, XML, XSD, DTD, XSL, Linux.
Confidential, Hyderabad India
Role: Oracle Applications / PLSQL Developer
Responsibilities:
  • Imported ITEMS from legacy system to Inventory base table MTL SYSTEM ITEMS B using the standard item import program through a custom package that validates individual records.
  • Developed code to import costing data of items imported from flat files to Costing tables directly.
  • Involved in the development of customer Interface.
  • Involved in importing Sales order data into Oracle Application base tables. Wrote PL/SQL procedure to validate data and load into interface tables & using order import inserted orders into base tables.
  • Involved in creating new messages and attached them to oracle forms as per business requirement.
  • Developed Pick confirm and Ship confirm Interface using oracle API’s.
  • Involved in rewriting some of the existing custom interfaces in PL/SQL to reduce the turn around time of execution and completion of concurrent processes.
  • Customized the schedule order form and moved Promise Date from one canvas to another.
  • Involved in Customization of Standard Oracle Reports in purchasing and order management as per client requirement.
  • Involved in Design and development of importing the BOM Components from the legacy system.
  • Developed workflow to do WIP Move Transactions interface, to bring in the shop floor move transactions occurring in the legacy System.
  • Involved in development of pricing formulas, setting modifiers and attached qualifiers also implemented Discount modifier list.
  • Performed various activities like creating, debugging and modifying Stored procedures, functions, packages, triggers, tables, mviews and user defined functions, etc.
  • Designed and developed scripts for uploading data from flat files and XML files into database and perform business validations on data using PL/SQL procedures.
  • Developed Shell scripts using vi editor to create FTP jobs and to schedule jobs
  • Extensively used PL/SQL tables and Bulk loader programs for processing data and loading into oracle tables.
  • Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
Environment: Oracle Applications R12.0.4, 11.5.10.2, Oracle Manufacturing, PL/SQL, Oracle 9i,10g Forms & Report, SQL *Loader, UNIX shell Scripting.
Confidential , India
Role: Jr. Oracle Developer
Responsibilities:
  • Imported ITEMS from legacy system to Inventory base table MTL SYSTEM ITEMS B using the standard item import program through a custom package that validates individual records.
  • Developed the PL/SQL codes on the basis of the requests for the change.
  • Coordinated with the business users to collect requirements.
  • Modifying & Creating PL/SQL Procedures, Functions, Packages, Triggers, SQL Queries for Reports.
  • Modified, maintained and developed the SQL codes to develop new enhancements.
  • Performance tuning: Partitioning the fact tables and materialized views to enhance the performance.
  • Worked on SQL queries, SQL Tuning, PL/SQL Tuning & Performance Tuning
Environment: Oracle 9i, SQL, PL/SQL, Forms 6i, Reports 6i, UNIX.

Hire Now