L alatendu Bishoyi

CA Clarity PPM Developer

SAP Business Objects, Plsql,Unix Developer

Phone No.: +91-855******* Email: acgtcr@r.postjobfree.com

Profile

Offering more than 4 Years of experience in Clarity configuration, Clarity Up-gradation, Vanilla Installation, NSql,

gelscript,Data Warehousing, performance tuning.

Expertise in deployment, integration, Bugfix, maintenance and performance tuning.

Expertise at mapping the requirements, custom designing solutions & troubleshooting for simple and complex software

& application problems.

Have strong analytical skills and ability to analyze business practices and define optimal procedures or solution.

Highly skilled in analyzing existing business processes to the desired levels (GAP Analysis), evaluating available

technology-based solutions, suggesting appropriate business solutions and restructuring the business process.

Resourceful and deft in all phases of the SDLC (Requireme nt analysis, development, testing and troubleshooting) as

well as project management activities.

Professional Certification

Certified Oracle 9i Database Administrator

Certified Oracle 9i Database Professional

Skills

Development Tool: CA Clarity PPM, SAP BO XI 3.1, Crystal Report 2008,Actuate e.Report Designing Toad, SQL

Server Management Studio, SQL Developer, Bridge clarify, BMC Remedy, IPMS, IQMS

Databases: Oracle 9i/10g/11g, MS-SQL Server 2005/2008

Languages Known: SQL, PL/SQL, Unix Shell script, C, C++, C#, Java

Other Skills: Data Warehousing, Business Intelligence

Experience

Capgemini India Pvt. Ltd. – Since July’2013

Date Project Skills Used Client Roles / Designation

Jun’14- FS Clarity PPM Upgrade Clarity PPM 13.3, Oracle Capgemini Clarity Developer /

Till now 11g, SAP BO XI 3.1, Crystal Internal Consultant

Report 2008

May’14- BNL CoE Clarity PPM DC- Clarity PPM 13.1, Oracle Capgemini Clarity Developer /

Jun’14 Movement 11g, SAP BO XI 3.1, Crystal Internal Consultant

Report 2008

Apr’14- Global CoE Clarity PPM DC- Clarity PPM 13.1, Oracle Capgemini Clarity Developer /

May’14 Movement 11g, SAP BO XI 3.1, Crystal Internal Consultant

Report 2008

Nov’13- SDM CoE Clarity PPM Clarity PPM 13.1, Oracle Capgemini Clarity Developer /

Apr’14 Upgrade 11g, SAP BO XI 3.1, Crystal Internal Consultant

Report 2008

Jul’13- Global CoE Clarity PPM Clarity PPM 13.1, Oracle Capgemini Clarity Developer /

Nov ‘13 Upgrade 11g, SAP BO XI 3.1, Crystal Internal Consultant

Report 2008

Tata Consultancy Services – March’ 2009 to July’2013

Date Project Skills Used Client Roles / Designation

Oct’ 12 - Clarity PPM upgrade v7.5.3 to Clarity PPM 13.1, Oracle TCS Internal - Clarity Developer /

Nov ‘12 13.1 11g,Apache tomcat POC System Engineer

Apr’12 – Clarity PPM, CA Data Clarity PPM 7.5.3, Oracle 9i, British Clarity Developer /

Jul’13 Warehouse ApacheTomcat Telecom System Engineer

server,Actuate

Oct’10 – URC: Unified Rolling Calendar Classical asp,Sql server British .net Developer /

Mar’12 2005,IIS 6 Telecom System Engineer

Mar’10 – GS FINANCE and OLSSR net,Sql server 2005,IIS 6 British .net Developer / Ast.

Mar’11 Telecom System Engineer

Dec’09 – TCS Initial Learning Program -N/A- -N/A- Ast. System Engineer

Feb’10 – Trainee

Capgemini India Pvt. Ltd. – July’ 2013 to till Now

Jun’14-Till now: FS Clarity PPM Upgrade

Upgrade application to CA Clarity PPM from V12.0.6 to v13.3.0.5.

Project documentation.

Reporting server set-up and configuration.

Post upgrade fixing.

Script modification according to the change of database design.

May’14-Jun’14: BNL CoE Clarity PPM DC-Movement

Contribution:

Set- up of BO servers on new DC.

Clarity set-up on new DC environment.

Interfaces setup.

Unit and infrastructure testing.

Apr’14-May’14: Global CoE Clarity PPM DC-Movement

Contribution:

Set- up of BO servers on new DC.

Clarity set-up on new DC environment.

Interfaces setup.

Unit and infrastructure testing.

Nov’13-Apr’14: SDM CoE Clarity PPM Upgrade

Contribution:

Acuate to Crystal Report Conversion.

Upgrade application to CA Clarity PPM from V12.0.5 to v13.1.0.7.

Configured & customized the Clarity functionality with Custom Objects, Processes & Jobs. This includes

Partition Models, Lookups, Object attributes/views, Menu Manager, Time Slicing, OBS, Groups (for Security),

and Processes & Jobs.

Set up of CSA, Business Objects server and application server.

Configuration of CSP and PMO reports

Tuned and optimized queries by altering database design, analyzing different query options, and indexing

strategies.

Patch deployment.

Bug fix during upgrade.

Jul’13 – Nov’13: Global CoE Clarity PPM Upgrade

Contribution:

Upgrade application to CA Clarity PPM from V12.0.5 to v13.1.0.7.

Configured & customized the Clarity functionality with Custom Objects, Processes & Jobs. This includes

Partition Models, Lookups, Object attributes/views, Menu Manager, Time Slicing, OBS, Gr oups (for Security),

and Processes & Jobs.

Set up of NSA, Business Objects server and application server.

Configuration of CSP and PMO reports

Tuned and optimized queries by altering database design, analyzing different query options, and indexing

strategies.

Time slicing setup.

Tata Consultancy Services – December’ 2009 to July’2013

Mar’11 – Jul’13: Clarity PPM, CA Data Warehouse (Client: British Telecom)

Contribution:

Configured & customized the Clarity functionality with Custom Objects, Processes & Jobs. This includes

Partition Models, Lookups, Object attributes/views, Menu Manager, Time Slicing, OBS, Groups (for Security),

and Processes & Jobs.

Developed Clarity Business Process Management workflows using GEL Scripting, Queries using NSQL,

Portlets, Portlet Pages, and Actuate Reports.

Setting Up the Access Rights to Actors.

Writing the GEL Scripts for Sending notification to Sub -ordinate offices.

Involved in various clarity reconciliation process.

Involved in yearend rollover process for BTD&O.

Development environment refresh activity.

Tuned and optimized queries by altering database design, analyzing different query options, and indexing

strategies.

Involved in various inbound and outbound interface development.

Employed best practices to maintain the performances of database.

Participating in client meetings and gathered requirements from Subject Matter Experts (SMEs).

Various Data loads on clarity and CADW.

Clarity & CADW data integrity.

CADW reconciliation process.

Labour data and nonlabour data reconciliation both at Calrity and CADW side.

Performance tuning of various Clarity and CADW reports.

Key Result Areas and Highlights:

Essayed a key role in decreasing the SLAs and providing service improvements.

Oct’10 – Mar’11: URC: Unified Rolling Calendar (Client : British Telecom)

Contribution:

User account creation/Ad-hoc requests.

Password reset.

Data Load requests.

Bug fix and code change.

Yearend code change.

Participating in client meetings.

Mar’10 – Mar’11: GS FINANCE and OLSSR (Client : British Telecom )

Contribution:

User account creation/Ad-hoc requests

Password reset

Data Load requests

Bug identification

Production maintenance on performance related issues.

Coordination with server and network team in case of any issues.

Incident Management

Code change and Bugfix.

Data load.

Service improvements.

Sql tuning for reporting queries.

Key Result Areas and Highlights:

Essayed a key role in decreasing the SLAs and providing service improvements.

Dec’09 – Mar’10: TCS Initial Learning Program

Topics Covered:

Programming Technique using C++,Dr. Scheme, Dr. Java

Data Base Techniques, PL/SQL and Oracle 10g

Project Life Cycle, Use case Diagrams and ER Diagrams

Education

2009 B.Tech. (Information Technology) from Biju Pattniak University, Rourkela, Orissa (National Institute of Science

and Technology) with a CGPA of 7.76

2003 XII (Science) from CHSE, Odisha (Khallikote Junior College, Berhampur, Odisha) with 66.44%

2001 X from HSC, Odisha (Port Trust High School, Paradip Port, Odisha) with 81.46%

Trainings Attended

“Pre-ILP” training conducted by Tata Consultancy Services at NIST, Berhampur; Sep’09 – Jan’10

A course on “Oracle 9i” at NIST, Berhampur

Summer Course on “Core Java and Advanced Java” at Interface Software, Bhubaneswar

Extramural Engagements and Other Accolades

B.Tech Project “Software Engineering for MAThematics”(SEMAT) developed in java and awarded with best

project for the year 2009 in NIST, Berhampur.

Personal Details

th

Date Of Birth: PAN Number:

9 July 1986. ATYPB5591N

Linguistic Ability: Passport Number:

English, Hindi, Oriya, Bengali H7150173

I, hereby declare that the above statements made are complete and true to my knowledge and belief.

Date:

Place: (Lalatendu Bishoyi)

Contact this candidate