SUMMARY:

• Over 9+ years of experience in analysis, design, development, testing and implementation as Oracle PL/SQL Developer.
• Extensive experience in Oracle Service/Customer Relationship Management (CRM/JTF): Service/TeleService/Service Requests/Case Management/Customer Support/Customer Care and Billing (CS/CSS/CSC/CC&B), Installed Base (CSI/CSE), Service Contracts/Contracts Core (OKS/OKC), CRM Foundation (JTF), Trading Community Architecture (TCA/HZ), iSupport (IBU), Customers Online (OCO/IMC), Service Intelligence (BIV);
• The Oracle Cloud Solution Consultant(PaaS) is an Oracle Public Cloud (“OPC”) subject matter expert (“SME”) andtechnical and business architect, overlaying with Consulting sales to drivesuccessful implementation of extensions, integrations to and from Oracle SaaSusing Oracle PaaS platforms on Oracle Public Cloud
• Expert at implementing, configuring Oracle GRC tools and leveraging the GRC tools to address violations and enforce controls
• ERP Fusion HCM Application Release 9, 8, 7 5 SaaS/Cloud, On Premise On Demand Models - Workforce Deployment, Profile Management, Talent Review, Workforce Directory, Succession Planning, Performance Management and Goal Management
• Experience in Technical and Functional Oracle HCM,Fusion HCM and PAAS Application Implementations
• Experience in Oracle Applications modules INV, BOM, WIP, WMS, Costing, PO, AME, OM, AR and AP
• Good knowledge on Mobile GUI, WMS Application integrated to Order Management Application
• Having experience in Creation of Security Profiles and Roles in Fusion HCM
• Fusion Middleware Oracle SOA 10g, Web Services, BPEL, ESB, XSLT, JDeveloper, Cloud Control Enterprise Manager 12c, Page Composer
• Experience implementing Oracle Single Sign-on (SSO), Oracle Internet Directory (OID), Oracle Identity Management, Oracle Grid Control, Oracle SOA Suite, Oracle Transportation Management(OTM), Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Data Integrator, Oracle Business Accelerators (OBA), Oracle Collaboration Suite, Real Application Clusters(RAC) or high availability oracle operating environment, SOA Suite with SSL
• Expertise in Order Management, Shipping, Inventory, Purchasing, Advance Pricing, Quoting, BOM modules, Oracle Subcontracting, Accounts Receivable, Oracle Customer Data Hub, Approval management engine AME, MRP, WIP, BOM, Quality, ASCP, Costing, OTM Oracle Transportation Management
• Extensive experience in Oracle Fusion Middleware stack such as ADF ADF Faces ADF BC, SOA, BPEL,ODI, Weblogic
• Oracle Utilities Customer Care and Billing (CC&B)
• Experience in large-scale SOA/EAI implementations using Oracle Fusion Middleware (Oracle JDeveloper, Oracle SOA Suite, Oracle OSB, Oracle BAM and Oracle Weblogic)
• Expertise in Enterprise Service Bus (ESB), Oracle Mediator, Java Message Service (JMS) Queues, Oracle Advanced Queues (AQ), Oracle Resource Adapters.
• Experienced in Oracle E-Business Suite(ESB)
• Highly proficient in Oracle SOA suite of products
• Good working experience in Oracle Demantra
• Solid experience in Java & J2EE based application & web services development
• Expertise in Oracle 9i,10g,11g and 12c Databases
• Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB triggers and Indexes
• Good working experience in Forms 9i, and Reports 9i Reports
• Strong skills in using tools such as PL/SQL developer, SQL*Loader, TOAD, Sql Navigator and SQL*Plus
• Experience in tuning sql statements and procedures for enhancing the load performance in various schemas across databases
• Proficient in Data modelling(Dimensional and Relational) concepts like Star-Schema Modelling, Snowflakes Modelling, fact and dimension tables
• Experience with Data flow diagrams, Database normalization theory techniques, Entity relation modelling and design techniques
• Effectively made use of table functions, indexes, table partioning, collections, analytic functions, materialized views
• Proficient with Oracle supplied packages such as DBMS HTTP, DBMS JOB and UTL FILE, UTL SMTP and working with DynamicSQL, collections, and exception handling
• Created functions to involve REST and SOAP web services from PL/SQL using DBMS HTTP API
• Responsible for Database Cloning, Patch Application, Unix Shell Scripting, Backup& Recovery and Documentation. Installing and Configuring Oracle11g grid and Data Guardmaintenance in large environments
• Detecting and diagnosing production system performance tuning of the database - SQL tuning, used tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, sizing of tables and indexes measuring system and database activity, querying Oracle dynamic performance views
• Experience in Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues
• Extensive experience with Application servers and Web servers (Oracle Web logic 10.3, Oracle OC4J, IBM Web Sphere 5.x and Tomcat 5.x). Good experience in writing complex Oracle SQL queries, creating PL/SQL stored procedures, functions, packages, performance tuning and triggers
• Expertise in Object Oriented Design (OOD) & Analysis (OOA) based on Unified Modeling Language (UML) architecture. Experience in developing Class, Sequence, flow diagrams using Smart Draw UML and Star UML
• Experience in Java build tools such asAntandMaven

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Linux, AIX

Middleware SOA Integration Products: JCAPS 6.3 & 5.1.3, eGate SRE 5.x, Glassfish ESB, MTS, IBM MQ Series, BMC PATROL WebSphere MQ 4.1, IBM Websphere MQ Explorer 7.1, MQ Visual Edit 1.6.4.1, Introscope

Languages/Integration: Java, XML, Web Services, JAX-WS (SOAP), JAX-RS (REST), XSD, JIBX

Oracle / Tools: Oracle 11gR2, 10g, 9i, SQL Server 2005 and 2008Oracle Products:Oracle10g (Grid Control), OEM (Oracle Enterprise Manager), RMAN, OEM 12C, SQL*Loader, Import and Export(EXPdp/IMPdp), ASM, TKPROF, SRVCTL, SQL* Loader and SQL * Net, Golden Gate.

Web Technologies: J2EE (Servlets, JSP, EJB), JDBC, AJAX, JQuery, JavaScript, AngularJS, HTML, CSS

Testing: Junit, Integration, Regression, UAT and Post-Production Testing

Framework: MVC Architecture, Jakarta Struts 1.1, Spring 3.1, Hibernate 3.1, JSF 2.0, Axis

QualityTools: Win CVS, CMVC, Tortoise SVN 1.8.4, HP Quality Center 10

IDETools: NetBeans 6.9, MEB 2013 (My Eclipse Blue 11.0), WSAD 5.x

Tools and Packages: Ant 1.7.1, Apache Maven 3.0.5, Log4J, UML, RAD, FTP, MS Visio, BMC Remedy 7.5, Service Now, Requestit, Microsoft Solution Center, JIRA 6.0, Splunk, Atlassian Bamboo 4.3, Altova XML Spy, Access Now

Servers: WebLogic Server 10.3.5, IBM WebSphere Server 8.5 (WAS 8.5), Tomcat Server 7.x, Glassfish V2

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. PL/SQL Developer

Responsibilities:

• FollowedAgile methodology, accomplishing the tasks to meet tight deadlines
• Develop a monitoring system to constantly monitor the BPEL and ESB transactions
• Oracle CC&B, WAM, MDM and BI-Publisher Administration
• Installation and upgrade of Oracle GRC, TCG and PCG
• Provide leadership and expertise to define and recommend best practices for the following PeopleSoft HCM business process flow areas: Perform Planning, Perform Program Development, Perform Budget Planning Formulation, Self Service, Fusion Middleware, Oracle Database and Oracle GRC
• Hands-on lead for overall technology review and standardization of Oracle Application product stack including .Net, Java, Ruby, Python and Oracle GRC within and between different business units
• Using Oracle GRC hid sensitive tax payer related information being displayed in Form field related LOV’s in AP, AR and PO Inquiry functional menu related forms
• Worked on XML Publisher based reports and solutions, Oracle's Governance and Risk Compliance GRC tool, Workflow, Oracle API's, Advanced Queuing, Oracle Forms Reports enhancements
• Managed as the Oracle security and controls lead for a large Oracle R12 implementation, led the Oracle GRC conference room pilot CRP and provided guidance and strategy for the implementation of Oracle Identity Manager OIM
• Participated and led several RFP pursuits pertaining to IT GRC Archer and Agiliance and Oracle GRC
• Provided post-production support of Oracle Advanced Controls (GRC)
• Prepared and executed test plans for the Oracle GRC modules implemented
• Worked on set-ups for WMS replenishment tasks. Created WMS picking rules and all WMS set ups
• Provided WMS solution to the business which is suitable for their requirements
• Created BR-100 and BR-110 documents for WMS, Purchasing, iProcurement and Inventory
• Worked for Procure to Pay Process and Order to Cash Processes and module integrations with AR, GL, AP, OM, WMS and INV with in EBS System
• Integrating FIM Forefront Identity Manager with SAP R/3 GRC, IBM CPQ and Oracle Leasing
• Installation and configuration of PingFederate for SAML 2.0 integration with IBM CPQ
• Worked with a multi-national manufacturing client implementing fusion talent management in Release 9
• Works in Oracle HCM Advisory group in Consumer Industries and Product Services CIPS
• Highest level of customer services Oracle offers to their customers. Fusion HCM lead for developing skills in this knowledge area for SSC. Delivered first engagement for SSC on Fusion HCM and Talent Management areas
• Worked on HCM Extracts to fetch data from Fusion and sending this data thru different delivery options
• Hands on experience in PAAS,specifically, Oracle’s SAOCS, JCS, DBCS, Storage Cloud Service as it relates toSaaS Applications is a plus
• Provide leadership and hands-onexpertise and execution capability on the delivery PaaS based technicalsolutions to extend and integrate with ERP or HCM Cloud
• Involved in overall CC&B end-to-end data migration design, planning, development, monitoring resources and go live implementation
• Setup and configure Oracle Order Management and Purchasing modules to work with OTM integrations. E.g. Shipping parameters, and system profiles
• Setup and configure OTM to integrate with EBS and production scheduling modules. E.g. external systems, agents and web services
• Involved in administration, configuration and support of Oracle Supply chain Management System Oracle SCM, Oracle WMS,Oracle OTM
• Create in SOA 11g BPEL processes and customized existing seeded processes to integrate Oracle OTM with E-business R12, other legacy systems and production scheduling. This included requirements gathering, setup, and design and development tasks
• Trained the client resources on CC&B Administration and Data migration. Responsible for preparing training manual for the new and existing employees in the team
• Developed various Web Services using WSDL, SOAP and Oracle JDeveloper
• Develop FDMEE User Interface using ADF ADF RC ADF BC
• Profiling and monitoring of ADF performance
• Installed Oracle Demantra 7.3 and Integrated with ASCP
• Implemented Oracle Demantra applications like demand management, sales & operations planning, and trade promotions management solutions
• Worked on integration interface, workflow, methods, series and system parameters of Demantra
• Developed user interface using ADF framework
• Design and Developed ESB processes, configure database, file adapters and tuned BPEL and ESB processes
• Involved in the deployment of BPEL, Mediator and ESB services on to the production server
• 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
• Extensively worked on Development and Administration of RightNow CX product
• Developed internal portal based integration with RightNow, which allowed passthrough login for internal support representatives, so that internal applications, support representatives can have complete access to FAQs links
• Created workspaces, workflows, Agent Scripting and assigning to profiles
• Utilized both RightNow Connect WebServices SOAP List Objects and Message Objects to build reports
• Extensively worked on ROQL (RightNow Object Query Language)Object query, tabular query and ROQL custom objects
• Establishing RightNow reports based on RESTful API
• Created custom fields and Custom objects
• Modifying standard reports and building new custom reports
• Support the upgrade and Migration process from CP1, CP2 to CP3
• Designed Customer Portal look & feel and adding custom functionality to it
• Worked on Integrating Oracle Service Cloud (RightNow) with Oracle Business Intelligence Cloud Service (BICS)
• Implemented PL/SQL queries, triggers and stored procedures as per the design requirements
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs
• Worked on Improving the performance of the procedures and packages for populating and validating data
• Developed the Data mart for the base data in Star Schema, Snow Flake Schema and Multi Star Schema and involved in developing the Data warehouse for the Database
• Created Bitmap, Unique, Function Based, Clustered and Non Clustered Indexes, Partitions on the Database Tables
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of large queries
• Support and enhance existing IT Applications and services including, new EDI requirements
• Performed SQL and PL/SQL tuning and application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Handled errors using Exception handling extensively for the ease of debugging and logging error messages in application.Worked on SQL- Loader to load data from flat files obtained from various facilities every day
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements
• Worked on Oracle Fusion BPM Suite - BPM Composer and Studio
• Extensively worked with Service Oriented Architecture concepts and patterns
• Troubleshoot performance issues for the RAC instances (GC events)
• Used BCV split/Data Guard technology to migrate over 13 TB Database
• Supporting Data Warehouse Database i.e. over 30 TB in size
• Analysed 10046 trace and 10053 traces, that generates detailed information on how a statement is parsed, what the values of bind variables are, and what wait events occurred during a particular session
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Developed PL/SQL triggers and master tables for automatic creation of primary keys
• Handled JSP compilation and worked on remote applications
• Actively participated in R12 upgrade with 4 member team
• Production Support for SOA and Agile Applications
• Developed Maven Script for the build and dependency process
• Monitored and scheduled the UNIX scripting jobs
• Version Controlwas mandated throughSubversion
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, OEM 11g r2/12c, Data Guard, Siebel eScript / VB script, SQL, PL/SQL, Shell script, TOAD, PLSQL Developer

Confidential, Nebraska

PL/SQL Developer

Responsibilities:

• Implemented various customized Oracle reports using different techniques in Oracle sql/pl-sql
• Used Oracle ESB for content based routing with synchronous/asynchronous messaging techniques to ensure guaranteed notifications to approvers
• Managed implementation of Oracle GRC applications including AACG, CCG, and TCG
• Performed end user training and documenting procedures for all related Oracle GRC processes and controls
• Implemented full suite of Oracle Governance, Risk and Compliance products (AACG, CCG, TCG and PCG).
• Enhanced internal Oracle Cloud/ERP/ GRC knowledgebases including the development of training materials, methodologies, deliverables and tools
• Defined Oracle GRC (Governance, Risk, Compliance) polices and identified key issues
• Created several complex transformation objects using XSLT 2.0 and XML to transform the data coming from production scheduling into the XML schema required by OTM GLOG schema
• Maintained and enhanced Oracle EBS seeded Java concurrent programs that integrate with Oracle SOA BPEL processes using SOAP calls. e.g. The Outbound integration program with OTM
• Worked on customizing the out of the box SOA BPEL processes that integrates shipping execution and OTM using SOA BPEL 10g. This included customizing the BPEL database adapters, the PL/SQL programs called by BPEL and the XSLT based XML transformation programs that come with the BPEL processes
• Design, implement, configure, tune and maintain Silk Performer database for CC&B ( company biggest database, 22 TB) new roll out testing
• Using EBS suite to Provide robust, consistent integration framework with extensive infrastructure based on SOA principles
• Develop various ESB services for the legacy system integrations
• Created indexes on tables to improve the performance by eliminating the full tbale scans and views for hiding the actual tables and to eliminate the complexity of large queries
• Written complex SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators
• Extensively used DBMS Scheduler package in order to schedule the refreshment of the Materialized Views on a periodic fashion
• Designed and developed several views like Materialized View for data retrieval for the reports
• Created a package to generate the Trace file for the Materialized View Groups using DBMS SUPPORT Package
• Responsible for Tuning of application with the help of Other Team Members & Oracle Support
• Created Table structures along with Triggers, Indexes like Bitmap and Function based Indexes
• Tuned SQL queries to enhance performance, using the method Explain Plan both at backend and in Toad
• Performed SQL and PL/SQL tuning and application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Involved in migrating database from oracle 9i to 10g database
• Worked on Build administration tasks such as WebLogic Server installation, HA Cluster setup and configuration
• Worked on Weblogic and OSB deployment and continuous integration practices using WLST, Maven & Jenkins
• Worked on Oracle Fusion SOA Suite - Oracle Service Bus (OSB), Oracle Coherence, Oracle BPEL Process Manager, Oracle Web Services Manager (OWSM), Oracle Business Rules (OBR), Oracle Human Workflow, Oracle Event Processing (OEP), OracleJDeveloper and Oracle Application Development Framework (ADF), Enterprise Scheduler, Oracle Business Activity Monitoring (BAM)
• Backup and restoration of database schemas/tables by EXPDP and IMPDP
• Monitor TEMP tablespace, monitor alert logs for errors, Identify CPU issues in the Middle tier and eliminate them
• Used several Oracle predefined functions NVL, NVL2, DECODE, CASE STATMENT
• Experience in using various oracle pl/sql collections VARRAYS,NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts
• Involved in migrating database from Oracle 9i to 10g database
• Performed partitioning of tables in datawarehouse environment
• Managing and monitoring the data guard, Creation Of core Databases
• Restoring unknown backup to create new Databases for Corporate applications
• Managed tablespaces and other database objects
• Support and Maintenance of over 4000 core Databases for CISCO
• OEM monitoring for CISCO databases
• Handling PSU and CPU new releases and applying the recommended patches
• Managing RMAN reports and oracle version mismatch
• Created unit test scripts withJUnittool for covering code in various modules
• UsedLog4J to log various events and exception when performing various transactions by the users for debugging purposes
• Used Subversion/SVNas a version control and source repository system
• Implemented the Maven framework to ease the development, build and dependencies management thus saving huge development time to the organization
• Creating Oracle objects like tables, types, packages, procedures and functions
• Provided Production Support by interacting with the testers and fixing bugs

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, OEM 11g r2/12c, Data Guard, Siebel8. Client Application Configuration, SiebelEIM and EAI (Inbound and Outbound Web Services), eScript& Administration and Workflows

Confidential, NC

Oracle Developer

Responsibilities:

• Created the PL/SQL packages, procedures, functions applying the business logic to update the database.
• Handled production tickets/defects and solved problem with in time frame with accurate decisions and identified the root cause and fixed the same
• Proficient in RAC Performance Tuning
• Performance tuning of queries consuming excessive resources or slow running queries by providing required hints to the query
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan
• Was responsible for monitoring database, diagnosing errors, building, deploy, maintain and trouble shoot database objects
• Extensively used DTS package in Migration of the data from the previous timesheet database in SQL Server database to Oracle 10g
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries
• Involved in developing screens and generating reports
• Implemented various UNIX scripts to generate the data in CSV format
• Tuned several Oracle sql statements using Explain Plan, Auto Trace utilities
• Expert at database tuning, application tuning and performance monitoring. Fine tuning Initialization parameters, I/O, memory and operating system kernel parameters
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed
• Monitored system resource availability and responded to system memory and data issues

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, OEM 11g r2/12c, Data Guard

Confidential, PA

Oracle Developer

Responsibilities:

• Involved in Design, Development and Support phases of Software Development Life Cycle (SDLC)
• Ensured high availability and performance(24 hrs production support)
• Was responsible for implementation and release of database changes as submitted by the development team
• Interacted with development teams, business owners, and various levels of management
• Participated in data-sourcing, import and data validation activities
• Provided database change and release management
• Coordinated all Oracle system changes with the Operational DBA teams
• Ongoing proactive database-level performance tuning and pro-actively monitor database systems to ensure secure services with minimum downtime
• Managedall database objects in a large mission critical system and provided end to end DBA support system and application side
• Analyzed and resolved complex technical problems regarding the integration of object-oriented applications and infrastructure with relational database technology
• Monitored databases and performs tuning enhancements to optimize their performance. Developed and maintained utilities to automate problem determination, change implementation, and monitoring activities
• Participated as a team-member in data management strategies. Integrated data architecture with appropriate components of the extended enterprise, transaction factories, and the data warehouse
• Currently helping team to use existing infrastructure to achieve maximum benefit to reduce cost and maximum performance
• Was responsible for two critical online applications database’sperformance which has a hugebusiness/revenue impact
• Coded Maven build scripts to build and deploy the application on WebSphere
• Used JUnit framework for unit testing of application and Log4j1.2 to capture the log that includes runtime exceptions
• Used CVS for version control and used IBM RAD 6.0 as the IDE for implementing the application
• Supported Testing Teams and involved in defect meetings

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, OEM 11g r2/12c, Data Guard

Confidential, MN

Oracle Developer

Responsibilities:

• Responsible for database administration for a large and complex database system using Oracle6 and Oracle7, IDMS, IDMS/R and DB2.Responsibilities included performance & tuning, database design, data modeling, database installation, technical support, and investigation of new technologies
• Used datapump for schema refresh, and RMAN for database refresh and for backing up databases
• Well Experienced in taking cold backup for a very huge 15-Tb Database
• Experienced in user management, table space management, session management, undo management issues
• Experienced in managing space issues in the database level for table space and regular file system cleanup at UNIX level
• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applied Oracle critical patch updates, Implemented and Managed Data Guard, Replication, Backup and Recovery support and performance tuning
• Installed grid Infrastructure software on new Linux Servers for 2 node and 3 node RAC and failover environments and Oracle Grid Control11g Installation
• Migrated Non-ASM databases to ASM environment for high availability using RCONFIG
• Worked on OEM 12C grid for monitoring the listeners present in the oracle environment
• Worked troubleshooting RAC and implemented ASM features
• Applied necessary patches during installation and also in up-gradation of databases
• Installed and configured of Goldengate on 11g database for the bi-directional replication
• Resolved the issues in conflicts between the target and source database in Goldengate
• Well experienced in taking Cold 10g to 11g Backup for a very huge 15-Tb Database
• Migration of databases from using export/import and data pump export/import utilities and performed database refresh activities for business requirement and tuning purposes
• Generated AWR, ADDM and ASHreports for database issues

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, EXADATA X2-2, ASM, AIX, Golden Gate, Database Control, TOAD, ASM, AIX, Golden gate, Tivoli