ETL Professional
Resume:
Daniel O. Oke
**** ********* ***** **********, ** 30005
678-***-**** (Mobile)
E-mail – acx70x@r.postjobfree.com
SUMMARY OF QUALIFICATIONS
** ***** ** ********** ** Relational Database Management System (ORACLE, SYBASE, SQL SERVER, DB2).
20 years of experience in Logical Data Modeling, using ERWIN as modeling tool.
18 years of experience in Dimensional Data Modeling, using ERWIN as modeling tool.
18 years of experience in data extraction, manipulation and movement using INFORMATICA PowerCenter (versions 3.5, 4.7, 5.1, 6.1, 7.1, 8.6, 9.0.1,9.5.1) and DATASTAGE Versions 3.5.2 and 3.5.6 as Extraction, Transformation and Load (ETL) Tools.
6+ years of experience in Project Management.
4 years of Project Implementation utilizing AGILE Methodology.
Strong understanding of Data Warehouse concepts (OLAP, ROLAP, HYBRID) and architecture (STAR SCHEMA and SNOWFLAKE).
Detailed knowledge of concepts and application of relational databases including entity integrity, referential integrity and data normalization.
20 years of extensive Structured Query Language (SQL).
4 Plus Years of experience working in an Agile/SCRUM Model.
1 year of Salesforce.com API, Apex data loader
Excellent communication skills, both oral and written.
Strong orientation to team development approach, with refined interpersonal skills, dealing with both clients and professionals.
Detail-oriented. Organizational abilities. Enthusiastic, personable, dependable.
EXPERIENCE
Datalitix, LLC, Atlanta, GA
Consulting Assignments include:
SmartSource West Africa
02/16 – Present: Senior ETL Consultant
Position Function: Senior ETL Lead – Telecommuting
Work remotely with Users and Technical leads to review and finalize solution design.
Develop ETL standards and best practices.
Developed library of reusable objects.
Develop medium to complex ETL mappings using INFORMATICA PowerCenter (Version 9.5.1) as the ETL Tool.
Create workflows to run tasks, sessions and worklets using INFORMATICA Workflow Manager (Version 9.5.1).
Spartan Technologies, Atlanta, GA
Consulting Assignments includes:
AutoTrader, Atlanta, GA
06/12 – 01/16: Senior ETL Consultant
Position Function: ETL Architect / Development Lead
Implemented NewCarX Project using Agile Methodology.
Worked with Program and Scrum Teams to deliver data for consumer site augmentation.
Worked with Business Analysts to capture ETL requirements to be documented into the source to target mapping document.
Designed and implemented strategies for ETL load into Enterprise Data Warehouse.
Developed medium to complex ETL mappings using INFORMATICA PowerCenter (Version 9.5.1) as the ETL Tool.
Created workflows to run tasks, sessions and worklets using INFORMATICA Workflow Manager (Version 9.5.1).
Reviewed ETL Design and construction deliverables for quality and accuracy.
3Sage Consulting, Atlanta, GA
Consulting Assignments included:
Manheim, Atlanta, GA
12/11 – 06/12: Senior ETL Consultant
Position Function: ETL Architect / Development Lead
Responsible for Requirement Analysis and ETL Development on a new CRM Project to extract Customer Sales data from Salesforce.com and download into DB2 database in order to track customer leads and support sales activities.
Designed and developed ETL and CRM (Salesforce) solutions for complex functional and technical requirements using INFORMATICA PowerCenter 9.0.1 as the ETL Tool.
Created Source to Target mapping documents to identify source attributes and how it gets transformed into the business information/requirement.
Performance tuned and optimized large volumes of data loads.
Consulted with Users and technical leads to review and finalize solution design.
Developed medium to complex ETL mappings using INFORMATICA PowerCenter (Version 9.0.1) as the ETL Tool.
Created workflows to run tasks, sessions and worklets using INFORMATICA Workflow Manager (Version 9.0.1).
Datalitix, LLC, Atlanta, GA
Consulting Assignments included:
Catlin USA, Atlanta, GA
05/11 – 12/11: Senior ETL Consultant
Position Function: ETL Architect / Development Lead
Consulted with Users and technical leads to review and finalize solution design.
Designed and Architected ETL Environment.
Designed and developed ETL and Data Integration (SAP) solutions for complex functional and technical requirements using INFORMATICA PowerCenter 9 as the ETL Tool.
Developed ETL standards and best practices.
Developed library of reusable objects.
Developed medium to complex ETL mappings using INFORMATICA PowerCenter (Version 9) as the ETL Tool.
Created workflows to run tasks, sessions and worklets using INFORMATICA Workflow Manager (Version 9).
Designed ETL error handling and error logging mechanism.
Tek Systems, Atlanta, GA
Consulting Assignments included:
AutoTrader, Atlanta, GA
02/09 – 05/11: Senior ETL Consultant
Position Function: ETL Architect / Development Lead
Designed and implemented strategies for ETL load for Next Generation Model Info (NGMI) project.
Designed and implemented strategies for ETL load into the Master Data Management (MDM) Database.
Designed and implemented strategies for ETL load for Car Inventory.
Designed and implemented strategies for ETL load for Dealer Tracking.
Designed and implemented strategies for ETL load for Secure Pricing Access automation.
Developed medium to complex ETL mappings using INFORMATICA PowerCenter (Version 8.6.1) as the ETL Tool.
Created workflows to run tasks, sessions and worklets using INFORMATICA Workflow Manager (Version 8.6.1).
Reviewed ETL Design and construction deliverables for quality and accuracy.
-
EarthLink, Atlanta, GA
06/07 – 02/09: Senior ETL Architect
Position Function: ETL Architect / Development Lead
Re-Architected ETL environment.
Created High Level ETL Design for complex data load
Developed medium to complex ETL mappings using INFORMATICA PowerCenter (Version 7.1.1 and 8.6.0) as the ETL Tool.
Created workflows to run tasks, sessions and worklets using INFORMATICA Workflow Manager (Version 7.1.1 and 8.6.0).
Developed Workflows and Worklets
Mentored Junior ETL Developers.
Created ETL standards and best practices.
Developed change control process for Informatica production code change.
Built Data Models (Star Schema) that identifies the items to be stored in the Data Warehouse and define their structure and the relationships among them.
Created estimation model for project actualization.
Datalitix, LLC, Atlanta, GA
Consulting Assignments included:
Mirant, Atlanta, GA
10/05 – 06/07: Senior ETL Consultant
Position Function: ETL Architect / Development Lead
Developed ETL standards and best practices.
Designed and implemented strategies for ETL load and error handling.
Developed medium to complex ETL mappings using INFORMATICA PowerCenter (Version 7.1.1 and 8.1) as the ETL Tool.
Created workflows to run tasks, sessions and worklets using INFORMATICA Workflow Manager (Version 7.1.1 and 8.1).
Reviewed ETL Design and construction deliverables for quality and accuracy.
Developed medium to complex Informatica mappings.
Mentored Junior ETL Developers.
Developed change control process for Informatica production code change.
Created Project plan for Informatica migration effort.
Built Data Models (Star Schema) that identifies the items to be stored in the Data Warehouse and define their structure and the relationships among them.
Systems Evolution, Atlanta, GA
Consulting Assignments included:
AGLR/SAPIENT, Atlanta, GA
08/05 – 10/05: Senior ETL Consultant
Position Function: ETL Architect / Development Lead
Developed Informatica Mappings and workflows using PowerCenter and PowerExchange as a Proof of Concept (POC) to prove Informatica’s capability of real time processing to the customer.
ChoicePoint, Alpharetta, GA (Now LexisNexis)
02/05 – 08/05: Senior ETL Consultant
Position Function: ETL Architect / Development Lead
Developed medium to complex ETL mappings using INFORMATICA PowerCenter (Version 7.1.1) as the ETL Tool.
Created workflows to run tasks, sessions and worklets using INFORMATICA Workflow Manager (Version 7.1.1).
Developed custom logic within workflow for complex data load using UNIX shell scripting.
Developed library of reusable objects.
Mentored Junior ETL Developers.
Created and applied Informatica best practices.
Developed data enhancement transformations (driven by data quality initiatives).
Identified bottlenecks/errors during data loads and transformations due to requirement changes, unexpected data volume and data quality changes.
Developed and execute Unit Test.
Participated in preparing project plans for ETL projects by identifying milestones and assessing workload.
Cox Communications, Alpharetta, GA
11/04 – 02/05: Senior ETL Consultant/Senior Data Warehouse Consultant
Position Function: ETL Development Lead/Data Warehouse Analyst
Responsible for Requirement Analysis, Data Modeling and ETL Development on a new Data Warehouse Project (Cornerstone) to replace the financial source of the Enterprise Data Warehouse (EDW) from JD Edwards to Oracle Financials.
Performed requirement analysis to determine project requirements.
Analysed Source Data to ensure business requirement conformity.
Built Data Models (Star Schema) that identifies the items to be stored in the Data Warehouse and define their structure and the relationships among them.
Documented metadata for logical data models.
Led effort in developing ETL mappings for Cornerstone Project using INFORMATICA PowerCenter (Version 6.1) as the ETL Tool.
Created workflows to run tasks, sessions and worklets using INFORMATICA Workflow Manager (Version 6.2.2).
Designed data flow diagrams, detailed ETL module and job flow specifications.
Ensured that the data loaded into the warehouse has been cleansed and is accurate as appropriate to meet the informational requirements of the users.
Documented ETL methodology for easier access to code in the event of a potential future change.
Northrop Grumman IT, Raleigh, NC
Consulting Assignments included:
United States Postal Service, Raleigh, NC
01/03 – 11/04: Senior ETL Consultant/Senior Data Warehouse Consultant
Position Function: Project Manager/ETL Architect /ETL Development Lead
Led effort in developing source to target mappings for Corporate Data Acquisition Service (CDAS) for the United States Postal Service using INFORMATICA PowerCenter (Version 6.2.2 AND 5.1) as the ETL Tool.
Created workflows to run tasks, sessions and worklets using INFORMATICA Workflow Manager (Version 6.2.2).
Loaded data into Teradata RDBMS using Fastload.
Responsible for reviewing Business Requirement and assigning resources to project task accordingly.
Conducted Informatica training sessions to educate PL/SQL developers on the functionality of INFORMATICA PowerCenter® (Version 5.1) as an ETL Tool.
24/7 On call Production Support.
Exhibited expertise with Informatica Power Center, including a thorough knowledge of all the transformation functionality of the tool - reusable objects and building of
worklets and workflows.
Participated in reviews of data modeling and business requirement analysis for new development projects.
Evaluated, redesigned and modified existing mapping logic to improve overall session performance.
Modis IT
Consulting Assignments included:
GlaxoSmithKline, RESEARCH TRIANGLE PARK, NC
06/02 – 12/02: Senior ETL Consultant
Position Function: ETL Development
Developed mappings to convert in-house built ETL solution to the Informatica PowerCenter solution.
Implemented mapping-level optimization procedures to boost session performance.
Participated in the overall Administration of the Informatica Server and Client software, helping with configuration issues, version/release upgrades, backup/recovery strategies, and general design/implementation topics.
Led effort in the end-to-end design and development of ETL mappings to extract, cleanse, integrate, transform and load data into the data warehouse using INFORMATICA PowerCenter® (Version 5.1) as the ETL Tool.
Programmed changes to the data loads using Informatica PowerCenter® (Version 5.1) as the Extraction, Transformation and Load (ETL) tool.
Conducted Informatica training sessions to educate ETL development group on the functionality of INFORMATICA PowerCenter® (Version 5.1) as an ETL Tool.
MergeTech
Consulting Assignments included:
GE POWER SYSTEMS, MARIETTA, GA
04/02 – 05/02: Senior ETL Consultant/ Production Support Lead
Position Function: ETL Development/ Production Support
Defined 24/7 production support requirements for all ETL projects within GE contractual services. The requirements included: Remote Access, DBA Support, Network Support, Informatica Support, Migration Process, Failure Notification Channel, Change Control and Secure ETL Production Environment.
Designed ETL Mappings using INFORMATICA PowerCenter (Version 5.1.1) as the ETL Tool.
Developed ETL Production Support process flow. This defines, in a step-by-step fashion, the mechanism that would be applied in managing the ETL Projects in the production environment.
Developed error-handling procedures that would be used to determine the cause of session failures in the ETL production environment.
Created documentation for ETL Production Support policies and procedures.
Developed slide presentation for ETL Project Team.
DEUTSCHE BANK/MAXBLUE USA INC., NEW YORK, NY
03/01- 04/02: Assistant Vice President, Data Warehousing
Position Function: Data Warehouse Technical Lead/Architect
Led effort in the end-to-end design and development of ETL mappings to extract, cleanse, integrate, transform and load data into the data warehouse using INFORMATICA PowerMart (Version 4.7.2) as the ETL Tool.
Designed and developed a Marketing Data Mart that made marketing data readily accessible to the staff that needed it.
Designed Campaign Management Module for Marketing Campaigns.
Interviewed prospective candidates for technical positions available within the Data Warehouse team.
Frequent travel to Latin America (Brazil) to meet with Users so as to identify business rules and requirement for new business development.
Designed ETL module to track Customers’ Money Laundering Transactions.
Built Data Models (Star Schema) that identified the items to be stored in the Data Warehouse and defined their structure and the relationships among them.
Created Reports using Brio as reporting tool.
Created, query, modify ORACLE database tables, add and modify database data using SQL*Plus 8.1.6.
SAKS FIFTH AVENUE, DATA CENTER, LAWRENCEVILLE, NJ
01/00-03/01; Senior Data Warehouse Consultant
Position Function: Data Warehouse Development.
Worked closely with Business Members, and other Data Warehouse Project Team Members to define business rules and requirements.
Responsible for the end-to-end design and development of ETL mappings to extract, cleanse, integrate, transform and load data into the data warehouse on a UNIX platform.
Designed data flow diagrams, detailed ETL module and job flow specifications.
Created, added, and modified data warehouse tables, using SYBASE SQL Advantage 11.5.1.3, as query tool.
Programmed changes to the data loads using Informatica PowerMart (Version 4.7.2) as the Extraction, Transformation and Load (ETL) tool.
Identified source systems data structures, syntax, and semantics, and translated those to corresponding specifications for data warehouse.
Assisted users in extracting information for Data Warehouse.
Interacted with users to determine requirements for new development.
HIGHLAND TECHNOLOGIES, INC., LANHAM MD
10/98-01/00; Software Engineer
Position Function: Data Warehouse and Data Modeling Development.
Designed data models that effectively represented the business requirements, which facilitated the use and sharing of data across the company.
Programming changes to the data loads using DataStage Versions 3.5.2 and 3.6.2as the Extraction, Transformation and Load (ETL) tool.
Programming changes to the data loads using Informatica PowerMart (Version 3.5) as the Extraction, Transformation and Load (ETL) tool.
Participated in JAD sessions.
Designed data flow diagrams, detailed ETL module and job flow specifications.
Constructed normalized and denormalized models of warehoused data.
Built Data Model that identified the items to be stored in the Database and defined their structure and the relationships among them.
Produced conceptual, logical data models including both entity relationship 3rd normal
form models and dimensional (star) models.
Developed logical and physical data models for ORACLE RDBMS utilizing IDEF and CADM methodologies in Erwin and Oracle Designer Case tools respectively.
Enforced and maintained database constraints to ensure database integrity.
Created, queried, modified ORACLE database tables, added and modified database data using SQL*Plus 8.0, the Oracle command line SQL environment
MULTI COMMUNICATION SYSTEMS CORP. BOWIE, MD
3/96 –10/98; Database Designer/ Modeler
Position Function: Database design
Worked with EDM (Enterprise Data Model) Group to understand standards and processes for the creation-maintenance of various data models
Assisted with requirement analysis to determine information requirements.
Produced logical data model for project and documented it using a CASE tool.
Developed physical data model that was later translated to a physical database by the DBA.
Designed ERD for processes intended for database design. Performed data Normalization on models.
Analyzed models for performance.
Documented metadata for logical data models.
Enforced and maintained database constraints to ensure database integrity.
Trained the system developers on the data model and assisted in resolving design issues.
Worked with data owners and established update processes and agreements.
Developed Database Applications using Oracle Developer 2000, Forms 4.5 and SQL*Plus on Windows NT 4.0 platform.
Created database objects, using SQL*Plus 3.0 as the development tool.
EDUCATION
University of Maryland University College, College Park, MD
Major – Information Systems Management.
Degree: Bachelor of Science
University of Lagos, Lagos, Nigeria
Major – Business Administration
Degree: Bachelor of Arts
INFORMATICA CORPORATION, Bellevue, WA
Diploma – Informatica Powermart and Powercenter 1.7, 2000
Emphasis: ETL Mapping Design/Performance Tuning
Computer Learning Center (CLC), Laurel, MD
Diploma – Client/Server Programming, 1998
Emphasis: Relational Database Design, Object Oriented Programming
MCS, McLean, VA
Data Modeling Certificate, Oracle Developer Certificate, 1996
Emphasis: Data Modeling, SQL, PL/SQL
IMMIGRATION STATUS: US Citizen
References available upon request.
Contact this candidate