PROFILE

• Responsible professional with academic and business training and experience.
• Talent for developing versatile and innovative financial software applications.
• Experience at working with and counseling college and university groups.
• Experience with innovative approach to teach Math, Statistics, Physics, Computer Science and Quality Management Six Sigma Hoshin Planning courses.
• Strong communication and interpersonal skills.
• Extensive foreign travel and international knowledge. Many Years of IT Experience, Extensive Education in Math and Computer Science
• Personal traits: Hard Working, Highly Motivated, Positive Attitude.

EXPERIENCE SUMMARY

• Database Administration/development with over 18 years experience in Information Technology specializing in Designing, Architecting, and Administrating of Relational Databases, primarily Oracle, on UNIX and Windows platforms. Experience in entire system life cycle including Analysis, Design, Programming, Testing, and Implementation of Oracle based applications Client Server and 3-tier platforms . Worked in various sectors like Financials, e-commerce, software development.
• Played managerial / technical leading role in researching technologies, designing, planning, and implementing of High Availability databases and Disaster Recovery strategies were applied at the Sep.11th, 2001 catastrophic events . Evaluated and implemented Oracle9i DataGuard with maximum protection option zero data loss for disaster recovery, Evaluated Oracle9i RAC and Oracle10g RAC on Veritas Clusters on both Sun's Solaris and RedHat's Linux EL AS 3.0/4.0/5.0 . Versatile in database capacity planning, growth, and trend analysis, used MS project and other office tools for project planning, monitoring, and resource allocation.
• Expert in Oracle RDBMS 11g, 10g, 9i, 8i, 8.x, 7.x on Solaris, HP-UX, Linux, and Windows platforms, Oracle DataGuard, Oracle RAC, Advanced Replication, and PL/SQL programming.
• Very strong system administration, Unix and shell programming skills.
• Competent in upgrading and migration of databases.
• Competent in performance tuning my STRONGEST POINT , and troubleshooting of Oracle databases. Used several Oracle and Quest software tools like OEM Grid Control , TOAD, FogLight, Quest Central, and BMC's Patrol for performance monitoring and tuning of databases.
• Competent at backup and recovery of Oracle databases, installation and configuration of Recovery Manager and integration of RMAN with Veritas' NetBackup and Legato's NetWorker for backup and restore of Oracle databases.
• Excellent exposure to EMC storage devices like Symmetrix and Clariion, and competent in implementing TimeFinder, SRDF for split mirror backups for cloning, and integrating Oracle backup and recovery with RMAN, Legato and EMC TimeFinder.
• Installed, configured, and implemented VLDB Very Large Databases on Sun's E10K, HP's DL580, and Fujitsu's 850. Features exploited are RAID configuration, I/O striping, use of raw partitions, dynamic multi-pathing with the help of EMC's PowerPath and Veritas' Volume Manager.
• Established standards and developed platform build documents for installation of RDBMS Oracle, MS SQL Server databases on Solaris, HP-UX, Linux, and Wintel platforms.
• Multi-year of SAP experience with all project stages including business development, project estimating, requirements determination, gap analysis, business process reengineering, issue resolution, configuration, custom code specifications, training, go-live assistance and post implementation support
• Implement and maintain SAP applications, and business process procedures, that support global organizations with optimized business solutions.
• Detail, hands-on knowledge and experience in all aspects of SAP Netweaver, SAP/ERP Enterprise Resource Planning ECC , SAP/BW-BI Business Warehouse-Business Intelligence , and SAP Solution Manager.
• Broad skills and know-how of SAP's BPC BusinessObjects Planning and Consolidation EPM tool, on installation Microsoft platform , maintenance, and support.
• Extensive knowledge of Business Process Re-engineering BPR and Change Management in SAP
• Excellent on managing and leading a team of IT professionals, charismatic team player, strong project management skills in planning and implementing tasks.

BUSINESS EXPERIENCE

Confidential

The company is a direct marketer of brand name and private label products Global Industrial, TigerDirect, CompUSA, Circuit City, Misco, WStore . The company's multi-faceted marketing plan features Internet, relationship marketing, and inbound catalog sales, online retailers of IT products and consumer electronics. Operates in Austria, Belgium, Finland, France, Germany, Ireland, Italy, The Netherlands, Spain, Sweden, Switzerland, Poland, Portugal, and the United Kingdom.

Database Architect // DBA Team Lead

• ProfitCenter Software's Profitability Suite is a web-based suite that provides Point-of-Sale, Sales Force Automation, CRM, Order Processing, Accounting, ERP-Expense Management capabilities to any type/kind of business. The software is J2EE compliant, with backend Oracle11g RAC on RH EL AS 3.0/4.0/5.0 and middle tier BEA's WebLogic Application Server. The backend 3-node RAC database has been upgraded to Oracle11g R2, running on Red Hat's Linux Operating System.
• There are multiple installations of the PCS software suite for all the business units. The biggest implementation is with the Miami-based unit TigerDirect , over a 1TB of Oracle 11g R2 database size.
• There are two 2 installations of the PCS suite in Europe, one based in Germany covering Germany, Austria, Belgium, The Netherlands, Switzerland, Italy, Poland, Sweden, Finland and the other one in UK covering UK, France, Ireland, Spain, and Portugal .
• The sizes of each database is about 500GB each.
• The main focus was on SQL tuning and performance. Using 10g's SQL tuning advisors and lately 11g R2 SQL Performance Analyzer SPA manually and/or Oracle Enterprise Manager OEM .
• Have implemented DataGuard for DR solutions, by using both physical and logical standby databases.
• Backing and restoring the databases by using RMAN, heavily.

Oracle11g RAC 64-bit Dev/Test/Prod

• Have installed Oracle11g RAC 64-bit on RedHat's EL AS 5.0 , the Linux Kernel is 2.6.9-22.ELsmp. The environment setup is as follows: A Configuring the Network : private network private ip's, to carry Cluster Manager and Cache Fusion inter-node connection, public network public ip's , and public vip see VIPCA . B Shared Disk Storage for B1 Oracle Clusterware Oracle's Cluster Ready Services CRS requires two files, the Oracle Cluster Registry OCR file and the CRS Voting Disk file, which must be shared across all RAC nodes. I have used raw devices for creating two 2 file systems, one for OCR and one for Voting Disk. B2 Using ASM Automatic Storage Management group disks for all the database files data files, control files, redo, etc . For ASM to become available, ASM instance needs to run first. Created two 2 ASM Disk Groups, one group for data and the other one for Flash Recovery Area. Implementing TAF Transparent Application FailOver and adding more clustering nodes for balancing and availability of client application. Starting with 11g R2, implementing SCAN Single Client Access Name replacing TAF, more efficient and provides less maintenance. Used Jumbo Frames for tuning Oracle Cache Fusion interconnect by implementing the proper MTU size.

Oracle RDBMS ETL Processing // Interfaces

All small clients are under the same database having multiple schemas on a multi-node RAC environment. Oracle RAC is on RedHat's EL AS platform. It is a hybrid environment, between on-line transaction system OLTP for all the online web-based users and many backend processes for keeping the system current from many vendors/clients/warehouse updated and shipping requests. There are many overnight bulk-load processes by using Mercator as the ETL tool for loading data.

Oracle's interMedia Text

• Full Text Indexing using Oracle Text interMedia, Domain Indices . An extensive full-text indexing technology allowing to efficiently query free text and produce document classification applications.
• CONTEXT Indices, CTXCAT Indices, CTXRULE Indices. ctx ddl .
• Search for Words containing special characters Minus, Hyphens, etc.
• Index Maintenance / Logging ctx schedule, ctx output .
• Data Replication // DR
• Clients access their data directly not via the application interface from a replicated copy of the main PCS database. This is accomplished by using Oracle's Data Guard Logical Standby Database feature, that provides real-time data synchronization.
• Point-of-Sale // Interfaces
• There are local database copies of the POS Point-of-Sale application, at the client's side. This database syncs up with the main PCS database with the usage of interfaces pulling and pushing data , including sensitive data credit card info , that's being encrypted. Both local copies and remote copies run on Oracle RDBMS, upgraded to 11g R2 first quarter of 2012.
• SAP ERP / BI / Solution Manager application modules
• All SAP's modules ERP, BI, Solution Manager run on Oracle 10g R2 10.2.0.4 .
• Planning on upgrading the Oracle backend database to Oracle 11g R2 on the 3rd quarter of 2012.
• Architect, design, develop, plan, implement, test, document complex SAP multi-tier processes and procedures for SAP ERP Central Component ECC 6.0, SR3 , Business Intelligence BI , and Solution Manager, running on a 2-node MSCS Microsoft Cluster Services , 64-bit platform Unicode system . Solution Manager runs on a dual stack system ABAP Java stack
• Design and implement the SAP NetWeaver Application Server WebAS NW 7.0 for entire landscape structure, along with the client configuration strategy 'Golden Client', Development Client, Unit Test, Integration Test, Data Conversion, Best-Practices Configuration .
• SAP Security Administration Role Design/build , BI Security.
• Set up the SAPRouter and IP-Port mapping, along with certificate creation and renewals.
• SAP Security Access Authorization Object Tracing /ABAP Debugging SQL Trace
• SAP CUA Central User Administration configuration on all landscapes.
• SAP Database Administration
• Transport Management System CTS Configuration
• SAP ECC Upgrades, Database Upgrades, Kernel Upgrades, SAP Support Packages, SAP Notes by using SAP Note Assistant.
• Performance monitoring and tuning CCMS , Operating System parameters configuration.
• System Refreshed, Client Exports/Imports, Homogeneous System Copies.
• Install, configure, maintain GLSU, which allows the organization to streamline its financial data entry functions.
• Maintain and support of Solution Manager and all the contents of all SAP Projects Org. Structure and Global Settings, Enterprise Management and Support, Procurement, Master Data, Project Management, Basis Team, Development Team, Integration Testing, Change Management .
• Expert knowledge in all areas of SAP application, and database performance and tuning.
• Set up Security Audit Log, for the Tax Director and IA Internal Auditors needs.
• Maintain and support of BI/BW's data refreshes Full and/or Delta Loads for all activated InfoProviders , MultiProviders, and InfoSets .
• BI data extraction to be provided to BPC application Open Hub Destination , for the company's quarterly earning reports.
• Maintain and support of all SAP Reporting Tools BEx Analyzer, BOBJ's Crystal Reports and Xcelsius that access BI data and raw data.
• Definition of BI blueprints with business specific reporting and authorization requirements.
• Implementation of BI Authorization Concept.
• Installation of SAP standard and generic extractors for SAP and non SAP data sources.
• SQL Server 2008 Enterprise Edition
• Calculating, tracking, and managing, company-wide, customer rebates, by running 3-rd party software on Microsoft's SQL Server 2008 RDBMS.

Confidential

Database Architect / Lead DBA, Engineering/Infrastructure Group

• BoA Specialist Client Portal Stream Replication Conflict Resolution
• BoA Specialist Client Portal provides on-the-spot communications and analysis to their corporate clients to keep them apprised of moves in the marketplace that directly or indirectly affecting their stock portfolio. Oracle10g's Stream Replication has setup as bi-directional replication. In a multi-database Streams environment allowing concurrent DML operations on the same data, conflicts can occur. When the apply process is applying changes directly to a table, and a conflict or an apply error is encountered, the apply process tries to resolve the error using a conflict-handler. Or a user-specified procedure called an error handler. There are three 3 types of conflicts: a Update, b Uniqueness, c Delete. Streams have four 4 pre-build update conflict handlers, but none for Uniqueness, Delete or other conflicts.

Major Migration/Moving DB Project

• There ha been a major migration project from HP-based UX-B.11 databases to Sun-based Solaris 5.9 ones. At the same time, we have physically to move the four 4 databases from the Charlotte, NC data center to Richardson, TX one. One of the databases was the main data warehouse one IDW of one 1.5TB size. It is quite a challenge since, moving from one platform to another, there are not too many options available.
• Data Warehouse DBA // ETL Tools
• Supporting the main data warehouse for the WIM business of the bank. A daily batch processing, loading the database with various feeds Fidelity's NFS, Bloomberg, Wall Street on Demand, Reuters, . The main ETL tool for extracting, transforming, and loading the data was Ab Initio.

Backup/Restore DR DataGuard Solutions

I was the point person for backup/restore and contingency/DR solutions for the WIM business branch of the bank. Having in place RMAN backup processes that will hot backup ALL the PROD databases to either DISK for large databases or to TAPE for small databases and cold backup ALL the DEV, TEST, UAT databases to DISK. There are many PRIMARY data centers such as Ridgefield Park, NJ Charlotte, NC Richardson, TX and many Contingency / DR data centers such as Secaucus, NJ Albany, NY San Francisco, CA . The main contingency / DR solution is the software one, by implementing Oracle's Data Guard. I am keeping all the SLO's and SSI's between the DBA group and the NetBackup and Production Control groups.

IBM's DB2 UDB

Because of Oracle's licensing deals, the bank is thinking of IBM's DB2 UDB RDBMS for 'large' databases. I have been at IBM's training center Palisades, NY multiple times for hand's research with a classroom instructor. We have been building DB2 UDB databases at our lab.

.NET Framework / Platform

The standard development platform is Microsoft's .NET. I have learned a big deal of the environment and its tools Visual Studio 2003 2005b for connecting to any back end MS SQL Server or Oracle .

MS SQL Server Admin

• Many new 'small' applications were build with MS SQL Server 2000 as the back end. I had formal training on SQL Server 2000 and its suite of tools at Microsoft's office s and from Learning Tree, Inc.
• The main DBA tools, Enterprise Manager and Query Analyzer provided by Microsoft along with other 'services' DTS, Data Transformation Services are part of my database admin arsenal.

Quality Management

• Six Sigma activities, Hoshin and Kanri Planning.
• DMAIC Define, Measure, Analyze, Improve, Control Problem-Solving Process.
• Green-Belt Candidate , Business Fundamental Plans Breakthrough Planning cascade down .
• Senior Database Analyst/Researcher
• Continued the implementation on Oracle9i RAC Real Application Cluster database 9.2.x on LINUX machines and OS, as well as on Oracle 10g.
• The main Linux/Oracle evaluation that was running on a two 2 node HP machines was as follows:
• - Linux cluster pre-install check/update for Oracle RAC
• - Oracle Cluster File System OCFS install
• - OCFS partitions format and mounting
• - Oracle Cluster Manager OCM install and config
• - Hangcheck-timer install and config
• - Oracle Universal Installer and JVM RT install
• - Oracle GSD Global Service Daemon
• Confidential

Manager / Lead DBA, Production Database Administrator Group

Managing a group of ten 10 Oracle DBAs that support the production and QA Oracle instances. Creating the schedule work for every member of the group for providing 7x24, weekend, holiday support. Establish environment standards: Oracle RDBMS standards, Database Naming standards, RMAN standards, Monitoring/Alerting scripts, refreshing QA environment.

Database Administrator on Oracle9i databases with vendor's products.

Supporting an array of Oracle9i databases 9.2.0.x with third vendor's products such as SIEBEL'S CMR package, EAGLE Pace data warehouse and GIM's 2000 applications. There were many issues with all vendor's codes functions, procedures, packages and had to use Oracle's Stored Outlines to indirect alter their code any direct alteration at the code was not supported by the vendor .

Senior Database Administrator on Oracle9i RAC databases

Supporting an Oracle9i RAC Real Application Cluster database 9.0.1.x that was the back-end for the Quick Reilly on-line trading site. The application was developed on a Java-based and J2EE-based technology by using the following products: WebLogic 6.1, iPlanet 6.0, CNT, MQ Series, Tibco Rendezvous, and Oracle 9i RAC . There were two 2 primary database servers using Sun Cluster 3.0 software based at Sterling, VA and two 2 secondary database servers hosted at Ridgefield Park, NJ. There was a master-to-master replication in place and many fail-over automated procedures. RMAN hot backups to disk and tapes, as well as exporting specific tables in specific time-intervals of the day. The main area of concern at this environment were: global cache, RAC tuning and the cache fusion part of the Interconnect architecture.

Confidential

Senior DBA, Engineering Database Group

• Senior Data Warehouse Analyst
• Responsible for developing, enhancing, and supporting the Data Warehouse of the company
• Analyzing, transforming, aggregate the data sources to the database.
• Oversee performance and maintenance of the Data Warehouse along with other applications Siebel, DCMM Database Campaign Marketing Management, Oracle Financials, ADP BPS Advantage as well as any application group needed access to the Data Warehouse.
• Applying Oracle's new feature: Partitioning range, hash, composite, exploring list-partitioning in 9i , Transportable Tablespaces, Function-based indexes, LogMiner and using STATSPACK as the tuning utility. Exports with the query feature.

Disaster/Recovery Analyst

• The D/R plan was THE MOST IMPORTANT project that kept this company in business, after the Sep-11-2001 catastrophic events.
• Using EMC's SRDF technology, were able to have mirror data up to the last transaction to a remote disaster area.
• Using Oracle's RMAN scripts, there were hot backups done daily.
• Using Oracle's Standby DataGuard feature, HA was provided to the most crucial 7x24 applications.

ORACLE 8i 9i

Data Architect

Designed, implemented, and maintained E/R diagrams for data analysis and data modeling by using Oracle's Designer 2000 and Ardent's MetaStage package for a centralize repository /BID . For the loading and /or cleansing, transformation of the data sources to the database using Ardent's DataStage product extensive training at the Ardent's Sunnyvale CA office along with Platinum's Computer Associates now AutoSys scheduling product for running and scheduling the daily load of the Data Warehouse formal in-the-house training on this product as well .

Database Administrator

Primary DBA tools are : Oracle's Enterprise Manager OEM and Performance Pack and Platinum DBVision. Started 2001, BMC's Patrol suite of tools were used as well as Quest's Spotlight for Oracle.

Siebel Architect Administrator

Maintained and supported the Socrates system. System that was built into an Oracle database running on RBO RULE-BASED-OPTIMIZER mode and MTS Multi-threaded Server since there were over 1000 clients connected through out the country. End users were win-95, win-98, win-2000 and win-NT Compaq Deskpro.

UNIX Sun Solaris 2.6

Unix Developer

• Designed, implemented, enhanced, and maintained many Bourne shell and Korn shell scripts for automating data warehouse tasks and system's environments as well as Perl scripts for the company's
• Automation download process of Bloomberg Data Sources.

Unix System Administrator

Installed, administer, and maintained software and hardware for all sun boxes. Installed and configured a Storage Library Jukebox Storage Tek 9714 Storage Library running LEGATO's NetAdmin program, an extremely powerful and versatile system for backing up anything and everything everywhere, by using either EBU Enterprise Backup Utility for backing up Oracle7.x Siebel Database and RMAN Recovery Manager for Oracle8.x Data Warehouse, DCMM .

Confidential

Senior DBA / Data Architect, Engineering Database Group.

Senior Database Analyst

• Responsible for developing internal projects for the all bank's branches needs and regulations.
• Converting Sybase database applications into Oracle ones.
• Oversee installation, performance and maintenance of Oracle related issues.

ORACLE 8.0.5

Data Architect

Designed, implemented, and maintained E/R diagrams for data analysis and data modeling by using Logic Works ERWin product PLATINUM/CA

Database Administrator

• Many years of experience in ORACLE RDBMS and SQL programming PL/SQL coupled with
• Windows NT, UNIX based systems administration knowledge. Primary DBA tools are : Oracle's Enterprise Manager OEM and Performance Pack.

Confidential

Senior DBA / Oracle Financials Admin, Engineering Database Group.

Senior Database Analyst

• Responsible for developing a big Loan-Origination project Cityware based on a three-tier architecture by using FORTE as the middle tier and Oracle as the back-end and using ACTUATE as the primary reporting tool, and connecting 500 end users through out the different branches of the company.
• Coordinate executive committee projects with various project leaders provide software user support.
• Oversee installation, performance and maintenance of Oracle Financials..

ORACLE 7.x 8.0.4

Data Architect

Designed, implemented, and maintained E/R diagrams for data analysis and data modeling by using Logic Works ERWin product.

Database Administrator

• Many years of experience in ORACLE RDBMS and SQL programming PL/SQL coupled with
• Windows NT, UNIX based systems administration knowledge. Primary DBA tools are : Oracle's Enterprise Manager OEM and BMC's Patrol Database Administrator Tool.

ORACLE FINANCIALS

Oracle Applications 10.7, Prod. 16.1 SC Smart Client

System Integrator

Maintained and supported the system. Server is on Sun Enterprise 4000, client is on Compaq Proliant and end users are win-95 and win-NT Compaq Deskpro

UNIX Sun Solaris 2.5.1

Unix Developer

Designed, implemented, enhanced, and maintained many Bourne shell and Korn shell scripts for automating db tasks and system's environments as well as Perl scripts for the company's Firewall.

Unix System Administrator

Installed, administer, and maintained software and hardware for all sun boxes. Installed and configured a Storage Library Storage Tek 9714 Storage Library running Veritose's NetBackup program, an extremely powerful and versatile system for backing up anything and everything everywhere. Automated database tasks by using the CRON.

NT 4.0

System Administrator

Having many Oracle instances running on various NT machines, had to administer those Automated database tasks by using the AT command..

Confidential

Database Developer / DBA , Development Database Group.

Senior Systems Analyst

• Responsible for deployment and development of software modules based on the client / server architecture.
• Coordinate executive committee projects provide software user support.
• Oversee user interface, software development and installation, and network management and performance.

DATABASE ORACLE 7.x

Data Architect

• Designed, implemented, enhanced, and maintained an ORACLE multi-platform NetWare, NT,
• UNIX , mutli-user database

Database Application Developer

• Developed based on client/server architecture the front-end part of an application module
• by using ORACLE 's primary development tools : Developer 2000, Designer 2000, and
• Discoverer 2000 Forms, Graphics, Reports .
• Used extensively PL/SQL for Triggers, Stored Procedures and Procedure Calls.
• Applied ORACLE's built-in Packages and user-defined Packages.

Database Administrator

• A couple years of experience in ORACLE RDBMS and SQL programming PL/SQL coupled with
• Windows NT, UNIX based systems administration knowledge.

Confidential

Director, Technical Information Services Department

Senior Advisor to the Mayor

• Supervised and trained a staff of hundred-twenty people.
• Provided work-related and progress in all the city, to the Mayor and to the City Council.
• Served on committee with other Municipalities of Europe City of Manchester - England, City of Stugard - Germany, City of Barcelona - Spain, City of Milan - Italy .
• Writing proposals and collaborated with Government Officials to accomplish projects and Workshops.
• Planned and evaluated systems that will be developed and installed in the City of Athens for the next Millennium.

TEACHING / ADMINISTRATIVE

EXPERIENCE

Confidential

Computer Science Department Graduate Division Adjunct Faculty

• Taught courses in intermediate and advanced Data Structures and Programming Languages.
• Taught courses in intermediate and advanced Data Bases and programming them.
• Taught credit-bearing courses in Elements and Introduction of Algorithms and advanced topics in Analysis and Performances of Algorithms .
• Evaluated course development and instruction in Data Bases and Programming.
• Served on committee to reassess the use of the Academic Computer Center in order to meet the Today's Technology.
• Conducted staff development and peer supervision.

Confidential

Computer Science Department PhD Program

• Took courses in intermediate and advanced Data Structures and Programming Languages.
• Took courses in intermediate and advanced Data Bases and programming them.
• Took credit-bearing courses in Elements and Introduction of Algorithms and advanced topics in Analysis and Performances of Algorithms .
• Worked on my Thesis and Dissertation based on Advanced Algorithms

Confidential

Computer Science Department

• Took courses in intermediate and advanced Data Structures and Programming Languages.
• Took courses in intermediate and advanced Data Bases and programming them.
• Took credit-bearing courses in Elements and Introduction of Algorithms and advanced topics in Analysis and Performances of Algorithms .

Confidential

Department of Mathematics and Physics Under-Graduate Division Teaching Assistant

• Taught courses in intermediate and advanced Analysis and Algebra.
• Taught courses in intermediate and advanced Probabilities and Statistics.
• Taught courses in Elements of Physics and Astronomy's .
• Served on a team in participating in Mathematical Olympics .