
ETL Tech Lead at Wells Fargo Advisors (Contract)
Greater St. Louis Area

ETL Tech Lead at Wells Fargo Advisors (Contract)
Greater St. Louis Area
Data Governance is key to business success, especially in these tough economic times. Businesses are generating larger volumes of data, yet much of that data is not accurate and therefor not actionable. Without the ability to generate accurate business intelligence a business will struggle.
I love data! I'm passionate about data integration and data migration. Recently my passion has moved over towards data profiling, data quality and data governance.
My ideal position is with a company that is serious about data governance which will be able to utilize my skills and experience in data integration and allow my employer to achieve its data management goals.
I am an Expert Content Contributor and Blogger on CIOZone.com, http://www.ciozone.com/go2/?TheDataIntegrator, where I blog about data integration and data governance issues.
Experience:
* Over 10 years Operational Data Integration and Software Implementation experience.
* Data Mart customization
* Design custom data migration and data integration solutions
* Data Integration Team Lead - Callidus TrueComp (SPM / EIM) implementations
* Technical Consultant - Siebel (CRM) and Peoplesoft (HRMS) implementations.
* Develop Informatica PowerCenter data mappings and workflows
* Create Oracle PL/SQL stored procedures and packages
If we share common interests, then I welcome you to send me an invitation.
Data Quality, Data Profiling, Data Integration, Data Migration, Data Warehousing, DW, Business Intelligence, BI, MDM, EII, ETL, Data Modeling
Enterprise Software:
Callidus TrueComp (SPM / EIM / ICM)
Siebel (CRM)
PeopleSoft (HRMS)
RDBMS:
Oracle, Microsoft SQL Server
DI Tools:
Informatica PowerCenter
Oracle SQL*Loader
Microsoft DTS
Oracle PL/SQL
Platforms: Windows, Linux, HP-UX, Solaris
(Privately Held; Information Technology and Services industry)
October 2009 — Present (3 months)
TEKsystems® is the leading IT staffing and services company. Our capabilities span a wide range of services: from technical staff augmentation and direct placement services, to full management of IT projects and comprehensive workforce management solutions.
I am an ETL Consultant on the Wells Fargo Advisors data management project.
(Public Company; WFC; Financial Services industry)
October 2009 — Present (3 months)
Technical ETL Lead on the 2nd largest brokerage merger ever between Wells Fargo Investments and Wachovia Securities.
Responsible for defining key business drivers for data management and BI Initiatives for organization. Define overall data and BI architecture (e.g., ETL process, ODS, EDW, Data Marts). Work with Data Analyst to define functional and technical requirements and data architecture(s) for the data warehouse; design and develop the ETL process, including data quality and testing; define meta data standards.
(Privately Held; Information Technology and Services industry)
July 2009 — Present (6 months)
CIOZone.com is a Professional Network for CIOs and IT Professionals.
I author the blog called "The Data Integrator" as an expert contributor on the CIOZone.com Experts Site. I write about the life and times of a data integration professional.
(Information Technology and Services industry)
April 2009 — September 2009 (6 months)
ETL Development Lead, translate business requirements to functional and technical requirements, technical specifications and data models. Implement and support large scale back end enterprise level operational business systems, data warehousing, database analysis, functional/design specifications, coding, system testing, implementation and post implementation data support.
Skills in ETL Development, Informatica, Data Integration, Data Migration, Oracle PL/SQL, Data Analysis, and Data Quality.
(Partnership; Information Technology and Services industry)
August 2006 — April 2009 (2 years 9 months)
OpenSymmetry is a leading independent consulting and integration firm that offers highly specialised services focused on delivering Sales Performance Management (SPM) solutions to clients worldwide.
Performed data integration and data migration tasks for several clients as a sub-contractor through OpenSymmetry and detailed below by project.
(Public Company; AMGN; Biotechnology industry)
November 2008 — March 2009 (5 months)
Callidus TrueComp application upgrade from 3.7 to 5.2.1. Modification and upgrade of complex PL/SQL procedures to optimize ranking processes to work in the TrueComp 5.2 environment. Modified other procedures including transaction and data loads to function in the TrueComp 5.2 environment.
(Privately Held; Financial Services industry)
December 2007 — November 2008 (1 year )
Automated incentive data imports and TrueComp compensation pipelines using Windows batch programs and Informatica. Created Payroll file extraction process using Informatica.
(Public Company; Telecommunications industry)
June 2007 — December 2007 (7 months)
Oracle PL/SQL programming. Team Lead for team of 5 consultants. Implemented moving National Retailers compensation from TrueComp 3.7 to TrueComp 5.x including inbound SQL feeds, preprocessor, and outbound feed processing.
(Public Company; S; Telecommunications industry)
June 2007 — December 2007 (7 months)
See above description of Sprint/IT position
(Public Company; DTV; Broadcast Media industry)
September 2006 — May 2007 (9 months)
Oracle PL/SQL and Unix scripting.
(Public Company; ADP; Computer Software industry)
May 2006 — September 2006 (5 months)
TrueComp Consultant at ADP through OpenSymmetry. Integration team lead. Integration specialist. TrueComp install, data migrations on Oracle using PL/SQL and Informatica.
(Public Company; CALD; Computer Software industry)
May 2004 — August 2006 (2 years 4 months)
Certified Data Integration Consultant. Extract data from variety of legacy data bases, transform data, import to TrueComp application data base.
(Information Technology and Services industry)
July 2000 — February 2004 (3 years 8 months)
Project roles around data migration and data integration using Informatica PowerCenter and Oracle PL/SQL to create inbound and outbound interfaces.
2001 — 2003
reading, learning new technologies, data quality, data integration, data migration, ETL, Informatica, Oracle PL/SQL, Callidus, TrueComp, Varicent, SPM, ICM
Callidus Certified TrueComp Data Specialist
Customer Certified Siebel Consultant