SUMMARY:

• IT professional with broad and in - depth technical and management experience in Data Architecture, Database Administration, Data Warehousing, ETL, Big Data, Data Science and Business Intelligence.
• Technical expertise in architecture designing and implementation of enterprise level data solutions.
• Hands-on experience in data governance, data analysis, data transformation, data migration, data modeling, data profiling, and all aspects of data designing.
• Experienced with massively parallel data warehouse technologies such as HP Vertica, IBM Netezza and Oracle Exadata.
• Hands-on experience in designing and building scalable infrastructure and platforms to capture and process massive amounts of structured and unstructured data.
• Experienced with distributed data warehousing and/or data mining systems, using “Big Data” andNoSQL technologies (Hadoop, Hive, Pig, HBase, Cassandra, MongoDB, etc.).
• Excellent analytical skills with solid hands-on experience in Data Science technologies such as data mining, predictive analytics, statistical analysis, data visualization, presentation and reporting.
• Software development experience using multiple languages Java, Perl, PHP, Python…

TECHNICAL SKILLS:

Databases Technologies: Oracle 11g and Exadata, Oracle GoldenGate, MySQL, HP Vertica, MS SQL Server, DB2, IBM Netezza, Sybase, PostgreSQL, VoltDB, MemSQL

Big Data and NoSQL: MongoDB, Hadoop, HBase, Hive, Pig, and some other tools in Hadoop ecosystem

Data Modeling: Toad Data Modeler, CA Erwin Modeling, SAP PowerDesigner

ETL and BI: Microsoft BI Stack, Informatica and Pentaho, Data Stage, Oracle OBIEE, Hyperion, Business Objects, Oracle OLAP, IBM Sterling Integrator

Programming Languages: SQL, PL/SQL, T-SQL, Linux/Unix Shell-Scripting, Java, PHP, Perl/mod-Perl, C/C++, Python

Platforms: UNIX (SunOS/Solaris), Linux (Red Hat/SUSE), Windows Servers

PROFESSIONAL EXPERIENCE:

Technical Architect - Big Data Platform

Confidential, Phoenix, AZ

Responsibilities:

• Evaluate tools and technologies to continue to refine the platform and to drive the next generation of capabilities. Research engagements are including, but not limited to, advanced visualization and analytic reports, data discovery & deep dive analytics on Hadoop, in-memory database & analytical platform for Big Data, data ingestion & distributed message queues for Big Data…
• Evaluate tools and utilities that allow systems administrators and production support teams to effectively oversee & monitor the platform and its applications. Research engagements are including, but not limited to, monitoring/alerting technologies, security configuration, authentication, authorization & impersonation for Big Data & Eco System technologies, data masking/encryption, data compression…
• Partner with the Big Data Engineering/Data Science team to develop Big Data Integration Strategy. Conduct POCs and design peer reviews to democratize big data, leveraging self-service tools, APIs and common libraries of algorithms.
• Work with Business Partners and IT leaders to ensure process standardization for Big Data project engagement, change management, disaster recovery, and production support activities. Expand engagement model to support enterprise use cases to ensure allocation of platform resources and data to business units in an effective and compliant manner.

Data Architect

Confidential, Des Moines, IA

Responsibilities:

• Partner with business, application/UI development and systems analysts to design scalable, high quality enterprise data solutions for a large and complex distributed environment across multiple data platforms.
• Interface with Confidential senior management, business, internal & external stakeholders for project initiatives and business requirements; work alongside product management and Data Team (Data Modelers, Data Analysts, ETL Developers, Operational and Performance DBAs) to insure development of requirements/tasks meet the architecture design, and ultimately stakeholder satisfaction with project deliverables.
• Conducted data research to explore a variety of Big Data and NoSQL technologies such as Hadoop, Hive, Pig, HBase, Cassandra, MongoDB, and some other tools in Hadoop ecosystem, in support of Confidential massive structured and unstructured consumer lending data.
• Proposed and designed an integrated Big Data solution to in corporate Hadoop platform and Oracle NoSQL into current data environment - run alongside Oracle Exadata to process and store the high-volume, high-velocity consumer lending Audit and BPM workflow data.

Enterprise Data/BI Architect

Confidential, Tempe, AZ

Responsibilities:

• Defined strategic principles and visions for data within the corporation. Established and enforced policies and procedures including data governance, quality and standards across all core business and reporting platforms.
• Provided architecture design and oversaw the development effort for the new Enterprise Data Warehouse (EDW) and BI Reporting system.
• Worked with cross-functional teams to gather reporting and analytic requirements.
• Analyzed data sources and business rules to define source to target mappings; established context diagrams; documented data flows and data quality specifications.
• Established DW architecture schema design including conceptual, logical and physical models using star schema and dimensional models.
• Designed ETL processes and data movement flows; defined data integration and load strategies.
• Interacted with major Data Warehousing vendors such as Netezza and Oracle; conducted Proof of Concept with Netezza and Vertica.
• Established infrastructure architecture to define hardware, storage capacities, network, and security requirements/configurations.
• Deployed the new Data Warehouse and BI platform to UAT and Production; populated it with 15 years of historic data.
• Defined data governance policies on master and metadata management, database security, administration, maintenance and data backup/recover procedures.
• Identified troubled queries and performance bottleneck; optimized and tuned the overall system performance.
• Designed and delivered OLAP Cube Structures and complex queries to support dashboards, ad hoc and visualization reports.
• Successfully delivered Data Warehouse and BI Reporting system in less than 6 months.
• Negotiated 50% discount with Vertica licensing for the organization.
• Dramatically improved reporting performance, accuracy, availability and utility. Early end user feedback reported improvements from 2 days to retrieve 2 years of data, to less than 20 seconds to report 15 years of historical data.

Data warehousing and BI Consultant

Confidential, Scottsdale, AZ

Responsibilities:

• Provided data warehouse and BI solutions for an environmental service company with limited IT budget.
• Recommended using Pentaho open source technology to reduce the project costs by 75%. Provided project management, data architect, DBA business & systems analyst, ETL and report development support.

Director of Business Intelligence and Engineering

Confidential, Monrovia, CA

Responsibilities:

• Interfaced and liaised with executive/senior management and business owners, directed a team of 10 technical resources, successfully designed, implemented and deployed an Oracle Data Warehouse and BI Reporting system in less than 6 months.
• Planned and configured network, servers and data storage (SAN) hardware and software for High Availability Oracle RAC systems for Dev, QA and Production environments.
• Provided tactical solutions for ETL processing, integrated over 20 terabytes of corporation data from multiple ‘data islands’ into a single corporation data warehouse.
• Established the logical and physical database design with data modeling using star schema and dimensional models.
• Optimized performance of Oracle database and ETL (Informatica) processes.
• Configured and deployed BI reporting system with Oracle Application Server, Oracle BI solutions including Oracle OBIEE, Oracle OLAP and, Data Mining technologies.
• Provided and implemented data warehouse backup and recovery solutions.
• Responsible for hiring, mentoring and managing a distributed team. Define mid-to-long-term vision, budget and direction on technology platforms, insure deepening of competitive advantage, foster innovating and risk-taking environment.

Senior Database Developer

Confidential, Los Angeles, CA

Responsibilities:

• Led and completed the full lifecycle development effort for Confidential ’s massive e-commerce, point-of-sale, click stream data collecting and tracking system.
• Designed and deployed the implementation of a large-scaled automation of online merchandising and personalization systems across multiple channels, including web content targeting and optimization, email targeting and segmentation, search engine marketing and keywords bidding system.

Senior Software Developer

Confidential, Cambridge, MA

Responsibilities:

• Responsible for managing software development lifecycle; worked closely with scientists for initial requirements; designed prototype for proof of concept; researched new technologies for improving system capabilities; created algorithms and implementation for data processing; built sophisticated web-based application and automated testing scripts.
• Developed and deployed a Linux cluster parallel computation system for CPU- and time-intensive scientific data processing; integrated the Linux platform with our current Window-based system infrastructures.
• Designed and developed a back-end Oracle data warehouse system to manage large-volume of scientific data; identified multiple data sources; created software components to integrate gigabytes of heterogeneous information contained in a variety of formats into the relational model.

Web Developer

Confidential, Boston, MA

Responsibilities:

• Participated in developing a web-based al software to support collaborative on-line course system using Java, J2EE, JSP, Servlets, Apache, Tomcat, MySQL, and XML/ XSLT.