SUMMARY

• Over 8 years of experience in experience in Oracle E - Business Suite/Oracle Applications 11i with core expertise Oracle Utilities Customer Care & Billing (CC&B) Revenue Management & Billing (RMB) Techno functional area and Technical Java Development. Around three years of experience in Java/J2EE Applications development.
• Experienced in Crystal Reports, Bl Reports and PL/SQL reports on CC&B.
• Hands on experience Modules like Taleo, recruitingcloud, Learning Management, Goals and Performance Management, Core HR, Compensation, Benefits, Payroll and Absence Modules.
• Extensive experience in creating OTBI Reports,BIPublisherReports and FastFormulas.
• Experience in Configurations, Personalization, and fusion role-based Security,HCMData loaders (HDL), Spreadsheet loader, OTBI Reports,BIPublisherreports,HCMExtracts, Workflows and approval configuration, Fast Formulas for Absence.
• Expertise inOracleRAC including CRS management, ASM disks/disk groups management, srvctl configuration, maintenance, grid infrastructure installation/upgrades, OCR and Voting files maintenance, ASM spfile migration.
• Expertise inOracleData guard including active/logical data guard, dgmgrl broker management, broker deletion, broker reconfiguration, disable/enable/add/remove database from broker, Data guard switchover/failover.
• Experience in advancedPL/SQLconcepts like Bulk collect, Bulk Insert, MultiTable insert, Cursors, Ref Cursor, Collections, Nested tables, Arrays, Records,Types.
• Hands-on development, maintenance, and support experience with theOracleCloudHCMmodules, tools, and associated components, including configuration/customization strategies and implementations, workflows, groups, roles, etc.
• Experience with Integration Oracle Utilities Application like (OUAF) I CC&B (Customer Care & Billing) and PSRM (Public Sector Revenue Management) System from SOA.
• Strong experience and knowledge of XML Technologies (XML, DTD, XSLT transformations, XSD and Style sheet etc.)
• Hands on experience in configuring and maintainingOracleRAC, Standby (DataGuard) and RHCS cluster databases for HA andDR purposes.
• Experience with multiple RDBMS includingOracle19C/12C/11g/10g/9i/8i, MicrosoftSQL Server 2000/7.0/6.5 and associated SQL Dialects such as Transact SQL (T-SQL),PL/SQL.
• Experience and analyzing requirements and translate business needs into long-term business intelligence solutions leveraging MSBI suites (SSIS, SSAS, SSRS), Power BI, Tableau and Micro Strategy.
• Experience in Data Mapping and integration process such as defining data source and target in XML structure as well as Meta data management.
• Hands on experience in various reporting tools such asOracleOTBI, OBIEE, BI Publisher, Workday report writer, Microsoft power BI, Salesforce Einstein and Tableau.
• Hands on experience in requirement gathering from business users for documentation of Business Requirement Documents (BRD), transformation of requirement to Software and Functional Specification for the documentation of Functional Specification Documents (FSD)/Software Requirement Specifications (SFS).

PROFESSIONAL EXPERIENCE

Confidential, North Liberty, IA

Sr Oracle SCM Functional Consultant

Responsibilities:

• Working on application security testing on Consolidation ICIS project, primarily worked on solving Test Cases/Test Scripts on CC&B, MDM and ODM. Responsible for the patch management policies for all the EBS instances for the Project INSPIRE. Responsible for driving data conversion/migration and interface planning activities to integrate ETM with Oracle OM. Working asOracleFusionsubject matter expert providing best-practice guidance.
• Working on Solution design for Lift and Shift migration of Oracle EBS On-premise application to Oracle Cloud ERP and CX applications. Java/J2EE CX Extension creation for Configurator. Functional Companion
• Responsibilities Member of the core team responsible for implementing and setup of GL and AP Involved in current system analysis and GAP analysis system configuration and testing in GL and AP module implementation.
• Responsible for running the Participation Process, Creating Life Events, Life event Summary Report, Enrollment Process inOAB(OracleAdvance Benefits). Research, evaluate and establish business processes associated with ERP.
• Worked on the Functional mapping of data Conversions & Enhancements for PO, I-Procurement, Advance Pricing, ASCP, Demantra, INV, BOM, WIP modules. Implemented the Available to Promise (ATP) functionality based on the collected data from planning. Implemented and CustomizedOracleECC(Enterprise Command Center) for iProcurement module.Managed Oracle SCM data team SME's, business users, contractors, data load schedule/timeline.
• Worked on Global order Promising (COP), Available to promise (ATP) rules setup, make to stock (MTS), Assemble to Order (ATO), Pick to Order (PTO), Drop ship order, Internal orders (IR-ISO), Invoice only orders, Ship only orders, Return orders processing, Scheduling, sales agreements. Worked on the setups of the Order to Cash Business flows (OM INV, po, Advance Pricing, 80M)
• Worked asOracleFusionsubject matter expert and helped the team in extractingBI reports using file-based loader (FBL) and spreadsheet loader.
• Responsible for the successful delivery of Global Core HR, Absence Management, Benefits, Global Payroll, Talent Management, TimeandLabor, and Workforce Compensation version R13:18B.Creating Item Templates in Oracle Inventory management module by modifying the control level options.
• Developed custom API to provide item availability information for online customers using seededATPAPI. implementation of Oracle RI 2 Master Data Management, including Product Data Hub (PDH), Customer Data Hub (CDH) and Supplier Data Hub (SDH).
• Developed, modified and Executed Test Scripts for INV, BOM, WIP, 0M, PO, iProcurement, AP and AR. Done personalization of Misc transaction form to control unauthorized use.
• Worked with OM leaders to bridge the gaps betweenOracleEBS OM module andOracleASCPto develop optimal category management strategies. and reporting applications and support as part of the SAPECCbrown field implementation life cycles modules - FICO, SD, CRM, MDG and EWM.
• Worked on apply hold procedures to apply hold on orders ifATPfails (Items on orders are not in stock for a given requested ship date), or order validation fails.SCM functions optimized, integrated, helped production planning and better financial controls. Design and Develop log miner-based replication from hub to spoke schema for Confidential .
• Implemented an Advance Supply Chain (ASCP), and a customization for releasing recommendations fromASCPfor WIP/PO which satisfy predefined business criteria.Flow Testing for SCM Modules (AR, AP, 0M, QP, 80M, INV, PO) to make sure flow is working without any issues.
• Implementing CX Oracle Cloud and EBS applications for Telecom, Retail, High Tech, Med Device and Software industries.
• Implement auditing and chain of custody guidelines, governance for SharePoint libraries. And identifying business requirements for Core HR, Goal, Performance and map them toOracleHCMCloudApplication functionality.
• Designed Conversion Strategy and Conversion Data Mapping Documents for HR/OAB,OTL modules and wrote conversion programs using API's.To migrate the existing Oracle HRMS ERP EBS RI 2.1.3 from the HPLIX environment to Oracle Linux environment. validated payroll setup, payroll elements and payrollfastformulas.Support the end users and resolving issues identified in SCM modules.
• Developed and modified SharePoint user privileges as directed. Supported for one of the biggest SharePoint farms in the world. Mapping and Functional Specifications for Data Conversion Programs related to AR, AP and GL modules.
• Created new invoice templates for newly created AR Transaction Types and registered the same in BPA.
• Design & Strategy of OIC components such as Lookup’s / Packages / NamingConvention /Error Handling /ATPDB
• Worked extensively on Inter Company transactions, Inter Organization transactions in Inventory management application. using these functions and procedure on the Misc. Transaction form of Inventory Module to populate the COGS account in the account field of the form.
• Created a new view for AR transaction lines and registered it as a custom data source in BPA (Bill resentment).
• Worked as a SCM Functional Consultant implemented modules - OM, PO, Advance Pricing, Shipping, INV of Oracle e-
• Business Suite. Developed BI reports/OTBI inOracleFusionCloud and scheduled the report to be delivered to Email and FTP.
• Involved in requirement gathering sessions, fit gap analysis sessions, implemented theoraclecloudcompensation from paper based using HDL and HSDL.Involved in migrating the EBS-HPLJX to Linux-RHEL platform.
• Working extensively on XQuery and XSLT transformations in OSB to provide mapping between the consumer and provider business service. Implementing complex Oracle ERP applications.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances. Implemented several monitoring scripts; alerts for better user experience in the EBS.
• Implementation of E-Business Suite Applications HRMS -HR,OABand OTL.Well versed with Fast formulas, value sets and used HCM Extracts and BIP Extracts across core HR, Payroll andOAB.

Environment: s & Tools:CC&B, OracleHCMCloud, BI Analytics,HCMExtracts, HDL Data Loader, EBS, BPEL, SOA, Oracle Database 11g, OATS, SQL Developer/Query Builder, VMware, Rational Clear Case, Clear Quest, WinSCP, MS Office 07/10, MS Lync, SharePoint, OUAF, BPA, XSLT, PL/SQL, OAB, ERP.

Oracle Functional Consultant

Confidential, Houston, TX

Responsibilities:

• Responsible in making sure that Data guard standby is in sync with the primary and making sure no error in DG Broker configuration. And for the implementation and conversion of the Oracle Consolidation Process in GL RI 1.5.10
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL andPL/SQLengines Prepared Functional Document for ATP and configured it the system ad tested end to end ATP flow.
• Create BR.100 Application setup and CV.040 Conversion data mapping documentation for GL, AP, AR, SLA Sub ledger Accounting Contributed towards Conference Room Pilots CRPI and CRP2 Coordinate with offshore technical team for data conversion. Worked onfastformulasin Payroll and absence management offerings.
• Developed User exits, Plug-inscripts, Servicescripts,BPAScripts, Maintenance extensions and UI Maps. Involved in improving system performance.In implementing ROLE based security as per SOX and OCC compliance and audit.
• Worked on the implementation ofOracleE-Business Suite R12 that includesOracleHR, Payroll,OAB, OTL and Oracle Financial modules.Data Mining - linking to DB in Access, SQL, SharePoint and other sources.
• Developed, designed and configuredOracleFusionMiddleware components: suite consisting of 4-node Weblogic cluster - SOA and SOA Cloud Services (SOACS), ODI,including web-based, IVR and middleware (El) systems.
• Worked as anOracleFunctional consultant for SCM/ASCPModules. Responsible for following up the issues logged by end users, resolving the issues, documenting the resolutions.
• Responsible for the Global (Mexico, Columbia, Canada, Spain to name a few) Implementation of HR, Payroll, Time and Labor, Compensation, SSHR, Advanced Benefits and Absence Mgmt version 12.1.3
• 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 data structures.
• Created and registeredBPAinvoice templates for newly added Oculus Invoice, Credit Memo, and Debit Memo transaction types.Obtained and signed off documents and tests from Oracle ERP side.
• Designed legacy data conversion strategy for HR, Payroll,OABand OTL modules. And Utilized SharePoint API sets like CSOM, JSOM based on requirements. Define pick release, pick release rules, shipping parameters, ATP, PTO modules, checking, availability and reservations.
• Worked on theASCPSetups for Collection, ODS Load process, Demand and Supply time fences, enabled EDD and ECC options for plans, defined the plan options, etc.Performed the functional Unit Testing, Integration testing and Performance Testing of SCM and Planning system,
• Work as part of a team and provide 7x24 support when required and Managed Production database work order tickets to which assigned in accordance with the Service Level Agreement (SLA) to ensure all tickets are processed on time and in track with project schedule. In various cloud modules including CX, CPQ, WMS, OTM, Marketing and EPM.
• Used accounting setup manager for implementation Intercompany multi-organization framework on GL, AP to extract data from legacy system into Oracle Applications open interface tables and for implementation of GL AP and I-Expense
• Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.actively participated on Spreadsheet Upload tool enhancements in PDH - Provided the preview functionality to review the taging data before committing it to the PDH
• Designed and developed several customized report in Finance ERP application and enhanced Front end UI such as cash management, payroll costing, procurement etc.
• Worked asOracleFusion subject matter expert providing best-practice guidance on HCM business processes on OTL and Payroll integrations and mass updates
• Implemented SDLC, which include Waterfall methodology with requirement specifications phase and development phase for overseeingOracleEBS Capabilities and best practices.
• Prepared the functional specifications for the custom Fast Formulas,BIpublisherreports and extracts needed for the client for compensation andRecruitment modules.

Environment: s & Tools:OracleEBS, SOA, BPEL,OracleDatabase 10g/11g, SQL Developer, VMware, Rational Clear Case, Clear Quest, WinSCP, MS Office 07/10, MS Lync, CC&B, BPA, XSLT, PL/SQL, OAB, SharePoint, GL, AP.

Confidential, King of Prussia, PA

Oracle HRMS Consultant

Responsibilities:

• Responsible for managing the documented System Requirements and Requirements Traceability Matrix using Rational Requisite Pro.
• Responsible for installation, upgrading and applying latestOraclesecurity patches in addition to corporate security requirements.
• Developed various BI Reports as per business requirements (OracleCloudHR,Benefits, Absence Management and SCM Modules) of various other Excel VBA applications for the Credit Flow Trading Desk.
• Worked as a senior CCB developer for a large IT company providing support and development for a utility billing product (Oracle CC&3 OUAF Ver 2.4/2.6) for a utility client.
• Used Shell Scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing Tables, and Rebuilding of Indexes.
• Worked with technical team closely to develop the reports using theHCMExtracts andBIpublisher.
• Developed severalPL/SQLpackages, procedures, functions, triggers from GUI events or database triggers, to implement complex business logic.
• Responsible for writing Functional Requirement Specifications FRS and User Requirement Specification URS.
• Designed logical and physical data model, Storage Capacity Management as well as Backup and Recovery.
• Managed various Projects related toOracleE-Business Suite - Implementations,Conversions and Upgrade.
• Worked as a Project Manager for the implementation ofOracleHCMCloudand Taleo application for the current customer using Axiom as the reporting software which included development of Excel VBA applications.
• Designed and developed complex reports including sub-reports, parameter-based reports, graphical reports, formula based, well-formatted reports, analysis reports and data reports.
• Developed front end using MS Access to enter data and to view report and established ODBC connection with the SQL Server 2012.
• Used MS. Visio for model diagrams and Ms. Office package for Documentation and UML for class and visual modeling.
• Created and maintained OBIEE RPD's, analysis and dashboards for rapid development for end user business intelligence reporting.

Environment: s & Tools:OracleApps, Java,OracleDatabase 10g, SQL, Toad, ADI, HP Service Manager, HP Planning & Portfolio Manager (PPM), MS Office 2007, OUAF, PL/SQL.

Confidential, NYC, NY

Oracle Analyst

Responsibilities:

• Responsible for performing GAP analysis, SWOT analysis, and Risk analysis.
• Involved in Test Planning, Data Preparation and also Test Execution of the CC&B upgrade from CC&B VI .5 to CC&B V2.3 and also General Rate Case (GRC) implementation.
• Performed Functional, Regression, Ad hoc, Backend and Smoke testing on various Crystal and Webi Reports
• Involved in full life cycle of the project from Design, Analysis, logical and physical architecture modeling, development, Implementation, testing. Supported the Daily LCR, IRR, NSFR and FTP use cases.
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Prepared System Requirement Specifications (SRS) to capture release requirements.
• Involved in perform Configurations as per the design for HR, Payroll, Self Service, Learning Management, Approvals Management and OAB modules.

Environment: s & Tools: JIRA, HP Quality Center, Toad, SQL Server.