SUMMARY:

• Over 30 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.

TECHNICAL SKILLS:

Databases: Oracle DBMS ; MySQL, MS SQL

Languages: JEE; Java, JSF, SQL, PL/SQL, Java Stored Procedures, XML, HTML

Development Tool: Informatica,, ODI, OWB, CDC

WebServers: Tomcat, Glassfish, PrimeFaces, JSF

CaseTools: Erwin, Designer/2000, S - Designer, Toad, ER Studio

Frameworks: Hibernate, JPA, Spring

PROFESSIONAL EXPERIENCE:

Confidential

Systems Engineer/Lead Data Management

• Created a data Taxonomy based on analysis of the legacy data;
• Created a data Ontology to integrate the Data Taxonomies;
• Created a canonical data model based on an the exhaustive definition of a concept;
• Designed a data repository for management of OLTP, OLAP and DW models;
• Researched the benefit of NoSQL and its applicable use;
• Interviewed incoming vendors based on their proposed Confidential ;
• Designed and presented a case for IPAAS as a Confidential for the future;
• Developed Restful Web Services;
• Managed the Data team activities;
• Extracted legacy data, and loaded cleansed data into the MySQL Schema;

Confidential

ETL Data Architect

Responsibilities:

• Performed a Data Taxonomy on the SEC legacy data models;
• Performed a data quality analysis on the enterprise collection of data;
• Provided and documented guidelines on a MDM Confidential based on desperate systems.
• Designed a universal data model to serve as the hub for a MDM Confidential ;
• Designed Integrated and Operation Data Stores for data movement;
• Designed subject specific data cubes to support business reporting;
• Designed Star and Snowflake data warehouse schemas;
• Performed a Data Taxonomy against the desperate systems to expose candidate subjects;
• Developed Java/PL/SQL validation methods;
• Created mapping documents to detail source to target operations;
• Developed ETL methods via Informatica to move data from source to target;
• Designed transformation and cleanings methods to address data anomalies;
• Vetted data transformation rules with the ETL developers and data stewards;
• Designed and built data and event driven data models;

Confidential

Data Architect

Responsibilities:

• Created Star-Schema designs for the Data Warehouse;
• Created mapping documents to detail source to target data migration;
• Performed data profiling tasks with Informatica Data Quality;
• Exposed and discussed data profiling anomalies with the data steward;
• Performed a taxonomy analysis against the legacy system;
• Presented observations/evaluations applicable to data governance concerns;
• Designed declarative and data driven OLTP data models;
• Evaluated the potential use of Oracle’s internal CDC process;
• Wrote a collection of java and PL/SQL methods to support the business rule processing;
• Created ODI mappings to execute ETL

Confidential,VA

Enterprise Architect

Responsibilities:

• Analyzed business requirements for clarity and completeness;
• Performed data model walk-through to evaluate consistency with industry practices;
• Created/Delivered Semantic, Conceptual, Logical and Physical data models;
• Designed OLAP and OLTP data models;
• Used Informatica to upload incoming text files into the database;
• Participated in agile group working sessions;
• Participated in data mining sessions to identify data behavior.
• Created dimensional models segregated by subject domain area;
• Wrote PL/SQL methods to process data for evaluation;
• Designed and developed user interfaces via APEX to view data;
• Performed data profiling activities;
• Setup an Oracle CDC model to study source to target data movement;

Confidential

Solution/Application Architect

Responsibilities:

• Analyzed business requirements for clarity and completeness;
• Discussed and implemented an approach to build for cloud computing;
• Created/Delivered Semantic, Conceptual, Logical and Physical data models;
• Worked with the Stakeholders to map business requirements to data concepts;
• Designed/Created/Delivered road map documents for upper management;
• Participated in proposal writing for new projects;
• Conducted candidate interviews for new hires;
• Participated in staff forecasting for new projects;
• Lead Agile(Scrum) group working sessions;
• Created dimensional models segregated by subject domain area;
• Created source to target mapping documents for ETL activities;
• Created work flow models to ETL execution;
• Created an ETL designed for data transition and reporting;

Confidential

Application Architect

Responsibilities:

• Evaluated/Reported my assessment on the state of the current Intranet applications;
• Recommended Hardware and Software tools to the stakeholders;
• Analyzed business requirements for clarity and completeness;
• Participated/created road map strategies for short and long term business success;
• Revised business requirement to achieve an agile environment;
• Participated/defined SCRUM activities;
• Created/delivered PowerPoint presentations for management;
• Designed/presented information models to expose opportunities for the business;
• Participated in proposal writing for future work;
• Created/delivered Semantic, Conceptual, Logical and Physical data models;
• Installed and configured the Glassfish Application Server;
• Created Java POJO for data access methods;
• Created data access methods using JPA services;

Confidential

Lead Data Architect

Responsibilities:

• Managed a team of 15 Data Architects and DBAs;
• Defined techniques to tune SQL statements for better performance;
• Converted legacy data structures to OLTP and OLAP designs;
• Evaluated the Enterprise’s Conceptual, Logical and Physical models;
• Designed data repositories based on HL7 requirements;
• Created dimensional models segregated by subject domain area;
• Created agile, flexible and extensible data models;
• Reviewed/Created several Data Management Plans;
• Conducted interview sessions to hire new employees;
• Created PL/SQL procedures and triggers to process data;
• Created a data taxonomy to assist in mapping source to target data;
• Created Informatica mapplets to move data;
• Created transformation methods for data;
• Performed data profiling to better understand the behavior of the system;
• Performed data mining exercises to expose business behavior;

Confidential,MD

Enterprise Architect

Responsibilities:

• Defined the Role of the Confidential within the data Management support group;
• Provided input into the Enterprise Confidential methodology;
• Served and orchestrated the Data Tier team for software development;
• Created and edited Database Design and Interface Control Documents;
• Analyzed process behavior and data usage for MDM analysis;
• Recommended and implemented solutions that minimized process and data redundancy;
• Elicited the business story to better understand their requirements;
• Served as the lead Confidential of several design strategies;
• Conducted sprint sessions and performed retrospective activities to determine progress.
• Identified reference/master data anomalies for the business to resolve through work sessions.