Management Oracle

NIDHI SONI

E-Mail: ********@*******.*** Mobile: +1-337-***-****

OBJECTIVE

To establish a challenging career in organizations of repute in the software industry through a long time commitment, contributing to the company's growth and in turn ensuring personal growth with in the organization. I believe that my technical, functional and communication skills will enable me in facing the challenging career ahead.

CORE COMPETENCIES

An astute young energetic result oriented IT professional offering about 6 years of experience. Extended expertise in Oracle database, PL/SQL, Reports, Interfaces, Conversions, Extensions and Customizations by serving various oracle modules like Purchasing, Account Payables, Account Receivables, Order Management, and Inventory. Deep understanding of technology with focus on delivering business solutions, Persuasive communicator with exceptional relationship management skills with an ability to relate to people at any level of research and management.

Experience in four full lifecycle implementations. Having good knowledge on Procure to Pay and Order to Cash Cycles.

Experience in Real time Production Support and Enhancement project.

Expert in Oracle, SQL, PL/SQL and REPORTS.

Strong knowledge in SCM domain, Payables, Receivables, Purchasing and order management Modules.

Worked efficiently on RICE components by serving various oracle modules.

Developed XML/BI Publisher Reports [Barcode Printing, Check Printing, Multi-sheet Excel, e-Text Reports].

Experience in analyzing, retrieving and loading the relational data using SQL, SQL*Loader and UTL_FILE.

Strong knowledge on Customization of Reports.

Skilled team member with proven ability to motivate teams to maximize productivity.

Dedicated and highly ambitious to achieve personal as well as organizational goals.

Adroit at learning new concepts quickly, working well under pressure and communicating ideas clearly and effectively.

PROFESSIONAL EXPERIENCE

SAIPSIT Inc.

EBS Application Analyst

Roles & Responsibility

Developed PL\SQL packages as per business requirement in purchasing module along with PO Attachments i.e. header level, line level and shipment level and generate XML reports using XML bursting concept to send via email a consolidated information related report to different mailers.

Developed Reports like check printing on pre-formatted forms showing Invoice details at the bottom.

Experience and working knowledge in Oracle database, advanced PL/SQL, Package customization.

Preparing Technical Solution Design using Oracle Applications and manage various phases of the project.

Developed inbound interfaces to upload the legacy data into the Oracle Application System and outbound interfaces to upload the Oracle Application data into the legacy system.

Re-design of custom components in R12 environment.

Porting of Marketing Data from Legacy System to Accounts Receivables module using Auto Invoice.

A PL/SQL package and procedure has been developed which validates and to insert records into the Receivables Interface Tables RA_INTERFACE_HEADERS and RA_INTERFACE_LINES.

Designed aging reports for the Customer Outstanding balances at the detail and summary level.

Designed and developed reports using BI Publisher including Pre-printing formats.

Deloitte Consulting India Private Limited

Business Technology Analyst (Oracle Packaged Technologies)

Projects Undertaken:

LEVEL3 Communication (R12 Implementation)

National Oil-well Varco (R12 Implementation)

Niagara Bottling, LLC (R12 Enhancement)

Roles & Responsibility

Developed conversion program for Oracle Asset Tracking Location Mapping.

Developed the control file to upload the data in the staging table by Sql Loader.

Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, and reports.

Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents.

Designed and developed reports using combination of Report 6i and XML publisher.

Developed various custom reports, translations for reports, multi-sheet excel reports and customized standard Oracle reports as per the business requirements.

Developed interface for importing orders using SOA Implementation.

Developed Extensions for ASCP module and for user-defined item serial number generation.

Designed and developed reports using BI Publisher including Barcode printing, Check Printing, Pre-printing formats.

Tech Mahindra

Oracle Apps Technical Consultant

Projects Undertaken:

GE Aviation (R12 Implementation)

GE Appliances and Lighting (R12 Implementation)

Qantas Airways, Australia (Technical Support)

Roles & Responsibility

Developed an interface to upload the legacy data into the Oracle Application System.

Worked on iterative and incremental agile development framework.

Developed conversion programs for suppliers, customers, invoices.

Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, and reports.

Develop the UNIX shell scripting to fetch the files details from the server and utilizing the files for the business validation and later archiving the files and sending the status information via mail.

Responsible for gathering Business Requirements, creation of Technical Design Documents and user Documents.

Designed and developed reports using combination of Report 6i and XML publisher for modules like PO, AP.

Providing solutions to fix production issues.

Working on the Enhancements as per the changing business requirements.

Supporting zero defects process as per SLA compliance.

Supporting all the technical areas of Oracle modules like (PO, INV, AP, and AR).

Support to custom objects and its integration testing.

Period Close Support to business.

Oracle SR Support.

SYSTEM EXPERIENCE

Software / Products:

Oracle E-Business Suite 6i, Proficiency – Expert

Oracle Apps 11i, Proficiency –Training Only

Oracle R12, Proficiency – Expert

Oracle 10g client, Proficiency – Expert

Development Tools / Languages:

Toad 9.7, Proficiency - Expert

SQL Developer, Proficiency - Expert

Report Builder 10g, Proficiency - Training only

Oracle SQL, Proficiency – Expert

Advance Oracle SQL, Proficiency - Expert

Oracle PL/SQL (For Interfaces and Conversions), Proficiency – Expert

Advance Oracle PL/SQL, Proficiency – Expert

Winscp, Proficiency - Expert

Putty, Proficiency - Expert

Oracle XML Publisher, Proficiency - Expert

Hardware / Operating Systems:

Windows XP/Vista/7 Proficiency - Expert

Middleware / Databases:

Oracle Database, Proficiency – Expert

ACADEMIA

Post-Graduation Diploma in Financial Management

Narsee Monjee Institute of Management, Mumbai, India

Bachelor of Technology

Institute of Technology and Management [RTU Rajasthan, India]

Contact this candidate