Description
Qualification Summary Over 28 years of experience in IT. My contributions include deriving solutions for my customer's data management needs. Developed data taxonomies to help the client better understand to true nature of their data assets. Exposed known and unknown data assets not correctly managed. Provided design enhancement to facilitate better user interface to data management. Enabling Technologies Experience Summary Career Summary Concept PLUS 08/2015 - 02/2016 ETL Data Architect, Fairfax, VA (Oracle, MS Office, Informatica, Agile (SCRUM), Toad Data Modeler, ER Studio, APEX) * Performed a Data Taxonomy on the SEC legacy data models * Designed a OLTP and OLAP Universal data model based on the Taxonomy findings * Collaborated and presented the data models designed for SEC * Developed PL/SQL methods to perform data extraction task from source to target * Created mapping documents to detail source to target operations * Created canonical data models to assist in data concept exploration * Created project Road Maps for team direction * Developed ETL methods via Informatica to move data from source to target * Designed transformation and cleanings methods to address data anomalies * Used Oracle APEX to design UI to expose data to the User for corrections Astor and Sanders 10/2014 - 03/2015 Data Architect, Rockville, MD 20850 (Oracle, MS Office, Informatica, OWB, Toad) * Collaborated on OLTP, OLAP and ETL designs * Created mapping documents to detail source to target data migration * Created canonical data models to assist in data concept exploration * Participated in staff forecasting to perform certain IT services * Identify reference data and structures for Master Data Management * Evaluated the potential use of Oracle's internal CDC process * Wrote a collection of PL/SQL methods to support the business rule processing * Created Informatica workflows to execute ETL * Designed and developed user interfaces via APEX to view data Career Summary Concept PLUS 08/2015 - 02/2016 ETL Data Architect, Fairfax, VA (Oracle, MS Office, Informatica, Agile (SCRUM), Toad Data Modeler, ER Studio, APEX) * Performed a Data Taxonomy on the SEC legacy data models * Designed a OLTP and OLAP Universal data model based on the Taxonomy findings * Collaborated and presented the data models designed for SEC * Developed PL/SQL methods to perform data extraction task from source to target * Created mapping documents to detail source to target operations * Created canonical data models to assist in data concept exploration * Created project Road Maps for team direction * Developed ETL methods via Informatica to move data from source to target * Designed transformation and cleanings methods to address data anomalies * Used Oracle APEX to design UI to expose data to the User for corrections Astor and Sanders 10/2014 - 03/2015 Data Architect, Rockville, MD 20850 (Oracle, MS Office, Informatica, OWB, Toad) * Collaborated on OLTP, OLAP and ETL designs * Created mapping documents to detail source to target data migration * Created canonical data models to assist in data concept exploration * Participated in staff forecasting to perform certain IT services * Identify reference data and structures for Master Data Management * Evaluated the potential use of Oracle's internal CDC process * Wrote a collection of PL/SQL methods to support the business rule processing * Created Informatica workflows to execute ETL * Designed and developed user interfaces via APEX to view data
Accomplishments
Highlights:
Keywords
