Scott Clark
5520 Clagston Ct. ¨ Dayton, Ohio 45424 ¨ [Send email to request phone number] 04.5318
sclark3001@woh.rr.com
Qualifications Profile
More than 13 years of experience with data systems reporting and analysis.
Accurately assess customer needs and requirements, translate information to data,
and provide timely analysis and reporting solutions.
Highlights include:
· Teradata Certified Master with 5 years of experience.
· Ability to rapidly learn new information regarding data systems and tools.
· Strong knowledge of software solutions and their interrelations with business
management objectives.
· Proactive self-starter known to initiate process and system improvements to
increase information analysis and reporting.
Professional Experience
The Coffing Corporation – US Air Force (contractor) October 2008 –
Apr 2010
TERADATA DATABASE ADMINISTRATOR
Responsible for and maintain support system databases for the US Air Force.
Create and maintain tables and views within several databases in the data
warehouse. Perform all aspects of DBA in a Teradata environment. Provide source
to target data mapping for projects relating to data information and reporting
analysis. Writing SQL queries and views to support specific information
requests.
· Data systems include: Teradata, Teradata Manager, SQL Assistant,
Informatica, Erwin Data Modeler, Cognos, Business Objects web-based reporting
tools
MeadWestvaco Corporation - Dayton, OH Aug 2007 – October 2008
RETAIL MARKET DATA ANALYST
Provided solutions to the development, analysis and reporting of point-of-sale
consumer data for the Dayton-based marketing and sales groups. Delivered timely
and accurate information to internal customers for in-depth research and
analysis.
· Successfully improved data availability by up to 3 business days by providing
newer business intelligence solutions with Cognos BI.
· Initiated partnership with research analysts and product managers to further
understand business needs and translate data into information.
· Provided a single source solution for information utilizing data cubes and
standard / ad-hoc reports, analysis and solutions.
· Data systems included; Cognos 8 BI solutions, Oracle, PL/SQL, MS Access
Logtec, Inc - US Air Force (contractor) Jun 2003 –
Jul 2006
DATA ANALYST
Received data requirements from Air Force personnel to create and maintain
reporting and analysis solutions. Delivered a single source application to
accurately identify and improve data management for more than 100 Air Force
sites.
· Created and maintained reporting solutions for personnel based on specific
information needs. Provided email and telephone support.
· Conducted training and information workshops for personnel to accurately
report and analyze their data needs.
· Data systems included; Business Objects v6 Web Intelligence, Cognos v7 and v8
Business Intelligence, Teradata, MS Access.
The Reynolds & Reynolds Company - Dayton, OH Sept 2000 – Feb 2003
DATA ANALYST/REPORTING SPECIALIST
Managed computer applications and systems for various personnel groups. Created
and maintained market driven reports and analysis. Successfully designed MS
Access reporting application for outside sales group.
· Data Systems Included; Crystal Reporting, Business Objects, Cognos v7 ,MS
Access
Delphi Chassis Systems - Dayton, OH Jun 1997
– Sept 2000
SYSTEMS ADMINISTRATOR
Administered the main automotive parts tracking system for entire Chassis
division. This MS Access / Oracle based application included parts, suppliers
and production/cost information. There were over 100 users and over 10,000
automotive parts in this system.
United States Air Force
Jun 1990 – Jun 1997
AIR TRANSPORTATION SPECIALIST
Honorable Discharge; 7 years active duty service; Top Secret/SCI clearance
obtained; Veteran, Operations Desert Shield/Storm; Medals included – Air Force
Commendation Medal (1), AF Achievement Medal (2), Kuwait Liberation Medal,
Southwest Asia Service Medal, Air Force Good Conduct Medal (3).
Computer Skills
• Teradata V 12.0 V2R5 • Cognos 7.3 / 8.1, 8.3 BI • Windows NT/XP/Vista
• Microsoft Excel • Business Objects 6.5 • PL/SQL, MySQL
• Microsoft Access • Crystal Reports v10 • Teradata QueryMan
• Microsoft Project • SAP Business Modules • SQL Server 2005
• InDesign • Informatica 7 • Visio
Formal Software Training:
Teradata: Teradata Certified Master (March 2009)
Microsoft Access: Advanced/Expert
Business Objects: Universe Design, v6.5 WEBi and OLAP Reporting
Cognos: PowerPlay OLAP Modeling for Series 7.3 & Cognos 8 BI ¨ Series 7
PowerPlay Exploration & Report Building ¨ Series 8 Framework Manager, Query,
Report, Analysis Studio Solutions
Crystal Reports: v 10 Reporting and Analysis
SQL Server: 2005 Express Edition, Query Analysis
|
