Summary
Overview
Work History
Education
Skills
Timeline
Generic

Nisha Dhami

HUTTO,TX

Summary

Highly skilled and results-driven professional with over 6 years of experience in both technical and customer-facing roles. Proven expertise in Oracle Techno-Functional consulting, with a strong background in implementing and supporting Oracle applications. Adept at bridging the gap between business needs and technical solutions, with a track record of improving processes and customer satisfaction.

Overview

8
8
years of professional experience

Work History

Oracle Techno Functional Consultant

Athene Des Moines
03.2022 - Current
  • Partnered with business stakeholders to gather requirements and deliver end-to-end solutions for AP, AR, and GL modules, ensuring alignment with financial compliance standards.
  • Automated invoice data imports by designing and implementing PL/SQL validation procedures and integrating with Payables Import, improving accuracy and reducing manual intervention by 30%.
  • Conducted data reconciliation and validation testing, ensuring clean migration and reliable reporting across subledger's and GL.
  • Developed and executed business test plans, UAT scripts (TE040), and SIT cycles, leading to a 20% reduction in post-go-live defects.
  • Created and reviewed AIM documentation (MD050, BR100), technical design documents, and functional specs to ensure knowledge transfer and audit compliance.
  • Optimized SQL queries and existing system logic, improving performance of critical financial transactions and reports. Supported end-to-end accounting flows across subledger modules, ensuring accurate journal entries and timely month-end close.
  • Automated and scheduled Oracle financial interfaces and PL/SQL batch jobs using Control-M, ensuring timely data loads and reducing manual monitoring.
  • Designed and deployed custom PL/SQL packages, procedures, and functions to validate data, integrate with Oracle interface tables, and support operational reporting.
  • Configured job dependencies and alerts in Control-M, improving SLA adherence for month-end and daily financial processes.
  • Provided hyper-care post-production support, resolving high-priority incidents under SLA and conducting knowledge transfer sessions to the customer support team.

Virtual Customer Service Representative

Amazon.in
04.2020 - 12.2021
  • Served as a key point of contact for a high volume of customer inquiries via phone, chat, and email in a fast-paced virtual environment.
  • Successfully resolved a wide range of customer issues, including order tracking, product troubleshooting, billing disputes, and technical platform navigation.
  • Consistently met and exceeded key performance indicators (KPIs) such as Average Handle Time (AHT) and First Contact Resolution (FCR), maintaining a customer satisfaction score of 95%.
  • Utilized multiple internal tools and systems simultaneously to access and update customer information, ensuring accurate and efficient service.
  • Proactively identified and escalated complex issues and emerging trends to management, contributing to process improvements that enhanced the overall customer experience.

Oracle Consultant

Digital Terrain Inc
01.2019 - 03.2020
  • Spearheaded system optimization and query tuning across AP, AR, and GL, improving execution speed and reducing downtime during peak financial periods.
  • Designed and implemented AP Invoice Import processes using the Payables Open Interface Import Program, cutting manual invoice entry by 40% and improving accuracy.
  • Developed outbound interfaces for Payables, Suppliers, Bank Accounts, and Contacts, streamlining integration between Oracle EBS and legacy applications.
  • Automated Journal Imports across AP and AR into GL, improving the accuracy and timeliness of financial reporting.
  • Implemented custom Form Personalization (Zoom functionality) to extend Oracle EBS functionality without heavy customizations.
  • Deployed FNDLOAD utilities to migrate concurrent programs, menus, and request sets across environments, reducing deployment effort by 25%.
  • Engineered custom XML/BI Publisher invoice templates, enhancing compliance reporting and meeting region-specific business requirements.
  • Built and monitored alerts for AP/GL interface tables, proactively identifying data discrepancies before they impacted financial close.

Oracle Techno Functional Consultant

Optimize IT Systems
05.2017 - 12.2018
  • Delivered day-to-day production support for Oracle Applications (AP, GL), ensuring minimal disruption to business operations.
  • Registered and maintained Concurrent Programs, Forms, Reports, and Request Sets within AOL and System Administration, streamlining process execution.
  • Performed SQL/PLSQL tuning, tracing, and debugging, applying optimizer techniques (hints, explain plans, SQL Trace) to reduce query cost and improve performance by 20%.
  • Designed and maintained Oracle back-end objects including Triggers, Stored Procedures, Functions, Collections, Views, Materialized Views, and Packages, supporting evolving business requirements.
  • Used FNDLOAD to migrate concurrent programs, menus, and personalization's across environments, ensuring consistency and reducing deployment errors.
  • Created and configured alerts to monitor record counts and error handling within AP/GL interface tables.
  • Developed custom XML/BI Publisher invoice report templates, improving reporting flexibility for business teams.
  • Collaborated with Oracle Support by raising Service Requests (SRs) to resolve standard bugs and apply required data fixes.

Education

Master of Science - Business Analytics

Trine University
Angola, IN
05-2023

Skills

  • Prioritization and scheduling
  • Skilled in resolving conflicts
  • Strategic issue analysis
  • Effective communication
  • Meticulous in task execution

Timeline

Oracle Techno Functional Consultant

Athene Des Moines
03.2022 - Current

Virtual Customer Service Representative

Amazon.in
04.2020 - 12.2021

Oracle Consultant

Digital Terrain Inc
01.2019 - 03.2020

Oracle Techno Functional Consultant

Optimize IT Systems
05.2017 - 12.2018

Master of Science - Business Analytics

Trine University

Similar Profiles

  • Breighen Powell

    Breighen PowellBreighen Powell

    Fire Lieutenant at City of Des Moines Fire DepartmentFire Lieutenant at City of Des Moines Fire Department

  • Emily Prymek

    Emily PrymekEmily Prymek

    Registered Nurse at UnityPoint Health - Des MoinesRegistered Nurse at UnityPoint Health - Des Moines

  • Nicholas Baedaro

    Nicholas BaedaroNicholas Baedaro

    Mens Basketball Student Assitant (Intern) at Des Moines Area Community CollegeMens Basketball Student Assitant (Intern) at Des Moines Area Community College

  • Richard Zabala

    Richard ZabalaRichard Zabala

    Fulfillment Associate at Lowes Home ImprovmentFulfillment Associate at Lowes Home Improvment

  • Damara Guillory

    Damara GuilloryDamara Guillory

    Customer Service Representative IV at Health and Human Services, TexasCustomer Service Representative IV at Health and Human Services, Texas

CREATE PROFILE