Objective:

• Seek a challenging position as Senior Oracle E Business Suite Technical/Functional Consultant.

SUMMARY

• Over Nineteen years of experience in Oracle 10g, 9i, 8x, 7x and 6 Databases, SQL *Plus, PL/SQL, SQL, Pro *C, Developer 2000 tools (Forms 9i IDS, 6i, 6, 5, 4.5 and Forms 3, Reports 9i, 6i, 6, 3 and 2.5 and Graphics 2.5) and Windows NT/2000/9x
• Over Ten years of Experience with Oracle Applications r12 and 11i modules such as GL, AP, AR, Cash Management, Fixed Asset, iExpense, Oracle Projects such as Project Accounting, Project Billing, Project Costing, Supply Chain Management Modules such as Oracle Inventory, Oracle Order Management, Oracle Purchasing, BOM, Oracle Transportation Manger (OTM), Oracle Process Manufacturing OPM, Advance Pricing, XML/BI Publisher
• Over one year of functional experience in Oracle Financials modules such as GL, AP, AR, CM, FA, PO, iExpense release 12
• Over five years of experience with Oracle Business Intelligence Enterprise Edition 11g, 10g (OBIEE), Seible Analytics
• Hands on experience with Oracle Business Intelligence Applications (OBIA) including HRMS Analytics, Financials Analytics and Supply Chain Analytics
• Over five years of experience in Design, Development and implementation of reports, answers and dashboards, Warehouse dimentional and relational modeling
• Hands - on experience with Oracle Application Development Frame work (ADF) 11g, jDeveloper 11g, Oracle Application Frame work (OAF), Java, JSF, JSP, Weblogics, Webservices
• Over nine years of Data migration experience between different platforms and databases
• Eleven Years of Data modeling experience using CASE tools ERWin and Designer 2000
• Eleven years of experience working with various Unix platforms
• Two years of experience in Alpha/VMS and VAX/VMS
• Excellent command of Web Development using Java, Java Script, HTML and Adobe Photo Shop
• Experience in working with Government projects such as Government of Yukon
• Conversion experience from character based forms to graphic user interface and Forms 4.5 to Forms 6i
• Extensive experience in cross-platform computer networking
• Strong international business experience and customer orientation
• Oracle Certified Professional
• Enhanced security Clearance # 9524 227052

PROFESSIONAL EXPERIENCE

Confidential, Alaska

Senior Oracle Financials Techno-Functional Consultant

Environment: Oracle Applications release 12 (12.1.3), Oracle Financial Modules such as GL, AP, AR, HRMS, Oracle Projects, Project Billing, Project Accounting and Project costing, Oracle Purchasing, Oracle Supply Chain modules such as Oracle Inventory and Oracle Enterprises Asset Management (EAM), data bases such as Oracle 11g and 10g, Oracle Application Framework (OAF), Oracle Forms 10g, Oracle Reports 10g, XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Windows XP and HP Unix

Responsibilities:

• Playing a key role in a senior techno-functional team for a project implementation and Support of Oracle Applications Release 12
• Resolved issues which are assigned through the tickets.
• Prepared Technical Documents using AIMS methodologies.
• Personalize Forms in Oracle Application Framework (OAF)
• Designed and Developed Reports using Oracle reports 11g and Bi Publisher.
• Designed and Developed Packages, Procedures and functions using PL/SQL, SQL, Oracle SQL Developer.
• Designed and Developed Complex Personalization for Oracle Purchase Requisition.
• Customized and Update of Oracle Project table using API.

Confidential

Senior Oracle Financials Techno-Functional Consultant

Environment: Oracle Applications release 12 (12.1.3), Oracle Financial Modules such as GL, AP, AR, HRMS, Oracle Projects, Project Billing, Project Accounting and Project costing data bases such as Oracle 11g and 10g, Oracle Forms 10g, Oracle Reports 10g, XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Windows XP and HP Unix

Responsibilities:

• Played a key role in a senior techno-functional team for a project implementation of Oracle Applications Release 12 upgrade from 11i
• Prepared Technical Documents using AIMS and OUM methodologies.
• Upgraded and Enhanced Check Printing.
• Created templates for Web ADI
• Designed and Developed Reports using Oracle reports 11g and Bi Publisher.
• Designed and Developed Packages, Procedures and functions using PL/SQL, SQL, Oracle SQL Developer.
• Designed and Developed Complex Personalization for AP Invoice.
• Customized and Update of Oracle Project table using API.
• Designed and Developed Complex POC Billing extension and Customized Billing Extension in Oracle Project Billing.

Confidential

Senior Oracle Financials Techno-Functional Consultant

Environment: Oracle Applications release 12 (12.1.3), Oracle Financial Modules such as GL, AP, AR, Fixed Assets, iExpense, Project Billing, Project Costing, Project Accounting, HRMS, data bases such as Oracle 11g and 10g, Oracle Forms 10g, Oracle Reports 10g, XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Windows XP and HP Unix

Responsibilities:

• Playing a key role in a functional team for a project implementation of Oracle Applications Release 12
• Prepared BR100 documents for Oracle General Ledger, Oracle Accounts Receivables, Oracle Accounts Payables, Oracle Cash Management, Oracle Fixed Assets and Oracle Purchasing
• Configuring COA
• Configuring multiple Business Groups, Operating Units and Legal Entities in Oracle HRMS to segregate Employees for each Business Group.
• Configuring modules such as Oracle General Ledger, Oracle Account Receivables, Oracle Account Payables, Oracle iExpense and Oracle Fixed Assets
• Implemented Oracle Approval Management Engine (AME).
• Setup Positions Hierarchy for the approval process in Purchasing.
• Setup Workflow for Employee/Supervisor to approve the Journals and expense reports
• Created templates for Web ADI
• Configured and Tested complete Bank Reconciliation
• Working with the team for Month-end process for AP and AR and then GL
• Designed and Developed Reports using Oracle reports 11g and Bi Publisher.
• Designed and Developed Packages, Procedures and functions using PL/SQL, SQL, Oracle SQL Developer.

Confidential

Senior Oracle Apps Technical Consultant

Environment: Oracle Applications release 11i (11.5.10.2), rel 12, Oracle Financial Modules such as GL, AP, AR, Project Accounting, Project Billing, Project Costing, data bases such as Oracle 11g and 10g, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle Business Intelligence Apps (OBIA), OBIA Modules such as Project Costing, Accounts Receivables, Accounts Payables, Human Resources, Oracle Forms 10g, 6i, Oracle Reports 10g, 6i, XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Windows XP and HP Unix

Responsibilities:

• Played a key role in a development team for a project implementation of Oracle Applications Release 11i and rel 12.
• Designed and Developed Repository for OBIEE.
• Modified/Sync, Added columns mapping with the database for OBIA.
• Customized OBIA HRMS Analytics, Financials Analytics and Supply Chain Analytics.
• Added columns in physical layer, Business Model and Presentation Layer.
• Designed and Developed Reports using Oracle reports 11g and Bi Publisher.
• Configured Projects, Tasks and Budgets.
• Designed and developed API s to import Projects, Tasks and Budgets.
• Designed and Developed Packages, Procedures and functions using PL/SQL, SQL, Oracle SQL Developer.

Confidential, IL

Senior Oracle Apps Technical Consultant

Environment: Oracle Applications release 12, 11i (11.5.10.2), Oracle Financial Modules such as GL, AP, AR, Project Billing, Project Accounting, Project Costing, Supply Chain Management Modules such as Oracle Inventory, Oracle Order Management, Oracle Purchasing, BOM, Oracle Transportation Manger (OTM), Oracle Process Manufacturing OPM, Warehouse Management System (WMS), data bases such as Oracle 11g, 10g and 9i, Oracle Business Intelligence Enterprise Edition 10g (OBIEE), Oracle Discoverer 9.04, Oracle Forms 10g, 6i, Oracle Reports 10g, 6i,, XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Windows XP and HP Unix

Responsibilities:

• Played a key role in a development team for a large project implementation of Oracle Applications Release 12.
• Sustained Already Implemented project in Oracle application 11i.
• Designed and developed Reports using XML / Bi Publisher.
• Designed and developed Conversions and interfaces such as Item Cost, Kanban Replenishment, fnd user and Stock Locators using PL/SQL, SQL and Oracle SQL Developer.
• Configured Projects, Tasks and Budgets.
• Designed and developed API s to import Projects, Tasks and Budgets.
• Designed and developed a custom form to print the Bar Code / Labels using Zebra Printers with WMS
• Designed architecture, designed/developed extensions, interfaces, customizations (CEMLIs)
• Mobile personalisation
• Customized wms pub API

Confidential

Senior Apps Technical Consultant

Environment: Oracle Application Development Framework (ADF), Oracle 11g, Windows XP

Responsibilities:

• Interviewed Business Users and Stake holders.
• Created Business Specific Documents, Technical Specific Documents, Technical Design Documents using ERwin 3.5.
• Designed ERDs, Logical and Physical Models.
• Worked as single point of contact for SARS application like SARS production support, User requests. Reassignments, implementing new enhancements in SARS, Deployment in Dev, Test & Stage.
• Design and developed user interface components usingADF Rich Faces.
• Design and developed multiple fragments using ADF Rich Faces, Facets and JSF.
• Developed UI fragments, templates and bounded task flows using Jdeveloper 11g.
• Developed ADF Model components (creation, configuration, and tuning of entity objects, view objects, application modules, bindings and data controls).

Confidential

Senior Apps Technical Consultant

Environment: Oracle Applications 11i (11.5.10.2), Oracle Financial Modules such as GL, AP, AR, Supply Chain Management Modules such as Oracle Inventory, Oracle Order Management, Oracle Purchasing, BOM, Oracle Transportation Manger (OTM), Oracle Process Manufacturing OPM, Advance Pricing, data bases such as Oracle 10g and 9i, Oracle Business Intelligence Enterprise Edition 10g (OBIEE), Oracle Discoverer 9.04, Oracle Forms 6i, Oracle Reports 6i,, XML/BI Publisher, Oracle PL/SQL, SQL, SQL *Plus, Oracle SQL Developer, Quest Software Toad, Windows XP and HP Unix

Responsibilities:

• Coordinated/managed Off-shore team in India.
• Designed and Coordinated with Functional Experts for Technical Overview Section in the Functional Specification Documents.
• Worked with the functional experts to evaluate and identify functional gaps between the application and business requirements and identify potential solutions.
• Reviewed Understanding Document prepared by off-shore team in India.
• Reviewed Technical Designs prepared by off-shore team in India
• Reviewed Codes written by off-shore team in India using Oracle Forms, Oracle Reports and PL/SQL.
• Designed and developed Reports using XML / Bi Publisher.
• Designed and Developed the PL/SQL Package for loading the data from OTM into AR interface tables and AP interface tables.
• Designed technical solutions to meet business and user requirements.
• Designed, developed and implemented business reports, Answers and dashboards using OBIEE 10.
• I was single point of contact for all the data warehouse issues.
• Designed and developed Routines to migrate data from legacy system to oracle EBS 11i database.
• Developed a separate Database with all RICE components which were developed by the offshore developers.
• Designed Physical, Business Model and Mapping and Presentation.
• Designed and developed a number of Reports for OTM, OPM and Planning using Discoverer 9.04 and more than 10 reports were complex and coded using SQL and PL/SQL.
• Designed and developed PL/SQL packages, procedures and functions to code the complexity of reports built in Oracle Discoverer.
• Troubleshoot and maintained existing base of applications in Production.
• Converted functional specifications into Technical design specifications by performing necessary analysis and design.
• Developed code and conducting unit testing of technical solutions.

Confidential

Senior Application Consultant

Environment: Oracle Applications 11i, 10.7, Oracle Financial Modules such as GL, AP, AR, Supply Chain Modules such as Inventory, Services, Order Management, Purchasing, BOM, Oracle 9i and 8x, Oracle Forms 6i, 4.5, Oracle Reports 6i, 2.5, XML/BI Publisher, Seible Analytics, Oracle PL/SQL, SQL, SQL *Plus, ERWin, Windows NT, HP Unix, Quest Software Toad

Responsibilities:

• Played a key role in the development of a customized module such as Omni Vision. Omni vision is a customized application for tracking integrated with Oracle modules (such as GL, Service, Inventory, Order Entry and Bills of Material)
• Interviewed client to gather specific functional requirements.
• Prepared Design documents using Erwin.
• Prepared Technical Document.
• Customized codes in the oracle application modules such as Oracle Inventory, Bills of Material and Oracle Service.
• Registered Customized Forms, Concurrent Programs such as PL/SQL Codes and Host script to Automate batch processes.
• Designed and developed business reports using Seible Analytics
• Designed Metadata including Physical Layer, Business Model and Mapping layer and Presentation Layer.
• Created Reports using Dashboards, Answers and Oracle BI Publisher.
• Created and modified Descriptive Flex Field to suite the functional requirements.

Confidential

Senior Analyst

Environment: Oracle 9x and 8x, Oracle Forms 9i, 6i, Oracle Reports 9i, 6i, C# .NET, Oracle PL/SQL, SQL, SQL *Plus, ERWin, Windows NT, Unix Solaris 10, HP Unix, Confidential AIX, Oracle Enterprise Manager Console (OMS), SQL DBA Enterprise Manager, DB Artison, Quest Software Toad

Responsibilities:

• Played a key role as a team member development and support of a Number of Health care Applications databases as backend on Oracle, Sybase and Sql Server.
• Developed database source such as Packages, stored procedures, functions and triggers using PL / SQL and Toad.
• Performed code tuning and query optimizations for the application.
• Performed on-call duties on rotation basis.

Confidential

Senior Consultant

Environment: Oracle 9i, 8i, Oracle Apps. 11i, Oracle GL, Oracle AP, Oracle Forms 6i, Oracle Reports 6i, Oracle PL/SQL, SQL, SQL *Plus 8, ERWin, UNIX Solaris, Windows NT, Quest Software Toad, SQL Programmer, and TCP/IP

Responsibilities:

• Played a key role in development and conversion of customized software COLIS (Commercial Lines Insurance System) and ISYCL (International System of Commercial Lines) and integrated with Oracle Apps 11i modules such as Oracle GL and Oracle AP.
• Managed various day-to-day activities of insurance and reinsurance business. Working with Business Analysts and end-users to analyze reported problems Coordinated with .NET developers to streamline front-end and back-end integration
• Performed code tuning and query optimizations for the application
• Analyzed and Rectified problems reported from the production system
• Migrated data from the Legacy system using Oracle utility SQL*Loader
• Developed Unix shell scripts (using korn, bourne and shell)
• Designed and Developed Input forms and output reports using Oracle Tools such as Forms 6i and Reports 6i
• Developed database objects such as Packages, stored procedures, functions and triggers using PL / SQL, SQL Programmer and Toad.
• Designed Physical and logical databases using ERWin. Designed Entity Relationship Diagrams, Physical and logical models and populated data dictionary
• Prepared business and technical documentation.

Confidential

Application Consultant

Environment: Oracle 9i, Oracle Apps 11i (11.5.4), Oracle GL, AIX, Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer, PL/SQL, SQL, SQL *Plus 8, Windows NT, Quest Software Toad and TCP/IP

Responsibilities:

• Played key role in the development of additional modules such as Store Financial Application (SFA), Financial Inventory System (FIS).
• Integrated functions with Oracle application 11i modules such and Oracle GL.
• Developed procedures, functions and triggers using PL / SQL, Procedure Builder and Toad.
• Prepared technical documentation.

Confidential

Programmer / Analyst

Environment: Oracle 8.1.7, PL/SQL, SQL, SQL *Plus 8, Designer 6, Oracle Forms 6, Oracle Reports 6, Windows 2000/XP, TCP/IP

Responsibilities:

• Played a key role in the development and maintenance of application systems and databases of Department of Health & Social Services, Yukon Territorial Government. Developed complex queries to meet client search criteria. Designed and developed stored procedures, functions and triggers. Employed CASE tools such as Designer 2000 for data modeling.
• As a team member designed and developed an application “Young Offenders Information System” for Government of Yukon.
• Designed and developed customized forms 6 and reports 6 for client/server environment.

Confidential

Programmer Analyst

Environment: Oracle 8.1.6 and 7.3, Oracle Application Server, Java, HTML, PL/SQL, Designer 6i, ERwin3.0, DBA Studio, Oracle Forms 6i, Oracle Reports 6i, SQL *Plus 8. SQL *Loader, VMS, Windows NT/2000, TCP/IP

Responsibilities:

• Played a key role in the development and maintenance of application systems and databases of medical personnel and facilities. Developed complex queries to meet client search criteria. Designed and developed stored procedures and triggers. Employed CASE tools such as Designer 2000 6i, ERWin for data modeling.
• Converted from Oracle Forms 4.5 to Oracle Forms 6i
• Designed, developed and implemented customized forms and reports for client/server environment satisfying user requirements. Designed and developed forms and Logical and Physical Data Models using ERWin. Designed reports for Intranet and Internet sites for publishing company policies and business procedures and rules using Oracle Forms 6I, Reports 6i JavaScript and HTML. Configured web server software and authorized web pages for publishing. Installed and Configured Oracle Form Server. Hands-on experience in three-tier systems architecture.
• Performed product design, development, support and training. Prepared technical documentation.
• Migrated data from ingres to oracle 8i.
• Developed various scripts in UNIX/Windows NT for hot/cold backup.

Confidential

Software Engineer/Team Leader

Environment: Oracle 8x, Java, Java Script, HTML, PL/SQL, ERwin3.0, Oracle Forms 6.0, Oracle Reports 6.0, SQL *Plus 8

Responsibilities:

• Interviewed clients for all the business requirements. Prepared Business Specification Document (BSD).
• Designed logical and physical databases. Prepared Entity Relationship Diagrams (ERD), Logical and Physical Data Models using ERWin and Designer 2000.
• Led a team of 5 Developers, 3 Junior Programmers and 2 Trainees. Analyzed, designed, developed and implemented, Billing Information System for leisure club with more than ten branches.
• Migrated all the data from flat files to Oracle Tables using SQL *Loader.
• Analyzed, designed, developed and implemented a Management Information System. The software was designed for a food services corporation. The applications included modules such as Inventory, Sales, Product Costing, Accounts Receivable, Accounts Payable and General Ledger.

Confidential

Sr. Programmer/Analyst

Environment: Oracle 6, 7, 8.05, SQL *Plus 3.2, SQL DBA, PL/SQL, SQL *Plus, Erwin3.0, Developer2000 (Forms 4.5, 5, Reports 2.5, 3, Graphics 2.5), Oracle Discoverer, SQL *Forms 3.0, SQL *Report

Responsibilities:

• Assessed clients for all the business requirements. Prepared Business Specification Document (BSD).
• Designed logical and physical databases. Prepared Entity Relationship Diagrams (ERD), Logical and Physical Data Models using ERWin.
• Led a team of 4 Developers. Analyzed, designed, developed and implemented customized software, Human Resources and Payroll System (HRPRS) for a large security replenishment company. Developed input forms using Forms, Reports using Reports and Discoverer.
• Led a team of 3 Developers. Analyzed, designed, developed and implemented an Inventory and Sales System (ISS) for a leading import and distribution company. The application was divided into modules (such as Imports, Sales, Inventory and Bank Reconciliation).
• Led a team of 3 Developers Analyzed, designed, developed and implemented Sales and Bank System (SBS) for a printing corporation having more than ten different companies and also involving Digital Designing and Composing, Film Making, Plate Making, Production of Printing and Binding. This software was previously designed for Forms 3.0 and SQL *Reports with Oracle 6 as database. Converted the application from character based Forms and Reports to GUI Forms 4.5 and Reports 2.5 and migrated the database from Oracle 6 to Oracle 7.