OBJECTIVE

• Information Technology/Systems management consulting to provide project / technical leadership in Database, Data Warehousing & Business Intelligence, E - Business and E-Gov, as well as Web Applications development in governments and industries

SUMMARY

• Over 20 years of IT/IS full lifecycle experiences, focusing on Oracle Database, Data Warehousing (OLAP/OBIEE),E-Business Suite, and Web Applications development
• Oracle Fusion Middleware environment and components, including OAS, WebLogic, OID, IAM, SSO, Portal, J2EE OC4J, BPEL, OBIEE ; Integrate OID and AD; Integrate OVD, OAM, Identity Server, Policy Manager, Access Server, and WebGate WebCenter Spaces, Discussion, Wiki, UCM and Secure Enterprise Search; Full life cycle management of the Oracle ECM/WebCenter implementation
• Full lifecycle E-Business Suite (ERP,CRM) planning, implementing, customizing, integrating, troubleshooting, performance tuning, user training and upgrading using Oracle Applications (12, 11i, & 10.7) in both federal /commercial industries
• Full lifecycle database and 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(11g/10g/9i/8i/7.x), OEM, Designer, Developer, Warehouse Builder(OWB), Express Server, Discoverer(10g/9i/4i/3.x), Financial Analyzer, DB2, Sybase, SQL Server, SAS, Informatica, ERWIN, Business Objects, Crystal Reports, Cognos, Oracle Application Express (APEX), Oracle Business Intelligence Enterprise Edition(OBIEE) v10g
• 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 data center infrastructure using Cisco router, content switch, firewall, load balancer, Oracle Applications Server, WebLogic, and IBM WebSphere, web application server farm, Real Application Cluster (RAC/OPS 8i,9i,10g,11g), Microsoft network, EMC storage network(SAN, NAS), HP(Service Guard, Superdome server) and SUN Cluster
• Web applications service development using OracleAS 10g/9i, Portal, WebDB, Designer 6i, Developer (Forms 4.5-10g, Reports 2.5-10g), Discoverer(10g/9i/4i/3.x), PL/SQL Server Pages, HTML, XML, JavaScript, Java servlets, JSP and EJB
• Unix (Solaris, HP-UX, AIX, Linux) and window server administration, patching and shell scripting (Korn, bash); clustering, load balancing and failover using Cluster, HP Service Guard, IBM HACMP, MSCS and Veritas VCS; server partitioning and data center consolidation using HP vPar, IBM LPAR and SUN LDOM
• 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, as well as TMS RAM SAN
• Software sales /marketing technical supporting by proposal, presentation, demonstration, prototyping, interacting with clients and customer relationship management
• Over ten 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

PROFESSIONAL EXPERIENCE

Sr. Principal Consultant

Confidential, VA

Responsibilities:

• 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
• Plan, install, configure, setup and upgrade multiple very large-scale (up to 12 nodes) Oracle 10g RAC & ASM
• Plan, install, configure, setup and upgrade Oracle Fusion Middleware environment and components, including OAS, WebLogic Server, OID, IAM, SSO, Portal, J2EE OC4J, BPEL, OBIEE ; Integrate OID and AD; Integrate OVD, OAM, Identity Server, Policy Manager, Access Server, and WebGate WebCenter Spaces, Discussion, Wiki, UCM and Secure Enterprise Search;
• Plan, install, configure, setup and upgrade Oracle GRID Control using RAC & configure associated management packs, proactive monitoring and trouble-shooting various issues, scheduling backup/recovery jobs, export/import using data pump
• Plan, install, configure, setup and upgrade Oracle APEX web applications, collaboration suite, Web Center, Beehive
• Install, configure, operate and manage clustered WebLogic Server environments (development, staging, QA, and production ); Write custom scripts to automate tasks; Deploy J2EE application modules and libraries; Manage applications through the entire production lifecycle to ensure quality of service for large scale J2EE applications hosted on WebLogic Servers
• Install, configure, operate and manage highly available enterprise portals using WebLogic Portal, Oracle WebCenter Suite, and content management system; Rapidly build professional, collaborative portals with GroupSpace; Index and search information in the BEA Virtual Content Repository
• Creating workflows to represent a formal approval process for content checked into the content server; Managing content subscriptions; Using Archiver to export and import content; Managing multiple servers using the Configuration Migration Utility and Archiver Table Replication to synchronize system configurations; Setting up security and metadata models; Configuring general System Properties for contribution, such as automatic assignment of Content ID on check in; Enabling components that offer specialized functions or efficiencies; Contributing content using WebDAV and the Batch-loader administrative applet
• Plan, install, configure, setup and upgrade Microsoft sharepoint servers for team collaboration and project managements
• Install, configure, patch, integrate and test 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 using RMAN
• Set up and trouble shooting Oracle Streams, Data Guard and database links for data replications and integrations
• Install & configure CMDB enterprise management system, supporting very large software application development and deployment following ITIL processes for incident management, change management and problem management
• 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, cloning Oracle home and database using RMAN
• 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 like AWR and ASH
• 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 (8i & 9i to 10g/11g) 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 inOracle 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
• Installed and configured Oracle Business Intelligence Enterprise Edition(OBIEE) (including Oracle BI Server, BI Interactive Dashboards, BI Answers, BI Delivers, BI Disconnected Analytics, BI Publisher); Creating/Merging/Importing Objects from Metadata Repositories; Setting Up Multi-user Development Environment; Creating and Modeling Aggregate Tables, with OBI Administration Tool; Cloning and Synchronizing OBI Requests and Dashboards Using Content Accelerator Framework (CAF); Integrated OBI Publisher with OBIEE; creating Answers requests, dashboard pages, and using with OLAP; Creating Reports in Oracle E-Business Suite Using XML Publisher
• Used Informatica, Oracle Warehouse Builder (OWB) and Oracle Data Integrator (ODI) for ETL (extract, transform and load), dimensional modeling, data quality, data auditing, and full life cycle management of data and metadata;Consolidating heterogeneous data sources; Migrating legacy systems; Data modeling of relational and dimensional structures; Designing and managing metadata; Data cleansing; Data profiling and data quality auditing
• 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)

Sr. Oracle Consultant

Confidential, VA

Responsibilities:

• 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
• Migrated Oracle Applications Release 11i/12 running on a single database instance to Oracle RAC (10.2.0.4) with ASM
• Plan, install, configure, setup and upgrade multiple very large-scale (up to 12 nodes) Oracle 10g RAC & ASM
• Plan, install, configure, setup and upgrade Oracle Application Server using WebLogic Server, OID, IAM, SSO, Portal, J2EE OC4J, BPEL, OBIEE
• Plan, install, configure, setup and upgrade Oracle GRID Control using RAC & configure associated management packs, proactive monitoring and trouble-shooting various issues, scheduling backup/recovery jobs, export/import using data pump
• Plan, install, configure, setup and upgrade Oracle APEX web applications, collaboration suite, Web Center, Beehive
• Install, configure, operate and manage clustered WebLogic Server environments (development, staging, QA, and production ); Write custom scripts to automate tasks; Deploy J2EE application modules and libraries; Manage applications through the entire production lifecycle to ensure quality of service for large scale J2EE applications hosted on WebLogic Servers
• Install, configure, operate and manage highly available enterprise portals using WebLogic Portal, Oracle WebCenter Suite, and content management system; Rapidly build professional, collaborative portals with GroupSpace; Index and search information in the BEA Virtual Content Repository
• Creating workflows to represent a formal approval process for content checked into the content server; Managing content subscriptions; Using Archiver to export and import content; Managing multiple servers using the Configuration Migration Utility and Archiver Table Replication to synchronize system configurations; Setting up security and metadata models; Configuring general System Properties for contribution, such as automatic assignment of Content ID on check in; Enabling components that offer specialized functions or efficiencies; Contributing content using WebDAV and the Batch-loader administrative applet
• Plan, install, configure, setup and upgrade Microsoft sharepoint servers for team collaboration and project managements
• Install, configure, patch, integrate and test 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 using RMAN
• Set up and trouble shooting Oracle Streams, Data Guard and database links for data replications and integrations
• Install & configure CMDB enterprise management system, supporting very large software application development and deployment following ITIL processes for incident management, change management and problem management
• 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, cloning Oracle home and database using RMAN
• 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 like AWR and ASH
• 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 (8i & 9i to 10g/11g) 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 inOracle 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
• Installed and configured Oracle Business Intelligence Enterprise Edition(OBIEE) (including Oracle BI Server, BI Interactive Dashboards, BI Answers, BI Delivers, BI Disconnected Analytics, BI Publisher); Creating/Merging/Importing Objects from Metadata Repositories; Setting Up Multi-user Development Environment; Creating and Modeling Aggregate Tables, with OBI Administration Tool; Cloning and Synchronizing OBI Requests and Dashboards Using Content Accelerator Framework (CAF); Integrated OBI Publisher with OBIEE; creating Answers requests, dashboard pages, and using with OLAP; Creating Reports in Oracle E-Business Suite Using XML Publisher
• Used Informatica, Oracle Warehouse Builder (OWB) and Oracle Data Integrator (ODI) for ETL (extract, transform and load), dimensional modeling, data quality, data auditing, and full life cycle management of data and metadata;Consolidating heterogeneous data sources; Migrating legacy systems; Data modeling of relational and dimensional structures; Designing and managing metadata; Data cleansing; Data profiling and data quality auditing
• 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)

Sr. Architect / Oracle APPS Administrator

Confidential, VA

Responsibilities:

• 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 inOracle 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)

Chief Architect / Project Manager

Confidential, VA

Responsibilities:

• 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 .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)

Chief Architect / Project Lead

Confidential, Alexandria, VA

Responsibilities:

• 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
• 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

Chief Architect / Director

Confidential, Rockville, MD

Responsibilities:

• 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
• Technical architecture design and multi-tier internet computation architect implementation, client requirements and gap analyses, capacity planning and sizing management
• Install, configure, patch, integrate and test unix servers (SUN SPARC Solaris), Veritas software and EMC storage arrays
• 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, WebDB or Portal) on the Unix and NT platforms, configure network using http/sql*net(8), perform post-installation tasks, apply patches, migrate/upgrade various software tools
• Configuring applications database with parallel server (OPS)
• Partially or fully Cloning Oracle Applications environments
• Using AD utilities 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.x to 8i) and applications(11.x to 11i) using 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.
• 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, AP, AR, FA, BOM, INV, MRP, WIP, PO, EIN, EDI and ADI
• 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
• Install and configure Oracle Express Server, Discoverer and Financial Analyzer; Create and manage multidimensional databases, develop applications with Oracle Express Server, Discoverer and Financial Analyzer
• Web Applications development using Oracle9i Application Server and Portal, WebDB, Designer, Developer (Forms 4.5-6i, Reports 2.5-6i), Discoverer 4i, PL/SQL and PL/SQL Server Pages, HTML, JavaScript, Java servlets and JavaServer Pages. Install, configure and administer Oracle9i Application Server architecture and components; design HTML web applications using Java servlets and JavaServer Pages; build web applications with PL/SQL stored procedures and PL/SQL Server Pages; create PL/SQL web applications with Oracle Designer; use Oracle Portal and WebDB to build application components, such as dynamic web pages; integrate Oracle Portal with Applications to implement and customize system performance charts, and critical management reports
• Install, configure, administer, performance-tune and trouble-shoot Oracle Application Server 9i and components (HTTP Server, Web and Database Cache, Security) ; design and build application components (forms, reports, charts, calendars, dynamic pages, hierarchies, menus, frame drivers, links, list of values, and shared components) and content areas; publish portlets and build portal pages; use PL/SQL, Java Servlets, JSP, and XML in database and web providers; enhance portal with JavaScript, and PL/SQL; integrating oracle products (Developer, Discoverer, Designer and ERP products) into Oracle9iAS portal; administer security in Oracle portal architecting and implementing information system security, reliability, scalability, high availability and disaster recovery solutions using Oracle Parallel Server (OPS), 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
• 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

Technical Manager

Confidential

Responsibilities:

• 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)
• Using Informatica 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 database system; Update and refresh the data warehouse, and set up Oracle Enterprise Manager and Oracle Workflow to manage the warehouse operation architecting and implementing information system security, reliability, scalability, high availability and disaster recovery solutions using Oracle Parallel Server (OPS), 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