OBJECTIVE

Information Technology/Systems management consulting to provide project leadership in E-Business ERP,CRM , E-Commerce, E-Gov, Data Warehousing, Storage Network and Web Application developments in both federal governments and commercial industries

QUALIFICATIONS

• Over 18 years of IT/IS experiences, focusing on E-Business web applications and Data Warehousing OLAP/BI
• Full lifecycle E-Business ERP,CRM planning, implementing, customizing, integrating, troubleshooting, performance tuning, user training and upgrading using Oracle Applications 12, 11i, 10.7 in federal /commercial industries
• Full lifecycle Data Warehousing Data Mart, OLAP, BI plan, system requirement analysis, back-end data model and front-end reporting tools design and development, extraction/transformation/loading ETL , prototyping, testing, evaluation, production deployment and support, performance tuning, and user training using Oracle 10g/9i/8i/7.x , OEM, Designer, Developer, Warehouse Builder, Express Server, Discoverer 10g/9i/4i/3.x , Financial Analyzer, DB2, Sybase, SQL Server, SAS, Informatica, ERWIN, Business Objects, Crystal Reports, Cognos
• Enterprise architecture EA strategic plan, business requirement analysis, design, implement and operational management using SOA, XML, Web Service, J2EE, .NET, Rational Rose XDE, RUP, UML, BPEL and Workflow
• Designing, building and managing highly available, scalable and secure web service data center infrastructure using Cisco router, content switch, firewall, load balancer, Oracle9iAS and IBM WebSphere, web application server farm, Real Application Cluster RAC/OPS 8i,9i,10g , Microsoft network, EMC storage network SAN, NAS , HP Service Guard, Superdome server and SUN Cluster
• Web applications and web service development using Oracle9iAS, Portal, WebDB, Designer 6i, Developer Forms 4.5-9i, Reports 2.5-9i , Discoverer 10g/9i/4i/3.x , PL/SQL Server Pages, HTML, XML, JavaScript, Java servlets, JSP and EJB
• Unix SUN Solaris, HP-UX, IBM AIX, Linux and window NT/2K administration, patching and shell scripting Korn, bash clustering, load balancing and failover using SUN Cluster, HP Service Guard, IBM HACMP, MSCS and Veritas VCS server partitioning and data center consolidation using HP vPar, IBM LPAR and SUN Domain
• Enterprise storage network SAN, NAS, DAS design and implementation using EMC Symmetrix, Connectrix, Celerra, Clariion, Enterprise Control Center ECC , Timefinder, Powerpath, SRDF, SnapView, and SAN Copy , Veritas Netbackup,VM,VCS , StorageTek and HP tape library
• Software sales /marketing technical supporting by proposal, presentation, demonstration, prototyping, interacting with clients and customer relationship management
• Eight years of software Project Management experience In-depth understanding of the SEI SW-CMM Key Process Areas of CMM Levels 2 and 3 Experience working in CMM Level 2 or higher environment Possess knowledge of software project planning, estimating, tracking and reporting, process and product quality analysis Ability to perform customer negotiations. Strong verbal and written communication skills Ability to exercise good judgment, set goals, make plans and track performance. Knowledge and expertise with Oracle, J2EE and .NET Architecture, PVCS, and Rational Unified Process methodology. Develop and maintain strategic plans along with budget and project management for the support team DBA and SysAdmin Develop and implement policies, procedures and best practice Develop a strong collaborative relationship with customers, development groups, end users and other IT teams Coordinate and develop a 24x7 support structure as needed

JOB EXPERIENCE

Confidential

• Providing technical and business functional consulting services and project leadership as Sr. Applications DBA / Developer / System Administrator to upgrade/implement Oracle Applications 11i 11.5.10 and 12 for GSA human resources systems
• Plan, install, configure, setup and upgrade Oracle Applications 11i 11.5.10 to Release 12
• Technical architecture design and multi-tier internet computation architect implementation, client requirements and gap analyses, business process re-engineering BPR , capacity planning and sizing management
• Install, configure, patch, integrate and test IBM AIX unix servers and Enterprise storage network SAN, NAS , Define procedures and set processes and unix scripts for automating repetitive tasks, such as backup, refresh, shutdown and startup instance.
• Backup / Disaster Recovery management including capacity plan, backup and restore technology infrastructure, on-site storage, off-site storage, backup scheduling, performance optimizing, troubleshooting, and tape retention policies.
• Set up oracle application suite environment. using AD utilities to install and configure various components of technology stack Database Server, Web Application Server, Developer Form and Report Server, Administration Server and Concurrent Process Server, Apache Server and Portal on the Unix and NT platforms, configure network using ssl, https/sql net 8 , perform post-installation tasks, apply patches, migrate/upgrade various software tools
• Converting standard 11i single instance installation to Real Application Clusters RAC 9i/10g , configuring load balance, fail over and parallel concurrent processing PCP using autoconfig and ADX utilities Install, create, administer, and monitor ASM and RAC databases Performance tuning and trouble shooting RAC Develop backup and recovery strategy for RAC databases
• Installing and integrating 11i with Application Server 10g components including Oracle Internet Directory OID , Portal Single Sign-On server SSO and Discoverer
• Cloning Oracle Applications Release 11i with Rapid Clone and Autoconfig
• Using Autoconfig and OEM to maintain multiple database instance demo, development, test, training, and production , analyze, and monitor database growth, manage tablespace fragmentation, backup recovery using RMAN and Veritas Netbackup
• Troubleshooting and resolving the problems, serving as the liaison with Oracle, logging tars, reproducing the error in the testing arena, searching and downloading patch files
• Performance tuning by collecting performance statistics for various components, analyzing and implementing tuning recommendations using various applications AD and DBA utilities
• Administer and customize application database security/responsibility, create user accounts and grant privileges, install configure printers, and monitor concurrent processing in Oracle Applications
• Plan and perform migration and upgrading of oracle databases 8.1.7 to 9.2.0.6 and applications 11.5.4 to 11.5.10 using migration tools, Export/Import, PL/SQL API and SQL Loader cloning/refreshing ERP instance from production to testing or development environments, backup, server partition, and version compatibility
• Set up and administer Oracle Workflow, design workflow processes to automate and streamline business processes using Oracle Workflow Builder, define event subscriptions to perform processing triggered by business event monitor the status of a runtime workflow process and respond to notifications, implement advanced workflow process design features, customizing Workflow Processes, write custom PL/SQL procedures for use in workflow processes, install and configur Oracle XML Gateway, Oracle Workflow Business Events System and Oracle Transport Agent on Oracle Applications 11i
• Customizing/extending oracle ERP applications system, build or modify window interface and reports using SQL Plus, PL/SQL, SQL Loader, Developer tools Forms 6i, Reports 6i and Discoverer develop open interfaces for data conversion and import from legacy system or other operational data system into oracle financial database, using sql, pl/sql, sql loader, unix scripts and concurrent programs, using pl/sql to implement business logic and data validation
• Training, mentoring and documenting technical and operating procedures
• Using Oracle Warehouse Builder to design, implement, and load a data warehouse Create definitions for a logical warehouse schema, its data sources, and the operations that extract data from a source, transform the data, and load the data into a warehouse Configure a physical instance of the logical warehouse, validate the set of definitions for the instance, generate a set of scripts that create and load a physical instance, and deploy a physical instance to an Oracle8i/9i database system Update and refresh the data warehouse, and set up Oracle Enterprise Manager and Oracle Workflow to manage the warehouse operation
• Using Discoverer to setup EUL and business areas, and generate reports for management decisions. Integrate Discoverer with Oracle Applications and BIS
• Created and modified XML documents, supported for XML offered in various Oracle products, such as database and applications. Stored and Retrieved XML in Oracle Databases
• Setup and customize self service web applications OSSWA using OA Framework. Set-up OA Framework Development environment with jDeveloper Creating OA Framework application to implement search, insert, update, and delete Debugging OA Framework Applications Implementing Part Page Rendering Creating Applications Menus and Function Security Personalizing and Extending OA Framework Pages
• Plan,deploy and maintain SAS data warehousing OLAP/BI infrastucture, install and configure business intelligence platiform components including SAS foudation SAS9,ACCESS,SHARE,CONNECT,STAT,GRAPH , BI servers Metadata, ETL,Workspace, Stored Process and WebDAV and applications Management Console,Information Map and Delivery Portal,Web Report Studio Perform administrative tasks Application performance analysis and optimization, Maintenance of users and security permissions,migration and replication, troubleshooting and patching

Confidential

• Providing technical and business functional consulting and project management as Sr. Applications DBA / Developer / System Administrator to upgrade/implement Oracle Applications from 10.7 to 11i 11.5.9 for NIST financial systems
• Technical architecture design and multi-tier internet computation architect implementation, client requirements and gap analyses, business process re-engineering BPR , capacity planning and sizing management
• Install, configure, patch, integrate and test unix servers and network infrastructure, Enterprise storage network SAN, NAS design and implementation using EMC Symmetrix, connectrix, Celerra, Clariion, TimeFinder, Powerpath, SRDF and Veritas CVM, VCS, Oracle DB edition and Netbackup, StorageTek and HP tape library
• Backup / Disaster Recovery management including capacity plan, backup and restore technology infrastructure, on-site storage, off-site storage, backup scheduling, performance optimizing, troubleshooting, and tape retention policies.
• Set up oracle application suite environment. using AD utilities to install and configure various components of technology stack Database Server, Web Application Server, Developer Form and Report Server, Administration Server and Concurrent Process Server, Apache Server and Portal on the Unix and NT platforms, configure network using ssl, https/sql net 8 , perform post-installation tasks, apply patches, migrate/upgrade various software tools
• Converting the existing single instance installation to Real Application Clusters RAC 9i
• Cloning Oracle Applications Release 11i with Rapid Clone and Autoconfig
• Using Autoconfig and OEM to maintain multiple database instance demo, development, test, training, and production , analyze, and monitor database growth, manage tablespace fragmentation, backup recovery using RMAN and Veritas Netbackup
• Troubleshooting and resolving the problems, serving as the liaison with Oracle, logging tars, reproducing the error in the testing arena, searching and downloading patch files
• Performance tuning by collecting performance statistics for various components, analyzing and implementing tuning recommendations using various applications AD and DBA utilities
• Administer and customize application database security/responsibility, create user accounts and grant privileges, install configure printers, and monitor concurrent processing in Oracle Applications
• Plan and perform Migration and upgrading of oracle databases 7.3.4 to 8.1.7 to 9.2 and applications 10.7 to 11.03 to 11.5.9 using migration tools, Export/Import, PL/SQL API and SQL Loader cloning/refreshing ERP instance from production to testing or development environments, backup, server partition, and version compatibility
• Define procedures and set processes and unix scripts for automating repetitive tasks, such as backup, refresh, shutdown and startup instance.
• Set up and administer Oracle Workflow, design workflow processes to automate and streamline business processes using Oracle Workflow Builder, define event subscriptions to perform processing triggered by business events,monitor the status of a runtime workflow process and respond to notifications, implement advanced workflow process design features, customizing Workflow Processes, write custom PL/SQL procedures for use in workflow processes
• Customizing/extending oracle ERP applications system, build or modify window interface and reports using SQL Plus, PL/SQL, SQL Loader, Developer 2000 tools Forms v4.5 6i, Reports v2.5 6i and Discoverer develop open interfaces for data conversion and import from legacy system or other operational data system into oracle financial database, using sql, pl/sql, sql loader, unix scripts and concurrent programs, using pl/sql to implement business logic and data validation
• Functionally implement, setup and test Oracle application modules such as GL, FA, and ADI, using tools like applimation, kintana, and dataload for setup migration
• Training, mentoring and documenting technical and operating procedures
• Using Oracle Warehouse Builder to design, implement, and load a data warehouse Create definitions for a logical warehouse schema, its data sources, and the operations that extract data from a source, transform the data, and load the data into a warehouse Configure a physical instance of the logical warehouse, validate the set of definitions for the instance, generate a set of scripts that create and load a physical instance, and deploy a physical instance to an Oracle8i/9i database system Update and refresh the data warehouse, and set up Oracle Enterprise Manager and Oracle Workflow to manage the warehouse operation
• Design, develop, test, and deploy Discoverer reports, using Discoverer to setup EUL, business areas and folders, and generate reports for management decisions. Integrating Discoverer with Oracle Applications and BIS, using materialized views for automated summary management, enabling Web Cache for Discoverer Viewer. Integrating Discoverer with Oracle9iAS Portal and Single Sign-On.
• Building the various components of the Balanced Scorecard system using tools within the Balanced Scorecard - BSC Builder, KPI Designer, MetaData Optimizer and the OBSC Loader.
• Setup and customize self service web applications OSSWA , self service human resource SSHR using OA Framework
• Working in CMM Level 2 and 3 environment project planning, estimating, tracking and reporting, process and product quality analysis set goals, make plans and track performance. Technical supporting business developments, PVCS ERP Change Management for Oracle Applications
• Plan,deploy and maintain SAS data warehousing OLAP/BI infrastucture, install and configure business intelligence platiform components including SAS foudation SAS8,ACCESS,SHARE,CONNECT,STAT,GRAPH , BI servers Metadata, ETL,Workspace, Stored Process and WebDAV and applications Management Console,Information Map and Delivery Portal,Web Report Studio Perform administrative tasks Application performance analysis and optimization, Maintenance of users and security permissions,migration and replication, troubleshooting and patching

Confidential

• Design, implement, operate and manage a highly available, scalable and secure data center for database warehouses and web applications for PTO and NOAA, DOC
• Design and modify Federal Enterprise Architecture Framework including business process modeling reengineering, process workflow, data architecture, application architecture, technology architecture, implementation plan and migration/transition
• Enterprise architecture business requirement analysis, strategic plan, design, implement and operational management security, high availability, scalability and performance and manageability using J2EE, .NET, RUP and UML
• Evaluate current architecture infrastructure, identify single point of failure and implement fault tolerance and redundancy,
• Server platform evaluation and selection, clustering using HP ServiceGuard, IBM HACMP and SUN Cluster
• Data Center consolidation and rebuilding using Window 2000 network infrastructure, Cisco routers, content switches, load balancers and firewalls
• Enterprise storage network SAN, NAS design and implementation using EMC Symmetrix, connectrix, Celerra, Clariion, TimeFinder, Powerpath, SRDF and Veritas CVM, VCS, Oracle DB edition and Netbackup, StorageTek and HP tape library
• Backup / Disaster Recovery management including capacity plan, backup and restore technology infrastructure, on-site storage, off-site storage, backup scheduling, performance optimizing, troubleshooting, and tape retention policies.
• Web/Application server farms using IBM WebSphere and Oracle9i Application Servers with load balancing and failover
• Clustered Database server using Oracle9i Real Application Cluster RAC and OPS in Active/Active or Primary/Secondary
• Security infrastructure including policy, domain and procedure firewalls, DMZ, IDS, server security, network security, storage security, database security, web/application security
• Management infrastructure including performance monitoring and optimization
• Backup and disaster recovery plan including remote web site or data center replication and synchronization
• Providing Federal Financial Management System FFMS data warehouse and data mart system requirement analysis, architecture design, development, programming, maintenance, trouble-shooting and performance tuning on the Core Financial System CFS including General Ledger, Accounts Payable, Purchase, Labor Distributions and Budgets modules, and finance data warehouse projects using Oracle8i/9i, Developer 6i, Discoverer 4i, Oracle Warehouse Builder and SQL Plus

Confidential

• Providing technical and business functional consulting services as Chief Architect / DBA / Developer / System Administrator and Programmer/Analyst in Oracle Applications Financials, Human Resources, Manufacturing Supply Chain/Distributions , Web Applications and Data Warehouse environments for both commercial industries Wachovia, Boeing and federal governments Marine Corp, DOD
• Design and modify Federal Enterprise Architecture Framework including business process modeling reengineering, process workflow, data architecture, application architecture, technology architecture, implementation plan and migration/transition.
• Providing Federal Financial/Accounting System requirement analysis, architecture design, development, programming, maintenance, trouble-shooting and performance tuning for Department of Commerce on the Core Federal Financial System CFS including General Ledger, Accounts Payable, Purchase, Labor Distributions and Budgets modules, and finance data warehouse projects using Oracle8i/9i, Developer 6i, Discoverer 4i, Oracle Warehouse Builder and SQL Plus, TOAD
• Design, build and maintain oracle application forms and reports using Oracle Developer Forms 4.5 6i, Reports 2.5-6i
• Install and configure OLAP system, design and build reports using Oracle Discoverer to enable OLAP data analysis like drill up, drill down and drill through
• Debug SQL and PL/SQL codes to resolve issues related to software problems, test programs through the standard interfaces to ensure the data quality
• Investigate and resolve system performance issues by tuning logical and physical data model, objects, schema, instance, parameter and applications
• Enterprise storage network SAN, NAS design and implementation using EMC Symmetrix, connectrix, Celerra, Clariion, TimeFinder, Powerpath, SRDF and Veritas CVM, VCS, Oracle DB edition and Netbackup
• architecting and implementing information system high availability and disaster recovery solutions using Oracle Parallel Server OPS / Real Application Cluster RAC , Replication and storage area network SAN . Install and configure shared disk subsystems, server parameter file and oracle application clusters software using OUI, create real application cluster databases with DBCA, install and configure OEM and high availability features, and migrating/upgrading to oracle 9i configurations
• As a Technical Director, Oracle Applications DBA/Developer and Unix System Administrator, plan, Install, configure, implement and upgrade Oracle Applications Financials, Manufacturing and Human Resources v11.x 11i for Codeon Corp., CPS Security Trading System , Partner First Financial Service Wachovia Bank
• As a Technical Manager, Oracle Applications DBA / Developer, Plan, Install, configure, implement and upgrade Oracle Applications Financial 10.7, 11 11i for Confidential
• Set up oracle application system environment, run and monitor utility tools to install Oracle Applications components Database Server, Web Application Server, Developer Form Server, Administration Server and Concurrent Process Server on the Unix and NT platforms, configure network using Net8, perform post-installation tasks to prepare the system for use, apply patches, migrating/upgrading software and capacity plan
• Enterprise storage network SAN, NAS design and implementation using EMC Symmetrix, connectrix, Celerra, Clariion, TimeFinder, Powerpath, SRDF and Veritas CVM, VCS, Oracle DB edition and Netbackup
• Monitor and maintain database tablespace structure and application file systems through archiving purging, create user accounts and grant privileges, backup recovery, and performance tuning using various DBA utilities. User training, supporting and trouble-shooting
• Administer and customize application security, install printers, and manage concurrent processing in Oracle Applications
• Functional implement, setup and test Oracle application modules GL, AP, AR, FA and ADI
• Migrate and upgrade database 7.x to 8.x or 8i and applications 10.7 to 11.x or 11i , cloning and customizing applications, design open interfaces and reports using PL/SQL, Developer 2000 tools Forms, Reports and Discoverer
• Install, configure and administer business intelligence reporting system BI using oracle Discoverer
• Creating and managing multidimensional databases with Oracle Express Server, Discoverer and Financial Analyzer
• Web Applications development using Oracle Portal WebDB , Designer, Developer Forms 6i, Reports 6i , Discoverer 4i , Java and HTMLin Oracle Application Server 9i environment

Confidential

• Gather and analyze system requirements through interviewing users and reviewing legacy documents and reports
• Design logical and physical data models using ERWIN and Designer 2000
• Map, convert data and populate warehouse using PL/SQL, SQL Loader and SAS
• Diagnose and resolve performance issues using views, utilities and tools like UTLBSTS/ESTAT, SQL Trace, TKPROF, alert log and trace files, dictionary and dynamic troubleshooting views. Database backup recovery, export/import and security
• Perform UNIX and EMC/EDM system administrations user accounts, logical volume file system, backup recover
• Design and implement OLAP applications using Cognos Impromptu Web, PowerPlay Web
• Technical Leader as a Principal Information Engineer at Boeing Company, build Manpower Reserve Affairs: Human Resource Data Warehouse for Confidential
• Gather and analyze system requirements through interviewing users and reviewing legacy documents and reports
• Evaluate COTS/GOTS tools such as Oracle, DB2, SAS, Cognos, Business Object, MicroStrategy, Brio and informatica
• Design logical and physical data models ADS SDW using ERWIN and Designer 2000
• Map, convert data and populate data warehouse using Oracle Export/Import, PL/SQL, SQL Loader and SAS
• Diagnose and resolve performance issues using views, utilities and tools like UTLBSTS/ESTAT, SQL Trace, TKPROF, alert log and trace files, dictionary and dynamic troubleshooting views
• Build multidimensional data cubes and catalogs using OLAP tools like Cognos Impromptu, PowerPlay