Experienced IT architect committed to maintaining cutting edge technical skills and up-to-date industry knowledge.
Hadoop, Teradata, Oracle, SQL Server
Data Warehouse Architecture
Business Analysis, Requirements Gathering
ERWIN, Cognos, Visio
Data Warehouse Analyst, 06/2007
to 11/2008 MTD Products – Valley City,
worked on the development and delivery of reports and dashboards
within Cognos business intelligence software suite, including
creation of the dimensional data models using Cognos Framework
and developed ETL solutions using IBM DataStage tool and
standardized and cleansed data using IBM QualityStage tool in Oracle
with various business units to define reporting and analytical
requirements and translated them into technical specifications
Sr. Consultant, Application Development, 11/2008
to 05/2013 CVS Caremark / Universal American – Solon,
for implementation and administration of the Cognos software suite,
along with the development and delivery of reports against a
relational operational database
utilizes Cognos Framework Manager for data modeling
in database and ETL design/development in Microsoft SQL Server
communication skills and business requirement gathering experience
working with various business units on business intelligence
to .NET C# web development
Enterprise Architect II, 05/2013
to Current Key Bank – Cleveland,
Designed and maintained logical and physical data hub model using ERWIN modeling tool within the highly normalized framework of IBM Banking Data Warehouse industry model.
Designed and maintained data models for denormalized consumption data marts.
Collaborated with ETL teams on data transformation and loading strategies
Worked with DBA teams on storage and performance tuning strategies within Teradata and HDFS storage solutions.
Participated in requirement gathering sessions with various business units
Bachelor of Science: Computer Science,
2007 The Ohio State University - Columbus,