| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateSUMMARY:20+ 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.Candidate's Name 2.0 SME (Subject Matter Expert) with experience of multiple years.Migrated 3NF DBs to combination of Kimball Dimensional DBs and Candidate's Name 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 domainsBig 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 TDDExperienced 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 DevelopmentCompetent 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 requirementsExpert in Teradata and Oracle development including query performance tuning and debuggingExpert 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 1989University of Arizona Tucson, Arizona Focus on AI, Expert Systems and Machine LearningB.S., Computer Engineering 1986University of Arizona Tucson, ArizonaSPECIAL RECOGNITION AWARDS:Received Recognition in Training IBM, Tucson employees in using Artificial Intelligence technologies. 1988Received Recognition for helping the Big Brothers Organization of Plano Texas. 2005Received recognition for contribution to NASAs 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 TeraCandidate's Name 2.0 for for multiple domains including Asset Management, Mortgage, Stock Trades, Wealth Management and Commercial Bank divisions.EXPERIENCE:7/19/21 to JadAIPresent Principal Enterprise Data ArchitectLeading Generative AI organization7/19/21 to CDW - Sirius6/28/2024 Managing Consultant Data Practice / Principal Enterprise Data ArchitectDesigned 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 Candidate's Name 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 targetsInteracted 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 knowledge12/31/15 to Wells Fargo7/5/21 Senior Cloud Architect / Senior Enterprise Data Warehouse Architect/ Senior Enterprise ArchitectCreated end to end enterprise level solutionsLead Architect for architecting and implementing TeraCandidate's Name 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 IT11/15/15 Senior Enterprise ArchitectCreated 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 Health05/23/14 Principal Enterprise Data Warehouse ArchitectScottsdale, AZCreated 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 ProjectCreating 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 Services12/24/13 Enterprise Data Architect / Enterprise Data Warehouse ArchitectTorrance, CADesigned 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 Cognizant7/8/13 Senior Manager / Senior Data Warehouse ArchitectI worked for Cognizant from 1/10/11 to 7/8/13Listed below are the project assignment details with Cognizant Clients.Client: CitiJersey City, NJResponsible 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 resourcesDesigned and implemented, Retail Banking, Commercial Banking and Capital Market solutions using internal and external data sources such as Moodys, 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 ExpressPhoenix, AZParticipated 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 Modeling01/10/09 to CONSULTING / Various Clients12/31/2010 ContractorAmerican ExpressSenior Data ArchitectPhoenix, AZCreated Data Models and Data Architectures for multiple large scale projects.The primary modeling tool was E/R Studio Architect Version 8.5.3UST-GlobalSenior Teradata ArchitectSafeway, Pleasanton, CAManaged 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 SERVICE11/24/08 Director of Enterprise Architecture / Client ConsultantApple Computer, Cupertino, CAManaged 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 Teradatas 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, NJManaged 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 EntertainmentManaged 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 planningSuccessfully 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 CONSULTING03/07 Contractor / Lead Data ArchitectDHLProvided 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, AZ05/2005 Director of Enterprise ArchitectureLead Teradata DBA for Production and Development TeamsThere 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 designLead 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, Arizona02/2000 Lead Teradata DBA & Lead Teradata Architect / Lead Data ArchitectProvided 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 classesUsed Inmons 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. |
