Data Warehouse Analyst
Resume:
650-***-**** Home
abihy9@r.postjobfree.com
Redwood City, CA 94065
Trevor Newman
Career Objective Seeking a team lead position in a dynamic data
warehousing environment.
Experience November 2008 - Present Lunexa, San Francisco
Senior Consultant
As a senior consultant I have provided Lunexa
clients with business intelligence and data
warehousing implementation and advisory services.
This has included
Data modeling
Design Development
ETL design and development (Powercenter 8.6/Talend)
Development of custom java code implemented within
objects
QA testing
Providing detailed test planning and production
support documentation
Providing production support assistance
July 2006 - Sept 2008 LifeMasters Self Supported
Healthcare, South San Francisco
Lead Data Warehouse Technologist
I was part of a team overseeing the support of
LifeMasters strategic Claims processing and
Reporting data warehouses. Ensuring that both
internal teams and external customers receive the
operational and clinical reports required to ensure
contract compliance. The infrastructure is SQL 2005
based and I am involved in the creation of an
improved reporting requirement using the SSIS,
SSAS, and SSRS components.
June 2005 - July 2006 Franklin Templeton, San
Mateo, CA
Data warehouse Analyst
I have applied my existing skills to the finance
sector. Supporting and enhancing a strategic data
mart and Oracle based enterprise data warehouse.
During this time I have had exposure to Informatica
Powercenter 7 and also Borlands' Together Designed
UML modeling tool.
1997- October 2004 LSI Logic, Milpitas, CA
Data Warehouse Analyst
Team lead for the data warehousing group that
supports custom data warehouse. Main
responsibilities include day-to-day oversight of
the integrity of the warehouse environment,
controlled implementation of modifications per
project requirement and schedules. I have a rare
combination of practical tool use and broad
knowledge of business data in a large enterprise.
Projects include:
Support for creation and rollout of a star schema
data warehouse for the corporate SAP ERP
Project oversight of the ETL tools (Powercenter
version 6.2) and DBMS (SQL Server 2000) upgrades
Support of end user access tools with access to the
warehouse (Brio 6/Hyperion)
Team member responsible for data modeling and
populating an archival data warehouse from a legacy
McCormack and Dodge accounting system.
1993-1997 National Semiconductor, Santa Clara, CA
Senior Analyst/Programmer
Promoted to Senior Analyst in a team supporting a
World-Wide Sales and Marketing system. Tasks
included taking on full responsibility with
requests from the systems users' ranging from
simple inquiries to major enhancements.
Held the position of Disaster Recovery Coordinator
covering all aspects from monitoring the systems of
record, creating recovery scripts and organization
and managing multiple disaster recovery tests at
off-site locations.
Also, a team leader of a standards council that
included members from business applications and the
production control group. Created and implemented
technical guidelines for use corporate wide.
Staff Analyst Programmer (1988 - 1993 Swindon, UK)
Initially worked in Munich, Germany as a member of
a team programming and analyzing a Worldwide
Quoting and Bid system supporting the Sales
organization, and later a Global Pricing system.
Gained exposure to CASE methodology tools and used
this experience to develop and maintain an on-line
Crediting/Invoicing system. Most of my work was of
the true analyst/programmer role. From the initial
request from a user to the final implementation of
a solution.
1986-1988 Linfood Cash & Carry, Northampton, UK
Application Programmer
Was a member of a small team that developed an
in-house marketing database which was used to mail
shot our branch stores with promotional incentives.
1985-1986 British Aerospace, Bristol, UK
Trainee Application Programmer
Hired as a trainee programmer as part of a team of
four, developing a Production Planning system.
Education 1983 George Ward Comprehensive School, UK
8 'O' levels and 1 'A' level
1985 Portsmouth University, England - HND Chemistry
with Computer Science
(Bachelor Degree equivalent)
Community Past President of Redwood Shores Lions Club
Involvement
Contact this candidate