Seeking a Oracle Applications Implementations and Upgrades - Techno-Functional Consultant / Architect / Technical Lead positionin a growing company where I can use my extensive technical, functional and administration knowledge & project Management skills for Oracle 11i / 12 implementations, Upgrades, Customizations, Extensions, Interfaces and support

EXPERIENCE SUMMARY:

• Masters Degree in Computer Science.
• 17 years experience as an IT consultant
• 15+ years experience with Oracle Applications / E-Business Suite - Performing technical, functional, administration and project management work.
• Proven background in developing interfaces, customizations, reconciliation scripts using PL/SQL, Oracle API’s and Open Interfaces where available and the ability to create Custom API’s where required.
• Hands-on experience with PL/SQL, UNIX, Oracle Forms/Reports, Discoverer development and Administration, BI Publisher, Workflow builder, Open Interfaces, API’s and performance tuning.
• Very strong in Customization and Integration of third party systems with Oracle Applications. Proven knowledge in Data Migration Strategy.
• Extensive experience with System Administration functions, Setups in GL, AP, AR, PO, Workflow Administration,
• 14+ years techno-functional experience with General Ledger, Oracle Projects, Oracle Purchasing, Accounts Payables, Receivables, Fixed Assets, Order Management and Inventory modules
• 3+ years implementation experience with HRMS, Contracts, Self Service ,Incentive Compensation, I-Expenses
• 2+ Years experience with iPayments, iSupplier Portal, iProcurement and Cash Management modules
• Good techno-functional knowledge in Procure-to-Pay and Order-to-Cash cycles
• Extensive experience and knowledge on Data models and table structures of all modules
• Worked on Numerous Interfaces: Customer, Auto Invoice, Order Import, AP Invoice Import & PO Vendor Import, Journal Import, Revenue Interfacing, BAI Import, HR Employee Data from SAP e.t.c
• Hands on experience in customizing and maintaining workflows. Knowledge with AME functionality, Business Events, building new workflows.
• Lot of experience with Production Support activities, working with Oracle On Demand, Instance management, TAR management, Bouncing servers, instance monitoring, planning and resolving support tickets
• Superior communication, organizational, and interpersonal skills.
• Extensive experience using Oracle AIM Methodology to produce Technical/Functional Specifications, Test Plans and Release Documentation as well as reviewing and generating Functional Specification and Setup documentation
• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion.
• Additional skills include Requirement Gathering, Bug Fixing, release code, Technical Lead experience, generating Project Standards as well as some Project Management experience.
• Experience with Project Delivery and Client Management, Technical Leadership, Strategies, Solutions Architecture, Presentations, Training, Workshops
• Worked for Many reputed companies in the Financial Implementation projects. The clients include Comcast, Travelport Inc., at&t, Merrill Lynch, IDT, Oracle Corporation, Unison, Yamaha e.t.c

Technical (technical lead, developer, etc.) activities : interfacing with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, leading developers, scheduling, producing documentation.
Functional responsibilities: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.

• Oracle E-Business Suite (EBS) / Applications: R12, 11i, R11, R10.7, R10.6 (15 yrs)
• Modules: GL, AP, AR ( 15 yrs ), PA, FA, PO ( 8 yrs ), OM, HRMS, INV, TCA ( 3 yrs), IC, I-proc, I-exp, I-supplier ( 2 yrs)
• Oracle: 10g, 9i, 8i, 8, 7.x, SQL, PL/SQL (17 yrs)
• Oracle Tools: SQL*Plus, SQL*Loader, PL/SQL, PRO*C 2.1/ 2.0 /OCI, TOAD, SQL*Navigator, Developer 2000 (Forms 6i/4.5/3.0, Reports 6i/2.5) , Discoverer 6i/10g, Discoverer Administration
• Other Components : Oracle BI Publisher, XML Publisher, Workflow Builder 2.6.3, OA Framework, BPEL / SOA, Application Object Library (AOL/FND), Concurrent Manager (CM), Flexfields
• MS-Office, Rollstream, IWM, IPM / COFAX, Ironside Power Works
• Job Schedulers: Control – M, Maestro
• Source Code Control: Sablime, Clear Case, PVCS, Remedy, Altris
• IBM Optim, Mercury Quality Center ( QTP )
• UNIX (SVR4.2, HP-UX, SUN Solaris), Korn/C/Bourne UNIX shell scripts, LINUX
• Windows 95/NT/98/2000/XP, Languages: C/C++, Java, Pascal/Basic/COBOL
• Hardware: SUN Ultra Enterprise Series Servers E10000/6000/4500, HP 9000 / E55, DELL Servers

Master's Degree in Computer Applications
Bachelor's Degree in Science

• R12.X Implement Oracle Workflow by Oracle University
• Course on BPEL and SOA by Oracle University
• Functional Foundation of Oracle Application Rel 11 from Oracle Education
• In house training in Oracle Workflow Apps Rel 10.7 and Oracle Web Server 3.0
• In house training in Oracle GL, AP, PO, AOL and Sys-admin
• In house training on 10SC Coding Standards and User interface Standards.
• Developer 2000 and Designer 2000 from Oracle Education, India
• Ironside Powered Certification / Quality Center by Mercury
• Optim for data management by IBM
• Project Management

PROFESSIONAL EXPERIENCE:

Oracle EBS Consultant, Confidential, NY Aug, 2011 – Present

Working as Lead Consultant in the R12 Implementation project for GILT Groupe, NY. This is a fresh implementation.

Involved in the following activities.

• Setups for GL, AP and CE modules
• Requirement gathering for Vendor Interface, Payables open invoice import, Banks import, journal import and Exchange Rates import
• Functional and Technical documentation for all the above interfaces
• Development of interface programs for vendor interface, Open invoice import, journal import, BAI Import using oracle standard interfaces
• Development of Banks import using Oracle API’s. Updating Supplier information using Oracle API’s.
• FTP scripts to move data between different servers using SFTP and encryption
• Creation of custom views required by Gilt enterprise applications to access data from Oracle EBS
• Coordinating with different business units on the file structures required, moving mechanism between servers

Worked as Lead Analyst in the corp systems department responsible for designing new interfaces, workflows, reports, Production support. Designed and worked on the following items.

• Employee interface: SAP HRMS à Shared Oracle HRMS . Employee creation / updation, termination / APPS user and assigning responsibilities and roles.
• Invoice interface: GXS / IWM system (External) à Oracle Payables, IPM / COFAX (Internal) ß Oracle Payables.
• Supplier / Bank interface: GXS / Rollstream (External) à Oracle PO / AP. Suppliers, Sites, Contacts, Bank Branches, Bank Accounts, Index file creation in IPM, Outbound file generation to GXS.
• Revenue Interface: External billing systems à GL module.
• GL Accrual Entry Transfer between Accrual and Cable books.
• Pre-Notes generation process to the banks for verification
• Payment file Generation based on the payment batch and send to the bank which will be processed by wellsfargo payment manager.
• IExpense implementation / Support. IProcurement Implementation
• Involved in System Administration, Performance tuning, Production support, Workflow Administration. Created Oracle EPM / BI Publisher reports. Customized Invoice workflow process, requisition workflow process. Monitoring synchronization with directory services, workflow background process. Forms Personalization
• Modifications of Supplier, Bank, Invoice interfaces to be compatible with Rel 12

Worked as a Techno-Functional Analyst / Project Lead in the Production Support team with focus on Functional & DBA Activities as well. Mainly responsible for Gap analysis, requirement gathering, Design and Development of interfaces, reports, data extraction scripts, Upgrade from 10.7 to Rel 11.5, Integration between Travelport & WorldSpan systems, User training / Support. Also involved in activities related to Data base administration, Instance Management, TAR Management, Raising SR’s with OOD, Production support. In this project I coordinated activities between teams in UK, Japan and US (Atlanta & NJ). Also responsible for managing the Discoverer reports as required by the user community and administration of Discoverer

Major Activities:

• Create extensions using Oracle recommended frameworks. Report against Applications data model.
• Write technical design documents for conversions, extensions, interfaces, and reports.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.
• Excellent knowledge on Setups related to customers, vendors, payments, orders, transactions, ledgers, projects, billing and iexpenses.
• Developed numerous Discoverer Reports for the Orbitz Business Unit, Travelport & Galileo Business Units in AP, GL Modules. Improved the performance of lot of existing Discoverer reports by tuning the SQL, using Hints e.t.c
• Designed and Developed multiple interfaces for the Business to manage data that come across different systems. Given below are the interfaces worked. All these are developed using PL/SQL and UNIX

Customer / Vendor Interface: Designed and Developed a single interface to create customers as well as vendors from the single data file. This is very complex interface which has lot of business logic before calling the standard interfaces provided by Oracle. This interface runs daily and create the required customers / vendors
Billing Interface: An interface is developed to load the daily transaction data that comes from external system into Oracle Financials. This interface is used by all external systems throughout the world to load data into Financials
Invoice Interface: Developed 3 invoice interfaces which take data from external systems and use the Auto Invoice interface to push the data into Oracle Financials
Procurement Card Interface: Designed and Developed an Interface for the Procurement Card Module under AP. This interface received monthly file in KR-1022 format from American Express, validate and load data into Procurement Card system in Oracle. Developed reports to get the Transaction History. Trained the users on the functionality of PCARD system.
FA Netting / Journal Accrual: Designed and developed interfaces for FA Netting process as well as FA Journal Accrual Process.
Order Import: Created Order Import Interface to import sales order information that is being captured by external systems.

• As a project lead, coordinated and worked in LE Merge projects to merge the legal entireties of different business units and all the related transaction data. Worked on the Project to migrate all the transaction data related to WorldSpan business unit in to the current Travelport Oracle Financial System. Developed lot of UNIX Shell Scripts to move data files between different internal systems as well as push data files to the vendors and customers. Also to automate jobs using CRON. Developed scripts and assisted the Conversion team to convert data from 10.7 to 11i and in the Set of Books separation Project. Developed Discoverer reports as well as Invoice Interface for Ebookers. Modified lot of Shell scripts which runs different interfaces as part of RAC implementation. Developed scripts to load / convert contract information from external system to Oracle Contracts module.
• Used IBM Optim tool to downsize development and test instances by archiving and removing old data.
• Used Oracle API’s in supplier updates, Oracle Pricing, Oracle HRMS, Oracle Receivables.
• Developed programs to convert price list and qualifier information.
• Defined DFF’s and captured pricing attribute information.
• Created data feeds using PL/SQL for the COGNOS reporting tool
• Involved in the implementation of HRMS, Incentive Compensation, Procurement and Contracts modules. Worked on data feeds from these systems to outside vendors that involves extraction processes as well as automation scripts.
• Developed scripts to reconcile data between FCH and GCS (GL) modules as part of FCH Implementation. Has good knowledge on all the data models in FCH Module.
• Performed DBA activities like bouncing Apache servers, resolving conflicts and dead lock situations in RAC enabled environment. Worked closely with Oracle On Demand to resolve any issues the users face while maintaining the Production Instance. Created and actioned numerous Service Requests, TAR’s with OOD. Maintained different instances, patch maintenance e.t.c
• Customized PO forms using custom.pll to control access based on different responsibilities. Modified Oracle Reports to make changes in XML templates.

Modified / Customized the following workflow

• Journal Approval Workflow to include new approval levels based on custom tables
• Fixed Asset Account Generator to include account derivations based on certain rules
• PO Approval Workflow to include checks for terms and conditions, to get the 1st approver information based on descriptive flex field and then follow the approval path.
• Involved in many day to day activities to maintain the fixing the problems with the Instances.
• Personalized Contracts forms using OA Framework to remove some buttons.
• Used BI Publisher and BI Discoverer to convert some existing discover reports and templates for more data presentation using charts for comparison.
• In-depth knowledge of performance tuning in PL/SQL using Hints and indexes.
• Created Orders on Credit Check Hold Report / Outstanding Holds Report to include additional columns regarding the customer based on the business requirements. These reports are created using Discoverer.

• Worked with ADBA Tech Team. Mainly responsible for all the activities related to Data base administration, Instance Management, TAR Management, Emergency Bug Fixes, Production support activities e.t.c. Day to day activities include supporting the production databases of Domestic as well as International. Has done lot of performance tuning in different applications.
• Also re-designed and modified all the code related to PA Archive / Purge process from 10.7 to 11.5.9. Tested the code on test platforms. Working on the Slim Down Instance process. Used the code to Purge data.
• Actively involved in the GACCR Upgrade project from 10.7 to 11.5.10. This includes writing migration scripts, setting up the test environments, modifying the custom code, running the scripts on the test instances, verifying the data, migrating the feeders and interfaces e.t.c. This project is mainly to migrate the Domestic general ledger to 11i.

Worked in the Confidential as a team member, responsible for the following activities:

• Involved in the extraction, conversion and reconciliation of Accounts Payables and Fixed Assets modules.
• Developed scripts to extract data from the 10.7 system. Wrote scripts to extract data for Invoices, vendors, Payments and Checks. These data files are used to load the data into the 11i system. Developed scripts to load this data into staging tables and then to the Oracle Interface tables for Payables Open Interface. Designed and Developed scripts to load the data from the extraction files into the 11i system for Vendors & Payments. Did all the required set-ups before doing the conversion on the 11i platform. Did the reconciliation of the data that was loaded using some custom developed scripts and by running the Standard Oracle Reports such as Payables Accounting Process.
• Developed scripts to extract Invoice Data & PO Data which will be loaded into the Ariba System.
• Involved in the testing of all the conversion scripts on UAT, Systems Test and Conversion platforms.
• Helped in developing scripts for the FA Module. Developed extraction & conversion scripts to convert assets related to the CORPORATE, FEDERAL, STATE, ACE, AMT Books. Also developed scripts to convert CIP Assets. This includes capturing information from the PA Modules also.
• Successfully converted and validated all the invoice, payment, check, vendor and Assets related information on the 11i platform.
• Involved in the day-to-day processing of the data feeds for the AP Module in the current 10.7 environment.

Senior Oracle Applications Analyst , Confidential, Newark, New Jersey Mar, 2005 – Jun, 2005

Worked in the MIS Group of IDT Corporation. As a team member, responsible for the following activities:

• Worked in the Conversion of SVP, ILD & PPS Customers into Oracle Financials AR Module. The customers from the other systems are migrated to Oracle Financials using the Customers interface. This involves lot of validations and finally getting the data into the platform
• Developed a Transaction Audit Process, which gives report of all the transactions, which will come to Order Management module and eventually to the AR Module. This involves identifying the transaction based on the CLID Ranges at the Warehouse, then match the transactions with the DTL Platform, match them with the Order Management staging & Order Management modules and finally matching them with AR Module. This includes lot of validations as well as getting data at every stage. This report helps IDT Financial team to see the revenue generated in the given period, revenue billed and any missed transactions e.t.c. This helps the team in billing the customers properly.
• Developed reports using Discoverer. Reports development includes Summary, Details of Errors, Details of Processed transactions.
• Worked in the Order Import & Auto Invoice Interfaces to load orders which are coming from Different Source Systems. This involves Validation, loading into interface tables as well as running the import process.
• Done some work on PO Approval & PO Requisition Account Generator workflows. This involves Setups as well as modifying the PL/SQL Code for the workflow process.
• Involved in the performance improvements for the Order Import Process. This process has 9 steps, which includes the Order Import Process. The Order Import process was taking 4 hours to process around 3000 transactions per day. The performance was improved to complete the job in 1 hour.
• Developed Check File generation process & Check file Reset Process. This process creates a CSV file based on the checks process in a particular period and based on type like CHECK, EFT e.t.c. Also gives the user to reset the check back to ‘VOIDED’ .

Worked in the AT&T’s International / Domestic Development team.

Job responsibilities include implementation of Oracle Financials Rel 11i ( 11.5.4, 11.5.9 ), Converting the existing data from 10.7 systems to a consolidated 11i system, Development and Support for the Current Oracle Financials 10.7(Domestic), 11i (international) environments. Cleaning up the database by doing purge based on certain criteria. Performance Tuning, Production support, TAR management, Patch management, Instance management and Development work related to the Domestic Platform. Developed numerous Custom reports related to the solutions and domestic general ledger modules. Supporting International platforms for GL, AP, AR, PO & PA Modules. Design and development of common Revenue, Customer Feeds for the International platforms like Europe, Japan, Latin America & Asia Pacific. These feeds give all the revenue related transactions for any particular period both in functional as well as local currencies. Also it gives all the customer related data associated with the revenue transactions. Developed a Mechanized Code Replacement System for International Division for all the above-mentioned regions. Most recent assignment was to migrate the massive Domestic Financial system of AT&T from 10.7 to 11i. Involved in the Design, Coding, Testing and Modifications of all the customizations related to PA, AR & AP Modules to migrate the data from 10.7 to 11i.
Mainly responsible for all 11i development and administration activities in GL, AP, PA, AR, FA and PO modules. As part of the requirements of the audit by Price Waterhouse Coopers, for the Sarbane-Oxley Legislation, developed financial statement reports for Domestic business. Worked on Consolidating 3 11i platforms, which contain more than 100 books into a single 11i instance. Mainly involved in GL, AR & AP Modules. Also working on devaluation of Turkey Currency project.

Major activities performed are

• Designed and Developed Purge Process system for Oracle Projects Module. This system is based on the Oracle Financials purge Process, but customized a lot to incorporate the changes required by the PA process controllers. The purge code available in 10.7 Patch set K has been taken, Customized a lot to include the custom tables and to change the criteria based on the requirements and ported back to 10.7 Patch set G. The purge process was executed successfully many times in Production and cleaned up a lot of data and transactions, which are no longer, required. This process will be run once every year. Also this process was used to slim down the instance to prepare for the upgrade from 10.7 to 11i.
• Designed and developed Conversion scripts to convert data from 10.7 to 11i systems for AR Module. For the Customer related data, Scripts were developed to use the standard Customer Interface program and includes converting Customers, Addresses, Sites, Contacts, Phones,Profiles, Profile Amounts e.t.c. For the transaction data and other tables, scripts were developed to convert data from 10.7 to 11i. About 30 tables were mapped.
• Designed and developed conversion / migration scripts to convert data from 10.7 to 11i system for PA module. This is the biggest module, which has about 54 tables. Also PO/GL/AP modules including code combinations tables were mapped. In Purchasing, OPEN PO Documents, PO Requisition Import interfaces were used to migrate the Open PO’s, Requisition data.
• These scripts were used to convert around 100 Set of Books into 3 consolidated single instances at AT&T. (That is one instance for each region. Eg: one for Asia Pasific which has around 40 books, one for Europe which has around 38 books and one for Latin America). Have excellent knowledge of the data models, new tables, and relationships between tables in all the above-mentioned modules. Has very good understanding of the new Customer table model, which was completely redesigned for AR.
• Extensively used the Customer Interface, Open PO Documents interface, Journal Import Interface e.t.c. Worked on AP Invoice Import & PO Vendor Import interfaces to load vendors as well as Invoices from legacy systems while converting to 11i. Modified lot of Customizations to migrate the data from 10.7 to 11i in PA, AP & AR Modules. Coded & Modified lot of reports related to the PA module.
• Customized workflow processes such as Journal Approval Workflow, PO Approval workflow and AR Inter Company accounting workflow. Good knowledge of the workflow process and workflow builder.
• Apart from the above activities, prepared technical design documents and gave seminars on the new data base changes for PA / AR modules. Developed reports for supporting the Solutions division with Domestic GL. Activity included, development of custom reports for the International regions as well as modifying the standard Oracle reports such as Journals – General Report, Account Analysis report.
• Has good knowledge at the data base level on all modules in 11i. Actively involved in all the balances in GL, AR, FA & AP modules, which will devaluate according to the Currency devaluation required for the Turkey currency. Consolidating 3 11i instances into a single instance. This involves consolidating all the books from Europe, Asia Pacific, Canada & Latin America into a single 11i platform.
• Working on DBA activities related to the domestic platform regarding performance improvements, working on TAR’s to fix the bugs in FA module.

Worked as Senior software consultant for MarchFIRST, USA on an integration project between Ironside Powered Works and Oracle Financials for YAMAHA Corporation, California. This project involves writing PL/SQL scripts to capture data from Order Entry, Receivables and Inventory modules. Mainly involved in identifying the data requirements by YAMAHA Corp & Ironside Power Works, identifying the tables involved in Oracle Financials, Creating tables to store the information and writing stored procedures to capture the data.

Ironside Powered works is a B2B buyer's side package, which is created using JAVA. This package needs information from the Oracle Financials based on the online user's requirements so that the users are able to view the orders, inventory, availability, and status of orders, Invoice information e.t.c. Through Internet. The information will be passed to our Stored Procedures and this procedures intern retrieve the data from order entry, inventory and Oracle Receivables modules based on the parameters and stores them in tables. This project helps me in clearly understanding the functionality of Order Entry, Receivables and Inventory modules.

Oracle Applications Developer, Confidential, New Jersey Apr,1998 – May,2000

• As a member of OCOE (Oracle Center of Excellence – AT&T’s division having expertise in Design and Development of modules having cross cluster impact and providing support for the entire suite of Oracle Financials) Team, Involved in the following activities:
• Implementations of Oracle Applications, integration among development teams (clusters like FA, PA, AP, PO, AR), developing and supporting new customizations & extensions and also project Management. Integrating the Custom Modules with Oracle Financials Modules e.t.c. Support to the Super Cluster Production System, International Production Systems.
• Developed a good understanding of the AT&T’s accounting system, architecture and structure of Super-Cluster Oracle implementation. Developed and Supported core AT&T’s modules like FCE Caller, SWEEP, CCPR, CIF, Collector etc, Developed good understanding of Sablime (Source Code Control System) and Release Management processes, Month-end & Year-end Book-Close issues, FRL processes and Inter-cluster dependencies.
• In this project, I was extensively involved in GL and FA modules. Activities include validating the segments from the custom tables and load the data in to Oracle Application tables, validating and creating new code combinations with the help of batch processes using the segment data, Converting and integrating third party systems with Oracle Assets module of Oracle Applications, Performance improvement for the Mass Additions and Depreciation processes.
• Actively involved in the performance tuning of several programs, did a lot of advanced PL/SQL & Pro*C programming like using DBMS Pipes, Dynamic PL/SQL cursors, Integrating PL/SQL & Pro*C programs.

Other responsibilities/activities include:

• Implementation and support of Standard Oracle Applications i.e. GL, FA and AP. Also involved in the System administration, performance tuning and patch maintenance.
• As part of AT&T Security Policy, developed a routine to encrypt/decrypt system passwords (apps, ar,gl). This routine was developed using C programming, and was standardized and used to retrieve the required passwords by processes across all the modules for all AT&T Oracle Financial Implementations.
• Design and development of AT&T’s custom modules CCPR, Sweep, Collector, FCE Caller and CIF (Common Interface Framework) .
• Worked with Oracle Assets core development team for the new setups and the changes in requirements coming in for existing Set-ups in Oracle Assets, Responsibilities include Integrating other systems with Oracle Assets, Writing scripts for the performance improvement, testing patches provided by Oracle, Writing scripts for the purging of Assets tables periodically, Correcting Invalid Code Combinations before running Mass Additions, Depreciation e.t.c.
• Involved in the design and development of a Closed Code Projection Reports, which identifies the combinations, which are going to be replaced in the next month, and the combinations in other cluster tables, which are going to be affected by them. Involved in the performance improvements and modifications required for the SWEEP process which creates new combinations at the end of each month.
• Involved in the Development and maintenance of FCE Caller Programs, which validate the combinations before creating them. Validate and end date the combinations periodically. This module is to maintain accounting segments and the key flexfield setups and code combinations.
• Involved in the Maintenance of CIF module, which runs all the Oracle Interfaces from one place. This is common module from which we can run all the standard Oracle interfaces. Using this module we can change, validate the data, which will be going to the final Oracle Applications tables. Responsibility included development of numerous Forms for Set-Ups.
• Supported Production system throughout the assignment and monitored the production activities as and when required.

As a Software Consultant, was involved in the front-end migration and Integration of GEMMS with Oracle Financials for the process manufacturing applications group of Oracle Corporation. The project involved migrating Oracle GEMMS from JAM/JPL and C platforms to Developer/2000 GUI environment, complying to Oracle Applications 10SC and AOL standards. JAM/JPL forms were migrated to Forms 4.5. The existing GEMMS reports developed in JYACC ReportWriter were redesigned using Reports 2.5. The C calls of GEMMS are migrated to dynamically linked libraries and accessed by Developer/2000 forms through ORA-FFI calls.

Involved in the following Activities in the Migration Side :

• Technical analysis of IC/SY forms,
• Development / Conversion of forms in System Module from JAM / JPL to Forms 4.5
• Development of Reports in System Module using reports 2.5
• Unit testing of forms developed as per AOL 10SC coding standards
• Bug fixing in GEMMS 4.1/3.2 . Re-synch of 5.0 in the System and Inventory modules

As a Senior Software Engineer, was involved in the integration of Maestro and Oracle Concurrent Manager (MCMAGENT). The project involved providing a software layer between Maestro and OCM. Software features include: Launch a job, monitor the status of a job, checking for file dependencies at O/S level and in OCM, terminating a job, parameter validation before submission, dynamic setting of environment, handling of report sets, controlling Oracle Concurrent Manager from Maestro (OCM control), presenting the data required by Maestro from Oracle Apps tables (GUI), handling multiple instances, etc. Was responsible for the following activities:

• Performed analysis, design, development, and testing.
• Participated in a feasibility study and system design.
• Participated in project discussions with the client.
• Developed the main program which controls the entire system using parent/child concepts of C and Unix. Participated in developing programs in C, Pro*C, and PL/SQL.
• Wrote installation scripts for the smooth installation of the system at the client site.
• Prepared test plans and participated in testing the entire interface with Oracle Concurrent Manager. Ported the software from HP-UX to Sun Solaris.
• Prepared a design document and integration strategy analysis document according to CAI standards ( AIM methodology ).

Confidential, India Mar, 1994 – Jul,1996

As a Systems Engineer, was involved in the development of an Integrated Bank Automation System (IBAS).