Project Profile
InstaSAP
Sample Project Profiles
InstaSAP Infotech
No. 2, 2nd Floor, Gokul Arcade,
Sardar Patel road, Adyar, Chennai,
India - 600020.
Tel: +91 44 43412626 Fax: +91 44 43412620
www.instasap.in
[email protected]
Page # 1
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Sap BW security & authorization, help desk support
Three Months (20 hours per week)
12
SAP SI Swiss
SAP BW, SAP security, sap basis
SAP BW
Project Description:
The project deliverables involved solving the complex authorization issues, to provide a new business
blueprint, knowledge transfer to client employees. The following tasks were carried out
1. Review of the present architecture for sap BW and reporting framework.
2. Participation in the review/development meeting of the new reporting framework as implemented
project has some issues like loosely coupled programs / not meet up the executive board standards.
3. Creation of a new BW business blue print.
4. Conducting KT sessions with existing sap security guys and show them how best we can implement
the BW security strategies.
5. Conducting sap suggested interviews with security staff.
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Sap BW Support & Performance
Nine Months (48 hours per week)
12 ( CCC team )
Centrica / British Gas
SAP BW
SAP BW
Project Description:
Handled the change requests, 2nd and 3rd level support calls. Deliverables included:
1. Support at expert level for Development and Production issues
2. Liaised with basis for lcp/patches/support packs.
3. Resolving various Query performance issues along with other members of dev team.
4. Point of contact as in charge for production system which contains about 80 cubes and more then
328 data loads per day where system is forced down at 11 PM and should come up by 5 AM.
5. Liaised with sap UK and sap America to solve complex BW performance issues deployed in many
locations across various hardware platforms and slow networking and old version of BW is in
question.
6. Load balancing issues were resolved. Addressed BW sizing issues.
7. Planned for upgradation.
8. KT sessions with query developers as well as team leaders in the company.
Page # 2
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Sap BW Development
Nine Months (40 hours per week)
18 Members Team and when it went to support then 6 Members
Price Waterhouse Coopers(PWC)
SAP BW
SAP BW
Project Description:
BW Development (Queries, Web templates, Info Cubes, Enhancements of Extractor’s):

Worked on development of New queries/Cubes/ODS’s, web templates and extractors
Did enhancements using CMOD/User Exits.
Customization of web templates, Web reporting, web items using BW 30B web application designer
(WAD) and query designer.
Liaise with Global team
for nece ssary update, patche s, correctio ns, transport s, ap plication
enhancements and data loading.
Trouble shooting the BW Authori zation Probl ems t hrough RSSM, RSSM TRACE, RSSMQ, and
RSRTRACE.
Aggregates a nd BW System Pe rformance ( ST 03n, RS RT, RSRT2, ST01, ST05, RSRV, Tables
like RS DDSTAT, RSDDS TATAGGR, RSRCATTTRACE, ABAP Trace ( SE30), Front end Trace:
IEMON, Lo cal Catch Also working on variou s issues relate d Data Clea ning/Quality, OLAP Ca che,
Pre-Calculated Web T emplates, Compressing, In dices, DB St atistics, DB and b asis (Buffer)
Parameter etc ) as well as Load Balancing of Processes.
Developing various RRI / Jump Targets using WAD, RSBBS (web template to web templat e, URL,
R3 etc).
Developing Local specific Process Chains and Meta Chains (RSRQ, RSPC, Event Collector, SM50,
SM37, and RSMO) and Create new Info Packages in addition to Global.
Integration with PWC SAP Internal Portal and Reporting Catalog.
Enhancements to cube, CKF, RKF depending on requirements.
Creating UK specific exits like forcing a user to enter one variable to increase performance.
Working closely with BW security team on BW security issues and provide Knowledge transfer.
BW Testing:

Working clo sely with vario us Fun ctional Testers and creatin g def ects in Te st Dire ctor and solving
TPR’s and BCR’s/CR through Change Management.
Unit Testing, String Testing, Integration testing, Regression testing with migrated data from Legacy
systems, UA T Testing. During above testing ph ases vario us Queries, Co ntent, Cube s again st
Business Process, Rules Vs Global/Local Template were tested using testing Tools : Mercury Test
Director, GFS Progman, Lotus Notes
BW Support:

Support for about 45 Cubes and 20 ODS.
Handling PWC (UK) Wave3 development and Handling Change requests approved by business.
Data loading by using process chains (RSPC), Meta process chains.
Management of critical master data load’s , non critical adhoc loads
Handling interface loads to other data warehouse products like PERD, TM1, and Finder etc.
Page # 3
Project Profile

Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Day to Day suppo rt for ab out 125 co mplex Analytic al , semi - operatio nal , operatio nal qu eries in
functional areas of time and expenses , Accou nt Receivables, cats, PCA, MOR , Financ ials , WIP
management , Client Billing , Invoicing.
Handling Various PR , Issues , RCR’s as critical , High , Medium , Low.
Page # 4
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
SAP interfacing with cognos
Nine Months (40 hours per week)
18 Members Team and when it went to support then 6 Members.
Proximus
SAP BW / Cognos
SAP BW
Project Description:
•
•
•
•
Formulate BW high level solution strategy and architecture using FI-CO,GL, MM, AM, AP
Cube/ODS. (Using BW version 31 Business content ) and Architecture to enhance extractors and
methodology.
BW Extraction strategy/loading strategy for these tables ANLA (Asset master record segment)
ANLZ( Time dependent Asset Allocations )AUFK( Order Master Data) BKPF (Accounting document
header) BSEG( Accounting document segment) CSKT (Cost Centre Texts) GLT0 ( G/L Account
Master record -Transaction Figures) KNA1( General Data In Customer Master) LFA1 (Vendor
Master (General Section) SKAT( G/L Account Master Record (chart of accounts description))
ZM013( Commitments: Amounts by PO – Item (ZZMZ0010)) and other MM and PO tables.
Interface between SAP BW 31 and Cognos Power play using SAP BW OPENHUB services.
Comparison of OLE DB,XML/A, OLAP BAPI and BW Open hub services with data stage BW
extract pack, Cognos head start for sap bw.
Page # 5
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
SAP / Oracle Expert
17 Months (40 hours per week)
80 Members Team(One of the 3 team leads)
Teslim Mobile Communications – Turkey – Istanbul.
SAP / Oracle / BO / Applix TM1 / Jupiter Billing System
SAP / Oracle
Project Description:
•
•
•
BW Data ware housing physical and logical Modeling and Implementation and preparing customer
specifications and documentation. BW installation and Set up. BW Database and applications and
Apply patch application. BW Database performance design, monitoring and tuning .BW to sap r/3
and r/3 to BW Database migration. (Sybase sql to Oracle, IBM DB2 to oracle, MS Sql server to
Oracle.)
R/3 systems: sap r/3 installation, user administration, performance tuning, printing administration,
management of batch, back up and recovery, archive (BR) back up, definition of r/3 related alerts,
bug correction, patches and upgrades, support of functional teams with data loads and interfaces.
Assistance in upgrading projects, data base security, preventive maintenance, sap data recovery
planning, planning for enterprise wide back up for sap r/3.
Oracle DBA Experience: Consultant Data ware housing, DBA for implementations project of
TELCOM solutions, Oracle server installation and Set up, Database and applications patch
application, Database performance design, monitoring and tuning, Systems performance and
monitoring I/o, memory, and CPU activities and logs.
Page # 6
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
SSS Project (Shared Sourcing Services)
4 Months
3
GE Betz water technologiesl
SAP-FICO
SAP
Project Description:
GE Betz water technologies planned to shift their purchase details from SAP to Oracle. Inter face was
developed for this to update financial documents during purchasing transactions happened in Oracle.
Page # 7
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
CBS (Common Business Systems)
From 15/12/2003 To 01/03/2005
20
APD Caterpillar India Pvt. Ltd. Confidential
SAP-FICO
SAP
Project Description:
It’s an End to End project. Caterpillar implemented SAP.
Page # 8
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
MTR Foods Implementation
From 01/02/2003 To 15/10/2003
15
MTR Foods India Pvt. Ltd. Confidential
SAP-FI
SAP
Project Description:
MTR Foods Banglore Implemented SAP. It is in food business.
Page # 9
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
SAP Implementation For HZL
From 01 / 11 / 2003 To 31 / 03 / 2005
7
Hindustan Zinc Limited
SAP FI/CO
SAP
Project Description:
Hindustan Zinc Ltd (HZ L) is India 's l eading zin c producer. A vertically inte grated Mi ning & Smelting
company, HZL, is currentl y gea ring up to b ecoming a global lo west-cost p roducer. As a p art of V edanta
Resources, a Lond on li sted metal s an d mining major with Al uminum, Co pper and Zi nc operations in UK,
India a nd A ustralia, HZ L t akes advantage of its mi neral resources and related co re com petencies and
believes it has growth opportunities for increasing products and improving returns. SAP R/3, 4.7 version was
successfully implemente d by our company in
various mod ules viz. Fi nance, Co sting, Material s
Management, Sales & Distribution, Plant Maintenance, Production Planning and Quality Management.
Page # 10
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Material Master Support
3 days
1
Scott Health And Safety
SAP FICO/MM
SAP
Project Description:
Supporting the client in the implementation of price control method in Material Master and defining new
exchange rate type for purchases.
Page # 11
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
People soft CRM Implementation with Oracle Database
From 15 / OCT/ 2004 To 14 / Aug./ 2005
50
NEC Japan. Confidential
People soft CRM, Oracle
People soft CRM
Project Description:
NEC Japan, the pre stigious name i s known for its la rge computer manufacturing and pe rsonal products in
Japan.
We customized the delive red Field Service modul e of People Soft CRM for th e client to im plement its fi eld
services. Thi s involved customizing the CRM to fit the client need s a nd requirements. It also offe rs
integration with other third party systems (like Clarify, SAP..Etc.,) that provide the various data to and from
PeopleSoft. Used Test Management System.
Page # 12
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
People soft HRMS customization & upgrade from ver. 7.5 to 8x
5 Months
35
Hewitt
People soft HRMS, Oracle
People soft HRMS
Project Description:
BMO, One of the biggest having branches all over Canada. We did Customization & Upgraded their People
soft applications from People Soft ver 7.5 HRMS module to ver 8x
Page # 13
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
SAP Development And Support
From 30 / AUG / 2003 To 22 / JUL/ 2005
8
Allergan Pharmaceuticals, CA, USA
ABAP/4
SAP
Project Description:
Allergan, Inc., with headquarters in Irvine, California, is a global specialty pharmaceutical company that
develops and commercializes innovative products for the eye care, neuromodulator, skin care and other
specialty markets. In addition to its discovery-to-development research programs, Allergan has global
marketing and sales capabilities in over 100 countries that deliver value to our customers, satisfy unmet
medical needs and improve people's lives. Driven by technology and innovation, Allergan addresses the
needs of consumers across the world with over 5,000 employees worldwide, 4 world-class Research and
Development facilities and 3 state-of-the-art manufacturing plants.
Allergan uses SAP for the automation of it ERP processes.
Page # 14
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
SAP Development
4 Months
15
Ajinomoto, France
ABAP/4
SAP
Project Description:
Ajinomoto is one of Asia's biggest food companies, with ambitions to be a global force also, with offices
throughout its home territory, Europe and the Americas. It specialises in the manufacture of seasonings and
chemical ingredients, based on amino acid technology, especially sweeteners and the flavour enhancer
monosodium glutamate, which it invented.
Ajinomoto uses SAP for the automation of it ERP processes.
Page # 15
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Release 12 Data Migration Project
3 Months
1
Oracle
Java, PL/SQL
Oracle Applications
Project Description:
Designed and coded the application which will help customers migrate their 11.5.9/11.5.10 systems to R12.
In R12 there is a Unified Catalog Datamodel where both Oracle iProcurement and Oracle Purchasing will
use the same database schema. Thus the iProcurement data needs to be migrated to the new Purchasing
schema.
Page # 16
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Migrating Oracle iProcurement eContent Manager Module to Oracle
Applications Framework
5 Months
2
Oracle
Oracle Applications Framework, PL/SQL
Oracle Applications
Project Description:
Migrated the Loader/eContent Manager functionalities of iProcurement Family Pack J to OA Framework and
incorporated a slate of new features. E-Content Manager provides support to catalog administrator to author
content.
Page # 17
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Difference Summary & Acceptance Project for Oracle eBiz Suite Rel. 12
3 Months
1
Confidential
Java, JDeveloper/OA Framework
Oracle Applications
Project Description:
Designed and developed Difference Summary & Acceptance Project using OA Framework Technology.
Difference Summary for Supplier and Catalog Admin will provide the Summary of all the changes made by
them through online editing for a Particular agreement (GBPAs). For Buyer, it will provide a facility where
the user can provide disposition (Accept/Reject) for these changes at Header level or Line level through
Acceptance Screen and also export the difference summary to a text file. The Suppliers will be able to
access this feature from Oracle iSupplier Portal. The Buyers and Catalog Administrators will have access to
this feature from iProcurement.
Page # 18
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
BAA Upgrade Project
7 Months
38
British Airport Authority, U.K
Oracle Financials, Forms 6i,Reports 6i, Oracle 9i DB
Oracle Applications
Project Description:
1. BAA intends to migrate their existing Oracle Applications from 11.0.3 to 11.5.10 to take the
advantage of new Oracle applications features.
2. It also involves customizations of some existing reports and development of some new interfaces to
suit their business needs.
3. Creation of Shell scripts for components movement and execution into different instances.
4. Creating outbound Interface for Account Receivables.
5. Preparation of Technical Design document for AR VAT Extract Interface.
6. Testing - Unit testing and preparing Test Scripts.
7. Bug fixing for the issues raised in Test Director.
8. Developed a custom form XXFAIBAD.fmb which talks about IBA Assets like Building.
Page # 19
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
SAP Migration to Oracle Financials
7 Months
9
Master Card, Belgium
Oracle Financials, Forms 6i,Reports 6i, Oracle 9i DB
Oracle Applications
Project Description:
1. The goal of the “SAP Migration to Oracle Financials” project is to consolidate the existing financial
2.
3.
4.
5.
6.
7.
processes of MasterCard’s European region from the existing SAP platform to the Oracle Financials
used by the rest of MasterCard.
It also involves customizations of some existing reports and development of some new interfaces to
suit their business needs.
Creation of Shell scripts for component movement and execution into different instances.
Converting components from SAP to Oracle Applications 11.5.9.
Preparation of Technical Design document for Data conversion for Fixed Assets and PO Vendors.
Creation of Packages for Migration and Interfaces for modules like Fixed Assets, PO Vendors.
Generating a report for Cost and Reserve Detail Report for Assets, Financial Information for Books.
Page # 20
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
ILO Oracle apps implementation
3 Months
19
International Labor Organization, Switzerland
Oracle Budgets, Forms 6i,Reports 6i, Oracle 9i DB
Oracle Applications
Project Description:
1. International Labour Organization(ILO) is the UN specialized agency wants to implement Oracle
Applications in the areas of Finance, Human resource, Project Management, Grants Management
with system-wide support for security and reporting, Self Service (iProcurement, HR, Travel) and
interfaces to other systems.
2. Creation of Packages for Custom module Budget Proposal System (BPS).
3. Testing - Unit testing and preparing Test Scripts.
Page # 21
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
SAP Migration to Oracle Financials
7 Months
14
Master Card, Belgium
Forms 6i,Reports 6i, Oracle 9i DB
Oracle
Project Description:
1. Epanda is the migration project from Forms/Reports6i to Forms/Reports9i for the FORD Thailand
2.
3.
4.
5.
Client. This project was primarly developed to make it web enabled. As prior to this migration, the
software is being used as Client Server even though its 6i version.
It also involves migrating the existing forms, Reports which involves certain code changes and
layout formatting.
Modifying the existing VB scripts and Pro*C files according to the requirement, which calls the
reports internally.
Unit testing the migrated components.
Production Support includes coding for some Bug fixes.
Page # 22
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Inventory Management System(IMS)
7 Months
7
Gati Cargo, India
Oracle Financials, Forms 6i,Reports 6i, Oracle 9i DB
Oracle
Project Description:
1. Inventory Management System (IMS) is a web based application, been developed using oracle 9i
2.
3.
4.
5.
(database) and Developer 6i (front-end). IMS helps in maintaining the inventory of IT assets of Gati,
all over India. The modules in IMS are : Hardware (keeps track of inventory of all hardware related
equipments), Software (keeps track of inventory of all software. They can be, application software,
Licensed software, Back-up software, etc), Annual Maintenance contract (ie AMC ) details and
Warranty, Insurance Policy details, Bulk Additions, Requisitions, Masters, Admin and Reports.
Peripherals is a sub-module of Hardware.
It involves Analysis of the specifications provided by the client and preparing the technical
documents.
Developing Forms for AMC Details Module which includes AMC Vendor Details, AMC Branch
details and AMC- Gati Location details. Developing Warranty and Insurance Module.
Developing Summary reports for AMC, Warranty and Insurance Details.
Unit testing the migrated components.
Page # 23
Project Profile
Project name:
Project Duration:
Team Size:
Client Details:
Technology Used:
Domain:
Rev: 1.2
Document #:
PWS.MKTG.F.RP002
Gati.net (intranet)
1 Yr
5
Gati Cargo, India
Java, JSP, JDeveloper, Oracle 8i DB
Oracle Applications
Project Description:
1. This project enables a communication system that connects Gati’s branches and head office as an
intranet. The intranet combines with information links like VSAT, Leased lines.
2. It involves Analysis of the specifications provided by the client and preparing the technical
documents.
3. Responsible in developing chat server and configuring it for various VSAT Locations all over India.
4. Responsible in coding and maintenance of the log files for Presentation and General Discussion.
5. Unit testing the migrated components.
Page # 24