SUMMARY:

• Over 13+ years of Techno - Functional expertise on end to end implementation of Oracle-EBS application (Ver.11i, R12) covering Oracle Distribution and Finance modules.
• Modules worked on - Oracle Projects, Order Management, Shipping, WMS, Inventory, Purchasing, Pricing Account Payables, Account Receivables, Cash Management, i-Procurement, Oracle AME, Fixed Assets, PDH & General Ledger.
• Expertise include Consulting, Solutioning, Integrations, Design, Maintenance and Support with special s to Reports, SOA Interfaces, Conversions, Extensions, Localizations and API modelling.
• Strong technical forte on PLSQL, Developer 10g- Forms, Reports, BI Publisher, Oracle Workflows, Oracle Application Framework, Oracle Fusion Middleware, UNIX, Python, Perl scripting and Goldengate.
• Extensively worked on SQL Performance Tuning using SQL Trace facility, TKPROF diagnostic tools.
• Hand on Methodologies include Agile Scrum, Hybrid Agile, Oracle Unified methodology, Iterative and Waterfall.
• Worked on Oracle Unified Method (OUM), Application Implementation Methodology (AIM) to support complete enterprise IT life cycle.
• Strong knowledge of SDLC, Application Lifecycle management, Version controls and change management processes.
• Responsibilities include requirements gathering, functional and technical design, development, review, unit/ system/ integration testing, post production support, onsite-offshore co-ordination.

SKILLS:

Software: Oracle e-Business Modules Order Management, Shipping, WMS, Inventory, Purchasing, Pricing, Receivables, Payables, Oracle Projects, Fixed Assets, General Ledger, i-Procurement, Cash Management, Oracle AME.

Software/Tools: SQL Developer, Toad, Forms and Reports Developer 10g, Workflow Builder 2.6, OAF, BI Publisher, SFTP, SQL Loader

Databases: Oracle 9i and 10g,12.1.0.2,Hadoop

Programming Languages: Unix shell scripting, PL/SQL, C, C++ & Java, Perl, Python

Version Control and Release: Appworx, PVCS (Polytron Version Control System), Microsoft Visual Source Safe (VSS), SVN, KINTANA, GIT hub, Jenkins

Bug Tracking System: JIRA (Atlassian), ALM, HP Quality Centre

EXPERIENCE:

Developer/Software Engineer

Confidential, Plano TX

Responsibilities:

• Identified the problem statement, gathered the requirements by interacting with the Business and designed the Application Design Document.
• Designed and developed the solution and scripts for Data Extraction and Migration from Oracle, PDH to Hadoop and Vertica.
• Worked with multiple cross functional teams involved in the project to implement the solution.
• Implemented OUM Methodology for the entire implementation lifecycle.
• Contributed to future state technical solution based on the Strategic initiatives and functional architecture.
• Worked on a hybrid agile methodology and participated in daily scrum stand-ups to address deliver the key components and address the bottlenecks.
• Used SVN tool for Configuration Management of code repository and deliverables and worked with Client for Code deployment using Jenkins.
• Involved in resolution and effective closure of defects raised during E2E testing by Functional team and Business Users using ALM tool.
• Supported the business users during pre-prod and Post Go Live Support.
• Analysis and solution for performance improvement of system.

Confidential

Lead Developer, Consultant

Responsibilities:

• Designed and developed various Interfaces like Sales Order OB to RP WMS system from Oracle, Sales Order IB Interface from WMS, Purchase Order OB, AP Invoices IB, Inventory Adjustments, and Inventory Stock Status IB between Oracle and Third-party systems, using PLSQL in coordination with Fusion Middleware team working on SOA.
• Contributed to Legacy data conversion as part of the Data Migration Strategy.
• Performed Impact assessment for the key design of CEMLI’s components.
• Implemented OUM Methodology for the entire implementation lifecycle.
• Contributed to future state technical solution based on the Strategic initiatives and functional architecture.
• Worked on a hybrid agile methodology and participated in daily scrum stand-ups to address deliver the key components and address the bottlenecks.
• Prepared DS140, TE20, CV10, CV27, IM90 documents based on OUM methodology.
• Designed and developed Remittance Advice Report, AR Customer Balance report using XML Publisher.
• Worked on GL - User Rate type forms Personalization.
• Designed and developed Custom Workflows namely PO acknowledgment and Changes, ASN Inbound to Oracle.
• Involved in preparation of Data templates for Conversion entities from SCM, FIN modules and co-ordinated with the client for data extraction, cleansing and loading from legacy systems to Oracle.
• Designed and developed PLSQL packages, technical objects required for data conversion of various entities like open AR, AP invoices, Fixed assets.
• Used SVN tool for Configuration Management of code repository and deliverables and worked with Client for Code deployment using Jenkins.
• Involved in resolution and effective closure of defects raised during E2E testing by Functional team and Business Users using ALM tool.
• Supported the business users during pre-prod and Post Go Live Support.
• Analysis and solution for performance improvement of system.

Lead Developer

Confidential

Responsibilities:

• Performed Impact analysis on the R12 enhancements along with participated in Requirements Gathering on selected modules.
• Lead Developer in the Offshore team of 5.
• Designed and developed PLSQL packages and technical objects as per the requirements of the functionality involved in OLFM module.
• Co-ordinated with the fusion middleware team for integration of PLSQL objects with the SOA services.
• Worked and co-ordinated with ADF team for design of front end screens based on ADF technology as PLSQL knowledge is essential for designing queries.
• Performed E2E testing with the Functional, Middleware team to test the Business functionality of the requirement.
• Worked on GIT hub for Version control in the project.
• Analysis and solution for performance improvement of system.
• Responsible for Review of the deliverable before submission to client.
• Responsible for identifying and resolving project risks, issues and problems.
• Providing development and testing estimates
• Prioritization of tasks.

Confidential

Lead Developer

Responsibilities:

• Involved in Business Requirements Gathering for the reports to be developed.
• Designed and developed BI Publisher Reports.
• Mentored a team of 4, provided constant support and worked through the different phases of project for the effective realisation of project deliverables
• Worked on SVN for Version control in the project.
• Used KINTANA for Code Migration.
• Involved in design, development and deployment of Dollar U deliverables
• Analysis and solution for performance improvement of system.
• Responsible for Review of the deliverable before submission to client
• Responsible for identifying and resolving project risks, issues and problems
• Providing development and testing estimates
• Prioritization of tasks.
• Consistently following of Quality Processes followed by the company.
• Constantly mentored the team to able to produce project deliverables of good quality.
• Business Induction of New Joiners.

Confidential

Lead Developer

Responsibilities:

• Performed Impact analysis on the R12 enhancements along with participated in Requirements Gathering on selected modules.
• Analysis and solution for performance improvement of system.
• Designed and developed PLSQL packages, customized Requestor Change Order Approval Workflow.
• Responsible for Review of the deliverable before submission to client
• Worked on SVN and KINTANA for version control and Code migration respectively.
• Responsible for identifying and resolving project risks, issues and problems
• Providing development and testing estimates
• Prioritization of tasks.
• Consistently following of Quality Processes followed by the company.
• Constantly mentored the team for the effective realisation of the deliverables.

Confidential

Lead Developer

Responsibilities:

• Performed Impact analysis on the R12 enhancements along with participated in Requirements Gathering on selected modules.
• Designed and developed PLSQL objects, customized reports, forms based on Oracle developer 10g.
• Analysis and solution for performance improvement of system.
• Responsible for Review of the deliverable before submission to client.
• Responsible for identifying and resolving project risks, issues and problems
• Providing development and testing estimates.
• Prioritization of tasks.
• Consistently following of Quality Procedures and Processes followed by the company.

Confidential

Lead Developer

Responsibilities:

• Performed Impact analysis on the R12 along with participated in Requirements Gathering on PA sub modules like Project Costing, Budgeting, OTL.
• GAP Analysis and solution for performance improvement of system.
• Preparing high level solution documents for the identified gaps.
• Discussions with Client IS team on technical/functional feasibility on suggested solutions.
• Designed and developed PLSQL program for Data migration of Oracle Projects, project structures, tasks, resources from legacy system to Oracle.
• Handling the Development, Unit Testing, IT testing and Go-Live activities.
• Involved in both implementation and Post Go-Live support.

Confidential

Techno Functional Consultant

Responsibilities:

• Understanding the GAIA Interfacing solution and GAP Analysis has been done between existing financial system ( Confidential Companies) and IFRS system.
• Preparing high level solution documents for the identified gaps.
• Discussions with Client IS team on technical/functional feasibility on suggested solutions.
• Presenting the solution to business users over conference call and identify gaps if any.
• Acted as a Window between Confidential Japan IS and TIP IS in understanding the solution and helped them in identifying the gaps between overall solution and local customizations.
• Resource Planning and project schedule till Go-Live.
• Preparing Project Proposal (Timeline, Project Plan, estimates and costs).
• Handling the Development, Unit Testing, IT testing and Go-Live activities.

Confidential

Tech Lead

Responsibilities:

• Supported the Finance Modules (AP/AR/GL/CM/Iprocurement/IExpense) from offshore location.
• Quick resolution of the bugs.
• Tracked the defects and resolution.
• Handling the Change requirements for new business requirements. Identifying the gaps.
• Preparation of schedule for the new enhancements and developments and ensuring the delivery on time.
• Coordinating with the onsite team on the change requests.
• Coordinating with the client for month end closure.

Confidential

Tech Lead

Responsibilities:

• Provided solution for customizations and High-Level Solution document preparation.
• Developed the interface and conversion scripts for OM/PO/WMS/Shipping/Pricing/ AR/AP/GL modules.
• Involved in solution discussions for customizations of modules.
• Resolved technical issues related to PL/QL, Oracle Forms, Reports, Workflow., Business Induction of new joiners.
• Handled Go-Live and Post Go-Live Support.

Programmer Analyst

Confidential

Responsibilities:

• Provided solution for customizations and High-Level Solution document preparation.
• To support the System implemented on Oracle Applications Technology by handling various Technical as well as Functional Issues in Order Management module.
• Resolved technical issues related to PL/QL, Oracle Forms, Reports, Workflow.
• Coordinated the Onsite, Offshore Activities.
• Prepared Activity diagrams and State-chart diagrams.
• Retrofitted baseline BRDs to accommodate requirements across various regions.