We provide IT Staff Augmentation Services!

Senior Systems Analyst Resume

Illinois, NapervillE

PROFESSIONAL SUMMARY:

  • 13 years of extensive experience in Oracle e - Business Suite implementation, upgrade and customization.
  • Expertise in system study, requirement analysis, system design, Data Flow Designs, support, development, testing, documentation and design reviews.
  • Hands-on operational experience with the Oracle Revenue Management and Billing (ORMB)
  • Having strong skills in Business Components of Oracle Revenue Management and Billing Analytics(ORMBA)
  • Experience in implementation, upgrade, Customization and support of various Oracle Applications modules such as HRMS and Payroll, Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), Sourcing, Projects, Property, TCA, Warehouse Management System (WMS) and Customer Relationship Management (CRM).
  • Hands-on experience in Data Conversion, Data Migration and Developing Interfaces within several modules in Oracle Applications.
  • Hands-on experience in developing/customizing Oracle reports(6i/10g), Oracle forms (6i/10g) and BI Publisher reports.
  • Technically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions and Workflows).
  • Functional exposure on the business flows Procure to Pay (P2P), Order to Cash (O2C) life cycles.
  • Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
  • Expertise in designing and implementing Oracle Alerts and Lookups.
  • Fair Knowledge in customizing existing OAF pages
  • Performed User and Administration responsibilities in Discoverer.
  • Experience in Customizing Oracle Forms with Forms Personalization using Custom.pll and Zoom functionality
  • Well versed with the client-server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Workflow, Discoverer and OBIEE
  • Expert in developing Technical design documents (MD070), Technical Test documents (TE020), Conversion (CV050) and Migration documents (MD0120).
  • Interacted with users, fixed the bugs, developed test plans and provided daily production support.
  • Familiar with onsite & offshore model

TECHNICAL PROFICIENCY:

ERP: Oracle Financials (GL, AP, AR, FA, Projects)Oracle SCM (PO, OM, Sourcing, WMS, INV), Oracle HRMS.

OUAF: ORMB, CCB

RDBMS: Oracle 10g/11g/12c

Languages: SQL, PL/SQL, Shell Script, C, C++, Java

Tools: Oracle Developer 2000(6i/10g), Oracle BI Publisher, Discoverer Reports, JDeveloper, Oracle Workflow, SQL*Loader

Development Utilities: TOAD, SQL Developer, PL/SQL Developer

Operating system: UNIX, LINUX, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Illinois, Naperville

Senior Systems Analyst

Environment: Oracle Revenue Management and Billing 2.7.0.1.0

Responsibilities:

  • Perform application support and maintenance activity and provide technical assistance and advice on ORMB
  • Perform incident and change management for application issues and small break fixes on ORMB
  • Lead the support activities with Oracle Revenue and Billing support
  • Work in the Revenue and Pricing System's Core Rating, Pricing and Billing team and lead the effort to migrate from the legacy system to ORMB and support the resulting implementation.
  • Developed ORMBA reports as per the business request.
  • Define data mapping between the legacy system and ORMB, Work with the legacy system's team and the ORMB architect/configuration specialist.

Confidential, Los Angeles

Team Lead

Environment: Oracle Applications R12.2.6

Responsibilities:

  • Team Lead Role
  • Design and preparation of Data Templates for conversions based on the business scenarios
  • Involved in finalizing and conflict resolution of DFF’s in G-One instance.
  • Designing the technical design documents for the new components
  • Lead the team on their deliverables
  • Developed conversions code for below
  • Counter group Creation
  • Install Base conversion for EID and TBS instance
  • Counter/Meter Reading
  • Customer Conversion for Accounts, Sites, Profiles, Site Uses, Contact Points, Site Contacts
  • Suppliers Conversion
  • Employees Conversion
  • AR On-Account Cash Receipts
  • GL Mass Allocations for misc. journals
  • Developed common utility load programs for conversions
  • Developed Common Pre/Post activity program
  • Retrofitted FTP host programs with IIB tool
  • Familiar with on-site and off-shore model.
  • Coordination with cross teams on the technical/functional related issues.

Confidential, Los Angeles

Team Lead

Environment: Oracle Applications R12.1.2

Responsibilities:

  • Team Lead Role
  • Business requirements gathering, Gap Analysis and preparation of High-Level documents such as MD50 Functional Specifications, MD070 Technical Design.
  • Developed SQL loader and PL/SQL code for validating and populating staging and interface tables from legacy systems
  • Involved in the development and customization of standard reports for application modules.
  • Was responsible for the conversation of Optio report to XML reports.
  • Involved in end to end testing from Order to Cash & Procure to Pay
  • Involved GTM to EBS Item Categories Outbound Interface
  • Involved EBS to KEWILL interface changes from TIBCO middleware to SOA
  • Involved Duplicate Categories Cleanup Interface
  • Well understanding of the Business process by working with the users closely in order to provide the best-fit solutions.
  • Having the experience to deal with Sev1, issues effectively as part of production support and handled multiple critical issues in Production support time.

Confidential, New York

Sr Oracle application Technical Consultant

Environment: Oracle Applications 11.5.10

Responsibilities:

  • Involved in the day to day activities of production support of Oracle applications environment in AP, GL, HRMS and Payroll.
  • Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
  • Work on the development activities as part of issue resolution. Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.
  • Closely worked with users to understand business needs and objectives.
  • Developed Void-Reissue-Reversal check details report.
  • Developed the U.S. Equal Employment Opportunity Commission (EEO) report.
  • Worked on the SIT interface program to validate and load Bonus data from the legacy system.
  • Worked on Oracle Financials technical issues and provided the solutions as per the requirement.
  • Worked on automation of the Fiscal sales bonus process.
  • Developed Tax Balance and Run Results OAF pages.
  • Worked on the VRS outbound interface program to gets the employee details from the Oracle HRMS system and Load Voice Response System’s server.
  • Worked on KRONOS Time interface to payroll

Confidential

Sr Oracle application Technical Consultant

Environment: Oracle Applications 11.5.10

Responsibilities:

  • Doing the Data Migration activities of Core HR/Payroll through conversion scripts (like personal, assignment, job, position, grade, bank details, element entry, pay proposals etc)
  • Development of new reports and customization of Reports by using XML publisher and RDF Reports.
  • Enhancement in Fast Formulas as per user requirement
  • Preparing Approval Hierarchies using HTML and Workflow Builder
  • Creation of different types of Alerts like Event and Periodic according to the client requirements including the details of the processes.
  • Responsible for coding, testing & debugging of Interface Scripts, conversion API's and packages.
  • Analysis of Report/Interface Specifications and preparing MD50 and MD 070.
  • Involved in impact analysis and technical solutions design for change requests and new enhancements to the system.

Confidential

Oracle Application Technical Consultant

Environment: Oracle Applications R12.1.2

Responsibilities:

  • Provide 24x7 Production Support and Maintenance of Business Applications like Financial, Procurement, HRMS and Payroll.
  • Involved in impact analysis and technical solutions design for change requests and new enhancements to the system.
  • Involved in analyzing the business requirements and building an effective solution to enhance the production system.
  • Well understanding of the Business process by working with the users closely in order to provide the best-fit solutions.
  • End-user support on Oracle HRMS modules (Core HR, Payroll and Self Service HRMS)
  • Developing Different types of Reports in Core HR and Payroll.
  • Dealing with Sev1 issues effectively as part of production support.
  • Handled multiple critical issues in Production support time.

Confidential

Oracle Application Technical Consultant

Environment: Oracle Applications R12.1.1

Responsibilities:

  • Enhancement in payroll element calculation using Fast Formulas according to new policies.
  • Define Payroll, Assignment Sets, Element Sets, Organization and Payment Methods
  • Doing the Data Migration activities of Core HR/Payroll through conversion scripts(like Persons, Assignments, Jobs, Position, Grade, Bank Details, Element Entries, Pay proposals, etc)
  • Worked on Conversions Developments for Item Master, Item Categories and Item Catalogs.
  • Worked on Interface Development for AP Invoice, GL Interface(Journal Import), GL Budgets, Fixed Asset(Mass Additions) and Item On-hand Quantity
  • Worked on Standard API for Stock Locators, AR Receipts, Employee Details, Positions, Supervisors, Employee Salary and Employee Assignments.
  • Well understanding of the Business process by working with the users closely in order to provide the best-fit solutions

Confidential

Oracle Application Technical Consultant

Environment: Oracle Applications R12.0.6.

Responsibilities:

  • Worked on Conversions Developments for Suppliers and Customers.
  • Worked on Interface Development for AR Invoice, GL Interface(Journal Import), Fixed Asset(Mass Additions), Purchase Orders, and Item On-hand Quantity
  • Created a Pre-Printed Stationery Reports For Check Print and Receipt Voucher
  • Designed the functional mapping between the Source and Destination systems while designing the Interfaces
  • Involved in Development of Custom Reports using XML Publisher and Discoverer
  • Preparing the documentation for the designed components as per AIM standards.
  • Implemented Performance Tuning mechanisms across the deliverables to meet the business standards
  • Involved in SYSADMIN tasks like Responsibilities, Request Groups, Users and Custom Menus creations
  • Conducting Workshops with Super Users and Managers for gathering Requirements in modules like Inventory, Purchasing and Account Payable

Confidential

Oracle Application Technical Consultant

Environment: Oracle Applications 11.5.1

Responsibilities:

  • Developing Conversions & Interface programs for WIP, BOM and AP modules.
  • Involved in Development of Custom Reports using Report 6i, and XML Publisher
  • Preparation of technical specifications from the functional specifications Received from the functional team like CV60, MD70 using AIM.
  • Played a major role in 11i implementation of Manufacturing, Financials, distributions modules.

Hire Now