Summary




An innovative IT Solution DBA/Architect with an extensive experience in Information Technology consulting, Grid computing, Project and Portfolio Management. Highly successful in evaluating, selecting, implementing and upgrading technology and solutions for corporations in financial services, banking, software service, retail, manufacturing and distribution industries. Strong experience in design, development and implementation of applications and technologies in the RDBMS, PeopleSoft and Risk Management world. Successfully managed internal, external, on-site and off-shore consulting resources and ensured project success in the triple constraint.
Strategic logical/physical design and planning in all relational databases platform
Experienced in data conversion, replication and patch and disaster recovery Project/Portfolio management in a matrix organizations structure.
Application Software Product Development, data warehouse architecture, E-Business Suite and security auditing.
Highly effective liaison and diplomatic change agent who, without formal authority, won the trust of diverse stakeholders and forged partnerships across conflicting interests to assemble cross-functional teams that executed swiftly and reliably.
Strong technical manager who delivered major systems on time and in budget by negotiating cost-effective service level agreements with offshore development vendors and leveraging extensive experience leading and executing full project life cycles
Experienced in Hardware and Software Selection and Application Sizing across Multiple Platforms.
PeopleSoft Practice development and establishing off site/ Off Shore COEs Centre of Excellence.
Project and Portfolio Management, SDLC/PMLC methodologies, Best Practice and Change/Version Control...
Application Architecture Evaluation and Software Selection.
Solution Configuration, integration, migration, conversion and Implementation PeopleSoft, WorkBrain, Field Glass, Ensemble. CODA, BankWare etc.
Managed internal, external, on-site and off-shore consulting resources.


Employment

2009 -  Present

A leading global security company whose 120000 employees provide innovative systems, products and solutions in aerospace, electronics, information systems, shipbuilding and technical services to government and commercial customers worldwide.

Responsible for installing, designing, patching and migrating Oracle 10.2.0.3 to 10.2.0.4 in AIX, Windows, HP/UX, Linux and Sun environment with Data Guard and RMAN.
Applies comprehensive business processes, application design and functional knowledge in problem resolution.

Responsible for decisions impacting a team and may provide input into the decision making process for larger decisions. Proposes and defines solutions and standards which may impact a team or the organization.

Translate the logical data model into physical data model for optimum performance and for integrity of relational data. Work with project teams of programmers in fine tuning queries for optimal database performance.

Provides leadership and experience in investigation and resolution of performance related issues for warehousing and complex system environments. Creates and maintains database logical and physical designs.

Implements improvements to process and code used for automating maintenance and operational tasks in various systems, critical complex systems, warehousing systems and other OLTP systems, using PL/SQL, PERL, shell.
Leverage in-depth knowledge of database clustering technologies to design and administer clustered warehousing databases.
Collaborate with release teams to provide analysis, design, development, ETL process and testing guidance and support.
Responsible to develop Sybase Replication system disaster recovery, warmstandby and latency checking.

1999 -  2008
Vice President

1 of the main European financial services companies and maintains extensive activities in others parts of the world.

Led team responsible for development across multiple environments, related to fixes/patches, enhancements and upgrades to existing functionality, code changes to existing objects, interfaces and conversions necessitated by data fixes, functionality patches and upgrades ; and production support tasks related to the identification, tracking and resolution of issues found in the production environment.
Architected and Rationalized global HRMS HR, Payroll Interface, ESS, MSS, eProfile, eDevelopment, eRecruit, ePay, Talent Managements, Compensation and bolt-on modules and interfaces Application portfolio.
Developed business strategies to create new or enhance existing conversions and interface programs to meet the user requirements. These will include, technical analysis, technical design technical specifications, development, unit testing, unbundling of code, customizations and documenting code using PeopleSoft HCM 8.8, SP1 Tools 8.49 and Oracle 11G Platforms.
Responsible for installing, designing, patching and migrating Oracle 9i/10g/11g and Sybase ASE 15.0 Rep 12.6 for global critical application. Setup Backup and recovery process by using RMAN and Data Guard
Completed to support Sybase and Oracle data warehouse architecture in large terabyte environment
Monitored database by using Oracle Stats pack, AWR and ADDM reports
Responsible to build DR servers by using EMC SRDF, BCV, Oracle RAC, VERITAS Cluster Server and implement change control procedure.
Tune the configuration parameters for all Sybase/Oracle/MSSQL Server for better performance of relational databases by analyzing system resource utilization.
Maintain SQL security, SQL Agent job scheduling, planning, monitoring and creating user accounts for proper access ; and ; SQL/Server system tables ; SQL Profiler and Enterprise Manager ; and Server monitoring to ensure adequate CPU, disk space and memory on all SQL servers
Managed and completed the implementation of EMC/SAN/VERITAS migration between NY and NJ.
Creation and review of Technical Designs ; unit testing ; bundling/un-bundling of code using PeopleTools 8.49 and Oracle 11G Platforms.
Complete the project to convert UDB/DB2 to Oracle for LOANIQ application.
Complete 3 full lifecycle PeopleSoft HR and Benefits Administration implementation

Development of KPI's to build on existing balanced scorecard initiatives and become a Strategy-Focused Organization.
Designed and implemented to replicate data from Paris Oracle 7.1 to NY Sybase 12.5 for BDR project by using Sybase Direct Connect, Oracle Transparent Gateway and setup streams replication in 10g.
Completed the migration for Calypso application to Sybase 15 for Fix Income derivatives.
Built a firm-wide technology community and engaged over 300 people across business and technology areas to define standards, identify issues and present resolutions in the Desktop, Network, Server and Storage technology domains.

1997 -  1999
Senior DBA

A global investment bank serving the financial needs of corporations, institutions, governments and high-net-worth investors worldwide.

Responsible for a subset of the development, customization and integration work associated with the expansion of the current PeopleSoft baseline to include new modules and new functionality to existing modules.
Responsible for installing and designing Sybase Adaptive Enterprise server 11.5.1 and Oracle 9i for global critical application.
Responsible for evaluation and development of PeopleSoft, Business development and managing internal and external projects.
Design and create 2 way Sybase replication between London, NY and Tokyo for trading application.
Designed disaster recovery plan between WFC and NJ cites.
Responsible to setup database standards and guidelines to manage and maintain Oracle, MSSQL and Sybase relational databases
Implemented global replication data synching strategy by using Oracle and Sybase.

1996 -  1997
DBA and Project Leader

A Fortune Global 500 and Fortune 500 company whose subsidiaries provide insurance, investment management and other financial products and services.

Responsible to tune the configuration parameters in Oracle Server for better performance of relational databases by analyzing system resource utilization.
Responsible to do the project management for planning, design and implementation resource management to complete VLDB project.
Defined the backup and disaster recovery procedure for Oracle/MSSQL/Sybase server.
Implemented production master database shrunk and designed disaster recovery plan and server failover mechanism.
Led development of overall cross channel/product OnePru architecture focusing on the knowledge-based business applications and object/data modeling.

1995 -  1996
Senior UNIX SA and DBA

A global investment bank serving the financial needs of corporations, institutions, governments and high-net-worth investors worldwide.

Designed the performance monitoring by using STATSPACK, OEM, UTLBSTAT and UTLESTAT for oracle servers.
Development, test, migration and scalability reviews of the Oracle E-Business Suite
Manage and maintain solid backup, recovery, disaster recovery planning and implementation, shell programming, database migration and system changes.

Responsible for the migration and patch for Sybase, Oracle and MSSQL database to and from different organization environments production, dev, testing, etc and coordinate strategies to move data between databases.
Interfaced with London, HK and Tokyo to setup replicate sites, routes and define data server function classes and function strings.
Responsible to develop Replication system disaster recovery, warmstandby and latency checking.
Responsible for installing and designing Sybase Replication server 11 for global critical application.
Led the Technology Selection Process to identify eBusiness product components. Responsible for business requirement development, project management, vendor relationship management, issue resolution, technology due diligence and selecting final products.

Technical Addendum

Applications : PeopleSoft Enterprise HR, payroll and Benefits, PeopleSoft General Ledger, PeopleSoft Financials Expenses, PeopleSoft EnterpriseOne, E-Business Suite, Calypso, Loaniq, Opics, Opus, Summit

Databases : Sybase, Oracle, Informix, Sql and UDB/DB2

Hardware Platforms : Sun Fire server MP-690 MP-670 Sparc 5, Sparc 10, Sparc 20, Sparc 1000, Enterprise 3000, 4000, 4500, 6000, M5000, EMC Symmetrix 3600, 3700, 8530.
Ultra 1, Ultra 2, Ultra 5, AT and T 3B2 600 1000, RS6000, IBM 3090, IBM 36xx.

2000 -  2003

Education

Miscellaneous

Network Env : Windows 2000, NT, Netware 3.x,4.x, NFS, NFS+, TCP/IP, IPX/SPX, MS Terminal and Citrix
Web Servers/Tools : BEA/Tuxedo server 6.5, BEA/Jolt V1.1, BEA Weblogic, IBM Websphere, IE 5. x/6. x/7 .x, Netscape, Firefox, MS front Page, HTML, DMTML, XML and Notes R6
Languages : SQL, PL/SQL, Basic, MF-COBOL 5.x, Merant COBOL, C, C++, FORTRAN, Pascal, Assembly, RPG II, DL/1, IMS, TSO
Software : Sybase Replication server 15.0 12.5 Sybase Open Client DB-Library, CT-Library, Sybase Open Server, SQR, ISQL, Transact-SQL, Sybase Audit Server, APT, DWB
Oracle 8i, Oracle 9i, Oracle 10gR2 Oracle 11g, sqlplus, PL/SQL, Oracle RAC, Oracle RMAN, Dataguard, Streams, Enterprise Manager OEM, Sql 2000, Sql 2005, DB2 UDB, Informix 7.2
Unix Shell C, Korn and Bourne, Perl, Sunview, X11R4 X11R5 X-Windows, Motif/OSF, Open Look, Sun ODS, Sun Net Manager, December Athena Kerberos, Zephyr, Moira, Framemaker,, Lotus Notes, DBArtisan, Erwin, PowerDesigner, Informatica PowerMart, ESSbase, RDJ, MQ Series, Tibco, BMC SQL-BackTrack, BMC Patrol, Platinum Enterprise DBA, CA Autosys, Oracle Fusion Enterprise Application, Sybase IQ, Quest, TOAD, VERITAS Netbackup, HP Openview
People Tools : Application Designer, Application Engine, Component Interface, Business Interlinks, Application Messaging, Objects peopleCode, Process Scheduler, Upgrade assistant, Security Administrator, XML Messaging, Application Upgrader, Import Manager, Data Mover, PS Query, Work Flow Designer, Crystal Report, nVision, SQL/SQR
Version Control : STAT V4 .x from Quest and Schema Manager from Oracle
Disaster Recovery : VERITAS HA High Availability cluster, VERITAS Cluster Server VCS, EMC SAN/SRDF/BCV, Oracle, Real Application Clusters RAC Grid, Automatic Storage Management ASM, Cluster Ready Services CRS
Project Mgt. Tools : Visio, Project 2000 and Office 2000