Oracle Software Engineer

**** *. **** **** ***** A. SILVASI 773-***-****

Chicago, IL 60660 ********@*******.***

EXPERIENCE SUMMARY

Database Administration including installation, upgrades, data migration,

conversions, integrations, and performance analysis/tuning in context of ERP and

Medical Information System applications support. Production data refresh and

conversion using DTS, T-SQL and PL/SQL. Experience with Oracle, Microsoft,

OS/400 DB2 and Sybase on Windows, HP-UX, Linux, IBM AS/400 iSeries and Sun

platforms. Identified and resolved contention issues between ERP systems, BI

software, development tools and data collection hardware and software in JD

Edwards EnterpriseOneWarehousing application. Experience in MS SQL clustered

environments.

ERP infrastructure build, upgrade, troubleshooting, maintenance and tuning

(JD Edwards EnterpriseOne infrastructure Configurable Networking Computing

[CNC]) within multi-environment project methodology frameworks as a member

of a life-cycle implementation team. Responsible for Thick, Thin and Web

clients; Application, Logic, RDBMS, combination, Development, Integration

and Web servers; Development Platform, Object and Change Management

applications. Executed project planning and delivery for reports,

interfaces, conversions and extension to other systems. Detailed technical

assessments with tuning recommendations for installed systems including

RDBMS, network, and server analysis. Installation to third-level support of

a proprietary Medical Information System over a WAN from the data center

servers to nationwide medical offices across Frame-Relay Cisco and

Microsoft networks, including Sybase RDBMS setup and configuration, through

successful client acceptance testing and go-live

ERP Application development (JD Edwards EnterpriseOne toolset) code fixes

using JDE development tools Event Rules, Visual C++, Report Design, Forms

Design, Table Design; and interoperability using IBM MQ Series and Bostech

ChainBuilder; Java/XML, CRON and PL/SQL for real-time integration with

legacy systems. Created custom insurance and premium calculations

applications using Lotus and MS Access and Access reporting tool

TECHNOLOGIES

. Databases: Oracle 8i - 10g, MS SQL 7, 2000, 2005, 2008, DTS, SSIS; MS

Access, Sybase, DB2/400 V4R3 - V5R4

. ERP: Oracle/JD Edwards EnterpriseOne Configurable Networking Computing

(CNC) B732 through 8.12/8.97

. Hardware platforms: Wintel, Sun, HP9000, AS/400 V4R3 - V5R4, RS6000

. Web: IBM WebSphere 6, 7; Oracle Application Server 10g

. EAI: EnterpriseOne Xpi, WebMethods, IBM MQ Series, Bostech ChainBuilder,

Oracle Business Services Server

WORK EXPERIENCE

Independent Consultant

11/08 - present

. JD Edwards ERP8 support and upgrade planning for JDE 9 including data

conversion, database migration from Oracle 9i to SQL 2008, DB sizing,

security and production data refresh

Terillium Inc, Cincinnati, OH

8/07 - 11/08

Senior Consultant

. JD Edwards 8.12/8.97 implementations including installations and

upgrades using Oracle 10g on HP/UX and Windows and SQL2000 and 2005

databases; Security and CNC mentoring, proof-of-concept for Oracle

Business Services Server and XML Publisher for JDE EnterpriseOne,

resolve SQL 2005 and Oracle 10g DB application contention issues. Pilot

testing and optimization of JDE applications with SQL 2008 in

anticipation of JDE support of SQL 2008. DBA duties on installations

ranging from 3 to 6 DBs, having 100GB - 1TB of data

CD Group, Atlanta, GA 10/05

- 7/07, 11/99 - 2/02

Senior Consultant

. JD Edwards B7332 - 8.10/8.95 and Xe - 8.11/8.95 upgrades on iSeries

DB2/400; 8.11 and 8.12/8.96 installations on Oracle 9i/Windows and

Oracle 9i/Linux; performance analysis and tuning; database contention

troubleshooting with DSI and RFSmart data collection systems; Vertex tax

software, and Premier Technologies' ESOM sales order software. Proof-of-

concept for SQL 2005 Reporting Services as alternative to JD Edwards

proprietary reporting tool. DBA duties on installations ranging from 2

to 4 DBs, with 70GB - 500GB of data

. Lead CNC Consultant, during implementation through go-live, for a Oracle

JDE EnterpriseOne system featuring custom point-of-sale applications

designed with JD Edwards' development tools for a chain of retail stores

running AS/400 V4R5, DB2/400 on WinNT and Citrix MetaFrame

. Designed and performed successful EnterpriseOne upgrade / platform

migration / database upgrade concurrently, from a live EnterpriseOne

B7332 SP16 / RS6000 / Oracle 8.1.6 installation to Xe SP17.1 Update 3 /

Windows 2000 / Oracle 8.1.7.1

. Responsible for all aspects of CNC including RDBMS, system architecture,

installation, path code & environment setup, object promotion and

package build/deployment, maintenance, enterprise, RDBMS and web server

tuning

Deloitte Consulting, Chicago IL

2/05 - 10/05

Senior Consultant

. EnterpriseOne assessment, installation, and 8.10 Configurator application

performance testing on SQL2000. Designed and built testing environment

and procedures that identified performance issues which lead to several

vendor patch sets for improved Configurator performance and stability

. Assisted with hardware sizing for an international EnterpriseOne client

planning a migration from IBM iSeries to eSeries with LPAR using IBM

sizing tools

Hitachi Consulting, Dallas TX

8/03 - 9/04

Senior Consultant

. EnterpriseOne analysis and performance evaluation / tuning including

Java, Citrix, logic and application servers at client sites. Detailed

assessments of live JD Edwards installations, identifying and resolving

performance bottlenecks in SQL Server 2000, Citrix Metaframe client, and

JDE servers. DBA duties on DBs ranging from 3 to 6 DBs and 100 - 800GB

. Project estimation for EnterpriseOne CNC upgrade, RDBMS requirements,

installation, change management, disaster recovery, documentation, path

code maintenance; and presales client meetings as part of an

implementation team

Brightpoint North America, L.P., Plainfield, IN

2/02 - 1/03

J.D. Edwards CNC Technical Analyst / Software Engineer

. Responsible for JDE infrastructure in cooperation with Sun/Oracle 8i

DBA; Sun Solaris, Windows 2000 and Cisco administrators. Instituted

monthly refresh of Production data to test environments using Oracle DB

scripts

. Architect and proof-of-concept for interoperability solution with legacy

Informix-based system using Java/XML, CRON, and PL/SQL for real-time and

batch applications

. Learned essentials of transaction processing, ERP systems

interoperability, and Java/XML under own initiative without incurring

training costs, and assisted in the development of Brightpoint standards

for application interfaces. Member of evaluation team for Bostech

ChainBuilder against these standards, and to design architecture to

close gaps between the Bostech solution and Brightpoint standards.

Metamor Technologies, Chicago, IL

11/96 - 9/98

Technical Consultant

. Installed, supported, and upgraded network of LANs running a custom

medical information system for a network of dialysis clinics using a

Windows NT, Citrix, Cisco 1800 series, Ethernet, Alta Vista firewall,

Sybase 10, Frame-relay configuration as part of the infrastructure

implementation team. Responsible for total infrastructure installation,

including vendor relations, through post-go live and second- and third-

level support

. Reduced implementation costs by leading the evolution of infrastructure

implementation team members from functional specialists to functional

generalists

OTHER EXPERIENCE

The Gads Hill Center, Chicago, IL

1995 - 1997

Responsible for operations of a community center as a member of the Board

of Directors, Board of Trustees, Public Relations Committee co-chair, and

Finance Committee. Provided mentoring for disadvantaged children

EDUCATION

Northwestern University - Bachelor of Sciences, 1991

Organizational Behavior / Business Administration

Contact this candidate