Sign in

Oracle Financials

Milwaukee, Wisconsin, United States
March 14, 2018

Contact this candidate



**** ***** ***** *** **, APT 110, Bayside, Wisconsin, 53217

Phone: 310-***-**** Email:


To be member and mentor of a technology team and work on challenging aspects of design, development and support of IT Systems.


•Over 5 plus years of IT experience in mapping business requirement to oracle and in developing Reports, Interfaces, Conversions, Enhancements and Workflows(RICEW) using ORACLE Tools such as Reports 10g/6i, SQL*Loader, SQL*Plus, SQL Developer, Workflow Builder, XML Publisher, etc.… and managing teams.

•Experience in Software Development Life Cycle (SDLC) methodologies such as Agile Scrum and Waterfall Model.

•Experience in developing interfaces and conversion programs between various legacy systems and Oracle Purchasing, Order Management, Payables, Receivables, General Ledger, Cash Management, Core HR modules, Cost Management, Advanced Collections etc.

•Functional knowledge on the flow of ‘Order to Cash’ & ‘Procure to Pay’ life cycles and Sub Ledger Accounting (SLA)

•Expertise in System Administrator activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports, concurrent programs, profile options.

•Worked in teams involved in requirements study, design and development of database for ORACLE APPLICATIONS.

•Experience in developing Database Triggers, Stored Procedures, Functions and Packages

•Skilled in Application Implementation Methodology (AIM) documents such as BR100, MD050, and MD070.

•Good understanding of Multi Org & TCA Architectures.


SRK SYSTEMS INC (Naperville, Illinois) Jun 2015 – Present

Role and Responsibilities: Oracle Financials Functional Consultant

Provide IT technical expertise and implement technology solutions as per the end client’s need and requirement.


REGAL BELOIT CORPORATION (Wisconsin, Grafton) Jan 2016 – Present

Role: Lead Oracle Financials Functional Consultant

Environment: Oracle EBS R12 – AP (Accounts Payable), AR (Accounts Receivable), GL (General Ledger), OM (Order Management), CE (Cash Management), AC (Advanced Collections), CM (Cost Management) Oracle 10g, Forms 10g, Reports 10g, XML Publisher, TOAD, SQL, PL/SQL, UNIX.

Developed a custom XML liability segregation report on RTF template using Oracle Reports Builder named RBC AP by Sales Brand Report procedures to provide liability segregation for Regal’s sales brands such as Genteq, Marathon, Leeson etc. This is an Org specific report which provides liability segregation for every operating unit. This has helped in segregation of liability across Regal’s businesses to meet statutory requirements.

Manage an offshore production support team of 50 people in India and report directly to the director of information technology.

Designed and Developed an Oracle enhancement using PL/SQL for Regal’s Global Sourcing business team to create custom holds on supply chain finance invoices which have a pay site of secondary pay. This helped invoices to be paid as part of Automated Clearing House payment run to avoid invoice aging by sending Custom Alerts to the Shared Accounts Payable department to change the pay site to secondary pay.

Designed and developed a custom “Received but Not Delivered Report” on XML to provide a custom view to extend On-hand inventory valuation, Business intelligence report to provide true on hand inventory valuation to higher management.

Implemented Oracle Cash Management on Regal US (526) Company Code and Regal Canada (509) as part of Regal’s cash management global rollout process.

Implement ACH Automatic Payment Process for Regal Canada for remitting supplier payments through Automated Clearing House.

Designed and Developed a Custom PL/SQL object named “RBC Bank Statement Program” to achieve transaction number populate process by populating payment document numbers and cash receipt numbers in Cash Management Interface Tables to achieve auto reconciliation whenever possible. The design is based on comparative matching of payment document numbers and cash receipt numbers against previous day BAI2 bank statements of PNC (Pittsburgh National Corporation) and Bank of Montreal (BMO). This helped achieve automatic reconciliation of bank statements whenever possible.

Identified and Corrected Key Standard Operating Procedure issue on Expense Accrual Reversal of Un-Invoiced Receipts which are not reversing as part of standard oracle functionality. Reproduced the issue on test environments and corrected the Standard operating procedure to mitigate the issue in production and provided an updated Standard Operating Procedure to Finance business users to fix the ongoing issue

Prepared numerous BR100 Setup Documents, MD050 Functional Design Document, MD070 Technical Design Document, CE040 Conversion Documents, Test Case Documents (TEO40) etc. in various modules such as Oracle Accounts Payable, Accounts Receivable, Work in Process, Purchasing etc.

Performed functional setups and provided data Conversion Strategies, validated Data Conversions such as Open Accounts Payable Invoices, Open Accounts Receivable Invoices, Pre-and Post-Conversions Trial Balance Liabilities on Open Account Payable, Accounts Receivable Trial Balances etc. from PTS (Power Transmission Systems) Maria System, STAR (Mechanical line of Business), Wuxi Row etc. legacy systems to Regal’s Source IPROD System.



Description: Licensing Elements such as applications, permits, registrations have been proposed to be integrated into a web based application; Liquor Information Tracking System (LITS) to modernize the license issuance system for DOLC. Environment: .Net, MTM (Microsoft Test Manager), TFS (Team Foundation Server), LM (Liquor Management) ERP, AP (Accounts Payable), AR (Accounts Receivable), GL (General Ledger)

Role and Responsibilities: Business Analyst

•Reviewed use case documents and developed Test scenarios, functional and regression test cases.

•Imported test script from excel into MTM and updated the test cases using TFS.

•Logged, Tracked and Generated Bug status reports using TFS and presented test cycle results to the Project Manager.

•Worked closely with Business Analysts to ensure the application meets the expected level of quality.

•Performed field level validation, backend testing and functionality testing of LITS system during integration phase with LM.

•Created documents for System Testing, Integration testing, End-to-End testing and User Acceptance Testing.

•Involved in daily meetings with the client regarding schedule and activity tracking (Show and tell)


STRYKER CORPORATION (Kalamazoo, Michigan) Jun 2015 – Oct 2015

Description: Stryker’s Compensation Team wanted to launch a tool to manage compensation across all their business groups. The development of the tool was outsourced to a third party vendor; Beqom. Five separate data extracts are to be run on a specific daily schedule as a data feed for the compensation tool. Environment: ORACLE EBS Version R12 – Core HR, SQL, PL/SQL, SQL Developer, Oracle 11g, UNIX.

Role and Responsibilities: Lead Business Analyst

•Involved in gathering requirements for Stryker’s Beqom Outbound Interface.

•Trained users to run the concurrent program, execute test scripts and extract files from archive folder.

•Prepared AIM Documents MD050, MD070 and MD120.

•Used PL/SQL utility to extract employee, assignment and compensation information as five data files.

•Used FND loads to download LDT’s (Loader Data File’s) from UNIX for code migration to test instance.

•Worked with the DBA to clone development instance with the latest production data.

•Worked with IBM on a regular basis on PGP encryption, SFTP for file transfer, archive logic and decryption of files.

•File reconciliation with respect to Beqom’s error log and advised on their ETL process issues.

•Created a request set to send error log file to the designated user group.


PROPELSYS Tech INC (Plano, Texas) Apr 2015 – Jun 2015

Role and Responsibilities: Programmer Analyst(Intern)

Oracle order to cash and procure to pay functional training on Oracle R12


CSX Tech INC (Plano, Texas) Mar 2015 – Apr 2015

Role and Responsibilities: Programmer Analyst (Intern)

Trained on Oracle PL/SQL, Reports and Forms.



Role and Responsibilities: Graduate Assistant/Research Assistant

•Conducted Research in the Department of Civil and Environmental Engineering & Construction.

•Externally funded graduate assistant in the Office of International Students and Scholars.

•Assisted responsible school officials in various matters related to immigration advising.

•Ran Reports from PeopleSoft Campus Solutions(ERP) to verify student enrollment and utilized a front end

application FSA (Federal Student Application to complete International Student Enrollment for every semester.


QWAY TECHNOLOGIES INC (Visakhapatnam, India) April 2011 – Aug 2013

Description: As a global business process outsourcing company QWAY has millions of customer transactions every year. Environment: Oracle EBS R12 – GL (General Ledger), AP (Accounts Payable), AR (Accounts Receivable), CE (Cash Management), INV(Inventory), Order Management(OM), CM (Cost Management), Bills of Materials(BOM), Purchasing(PO), Human Resources(HR), Oracle 10g, Forms 10g, Reports 10g, XML Publisher, SQL*Loader, SQL Developer, SQL, PL/SQL, UNIX.

Role and Responsibilities: Programmer Analyst

•Developed a program to load invoice data from NOMADS legacy system using SQL*Loader and Oracle seeded utilities to import data into AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE interface Tables.

•Customized multiple reports and forms in GL, AP, AR and OM modules according to the requirements.

•Interacted with users to map requirements and develop custom code, forms and reports to register in application.

•Used Web Application Development Interfaces to import data from Excel to Oracle General Ledger

•Developed multiple Customizations and documented every process into a global process using AIM Methodology.

•Functional Setups for core financials implementation.


Oracle EBS Modules:

General Ledger (GL), Sub Ledger Accounting (SLA), Accounts Payables (AP), Accounts Receivables (AR), Purchasing (PO), Order Management (OM), Inventory (INV), Human Resources (HR), Self Service HR(SSHR), Payroll and Oracle Advanced Benefits (OAB), Cost Management(CM), Advanced Collections(AC)


Procure to Pay & Order to Cash

Oracle Tools:

Reports 10g/6i, Forms 10g/6i, SQL*Loader, SQL*Plus, SQL Developer, Toad, Workflow Builder, XML Publisher

Oracle EBS Versions:

R12, R11





Institution & Year of Completion:

CGPA/ Percentage:

Master of Business Administration, Management Information Systems

Concordia University, Wisconsin, Current

3.73 (IN Progress)

Master of Science in Civil Engineering

University of Nevada Las Vegas, 2014


Bachelor of Technology, Civil Engineering

GITAM University, 2012



References shall be provided upon request.

Contact this candidate