SUMMARY:

• Project management analysis, modeling, design & implementation for Customer, Vendor and Product in the pharma space; Data integration and conversion for design of Confidential and Master Data; Information quality management;
• Database Administration; Relational Data Modeling ( Confidential, OLAP) ; Object - Oriented modeling and design (Rational Rose); Dimensional data modeling; Confidential Design, Data Warehouse Design; 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 using concept diagrams, wireframes, content matrices, flow diagrams, and functional requirements; 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;
• Econometric and economic cost analysis; Business Intelligence, 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, Confidential, TERADATA, SYBASE, TERADATA, ORACLE RDBMS ( version 7.3.4,8i,9i, 10g, 11g), PL/SQL, Oracle Discoverer and Express, Oracle Enterprise Data Warehouse (EDW), Oracle web Services, InterConnect, RMAN, Oracle Warehouse Builder (OWB), OBIEE, Oracle Designer, Pure*Integrate/Pure*Extract, Oracle Clinical (ORACLE ERP- GL, AR, AP, Order Entry, Inventory, Purchasing, HR, Assets); Informatica Confidential Hierarchy manager, Maximus M4, M5, CAS Financial Systems, Confidential, POWER DESIGNER, ER/STUDIO, MYSQL, Onekey, IMS databases, SPOTFIRE, SQL SERVER, LDAP,WEBLOGIC, WEBMETHODS, Business Objects, Informatica - Power Center, Power Exchange, Global ID Data Governance Appliance, Hyland OnBase/AnyDoc, SMF, MICS, SAS, Python, R,SAP, SAP customer data and transactional code; PEOPLESOFT, PRECISE, DB Artisan, INFORMATICA., DATASTAGE, BRIO, PLATINUM/CIMS,REMEDY, ITIL/SOX/SAS7, AUTOSYS, ARCSERVE, NWADMIN, OPENVISION, CCNECBACKUP, INFOMAN, Sun Enterprise Server 10K (28 CPUs) with Sun Solaris 2.8, EMC mirrored disk frame and VERITAS volume manager with NETBACKUP, VERITAS Cluster Server, AIX, VERITAS,HPUX, Oracle 11i clustering, LINUX, Sparx Enterprise Architect 11, SPOTFIRE, Confidential 9, JAMF System Management

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

PROFESSIONAL EXPERIENCE:

Confidential, Deerfield, IL

Enterprise Architect

Responsibilities:

• Creates artifacts within an EA framework.
• Facilitates transformational change through the use of architectural roadmaps.
• Supports analysis, design, development and implementation of large-scale systems (OO and /or distributed component based) for both relational and NoSQL databases a plus.
• Support the r software development life cycles and technical design principles using Agile, RUP, and Confidential framework.
• Alignment of IT strategy and planning with company's business goals.
• Optimization of information management through an understanding of evolving business needs and technology capabilities.
• Strategic responsibility for the company's IT systems.
• Provides enterprise content management (ECM), case management, business process management (BPM), records management using Hyland OnBase & AnyDoc for enterprise file sync and share (EFSS).
• Promotion of shared infrastructure and applications to reduce costs and improve information flow. Ensure that projects do not duplicate functionality or diverge from each other and business and IT strategies.
• Work with solutions architect(s) to provide a consensus based enterprise solution that is scalable, adaptable and in synchronization with ever changing business needs.
• Work with Mainframe solution Architects in data migration efforts using TSO, Clist, and security and access control through RACF.
• Risk Management of information and IT assets through appropriate standards and security policies.
• 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.
• Build employee knowledge and skills in specific areas of expertise.

Confidential, Deerfield, IL

Enterprise Data Architect

Responsibilities:

• Leads 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.
• Create effective models to build a business-driven data architecture
• Document and enhance existing databases to reduce redundancy
• Implement naming standards to improve data consistency and quality
• Effectively share and communicate models across the enterprise
• Map data sources and trace origins to enhance data lineage
• Migrated data from Mainframe, Cobol CICS using TSO, CLIST, RACF and other mainframe utilities
• Provided enterprise content management (ECM), case management, business process management (BPM), records management using Hyland OnBase and AnyDoc for enterprise file sync and share (EFSS).
• Create Data Governance strategy and implementation using Collibra Data Governance tool
• Provided technology Solutions Architect analysis, design and development of Big Data infrastructure/ technology platform strategy by bridging the gap between the applications requirements as it confirms to the client's reference architecture.
• 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 ( Confidential ), storage, backup/recovery, appliances, messaging, networking, workflow, interoperability, flexibility, scalability, monitoring and reliability including fault tolerance and disaster recovery in collaboration with Enterprise Architect.

Confidential, Lincolnshire, Illinois

Enterprise Solution Architect

Responsibilities:

• Provided technology Solutions Architect analysis, design and development of Big Data infrastructure/ technology platform strategy by bridging the gap between the applications requirements as it confirms to the client's reference architecture.
• 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 ( Confidential ), storage, backup/recovery, appliances, messaging, networking, workflow, interoperability, flexibility, scalability, monitoring and reliability including fault tolerance and disaster recovery in collaboration with Enterprise Architect.
• 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
• 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
• Migrated data from mainframe using TSO, CLIST, and RACF for enterprise data analysis
• 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 Confidential
• Documented end-to-end application transaction flows through the enterprise and the technology architecture decision process, and if required develop relevant templates.
• Provided enterprise content management (ECM), case management, business process management (BPM), records management using Hyland OnBase and AnyDoc for enterprise file sync and share (EFSS).
• Data Analysis using R, SAS, and Python

Environment: Confidential, Confidential, Teradata, Confidential, ER/Studio, Power Designer, Hyland OnBase/AnyDoc Infosphere Data Architect, COGNOS, SAS, Spotfire, LDAP, Oracle OIM, Ping Federate, VDI, SPARX Enterprise Architect 11, DB2 BLU, MVS, CLIST, TSO, RACF

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.
• Define and document the information viewpoint of the Enterprise regarding technology and architecture including cloud architecture
• Provide Data Management support including and Data Governance and Confidential 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.
• Provide the strategy and implementation of the Enterprise Data model as a service in the SOA Architecture requirements.
• Data Analysis using R, SAS, and Python

Environment: Confidential, Confidential, Teradata, UDB/DB2, Confidential, ER/Studio SAS, Python, R, SAP Power Designer, COGNOS, SAP, LDAP, Oracle OIM, Ping Federate

Confidential

Enterprise Solution Implementation Manager

Responsibilities:

• Provided detailed assessment of the current environments and assumptions made to identify risks, dependencies and determine readiness for the migrations including cloud architecture.
• Providing project plan input to BMO in creating an overall project plan outlining activities, efforts, dependencies and timelines in detail for all necessary activities as defined in this SOW and at a high-level for activities not defined in this SOW but expected to be added to the project scope following further analysis through a project change request.
• Collect existing migration scripts used by BMO for past DDL migration and DDL change capture and analyze script purpose, functionality and output format for each script.
• Source Data from Mainframe using COBOL, CICS, TSO, CLIST, RACF and other MVS utilities.
• Provided Data Management support including Confidential (Product, Customer & Vendor) and Data Governance 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 using SAP Power Designer
• Determine high-level script design for Confidential to PDA DDL migration and DDL change capture
• Validate the effort required to develop scripts to capture changes in the DDL.
• Finalize the DDL migration approach for each environment
• Analysis of DDL conversion requirements
• The design of DDL conversion scripts using Confidential Production DDL as the Baseline.
• Perform initial DDL Code Migration to create an empty Confidential database on PDA, Unit Testing of the résultant PDA Confidential database instance
• Data Analysis using R, SAS, and Python

Environment: Confidential, UDB/DB2, Confidential, ER/Studio, SAP Power Designer, Infosphere Data Architect, COGNOS, SAP, R, SAS, Python, LDAP, Oracle OIM, Ping Federate, MVS, TSO, CLIST, RACF

Confidential, Greensboro, NC

Enterprise Data Architect/ Data Warehouse Architect

Responsibilities:

• Acts as subject matter expert internally and externally on data quality, data sourcing, and data strategy
• Design 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 Confidential and EDW on Confidential .
• Delivers data strategy and data roadmap presentations to strategic prospects and clients by establishing data strategy and overall data architecture including cloud architecture
• Provide Technical Leadership in Business Intelligence reporting including data quality management using COGNOS, OLAP configuration for Multi- Dimensional Modeling for generalized hierarchies
• Provided Data Management support including Confidential using Informatica Confidential Hierarchy manager and Data Governance 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 Retail data using Power Designer
• Microsoft Office 365 deployment/adoption including General Management, PowerShell scripting, and Troubleshooting
• Confidential database administration including installation of Confidential database software, configuration, troubleshooting, database object creation, routine maintenance tasks; performance monitoring and troubleshooting on the Postgres database including Database Design; Command Center; Workload Management; Query Tuning; Data Loading using upload/external tables
• Develop data migration roadmap for moving data from 350 heterogeneous sources to single Confidential database
• 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 alternate strategies for resolving both data and other technical issues associated with data conversion using reference architecture of Confidential -Banking Data Warehouse on SAP Customer data including the transactional codes.
• 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.
• Provides guidance to team members on effective problem resolution by assisting them in the identification of alternatives and presentation of recommendations.
• Data Analysis using R, SAS, and Python

Environment: AS400, DB2/UDB, Confidential, UDB/DB2, Confidential, ER/Studio, SAP Power Designer, COGNOS, SAP, R, SAS, Python, LDAP, Oracle OIM, Ping Federate

Confidential, Atlantic City Lakes, NJ,

Enterprise Data Architect / 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.
• Developed and documented methodology for implementing data quality across the organization
• Provides IT leadership role as an Enterprise Architect for Confidential, OLAP and recently implementing NOSQL (HADOOP) implementation for BIG Data with the entire ramification associated with Enterprise Data architecture.
• Provided technical leadership in Data Governance as Subject Matter Expert for all Master Data Management 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.
• 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 Confidential Platform using Informatica Confidential Hierarchy manager on SAP Customer and Product Data.
• Provided Technical Leadership in Business Intelligence reporting using COGNOS, OLAP configuration for Multi- Dimensional Modeling for generalized hierarchies.

Environment: Confidential, Confidential, Confidential DATASTAGE, SQLSERVER, Confidential, ER/Studio, POWER DESIGNER, Confidential DATA ARCHITECT, UNICA, SALEFORCE.COM, COGNOS, SPSSX

Confidential, Franklin Lakes, NJ,

Enterprise Data Warehouse Architect

Responsibilities:

• Created the data strategy, policies and procedures surrounding data for Confidential 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
• Provided leadership in Data modeling using Confidential IDA for Confidential forward engineering in the legacy application on Confidential Data Warehouse USING sap Power Designer.
• Develops data migration strategies for moving data from 145 heterogeneous sources to a single Confidential database
• Maintained pre-processing data for analysis & interpretation of clinical trials
• Designed ETL routines using Informatica and where applicable using NZLOAD to extract data from source systems, transform data into target structures into Confidential Database
• Develop USES CASES for conversion output analysis strategies and evaluating results of their implementation on SAP Customer data using Informatica Confidential Hierarchy manager

Environment: Confidential, ORACLE 10g, TERADATA, Confidential, Confidential, SAP POWER DESIGNER, Pega System, Confidential, ER/Studio, Confidential IDA, Cognos, MSSQL, DB2, MVS, DATASTAGE, SAS

Confidential, Deerfield, IL

Enterprise Data Warehouse Architect

Responsibilities:

• Provided Data Management support including Confidential and Data Governance 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 pharmaceutical data using EVMPD, XEVMPD, IDMP, and RIM. Assist in definition, approval, and the establishment of data warehouse integration with systems of record.
• Provided leadership in Data modeling for Conceptual, Logical and Physical data Models for Confidential, and OLAP using Informatica Confidential Hierarchy manager on SAP Customer Data USING Power Designer.
• Participated and provided leadership data quality compliance regarding standards, policies, and guidelines for cloud architecture
• Maintained pre-processing data for analysis & interpretation of clinical trials
• Provided leadership for the Implementation of data validation, accuracies, relevance in the enterprise.
• Developed data migration roadmap for moving data from 350 heterogeneous sources to single Confidential database
• Pro-actively identify alternate strategies for resolving both data and other technical issues associated with data conversion.
• 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.
• Provides guidance to team members on effective problem resolution by assisting them in the identification of alternatives and presentation of recommendations.

Environment: Confidential, ORACLE 10g, Confidential, Confidential, SAP Power Designer, Confidential, ER/Studio, Confidential IDA, Cognos, MSSQL, DB2, MVS, DATASTAGE, SAS

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 Confidential, Confidential, Data Warehousing, Confidential analysis for the design & Implementation of Customer
• Products, Confidential, and Prescribers data stores (using Informatica Confidential Hierarchy manager on SAP Customer & Product data, Power Designer, developed and maintained data quality reports and related business processes for corporate data using EVMPD, XEVMPD, IDMP, and RIM.

Environment: ORACLE 10g, SAP, TERADATA, Confidential, Confidential, Confidential, ER/Studio, Confidential IDA, MICROSTRATEGY, MSSQL, DB2, MVS, DATASTAGE, OWB, SPOTFIRE, SAS, BUSINESS OBJECTS, OBIEE

Confidential, Hoffman Estates, IL

Enterprise Data Architect

Responsibilities:

• Provided lead data architect solution including production DBA support for handling retail data for Sears Holdings at the enterprise level including data modeling support for Confidential, Confidential, Data Warehousing, Confidential analysis, design & Implementation for Customer and Products; OLAP and Reporting layers using Power Designer Data Modeler for XML/ Confidential 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,TERADATA, Confidential, Confidential, Confidential, ER/Studio, POWER DESIGNER, Confidential IDA, MICROSTRATEGY, MSSQL, DB2, MVS, DATASTAGE, OWB, SAS, BUSINESS OBJECTS, OBIEE

Confidential, Jacksonville, FL

Data Warehouse Architect

Responsibilities:

• Provided data warehouse architecture, design, development, administration support for Confidential Business Intelligence including data integration, Confidential analysis, design & Implementation for
• Customer & Products(using Informatica Confidential 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 ( Confidential on Legacy application and Confidential IDA on Enterprise architecture on Confidential Platform) support for Confidential, Confidential, Data Warehousing, OLAP and Reporting layers using Power
• Designer and Confidential Data Modeler for Confidential forward engineering, Model Manager and Confidential Data Profiler.

Environment: ORACLE 10g, DB2, SQLSERVER, TERADATA, Confidential, Confidential, SAP, Confidential, ER/Studio, Confidential IDA, MICROSTRATEGY, MSSQL, DB2, MVS, DATASTAGE, OWB, SAS, BUSINESS OBJECTS, OBIEE

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 Confidential architecture using Confidential 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, Confidential analysis, design & Implementation for Customer, Products & Confidential, management access control and implementation of recovery plans, monitoring, installation and configuration, administering, performance tuning, backup/recovery and data modeling support for Confidential, Confidential, Data Warehousing, OLAP and Reporting layers using Confidential Data Modeler for / Confidential forward engineering, Model Manager and Confidential Data Profiler.

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

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 Confidential architecture using Power Designer

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