Mounica Datla
Frisco,TX
Summary
Oracle Revenue Management Cloud Service (RMCS) and Receivables specialist with 8+ years of experience in design, development, customization, and maintenance of enterprise financial and HCM applications. Extensive expertise in PL/SQL programming, data integration, and reporting solutions for high-volume transactional systems. Proven ability to deliver RMCS revenue recognition, Accounts Receivable automation, payroll integrations, and financial reporting for global clients. Recognized for strong problem-solving skills, cross-functional collaboration, and delivering quality solutions under aggressive timelines.
Overview
9
9
years of professional experience
Work History
Senior Member Technical
ADP India Pvt Ltd
Hyderabad
04.2018 - 06.2023
- Worked on multiple ADP products – Enterprise, Vantage, WFN, and Payforce – along with Oracle RMCS and Receivables for financial reporting, invoice processing, and revenue recognition.
- Designed and developed custom financial and payroll reports using ADP Reporting Tool, ADP Enterprise, and Oracle Receivables data structures, including complex SQR requests for major clients.
- Built and optimized PL/SQL-based data extraction scripts for Accounts Receivable processes, including invoice generation, payment application, and reconciliation reporting.
- Provided production support for payroll and AR modules by resolving tickets, fixing reports, and troubleshooting RMCS-related revenue allocation and recognition issues.
- Led requirement gathering with on-site BAs and clients to finalize specifications for RMCS and Receivables-related customizations and reports.
- Acted as Business Analyst for select clients – created requirement documents, developed interfaces, and managed UAT and production testing.
- Worked on Vantage Outbound processes via ADP Reporting Tool and Inbound integrations via Data Bridge, including mapping to Receivables and RMCS data flows.
- Performed internal code reviews and created unit test plans/test scenarios for AR data accuracy and RMCS revenue allocation validation.
- Developed an internal SQL-based tool using multiple joins across payroll, receivables, and RMCS tables to improve reconciliation and reporting efficiency.
- Mentored and trained team members on RMCS integration concepts and Receivables reporting best practices.
Member Technical
ADP India Pvt Ltd
Hyderabad
12.2014 - 03.2018
- Developed customized financial and payroll reports, including Accounts Receivable invoicing, payment application, and revenue recognition data for RMCS integrations.
- Designed and implemented complex PL/SQL queries with CASE statements, joins, and analytic functions to produce precise AR and payroll reporting outputs.
- Collaborated with clients to gather requirements and provide alternate solutions for reporting or RMCS processing limitations.
- Analyzed existing SQR programs and re-developed them in ADP Reporting and PL/SQL for improved efficiency and Receivables reporting.
- Created and executed test scenarios, scripts, and plans to validate payroll, AR balances, and RMCS revenue allocations.
- Worked extensively on ADP Enterprise, ADP Vantage, and ADP Payforce – building payroll integrations with Receivables and RMCS modules.
- Led development, optimization, and debugging of SQR and PL/SQL-based inbound/outbound interfaces for financial and payroll systems.
- Customized numerous SQR and PL/SQL scripts for client-specific Receivables and RMCS automation, including deferred revenue handling and aging reports.
- Converted legacy ReportSmith reports into ADP Reporting and PL/SQL formats for improved performance.
- Served as single point of contact for offshore and onshore teams, ensuring timely delivery of payroll and financial module deliverables.
Education
B. Tech - Computer Science and Engineering
Rajamahendri Institute of Engineering & Technology (JNTU Kakinada)
01.2014
Skills
- Oracle Revenue Management Cloud Service (RMCS)
- Receivables processes
- Revenue Recognition
- AR Invoicing
- Payment Application
- Customer Account Management
- Financial Reporting
- HCM Modules
- Core HR
- Payroll
- Absence Management
- Benefits
- Talent Management
- Time & Labor
- Compensation
- Oracle HCM Cloud
- HCM Extracts
- HCM Data Loader (HDL)
- OTBI
- BI Publisher
- Oracle Integration Cloud (OIC)
- Fast Formulas
- Security Configuration
- PeopleSoft HCM
- PeopleTools
- Application Designer
- PeopleCode
- Application Engine
- Integration Broker
- Component Interface
- SQR
- PS Query
- Data Mover
- Reporting & Analytics
- Integration & Data Migration
- Project Lifecycle
- Requirement Gathering
- Fit-Gap Analysis
- Functional & Technical Documentation
- Testing
- User Training
- Technical Expertise
- PL/SQL
- SQL Optimization
- Performance Tuning
- Complex Joins
- Dynamic SQL
- Bulk Processing
- Soft Skills
- Effective Communication
- Problem-Solving
- Cross-Functional Collaboration
Timeline
Senior Member Technical
ADP India Pvt Ltd
04.2018 - 06.2023
Member Technical
ADP India Pvt Ltd
12.2014 - 03.2018
B. Tech - Computer Science and Engineering
Rajamahendri Institute of Engineering & Technology (JNTU Kakinada)
Similar Profiles
Rohit ChowdharyRohit Chowdhary
Sr. Analyst (Team Lead) at ADP India Pvt LtdSr. Analyst (Team Lead) at ADP India Pvt Ltd
VENKATESH SANGAVENKATESH SANGA
Technical Manager/Principal App Developer at ADP India Pvt LtdTechnical Manager/Principal App Developer at ADP India Pvt Ltd
Mounica DatlaMounica Datla
Senior Member Technical at ADP India Pvt LtdSenior Member Technical at ADP India Pvt Ltd
Bharani AmbatiBharani Ambati
Sr. Associate Functional consultant at ADP India Pvt LtdSr. Associate Functional consultant at ADP India Pvt Ltd
Srikanth DomaSrikanth Doma
Linux System Engineer at Citi GroupLinux System Engineer at Citi Group