We provide IT Staff Augmentation Services!

Systems Engineer/lead Data Management Resume

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

Responsibilities:
  • 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.

Hire Now