SUMMARY:

• Over 21+ years of professional IT experience across the SDLC focused on Oracle related technologies and applications, (including working for Confidential and Top 5 Consulting companies on Oracle ERP projects)
• Over 21+ years of broad - based experience as Oracle Applications (EBS) as Techno (50%) / Functional (50%) Consultant and Technical Designer / Lead Developer with significant hands-on involvement in development & delivery of Oracle EBS software components.
• Extensive experience in Oracle Supply Chain and Financials R12 (12.1.3/12.1.2 ) / 11i (11.5.10/11.5.9/11.5.8/11.5.4 ); and Oracle EBS background also includes significant experience with:
• Fusion: Financials AR, AP, Projects, HCM
• Financials: (GL, AP, AR, FA, Projects (Project Billing and Project Costing), CM, OTL)
• Supply Chain: (OM, BOM, INV (Inventory), Oracle Purchasing, WIP, Advanced Pricing)
• CRM: Service Contracts,TeleService, TeleSales, iExpense, iStore, Install Base
• HRMS: Oracle HRMS, Payroll, CWB, and Advanced Benefits
• Foundations: System Administrator
• US Government Security Clearance
• Extensive experience in configuration of Oracle GL, AP, PA, PO, FA, AR, INV, OM, HRMS, Payroll, OAB, WIP, BOM, Service Contracts, and Installed Base.
• Well versed and working experience with ERP Business Processes - Quote to Cash, Procure to Pay, Data Migration into Oracle EBS from Legacy Systems, and building Data Center / Warehouse.
• Proven ability to both effectively interface with end-users and translate business requirements into functional and then technical requirements; and experienced documenting following Application Implementation Methodology (AIM), utilizing various templates (MD050, MD070).
• Strong hands-on technical skills with extensive integration / implementation experience ofOracle EBS Applications, includingalmost 14 years of solid hands-on design / development / implementation, and production support of RICE components.
• Extensive hands-on expertise in design / development of Inbound / Outbound Interfaces and Conversion programs
• Solid hands-on working experience with customizing standard Oracle Workflows
• Proficient designing and developing Oracle EBS Personalization / Extensions, and in (PL/SQL, JSP, OA Framework,), including almost 2 years working experience with OAF Pages with JDeveloper
• Very strong hands-on DB development skills, (including working withPL/SQL, Store Procedures, Functions, DB Views, and query optimization).
• Expertise in Oracle R12 Upgrades, R12 Implementation, and EBS Testing; includes Functionality Testing, Data conversion validation, Patch regression, Interface validation, and Reports generation & validation
• Strong experience in developing and customizing Forms using Forms 6i/9i/10g, Reports using Oracle Reports 9i/6i/4.5/2.5, Discoverer 10g/4i/3i and XML Publisher 5.6.3/5.6.2, OBIEE, and Workflows using Workflow Builder 2.6.3/2.6.4.
• Additional Skills: Personalization, ADF, Informatica, Mercator, PVCS, SOA/BPEL, UNIX Shell Scripting, XML Publisher, 10g and 11g Oracle databases.
• Results-oriented team player with excellent communication and hands-on technical leadership skills

TECHNICAL SKILLS:

Industries: Telecommunications, Media and Entertainment, Utilities & Energy, Consumer Packaged Goods / Wholesale

Project Domain: Financial Management Solutions, Customer Relationship Management Solutions, Managed Application Solutions, Systems Integration, Business Process Re-engineering, Application Development.

Hardware: SUN, IBM, PCs.

Operating Systems: UNIX, SUN Solaris, Windows NT, Windows 95, MS-DOS

Computer Languages: PL-SQL, SQL, Java, C++, C, Assembly, LISP, Ada, Pascal.

RDBMS: ORACLE 8.0, 9i, 10g.

Development Tools: Developer/2000, Designer/2000, Oracle Workflow, Discoverer, TOAD, SQL Navigator, Mercator, SmartDB, WebMethods

Applications: Microsoft Office 97, Microsoft Office 2000, Microsoft Visio, Oracle Financials, Oracle Manufacturing, Oracle CRM

: Oracle 8i, Oracle 9i, PL-SQL, Developer/2000, Designer/2000, Oracle Workflow, Oracle Projects, Oracle Inventory, Oracle Payables, Oracle Purchasing, Oracle Fixed Assets, Oracle CRM - Service, Contracts Core, Customer Care, Call Center.

Development Tools: Oracle Module

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle EBS Techno-Functional Developer / Lead - Oracle R12 ERP

Responsibilities:

• Worked with business team to gather requirements, design, build, and deploy integration points into Sales Force and Work Day.
• Worked with business team to configure Oracle Project Costing and Oracle Project Billing modules.
• Worked with business team to re-implement AP positive pay integration with external bank. This involved in redesigning the file along with file transmission process.
• Self Service/OTL: wrote MD.50 for system to automatically add or remove responsibilities (ESS, MSS, Time View, Timecard Supervisor) for employees based on existence of direct reports and employee type (i.e. hourly/salary) and guided client through testing cycles.
• Worked on MD 50 relating to the shipping interface which was primarily used to convert WCS data toracle EBS systems, validation rules, customer web interface and cyber source interface.
• Designed and developed a new AP invoices inbound interface.
• Designed and developed a new inbound OM sales order from Sales Force into Oracle OM.
• Designed and developed a Web ADI integration into Oracle Inventory item master.
• Documented To-Be process of Oracle Financials Fusion - AR and Procurement.
• Conducted configuration workshops for the future state for Oracle Fusion AR and Procurement modules.
• Gathered and documented data integration and conversion requirements for future state Oracle Fusion.
• Configured Oracle Fusion AR and Procurement for a CRP/prototype environment.
• Modified Oracle ADF forms for Oracle iProcurement. The modification involved in building a complex defaulting of POET fields during the checkout process.
• Created 2 Oracle ADF forms to support integration with external systems for Sales orders
• Conversion of Projects and HCM data into Oracle cloud.
• Conduct Business Process review session, to improve client usage of seeded EBS functionalities.Identify challenges with existing applications and drive towards a process driven solution
• Build an outbound integration from OAB to an external system.
• Designed and developed fast formulas for HR and OAB.
• Involved in upgrading PeopleSoft HCM and new implementation of Time Labor for a multinational client
• Worked on analyzing current time and labor rules, decommissioned rules that were not in use, and modified existing rules that were not meeting client’s satisfaction.
• Designed legacy data conversion strategy for HR, Payroll, OAB and OTL modules and performed lead rule for configration in CRP1, QA and cut-over phases.
• Co-ordinate development & testing activities that include Supply Chain modules like
• Inventory, Purchasing, Order Management, Planning and Finance.
• Led a team to support Canadian core HCM and Payroll implementation and Labor support system
• Led several implementations in HCM, Time and Labor, NA Payroll, Benefit, and Absence Management. Believer in Oracle Unified method for implementation, development and project management.
• Across module experience- TL to Project Costing, Project and Activity setup, TL (Timesheet) to GL and Project Costing, Payroll to GL, Agile to Timesheet, ABSENCE Management to Payroll /Time and Labor Authorized to work in the US for any employer
• PeopleSoft Query and SQL, PeopleSoft Security, PeopleSoft Approval Framework - AWE
• Time and Labor custom rules (technical rules), FLSA law, FLSA mandatory changes for overtime
• Setting chart keys and chart-field keys in HR for Commitment Accounting
• As the functional Consultant Worked with acquired company to merge existing company with acquired company in Oracle Fusion.
• Established Geographic core structure, Division, Business Units and sets, approval setup.
• Created Time-period, Time categories, Time card fields, Consumer setup, Time Groupers, and time worker profiles.
• Setup Payroll tables - Pay period, Payroll earnings and deductions, Payroll flow and performed complete testing.
• Performed QA testing, system testing, UAT testing, kept log of test results and followed up for resolution. Worked with Time and Labor in OTL- Cloud.
• Analyzed new federal Payroll overtime law for 2016- all exempt employees who earn $1826 or less, on biweekly terms or $918 on weekly basis threshold, are impacted. Recommended actions to be taken for employees earning below the threshold. Provided a Query (Coded and ran the query) to identify the total number of employees of salary exempt, who fall into category impacted by new FLSA and overtime limit).
• Suggestions provided was reclassification employee type, increase in pay to exclude majority of employees from the rule, as well as new time and labor rules needed for impacted employees for overtime calculation. Performed analysis for FLSA Payment via Time and Labor rules of SQL patches and consolidation with what was paid via NA Payroll overtime setup.
• Led feasibility studies, Provided Project plan, deliverables, business plan and task list for PeopleSoft Benefit/ Ben Admin and Time and Labor set up
• For PUM upgrade changes for Time and Labor, helped users to understand and sign off on the new updates for Payroll and Time and Labor module changes.
• Put in place the new delivered Auto enrollment and tested successfully. Consolidated the Time and Labor rules and balanced between Payroll and TL.
• Authored BR100, TE040 and MD050 documents as per the requirement.
• Created interface files to send hours for UK, Netherland and China to their local Payroll providers. Worked with local vendors to work out the layout, fields and rules for transferring the files.
• Involved in development of many custom reports using BI Publisher and Reports 10g for Projects andSCM modules.
• Worked with business/technical team in developing external files transfer process.
• Worked on R12 implementation and upgrades in oracle SCM and Manufacturing modules and on RICEF components.
• Worked with business team to troubleshoot and fix data warehouse extracts issues.
• Worked with business team to design and develop FA conversion into R12.2 instance.
• Worked with business team to design and develop FA account generator customization
• Worked with business team and technical team in providing support for day-to-day production issues across different modules.
• Release manager / Technical Managers for Sales Force and Oracle Integration
• Project Management: Independently drafted O2C project plan, billing implementation project plan, and P2P project plan, and cutover plans for all phases. Worked with team for daily and weekly statuses, provided weekly status to steering committee, managed a team of 8 developers, and managed external Salesforce and Work Day team in meeting all deadlines.
• Modules: GL, AP, AR, PA, INV, OM, PO, FA, HRMS, OAB
• Release: R12.2 and Cloud

Confidential

Oracle EBS Techno-Functional - Oracle R12 ERP

Responsibilities:

• Worked on UNIX shell scripting to modify current data feed/integration process
• Worked with business team to resolve production support issues.
• Independently handle the deployment and support activities on Finance and SCM modules.
• Experience in developing ISG packages for the data flow from EBS to third party systems and vice versa.
• Create Functional Designs (MD.050), Configuration Document (BR100) and MD120
• Development & testing activities include various Supply Chain and Process Manufacturing modules in Inventory, Work in Process, Bill of Material, Purchasing,Order Management, Planning and Finance.
• Supported other teams, Payroll, Self Service, OTL, and Benefits to provide continuity between all teams on all modules.
• Worked with business team to resolve production support challenges on integration with the bank.
• Modules: GL, AP, PA, INV, PO
• Release: R12

Confidential

Solution Architect / EBS Techno-Functional Lead - Oracle R12 ERP

Responsibilities:

• Conducted requirement gathering sessions for Procure to Pay process.
• Delivered a proposal and estimation for Procurement Contract and Oracle TCA implementation
• Worked with the functional and technical teams in writing and reviewing MD50s and MD70s for AP, AR, GL, PO, and Projects
• Worked on OAF form changes for Oracle iProcurement.
• Worked on integration with BOA payment process.
• Primarily responsible for involving in Requirement Gathering, Gap analysis, Solution Design, Configuration ownership, which involves Oracle SCM Modules - Customer Master, Order Management, Return Orders
• Conducted conference room pilots for gathering requirements of Oracle HRMS integration with an external system.
• Developed SOA web service by using BPEL to read the EBS data and insert the same into legacy SAS ODS system stage table.
• Developed EBS WSDL package and SOA web service by using BPEL to read the PD (Product Delivery legacy system) Sales Order Delivery data, update the EBS stage tables(used by other interfaces) with the allocated quantity details based on the validations.
• Designed and developed FA mass additions customization
• Designed and developed FA custom reports in BI publisher
• Developed EBS WSDL package to validate the ACCELLOS data against derby data and generate the xls report with multiple tabs showing exceptions and graph.
• Conducted conference room pilots for gathering requirements of OTL and complex approval process.
• Configured a new business unit for the new external system’s employees.
• Designed and developed HR conversion and integration point from this external system for daily employees feed.
• Designed and developed FF and OTL rules for complex time approval process.
• Designed and developed US payroll integration with Vertex Q series to calculate taxes different levels.
• Modules: AP, AR, FA, PO, GL, Projects, HRMS, OAB, OTL
• Release: R12.2

Confidential

Solution Architect - Oracle R12 ERP

Responsibilities:

• Assisted the client to perform QA on implementation team’s deliverables, cutover plan, performance testing, code reviews.
• Reviewed implementation team’s configurations and business processes for Oracle E-Business Suite.
• Test lead for performance testing which involved detail planning, instance management, along with orchestrating execution of performance testing, and communication to the team.
• Involved in implementation of E-Business Suite Applications HRMS 11i - HR, Payroll, CWB, SSHR, OAB and OTL
• Prepared and executed the test scripts and test scenarios on R12 Oracle SCM and MFG modules.
• Test lead for Integration and User Acceptance Testing which involved detail planning, communication to the client and team, execution of the testing cycle, defect management, and closure.
• Review and revise BR100 documentation for the Oracle Financials R12 application set-up.
• Reviewed implementation team’s MD70s deliverables
• Reviewed implementation team’s MD50s deliverables
• Worked with implementation team to complete production cutover
• Worked with implementation team to perform instance performance testing
• Modules: AP, GL, INV, HRMS
• Release: R12.2

Confidential

Oracle EBS Technical Lead / Solution Architect - Oracle R12 ERP

Responsibilities:

• Worked on configuring Service Contracts and Installed Base module, MD50s for SC/IB conversion and interfaces.
• Designed and developed IB / SC conversion and integration point.
• Worked with business to identify business requirements for AR integration points, and AR invoices / receipts conversion.
• Test lead for performance testing, system testing, integration testing, and user-acceptance testing. This involved in coordinating the test scripts, working with team and client in writing test scripts, instance management, execution of the test cycles, defect management, and also communication to the client team.
• Documented MD50s for OTC process - AR Invoices interface, AR conversion, and AR cash applications extension.
• Documented MD70s for OTC process - AR Invoices interface and AR cash applications extension.
• Designed and developed OTC process - AR Invoices Interface.
• Assisted in developing AR Conversion
• Design and develop RD020, MD050 and BR100 in SCM instance based on the new solution going forward.
• Involved in Manufacturing and SCM track enhancements, developments and issues mainly dealing with modules PTP, OM, INV, Property Manager, Advanced Pricing, BOM, WIP, Planning and Quality.
• Designed and developed Installed Base and Service Contracts conversions.
• Designed and developed AR Cash Application extension which involved custom forms and processing extension.
• Designed and developed an interface from external HR system into Oracle HRMS which included both employee and assignment data set.
• Designed legacy data conversion strategy for HR, Payroll, OAB and OTL modules and performed lead rule for configration in CRP1, QA and cut-over phases.
• Involved in implementation of E-Business Suite Applications HRMS 11i - HR, Payroll, CWB, SSHR, OAB and OTL.
• Designed and developed outbound interfaces from Oracle HRMS to a third party payroll system.
• Worked with business in identifying their business requirements for a new business group within Oracle HRMS.
• Designed and developed FA conversion from an external legacy system.
• Designed and developed FA account generator workflow.
• Delivered MD50s/MD70s for Oracle HRMS data conversion.
• Designed and developed employees data conversion
• Configured Oracle HRMS module.
• Configured and implemented AME with PO and AP approval process.
• Customized OTC process - Oracle Sales Order Header and Lines workflows.
• Developed an interface for collecting cost for Project Costing.
• Developed an interface for collecting all billing for Project Billing.
• Worked on Project Costing to Fixed Assets configuration / setups.
• Worked on configuring Procurement Contracts module
• Worked on MD50 and MD70 for Procurement Contracts conversion.
• Designed and developed Oracle HRMS/Payroll/OAB Fast Formulas
• Developed code for Procurement Contracts conversion
• Project Management: Drafted project plan for migration of an acquired company to existing systems. Worked with both functional and technical teams in gather status and provided weekly status reports to steering committee. Worked with the conversion and integration teams for a successful delivery of all their deliverables.
• Modules: AR, OM, AP, FA, GL, Service Contracts, Installed Base, HRMS, OAB, Project Billing, Project Costing, Procurement Contracts
• Tools: XML Publisher, Custom PLL/Forms/Reports Customization, PL/SQL, Personalization.
• Release: R12.1.3

Confidential

Senior Solution Architect - Oracle R12 ERP

Responsibilities:

• Worked with business teams to identify critical reporting needs, and documented functional specifications for financial reporting.
• Worked with business team to identify an acquired company’s integration into Oracle EBS footprint.
• Setup of POS applications for client to utilize in its stores.
• Documented and created POS data extract for employee’s sales credits.
• Documented data retention, purging, and archiving process at the client.
• Documented MD50s and MD70s for OTC process customizations which included Sales Order workflow modification, modifications to AR invoicing process
• Designed and developed Oracle HRMS/Payroll/OAB Fast Formulas
• Designed and developed iExpense data processing.
• Redesigned approval process for PO reqs and AP invoices with AME.
• Designed and developed integration of an external system with US and Canada Payroll
• Designed and developed Payroll integration with Vertex Q series.
• Modules: General Ledger, Inventory, Purchasing, OM, AR, AP, iExpense, iProcurement, Project Accounting, Project Billing, Project Costing, Fixed Assets, POS, HRMS, Payroll
• Tools: XML Publisher, OAF, PL/SQL.
• Release: R12.1.3

Confidential

Senior Techno-Functional / Solution Architect - Oracle R12 ERP Implementation

Responsibilities:

• Designed and developed AR Customers and Suppliers Conversion and Interface.
• Designed and developed Payroll integration between third party system and Oracle Payroll.
• Designed and developed Oracle HR employees integration between a third party and Oracle HRMS.
• Designed and developed AP Invoices, Suppliers and Customers integration between external systems and Oracle AP and TCA, to support shared services model.
• Designed and developed interfaces utilizing Advanced Queing (AQ)
• Modules: HRMS, Payroll, AR, AP
• Tools: XML Publisher, PL/SQL.
• Release: R12.1.3

Confidential

Technical Lead - Oracle R12 ERP Implementation

Responsibilities:

• Assisted in documenting RICEW Inventory.
• Designed and developed integration hub UI and processing programs.
• Reviewed MD70s documented by offshore team.
• Modules: HRMS, Financial modules
• Release: R12

Confidential

Senior Techno-Functional / Solution Architect - Oracle R12 ERP Implementation

Responsibilities:

• Designed and developed Items Conversion and Interface. This involved creating Items under Item Master, Assigning them to organizations, updating item attributes, creating item cross s.
• Designed and developed interfaces utilizing Advanced Queing (AQ)
• Designed and developed integration from external systems into Oracle through ODI (Oracle Data Integrator)
• Modules: General Ledger, Inventory, Purchasing, AR, AP
• Tools: XML Publisher, PL/SQL, Informatica.
• Release: R12.1.3

Confidential

Senior Techno-Functional / Solution Architect - Oracle R12 ERP Implementation

Responsibilities:

• Worked with business to gather Oracle HRMS, Payroll, and Oracle Projects requirements.
• Created requirements matrix for Oracle HRMS, Payroll, and Oracle Projects.
• Delivered configuration workbook for Oracle HRMS, Payroll, and Oracle Projects modules.
• Configured Oracle HRMS, Payroll, and Oracle projects modules.
• Delivered MD50s and MD70s for Oracle HRMS conversion.
• Delivered MD50s and MD70s for Oracle Projects conversion.
• Designed and developed HRMS and Projects integration points from external systems utilizing Oracle Data Integrator (ODI)
• Designed and developed integration into Oracle Customer Hub, and worked on performing all the configurations for customer hub.
• Managed mock conversion cycles and production cutover activities.
• Worked on Project Accounting conversion which was to convert data from multiple external systems. The conversions were scaled to convert over 90K projects, 570K tasks.
• Assisted on an Interface to accept project accounting expenditures and labor, and upload them to different projects.
• Designed and developed Oracle HRMS/Payroll/OAB Fast Formulas
• Designed and developed an OTL Approval Customization
• Performing the Setups in the Applications 11i and R12 based on the BR100 and MD 120.
• Designed and developed extensions to iExpense
• Designed and developed the Oracle P-Card integration into Oracle AP. This also involved completing all configurations within Oracle AP.
• Designed and developed Employees / Assignments integration between Oracle HRMS and third party system.
• Functional consultant for PA CIP implementation in Netherlands. This included the project costing module.
• Solution architected PA CIP gaps, and assisted business in identifying business processes for their CIP process.
• Worked with third party IT team in testing customizations and standard functionality.
• Delivered MD50s, MD70s, and code development for converting POET for Project Billing and Project Costing.
• Delivered MD50s, MD70s, and code development for interfaces to the Project Billing and Project Costing expenditures.
• Delivered MD50s, MD70s, and code development for interfaces to the Procurement Contracts
• Modules: Oracle Project, Project Costing, Project Billing, iExpense, HRMS, Payroll, OAB, Service Contracts, Purchasing, Procurement Contracts
• Release: R12.1.3

Confidential

Senior Techno-Functional - Oracle R12 ERP Implementation

Responsibilities:

• Reviewed 11i Forms and upgraded them to R12 with code modifications.
• Reviewed 11i Interfaces and upgraded them to R12 with code modifications. These involved changing APIs, adding additional validations, adding/removing API fields.
• Reviewed 11i Reports and upgraded them to R12 with code modifications. These involved changing the source table/view, modifying the columns, and generating the reports in XML Publisher.
• Designed and developed Oracle Requisition Approval, OTC process - Sales Order Lines Workflow, PO Create Documents, and PO Approval Workflows
• Designed and developed OTC process - OM Defaulting Rules
• Designed and developed iExpense defaulting rules
• Designed and developed Order Generation (Sales Orders) Hub - Sales Order Inbound Interface
• Designed and developed CUSTOM.PLL extensions for PO and OM
• Designed and developed two complex Oracle Reports.
• Implemented Oracle P-Card solution for the client. This involved configuring the payables credit card program, and then designing/developing the integration of the transactions into Oracle AP system.
• Configuration team member responsible for configuring Oracle PA, GL, AP, AR, and PO modules. Worked in maintaining configuration workbook.
• Worked extensively writing UNIX shell scripts, PL/SQL, and SQL scripts/packages in both 10g and 11g databases.
• Designed and developed an interface from third-party system to Oracle Manufacturing, Inventory, and Bills of Material modules.
• Designed and developed an extension which would send outbound notification to a third-party system when new Oracle Manufacturing orders were processed.
• Worked in a team to build ETL layer for OBIEE using Informatica. This involved understanding the Oracle EBS architecture, building queries to extract the data, and load it in OBIEE.
• Designed and developed interfaces to JD Edwards system
• Modules: OM, AP, PO, iExpense, iSupplier, iProcurement, HRMS
• Release: R12

Confidential, Chicago, IL

Senior Oracle Designer and Developer, Oracle R12 ERP Implementation

Responsibilities:

• Worked as a technical SME for an implementation from legacy mainframe systems to Oracle R12.
• Functional and Technical designs for Project Accounting conversions.
• Functional and Technical designs for PA Labor distribution.
• Functional Design documentation of GL conversion, AP Invoices integration / data migration, AP Suppliers conversion, and Purchase Orders data migration.
• Designed and customized/developed PO account generator workflow, Requisition account generator workflow, Requisition approval using AME, and two customized workflow for invoices payment processing.
• Designed and developed GL conversion.
• Designed and developed Inventory Items Conversion
• Designed and developed AP vendor’s conversion, AP invoices interfaces, and AP invoices data migration.
• Designed and developed purchase orders conversion.
• Designed and developed iProcurement extensions for generating requisitions/purchase orders.
• Designed and developed items conversion.
• Configuration team member responsible for maintaining configuration workbook and completing configurations in multiple R12 environments.
• Project Management: Drafted a comprehensive deliverables and work plan for all technical objects, for both onshore and offshore teams. Worked with both onshore and onshore developers for deliverables statuses, and provided weekly status to upper management.
• Modules: GL, AP, AR, FA, Project Costing, Project Billing, and INV modules customizations, 10g database.
• Release: R12

Confidential

Senior Designer and Developer, Oracle R12 ERP Implementation

Responsibilities:

• Worked as a technical SME for an implementation from legacy mainframe systems to Oracle R12.
• Responsible for designing and developing Supply Chain and Financial conversions, interfaces, and extensions.
• Designed and developed complex Order Management Order Interface, including MD50 and MD70.
• Designed and developed complex Sales Order Lines workflow, including MD50 and MD70.
• Designed and developed Items, Vendors, On-Hand Quantity, GL Journals, and Customers data migration, including MD50 and MD70.
• Designed and developed Interface Hub that was utilized by Inventory, Order Management, General Ledger, and Accounts Payables.
• Designing and developed conversions and interfaces of Service Contracts.
• Participated in design of TCA structure.
• Project Management: Technical lead responsible for delivery of 192 objects. Worked daily with 50 onshore and offshore developers for successful delivery of the deliverables. Worked with external data conversion and integration team to design, build, and deliver conversions and interfaces for mock conversion phases, and integration testing phases
• Modules: OM, INV, TeleSales, AP, AR, GL, Advanced Pricing, Service Contracts
• Release: R12

Confidential

Senior Designer and Developer, Oracle 11i ERP Implementation

Responsibilities:

• Designed and developed Oracle Projects conversion.
• Designed and developed Oracle Projects interfaces with five external systems.
• Designed and developed Oracle Projects to Fixed Assets capitalization extension
• Designed and developed Items conversions.
• Modules: Projects and INV

Confidential

Senior Designer and Developer, Oracle 11i ERP Implementation

Responsibilities:

• Designed and developed Employees, Jobs, Organizations, Positions, and Advanced Benefits conversions.
• Designed and developed interface between Oracle Advanced Benefits and a Third Party Payroll Service
• Utilized Noetix views to write Discoverer reports
• Designed and developed Customers, AR Invoices, Suppliers, AP Invoices, GL Journals, and Items conversions.
• Designed and developed Inventory Items interface utilizing Mercator, SmartDB, and WebMethods.
• Designed and developed Customers interface utilizing SmartDB and Mercator.
• Designed and developed Projects interface utilizing SmartDB and Mercator.
• Designed and developed conversions of Service Contracts
• Interfaced Oracle AR with External Tax System (Vertex)
• Modules: GL, INV, Projects, AR, AP, Service Contracts, HRMS and Advanced Benefits

Confidential

Technical Lead/Designer, Williams ERP Implementation

Responsibilities:

• Hands-on leadership of team of 10 developers
• Gathered AP Invoices, PO Conversion/Interface, RFS Conversion, Contracts Conversion business requirements
• Conducted CRP sessions with client to discuss and finalize AP and PO requirements.
• Design and Build Interface Gateway leveraged by GL, AP, AR, CE, PO, and INV modules.
• Design and Build Oracle Contracts Conversion
• Design and Build PO and RFS Conversion/Interface
• Design and Build AP Invoices Interface

Interface Lead

Confidential

Responsibilities:

• Hands-on leadership of team of 4 developers
• Analyze the current ML regional financial applications
• Gather business requirements
• Gap Analysis
• Design Interface Gateway for GL, AP, AR, and PO modules

Technical Team Lead

Confidential

Responsibilities:

• Hands-on leadership of team of 13 developers
• Gathered interface and conversion requirements
• Mapped and gapped clients business requirement and Oracle software.
• Wrote interface strategy document, interface/conversion design documents, developed and tested each interface and conversion
• The team was responsible for Suppliers conversion, Open AP invoices conversion, FA conversion, GL balances conversion, AP invoices interface, AR invoices interface, and GL journals interface. The team also customized Oracle check printing and AP discounts.

Confidential

Technical Team Lead

Responsibilities:

• Gathered interface and conversion requirements
• Mapped and gapped clients business requirement and Oracle software
• The team was responsible for FA conversion, GL conversion, Suppliers conversion, and AR invoices conversion.

Business Analyst/Lead

Confidential

Responsibilities:

• Liaison between Oracle Development and Confidential
• Played a key lead role in writing 22 enhancements for Oracle Network Logistics development team by leveraging knowledge of client’s network business, an in-depth understanding of PICS/DCPR, and Oracle NL.
• Mapped client’s business requirements and PICS/DCPR functionality with current Oracle NL functionality
• Worked on analyzing client “As-Is” network tracking processes and systems for a Fortune 500 Tele-communication corporation
• Lead/facilitated in the Network Asset Tracking (NAT) team field interviews, team sessions for gathering requirements, and documentation of the “As-Is” business
• Member of a small team responsible for designing “To-Be” process flows/narratives, business scenarios and scripts, key process indicators, business rules, GAP analysis and resolution, functional requirements, GAP analysis between Oracle’s Network Logistics and client’s requirements, future policies, and configuration
• Worked independently in configuring R11I Oracle Network Logistics and its integration with Oracle Inventory, Projects, Fixed Assets, and Purchasing for Conference Room Pilot (CRP).

Developer

Confidential

Responsibilities:

• Worked on gathering project requirements, developing reporting tools for the reconciliation of Management and Tax Books, writing test plans from project requirements, and performing module/system testing for a worldwide consulting firm.
• Designed and developed adequate custom tables, packages, and reports to assist client in reconciliation of their Management and Tax Books.
• Designed, constructed, and tested a methodology for the reconciliation tool, which required a thorough study of client’s Management and Tax data.
• Designed entity relationship diagram, tables, and several PL/SQL scripts.
• Worked extensively with the client.

Confidential

Oracle System Analyst/Developer

Responsibilities:

• implemented an upgrade of Oracle Financials from 10.5 character-based to 10.7 SmartClient for a Fortune 500 Tele-communication corporation
• Member of a small team responsible for upgrading and module testing of Project Accounting, Oracle Receivables, Oracle Payables, and General Ledger modules
• Worked independently on upgrading, writing test plans, and testing custom reports, interfaces, and PSA Billing Extension. Communicated and worked extensively with the client during all phases of upgrade.
• Performed analysis and design work for the implementation of Data Warehouse for a Fortune 500 Tele-communication corporation.
• Independently coded extraction and transformation process programs in PL/SQL. Created detail extraction, transformation, and design documents throughout the warehouse project.
• Performed analysis, design, construction, writing test scripts, and system test work for the implementation of Project Accounting Billing extension for a Fortune 500 Tele-communication corporation.
• Assisted in the database design, development of an entity relationship model, database table definition and field definition, PL/SQL stored procedures, database triggers, sequences, and indexes.
• Also responsible for designing and implementing the front end interfaces using Developer/2000 Forms
• Member of a small team to maintain and support the Production System for a Fortune 500 Tele-communication corporation
• Created, modified, registered, and tested both custom and standard Oracle Reports for Project Accounting, Accounts Payables, Oracle Receivables, and Fixed Assets Modules, and PSA Billing. Worked extensively with Oracle Database, Oracle Financials both GUI and character-based
• Performed Alerts, Interfaces, and Reports customization for a Fortune 500 Tele-communication corporation.
• Created Alerts using Oracle Alerts and created, registered, tested, and maintained interfaces using Forms 4.5, which included creating new tables, sequences, stored procedures, and views