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.