DMV - ERP Analyst 3 - Richmond, VA 23269

Yakshna Solutions, Inc.; Richmond (VA); On-site; USD 125,000 - 130,000; Full time

Benefits offered by this job

401(k)

Health insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

Paid time off

Training

Professional development

Job summary

Yakshna Solutions, Inc. seeks an DMV ERP Analyst 3 in Richmond, VA to analyze, design, develop, and maintain Oracle E-Business Suite Financial modules (R12). You will work with business teams to gather requirements and implement new functionality, while ensuring secure coding and governance practices.

The role focuses on AR/AP/GL modules, data migrations, and integrations using APIs and Web Services, with collaboration across DBAs and infrastructure teams. Competitive benefits provided.

Qualifications

• 7 years of experience in PL/SQL packages, procedures, triggers, functions, and reports.
• Troubleshooting and resolving application issues, performance problems, and data discrepancies.
• Experience with data migration and interface development (APIs, Web Services, flat-file integrations).
• Experience analyzing, designing, developing, optimizing, and maintaining Oracle E-Business Suite Financial modules.
• Strong communication skills and ability to work with business and technical teams.
• Knowledge of secure coding practices, change management, and IT governance policies.
• Experience with Oracle EBS Financial modules such as AR, AP, GL and related custom processes.
• Familiarity with TOAD, Oracle Forms, Oracle Reports, BI Publisher and Oracle DB administration.

Responsibilities

• Analyze, design, develop, optimize, and maintain customizations, extensions, and integrations for Oracle E-Business Suite Financial modules (R12).
• Provide documentation on system and process enhancements.
• Coordinate regular system updates with the DBA and implement enhancements to meet operational requirements.
• Support core financial modules: AR, AP, GL, and custom processes in Oracle.
• Gather requirements with business and functional teams and implement new functionality.
• Develop and maintain PL/SQL packages, procedures, triggers, functions, and reports.
• Troubleshoot, debug, and resolve application issues, performance problems, and data discrepancies.
• Support data migration and interface development activities, including API calls and web services.
• Ensure adherence to secure coding practices and IT governance policies.
• Collaborate with DBAs, system admins, and infra teams for reliable environments.
• Participate in project planning, testing, deployment, and post-implementation support.
• Provide knowledge transfer and documentation to internal teams.
• Lead scoping, requirements gathering, estimating, and planning for single/multiple workstreams.

Skills

PL/SQL development

Troubleshooting

Data migration

Requirements analysis

Communication

Secure coding

Oracle EBS Financials

Oracle dev tools

Tools

TOAD

Oracle Forms

Oracle Reports

BI Publisher

Job description

Job Title

DMV - ERP Analyst 3 (806379)

Client

Dept of Motor Vehicles (DMV)

Location

2300 West Broad Street, Richmond, VA 23269

Salary

$125,000-130,000 annually with benefits

Citizenship Requirement

US Citizen or Green card holder only

Benefits

Competitive benefits package includes 401(k), health, dental, and vision insurance, Life insurance, short-term and long-term disability insurance, paid time off, training, and professional development assistance.

Responsibilities

• Analyze, design, develop, optimize, and maintain customizations, extensions, and integrations for Oracle E-Business Suite Financial modules (primarily R12).
• Provide documentation on all system and process enhancements.
• Coordinate regular system updates with the Database Administrator and implement enhancements to meet operational requirements.
• Support and enhance core financial modules, including Accounts Receivable, Accounts Payable, General Ledger and custom-built processes within the Oracle application.
• Work with business and functional teams to gather requirements, document solutions, and implement new functionality.
• Develop and maintain PL/SQL packages, procedures, triggers, functions, and reports using Oracle development tools (TOAD, Oracle Forms, Oracle Reports, BI Publisher).
• Troubleshoot, debug, and resolve application issues, performance problems, and data discrepancies.
• Support data migration and interface development activities, including API calls, Web Services, and flat-file integrations.
• Ensure adherence to secure coding practices, change management standards, and IT governance policies.
• Collaborate with DBAs, system administrators, and infrastructure teams to maintain reliable, high-performance environments.
• Participate in project planning, testing, deployment, peer reviews and post-implementation support.
• Provide knowledge transfer and documentation to internal teams and stakeholders.
• The Oracle E-Business Suite Financials Developer is responsible for the design, development, implementation, and support of Oracle EBS Financial modules and related business processes.
• Lead and coordinate the scoping, technical requirements gathering, estimating and planning for single or multiple work-streams.

Required Skills and Qualifications

• 7 years of experience in developing and maintaining PL/SQL packages, procedures, triggers, functions, and reports using Oracle development tools.
• Proficient in troubleshooting, debugging, and resolving application issues, performance problems, and data discrepancies.
• Experience supporting data migration and interface development activities, including API calls, Web Services, and flat-file integrations.
• Experience analyzing, designing, developing, optimizing, and maintaining customizations, extensions, and integrations for Oracle E-business Suite Financial Modules.
• Strong communication skills and ability to work collaboratively with business and technical teams.
• Knowledge of secure coding practices, change management standards, and IT governance policies.
• Experience with Oracle EBS Financial modules such as Accounts Receivable, Accounts Payable, General Ledger, and related custom processes.
• Familiarity with Oracle development tools (TOAD, Oracle Forms, Oracle Reports, BI Publisher) and Oracle database administration.

EEO Statement

YSI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.