Sr. It Engineer Presales Consultant
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