Profile

Currently working as Primavera Consultant with ITCAN, Malaysia as a Permanent Employee. At client location SHELL, Malaysia through Accenture.

Primavera Consultant with 5+ years of rich experience in Primavera Implementation/Upgrade/Planning and Sizing/Installation/Support. It also includes the Primavera P6 Analytics implementation/Upgrade/Planning and Sizing/installation/Support /Customization and Development of New Dashboard and Analysis. Having a rich and advance database and Java/J2EE API implementation & programming experience .Also have Reporting Experience with primavera and Actuate/BI Publisher/OBIEE. Having a rich experience of providing technical and administration training of Primavera components to the core team member and support group.

As an international worker, I have been able to adapt quickly and efficiently to my working environment. I pick up skills quickly and apply them successfully, through both the use of initiative and the ability to comprehend instructions. Having a rich experience of Co-ordination among different teams and vendors. Have a good experience of analysing client requirement and preparing the specification accordingly.

Educational Qualification Master Of Computer Applications

Professional Experience 5.8 years

Primavera Experience 5 + years

Current Organization ITCAN, Malaysia (July,2011-Till Date)

Previous Organizations

• Wipro Infotech, Gurgaon, India(October, 2010-July,2011)

• SIEMENS Information System Ltd. Gurgaon, India (Jan,2007-October, 2010)

Skills and Experience :

Applications • Oracle Primavera P6 EPPM Suite R8.2/R8.1/R8.0/V6.2/V7

• Oracle Primavera Evolve8.9

• Oracle Primavera P6 PPM R8.2/R8.1

• Oracle Primavera P6 Analytics R2.0

• Oracle Primavera P6 ERDB 3.0

• Oracle Primavera Risk Analysis

• Oracle Primavera Contract Manager

• CompareDB (SHELL Specific)

• Picklist (SHELL Specific)

• IMPRESS (SHELL Specific)

Middlewares • Oracle Weblogic 11g (10.3.5)

• JBOSS

• OBIEE 11g

• BI Publisher 10g/11g

• Actuate Enterprise Report Designer Professional 8.0(sp2)

• BusinessObjects Data Integrator Designer v11.7 (XIR2)

• BusinessObjects v 6.5.1 & XI

• SQL Developer/Netbeans 6.5/Toad/ SQL-Server Management Studio

Database • Oracle Database 10g/11g Enterprise Edition

• SQL Server 2005/2008

• Oracle Database Client

Operating System • Windows Server2008 Enterprise Edition

• Windows Server2003 Enterprise Edition

• MS Windows Vista/XP/98/95

Programming Languages • PL-SQL /T-SQL

• Core JAVA/J2EE,SWING,Java API Implementation

• Java Script, HTML, CSS

• XML

Others • Synchronization of Global and Local Processes for an organization.

• Project Management Office flow and process concept.

• Requirement Analysis

• Planning and Sizing for Primavera Application set.

• Co-Ordination among teams and vendors

• Agile (Scrum) practitioner

• Strong Aptitude towards learning new technologies & excellent communication skill

Projects Experience

Project : Primavera P6 Analytics2.0 Implementation as SHELL Global Planning Tool Set

Client : Shell is a global group of energy and petrochemicals companies. With around 90,000 employees in more than 80 countries and territories, Shell helps to meet the world's growing demand for energy in economically, environmentally and socially responsible ways. Shell Standard Primavera P6 Environment is Part of Global Planning Toolset. Primavera P6 EPPM is widely used in SHELL as a Planning Tool with approximately 2000 users span over different work stream and OUs.

Organization :Accenture, Malaysia through ITCAN,Malaysia

Duration :April 2012-Till Date

Description : The main aim of this project is to create a Global Project Data Repository for Reporting and Analysis

With Primavera P6 ERDB3.0 capability to merge multiple PMDB database to one STAR schema.

Tools and Technologies:

• Primavera P6 EPPM R8.2

• Primavera P6 Analytics 2.0

• Primavera P6 ERDB 3.0

• OBIEE 11g

• BI Publisher 11g

• Oracle Database 11g

• SQL Developer

• MS Excel/Power Point /Live Meeting

Role and Responsibilities:

• Primavera Consultant

• Prepare & Co ordinate the P6 Analytics2.0 Implementation Plan.

• Prepare the P6 Analytics2.0 System Architecture

• Infrastructure Planning and Sizing of P6 Analytics2.0 Environment

• OBIEE 11g Installation

• Configuration of P6 Analytics2.0

• Develop customize Dashboard /Analysis/KPI and Reports as per Business Requirement

• Preparing the Technical Documentation for Environment

• Provide Training to the Core user

• Provide Training to Shell Global Application Support Team for providing Support and Maintenance.

Project: SHELL Primavera P6 EPPM V6.2.1SP2 Upgrade.

Client: Shell is a global group of energy and petrochemicals companies. With around 90,000 employees in more than 80 countries and territories, Shell helps to meet the world's growing demand for energy in economically, environmentally and socially responsible ways. Shell Standard Primavera P6 Environment is Part of Global Planning Toolset. Primavera P6 EPPM is widely used in SHELL as a Planning Tool with approximately 2000 users span over different work stream and OUs.

Organization : Accenture, Malaysia through ITCAN,Malaysia

Duration : July 2011-Till Date

Description : The main aim of this project is to upgrade SHELL Global Primavera P6 EPPM v6.2.1SP2 Environment to the recent release of Oracle Primavera P6 EPPM R8.2.In the first phase Shell Global Primavera P6 EPPM environment has to be upgraded and then the other Out steps (different countries or Business units having their separate Primavera P6 EPPM environment).The project also include to upgrade (compatible with new Primavera P6 EPPM version) the other external applications (CompareDB,Picklist,IMPRESS) which are being used in the SHELL Global Primavera P6 EPPM environment.

Tools and Technologies:

• Primavera P6 EPPM R8.2

• Primavera P6 EPPM R8.2 API

• Weblogic 11g

• Oracle Database 11g

• CompareDB (SHELL Specific External Application for Primavera P6)

• Picklist (SHELL Specific External Application for Primavera P6)

• IMPRESS (SHELL specific interface for SAP integration with Primavera P6)

• SQL Developer

• MS Excel/Power Point /Live Meeting

Role and Responsibilities:

• Primavera Consultant

• Provide Techno Functional support to Primavera P6 Shell user base as a SHELL Global Application Support team member.

• Prepare Functional and Technical Enhancement of Primavera P6 EPPM R8.2

• Prepare the System Architecture for R8.2 and approved from SHELL Global Architect

• Infrastructure Planning and Sizing for SHELL Global Primavera P6R8.2 environment

• Planning and Sizing for SHELL Out step units for Global Primavera P6R8.2 environment

• Prepare the upgrade Plan for SHELL Global Primavera P6 V6.2.1SP2 Environment to Primavera P6 EPPM R8.2

• Co -ordinate with vendors of SHELL to upgrade and configure different components of Primavera P6 EPPM R8.2 environment.eg Citrix Server Team, Database Team and other shell specific external application vendors.

• Upgrade the SHELL Global Primavera P6 V6.2.1SP2 Environment to Primavera P6 EPPM R8.2

• Prepare the web access environment for Primavera P6 EPPM R8.2

• Install and Configure Picklist and CompareDb.

• Upgrade different SHELL Out step units Primavera P6 Environment to Primavera P6 EPPM V6.2.1SP2 and then to P6 EPPM R8.2 .Like Nigeria (UIG) Primavera P6 Environment Upgrade.

• Provide Primavera P6 EPPM R8.2 Administration training to the SHELL Global Application Support Staffs.

• Provide Weblogic 11g installation and Administration training to the SHELL Global Application Support Staffs.

• Define the Database Refresh process for the SHELL Global Primavera Review and Acceptance environment.

• Prepare the Primavera Database Audit report for implementing the Enhanced Reporting functionality of Primavera P6 EPPM R8.2.

Project : Prepare Oracle Primavera P6 EPPM v8 Environment at JSPL, Angul, Orissa.

Client : Jindal Steel and Power Limited (JSPL) is one of India's major steel producers with a significant

presence in sectors like Mining, Power Generation and Infrastructure.

Organization: Wipro InfoTech, Gurgaon, India.

Duration : 7 March 2011 – 15July 2011

Description : we have to Prepare Oracle Primavera P6 EPPM v8 Environment and give training to the core

Users/support Group and also provide the technical and functional support to the user group.

Tools and Technology:

• Oracle Primavera P6 EPPM 8.0

• Oracle Database 11gR1

• Oracle Database client 11gR1

Role and Responsibility :

• Primavera Techno Functional Consultant

• Planning and Sizing for Primavera P6 EPPM R8.0 environment

• Prepare System Architecture for Primavera P6 EPPM R8.0 environment

• Prepare two production server on windows 64 bit which involves the following activities:

• Oracle Database installation

• Weblogic installation

• Deploying web access

• Testing the environment

• Oracle primavera p6 professional installation on user system and train the support staff for installing the same.

• Oracle database client installation on user system and train the support staff for installing the same.

• Provide Primavera Administration and maintenance training to support staff.

Project : EMOS- Energy Markets Observation System

Client : European Commission (DG TREN).

Organization: Siemens Information System Ltd.

Duration: Jun 2010 to Oct 2010

Description: The Energy Markets Observation System (EMOS) is a Business Intelligence system designed to enable the Commission to efficiently monitor and analyze the energy markets, identify potential risks and support regulatory decisions. EMOS extracts, transforms and loads data stemming from a diverse set of sources in its Data-Warehouse, categorized into unique Data Marts. Specifically, EMOS holds strategic agreements with leading statistical and information providers and therefore is entitled to access a large number of high-quality data sources. EMOS additionally collects and processes energy market statistical data directly from the EC member states through a specialized web interface. The project was for enhancement and maintenance.

Tools and Technology:

• BusinessObjects Data Integrator Designer v11.7 (XIR2)

• BusinessObjects v 6.5.1 & XI

• BusinessObjects Designer v 6.5.1 & XI

• BusinessObjects Supervisor v 6.5.1 & XI

• Oracle Database 10g

Role and Responsibility:

• Team Member

• Requirement Gathering and Analysis

• Create and Update Business Analysis Document

• Create and Update Object Analysis Document

• Creation of new BODI ETL batch jobs per file. New workflows, data flows, queries, scripts, table and file definitions implementation.

• Enhancement of existing BO Universe to support the new changes.

• Test Report Document

Project: SPARTA CoC – Custom Reports (Actuate)

Client and Organization: Siemens Information System Ltd.

Duration: Feb 2009 to Oct 2010

Description: CoC-Actuate is a competency centre for Actuate tools. Actuate tools include Enterprise report designer, iServer and ActivePortal. CoC-Actuate is for developing custom reports for SPARTA (Siemens Project Assignment Resource and Time Management Applications).The purpose of this project is to develop new custom reports for different countries using Oracle Primavera Evolve and maintain the existing custom reports. Developed reports are integrated in Primavera-Evolve as Custom Reports.

Tools and Technology:

• Primavera Evolve 8.0

• Security and Account Manager (of Primavera Evolve)

• Primavera Administration (of Primavera Evolve)

• Configuration Application(of Primavera Evolve)

• Actuate Enterprise Report Designer 8.0(SP2)

• Actuate iServer

• Actuate iPortal

• Agile methodology of software development

• SQL-SERVER-2005

• IIS

• VMWARE

• Tortoise-SVN-Client

• T-SQL,PL-SQL/ASP(VB/java script)/CSS, JavaScript, jQuery

• ANT1.7.0

• Live Meeting

Role and Responsibility:

• Tech Lead for Actuate and Primavera Configuration

• Analyzing the customer requirement.

• Estimation of user stories for each Report or task.

• Developing reports using Actuate Enterprise Report Designer 8.0(sp2)

• Implementation of Oracle Primavera security APIs in reports.

• Translating Business Logic of report into stored procedure and sql queries for Reports

• Deploying reports on Actuate iServer.

• Configuring Primavera Evolve as per report specification for testing.

• Developing other artefacts for the GUI purpose. eg. Generalised pool picker, resource picker, calendar.

• Preparing importer sheet for importing data into the Primavera Evolve for testing purpose.

• Maintenance of virtual image.

• Documenting Report Specification, UATs, Installation document and User Guide.

Project: SPARTA-Siemens Project Assignment Resource and Time Management System.

Client and Organization: Siemens Information System Ltd, Gurgaon,India

Duration: Feb 2008 to June 2009

Description: SPARTA is an enterprise resource management solution that includes three dimensions - time sheeting, resource management and project lifecycle management. The main aim of this project is to implement the Primavera Evolve (Oracle PLM Solution) Globally in different business unit of SIEMENS INFORMATION SYSTEM Ltd. SPARTA program was managed from head quarter Germany.

Tools and Technology:

• Primavera Evolve 8.0

• Security and Account Manager (of Primavera Evolve)

• Primavera Administration (of Primavera Evolve)

• Configuration Application(of Primavera Evolve)

• MS-word, MS-Excel MS-PowerPoint

• NetMeeting

Role and Responsibility:

• Team Member

• Analysis of existing system

• GAP analysis of Global and Local processes

• Alignment of Global and Local processes

• Documenting the system requirement

• Preparing the pool structure (EPS,OBS) and foundation data for primavera- evolve configuration Writing UAT & Test Cases

• Testing of system after configuration

• Educating core users

Project: Neotel Portal

Client : Neotel is South Africa's first converged communications network operator, dedicated to improving the way

South Africans communicate. Neotel is redefining the telecoms market. The company aims is to challenge

convention, without compromising on world-class standards and service.

Organization: Siemens Information System Ltd., Gurgaon, India

Duration: Oct 2007-Feb 2008

Description: The project aims at configuring the network elements through the web based interface so that the

Neotel customers can change the parameters and Bandwidth on demand of their own beside that

customer would be able to view the reports for their SLA parameters and packet-in/packet-out as well

as bandwidth utilization per interface.

Tools and Technology:

• Core JAVA, Servlet, Swing, JDBC, PL/SQL,

• JFreeChart API

• Netbeans 5.5

Role and Responsibility:

• Team Member & Developer

• For Graph Module. To develop the graphs and charts using JFreeChart API and integrating the same in the Portal

Project: SICAD-NetMinister-OSP

Client & Organization: Siemens Information System Ltd., Gurgaon,India.

Duration: Jan 2007-May 2007

Description: To enhance the existing software as to suit the changing needs of the Telecom sector.

Tools and Technology:

• Core JAVA, Swing, JDBC, PL/SQL

• Netbeans 5.5

Role and Responsibility:

• Team Member, Developer

• Drawing module

Certification and Training

• Create Analysis and Dashboard 11gR1 Training from ORACLE University in August 2012

• Certification of Actuate Enterprise Report Designer Professional in March 2009.

• Five days training of Primavera Evolve at Siemens Information System Ltd in April, 2008.

• Three Months (31July08-27Oct08) Induction Training in Siemens Information System Ltd. at Kharghar,Mumbai.

• Five days training of Corizon at Siemens Information System Ltd in March, 2007.

• Certification of I.B.M. Web-sphere in December,2006

Academic & Professional Qualification

• MCA from School Of Computer Science DAVV, Indore with 9.15 GGPA.

• B.Sc (Hons) (Math) from LNM University Darbhanga, Bihar

• High Secondary (Science Group) from Rose Public School (CBSE)

• High School from Gyan Bharti Public School (BSEB, Patna)

Personal Particulars

Brief Profile : A firm believer of karma, sincere, keen learner and friendly in nature.

Date of Birth : 2nd February 1982

Strengths : Adaptability, Learning, Team player, good communication and analytical

Skill.

Hobbies & Interests : Listening music, reading novels, teaching and cooking

Language Known : English and Hindi

Passport no : F8760739

Contact Address : A3-5-7, Cyberia Condos, Cyberjaya, Selangor, Malaysia

Declaration

I hereby declare that the above specified information is true to the best of my knowledge and belief.

Date:9-2-2012

Place: Malaysia (Mitul Avijit)

Contact this candidate