SUMMARY:

• An innovative IT Data Architect with an extensive background in Information Technology consulting, Grid computing and Cloud technology, 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, SAP, CRM, ORMB, Big Data, Data Science and Risk Management world. Successfully managed internal, external, on - site and off-shore consulting resources and ensured project success within the triple constraint.

TECHNICAL SKILLS:

Applications: PeopleSoft Enterprise (HR, payroll & Benefits), PeopleSoft General Ledger, PeopleSoft Financials Expenses, PeopleSoft EnterpriseOne, Oracle E-Business Suite, Calypso, Loaniq, Opics, Opus, Summit, Oracle Discover, Oracle Fusion, Oracle BI tool OBIEE, Oracle Data Integrator (ODI), Oracle SOA, Oracle Fusion, SAP Business Suite, SAP NetWeaver

Databases: Sybase, Oracle, Informix, MS SQL, Mysql, Mongodb 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, AIX p6, p7

Network Env: Windows (2000, NT), Netware (3.x, 4.x), NFS, NFS+, TCP/IP, IPX/SPX, MS Terminal and Citrix

Web Servers/Tools: Weblogic 11g, BEA/Tuxedo server 6.5, BEA/Jolt V1.1, 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, Python, Jira, R

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, Oracle 12c, sqlplus, PL/SQL, Oracle Real Application Testing(RAT), Oracle RAC, Oracle RMAN, Dataguard, Streams, Enterprise Manager(OEM), MS SQL 2000, MS SQL 2005, MS SQL 2008, 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 PowerCenter, 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, Oracle Designer 2000, Oracle SQL Developer, Eclipse, Netbean, SVN, Clearcase, BDW, AWS, Talend, MicroStrategy, Ab initio, AWS( Amazon Web Services)

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), Weblogic Cluster

Project Mgt. Tools: Visio, MS Project 2007 and MS Office 2007

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Senior Data Architect

Responsibilities:

• Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems
• Maintain enterprise data mappings consistent with internal policies and standards
• Deploy production models, design and implement improvements in analytical systems, frameworks, and capabilities.
• Lead data architecture design and review processes, including planning and monitoring efforts, reviewing deliverables and communicating to management
• Design data quality for Big Data/Data Science Project, setup Hadoop environments, Nosql/Mongodb, Spark/MLlib/R and Amazon Web Services/EC2 design
• Developing and delivering logical and physical data models, including the creation and maintenance of ERD diagrams and other documentation for large complex operational systems employing deep system integration.
• Design the Information Architecture for complex Enterprise Transactional Data stores and Data warehouses
• Develop data models to meet the needs of the organizations information systems.
• Manages the flow of information between departments through the use of relational databases
• Create Conceptual Data Model, Data Flows, Data Management specifications
• Develops strategies for data acquisitions, distribution, archive, recovery, and implementation of a database.
• Provide Leadership to the business and technology teams in identifying the data flow associated with a business flow and guides data provisioning and data capture process optimization
• Contribute to the overall system design, Data Vault Modeling and operational design
• Work with the application development groups to design ER data models and Dimensional data models by using ER Studio /Erwin and IBM Banking and Data Warehouse (BDW).
• Re-design and implementation of the database infrastructure, including Failover, Disaster Recovery, Performance Monitoring, Capacity Planning, and Automation of database related processes.
• Develop, support and approval for RDBMS objects and code for data profiling, extraction, load and updates by using udeploy
• Responsible for convert Oracle Financial Services Revenue Management and Billing (ORMB) to 11g platform
• Responsible to do performance tuning by using OEM AWR/ADDM/ASH, tuning RAC/ASM and optimization for relational and dimensional models
• Design and test Oracle cloud software as a service (SaaS), platform as a service (PaaS), infrastructure as a service (IaaS), Oracle Golden Gate Cloud Service and migrate database to cloud
• Design and implement data verification and validation by PL/SQL and GoldenGate veridata
• Providing and maintaining technical documentation, specifically Data Mapping and Low Level / ETL (or ELT) Design Documentation
• Design and implement GoldenGate forward and backward and Shareplex Database replication.
• Convert 10g Data Warehouse to 11g by using Oracle Real Application Testing(RAT) to do capture/replay and perform table partitioning maintenance for large databases (60TB).
• Responsible to communicate with CATE (Citi Architecture & Technology Engineering ) for certification of the platform
• Experiences of engineering practices such as code refactoring, design patterns, design-driven development, continuous integration, building highly scalable applications, application security.
• Applies comprehensive business processes, application design and functional knowledge in problem resolution.

Senior Data Architect

Responsibilities:

• Lead data architecture design and review processes, including planning and monitoring efforts, reviewing deliverables and communicating to management
• Defining relationships and touch points between data subject areas
• Setup Hadoop environments and deploy Nosql/Mongodb
• Built 6 nodes Oracle RAC and impletement 10g to 11gR2 migration and troubleshooting.
• Provided advice in Table Partitioning in alignment with logical/physical modeling (Ralph Kimball) for OLAP / OLTP, data replication by using Golden Gate, DataGuard, Informatica ETL and Advanced queuing.
• Re-design Financial Statement Data Model by using Erwin to do forward/reverse database engineering and optimization for star and snowflake schema.
• Configured and installed SDL Tridion Content Manager to make online marketing easier through tools tailored to manage brands, localization and translation, cross-channel engagement, targeted audience interaction and multi-channel campaigns.
• Develop and implement strategies for data federation, replication, virtualization, data archival and recovery (for both primary and remote sites)
• Design and builds database structure and objects that best support operational and analytics application to assess, analyze and debug the data requirements for applications and problems, translate data requirements into database structures for optimal performance and availability.
• Lead/participate in database projects and work with partners to bring projects to successful and timely completion.
• Plan, design, enhance, and maintain decision support database solutions using Oracle OBIEE, Oracle EE RAC 11gR2, Netezza and MetaMatrix Technologies.
• Drive data standardization, data integrity and quality, utilize MS SSIS/SSAS, identify to promote Data Warehouse best practices and patterns for data models.
• Leverage in-depth knowledge of database clustering technologies to design and administer several clustered warehousing databases by using Oracle Weblogic 11g.
• Plan, install, configure, migrate and support Sybase ASE 15 Servers and Replication Server.
• Performed batch load from MS SQL 2008 to Oracle database by using Oracle Data Integrator for SAP BW and ECC.
• Perform database management tasks including database infrastructure design, automation of data loads, performance tuning, SQL programming, space management, backup/recovery(RMAN), and version control.

Senior Data Architect

Responsibilities:

• Monitor and optimize database performance as it relates to partitioning strategies, index tuning, ETL, and query optimization on a Data Warehousing environment.
• Built 4 nodes Oracle RAC, install ASM, CRS and grid control
• 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.
• Created Sybase replication definition and subscription, and configured replication server. Trouble shooting server errors.
• 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 expertise 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 including 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 several clustered warehousing databases.
• Collaborate with release teams to provide analysis, design, development, ETL process( MS SSIS/SSAS) and testing guidance and support.
• Evaluated Oracle features and product to complete the Proof of Concept for new platform.

Senior DBA/Architect

Responsibilities:

• Led team responsible for development across multiple environments, related to fixes/patches, enhancements and upgrades to existing functionality including code changes and code review 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 to build DR servers by using EMC SRDF, BCV, Oracle RAC/ASM/CRS, VERITAS Cluster Server and implement change control procedure.
• 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
• 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. Also utilize MS SSIS/SSAS for ETL processing.
• 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 three full lifecycle PeopleSoft HR and Benefits Administration implementation
• Evaluate Oracle features and products and establish policies and procedures.
• 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 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.

Senior DBA

Responsibilities:

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