SUMMARY

• Having around 14 Years of experience in IT industry with emphasis on Development, Implementation and Support of projects
• Skilled on EBS and Cloud environments in across modules mainly into Account Payables, Account Receivables, Order Management, Inventory, General Ledger, Purchase, Cash Management WIP and BOM
• Good knowledge on Order Management, Payables, Account Receivables, & Purchase order Functionalities and flows
• Strong exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Tables.
• Experience in Oracle Integration Cloud with multiple Integrations using App Driven, Schedule Orchestration, and FTP
• Used FTP, REST and ATP Adaptors as part of Integrating Legacy with Cloud Instances (SaaS, PaaS)
• OIC Integrations defined with Lookups, Parameters, Loops (For - Each) and Re-process mechanisms
• Requirement gathering preparing technical documentation, operated as a single point of contact for the customer on the technical deliverables stand point
• PLSQL Performance tuning, Debugging, TK proof, Trace
• Experience in creating & publishing Sandbox for Springboard personalization
• Good Experience in Core HR and Fast formulas, Global Payroll from the technical perspective
• Good Experience in Develop the Descriptive and Key Flex fields.
• Code Review and Code deployments UAT
• Involved extensively on Fusion utilities like FBDI Loader, HCM Data Loader (HDL), Spreadsheet Loader, Payroll Batch Loader, BI reports and HCM Extract.
• Good Experience in HCM Data Loader File Generation/file preparation.
• Data migration experience using Alteryx tool, ETL Testing, Developed Complex SQLs for the data migrations and Testing
• Good knowledge Web services such as REST/SOAP services by using Payloads in XML and JSON.
• Extensive experience in Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, parameters and standard request submissions in the process of development.
• Worked on Integrations for sending data to the third-party systems/vendors with encryption mechanism.
• Shell scripting (BASH) knowledge, FTP, SFTP, and Connectivity with different Linux boxes
• Experience with oracle and other utilities: Sql*Loader, Toad, SQL Developer

TECHNICAL SKILLS

Fusion Applications: Finance (AP, AR, GL, CM) SCM(PO,INV,OM) WIP& BOM

Oracle Applications: OM, PO, Inventory, AP, PA, AR, GL

RDBMS: SQL, PL/SQL

ERP: Oracle Apps 11i / R12, Oracle Fusion Application

Development Tools: Oracle Reports, Forms 10g, Workflows API’s, Oracle BI Publisher, OTBI, HCM Extracts, HDL,FBDI, Spreadsheet loader, SQL Loader, Smart View, Putty, WinScp, File Zilla, Service now, GitHub, SVN, Alteryx

Database and Tools: Oracle 10g and 11g, SQL Loader, SQL Developer, Toad, Putty, WinScp and SVN

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Fusion FSCM Technical Consultant

Responsibilities:

• Involved in Accounts Payable Configurations, Key set ups as to load Invoice and Accounting information to Application
• Created Integrations to send an email notifications using OIC Attaching BIP report out after staging it after converting the same from Base64 Format
• Worked with Agents on a High Availability Environment
• Created integrations to Read data from FTP Servers
• Created Integrations with Parameters, lookups, For Each and Error handling mechanism
• Involved in Order Management and Inventory level configurations to load Items and sales Orders data
• Integrated HCM adaptor for bulk Data load operations, HCM Extraction experience
• Customers spreadsheet load Approach for AR applications
• Item Conversions to the application as to load Item related information
• Supplier, Sites, Address, contact related information loads using FBDI
• BIP reports for Customer Invoice and supplier payments with bursting concepts
• OTBI reports for functional analysis
• Created OIC Integrations for ATP Database using PLSQL packages
• Created Sandbox as to personalize report level information on the spring board
• Experience with creating Integrations using Rest APIs, FTP, Salesforce, ERP adaptors
• Experience in requirements gathering, solution design, configuration, functional specifications, testing & deployment.
• Conducted user training sessions on the reports and processes
• ESS Jobs register and scheduled
• Conducted Conference Room pilots with clients.
• Created BIP reports with Parameters, List of Values and different Delivery Channels Scheduled
• Worked on Integration legacy system to extract the data
• Maintained the local repository and script for reuse.

Confidential, Atlanta GA

ERP - R12 Technical consultant

Responsibilities:

• Effort estimations, Gap analysis, Technical designs
• User training sessions, Process flows for business understanding
• Contributed on customizations and development of PLSQL Packages and procedures
• Performance tuning of existing objects
• Couple of Interfaces and conversions developed
• Supported in fixing up bugs/Issues within the time lines, Suggested code changes as to achieve new functionalities
• Involved in extending VO and CO level change for OAF
• Single point of contact to the business on the technical deliverables and deployments
• Worked on Agile methodology, Two week sprints and JIRA tasks for regular intervals
• Involved in Month end closures & Involved in bank reconciliations
• Created Alerts, Triggers, Concurrent Programs schedule and maintenance
• Created/edited Cron related jobs using Linux
• Involved in the Code review activities before migrating to another instances
• Developed and customized XML publisher reports
• Version control monitoring and technical spec design for the development scope
• Conducts brainstorm session with in the team for better understanding the integrations and processes

Confidential, Alpharetta GA

Responsibilities:

• Created Customer conversion using Public APIs
• Item Import
• Sales order Import
• Developed many custom Procedures and Packages
• Involved in verifying functional setups, Lookups for cycle flows
• Developed Xml Publisher reports with multiple layouts and multiple templates
• Involved in Procedure and Packages performance tuning
• Created alerts, Triggers, Concurrent Programs schedule and maintenance
• Created/edited Cron related jobs using Linux
• Deployment, UAT and Customer calls for Requirement gathering
• Month end /Quarter End /Year End Activities for closing AP and AR books
• Involved in reconciliations process
• Bug fixes in the codes and couple enhancements
• Version Control to check in and check out the codes for every processes
• Issues related to Integrations, Data exchanges and generic workflows and roles
• Prepared technical documentation after every integrations and conversions
• Involved in oracle Form personalization activity
• Written couple of out bound interfaces and scheduled them for the integrations
• Fixed issues as per the SLA, Including Priority 1 Issues
• Conducted team calls for regular connect and support

Confidential, Alpharetta GA

Responsibilities:

• Created, Customized procedures, Package and Functions
• Concurrent program defined, Alerts, Events created
• Code fixes for Integration level issues
• Created reports from AP, AR and Inventory modules
• Tuned PLSQL procedures which was running more than the expected executions time
• Created XML publisher reports using data template & PLSQL Approach
• Customized RDF reports
• Functional setups verifications when required
• Code deployment and participated in UAT
• Conducted daily scrums and weekly calls with stakeholders
• Created MD70 other technical and training documents
• Created reusable scripts for the repository
• Created triggers
• Involved in Form personalization
• Workflow related issues as part of production support
• Involved in Month end/Quarter/Year End activities

Confidential, Alpharetta GA

Responsibilities:

• Prepared Tech design documents.
• Giving estimation for development and testing
• Prepared migration documents for Deployment teams
• Worked on reports, interfaces and conversions
• Interacting with Onsite team.
• Worked on Daily Support Issues using Service now tool
• Worked on Custom process for Order management.
• Worked on integration activities like migration of data from Legacy System to Oracle EBS.
• Involved in Development of outbound interfaces.
• Involved in Performance Tuning of queries.
• Involved in configuring functional setups for assigned modules, evaluating/ mapping business processes to Oracle E-Business Suite
• Involved in development of custom OAF pages for various modules in application
• Configure test instance and test required functionalities to cater to functional requirements
• Organize UAT sessions. Test Automated Sourcing process post applying procurement patches applied by DBA team on non-production instances
• Migrate approved setups to Production Instance post UAT signoff followed by configuring setups on Production environment as part of post GO LIVE support
• Development of custom reports based on Business Requirement
• Work with Business Users for support and development of custom objects related to above-mentioned module.
• Understanding the Business process of the organization and its mapping to Oracle E-Business Suite

Confidential

Responsibilities:

• Technical Consultant involved in integrated legacy applications Invoices with account payables, PO and Inventory related aspects
• Involved in validation configuring functional setups for assigned modules, evaluating/ mapping business processes to Oracle E-Business Suite
• Prepare functional specification document (RD-020) using OUM methodology as well as future business process document (RD-010) based on discussions with business
• Render functional support to technical consultants in developing OAF customizations Worked on Development of new custom OAF pages and Forms.
• Test/ align custom reports & OAF customizations based on RD-010 document
• Configure test instance and test required functionalities to cater to functional requirements
• Organize CRP and UAT sessions. Test Automated Sourcing process post applying procurement patches applied by DBA team on non-production instances
• Migrate approved setups to Production Instance post UAT signoff followed by configuring setups on Production environment as part of post GO LIVE support

Confidential

Responsibilities:

• Created custom packages and procedures for Sales and prorate commission
• Created /modified XML publisher templates
• Defined Request sets for Concurrent programs
• Interfaces and Conversions
• Seeded APIs and Custom APIs have used to load and validate the data
• Developed SSH Connectivity between the Linux boxes
• Created evens, Alerts, Triggers
• Created DFF on a form personalization
• Involved in designing the tech document
• Participated in UAT and Customer training sessions
• Written reusable scripts for the benefit of the team
• Trained and mentored juniors
• Prepared documents for the deployments
• Used Version control for checking in and checkout of the code
• Conducted Code review activities at peer level & Primary level
• Defined lookups and list of values for Vales sets
• Worked on SLA for Bug fixes
• Involved in modify/customize the workflows