●Paul Thomann

**** ***** *******

Chicago, IL ***30

Home: 312-***-****

Email: adsdz6@r.postjobfree.com

Objective: Decision Support / Data Warehousing / Architect

Combining technical architecture and implementation with direct client responsibilities

Technical Expertise:

Hardware: IBM 3090, AS/400, Teradata DBC/1012, IBM RS6000/SP, Sun 10K, HP V2500 SCA

System Software: MVS, AIX version 4(Unix), Windows NT, Windows 2000, Sun Solaris 2.5.1 (Unix), HP UX 11.0, AS/400

Software: Teradata DBMS SQL, Oracle 8i SQL, AS/400 DB2 SQL, Informix SQL (XPS 8.11 and DS 7.30), Brio (report writer), Erwin (ERD tool), Power Designer (ERD tool), Torrent/Orchestrate (ETL tool), Ascential/DataStage (ETL Tool), Unix tools, Perl, Korn Shell, vi, TCP/IP, FTP, Information Advantage and I.Q. Software (both now CA)

Work Experience:

Motion Design (Consulting spec work) Chicago, IL

Business Intelligence Developer and Architect 2009-Present

Pentaho Open source business intelligence tools

●Proposed designs to small & medium sized businesses

●Learned tools in order to automate them

●Automated design tools for Pentaho tools

Motion Design (Consulting for Sears) Chicago, IL

Teradata Developer and Architect 2008

IBM AIX Servers, Teradata DBS

●Designed and developed Teradata SQL to reflect changes in the definition of households

●Worked with DBA and Data Architect using Power Designer to refine schema to adjust for the specifics of that job

●Wrote SQL Excel jobs to aid in verify that results were consistent with the old definition of household.

CSC (Consulting for BCBS association) Oak Brook, IL

ETL Developer and Architect 2006-2007

IBM/DataStage, IBM AIX Servers

●Designed and developed ETL jobs for Blue Cross Blue Shield (a warehouse in excess of 40 Terabytes)

●Wrote Korn shell scripts to run DataStage on the command line so that jobs could be automated and run with Tivoli.

●Worked with DBA and Data Architect using Erwin to refine schema to improve performance

●Wrote Korn shell scripts to aid in error tracking and report generation

Business Objects (Consulting & Software) Rosemont, IL

ETL Developer and Architect 2005-2006

IBM/DataStage, IBM AIX Servers and Mainframe

● Designed and developed DataStage jobs for MOPAR (Detroit Automotive)

●Aided in installation of Data Integrator (Business Objects product) along with training and best practices at Spartech.

Boise Cascade Office Products. (Business to Business) Itasca, IL

Technical Specialist Essbase and DataStage 2000-2004

Hyperion and Ascential Software, Sun 6800, Oracle 8i, NT Servers, SQL, Hyperion Essbase, Ascential DataStage

●Designed processes and wrote jobs to load data from Legacy systems (Mainframe and AS/400) into an Oracle Data Warehouse using Ascential/DataStage

●Administrated DataStage

●Maintained Hyperion Essbase (Cube technology)

●Redesigned Essbase Cubes based on changing business requirements

●Administrated Essbase

●Maintained legacy Essbase reports and created new reports

●Created scripts using to assist in Essbase security

●Designed and architected processes (using Erwin) to load data for One-Boise project (Project won the 2001 Gartner CRM Excellence Award)

●Worked with DBA’a and business to produce a workable Database design for One-Boise

●Used Erwin to design a Data Mart using Star Schema (Executive Level Summary Tool)

●Led team in the development and testing this Data Mart

Aerial Communications Inc. (Wireless) Chicago, IL

Analyst III, Decision Support Specialist 1999-2000

RedBrick 5.1.6, Information Advantage (Business Intelligence Tool), HP-UX 11.00, Oracle 7.3.4, Brio, Erwin, SQL

●Team lead for OLAP reporting using Information Advantage/RedBrick

●Managed monthly reporting Information Advantage/RedBrick

●Managed ad hoc reporting for Data Warehouse team Brio queries/RedBrick and Oracle

●Translated business requirements to the Data Warehouse team

Sears Roebuck and Co. (Retail) Hoffman Estates, IL

Database Architect, Database Designer, Database Analyst for Decision Support 1994-1999

Informix 8.11, Informix 7.3, IBM RS6000/SP, PeopleSoft, Sun 10K, Solaris 2.5.1, Torrent Orchestrate (ETL tool), Power Designer (ERD tool), SQL, AIX, Korn Shell, Perl, Information Advantage (Business Intelligence Tool), Teradata DBC/1012, IBM 3090, MVS, TSO, SPF, JCL

●Developed logical design (Power Designer) for reporting ODS (Migration of GL from mainframe to PeopleSoft

●Implemented incremental load strategy for above ODS in order to do partial loads during the day

●Created SQL logic to support extract for Torrent/Orchestrate (an ETL tool)

●Created scripts to populate call center Datamart (utilizing Informix SQL and Korn shell scripting)

●Co-developed Data Warehouse design (Power Designer) and metadata for call center Datamart

●Created, defined and maintained Datamart tables (call center effectiveness)

●Integrated load processes to the front-end tool (Information Advantage)

●Set up Unix environment (generic ID’s, generic profiles, file structure, and data backup)

●Created and designed (DDL) aggregate tables in order to roll off data at the lowest level

●Designed table structure and coded SQL for Advertising Effectiveness

●Converted reports from Teradata to Informix

●Developed processes to automate running of our legacy reports from the mainframe

●Designed table structure for performance reports (Sears repair business)

●Designed and coded SQL to generate data used by company systems to route technicians

●Translated business problems into SQL working around data integrity issues

Education:

DePaul University, Chicago, IL Computer Career Program

(An accelerated post-graduate program in computer science)

Rice University, Houston, TX BA in Philosophy and Mathematics

Contact this candidate