SUMMARY:

• Technology and business professional with over 16 years of cumulative experience in the enterprise software design, development, implementation, customization & management of Oracle ERP Applications
• 5 Years of experience leading and managing Oracle E - Business 11i and R12 Implementations
• Over 11 years of Techno Functional experience focusing on conceptualizing business needs and translating them into viable technical solutions
• Excellent verbal and written communication skills as well as Leadership skills, Interpersonal and relationship management skills
• Ability to effectively communicate direction to all project resources including functional, technical, DBA and other infrastructure resources both onsite and offsite in multi-cultural and global environments through the various phases of the project from planning to transition to operations
• Experience with Project management tools including MS Project, MS Word, and MS Excel
• Experience with Water fall / Agile Software Development Life Cycle (SDLC) and project management techniques.
• Complete the detail design phase of a project by preparing application specifications and technical specifications.
• Design, configure, unit and system testing, documentation, assist in training and implementation of projects, programs, workflows, etc.
• Area of expertise includes analysis, design, estimation, coding, testing, migrating and production support of application software
• Experienced in CEMLI, RICEW, Oracle AIM methodology for functional and technical specification/documentation and design, development in single and multi-org, multi - currency environments & worked on MD050, MD070, CV040 and BR100 documents
• Experience in sysadmin tasks, Application object library including creation of value sets, flex fields, users, responsibilities, menus, concurrent programs, request sets, request groups
• Hands-on experience in designing and developing packages, procedures, functions, triggers, OAF pages, custom reports and forms, registration/migration of Forms, Reports, XML Publisher Reports
• Working knowledge of the financials table structures, API's, Open Interfaces of Oracle Application Version 11i and R12 and performing some functional setups AR, PO, AP, FA and GL with business users
• Proficient at understanding custom and legacy applications and integrating with Oracle Applications
• Skilled in gathering and documenting requirements; perform gap analysis, developing specifications, creating programs, assisting with user testing, developing and executing test scenarios using Oracle databases and tools in Unix and Windows environments

TECHNICAL SKILLS:

Software: PMI-PMP, Scrum, Agile, MS Project, MS Project Server, JIRA, SharePoint, SOA, Oracle R12, Oracle 11i, DB2/400, RPG, CL, SQL, SQL*Plus, PL/SQL,Java/J2EE, JDK 7, Apache Tomcat, Cognos, Saleforce.com, BI, DW, ITIL (concepts), Web services SOA, Oracle11i, SQL*Plus, SQL*Loader, ODI, TOAD, PL/SQL, PL/SQL Developer, Forms and Reports 10g, 9i, 6i Reports 2.5/6i, JDeveloper, Oracle Workflow, BI Publisher, Financials, Discoverer, Noetix, Oracle OLAP, Microsoft Office (Excel, Word, PowerPoint, and Access), Visio, Cognos, OPTIO Design Studio, PVCS Version Manager, Microsoft Visual Source Safe, Seagull FTP, WinScp, Putty, Dataload Classic and Professional

Languages: PL/SQL, XML Publisher, SQL, C, Java, OAF, HTML, XML, XSL, Oracle Forms & Reports(6i,9i,10g) and Designer 2000

Operating System: LINUX, MS-DOS, SCO/UNIX, UNIX, Windows NT, and WIN 95, WIN98, Windows 2000,8,10

PROFESSIONAL EXPERIENCE:

ERP Developer

Confidential

Responsibilities:

• Oversee Plan and direct all team related work activities for the Oracle R12 Upgrade throughout all phases of the ERP Implementation in US and China
• Responsible for the implementation of R12 multi org and Multilanguage changes for US and China
• Responsible for the creation of the functional setups, Business Process and technical specifications documents BRD, BR100, MD050, MD070
• Responsible for the implementation of outbound interfaces to send Customer, Contacts and Territories percentages to Sales Force Application
• Responsible for the development and implementation of inbound interface for loading daily currency rates necessary for dealing with foreign currency transactions in E-Business Suite from online current rate source Yahoo.
• Responsible for the implementation of Account Generator workflow customization for Oracle Projects implementation in China
• Managed and supported the Oracle EBS Applications especially on Accounts Payable, Accounts Receivable, Purchasing and Order Management as part of the routine process required for the customer.
• Defined concurrent programs and assigned to request groups. Performed registration of concurrent programs, implemented PL/SQL for invoking concurrent programs, defined value sets and parameters for custom reports, performed system administration functions such as Creation of Users, Creation of Responsibilities and Set up user profiles specific to applications
• Coordinate project and accountability ensuring business project deliverables are achieved
• Prepared high level functional specifications for new reports and interfaces
• Involved in the requirement gathering and Gap analysis pertaining to AT&T cloud hosting.
• Efficiently supervised teams of 5 to 12 resources of various teams with both on-shore, near-shore, and off-shore providers across multiple time zones and global locations. Conducted biweekly status calls and tracking progress.
• Representing application development projects in stakeholders meeting with PMO and cross functional product managers.
• Maintain project plan, timelines and project milestones and communicate to business stakeholders on key milestone dates.
• Identifying critical paths, potential hurdles and recommending appropriate actions
• Ensuring that the work of the project team meets and remains in scope of the project
• Managing change requests to the scope of the project and create strategies for risk mitigation and contingency planning
• Handled budgeting and forecasting aspect for projects and coordinated with PMO in managing cost exception for ongoing project.
• Conduct weekly Release Meetings and coordinate post implementation production support and development activities with help desk, Infrastructure, DBA’s and Functional specialists on all activities related to EBS application issues & customizations and enhancements
• Environment: Oracle 9i, Oracle 10G, J developer 12c, Oracle EBS R12 (GL, AR, AP, OM, INV) Workflow Builder 2.6, Forms and Reports Builder 6i, HP-UX OS UNIX, PL/SQL and SQL Plus, PL/SQL Developer, VSS (Visual Source safe), Panaya, MS Project, JIRA, Share Point, Wordpress

Technical Consultant

Confidential

Responsibilities:

• Provided Application enhancement and support for AP, AR, PO, FA and GL modules
• Performed Business process analysis and requirement gathering for new customization, report development.
• Created MD050, BR100, TE040 (Test Scripts) and End User Training Manuals.
• Implemented Auto Lockbox for transferring customer payments from the bank into auto lockbox tables using an SQL*Loader script(s) and applying receipts
• Converted City of Confidential ’s agencies (Police, Fire, Third Party) invoices using AP invoices Oracle interface; used a series of custom PL/SQL programs, Packages to populate invoice data into Oracle Open Interface tables
• Created an Oracle Cash Management Inbound Interface to Import the Statements BAI File from Confidential, Confidential and Confidential on a daily basis and several times within a day
• Auto Invoicing to import Fire Departments AR invoices in to Oracle AR Module
• Conducted System Study and Gap Analysis and Mapping requirements with Oracle Applications
• Developed GUI-Data Conversion Scripts using DataLoad Classic and DataLoad Professional
• Developed various AOL objects and migrated them using SQL script as well as FNDLOAD scripts
• Defined descriptive flex fields and Key flex fields
• Integrated Customer Information and invoices using Oracle Receivables Customer Interface
• Customized the Purchase Order Form in Purchasing Module using Form Personalization to Disable Finally Close Purchase Order for all except DRM Purchasing Super user
• Personalized the Purchase Order form for Blanket, Contract and Planned Purchase Orders to mandate entry of Date in Effective and Expiration Field
• Supported Oracle Applications including AP, AR, GL, PO, Cash Management and a collection of support apps including PVCS, Noetix, WebADI, Dataload, GLWAND and others
• Unclaimed property Escheat processing of uncleared checks to Michigan State Tax Authority
• Performed data analysis and reporting required for CAFR (Comprehensive Annual Financial Report)
• Customized Payables Report Final Payment Register by Fund Showing Accounting Segment to take additional input for user parameters
• Created Dataload Scripts to load Oracle Users and User responsibilities to Training Instance used for CityWide Training of Oracle Modules
• Customized Receivables Aged Receivables Balance by Fund
• Created Alerts to email Purchasing module users on Purchase Order contract expiration
• Supplier Merge issue resolution for vendors stuck in the merge form
• Conversion of Poll Workers payments file for reporting to IRS required format
• Converted data from Excel to Michigan State Software for the purpose of Escheat
• Formatted Confidential - ARP/Positive pay file per bank specs and Transmit to bank - 2011 Year End close
• Data fix to correct the status of Cancelled Purchase Orders in Requires Reapproval status caused by the Bug in the seeded Mass Cancel Program
• Provided support to BSS for adding assets using WEB ADI and resolve errors due to Macros VB and Excel error
• Created VBScripts to monitor the FTP files from received the Banks and send email messages to business users on the status
• Worked with the software vendors to resolve issues that impact City of Confidential DRMS applications by coordinating code fixes or patches
• Monitored and resolved issue related to oracle purchasing work flow and user notification workflows
• Created Oracle Tars for technical and functional issues related to oracle support in oracle EBS
• Managed tickets and triage issues
• Maintained peer relationships across IT areas (infrastructure, operations, etc.) to support effective implementations
• Involved in testing of the implemented modules and post implementation production support

Environment: Oracle 9i, Oracle 10G Oracle EBS 11i (GL, AR, AP, FA, HRMS, PAY, BEN), Workflow Builder 2.6, Forms and Reports Builder 6i, HP-UX OS UNIX, PL/SQL and SQLPlus

Oracle EBS Developer

Confidential

Responsibilities:

• Conducted System Study and Gap Analysis and Mapping requirements with Oracle Applications
• Involved in analysis for defining Item segments as per business requirement
• Involved in multi-org and multi-currency setup
• Imported data from legacy system to Oracle Receivables tables using SQL*Loader and validated them using procedures
• Auto Lockbox was used for transferring data from data files provided by the bank into auto lockbox tables using an SQL*Loader script(s)
• Conversion of AP open and closed invoices using invoices interface; used a series of custom PL/SQL programs, Packages to populate invoice data into Oracle Open Interface tables
• Developed Data Conversion PL/SQL programs for a variety of Oracle Applications Modules with most emphasis on the Transactions Modules (PO, OM, and AP), Vendors, and Inventory Items
• Developed GUI-Data Conversion Scripts using DataLoad Classic and Dataload Professional
• Developed Interface for Oracle General Ledger, segment value import from legacy system to Accounting flex field segment using API’s
• Defined descriptive flex fields and Key flex fields
• Developed new reports for the Oracle applications using XML Publisher for SSR system that keeps track of system service requests and statuses
• Customized various reports in purchasing module including partially received PO’s report, Purchase Orders not invoiced report
• Integrated Customer Information using Oracle Receivables Customer Interface
• Involved in testing of the Implemented modules & post Implementation production support

Environment: Oracle 9i, Oracle Financials 11i (GL, AR, AP, FA, Inventory, Order Management), Self Service (iProcurement), Workflow Builder 2.6, Forms Builder 6i, SUN OS UNIX, PL/SQL and SQLPlus

Technical Consultant

Confidential

Responsibilities:

• Involved in user meetings for Gap Analysis and legacy field mapping and requirements gathering
• Designed and developed programs to extract data from the legacy using embedded SQL and ILE Programs, FTP extracted files to Unix box for converting data to Oracle applications
• Prepared technical, business mapping documents
• Involved in Functional Design for Interfaces and Customization (MD50)
• Involved in Creation of Technical Specification for Interfaces and Customization (MD70)
• Involved in Data Migration of vendors, items and employees
• Performed data conversion from other legacy systems
• Performed detailed analysis and developed programs for Rollins Confidential District swing
• Performed tape backup and restores, Monitored and scheduled jobs
• Interfaced different operating systems, such as PCs and OS/400s for transferring data using Networking techniques including FTP, TCP/IP, and ODBC

Environment: Oracle 8.1.7, Oracle Financials 11i (11.5.8), Dataload Classic and Professional, DBU, Hawkeye Pathfinder, PDM, DFU, SDA, SEU, Query/400, Turnover Version Control, ISDB, RLU, GPS data warehouse Unix, PL/SQL and SQLPlus

Software Developer

Confidential

Responsibilities:

• Researched, designed, developed programs for one of the largest consulting companies in USA called Confidential, GA for the conversion and up-gradation of programs on an IBM AS/400 using RPG/IV with RPG ILE
• Designed and developed programs for the Purchase Order module
• Designed and developed the sub file programs for vendor, item, region, section, and location master file maintenance using PDM and SDA
• Developed reports for parts with various parameters including process, vendor, date range, order date, etc.
• Created sub file programs with search, Sort and scan functionality to Depot Master, Section Master and Location Master
• Created sub-file programs for search and select function for Process Master
• Modified program for vendor Master maintenance to combine the functionality of the search / select program and also the maintenance (edit, delete, add) programs to process based on the action code
• Created Reports for detailed committed report for Vendor / Date Range, For Items Authorized by process, For Items authorized by date and detail receive report by Vendor / date Range busing the PDM and RLU

Environment: JD Edwards, DBU, Hawkeye Pathfinder, PDM, DFU, SDA, SEU, Query/400, TURNOVER, ALDON CMS, Pacman Change Management, WW, DW, ISDB, RLU, GPS data warehouse, MS Windows NT/98/95, MS DOS, MS Access, MS Excel, MS Word, PowerPoint, MS Internet Explorer, GroupWise, Lotus Notes MS Outlook, Visio, OPTIO Design Studio, IBM Client Access, Rumba PC Emulation

Software Developer

Confidential

Responsibilities:

• Researched, designed, developed programs for Confidential, Troy, MI for the Enhancements and production support for Grocery Host systems (GHS) applications on an IBM AS/400 using RPG400, CL400, RPG/IV with RPG ILE
• Designed and developed various batch and interactive programs for the various modules in the GHS applications including, but not limited to, sales invoicing, item maintenance, nightly maintenance, price simulation, EDI, etc.
• Performed production support and user training
• Used PaCMan change management tool to move code into production
• Converted programs from RPGIII/400 to RPGIV
• Developed Program change documents, Test plans, Test scripts and system testing documents
• Developed programs for enhancement of MRP application on an IBM AS/400 using RPG/IV
• Worked extensively with the RPGIII, RPG IV, ILE, CL/400, and SQL400 creating new interactive and batch programs for the RF scanners
• Wrote multiple interface programs using RPG ILE on IBM AS/400
• Wrote conversion programs for the payroll application to meet user requirements
• Analyzed, developed, and modified applications to improve the quality and integrity
• Created, tested, and implemented new programs for a new store
• Sent and received data to and from Mainframe system
• FTP data to UNIX for printing labels; worked on the DDM files
• Sent data to Excel using ODBC
• Performed Y2K remediation and support

Environment: IBM AS/400, IBM Mainframe, IBM compatible PCs, UNIX, Windows 95/98/2000/NT, MS-DOS, RPG IV/III/II, RPG ILE, CL/400, SQL/400, SQL, Java, HTML, XML, XSL