SUMMARY:

• An Oracle Apps Techno Functional Consultant with nearly 14 years of rich experience in Project Management, Oracle Applications Development and System Maintenance.
• Experience in developing interfaces between various legacy systems and data loadings on Oracle based databases.
• Proficient in Oracle Applications starting from gap analysis to development, testing and production move.
• Expertise in developing interfaces and conversions for various entities like Items, POs, PO Receipts, Vendors, Banks, Customers, etc.
• Adept in end - to-end development of software products/projects from inception, requirement specs, planning, designing, implementation, documentation and closure with cross-cultural teams.
• Well versed with Oracle PL/SQL, Unix Shell Scripting, C and Oracle Apps.
• Strong organizer, motivator, team player and a decisive leader with successful track record in directing from original concept through implementation to handle diverse market dynamics.

TECHNICAL SKILLS:

Languages: Oracle PL/SQL, Unix Shell Scripting, C.

Operating Systems: Windows 98/2000/NT, UNIX, Linux.

Software/Tools: Oracle E-business suite, GEMMS (Global Enterprise and Manufacturing Management System), Metalink, Autosys, TOAD, VSS, Track-it, Powerbuilder, Business Objects, Microsoft Outlook, Lotus Notes

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Team Lead

Technologies: Oracle 9i, PL/SQL, Oracle Apps, Unix Shell Scripting, Kintana, PVCS, Support Central.

Responsibilities:

• Providing quotes and scope documents for new projects that come from the business users.
• Having discussions with the users to understand the requirements and finalising the scope.
• Assigning tasks to the team and handling quality management activities and take care of the project management.
• Taking care of Tollgates for various deliverables and making sure that timely delivery of the products.
• Working on the enhancements for GEHC business requirements for various interfaces.
• Mapping client’s requirements and coordinating in implementing processes in line with the guidelines specified by the client in ORACLE 11i environment
• Understanding business process, study and analyse to design solutions.
• Participating in technical and functional review meeting.
• Coordinating with the Development Team for development / customisation of software.
• Handling Oracle Application Implementation at client location in USA on the following modules; PO, INV, AP, AR & HR Management.
• Working closely with the Database team to create and modify procedures, functions and packages for different functionality modules as per business rules.
• Identifying, analysing defects.
• Documenting, tracking, & communicating test plans, results, analysis, & unresolved problems using test management tool.
• Managing smooth implementation and testing of the application at client location.
• Extending post go-live and application maintenance support to the client.
• Responsible for managing customer, Oracle implementation at client site.

Confidential, OHIO

Programmer Analyst

Technologies: Oracle 7/8/9i, PL/SQL, Oracle Apps, Unix Shell Scripting, Pro*C, PowerBuilder, Autosys, VSS, Toad and Java.

Responsibilities:

• Discussing with the end users and the functional groups to do the gap analysis as part of Oracle Apps project planning.
• Converting the data from the legacy systems into Oracle Apps environment for entities like Items, Customers, Purchase Orders, PO Receipts, Banks and Suppliers. Took care of cleansing and validating the data.
• Responsible for managing Oracle Applications setup activities like Subinventories, Inventory Organisations, Locators, Lockbox, Numbering schemes, etc.
• Maintenance and support of the Oracle Applications modules - Inventory and Purchasing
• Developing the interfaces between Oracle E-Business suite and legacy systems for Items, Standard Costs, POs, PO Receipts, Vendors and customers.
• Creating the Autosys scheduling jobs for the batch jobs that will run on regular intervals and monitoring the job stream for any failures and fix them.
• Analysing in creating a permanent solution to improve the processes.
• Handling change requests of users and implementing the solutions for legacy systems like GEMMS, Datawarehouse, etc.
• Developing to an extranet website Abrasivesnet.com in changing the content and layout of the customer home page.

Confidential

Developer and Team Leader

Responsibilities:

• Responsible for handling maintenance requests coming from the users for GEMMS and developing the interfaces between GEMMS, Data warehouse and I2.
• Assigning the change requests to the team members and performing the code reviews.
• Preparing the unit test plans and unit testing.
• Handling project management activities and regular quality audits.
• Co-ordinating with the onsite team members in finalising the requirements for the new development requests and participating in user testing.

Confidential

Developer

Technologies:PL/SQL, Unix Shell Scripting, Pro*C, Toad

Responsibilities:

• Analysing the requirements for new interfaces.
• Designing and constructing the codes.
• Preparing unit test plans and performing the testing.

Confidential, Pittsfield, MA

Developer

Technologies:PL/SQL, Unix Shell Scripting, Pro*C, C

Responsibilities:

• Understanding the process of different current purchasing systems of Confidential sites.
• Gathering the requirements for the new interfaces to replace the Plant & Equipment module.
• Preparing the functional and technical specifications for the new interfaces.
• Construing the codes, preparing the test plans and performing unit testing.
• Co-ordinating with the team members to ensure proper integration testing is done.

Confidential

Developer

Technologies:PL/SQL, Unix Shell Scripting, Business Objects.

Responsibilities:

• Understanding the business terms related to the Confidential and relating to the data warehouse terminology.
• Analysing the requirements for the new reports and enhancements.
• Building the business objects reports and testing.
• Writing the shell scripts for the scheduled jobs.
• Monitoring the production job schedule.