Oracle Management

Rashmi Potdar

************@**********.***

Cell # 703-***-****

US Citizen, residing in Centreville, VA, 20121

ACTIVE SECRET CLEARANCE

Skills Summary

More then 11 years of IT experience in project management,

infrastructure architecture, IT governance, IT policy, Federal compliance,

information security and infrastructure support operations for commercial

and federal organizations. Highly successful Configuration and Release

Manager focus on Software Support and proven ability to deliver cost

effective and quality IT Services that builds efficient Enterprise

Infrastructure IT operations and is geographically distributed. Expert in

tactical and strategic Enterprise Infrastructure and relating Data

Components Architecture, design, research, planning, Implementation,

migration, consolidation, administration, engineering, security, management

and Business continuity.Demonstrated leadership, leveraged business acumen,

management skill in globally distributed organizations and problem solving.

Individual contributor and Team player as well.

Key Skills and Knowledge

Domain Expertise & Solutions

Financial Systems, Customer Relations Management

Databases

Oracle

Operating Systems

UNIX, DOS, MS-Windows, Windows 98, Windows NT environments

Programming Languages & Tools

Sql*Plus, Pl*Sql, Oracle Forms, Oracle Reports, ADI, OFA, Discoverer,

ClearCase, ClearQuest, Collabnet, Subversion, Mercury, IV&V, RequisitePro,

MSProject, Familiar with Remedy

Project Experience

UNISYS

04/05 - Present

Working currently as a Configuration Release QA IV&V Management

using Collabnet and Subversion to stage the various assets to its staging

repository for its successful deployment for TSA.

Creating and modifying IV&V checklists for Delivery Release

Notice, Build Doc, Test Case Doc, Requirements Doc, User Acceptance Doc and

enforcing on the same on the various projects. Created branches for the

various Releases and Repair Operations as needed. Performing the merge of

the Production code to the trunk form baseline once the application is

deployed into Production. Managing all Change, Configuration and Release

Management activities in national level in four environments such as

development, testing, production and business environments. Establish and

maintain Software Configuration management processes, develop Configuration

Management procedures and identify items to be put under configuration

control. Track changes to various types of configuration items to include

hardware and software components and documents. Create metrics to track

various Releases that were deployed to Production on a quarterly basis as

well as monthly basis. Provided schedules for deployment to the various

environments. Worked with development, test DBA teams to co-ordinate the

same.

Developed test scripts to test software based on new requirements

and modifications made to the existing baseline system functionality.

Designed and executed detailed test procedures to validate application

functional requirements for customer applications. Assisted in the formal

development functional test plans and reports. Provided monthly status

reporting for input into contract deliverables. Detected trouble reports

and logged defects into ClearQuest to effectively manage issues to

resolutions.

Worked on as Apps functional resource incorporating the Apps setups

for the Customer Relation Management system. Created the necessary Groups,

Responsibilities, Inquiry Types, mapped the Inquiry Types to the

Responsibilities, Problem codes, Problem code mapping, Value sets,

Extensible Attribute Groups, added the Extensible Attributes, Database

Views, Associated the Extensible attribute Groups to the Inquiry Types,

created Association Pages for Inquiry Type to Extensible Attribute Group

and also set some of the Profile Options in the Apps 11i.

Worked on Discoverer 4i, gathering new requirements for enhancing

and maintaining the folders in the Business Areas. Gathered requirements

needed for new procedures and functions for the business areas. Gathered

requirements for new pl*sql scripts for data cleaning, data fixing as well

as for purging records. Worked on gathering functional requirements as well

as writing quite a few functional requirements needed for the applications

that I worked on as well for the team.

Worked on gathering the new requirements for BI Discoverer 10 G

with the users. Worked on analyzing the new Business Areas that were needed

for the new 11.5.10 Env. Communicated the requirements with the

appropriate consultants who then designed the system. Performing Quality

Assurance for all the applications for the team. Using ClearCase for

Configuration Management of the same as well as Application Tracking Tool

to deliver the Releases / Builds as well as assets for deployment.

CybrWorld Inc

NIH

07/03 -

05/04

At National Institute of Health as a member of the technical

team involved in implementation of Oracle Federal Financials. Mainly worked

on AP, PO & GL modules. Gathered requirements for building various

financial reports using Oracle Reports as per the needs of users. These

reports were run as concurrent programs. Tested the various applications

using Test cases. Used Mercury for writing Test Cases and validating the

application based of it. Defects were checked in ClearQuest. Responsible

for Test process implementation, conducting Peer reviews, Test Status

monitoring, Risk mitigation, Test Deliverable, and coordinating with other

team during production rollout.

Worked on analysis to create business areas based on base

tables and views. Analysis to create workbooks and worksheets as per user

requirements. Administered ClearCase and ClearQuest.

New Corporation

07/02 - 10/02

Modified and developed Balance Sheet, Trial Balance, Revenue &

Expense Statements, Detail Expense Statement Reports using Financial

Statement Generator (FSG). Also developed Oracle Reports using Reports

Builder 6i and registered the custom program and the executable in the

Application Object Library and registered it under the appropriate Request

Group. And then ran the report as a Concurrent Program through its

appropriate responsibility.

BTG Inc.

04/01 - 02/02

Involved in the production support of Oracle Federal Financial

Application modules like General Ledger, Accounts Payable, Purchasing,

Projects and CRM. Developed and supported custom enhancements like Reports,

Pl*Sql Interfaces and Alerts. Developed complex financial reports using

Oracle Reports, Discoverer and Noetix views. Worked on open interfaces to

load data from the feeder systems into Oracle Financials. Involved in the

complete life cycle development, testing and moving the financial system

into production. Tested the various applications used the Test scripts as

well as Regression Testing.

Created menus, responsibilities with different privilege level with a

specific business area like GL, AP, PO, Projects and AR. Created profile

for different users and responsibilities. Also created descriptive and key

flex fields.

Nextel Communications, Inc.

12/97 - 03/01

As a System Administrator of Oracle Financials, created users,

granted responsibilities, maintained concurrent managers and setup the

printers. Registered the custom programs in Application Object Library,

registered the executable and the program and assigned them to the

appropriate request groups. Created various value sets needed.

As a Programmer Analyst used Developer 2000 Forms 4.5 and Reports 2.5

and FSG (Financial Statement Generator). Created numerous complex financial

reports needed by more than 10,000 users. Worked independently, meeting the

various users, getting requirements, analyzing, developing and deploying

the same into production. Used Discoverer and Neotix views to create ad-hoc

reports too. Used Oracle Financial Analyzer (OFA) for business analysis and

Application Desktop Integrator (ADI) to upload budget information into

Oracle Applications.

Worked on the setups of Oracle Sales Compensation module for a

multi org setup. Talked to the users to get the required data needed for

the system. Developed numerous custom extensions needed for the users of

different markets using Sql, Reports 2.5 and also modified some custom

forms. Worked in Unix to maintain some of the existing programs and Unix

scripts.

Worked on converting data for an Oracle Financials data

warehouse using Pl*Sql, Etl tools, Sql*Loader and used ad-hoc tools for

reporting for different users.

Orkand Corporation / Johnson Controls

07/96 - 12/97

As a Database Analyst involved in the design and development of Oracle

based systems using Designer 2000 and Developer 2000. Created comprehensive

company wide databases and did backup and restore procedures using Import

Export utilities. Converted data from various sources into Oracle using

Sql, Pl*Sql, Sql*Loader.

Did physical and logical design of business applications using Oracle

Designer. On the logical side used the Entity Relationship Diagrammer and

Function Hierarchy Diagrammer. On the physical side used the Data

Diagrammer to create the data diagrams and created database objects like

tables, indexes, constraints and table spaces. Used the

Data Definition utility to create database objects mentioned before. Used

Reverse Engineering utility to re-engineer existing Oracle business

applications into Designer. In the process created the Entity Relationship

Diagram, Function Hierarchy and also corrected some business rules. Used

the Forms template and preferences to create screens with a uniform look

within a business application.

Automated Concepts Inc. ( ACI )

01/96 - 07/96

Worked on an Oracle based switch port application system at

Cable & Wireless as an Programmer Analyst which used Oracle 7.1, Sql*Forms

and Sql*Reports. Developed numerous complex reports using tools like Oracle

Reports, Sql*Plus and Discoverer. Created different types of reports like

tabular report, master/detail report and matrix report. Used various

features like formula columns, summary columns, placeholder columns,

different format masks and parameters for the report, report triggers and

variety of layouts for the report.

Developed different database triggers using Pl*Sql and created

row level and statement level triggers and also created user defined

exceptions.

Technology Management & Analysis (TMA)

05/95 - 12/95

As a Programmer Analyst worked in MIS system and was involved

in sales order system using Sql*Forms 3.0 on the front end and Oracle on

the back end. Developed screens of varying complexity using Oracle Forms.

Used standard features like alerts, triggers, program units, and attached

libraries. Used Sql*Menu to integrate different forms, reports, interfaces

for business applications.

Responsible for security system in Corporate Information Systems on

Unix platform. Controlled the database security of around 400 to 800

entities used by 1000 to 5000 users by creating roles and granting

different privileges (select, insert, update, delete) to users / roles.

Used Impromptu to create ad-hoc reports used. And also worked on

Developer 2000 using Forms 4.5 and Reports 2.5 and Sql*Plus.

M. N. Dastur Consulting Engineers, India

03/94 - 01/95

Worked as an accountant in the finance department. Involved in bank

reconciliation, recording transactions, verifying ledger balances, summing

up, adjusting, reversing and closing entries. Participated in making

financial statements like trial balance, balance sheet and profit and loss

accounts.

Also worked as an entry-level programmer. The Oracle based system was

an insurance application for a client. It involved the cash, billing,

statistical and commission sub-systems. Worked on an Oracle database,

created tables, indexes, sequences, views, inserted data, updated tables

using Sql*Loader and developed basic reports in Sql based on specs given by

team members.

Education

Bachelors in Commerce

Masters in Accountancy

Professional Certification

Diploma in Systems Management - National Institute of Information

Technology (NIIT)

Professional Training

Oracle Advanced Sql and Sql*Plus

Oracle Program Units (Pl*Sql)

Oracle Developer / 2000 Reports

Oracle Developer / 2000 Forms

Oracle Applications System Administration

Oracle Financials Technical Foundation

Oracle Financials Functional Foundation

Oracle Alert

Extend Oracle Applications

Oracle BI Discoverer 10 G: Develop an EUL

Oracle 11i System Administrator Fundamentals

Business Architecture 3D-VE Tools for Practitioners v 3.0

Provision

CMMI v1.2

In process of getting ITIL Certified

Contact this candidate