Candidates About

 

Dayakar Chary Banala

 

Executive Summary

·         Working as a Techno-Functional Consultant with strong technical expertise in Oracle SQL, PL/SQL, Oracle Reports, Oracle Forms, BI Publisher, Oracle Applications Framework (OAF) and Unix/Linux.

·         Development expert in building complex custom RICE objects, Standard Oracle APIs, Oracle Reports and BI Publisher reports. For example,

a.       Critical Oracle to SAP GL Accounting Key Flexfield conversion

b.      Oracle iProcurement Punchout functionality to extend for capital purchases and asset management.

c.       Oracle Supplier Network implementation.

d.      I-9 implementation.

e.      Oracle to Getpaid Integration.

·         Strong expertise in Oracle Financials (Account Receivables, Account Payables, General Ledger, Fixed Assets) with good knowledge of Order Management, Purchasing, iProcurement, iSupplier, Time & Labor, WebADI and Oracle Incentive Compensation. Besides, Order-to-Cash (OTC) and Procure-to-Pay (P2P) cycles

·         Expertise in legacy collections system Getpaid, Payable Invoice Processing system – Basware, Integration system – Informatica Cloud Services

·         Good Knowledge on Customer process tools like Version Control System, Jira, Peregrine, ClearQuest tool, Change Management Process and migration of objects using Kintana.

·         Experience of implementing 5 SDLC cycles including phases – Requirements Gathering, Development, Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT), Production (Go-Live) and post-production support.

·         Expertise in documentation of Technical Design, Unit Test Cases , User Training documents and Code migration process.

·         Excellent interpersonal and communication capabilities and extensive experience in dealing with people from various organizational levels.

 

Skills Summary

Domains	Oracle E-Business Suite                - Oracle Applications versions 11.0.3, 11i, R12.1.3 and R12.1.4 Legacy Applications Getpaid, Basware and Informatica Cloud Services
Modules	Oracle Financials - AR, AP, SLA, GL, FA, CM, OIC, OM, PO, iSupplier, WebADI, Alert Manager and AOL Oracle HR - Time & Labor Oracle SCM – iProcurement and Inventory Business Cycles – O2C, P2P cycles
Tools	Oracle Reports, Oracle Forms, Oracle BI Publisher, OAF, Shell Scripting, Data Loader, SQL Loader, SQL and PLSQL   Toad, Notepad++,Secure CRT, WinSCP, Ticketing  tool – ClearQuest, Jira, Peregrine Tools, Configuration Management tools – PVCS, Harvest, MKS, Perforce, Change Management tool – Kintana, Linux System and Textpad, Job scheduling tool – ControlM, Oracle Scheduler.
Databases	Oracle 11g, 10g and 9i
OS Platforms	Sun Solaris, Linux, Unix, Windows NT/XP

 

Professional Experience Summary

Company Name	From Date	To Date	Last Designation
Monster Worldwide	21-Jan-14	Till Date	Software Development Engineer/Oracle Financials Consultant
Wipro Technologies Ltd	25-Jul-2012	17-Jan-2014	Lead Engineer
Wipro Technologies Ltd	14-Apr-2010	20-Jul-2012	Programmer Analyst
Wipro Technologies Ltd	1-Jan-2007	13-Apr-2010	Developer, Senior Developer and Technical Consultant

 

Professional Experience Details

 

A.     Company Name: Monster Worldwide

 

1)      Project Name: Implementation and Production support of Oracle EBS systems

Duration:                    Jan 2014 – Apr 2018

Client Name:              Monster Worldwide

Role:                            Software Development Engineer

 

Domains	Oracle E-Business Suite                - Oracle Applications versions 11.0.3, 11i, R12.1.3 and R12.1.4 Legacy Applications Getpaid, Basware and Informatica Cloud Services
Modules	Oracle Financials - AR, AP, SLA, GL, FA, CM, OIC, OM, PO, WebADI, Alert Manager and AOL Oracle HR - Time & Labor Oracle SCM – iProcurement and Inventory Business Cycles – O2C, P2P cycles
Tools	Oracle Reports, Oracle Forms, Oracle BI Publisher, Standard Oracle APIs, OAF, Shell Scripting, Data Loader, SQL Loader, SQL and PLSQL   Toad, Notepad++,Secure CRT, WinSCP, Ticketing  tool – ClearQuest, Jira Tools, Configuration Management tools – Perforce, Change Management tool – Linux System and Textpad, Job scheduling tool – Oracle Scheduler.
Databases	Oracle 11g, 10g
OS Platforms	Linux, Windows NT/XP

 

 

Project Description: Implementation, Customization and Production Support of Oracle EBS HR and Financials versions R12.1.3.

      

My Role:

·         Overall accountability for Oracle Financial Projects deliverables, iTime, Getpaid, Basware and Informatica Cloud, Maintaining the existing customizations and enhancing them.

·         Execution of various projects/Issues

ü  CQ/Jira Tickets and Agile stories.

ü  SOA Replacement Project – Replacing SOA with Informatica Cloud Service (ICS) for integrations and enhancing the custom Oracle Interfaces to liaison with ICS.

ü   Logo Change – As part of rebranding, new logo to reflect in all its digital documents generated via Oracle.

ü  Pay Per Click – Project to capture the invoicing information generated by the Change in billing model of Monster.

ü  Installment Billing Project - Finance solution to break one Salesforce order into multiple Installment invoices based on payment terms.

ü  Mforce Integration (Informatica Cloud and Salesforce Integration with Oracle)

ü  Intercompany Invoice Creation – Project to create AP invoice for Intercompany transactions.

ü  Invoice Print Programs Update Project

ü  Getpaid

a.       Design Oracle to Getpaid Integration

b.      Setting up strategies

c.       Defining portfolios

d.      Creating Collection types

e.      Manage user groups

f.        Setting up Exchange Web services (EWS)

ü  Getpaid Intraday Payments – Creating and sending a payment file to the collections systems from Oracle EBS.

ü  Oracle and SQL Server datacenter move project – Databases moved from the existing location.

ü  Europe Single Euro Payments Area (SEPA) Update Project – Implementation of SEPA across EU in Oracle EBS.

·         Process development and improvement in Finance, HR, legacy applications and Procurement area.

·         Provided post implementation support.

·         Experience of working in Agile software development methodology.

 

B.      Company Name: Wipro Technologies Ltd

 

1)      Project Name: Oracle EBS Financials Implementation projects

Duration:                    Jul 2012 – Jan 2014

Client Name:              TJX Companies

Role:                            Lead Engineer

 

Domains	Oracle E-Business Suite                - Oracle Applications versions R12.1.4 Legacy Applications Getpaid, Basware and Informatica Cloud Services
Modules	Oracle Financials - AR, AP, SLA, GL, FA, PO, iSupplier, WebADI, Alert Manager and AOL Oracle HR - Time & Labor Oracle SCM – iProcurement and Inventory Business Cycles – O2C, P2P cycles
Tools	Oracle Reports, Oracle Forms, Oracle BI Publisher, Standard Oracle APIs, OAF, Shell Scripting, Data Loader, SQL Loader, SQL and PLSQL   Toad, Notepad++,Secure CRT, WinSCP, Ticketing  tool – ClearQuest, Jira, Configuration Management tools – MKS, Change Management tool – Kintana, Textpad, Job scheduling tool – Oracle Scheduler.
Databases	Oracle 11g
OS Platforms	Unix, Windows NT/XP

 

Project Description: Customizations and Production Support of Oracle EBS HR and Financials   versions R12.1.4.

      

My Role: 

·         Overall accountability for transition, steady-state and continuous improvement of Finance projects offshore and onsite.

·         Implementations of projects

ü  Spend Analytics – Solution to capture all indirect, historical spend data in Oracle for analysis and reporting using a third party SaaS tool.

ü  Capital Purchases – Extend iProcurement Punchout use to include capital purchases and Asset management.

ü  Oracle Supplier Network – Implement XML Gateway invoice import functionality via Oracle Supplier Network (OSN) and design Custom validation and processing steps.

ü  CTC Paybase Integrations for US and UK, Hyperion Integrations – Implementation of CTC Paybase Integration with Oracle

ü  I-9 Project – Implementation of I-9 OAF page to digitize legal process for newly hired or rehired Associates eligible to work in the U.S

ü  Hyperion Integration project – GL data extract to Hyperion

·         Ensuring integration across multiple regional and Global Teams in understanding functional requirements, technical design, create/assist in creating technical specifications and suggest an implementation approach.

·         Review the documentation, code, unit test plans/results and finalize for configuration management.

·         Support high-level solution/estimates functional and technical design.

·         Support CRP, SIT and UAT test phases including resolve and fix code defects.

·         Participated in Solution Engineering Team for Technical Design with the customer.

·         Provided post implementation support.

 

 

 

2)      Project Name: Oracle EBS Production Support and OIC Implementation

Duration:                    Aug 2011 – Jul 2012

Client Name:              EMC (DELL EMC)

Role:                            Team Lead and Programmer Analyst

 

Domains	Oracle E-Business Suite                - Oracle Applications versions 11.0.3, 11i, R12.1.3 Legacy Applications Getpaid
Modules	Oracle Financials - AR, AP, SLA, GL, FA, CM, OIC, OM, PO, WebADI, Alert Manager and AOL Oracle SCM – iProcurement and Inventory Business Cycles – O2C, P2P cycles
Tools	Oracle Reports, Oracle Forms, Oracle BI Publisher, Standard Oracle APIs, OAF, Shell Scripting, Data Loader, SQL Loader, SQL and PLSQL   Toad, Notepad++,Putty, WinSCP, Ticketing  tool – Peregrine Tools, Configuration Management tools – Harvest, Change Management tool – Kintana and Textpad, Job scheduling tool – ControlM.
Databases	Oracle 11g, 10g and 9i
OS Platforms	Sun Solaris, Unix, Windows NT/XP

 

Project Description: Customizations, Oracle Incentive Compensation (OIC) Application Setups and Production Support of Complex Oracle EBS Financials versions 11.0.3, 11i and R12.1.3, legacy and custom applications – Getpaid and Business Review Meeting (BRM) respectively.

 

My Role:

·         Work with Business for creating the 2010, 2011 and 2012 Compensation plan setups for EMC Salespersons and other configurations in OIC, 11i.

·         Design, Code, Test and deliver Oracle to Getpaid collections system Interfaces and Oracle to SAP GL data conversion.

·         Managing Finance track of Order to Cash (OTC) and Requisition to Check (RTC) cycles.

·         Relationship management with the customer and Responsible for the offshore deliverables while working from the offshore and onsite.

·         Process and/or Performance Improvement as part of Lean Initiation and BAM Data Integrity Checks.

·         Solution Design, Review/Create Technical and/or Functional designs and Test Case documents.

·         Support CRP, SIT and UAT test phases, resolve and fix code defects.

·         Customization, Data Analysis, Analysis of Oracle Reports, Forms and Interfaces.

ü  Debook/Rebook Sales Order process – Automating the process of debooking the original SO (RMA) and rebooking new SO at one instance.

ü  Debill/Rebill Invoice process – Automating the process of debilling the original AR invoice and rebilling new invoice to handle changes to customer data.

ü  Sale of RMA process - Custom solution that allows users to fulfill SOs using material from an RMA.

ü  Professional Service SOs – Solution to split Hardware and Software Orders

ü  ABA Project (Auto-Book and Approve SOs) – Automate SO booking and approval process for specific order sources.

ü  Bookings Ledger process – Customization to have an audit of SO.

ü  Invoice Print programs

·         Root Causing the issues and break fixing them for permanent resolution. Fixing Issues raised by the Business users based on the priority levels, related to the

·         Oracle E-Business Suite modules Quoting, OM, AR, AP, GL, OTC and P2P cycles, Getpaid, BRM and OIC.

·         Accomplishment of Financial books closure during the month-end and quarter-end process with reconciled accounts.

ü  Revenue Reconciliation across sub-ledgers, GL and custom applications.

ü  Handling the complex period closing process at EMC for sub-ledgers during the quarter-end.

 

3)      Project Name: Production Support of Oracle EBS 11.0.3 and Legacy Applications.

       Duration:                    Jul 2007 – Aug 2011

       Client Name:              EMC (DELL EMC)

        Role:                            Senior Software Engineer and Financials Consultant

 

Domains	Oracle E-Business Suite                - Oracle Applications versions 11.0.3, 11i Legacy Applications - Getpaid
Modules	Oracle Financials - AR, AP, GL, FA, OIC, OM, PO, WebADI, Alert Manager and AOL Oracle SCM – iProcurement and Inventory Business Cycles – O2C, P2P cycles
Tools	Oracle Reports, Oracle Forms, Oracle BI Publisher, OAF, Shell Scripting, Data Loader, SQL Loader, SQL and PLSQL   Toad, Notepad++,Putty, WinSCP, Ticketing  tool – Peregrine Tools, Configuration Management tools – Harvest, Change Management tool – Kintana and Textpad, Job scheduling tool – ControlM.
Databases	Oracle 10g and 9i
OS Platforms	Sun Solaris, Unix, Windows NT/XP

 

Project Description: Minor enhancements and Production Support of Complex Oracle Applications11.0.3-Financials (specific modules: Accounts Receivables and Order Entry).

 

My Role:

·         Root-Cause analysis, Enhance and/or data fix issues, Test and deploy the fix to Production based on service level agreements related to Oracle EBS Modules Order to Cash (OTC) cycle, Order Entry, Account Receivables and custom application BRM.

·         Design, coding and testing the value addition service and improvement ideas for process and performance improvement.

ü  BRM job monitor email via Alert Manager.

·         Analysis of Oracle reports, forms and interfaces.

·         Accomplishment of Financial books closure during the month-end and quarter-end process with reconciled accounts.

ü  Revenue Reconciliation across sub-ledgers, GL and custom applications.

ü  Handling the complex period closing process at EMC for sub-ledgers during the quarter-end.

·         Besides, supporting BRM – a custom module interfacing Hyperion for revenue reconciliation.

 

4)      Project Name: Oracle EBS Development and Production Support

       Duration:                    Jan 2007 – Jul 2007

Client Name:              Albertsons (American Grocery Company)

        Role:                            Software Developer

 

Domains	Oracle E-Business Suite                - Oracle Applications versions 11i
Modules	Oracle Financials - GL, FA, PA and AOL Business Cycles – P2P cycles
Tools	Oracle Reports, Oracle Forms, Oracle BI Publisher, Workflow, OAF, Shell Scripting, Data Loader, SQL Loader, SQL and PLSQL   Toad, Peregrine Tools, Configuration Management tools – PVCS, Change Management tool – Kintana, Unix System and Textpad, Job scheduling tool –Oracle Scheduler.
Databases	Oracle 9i
OS Platforms	Unix

 

Project Description:  

GL Workflow Project - Oracle Reports development and workflow customization in General Ledger,

FA Asset Revaluation Project and Production Support.

 

My Role:

 

·         Customizing the Oracle workflow to automate the Journal Approval process in General Ledger Module of Oracle EBS 11i.

·         Development of Oracle Reports

ü   GL Journal Employee Supervisor Report - Program to get details of Employee and his Supervisor with Approval Limits.

ü  GL Journal Batch Summary Report.

·         Development of custom FA Asset Retirement process.

·         Production support issues related to Project Accounting.

 

 

Educational Qualifications

Degree	College/University	Mth-Year of passing	%Marks/Grade
Master’s Degree	Birla Institute of Technology, Pilani	Dec-10	7.88 Grade
Bachelor’s Degree	Osmania University	Apr-06	85%