We provide IT Staff Augmentation Services!

Principal / Information Management Resume

SUMMARY:

  • Over 25 years of hands - on experience creating solutions across multiple architecture domains - Big Data, Information, Data Warehouse, Database, Integration and Technology. Working experience with multi-terabyte Data Warehouses, Big Data and cloud based solutions.
  • Real Estate, Telecommunications, Insurance, Healthcare, Pharmaceutical, Retail/CPG, Logistics and Supply Chain industry verticals expertise.
  • Led successful $3.5MM+ project implementations, managed cross functional teams of 25+ people (on-shore and off-).
  • ITIL certified, experienced in various SDLC methodologies such as Agile and Waterfall, regulatory and compliance requirements (SOX, HIPAA ), Data Warehouse Methodology (Kimball and Inmon) and Enterprise Architecture Framework (TOGAF).

TECHNICAL SKILLS

Software Packages: SAP, Salesforce.com, Siebel, Model N, Trackwise, Aris, Documentum, I-Many, Quantum, JD Edwards

Big Data Technologies: Cloudera CDH, Hortonworks HDP, Apache NiFi, Hive, HBase, Impala, Spark, Kafka, Flume

BI/Reporting: Business Objects, Oracle BI, Cognos, Datameer, Brio Query, SQR, Impromptu, Cypress

Data Management/ MDM: Talend, SAP, Informatica, IBM, Alation, Waterline Data, Collibra, Cambridge Semantics

Data Integration/Data Quality/ETL: Talend Data Fabric (includes all components), SAP - BODS/BODQM, Information Steward; Oracle Data Integrator, Oracle GoldenGate, DataFlux, IBM DataStage/QualityStage, Informatica, Alteryx

Data Modeling: ERwin, Toad, PowerDesigner, ER/Studio, Visio for Enterprise Architects

Data Warehouse/ Database Platforms: RDBMS - Oracle (Exadata), Teradata, SAP HANA, MySQL, MS SQL Server NoSQL - HBase, Amazon Redshift, Cassandra, MarkLogic, MongoDB

Cloud Computing: Amazon Web Services, Microsoft Azure

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, Apache Hive (HQL), HTML, Java, JSON, XML, Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential

Principal / Information Management

Responsibilities:

  • Building a unified, cloud based Cyber Defense Data Platform to support information security analytic needs, to streamline data discovery, collection and persistence, and to provide self-service analytic capabilities for the members of Information and Cyber Security organizations.
  • Architecture, design and implementation - real-time and batch data integration framework, data storage (persistence) area, and analytics layer.

Technical Environment: AWS - EC2, S3, IAM, ELB; Apache NiFi; Splunk Enterprise; Logstash; Oracle

Confidential

Principal / Information Management

Responsibilities:

  • Solution Architect responsible for evaluation and selection of the Data Catalog platform for Confidential ’s Big Data and Analytics space.
  • Gathered, analyzeed and documented business requirements and KPIs, created use cases, defined vendor selection and success measurement criteria.
  • Organized and facilitated product demos from various vendors, drove the final vendor(s) selection process to perform POC.
  • Assessed maturity level, defined Data Governance strategy, architecture, processes and implementation roadmap for Big Data and Analytics landscape.
  • Defined and documented self-service data access patterns, authorization, authentication and auditing processes, high-level information lifecycle strategy and supporting technology stacks.

Technical Environment: Hadoop - Cloudera CDH 5.x, Hive, Impala, Navigator, Sentry; Oracle 12c; Data Catalog - Alation, Collibra, Waterline Data, Cambridge Semantics

Confidential

Principal / Information Management

Responsibilities:

  • Built a robust Data Foundation Platform to support information analytic needs, to streamline data discovery and collection processes, and to provide self-service analytic capabilities for business and IT users. Designed, developed and implemented Global Data Warehouse that will support over 20 Data Domains and multiple organizations and users across dispersed geographical regions.
  • Solution Architect / Delivery Lead - responsible for the architecture, design and overall project implementation. Led a cross-functional, on/off-shore team of 25+ people - Business, Data and QA Analysts, Data Modelers / Architects, and ETL Developers. Accountable for the project deliverables of all sub-teams.
  • Drove Data Warehouse strategy, planning and roadmap design discussions. Evaluated and recommended technology platforms and tools for the implementation - on premise vs. cloud, Big Data vs. NoSQL vs. RDBMS, open source vs. proprietary code, etc.
  • Defined and implemented DW governance, compliance, security and auditing models, policies and procedures; and robust data integration architecture that leverages reusable ETL framework to load and transform data from disparate source systems into Data Lake (Hadoop) and GDW (Oracle).
  • Conducted working sessions with business users, functional and technical teams to determine and evaluate project requirements, perform current architecture state and gap analysis, identify and document data classification and validation rules, source to target mappings, and current DW usage. Defined future state data and technology architecture and determined short and long-term architecture recommendations.
  • Created conceptual, logical and physical data models, data migration plans, and process flow diagrams.

Technical Environment: Hadoop - Hortonworks HDP 2.3, Hive, Sqoop; Talend - Data Prep, Data Fabric 6.1, MDM, Metadata Manager; Oracle 12c; Erwin 9.64; Linux; AWS (evaluation)

Confidential

Principal Consultant / Information Management and Analytics

Responsibilities:

  • Created and deployed a guest-centric, mobile-first digital platform that enabled the delivery of highly targeted and personalized messages, programs, and experiences across the path to purchase, on and off the mall properties, for guests, mall associates and tenants.
  • Assessed and documented current state architecture and identified gaps. Defined future state data and technology architecture. Created data migration plans, facilitated working sessions for data attributes definitions, source to target mappings, ETL transformations, and data integration.
  • Drove database design discussions, created conceptual and logical data models and data flow diagrams.
  • Worked closely with technology groups to make sure optimum design and integration of on premise applications and cloud-hosted database (Microsoft Azure).
  • Facilitated vendor selection process by creating RFI, conducting vendor interviews, and preparing vendor assessments and recommendations.

Technical Environment: Microsoft SQL Azure; Jira; JD Edwards; Adobe Experience Manager; Adobe Target; Jibestream (digital maps and wayfinding platform); Gigya (social sign-in); Alteryx (Data Profiling); Java; JSON

Confidential

Principal Consultant / Information Management and Analytics

Responsibilities:

  • Architecture, design and implementation of Enterprise Financial Information Hub - a single and trusted source of balanced, reconciled, and consistently classified financial-based information for Risk Adjustment, Reinsurance, Risk Corridor, and other regulatory reporting requirements.
  • Facilitated information gathering sessions to perform current architecture state and gap analysis, identified and documented data classification rules, source to target mappings, and current DW usage.
  • Conducted data modeling sessions to modify existing data models for better system performance and scalability, and to better support business processes.
  • Designed solution to decommission and replace a mainframe-based legacy system handling financial reporting on all finalized and paid claims activities and providing data for the enterprise General Ledger balancing.
  • Conducted working sessions with SME’s to gather information about current processes, data flows, data extracts/enhancements/classifications/transformations and reports. Prepared decommissioning approach framework, data migration templates, and project plan tasks and estimates. Drafted Request for Information (RFI) document for classification engine vendor selection process.

Technical Environment: Teradata; Oracle; DB2; Mainframe; DataStage; COBOL

Confidential

Principal Consultant / Data and Technology Architecture

Responsibilities:

  • Re-platformed and migrated all Oracle-based enterprise systems, including SAP ERP, CRM, SCM and BW, onto Oracle Engineered platform.
  • Defined solution architecture; policies and procedures; monitoring and performance KPIs.
  • Created systems integration and near-zero-downtime data migration framework, quality of service (QoS), security, auditing and compliance models.
  • Directed ETL Developers / Administrators team; coordinated team efforts to meet business customer commitments and quality expectations.
  • Led SAP BI and SAP Data Services installations and upgrades ensuring adherence to best practices, project deliverables and enterprise architecture principals and roadmaps.
  • Architecture, design and implementation of Enterprise Customer Master Data Hub - consolidated master data repository that enables sharing of master data between Business Units, data integration and master data governance.
  • Conducted information-gathering and data mapping sessions with business users, technical teams and software integrator to determine and evaluate project requirements and to identify best-fit architecture solutions and data integration patterns with various data sources.
  • Consulted and advised technical teams and software vendors on the architecture and performance of application software running on Oracle Engineered platform.

Technical Environment: IBM - Master Data Management (MDM), Business Process Manager (BPM), Information Server (IIS), DataStage, QualityStage, SAP Packs; Oracle Exadata X4; Linux; Windows

Confidential

Principal Consultant / Data and Technology Architecture

Responsibilities:

  • Architecture, design and implementation of BI solution with near real-time data replication and reporting platform; system performance optimization.
  • Created Logical and Physical Data Models for the reporting database. Designed, configured and implemented near-real time data replication with Oracle GoldenGate. Consulted and advised Application, DBA and BI technical teams on system performance best practices and techniques.

Technical Environment: Oracle; Oracle GoldenGate; Cognos; TOAD Data Modeler; Crystal Reports; Unix

Confidential

Principal Consultant / Data and Technology Architecture

Responsibilities:

  • Architecture, design and deployment of Enterprise Information Management (EIM) solution that resulted in unified decision-making platform and increased operational efficiencies for the business users.
  • Facilitated information-gathering sessions with business users and technical teams to determine and evaluate project requirements and identify best-fit architecture. Defined architecture and design of ETL and dashboard reporting solutions.
  • Led SAP Data Services upgrade project including definition of project scope, facilitation of architectural discussions, solution documentation, team mentoring, and implementation.
  • Data and Technology Architect for the Model N Performance Optimization project. Collaborated with business users, technical teams, and hardware/software vendors to identify and prioritize system performance issues, design strategies and overall architecture. Delivered high performance, high availability solution that achieved 17x performance improvement and saved the company over $6MM.
  • As part of POC efforts, evaluated and benchmarked performance of Amazon Redshift database running on Amazon Web Services (beta release) vs. Oracle on AWS vs. Oracle RDS on AWS.

Technical Environment: SAP - Data Services (4.0/4.1), PI; Oracle - Exadata/Exalogic X3, GoldenGate, RAT/RUEI, OEM, Weblogic; SQL Server; Model N; Java; QlikView; Unix; Linux; Windows; Amazon Web Services (AWS); Amazon Redshift (beta)

Confidential

SAP Solutions Architect

Responsibilities:

  • Data and Technology Lead for a B2B solution leveraging SAP’s modules and technologies and integration with over 20 legacy systems.
  • Managed Data Migration and Integration efforts from the legacy systems into a Data Lake (Hadoop) environment and SAP. Accountable for the project deliverables of onsite and offshore Data Migration and ETL teams and for Data Governance efforts.
  • Reviewed and approved strategy and design documents for technology, integration and information management domains, functional and technical specifications.
  • Led data profiling and data quality efforts, analysis of data extraction process from various data sources; architecture and design of ETL processes and data mappings.
  • Defined and deployed SAP technical architecture that included High Availability solution using Oracle Grid Infrastructure. Managed installation, configuration and performance optimization of all SAP software modules. Coordinated the project activities of technical groups including Infrastructure, DBA, SAP Basis, and ETL developers, working in close collaboration with the software vendor, service integrator, business users and other technical teams.
  • Collaborated with Confidential ’ subsidiary - MetaScale, on SAP HANA proof of concept (POC) implementation with Hadoop, SAP Data Services and Amazon Web Service (AWS).

Technical Environment: SAP - ECC, CRM, PI 7.31, Solution Manager, MDM, WCEM, BODS/BODQ, Information Steward, SAP HANA; Oracle - RAC, ASM, Grid Infrastructure, SAPCTL; Linux; PeopleSoft; Informix; Hadoop; Hive; Datameer; DataFlux; Amazon Web Services (AWS); Mainframe

Confidential

Sr. Enterprise Data Architect

Responsibilities:

  • Partnered with business and technology stakeholders to implement the strategy and roadmap for data and database architecture. Member of the Architecture Review Board (ARB).
  • Led a team of 12 DAs/ETL Developers (on-shore/off-shore), and coordinated team efforts to meet business customer commitments and quality expectations. Mentored and coached team members.
  • Set strategic technical direction for Enterprise Business Intelligence (BI) and Data Warehouse (EDW) environments. Architecture, design, and implementation; data and gap analysis; data modeling.
  • Delivered an improved EDW architecture with more efficient master data management, data governance and data integration. Reduced overall data footprint and traffic across enterprise, reduced ETL processing by 25% and business reporting runtime by 30-40%.
  • Defined architecture and led integration of multiple disparate Data Warehouse and Business Intelligence implementations and their infrastructure into an interconnected ecosystem. Realized over $1MM in annual savings by reducing license costs, consumption of storage, hardware and other resources, application processing times, administrative and maintenance costs, and improved SLA.
  • Architecture and design of Oracle High Availability (HA) Solution resulting in a projected annual cost savings of over $500K.

Technical Environment: Informatica; Siperian (MDM); Cognos; JD Edwards; TOAD Data Modeler; TOAD for Data Analysis; Quantum; Documentum; Teradata; Oracle - RAC, ASM; Linux; HP-UX; Solaris; EMC Data Domain

Hire Now