EXPERTISE SUMMARY
w Over 10 Years of Development
and Consulting experience in Oracle Applications.
SKILL SETS
Operating Systems : MS-Dos, Solaris, Linux, Windows NT/2000/XP,
HPUX
SKILL SETS
|
Finance
|
Manufacturing
|
Service
|
Others
|
|
General Ledger
|
Purchasing
|
Service Contracts
|
Project Accounting
|
|
Payables
|
Inventory
|
Service Request
|
HRMS
|
|
Receivables
|
Bill of Material
|
Installbase
|
Property Manager
|
|
Fixed Assets
|
Work in Process
|
Depot Repair
|
Order Management
|
Tools/Utilities : - Oracle
Forms and Reports 4.5/ 6i / 10g
-
Oracle
Discoverer 4i / 10g, Oracle Workflow 2.6
-
Hyperion
BRIO Interactive Reporting
-
XML
Publisher Reports, Oracle Alerts
-
WEB
ADI, Linux / Unix Shell Scripting
-
Oracle
SQL*Loader, FNDLOAD, UTL_FILE
EDUCATION SUMMARY
w Master Science (MSc)
in information Technology from Vinayaka Mission Research Foundation, Salem,
India
w Bachelor
of Commerce from Osmania University,
India
EXPERIENCE SUMMARY
- Implementation
of Advanced Supply Chain Planning and Demantra for Deckers (Oracle
Applications Version 12.1.3)
- Manage the
Support, Enhancements and Defects related to Supply Chain Planning, Supply
Plan Sourcing and Purchase and Manufacturing.
- Manage PLM
Integration Support (Enhancements and Bug Fixing)
- Manage Product
Serialization (Fresh Implementation).
- Lead the team
for Upgrading Oracle Applications
Version from 11.5.10 to 12.1.3 for MasTec Corporation (MNS, MWS and NSORO Service Lines)
- Upgradation and Go-Live Support of Oracle Applications Version from
11.5.10 to 12.1.3 for RandStad
- Lead the Technical
team for Implementation of Oracle Project Accounting for Haemonetics Corporation (Oracle Applications 11.5.10)
- Fixing and
Enhancements of Service Contract and Preventive Mainenance for Haemonetics Corporation (Oracle Applications Version 11.5.10)
- Technical Lead
for Implementation of Blanket Sales Agreement Reports and workflow for
Amendment for Haemonetics
Corporation (Oracle Applications Version 11.5.10)
- Techno-Functional
Support on Oracle InstallBase, Service Request, Service Contract, Depot
Repair, Order Management, Inventory modules for Haemonetics Corporation (Oracle Applications Version 11.5.10)
- Techno-Functional
Support and Enhancements on Order Management, Projects, Payables, WIP, BOM
for Cobham
Defense Electronics System (Oracle Applications Version 11.5.10).
- Development and
Customization of Discoverer Reports for AAI Corp (Oracle Applications Version 11.5.10)
- Implementation
of Daily Business Intelligence in modules Financials, Account Receivables,
Account Payables, Procurement, Inventory, Supply Chain for Ramsey Winch (Oracle
Applications Version 11.5.10)
- Development and
Customization of Discoverer Reports in Order Management and Quality
Modules for Brooks
Automation (Oracle Applications Version 11.5.10).
- Technical and
Functional Support for Seachange
(Oracle Applications Version 11.5.9)
- Implementation
of Daily Business Intelligence in modules Financials, Procurement and
Development and Customization of reports for Butler Manufacturing (Oracle Applications Version
11.5.10)
- Customization
Order Header, Order Lines, Workflow for Task Manager Workflows for TallyGenicom
- Implementation and Development of
Workflow, General Ledger Interface,
Developer 2000 Reports in Financial and Service Modules for Fullerton Financial Holdings, Dubai (Oracle Applications
Version 11.5.10)
- Implementation and Development of
Interfaces, Workflow (Account Generator), Reports in GL, AP, AR and FA
modules for Air
India, Mumbai, India (Oracle Applications Version 11.5.10)
- Upgrading Oracle applications
from 11.5.7 to 11.5.10 which has major custom components like 11
Interfaces with other legacy systems and Purchase order Approval workflow
for GE (Oracle Applications Version
11.5.7 to 11.5.10)
- Study and Documentation of Legacy
systems for integration with Oracle Applications for World Health Organization, Republic of Congo (Oracle
Applications Version 11.5.10)
- Implementation and Development of
Reports, Workflow, Forms, Integration and interface in module Oracle
Property Manager for Dubai Muncipality (Ta’jeer), Dubai (Oracle Applications
Version 11.5.10)
- Upgrading Oracle Applications
from 11.0.3 to 11.5.9 and Implementation and development of Oracle
Discoverer Reports for Wataniya
Telecom, Kuwait (Oracle Applications Version 11.5.9)
- Implementation and Development of
Workflow (PO Approval, PO Account Generator, Req Account Generator,
Supplier Invoice Account Generator, Expense Report Account Generator),
Development of forms, developer 2000 reports, Discoverer reports for Balfour Beatty Plc, UK (Oracle
Applications Version 11.5.9)
- Design and Development of Sql
Reports and testing the reports in Oracle applications for Agilent Technologies Inc, India
(Oracle Applications Version 11.5.7)
- Development of Forms, Reports and
Workflow in custom module for Oracle
Corporation Ltd, Bangalore, India (Oracle Applications Version 11.5.9)
- Development and customization of
Reports in Financial Modules (GL, AP, AR, FA)
for AstraZeneca
Pharma Ltd, Bangalore, India (Oracle
Applications Version 11.0.3)
- Development and Customization of
forms, Reports and Upgrading Oracle applications from 10.0.7 to 11.5.7 in
modules OM, BOM, WIP for Solectron,
CA (Oracle Applications Version from 10.0.7 to 11.5.7)
- Implemenation and Customzation of
Open Financials, development and customization of forms, report and
interfaces for B.D.Mehta
Mahavir Hear Institute, Surat, India
PROJECT EXPERIENCE IN DETAIL
Sunera
Technologies
Goleta, CA,
USA
Deckers, CA, USA (Apr’12 – Till Date)
ENVIRONMENT: 12.0.1
MODULES:
Advance
Supply Chain Planning, Purchasing, Inventory, Material Planner, Supplier
Collaboration, Demantra
Responsibilities
included
Ø
Leading
Technical team for the entire Advanced Supply Chain Planning Project.
Ø
Project
Includes major Interfaces between EBS to Demantra, ASCP to Demantra, Product
Family Ratio Interface from Demantra, Forecast Set Interface from Demantra,
Consolidated Forecast Interface. Few Forms like Buy Plan Adjustment form,
Pre-Load Adjutment form.
Ø
Custom
interfaces also include Item Attribute Updates, Item Category Assignment,
Approved Supplier List Interface, Assigning Assignment Set to Sourcing Rule
Ø
Customization
in Supplier Collaboration – Build OAF Page for uploading the interface document
from web page and interface the changes in the Purchase Order. Build a Custom
Workflow to send approvals based on changes made.
Ø
Understand
the Requirement from the functional consultant, prepare MD070 and make sure
development team is able to follow and code based on requirement.
Ø
Reviewing
the Development, Testing and coordinating the functional Testing.
Ø
Make
sure development team is following all the client standards without missing the
development target date.
Ø
Optimizing
the programs to run in minimal time by using index hints and creating index on
the custom tables.
Ø
Fixing
the bugs / issues in minimal time based on workload on the team with the
ongoing development activities
Ø
Make
sure all the components has MD070 (Technical Document), TE040 (Test Case
Documents), MD120 (Migration Document)
Ø
Conduct
Weeky meeting between team to discuss status, issues and Project Status
Centium Consulting Inc
Chelmsford,
MA, USA
MasTec, GA, USA (Apr’11 – Mar’12)
ENVIRONMENT: 12.0.1
MODULES:
General
Ledger, Accounts Payable, Accounts Receivable, Inventory, Purchasing, Fixed
Assets
Responsibilities
included
Ø
Leading
Offshore team, Testing the Development, Make sure development team is following
MasTec Development and Naming Standards and Help build Custom Inventory
Solution.
Ø
Changing
the architecture of custom migration for re-usable in different service lines
(Operating Units).
Ø
Understanding
the Custom Program in 11.5.10 Instance and prepare an documents to make the
object reusable across the Service Lines / Operating Units
Ø
Preparing
CV040 for all the conversions (Customers, Vendors, Items, Item Categories, Open
Payable Invoices, 1099 Invoices, Open Receivables Invoices and Partial
Payments, Approved Supplier List. Open Purchase Orders, Open Requisition,
Inventory Balances).
Ø
Development
and Supporting custom Scanner Transaction, Receiving process
Ø
Development
of Custom Inventory Physical Count. Development component Includes
·
Uploading
Scanned Inventory Physical Count File to Staging Table.
·
Comparing
Physical Count to oracle count and generate 4 different reports (Summary
Report, report for non-serialized, report for serialized item and Report for
Missing Serial Numbers)
·
Reports
generated in the earlier step can be modified and upload into the oracle with
inventory stock corrections.
·
Validate
the corrections and do the changes (Stock Overage or Stock Deplete) based on
the changes.
Ø
Development
of Inventory Item Conversion, Onhand Conversion, Approved Supplier Conversion
and Purchase Order Conversion (Full Open and Partial Open)
Ø
Testing
and reviewing the code and providing review comments to the developers if fails
and pass on for Functional Lead Testing and User Testing if succeeded.
Ø
Understanding
the Integration points between Siebel Work Order System and Oracle Applications
and helping functional lead to prepare required documents.
Ø
Managing
Developed / Migrated code in Version Control Software.
RandStad, MA,
USA (Feb’11 – Mar’12)
ENVIRONMENT: 12.0.1
MODULES:
General
Ledger, Accounts Payable, Account Receivables
Ø
Responsibilities
included production support and Development Customizations in 12.1.3.
Ø
Development
of Check Printing and FTP the output of the concurrent program to the Network
Path
Ø
Development
of Positive Pay and FTP the output of the concurrent program to the Network
Path
Ø
Development
of Nacha and FTP the output of the concurrent program to the Network Path.
Ø
Debug
and Fix WEBADI for uploading General Ledger Journal Entries
Ø
Fixed
the Issue with the Column Set, Displaying error at the time of Querying and
scroll.
Ø
Fix
the Custom Report which got migrated to 12.1.3 and not working as intended.
Haemonetics,MA (Oct’10
– Apr’11)
ENVIRONMENT: 11.5.10
MODULES: Oracle Project
Accounting, Oracle Service Contract, Account Receivables, Oracle Inventory,
Oracle Alerts
Ø
Responsibilities
included Development of Project Service Request Workflow, Writing Billing
Extensions, Customizing Project and Budget Workflow, Customizing Quality
Assurance Check list in Service Contract Module, Creating Auto Accounting
Lookups in Projects and Developing Custom BRIO Reports
Ø
Development
and Customization of Project Approval Workflow.
Ø
Development
and Customization of Budget Approval Worflow.
Ø
Coding
and Testing of Billing Extensions
Ø
Developed
Query for Auto Accounting Lookups in Projects Module.
Ø
Developed
Mechanism for which few of the changes in Project and Task forms will send
emails to the Users using Oracle Alerts and Oracle Workflow.
Ø
Development
of Custom Hyperion BRIO Reports (Deferred and Unbilled Revenue Report, Time and
Approval BRIO Report, Master Data Audit Report, etc…)
Ø
Testing
of Complete Flow from Oracle Projects to Account Receivables and General
Ledger.
Ø
Documenting
MD050, MD070, TE020, MD120 for the development and customization
Ø
Worked
on Forms personalization for making few field mandatory and restrict Users of
bypassing business flow.
Ø
Worked
on Performance Tuning to increase the performance of the Reports, pl/sql and
sql
Haemonetics,MA (Feb’10
– Oct’10)
ENVIRONMENT:
11.5.10
MODULES:
Service Contract, Service Request, Project Accounting, Install Base, Depot
Repair, Order Management, Oracle Inventory
Responsibilities:
As
a Technical Lead, I am responsible for
Ø
Fixing
issues with Service Contract Approval Workflow
·
Because
of some issue with seeded Service Contract Approval Worflow and Contract Alert
Workflow notifications for approval are going to unknown users who are not yet
all related to service contract.
·
Identified
a patch that has been applied for the same reason and issue is happening for
the contracts created before that patch application date.
·
Provided
Custom Code which fixes the issue
·
Tested
with different scenarios after running custom code.
·
Documented
the findings, changes and provided to user.
Ø
Enhancement
/ Debug Preventive Maintenance (Service Contract / Service Request)
·
Fixed
the setup issues and runtime issues of Preventive Maintenance
·
Fixed
the issues with Build Unit Effectivity which helps to pull record from service
contract and insert in ahl_unit_effectivities_b table.
·
Fixed
the issues with “Preventive Maintenance Generate Service Requests and Tasks”
which creates service request by referring to ahl_unit_effectivities_b table.
·
Prepared
Test Scenarios and technical documentation.
Ø Implementation of
Blanket Sales Order Reports.
·
Design
and Development of Java file to bring additional datasource in BSA Reports.
·
Design
and Development of Blanket Sales Agreement (XML Publisher) which will be
executed from “Preview and Print” of the Blanket Sales Order Form.
·
Preparing
Technical Document for the database components and xml publisher reports.
·
Preparing
migration document for migrating from development instance to test instance to
production instance.
Ø Functional Support on
Oracle InstallBase, Service Request, Service Contract, Depot Repair, Order
Management, Inventory.
Cobham
Defense Electronic Systems, Landsdale, PA (Sep’08 – Feb’10)
ENVIRONMENT: 11.5.10
MODULES: Accounts Payable,
Project Accounting, Purchase Order, Depot Repair, Order Management, Oracle
Inventory, Work in Process, Bill of Material
Ø
Created and
Tested Crystal Reports
(Buyer Workload Dynamic Page Source, Current Week OWL, Open Allocation
for Stockroom Report, Open Purchase Order Report, Move orders report, Tool
Stores Demand-Supply Report
Ø
Build
alert system for the long running and errored concurrent requests which sends
emails to the support staff.
Ø
Corrected
the Payroll file generation package which was not calculating as required.
Ø
Customization
for incorporating CIP Account generation for PO, PA, AP Account Generators.
Ø
Support
and Enhancements has been made in Cost of Sales and Revenue Event Interface.
Ø
Provided
technical solution for few of the forms using Forms Personalization
Ø
Customization
of Bills of Material Form using CUSTOM.pll
Ø
Build
and tested two custom mapping form which would be used in the validating BOM,
PO and Requisitions
Ø
Customization
and Changes of XML Publisher reports (Purchase Order and RFQ reports).
Ø
Debugging
the Labor Costing Extension in Oracle Projects.
Ø
Worked
on few customization in Delivery Tracking System in Oracle Projects
Ø
Provided
solution generating of specific accounts when capitalizing Oracle projects
Ø
Customized
Project Costing Client Extension and Project Transaction Client Extension.
Ø
Forms
personalization has been done on Project Contracts screen to make a term
mandatory based on business requirement and sorting of Delivery Tracking
Records using personalization
AAI Corp,
Baltimore, MD (Sep’09 – Feb’10)
ENVIRONMENT: 11.5.10
MODULES: Purchase Order,
Order Management, Oracle Inventory, Work in Process
Ø
Development
/ Customization of Discoverer Reports and SQL Reports
·
Few
of the discoverer reports include Material Received Not Stocked Report, Daily
Receiving Report, Daily PO Status Report.
·
Customization
of Backflush Material Requirement Report. This report gives output in Microsoft
excel.
Ramsey Winch
Company, Tulsa, OK (May’09 – Sep’09)
ENVIRONMENT: 11.5.10
MODULES: Purchase Order,
Order Management, Oracle Inventory, Work in Process
Responsibilities:
As
a Project Lead, I am responsible for
Ø
Setup
Daily Business Intelligence for Financial
(Profit
and Loss and Profit and Loss by
Manage, Account Receivables, Account Payables)
Ø
Setup
Daily Business Intelligence for Manufacturing
(Procurement,
Inventory, Supply Chain)
Ø
Prepare
setup documents
Brooks Automation –
Chelmsford, MA (Dec’08
– Feb’09)
ENVIRONMENT: 11.5.10
MODULES: Quality, Order
Management
Ø
Created
Discoverer Report and Graph on Revenue/Margin Report (AR)
Ø
Created
Discoverer Reports and Graphs on Quality Reports
(Failure Category & Failure Mode, 24
Month Returns & 24 Month QPPM Report, OBQ Trend & OBQ QPPM Data)
Seachange,
Acton, MA (Apr’08
– Apr’09)
ENVIRONMENT: 11.5.9
MODULES:
Accounts Receivables, Service Contract, Order management
Responsibilities:
As
a Technical Project Lead, I am responsible for
Ø
Customization
of Service Contract Budget Reports
Ø
Customization
in Quality Assurance custom Checks
Ø
Customization
of Service Contract Approval workflow
·
Customizing
the workflow to eliminate a confirmation notification to approver after
notification approval
·
Including
Timeout option for the contract signing notification
·
If
Contract Signer has not responded and notification timed out then signing
authority should be given to approver i.e., signing notification should be sent
to Contract Approver.
Ø
Demonstration
of WEB ADI to the users.
Ø
New
Development of Discoverer report for Oracle Contract (Revenue Distribution
Report)
Ø
Preparing
Technical and Installation Documentations.
Butler
Manufacturing, Kansas City, MO (Jan’08
– Oct’08)
ENVIRONMENT: 11.5.10
MODULES: General Ledger,
Account Payables, Account Receivables, Purchasing,
Ø
Setup
Daily Business Intelligence for Financial
(Profit
and Loss and Profit and Loss by
Manager)
Ø
Setup
Daily Business Intelligence for Procurement
(Procure to Pay, Procurement Management,
procurement Status, Commodity Spend and
Commodity
Supplier)
Ø
Customization
and Development of reports and interfaces
Ø
Preparing
MD070 Technical Documentation
Ø
Preparing
MD080 Installation Documentation
TallyGenicom,
Waynesboro, VA (Jan’08
– Nov’08)
ENVIRONMENT: 11.5.10
MODULES: Order Management
Ø
Customization
of Order Header and Order Lines Workflow for certain requirement
·
Order Header
Workflow: Customization
has been made to carry information from Service request module to Order Header.
·
Order Line Workflow :
Customization of Order Line Workflow for
setting up the Order Management workflow for Non-Shippable Items
Ø
Customization
of “Workflow for Task Manager”
·
Initiate
a Concurrent Requests from the workflow which sends an e-mail to the task
related task owners.
Ø
Training
of Oracle Workflow 2.6 for the Team members.
Ø
Preparing
Technical and Installation Documentations
Satyam Computer Services Ltd
Fullerton
Financial Holdings, Sheik Zayed Road, Dubai (May’07
– Dec’07)
ENVIRONMENT: 11.5.10
MODULES: General Ledger,
Account Payables, Accounts Receivables, Fixed Assets, Oracle Treasury
Responsibilities:
As
a Finance Technical Lead, I am
responsible for
Ø
Closely
working with the team and functional analyst for making the team understand
about the functionality
Ø
Developed
a custom workflow for Service Request Module
·
Trained
team member about developing and customization of Workflow.
·
Helped
Subordinate in Workflow Designing and developing
·
Workflow Development
Details:
Custom Workflow has been developed to send a notification to the Available
Technical Person in the company based on service request severity, hierarchy
and availability. Workflow has been designed to call from a custom form
Ø
Interacting
with the team and make sure that development and customization is in the
correct shape
Ø
Estimating
of time for the development or customization of objects.
Ø
Developed
Other systems to GL interface
Ø
Developed
interface to transfer finance data to Data warehouse and OFSA
Ø
Developed
few custom reports.
Ø
Reviewing
the code and documentation.
Ø
Need
to confirm about the following of Satyam standards in all objects and the
documentations.
Satyam Computer Services Ltd
Air India Financial
Implementation, Mumbai, India (Dec’06
– Apr’07)
ENVIRONMENT: 11.5.10
MODULES: General Ledger,
Account Payables, Accounts Receivables, Fixed Assets, Cash Management
Responsibilities:
As
a Technical Project Lead, I am responsible for
Ø
Monitor
the Object Tracking sheet for tracking of timelines and deadlines of the
Development Objects
Ø
Attending
calls frequently with Onsite functional consultants and with client when ever
required.
Ø
Closely
working with the team and functional analyst for making the team understand
about the functionality
Ø
Worked
on the Fixed Assets Account Generator
·
Assigned
“Generate Category Level Account” Process as default process for all assets.
·
Changed
the “Assigning value to Segment” node attribute “value” to pick accounts from
distribution ID
Ø
Trained
6 developers in oracle applications (Technical) and Satyam standards on
Interfaces, Reports
Ø
Interacting
with the team and make sure that development and customization is in the
correct shape
Ø
Reviewing
the code and documentation.
Ø
Make
sure that SATYAM standards have been followed by the team.
Ø
Estimation
of time for the development or customization of new object
GE Consumer products
GE Consumer Product
Upgrade Project Begumpet, Hyderabad (Mar‘06
to Nov’06)
ENVIRONMENT: 11.5.10
MODULES: Purchasing, Inventory,
Account Payables
Responsibilities:
As
a Delivery Lead, I am responsible
for
Ø
Upgrading
Oracle Application from 11.5.7 to
11.5.10
Ø
Monitor
the Project Management Track Sheet for tracking of timelines and deadlines of
the project
Ø
Attending
daily and Weekly calls for updating the project status to the client
Ø
Worked
on Customization of PO Approval workflow
·
GE
Consumer Services has concept of Purchase Order sub types which was configured
as one of the PO Header Attributes (DFF). Purchase Order Approval has been
customized based on the PO Subtypes and has been separated different approval
paths for each sub type.
Ø
Closely
working with the team and functional analyst for making the team understand
about the functionality
Ø
Interacting
with the team and make sure that development and customization is in the
correct shape
Ø
Reviewing
the code and documentation.
Ø
Need
to confirm about the following of GE standards in all objects and the
documentations.
Ø
Estimation
of time for the development or customization of new object
Satyam Computer Services Ltd
World
Health Organization (WHO), Republic of Cango (Nov’05 to Feb’06)
Environment:
11.5.10
Responsibilities:
As a System Analyst, I am responsible
for
Ø Finalize
the list of current systems being used across the organization and the
interfaces between these systems;
Ø Examining
the current interfaces if there is any commonality.
Ø Define
the list of permanent and temporary interfaces and map those into Oracle APIs
and Open Interfaces;
Ø Map
the current systems into Oracle modules defining which systems will be replaced
and which will remain;
Ø Define
an architecture strategy that minimizes the number of custom interfaces
Ø Refine
the list of environments
required for this region.
Satyam Computer Services Ltd
Implementation
of Property Manager (Ta’jeer) (Mar’05
to Oct’05)
Dubai
Municipality, Dubai
ENVIRONMENT: 11.5.10
MODULES: Oracle Property
Manager, Accounts Receivables
Responsibilities:
As a Technical Lead, I am responsible
for
Ø Requirement
Gathering for Development of 6 Custom Workflows
Ø Requirement
Gathering for Integrations with the other Dubai Municipality Services
Ø User
Acceptance for the gathered requirement
Ø Preparing
Technical Documents for the Workflows and Integrations
Ø Development
of 6 new workflows
(New Tenancy Title,
Renewal, Title Change, Title Transfer, Unutilized, Termination)
·
Requirement:
Property Lease applicant has to apply for lease online in
Dubai municipality online website along with the required documents attached.
Through an asynchronous interface data used to interface to the custom objects
in Oracle Applications instance. A workflow should be started immediately and
send notifications to the approval authorities along with the attached documents
as workflow notification attachments.
·
Workflow Notifications have been
designed for displaying the notification content in English and Arabic.
·
In the notification process, a
notification will goes to all of the board members for voting and based on the
voting lease decision will be made.
·
Lease approval and rejection is based
on the Lease approval workflows
Ø Performed
workflow Administration and Development Training to the Technical Team in Dubai
Municipality.
Ø Development
of Integrations with other DM Services
(Fines and Penalty
systems, E-Services, SMS, CRA and GIS)
Ø Developed
a Custom Component to transfer attachments from E-Portal to Oracle Applications
database and display the attachments in Workflow Notifications using Java
Stored Procedures and Oracle Package.
Ø User
Acceptance Test (UAT) from users
Ø Data
Migration for Customer, Locations and Leases in Production Instance
Ø Development
of few Employee Performance and Management Reports.
Satyam Computer Services Ltd
Wataniya Telecom,
Kuwait (Oct’04 to Mar’05)
ENVIRONMENT: 11.5.9
MODULES: General Ledger,
Accounts Payable, Account Receivables, Fixed Assets, Purchasing, Inventory,
Cash Management
Responsibilities:
As a Technical Lead, I am responsible
for
Ø Oracle Applications Upgrade from
11.0.3 to 11.5.9
Ø Preparing
Technical Impact Analysis, Technical Assessment documents to provide before
starting upgradation.
Ø Helped
team member by explaining the concepts and usage of workflow builder for
customizing Self Service Human Resource Workflows.
Ø Followed
Technical steps in upgrading mentioned in Upgrade Assistance sheet.
Ø Followed
the same steps in 3 Iterations and Production.
Ø Upgrading
existing forms 4.5 to 6i using flint60.
Ø Upgrading
reports from 2.5 to 6i
Ø Preparation
of Unit Test Scripts for the upgraded objects
Ø Testing
existing interfaces. Few interfaces exist to pull data into Requisition,
Inventory, Cash Management and General Ledger from legacy system.
Ø Understand
Discoverer Report Requirement from user and Assign Reports to the associates
and helping them to deliver the reports in time.
Satyam Computer Services Ltd
Balfour
Beatty Plc., UK (Jan’04
to Oct’04)
ENVIRONMENT: 11.5.9
MODULES: Purchasing, Account
Payables, Accounts Receivables, Oracle
Projects
Responsibilities:
As a Module Lead, I am responsible for
Ø Analysis
of the specifications provided by the client.
Ø Design,
Development and Testing of workflow.
Ø Customizing PO Approval:
PO Approval workflow has been customized for incorporating project based
approval process depending on the type of Purchase Order. If Purchase Order has
been raised for a specific project then project based approval process will be
called else standard approval process will be followed
Ø Customizing PO Account Generator:
Oracle has not provided any logic for Seeded PO Account Generator in 11.5.9 if
PO is based on project. Customization is to select the code combination for the
particular purchase order and update in the attributes.
Ø Customizing Requisition Account
Generator: Oracle has not provided any logic for
Seeded Requisition Account Generator in 11.5.9 if Requisition is based on
project. Customization is to select the code combination for the particular
Requisition and update in the attributes.
Ø Customizing Supplier Invoice Account
Generator: Oracle has not provided any logic for
Seeded Invoice Account Generator in 11.5.9 if Invoice is based on project.
Customization is to select the code combination for the particular purchase
order and update in the attributes.
Ø Customizing Expense Report Account
Generator workflows: Oracle has not provided any logic for
Seeded Expense Report Account Generator in 11.5.9 if Invoice is based on
project. Customization is to select the code combination for the particular
purchase order and update in the attributes.
Ø Developed
an Interface for uploading Standard and Blanket Purchase Order Data and
Supplier and Supplier Site Data.
Ø Developed
few Discoverer reports
Ø Maintain
Defect Tracking system in intranet.
Ø Maintaining
files in VSS (Visual Source Safe) for version control.
Ø
Responsible for overseeing the
documentation standards related to the project i.e., Deliverables, IDD
(Integrated Design Documents), UTC (Unit Test Scripts)
Satyam Computer Services Ltd
Agilent
Technologies Inc., Gurgoan, India (Dec’03 to
Jan’04)
ENVIRONMENT: 11.5.9
Responsibilities:
As a team member, am responsible for
Ø Analysis
of the specifications provided by the client.
Ø Design
and Development.
Ø Tuning
performance of Query
Ø Reporting
using SQL*Reports.
Ø Concurrent
Program creation using parameters and value sets
Ø Responsible
for overseeing the documentation standards related to the project i.e.,
Deliverables, MD70 (Technical Documentation), TE30 (Test Scripts)
Solix Technologies
Oracle
Corporation Ltd. Bangalore, India (Mar’03 to
Jul’03)
ENVIRONMENT: 11.5.7
MODULES: Accounts Receivables
Responsibilities:
Ø Building
new forms and customization, modification and bug fixing of existing forms.
Ø Building
New reports and customization, modification and bug fixing of existing reports
Ø Reviewing
Objects and entering review comments in Review Comment List.
Ø Worked
on new Workflow Notifications and small customization on existing workflow.
Ø Following
Build Standards and Design Standards of Oracle Corporation while coding and
designing objects.
Ø Following
AIM Methodology for the documentation.
Solix Technologies
AstraZeneca
Pharma Ltd. Bangalore. (Oct’02 to feb’03)
ENVIRONMENT: 11.0.3
MODULES: General Ledger,
Accounts Payable, Accounts Receivables, Fixed Asstes
Responsibilities:
Ø Building
new report and customization of standard reports for checking the balances for
the Legacy system and showing the data when required in Financial Modules (GL, AP, AR, FA)
Ø
Customization of Interfaces in
Financial Modules (GL, AP, AR, FA)
Ø
Customization of forms in Financial
Modules (GL, AP, AR, FA)
Ø
Preparing Technical Documentation for
all the customized or Developed Objects
Solix Technologies
Solectron,
Milpitas, CA (Aug’02
to Oct’02)
ENVIRONMENT: 11.5.7
MODULES: Order Management,
Bill of Material, Work in Process
Responsibilities:
Ø Building
forms and customization of forms for validation and entering the data in OM
Module
Ø Building
report and customization for checking the balances for the Legacy system and
showing the data when required in OM module
Ø Converting
SQL/PLSQL code from 10.7 to 11i
Ø Converting
Pro *C code from 10.7 to 11i
Quest Syscon International
Shri.
B.D.Mehta Mahavir Heart Institute, Gujarat, Surat (Jul’01
to Jun’02)
MODULES:
General Ledger, Payables, Receivables, Assets, Purchasing, Inventory
Responsibilities:
Participated in Conversion,
Customization and development of Purchase Module, Inventory Module, Creditors
Module, Debtors Module & General Ledger Module.
Ø Transaction
Processing Options
Ø Purchase
Indent entry, Purchase Indent authorization, allotment and cash Indents.
Ø Purchase
Orders, Stock Inward Book & Goods Receipt Note.
Ø Material
request to main stores, Material issue to sub stores, Material receipt in sub
stores,
Ø Transaction
Entry/ Maintenance
Ø Payment
Approval to Suppliers (Creditors), Payment release, Cheque Printing, Expense
Journal, Debit Note & Credit Note to Creditors.
Ø Receipt
Entries (Debtors), Debit & Credit Note to Debtors.
Ø GL
Receipts, GL Payments, GL Journal, Summary Chart Maintenance, Trial Balance,
Profit & Loss Statement, Balance Sheet
Ø Developed
Transaction Processing Options
Ø Customized
Purchase Indent entry, Purchase Indent authorization, allotment and cash
Indents.
Ø Developed
Purchase Orders, Stock Inward Book & Goods Receipt Note.
Ø Material
request to main stores, Material issue to sub stores, Material receipt in sub
stores,
Ø Customized
Receipt Entries (Debtors), Debit & Credit Note to Debtors.
Ø Customized
GL Receipts, GL Payments, GL Journal, Summary Chart Maintenance, Trial Balance,
Profit & Loss Statement, Balance Sheet
Ø Developed
selection procedure, application reference, selection process forms.
Ø Developed
Employee other income, Employee rent, Miscellaneous others, Income tax process,
Deductions under chapter VI a, Rebate under SEC 88, Rebate under SEC88 (para2),
TDS details, Education, Entertainment allowances, and House property forms.
Ø Developed
reports.
Ø Developer
Employees Salary Details, Employees Leave Transactions, Employees Separation.
Ø Developed
an Interface of Time Office Machine, which will get whole data of Employees
Attendance (In time and out time) in Database.
