Oracle Sales

**** ******* ****** **.

Wildwood, MO *****

Cell/Mobile: 314-***-****

Home: 636-***-****

Email: ****.*****@*******.***, *******@*****.***

WORK/VISA STATUS: US Citizen

EXPERIENCE: Oracle Database Administrator over 9+ years experience Mid-

Range UNIX(HP-UX, AIX, Solaris) & Windows

Platforms. Have Production support DBA

experience providing 24/7 support from 10 to 55+ Oracle Databases

(on-call support rotation inside a 5 to 6 dba team support).

Knowledge in all aspects of database

administration including but not limited to installation and

configuration of Oracle (8i, 9i & 10g), Troubleshooting,

Patching, Upgrading, Security, Auditing, Backup & Recovery,

Performance Monitoring and Tuning,

created/managed databases on IBM HACMP & SUN VCS cluster

servers, installing and maintaining

9i Dataguard environment, Executing Physical (with DR datacenter

& Sungard servers) and tabletop Disaster

Recovery Exercises.

02/28/11 - Current NEW HOME PROJECTS

Installed and configured Oracle Linux 5.4 on 2 desktops to create a 2

Node RAC cluster with dual N/w cards and Sata drives.

. Installed and configured Openfiler ISCSI Network storage server to

support a 2 Node RAC cluster with SATA and IDE drives.

. Installed and created Oracle 11.2 2 Node RAC Database cluster with ASM

storage on the above Oracle Linux desktop hardware with Gigabit

interconnect and 100Mbit public interface using the documentation from

Jeffhunter's presentation on oracle website.

. Practiced database and cluster startup and shutdown using crsctl,

srvctl on the above Testbed/Sandbox environment.

. Created oracle 11.2.0 database on a windows 7 box/laptop.

. Installed and configured Goldengate 11.0 from UNIX ASM RAC database

Source to windows destination for

A) DDL synchronization,

B) Change synchronization,

C) Initial dataload.

. Created and implemented 11g Oracle Streams between 2 databases running

on Windows 7 and Linux/RAC for SCOTT schema. Tested streams for

insert, update and Table Level DDL change functionality between both

source and destination databases.

. Created and implemented 11g Oracle Replication between 2 databases

running on Windows 7 and Linux/RAC for sample HR schema. Tested

replication for insert, updates functionality between both source and

destination databases.

. Created a 11G Standby database using RMAN duplicate for Standby using

hotbackups of the primary rac database.

Tools & Oracle Features : Openfiler 2.6, Goldengate 11.1(ggsci),

Putty, Intel based Desktops, vmstat, top, sar, linux xwin interface,

11G Oracle Streams, SQL*Developer

Database: Oracle 11.2.x

Operating Systems: Oracle Linux 5.4, Windows xp/7

01/2010 - 02/25/2011 Contractor Database Administrator

Strategic Staffing Solutions, St. Louis MO

Client: Wells-Fargo Advisors, Inc. (Wells-Fargo

Brokerage Division)

. Supporting Oracle database related activities during Mock and Live

Data conversion events (Merger of Wachovia and

Wells-Fargo Brokerage systems ).

. Assist Conversion Execution Team in different database related

activities

a) Running scripts,

b) Troubleshoot ORA-xxxx errors in the logfiles,

c) Rebuild missing Indexes,

d) Refresh object level grants during conversion events,

e) Troubleshoot Sql*Loader and Informatica dataload log errors,

f) Identify and create missing database objects in Mock Testing

environment to match Production,

g) Submit tickets to place Database related jobs on-hold/execute

during pre/post conversion events as per the timelines.

h) Assist project managers to define the database related tasks,

issues and provide feedback on task completion.

i) Assist execution team on application-id permissions on the

converted tables (revokes, re-grants) during conversion execution

events

j) Provide technical support on oracle database related

questions/issues to developers, vendors (on-site & offshore) and

trouble shoot ora--xxxx errors in their scripts (thru trouble

ticket system, adhoc emails, etc.).

k) Refreshed 700G worth of data for mock testing using Transportable

Tablespaces under oracle 10g

. Participated in daily checkpoint calls to provide status on the

database activities and collect requirements & project tasks for

upcoming database related activities.

. Provide off-hour on-call support to the Conversion Team for oracle

database related issues and errors.

. Promote code between several testing and production environment using

Change Management Ticketing Systems

( home grown tool and BMC Remedy). Follow the promotion process

to comply with Audit and SOX requirement (jacksum

hash). Create users and grant roles and privileges from the non-prod

user ticketing system.

. Provide Onsite and off-hour support to the ETL/Data refresh team (to

offshore & onshore developers ) during data refresh operations

a) Troubleshoot ORA-xxxx errors,

b) Identify missing objects using Toad schema compare utility

between prod and test schemas,

c) Add datafiles to tablespaces during dataload operation if

required

d) Refresh materialized views on Replicated Tables on slave site

e) Grant and revoke privileges, disable/enable constraints, rebuild

indexes, truncate

f) Troubleshoot Replication related errors(table ddl changes,

repadmin job, remove/add tables between replication group) during

code deployment and data refresh activities

. Monitor SQL statement execution (Wait Events, Physical I/O, Consistent

gets, execution plans) using Precise Indepth,

Toad session browser and command line tool (sql*plus querying

v$session_wait, v$sql_plan, etc.). Generate and provide

Indepth and AWR reports during Application Load Testing Activities to

different teams.

COMPUTER TOOLS

Databases: Oracle 10g (10.2.0.4)

Operating Systems: UNIX (Solaris), Win 200x

Other Tools: TOAD 8.x, SQL*PLUS, 10g OEM Grid control tools, Putty, MS-

OFFICE 200x, top, scp, pscp, vmstat, prstat,

Precise Indepth

12/2009 - 01/10/2010 Recent Training & Home Project:

R12 Oracle Install, Patch, and Maintain Oracle Applications (E-

Business Suite) (oracle university 12/2009)

R12 Oracle Applications System Administrator Fundamentals(oracle

university 01/2010)

Home Project:

Installed and configured Oracle Linux on a desktop, patched the Linux

environment to install the R12 and Oracle 11g.

Installed and configures R12 Suite of product to practice the above E-

Business training class courses.

Installed and created oracle 11.2.x (11G) database on a

homegrown Oracle Linux desktop server.

06/2008 - 11/2009 Sr. Database Administrator

ArchCoal Inc., St. Louis MO

. Primary responsibility to support several Production, Test and

Development databases(10g,9i) on HP-UX 11.11 platform,

running off the shelf(Ellipse, Allegro, Equity edge, Tripwire, Numara)

and homegrown applications

(RMS,LMS,RCMS,Warehouse)

. Support Oracle Application Server installs on dev, test and production

environment (10.1.2.0.2) running forms and Discoverer. Patched 10g

Application Server and discoverer environment from 10.1.2.0 to

10.1.2.3 using metalink and oracle documentation on Sandbox & Test

environments. Created users and granted permissions(sharing workbooks,

grant privileges under EUL, etc.) using Discoverer Administrator.

Troubleshoot Oracle Application Server environment using metalink

support documents and documentation from Tahiti.oracle.com. Edit and

configure formsweb.cfg and default.env files for new forms based

applications

. Recovered database on Sungard servers for Disaster Recovery exercise

using RMAN hot backups

. Installed and created 10g databases (Dev,Test, Prod), configured the

database for Warehouse implementation. Cloned schemas and databases

using RMAN Duplicate, exp/imp from Prod to Dev and & Test. Modified

procedures, deployed profiles, for generating audit report to comply

with SOX and audit requirements. Applied periodic PSU/CPU Security

patches to 21+ oracle databases on Six DEV, Nine TEST and Six PROD

database environments.

. Upgraded (Ellipse and other apps)databases from oracle 9i to 10g using

metalink document on manual upgrade process & applied CPU patch on the

upgraded database. Created & dropped users as requested and

grant/revoke permissions as per their roles. Patched databases from

10.2.0.3 to 10.2.0.4 for CPU patching to comply with SOX and Audit

policy.

Deployed Profiles, Password Functions and DB hardening/lockdown

process to database accounts&environment to comply with enhanced

security standards dictated under Baseline Control Standards, audit

vendor standards,etc.

. Troubleshoot database connectivity and performance problems as

required, install and configure oracle client for off the shelf apps

on user desktops. Work with application vendor in troubleshooting

problems.

. Run AWR and statspack reports to identify sql with large buffergets

and physical reads per execution. Run sql tuning set's exercise to

identify any index recommendations to be implemented. Created/rebuilt

indexes and computed stats to decrease physical and logical i/o on the

sql executions and better execution plan selection (used v$ views and

top to identify the problem sessions). Assisted developers in

troubleshooting sql execution_plan/performance using event 10046

setting at the session level during performance tuning exercises.

. Assisted functional administrators to troubleshoot connectivity (odbc,

sqlnet) and sql plan tuning exercises. Troubleshoot and patch Grid and

database environment with oracle SR/TAR request process (using RDA

utility and tracing for agent and oms).

. Upgrade Emagent for 10g grid control to resolve errors appearing under

emagent.trc, emagent.log, emoms.trc files with assistance from

metalink documents and documentation. Rediscover new components

created on the database servers for monitoring. Deployed apex

development tools in a sandbox environment

COMPUTER TOOLS

Databases: Oracle 8i, Oracle 9i(9.2.0.8), Oracle 10g (10.1.0.4 - 10.2.0.4)

Operating Systems: UNIX (HP-UX), Win 200x

Other Tools: TOAD 8.x, ER-Studio, SQL*PLUS, OEM Admin Tool (DBA Studio),

10g OEM Grid control tools,

Sql_trace/tkprof, Putty, MS-OFFICE 200x, top, vmstat, Oracle

Application Server 10.1.2.3

08/2007- 05/2008 Sr. Data Engineer (Sr. DBA for OLTP apps)

MasterCard, O'Fallon, MO

Primary responsibility to support several production, test and

development databases on Solaris and Windows 2003, Oracle 8.1.x

thru 9.2.0.7(stand alone, homegrown replication).

Cloned database using hotbackup and backup controlfile option on

Solaris, Rehosted/Migrated databases across servers, created and

configured database environment for Ingrain, Protegrity, Voltage

encryption dbtool, configured extproc listener and settings for

encryption application testing, assisted developers and vendors

for table level data changes and testing using event 10046 and

tkprof. Assisted in deploying Protegrity's VPDISK encryption

tool on OLTP & Warehouse Test Databases as part of pilot

project. Was given SPOT award for participating, assisting and

evaluating different encryption tools(Proof Of Concept Project).

Co-ordinate tasks with offshore dba's for database work (running

audit scripts, tasks assigned directly by clients etc) on

Solaris and Windows 2003 Platforms.

. Setup/configure Rman backup scripts for full backup and

archivelog backup. Troubleshoot and loaded data for character

set conversion from usascii 7 to utf8. Upgraded database from 9i

to 10g for Lawson application.

Tuned database using statspack reports, creating new indexes,

computing stats on tables - to decrease the physical i/o(3k/sec

to < 100/sec) and logical i/o (8k down to 3k)per second on sql

statement executions and inturn

reclaiming cpu usage (using event 10046 trace and tkprof).

Assisting other dba's in the team troubleshooting

performance (using v$session, v$session_wait, x$bh, v$sql_plan,

etc. views), connectivity and database

problems.

. Assisted other dba's in troubleshooting their database

performance using sqltrace/tkprof and v$ views

COMPUTER TOOLS

Databases: Oracle 8i, Oracle 9i(9.2.0.2-9.2.0.7), Oracle 10g

(10.2.0.4)

Operating Systems: UNIX (Solaris 8-10), WIN200x

Other Tools: TOAD 8.x, Precise-Indepth, SQL*PLUS, OEM Admin Tool (DBA

Studio), Sql_trace/tkprof, Putty,

MS-OFFICE 200x, lotus-notes/email, top, topas, vmstat,

prstat

01/2006 - 07/2007 Sr. Database Administrator

Sisters Of Mercy Health System (MISD), St. Louis, MO

. Primary responsibility to administer and support oracle

databases running Cerner, Lawson and other applications on AIX

and oracle 9.2.0.x, 10.1.x, 10.2.0 (With Standalone, Physical

Standby & Dataguard - sizes upto 1.4TB) on RAW and JFS2 file

systems

. Secondary responsibility to administer and support MHP-

subsidiary oracle databases(8i, 9i 10.2) running on AIX & Window

200x platforms used by homegrown and vendor products. Oversaw

tasks of 2 other dba's for MHP databases(8i, 9i, 10g). Tracked

and worked on issues, tickets and resolve

performance/issues/problems.

. Performed required tasks (create users, grant permissions, run

scripts, clone schemas) as per work-order tickets as requested

by end users, QA-Analysts, Vendor engineers and developers.

Resolved database connectivity problems under sqlnet, ldap,

odbc, oledb drivers, Lawson/pactrac interface setup.

. Cloned databases using a) RMAN (duplicate using TSM TDPO), b)

hot disk backups, c) export/import across hosts. Configured TDPO

settings for RMAN backup using tdpoconf utility and

dsm.opt/dsm.sys files. Deployed DB Backup solution (RMAN,

tsm/tdpo) and monitoring scripts for test and production

databases.

. Recovered databases on Windows and AIX platforms due to disk and

hardware problems. Trained other dbas (1 on 1) on database

maintenance and installation/configuration activities. Installed

and created 10.2 database on Linux (REL 4) for TADDM

application( under Proof Of Concept process).

. Restored production databases for DR (Disaster recovery)

exercise on Sungard servers using previous hot backups and RMAN

scripts. This included planning and execution of recovery with

assistance from Sys Admin and TSM administrators.

. Recovered and troubleshoot of Tecsys Production/warehouse

database, created standby database under 8.1.7.4 for DR/HA and

Reporting.

. Tuned database environments using statspack, sql scripts, OEM

tools (Sql Analyze, Sql Expert), coalesce DMT's, Computing

stats, sqltrace/tkprof analysis. Troubleshot database problems

using oracle (OEM & querying v$session, v$sql, v$sql_plan,

v$session_wait ), UNIX (topas, sar) and Win 200x (process

monitor, performance monitor, counters & other utilities by

sysinternals.com) tools.

. Worked with Sys admins, storage and backup admins to setup the

oracle environment, backup process using RMAN under TSM and

Legato/Networker MML. Created and maintained RMAN catalog on

production environment.

. Provided on-call (off hours Monday thru Monday) dba support for

all of the production databases across Mercy IS on pager

rotation within the dba team.

. Prepared and Presented on Oracle High Availability for Lunch &

Learn session for DBA group. Topics covered were RAC, Hardware

Clustering. Wrote draft Policy documents on Oracle Binary

installation & Support and Database Tuning. Developed a

requirement document for RAC deployment to be used for TIBCO

application.

. Developed Trigger and 2 Packages (with few small procedures) for

PHR application for inserting, updating tables as per

application requirements.

. Provided database support and cloned production databases for

Cernerworks Remote Hosting support. Used Rman to create the

standby clone on the Snap Drive.

. Installed and configured 10g agent on existing server and

troubleshoot 10g GRID installation using Metalink and oracle

documents. Monitored database performance using AWR snapshot

reports, sql tuning tasks, ADDM reports. Monitored and

troubleshoot IAS, OID and GRID infrastructure using metalink and

oracle documentation.

. Was awarded Geek of the Week award for working with technical

teams, vendor and recovering the production database.

COMPUTER TOOLS

Databases: Oracle 8i, Oracle 9i(9.2.04-9.2.0.7), Oracle 10G(10.1,

10.2)

Operating Systems: UNIX(AIX 4.3-5.3), LINUX, WIN200x

Other Tools: 9i SQL Analyze, TOP Sql, Oracle OEM Admin Tools (DBA

Studio, Index tuning wizard, Oracle expert),

10.1 Grid (ADDM, SQL Tuning task, snapshot

reports, etc DBArtisan, Raptor, tkprof, View-now, Putty,

MS-OFFICE 200x, Perigrine, CYGWIN/X, PL/SQL,

top, topas, vmstat, truss

12/2001 - 08/31/2005 Systems DBA (Production/Physical DBA)

SBC/AT&T Services, Inc. St. Louis, MO

. Installed binaries and Created/Supported 55+ Oracle 8i and 9i

databases on Midrange Solaris, AIX, HP-UX servers (standalone

and HACMP/VCS Clusters). Recovered, migrated & monitored

databases with different

Backup solutions (TSM and Netbackup) Disk, RMAN (with catalog

db), managed databases up to 350+GB in size

. Configured monitoring, startup/shutdown and Backup scripts, BMC-

Patrol KM for monitoring production databases. Recovered

databases as required (point in time, backup control file, hot

and cold backups, full and partial exports, RMAN).

. Upgraded and patched databases (8.0.5, 8.1.6, 8.1.7.0 TO

8.1.7.x, 9.2.0.x) on Production, Test and Development boxes.

Compiled packages and procedures during migrations and upgrades

(using utlrp, scripts and command line)

. Installed and configured Physical Standby (Data guard) databases

for Micromuse-PrecisionTN application.

To provide High Availability (inside same data center) with 15

minute delay between primary and standby db's.

Recovered Standby database for unit/acceptance test activity.

Patched standby database pairs from 9.2.0.3 to

9.2.0.5

. Troubleshoot cluster environment during Outages due to

hardware/software problems. Provided 7x24 on-call support under

pager rotation (inside the 5 dbas team).

. Migrated and re-hosted several databases across different OS

platforms (Solaris to AIX, NT to Solaris, AIX to AIX servers).

Supported databases which ran different kinds of (OLTP and DSS)

applications (Billing, Shopping-cart, Content manager app,

websphere-portal, Optical Network surveillance management,

Outside plant management, CNM app for ATM & Frame-Relay).

Created tables, indexes, views for new and 3'rd party

applications. Migrated tables, packages and procedures from

development to Test and Production environments (using

export/import utility).

. Migrated data using export/import and loaded delimited flat file

data using sql loader. Assisted application

dba's for database security setups and other application related

work (creating roles and create and run scripts for granting

select, insert, update by querying v$ views, dblinks, migrating

schemas, advanced queue configuration).

. Ran statspack report periodically to monitor performance and

tune initsid.ora parameters. Used OEM (dbastudio, sqlanalyze,

topsessions) and command Line tools (sqltrace, tkprof,

autotrace, v$session_wait, x$bh) to tune sql and re-org database

objects (hot blocks). Collected schema level statistics (CBO) on

tables/indexes, created indexes to resolve response time on SQL

queries. Worked with internal oracle support to tune sql

queries. Tuned environment to increase CPU idle time upto 85+%

on one of the servers and reduced outages during heavy load on

several databases.

. Troubleshot and debug database connectivity problems using

sqlnet tracing (client/server), listener tracing, tracing UNIX

system calls and errors using truss utility. Debug JDBC

connectivity problems using java test scripts and jdbc system

call tracing.

. Monitored and assisted application groups and testers during

unit testing, load testing and failover testing activities of

application environment /footprint.

. Assisted in Migrating SQL server and Informix database to Oracle

using Oracle Migration Workbench for test and production

environment. Provided feedback on Annual Capacity Planning for

disk storage, by monitoring disk/tablespace usage for data and

backups.

. Collected and provided project requirements on database

implementation calls, for file system layout design, security,

monitoring, kernel settings on OS. Worked with other SME's(Sys

Admins, Backup, Storage Admin) during deployment of database for

application group use. Provided disk storage and implementation

time estimates for deploying oracle databases on New solution

Projects and enhancement Projects.

. Created oracle filesystems layouts on Hitachi Storage Array

using LUN information output from xpinfo utility. Also created

oracle filesystem layout from EMC disk/LUN information. This was

done provide physical separation of data and backup file systems

(as per Oracle OFA recommendations).

. Used Change Management tool (Vantive) and change management

Processes for database related changes and problems. Assisted

new team members on processes, installations and OS environment.

COMPUTER TOOLS

Databases: Oracle 8i, Oracle 9i, Oracle 10G

Operating Systems: UNIX(HP-UX11&11i, AIX 4.3-5.1, Solaris 2.8)

Hardware (Technical Knowledge) : EMC Symmetric 8730/8430 Storage

Arrays, Hitachi/HP Arrays

Other Tools: SQL Analyze, TOP Sql, Oracle OEM Admin Tools (Index

tuning wizard, Oracle expert),

Migration Workbench, truss, tkprof, TOAD,

Exceed, View-now, MS-OFFICE 2000, PowerPoint, Vantive,

Panagon, PL/SQL

7/2000 - 11/2001 Database Analyst (Application DBA)

SBC/AT&T Services, Inc. St. Louis, MO

. Extensively worked on the Budget and deployment plans for the

Project (Mainly on EMC data storage, network Planning, HP

midrange servers). Actively worked in a team defining

requirements for high availability computing for the Telcordia

applications (server layouts, storage layouts, backup assurance,

high level DR hardware design), with business requirement of <

30 minutes data loss and < 1hr failover of application to DR

site

. Actively worked on the Failover Testing Team for Server failover

using M/C service guard (Included business requirements,

technical requirements, solution plan, analysis). Extensively

worked on the hardware sizing, EMC storage price estimates, disk

sizing, Fibre channel counts, BCV's, SRDF, backup and recovery

assurance for databases

. Created and configured Oracle 8i databases for various Telcorida

Apps (Delivery, Surveillance Manager) as per SBC standards.

Acquired technical knowledge on TNM, CNM, ATM-Forum

architectures and concepts thru self study (OO Model of NE, EMS,

Provisioning/Inventory, Configuration management-CM,

Surveillance management-SM, Fault Management-FM, North/South

bound interfaces, PTP/CTP/link concepts, FCIF, NDD, SNMP,

MIB/TL1/CORBA, ATM cloud, DSLAM, RT), for the lower

transport/network/datalink/physical layers (under 7 layer OSI

Model).

. Installed and configured Oracle 8i and MS-SQL server binaries on

the WINNT 4.0 server for internal use. Created a development

database on the same server. Installed and configured Middleware

(Visiborker (ORB) 3.3, TOPCOM, BBCS, SysPilot) and Oracle

database for prep work on the HP Boxes for Acceptance Testing.

Actively worked with installers on debugging UNIX OS related

issues (IPC, deamon process settings, network communication

issues, Permissions)

. Installed and implemented Echangeman (SCM Tool) from Serena,

PVCS-Tracker, tools for the team (using Oracle, MS-SQL Server

DB's). For Work Tracking, Release mgmt, Change Mgmt Processes.

. Migrated Oracle database schema from NT to UNIX environment

through Oracle logical Export and Import utilities

. Migrated MS Access data to Oracle schema for PMTS application,

this included, Creating DB tables, constraints. Used ODBC pipe

to load data into Oracle and PL/SQL scripts to populate the

tables

COMPUTER TOOLS

Databases: Oracle 8i, SQL Server 7.x, Access

Operating Systems: UNIX(HP-UX), NT 4.0

Hardware ( Technical Knowledge) : Midrange Servers (HP, SUN, RS6000),

EMC Symmetric 8730/8430 Storage Arrays,

Hitachi/HP Arrays

Other Tools: Oracle OEM Admin Tools, Exceed, View-now, NCR Queryman,

MS-OFFICE, PowerPoint,

Vantive, PVCS-Tracker, E-changeman, PL/SQL

9/1993 - 5/2000 MIS Specialist (IT Administrator)

Industrial Wire Products, Inc. Sullivan, MO

. Installed and upgraded Progress 4GL DB on server and clients.

Designed and created custom modules for sales DB app. Tuned DB

parameters for performance. Installed & Configured SCO UNIX ver's,

configured serial interfaces and network clients for login and

Intermec data-collection equipment. Tuned KERNEL parameters for

resource usage and system stability.

. Installed and configured NT server OS, performed user admin on

various shared resources on the file server. Installed, upgraded

various client OS's (Win95, Win 98, NT 4.0 Workstation)

. Installed and implemented Post.Office SMPT email server (POP 3)

from Software.Com on NT. Worked with local ISP in setting up MX

records, Registering domain name for the company on Internic. User

admin and security admin on the mail server. Installed and

implemented Microsoft IIS server. Installed and configured Proxy

server (WINPROXY2.0) for internet access on a HDSL pipe

. Installed and configured Network nodes and remote nodes (on a WAN-

T1) to the network, with corresponding updates to the UNIX & NT

database files. Installed & configured N/W hardware (Switch, Hubs,

Routers, Multiplexer), for data & voice communication and HP

Jetdirect print servers. Installed Network Backup solution of all

the Servers and clients using CA-ArcServer and Sony AIT network

tape drive

. Installed and upgraded SYMIX ERP software, Administered users on

various Modules (permissions, menus, etc.). Assisted and Trained

Users on the ERP modules & Business Flows. Setup and audited

parameters on various modules(acct codes, unit codes, depts,

product codes, calendars, etc). Installed and configured data-

collection module for Time & Attendance. Closely worked with vendor

for problem resolution and patch upgrades.

. Installed and configured standalone EDI software, setup profiles

for various customers (Wal-Mart, K-Mart, BB&B,

OfficeMax - ANSI X.12 - 850, 855, 864, 810, 856). Debug and

monitored EDI transmissions with various VANS and SYMIX ERP pkg.

Integrated RPS Multiship application with ERP, for small package

shipping using 3'rd party software (TracerX, vendor scripts and sql

statements using ODBC ) for shipment tracking, this eliminated

duplicate data entry and enabled online shipment tracking.

. Upgraded SYMIX (Ver 2.7) to Syteline (2.x) ERP from host based to

client server configuration. Collected requirements for the upgrade

(hardware/software/licensing costs), Budgeted expenses Timeline &

Schedule for upgrade and training. Coordinated with Vendor

consultant for training and implementation

The project was completed within the $100K allocated budget and

timeframe (used MS-Project and excel for the

project related tasks).

. Migrated historic sales data from IBM System38 into Progress DB:

extract data from IBM system, load data into

Progress 4GL DB, massage and populate data (for sales tracking)

. Designed and Developed Sales Tracking and forecasting Application

(data warehouse) and Employee Incentive pay applications -

Collected requirements from sales managers, production managers,

shop floor schedulers and employee contract documentation.

Developed database logical/physical design (with 15-20 entities

spread across 20 tables) using MS-Office tools. Developed data

entry screens, stored procedures, menus, using Provision. Developed

backend scripts (progress - sql and shell scripts to run under cron

) to collect and update sales information under monthly buckets

from ERP software. Developed utilities to massage and update the

product forecast information into the MRP engine and incentive pay

information into payroll tables.

. Negotiated and implemented long distance carrier for company wide

phone system (from MCI to Sprint), Negotiated and implemented

Voicemail into the existing DBS phone system (total budget of

$20K), installed and configured additional extensions to the

existing phone system.

. Upgraded and installed hardware and software for Y2K compliance (on

ERP software and Intel based servers and PC clients), also

responsible to investigate vendor Y2K compliance

. Installed and implemented Barcode solution for printing SCC14, UPC

& SCC18 barcodes for Retail line of products. Integrated Barcode

application with ERP software using ODBC pipe for online label

printing and tracking for Retail and OEM line of products.

Extensively developed reports and tracked product sales on Wal*Mart

(Retail-Link) DSS App. Extensively used Monarch for developing

custom reports for auditors, year-end procedures and Sales & Acct

Depts

COMPUTER TOOLS

Languages: SQL, Progress 4GL

Databases: Access, Progress 6.2 Thru 8.x

SDK's: Provision 7.x, 8.x,

Operating Systems: UNIX(SCO OPEN Server), Linux, MS-DOS, NT 4.0,

WIN.xx

Hardware (Hands-on & Technical Knowledge) : Intel Based Servers

(Dell, HP), PLC's, IBM Compatibles

Networking Hardware(Hands-on): 3Com Super stack 1000, 3Com Boundary

Router, Adtran TSU 120 (Multiplexer),

HPJetdirect, Print servers, Hubs, Intermec data

collection hardware

Networking Apps : SCO Runtime TCP, NT 4.0, ICETCP, NFS

EDI: TPPC 32, RADLEY

Bar-coding : Printware 32, Loftware

Graphic & CAD Software: Corel Photo Paint 7.0, Photoshop, MS Image

Editor, Autocad V14 (&Lite)

Other Tools: Exceed, View-now, Progress RESULTS, 1776, Lotus 123,

MONARCH, MS Works,

MS-OFFICE, PowerPoint, MS Project, Master CAM 7.0, MS Front

Page, PCAnywhere,

SYMIX/SYTE-Line ERP application

EDUCATION

(1998) (9 Credits Hours Computer Science )

University of Missouri - Rolla (St. Louis extension Center)

5/1993 M.S.Electrical Engineering.

Southern Illinois University At Edwardsville US-IL-Edwardsville

7/1989 BS Electrical & Electronics Engg

Bangalore University/MSRIT India-Karnataka-Bangalore

Training & Seminars

Project Management Concepts (yr 2008)

Oracle 10G Real Application Cluster Refresher course from Oracle University

onsite (yr 2008)

Concepts on Customer Service for Information Technology personal (yr 2008)

Oracle 9i Real Application Cluster from Oracle University (yr 2005)

Oracle 9i For Administrators from Oracle University (yr 2002)

Patrol Administration & Configuration Training SBC/AT&T (2002)

Performance & Tuning Workshop from Oracle University (yr 2001)

SQL Tuning Workshop from Oracle University (yr 2001)

Introduction to PL/SQL from Oracle University (yr 2001)

Developing PL/SQL Program Units from Oracle University (yr 2001)

Enterprise DBA System Architecture & Administration from Oracle University

(yr 2000)

Backup And Recovery Workshop from Oracle University (yr 2000)

Oracle seminars on High Availability Computing Environment, Intro to OEM,

Oracle SQL Tuning

Object Oriented Analysis & Design Using UML (From Barker Pacific Group in

yr 2001)

Manager's camp for Individual Contributors by SBC/AT&T CFL (Project

Management & Leadership Yr 2001 )

Capability Maturity Model Overview at SBC/AT&T (Yr 2001)

IT Quality System Overview at SBC/AT&T (Project Life Cycle Related Yr 2001

)

Workshop on using Panagon for document storage SBC/AT&T (yr 2002)

Basic Telephony overview by SBC/AT&T Center for Learning (Yr 2000)

Basic Data Communications and Networking by SBC/AT&T (Yr 2001)

Understanding ATM in Corporate Networks by SBC/AT&T (Yr 2001)

Acquired SYMIX System Administration, SYMIX System Customization and

Progress

Language Application Certificates from SYMIX Computer corporation(Front

Step) (1993)

Meractor (data mapping & Admin) from TSI corp / Mercator Corp

Seminars on Managing an IS project, Advanced Excel, Understanding Financial

Statements from Dun & Bradstreet (1995)

Contact this candidate