Oracle EBS Consultant
Resume:
NARESH PASAM
PROFILE:
Sr Oracle ERP Analyst
adksa7@r.postjobfree.com
https://www.linkedin.com/in/nareshpasam/
Lives in : Atlanta, GA
Interests : Running, Watching & Playing Tennis,
Automobiles, Having Fun with Family,
Traveling, Exploring Breweries
EDUCATION:
2022(Anticipated): Ph.D. in Information Technology University of the Cumberlands, KY
2015: Masters in Computer Information Systems
College of Business, Colorado State University,
Fort Collins, CO
2009: Bachelors in Information Technology
Jawaharlal Nehru Technological University, India
PROFESSIONAL SUMMARY
Over 10 years of experience working across Health Care, Financial, Retail and Manufacturing industries in design, development, deployment, and support in large scale environments to wide range of business processes.
Extensive experience working as an Oracle e-Business Suite Consultant (R12/11i) and Epicor 10.
Proficient in customizing the business processes in Oracle EBS covering Procure to Pay & Order to Cash cycles including Financials (AP, AR, FA, GL), Supply Chain Management (PO, OM, INV, BOM), HRMS & CRM(OKS).
Proficient in automating processes through end-to-end internal and B2B technical integrations.
Expertise in building ‘state-of-the-art’ Data Visualizations, Data Stories, and Dashboards in OBIEE.
Hands on experience on Application Object Libraries (AOL), XML Publisher, D2K (Forms/Reports 6i/10g), SQL and PLSQL.
Experience with integrating OM, AR with third party tax software like VERTEX.
Proficient with TCA architecture and defining custom business process to handle critical financial operations.
Expertise in RICE Components that includes development of Reports, Forms, XML publisher, Conversions & Interfaces.
Proficient in creation and registration of Reports, Menus, Functions, Value Sets, defining Concurrent Programs, Request Sets and Executables.
Hands on experience in designing, developing, Extraction, Transformation and Load (ETL) scripts utilizing SQL, PL/SQL utilities.
Extensive experience in OBIEE Presentation Services including Answers, Interactive Dashboards, Cache Management, scheduler Configuration, BI Publisher.
Hands on experience on Noetix BI Tools, SAP HANA (MRP), SAP Lumira to visualize the data.
Proficient with SQL and UNIX Shell Scripting
Knowledgeable in Python, and JavaScript programming NARESH PASAM
TECHNICAL SKILLS
Enterprise Applications Oracle Enterprise Business Suite (R12, 11i), Epicor 10 Oracle Tools OBIEE 11g, Oracle Forms & Reports (10g/9i,6i), SQL*PLUS, Oracle 11i/10g/6i, Discoverer 10g, XML Publisher, Workflow Builder, JDeveloper 11g Languages SQL, Shell Scripting, Java, PHP, HTML, C#.Net, VB.Net EBS Modules Accounts Payables(AP), Accounts Receivables(AR), Inventory(INV), Purchasing(PO), Order Management(OM), General Ledger(GL), Project Accounting (PA), Fixed Assets(FA), Service Contracts(OKS), Bills of Materials (BOM), Human Resources(HRMS)
Version Control Tools Bitbucket, Tortoise SVN, PVCS Tools & Utilities AS400, Salesforce, Tibco, Splunk, SharePoint 2013, Toad, SQL Loader, Putty EXPERIENCE
October 2019 - Current: Sr Oracle Technical Consultant MedImpact Healthcare Systems – San Diego, CA
Work with Business Process Owners to understand and gather requirements to design, develop and implement solutions in Oracle Financials and Supply Chain modules.
Develop a platform to integrate Oracle with Salesforce via custom API to enroll bill rates and sum objects to process claims in Oracle EBS.
Build a custom application for Broker Fee Management using Oracle Framework and design underlying database components to support the architecture.
Automate payments transmission to financial institutions such as US bank and Bank of America.
Develop an API to automatically import employee expenses from Kronos and Chrome River applications to process invoices and payments from Oracle.
Design a process that automatically enrolls our clients to receive electronic payments by updating their payment preferences in Oracle’s TCA architecture.
Build encryption mechanisms as per HIPAA compliance to protect data privacy and prevent data thefts while transmitting data to external parties.
Triage with data exchange teams to extract claims, verify member eligibility through custom API, and process direct reimbursement using standard Oracle payment process.
Provide functional support to Account Payables (AP), Account Receivables (AR), Cash Management
(CM), iProcurement, General Ledger (GL), Purchasing (PO) teams.
Lead EOB(End-of-Business) closures by importing claims and new clients' information to Oracle and export critical financial information to Data Warehouse teams.
Triage issues corresponding to procure to pay and claims to cash cycles with end-users and external stakeholders.
NARESH PASAM
Feb’16 - Sep’19: Data Analyst
Cox Automotive - Atlanta, GA
Design custom components to help the client to achieve functionality in EBS application suite along with using Standard EBS flows.
Customize SLA (Sub-Ledger Accounting) to drive Accounting for complex revenue requirements based on Item type and Item definitions.
Triage any business issues related to Oracle SOA, Order Entry, Order Fulfillment, Invoicing, Customer, and tax issues (Vertex Q series).
Point of Contact for Order Management and Account Receivable issues.
Successfully integrated SalesForce(SFDC) and EBS using Standard and Custom API’s for arbitration business line.
Maintain and support Oracle EBS and the data flow from third party systems viz., AS400, Salesforce, Tibco to Oracle after gavel and assist users with achieving the key financial data.
Provide functional support to end users (Oracle Super Users), across the US Manheim operating units in OM, Receiving, Payable, FA, Inventory, General Ledger & HR modules.
Troubleshoot the data issues pertaining to Billing, Settlement & Floorplan functional areas.
Triage with various other business teams to recommend optimum solutions to help expedite the business processes.
Perform data loader validations from legacy to OM & AR.
Troubleshoot the workflow background activities to improvise the business process standards and expedite the issue resolution.
Lead data synchronization issues across the system and verifying the impact on downstream applications.
Perform scheduler activities to run the jobs automatically on daily basis based on the business requirement.
Actively monitor the in & out cash flows within Oracle Cash Management and triage with external financial institutions for any discrepancies.
Triage with the functional/development teams for process/data issues and assist them with raising SRs to Oracle to deploy patches if required.
Assist users with UAT/Pre-Go-Live/Post-Go-Live support for new functionality introduced.
Conduct Business Process review session, to improve client usage of seeded EBS functionalities.
Train Off-Shore teams on new enhancements during roll-out of the projects and their impact on the downstream applications.
Jan’15 - Dec’15: Epicor Implementation Intern
Wolf Robotics – Fort Collins, CO
Understand the legacy systems and their underlying database systems.
Develop migration strategies by analyzing the legacy systems for its conversion to the Epicor 10. One of the strategies involved developing stored procedures to pull the data, validate and migrate to Epicor.
Customize the Epicor Application using C#/VB.Net and Business Process Management (BPM) to meet various business needs.
Develop and customized the Crystal Reports as per the business requirements.
Developed an interface program to load data from custom tables to interface tables. NARESH PASAM
Aug’15 – Dec’15: Graduate Teaching Assistant
Colorado State University - Fort Collins, CO
Assisted professor to configure SAP environment to run MRP process through simulation.
Mentored students to help them understand SAP HANA and learn building visualizations using SAP Lumira.
Tutored students to build strategies to enhance their business process development like improvising the production efficiency, sales, revenues etc. to stand top among the competitors. Jun’13 - Jul’14: Oracle EBS Technical Consultant
NTT DATA – Hyderabad, India
Development of Data Conversion programs like Item, Vendor, Customer, Open PO, BOM & Routings conversions.
Extensively worked on Oracle Lockbox Processing (AR Lockbox) to efficiently process the data received from the bank.
Modified AR Invoice Report and Packing Slip Report with HS Commodity Code, Location.
Worked on the development of new reports, customizing seeded reports pertaining to order to cash modules such as AR, OM, and PO.
Involved in resolution of technical issues related to Oracle Supply Chain Management during implementation.
Setup and maintenance of all the alerts and notifications.
Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy data into Oracle environment.
Involved in preparation of MD-70, MD120 and Unit Test-case documents.
Customization of standard workflows as per Client requirement.
Preparation of .ldt files used for migration of objects into respective instances.
Developed customized pages using OA Framework. Modifying existing pages by customizing lov, button events, hiding regions, adding new view objects (VO) and customizing the controllers (CO) as per the functional specification.
Implemented NoetixViews, Noetix Generators & Noetix WorkBench in the client’s Oracle environment.
Developed custom reports using Noetix WebQuery as per the client requirement.
Held responsible for granting access to Noetix Environment to end users.
Created roles and responsibilities for various business users to access reports and view the data. May’12 – Jun’13: Oracle EBS & OBIEE Associate Consultant Noetix Corporation - Hyderabad, India
Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
Built prototype NoetixViews during the requirement-gathering phase to visualize the reports and clarify requirements.
Done customizations to NoetixViews using Noetix Workbench specific to the customer by understanding the customer EBS functionality.
Responsible for developing new reports based on the customer’s requirement. NARESH PASAM
Defined additional views (compound, table, chart views) of the data returned by the request to visualize data in many ways.
Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
Created custom CSS classes and styles, java scripts and HTML scripts to enhance the dashboard functionality and produce reports that meet user requirements.
Regenerating the OBIEE repository using Noetix Generator to make latest changes available in it to build the reports based on new requirements from the customer.
Involved in migrating OBIEE catalogs from Development to UAT by achieving it in several ways.
Coordinating with the Onsite Team for any enhancements to the existing requirements and involved in maintaining customer issues to preserve customer loyalty while complying with company policies.
Involved in report testing with the user and resolved with the performance issues held during the report development.
Preparing Relevant AIM Document and Client Specific Document for Internal Purpose. Trainings Held at Qualcomm:
Training end users on Noetix Products and significance of using Noetix Products to help enhance their business processes.
Conducted various assessments on Noetix Products to get them accustomed to use the products in very effective manner.
Sep’10 - Apr’12: Oracle EBS Associate
LGS Global Ltd - Hyderabad, India
Designed and Developed Custom Reports.
Customization of Standard Reports as per Client requirement using the reports 10g/9i.
Designed and developed RTF using XML publisher.
Created PL/SQL Packages, Procedures, Functions as per the requirement.
Registration of forms, Reports, Menu Creation, Registration of concurrent programs and request sets into Oracle Apps through AOL.
Defining Responsibilities and Creating Value Sets.
Involved in the development of SQL*loader programs.
UAT Support, solving UAT bugs and providing solutions on time.
Customizing the standard forms using Form Personalization.
Preparation of Technical Specifications Documents.
Customization and Personalization of standard forms as per the client’s requirement. Jun’09 - Dec’09: Technical Support Associate
Sutherland Global Services – Visakhapatnam, India
Provide technical support to end users and troubleshoot issues pertaining to installation of Symantec products and renewing product licenses.
Execute the utilities to get rid of the Trojans from the client’s business machines and ensure the security.
Contact this candidate