Dynamic information
technology professional focused on leading and developing strategies to execute
data integration initiatives. Results
oriented individual with demonstrated business acumen through communication,
execution, and relationship building.
Technologies
· ETL/BI Tools: Informatica PowerCenter 4.7/5.1/6.2/7.1/8.1/8.5, Informatica PowerExchange 4.1/5.1/5.2/8.1/8.5, Business Objects 5.1/6.1, Microsoft DTS 7/2000,, Microsoft Analysis Services, T-SQL, Pl/Sql, Unix Scripting Korn/Perl, Windows Scripting VBScript/JScript/Python, Seagate Crystal Reports 7, Power Designer, ERwin
· RDBMS Platforms: DB2 UDB EE & EEE 5/7.2/8.1/8.2 on HP-UX/AIX, DB2 MVS 7, Sybase SQL Server 11.9/12.0/12.5 on HPUX, Adabas, Microsoft SQL Server 6.5/7/2000/2005, Oracle 8i, Microsoft Access, VSAM
· Application Development Tools: Oracle Forms, Visual Basic, ASP, C, C++
·
Operating Systems: HP-UX, AIX, MVS,
z/OS, Windows
·
Miscellaneous: AutoSys, CA7,
ControlM, IIS, Siebel, JCL, TSO
Professional Experience
Pure Strategy
President and Data Integration Evangelist, March 2003 – Present
Data integration initiatives to develop the
SOA Data Integration
Architect / Data Warehouse Architect / ETL Architect / Project Manager
· Practitioner of leading edge implementation of a Real-Time Data SOA utilizing Informatica Webservices and PowerExchange Change Data Capture offerings. Real-Time Data SOA utilizing An early adopter of Informatica Webservice technology in the data integration space proved challenging yet through a closer partnership with Informatica were able to drive success out of the initiative.
·
Architected and coordinated multiple projects in
parallel to build from the ground up an EDW consisting of Claims, Policy,
Rating, Agency and Workflow subject areas.
Integration of highly complicated
legacy sources including VSAM, DB2
· Directed and architected successful implementation of Informatica PowerCenter Advanced Edition 8.x install including options (Enterprise Grid, Team Based Development, Partitioning, High Availability and Data Quality). Directed implementation of Informatica PowerExchange 8.x install including options (VSAM Batch/CDC, DB2 CDC, SQL Server CDC).
|
Informatica PowerCenter 8.1, DB2 MVS 7(Batch, Real-Time CDC), DB2 UDB 8(Batch),TSO, JCL, CICS, VSAM(Batch, Real-Time CDC), ControlM, Informatica PowerExchange 8.1, SQL Server 2000/2005(Batch, Real-Time CDC) |
American Family Insurance March 2003 – April 2006
Multiple phased projects to develop
Data Warehouse
Architect / ETL Architect / Project Manager
· Worked with high level management developing strategies to deliver successful implementation of an EDW with claim, policy, education, and agency subject areas to deliver business intelligence projects. Creation and management of the solution proposal, work plan, project plan and deployment plans. Coordinating day-to-day activities of developers and goal setting
· Lead discussions and decision-making groups involving business clients to determine business needs of data warehouse. Functional experience gained in billing, account receivables and insurance products such as personal/commercial auto, property and personal umbrella products.
· Architected and implemented change data capture and slowly changing dimension design. Performed dimensional and 3NF modeling according to enterprise standards. Assisted DBAs in implementing partitioning, MQT (Materialized Query Tables), MDC (Multi Dimensional Clustering) and optimizing EEE performance for data warehouses.
· Acted as a key contributor for direction of strategic enterprise data warehouse and Informatica implementation. Acted as a key resource in successful upgrade from Informatica 5.1.2 to 6.2 and 6.2 to 7.1. Designed and implemented Meta Data repository and reusable components to capture ETL Meta Data.
· Viewed as “Informatica Expert” by multiple groups within American Family. Development of complex mappings and session. Development of shared libraries and creation of technical foundation for Informatica developers. Mentoring and teaching junior developers. Performed extensive debugging and performance tuning of mappings, sessions and workflows including partitioning, memory tuning and cache management.
|
Informatica PowerCenter 5.1/6.2/7.1, UDB DB2 EE & EEE 7.2/8.1/8.2 DB2 MVS 7, Business Objects 5.1/6.1,Unix Scripting Korn/Perl, CA7, Informatica PowerExchange 4.1/5.1/5.2, Adabas, XML, VSAM |
CataList Homes http://www.catalisthomes.com March
2003 - Present
Realty Based Internet Application
ETL Architect / Database
Architect
· Architected and developed complex ETL(Extract/Transform/Load) procedures were developed using SQL Server’s DTS and T-SQL to provide a way to update/insert/delete data from multiple heterogeneous realty listing sources.
· Created logical and physical database design modeled to support the displaying of realty based information through use of online tools such as customized search engines for retailers, property pages, and virtual agent support.
|
Microsoft SQL Sever 7/ 2000, DTS, T-SQL, VBScript, JScrip |
Greenbrier & Russel
Consultant, February 2000 – March 2003
Northwestern Mutual June 2001 – March 2003
Multiple phased projects to develop Operational Data Store,
Technical Lead /
Data Warehouse and ETL Architect
·
Development of complex Informatica mappings to
load ODS, EDW and Data Marts. Defined
technical requirements for ETL processes.
Performed dimensional and 3NF data modeling. Performance tuning of
· Assisted in defining long-term project objective and goals with project manager. Responsible for day-to-day management and technical task assignment of developers. Estimated new projects and new phases to existing projects. Member of core architecture group in decision making spanning multiple development groups working on enterprise data warehouse.
· Worked directly with the business clients to analyze their needs and priorities for these very large-scale and highly visible projects. Helped manage integrated test system ultimately providing successful client acceptance testing, which was a key component in making these project successful.
· Performed activities including execution of test plans and design of exception handling strategy. Completed documentation in relation to detailed work plans, mapping documents and high-level data models.
· Mentored peers and junior staff in both design and development of ETL architecture. Key member in defining standards for Informatica implementation.
· Lead discussions and decision-making groups in determining needs for subject areas. Functional experience and knowledge gained in client, agent, insurance product, investment product, case management and contact management subject areas
|
Informatica PowerCenter 4.7/5.1, DB2 UDB EE 6/7.1, Sybase 11.9/12.0/12.5, DB2 MVS, T-SQL, Unix Scripting Korn, Siebel, MVS, AutoSys, Business Objects 5.1 |
Homestore.com February
2000 – June 2001
Multiple Realty
Based Internet Applications
ETL Developer / Senior
DBA / Internet Development Architect
· Created logical and physical database design modeled to support the displaying of realty based information through use of online tools such as customized search engines for retailers, property pages, and virtual agent support.
· Architected and developed complex ETL(Extract/Transform/Load) procedures were developed using SQL Server’s DTS and T-SQL to provide a way to update/insert/delete data from multiple heterogeneous sources.
· Monitored and improved database performance by creating efficient database design, creation of necessary indexes and table partitioning.
|
Microsoft SQL Sever 7/ 2000, DTS, T-SQL, PowerDesigner, VBScript, JScript, ASP |
New Technology Solutions, Inc & NTSNET, Inc
Minority Owner of Sister Company NTSNET, April 1998 – January 2000
Consultant New Technology Solutions, February 1997 – February 2000
Various Internal and External Projects February 1997 – February 2000
Clients including Kimberly Clark,
International Paper, Fort James
ETL Developer / DBA
/ Oracle Forms Developer / Internet Application Developer
· Created database models both logical and physical and designed ETL procedures used in importing data from various operational systems for reporting purposes using dynamic crystal reports.
· Developed project scope and defined products used by working directly with client.
|
Oracle 8i, Sybase, Pl/Sql, ERwin,, Oracle Developer 2000, DECVoice, Visual Basic 5.0, C, Microsoft SQL Server 6.5/7.0, T-SQL, Microsoft Site Server 3.0, IIS 4.0, Net It, Real Audio Server, Seagate Crystal Reports 7.0 |
Education
|
University
Wisconsin Bachelor of Science (BS) Major: Computer Science Minor: Business |
University
Wisconsin Master of Business Administration (MBA) Course Work On-Hold |
Certifications
MCDBA, MCSE
|
System Administration for SQL Server 7.0 |
Microsoft TCP/IP |
|
Implementing a Database Design on SQL Server 7.0 |
Internet Information Server 3.0 |
|
Windows NT Server 4.0 |
Windows NT
Server |
|
Windows NT Workstation 4.0 |
Networking Essentials |
Organizations/Interests
· Beta Theta Pi Alumni
· Fishing
· Travel
· Home Improvement