Project Management

Prakash Sanka

M: 678-***-****

M: 510-***-****

PROFESSIONAL SUMMARY

. Over 6 years IT experience with different technologies including CA

CLARITY.

. More than three years experience working in CA Clarity 7.5, 8.0, 8.1 & 12

versions.

. Close to three years experience working in Oracle 8i/9i/10g, Microsoft

SQL Server 2005 and development of software projects in Java/J2EE using

JDBC, Servlets, GUI design, and Object Oriented Programming.

. Experienced in customizing Clarity Studio to include custom objects,

custom fields, custom Portlets and sub-pages for Project Management,

Resource Management and Demand Management modules.

. Experienced in New Installations of Clarity and also Clarity from v7.5 to

v12.

. Experienced in Deploying new modules of Clarity.

. Experienced in providing end-user training and support for New

User/Project Setup, Project and/or Resource profile changes, custom

attributes and custom Portlet and/or Portlet pages.

. Created and configured Organizational Breakdown Structures to enforce

system security using access rights and captured additional hierarchical

information for Projects and Resources. Standardized roles across

companies for easy administration.

. Experienced in setting up Clarity processes.

. Experienced in XML Open Gateway (XOG).

. Possess excellent analytical, written and verbal communication skills

with proven ability to multi-task to competing deadlines efficiently with

both internal and external customers.

. Experienced in gathering Business Requirements and Technical design

specifications.

. Excellent service oriented work ethic, attention to detail, flexible and

adaptable to change.

. Motivational inter-departmental team building skills.

. Experienced in all phases of Iterative Software Development Life Cycle

(SDLC)

. Proven ability to work independently and as a team player in design,

development, and implementation of IT innovative business processes and

system solutions.

. Proficient in learning new technologies and quickly adapting to new

environments.

. Experienced in using IDEs such as Eclipse, JBuilder and NetBeans.

. Experienced in Java, Servlets, JDBC & SQL.

. Excellent knowledge of Internet Protocols like SNMP, TCP/IP, and SMTP.

. Experienced in Network Management (Router Configuration, Workstation

setup

. Excellent knowledge of Computer Networks (Internet & LAN) & Security

(LDAP, SSO, HTTPS, Kerberos)

. Experienced in Oracle 8i/9i/10g, SQL.

. Excellent knowledge of testing tools (Automated and Manual)

. Experienced in training users in Clarity processes

Education:

Master of Science in Computer Science. (M.S.)

Bachelor of Technology in Electronics & Communications Engineering.

Certifications:

CA Accredited Professional

(CA Certified - Clarity Studio Developer, Clarity Technical Essentials I &

II 200, Clarity Technical Essentials III 300, Clarity Boot Camp Technical

Track)

Certified in Networking Management, Metrology, Micro-Controller

Programming, Electronic Assembly Techniques with excellent performance from

CENTER FOR ELECTRONICS TEST ENGINEERING (An ISO 9001:2000 Certified

Training Institute, Govt. of INDIA)

Technical Skills:

Project Management Tools Clarity 7.5/8.0/ 8.1/12, ConceptDraw.

Programming Languages C, Java.

Browser Scripting Languages Java Script, HTML, XML, AJAX and GEL

Server Scripting Languages Servlets, PHP, SQL, PLSQL

Assembly Languages 8056, 8086

Application / Web Servers IBM WebSphere 6.1, Java Application

Server and Tomcat 5.0/5.5

System Design UML, Rational Rose, DreamWeaver,

SmartDraw

IDE Tools NetBeans, JBuilder and Eclipse

Databases MS-SQL 2005, Oracle 8i/9i/10g and MS

Access.

Operating Systems Windows 98, 2000/2003/NT/XP.

Internet Router Configuration, SNMP Agent &

Management, TCP/IP, DHCP, DNS

Networking Tools Ethereal, Wireshark, Netmonitor, MIB

Browser, AdventNet Utilities

Data Communications ISDN, X.25, Packet & Circuit Switching

Communications Wireless Communications, Mobile

Technologies

WORK EXPERIENCE:

GTECH - Providence, RI, USA

Clarity Administrator/Support/Technical Consultant Duration:

January '10 - July '10

. Worked as Clarity Administrator/S.M.E alongside daily operations,

development and production support.

. Installed a new Clarity Instance on the Sandbox with full

functionality to test the Upgrade from 8.1 to 12.0.6 (latest version

till date).

. Trained Users in how best to use CA-Clarity for Project Management and

Resource Management along with the best practices.

. Deployed Demand Management Module of Clarity and trained users on how

to use the IDEA object efficiently.

. Dealt with SAP and Clarity integration issues and daily development

work requests through JIRA.

. Back-ups of Clarity Installations for security and safety rationales.

. Upgraded Clarity from 8.1 FP 03 to 12.0 SP6.

. Reviewed upgrades for changed features, system and project impact.

. Configured LDAP for easy management and SMTP for email features

through CA's NSA/CSA.

. Ran Health - Reports to check Validation of Clarity Installation.

. Viewed Log - Files for problem resolution.

. Provided Technical, Functional and training expertise for Project,

Resource, Financial and Demand Management modules of CA Clarity for

customers and service contracts.

. Created efficient GEL scripts for running scheduled batch jobs, for

loading data from SAP, for sending weekly system-generated automated

emails to employees with open timesheets, etc..,

. Created and customized new and existing Objects/Sub-objects.

. Created and modified Portlets using existing/new Objects and NSQL

based query Portlets for efficient administration of resources,

projects, Reports & Jobs for optimum performance.

. Created process work flows based on business requirements.

. Managed page content by adding Portlets to Pages.

. Extensively used XOG for xogging data in and out of different

environments.

. Managed Cost Matrix using Clarity's Financial Management module.

. Managed and troubleshot issues with Open Workbench and MS Project

modules to interface with Clarity VIA Schedule Connect interface.

Environment: Clarity 8.1 FP03, 12.0 SP06, SAP, MS-SQL Server, Apache

Tomcat, Windows, NSQL, GEL, JIRA.

Turner Broadcasting, Atlanta, GA

Clarity Developer/Production Support Duration: September '09 -

January '10

. Created GEL scripts for easy administration of resources, idea object

and projects.

. Troubleshot issues with AXIS Reporting.

. Extensively used XOG for xogging data in and out of different

environments.

. Xogged object and project, modifying and/or custom templates and

established database connections to support object or project

properties.

. Modified processes that converts and automates an IDEA into a Project

using Demand Management module of Clarity.

. Data administration activities such as creating lookups/multi-valued

lookups and job definitions.

. Managed Cost Matrix using Clarity's Financial Management module.

. Resolved timesheet issues and inefficient action items for the end-

user.

. Created process work flows based on business requirements.

. Experienced with STARS - REMEDY.

. Best Performance grade in CNN's Monthly Customer Survey Reports.

Environment: Clarity 12, Stars - Remedy, AXIS Reporting, Apache Tomcat,

Windows, NSQL, GEL, Aqua Data Studio.

PPM Essentials, Arkansas, USA

Clarity Technical Consultant Duration: December

'07 - September '09

. Installed and Deployed out-of-box Clarity instance for several

clients.

. Consultant on several CA Clarity Installation and Upgrade projects

across Clarity 8.0 to 8.1 and to v12.

. Provided Technical, Functional and training expertise for Project,

Resource, Financial and Demand Management modules of CA Clarity for

customers and service contracts.

. Troubleshot end-user issues in a timely, professional and efficient

manner.

. Configured LDAP for easy management and SMTP for email features

through CA's NSA/CSA.

. Ran Health - Reports to check Validation of Clarity Installation.

. Viewed Log - Files for problem resolution.

. NSA, installation, validation & maintenance of required services.

. Worked directly with stakeholders and PMO to develop Business

Requirements and Technical design specifications, ensuring all

documentation was signed off prior to implementation and was SDLC

compliant as per organizational standards.

. Created efficient GEL scripts for running scheduled batch jobs.

. Created NSQL based query Portlets for efficient administration of

resources and projects.

. Created and managed Cost Matrix using Clarity's Financial Management

module.

. Created users with external authentication and providing end-user

support for Project Setup, Resource & Project profile changes.

. Dealt with Clarity integration issues and daily development work

requests.

. Extensively used XOG for xogging data in and out of different

environments.

. Resolved timesheet issues and inefficient action items in the users'

action items list page.

. Modified NSQL based queries in Reports and in Jobs for optimum

performance.

. Data administration activities such as created lookups/multi-valued

lookups and job definitions.

. Worked with Open Workbench and MS Project Modules to interface with

Clarity VIA Schedule Connect interface.

. Reviewed upgrades for changed features, system and project impact.

. Back-ups of Clarity Installations for security and safety rationales.

. Created process work flows based on business requirements.

. Managed page content by adding Portlets to Pages.

. Created Portlets using existing and new Objects and queries.

. Created new Objects/Sub-objects and customized existing Objects/Sub-

objects.

. Xogged object and project, modified existing and/or custom defined

templates and established database connections to support object or

project properties while Xogging.

. Customized Menu Manager.

. Developed various notification processes to send notifications to

different user groups including management.

Environment: Clarity 8.0, 8.1 and v12, MS-SQL Server, Oracle, Apache

Tomcat, Windows, NSQL, GEL, Aqua Data Studio.

First Data International (FDI), Basildon, UK

Clarity Technical Consultant Duration: September '06

- November '07

. Trained users in Clarity application and understanding of clarity

functionality.

. Team member in implementation of upgrade from Clarity 7.5.3 to 8.0.

. Created resources, groups, and OBS units and required user privileges.

. Set up user and resource records in Clarity.

. Configured system to Auto-Generate a Project ID, Risk ID, Issue ID and

Change Request ID number etc..,

. Created project level dashboards for Milestones,and project management

by managers, analyzed pain areas and provided technical solutions

using GEL scripts and database objects.

. Created and configured custom objects & attributes, developed

organizational break down structure (OBS), and also groups.

. Distributed work according to resources knowledge and skills.

. Performed data load configurations using the XML Open Gateway tool.

. Created Process Flow Notifications for users as per requirements.

. Created ad hoc SQL queries for users as per requirements.

. Created Action Items, Events, and Notifications for assignment to

users.

. Assignment of participants to projects, creation and assignment of new

tasks to participants.

Environment: Clarity 7.5.3, Oracle 10g Server, Apache Tomcat, Windows.

JJ Computer Systems, Essex, UK

Oracle SQL/D.B.A Duration: June '05 -

September '06

. Programming in Oracle SQL & PL/SQL.

. Ensured queries optimized, tables correctly indexed and data accurate.

. Troubleshot databases and custom application issues.

. Performed DBA duties including database backups and restorations.

. Application design, development and administration using Microsoft

Access.

. Used PL/SQL and SQL*Plus programming to write stored procedures,

queries, objects, and views on normalized database tables.

. Worked closely with other systems staff to ensure high, overall

database performance, network communication, and security within the

database environment. Maintained effective backup/recovery strategy

and support documentation.

. Provided operational support for database by implementing predefined

SQL processes. Modified and maintained software programs written by

other programmers.

. Team Member in a team of DBAs in migration of databases from Oracle 9i

to Oracle 10g Release.

. Addressed a variety of database integration issues including

migration, integration, maintenance, conversion, new applications, and

capacity planning issues.

Environments: Windows, Oracle 9i Server, SQL, PL/SQL.

Global Customer Works Trading Services - Hyderabad, India

Java Developer Duration: January '05

- May '05

Developed the company website through which a customer can register and buy

company products. My role was to gather requirements and then design the

system, providing functionality to download system data upon product

purchase completion and also allow the user to make updates to the

registered user details. Worked as a developer as per company requirements.

. MyEclipse utilized for development and design of the system.

. HTML used for system design. JavaScript used for validation.

. Servlets used for server side coding.

. File system and RMI used for downloading files and updating system.

. File system used to store queries from the system, so that no re-

deployment of the system was necessary.

. JDBC API was used for system connectivity with database.

Environments: Windows,Oracle 8i, MyEclipse, Java 1.5, HTML, Servlets, and

JDBC

Java Developer Duration: June '04 - Dec

'04

Developed an internal chat application for company use. The system

specification included ability to add, delete and maintain users and

groups, chatting for problem resolution, conference ability between more

than two users, file transfers and have the ability to integrate within

existing company tools and on LAN.

. Gathered system requirements from management and end users.

. Researched understanding of chat systems present in the market.

. Complete understanding of the functionality of the system.

. Database design in Oracle 8i for maintaining user lists, groups,

offline messages and logins of the system.

. Designed GUI interface system using NetBeans4. HTML was embedded with

the components for efficient look and feel.

. Web Service SOAP used for data transfer between two nodes/users.

. Java file system used for file transfer between two nodes. JDBC API

used for system connectivity with the database.

. Exe4j was used for exe file generation for chat system.

Environment: Windows, NetBeans 4, JSwings, JDBC, HTML and Oracle 8i.

Java Intern Duration: Jan '04 - June

'04

The company had a small local depositor system for employees to deposit

their financial savings. The system requirements were to expand the local

depositor system to include 24 branches internationally and enable existing

local depositor system data to be stored within the enhanced new system. A

Depositor System was developed using JSwing as an attractive design tool

for the front end interface and Oracle 8i database was used as back end.

JSwing was selected given component availability is widespread allowing all

types of Standalone and Distributed System developments. Oracle was

selected given the company was in justified need of a centralized database

system.

. Used Netbeans4 as IDE tool to develop the Java application.

. AWT used for component handling and functionality.

. Combination of HTML and JSwing used for better look and feel. For

static design, HTML was embedded in JSwing, programmatically.

. All components used multiple times in same and different applications

were reviewed thoroughly and java beans prepared so that the

reusability concept of OOPs was achieved efficiently utilizing Oracle

8i as backend.

. JDBC API's used for database connectivity and the use of Database for

correct system formatting.

. Backup of the system was set in the software and MS Access utilized.

. Executable file was prepared using Exe4j.

Environment: Java 1.4, JDBC, UML, Oracle 8i, MS Access and Netbeans4.

References: Upon Request.

Contact this candidate