Key Skills Details

Industry Experience

  • 25+ Years Banking and Finance  
  • 4+   Years Automotive 
  • 4+   Years Manufacturing and Distribution
  • 2+   Years Healthcare and Insurance 
  • 2+   Years Retail

Data Architecture

  • 18+ years as a Data Architect, leading & supporting DBA, ETL, UI, BA, Data Modeling and Report development
  • 20+ years in advanced data modeling skills including CDM, LDM and PDM including ODS, EDW and OLTP
  • 20+ years Both Relational (Inmon) and   Dimensional (Kimball) and when to use which.  Application of correct Normal-Form when   needed and understanding when to use correct de-normalization techniques 
  • 20+ years guiding and helping clients set,   design and implement their data operations and analytics needs
  • 20+ years creating data quality test cases   and writing complex SQL Scripts to review millions of data points
  • 10+ years supporting data governances and   master data management for various projects
  • 15+ years creating metadata documents including   data dictionaries, domain of values and reference data.
  • 18+ years creating db views, stored   procedures and functions to reduce complexity and increase reusability
  • Work, support and lead ETL teams in creating   advanced ETL Logic including CDC, snapshot loads, update in place, and   history management. 
  • 20+ years facilitating JAD sessions, gathering   and documenting business requirements and transforming business requirements   to technical requirements / specifications.  Creating and documenting data project and   data standards including technical names and classwords.
  • 20+ years creating technical design specifications   and architecture documentation including data flows, source to target mapping   and transformation rules.
  • 20+ years providing or leading QA testing of   accurate data movement including creation of simulated data to test all rules   in the process. Also provided repeatable processes to assist in continual   data validation.
  • 17+ years with IBM’s BDW and FLSDM. This   includes leading teams on the implementation of the model; scoping the model   to fit client's needs; providing in-house training on the BDW and advance   modeling techniques; delivering scoped BDW LDM an implementable PDM; mapping   source to BDW; guiding ETL on how to load the BDW; Bus Matrix Mapping and   reporting on how querying implemented BDW

Data Management Tools

Data Modeling

  • 20+ Years With Erwin
  • 4+ Years With ErStudio
  • 3+ Years With Oracle Designer
  • 20+ Years With Visio

Database (RDBMS)

  • 20+ Years With SQL Server
  • 20+ Years With Oracle
  • 10+ Years With Teradata
  • 5+ Years With Neteeza
  • 10+ Years DB2/UDB
  • 10+ Years DB2
  • 5+ Years Informix

Leadership

  • Facilitate training sessions for IBM’s   Banking Data Warehouse, Data Modeling ‘101’ as well as designed and planned   architecture. 
  • Project Roadmaps, estimates and detail   tasks/plan
  • Thought leadership – align with best   practices and meet and exceed client expectations
  • Create solutions that are flexible,   extendable and reusable over time
  • Lead other data teams (ETL, DBA, Modeling,   Reporting, Project Management) to ensure business requirements are met and   are consistent and accurate
  • Communication with all team members   including “C” level executives. 
  • Facilitate training sessions for IBM’s   Banking Data Warehouse, Data Modeling ‘101’, and knowledge transfer sessions.
  • Worked   extensibility with various project management methodologies including   waterfall, iterative and Agile.