PROFILE:

Confidential ’s career as an IT Specialist spans many industries with extensive BI experience working within Confidential Global Business Services’ (GBS) Application Services and Enterprise Data Warehousing for BI Reporting in Confidential . During his 13+ years Confidential experiences, he has supported numerous Business Intelligence Confidential web applications. He came to Confidential as an ETL consultant building custom ETL to load a newly normalized data warehouse. In that capacity, he assumed the team lead role and provided guidance to the ETL team in best practices. Mr Moore has worked through all project phases of design, development, testing and deployment and support. He has used numerous project methodologies, with the latest methodology being AGILE where ETL deliverables can fit overall project planning. His background in System Engineering Architecture & Test gave him the ability to identify defects early, decrease time to project completion and increase quality of application development. Confidential is adept using technical tools in many capacities with ability to rapidly learn their function and become the expert in their use. Using these tools he has provided validation and traceability of business, system and component requirements. Confidential ’s clients have praised his knowledge of data warehousing and ability to motivate teams by sharing his technical knowledge and experience of system engineering, data modelling, data migration, ETL and programming design techniques.

KEY SKILLS:

• Extensive experience in Datastage (v7.5.2 and 8.1) (Design/Develop/Debug/Administrate)
• Informatica (v9.6.1) PowerCenter - installation and administrator
• Informatica (v9.6.1) PowerExchange - installation and administrator
• Confidential Change Data Capture (v6.5.2) - installation and administrator
• PL1/ with embedded SQL (data migration)
• DB2 v9.5 / Oracle 11g/12c /SQL
• Data Modelling (ERwin, Confidential s Rational Data Architect)
• Strong background in RDBMS DW/Datamart/ODS concepts
• Strong software engineering and data analysis abilities
• Strong programming, software design, and debugging skills.
• Experienced QA/Production implementation with analysis, problem solving and support
• Excellent communication skills (written and verbal)
• Interaction with customer team and offshore ETL Developer resources

PROJECT METHODOLOGY:

AGILE

Waterfall

Systems Development Life Cycle (SDLC)

System Engineering and Architecture (SE&A)

ASSIGNMENT HISTORY:

Confidential

Responsibilities:

• Created ETL requirements, designed, coded, tested, and deployed ETL processes loading DW.
• Implemented multi-level validations for data accuracy and cleansing. Acquisition of lending companies utilizing 3rd Party vendor POS provided additional data streams to the EDW.
• Implemented Confidential Change Data Capture technology against OLAP database.
• The company is transitioning for Datastage to Informatica and am heavily involved in its installation/configuration and development using PowerCenter and PowerExchange.

Confidential

BI Enterprise Information Decision Enablement

Responsibilities:

• Supported simultaneously, ETL development for two BI Web Applications, one a worldwide marketing alignment program (MAP) using DB2 datamart of historical revenue, model business aspirations and client information to improve resource allocations iteratively by Geo/Region releases using AGILE Project Methodology.
• The second BI web app was built using data from MAP for managerial ability to optimize sales employee territories.
• Created, tested and deployed Datastage code, Unix Shell Scripts, performed data analysis using Squirrel, DB2 or Rational Data Architect (RDA), and Datastage project administration.

Confidential

ETL Development Lead

Responsibilities:

• Implement a worldwide Maintenance Agreement (MA) datamart to hold identified MA opportunities for Reporting. Iterative Geo/Region releases using AGILE Project Methodology.
• Created ETL Design Specifications, leading Off-shore Datastage development team by holding code reviews, performed data analysis using BRIO, DB2 for data quality and testing validation.

Confidential

Data Architect

Responsibilities:

• He has identified data requirement needs across applications addressing security access and functionality.
• He created logical and physical data models for CACTUS project using Rational Data Architect.
• Confidential has researched several technical solutions to use in data migration and transformation for multiple data repositories in an automated manufacturing environment;
• He proposed designing high level architecture use of Datastage to meet Confidential Corporate ETL recommendations.

Confidential

Systems Engineer

Responsibilities:

• worked on project to provide telesales support for Confidential 's i, p, & x series servers.
• He performed analysis and identified business and system requirements needed across 16 applications for functionality.
• Assisted in implementing RequisitePro use managing business and system requirements.
• Responsible for support, maintenance and publication of data models using CA Erwin modelling software, Lotus Word Pro/123/Freelance defining table/view/index definitions to implement on DB2 database.
• Utilized DB2 Data Propagator as ETL method of data flow defining extract criteria of SAP Fulfilment Operational Data Store (FODS) source data and other upstream customer and product applications.
• Enhanced business reporting needs by analysing performance through running Explain plans to tune SQL queries.

Confidential

Technical Team Lead

Responsibilities:

• Designed and implemented manufacturing and shipping ETL feeds to data warehouse for warranty fraud reduction. maintenance contracts, consumer registration from Lotus Notes db, proof of purchase & shipping data feeds into the DW used in validating PC’s warranty.
• Designed/created batch processes defining unique configuration values for components comprising machine by defining DB2 tables and writing embedded SQL PL/1 programs. I was responsible for the application’s DB2 database access and security(RACF). Maintained quality assurance of application changes and installs by holding peer reviews to capture defects before deployment.

Senior ETL Manager

Confidential, SC

Responsibilities:

• Installed, configured and support Confidential ’s Change Data Capture v6.5.2 (CDC) capturing daily delta mining OLTP Oracle archive logs and populate staging database.
• Administer security access to Datastage v8.1.
• Develop and test shell scripts used in ETL data flows.
• Designed data flow documentation with generic data and process exception handling during extract, transforming and loading.

Lead ETL Developer

Confidential, SC

Responsibilities:

• Setup security access to Confidential InfoSphere Server DataStage v8.1 as administrator on Unix platform extracting and loading Business Intelligence Oracle 11g data warehouse.
• Providing detail requirement specifications and coordinating peer code reviews before deployment.
• Perform code deployment and production support.

ETL Developer, System Engineer

Confidential, Raleigh, NC

Responsibilities:

• Developer Lead and Datastage administrator using Datastage 7.5.2 and v8.1 on Unix platform extracting and loading DB2 Databases.
• Lead team of offshore ETL developers providing details requirement specifications and coordinating code reviews for deployment.
• Performed configuration management code deployment and production support.