Sql Server Data
Resume:
Résumé of Paul H. Lemmen
Largo FL. 33770
*********@*****.***
CURRENT STATUS
January 2010 Current
Social Security Disability
• I have been on Social Security Disability due to a severe illness that is no longer affecting my ability to work without
accommodation. During the past years on disability, I have leveraged my time by downloading and working with the
latest and greatest offerings from Microsoft, Oracle, Cognos, Crystal Reports, BODS, Microstrategy and Informatica (I
am current with ver. 9.6). Working with the expanded tool sets available with each new release I have sharpened by
abilities and knowledge in pursuit of my goal of returning to the workforce in my chosen field.
• I am a member of both Microsoft Developers Network (MSDN) since its inception in 1986 and a member of the
Oracle Developers Network (ODN) since 1992. I am currently evaluating Hadoop 2.4, Microsoft Azure cloud client
against local databases created in SQL Server 2014, SQL Server 2012, SQL Server 2008 (as well as earlier versions of
SQL Server), Oracle 10g/11i and Oracle 11g.
• As mentioned in the above paragraph, I have been working on SQL Server 2014. This platform has been released on
July 1, 2014 and I was a part of the beta test (uncompensated) team and Release Client team for the 18 months prior
to release. As part of the testing, there is the need for multiple datawarehouses, databases of different versions of
SQL Server as well as other RDBMS’s. To this end, I architected and created in excess of 20 datawarehouses in
various forms (UDB, Oracle 11g and SQL Server) as both sources and destinations for the purpose of testing the
capabilities of SQL Server 2014 and identifying weaknesses and improper code or configuration. I utilized other ETL
toolsets such as Informatica (versions 8.2, 8.4, 9.5 and 9.6) using a variety of SQL Server versions and Oracle
versions (as well as UDB, DB2, Access and a wide variety of flat files and feeds from SharePoint) as sources and
targets.
• To accomplish this validation using the external toolset of Informatica 9.6 as an example, I not only created mappings
and re usable mapplets in the Designer client in Informatica, I also used the designer client to create SQL scripts and
stored procedures. I used the Administrator client to manage the execution and load balancing (as well as other
functions and to manage permissions). In Informatica 9.6 in both the designer client and the new(ish) Java based
thick client Developer, I created, tested and maintained workflows with the Workflow Manager.
WORK EXPERIENCE:
July 2005 March 2007
Blue Iraq (now defunct)
LSA Anaconda, Balad, Iraq
Title: CEO
• Satellite Communications/Satellite Internet as well as data services provided to governmental, NGO's and military
entities in the middle east. Clients included DOD, DOD Finance, The Emirate of Kuwait, the Kuwait Ministry of
Defense, the Kuwait Royal family, the United Arab Emirates, The Kingdom of Saudi Arabia, KBR, Halliburton as well
as others.
April 2004 July 2005
Top Echelon Consulting, assigned to Healthways, Inc.
Nashville, Tennessee
Senior Data Warehouse Architect
• Responsible for the design, architecture and capabilities for the successful roll out of their reporting data warehouse.
Development team lead for 12 developers in 2 year project incorporating HIPPA restrictions and daily importing data
from over 175 discrete sources using a very complex ETL process.
• Technologies employed: SQL Server 2002, Oracle 8i, and Informatica PowerCenter 8.0 as ETL tool, Business Objects,
Crystal Reports as well as custom 'dashboards' created using Visual Studio. Created stored procedures, back up
processes and disaster recovery procedures.
April 2001 October 2003
Saxon Capital (Now Defunct)
Richmond, Virginia
Title: Senior Data Warehouse Architect
• Redesigned and re architected a failed data warehouse, leading a development team of 15 developers. Responsible
for the design, architecture and choice of RDBMS and ancillary tools such as ETL, report, SDLC, test and QA
environments.
• Technologies employed: SQL Server 2000, Oracle 8i and Informatica PowerCenter as ETL tool, Business Objects,
Crystal Reports and Oracle Financials. Created stored procedures, back up processes and disaster recovery procedures
thus facilitating reporting and compliance with SEC regs and Sarbanes/Oxley as well as executive dashboards and an
agent database to allow in the field loading of mortgage applications into the approval data warehouse.
January 2000 April 2001
Metro Consulting (now defunct) assigned to AT&T Inc.
Tampa, Florida
Title: Senior Consultant
• Creation and architecture of an international billing services data warehouse importing data from systems as diverse
as DB2 and MySQL and writing COBOL and FORTRAN to retrieve session data from RADIUS servers worldwide,
architecting and constructing a data warehouse that merged the data from these disparate sources and produces a
comprehensive to the second monthly bill in the local currency against the exchange rate to US Dollars at the time of
the call or data transmission utilizing Informatica PowerCenter ETL tool suite to import and process the daily data
load from RADIUS server hosting DB2 databases in 127 countries.
January 1999 - January 2000
FarAway.com (now defunct)
St. Petersburg, Florida
Title: Senior Data Warehouse Architect
• Creation of international travel and hotel booking data warehouse for their web connected Internet site. The data
warehouse was hosted on a SQL Server instance and the ETL tool used to load the data hourly was Informatica.
Several competing web sites in the travel niche caused FarAway.com to go defunct in 2001 because ownership
declined to upgrade infrastructure and technology per my recommendations.
July 1987 January 1999
Paul H. Lemmen Consulting (now defunct)
Los Angeles, California and Largo, Florida
President
Consultant on data infrastructure, database creation, architecture and administration, software and operating
systems, hiring, training and retention of IT staff, system migration and upgrade, network architecture and
desktop computer networking under Windows 3.11 and Windows NT. Based on client needs, installed and
designed the architecture of data warehouses, databases, client interfaces and input forms with a variety of
tools including DataStage, Cognos, Business Objects and Informatica on RDBMS's Oracle, DB2, Teradata and
SQL Server.
Clients included Nissan, Toyota, Vienna Beef, RCS Inc., 4G Technologies and Yellow Freight.
EDUCATION
September 1970 June 1973
CS Mott High School
Warren, Michigan GPA 3.77
August 1975 – March 1977
Macomb Community College
Mt. Clemens, Michigan
Management of Information Systems
Paramedic Training GPA 3.51
August 2014 to (projected) July 2015
North Central Theological Seminary
Columbia Heights, Minnesota 55421
Chrstian Social Work Degree Program for Experienced Learners.
Overall Technical Knowledge/Experience
• 37 Years total experience, from IBM 360 mainframes to client/server and cloud applications/computing/platforms.
• Member of MSDN since 1986. Beta test participant since 1986.
• Member ODN since 1992. Beta test participant since 1992
• Kimball and Inmon since the middle 90’s
• SAS, Cognos, Business Objects, Crystal Reports since 1992
• SSIS, SSAS, SSRS since 2008, full stack since 2010 (just completed 18 months of beta testing and development of
SQL Server 2014 which was released on July 1, 2014)
• Visual Studio since 1995
• SAP since 2000
• Web development since 1995
• SOA and Web Services since 2003
• OODD since 1995
• EDW/BI since 1995
• Data Modeling since 1995
• DBA/Architect since 1995
• Experience with multiple ETL toolsets/software/languages (SQL, PL/SQL/T SQL) and tools (i.e., TOAD).
• RDBMS’s: DB2m UDB, TeraData, Oracle, MS SQL Server, Access and many others.
Pretty much any software, operating system or data base system that exists as a major application I have used or
developed with. I am able to roll up my sleeves and write script as well as sit facing end users to acquire their
requirements interactively, manage their expectations and reduce scope creep. I am able to wear many hats concurrently.
References
Stephan Jung via email: ******@*********.*** or telephone: 314-***-**** (Mobile)
Bob Kellum: via email only: ***.********@*****.***
Chad Keck: via email: **********@*****.*** or telephone: 727-***-****
Contact this candidate