Financial Services Enterprise Architect

SUMMARY:

•**+ years of Technology experience, most of it as Teradata specialist, in various Architect roles for Banks & Financial services with a focus on Capital Markets, Insurance, Health care, Pharmaceutical, Manufacturing, Data Providers, Entertainment and other domains.

•Data Vault 2.0 SME (Subject Matter Expert) with experience of multiple years.

•Migrated 3NF DBs to combination of Kimball Dimensional DBs and Data Vault 2.0 for Big Banks such as Wells Fargo and Citi for multiple domains including Asset Management and Wealth Management with Exabyte DBs and 96 subject areas and 2080 entities/tables.

•Competent Enterprise Architect, with strong command in Data Strategy, Data Governance ETL, ELT, Data Architecture, Solution Architecture, Integration Architecture and Road maps.

•Multiple years of experience migrating on-premise data and applications to Azure, AWS and GCP.

•Multiple years of experience working on various IBM BDW & Teradata iLDMs (Industry specific Logical Data Models ). 8 years mLDM (Manufacturing LDM), 8 years LDM (Communication LDM),10years rLDM Retail LDM) etc.

•10 years as Senior Manager / Director of Enterprise Architecture and 15 years as Senior Enterprise Architect in Banking & Finance and other domains

•Big Data expert and enthusiast, with expertise in java, Node.js, Cassandra, Cloudera, Horton works, MongoDB, Hadoop, HDFS, Map Reduce, Spark, Hive, pig, impala, CI/CD, GitHub, Kubernetes, IoT, and TDD

•Experienced in AWS, AWS Lambda, Redshift, S3, EC2, Azure, Azure SQL, Azure Serverless, Graph DB – Neo4j, and Gremlin.

•Expert in Data Warehouse design and implementation using Columnar Database technologies such as Teradata (Columnar DB Option), Oracle 12c and Sybase IQ. (These products have capabilities similar to Vertica).

•15 years of Lead Teradata DBA experience for Production and Development

•Competent in both Inmon and Kimball approaches to Data Warehousing.

•10 years experience in creating Roadmaps for complex Data warehouse implementations, Operational Data Store (ODS), BI implementations, specializing in Teradata and Oracle based solutions for cloud environments including Azure, AWS, GCP and Oracle.

•15+ years experience in Data Warehousing as an Enterprise BI/Data Architect and Solution Architect with a primary focus on 3rd Normal Form and Dimensional Modeling on Teradata and Oracle based solutions.

•10 years experience in Design, development and maintenance of ETL code, definition and capture of metadata and rules for ETL, definitions and development of ETL Validation code, and Source system analysis and profiling on Teradata Enterprise Data Warehouses.

•Expert in communicating with Business Users and gathering requirements

•Expert in Teradata and Oracle development including query performance tuning and debugging

•Expert in all aspects of Business Intelligence and Data warehousing including ETL, Data Modeling, LDM, PDM, Normalization, de-normalization, Star Schema, Snow Flakes, design of Fact tables, and Dimension Tables, designing data marts, designing aggregate tables and designing metadata repository.

EDUCATION:

M.S., Electrical and Computer Engineering 1989

University of Arizona Tucson, Arizona Focus on AI, Expert Systems and Machine Learning

B.S., Computer Engineering 1986

University of Arizona Tucson, Arizona

SPECIAL RECOGNITION AWARDS:

Received Recognition in Training IBM, Tucson employees in using Artificial Intelligence technologies. 1988

Received Recognition for helping the Big Brothers Organization of Plano Texas. 2005

Received recognition for contribution to NASA’s Space station research regarding Robotic Identification of Objects, as part of University of Arizona NASA Research Project Team 1987-1989.

Received award from Citi Group for Teradata implementation of IBM BDW and Teradata fLDM (Financial Services Logigal Data Model) in record time. Migrated 3NF DBs to combination of Kimball Dimensional DBs and Data Vault 2.0 for for multiple domains including Asset Management, Mortgage, Stock Trades, Wealth Management and Commercial Bank divisions.

EXPERIENCE:

7/19/21 to JadAI

Present Principal Enterprise Data Architect

•Leading Generative AI organization

7/19/21 to CDW - Sirius

6/28/2024 Managing Consultant – Data Practice / Principal Enterprise Data Architect

•Designed and delivered best-in-class Data solutions for CDW-Sirius clients.

•CDW-Sirius and the client teams respected my excellent communication abilities for providing the best service and leadership to the clients.

•Lead client Discovery, Assessment and implementation assignments including presentations to Senior/ Executive Management and Technical teams of the clients. Most of Discovery and Assessment assignments were converted in long term client engagements for sizable teams.

•Responsible for planning, directing, and coordinating activities of designated Data projects and subcontractors along with managing team financial objectives through efficient SOW delivery and early escalation of potential change requests.

•Worked with other consulting and sales colleagues to develop a “trusted advisor” relationship with clients for further penetration into accounts for follow-on sales.

•Lead projects as Subject Matter Expert in technologies such as Data Vault 2.0, Inmon 3NF, Kimball Dimensional Model, Gen AI, IBM BDW (Business Dat Warehouse), Teradata fLDM (Financial Services Logigal Data Model), Cloudera, Snowflake, DB2, SQL Server, Oracle, Erwin, ER-Studio, AWS, Azure GCP, Redshift, Synapse, BigQuery, IBM BDW, IBM Salefish, Python, LogicApps, Databricks, AI & Machine Learning, and Gen AI based on Azure and Nvidia.

•Lead Modern Data Platform design and implementation for clients in multiple industries with a focus on Banking & Financial Services and Healthcare, including migration from On-prem EDW to Snowflake, Redshift, Synapse and BigQuery, and met billable utilization targets

•Interacted with clients, sales personnel and Sirius Presales Architects to identify, qualify, and validate client requirements for technology solutions.

•Conducted research & development work targeted to create frameworks, utilities, or best practices to enhance the efficiency and quality of client delivery efforts along with developing best practices, strategies, methodologies, and documentation.

•Engaged in professional development, including obtaining industry related certifications as directed by management, to maintain continued growth in professional skills and knowledge

12/31/15 to Wells Fargo

7/5/21 Senior Cloud Architect / Senior Enterprise Data Warehouse Architect/ Senior Enterprise Architect

•Created end to end enterprise level solutions

•Lead Architect for architecting and implementing Teradata fLDM (Financial Services Logigal Data Model) in record time using Data Vault 2 for Mortgage and Wealth Management organizations.

•Analyzed current state and target state, and performed gap analysis for enterprise architecture. Listed all possible solutions for the project and recommended the best option. Created roadmaps for the solutions. Implemented the solution using help from Offshore.

•Created data strategy, data acquisition from source systems, data integration, ETL/ELT, data governance, Metadata, and Master Data solutions.

•Did research to identify possible approaches for various technical problems, provided pros and cons, and the recommendations for the best approach.

•Created data models, physical database structures and SQL scripts, using Power Designer and Teradata SQL Assistant, for MIDE DEV, SIT, UAT and PROD environments on Teradata platform.

•Designed and implemented data pipelines using Python, Java, Cloudera, StreamSets. Azure Data Factory (ADF) Wherescape, Informatica, Talend, AWS Data Pipeline, and DAG.

•Designed and implemented Capital Markets solutions using Kafka, Apache Spark, and NoSQL (Cassandra).

•Created and maintained Teradata Utilities scripts, such as FastLoad, FastExport, and MultiLoad.

•Used Teradata Administrator, Performance Monitor (Pmon) and SQL Assistant on Unix machines for data administration, performance tuning and research.

•Create Data Science, Machine Learning and. AI solutions using KNIME, Python, R, SAS, Tensorflow and H2O, for use case such as Fraud analytics, Stress testing and Regulatory analytics.

•Migrated on-premise data and applications based on SQL-Server, Oracle and Teradata to AWS, GCP and Azure based on LOBs technology stacks using CI/CD and TDD.

•Automated Data Warehouse creation and maintenance using Wherescape.

06/09/14 to Best IT

11/15/15 Senior Enterprise Architect

•Created Strategies for Best IT to secure new business from existing customers, and signing up new customers; while demonstrating excellent communication and organizational skills, and handled some tough customer situations.

•Provided leadership on Data Strategy, ETL/ELT, Data Governance, Metadata, and Master Data.

•Provide Enterprise Architecture services. Along with analyzing current state and target state, performed gap analysis. Provided roadmap for the solutions. Implemented the solution using help from developers.

•Migrated on-prem data and applications to AWS.

•Designed ad implemented Data Science, and Machine Learning AI based Capital Markets and Mortgage solutions using KNIME, Cloudera, Python, R and Spark.

•Designed and implemented Enterprise Data Warehouse architecture in Teradata, Oracle and SQL Server.

•Designed and implemented SaaS, IaaS and PaaS solutions for Best IT clients, on AWS and Azure cloud services.

•Lead team of Data Stewards of Customer, Product and Account data for Best IT clients.

•Created and maintained Business Glossary for Best IT clients.

•Utilized Teradata Administrator, Performance Monitor (Pmon) and SQL Assistant for data administration, and performance tuning.

•Utilized Explain, Stats collection, Skew factor analysis and Row Distribution for performance analysis and tuning. Established optimal indexing, especially Primary Index.

•Clients in my portfolio include Wells Fargo, Rebuilders Automotive Supplies, LogistiCare and Allen Parish Hospital.

01/13/14 to Orion Health

05/23/14 Principal Enterprise Data Warehouse Architect

Scottsdale, AZ

•Created Strategies and Roadmaps for clients.

•Migrated on-prem data and applications based on Oracle and SQL to AWS, and Azure.

•Designed and implemented Enterprise Data Warehouse architecture in Oracle Exadata.

•In-charge of data related design activities for Blue Shield of California Project

•Creating Enterprise Operational Data Store (ODS).

•Implemented Orion Data Platform, Clinical Portal and Patient Portal solutions using full stack development, java, Kafka, Cloudera Apache Spark, and NoSQL (Cassandra).

07/15/13 to Toyota Financial Services

12/24/13 Enterprise Data Architect / Enterprise Data Warehouse Architect

Torrance, CA

•Designed and implemented Enterprise Data Warehouse architecture in Oracle.

•Created Enterprise data elements naming standards including Prime Words, Modifiers and Class Words and associate abbreviations using ERWin.

01/10/11 to Cognizant

7/8/13 Senior Manager / Senior Data Warehouse Architect

•I worked for Cognizant from 1/10/11 to 7/8/13

•Listed below are the project assignment details with Cognizant Clients.

Client: Citi

Jersey City, NJ

•Responsible for End to End Data Modeling and Database Design of critical and Highly visible Citi Program.

•The data modeling tool was Erwin.

•Lead a team of 8 onsite and 12 offshore resources

•Designed and implemented, Retail Banking, Commercial Banking and Capital Market solutions using internal and external data sources such as Moody’s, Fitch and Experian.

•Designed and implemented Enterprise Data Warehouse architecture in Teradata.

•Created Strategy and Roadmap for Applications providing the source data, ODS and EDW.

•Responsible for Logical and Physical Modeling, as well as query generations for various TIBCO services.

•Lead the efforts to create Logical and Physical data model compliant with IBM Banking Data Warehouse (BDW), similar to Teradata fsLDM (Financial Services Logical Data Model).

•Designed big data and relational platform solutions with data stored on Mongodb, Cassandra and Oracle, using Java and Spark.

Client: American Express

Phoenix, AZ

•Participated in creating response to RFPs on behalf of Cognizant.

•Managed a team of 10 onsite and 14 offshore resources.

•Did extensive research on Basel II to be able to handle potential upcoming Basel II related projects.

•Created Source to Target Mapping requirements for ETL Jobs.

•Created Normalized and Dimensional models. Dimensional models were created for Business Intelligence Reporting.

•Used ER Studio 8.5 for Data Modeling

01/10/09 to CONSULTING / Various Clients

12/31/2010 Contractor

American Express

Senior Data Architect

Phoenix, AZ

•Created Data Models and Data Architectures for multiple large scale projects.

•The primary modeling tool was E/R Studio Architect Version 8.5.3

UST-Global

Senior Teradata Architect

Safeway, Pleasanton, CA

•Managed Onsite and offshore Enterprise Architecture and Delivery teams.

•Led efforts for Teradata to Netezza migration.

•Led meetings with the client to understand their business and technical requirements.

•Researched the optimal Data Model Tool among ERWin, E/R Studio and IBM Architect.

•Selected the ETL methodology (between Data Stage and Teradata Utilities Scripts+ Shell scripts) for the initial historic data load and CDC / incremental load.

05/28/07 to TATA CONSULTING SERVICE

11/24/08 Director of Enterprise Architecture / Client Consultant

Apple Computer, Cupertino, CA

•Managed the teams of Enterprise Data Architects, Solution Architects, Data Architects, Application Architects and Teradata / Oracle DBAs. The total team size was 24.

•The Data Modeling tool was ERWin.

•Customized Teradata’s MLDM (Manufacturing Logical Data Model) for Apple Computer Manufacturing requirement, primarily for iPhone.

•Studied the requirements for the Teradata Disaster Recovery Project, and made recommendations for optimal D/R plan.

•Utilized tools such as Teradata PMON, BTEQ, MLoad, Fload, Tpump, Archive recovery, Teradata Manager.

•Used Golden Gate for replication.

Johnson & Johnson – Morris Plains, NJ

•Managed a team of 10 direct reports.

•Studied the current architecture of five large/major applications.

•Made improvement recommendations.

•Assessed the Resource and Skill Level needs to support these applications with TCS teams onsite, and offshore in Uruguay and India.

•The data warehouse was implemented using Teradata infrastructure.

•Designed mLDM (Manufacturing Logical Data Model) using ERWin for Johnsons & Johnson for Consumer Health Product manufacturing.

Sony Pictures Entertainment

•Managed Teradata DBA and Business Intelligence Architects.

•Lead the Migration project to migrate from DB2 to Teradata.

•Responsible for performance, and successful daily operation of the new Teradata environment.

•Provided tuning for poorly performing queries.

•Lead performance trending and analysis including recommending indexing strategies, partitioning, compression opportunities and statistic collection planning

•Successfully deployed scheduler to manage ETL jobs.

•Created Logical Data Models for the Dimensional models of multiple subject areas.

•Worked with Sony Picture Entertainment Business Analysts and Data Architects to complete the LDM for Vendor Managed Inventory (VMI) and Sales Planning projects, and participated in the conversion of the LDM into Physical tables.

•Made major performance enhancements. For example, in one instance I improved the query performance from 8hrs to 5 mins. In another instance I improved the query performance from 10 mins to 40 secs.

06/05 to CONSULTING

03/07 Contractor / Lead Data Architect

DHL

•Provided Lead Teradata DBA services for the Development and Production Teams.

•Used ER Studio to created LDMs and PDMs for Oracle and Teradata databases.

•Provided lead DBA support to Development, Test, UAT, and Production Teams. Helped in the effort to migrate large applications with 1.5 Terabytes of Data from the Scottsdale data center to the Prague data center.

•Made use of Teradata PMON, BTEQ, MLoad, Fload, Tpump, Archive Recovery, Teradata Manager, Bulk Load, CLI, TDP, and mTDP.

•Designed ETL & Services architectures for data integration.

03/2000 to UNIVERSAL SOLUTIONS, INC Phoenix, AZ

05/2005 Director of Enterprise Architecture

•Lead Teradata DBA for Production and Development Teams

•There were 15 direct reports.

•Created Teradata cLDM based solutions. Lead DBAs team for physical implementation.

•Completed mLDM design and Physical implementation for various Teradata customers.

•Used ERWin for mLDM design

•Lead multiple projects migrating from Oracle and DB2 to Teradata.

•Used Teradata PMON, BTEQ, MLoad, Fload, Tpump, Archive Recovery, Teradata Manager, Bulk Load, CLI, TDP, mTDP and other Teradata tools.

•Lead multiple Dimensional Modeling and MDM projects.

•Lead ROI, Cost Benefit Analysis, Proof of Concept, and Feasibility study for various projects.

•Developed architectures for mid to large scale data warehouses using Teradata, and MS SQL Server.

•Provided Business Intelligence solutions using Business Objects, Cognos and MicroStrategy.

•Lead the efforts for requirement analysis, conceptual design, logical design, physical database design and the application development.

08/1989 to BULL WORLDWIDE INFORMATION SYSTEMS Phoenix, Arizona

02/2000 Lead Teradata DBA & Lead Teradata Architect / Lead Data Architect

•Provided Lead Teradata DBA services for the Development and Production Teams.

•Designed and developed the code for BTEQ, MultiLoad, FastLoad, FastExport, Tpump, Archive Recovery, IFP/PE, CLI and TDP.

•Provided Teradata Data Warehouse Architect and Teradata DBA services.

•Real time monitoring identifying and tuning poorly performing queries and providing improvement recommendations through mentoring and training classes

•Used Inmon’s approach to develop data warehouses based on 3NF models.

•Participated in the design of data marts, data warehouses, and data mining applications.

•Used ERWin for Data modeling.

Contact this candidate