Arun Kumar S Rathod, Pmp® Email & Phone Number

Nashua, Nh, Us

Apps Associates, Boston, Ma

• Conduct requirements and solution design workshops • Participate in medium-high complexity analysis, specification, design and development activities • Responsible for the overall technical design, structure, configuration and implementation of intended solution, including Service Cloud and Community Cloud design and Salesforce/Integration messaging patterns • Manage technical documentation, design, coding and testing• Document the approaches, guides and Integration… Show more • Conduct requirements and solution design workshops • Participate in medium-high complexity analysis, specification, design and development activities • Responsible for the overall technical design, structure, configuration and implementation of intended solution, including Service Cloud and Community Cloud design and Salesforce/Integration messaging patterns • Manage technical documentation, design, coding and testing• Document the approaches, guides and Integration details• Conducting review sessions, training sessions and status update sessions to the teams on the project tasks Show less

Greater Boston Area

Initiated and led the creation of a cutting-edge UI application, born from my vision to revolutionize Oracle Fusion Cloud SQL query execution. This application facilitates direct query input and instant result display within an intuitive editor, eliminating the need for repetitive data model and report creation. By incorporating Single Sign-On (SSO) leveraging Oracle Fusion credentials, it ensures secure and streamlined user access.The application's capabilities extend to running… Show more Initiated and led the creation of a cutting-edge UI application, born from my vision to revolutionize Oracle Fusion Cloud SQL query execution. This application facilitates direct query input and instant result display within an intuitive editor, eliminating the need for repetitive data model and report creation. By incorporating Single Sign-On (SSO) leveraging Oracle Fusion credentials, it ensures secure and streamlined user access.The application's capabilities extend to running multiple queries simultaneously and saving SQL queries for future reuse, significantly boosting efficiency and productivity. I designed the tool with an emphasis on user experience, featuring an interface that simplifies complex data operations and fosters an environment of efficiency and innovation. Show less

Apps Associates, Boston, Ma

• Technical Consulting, to support development of the PaaS Solutions using Oracle APEX• Responsible for authoring, reviewing and publishing Architectural documentation, including Current State technology architecture map and future state technology architecture map • Conduct requirements and solution design workshops• Participate in medium-high complexity analysis, specification, design and development activities• Responsible for the overall technical design, structure… Show more • Technical Consulting, to support development of the PaaS Solutions using Oracle APEX• Responsible for authoring, reviewing and publishing Architectural documentation, including Current State technology architecture map and future state technology architecture map • Conduct requirements and solution design workshops• Participate in medium-high complexity analysis, specification, design and development activities• Responsible for the overall technical design, structure, configuration and implementation of intended solution, including Service Cloud and Community Cloud design and Salesforce/Integration messaging patterns• Manage technical documentation, design, coding and testing for the custom PaaS solution• Coordinating functional team too Validate and test the configuration changes and data updateso Validation of data visibility in cloned applicationso End to end process validation in cloned applicationso Validation of integrations, extensions and reports• Document the approaches, guides and Integration details• Conducting review sessions, training sessions and status update sessions to the teams on the project tasks• Created various Oracle APEX applications to maintain Orders, Apply Order Holds automatically and maintain shipment container information Show less

Apps Associates, Boston, Ma

• Driving architecture discussions, and lead the technical team members to design and build integrations Automate Concur feed to Oracle Cloud• Worked on Performance improvements on various finance reports

Apps Associates, Boston, Ma

• Successfully optimized the time entry and billing process by fixing the performance of the BI publisher report and the integration flow, resulting in a more intuitive and efficient system that significantly reduced manual errors and improved billing accuracy• Led a cross-functional team, fostering collaboration and innovation to achieve project goals within tight deadlines• Enhanced client satisfaction through the delivery of a reliable and user-friendly process, setting a new… Show more • Successfully optimized the time entry and billing process by fixing the performance of the BI publisher report and the integration flow, resulting in a more intuitive and efficient system that significantly reduced manual errors and improved billing accuracy• Led a cross-functional team, fostering collaboration and innovation to achieve project goals within tight deadlines• Enhanced client satisfaction through the delivery of a reliable and user-friendly process, setting a new standard for operational excellence in the industry Show less

Apps Associates, Boston, Ma

• Created custom views for advance collections and territory management• Responsible for Integration design between in Oracle R12o Stripe and Oracleo Automate Concur feed to Oracle

Apps Associates, Boston, Ma

• Responsible for technical global design delivery• Documenting all the conversions and reports required for implementation

Apps Associates, Boston, Ma

• Technical Consulting, to support development of the various PaaS Solutions using Oracle APEX• Perform global design in conjunction with the team from BIAS to incorporate the BIAS consolidated billing solution into the new deployments of Oracle ERP Cloud and Salesforce• Provision the Oracle PaaS environment and configure with the appropriate services required to support the global design and implementation• Collect billing lines from source data including Oracle Order Management… Show more • Technical Consulting, to support development of the various PaaS Solutions using Oracle APEX• Perform global design in conjunction with the team from BIAS to incorporate the BIAS consolidated billing solution into the new deployments of Oracle ERP Cloud and Salesforce• Provision the Oracle PaaS environment and configure with the appropriate services required to support the global design and implementation• Collect billing lines from source data including Oracle Order Management, Oracle Service Contracts, Oracle Projects, Salesforce Contracts, and BioInventory and work with the BIAS team to support feeding this data into the custom billing solution• Establish a master contract number and any other necessary data fields to support the consolidation engine global design• Create an integration from the custom billing solution designed in Oracle APEX to Oracle ERP Cloud as necessary to support month end billing process• Design a solution to support transition from existing Oracle EBS Depot Repair and Spares Management solution in Oracle Cloud• Assess the need to replicate Oracle data objects (Work Order, Parts Order, Repair Order, Inventory Management) in Salesforce and build the appropriate custom objects as necessary• Consolidate information across Installed Base, Manufacturing, OM, Inventory, AR and Service (SFDC) in custom databases on the PaaS instance• Responsible for authoring, reviewing and publishing Architectural documentation, including Current State technology architecture map and future state technology architecture map• Participate in medium-high complexity analysis, specification, design and development activities• Responsible for the overall technical design, structure, configuration and implementation of intended solution, including Service Cloud and Community Cloud design and Salesforce/Integration messaging patterns• Manage technical documentation, design, coding and testing Show less

Apps Associates, Boston, Ma

• Created new Oracle APEX application to create and maintain budgets and forecast for business review• The application gave the ability for project managers and business to create or update forecast and budgets in real time without the need to login to Oracle EBS. Users now have the ability to update multiple project budgets and forecast without the need for IT to update for them

Apps Associates, Boston, Ma

• Remediate current Oracle APEX application to fine tune and upgrade to adapt it for the new business• The remediated APEX application gave the ability for project managers to visualize budget and forecast load more accurately

Apps Associates, Boston, Ma

• Responsible for the design data masking approach• Involved in design review meetings and discussions• Manage technical documentation, design, coding and testing for the data masking and data purge routines• Remediation of existing interfaces• Remediate existing XML publisher, Oracle and Discoverer reports and creating new reports for business reconciliation• Develop programs to data mask/Purge various Oracle data elements based on the following oracle moduleso General… Show more • Responsible for the design data masking approach• Involved in design review meetings and discussions• Manage technical documentation, design, coding and testing for the data masking and data purge routines• Remediation of existing interfaces• Remediate existing XML publisher, Oracle and Discoverer reports and creating new reports for business reconciliation• Develop programs to data mask/Purge various Oracle data elements based on the following oracle moduleso General Ledgero Accounts Receivableso Accounts Payableso Cash Managemento Fixed Assetso Vertex Tax configurationso Purchasingo Oracle Management, Service Contract/Depart Repairo Manufacturingo Supply Chain Planning• Coordinating functional team to validate and test the configuration changes and data updates• Validation of data visibility in cloned applications• End to end process validation in cloned applications• Validation of integrations, extensions and reports• Documenting the approaches, guides and details in Brooks SharePoint site, which will be reviewed by Brooks Team• Conducting review sessions, training sessions and status update sessions to the teams on the project tasks• Validating code and custom scripts based on Brooks defined rules• Created a custom Oracle workflow to run concurrent programs in sequence and send the respective outputs as workflow notifications• Setup custom automated migration process tightly integrated with CVS Show less

Apps Associates, Boston, Ma

• Responsible for the technical implementation of a new revenue system to address the requirements of the new Accounting Standard, ASC606• Managed technical documentation, design, coding and testing for the conversion routines• Converted data conversions and load data for the following modules:o Projectso Tasks (WBS)o Project Budgetso Eventso Expenditureso Taskso Budgetso Expenditures• Designed and build multiple custom HR/PA outbound/inbound… Show more • Responsible for the technical implementation of a new revenue system to address the requirements of the new Accounting Standard, ASC606• Managed technical documentation, design, coding and testing for the conversion routines• Converted data conversions and load data for the following modules:o Projectso Tasks (WBS)o Project Budgetso Eventso Expenditureso Taskso Budgetso Expenditures• Designed and build multiple custom HR/PA outbound/inbound interfaces• Created a custom Oracle workflow to run concurrent programs in sequence and send the respective outputs as workflow notifications• Setup custom automated migration process integrated with SVN• Modified auto accounting setups• Worked on to fix multiple high performance queries• Created multiple point reconciliation queries for business to reconcile Show less

Apps Associates, Boston, Ma

• Converted data conversions for the following modules:o Purchase Orders o Itemso Item Categorieso Bills Of Materials (BOM) o Routingo Item Quantity On Hand o Projectso Tasks o Budgets o Expenditures• Designed a complete custom one click interface process to load data into Items, BOM’s and Routings from the existing Spreadsheet’s that are been generated from Inventor• Designed extensions to integrate custom OTL tool to Oracle… Show more • Converted data conversions for the following modules:o Purchase Orders o Itemso Item Categorieso Bills Of Materials (BOM) o Routingo Item Quantity On Hand o Projectso Tasks o Budgets o Expenditures• Designed a complete custom one click interface process to load data into Items, BOM’s and Routings from the existing Spreadsheet’s that are been generated from Inventor• Designed extensions to integrate custom OTL tool to Oracle Workorders• Designed extension to create burdening line on Oracle project expenditure’s• Designed and build multiple custom HR outbound/inbound interfaces (ADP and Taleo)• Customized Oracle PO PA account generator• Setup custom automated migration process tightly integrated with CVS Show less

Apps Associates, Boston, Ma

• Developed multiple XML Publisher Reports• Implemented Oracle AP approval using AME• Implemented HR PTO process for international employees• Implemented custom notification process for Quantity on hold/ Amount On Hold invoices and notification on timecard submission• Designed and build multiple custom HR outbound/inbound interfaces• Setup custom automated migration process tightly integrated with CVS

Apps Associates, Boston, Ma

• Implemented Fixed Assets with a custom solution to load assets from legacy to Oracle Applications• Involved in the preparation of the MD-70 and MD-120 documents• Work closely with Project Manager to meet project milestones, provide periodic updates, help in identifying solutions, and reduce risks for the successful implementation of the solution

Apps Associates, Boston, Ma

• Designed and built custom GL Workflow Process• New report to identify ‘Pay When Paid’ process in order to pay consultants/vendor accordingly• Designed and built custom PA integration interface and Workflow approval process

Apps Associates, Boston, Ma

• Design custom approval workflow for Project Accounting Approval process and create an oracle program to automate loading data in oracle projects budget table and baseline the budget automatically• The enhancement gave the ability for project managers to automate the fund request and approval process and budget load. Users now have the ability to complete an online form to request funds for a particular project and submit the request electronically for approval. The workflow routes the… Show more • Design custom approval workflow for Project Accounting Approval process and create an oracle program to automate loading data in oracle projects budget table and baseline the budget automatically• The enhancement gave the ability for project managers to automate the fund request and approval process and budget load. Users now have the ability to complete an online form to request funds for a particular project and submit the request electronically for approval. The workflow routes the request to the appropriate individuals for approval• The Project Managers will have visibility over the project commitments and actuals data Show less

Apps Associates, Boston, Ma

• Document (Flow chart) process flow of 3 interfaces which run from legacy to AR, PN, AP and GL• Knowledge Transition Technical code to the Apps Associates Managed Services team

Apps Associates, Boston, Ma

• Upgrade/Remediate following Oracle modules from 11.5.10 to R12:o Accounts Receivableso Accounts Payableso Cash Managemento General Ledgero Fixed Assetso Purchasingo Procuremento Advanced Product Catalogo Property Managero Core Contractso TCAo HRMS includes Human Resources, Compensation Workbench, Learning Management, Employee Self Service, iRecruitment, Advanced Benefits, Talent Management, Time and Labor and Manager Self… Show more • Upgrade/Remediate following Oracle modules from 11.5.10 to R12:o Accounts Receivableso Accounts Payableso Cash Managemento General Ledgero Fixed Assetso Purchasingo Procuremento Advanced Product Catalogo Property Managero Core Contractso TCAo HRMS includes Human Resources, Compensation Workbench, Learning Management, Employee Self Service, iRecruitment, Advanced Benefits, Talent Management, Time and Labor and Manager Self Service• Implemented two new modules:o Oracle Projectso Oracle Advanced Collections• Performance Tuning - Tuned the HR scrambling script to run from 2 days to 55 minutes• Applied all the Oracle coding best practices to custom code• Legacy Code enhancement to make it compatible with R12• Designed a custom tool for migrating all the re-mediated objects without manual intervention in R12. During the cut over the migration, time was cut down from 2.5 days to 1 hour with this tool with 0 errors Show less

Apps Associates, Boston, Ma

• Involved in trouble shooting production issues (Day-to-Day production support), performance tuning and provided techno functional support for existing Oracle application modules in a multi-org and multi- currency environment• Responsible for defining and enforcing standards and best practices to be adopted by different development efforts and teams. Maintained overall responsibility for quality of solutions/code in Oracle Applications production deployments• Designed the version… Show more • Involved in trouble shooting production issues (Day-to-Day production support), performance tuning and provided techno functional support for existing Oracle application modules in a multi-org and multi- currency environment• Responsible for defining and enforcing standards and best practices to be adopted by different development efforts and teams. Maintained overall responsibility for quality of solutions/code in Oracle Applications production deployments• Designed the version control structure, which helped AMSC to control the code versions and approvals for PROD• Designed a custom iExpense functionality to split the amounts into two lines (billable and non-billable) depending on the amount limits for each task• Modified the check templates to pick the signatures from lob tables instead of hardcoding or storing the signatures in some folder Show less

Apps Associates, Boston, Ma

• Lead and Participated in designing and developing application interface programs, conversions and various customizations. • Served as a technical lead for the forms personalization, workflow customization and building extensions• Involved in trouble shooting production issues (Day-to-Day production support), performance tuning and provided techno functional support for existing Oracle application modules

Apps Associates, Hyderabad, India

• Developed 1 inbound and 4 outbound benefits interface for COBRA, TSA and UHC and also help i2 team in building oracle standard benefit system functionally• Involved in the preparation of the MD-70 and MD-120 documents• Work closely with Project Manager to meet project milestones, provide periodic updates, help in identifying solutions, and reduce risks for the successful implementation of the solution• Manage deliverables from the development and quality team. Monitor and test… Show more • Developed 1 inbound and 4 outbound benefits interface for COBRA, TSA and UHC and also help i2 team in building oracle standard benefit system functionally• Involved in the preparation of the MD-70 and MD-120 documents• Work closely with Project Manager to meet project milestones, provide periodic updates, help in identifying solutions, and reduce risks for the successful implementation of the solution• Manage deliverables from the development and quality team. Monitor and test systems to detect potential defects Show less

Apps Associates, Hyderbad, India

• Participated in post-production support• Resolved various issues with the financial modules as they appeared

Apps Associates, Hyderabad, India

• Participated in post-production support• Resolved various issues with the financial modules as they appeared

Apps Associates, Hyderabad, India

• Created 15 custom WEBADI (Application Desktop Integrators) to facilitate users to enter bulk HR data (Core, Re-Hire, Payroll, Employment Changes) from the application

Apps Associates, Hyderabad, India

• Involved in the performance tuning of DB process and reports• Created custom Interface using PL/SQL to extract Oracle HRMS and interface to ADP• Work closely with Project Manager to meet project milestones, provide periodic updates, help in identifying solutions, and reduce risks for the successful implementation of the solution• Manage deliverables from the development and quality team. Monitor and test systems to detect potential defects

Apps Associates, Hyderabad, India

• Participated in post-production support• Resolved various issues with the financial modules as they appeared

Apps Associates, Hyderabad, India

• Upgrade database systems from legacy (JDE, QAD and Teseract) to 11.5.10 with major changes in the current business process• Developed reports using XML Publisher• Defined Concurrent Programs, Registering Custom Build Reports and PL/SQL Procedures, and Packages and creating Executables using Application Object Library (AOL) in the development Environment• Developed reports in OPM & OM. Reports like pick-slip report, Packing Slip Report & Sales Order Acknowledgement… Show more • Upgrade database systems from legacy (JDE, QAD and Teseract) to 11.5.10 with major changes in the current business process• Developed reports using XML Publisher• Defined Concurrent Programs, Registering Custom Build Reports and PL/SQL Procedures, and Packages and creating Executables using Application Object Library (AOL) in the development Environment• Developed reports in OPM & OM. Reports like pick-slip report, Packing Slip Report & Sales Order Acknowledgement reports• Involved in the preparation of the MD-70 and MD-120 documents• Developed data conversion scripts for the following modules:o Core HRMS and Payrollo Vendorso Bank Accountso AP Invoiceso Purchase Orderso Attachments (BOM, Routes and Customers)o Sales Orderso Install Base Show less

Apps Associates, Hyderabad, India

• Migration from legacy to Oracle 11.5.10• Developed data conversion scripts for the following modules:o Core HRMSo Vendorso Payables (AP)• Involved in the preparation of the MD-70 and MD-120 documents

Apps Associates, Hyderabad, India

• Development and customization of Workflow as per customer requirements• Customized Oracle standard reports like AP and AR Reports changed the output format to XML and created new templates for XML Publisher to display in pdf• Created Workbooks based on the custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop• Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of… Show more • Development and customization of Workflow as per customer requirements• Customized Oracle standard reports like AP and AR Reports changed the output format to XML and created new templates for XML Publisher to display in pdf• Created Workbooks based on the custom Folders with parameters, cascading parameters, conditions, calculations using Discoverer Plus and Discoverer Desktop• Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of Application Object Library (AOL)• Experience with Oracle Supplied Packages such as DMS_SQL and UTL_FILE• Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets• Developed UNIX Shell scripts to FTP the flat file from External Server to Oracle UNIX Server location. Automated the process of encrypting and archiving• Developed custom templates for the invoice reports by calling sub templates in XML/BI Publisher.• Submitted Service Request with Oracle Support in different Scenarios, for providing Solutions to the Bugs identified during Production support resolved various bugs, working in collaboration with Oracle Support.• Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validate data into Oracle Standard interface tables• Used Version Control (tortoise subversion) to maintain code changes• Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace• Documentation using AIM methodologies of MD50’s, MD70’s• Developed Custom Reports using XML Publisher Reporting Tool• Created conversion scripts for the following modules:o Core HRMS and Payrollo Vendorso Item Costs Show less

Apps Associates, Hyderabad, India

• Upgrade various 6i reports into XML Publisher reports that are used for invoicing and purchasing• Defined Concurrent Programs, Registering Custom Build Reports and PL/SQL Procedures, and Packages and creating Executables using Application Object Library (AOL) in the development Environment• Proactively tuned SQL queries & Views using Explain Plan, Hints and indexes, SQL trace• Documentation using AIM methodologies of MD50’s, MD70’s

Apps Associates, Hyderabad, India

• Upgrade Oracle Applications from 11.5.9 to 11.5.10 • Developed PL/SQL procedures to validate data extracted, and then populated tables in 11.5.10 database• Developed data conversion scripts for the following modules:o Core HRMSo Bills of Materialso Routingso AP Invoiceso Attachments• Practiced user centered design methods to during requirements gathering including user interviews, paper prototyping• Involved in the preparation of the MD-70 and MD-120… Show more • Upgrade Oracle Applications from 11.5.9 to 11.5.10 • Developed PL/SQL procedures to validate data extracted, and then populated tables in 11.5.10 database• Developed data conversion scripts for the following modules:o Core HRMSo Bills of Materialso Routingso AP Invoiceso Attachments• Practiced user centered design methods to during requirements gathering including user interviews, paper prototyping• Involved in the preparation of the MD-70 and MD-120 documents Show less

Pmp

B.E, Computer Science And Engineering

Bachelor of Engineering

Education record