SUMMARY

• A distinguished information Technology Application Developer wif extensive experience in Project Management wif planning, Program Management and Project Engineering. Expertise in managing projects within information systems, Customer Service and Manufacturing environments. Solid background in directing programs to implement Enterprise Resource Planning (ERP) and web based applications. Proven ability to bridge technology and business goals as functional noledge to provide productive solutions. Demonstrated success leading and mentoring cross - functional teams in multi-facility environment in order to maximize levels of productivity. Experienced interfacing wif key business units including Marketing, Finance, operations, Human Resources, Manufacturing and Engineering in multi-cultural global arena. Excellent communicator, wif emphasis on building strong client relationships. Quick learner that rapidly adapts to emerging technologies, organized working habits wif a willingness to learn new concepts.
• Excellent experience spanning over 24 years, software design, development, data modeling, enhancing, maintaining Oracle Applications, customizing and full life cycle implementation of Oracle Financial Applications and experience in customizing Oracle Applications under SACWIS guidelines. Worked on Clients functional Requirements gathering, Setups, creating roles and responsibilities etc.
• Excellent noledge in Accounts. Technical & Functional (Setup) experience in Oracle Applications R12 &11i(General Ledger, Payables, Receivables, Purchase order, iProcurement, iSupplier,Inventory,BOM,WIP, ASCP, OM, HR, OTA, System Administration, Demantra, DLOG, Liason, Service Now, CVS. FlexDeployExperience in Apex 18.0/5.0/4.2/3.0,Oracle Developer suite 10g/6i experience. Worked on RICE((Reports, Interfaces, Conversions and Enhancements / Extensions) Components.
• Designed, developed ER Diagrams and FHD, generated, and customized various Oracle Forms & Reports using Oracle Designer 6i and Oracle Developer 6i. Designing, developing, testing, Data conversion and technical implementation and customization of various Application packages.
• Functional Experience: Design flexfield structures, segments, value sets, Key, Descriptive flexfields. Define Flexfield Segment values, Cross Validation Rules, Segment Qualifiers and implement Account Flexfield. Define Periods. Calendars, Open and close periods.
• Excellent technical, analytical abilities. Problem solving skills identify root cause, strong oral and written communications skills, analytical and interpersonal skills. working noledge in .net development.
• Industries worked (Government Agency, ERP Consulting, Manufacturing, Retail etc) and Consultant to IBM Global Services, BMC.
• Excellent experience spanning over 24 years includes software design, development, data modeling, enhancing, maintaining Oracle Applications, customizing and full life cycle implementation of Oracle Financial Applications and experience in customizing Oracle Applications under SACWIS guidelines.
• Experience in Oracle VM5.3.8 Virtual Box installation and deployment of Oracle ERP R12 applications. Oracle Linux 5.7 on VM wif Oracle ebusiness suite R12.2.3, R12.2.0, Oracle Cloud 12.1.3, OAF Oracle application frame work. Experience wif R12.2.6
• Excellent noledge in Accounts. Technical & Functional (Setup) experience in Oracle Applications R12R &11i(General Ledger, Payables, Receivables, Purchase order, iProcurement, iSupplier,Inventory, Order Entry, HR, OTA, System Administration. Knowledge SOA, SOA BPL. Knowledge & experience in Metalink support.
• Experienced setting a computer from barebone to installing Processor, Hard disk, upgrading memory, Bios upgrade, diagnostics testing and configuration.
• Experience in SQL Server installation, Oracle APPS installation, database administration & system administration.
• Knowledge in Amazon web services (AWS) and Amazon Cloud Services.
• Knowledge in Azure cloud services.
• Knowledge in MS Power BI and noledge of Oracle Cloud Integration.

TECHNICAL SKILLS

Database: ORACLE 12C/11g/10g, 9i/ 8i / 8.X / 7.X / 6.X, MS-Access, SQLServer 6.5/7.0,Foxpro/(5 yrs) 2.0/1.0, Visual FoxPro 6.0/2.X, dBase III+,MS SQL Server 2012.

Database Tools: Oracle Forms 10g/6i/6/4.5/4.0/3.0/2.3, Oracle Reports 6i/6/2.5/1.1, Oracle Designer 6i/ 6 / 2.1, Oracle Discoverer 10g/4i/3i/3.1/3.0

Other Tools: Clipper 5.2/5.0/87, Toad 9.X, SQL*Navigator, JDBC, ODBC, ERWIN,Brio 4.0, Noetix Views, SQL*Developer 2.1.1

Languages: C,Java 2.0, JSP, XML, PL/SQL, Pro*C, C Shell, K Shell programming,Perl, Straberry perl

Web Tools: HTML 4.0, Java Script 2.0, Jdeveloper 9i, WebDB 2.1, Web PL/SQL, Eclipse, APEX 5.0/4.2/3.0 Splunk, autosys.

Operating Systems: Oracle Linux 5.7, UNIX (HP-UX, AIX 4.X / Motif, Solaris 8.X), LINUX, Windows 7, Windows NT, Windows 2000, Novell LAN, Dos 6.X

Application/Web Server: Apache/9ias/4.0.8.1/4.0.7.1/3.0

Hardware: HP-9000, RS6000, Sun servers, IBM Netfinity Servers, Compaq Servers

PROFESSIONAL EXPERIENCE

Software Development Specialist

Confidential

Responsibilities:

• Worked on Developing, supporting Oracle EBS Custom Applications(Order Management (OM), SCM, Purchasing, Inventory, Receivables, General ledger, Payables,Shipping, Deliveries, iSupplier etc), modifying forms, reports, workflow changes, custom Demantra loading data, color code changes, Writing PL/SQL interface using oracle API, Cancel requisitions using Oracle API, Cancel releases, data fix using PL/SQL. Correcting Shell script. Correcting reports, modifying queries, Creating new Alerts, creating SR using Oracle Support, applying patches, worked on fixing on AP trial balance vendor discount discrepancies wif Vendor liability report, Vendor invoice base currency discrepancy TB wif Foreign currency balances. Worked on Oralce EBS - AS/400 interface gateway issues.
• Worked on modifying various Oracle APEX Applications (QCIS, SVR, PNR, HMAR, ECMS,WINAPP,AP,AR Dashboard, GUM) pages and bug fixing pages, Publishing Multi language translations, Correcting PL/SQL, Creating Service requests using Service now, Check-in & out WinCVS/CVS, migrating Changes using FlexDeploy. Correcting datafix using PDBU. Worked on modifying reports and interfaces. Worked on Supporting Logility.

Environment: Oracle EBS12.1.3 Cloud(Order Management(OM), General Ledger, Receivable, Shipping, Payables, iExpense, Purchasing, Inventory, iProcurement, iSupplier), Demantra Cloud 12.1.3 on Linux server, Oracle forms 10g, Oracle Reports 10g, PL/SQL, Shell scripting, SQL Loader, Oracle EBS 11i(11.5.10), Workflow Customization. Oracle Apex Custom Applications PLP, SVR, QCIS(QC2), HMAR (Hazards Material Management),PNR(Part Number Register), ECMS(Engineering Change management), WINAPP. Oracle Apex18.0/5.0, Service now, FlexDeploy, WinCVS, DLOG, Liason Support, CA Workload automation. Knowledge on EDI interface, Logility, Splunk, Autosys.

Confidential, Nashville, TN

Application Developer

Responsibilities:

• Worked on Clients functional Requirements gathering, Setups, creating roles and responsibilities etc.
• Customized various oracle OM, AP Forms and customization, personalization oracle forms. Modified existing oracle reports by adding parameters. Update item category,on hand quantity values.Loading new items, item category using interface tables into various inventory organizations.
• In oracle OBIEE developed various custom reports, dash board reports and developed using SQL query reports.
• Modified existing RPD. Created different subject areas and integrated various subject areas. Worked on Oracle data integrator (ODI) to migrate data from Oracle EBS to BI subject areas.
• Worked on Order Management(OM), Supply Chain Management(SCM), Warehouse Management (WMS),Supported Order booking,resolving various issues such as onhand quantities (Inventory), item Price issues, Item category, Pick Release issues, Shipping, LPN etc.
• Assigned Shipping Roles.
• Created WMS Rules and strategies, resources, assigned employees.
• Created WMS User task types.
• Worked on modifying existing APEX 4.2 My Unvlt applications, integrated wif Orace EBS R12. Developed custom business development application using APEX integrated wif oracle ebusiness suite R12. Created users, assigned roles to users. Created views in by combining various tables. Integrated wif oracle e-business suite loading data into custom tables. created views inventory item list, responsibilities lovs from oracle erp tables,views as shared components. Imported data using sql scripts,. Developed screens using Page designer integrated Reports wif forms and master details forms. Utilized dashboard. created mile stones. Developed classic, interactive, report on web services. Create public page and assigned to various reports to public access. Reports output as pdf, csv file etc
• Monitoring existing SQL code and fine-tuned the SQL queries using optimizer hints for joins, parallelism and Explain plan.
• Involved in Unit Testing, System Integration Testing and deployment of the application. Creating oracle users, assigning responsibilities. Assigning shipment roles.
• Developed UNIX Shell scripts to automate repetitive database processes.

Environment: JSP, Html, Java Script, Oracle 12C, TOAD, SQL Developer, SQL* Plus, Linux, PL/SQL,UNIX shell scripting, Oracle 12R (GL, AP,AR,INV,OM,ASCP,BOM, WIP,PO,HR, WMS), OBIEE 11g, ODI, MS SQL Server 2012, VB 6.0., Oracle 10g forms, Oracle 10g reports.

Confidential, Ashburn,VA

Sr.Developer

Responsibilities:

• Experience in upgrade APEX 4.2 to 5.0 APEX. Developed custom business development application using APEX integrated wif oracle ebusiness suite R12. Created work space, created users and assign roles to developers. Using data model created logical objects, created constraints, developed scripts, sequences, imported into apex. Run sql scripts and created tables. Created views in by combining various tables. Integrated wif oracle e-business suite. created employees, items list, responsibilities lovs from oracle erp tables, views as shared components. Imported sql scripts, loading data into custom tables. Developed screens using Page designer integrated Reports wif forms and master details forms. Utilized dashboard. created mile stones. Developed classic, interactive, report on web services. Create public page and assigned to various reports to public access. Reports output as PDF, CSV file etc
• Extensively used SQL*LOADER facilities.
• Developed and Customized JSP pages to display data dynamically for usability, rich look and feel.
• Developed and modified the existing Java script for the client side validation.
• Developed and customized various reports using Oracle 10g report builder.
• Monitoring existing SQL code and fine-tuned the SQL queries using optimizer hints for joins, parallelism and Explain plan.
• Involved in Unit Testing, System Integration Testing and deployment of the application.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Customized various oracle PO, AP forms and customization, personalization Self Service forms using JSP, JavaScript, HTML5.

Environment: JSP, Html, Java Script, Oracle 11g, TOAD, SQL Developer, SQL* Plus, Linux, PL/SQL,UNIX shell scripting, Oracle 12R (General ledger, Payables, Inventory, Purchasing, iProcurement, iSupplier, Human Resource, OTA, Alerts), Oracle Forms10g, Oracle 10g Reports, oracle APEX 5.0/4.2, python 2.4

Confidential, Nashville, TN

Sr. Developer

Responsibilities:

• Involved in the creation of database objects like Tables, Views, stored Procedures, Functions, Packages, DB triggers, Indexes and Collections.
• Extensively used SQL*LOADER facilities.
• Monitoring existing SQL code and fine-tuned the SQL queries using optimizer hints for joins, parallelism and Explain plan.
• Prepared the detailed design documentation for business requirements
• Developed and modified the existing Java script for the client side validation.
• Involved in debugging and bug fixing for Web based application.
• Implemented tab functionality for the application and the program component screens
• Developed Data access layer (DAL & DAO Objects) is developed for interacting wif databases.
• Developed and customized various reports using Oracle 10g report builder.

Environment: Java/J2ee, Jboss, JSP, Html, Java Script, Oracle 11g/10g, Struts framework, Eclipse, TOAD, SQL Developer, SQL* Plus, Unix, PL/SQL, UNIX shell scripting.

Confidential, State of Tennessee

Sr. Consultant

Responsibilities:

• Application support and maintenance and enhancement/change requests. The Tennessee Family and Child Tracking System (TFACTS), is a web based information system that provides a comprehensive case management tool for managing all child protection, child welfare, and juvenile justice service, Placement, Financial payments, Funding, Federal grants, Serious Incident, Critical Incident reporting etc delivery for the Department of Children’s Services. The application provides for immediate access to statewide data to share information, manage caseloads, and maintain accurate data for reporting and case management. The TFACTS system will replace many legacy applications currently being used by DCS and have interfaces wif other state and federal systems (for e.g. TennCare, Social Security Administration and Tennessee State Accounting and Reporting System, TNKIDS Financials, TNKIDS etc.).
• Requirements gathering and writing functional & technical specs; Application design and architecture; Designing/developing presentation, business and data components; End-to-end development and maintenance releases;Object and database Modeling; Assigned tasks to the team based on their expertise; Peer reviews; Perform code reviews and work review of team members according to standards laid out; Performing integration testing and halping client in acceptance testing; Provide technical guidance to the team members; System support and maintenance; Proof of concept/Prototype development; Work wif Business Analysts to resolve functional issues, provide technical recommendations and solutions; Leverage available/ organization standard design patterns, application architecture/framework capabilities and functionality; Develop complex SQL scripts; Construction of common routines and modules and Database design. Involved in correcting the bugs in TFACTS system by correcting java code based on functional requirements, test it using Jboss, Demoed to BA and move the corrected code to CVS and tan move to Staging etc. Participated in noledge transfer sessions for application maintenance and enhancement/change requests and supporting legacy systems.
• Integrating Oracle ebusiness suite 11i(11.5.8) wif TNKIDS (Power builder based) under SACWIS(State wide Automated Child Welfare information System) guidelines
• Involved in customization, implementation of Oracle E-business suite 11i (11.5.8) Modules(GL, AP, PO, iProcurement, iSupplier, INV, HR,OTA) on Solaris 5.2 server wif windows xp professional as clients.
• Developed various open interface programs for HR, OTA, Self Service.
• Migration of Employee legacy data from Remedy, DOP into intermediate tables from their imported into oracle HR tables using HR API packages (Location, Organization, Job, Position, Employee, Address, assignment, assignment criteria).
• Designed, developed custom employee database to load from legacy Remedy, DOP data into Oracle tables. Worked & developed Custom web based CIR(Critical incident Reporting), SIR(Serious Incident report), Un-Invoiced Children reporting using APEX 3.0 & Oracle ebusiness 11i.
• Developed, modified Pre-batch validation (to validate child location from TNKIDS data) at the time of creating the release & and the time of creating invoice.
• I put invoices on hold if the validation fails.
• Re-validate pre-batch process to validate already validated invoices. Allowed re-invoice after debit memo was created.
• Customized ap invoice validation process by adding PO number. Involved in developing Auto debit memo process.
• Customized various oracle PO, AP, HR, OTA Forms and customization Self Service forms and developed, registering new Self service forms for OTA using Oracle Web PL/SQL(htp, htf, owa util etc), Javascript, HTML.
• Developed online Training Enroll Status to Cancel status form, remove enrollee from a Program, Employee enrollment in programs. Employee creation, assigned grades, Positions, Assigning Supervisor, termination of employees.
• Developed un-invoiced children online self-service forms in iSupplier and developed DCS Un-Invoiced Children reports, Summary reports using discoverer.
• Worked wif Oracle Concurrent manager for running jobs etc.
• Customized database triggers. Customized oracle purchase order, Inventory, Payables forms made only unique items to be entered and made certain attributes made mandatory columns. All the customizations are performed based on business needs which tightly integrate TN KIDS data wif TN KIDS Financials Data to reduce redundancy of data and manual effort. Customized Workflow packages for OTA, PO.
• Customized apps.po wf po notification package and changed line titles.
• Customizing Oracle Alerts and creating new alerts.
• Written shell scripts to send email notifications.
• Developed various custom discoverer reports by creating business area, folders, custom folders using discoverer Admin edition.
• Created various reports assign to respective responsibilities.
• Developed various functions to utilize in Discoverer 4i reports.
• Worked on RICE((Reports, Interfaces, Conversions and Enhancements / Extensions) Components.
• Involved in implementation & Customization of Oracle Applications .Worked on various development jobs i.e. conversions & interfaces involving major modules of Oracle Applications.
• Customized various Oracle Application Reports and Forms involving various modules. The job also involves writing Test Plans, Coding and Customizing strictly as per the Oracle Coding Standards, testing in different instances and also using tools like PVCS to maintain the code efficiently.
• Also designed, developed, implemented Business development system using oracle designer, developer and web enabled wif Oracle Web/Application Server.
• Environment: Oracle 8i, Oracle Developer 6i (Forms 6i, Reports 6i), PL/SQL, Oracle Designer 6i, Oracle Web/Applications Server, Discoverer 3i(Admin & User Edition), IE 5.0, Netscape 4.7, Oracle Applications

Confidential, Ft. Lauderdale, FL

Technical Consultant

Responsibilities:

• Involved in user requirement analysis and implementation of Oracle financials based accounting system for Accounting Receivables and General Ledger.
• Mapping the fields from legacy system into Oracle Receivables And Oracle General Ledger.
• Created conversion programs using pl/sql and sql/loader for ra customers interface all, gl interface tables in Receivables and General Ledger.
• Registered all conversion and customized programs and reports in Oracle Application Object library.
• Created EUL, various business areas, folders, assigned users roles, privileges.
• Created work books, passing parameters, sharing work books, Drill down reports, and graphics.
• Written PL/SQL procedures for transferring Oracle data into Data ware house tables.Worked in customization of Order Entry (OE) and Human Resource (HR) Forms using Forms 4.5. The forms should allow zero, decimal quantity, customization of Column labels, changing columns positions of order entry, HR for Oracle 10.7 SC and also for Oracle Application (Web) Server, generated Oracle forms using designer 2.1.
• Worked in designing functional flow diagrams, coding for delivery, receiving transactions for purchase orders using RF device into receiving transaction interface tables.
• Developed, Implemented Decision Support systems(DSS) using Noetix Views, Brio on Oracle Manufacturing
• Created various views and developed variousreports such as Orders to be cancelled, MRP weekly demand report, Po Action history report, Item wise Exceptions, Low balances report etc.Wrote Packages, procedures for extracting manufacturing data and store into warehouse tables.
• Worked in setting up concurrent jobs and running concurrent manager. Analyzed the Legacy Reports and developed the system critical reports using Reports 2.5 and Discoverer 3.0.
• Created stored procedures, functions, database triggers, and packages for the development of the common access modules on Oracle8i database to facilitate data entry, modification, and deletion.
• Modified the existing creation script for the database objects.
• Tested individual modules for conformance to the client's specification.
• HP9000, HP UX, Windows NT, Oracle 7.3, P/L SQL 2.3, Oracle Web Server, Oracle Forms 4.5, Oracle Reports 2.5, Discoverer 3.0,Designer 2.1, Oracle Financials 10.7 SC (PO, OE, HR, INV, WIP, BOM), Visio, Noetix Views 1.X, Brio 4.0
• Worked in Oracle applications to import invoices and conversion of revenue accrual data.
• Converted revenue accrual data from legacy into intermediate table and transfer into Customized Accounts Receivable module.
• Creating Oracle views using Oracle tools provided for AS/400 ASCII files. Load views data into Oracle tables.
• Transfer intermediate table data into Oracle interface tables.
• HP Servers, Windows NT, Oracle 7.3, Oracle Forms 4.5, Oracle Reports 2.5,PL/SQL, Procedure Builder 1.5, SQL Loader, Oracle Financials 10.7 SC (AR)
• Worked wif IBM Consulting Group in Quality Assurance projects (Dade QAP). This project is a leading edge plan server project, which provides Statistical Quality Assurance for Hospitals and Laboratories across the country. It is done using Oracle 7.3 engine rolling on AIX - 30 SMP.
• Involved in developing PL/SQL stored procedures, functions and packages.
• Developed various Forms, reports, adhoc reports, reports wif Graphics using Developer 2000, discoverer 2000.

Environment: Oracle 7.3, AIX 4.X, Sun Solaris, RISC 6000, Motif, Developer 2000(Oracle Forms 4.5, Oracle Reports 2.5, Graphics 2.5), Procedure Builder 1.5, PL/SQL 2.3, Shell Scripting, Discoverer 2.0

Confidential

Muttrah, MuscatFinancials Technical Consultant

Responsibilities:

• Involved in implementation of Oracle Applications based accounting system. Extended support in updating existing forms and reports in General Ledger and Accounts Receivables. Used FSG reporting.
• Responsible for importing legacy data into Oracle applications.
• Imported Customer data from legacy systems into Accounts Receivable and Updated customer details.Involved in creating and maintaining journal entries, cross application reporting and consolidation.
• Created invoices through Invoice import.
• Provided technical support for month end closing for accounts receivable.
• Creating recurring invoices in AR, quick codes, user exits zooms, Oracle Alerts.
• Involved in designing, developing, testing and implementing Accounts
• Receivable and General ledger accounts, Inventory Management System (IMS). It gives the details of General ledger, Debtors outstanding, Creditors outstanding, trial balance, Profit & Loss statement and balance sheet etc.
• Inventory management system(IMS) for stores department. It contains different transactions entries like Goods Receipts, Delivery Orders, Stock Update on delivery/receipts, Reports like stock register, Purchase Register,Delivery orders stock summary statements et
• Involved in designing, developing, testing and implementing Payroll & Personal details system (PPMS) to maintain employee salaries.
• Involved in designing, developing, testing and implementing Financial Accounting Management system (FAMS).Involved in designing, development, testing and implementation of Inventory Management system for Garment Manufacturing Company. Bills of Material systems, Cost management systems.

Environment: IBM PC, MS-DOS Clipper 87, Novell 2.0, FoxPro 2.0,C