Oracle Project

Contact No: 310-***-**** Koushik BISWAS Email: ******.*******@*****.***

PROFILE

More than (7.5+) years, I have worked in the field of Information Technology (IT) with an emphasis in the

technical and Business analysis track.

I have substantial experience of business processes in Auto Industry, Global Development Center & Information

Technology Enabled Services (GDC & ITES) and Research & Development Area.

Presently, I am searching for the opportunity to join a leading company, as a Senior IT Consultant, which would

utilize my diverse software engineering skills and where I can share my skill sets.

EXPERIENCE SUMMARY

More than (7.5) years of Information Technology (IT) experience in Software Development and Maintenance

Especially skilled in Software Development Life Cycle (SDLC) projects which include:

Full life cycle of the system analysis, design, development, maintenance & enhancement process

including requirement gathering, analysis, development, testing and deployment of the various application

software and creating documentation as per the standard.

User Adhoc Reporting and 24/7 Production Support Experience.

Oracle Certified Associate (in Oracle 9i Data Base Administration) with extensive application development &

implementation experience in:

Oracle ERP 11.5.7/11.5.9/11.5.10 - (AP/ GL/ PO / iExpense / OM/ AR / iProcurement/ iExpense)

customization, Interface Development with different 3rd Party Product ( Biz-Talk/EDI/ RosettaNet)

Oracle Developer-2000 (Forms / Reports / Customization of Apps. Forms / Reports / XML Publisher )

Oracle SQL, PL/SQL, Custom.pll, Function, Stored Procedure and Package, Triggers etc.

Oracle Utility: SQL-Loader & Export-Import Utility, FNDLOAD and OAF Customization.

Exposure to common oracle ETL processes from Legacy and Oracle ERP.

Exposure to Decision Point Data warehouse tool and Oracle BI reporting tools ( Oracle Discoverer ).

Performance Tuning of applications.

Hands-on knowledge and experience in Unix-Shell-Scripts.

Adequate knowledge and experience in Web Programming using JavaScript, VBScript, DHTML & HTML

Preparing Documentations based on Oracle AIM ( MD050/MD070/BR100/ Test Scripts )

Excellent analytical, problem solving, communication and interpersonal skills, and having the ability to learn,

understand & use of any in-house tool with ability to interact with individuals at all levels

TECHNICAL EXPERIENCE SUMMARY

Industries: Auto Industry, GDC & ITES and Research & Development, Manufacturing

Database: ORACLE 8i,9i & 10g

Software: Developer-2000 (Forms-6i, Reports-6i), Oracle 11i ERP, Discoverer 4i

Languages: UNIX-Shell-Scripts (Korn),SQL, PL/SQL,C & Pro*C

Misc. Tools: Job Scheduling-UNIX crontab,Version Control-PVCS / Kintana, Quality Center,

FTP/SFTP, Data Analysis, Structure Query Reports, HP Quality & Performance Center,

Exposure to Testing Tools – Load runner and Quality Test Professionals ( QTP )

DW Technologies: Data-Warehouse-(DW) / Data-Mart-(DM) Lifecycle (Theoretical Knowledge Only)

DW Functional Areas: DW/DM Lifecycle (ETL/Staging Process, Data Quality & Meta Data Management)

(Theoretical Knowledge Only)

Operating System: UNIX, WINDOWS, DOS

Platforms: HP Tru64 Unix 5.1b OS, VAX-II and PCs

EDUCATION

Education: Master Degree in Computer Science.

PROFESSIONAL CERTIFICATION AND TRAINING

Oracle Certified Associate in Oracle 9i Database Administration & BRAIN BENCH Certified in ‘C’

Language

Page 1 of 5

Contact No: 408-***-**** Koushik BISWAS Email: ******.*******@*****.***

ORACLE, DEVELOPER-2000, C & UNIX Training from Tata Cummins Limited,

Oracle Apps (11.5.10 ) Finance Module (GL/AP/AR/FA/CM) Training from Tata Consultancy Services

JAVA Training from SUN through Tata Cummins Limited

PROJECT ENGAGEMENT OVERVIEW

Client: JDS Uniphase Corporation, CA, USA Apr-2009 to Till Date

Project: Oracle Application – Quoting / Siebel OnDemand Module enhancement

Role: Team Member (Interface Design with Custom Report Development )

Overview:

JDSU is a leading provider of optical products and test and measurement solutions for the communications

industry. The IT division at JDSU takes care of the Oracle EBS instances, Siebel OD, De-mantra and other

peripheral applications. JDSU implemented Quoting module as part of project “Pipeline” to provide a complete

end-to-end solution from lead-to-opportunity-to-quote-to-order-to-invoice. By integrating Siebel OnDemand with

Oracle Quoting, increased accuracy for sales and operation data for forecasting is achieved. Also customer

service efficiency is increased by converting quote to orders within a single system.

Contributions & Responsibilities:

Design of various Interface / Validation process using OM public API Provided by Oracle.

Coordination with oracle on demand for various SR’s and API related issues.

Understanding JDSU existing Quote/Sales Business process in Oracle.

Design of MD070 / MD050 based on oracle AIM methodology.

Gained Oracle Quoting functional knowledge.

Customized the Quote Approval Workflow, reports and developed Interfaces.

Design and developed the AME Rules for Quote Approval Workflow

Environment: Oracle ERP Application (11.5.10.2), Oracle 10g, Oracle PIP for Siebel On-Demand, XML, Unix,

SQL/PLSQL, OAF, Oracle Workflow.

Client: JDS Uniphase Corporation, CA, USA Sep-2008 to Apr-2009

Project: Oracle Application – B2B application based on RosettaNet standard

Role: Technical Lead ( Order Management / Interface Design with Custom Development )

Overview:

The CommTest B2B application is currently used to transmit order information between JDS Uniphase

and Contract Manufacturers (CM). This application has been upgraded to be capable to support multiple

CMs in Jan 2009. This application is currently live with Flex Poland in Production. In March of 2009 this

application will be expanded to Five more Contract Manufacturers direct order fulfillment. As the use of

this application is expanded, additional functional requirements have emerged. Some are critical and are

required for SOX/Trade Compliance. Some have been identified as changes that will improve customer

satisfaction, reduce costs or improve the scalability of this solution.

Contributions & Responsibilities:

Understanding JDSU existing B2B Business process in Oracle OM Module.

Design of MD070 / MD050 / T040 based on oracle AIM methodology.

Developed inbound ( 3A7 / 3B2 ) and outbound interfaces ( 3A4 / 3A8 )

Design of various Interface / Validation process using OM public API Provided by Oracle.

Coordination with oracle on demand for various SR’s and API related issues.

Developed Alerts / Email attachments / New Forms / Reports including Form personalization using

Custom.pll

Conducted technical training session for the support team member for post production GO-LIVE

Tuning of application for various concurrent program.

Environment: Oracle ERP Application (11.5.10.2), Oracle 10g

Client: JDS Uniphase Corporation, CA, USA May-2008 to Sep-2008

Project: Oracle Application

Role: Technical Lead ( EDI Implementation )

Page 2 of 5

Contact No: 408-***-**** Koushik BISWAS Email: ******.*******@*****.***

Contributions & Responsibilities:

Understanding JDSU Business process.

Developed interface for EDI 850 Inbound, 855 / 810 Outbound for QWEST and AT&T Customers

Interaction with various business and preparation of MD050 and MD070.

Developed Interfaces using Customer / site and OM API / Shell script / New Forms / Reports

Unit testing / CRP and UAT test preparation including user training and knowledge sharing.

Client: JDS Uniphase Corporation, CA, USA Feb-2008 to May-2008

Project: Oracle Application

Role: Performance Analyst ( Application Tuning & Custom Development )

Contributions & Responsibilities:

Understanding JDSU Business process.

Identify top Recourse Consuming program and analysis of those program.

Extensive work on Performance Tuning of those top rated programs which takes high resources

( I/O,CPU, Elapse time, Disk Read etc ) and takes longer time to execute which directly/indirectly

impact business specially during month end activities.

Close interaction with DBA and Oracle On Demand for knowledge transfer and analysis of results.

Rewritten some long running critical business logic in more efficient way in Oracle Quoting Module and

AR / AP reports including XML Publisher.

Customization of applications based on requirement with proper impact analysis.

Designed and developed reports and given solution towards reducing gaps on various measures and

controls to make the business process in compliance with SOX norms in PO and GL Module.

Environment: The environment of above projects is based on N tier architecture, running on Oracle 9.1.0.2 DB,

Application Server as 9i (version: 1.0.2.2) & SUN Solaris Linux OS.

Client: Google, Inc. CA, USA May-2007 to Feb-2008

Project: Oracle Application ( P2P Track Support / Development)

Role: Programmer Analyst (Team Size:9)

Contributions & Responsibilities:

Understanding Google Business process for Procure-to-Pay cycle ( PO / iExpense / AP / GL ).

Exposure to 170 MarkView System.

Involved in various failover testing during tech-stack upgradation.

24/7 Production support

Customization of existing reports / Business process including analysis of various cases.

Fixing Bugs and worked with Oracle for different SR .

Exposure to ADI and writing various custom interface modification and data fixes.

Requirement gathering and analysis to define the scope and close interaction with users.

Code development and unit testing for various custom programs in PO / AP Module and Workflow.

Preparation and review of test cases. Unit testing of converted objects. Fixing bug & provide solution.

Close interaction with business-users and development-team during different phase of project

Environment: Oracle ERP Application (11.5.9/11.5.10), Oracle 9i/10g. The environment of above projects is based

on n tier architecture, running on Oracle 9.1.0.2 DB ( upgraded to 10g ), Application Server as 9i (version: 1.0.2.2) &

HP SUN Solaris Unix OS.

Client: Cisco Systems, Inc. CA, USA Sep-2006 to Mar–2007

Project: Cisco – CIBER & POM Project

Role: Sr. System Analyst & Technical Team Lead (Team Size:11)

Project Involved:

CIBER (Contracts, Installed Base and Entitlement Repository) is a complex, Oracle 11i ERP-based

system. The system is housing all sales related service-contract-agreement activities and installed-

base-equipment. The sales related service-contract-agreement activities include: creating, modifying,

renewing and terminating contracts. It also contains business rules to interface between service-

agreements and the installed-base-equipment.

Page 3 of 5

Contact No: 408-***-**** Koushik BISWAS Email: ******.*******@*****.***

POM (Partner Opportunity Management) is for the renewal of contracts and quotes. POM system

improves the renewal process for users by excluding already-renewed-items & Do-Not-Renew(DNR)-

label-items. It improves user experience & extends user visibility by providing custom filtering, grouping

and sorting functions with download functionalities.

Contributions & Responsibilities:

Understanding Cisco processes & preparation of detailed object analysis document of individual objects

Developed interface between POM and SOM (Supplier Opportunity Management) system

Downloading & uploading Application Object Library(AOL) objects across instances by FNDLOAD utility

Migration of objects using Kintana Workbench across instances using PVCS version control.

Knowledge of Trade Community Architecture (TCA)

Requirement gathering and analysis to define the scope, prepared MD070 Technical Specification.

Preparation of coding standard document, coding checklist document, migration checklist document.

Preparation and review of test cases. Unit testing of converted objects. Fixing bug & provide solution.

Environment: Oracle ERP Application (11.5.10.), Oracle 9i. The environment of above projects is based on n tier

architecture, running on Oracle 9.1.0.2 DB, Application Server as 9i (version: 1.0.2.2) & HP SUN Solarix Unix OS.

Client: Tata Cummins Limited (TCL), INDIA Aug-2003 to Sep-2006

Project: Tata Cummins ERP Implémentation/Up-grada Project

Role: Sr.Manager-Technical Team Lead (Team Size:8)

Contributions & Responsibilities: Selected as a team lead for Oracle Applications (11.5.10) ERP implementation at

Tata Cummins Limited. Involved in implementation of Finance Modules: Oracle General Ledger (GL), Oracle Account

Payables (AP), Oracle Account Receivables (AR), Fixed Assets ( FA ), and Cash Management (CM ) and

migration /up-gradation of HRMS Module (from 11.5.5 to 11.5.10). Main responsibilities are:

Review of existing documents for analysis of existing functionality of the system

AS-IS, TO-BE and Gap analysis, preparation of high and detail level technical design documentation

Application Object Library (AOL) setup, downloading and uploading AOL Objects across instances

using FNDLOAD utility

Design/modification New forms/ Reports, Form personalization & Alert writing.

Code development, unit testing, string testing & customization of Oracle Apps Forms/Reports.

Backend coding using PL/SQL for data validations & data migration for various inbound and out

bound interfaces and migration ( e.g Customer Migration, HRMS to Legacy Payroll to AP / GL )

Interface design for OM / interface for interaction of sales data to customer’s SAP system.

Guiding team members. End user training on Control Room Pilot (CRP). Production support.

Environment: Oracle ERP Application (11.5.5 /11.5.10.), Oracle Developer 2000 (Forms-6i/Reports-6i

Project: Tata Cummins In house Software Development and Support Projects

Role: Senior Software Engineer Aug-2002 to Aug-2003

Contributions & Responsibilities:

During this period, designed, developed, implemented & supported, some new and old applications which had made

whole business process smooth and faster in Tata Cummins Limited. Some of the applications are:

Tata Cummins Legacy Finance Module which includes different sub modules (General Ledger,

Accounts Receivable, Accounts Payables, Bill Marketing System, Supplier Payment System etc.).

Tata Cummins Payroll System which includes various sub modules (Leave, School, Loan, Tax,

Settlements, etc), which are linked with employees various earnings and deductions.

Online Invoice Uploading System for Tata Motors’s Supplier Relation Manager (SRM) System in SAP

ERP System

Customize reports using Pro*C and Structured Query Report

BI Reporting System (various financial and BI adhoc report using Oracle Discoverer)

Analysis, design, development, maintenance, enhancement and support of old/new programs/module

Close interaction with users during development, maintenance, enhancement and support phase.

Developed various Business reports in Discoverer

Page 4 of 5

Contact No: 408-***-**** Koushik BISWAS Email: ******.*******@*****.***

Environment: Oracle Developer 2000 (Forms-6i/Reports-6i), Oracle Discoverer 4i, Oracle (SQL, PL/SQL,

Function/Stored-Procedure/ Package/SQL-Loader/Export-Import-Utility and Pro*C) and Unix-Shell-Scripts.

Indian Statistical Institute (ISI), INDIA Jan-2002 to Jul-2002

Project: Pattern Recognition & Classification Problems: Artificial Intelligence

Role: Research Associate

I had been assigned for solving different Pattern Recognition & Classification Problems with Case Based Reasoning

& also generation of different rules using Artificial Neural Network & Fuzzy Set as major tools.

Exposure to Bio-informatics and wavelet theory

Environment: C & Digital Unix, DEC-Alpha 4100 system: 5/466 workstations, Sun Solaris Platform

Reference: Available upon Request

Page 5 of 5

Contact this candidate