SUMMARY:

• 8 years of experience with implementations, upgrade, development and maintenance of Oracle E-business EBS Applications.
• On L2 Visa. Have Employment Authorization Document EAD .
• Have extensive experience in developing and customizing objects in AP, PO, GL, AR, OM, INV, PA, HR and Services modules. Around 5 yrs of experience in Oracle Financials, 4yrs of experience in Oracle SCM in some projects I worked on both Financials and SCM .
• Expertise in applying AOL standards, BI Publisher, RDF reports, Interfaces, Conversions and PL/SQL scripts and Alerts.
• Have fair knowledge in Forms, OA Framework, Shell Scripting and Workflows. Used these in Upgrade and support projects.
• Extensive experience in complete software cycle from Analyze, Design, Development, Testing, Documentation to User Training.
• Have good R12 Implementation Experience in Oracle Financials. Built various reports using BI Publisher, conversions, interfaces and alerts in implementation projects. Worked with Clients and functional users in gathering requirements, analyzed design, worked on data-mapping, developed code, Unit tested and created documents.
• Have strong enhancement experience in OM and PO. Worked on Automating seeded Oracle flows such as Drop Shipment and Auto Receipt and Clients Quarter end automation. Have strong experience on O2C and P2P cycles
• Have Extensive Support experience in GL, AP, PO, AR, FA, OM and INV modules in Oracle R12 as well as 11g. Prioritized and analyzed issues, worked with functional resources or clients in gathering requirements, fixed code, customized objects and worked with DBA to migrate code.
• Worked on Documentation in all projects MD70 Technical , MD 120 Installation , Test Case Document and User Training Documents.
• Created SRs in Oracle Metalink in Support and implementation projects.
• Worked on R12 Implementation, 11i to R12 upgrade andOracle Apps 11i Support and enhancements projects.Around 3 years of experience in Oracle Apps R12.
• Solid management skills, demonstrated proficiency in leading and mentoring individuals to maximize levels of productivity, while forming cohesive team environments.

SKILLS

Operating Systems WindowsNT/95/98/XP, 2000 MS DOS, UNIX

Programming Languages SQL, PL/SQL, C, Java

ERP Solutions Oracle 11i, R 12. AP, PO, GL, AR, OM, INV, PA, HR and Services modules

Databases Oracle 9i,10g,

GUI Design Tools Oracle Forms 6i,FSG, Workflow, TOAD, SQL developer and Jdeveloper

Version Control Tortoise SVN, PVCS and Harvest

PROJECTS SUMMARY

Responsibilities:

• Analyzed complexity of tasks and dived objects among team.
• Helped in Designing and maintaining an Excel sheet for checklist of all the objects.
• Modified forms, packages and reports.
• Checked for objects that had the same change and grouped them. Explained the change to the team and documented the change and testing procedure so that the team could fix the objects quickly.
• Teamed and discussed with the functional member and the end users in understanding the functionality and participated in testing of my objects
• Updated technical documents of the modified objects.

Responsibilities:

• I worked on Implementation from Apr'2012 till Phase1 Go live in Dec'2012 and worked on Post production support till Mar'2013.
• Gather requirements, Analyze, create data mapping, provide gap analysis and develop solutions.
• Developed conversions Customers, Credit Cards and Transactions in AR module.
• Designed various reports using BI Publisher and BI Publisher bursting in AR, Purchasing and PA modules.
• Designed and developed Alerts in Purchasing module.
• Designed MD 70 and MD120 documents.
• Participated with the Functional team in preparing User Training Documents.

Responsibilities:

• I worked in Enhancements team and moved to support after completion of Enhancements.
• Gather requirements, analyze issues, design and develop or modify.
• Monitor and prioritize change requests.
• Developed Order Import Interface.
• Modified existing objects to incorporate new functionality in Pricing Module.
• Fixed various package that interface with B2B Functionality.
• Modified and Fixed package, reports and forms as mentioned by the support team.
• Learn Oracle functionality of the objects that I modified in various modules OM, AP, GL, AR, INV, HR to perform unit testing.
• Worked in Tuning existing custom Packages for better performance objects.
• Interact with DBAs, functional team and users during testing, change release and implementation.
• Created updated MD70 documents.

Responsibilities:

• Build packages for QLogicDropship automation, Quarter-End automation and Auto-Receipt automation.
• Build PL/SQL scripts for .net to interact with Oracle Apps database.
• Build scripts for planning, Order Organizer and Business rules screens of the new QLogic Web Entry System
• Create and Modify reports.
• Add additions functionality to PL/SQL scripts and views.
• Test the objects and functionality.

Responsibilities:

• Clopay upgraded to R12 in 2008
• Deal with issues that had to be resolved in 4hrs time. Monitor and prioritize issues Concerning Sales Order entry, booking, holds, pick release, Shipping, Inventory
• Assigned tickets to off-shore
• Check ticket Issues count and manage tickets and co-ordinate with offshore so as to reduce ticket count.
• Coordinate with offshore and business users.
• Analysis of issues originating from R12 implementation.
• Technical Support/Solution for the issues Bug fixing for custom developed forms and reports .
• Functional support for clopayHelpd desk Distribution centers and Manufacturing plants.
• Unit test code changes.
• Prepare Design/Installation, test case and User training documents.
• Oracle TAR problem reporting and tracking.

Responsibilities:

• Develop Purchase Orders interface, Item Conversion, AP Invoice Interface, FA import.
• Customization of PL/SQL scripts and reports using reports 6i and XML Publisher based on client requirement.
• Analyze requirement from users and decide on man-days
• Design data flow and document MD70, Test case document and MD120
• Perform unit testing of the data flow from Legacy system to Purchasing then to AP-GL-FA
• Create and follow up SRs with Oracle.
• Preparation of weekly and monthly reports for project monitoring and maintenance
• Maintaining all the source codes and documents with the modified versions in VSS.