SUMMARY:

• A certified Master IT Professional with extensive experience in all aspects of system analysis and design from initial requirements preparation to final implementation. Major strengths in using IE methodology and modeling tools to create functional databases and re - usable processes. Additional skills in big data analytic, database administration, system performance tuning and project management. A curious, reliable, well-organized, results-oriented, technically skilled team player who is innovative, capable to adapt and communicates effectively.
• Instituted industry best practices and standards for database administration, recovery, and information access security to attain customer satisfaction and CMM certification.
• Analyzed data and provided intelligence that led to better business decisions and new products.
• Introduced automatic process to monitor and rebuild fragmented SAP tables and indexes. Improved SAP application performance by 30% and reclaimed over 150 GB disk space.
• Created multi-master replication sites to provide failover protection, to improve database performance, and to reduce network load. Achieved 100% system availability to customers.
• Redesigned and successfully implemented a 8 TB data warehouse storing check info via data/process modeling, Oracle and reporting tools. Received achievement cash bonus.
• Led development of a global data warehouse storing project and financial data from SAP. Completed in 6 months using ABAP/4, Oracle, Web Server, and Cognos technology.
• Managed development of a world class brokering and electronic commerce system that doubled the company's revenue and profit for 2 years. Received huge cash bonus.
• Established enterprise wide data repository. Introduced data modeling standards, guidelines, and examples for other developers to follow.
• Re-engineered a corporate tax accounting system to consolidate all tax transactions from 13 different data sources in 7 months using RAD methodology, and CASE tools.
• Improved system service level by 70%. Led a cross-functional team to overhaul application, system software/hardware, and database using Virtualization and Capacity on Demand.

TECHNICAL COMPETENCY:

Industries: Automotive, Consumer Package Goods / Wholesale, Energy & Utilities, Financial Markets, Chemical & Petroleum, Small Medium Business

Project Domain: Financial Management Solutions, Customer Relationship Management Solutions, Managed Application Solutions, Systems Integration, Performance Improvement, Business Process Re-engineering, Application Development, Big Data & Analytic

Hardware: Oracle Exadata Database Machine X3-2; Confidential P590 eServer with Virtualization + Capacity on Demand option, RS/6000, Confidential Mainframes ES/9000 390, AS/400; SUN M5000, E10K; HP 9000 BL680c; DEC Alpha 8400, VAX 11/780; PCs

Operating Systems: AIX 7.1, VM/MVS, SUN Solaris 10/ 9/5.9, HP/UX 10.2/vue, Linux 2.6.18, Red Hat Linux 5.10, Tru64 Unix, VAX VMS, Windows Server 2012/2008, 7/10

Languages: PL/SQL Procedure / Package / Trigger, Transact-SQL, Pro*C, Java, C, Server API, shell script, Pascal, Cobol, Fortran, Assembly, Basic, REXX / EXEC2, JCL/JES3, Mark IV, RPG3

RDBMS: Oracle 7.X-12c, MS SQL Server 2016/2014/2012/2008/2005/2000 , MongoDB 3.4, DB2 9.0, Sybase 11.3 ISQL, Informix 7.3 4GL, Turbo Image/Query, IMS DB/DC/DL1, SQL/DS QMF/SQLEXEC/DBSU, S2K SCF/PLEX

Methodologies: Shlaer-Mellor, Learmonth-Burchett, FirstCase, Information Engineering (IE) Application Delivery Environment (ADE), Shell Structured Model Methodology (S2M2), Confidential Application Development (AD) / Cycle Model

Tools: Oracle Designer, Oracle Developer, Oracle RAC and Grid AdministrationOracle Enterprise Manager (OEM) 12c, Oracle9iAS/OAS, Oracle Multi-Master Replication / Data Guard / Standby DB / RMAN, Oracle Warehouse Builder with ETL, Oracle GoldenGate, Oracle Discoverer, Solarwinds Database Performance Analyzer, BMC Patrol 3.4, Toad 11, Desktop DBA, CA Erwin r9, Rackware, Cognos PowerPlay Impromptu, SAP ABAP/4 Workbench, BRTools, Tivoli, IA MyEureka, Confidential, Select SE, WebSphere Process Server (WPS), WebSphere Integration Developer (WID), KnowledgeWare Application Development Workbench (ADW), Intersolv Excelerator, TSO, CICS, eXcursion

Applications: PeopleSoft 9.2, Oracle Fusion Application R8, Oracle Financial Application 10.7SC-11.5.6 suite, Oracle Express / OFA, Oracle Hyperion Analytics 11.1, SAP R/3 release 4.6C, Maximo Asset Management 7.6, Microsoft Project, Microsoft Office, Microsoft Outlook, Lotus notes R9

WORK HISTORY:

Confidential

Senior IT Architect/Specialist 

Responsibilities:

• Developed marketing data warehouse storing Confidential consumer information.
• Administrate Oracle 11g RAC.
• Migrated databases and applications from data center to cloud platform.
• Tune PeopleSoft and SAP R/3 application.
• Manage over 730 databases in Oracle, DB2, and MS/SQL.
• Set up White Glove Big Data service.
• Lead a team of 15 US and global DBA resources.
• Perform change management, project coordination, capacity planning, database/server migration, architecture, consultation, and operational escalation.

Confidential, Houston, Texas

Supervisor, Database Administration

Responsibilities:

• Technical leader of the company’s database environment.
• Defined strategies, procedures, standards, and guidelines for global implementation and management of databases and data architecture.
• Managed and developed DBA resources within budget.

Confidential, Houston, Texas

Senior Data Technology Specialist

Responsibilities:

• Mentor of 6 DBA.
• Led all aspects of database activities from requirements gathering, data analysis, modeling, logical/physical design to construction, tuning, and maintenance.

Confidential, Houston, Texas

Director of Oracle Development / Senior Technical Specialist

Responsibilities:

• Managed a software development department.
• Made strategic and tactical IT decisions.
• Managed cross-functional team to accomplish company’s joint objectives.
• Designed 3-tiered enterprise applications, architecture, and databases.

Confidential, Sugar Land, Texas

Senior Analyst

Responsibilities:

• Created logical and physical database design for a Telephony / Cable Multiservice Operational Support System that would handle 2 million subscribers.

Confidential, Houston, Texas

System Analyst / Team Leader

Responsibilities:

• Large DBMS design, development, and tuning in Oracle, SQL/DS, DB2, IMS, S2K.
• Business / system process re - engineering by Confidential, Excelerator, KnowledgeWare.
• Created integrated business/scientific applications for different sectors and divisions.

Confidential, Short Hills, New Jersey

Member of Technical Staff

Responsibilities:

• Designed and developed system software written in C and Unix scripts to control PBX.