We provide IT Staff Augmentation Services!

Advisor / Data Architect Resume

2.00 Rating

PROFESSIONAL EXPERIENCE:

Confidential

Advisor / Data Architect

Responsibilities:

  • Directing sensor data collection Solutions supporting data monitoring and control systems. an advisor implementing the integration of big data and remote data collection systems.
  • Providing professional services teams direction in building long term data management strategies leveraging emerging technologies as the reporting platform for very large data volumes.

Confidential

Data Architect

Responsibilities:

  • Data Architect for Enterprise Data Warehouse projects supporting data modeling and reporting view layer entity relationship discovery and identification.
  • Analysis supporting the definition of in - scope data elements required for harmonizing the equipment domain and integrating with other business entities across the enterprise.
  • Analysis of the ETL system to discover scheduling and transformation logic for sourcing data requirements.
  • ErWin, Teradata, Teradata Utilities, AIX, Maestro (Tivoli Workload Scheduler)

Confidential

Data Architect

Responsibilities:

  • Professional Services Data Architect for Decision Support Services implementation. Driving the deployment of new data sources resulting from SAP and JDA ERP implementation efforts from the Architect role down to the DBA role. Full scale data warehousing solution including all phases of blueprint to cutover planning.
  • SAP data captured using data extractors. Teradata data loads using Business Objects Data Services and Teradata Parallel Transporter.
  • Slowly changing dimensions implemented using a valid from and valid to period date approach. Development of high level documentation down to technical interfacing, and operational implementation of products IBM IDMS, Business Objects Data Services, Teradata Utilities, Teradata Data Models originating from Erwin, and Cognos reporting platform data delivery.
  • Professional Services Data Architect for Initial Enterprise Data Warehouse migration from IBM DB2. This was the first step in expanding the existing data warehouse to handle more data and queries migrated the DB2 physical data design to Teradata, of course many subtle changes are required to take advantage of Teradata’s architecture.
  • Point of Sale information combined with product display analysis by merchants and product management where top priorities.
  • Teradata provided standard reporting and adhoc query utilizing the IBM Cognos platform for Business Intelligence applications.
  • Informatica, Business Objects Data Services, and Teradata Parallel Transporter where used as ETL tools to load data on daily, weekly schedules.

Confidential

Solution Architect

Responsibilities:

  • Integrated Data Warehouse design, development, and management utilizing professional services methodology on client engagements.
  • Full data warehouse life cycle development and deployment technical management and lead development.
  • Technical Solution Sales to customers. Providing technical expertise to pre-sales solutions.
  • Developing customer solutions and roadmaps for leveraging data as an asset.
  • Development of proposals, statement of works, project plans, and staffing requirements as well as oversight of projects in execution.

Confidential

Project Manager

Responsibilities:

  • leading the professional services delivery and engagement development of the first Teradata appliance for an enterprise data warehouse project supporting the Marketing Data Platform.
  • Managed and directed a team of 12 consultants, 4 onshore and 8 offshore.
  • MDP SQL Servers to Teradata Migration Project involved the conversion of the current MS SQL-based Server environment to a 15 node Teradata 2650 platform with a 9 node Teradata 2650 disaster recovery platform.
  • The MDP platform supports a multi-million target marketing campaign application supporting Unica, Siebel, SAS, and Oracle analytics.
  • This customer provided personnel and management new to Teradata.
  • Emphasis on mentoring and knowledge transfer was a significant need of the project.
  • Multiple platforms of data sources included SQL server, Oracle, and Teradata.
  • Challenges to overcome included the scoping of 2.4M lines of code down to a reasonable.
  • Delivered a High Level and Low Level design along with guidance on integrating architecture, metadata, data quality, data lineage, governance, and managed services within the bank environment.

Confidential

Project Manager / Solution Architect

Responsibilities:

  • professional services delivery and engagement development of a new enterprise data warehouse project.
  • Managed and directed a team of 6 consultants to provide Informatica ETL and Teradata data management components.
  • This customer was new to Teradata, personnel and management.
  • Emphasis on mentoring and knowledge transfer was a significant need of the project.
  • Multiple platforms of data sources included SQL server, Oracle rdbms, and unstructured master data stored in spreadsheets.

Confidential

Project Manager

Responsibilities:

  • Managing the professional services delivery and engagement project.
  • Responsible for development of an Informatica, Teradata, Business Objects platform of products utilizing an onshore and offshore ADC development team.
  • Managed and directed a team of 16 consultants to provide ETL, Teradata data management, SAS, and Business Objects universe reporting components.
  • The project migrated world wide data from an existing oracle data warehouse to the Teradata platform resulting in a significant improvement in performance and in most cases actually completed complex queries in minutes rather than hours.
  • Some challenges included the management of Unicode based data and upgrading the Informatica platform to support this data during loading.
  • An incremental approach was taken to reduce the overall project risk by loading sets of subject areas in multiple iterations.
  • The ADC offshore team played a major role in the development and delivery of the ETL deliverables.
  • Managing the engagement of professional services methodology supporting the Sabre20 component of the Mosaic engagement. Responsible for operational data store consolidation of 10 data marts into the AA integrated data warehouse.
  • Leading the definition of source data elements, approx. 10,000, mapping the data entities to integrated data components, logical data modeling utilizing ERWin, Teradata physical data modeling, Data Stage ETL requirements and development, semantic view layer requirements and development, and user acceptance testing.
  • Managing and directing a team of 4 on-site and 4 off-shore, ADC resources.
  • Responsible for the Sabre20 data marts overall progress and success.
  • Directly influencing the customer’s activities and facilitating agreements on development and delivery methodology.
  • Full data warehouse life cycle development and deployment.

Confidential

Project Manager

Responsibilities:

  • Responsible for development of a set of baseline Cognos-based air reporting capabilities for Sabre Airline Distribution & Marketing personnel.
  • The cubes and reports are based on data from the Enterprise Travelers Data Warehouse, Scorpion, and GDS Reporting Universe.
  • Also provided documentation, training, and technology transfer services.
  • Managed and directed a team of 6 consultants to provide Sunopsis ETL, Teradata data management, SAS, and Cognos cube reporting components.
  • Determined the Business Continuity, Data Synchronization, Workload Management, and Systems Management requirements of the Teradata applications that Sabre utilizes for the Enterprise Travelers Data Warehouse, analyzed the requirements, and designed a Teradata Dual Active solution to satisfy the requirements.
  • Determined the data and source(s) associated with the applications.
  • Examined the current ETL for any revisions needed.
  • Designed and documented a solution capable of synchronizing this data between the two systems.
  • Developed a Data Synchronization implementation plan, including the number of tables to be synchronized and the synchronization methods used for each table.

Senior Product Manager

Confidential

Responsibilities:

  • Managing the development of professional services methodology and engagement assets supporting Master Data Management engagements.
  • Responsible on a Global product deployment scope, interfacing with internal Marketing, Engineering, Training, Sales, and Professional Services resources to develop service offerings.
  • Driving cross-functional alignment, program management, global requirements capture, internal budgeting and business case development, 3rd party partnerships, development and delivery of tools and assets which become part of the MDM proposed offer.

Confidential

Enterprise Architect

Responsibilities:

  • Leading business development, marketing teams, and providing architectural assessments and recommendations to senior management on consulting services opportunities. Responsible for supporting all technical aspects for Air Force Logistics enterprise architecture and major program acquisition strategies.
  • Full life cycle activities from Enterprise modeling, project sizing, technical road maps for development and deployment of application systems, portfolio management, legacy modernization, business justifications, and COTS integration projects ranging from $1M to $250M.
  • Developed teaming agreements with CSC to leverage the ECSS program win, $1.2B, providing the enterprise architecture and integration roadmap.
  • Delivering technical thought leadership in the incremental improvements required for sustaining long-term maintenance of program software solutions focusing on Enterprise Architecture Frameworks and Portfolio Management.
  • Creating and defining Enterprise Architecture Frameworks consisting of various approaches, models, and definitions for communicating and facilitating the presentation of key architecture components (i.e. architecture vision, governance, principles, guidance, products, etc.) required for the development and integration of business domain architectures.
  • Enterprise Architecture Frameworks establish a common foundation for understanding, comparing and integrating architectures and as such provide the overarching guidance for generating domain architectures. The resulting artifacts document the linkages between business needs, information content, and information technology capabilities.
  • Developed “integrated plans or roadmaps” to conduct capability assessments, guide systems development, and define the associated investment plans as the basis for aligning resources.
  • Critical to the execution of enterprise architectures is the demonstration of visibility and management of the resources allocated to IT investments. Portfolio management permits business units to assess, prioritize, and allocate funding for IT, as well as identify redundancies and opportunities for increased efficiencies.
  • Portfolio management ensures IT investments are synchronized with the Architectural Blueprints.
  • Advising and developing technical approach solutions involving Enterprise architecture technical tools and frameworks including Confidential modeling, Service Oriented Architectures, Global Combat Support Systems (GCSS-AF) integration framework, and Air Force Enterprise Information Technology Strategies core to the business solution.
  • Exercised a full understanding and training of the technical workings and various component/levels of the Confidential and DoDAF architectural frameworks supporting Government contract proposal development and program execution including government mandated requirements and compliance.
  • The Air Force Federated SOA realized in the GCSS-AF IF consists of Discovery, Mediation, Enterprise Storage, Enterprise Application Hosting, Information Assurance/Security, User Assistance, Enterprise Services Management, Collaboration, and Messaging.

Proposal Manager

Confidential

Responsibilities:

  • Managed bid and proposal life cycle for Confidential ’s request for proposal to obtain services for the “As-Is” state for the State’s email infrastructure requiring the preparation of a business case, using a planned methodology to provide alternative solutions for cost savings and efficiency as well as establishing standards for the Confidential .
  • The Confidential ’s enterprise architect initiatives govern themselves in accordance with the Confidential .

We'd love your feedback!