[59235] in SAPr3-news
Excellent Oracle apps technical consultant available
daemon@ATHENA.MIT.EDU (Anshita@dgntechnologies.com)
Mon Apr 16 14:49:19 2007
To: sapr3-news@mit.edu
Date: 16 Apr 2007 11:49:08 -0700
From: "Anshita@dgntechnologies.com" <ansh.jalan@gmail.com>
Message-ID: <1176749348.556104.299730@l77g2000hsb.googlegroups.com>
Subodh Shetty____________________________ Oracle Applications
Technical Consultant
SUMMARY
Over 7 years of extensive experience in System analysis, design,
development, system support maintenance using Oracle databases and
Oracle Applications Release 11i. Special Emphasis on production
support to existing systems, troubleshooting of live issues, Analyzing
patches and its application and testing. Translate user systems needs
into alternative technical solutions, User trainings and regressing
testing. Change control management. Requirement Analysis, Mapping and
GAP analysis, Module Setups, System Administration, and Customization
to standard oracle objects. Participation in after-hours technical
support by rotating call schedule on a regular basis. Excellent
communication, correspondence and reporting skills.
Expertise Includes:
=B7 Five years of extensive experience in System analysis, design,
development, system support maintenance using Oracle databases and
Oracle Applications Release 11i.
=B7 Expertise in INV, Order Management, BOM, PO, AP, AR, GL, Oracle
Service, Customer Support, WIP and iStore.
=B7 Provided Production Support for Manufacturing modules (INV, PO, BOM,
WIP, Order Management) & Financial modules (GL, AP, AR).
=B7 Perform Purge & Archive of obsolete data using a combination of
Oracle standard API and custom code.
=B7 Preparation of Requirement analysis, Mapping and Gap analysis for
enhancements to existing releases,
=B7 Setups in Oracle Inventory, Oracle Work In Process
=B7 Provide System Administration functions such as Setup custom
responsibilities and menu structures as per the guidelines of Sarbanes-
Oxley.
=B7 Participated in DBA activities, User creation, roles assignment,
granting and revoking privileges.
=B7 Applied modifications to Rel 11i standard oracle Install Base
program using Advance Queuing to filter orders from getting installed
in Customer Products on a specified condition.
TECHNICAL SKILLS:
Oracle Modules : 11i INV, PO, Order Management WIP,
BOM,
AP, AR,
GL, Oracle Alerts, System Administration
Development Environment : Oracle 8i, Reports 6i, Forms 6i, PLSql,
SQLPlus,
SQL
Loader, Pro C, DB Workbench, Discoverer,
C, C++, VC++, Visual Basic,
MFC, Microsoft Frontpage,
Lotus Notes, Domino Doc, Domino Designer
Operating Systems : UNIX, Linux and Windows NT
4=2E0
WORK EXPERIENCE:
Currently Working
Jan-07 Cisco Systems, Inc. Technical Analyst
=B7 Integrated tax data from acquired companies into AP/AR production
tables using API's.
=B7 Developed pl/sql package and utl_file to load merit review data to
temp tables and used API's to import into Oracle AP/AR application.
=B7 Created and linked elements to maintain data for SABRIX TAX PROGRAM
and fringe benefits.
=B7 Wrote pl/sql packages to calculate TAX and developed concurrent
program to call these package.
=B7 Developed PL/SQL Interface program for SABRIX TAX PROGRAM.
=B7 Ongoing production support for all of the above.
Environment: Oracle AR/AP Modules, PL/SQL, SQL, SQL Loader, utl_file,
TOAD, SQL Navigator
=B7 Developed an Interface to load manually entered GL Journal Accrual
Entries into Projects.
=B7 Designed and developed BOM Actual and Planned Report to compare the
cost and the Components of BOM and the WIP Jobs.
=B7 Extensively involved in the Conversion project of consolidation of
Sets of Books.
=B7 Designed and developed a program to convert Bill Rate Schedules of
Project Accounting.
=B7 Created an interface program to convert purchase orders.
=B7 Analyze, design and develop enterprise-wide application functional
solutions to meet the business and users requirements.
=B7 Evaluate user and departmental requests gather business requirements
and prepare gap analysis.
=B7 Researched solutions for business requests and present functional
and technical options to enhance operational effectiveness and reduce
cost. These solutions could include modifications to the set up and
configuration/enhancement of existing modules, implementation of new
Oracle modules or business process reengineering.
=B7 Provide functional support, reporting, conversions, interface
support and training for all Oracle Apps end-users.
=B7 Collaborate with business users, other IT technical resources and/or
Oracle Support to troubleshoot problems and resolve applications
issues.
=B7 Perform configuration and setup work to support new and existing
functionality; function as resident team expert for all configuration
issues within their areas of expertise.
=B7 Design, plan and conduct functional testing to minimize production
issues. Develop and maintain test scenarios for project team and end
users.
=B7 Recommending the best practices to the management to increase
efficiency and functionality and ensure the compliance with SOX.
=B7 Review code developed by contractors for accuracy, quality and
adherence to coding standards.
=B7 Global Support to the Users on day-to-day functional issues on
Financials.
=B7 Working with Oracle Support for resolving Critical and Transactional
Issues
=B7 Preparing Functional Documents for Report Customizations
May-05 - Sep-06 Virsa Systems, Fremont, CA Technical Analyst
=B7 Development of programs and procedures to detect major gaps in
Procure to Pay , Order to cash and Financial Accounting business
areas.
=B7 Code written would report gaps as per SOX compliance and industry
specific regulations.
=B7 The front end product would take input and relay its data to the
back-end programs for data delivery in XML format. Other duties
include testing of programs on other versions of Oracle Applications
for scalability.
=B7 Provide technical and functional solutions to user community.
=B7 Develop system documentation for any change.
=B7 Provide training to user community.
Apr-04 - Mar-05 Dell Inc, Round Rock, TX Technical Analyst
=B7 Provided Production Support for Manufacturing modules (INV, PO, BOM,
WIP, Order Management) & Financial modules (GL, AP, AR).
=B7 Troubleshoot user issues and problems on a daily basis.
=B7 Provide users with prompt solution.
=B7 Coordinate issues on TAR's to oracle support and analyze patches
required to fix issues.
=B7 Provide technical and functional regression tests in light of patch
application to production copy.
=B7 Deploy Oracle Alerts to proactively monitor system.
=B7 On-call and month-end support to Production Database.
=B7 Provide development or enhancement of custom objects to accommodate
custom process and its testing as per the user requirement.
=B7 Provide System Administration functions such as Setup custom
responsibilities and menu structures as per the guidelines of Sarbanes-
Oxley.
=B7 Perform Purge & Archive of obsolete data using a combination of
Oracle standard API and custom code.
=B7 Monitor system performance from System Administration and build
alerts to notify abnormal activity.
=B7 Support Physical Inventory activity. Prepare and maintain
documentation of regression tests, custom development and change
control.
=B7 Roles to Implement AR, GL and FA and few part of AP
End
=B7 User training & Preparation of Documentation relating to
modules,Preparation of User manual for end user, Preparing Functional
Documents for Report Customizations
Dec-03 -Mar-04 Xerox Corporation, Stamford, CT Technical Analyst
=B7 Provided Production Support on manufacturing and financials
modules. Modification and Maintenance of existing shell scripts ,
Packages , procedures and Custom Interface programs.
=B7 Preparation of Requirement analysis, Mapping and Gap analysis for
enhancements to existing releases,
=B7 Development of Reports and forms,
=B7 Ensuring smooth run of custom interfaces which transfer data
between Oracle and legacy systems.
=B7 Applied modifications to Rel 11i standard oracle Install Base
program using Advance Queuing to filter orders from getting installed
in Customer Products on a specified condition.
=B7 Modules worked on INV, Order Management, BOM, PO, AP, AR ,
GL ,Oracle Service , Customer Support , WIP and iStore.
Jun-03 - Nov-03 New Zealand Dairy Milk , New Zea Land. Technical
Analyst
=B7 Job involved support to Core Manufacturing Implementation team.
=B7 Solving Paclog Issues , AOL Setup, Mapping and GAP Analysis .
=B7 Conversion of Inventory Onhand Quantity from legacy system to Oracle
10.7 SC GUI.
=B7 Conversion of Customer Items from legacy system to Oracle 10.7
GUI.
=B7 Completed AR Module Setup .
=B7 Modules involved AR, INV, OE and PO. Solving Paclog Issues.
=B7 Design and Development of Reports. Prepared AIM Documentation for
Manufacturing Modules.
Sep-02 - Apr-03 Symbios Logic , Santa Clara, CA Technical Analyst
=B7 Job involved Post Production Support for Oracle Manufacturing and
financial modules.
=B7 Complete Requirement Analysis, Mapping and Gap Analysis, Conversion
Specification and its translation into PLSql programs, User Training.
=B7 Preparation of Test Scenarios,
=B7 System Testing with Converted data.
=B7 Setups in Oracle Inventory, Oracle Work In Process.
=B7 Modules interacted and worked upon: AP, AR, PO, INV, BOM, QA, WIP,
OE, Oracle Service, AOL and System Administration.
Jan-02 - Jul-02 Unocal Energy, Sugar Land, TX Technical Analyst
=B7 Provided technical support on Oracle Energy on the Inventory Module,
Development of Custom Reports,
=B7 Registration of Reports.
=B7 Provided technical support for conversion of data from MIMS system
to Energy Inventory.
=B7 Developed enhancements to suit client requirement. Modules
Interacted with INV, PO, GL, FA, AP, System Administration,
Application Object Library.
May-00 - Ja-02 NIIT Ltd - Reserve Bank of India, Mumbai Software
Developer
=B7 Developed application for Reserve Bank Of India's Department Of
Banking Operations and Development, World Trade Center, Mumbai.
=B7 Participated in preparation of test plans for Banking modules.
=B7 Created user manuals and technical support documents.
=B7 Provided Implementation support.
=B7 Prepared a database design document based on the functional and
technical specifications.
=B7 Prepared user interface and its technical document based on the
Functional specifications and current system.
=B7 Involved in design and development of database.
=B7 Designed and Created database objects.
=B7 Created database triggers.
=B7 Responsible for Designing and Developing User interactive Forms
(screens), developed packages and procedures in PL/SQL.
=B7 Developed complex Reports in Report Builder 3.0 of Developer 2000
Application development was completed using Oracle 8 and Developer
2000 (Forms 5.0,Reports 3.0), Designer 2000, Lotus Notes.
May-00 - Jan-02 NIIT Ltd - Rashtriya Chemicals & Fertilizers Ltd,
Mumbai Software Developer
=B7 Responsible for generating complex Reports in Power Builder and
testing the application.
=B7 Technical assessment of modules and preparation of technical
documents. Preparing Functional and Program Specification Documents.
=B7 Developed Stored Procedures, functions and triggers.
=B7 Fine Tuned the SQL queries using hints for maximum efficiency and
performance.
=B7 User Training and technical support.
=B7 Preparation of backup and recovery plans.
=B7 Participated in DBA activities, User creation, roles assignment,
granting and revoking privileges.
=B7 Development was completed using Oracle 8 environment with
Powerbuilder
May-00 - Jan-02 NIIT Ltd - GLAXO India Pvt Ltd, Mumbai Software
Developer
=B7 Requirement analysis and its translation into technical design.
=B7 Maintenance and support of client databases.
=B7 Created and maintained technical documentation for all changes
incorporated.
=B7 Development of database triggers for data security within the
application.
=B7 Developed Packages and procedures to be called by Visual Basic
modules.
=B7 Development of reports using Business Object Reporting Tools.
=B7 Optimizing SQL queries for higher performance.
=B7 Provided user training at various company locations.
=B7 Development was completed using PL/SQL and Oracle Developer 8i.
EDUCATION:
Bachelor of Commerce - Accounting
GNIIT - Systems Management
Oracle DBA Training
Oracle Financials Training
References: Available upon request.
