We provide IT Staff Augmentation Services!

Senior Analyst Resume

Danbury, CT

SUMMARY:

  • Oracle Certified 9i (OCA) professional with over 19+ years of rich experience working in IT industry and 17+ years of experience as an Oracle EBS professional, I have worked in implementation, support, solution designing and project management of EBS 12.1.3, 11.5.10.2 and 11.5.8 in various Oracle financials and supply chain modules.
  • 17+ years of experience in Oracle Applications Financial modules PA, AP, AR, GL, SLA, FA, CE, IBY, ZX.
  • 5+ years of experience in Supply Chain modules such as PO, iPro, INV, OM.
  • Extensive knowledge of Agile methodology.
  • Completed 3 Full Life Cycle Implementation and 10 Post Implementation Support / Production support of Oracle Application R12/11i (GL, AP, AR, FA, CM, PA, PO, OM, INV).
  • Completed 2 Full Life Cycle migration of financial modules from R11.5.10.2 to R12.0.4
  • Worked in multiple business processes like Procure to Pay and Order to Cash.
  • Project Billing and Costing, integration of PA with other modules in EBS
  • Adept in all stages of project lifecycle including feasibility study, analysis, business requirements, technical design & development, creating testing scenarios, user acceptance testing and production support.
  • Extensive experience in implementation & production support of Oracle E - business Suite R12.1.3 and 11i using Oracle 10g/11g/12c Databases, PL/SQL, UNIX shell scripting, Reports & Forms 10g/6i, XML BI Publisher reports, Oracle Workflow.
  • Full cycle knowledge of solution development for CEMLI/RICE components viz. interface-programs, reports, forms, Oracle workflows, Alerts, Personalization starting from the analysis and design phase to the development, unit test and integration test phases.
  • Extensive knowledge and experience in SOX compliance & release management processes for Oracle ERP
  • Oracle functional and technical documentation like BR100, MD050, MD070 and MD120
  • Experience in integrating Oracle E-Business Suite with various US banks like BNY Mellon/JPMC/BOA for ACH and other systems like Concur, Paypal etc
  • Innovation, excellent inter-personal, written and oral communication skills, teamwork and flexibility
  • Project management experience including 12 years of onsite/offshore model

TECHNICAL SKILLS:

Oracle EBS R12 & 11i: Project Accounting (PA), Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Inventory (INV), Fixed Assets (FA), Cash Management (CE), Purchasing (PO), iProcurement, Order Management (OM), AOL, SLA (Subledger Accounting), E-Business Tax (ZX), Financial Statement Generator (FSG)

Oracle EBS Technical: Oracle Reports & Forms development, BI Publisher XML Reporting, Oracle BI Discoverer, OBIEE 11g, OBIEE 10.1.3, Integrating Oracle E-Business Suite with legacy systems, Oracle Workflow customization, OA Framework Customization, OA Framework personalization, Forms Customization & Personalization, Oracle Applications AOL, Oracle Alerts, Testing using Oracle Test Manager, Oracle Financial Analyzer (OFA) 6.4, ADI 7.2, AIM 3.0, TOAD, SQL Navigator

Oracle Development Tools: Oracle PL/SQL with Oracle database 8i/9i/10g/11g,/12 Oracle Reports & Forms Builder 10g/D2K 6i, Oracle Workflow Builder, Oracle BI Publisher XML, TOAD, Version Management tools like PVCS/VSS/TFS, Unix shell scripting, SQL Loader, LDT scripting, Oracle Test Manager 1.0, JDeveloper, Oracle Alerts, Data Loader, Oracle Web ADI

Other Tools: Microsoft Office Word, Excel, PowerPoint, Visio, Projects

PROFESSIONAL EXPERIENCE:

Confidential, Danbury, CT

Senior Analyst

Responsibilities:

  • Implemented new R12 functionality called “Pay When Paid” (PWP).
  • Configured custom R12 Sub Ledger accounting (SLA) to recognize expense and non-expense revenues.
  • Created Custom ADI's to upload project events (PA Billing), AP invoices and AR invoices using oracle standard BNE API's from Excel spreadsheet.
  • Interacted with business users on requirement gathering, creating MD 50 and MD70 (AIM Methodology).
  • Participated in production support activities for Account Payables, Account Receivable and Project billing modules.
  • Work on all phases of a project starting with requirements gathering to going live
  • Production Support and ad hoc functional and technical support to various business teams and also develop solutions to complex system issues and critical enhancements.
  • Regression and system integration testing cycles.
  • SOX compliance for all objects and changes made to Oracle E-Business Suite.

Confidential, Fairfield, CT

Team Lead (Techno Functional Consultant)

Responsibilities:

  • Working with business users to identify functional, technical specifications & requirements.
  • Deliver technical and functional solutions that support the organizations financial and business process initiatives
  • Preparing functional and technical documents as per business requirement, based on these documents team members develop or enhance the functionality.
  • Performing conference room pilot (CRP) testing and related documentation/deliverables
  • Plan, prepare, and execute quality assurance and user acceptance testing. Engage business users during UAT and facilitate sign-off on test results.
  • Design and development key financial reports as well as configuration of modules to ensure and achieve global functionality
  • Supporting the development team as it configures, builds, and tests the application enhancements.
  • Work with other team members to ensure that the configuration and custom components meet application requirements and performance goals
  • Developed a custom program to extract all the balances from the system as per the CCL requirement.
  • Define the existing Chart of account mapping with the new system Chart of account.
  • Design, implement and support finance and business intelligence modules.
  • Generated separate files for GL Balances for each Set of Books for primary and consolidation books from R 11.5.10.2.
  • Prepare Test Scripts and test cases in for Oracle General Ledger.
  • Train the functional team on testing procedures

Environment: Oracle Application R12 (GL, AP, AR, FA, IBY), BI Publisher, OBIEE 11g, Oracle Application R11.5.10.2 (GL), AOL, Toad 9.6, AIM Methodology, Putty, Linux

Confidential, Fairfield, CT

Team Lead (Techno Functional Consultant)

Responsibilities:

  • Developed validation scripts to validate data while loading into GL interface tables.
  • Developed outbound interfaces to extract data from Oracle Application systems into .CSV files during the GL month end close/quarter end close and year-end close
  • Involved Year End and Month End Close activities for 17 Sob’s
  • Worked with users in Month end/Quarter end/Year end close process relating to Revaluation, Translation and consolidation process.
  • Worked on the consolidation process mapping and mapping set relating to Consolidation and transferring data from Primary set of books to USD consolidated set of books.
  • Worked on preparing test scripts for different processes, which need to be tested before Monthly/Quarterly/Year end close.
  • Run all the closing process (Revaluation, Translation & Consolidation) on Monthly/Quarterly/Yearly basis and generate the consolidate report from primary & consolidation books.
  • Done enhancement to TREMA (Treasury), MOR (Monthly Operating Rate) and GAP rate program as per client requirement.
  • As per business requirement design a process two capture additional segments in the Key Flexfield.
  • Defined various ADI templates to load journals into Oracle GL as per user requirements.
  • Reconciliation of AP & AR to GL.
  • Managing Discoverer Administrator role for around fifty discoverer users globally.
  • Managing access and privilege of business area and workbooks.
  • Creation and maintenance of discoverer business areas.
  • Experience working with Oracle On Demand, Oracle support, opening, managing, and resolving Oracle TARs

Environment: Oracle Application R11.5.10.2 (GL, AP, AR), AOL, OBIEE, Oracle 10g, Forms 6i, Reports 6i, Toad 9.6, AIM Methodology, Putty, Linux

Confidential, Shelton, CT

Team Lead (Techno Functional Consultant)

Responsibilities:

  • Involved in technical support, functional support, month end, yearend process of the entire Oracle Financials Application System with four main modules (GL, AP, AR, PO).
  • Done changes to functional setups due to change in Business Process or business requirement.
  • Prepare Application extensions functional design (MD050) and Application extensions technical design (MD070) documents
  • Development and modification of FSG reports as per client requirement.
  • Performed Setup of Auto Lock Box Interfaces by developing SQL*Loader Scripts for importing legacy systems Receipts data into AR interface tables.
  • Query optimizing using EXPLAIN PLAN and TKPROF.
  • Helped team members in developing RICE components (Reports, Interfaces, Customizations/Conversions and Extensions).
  • Worked with other functional integration team while testing the reports which was developed or modified.
  • Performed Administrative functions including Creating Users, Responsibilities, Menus and User Security system. Created/Registered Concurrent programs, Concurrent executables, Value Sets, Flex Fields, Reports, PL/SQL Procedures and Packages.
  • Worked extensively on issues related to GL, AP, AR, and PO modules. Used TAR mechanism of Oracle Support for obtaining relevant patches.
  • Designing, customizing, and configuring Oracle Business Intelligence (BI) Applications and Oracle Business Intelligence Warehouse (OBAW).
  • Extensively used AOL and System Administrator modules for set up of various Concurrent programs, Request sets, and Value sets.
  • Experience working with Oracle support, opening, managing, and resolving Oracle TARs
  • Provided to the End Users on different Modules and also developed Lab scenarios for client.

Environment: Oracle Application R11.5.10 (GL, AP, AR, PO), BI, AOL, System Administrator, Oracle 9i, Forms 6i, Reports 6i, Toad 8.6, AIM Methodology, UNIX

Confidential

Team Lead (Techno Functional Consultant)

Responsibilities:

  • Study the Client business process and prepared the documentation for As Is and To Be
  • Analyzed the detailed business requirements and mapped them to Oracle General Ledger, Oracle Payable, Oracle Receivable, Fixed Asset, and Cash Management Functionality.
  • Prepared the Gap Analysis document based on the study and prepared the Setup Document (BR100).
  • Conducting Conference room Pilot (CRP’s) with Client and Team members as and when required.
  • Prepare Application extensions functional design (MD050) and Application extensions technical design (MD070) documents.
  • Conducted weekly meetings to monitor progress and realignment of priorities.
  • End User and Support during Go Live and post implementation
  • Designed various data loading programs and documentation pertaining to different project phases. Designed customized reports and all documentation and deliverables.
  • Done functional setups of GL, AP, AR, FA, CM
  • Created new End User Layer (EUL) for Oracle Discoverer version 10g. Created views, business, areas and reports.
  • Administer discoverer end user layer (create folders/joins/manager security/privileges) using discoverer administration edition
  • Designed and developed various Reports using Discoverer 10g.
  • Load Legacy Asset data into Oracle Asset with Application Desktop Integrator
  • Enabled the Lockbox Interface functionality with the third-party applications/systems
  • Developed Bank Statement Open Interface to load the Bank transaction files in Cash Management as like Confidential specification
  • Defined Bank Transaction Code as per the code used by external bank in cash management for reconciliation
  • Writing Business Logic for migrating data from current system to Oracle Application
  • Developed FSG Reports (Balance Sheet, P&L etc)
  • Configure ADI with Oracle Application
  • Wrote scripts using CONCSUB utility to schedule/call/submit concurrent requests from the Operating System
  • Define General Ledger Segment Mapping with Enterprise Planning and Budgeting
  • Define Business Process, Dimensions and Hierarchy etc as per the user requirements.
  • Define users and assign responsibilities for EPB.
  • Creation of reports and folders as per the user requirements.
  • Load Budget data and develop reports through Application Desktop Integrator.
  • Enforce Business logic/Integrity by writing Package / Trigger / Procedure / Functions / Forms etc.
  • Apply Patch for Localizations Issues.
  • Experience working with Oracle support, opening, managing, and resolving Oracle TARs

Environment: Oracle Application R11.5.10 (GL, AP, AR, FA, CM, PA, EPB), AOL, System Administrator, Discoverer 10g, Forms 9i, Reports 9i, Oracle 9i, Linux ES4, Windows 2000, Toad 8.6, Data loader, Application Desktop Integrator, AIM Methodology

Confidential

Team Member (Technical Consultant)

Responsibilities:

  • Gathered requirements, performed impact analysis and estimations for Reports customization
  • Imported the journal entries from legacy system to Oracle General Ledger using SQL*Loader, performed validations including purging previous data, checking for duplicate files, validate input data, updating invalid data, formatting input data. Transferred data from Custom Staging table(s) to Interface table(s) using PL/SQL package and populated the data into GL base table
  • Developed packages, stored procedures, and triggers and tune SQL statements and resolve performance or system issues.
  • Performed Troubleshooting Data errors
  • Developed & Customize reports as per user requirements.
  • Query optimizing using EXPLAIN PLAN and TKPROF
  • Development of new FSG reports (department wise expense report, location wise expense report, cost center wise expense report)
  • Prepare Application extensions functional design (MD050) and Application extensions technical design (MD070) documents.
  • Creation of Value sets/Concurrent Request / Programs / Request Groups etc

Environment: Oracle Application R11.5.10 (GL, AP, AR), AOL, System Administrator, Forms 6i, Reports 6i, Oracle 9i, Linux ES3, Windows XP, Toad 8.6, AIM Methodology

Confidential

Team Member (Techno Functional)

Responsibilities:

  • Developed reports using Reports 6i including AP Recipients, AP Trial Balance, AP Trial Balance Charges, GL unused segments report, GL Sub Ledger report, AR Batches
  • Interacted with the end-user to gather the requirement for the Customization of Financials modules and for all kinds of reports
  • Worked with Auto Invoice Interface Receivables and Data Conversions
  • Reports Customizations, Development of New Reports
  • Developed GST Input and Output Report (Specific to Singapore)
  • Prepare Application extensions functional design (MD050) and Application extensions technical design (MD070) documents.
  • Developed FSG reports (Profit and Loss Account, Rectified balance sheet report).
  • Developed Package, Procedure and Functions etc.
  • Worked on UTL FILE utility to generate CSV and flat files from Oracle Application.

Environment: Oracle Application R11.5.9 (GL, AP, AR), AOL, System Administrator, Forms 6i, Reports 6i, Oracle 9i, Sun Solaris 8, Windows XP, Toad 8.5, AIM Methodology

Confidential

Team Member (Technical Consultant)

Responsibilities:

  • Reports Customizations, Development of New Reports as per user requirements.
  • Prepare Application extensions functional design (MD050) and Technical design (MD070) documents.
  • Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
  • Loading Customer Through CUSTOMER INTERFACE: Transfer Customer data from flat file to Oracle app base table. Populate records in INTERFACE tables. Created PL/SQL Procedures to validate and load the data into the Customer Interface tables.
  • Enable several DFF to Capture Extra information
  • Feeder Program for Invoices to be uploaded from the legacy system to base apps
  • Developed packages, stored procedures, and triggers and tune SQL statements and resolve performance or system issues.

Environment: Oracle Application R11.5.9 (GL, AP, AR), AOL, System Administrator, Forms 6i, Reports 6i, Oracle 9i, Microsoft Windows Server 2000, Windows 2000, Toad 8.5, AIM Methodology

Confidential

Team Member (Functional Consultant)

Responsibilities:

  • Involved in functional setup of Accounts Payables/Taxes (TDS/SDS) etc, also helped other members to understand the functionality of Accounts Payables.
  • Gone through BR100 document to understand business process.
  • Participating in Conference room Pilot (CRP’s) with Client and Team Lead.
  • Setting up the functionality of TDS in Accounts Payable module.
  • Develop test case to check the functionality of TDS/SDS/UPST.
  • Developed the AP invoices Interface program incorporating TDS/SDS/UPST taxes from legacy system, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations, especially for Taxes, before loading into AP INVOICE INTERFACE, AP INVOCIE LINES INTERFACE tables and Calling Payable Import Program.
  • Localization Support specific to TDS related Issues.

Environment: Oracle Application R11.5.9 (Accounts Payables), AOL, System Administrator, Forms 6i, Reports 6i, Oracle 8i, LINUX ES3, Windows XP, Toad 8.5, AIM Methodology

Confidential

Team Member (Techno Functional)

Responsibilities:

  • Requirement gathering from the Core team members of the organization
  • Helped in Creation of AS - IS and TO-BE process.
  • Done functional setups of GL, AP, AR, CM, FA
  • Participated in Conference room Pilot (CRP’s) with Team Lead and Client as and when required.
  • Developed functional mapping for existing legacy system to Oracle Apps. (Utilizing functionality of Key flexfields and Descriptive flexfields)
  • Administer discoverer end user layer (create folders/joins/manager security/privileges) using discoverer administration edition. Created new End User Layer (EUL), views, business areas and reports
  • Wrote a package on AR Auto Invoice interface, Imported invoices from legacy system to Oracle Receivables tables using the Auto Invoice import program and wrote a custom program in grouping the invoices based on the requirement.
  • Developed the AP invoices Interface program, loaded the data from flat file to the staging table using SQL*Loader and did all the necessary validations before loading into AP INVOICE INTERFACE, AP INVOCIE LINES INTERFACE tables and Calling Payable Import Program.
  • Enabled the Lockbox Interface functionality with the third-party applications/systems
  • Load Legacy Asset data into Oracle Asset with SQL Loader by populating interface table.
  • Developed procedure to load Bank Statement transaction file (data file) in Cash Management as like Confidential specification.
  • Mapped Bank Transaction Code as per the code used by external bank in cash management for reconciliation
  • Developed Custom forms (with the Template.fmb, CUSTOM.pll) to Capture Form C information and Security Deposit for the dealers/Customers
  • Give Functional and Technical support to the user.
  • Developed FSG Reports (Balance Sheet, P&L, and Expense Reports etc.)
  • Configure ADI with Oracle Application.
  • Registration of Program: Registered reports, Procedure and SQL *Loader in Oracle Apps. Defined executable, Concurrent Program and attached in Request Group.
  • Load Budget data in GL through ADI.
  • Query optimizing using EXPLAIN PLAN and TKPROF
  • Created custom table and registered in apps by using ad dd package.
  • User/Responsibility/Menu/Flex field/Value set/Concurrent Request / Programs / Request Groups etc. Management.
  • Enforce Business logic/Integrity by writing Package / Trigger / Procedure / Functions / Forms etc.
  • Database Backup, Database Clone, Manage Tablespace, and Extent etc.
  • Prepare Application extensions functional design (MD050) and Application extensions technical design (MD070) documents.
  • Support to TDS/SDS/UPST Localization features.

Environment: Oracle Application R11.5.8 (GL, AP, AR, FA, CM, PA, iExpenses, PO, OM, INV), AOL, System Administrator, Discoverer 4i, Oracle Workflow 2.6, Forms 6i, Reports 6i, Oracle 8i, Discoverer 4i, Sun Solaris 8, Windows 2000/XP, Toad 7.6, Data loader, Application Desktop Integrator 7.0, AIM Methodology, X Manager, Humming Bird Exceed 9.0

Hire Now