RANJEET SINGH BIJAY

Mailto: aboduu@r.postjobfree.com (w)

aboduu@r.postjobfree.com (p)

Phone: 415-***-**** (Mobile)

707-***-**** (Home)

An accomplished Software Developer/Engineer specializing in Client Server

application development and database programming with experience in all

phases of software development life cycle. Specialization in EDMS/Filenet

System Support and Documentum 6 and eGain Knowledge Management GenRef

Support

SUMMARY

. Total 12 years' experience in Design, Development, Coding Testing &

Implementation

. Extensive development experience on various projects in DOS/Windows

NT/Windows 95 & UNIX environments (Platform: VB5.0/VB/VBA 6.0 Using

Active x Controls.COM/DCOM and Oracle / SQL Sever7.0 as back end)

1. Extensive knowledge in the development of COM/DCOM components using

Visual Basic(Active-X DLLs, EXEs and Active-X Controls)

. Extensive experience in E-Commerce Applications.

. Experience in development of multi-tier architectures

2. Expertise in database design and server side programming in Oracle

8.1.7, SQL Sever 7.0/6.5 using stored procedures and triggers,

PL/SQL, MSSQL

3. Good experience in front-end database programming using ADO, DAO and

ODBC.

4. Experience in multi-tier architecture development using MTS and IIS.

. Extensively worked on WEB development applications using,

ASP,XML,Visual Basic,Visual INTERDEV, VB Script, JavaScript, HTML,

DHTML/PERL,CSS, Dreamweaver, Adobe Photoshop,

. Strong XML parsing and data manipulation expertise

. Understanding of Document Imaging / Expertise in Filenet Document

Management System P8 and IBM DB2 document management system

. Hands on Experience in VB.Net, ASP.Net C#.Net, JAVA.

. Web server configuration ( IIS and System Admin)

. Experience in handling 24/7 On call duties

. Working knowledge of CC&B (Customer Care and Billing) - Billing and

rates

. Strong knowledge in PL/SQL, MS SQL.

. Strong Relational Database experience for configuration and migration.

. Project resource and performance management experience

. Knowledge of cross-platform, multi-browser development issues

. Strong knowledge of Windows (95/98/2000/XP/7) and Windows Server

(NT/2000/2003/2008).

. Working knowledge of PC hardware and operating systems, including

laptops and desktop models, LAN/WAN, Microsoft networking.

. Knowledge of networking

. Self-motivated, self-directed, and self-confident

. History of achieving/exceeding goals

. Strong Internet and computer literacy skills in Microsoft Office

(Word, PowerPoint, Access, and Excel)

EDUCATIONAL QUALIFICATION

. Bachelor Degree in Commerce.

. Post Graduate Diploma in "Systems Management" from NIIT

. Oracle Database Administration from Berkeley Extension CA. USA

. Unix Administration from Berkeley Extension CA USA

. Certified Filenet Panagon CS Administrator From Filenet Corp.

. Certified in Kofax Capture Version 10

. Knowledge working with KTM 5.5

. Certified Documentum version 6 System Admin

. Certified Documentum v 6 Fundamentals

. Certified Documentum Advanced System Administration

. Certified in Captiva Version 5.5

HARDWARE

IBM 3090, PENTIUM / Compaq & Intel based Servers & Workstations.

OPERATING SYSTEMS

MS-DOS, WINDOWS 95, 98, 2000, XP OS/2, NOVEL LAN 3.11, MVS, VSAM, CICS,

DB2, JCL, WINDOWS NT & UNIX/LINUX

LANGUAGES

Visual Basic 5.0/6.0, VB.Net, ASP.NET, C#, Java, VBScript, JavaScript,

PLSQL, HTML4.0, DHTML, MSCOBOL, JScript

WEB TECHNOLOGIES

Active Server Pages (ASP), Visual Interdev6.0, ADO, IIS, XML, MTS,

Frontpage98

DATABASES

Oracle9i,SQL Server 6.5/7.0,MS Access and DB2.

GUIs

Visual Basic 5.0/6.0 Crystal Reports. DAO, RDO, ADO

PROFESSIONAL EXPERIENCE:

Client: Pacific Gas and Electric Company: -San Francisco / San Ramon - CA

(Oct'2000- present)

Title: Sr. Programmer and System Analyst and Production Support

Projects Involved:

. Documentum for MOAP/GAS Operation

. Genref Project for Customer Call Center

. Etariff for Electric Transmission Rates Department

. Kofax / Scanning and OCR for Accounts Payable /HR/ERU

. EDMS/ Filenet / (Document Management System for PGE)

Roles:

. Lead Documentum Developer and System Administration

. Lead Kofax/Captiva Developer and System Administration

. Lead Filenet Developer and System Administration

. Acted as IT System Analyst and Data Analyst.

. Acted as Business Analyst

Environment:

. BEA/Weblogic/Apache, Oracle on Linux, Oracle 11g. SQL Server,

. Java/ JavaScript, ASP, VB Script, PERL, PHP, PL SQL, MS SQL.

. Documentum Server Version: 6.7.1060.0128 Linux. Oracle

. Unix/ Linux, Windows Servers 2003,2008

Documentum Environment:

. Documentum (version 6.5+)

. System Administration of Operating Systems - Linux (RedHat) and

Windows Server (2008)

. Web Servers (Weblogic/JBoss, Apache)

. Relational Databases (Oracle)

. Documentum Query Language (DQL)

DM Admin Responsibilities:

Managed Users (user accounts)

Managed Groups

Managed Roles

Managed Policies & ACLs

Managed Collections of Information (Cabinets)/Folders

Create, Run, Manage System Reports

Deployed Artifacts to Pre-Production and Production Environments

Refresh Data in Staging Environments

Configuration Manage the System

Upgrade Documentum Components

Installed Documentum Components

Monitoring Documentum Housekeeping Jobs

Migrated Documents from QA to PROD using dump and load method.

System Admin Responsibilities:

Installs/Administers/Maintains the delivery systems hardware and software

and the network in accordance Provides computing hardware and system

software problem resolution

Performed Capacity Planning

Storage and Security Administration

Monitored Backups

Technical Skills: In KOFAX CAPTURE 10 and Captiva.

. Provided Kofax technical expertise

. Responsible for the analysis, design, programming, debugging and

testing the application

. Experience in Installing & configure Kofax components

. Experience in Install & Configure Kofax Client modules (Admin

/ QC/ Review/ Validation and Release)

. Experience in Configure Kofax batch classes and their desired

properties.

. Experience in Configure KTM Classification and Separation.

. Configure KTM Extraction to extract the data from the documents.

. Produce efficient error-free programs.

. Conduct unit, integration, and system testing

. Provided full-time support throughout test phases

. Prepared applicable system documentation

. Performed both development and software support roles

. Assisted with troubleshooting production application system

. Worked closely with the solutions Architect

. Delivered training to business users and Knowledge Transfer

Responsibilities:

. Work with business analysts, developers, project managers, and

users to capture, define, and document business requirements

. Advanced experience in Imaging Technologies including Document

Scanning, Distributed Capture, understanding of Imaging File

formats, Data Extraction, OCR, ICR, Barcode Recognition, Document

Separation methods

. Working with other technology areas to facilitate integration

with external systems

. Experience with developing and configuring Web Services in order

to customize ECM solutions

. Advanced knowledge of .NET Scripting and ASP .NET in order to

develop custom and exception processing modules for Imaging

applications

. Ability to work in a team environment as well as independently

. Perform testing support for ECM Kofax/Captiva applications

. Troubleshooting and performing root cause analysis on application

and web servers to diagnose issues and rectify them

Project: GenRef (CCO)

Role: Sr Application System Support for eGain Web Portal Design.

Environment: Java/Java Script/HTML/AJAX/APACHE/BEA/Weblogic, Oracle on

Linux.

The General Reference Redesign project falls within the 2010 Service

Initiative's focus for "Improving CO Employee Knowledge." Implementation

of a new tool is focused on strategic actions to improve the customer pain

points.

Long term - multiple phases:

. Redesigning existing knowledge resources for enhanced effectiveness

. Adding new knowledge resources and tools where knowledge gaps exist

. Implementing systems for accountability/assurance that current

knowledge resources are used and useful as designed

Project Objective:

Redesign or replace the Customer Service Representative (CSR) General

Reference tool in order to provide greater functionality, improve the

accuracy and consistency of the information provided to customers, and

reduced handle time of customer calls.

Scope of work:

The General Reference Redesign Phase 1 will

1) Select through request for proposal, purchase and install new

Knowledge Management software and supporting hardware environments.

2) Enable crawling to existing General Reference documents and

information and/or facilitate the creation and/or porting of the

existing General Reference database.

3) Provide automated topic search to the receiving Customer Service

Representative based on last topic selected by a customer from the

Integrated Voice Recognition (IVR) system.

4) Facilitate analytics enabling improvement of use, quality of content,

acceleration of search and expansion of Knowledge Management solution.

5) Identify and provide a timeline for subsequent phases/projects to

integrate additional support and business systems to the Knowledge

Management solution.

The General Reference piece of the Customer Operations Service Initiative

will implement a series of improvements to the existing knowledge tool, and

add new resources/features for CSR's and other CO employees who rely on

technical documentation for job performance. Specifically, this

encompasses replacing the current tool's capabilities with functionality

for operational efficiency (i.e. quickness of use while handling customer

inquiries), ease of navigation (i.e. how quickly policies and procedures

can be located), effectiveness of comprehension (i.e. is the tool properly

communicating the proper procedures), and accountability (i.e. ensuring all

available resources are used).

Project: eTarrif

Role: Lead IT System Support and Analyst

Environment: Java/JavaScript .Net and SQL Server.

Project Description:

Ability to electronically file baseline tariff filings at FERC beginning

April 1, 2010 (eTariff initial Implementation Date). Pursuant to FERC's

eTariff Final Rule ("Order No. 714"), PG&E is required to submit filings to

establish its baseline open access tariffs with implementation of this

ability to begin on the Implementation Date, pursuant to a subsequent six

month staggered schedule ("Initial Implementation Period"). Upon successful

submittal to FERC, the baselined tariff establishes a unique Tariff Record

in FERC's eTariff system against which all future Tariff Changes to the

tariff are compared.

Project: Electronic Data Management System (EDMS)

Role: Lead Filenet Web Developer and System Support

Environment: ASP 2.0 With IIS, VBScript, JavaScript/Perl HTML using Visual

Interdev Visual Basic 6.0 under MTS, C#, VB.Net,ASP.Net Oracle9i./Sybase

Unix platform, VSS. Filenet/ Panagon CS System/Filenet Open Client/Document

Services and Image Services, IBM DB2 Document Management.

Project Description:

Electronic Document Management Systems (EDMS) supports automated processes

for Information Management. EDMS provides electronic management of paper by

storing the information in an electronic library in an online reporting

system. EDMS reduces costs associated with printing and managing paper

documents. Effective document management will streamline business processes

and automate the work associated with managing paper documents

Panagon Doc Services provides a centralized, easy to use [pic]

facility for managing electronic documents.

Services include:

Automated retention and backups

Document version control

Archiving processes

Automated checking and checkout processes

Security can be assigned based on a specific document or group

of documents and by individual user or groups of users.

Security includes viewing and / or modification capabilities.

Scanning solutions supported include Kofax, OCR for Forms, etc.

Kofax supports high volume scanning processes. OCR for Forms

enables character recognition from your forms. Scanning

solutions can reduce/eliminate data input processes. The

scanning software can be integrated with our EDM products to

provide a comprehensive, automated means to manage your

documents.

Role:

. Acted as Filenet Specialist for the development team and project

management team.

. Administered the development and production Filenet Content Services

and Web Servers.

. Designed and developed a wrapper for Filenet IDMWEB.

. Modified FileNet's out of box IDMWEB web front end for Business

requirements

. Used FileNet Content Services 5.2, Visual Basic 6.0/.Net, Java,

JavaScript, ASP Kofax and Oracle/MS SQL.

. Support Clients /Customers, Bugfixing, Production Support Developing

new web pages. Interaction with clients and customer and problem

solving.

. Develops and maintains complex programs to meet business unit needs.

Provides application development services to create new applications,

enhance existing applications and to implement purchased software

applications which deliver business unit value.

Primary focus is design and development of software applications and

components, and evaluation and implementation of third party products.

Modifies and enhances programs as appropriate to user requirements.

Supports the design and development of applications through

requirements, design, development and documentation, programming, unit

testing and other tasks related to the systems development life cycle.

Responsible for requirement validations, designing, developing,

testing and implementation of software applications and packages,

using a variety of legacy, client/server and web based technologies.

Consults with users to finalize the requirements and application

design.

Works with interfacing departments and vendors to define download

requirements, coordinates scheduling and implementation with release

management.

Develops and prepares general and detailed specifications and related

documentation.

Writes detailed technical and system documentation; assists in the

creation of user documentation.

General Responsibilities:

. Understand and maintain a detailed knowledge of the application

development and maintenance life cycle (SDM).

. Understand ISTS organization and ISTS initiatives, such as technical

architecture, development standards, project principles business

model, mission, vision etc. Incorporate models into projects as

appropriate.

. Respond quickly to system outages and client calls. Keep clients and

team members informed regularly on the status of the problem until it

has been resolved.

. Be proactive in training backups for our assignments before leaving

for an extended period to meet client's service level expectations.

Key Responsibilities:

. Developing individual work plans including task estimates and

timelines.

. Prioritize and manage individual task to meet the defined deadlines.

. Monitor progress of work assignments and provide concise and timely

status as needed.

. Design proper indexing, folder structures and security for EDMS

applications based on the client's requirements but also adhere to

EDMS standards and guidelines

. Develop scripts as needed to integrate vendor software and balance the

long term maintenance implications with customization and meeting

client's needs.

. Develop scripts that reuse existing code and adhere to EDMS standards

and guidelines. Develop documentation for the code and schedule team

reviews of code and documentation.

. Develop comprehensive test plans and execute unit testing and system

integration testing techniques and practices.

. Provide primary support for the EDMS support line.

. Develop expertise with scanner software and viewers to provide

technical support for clients, Upgrade Clients with latest KOFAX

Ascent Capture.

. Develop structured testing and troubleshoot desktop integration with

Panagon products, on demand, Brio, Auto view etc.

Client: INTEL Corp - Santa Clara -CA (May'2000 -Sept'2000)

Project: Martinque Project - IION (INTEL INSIDE ONLINE NETWORK)

Role: Web Developer

Environment: ASP 2.0 with VBScript, JavaScript, HTML using Visual Interdev,, Visual Basic 6.0 under MTS, Oracle 8.1 using Embarcadero and Toad, on

Windows NT platform, Visual Source Safe, Rational Rose, PVCS Tracker

Project Objective:

The objective of Martinique is to build an industry leading marketing

support solution that enhances the value of Intel inside Program.

Martinique is a leading -edge Web solution and showcase candidate for

Intel's new e-Commerce vision ("Successfully pioneer the use of e-

Business")

Project Description:

The Martinique project is involved in the development of a website to

handle advertisement reimbursement to licensee companies that are

participants in the Intel Inside Program. IION will be a showcase ecomm

website for Intel in B-to-B transactions to cater to its own requirements

to handle disbursements running into billions of dollars. This is a

prestigious project with a team strength exceeding 100.

The Website uses ASP at the front-end with VBScript for server-side and

JavaScript for Client-side validations. It uses Visual Basic 6.0 in the

middle layers of User Interface and Business Component. The database is

Oracle 8.i. The application uses MTS as the middleware to distribute data

calls. All database queries use only Stored Procedures. There is a

fullfledged Security object to check access at login, and an Architecture

Object to create connections and make standardized database calls.

Responsibilities:

Designed and developed ASP pages using HTML/DHTML

. Create User Interface Controller Object.

. Display default error message to the user if fails to create User

Interface Controller Object

. Call method of UIC to get the User Profile information if that info is

not passed from previous logical page.

. Call method on UIC to check security,

. Call method on UIC to check preconditions to display the ASP pages.

. Call method on UIC to get the initial data to be displayed on the ASP

page from the database.

. Get all inputs values and validate them by calling common functions

from Common ASP.

. Call method of UIC to get any validation errors by converting them

into local language. Display those Errors in the same ASP page.

. Call method of UIC to capture all the validated input values in the

ObjectContext of UIC.

. Gets the output from the User Interface Controller object in the form

of recordsets if it is a query to the database.

. This output is a return parameter and output parameter.

. Gets the output as a Boolean return value from the User Interface

Controller object it it is writing to the database

. Saying whether transaction is successful or not.

. Generate HTML output depending upon the return values received from

User Interface Controller.

. Do ASP related error handling. Display all errors raised from UIC in

local languages.

. Engaged in Code Reviews and Code Cleanup exercise.

. Participated in the preparation of Test Scripts for individual use

cases and for end to end tests, and their execution to identify and

track bugs. Involved in bug fixing, problem solving and

troubleshooting.

Client : MVX.Com - Quantumshift.com- Novato - CA (Oct'99 - April

2000)

Position : Senior Developer.

Project : InterAct.

Interact is web based telecommunication management system. Mainly this is

an

E-Commerce based project dealing with telecommunications products like

Calling cards for long distance and prepaid phone cards. It provides

services for all types products. The project uses Microsoft technologies

like VB/ASP, JavaScript, Vbscript, COM, MTS and Xml. The Webscreens are

designed using XML and ASP with DHTML. It uses Visual Basic COM components

for registering the dll and inserting the data into database and MTS as a

server for transaction.

The project gives both customers and employees an overall picture of their

services including information of sales contacts account balance, payments

and active services.

Responsibilities:

. Designed and developed ASP pages using HTML/DHTML and XML

. Retrieved data from the Oracle database

. Developed COM components and registered the same.

. Used MTS as a server for transaction

Contact this candidate