SUMMARY:

• Oracle Certified Professional (OCP)
• Over 12 years’ experience of delivering robust solutions including:
• Requirements gathering, solution designing, creating functional / technical specifications, software development life cycle (SDLC), conducting UAT and users
• Over 6 years’ experience implementing and customizing Oracle E - Business Suite 11i and R12
• Techno/ functional expertise in modules: Purchasing (PO), iProcurement, Payable (AP), Receivables (AR), General Ledger (GL), Cash Management (CE), Human Resources (HRMS), Payroll modules
• Well versed in technologies: Hyperion, Toad, BI (XML) Publisher, FSG, ADI Integrator, SOA
• Strong analytical, problem-solving, time management and communication skills
• Organized, self-motivated, detail-oriented and a good team player
• Reliable and adaptable, take initiatives and learn new systems quickly
• Continuously learning and updating my skills to keep up with changing IT technology

TECHNICAL SKILLS:

Tools: & Technologies: Oracle, Siebel, SQL Server, Hadoop (Hive & Pig) Oracle Forms, Reports, Oracle BI Publisher, XML reports, Oracle SOA, Oracle Discoverer, Oracle APEX, Workflow Oracle AP, AR, GL, HRMS and Payroll Windows, Sun Solaris, Oracle Cloud PLSQL, Shell scripting, Pro C, Java TFS/ PVSC / Visual Sources Safe/HP QC, GO PKI, Control M Scheduler, Oracle CEMLI, Eagle Investment System

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Techno Functional Consultant

Responsibilities:

• Created a new ledger in Oracle E-Business R12 hosted on cloud, denominated in US currency, to enable users track foreign currency transactions
• Designed and development data transfer program (CEMLI) to process investment information arrived in Oracle E-Business Suite GL module (used by Intact) from Eagle Investment system further down into PeopleSoft GL module (used by One Beacon Corporation)
• Designed and developed comprehensive solution to enable users transfer information from Clarity PPM (Project Portfolio Management) to Oracle E-Business Suite Purchasing module
• Developed Excel based interface using Web ADI integrator, to enable users upload hours into Staging table
• Build required CEMLIs to perform validations and process information in Staging table via Receipt import interface
• To meet changing requirements of users, setup new bank account in Cash Management module and performed related testing of full procurement to pay cycle
• Designed and developed data transfer CEMLI to transmit balances from Corporate ledger in GL module to Oracle FCCS platform (Financial Consolidation and Close Cloud), including creating and scheduling required Control-M jobs
• Using Oracle Workflow Builder, performed customizations to Requisitions approval process
• Created system requirements document, functional and technical specification document (MD50/MD70), test scripts, and user guides
• Managed RFCs (request for changes) on Oracle cloud
• Worked with Oracle support to troubleshoot issues
• Assisted business users in ad hoc inquiries
• Performed code reviews for developers: provided feedback in terms of best practices for Oracle development
• Participated in solution design brainstorming sessions: suggested creative solutions and offered critical analysis

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked in Oracle upgrade project from R12.1.3 to R12.2.4.
• Modules in scope: Oracle AP, AR, GL, FA and HRMS
• Analyzed, monitored and fixed issues raised during the upgrade
• Provided functional and technical production support, assisted users in ad-hoc inquiries
• Worked with Oracle Support to manage service requests
• Created functional and technical specifications (MD050/MD070) and installation instructions (MD120)
• Developed and modified customized forms using Oracle Forms Builder
• Developed and modified customized reports using Oracle BI Publisher (XML Publisher), Oracle FSG tool
• Designed and developed Excel interface using Web ADI integrator to enable users upload invoices
• (Financial Statement Generator)
• Created number of CEMLIs including:
• CEMLI to import check images into the Oracle; used API to have them attached to respective invoices in AP module
• CEMLI to extract employee information from HR module into flat file and transmit it over to third party uniforms’ vendor via SOA (Service Oriented Architecture)
• CEMLI to import bulk invoices into AP module from utility vendors
• CEMLI to integrate Work Brain (time management) software to Oracle ERP payroll for employee payroll.
• CEMLI to customize Oracle workflow approval process and use Oracle AME to put approval rules as per business requirement.
• Created various financial and payroll reports as per business requirement, use Oracle XML reporting, Oracle discoverer and Oracle reports to achieve it.
• Personalize and customize Oracle OAF page as per business request.
• Used Visual Source Safe for source controlling and change management process

Confidential

Oracle Applications Techno /Functional Consultant

Responsibilities:

• Reviewed Oracle R12 upgrade strategy
• Performed impact and retrofit analysis for upgrade project for AP, AR, and GL modules
• Provided production support to users for post upgrade functional/technical issues
• Worked with Oracle Support to manage service requests
• Developed and modified customized forms using Oracle Forms Builder
• Developed and modified customized reports using Oracle BI Publisher (XML Publisher) and various ad-hoc reports using Oracle FSG tool
• Modified data transfer CEMLIs responsible for importing data into AP, AR and GL modules
• Created functional and technical specifications (MD050/MD070) and installation instructions (MD120)
• Used PVCS tool for source control and change management process

Confidential

Oracle Applications Consultant

Responsibilities:

• Responsible for implementing data migration from Siebel database to Oracle E-Business Suite; Modules in scope: AP, AR and GL
• Created mapping documentation and physical and logical diagrams for the migration process
• Worked with functional team to implement data migration mapping between legacy data system and the target application
• Designed and implemented ETL, validation, and data reconciliation process
• Managed functional and technical issue raised during the implementation
• Designed and developed interface CEMLIs to load large volume of data with parallel processing capability
• Created and modified Oracle BI Publisher (XML Publisher) reports and Oracle FSG reports
• Created customized forms and reports using Forms and Reports Builder
• Utilizing Oracle API’s (Application Programming Interfaces), seeded packages, procedure and functions, built-in concurrent programs
• Created functional and technical specifications (MD050/MD070) and installation instructions (MD120)

Confidential

Oracle Technical Lead

Responsibilities:

• Monitored, developed, debugged and implemented various applications run across bank branches
• Provided production support for Retail Information System; Monitored and fixed issues raised by business end users
• Performed upgrade of Oracle Forms / Report from 10g to 11g Fusion WebLogic Server
• Provided solutions for performance issues by rewriting existing programs in PL/SQL (package, procedure and functions)
• Designed and developed front end user application using Oracle Forms 11g and provided enhancements to existing ones
• Designed and developed ad-hoc management reports using Oracle Reports 11g
• Performed code review and enhancements for PLSQL code embedded in Pro C, C# and C++ language
• Coordinated with business end user for changes and enhancements
• Performed automations of manual jobs by creating Unix shell scripts.
• Monitored and resolved issues for overnight Unix Shell batch process that runs on branches
• Created Impact Analysis document, Technical and Functional Specifications, Logical and Physical Data Modelling, and Process Flow Chart for change requests and projects
• Used PVCS tool for source control and change management

Confidential

Senior System Analyst and Oracle Developer

Responsibilities:

• Gathered business requirements from users for changes and enhancements
• Presented proof of concepts with the help of stage prototypes and data flow diagrams
• Performed implementation of ETL (Extraction, Transformation and Loading) process
• Performed development for the client to meet business requirements using System Development Life Cycle Methodology (SDLC).
• Developed and modified Oracle Forms and Reports and back end database objects (Packages, Procedure, Function, Triggers, views/Materialized)
• Implemented standards for software installations and database monitoring
• Created requirements, functional/technical specifications, and documents
• Created test scripts: including load and regression testing
• Provided troubleshooting for issues raised by existing monitors
• Evaluated new technology and products from Confidential for the client

Confidential

Application Developer

Responsibilities:

• Worked as application developer and production support specialist
• Performed development for the client using System Development Life Cycle (SDLC) methodology.
• Developed and modified Oracle Forms and Report and back end database objects: procedures, functions, triggers, packages
• Performed unit testing and end-to-end integration testing
• Performed database monitoring and health check
• Created migration scripts using import/export, SQL loader and UTL FILE.
• Developed database auditing and security system to track users’ activities.
• Conducted meetings with client/end users to gather requirements.
• Performed installations of client side software
• Provided on call user support in 24x7 database environment

Confidential

Sr. System Analyst

Responsibilities:

• Implemented clients requirements via Business Process Reengineering (BPR)
• Developed new database objects tablespace, table, view, triggers, synonyms and roles.
• Created system flow diagrams, ER diagrams, technical and user documentation
• Debugged packages, procedures, functions, system source codes and PL/SQL libraries to optimize performance.
• Designed and modified custom Forms and Reports.
• Conducted end user and managed system issues.