OBJECTIVE:

• A challenging position in Data Warehouse architecture and design, ETL solution architecture and design with opportunities for an aggressive, dedicated individual with leadership abilities, strong analytical and problem solving skills.
• Proven knowledge and experience of enterprise architecture and effective design and implementation of business solutions in line with industry trends.
• Ability to engineer and implement new processes and methodologies and enhance and expand existing solutions.
• Architect and design ETL and ELT solutions and frameworks.
• Data Warehouse architecture, multi - dimensional data model and OLAP cube design and development on MPP Appliance and other conventional platforms.
• OLTP, OLAP and Warehouse database architecture, design and logical and physical data modeling skills.

TECHNICAL SKILLS

Development Tools: Postgres, Netezza SQL, PL/SQL, T-SQL, MDX and DMX, Microsoft BI Stack including Sharepoint and PerformancePoint Services, Oracle PL/SQL, Forms & Reports and Discoverer, Informatica

Databases: Greenplum 4.x,Netezza Twin-Fin/1000, Microsoft SQL Server, SSAS & OLAP, Oracle 7.x and 8i and 9i and exposure to 10g

Applications: SQL Server Business Intelligence Development, Management Studio and Tools, Microsoft Visual Studio, TFS and Visual Source Safe, Visio and Project, CA Erwin Data Modeler and Profiler, Aginity Confidential Workbench, BusinessObjects 6.5, XI and XI R2, Server, User and Content Administration, WebIntelligence & Desktop Intelligence, InfoView, CMC, CCM, CMS, Universe Designer

PROFESSIONAL EXPERIENCE:

Confidential

Greenplum Consulting

Responsibilities:

• Subject Matter Export on Oracle to Greenplum ETL implementation for a Federal Government Project (Will discuss in person).
• Providing consulting services on a NeoView to Greenplum DCA migration to Pivotal's client.

Confidential

Consulting

Responsibilities:

• Providing consulting services on Confidential 1000 enhancements to IBM's client.

Confidential

Greenplum Architect

Responsibilities:

• Presented different implementations of GP DCA capacities and abilities to clients and which would fit best to their short term and long term needs and upgrade and migration paths.
• Provided guidance on stacking up Greenplum DCA against competitors on Cost/Performance comparisons.
• Design and architecture of DW and ETL/ELT projects for EMC clients.
• Implementation of new Greenplum DCA or upgrade and migration of previous/existing for EMC clients.
• Design and architecture of full ETL/ELT Eco-systems for EMC clients.
• Provided direction and best-practices on implementation of Greenplum DCA to clients.
• Assisted DBAs and Data Architects on establishing multi-tenancy databases and how to address entitlements to database users.
• Participated and provided guidance on implementation of database security.

Confidential, San Francisco, CA

Data Warehouse Architecture Enhancement

Responsibilities:

• Reviewed and improved data loading and ETL approach to comply with MPP architecture and Confidential best practices.
• Discussed and provided guidance on implementation of a custom process auditing and metrics framework on Confidential platform and presented scenarios on its benefits in administration efforts.
• Designed and implemented of process auditing, logging and metrics for existing and new ETL processes.
• Code review and auditing and improving performance and run-time of existing processes where applicable.

Confidential, Irvine, CA

Data Warehouse, ETL Architect

Responsibilities:

• Designed and architected an Enterprise Data Warehouse on Confidential platform to support corporate analytics and reporting needs.
• Designed and architected a Data Warehouse of Automotive Sales, inventories and listings to complement and enhance KBB's Vehicle Valuations and forecasting on Confidential platform.
• Defined and established a set of Data Governance guidelines to ensure and secure data quality, data improvement and enhancement methodology, and accountability of data sources for providing data (both internal and external).
• Designed and implemented and data quality profiling process and feedback of defects to users for improvement.
• Established guidelines and policies for data retention, archival and retrieval for every stage of data processing such as ODS, Stage and DW, and data storage.
• Migrated SSIS ETL processes to a Confidential ELT framework to utilize processing power and scale data loads to Confidential databases.
• Developed ETL framework in SSIS 2008 to import data from various sources into ODS, transform and apply business rules, consolidate and dimensionalize, and populate VIMS Warehouse to be consumed by end-users in 2008 OLAP cubes.

Confidential, Long Beach, CA

BI/DW Architect

Responsibilities:

• Designed and implemented corporate dashboards of KPIs and Scorecards for internal and external usage.
• Designed a multi-dimensional Data Warehouse for Inbound and Outbound claims processing system with Membership, Enrollment, Claims and Eligibility subject areas.
• Designed an SSIS/SSRS reporting framework to create snapshot report files and maintain historical versions of reports via Web Service call.

Confidential

Senior DBA/BI Developer/Analyst

Responsibilities:

• Business Objects Universe design, development and administration.
• Performance tuning BusinessObjects environment and responsible for maintaining BusinessObjects Repositories.
• Migration of BusinessObjects 6.5 implementation to XI R2.
• Design and implementation of BO XI R2 universes for CMS and ER subject areas.
• SQL Server administration of development and production database servers.
• Designed and implemented a database security model with all documentations and procedures.

Confidential

Senior DBA/BO Admin/Developer

Responsibilities:

• Enhanced existing applications and developed new modules to replace older programs using Visual FoxPro 8.0 and Visual Basic in a Client/Server environment.
• Performed SQL Server 7.0 and 2000 database administration on development and production database servers.
• Performed risk analysis and prepared execution plans for upcoming SQL Server 2005 upgrade projects.
• Reviewed and analyzed all SQL Server objects prior to deployment to ensure compliance with corporate standards and guidelines.
• Business Objects 6.x Administration: Monitoring BusinessObjects environment and responsible for maintaining BusinessObjects Repository.

Confidential, Garden Grove, CA

Senior Developer

Responsibilities:

• Designed and developed data access class libraries using Visual FoxPro 7.0 & 8.0 for data access to Informix database to be used in newly developed Visual FoxPro applications.
• Developed data access methods and foundation classes in Visual FoxPro and Visual Basic to provide communication and XML data transfer with Intuit QuickBooks and other contact management applications.

Confidential, Foothill Ranch, CA

Senior Developer

Responsibilities:

• Developed ETL processes to enable smooth transition and migration of the Legacy System data to Oracle databases.
• Created DTS packages to collect, manipulate and consolidate data from various sources.
• Designed and implemented report programs in Crystal Reports using stored views and procedures in SQL Server and Oracle databases.