Developer Data

Dale G. Johanning

**** **** ****, *******, ** ***04-2140

(C) 608-***-**** (E-mail) *********.****@*****.***

Dynamic IT professional, with experience in Application Design, Data Warehousing, Business Intelligence, Data Architecture & ETL Development technologies. Successfully lead & architected mid-large sized Data Warehousing, Data Integration & BI projects. I am focused on leading and developing strategies to execute data integration initiatives. Results oriented individual with demonstrated business acumen through communication, execution, and relationship building.

Summary of Qualifications

Expertise in architecting the overall ETL framework for data integration & analytics, implementing SOA based data services using Informatica and DataStage for seamless application integration, designing ETL process for scalable & robust data movement

Demonstrated experience in modeling data warehouses & data marts using star schemas, staging area design, implementing dimensions & facts, data analysis & profiling, creating source to target documents, transformation specs, cleaning & cleansing rules.

Worked as a project/tech lead responsible for project planning, work breakdown and estimation, team building & coordination, requirement scoping, implementing standards & best practices, mentoring other developers, status reporting to upper management, issues & change management

Hands on experience in designing & developing complex mappings, developing web services using Informatica, DataStage and Business Objects, building process for real time data pulls from legacy, relational sources using IBM InfoSphere, Informatica Power Exchange, tuning Informatica and DataStage jobs for high performance data loads

Strong background in large data warehouses using Oracle 7/8/9i/10g/12c, Sybase 15.0 & DB2 UDB. Skilled in writing/tuning SQL, PL/SQL programming, effectively coupling Informatica and DataStage with these databases

Technologies

ETL/BI Tools: IBM InfoSphere DataStage Director & Designer 8.1/8.5/8.7, Informatica PowerCenter 4.7/5.1/6.2/7.1/8.5, 9.6,10.2 Informatica PowerExchange 4.1/5.1/5.2/8.5, Informatica Power Analyzer, Change Data Capture, Business Objects 5.1/6.1/ XI (ZABO and Webi), Cognos, SQL, PL/SQL, Erwin 3.5.2 – 4.1.4,

RDBMS Platforms: Netezza, DB2 & Oracle 9i/10g on MVS 7, Adabas, Microsoft SQL Server 6.5/7/2000/2005, Oracle 8/9i/10g/12c on HP-UX/AIX, Sybase 15.0 on HP-UX/AIX, Microsoft Access, VSAM

Application Development Tools:, SQL, PL/SQL, Stored Procedures, DB2 SQL, COBOL, COBOL II, CICS, MVS/ESA JCL, NATURAL, C/C++, Visual C++, Visual Basic 6.0, VBA, VB.NET, ASP.NET, Microsoft SQL, SAS for Windows, Java 2, Perl, Eztrieve, FOCUS, Crystal Reports 2008

Operating Systems: HP-UX, AIX, MVS, Z/OS, Windows

Miscellaneous: Rapid SQL, TOAD, SQL Navigator, SQL Developer, Oracle Designer, Oracle Quest, Oracle SQL*Loader, Oracle Forms, Reports, IIS, TSO/ISPF, SPSF, MVS/JCL, Panvalet, ChangeMan, Endeavor, File Manager, File Manager for DB2, Xpediter, Comparex, SuperCe, Hourglass, File-Aid, Abend-Aid, Connect Direct, Quickjob, Micro-Focus REVOLVE, Micro-Focus COBOL, Micro-Focus Main Frame Express, Microsoft Office, MS OutlookMicrosoft Project 2000, Excellerator CASE Tool, Visio Standard 5.0/2000, Key Analyze, Business Objects, Business Objects - Web Intelligence, RoboHelp & RoboHelp HTML, Visual Source Safe, Broadcast Agent, Golden, PKZIP, Visual Studio, UltraEdit, Filezilla, WinCSP, Putty, SharePoint, Rally, xMatters, SPOK Moble, Service Now

PROFESSIONAL EXPERIENCE

Lands End (Dodgeville, WI) (Feb. 2020 – April 2020)

Role: Sr. Data Warehouse Developer

Technology DataStage 11.2, Netezza 7.2, Oracle 12.c, Oracle SQL Developer v17.3,OPSWISE, JIRA,

IBM Netezza Server v. 7.2, Unix, Putty

Worked as Lead Developer on conversion of legacy systems

(COVID-19 cancelled project prematurely)

UW Health (Madison, WI) (June 2014 – October 2019)

Role: Sr. Data Warehouse Developer

Technology Informatica 9.6/10.2, Netezza 7.2, Oracle 12.c, Oracle SQL Developer v17.3, EPIC CLARITY,

MS SQL Server v. 14.0, A2B Load, CA Workload Automation, IBM Netezza Server v. 7.2

Worked as Lead Developer on Press Ganey Incoming and Outgoing applications. EPIC Software Upgrade,

On-Call Support for daily loads. NAACR (National Cancer Registry), Consortium Loads

QBE (Sun Prairie, WI) (June 2011 – May 2014)

Role: Senior ETL Developer

Technology: IBM InfoSpere DataStage 8.1/8.5//8.7, Cognos, DB2 V11, AIX Unix 11i v3, UltraEdit, Filezilla, WinSCP, Putty, SharePoint, Rally

Worked as a technical lead/developer in an Insurance Investment’s (Mortgage, Reinsurance, and Real Estate) I.T. Department. Implemented and revised numerous data warehouses, data marts, operational data stores, real time processes & web services using IBM InforSphere DataStage, Cognos and Unix systems.

Adecco / Hexacorp, (Milwaukee, WI) (Nov. 2010 – May 2011)

Role: Senior Application Developer

Technology: Informatica Power Center 8.1.1/9.0.1, Business Objects XI 3.1, Sybase 15.0, Unix 11i v3, RapidSQL 7.4.2, Crystal Reports 2008

Worked as a technical lead/developer in an Insurance Investment’s (Oil/Gas, Real Estate) I.T. Department. Implemented and revised numerous data warehouses, data marts, real time processes & web services using informatica, Business Objects and Unix systems.

K-Force Professional Staffing, (Madison, WI) (Dec. 2007 – Nov. 2010)

Role: Senior Application Developer

Technology: OS/390, TSO/ISPF, SPSF, COBOL II, CICS, DB2, MVS/JCL, Oracle 9i/10g, Panvalet, File-Aid, Abend-Aid, Microsoft Windows, Microsoft Outlook, Microsoft Office, Lotus Suite, Visio 2000, Oracle 9i/10g, PL/SQL, SQL, Golden, Perl, VBA, Informatica Power Center 8.6, Informatica Power Exchange 5.2, Real time with legacy sources, PeopleSoft

Worked as a technical lead/developer in various I.T. Departments. (Banking, Utilities, Communication) Implemented and revised numerous data warehouses, data marts, real time processes & web services using informatica and MVS/OS systems.

State of Wisconsin – DWD (Madison, WI) (June 1999 – Dec. 2007)

Client: Department of Workforce Development - CARES/BITS Data Warehouse

Role: Senior Programmer/Analyst - ETL Developer/Tech Lead/ DBA Liaison

Technology: Informatica Power Center Ver. 5 – 8.2, Informatica Power Exchange 5.1, Business Objects 6.5 (ZABO & Webi), DB2 UDB EEE v8, Oracle 7/8/9i/10g, MS Project, Visio, MVS, VSAM, OS/390, TSO/ISPF, SPSF, COBOL II, MVS/ESA JCL, DB2, DB2-SPUFI, SAS, File-Aid, Endeavor, Comparex, SuperCe, Micro-Focus Mainframe Express, Finalist, Visio, Standard 5.0, Control-M (Scheduling), UNIX Scripting, RACF, IDMS, ERWIN ModelMart v. 3.5.2 – 4.1.4, PL/SQL, SQL *Plus, SQL Navigator, TOAD, SAS for Windows

DATA WAREHOUSE GROUP

Implemented numerous Data Warehouse & Data Mart Projects to facilitate BI Reporting, Data Mining & building the Enterprise Data Warehouse. Responsible for designing & implementing Child Care (CC), Food Stamp/ Food Share (FS), additionally Electronic Benefits Transfer (FS-EBT) - Quest Card Data, Wisconsin Works (W2), Federal Performance Standards (PS, PS23, PS45, PS67) Data Marts using Kimball’s Dimensional Star Schemas.

These Data Warehouse/Reporting application captures data from internal and external flat files, DB2 and Oracles tables. The applications cleanses data, load data into Star Schemas & provide reports for online analysis including trend analysis with drill-down capability and present information in the form for Business Objects Cubes and Drill down reports.

Contact this candidate