SUMMARY:

• Project management; Enterprise Data architecture (TOGAF, ITIL, DODAF) including data ingestion pipeline design, Hadoop information architecture,; Master Data Management (MDM) implementation for Customer, Vendor and Product; space; Data integration and conversion for design of Data Lakes, ODS and Master Data; Information quality management; Database Administration; Relational Data Modeling (OLTP, OLAP) ; Object - Oriented modeling and design (Rational Rose); Dimensional data modeling; ODS Design, Data Warehouse Design (Kimball & Inmon); Data standards & guidelines; Metadata management & tools;
• Relational Database (Oracle, UDB/DB2, SQL Server) design and implementation; Information Security and Identity Management; Business Process Modeling; Document Management/Content Management; Knowledge Management/Rules Engine; Process Modeling; Database design, maintenance, troubleshooting, management access control and implementation of recovery plans, monitoring, installation and configuration, administering, performance tuning, backup/recovery; application of software engineering methodologies for software development, software measurement, quality assurance, business process re-engineering; Appliance technology installation, design and management (NETEZZA, EXADATA, Greenplum, Redshift); Econometric and economic cost analysis
• Business Intelligence and Big data Analytics, Research Design and Statistical Analysis using SAS; user and system documentation; training and seminar development; and application of computer software packages for information storage and retrieval, statistical analysis, data modification, graphics and reporting.

TECHNICAL SKILLS:

SOFTWARE: TSO/ISPF/PDF, CLIST, WYLBUR,MVS/XA, JCL UTILITIES, DOS/VSE, OS, VM/CMS, MS/DOS, MS/WINDOWS, EXCEL, BUSINESS OBJECTS, RACF, ADR LIBRARIAN, DB2, CSP, AS, FOCUS,EIS, DB2/UDB, DB2 BLU, NETEZZA, EXADATA, Salesforce.com, TERADATA, SYBASE, TERADATA, ORACLE RDBMS (version 7.3.4,8i,9i, 10g, 11g, 12c), PL/SQL, Oracle Enterprise Data Warehouse (EDW), Warehouse Builder (OWB), OBIEE, ORACLE ERP- GL, AR, AP, Order Entry, Inventory, Purchasing, HR, Assets); Infoshere MDM, Informatica MDM Hierarchy manager, Pentaho, Maximus M4, M5, CAS Financial Systems, ERWIN, POWER DESIGNER, ER/STUDIO, MYSQL, IMS databases, SPOTFIRE, SQL SERVER, JAVA and J2EE and web services, LDAP,WEBLOGIC, WEBMETHODS, MULESOFT, Business Objects, Informatica - Power Center, Power Exchange, Global ID Data Governance Appliance, SMF, MICS, SAS, Python, R,SAP, SAP customer data and transactional code; PEOPLESOFT, PRECISE, DB Artisan, INFORMATICA, DATASTAGE, TOGAF 9, JAMF System Management, MarkIT EDM

Big Data Ecosystems: AWS- (Redshift, EMR, EC2, S3, Route53); Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Cassandra, Oozie, Flume, Chukwa, Pentaho Kettle and Talend, MemSQL

HARDWARE: Confidential MAINFRAME, MINIS, MACROS AND COMPATIBLES, SUN RS6000HP V CLUSTERS, DEC ALPHA, TRU96, SUN E10K, NETEZZA, Golden ID Appliance, Greenplum, Teradata, Exadata

WORK EXPERIENCE:

Confidential, Bakerefield, CA

Teradtada Enterprise Architect

Responsibilities:

• Provides Teradtada Enterprise Architect Subject Matter experts (SME) and mentor and assist technical staff in data governance and best practices for the full life-cycle of corporate data from data modeling, Data Warehouse, Business Intelligence and analytics, and database design and optimization and related activities.

Software: Erwin, Teradata 16.0, MicroStrategy, PowerBI

Confidential, Deerfield, IL

Enterprise Data Architect

Responsibilities:

• Managed the customer data analytics program for actionable business intelligence to identify, attract and retain the most profitable customers.
• Defined and implemented data security, enterprise data quality enforcement, and retention policies in a complex, multiple application environments; created, implemented and tested procedures for backing up and recovering databases
• Designed, created and implemented a Data Lake infrastructure for the Consumer Research initiative for Confidential (55 TB of Data) using MemSql for cloud data ingestion and integration
• Review, and maintained the Customer MDM for GlobalID, to create a single, accurate view of the customer for actionable analytics on acquisition and retention of customer, identify high-value customers and proactively interact with them.
• Work withsolutions architect(s) to provide a consensus based enterprise solution that is scalable, adaptable and in synchronization with ever changing business needs with both Onshore and offshore teams.
• Provided Data Management support including and Data Governance and MDM solution (Informatica MDM) covering the full life Cycle of data from creation, storage, integration to business intelligence and including all the various facets of distributed data stores for both structured and unstructured data through the convergence of data quality, data management, data policies, business process management, and risk management surrounding the handling of both medical & pharmaceutical data using JAVA, J2EE, web services, SAP Power Designer Greenplum, Exadata and Netezza
• Worked with other Architect to design data integration solution using Salesforce data from the cloud with the traditional on-premise data stores using Jason, XML Schema, XML standards and Pentaho
• Direct or indirect involvement in the development of policies, standards, and guidelines that direct the selection, development, implementation and use of Information Technology within the enterprise for application, IDMP (Identification of Medicinal Product), data and network architecture, interface development, security, and business relationship management areas and other stakeholders. program.
• Provided Data Modeling and data integration support using Pentaho for the Data Governance project documenting the various objects in Oracle-E-business Suite for data governance support and GlobalID framework.

Confidential, Deerfield, IL

Enterprise Data Architect

Responsibilities:

• Provided data architecture leadership for the development, validation, publishing, enterprise data quality .and maintenance of logical and physical data models required to migrate existing independent data marts into the EDW, and for new business requirements to be implemented using the EDW.
• Develop data migration roadmap for moving data from 350 heterogeneous sources to single Enterprise Database for Business Intelligence and analytics using Pentaho for ETL.
• Designed, created and implemented a Data Lake infrastructure for the Enterprise Data Archival initiative for Confidential (60 TB of data)
• Worked with other Architect to design data integration solution using Salesforce data from the cloud with the traditional on-premise data stores
• Created security architecture for the enterprise using Role mining techniques for LDAP consolidation with emphasis on GlobalID
• Architects the database from a hardware, software, data model, accuracy, consistency, timeliness, completeness, and stewardship perspectives to meet client demand and to innovate unique data assets on a regular basis.
• Pro-actively identify alternative strategies for resolving both data and other technical issues associated with IDMP (Identification of Medicinal Product), data conversion using a reference Data architectural framework for Greenplum DCA, Exadata, and Netezza, JAVA, J2EE, and web services.
• Developed and implemented test cases as required to accomplish the Data transformation and conversion process.
• Review data warehouse applications design, build, and test plans to ensure they meet the functional and technical design specifications using standards and established the methodology using Jason for document management, XML Schema, XML standards and using MemSql and Pentaho for cloud data ingestion and integration
• Provided technology Solutions Architect analysis, design, and development of Big Data infrastructure/ technology platform strategy by bridging the gap between the requirements of the application as it confirms to the client's reference architecture with both onshore and offshore teams.

Confidential, Lincolnshire, Illinois

Enterprise Data Architect

Responsibilities:

• Analyzed the business solution proposed for architecture impacts and defines technology solution architecture focusing on infrastructure, logical and physical layout of the systems and technologies including Cloud Architecture, hardware, distributed and virtual systems, software, security, data management, Master Data (MDM),, enterprise data quality, storage, backup/recovery, appliances, messaging, networking, workflow, interoperability, flexibility, scalability, monitoring and reliability including fault tolerance and disaster recovery in collaboration with Enterprise Architect using Greenplum DCA, Exadata, Netezza.
• Analyzed, design and implemented corporate data structures using Sparx Enterprise Architecture & Power Designer 16 for both Forward and Reverse engineering, Metadata Development, Domain designation, Data governance and data naming and standardization using Jason for document management, XML Schema, XML standards and Pentaho for datas integration
• Worked with other Architect to design data integration solution using Salesforce data from the cloud with the traditional on-premise data stores.
• Designed, created and implemented a Data Lake infrastructure for the Consumer Analytics for the Boots/ Confidential data integration project using MemSql and Pentaho for cloud data ingestion and integration
• Architected the technology platforms supporting the enterprise analytics strategy with multiple analytics tools including COGNOS, R, Spotfire, BO and SAS with industry architecture best practices, guidelines, standards, principles, and patterns while working with infrastructure and technology project teams
• Perform gap analysis between current state and the future state architecture to identify single points of failure, capabilities, capacity, fault tolerance, hours of operation (SLA), change windows and resolve conflicts within infrastructure and application teams, business units, and other architects
• Worked with the security architect in the provision of Cloud based infrastructure for data visualization (SPOTFIRE) using AWS as integrated solution between DB2 blue and Netezza and Identity management solution using GlobalID, JAVA, J2EE, and web services.
• Documented end-to-end application transaction flows through the enterprise and the technology architecture decision process, and if required develop relevant templates with both onshore and offshore teams.

Environment: NETEZZA, EXADATA, Greenplum, Teradata, Exadata, ERWIN, Oracle 12C, COGNOS, SAS, Spotfire, LDAP, Oracle OIM, Ping Federate, VDI, SPARX Enterprise Architect 11, DB2 BLU, NETEZZA, EXADATA, MVS, CLIST, TSO, RACF; JAVA, J2EE, and web services,AWS- (Redshift, EMR, EC2,S3,Route53); Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Cassandra, Oozie, Flume, Chukwa, Pentaho Kettle and Talend

Confidential

Enterprise Information Architect

Responsibilities:

• Define architecture roadmaps, standards, and procedures which align closely with business strategy and most effective combination of business fit, strategic and innovative of technology, business risk and total cost of ownership of solutions with both onshore and offshore teams..
• Define and document the information viewpoint of the Enterprise regarding technology and architecture including cloud architecture
• Provide Data Management support including and Data Governance,, enterprise data quality and MDM covering the full life Cycle of data from creation, storage, integration to business intelligence and including all the various facets of distributed data stores for both structured and unstructured data through the convergence of data quality, data management, data policies, business process management, and risk management surrounding the handling of both medical & pharmaceutical data using SAP Power Designer
• Provides leadership on the strategic execution of information architecture based on business needs including cloud architecture using Jason for document management, XML Schema and XML standards
• Provide the strategy and implementation of the Enterprise Data model as a service in the SOA Architecture requirements.
• Provided Enterprise information management for GlobalID through LDAP and oracle Identity and Access Management, JAVA, J2EE, and web services

Environment: NETEZZA, EXADATA, Greenplum, Teradata,Exadata, UDB/DB2, ERWIN,, ER/Studio SAS, Python, R, JAVA, J2EE, and web services. SAP Power Designer, COGNOS, SAP, LDAP, Oracle OIM, Ping Federate

Confidential

Enterprise Data Warehouse Architect

Responsibilities:

• Provided data architecture leadership for the development, validation, publishing, and maintenance of logical and physical data models required to migrate existing independent data marts into the EDW, and for new business requirements to be implemented using the EDW.
• Develop data migration roadmap for moving data from 350 heterogeneous sources to single Enterprise Database for Business Intelligence and analytics using Pentaho.
• Architects the database from a hardware, software, data model, accuracy, consistency, timeliness, completeness, and stewardship perspectives to meet client demand and to innovate unique data assets on a regular basis for 100 TB data storage environment.
• Provided Enterprise information management for GlobalID through LDAP and oracle Identity and Access Management, JAVA, J2EE, and web services.
• Pro-actively identify alternate strategies for resolving both data and other technical issues associated with data conversion and enterprise data quality using a reference Data architectural framework of NETEZZA, EXADATA, Greenland DCA, and Exadata
• Develop and implement test cases as required to accomplish the Data transformation and conversion process.
• Review data warehouse applications design, build, and test plans to ensure they meet the functional and technical design specifications using standards and established the methodology and MemSql for cloud data ingestion and integration
• Provided technology Solutions Architect analysis, design, and development of Big Data infrastructure/ technology platform strategy by bridging the gap between the requirements of the application as it confirms to the client's reference architecture with both onshore and offshore teams.

Confidential, Greensboro, NC

Enterprise Data Architect/ Lead Data Warehouse Architect

Responsibilities:

• Acted as subject matter expert internally and externally on data quality, data sourcing, and data strategy
• Designed and created the conceptual, Logical and physical data models for both retail data management using Confidential ’s InfoSphere Data Architect (IDA) with physical implementation on UDB/DB2 for ODS and EDW on Greenplum, Exadata.
• Delivered data strategy and data roadmap presentations to strategic prospects and clients by establishing data strategy,, enterprise data quality and overall data architecture including cloud architecture.
• Provided Enterprise information management for GlobalID through LDAP and Confidential Identity and Access Management and RBAC, JAVA, J2EE, and web services.
• Provided Technical Leadership in Business Intelligence reporting including data quality management using COGNOS, OLAP configuration for Multi- Dimensional Modeling for generalized hierarchies
• Worked with other Architect to design data integration solution using Salesforce data from the cloud with the traditional on-premise data stores using Jason for document management, XML Schema and XML standards
• Database administration including installation ofGreenplumdatabase software, configuration, troubleshooting, database object creation, routine maintenance tasks; performance monitoring and troubleshootingon the Postgres databaseincluding Database Design; Command Center; Workload Management; Query Tuning; Data Loading using upload/external tables.
• Reviewed data warehouse applications design, build, and test plans to ensure they meet the functional and technical design specifications using standards and established the methodology.
• Provided guidance to team members on effective problem resolution by assisting them in the identification of alternatives and presentation of recommendations with both onshore and offshore teams.

Environment: AS400, DB2/UDB, Exadata, GREENPLUM, UDB/DB2, ERWIN, COGNOS, SAP, R, SAS, Python, LDAP, Oracle OIM, Ping Federate

Confidential, Atlantic City Lakes, NJ

Enterprise Data Architect / Lead Data Warehouse Architect

Responsibilities:

• Assists in creating the data strategy, policies and procedures surrounding data for both Casino Patrons and Hospitality management for cloud architecture.
• Provides Data Management support covering the full life Cycle of data from creation, storage, integration to business intelligence and including all the various facets of distributed data stores for both structured and unstructured data.
• Architect database to add & subtract sources seamlessly as new data relationships are forged or expire.
• Provided Enterprise information management for GlobalID through LDAP and Confidential Identity and Access Management and role mining, JAVA, J2EE, and web services
• Provided technical leadership in Data Governance asSubject Matter Expert for all Master Data Management and, enterprise data quality through the convergence of data quality, data management, data policies, business process management, and risk management surrounding the handling of gaming and hospitality data using Global IDs Data Governance Appliance using SAP Power Designer, Exadata and Greenplum DCA..
• Designed and created the conceptual, Logical and physical data models for both Gamming, and Hospitality management using Confidential ’s InfoSphere Data Architect (IDA) with physical implementation on Netezza Platform using Informatica MDM Hierarchy manager on SAP Customer and Product Data.

Environment: GREENPLUM, NETEZZA, EXADATA, Exadata, Confidential DATASTAGE, SQLSERVER, ERWIN, ER/Studio, POWER DESIGNER, Confidential DATA ARCHITECT, UNICA, SALEFORCE.COM, COGNOS, SPSSX, JAVA, J2EE, and web services

Confidential, Franklin Lakes, NJ

Enterprise Data Warehouse Architect

Responsibilities:

• Created the data strategy, policies and procedures surrounding data for MDM implementation of both Customer and Product Data using Global Ids Data Governance Appliance using EVMPD, XEVMPD, IDMP, RIM.
• Delivered Business Intelligence Solutions for the Pharma Sales and CRM sector Using VEEVA as a source system working with both onshore and offshore teams.
• Provided leadership in Data modeling using Confidential IDA for XSD forward engineering in the legacy application on GREENPLUM Data Warehouse USING sap Power Designer.
• Develops data migration strategies for moving data from 145 heterogeneous sources to a single NETEZZA and Exadata databases.
• Provided Enterprise information management for GlobalID through LDAP and Confidential Identity and Access Management and RBAC.
• Maintained pre-processing data for analysis & interpretation of clinical trials bases on IDMP (Identification of Medicinal Product),
• Developed USES CASES for conversion output analysis strategies and evaluating results of their implementation on SAP Customer data using Informatica MDM Hierarchy manager

Environment: GREENPLUM, ORACLE 10g, Exadata, TERADATA, NETEZZA, EXADATA, GREENPLUM, SAP POWER DESIGNER, Pega System, ERWIN, ER/Studio, Confidential IDA, Cognos, MSSQL, DB2, MVS, DATASTAGE, SAS, JAVA, J2EE, and web services

Confidential, Deerfield, IL

Enterprise Data Warehouse Architect

Responsibilities:

• Provided leadership in Data modeling for Conceptual, Logical and Physical Data Models for OLTP, and OLAP using Informatica MDM Hierarchy manager on SAP Customer Data USING Power Designer.
• Participated and provided leadership data quality compliance regarding standards, IDMP (Identification of Medicinal Product), policies, and guidelines for cloud architecture
• Developed data migration roadmap for moving data from 350 heterogeneous sources to single Exadata database
• Pro-actively identify alternate strategies for resolving both data and other technical issues associated with data conversion.
• Provided Enterprise information management for GlobalID through LDAP and Confidential Identity and Access Management and RBAC, JAVA, J2EE, and web services
• Develop and implement test cases as required to accomplish the Data transformation and conversion process working with both onshore and offshore teams.
• Review data warehouse applications design, build, and test plans to ensure they meet the functional and technical design specifications using standards and established the methodology.
• Provides guidance to team members on effective problem resolution by assisting them in the identification of alternatives and presentation of recommendations.

Environment: GREENPLUM, ORACLE 10g, NETEZZA, EXADATA, GREENPLUM, SAP Power Designer, ERWIN, ER/Studio, Confidential IDA, Cognos, MSSQL, DB2, MVS, DATASTAGE, SAS, JAVA, J2EE, and web services

Confidential, North Chicago, IL

Enterprise Data Warehouse Architect

Responsibilities:

• Provided data management leadership pertaining to data quality instrumentation, implementation and validation within the Confidential Enterprise including data modeling support for OLTP, ODS, Data Warehousing, MDM analysis for the design & Implementation of Customer, Products, Vendors, and Prescribers data stores (using Informatica MDM Hierarchy manager on SAP Customer & Product data, Power Designer, Onekey and IMS databases for source data and references), developed and maintained data quality reports and related business processes for corporate data using EVMPD, XEVMPD, IDMP, and RIM.

Environment: ORACLE 10g, SAP, TERADATA, NETEZZA, EXADATA, GREENPLUM, ERWIN, ER/Studio, Confidential IDA, MICROSTRATEGY, MSSQL, DB2, MVS, DATASTAGE, OWB, SPOTFIRE, SAS, BUSINESS OBJECTS, OBIEE, JAVA, J2EE, and web services

Confidential, Hoffman Estates, IL

Enterprise Data Architect/Developer

Responsibilities:

• Provided lead data architect solution including production DBA support for handling retail data for Confidential at the enterprise level including data modeling (Power Designer on Legacy Application and Confidential IDA on Business Intelligence on Netezza Platform) support for OLTP, ODS, Data Warehousing, MDM analysis, design & Implementation for Customer and Products (using Informatica MDM Hierarchy manager on SAP Customer & Product data); OLAP and Reporting layers using Power Designer Data Modeler for XML/XSD forward engineering.
• Reviewed data warehouse applications design, build, and test plans to ensure they meet the functional and technical design specifications using standards and established the methodology.
• Perform DBA duties including capacity planning, object creation, performance monitoring & tuning, Backup & recovery and production support.

Environment: ORACLE 10g, SAP, Exadata, TERADATA, NETEZZA, EXADATA, GREENPLUM, ERWIN, ER/Studio, POWER DESIGNER, Confidential IDA, MICROSTRATEGY, MSSQL, DB2, MVS, DATASTAGE, OWB, SAS, BUSINESS OBJECTS, OBIEE, JAVA, J2EE, and web services

Confidential, Jacksonville, FL

Data Warehouse Architect

Responsibilities:

• Provided data warehouse architecture, design, development, administration support for Confidential Business Intelligence including data integration, MDM analysis, design & Implementation for Customer & Products(using Informatica MDM Hierarchy manager on SAP Customer & Product data), data warehouse database design, maintenance, troubleshooting, management access control and implementation of recovery plans, monitoring, installation and configuration, administering, performance tuning, backup/recovery and data modeling ( ERWIN on Legacy application and Confidential IDA on Enterprise architecture on Netezza Platform) support for OLTP, ODS, Data Warehousing, OLAP and Reporting layers using Power Designer and Erwin Data Modeler for XSD forward engineering, Model Manager and Erwin Data Profiler.

Environment: ORACLE 10g, DB2, SQLSERVER, Exadata, TERADATA, NETEZZA, EXADATA, GREENPLUM, SAP, ERWIN, ER/Studio, Confidential IDA, MICROSTRATEGY, MSSQL, DB2, MVS, DATASTAGE, OWB, SAS, BUSINESS OBJECTS, OBIEE, JAVA, J2EE, and web services

Confidential

Enterprise SOLUTION ARCHITECT

Responsibilities:

• Provided Architectural support for delivering IT solutions for data and Server integration through Configuration Management and Resource Control using SUN SRM for Oracle 10g SPI Provisional System Architecture and leadership in logical/physical modeling and design for both ORACLE Customer and Product Hun(MDM) architecture using ERWIN and reference architecture using the Confidential -Banking Data Warehouse.

Confidential, Charlotte, NC

Data Warehouse Architect

Responsibilities:

• Provided data warehouse architecture, design, development, administration support for Confidential Business Intelligence including database design, maintenance, troubleshooting, MDM analysis, design & Implementation for Customer, Products & Vendors, management access control and implementation of recovery plans, monitoring, installation and configuration, administering, performance tuning, backup/recovery and data modeling support (Power Designer on Legacy Application & Confidential IDA on Enterprise Architecture on Netezza) for OLTP, ODS, Data Warehousing, OLAP and Reporting layers using Erwin Data Modeler for /XSD forward engineering, Model Manager and Erwin Data Profiler.

Environment: ORACLE 10g, DB2, SQLSERVER, TERADATA, NETEZZA, EXADATA, Exadata, GREENPLUM, SAP, Power Designer, ERWIN, ER/Studio, Confidential IDAMICROSTRATEGY, MSSQL, DB2, MVS, DATASTAGE, OWB, SAS, BUSINESS OBJECTS, OBIEE, JAVA, J2EE, and web services

Confidential, Minneapolis, MN

Enterprise Architecture

Responsibilities:

• Provided Architectural support for delivering IT solutions for data and Server integration through Configuration Management and Resource Control using SUN SRM for Oracle 10g SPI Provisional System Architecture and leadership in logical/physical modeling and design for both ORACLE Customer and Product Hun(MDM) architecture using Power Designer

Environment: ORACLE 10g, DB2, SQLSERVER, TERADATA, NETEZA, GREENPLUM, SAP, Power Designer/ ERWIN, ER/Studio, MICROSTRATEGY, MSSQL, DB2, MVS, DATASTAGE, OWB, SAS, BUSINESS OBJECTS, OBIEE