Supply Chain Oracle
Resume:
Kaushik Biswas
***********@*****.***
PROFILE SUMMARY
* Efficient with Oracle BI technologies, which includes OBIEE, DAC,
Informatica, ODI, and SQL.
* Trained Oracle partners on OBIA in a technical workshop.
* Contributed to three product release cycles of Oracle BI Applications.
* Contributed to Spend Classification Data Mining product.
* Currently own some of the important modules of Oracle BI Applications
11g.
* Possess good knowledge of Cognos and Teradata SQL, familiarity with
scripting languages
* Strong academic background with good management/leadership abilities.
SOFTWARE SKILLS
* Programming Languages: C/C++, VB
* Databases: Oracle, Teradata, Mysql
* Operating Systems: Windows, Linux
WORK EXPERIENCE - 4 years 3 months
Oracle India Private Limited, Bangalore as Senior Member Technical Staff
(Aug 2009 - Present)
Symphony Services, Bangalore as Senior Member Technical Staff (Dec 2008 -
August 2009)
Cognizant Technology Solutions, Bangalore as Programmer Analyst (Sep 2006 -
Nov 2008)
PROJECT PROFILE
Profile 1: Duration - Dec 2008 - Present
Working as Senior Software Developer in the most effective and reputed
division of Oracle named 'Server Technology - Business Intelligence'.
Contributed to 7.9.6, 7.9.6.1 and 11G release of Oracle BI Applications
(OBIA).
Designed and developed Procurement, Logistics and Costing related
dimensions and facts for OBIA as part of Supply Chain Analytics Development
Team.
* Designed data model for Oracle BI Applications 11G Data Warehouse from
business requirements and ETL performance considerations, and authored
various technical design documents.
* Developed ETL to populate Data Warehouse from various Sources (EBS,
PeopleSoft, Siebel, Fusion) by coding mappings/transformations and
then creating sessions/workflows in Informatica, and configuring
Oracle Data Warehouse Administration Console (DAC) to create Subject
Areas and Execution Plans.
* Developed OBIEE Business Model for Oracle BI Applications,
Procurement, Supply Chain Analytics and Spend Classification Data
Mining. This includes designing and creating Logical Tables, Logical
Table Sources (LTS), dimension hierarchies and physical layer.
* Experience with Oracle Fusion Middleware (FMW) technologies, which
include Oracle Weblogic 11g, Oracle Jdeveloper 11g, Oracle
Application Development Framework 11g and is the underlying
technology for the upcoming Oracle BI release.
* Designed FMW objects like Entity Objects (EO), Entity Associations,
View Objects (VO) and View Links on top of source tables for
Procurement and Supply Chain Areas.
* Performed several Unit/Integrations tests and POCs; wrote scripts to
validate data, consistency checks and Automate ETL runs.
* Fixed numerous bugs to ensure speedy delivery of the product.
* Familiar with Oracle DBA activities like creating database, managing
users and permissions, table spaces etc.
Profile 2: Duration - Sep 2006 - Nov 2008
Orbitz Work Package Execution consists of various modules, which include
the developments of ETL and Reporting for Air and Hotel Booking Analytics
Client : Orbitz, a wholly owned subsidiary of Travelport Corporation and
part of Travelport Travel Distribution Services division, is a world leader
in providing Travel and distribution services offering online booking
process for customers across the globe.
Roles and Responsibilities:
* As a Programmer Analyst in the Work Package Execution project I have
shouldered the overall responsibilities to understand Client Processes
and to work efficiently to meet targets and deliver solutions in
accordance with Cognizant quality control standards and business
practices and procedures.
* Performing the analysis for various enhancements, performing impact
analysis to find out the processes that could be potentially affected
by proposed change(s), coding, testing and implementation activities.
I was exhaustively involved in the design, development and testing of
the Informatica components.
* SCM coordinator for the project and have taken care of internal audits
for the project.
Technologies Used: Informatica 8, Cognos 8, Teradata v2R5
EDUCATION
Undergraduate Education:
Degree: Bachelor of Engineering (B.E)
Branch: MECHANICAL Engineering
Institution: National Institute of Technology Karnataka,
Surathkal,India
* Aggregate : 64.76 %
Senior Secondary Studies:
12th Class (PCM.)
School: Vivekananda College, Kolkata.
Year of Passing: 2002
* Percentage : 75.9%
Higher Secondary Studies:
10th Class (Science)
School: National Gems H.S. School, Kolkata.
Year of Passing: 2000
* Percentage: 84.2%
Contact this candidate