We provide IT Staff Augmentation Services!

Data Architect Lead/ Lead Systems Architect Resume

SUMMARY:

  • Over fifteen years experience in data management, project management, database performance and maintenance, relational and dimensional modeling, ETL, BI Analytics, metadata and data dictionaries. Over 20 years total IT experience. Familiar with both Inmon and Kimball approach.
  • Currently working with Big Data developers with DataStax Cassandra, Spark/Scala Microservices using Kafka Data Streams, Cloudera Technology Stack, migrating EDW stage to Data Lake.
  • Knowledge of many Business Intelligence tools such as Microstrategy, DataStage, OBIEE, Hyperion, Business Objects, Information Builders WebFocus, Tableau, Computer Associates Eureka Strategy/ Eureka Reporter, and Cognos.
  • Experience in development involving back - end functions (RDBMS utilities and ETL concepts) and front-end (report generation, DML). Managed ETL teams using Ab Initio and DataStage and BI teams using OBIEE, Microstrategy and Actuate.
  • Work with requirements/sources from both domestic and international, including (but not all) POS from Europe and Loyalty from Asia, Australia, and Europe. Includes retail Licensed Stores, Joint Ventures, and company owned. Familiar with ARTS (Association of Retail Standards) model.
  • Experience at managing multiple engagements for large dynamic clients. Includes account management with emphasis on product delivery and cost control.
  • Experience with customer engagement.
  • Experience in conducting BI assessments to create a BI strategy based upon business needs and resulting technologies.
  • Experience in working with team technical evaluations and presentations.
  • Very Good knowledge and experience in developing best practices (Data Warehouse methodology), Data Modeling, Metadata management (Transfer rules, update rules) and ETL.
  • Experience with KPI’s driving Finance, Supply Chain, Manufacturing, Retail, Marketing, Sales, CRM/Loyalty, Personnel, Labor, Pharmacy, Media, Geospatial, Facilities/Vendor Management and Logistics.
  • Experience in Oracle, Teradata, Red Brick and Sybase data warehouse environments.
  • Excellent Communication skills, able to work with various levels of business from executive to developer. Strong analytical and design skills, success oriented, very self-motivated, thrives in multi-task environment.
  • Have held positions of Senior Project Manager, Business Engagement Manager, BI Product Line Manager, Senior/Lead Data Warehouse Architect, Senior/Lead Data Architect and Senior Data Warehouse Consultant and BI Administrator and DBA.
  • Experience with project scoping/estimations, SOW management, and customer relations.

EXPERIENCE:

Confidential

Data Architect Lead/ Lead Systems Architect

Responsibilities:

  • Lead Enterprise Data Warehouse Architect
  • Migration from traditional ETL to Big Data Platforms.
  • Architecture mainly on Oracle Exadata platform with minimal Teradata.
  • Oversee all Data Models for all projects touching Enterprise Data Warehouse.
  • Lead and maintained both physical and logical data models for EDW and Data Marts.
  • Work towards aligning department goals with corporate and specific customer goals.
  • Multiple layers of data zones, Stage, Atomic, Derived, Operational, Analytical using different modeling techniques such as dimensional, normalized, Starflake.
  • Extensive work leading projects in-charge of DataStage and Microstrategy development teams (onshore/offshore).
  • Establishment of best practices.
  • Usage of DataStage, Microstrategy, Oracle 10i/11g, OBIEE, Tableau, Erwin, Hyperion.
  • Sources of Oracle ERP, SAP, JDA, Convergys, Confidential .com, Micros Simphony, and other.
  • Work with management, including frequent meetings with VP, on BI strategies.
  • Currently Evaluating Big Data impact on EDW.

Confidential

BI Practice Manager

Responsibilities:

  • Engage with clients and understanding strategies, objectives and needs, both business and technical
  • Ensure team knowing and following current state of Data Warehousing trends and best practices.
  • Manage teams, and mentor both from communication and technical perspective.
  • Develop business and manage resources. Creation of proposal documents from RFP’s and SOW’s.
  • Work as representative of Confidential for organizations such as Gartner Group.
  • Microstrategy Product Line Manager.
  • Consult as Data Modeler/Architect on engagements. Review teams model solutions.

Confidential

Information Architect

Responsibilities:

  • Create data model for International finance and integrate into Enterprise Data Model
  • Analyze and re-engineer Stored Value Card system into Enterprise Data Model sourcing First Data.
  • Design ETL mappings and communicate rules to developers.
  • Help drive best practices in Information Architecture.

Confidential

Information Architect

Responsibilities:

  • Work on Enterprise Data Model sourcing SAP
  • Educate and mentor on Enterprise Data Models
  • Educate and mentor on Business Intelligence technologies.

Confidential

Engagement Manager

Responsibilities:

  • Communication with management to ensure proper engagement steerage and resource usage.
  • Manage SOW and overall direction to project team.
  • Manage expectations and relationships.
  • International travel in Asia for requirements gathering.
  • Engaged at major milestones to ensure quality and project delivery.
  • Review overall architecture to ensure following best practices.

Confidential

Engagement Manager

Responsibilities:

  • Communication with management to ensure proper engagement steerage and resource usage.
  • Work to ensure balance of resources between onshore and offshore development to deliver right product at right time at right cost.
  • Controlled SOWs and change management.
  • Managed expectations and relationships.
  • Engaged at major milestones to ensure quality and project delivery.
  • Developed overall architecture and created data model (logical and physical) for Teradata V2R5.
  • Worked at performance tuning against Teradata platform for Cognos ReportNet interface.

Confidential

BI Assessment Consultant

Responsibilities:

  • Worked with IT technical and management to clearly understand objectives and environment.
  • Reviewed source Oracle Application system in version change from 11.0.3 to Oracle 11i 11.0.10 to understand technical change impacts to Data Warehouse and other downstream reporting systems.
  • Understood functional changes and additions within Oracle Application system and the impact to downstream BI.
  • Understand impact to ETL, data model, and BI environment.
  • Transformed impact points into measurable work units to associate cost against.
  • Presented of impact assessment to director level.

Confidential

BI Assessment Consultant

Responsibilities:

  • Managed relations, overall strategy, and all SOWs.
  • Understood needs of Confidential and help strategic directions for BI environment
  • Created Logical and Physical model for data warehouse.
  • Presentation of methodology and extensive work with Erwin.

Confidential

Assessment Consultant - Data Warehouse

Responsibilities:

  • Determined BI strategy based upon business and technical requirements to create a product for call support analytics that was marketable and competitive in a fast changing industry.

Confidential

Assessment Manager

Responsibilities:

  • Worked directly with VP in evaluation of current state of data management resulting in high level recommendation document and proposal targeted for Senior Level Executives.
  • Evaluated Teradata architecture for bring together multiple disparate sources.

Confidential

Data Warehouse Architect / Business Liaison

Responsibilities:

  • Worked with Marketing on requirements and implementation of Category Management System.
  • Responsible for metadata storage. Worked with DBA, ETL and BI professionals in maintaining metadata including content, archives, usage, and audit.
  • Design & review data architectures to ensure business requirements.
  • Architected retail ODS system for multiple sources including Finance, Point of Sale, and Marketing.
  • Work with system to source Oracle Financials to data warehouse for analytics.
  • Worked with DecisionPoint software to provide Oracle Financials reporting.
  • Architect, implement, and maintain Microstrategy Environment on Intelligent Server 7i (7.2.x) and Web Universal 7.3.1. Lead Microstrategy contractor/consultant team in finding solutions on development for their customers.
  • Architected Microstrategy hardware environment.
  • Work on SQL generated optimized for Teradata V2R4 and V2R5. Also work with DBA’s on implementing PPI’s.
  • Main controller of all object manager and project merge functions..

Confidential

Data Warehouse Architect

Responsibilities:

  • Worked on supply chain datamart for external customers and on CRM for marketing/sales/customer service.
  • Design System layout for data warehouse to data mart structure.
  • Work with Finance on movement of information from Source to ODS to Data Warehouse to Business Intelligence.
  • Presented and Introduced BI technology to Enterprise Warehouse team.
  • Work as Teradata Data Architect and maintained physical schema in development environment.
  • Developed scripts using Teradata Utilities such as TPump, FastLoad, and BTEQ.
  • Lead team of ETL developers.
  • Work on integration of companies and sales due to acquisitions.
  • Lead Logical Data Models initiative for multiple systems including Shipping and Customer.
  • Implemented and lead administration team for Microstrategy platform.
  • Help develop Microstrategy reports, concentrating on Sales, Clickstream, and HR systems.
  • Give overall technical direction to local team under director as well as play large role across all teams.
  • Implemented several key customer warehouse projects.
  • Understand role and requirement of analytical software and interaction in Teradata environment.
  • Mentored co-workers.
  • Drive technical direction for BI tool and OLAP concepts/technologies.
  • Developed (modeled and reported) cycle-time logistics data mart on Oracle 8i.
  • Work with different BI tools such as Cognos and Business Objects.
  • Worked with Procurement, Legal, and Vendors in establishing and maintaining vendor contracts.
  • Use RDBMS utilities to move data from Teradata to Teradata, from Oracle to Teradata, from Teradata to Oracle.
  • Participated in Design of ODS system for CRM.

Hire Now