SUMMARY:

• 10 years of experience as Senior Manager / Director of Enterprise Architecture and 18 years as Senior Enterprise Architect in Banking & Finance and other domains
• Big Data expert, enthusiast, and evangelist, with expertise in java, Cassandra, MongoDB, Hadoop, HDFS, Map Reduce, Spark, Hive, pig and impala.
• Lead Big Data adoption to help the organizations benefit from Big Data implementations.
• Expert in Data Warehouse design and implementation using Columnar Database technologies such as Teradata (Columnar DB Option), Oracle and Sybase IQ. (These products have capabilities similar to Vertica).
• Proven Data Scientist.
• Multiple years of experience in SSIS,SSRS and SSAS.
• Worked with the Development teams to use microservices.
• Multiple years of experience in Tableau, Microstrategy, and Business Objects.
• Expert in designing and implementing hybrid data solutions using structured and unstructured data.
• Expert in leading dream teams, able to motivate each team member to excel and be the best.
• Auto Captive Enterprise Operational Data Store experience.
• Big Data Engineer, with experience in data and infrastructure.
• Multiple years of ErWin, ER/Studio, Power Designer & experience using various databases such as Teradata, Oracle, SQL Server, DB2, DB2UDB, etc.
• Multiple years of Data Integration and Services Architecture experience using tools such as Data Stage, Ab Initio, Informatica and TIBCO.
• 15 years of Lead Teradata DBA experience for Production and Development
• Multiple years of experience working on various IBM BDW & Teradata iLDMs (Industry specific Logical Data Models ) such as MLDM (Manufacturing LDM), CLDM (Communication LDM),RLDM Retail LDM) etc.
• Passionate about software design theories and implementation.
• Experienced in designing, developing and deploying various software products including Data Sourcing APIs.
• Competent in both Inmon and Kimball approaches to Data Warehousing.
• 25 years experience in State of the Art software development methodologies, software and hardware architecture, infrastructure design and development in SOA, Teradata, Oracle, and SQL - Server in Microsoft Windows, Linux and Unix environments
• 10 years experience in creating Strategies snd Roadmaps for complex Data warehouse, Operational Data Store (ODS) and BI implementations, specializing in Teradata and Oracle based solutions.
• 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 and implementation of data mart models, mapping source system models and data mart models on Teradata and Oracle platforms.
• 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
• 20 years End-to-End SDLC and Agile development experience including analysis, scoping, design, development, QA, deployment, and maintenance.
• Expert in Teradata and Oracle development including query performance tuning and debugging
• Experienced in Security administration including creating and maintaining user accounts, passwords, profiles, roles and access rights
• Expertise in reviewing the current Corporate BI practices and finding the gaps in the current practices.
• 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.

TECHNICAL SKILLS:

Technology Areas: Big Data Solutions, Cassandra, Hadoop, HDFS, Map Reduce, Pig, Hive, Impala, Python, Spark,LTP, Data Warehouse, Data Mart, and BI systems, Transactional database systems, Data structures, Relational database and data warehouse modeling, ETL processes, Data Integration, Complete development lifecycle, White box (structural) and black box (functional) testing methodologies.

Design/Modeling Techniques:: ER Studio Architect Version 8.5.3 and 7.5. OLTP, 3NF Data Modeling, Star/Dimensional, Logical and Physical ER model Design, Architecture frameworks such as Zachman and TOGAF, Corporate Information Factory (Inmon), Kimball Data Warehouse Bus (Kimball), Data Stewardship, Data Modeling, and ETL DBMS, Database, Data Warehouse and BI Tools: Teradata, Sybase IQ, Gemfire, SAP HANA, Oracle (v.7, 8, 8i, 9i, 10g, 11g, 12c), MySQL, MS SQL Server 2000/2005/2008 , MS Access, DB2, UDB, IBM(Ascential) DataStage (Server and Enterprise Edition v.7.x), Informatica, Micro Strategy, COGNOS (Impromptu and Powerplay), Business Objects, Crystal Reports ERWin. ER Studio Architect 8.5.3, SQL Tuning, MDM, and CDI.

Programming Language and Tools:: Teradata SQL, PL/SQL, Shell Scripts, HTML, XML, WML, C/C++, C#, VB, VB.net, and ASP .net, TIBCO, Informatica, Ab Initio, java, Spark

OS, Servers, and Software: Solaris, Unix, NCR-UXLinux, BSD, HP-UX, Microsoft Windows/NT Server, XP, 2003. MS-IIS, Apache Web Server, Net Backup, Remedy, Visio

Hardware and Network: Teradata, Sun Enterprise Servers, Sun Disk Array, NetApp Filer, Intel PC, understand TCP/IP network and Internet protocol, familiar with switches, routers and load balancers and understand wireless network protocols.

Project Management: Creating and adhering to multiple project schedules, ITIL, managing personnel/resource issues, team building, requirements gathering, developing and enforcing standards, and mentoring junior staff.

EXPERIENCE:

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for Mortgage Integrated Data Environment (MIDE) End to End Solution Designs, including Requirement Gathering, Conceptual, Logical and Physical Data Model, as part of the Solution Engineering Team)
• Created Solution Design Documents (SDD), Functional Design Documents (FDD) and associated presentation material for various projects, and performed detailed data analysis for project teams, and business partners.
• Worked in Waterfall and Agile projects.
• Did research to identify possible approaches for various technical problems, provided pros and cons, and the recommendations for the best approach.
• Did detailed internal and external research, and data analysis to propose data strategy, and implement the solution based on the strategy.
• Designed and implemented solutions for ECM using Java, microservices, events, kafka, and kubernetes in AWS cloud.
• Designed solutions for Correspondent LOB using Layered design pattern. Designed APIs for these solutions and passed them on to the EGS team in India for implementation, and maintenance.
• Provided leadership to the US and the EGS teams in India regarding Data Analysis, Query Performance, Database Design, Data Integration (ETL) and reporting.
• Collaborated with various LOBs, such as ICMP, Capital Markets, CRoM, and Community Banking.
• Created data models for BMG (Community Banking Teradata platform) teams using ERWin.
• 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.
• Used SSIS to move data from Source systems to SQL Server and Oracle.
• Used SSRS, Microstrategy, and Tableau for reporting, and SSAS and Cognos for cubes and analytics for Mortgage Sales & Fulfilment and Mortgage Servicing data.
• Created Data Science / Machine learning models for fraud analytics using Python and R.
• Worked closely with the Teradata DBA for structure and query deployments, and performance tuning.
• Worked closely with the Business partners for MIDE and BMG environments.
• Designed and implemented Informatica MDM solution for Master parent entities such as Account, Product and Party, and a number of derived/child entities such as Customer, Vendor, Employee, Checking Account, Saving Account, Mortgage, Accounting Units etc, and Reference Data.
• Populated Informatica MDM from proprietary MDM database.
• Migrated existing Data Governance solution to Collibra, and started capturing Business metadata to Collibra.
• Created interface to connect Business Metadata in Collibra to Technical Metadata in Abnitio Metadata Hub.
• Created Data Lake using Big Data technology such HDFS, Hadoop and Spark.
• Migrated a portion of Teradata EDW to Snowflake using WhereScape, for selective LOBs.
• Was a MIDE Role approver from, and the Lead MIDE Role approver from .
• Provided assistance to the MIDE Prod support team on various problems.

Confidential

Enterprise Data Architect

Responsibilities:

• Responsible for Strategy, End to End Solutions including Requirement Gathering, Conceptual & Logical & Physical Data Modeling, Database Design and Integration, Data Governance, Data Cleanup, Database Performance, Reporting, Application Development and Adoption for Healthcare and Finance Industries.
• Worked on Agile and waterfall projects
• Created Data science solutions for predictive analytics. by collaborating with the client Data Scientists and Business teams.
• Created SSRS and Tableau reporting solutions for Confidential clients.
• Migrated client EDWs to AWS Redshift as part of Cloud migration initiatives.
• Designed solutions using Columnar Databases using Oracle 12c (similar to Vertica) and NoSQL databases such as MongoDB and Cassandra.
• Clients in my portfolio include Confidential, Rebuilders Automotive Supplies, LogistiCare and Allen Parish Hospital.

Confidential, Scottsdale, AZ

Enterprise Architect & Integration Lead

Responsibilities:

• Responsible for Data Strategy, End to End Data Modeling, Database Design, Integration, Reporting and Adoption of HealthCare solutions for Healthy Populations Organization, using Industry Best Practices.
• Created data mining solutions using python.
• Creating Enterprise Operational Data Store (ODS).
• Implemented Orion Data Platform, Clinical Portal and Patient Portal solutions using java, microservices, Spark, and NoSQL databases such as Cassandra and MongDB.
• Worked on Agile projects.

Confidential, Torrance, CA

Enterprise Data Architect

Responsibilities:

• Responsible for Strategy, End to End Data Modeling, Database Design of Integration Repository and Adoption for Confidential Financial Services, an Auto Captive company.
• Creating IR Data Inventory and Application Inventory tools
• Improving the quality of IR design documents via review and recommendations.
• Creating Enterprise Operational Data Store.
• Creating Enterprise data elements naming standards including Prime Words, Modifiers and Class Words and associate abbreviations using ERWin.
• Worked on Agile and Waterfall projects.
• Reverse Engineered the current Integration Repository model to get as-is model and working on ODS as to-be model.
• With the reverse engineered as-is model, I was able to answer a lot of data related questions to be more productive in new integration projects.
• Creating various subject areas based on the source data and the use of that data by downstream applications.
• Creating excellent metadata..
• Working with Informatica team to model and create all new tables in ODS.
• Helped in testing of Service Now implementation in the TFS enterprise
• Developed in memory sol
• Lead the Team on Big Data projects using Cassandra clusters, java and Spark.

Confidential

Senior Manager / Enterprise Architect

Responsibilities:

• Responsible for End to End Data Modeling and Database Design of critical and Highly visible Citi Program.
• The data modeling tool were Erwin and ERStudio.
• Lead a team of 8 onsite and 12 offshore resources
• Lead RFP efforts on behalf of Confidential .
• Created, documented and socialized business and technical processes.
• Responsible for Logical and Physical Modeling, as well as query generations for various TIBCO services.
• Lead the efforts for Data strategy and the creation of Logical and Physical data model compliant with IBM Banking Data Warehouse (BDW), and similar to Teradata fsLDM (Financial Services Logical Data Model).
• Lead ETL, Object Model, TIBCO services and Query Developer teams, both onsite and offshore.
• Create Schemas and tables, indexes and partitions. Update the Database structures regularly based on the continuous modeling updates for different waves of the Program.
• The team included Oracle 10g Development DBAs
• Provide query performance tuning services
• Collaborated with other teams such as Business Analysts, Business users and IT teams for requirement analysis.
• Design ETL & TIBCO solutions.
• Created architecture for real time and batch interfaces.
• Created ETL graphs to read data from Legacy source systems and store on EDW.
• Create UML object models used for designing TIBCO services.
• Implemented Big Data Solutions using Hadoop and Hive.
• Designed big data and relational platform solutions with data stored on Mongodb, Cassandra and Oracle, using Java and Spark.
• Designed solutions using Columnar Databases using Oracle 12c (similar to Vertica), and Teradata with Columnar Database option (similar to Vertica)
• Worked on Agile and waterfall projects.
• Exceeded all Citi and Confidential expectations for critical projects.
• Provide impressive POC covering functionality and performance, and stunned Citi and Confidential with results.

Confidential, Phoenix, AZ

Responsibilities:

• Responsible for End to End Architecture of a very strategic project
• Leading technical aspects of all phases of the project including Requirement Gathering, all stakeholders sign-offs, Conceptual Architecture, Logical Architecture, Physical Architecture, Infrastructure Architecture, High Level and detailed design, Development Environment (E1), QA Environment (E2) and Production Environment (E3).
• Collaborate with the System Integration (SIT) and User Acceptance Test Team (UAT).
• The platform for Enterprise Data Warehouse, Analytics and data mining will be Teradata.
• Created documented and socialized business and technical processes.
• Had dual assignment in the Confidential club and Insurance Exchange (IE) projects in the Separation Program.
• Responsible for the Solution Architecture for the inbound (from Confidential club to IE) project, and the outbound (IE to the Confidential club) project.
• Did detailed research and had several meetings with the SMEs to understand the current state of the data flow for various inbound and outbound requirements.
• Created diagrams for the data \flow for various data requirements.
• Created approach presentations (ppt) for both inbound and outbound projects, and presented to the Client teams.
• Created Downstream applications diagrams for each inbound requirement.
• Worked on Agile and waterfall projects.
• Provided a conceptual design for inbound project using ODS in the middle of the inbound data feeds and the IE applications (the consumers of the data).
• Provided consultation for short term, midterm and long term solutions for both inbound and outbound projects.
• Created, documented and socialized business and technical processes.
• Created ETL processes.

Confidential, Mountain View, CA

Responsibilities:

• Lead Data Warehouse Implementation proposals.
• Worked on the Confidential Human Resources Business Intelligence (HRBI) projects, as the Senior Manger, managing a team of 4 onsite and 5 offshore resources
• Defined, designed and implemented multiple HRBI Data Ware House Requirement Analysis and Assessment projects
• Lead the Data Warehouse Subject Matter Experts (SMEs) knowledge acquisition projects in the various HR Domains.
• Lead HR Data Warehouse Solution Architecture Design, Data Governance & Data Quality implementation Design, and the Roadmap Projects for the Confidential HR Data Warehouse implementation, proposing:
• One time Foundation Phase containing projects such as:
• Data & Capability Definition
• Capacity Planning
• Tools Evaluation
• Infrastructure Implementation
• POC for Extract from SaaS and non-SaaS source systems
• Implementing Various Environments: Dev, QA, UAT,& Prod
• Subject Area Wise Core Projects
• Multiple waves to implement Subjects Areas into the Data Warehouse based on the Priority, covering Landing Zone, Staging, 3NF & Dimensional /Reporting layers for Dev, QA, UAT and Prod Environments
• Designing and implementing ETL jobs & schedules based on the requirements
• Creating Logical & Physical Data Models
• Creating BO Universe (or other environments if required)
• Creating the queries required for Reporting
• Creating Reports based on the requirements
• Providing proper permissions to Report users based on Departments, Users, Super Users and Admin
• Implement repositories such as Business Glossary, Business Rules, Data Transformation Rules, Data Quality Checks, etc
• Subject Area Wise Support Projects
• Support project for each subject area.
• Completed the Data & Capability Definition and Capacity Planning (Database) Projects .
• Created data models per Client’s requirement.
• Designed ETL & Services architectures for data integration.
• Presented all project deliverables to the client before time and received sign-off.
• Provided daily and weekly status for all projects to the Confidential and Confidential teams.
• Worked closely with other Off-shore teams, besides my own team, on all these projects.
• Participated in creating response to RFPs on behalf of Confidential .
• Provided guidance in Talent Acquisition for BIDW-PM practice.
• Senior member of the BIDW-PM practice.
• 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.
• Worked on all Basel streams where there were new data feeds..
• Participated in Basel Data Quality and Data Governance Strategy.
• Implemented Sharable Data Assets
• Created Source to Target Mapping requirements for ETL Jobs.
• Used complex SQL logic for Derived fields.
• Created 2 versions of data models for multiple source feeds: dbo Business as Usual (BAU) and AXP schema for Point of Arrival (POA).
• Attended regular meetings with Business and Source System teams for various phases of the projects. Used Method1 approach. Hence the primary project phases were PDP, Analyze, Design, Build and Test.
• Created Normalized and Dimensional models. Dimensional models were created for Business Intelligence Reporting.
• Lead Informatica 9.1 ETL team, to convert Ab Initio graphs to Informatica 9.1.
• Designed solutions using Columnar Databases using Sybase IQ (similar to Vertica).
• Shared responsibility in implementing Informatica Metadata Manager, and creating Business Glossary.
• Created UML Object models and Use Case diagrams.
• Used ER Studio 8.5 for Data Modeling
• Worked on Agile and Waterfall projects.

Confidential, Phoenix, AZ

Enterprise Data Architect

Responsibilities:

• Created Data Models and Data Architectures for multiple large scale projects.
• Worked for Data Architecture & Database Development (DA&DD) organization.
• Typically worked on 4 to 6 projects simultaneously
• Worked on Operation, Data Warehouse, ETL and Business Intelligence architectures.
• Developed excellent relationships with Data Base Administrators, Application Team, Business System Analysts, Project Managers, Test Managers and the Business teams. These relationships have made me very productive.
• Modified and created multiple Logical and Physical models with larger models having close to 400 entities/tables where 20% of the entities/tables had close to 80 attributes/columns.
• Most of the data models have been designed for OLTP systems.
• Captured excellent metadata for all my projects.
• Worked closely with application team to achieve Project goals.
• Designed ETL & Services architectures for data integration.
• Created UML Object models and Use Case diagrams.
• Worked on Waterfall projects.

Senior Teradata Architect

Confidential, Pleasanton, CA

Responsibilities:

• 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.
• Used Golden Gate for replication

Lead Teradata Client Consultant & DBA

Confidential, Clinton, MS

Responsibilities:

• Participated in the meeting sessions with the client to understand the needs of the project.
• Reverse Engineered the current data model using ERWin.
• Designed ETL jobs using Teradata utilities such as BTEQ, FastLoad and MultiLoad.
• Worked with Teradata cLDM (Communication Logical Data Model) as a base to design the EDW solution for Verizon
• Used Golden Gate for replication.

Director of Enterprise Architecture / Client Consultant

Confidential, Phoenix, AZ

Responsibilities:

• Participated in the meetings with the client to understand the IT and Operations requirements.
• Lead the due diligence from EDW/BI perspective.
• Provided input to the proposal and participated in reviewing it.
• 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.
• 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.
• Played the role of a Senior Director in managing the Onsite and Offshore teams from a technical leadership perspective.
• I managed a team of 30 resources, 10 onsite and 20 offshore.
• Designed and implemented data mart models, mapped source system models and data mart models.
• Designed, developed and implemented processes for maintenance of ETL code, created definitions and capture processes of metadata and rules for ETL, definitions and development of ETL Validation code, and source system analysis and profiling.
• Used Cognos, Oracle and Netezza.
• Used Golden Gate for replication.