We provide IT Staff Augmentation Services!

Technical Lead Resume

Columbus, IN

SUMMARY:

  • An accomplished Technology Lead having around 8 years of experience, specializing in Oracle Apps implementation with extensive exposure in full life cycle of the Apps implementation process including requirements, prototyping, proof of concept, design, interface implementation, testing and support.
  • Understanding business process/requirements and translating them into technical requirements.
  • Expertise in developing Inbound and Outbound Interfaces and Conversions.
  • Expertise in developing Oracle Forms, Oracle XML Publisher Reports, RDF reports, Oracle Workflow, XML bursting and Form Personalization of Oracle Applications.
  • Proficient in writing PL/SQL stored procedures, AOL objects, alerts, implementing RICE components and Software Development Life Cycle (SDLC).
  • Expertise in developing Real Time Interfaces using Oracle Business Events.
  • Expertise in tuning of SQL Queries for performance improvement using TKPROF/Trace and AWR Reports.
  • Worked on all financial modules which includes AP, AR, GL, CM, PO and have exposure on AGIS, FA, CP modules.
  • Worked on Web service Intergration with Middleware through Web - service calls and developing API’s for Middleware Fusion and ODI Interfaces including Inbound and Outbound.
  • Experience in requriements gathering, functional gap analysis, application design, configuration, testing and support.
  • Experience in preparing Technical Design Documents (MD070), Technical Test Documents (TE020) and Migration Documents (MD120).
  • Good experience in preparing field level mapping documents for integration with MW and Edge systems
  • Experience in Production Support after Go-Live which includes resolving production issues, interacting with end user, proactively monitoring issues and fixing production issues.
  • Had exposure on Oracle Advanced Queues, publish subscribe mechanism and queue propagation using DB links to interact with Middleware.
  • Expertise in implementing Change Requests (CRs) in existing components.
  • Trained in OAF, WebADI and ADF.
  • Analysed Oracle patches using Panaya tool.
  • Excellent Programming, Analytical and Communication skills.
  • Self-motivated, proactive, flexible and dedicated to complete the work with stipulated time frame and manage multiple task assignments.
  • Passionate to learn new technologies, good problem solving skills and ability to grasp things quickly.

TECHNICAL SKILLS:

Language/Tools: C, PL/SQL, Toad, SQL Developer, Putty, Winscp, SQL*Plus, PanayaBMC Remedy, IBM Clearcase.

GUI/Oracle Tools: Oracle Forms Builder, Oracle Reports Builder, Oracle Workflow

Builder: BI Publisher, XML Publisher Reports

Databases: Oracle 12c, 11g, 10g.

Operating Systems: Windows 10/8/7/XP/NT/2000/98/95

ERP: Oracle Applications E-Business Suite (EBS) R12.

PROFESSIONAL EXPERIENCE:

Technical Lead

Confidential, Columbus, IN

Responsibilities:

  • Designing, developing and unit testing of RICE components which includes integration with various source/edge systems.
  • Developed API’s for Middleware Fusion, ODI Integration in various flavours for Inbound and Outbound Interfaces.
  • Developed Cross Validation Rules Outbound, AP Invoice Inbound/Outbound, GL Journal Inbound/Outbound, Bank Statements Inbound through file, Customer Master Outbound, Code Combinations Outbound, Segments and Currency Rates Outbound, PO Receipt Inbound, EDI Invoice Inbound, PO Receipt and AR Invoice Reconciliation Outbound and involved in many other interfaces design/development which includes standard Oracle programs to import data.
  • Developed numerous custom XML Publisher and RDF Reports in almost all financial modules.
  • Developed Extension components which include Oracle Forms, Oracle Workflows, Form Personalizations and XML Bursting.
  • Customized number of standard Reports, Workflows and Forms.
  • Worked on Proof of Concept (POC) for multiple requirements.
  • Reviewing and enhancing Technical Design Documents and Code developed by team members.
  • Implemented performance improvement changes for many components.
  • Worked on sending Customer Statements to customers in different languages set at customer site level via E-mail using XML bursting.
  • Supporting UAT sessions and involved in GO-live cutover activities.
  • Implementing Change Requests (CR) in existing components.
  • Anchoring Technical Design Reviews, Code Reviews with DBA, preparing Migration documents for ensuring smooth migration of code to CRP/UAT/PROD Instances.
  • Performing BU IT (Business) reviews with Client for finalizing Technical Design solutions.
  • Worked on subledger accounting tables.
  • Involved in discussions to understand the business requirements for providing better solution inline with client expectations.
  • Co-ordinating with offshore team for day to day activities.
  • Responsible for analyzing patches using Panaya tool.
  • Preparing technical requirement specifications, technical design, coding, testing, change documentation and maintenance of client knowledge repository.
  • Mentoring team members and providing required training/KT to newly joined members in the team.
  • Involved in interface end to end testings with edge systems.
  • Working in Multi-Vendor Environment to integrate with various systems.
  • Worked in agile mode for adhoc requirement changes and for emergency production issues.

Technical Analyst

Confidential, Columbus, IN

Responsibilities:

  • Worked on development of reports, interfaces in various modules such as Account Payables, General ledger, Account Receivables.
  • Involved in preparing Technical design documents.
  • Documented unit test cases for all possible scenarios of the components.
  • Involved in end to end testings with source/edge systems.
  • Supported UAT sessions.
  • Conducted Code reviews for better tuning of queries & Performance Improvement for all deliverables.
  • Worked on TCA API’s and tables for customer/site creation, updation.
  • Worked on Proof of Concepts (POC) for multiple requirements for finalizing solution.
  • Developed Customer Inbound Interface where customer data is interfaced from other system to ERP.
  • Reviewing and enhancing code developed by team members.

Technology Analyst

Confidential

Responsibilities:

  • Designed and developed AP Invoice Inbound interface from third party systems like ARIBA.
  • Worked on fixed payment formats for various banks such as BOFA, Chase across globe.
  • Worked on PO Approval Workflow for Purchase Order Approvals.
  • Customized many standard reports as per business requirements.
  • Involved in unit and integration (end to end) testings.
  • Involved in UAT sessions and resolved issues found in UAT.
  • Developed XML Publisher Reports in various modules such as Account Payables, Account Receivables and General Ledger.
  • Mentoring newly joined team members in their development activities.

Technology Analyst

Confidential

Responsibilities:

  • Developed API’s for Middleware Fusion, ODI Integration in various flavours for Inbound and Outbound Interfaces.
  • Developed AP Invoice Inbound/Outbound, GL Journal Inbound/Outbound, Bank Statements Inbound through file, Cross Validation Rules Outbound, Customer Master Outbound, Code Combinations Outbound, Segments and Currency Rates Outbound, PO Receipt Inbound, EDI Invoice Inbound, PO Receipt and AR Invoice Reconciliation Outbound and involved in many other interfaces design/development which includes standard Oracle programs to import data.
  • Developed numerous custom XML Publisher and RDF Reports.
  • Developed Extension components which include Oracle Forms, Oracle Workflows, Form Personalizations and XML Bursting.
  • Designing, developing and unit testing of RICE components which includes integration with various source/edge systems.
  • Customized number of standard Reports, Workflows and Forms.
  • Worked on Proof of Concept (POC) for multiple requirements.
  • Reviewing and enhancing Technical Design Documents and Code developed by team members.
  • Implemented performance improvement changes for many components.
  • Implementing Change Requests (CR) in existing components.
  • Anchoring Technical Design Reviews, Code Reviews with DBA, preparing Migration documents for ensuring smooth migration of code to CRP/UAT/PROD Instances.
  • Preparing technical requirement specifications, technical design, coding, testing, change documentation and maintenance of client knowledge repository.
  • Involved in interface end to end testings with edge systems.
  • Worked in Multi-Vendor Environment to integrate with various systems.

Developer

Confidential

Responsibilities:

  • Involved in technical design for the requirements/Change Requests(CR).
  • Developed AR Invoice Inbound and did unit testing for the same.
  • Analyzed existing code and documented business logic behind it for re-implementing.
  • Drafted test scenarios covering all possible boundary conditions, positive and negative cases.
  • Involved in POC (Proof of Concept) for multiple requirements.
  • Involved in interface end to end testings with source/edge systems.
  • Worked on subledger accounting tables.
  • Implemented Form Personalization for standard screens.
  • Preparing code files, migration documents for ensuring smooth migration of code to CRP/UAT/PROD Instances.
  • Developed reports in various financial modules.

Hire Now