Professional Profile Technological Proficiencies

• Hardware: CISC/RISC processors proc. , Sun Sparc Enterprise M9000 32-CPU System , Cluster of Sun M-class M5000 8-proc. , Single Sun M8000 16-proc. SPARC64, IBM RS-6000 pSeries 650 and 670, HP 9000 PA-RISC Series 600 and 800, Dell Power Edge M600 Blade Servers, Intel Xeon Quad-Core, VMware ESXi 3.5 , Tyan FlexBlade 10 AMD Opteron Quad-Core , AMD Athlon and Opteron, Intel x86, x64, Pentium, Xeon, Ms Cluster Servers x86/x64 High Availability on Hardware, and on Virtual Machines with VMware , Oracle Real Application Clusters 10g, 11g, Development, QA, Integrated Testing, Production Migration/Administration , Linux HTCondor 4 Virtual nodes, experimental .
• Object Oriented Technology Introductory to medium level : EJB, JSP, Servlets, JMS, JNDI, Hibernate, Spring, Java/ J2EE/ Java EE 5-7 , CORBA, C , STL, C and VB ASP .NET, wx Erlang binding of wxWidgets .
• Middleware: IBM SOAP, WebSphere MQ Series , WebLogic, JBoss, Jabber XMPP and Vertebrae platform for Cloud Computing on Erlang , TIB/Rendezvous, Tivoli/ORB, JDBC, ORBit, ODBC, SNMP. RDBMS: Oracle 10g and 11g, introductory 12c, Ms SQL Server 6/7/2005/2008/2012, Introductory 2014 Community Technology Preview 1 CTP1 , MySQL 3.20 to 5.5 , PostgreSQL 6.1 to 9.1 , Ms Access 97 to 2012. Cloud Technology: Amazon ECC Elastic Computer Cloud / AWS Web Services, interfaces REST, SOAP and BitTorrent / S3 Simple Storage Services , NoSQL looser consistency models/key-value stores , Apache Hadoop 2, Cassandra 2.01, Hbase 0.94.4, MongoDB 2.4.6, Introductory JBoss Middleware and Oracle Fussion Midleware.
• Datrawarehousing and Business Intelligence Introductory to medium level : SSAS 2008,2012 SQL Server Analysis Services , SSIS 2008,2012 SQL Server Integration Services formerly DTS Data Transformation Services , Introductory OBIEE 11.1.7 ETL Extraction Transformation and Loading , Integrated DB data cleaning , Datawarehouse, Datamarts, Aggregation, Data Mining and Business Intelligence Basics , OLAP, Pivot Table, Star/ Snowflake Schemas, Fact and Dimension tables, SAS, R Language, Seabol Analytics basics , SAS 8 and 9 Statistical Analysis System , SAS Enterprise Guide.
• Business Rules Management System BRMS / Linear Programming/ Optimization/ Symbolic and Numerical Mathematics Solver s / Analyzer s / Computer algebra system/ Scientific Computing: Red Hat JBoss Enterprise Business Rules Management System BRMS / JBoss Drools, iLog BRMS/IBM Operational Decision Manager CPLEX ,OptimJ, GLPK, lp solve, Maxima/ wxMaxima/ Macsyma, GNU Octave, MATLAB matrix laboratory . Operating Systems: Linux Red Hat Enterprise/ Oracle / Scientific / Ubuntu/ Debian , OS-X, FreeBSD, Windows Server 2003/2008/2012, Windows XP/Vista/7/8, Unix System V, AIX 5.3, 6.1 and 7.1, HP-UX 9,10,11, Oracle Solaris 10, 11, Cygwin OS Extension . CASE /DATA MODELER/IDE/Test/Debug: Eclipse, MyEclipse Enterprise, Borland Together, CA Gen IEF , Erwin/Rx, CA ERwin Model Manager 4.1.4 and 7.3 formerly ERwin data modeler , IgniteXML entry level , DB-Artisan, Visio, TesGen4J, Java Test Runner, Ms Visual Studio 2008/2010, Embarcadero ER/Studio, ModelRight, DeZign for Databases, Oracle SQL Developer Data Modeler, GNU Development Tools.
• Development Methodologies/ Software Engineering/Test Driven Development/Rapid Application Development RAD / Regression Test Harness: Structured Design, Agile, Scrum, Extreme Programming, UML, Design Patterns, Incremental Software Development, Pair Programming, BSPM Enterprise-wide Business System Planning Methodology , DB-Regression-Test Harness author/proprietary design/Implementation . Transaction Server/Monitor: Microsoft MTS, Encina and Tuxedo. Languages: C, C , C , Java, Erlang, HTML/DHTML, XML, SQL DML and DDL , PL/SQL, Transact SQL, 4GL, SQLJ, ABAP/4, Perl, Python, VB .NET, VBA, COBOL, IDL interface description language introductory SOAP, CORBA, XML-RPC. Script Languages: JavaScript, Ajax, JQuery 1.8-2.0.0 , VBScript, bash, sed, awk, csh, ksh and tcsh. Libraries: STL, JFC, Boost, Struts, MFC, Persistence, Rogue Wave, glib and glibc. Concurrent Development/Configuration Mgmt.: HP SoftBench, Configuration and Developer Manager, Debugger, Class Editor, static and performance analyzer, RCS, Git, Make, CVS, Ant, GNU Make, Ms Visual Source Safe/2005, Ms Team Foundation Server Visual Studio 2010, introductory 2012 .
• Other Tools/Technologies Used/ Study Areas
• Oracle Applications, SAP R/3, ISO 15926 Data Standard all phases of process plant and production facility life cycle , Brio Intelligence/Reports/Portal, SQL Loader, Oracle forms and Reports, SQL Pro C/C /Cobol, Oracle Enterprise Manager, SQLDBA, DB Verify, Explain Plan, RMAN, DBEdit, Trace and TKPROF, Informatica DW Toolset , CWM, SAP Business Objects Universe Designer, Life Cycle Manager, Web Intelligence, Xcelsius -Dashboard design , Excel, Crystal Reports, Noetix Apache, IIS, Office development tools, Office object model, Solomon IV, Rational XDE, PurifyPlus memory leak fix , EMC Hot site backup, RAID, I2O, CISCO switches, routers, hubs, firewalls. TCP/IP, SONET, DSL, ISDN, Ethernet, Frame Relay, X.25, voice, video, data on private networks VPN, Computer to Telephone technologies. HIPAA Compliant Hosting Services/ Client Consulting, ERP, Oracle Financial, People Soft, OFBiz, ERP5, Artificial Intelligence/Expert Systems, Amazon ECC Elastic Computer Cloud / AWS Web Services, interfaces REST, SOAP and BitTorrent / S3 Simple Storage Services , Redis in-memory, key-value data store and optional durability , Infinispan data grid and cache interface , Oracle Coherence in-memory distributed data grid , Jabber XMPP and Vertebrae platform for Cloud Computing on Erlang , CouchDB and SimpleDB at the top of Erlang OTP platform ., Deadlock and concurrency/race condition prevention issues.

Job Overviews

• 17 Years as an Advanced Database Administrator/Programmer, in the following Databases: Oracle, Sybase, Microsoft SQL Server, MySQL, PostgreSQL, PL/SQL, Transact SQL, Informix 4GL/SQL DML and DDL , Dbase/Xbase. 14 Years as an Analyst, working with HIPO, DFD, ERwin, IEF, Composer, RUP, Together, Rational Software Modeler UML , Design Patterns and Visio. 11 Years as a Database Architect/ Technical Architect.
• 10 Years as a Project Manager working with Pert/CPM, Microsoft Project. 9 Years as a Unix/Linux System-Administrator with NIS, NFS, SAN, NAS, iSCSI, Fibre Channel, RAID mainly 0,1,5,6,1 0 . 5 Years as a Data Warehouse Designer/Administrator, Interfacing and report writing with ABAP, BAPIs, IDOC, SAPscript, supply chain, logistics, production, finance modules of SAP, Oracle Financial, ERP, OFBiz, ERP5.
• Day to day work as a DBA/Data Warehouse administrator about 50 of the time .
• Maintenance and monitoring of SQL Server installation versions 2005, 2008, and SQL Server 2012.
• Managing all activities related to the administration of SQL Instances, SQL Server Replication, SQL Server Integration Services, Log Shipping and Database user Admin.
• Installing and configuring SQL Server instances and databases.
• Providing operational support for instance database security, data inquiries, and traces.
• Providing technical support and guidance in the investigation, analysis, and resolution of issues related to SQL Server instances, databases, SQL Server Replication, data warehouse extraction transformation and loading ETL as well as Business Intelligence tools.
• Provides technical support and guidance in the investigation, analysis, and resolution of ETL processes and data synchronization issues.
• Aplied advanced knowledge of Microsoft SQL Server.
• Advanced knowledge of SQL Server Replication, Integration Services, log shipping, Operating Systems, ETL and Data warehouse processes
• Proficient in writing create/replace/insert/update/delete , testing, migration into production of Stored Procedures, Functions, Rules, Triggers, Maintenance Jobs, Packages by using best practices, standards, and code-optimization techniques.
• Proficient with altering databases/schema, including but not limited to creating/altering tables, constraints, indexes, grants, and sequences. Able to write DDL and DML via command line tools as well as GUI tools Query Analyzer, Enterprise Manager, and Management Studio .
• Proficient with change control. Ability to coordinate and implement database/schema changes to various environments Development, Test, Training, QA, and Production on OLTP Daily operation transactions and OLAP ETL for Datawarehouse/ Datamarts/ Cubes/ Business Intelligence .
• Professional experience with MS Cluster Services High Availability/Fail-over , database monitoring tools Big Brother, Hobbit, Xymon, Idera , loading legacy data from mainframe systems via SSIS DTS , BCP and scripting technologies such as Perl, Python, VBScript, JavaScript , Performance tuning PL/SQL, T-SQL Stored Procedures, SQL statements, using SQL Profiler, Query Analyzer, Management Studio fka Enterprise Manager to identify performance issues.
• Ability to assist other teams in regression testing, stress-testing applications, locating bottlenecks, and recommending solutions.
• Monitor database system details within the database.
• Efficiently Respond to and resolve database access and performance issues.
• Monitor, optimize and allocate physical data storage for database systems.
• Perform database transaction and login audits.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Establish appropriate end-user database access control levels.
• Maintain user access privileges for the security of databases.
• Develop routines to facilitate end-users best practices and database use.
• Efficiently Response to end-user requests for ad hoc reports, updates and data repairs.
• Work with Agency or Management/Users staff to develop test plans and ensure successful testing and validation of all developed solutions.
• Develop technical documentation that will be referenced for support of the delivered solution and subsequent enhancements.
• Strong understanding of database structures, theories, principles, and practices
• Working technical experience with designing, building, installing, configuring and supporting database servers.
• Hands-on database tuning and troubleshooting experience.
• Strong PL/SQL abilities.
• Proficient with RMAN.
• Proven analytical and problem-solving abilities.
• Ability to effectively prioritize and execute tasks in a high-pressure environment.
• Ability to conduct research into database issues, standards and products as required.
• Experience working in a team-oriented, collaborative environment.
• Working knowledge of VMware, Oracle VM VirtualBox, Red Hat Enterprise Linux Several Unix Operating Systems as System V/Solaris/Aix/HP-UX/OS-X/Linux and Apache Tomcat application server platforms, certificate management, LDAP and proxy services.
• Strong technical documentation skills.

Job Descriptions and Titles Held

• Senior Systems Data Architect, Senior DBA, Senior Developer, Oracle, Sybase and Microsoft SQL Server DBA, DB Applications Engineer, Linux, HP-UX, IBM-AIX, Sun Solaris and Windows Systems Administrator, Senior Systems Integrator, Systems Consultant, Scientific Computing Engineer. CTO Chief Technology Officer . Computer Center Principal, Assistant Professor in Computing and Engineering fields.

Other Projects

• Alligence, WireCraft, SAP R/3 BW/SEM/ABAP/4 Interfacing and custom reporting.
• South Western Bell, FRANCE-TELECOM, Telmex, GIRAFE System Integration for telecom channel inventory, sales support, remote management and testing.
• Graduate Center of Technological Institute of Oaxaca, full time Assistant professor for Numerical Analysis, Programming in C and Pascal Languages, Database Analysis and Design, Research and System developments Scientific Programming for: Hydraulic Pipe Network Design Water Utilities , Analysis and Design of Concrete Structures, Photogrammetry, Topography and Planimetry, Earth Movement on Highway Design, Statistical Analysis SAS development tools for a Malthus 7, population growth estimation State and Town levels in Chiapas and Oaxaca States , SSA State Health Secretary Oaxaca State, Epidemiology Control Statistics. ISSSTE Branch Oaxaca Regional Health Care Hospital administration and patient tracking, systems design and development. Review/Implementation of ERP System. SHCP Mexican IRS Regional CAF-Sur Computer Center Principal Federal Income Tax processing center, southern region of Mexico.

Work History

Confidential

Technical Architect/Database Design / Development Design, Programming, Testing Regression testing , Integration, Production Migration and advanced Data Base Administration of the Enterprise Resource Planning System and Data Warehouse.

• Uses: Linux RAC, HP 9000, IBM RS-6000, SunSparc E-10000 Windows Server, 2005, 2008, High Availability DB Cluster , Erwin/Rx, CA ERwin Model Manager 4.1.4 and 7.3 formerly ERwin data modeler , UML Modeling, Data Warehouse design, star model design for data marts, Integrated Database design, development and Implementation, agile RAD, systems integration with implementation of the ISO 15926 Industrial Data Standard all phases of process plant / production facility life cycle , with ERP Oracle Financial,People Soft, OFBiz with PostgreSQL DB, Informix IDS 11, MS SQL Server 2008/2012, SQL DML and DDL , PL/SQL, Transact SQL, 4GL Programming, Data Transformation Services DTS/ETL , Backup, Recovery, Oracle Recovery Manager hot backups with RMAN , Apache 2.0/2.2 , Monitoring, Auditing, Tuning, Data center implementation Crystal Reports BI/Reporting, JavaScript, Ajax, JQuery 1.8-2.0.0 ,Red Hat JBoss Enterprise Business Rules Management System BRMS / JBoss Drools, iLog BRMS/IBM Operational Decision Manager CPLEX , OptimJ, GLPK, lp solve, Amazon ECC Elastic Computer Cloud / AWS Amazon Web Services, interfaces REST, SOAP and BitTorrent / S3 Simple Storage Services , Apache Hadoop, NoSQL looser consistency models/key-value stores for big data and real-time web , MongoDB, Redis in-memory, key-value data store and optional durability , Infinispan data grid and cache interface , Oracle Coherence in-memory distributed data grid , JBoss Middleware, Oracle Fussion Midleware. Also on charge of the team of Database administration, replication, capacity planning, development of the Database Test Harness with meta-data implementation for regression testing new functionality vs. prior releases of complex heterogeneous data sources and transformations, coordinating VPN and network access setup and testing.
• Data Warehouse Development/ Implementation/ Business Intelligence: Crystal reports, Informatica DW Toolset , CWM, SAP Business Objects Universe Designer, Life Cycle Manager, Web Intelligence, Xcelsius -Dashboard design , Excel, Access, PowerPoint, Crystal Reports, Noetix, Python, Perl for Complex ETL extraction, transformation, optimization and loading - Oracle SQL and PL/SQL , DTS Data Transformation Services/ MsSql , Star Schema Design, Datawarehouse Modeling with Staging Integrated Database Data Loading, Clean-up, and consistency checking , Data Mart Design/ load/ growth planing and administration/ OLAP Cube Design/ load and refresh.
• Windows Server 2003,2005,2008, Ms Sql Server 2005,2008,2012. Red Hat Linux Enterprise 3,4,5 AS , Oracle 10g,11g, PostgreSQL, MySQL, Apache 2.0/2.2 , Erwin/Rx, CA ERwin Model Manager 4.1.4 and 7.3 , SQL DML and DDL , PL/SQL, Transact SQL, 4GL, Database Architecting, development, testing, High Availability, Cross development, .NET, Java, Perl, SQL, Backup, Recovery, Oracle Recovery Manager hot backups RMAN, Monitoring, Auditing, Tuning, Data center implementation, Hardware configuration, Clusters, Blade Servers, RAID 0,1,5,6,5 1 on SAN and NAS layout and implementation.

Confidential

Holiday Systems International

• Uses: Windows 2003 Enterprise Server, Ms SQL Server Enterprise 2000,2005 , SQL DML and DDL , Transact SQL, CA ERwin Model Manager 4.1.4 formerly ERwin data modeler , IIS 6.0 , C Visual Basic, .NET technology programming, interfacing with J2EE technology to major Airline ticket reservation systems. Projects: HIS-Business Engine, Taste of Paradise Web Site development, database and application migration s and management day to day database administration, automation, optimization of processes to reduce labor costs, improve facility utilization, increase availability-reliability, provide services to customers. Database development, Ms SQL, day to day advanced database administration in the production environment, backup, recovery, replication, security, updates/upgrades testing and migration to production, monitoring, performance tuning, space management and forecasting, hardware reconfiguration and upgrading.

Confidential

Senior Technical Architect/Applications Engineer

• Technical Architecture Design/Development/Test/Implementation/Migration to Production and Mangement.
• Uses: Linux, Red Hat, FreeBSD, OpenSUSE, Windows 2003 Enterprise Server, PostgreSQL, MySql, DBMirror, eRserver, Ms SQL Server Enterprise, Snap Shot Replication, Transactional replication, Merge replication, log shipping.
• Projects: Comstock, Trio, Transaction Point, Hot-Site and Warm site implementation for three major projects infrastructure support for over 7,500 Real Estate Web Sites. Real-time implementation and real time switching over for Disaster recovery, database migrations and management of complex heterogeneous data sources as well as data transformations day to day database administration, automation and optimization of processes, to reduce labor costs, improve facility utilization, increase availability-reliability, provide services to customers. Software development with Agile Methodology, Scrum, J2EE 1.4 Architecture, database development, Ms SQL, PostgreSQL, SQL DML and DDL ,Transact SQL. Systems integration, day to day advanced database administration of the production environment, backup, recovery, replication, updates/upgrades testing and implementation in production, monitoring, performance tuning, space management, forecasting, hardware reconfiguration and upgrading. Staff management.

Confidential

SEI Information Technology

• Linux Cluster Windows NT 4.0 Enterprise Edition/2000 Advanced Server AlwaysOn database Failover Cluster , IBM WebSphere/ J2EE 1.3 MQ Series , CA ERwin Model Manager 4.1.4 formerly ERwin data modeler ,Rational rose modeler UML , Data Warehouse Integration, design with a Common Warehouse Metamodel, star model design for data marts, Integrated database design, development with Agile Methodology Scrum , with implementation of the ISO Industrial Data Standard, systems integration with ERP oracle applications 11i , MySql, Ms SQL Server 7/2000, SQL DML and DDL , PL/SQL, Transact SQL, and Developer 2000 Programming, Data Transformation Services DTS/ETL , Brio Intelligence/Reporting, database administration, replication, capacity planning, Designer and developer of a Database Test Harness with metadata implementation, a query engine for regression testing of systems with complex heterogeneous data sources, coordinating VPN and network access setup and testing.

Confidential

• Unix - Windows NT 4.0/2000 Oracle and MS Sql Server Data Warehouse Architecting, Anthology co-design, Development, Testing and Implementation ETL Star Scheme , T-SQL DML and DDL , PL/SQL, Transact SQL, Data Transformation Services, Data Load of complex heterogeneous data sources and transformations, Business Objects, Configuration Management, System Tracking, J2EE, Perl and Python Programming, Internet logs parsing, GuideStats Internet Statistics system administration and configuration, coordinating VPN and network access setup and testing. Unix web server cluster administration, day to day operation web logs transportation, data parsing and loading into the datamarts/anthology , 3 to 4 gb per day of data, cleaned, organized - processed to cube destinations .

Confidential

• Digital customer experience management, customer behavior analysis solutions with a short implementation of the ISO Industrial Data Standard, Database and Data warehouse Architecting/Design, development, testing, migration to production, day to day operation and management system to help companies comprehend how and why a customer's website interacts with clients and use this insight information loaded to the data warehouse to optimize the customer's digital experience, across the marketing, sales, and service channels, leading to improved business results, customer satisfaction customer service productivity, and profitability.
• Oracle 8i/Ms SQL Server, Database Architecting, Data Base Administration, Capacity Planning and Data Base Configuration. January 2000-April 2000, Senior Technical Architect/ DBA/ System Integrator