We provide IT Staff Augmentation Services!

Sr. It Engineer Presales Consultant

2.00/5 (Submit Your Rating)

Senior IT Professional Specializing

IT Strategy and Transformation

  • Information Architecture Vision, Strategy and Roadmap
  • Information Architecture Tools, Techniques and Best Practices
  • Enterprise Data Warehouse Architecture and Design
  • Business Analytics and Optimization
  • Relational Database Architecture and Management

Specializations:

  • Big Data Strategy, Architecture, Implementation and Management
  • Enterprise Data Warehouse Architecture and Design
  • Enterprise Information Architecture and Management
  • Enterprise Information Integration
  • Teradata Industry Logical Data Models Unified LDM, MFGDM, FSDM
  • IBM Industry Models IAA / IIW
  • IBM InfoSphere Information Management Solutions

Experienced in a Wide Spectrum of Industries:

  • Automotive
  • Insurance
  • Utilities
  • Entertainment
  • Health Care
  • Finance
  • Manufacturing

Fluent in English, Italian, French and Spanish

PROFESSIONAL EXPERIENCE

Confidential

SR. IT ENGINEER PRESALES CONSULTANT

Responsibilities include:

  • Leveraging Data Warehouse Technical Knowledge to Promote Sales of Data Warehouse Solutions within Several Industry Verticals
  • Playing an Active Role in Pre-Sales and Post-Sales Activities, Ensuring a Long-Term Partnership with Customers
  • Providing Technical Consulting to Support Sales and Professional Services PS Activities
  • Establishing and Enhancing Customer Relationships
  • Delivering High-Quality, Customer Billable Consulting on Services Engagements
  • Understanding, Documenting and Articulating Customers' Data Warehouse and Data Mart Architectures
  • Advising on Competitive Products in the Data Warehouse, BI and Big Data Space: Teradata UDA, IBM Big Data / BigInsights, Oracle, HP, Pivotal Data Hub, Hadoop Distributions Cloudera, Hortonworks , MapR, No-SQL Databases MongoDB, Cassandra, etc
  • Advising on Mainframe and Distributed Computing Environments
  • Articulating Customized Solutions to a Wide Spectrum of Business Problems using RDBMS, Master Data Management MDM , Cloud Services, Data Mart Consolidation, Big Data, Industry Logical Data Models, and Other Related Solution Offerings
  • Functioning as a Trusted Advisor to the Customer's Decision-Makers by Establishing Credibility and Expertise in both Information Architecture and Information Management
  • Identifying new Opportunities that will Lead to Capacity Expansion to the Customer's Data Warehouse BI Ecosystem, as well as High-Margin Services Engagements
  • Contributing to the Financial Objectives of the Team through Business Development and Demand-Creation Activities
  • Demonstrating the Ability to Relate Business Problems to the Underlying Data and the Ability of Technology to Solve a Customer's Business Challenges

Confidential

SR ENTERPRISE INFORMATION ARCHITECT

Projects: eCommerce System Redesign. Subject Areas: Merchandising, Cart Offer, Attraction and Venue

Sr. IT Architect Responsibilities included:

  • Analyzing Business Requirements and Creating High-Quality, Flexible, Logical Data Models
  • Mentoring other Project Team Members on Information Architecture Standards, Procedures and Best Practices

Environment: Sparx Enterprise Architect, CA ERwin Data Modeler

Confidential

SR ENTERPRISE INFORMATION ARCHITECT

Projects:

  • Enterprise Information Architecture Services
  • IBM InfoSphere Data Federation Platform Support

Sr. IT Architect Responsibilities included:

  • Creating and Maintaining High-Quality, Flexible, Logical and Physical Data Models using ERwin Data Modeler and IBM IDA InfoSphere Data Architect .
  • Reviewing Data Integration Requirements from Project Teams and Evaluate Eligibility of Data Federation as a Viable Data Integration Virtualization Option
  • Working Closely with Application Teams and Business Users to Identify Pilot Projects, Reporting Requirements, KPIs, Data Sources and Needed Facts Dimensions
  • Assisting and Mentoring Project Teams with Interaction with Federation Servers and Back-End Data Sources
  • Consulting and Participating in the Configuration and Administration of Data Federation Servers on UNIX/Solaris and z/OS Classic Federation , including DB2 LUW HADR
  • Designing, Developing and Implementing Federated Data Models and Federated Application Objects using IBM IDA InfoSphere Data Architect , Classic Data Architect CDA and IBM Information Server's IISD Information Services Director

Environment: DB2 z/OS V8, DB2 LUW 9.5, IMS/VS V7, Oracle 9i/10g, IBM InfoSphere Classic Federation, IBM InfoSphere Data Federation, IBM InfoSphere Information Server Information Services Director IISD , ERwin 7.2, IBM InfoSphere Data Architect IDA , Endeca

Confidential

INFORMATION ARCHITECT

Project: Business Intelligence / Data Warehouse Proposal for a Major Digital Media Client

Confidential

INFORMATION MANAGEMENT CONSULTANT

Project: Database Support during WMS Application Software Upgrade

Confidential

SR ENTERPRISE INFORMATION ARCHITECT

Project: Implementation of IBM WebSphere/InfoSphere Data Federation Technology

Platforms and Solutions

Implemented IBM InfoSphere Data Federation as a New Technology Platform to Expedite Delivery of Application Solutions Requiring Data from Both Legacy Distributed Systems, as well as a New Approach to Federate Existing Data-Marts within a Bottom-Up Approach to an Enterprise Data Warehouse Framework.

Sr. IT Architect Responsibilities included:

  • Performing in a Lead Role in the Coordination of Technology Proof of Concept POC Setup and Execution
  • Reviewing Data Integration Requirements from Project Teams and Evaluate Eligibility of Data Federation as a Viable Data Integration Virtualization Option
  • Working Closely with Application Teams and Business Users to Identify Pilot Projects, Reporting Requirements, KPIs, Data Sources and Needed Facts Dimensions
  • Assisting and Mentoring Project Teams with Interaction with Federation Servers and Back-End Data Sources
  • Consulting and Participating in the Configuration and Administration of Data Federation Servers on UNIX/Solaris and z/OS Classic Federation , including Setup and Operation of DB2 LUW HADR
  • Designing, Developing and Implementing Federated Data Models and Federated Application Objects using ERwin and IBM RDA Rational Data Architect , Classic Data Architect CDA and IBM Information Server's WISD Information Services Director
  • Creating and Executing Migration/Promotion Scripts across Federation Environments
  • Tuning Federated Queries Performance
  • Developing Standards, Procedures and Guidelines for InfoSphere Data Federation

Environment: DB2 z/OS V8, DB2 LUW 9.5, IMS/VS V7, Oracle 9i/10g, IBM InfoSphere Classic Federation, IBM InfoSphere Data Federation, IBM InfoSphere Information Server Information Services Director WISD , ERwin 7.2, IBM InfoSphere Data Architect IDA

Confidential

LEAD SR. INFORMATION ARCHITECT

Projects: - Call Center Analytics Reporting System

  • Travel Portal Reporting System
  • Lead Sr. Data Architect Responsibilities included:
  • Interfacing with Business Clients and Project Sponsors
  • Participating in Business Requirements Capture Sessions
  • Creating 3NF/Normalized Transitional Logical Data Models
  • Creating Multi-Dimensional Star Schema Physical Data Models
  • Assisting Mentoring ETL Design Development Staff
  • Defining Data Architecture and Data Governance Standards

Environment: ERwin 4.1, Business Objects, Siebel, Teradata, MS SQL Server, Informatica ETL

Confidential

LEAD SR. INFORMATION ARCHITECT

Projects: - Web-Based Policy Claim Inquiry System

  • Reporting System in the Areas of Finance, Actuarial and Enterprise
  • Lead Sr. Information Architect responsibilities included:
  • Participating in Requirements Gathering Sessions with Business Systems Analysts and Client Representatives
  • Creating Conceptual and Logical Data Models using Standard 3NF Modeling Techniques
  • Forward-Engineering Logical Data Models into Physical Database Schema Designs
  • Maintaining Data Dictionary
  • Collaborating with ETL Design Development Staff in an Agile/SCRUM environment

Environment: Embarcadero ER/Studio 7.1, Cognos ReportNet, Cognos ETL, Oracle 10g, SVN

Confidential

SR. DATA ARCHITECT / DATA WAREHOUSE ARCHITECT

Projects: - Home Entertainment Data Warehouse Sales Operations

  • Data Warehouse Conforming Dimension
  • Order-To-Delivery Data Mart
  • Vendor-Managed Inventory VMI Data Mart

Sr. Data Architect Responsibilities included:

  • Conducting Exploratory Meetings and Joint Design Sessions with Project Sponsors and User Representatives in order to Define Project Scope and Gather/Define/Document Business Requirements
  • Performing Conceptual Logical Data Modeling using Standard 3NF Modeling Techniques, as well as Star Schema Snow Flake Techniques for Data Warehouses and Data Marts
  • Transforming Logical Data Models into Physical Models with Special Emphasis on Denormalization Techniques to Optimize Performance
  • Working Very Closely with Development Staff to Provide Guidance and Technical Assistance in the Form of Data Mapping to Legacy Systems, ETL Strategy, SQL Complex Query Design, and Fast Performing Data Loads into the Target Database Tables
  • Performing Post-Implementation Reviews to Assess whether Data Integrity, System Utilization and Response Time Targets have been Successfully Achieved and whether Additional Database Turning is Needed

Environment: PowerDesigner 11.0, AllFusion ERwin 4.1, Cognos ReportNet, MS SharePoint, Sybase IQ, MS SQLServer, EAI/ESB tools

Confidential

SR. DB2 DATABASE ADMINISTRATOR

Projects: - Payroll Management System

  • PeopleSoft 7.01 HR System
  • Domestic Media Tracking System
  • Domestic TV Distribution System
  • Rights Residuals Systems
  • Network Television Systems
  • Retail / Studio Stores System
  • Studio Work Authorization System
  • Warner TV Systems

Sr. Data Architect

Responsibilities included:

  • Defining Business Requirements and creating Data Flow Diagrams
  • Reverse-Engineering from Existing Systems
  • Performing Logical Data Modeling
  • Transforming Logical Data Models into Physical Models
  • Providing Guidance to Development Staff
  • Defining Data Architecture and Data Governance Standards
  • Sr. DB2 DBA Responsibilities included providing Overall DB2 Technical Support:
  • Performing Logical Physical DB2 Database Design
  • Object Sizing and Defining DASD Requirements
  • Providing Database SQL Support to Application Developers
  • Providing 24x7 Around-the-Clock Production Support
  • Providing DBA Support during Migration from OS/390 to z/OS and from DB2 UDB OS/390 V5 to V7
  • Performing Ongoing Database Application Performance Tuning Both Pre- and Post-Production
  • Performing Ongoing Database Monitoring and Capacity Planning

Environment: DB2 UDB z/OS V7, DB2 UDB AIX/SOLARIS V7-8, DB2 CONNECT 7.1, NET.DATA, IBM DATA PROPAGATOR V7, CA-PLATINUM TOOLS, BMC CHANGE MANAGER, ERWIN 4.0, QMF, DB-ARTISAN, ER-STUDIO, PEOPLESOFT 7.0, INSYNC-DB2, MOVE-DB2, CA-INSIGHT PERFORMANCE MONITOR, BUSINESS OBJECTS

Confidential

SR. DATA WAREHOUSE SPECIALIST and

SR. DB2 DATABASE SPECIALIST

Confidential

DATA WAREHOUSE ARCHITECT

Confidential

DATA ARCHITECT and DB2 CONSULTANT

Confidential

DB2 DBA CONSULTANT

Confidential

DB2 DBA CONSULTANT

Confidential

DB2 DBA CONSULTANT

Confidential

PRODUCTION SUPPORT DBA and

APPLICATION SUPPORT SPECIALIST

Confidential

DB2 DBA CONSULTANT

Confidential

DB2 DBA CONSULTANT

Confidential

DB2 CSP CONSULTANT

Confidential

DB2 APPLICATION CONSULTANT

Confidential

IBM SYSTEMS ENGINEER

Confidential

IBM SYSTEMS ENGINEER

Confidential

IBM SYSTEMS ENGINEER

Confidential

IBM SYSTEMS ENGINEER

Confidential

IBM SYSTEMS ENGINEER

Confidential

IBM SYSTEMS ENGINEER

Confidential

SR PROGRAMMER / ANALYST

We'd love your feedback!