Data Conversion/technical Lead Resume
EXECUTIVE SUMMARY
- Having 9+ years of experience in Oracle applications (Oracle EBS) as a Techno functional consultant with strong exposure to oracle financials, SCM and core HRMS modules.
- Worked on various types of oracle apps projects (R12 implementations, R12 Upgrade, R12 Support/Maintenance 11i Implementations and 11i Support/Maintenance).
- Strong development skills with oracle PLSQL, UNIX Programming, Oracle apps, Oracle reports, XML Publisher Reports, Oracle forms, Oracle workflow, AME and Oracle Web ADI.
- Proficient in technical aspects of oracle applications customizations, Reports, Interfaces and Data Conversions.
- Experience in conversions from legacy system to oracle modules AP, AR, GL, PO, OM, INV, HRMS and Core Contracts using PLSQL, SQL Loader.
- Experience with all phases of SDLC - Requirement Gathering, Application Development, Testing (Unit, Integration and User Acceptance), Performance Tuning, Deployment and Production Support.
- Developed Reports using BI Publisher tool (XML Publisher).
- Working Knowledge in Oracle Financials, SCM and core HRMS modules.
- Have strong exposure to P2P (Procure to Pay) and O2C (Order to Cash) cycles.
- Experience in performance and tuning (PL/SQL) using Cursor Variable, Bulk Collect/Bind, Apply Index and Hints in queries after Analyze, Explain Plan, interpret trace files with TKPROF.
- Extensive experience in Application Object Library (AOL), System Administration for Registration of Forms, Reports, other concurrent programs.
- Handled the technical team more TEMPthan 8 members.
- Strong analytical and problem solving skills, Ability to work independently and lead teams.
- Ability to organize and coordinate multiple tasks, builds strong customer relationships, and communicates effectively with all levels of an organization.
TECHNICAL SKILLS
ERP: Oracle Applications R12 (12.2.3), 11i (11.5.10)
APPS Modules: Oracle payables (AP), Oracle Receivables (AR), General Ledger (GL), Purchase Order (PO), Order Management (OM), Oracle Inventory (INV), Shipping Execution (WSH), Core HRMS, Core Contracts, AOL, System and Workflow Administration
Databases: Oracle 11g/10g/9i
Tools: Developer 2000, TOAD, SQL Developer, SQL*Loader, Web ADI,XML/BI Publisher and Workflow Builder 2.6.3
Programming: SQL,PL/SQL, Shell scripting
Change Management: MS VSS and Tortise SVN
Operating Systems: MS Windows 7/XP/2003, Unix
Migration: FNDLOAD, WFLOAD
PROFESSIONAL EXPERIENCE
Confidential
Data Conversion/Technical Lead
Responsibilities
- Provide overall technical conversion guidance and manage conversion scope
- Involved in writing/reviewing technical spec (MD070), Test plan (TE020) and migration documents (MD120).
- Perform work planning and assign tasks to offshore developers and designers for the below data conversions
- Resolve technical and design issues in conversion area
- Developed Journal import inbound interface.
- Developed Outbound interface for journal extract to Hyperion
- Developed custom GL Reconciliation Report as per business need.
- Assist with the coordination of Process Team for Data Preparation and Validation activities
- Review the deliverables(Technical Designs, Code and Unit testing documents)
- Customized Supplier approval workflow/AME as per business need
- Developed Supplier conversion
- Worked on outbound interfaces(Supplier, PO, Contracts) for other verticals
- Worked on inbound interfaces(Requisition and Invoice)
- Developed reconciliation queries/Scripts used for post conversion load data verification.
- Developed and reviewed unit test plans for the custom RICEFW objects
- Involved in the functional test scripts execution
- Developed several custom reports using XML Publisher in PO and AP modules
- Involved in the data validation and data cleansing activities.
- Involved in Integration testing, User Acceptance testing and GO-Live Activities.
- Monitor and report technical conversion status
- Execute and Manage Mock Data Conversions
- Monitor production run for data conversions
- Lead the Technical team of 12 members and involved in RICEFW development/review
- Involved in writing technical designs, Test plans and migration documents.
- Reviewed the RICEFW components Technical Design, Build, UTP and migration documents
- Estimate the build efforts for the RICEFW components and CR's.
- Responsible for the RICEFW deliverables in Purchasing, Payables and Receivables modules.
- Developed custom oracle forms to maintain the contracts information, Post Dated Cheque details and Revenue Recognition scheduling details.
- Developed AR invoice and Credit Memo reports
- Modified the standard customer statement report as per business need.
- Developed custom WebADI to import the customer payment checks
- Acted as Single POC for the all the technical issues during the UAT and GO - Live
- Provided Knowledge transition to the Client IT team about all the custom objects and the interface frame work developed.
- Involved in developing technical Proof of concepts (POC’s) in AR Lock box line level application and forms customization
- Coordinating with Oracle on the Service Requests (SRs) for any patches needed from them to fix bug in the Oracle's seeded functionalities.
- Responsible for the code migrations to the ST, SIT, UAT and Production environments
- Helped the client IT team to validate the inbound data file format and involved in data cleansing activities.
Confidential
Technical Lead
Responsibilities
- Lead the Technical team of 3 members
- Functional design phase support
- Customized Sales order line workflow to achieve the below business requirements
- Done the POC for the complex extensions and workflow changes in SCM before publish the solution to the business.
- Estimate the efforts for the new components and CR's in technical perspective.
- Taking transition of the Functional designs
- Responsible for the deliverables timelines, code review and defect fixes.
- Reviewed all TDD's, Code and unit test plans done for the below RICEFW components
- Involved in helping the functional team to finalize the data templates for interfaces.
- Lead the Technical team of 6 members.
- Gather requirements, provide data mapping for the interfaces from legacy systems and get those verified by business analysts before design freezing.
- Done the POC for the custom extensions in PO, INV, OM, AP, AR and PA modules.
- Modified the Technical documents (MD070) and Test plans (TE020) as per the R12 data model.
- Reviewed all Technical designs, Code and unit test plans for Recompile and Retrofit components.
- Responsible for the deliverables timelines and defect fixes.
- Created SQL scripts to verify the upgraded data verification.
- Created SQL scripts for custom RICEFW components migration verification.
- Developed the common migration script to migrate the custom RICEFW components.
- Attend daily status call to update the current status of offshore work and next steps.
- Analyzed and provided defect categorization after completing each testing phase(PT, SIT and UAT) with root cause/explanation.
- Involved from design phase to till go-live and support.
Confidential, UK
Technical Consultant
Responsibilities
- Functional design phase support.
- Involved in writing technical design (MD070), Test plan (TE020) and migration documents (MD120).
- Technical designs (Authored and Reviewed)
- Developed Banks and Branches conversion using public API’s
- Developed BACS payment formats e-text outbound interface for Barclays bank.
- Developed form personalization in AP invoice screen to put the custom hold during invoice validation as per business need.
- Customized the standard Customer statement report in Receivables which involves modifying the standard queries within the XML file, changing the layout, adding custom fields.
- Customized the standard PO Requisition Approval Workflow to customize the standard escalation functionality.
- Provided Post Go-Live support
- Taking transition of the Functional designs.
- Authoring of Technical designs, unit test plans and migration documents
- Developed Customer inbound Interface in Receivables using public API’s.
- Developed Supplier inbound Interface in Payables using public API’s.
- Developed BI Publisher EFT report (eText - Outbound) payment files for JP Morgan and UniCredit Banks.
- Customized the Purchase order workflow and standard PO output template.
- Provided Post Go-Live support
- Implemented SOX deficiency count file validations to the existing Item Categories, Price List and AR invoice interfaces.
- Implemented detailed posting in GL to provide the required additional information to the GLA (BI Tool) through custom interface.
- Involved in GL detailed posting load testing and performance testing.
- Prepared test scripts and executed in Quality Centre.
- Involved in system integration and User testing.
- Given the KT to the users and support team.
- Provided post go-live support.
Confidential
Technical Consultant
Responsibilities
- Implemented purchase order interface to import standard and blanket release purchase orders from legacy system.
- Implemented receipt interface to import new receipts, correction and return to vendor transactions from legacy system.
- Developed the PO and Receipt interface error reports using XML publisher.
- Implemented form personalization to default the destination organization in PO requisition screen as per the OU.
- Prepared technical design documents for PO and Receipt interfaces.
- Prepared installation scripts for the custom RICEFW components
- Registration of concurrent programs and request sets
- Involved in system integration testing and user testing.
- Given the KT to the support team.
- Provided post go-live support.
- Provided the production support for the issues in Purchase orders, Receipts, ASN, Inventory
- Items and sales orders in PO, INV and OM modules.
- Provided the production support for issues in custom modules Global exchange services (GXS) and custom module Installation and warranty (me&W).
- Provided the production support for the interfaces in PO, INV, OM and custom modules.
- Given KT to the new members in the team.
- Worked as Track lead to the support team for custom module me&
- Developed Employee and Address Conversions in HRMS.
- Developed Customer item interface in Inventory.
- Added Menu Entry to the Purchase Order form to run the "Print Purchase Orders" seeded report using Form Personalization.
- Prepared technical design documents and unit test cases
- Registration of concurrent programs and request sets
