SUMMARY

• Senior Applications Developer with over 15 years of IT expertise
• 10+ years of experience in system design, installation, testing & implementing, production and development environments, supporting application functionalities in Oracle ERP
• Expert in EBS R12 (HRMS, Financials, SCM Modules). Thorough knowledge of Application Object Libraries, System Administration, Alerts and Business Intelligence Systems
• Strong expertise in creating and documenting complex system designs, data flow diagrams, test plans and process diagrams
• Extensive experience in remediating CEMLI components and retrofit to the EBS upgrade
• Authored numerous RICEW objects
• Involved in performing Setups, GAP Analysis, requirements gathering, testing, customizations, implementation, upgrade and post implementation/production support expertise with different versions of Oracle Applications across different operating systems
• Expertise with setting up KFF (Key Flexfields) and DFF (Descriptive Flexfields) to capture essential information for the clients
• Designed and implemented the complete interface Application Programming Interface (API’s) to Oracle applications in Job scheduling effectively and optimally using Appworx scheduler
• Expertise with Oracle Workflow, customizing Approvals Management (AME) to Procure to Pay, Invoicing, Payments and Human Resources
• Written numerous Interface programs for importing data from feeder systems to Oracle using Data Loader, SQL*Loader and PL/SQL constructs
• Expertise at various levels of software development process (Agile/Waterfall methodology). Includes conception, design, development, coding, testing, implementation, QA, deployment and presentation
• Experience in working with Oracle support to resolve business issues both functional, technical, bugs and patches
• Exceptional skills in performance tuning of EBS applications and system availability 24x7
• Experience in Unix Shell Scripting and testing of EBS application to Linux migration
• Highly motivated, firm believer in team work and good rapport with stake holders

TECHNICAL SKILLS

Application Suites: EBS R12.1.3 HRMS(Core HR, Payroll, OAB, SSHR, iRec.)R12.2.4 Financials (AP, AR, GL, iProc, Purchasing, Projects), EBS R12.1.3 Financials (AP, AR, GL,FA, CE, Treasury, Projects, GMS), Oracle Manufacturing 12.1.3/11i, 11.x, 10.7 SC/10.6 (OM, INV, BOM, Advanced Pricing, ASCP)

Databases: Oracle 11g,10g/9i/8i, Oracle 8.x / 7.x

Development Tools: SOA, BPEL, OAF, Oracle Fusion Enterprise 11g, OAF, Oracle Workflow Builder(2.6.3/2.6.2/2.5), Approval Management (AME), Forms 11i/9i//6i, Reports 11i/6i, Oracle 6i Toolkit, Designer 6i/2000, Oracle 9i AS, Oracle Portal/WebDB, SQL*Loader, Import/Export, PL/SQL Web toolkit, XML Publisher, OBIEE, BI Publisher

Languages: PL/SQL, Java, JavaScript, Pro*C, C, XML

Hardware: IBM COMPATIBLES PENTIUMS, DEC ALPHA, HP - 9000, MQ Series

3rd Party Tools: Microsoft Project, Microsoft Visio, MS Office, FTP 7.0/6.0/5.0, TOAD, SQL Navigator, ERWIN, Macromedia Generator, Rational Clear Case, PVCS ERP Change Manager, Serena Dimensions, PVCS Tracker, Crystal reports. Secure CRT, Formatter Plus 1.4.0, Data Loader, AppWorx System Scheduler, Smart dB Workbench, COGNOS, Informatica, Kronos

O/S: Windows Professional, NT, 2000, Sun Solaris 2.4,7,8 HP-UX 10,11

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Technical Consultant

Responsibilities:

• Performed remediation for R12.2.4 upgrade of Financials, Procure to Pay, Order to Cash and Supply Chain Management modules. Identify risks associated with CEMLI remediation in upgrading
• Oracle Applications. Implement prototype and remediate programs relating to DEAMS (Defense Enterprise Accounting Management Systems).
• Retrofit complex customized workflows to integrate with upgrade environment. Streamline and integrate Inbound and Outbound processes from different sources.

Confidential, New Orleans, LA

Senior Oracle Applications Developer / HCM Lead

Responsibilities:

• Prototype and remediated 100 plus CEMLIs (Configuration, Extension, Modification, Legislation, Integration) associated with the Procure to Pay Process
• Analyze custom Invoice and payment workflows with respect to R12 upgrade architecture
• Remediate, re-design, retrofit and develop new customized workflow processes
• Perform unit testing of the objects and integrate with third party applications using web services
• Migration/version control of objects using Serena Dimensions to customized repository
• Trigger Inbound and Outbound processes through SOA/BPEL customized process
• Analysis of HCM modules for new implementation to the existing R12 Financials
• Authored BR30, BR100, BP80, MD50, MD70, MD80, CV120 and other related AIM documentation for different modules
• Provide Support in various Conference Room Pilot’s and UAT processes
• Identify the CRP/UAT issues and resolve functionally through setups or technically through development of programs to accomplish business initiatives
• Analysis, Design, develop and implement numerous Reports, Interfaces, Conversions, Enhancements/ Extensions and Workflows (RICEW) items
• Performed unit testing, system testing and integration testing
• Support all aspects of Payroll/Advanced Benefits/SSHR since go live
• Time Management using Kronos (OTL alternative) to suit business requirements
• Performed Absence Management setups by creating elements, links and absence types, developed complex accrual fast formulas to satisfy business logic for different people groups
• Designed and developed inbound and outbound interfaces to and from Oracle Applications
• Authored several System Extracts to retrieve data from applications to third party vendors in Vision, Medical, Retirement and FSA
• Developed numerous custom Fast Formulas for Payroll Deductions and Advanced Benefits to accomplish complex business objectives
• Successfully completed advanced benefits open enrollment process to 5500 employees for three consecutive years
• Supported entire university Payroll Processes for 9500 employees with 100% efficiency
• Extensive experience with Payroll Taxes, Year End processes and coordinating with ADP vendor on system extract issues
• Developed custom programs, data conversion from Legacy to EBS using API’s
• Extensively developed custom packages/reports using Business Intelligence and XML publisher
• Troubleshooting issues in the Front-end application and reports

Confidential, Pittsburgh, PA

Software Engineer / Programmer

Responsibilities:

• Support OPEX custom application Order Management/ Supply Chain and CRM modules
• Providing production support and resolving critical issues expeditiously
• Generating custom reports/extracts to different business units across the organization.
• Enhanced the Mass Support Changes module performance by 85%
• Automated MQ Series messages to the organization.
• Successfully resolved more than 100+ customer issues and performed 60+ process control changes
• Modified CUSTOM.pll to customize the standard forms
• Excellent team member and take leadership to complete tasks
• Expertise in converting business issues to Functional/Technical designs
• Communicate and Report on project progress with IS management
• Worked on numerous packages, procedures, functions, trigger and other database objects
• Support Oracle Applications end user population and the Business Analysts
• Extensively utilized the Application Object Library to register SQL*Loader programs, shell scripts, PL/SQL Procedures, Forms and Reports. In addition, also used the System Administrator responsibility to configurations of value sets and request sets
• Defined key and descriptive flex fields to capture additional information about orders and transactions in order management
• Created functional design documents for custom Install Base APIs and for interfaces to integrate Order Management, Configurator and third party applications.
• Designed and developed custom Bill of Materials project replacing existing third party quoting process to native oracle
• Modified SoftTech order entry process to use Oracle API’s
• Automated system to process numerous orders in a batch process
• Performance tuning of applications
• Application analysis and design of Major Accounts Billing modules
• Data modeling for Electronic Bankruptcy process
• Analysis, design, development and implementation of Electronic Bankruptcy
• Integrated complex business logic utilizing PL/SQL packages, procedures and functions
• Developed interfaces from mainframe and custom data sources to Oracle
• 24x7 On-Call production support to the KCS (Key Customer Service) applications
• Data mining and dataflow analysis from multiple sources of data
• Initiating production control bills to 4 million customers
• Creating Maestro Schedules, implement automatic batch jobs using shell scripts in HP UNIX, procedures in Oracle 9i and reports using VISTA enterprise solutions
• Cross Platform Interoperability between Windows NT/UNIX Operating Systems
• Customized reports to Business partners using Oracle Reports
• Designed schema for the system, migration of data to Oracle using SQL Loader and developed data types, tables and indexes
• Developed complex PL/SQL packages, stored procedures and database triggers for the process of the data
• Initiated, designed and developed user interface screens/custom reports
• Wrote packages and stored procedures that will trigger when the data reaches certain department of environmental protection allowable limits
• Created object groups (.olb) and PL/SQL libraries (.pll) for the coding standard and inheritance
• User modules designed using Oracle WebDB and client validation with JavaScript