SUMMARY:

• I am a highly experienced senior IT professional with extensive credentials including the following:
• Database architect offering over 10 years’ experience and in - depth knowledge of functional and data needs in numerous industries. A strong understanding of relational data structures, theories, principles, and practices. Expert knowledge of formal and informal data modeling in major application areas across industries including manufacturing, telecommunications, the travel industry and retail.
• Over 10 years dedicated data modeling (entity relationship diagrams, logical models, physical models, normalization, de-normalization; small to medium sized databases in OLTP; VLDB, BI systems and OLAP): mobile contents provisioning; online advertisement and click management; security and handheld computing; telecommunications and billing; semiconductor manufacturing; and the travel industry
• Software development with extensive skills in programming, architecture, analysis, and the Software Development Life Cycle (SDLC). Expertise in high-level and detailed system design, requirement gathering, logical and physical data modeling, enterprise database management, development, stored procedures, business rules and implementation.
• Extensive knowledge of RDBMS: ORACLE, PostgreSQL, MySQL, MS SQL Server, HSQL, Sybase, PowerDesigner, and ERWIN. Extensive experience in the UNIX, LINUX, and Windows operating systems as well as version control systems including Start Team, Subversion and CVS.
• Proven ability to assemble and mobilize project teams, building consensus among multidisciplinary technical and functional teams in the rapid development and implementation of database solutions. Recognized by managers and colleagues as a positive leader and a sharp strategic thinker, mentor and problem solver.
• Designed and implemented a migration scheme that reduced downtime from 5 days to 36 hours saving the company over $80 million.
• Architected and built tools that revolutionized content comparison and increased the hit rate of client sites by over 20% in a search engine optimization environment.
• A track record for timely project delivery -- implemented a Customer Support system that exceeded expectations and was completed under budget and in less than half the time that the previous attempt took to conclude in failure.
• An acclaimed publisher and a proud recipient of a publisher of the year from the British Computer Society.
• A highly educated motivator with an aptitude for assessing corporate needs and delivering systems that meet goals and remain within budgetary guidelines.

TECHNICAL SKILLS:

Programming Languages: C, Shell, SQL, Java, Perl, REXX, C++, 4GL, PROLOG, LISP

Programming Environments: Eclipse, JBuilder

Database Development: Oracle, PostgreSQL, SQL Server, MySQL, DB2, Informix, Sybase, JDBC, HSQL

Data Warehouse Development: Retail IDEAS, DB2, Talend (ETL)

Data Modeling: DataArchitect, PowerDesigner, ERWIN

Operating Systems: UNIX, Linux, HPUX, Windows, DOSInternet Development: Apache, HTML, XML, Java, MS Visual Basic

PROFESSIONAL EXPERIENCE:

PRINCIPAL DBA / DATA ARCHITECT

Confidential

Responsibilities:

• A provider of IT consulting: Database Development, DBA, System Integration and Web-based applications.
• I designed and implemented business support systems for various clients including the following:

Confidential, Scottsdale AZ

Data Architect

Responsibilities:

• Data Warehouse Implementation and Reporting - ETL, Data Quality and Reports
• Maintenance of Data environments, performance tuning - OLTP loads and OLAP

Technologies: PotgreSQL, MySQL, Talend, LINUX, WINDOWS, Subversion. JIRA, JAVA, Eclipse with plugins

Confidential, Scottsdale AZ

Business Intelligence Architect

Responsibilities:

• Data Warehouse Design and Implementation from scratch - OLAP cubes, dimensions and facts
• Data Analysis for all operational sources, and Mapping onto the data warehouse
• ETL development and Data Quality Control
• Maintenance of the BI environment (using JIRA), performance in all operational databases with high OLTP loads

Technologies: MySQL, Talend, PowerDesigner, LINUX, WINDOWS, Subversion. JIRA, JAVA, Eclipse with plugins

Confidential, Lake Oswego, OR

Data Integration/Migration specialist

Responsibilities:

• Data Analysis and Mapping onto the new Data model
• ETL development and Data Quality Control
• Integration with Java based components for maximum parallelism
• Source extraction Performance tuning and Reporting performance

Technologies: PostgreSQL, Talend, SQL, JAVA, LINUX, WINDOWS, Subversion

Confidential, Seattle, WA

Senior member

Responsibilities:

• Data Analysis of the Legacy implementation, Mapping onto the new Data model
• Evaluation of deployment options, ETL development and implementation

Technologies: MySQL, Talend, SQL, JAVA, LINUX, WINDOWS, RALLY, Subversion. JIRA, Eclipse with plugins

Confidential

Data Architect and lead DBA

Responsibilities:

• Led the evaluation and comparison of the in-house Vs current retail warehouse solutions
• Reengineering and enhancements of existing warehouse and ETL implementations

Technologies: SQL, DB2, ORACLE, Retail IDEAS, Talend, WINDOWS

Confidential, Scottsdale AZ

Responsibilities:

• Led DBAs in production systems and performance tuning - 250+ databases/warehouses.
• Architected and implemented a language-mediated system:
• Gathering of ranked search keywords with statistical details
• Keyword Categorization by industry and themes/meanings
• Text analysis - contextual meanings, theme matrixes, morphological analysis, relevance and confidence.
• Modeled enterprise data systems and implemented data sharing strategies among client warehouses
• Mentored with hands-on production DBAs and developers
• Documented, designed and enhanced numerous databases, data models, and ETL tools.
• Implemented data architecture, data modeling standards and the Information Delivery Strategy for the company

Technologies: SQL, Perl, JAVA; PostgreSQL, MS SQL, MySQL, PowerDesigner, CVS; LINUX, WINDOWS, Eclipse

Confidential, Scottsdale, AZ

DATA ARCHITECT & DBA

Responsibilities:

• DBA of all production databases (ORACLE, MS SQL Server, DB2, Hyper SQL, Pointbase Micro)
• Participated in the design and implementation of servers and supporting technologies on handheld devices.
• Designed, developed and implemented an SQL based database engine on handheld devices (in JAVA)
• Implemented data-sharing and replication schemed for the enterprises as well as the wireless handheld devices.
• Created all the logical data models from data requirements to reflect the business requirements.
• Implemented a data migration strategy across various database engines using native SQL loaders
• Designed the overall database instances as well as capacity planning and memory allocation
• Designed and built the database subsystem and components of a work-flow system (healthcare monitoring).
• Managed the project life cycle: analysis, change requests, bug tracking, data mapping, and production support.

Technologies: C, JAVA; ORACLE, SQL, HSQL, MySQL, DataArchitect, StarTeam; LINUX, WINDOWS, Eclipse