Pavan Kumar K Email & Phone Number

Hyderabad, Telangana, India

**Created the infrastructure for the fraud analytics team by leveraging Amazon services like VPC[Virtual Private Cloud], EC2[Elastic Compute Cloud], IAM[Identity and Access Management], Secrets Manager, KMS[Key Management Service], Redshift, S3[Simple Storage Service],Glue,Athena,Quicksight,CloudWatch etc.**Developed ETL [Extract,Transform,Load] pipelines to onboard Oracle ERP financial, Amazon fulfillment, customer, seller, vendor, employee, payee and transportation tables onto redshift… Show more **Created the infrastructure for the fraud analytics team by leveraging Amazon services like VPC[Virtual Private Cloud], EC2[Elastic Compute Cloud], IAM[Identity and Access Management], Secrets Manager, KMS[Key Management Service], Redshift, S3[Simple Storage Service],Glue,Athena,Quicksight,CloudWatch etc.**Developed ETL [Extract,Transform,Load] pipelines to onboard Oracle ERP financial, Amazon fulfillment, customer, seller, vendor, employee, payee and transportation tables onto redshift cluster using Amazon internal BDT [Business Data Technologies] tools such as EDX[Elastic Data Exchange], Cradle, Datanet, Andes.**Automated the data ingestion process between third party expense reimbursement tool and Amazon internal concur application by interfacing both SFTP servers using SEDI[Simple Enterprise Data Integration] and programmatically transformed & loaded data with python scripts.**Reverse-engineered the ETL process to consume vendor sign-in streaming data and flatten the raw data into normalized datasets.**Developed a reporting platform to perform analysis on Payments data to identify fraudulent cases using Amazon glue and Quicksight. Show less

Hyderabad, Telangana, India

**Developed one-click Java based UI tool to map the PO commodities with fixed asset categories in order to derive the asset related accounting attributes automatically.**Automated the entire asset lifecycle, from creation to disposal, through generic APIs with event-based and bulk-upload options.**Automated accounting accrual entries including CIT[Cash In Transit], Tax Professional fee, PO RBNI[Received but not Invoiced] Adjustments, IOH[Invoice On hold] Adjustments.**Incorporated… Show more **Developed one-click Java based UI tool to map the PO commodities with fixed asset categories in order to derive the asset related accounting attributes automatically.**Automated the entire asset lifecycle, from creation to disposal, through generic APIs with event-based and bulk-upload options.**Automated accounting accrual entries including CIT[Cash In Transit], Tax Professional fee, PO RBNI[Received but not Invoiced] Adjustments, IOH[Invoice On hold] Adjustments.**Incorporated systematic control for the end-to-end flow from journal creation to posting using AME (Approval Management Engine) with single & multilevel hierarchical approval.**Developed Month End Reconciliation Dashboard with APTB and Primary Vs Secondary Ledger balances.**Improvised the Performance of long running Accrual reconciliation and custom GL,AP & FA reports.**Extensively worked along with end users on AP Subledger, Inventory, Fixed Assets Period Close Month end activity.**Built Accrual Adjustment tool for PO RBNI & IOH using Oracle Application Framework.**Provided inputs on process simplification, helped functional analysts on system configurations, did mentoring, design reviews, code reviews, hiring, knowledge sharing with cross tech & non tech teams and fixed the operational issues. Show less

Hyderabad Area, India

**Managed to identify and resolve the Oracle EBS Sub-ledger Accounting (SLA) product related bugs.**Pro-actively developed generic SLA MGDF to avoid the accounting issues in EBS R12 applications for the 11iAX upgrade customers.**Dexterous in providing the solutions for Oracle fusion Invoice Image Processing(IPM) import issues.**Developed web based Apex application for internal bug tracking process.**Substantial development experience in enhancing requests related to Oracle… Show more **Managed to identify and resolve the Oracle EBS Sub-ledger Accounting (SLA) product related bugs.**Pro-actively developed generic SLA MGDF to avoid the accounting issues in EBS R12 applications for the 11iAX upgrade customers.**Dexterous in providing the solutions for Oracle fusion Invoice Image Processing(IPM) import issues.**Developed web based Apex application for internal bug tracking process.**Substantial development experience in enhancing requests related to Oracle Fusion Cloud Payables Product.**Conceptualized, planned and implemented successful strategies to reduce bugs inflows.**Worked closely with Customers, Support and internal cross product teams to resolve accounting issues in Oracle E-Business Suite(R12) financial and Fusion Cloud(R11) Payable applications.**Hands-on experience across functional areas like Subledger Accounting Applications, Accrual & Cash basis, Encumbrance, Multi Period(MPA) & Transaction Account Definition(TAD) accounting, Supporting references & Control balance calculations , SLAM setups and SLA integration with financial applications. Show less

Chennai Area, India

**Developed EBS application components like RDF/XML publisher & Email bursting reports , Interface/APIs & Sql Loader programs , Alerts and Workflows.**Built Custom bolt-on Apex Applications.**Adroit in Performance tuning of SQL queries for optimized results.**Improvised the migration process using FND utility.**Hands-on experience across functional areas like P2P & O2C process cycles, TCA, Core Hrms, Payables, Receivables and General ledger applications.