Summary

An innovative IT Solution DBA/Architect with an extensive background in Information Technology consulting, Grid computing, Project Portfolio Management. Highly successful in evaluating, selecting, implementing and upgrading technology and solutions for corporations in financial services, banking, software service, retail, manufacturing 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 within the triple constraint.

Areas of Expertise

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

Experiences

Confidential

Vice President

• Responsible for development across multiple environments, related to fixes/patches, enhancements and upgrades to existing functionality including code changes to existing objects, interfaces and conversions necessitated by data fixes, functionality patches, and upgrades as well as production support tasks related to the identification, tracking and resolution of issues found in the production environment.
• Responsible for creating new or enhancing existing conversions and interface programs to meet the 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 10G Platforms.
• 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.
• Complete three full lifecycle PeopleSoft HR and Benefits Administration implementation
• Creation and review of Technical Designs unit testing bundling/un-bundling of code using PeopleTools 8.49 and Oracle 10G Platforms.
• Complete the project to convert UDB/DB2 to Oracle for LOANIQ application.
• Completed to manage DST Day Light Saving for 3/11 project for all RDBMS platform.
• Development of KPI's to build on existing balanced scorecard initiatives and become a Strategy-Focused Organization.
• Completed the migration for Calypso application to Sybase 15 for Fix Income derivatives.
• Built a firm-wide technology community and efficiently 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.
• Responsible for installing, designing, patching and migrating Sybase ASE 15.0, Rep 12.6 and Oracle 9i/10g/11g for global critical application.
• Tune the configuration parameters for all Sybase/Oracle/MSSQL Server for better performance of relational databases by analyzing system resource utilization.
• Responsible to build DR servers by using EMC SRDF, BCV, Oracle RAC, VERITAS Cluster Server and implement change control procedure.
• 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.
• Managed and completed the implementation of EMC/SAN/VERITAS migration between NY and NJ.
• Designed and implemented to replicate data from Paris Oracle 7.1 to NY Sybase 12.5 for BDR project by using Sybase Direct Connect and Oracle Transparent Gateway
• Collaborate with release teams to provide analysis, design, development and testing guidance and support.

Confidential

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/or 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 two 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.

Confidential

Senior System Architecture

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

Confidential

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 and scalability reviews of the Oracle Database at the enterprise level.
• 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.
• Create and update database policy and procedures documentation.
• 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, selecting final products.

Technical Addendum

Applications: PeopleSoft Enterprise HR, payroll Benefits , PeopleSoft General Ledger, PeopleSoft Financials Expenses, PeopleSoft EnterpriseOne, Calypso, Loaniq, Opics, Opus, Summit

Databases: Sybase, Oracle, Informix, MS SQL and UDB/DB2

Hardware Platforms: Sun Fire v280, v880, v1280 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 T 3B2 600, 1000 , RS6000, IBM 3090, IBM 36xx.

Operating Systems: Linux, SunOS 4.1, 4.1.1, 4.1.2, 4.1.3 and Solaris 2.3/2.4/2.5/2.6/2.7/2.8/2.10, Windows 9x, XP, 2000, 2003, NT , Citrix, SCO, Digital UNIX V4.x, IBM AIX V4.x/V5.x, HP UNIX 10.10, MS-DOS 6.2, Novell NDS, Netware 4.x

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 , MS SQL 2000, MS 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, Dec 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

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, MS Project 2000 and MS Office 2000