We provide IT Staff Augmentation Services!

Data Warehouse Architect Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • 14 years of experience in the analysis, design, development, testing, deployment, and support of various data processing/analytics and other IT solutions in financial (banking and insurance), pharmaceutical, logistics, manufacturing, and retail sectors.
  • Designed, developed, profiled and tuned for performance ETL data pipelines leveraging Informatica, Oracle platforms.
  • Experience in developing automated solutions, reports, and dashboards.
  • Maintained relationships with business owners. Built effective and long - term relationships with internal and external customers. Collected and formalized business and system requirements for IT products.
  • Vendor and contract management, procurement: negotiations, competitive tenders, contracts.
  • Strong communication and presentation skills, adaptability, quick decision making, teamwork.

TECHNICAL SKILLS:

Industry Knowledge: Data Governance, Data Modeling, Data Management, Business Intelligence (BI), Data Governance Framework, Data Quality, Data Analysis, Data Warehouse, Master Data Management, Requirements Analysis, Business Analysis, Change Management, Agile Methodologies, Oracle BI, Data Warehousing, Data Migration, Project Management, Business Process Improvement, Stakeholder Management, ETL, Informatica PowerCenter, Informatica Data Quality, Informatica Developer, Informatica MDM Hub, Informatica Axon, Unified Modeling Language (UML). Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes, experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS, experience with Oracle E-Business Suite 11i and R12 and Oracle Developer Suite.

Technical Skills: SQL, Oracle, Oracle PL/SQL Business Objects, Cognos, Microsoft Business Intelligence, SQL, Oracle, Teradata, Liferay, SharePoint, SAP, Salesforce, NetSuite, Webex, Google Analytics.

Soft Skills: Communication, Problem Solving, Teamwork, Leadership, Time Management, Organizational Skills.

WORK EXPERIENCE:

Data Warehouse Architect

Confidential

Responsibilities:

  • Overseeing the ETL pipeline for business data workflow using Informatica PowerCenter 10.2
  • Responsible for the design, development, and deployment of data architecture and data models (physical and logical) using Oracle database 19c
  • Working together with various business units to analyze business requirements and develop data warehouse platform vision, strategy, and roadmap
  • Oversaw the MDM system design, development, and operation
  • Analyzed data lifecycle, diagnosed, and resolved data corruption causes in client data

Team Leader of IT Application Development

Confidential

Responsibilities:

  • Oversaw all corporate ERP systems, incl. internal operations, customer-facing operations, etc.
  • Led a development team
  • Oversaw compliance with Russia, EU, USA regulations on data handling
  • Responsibilities included risk management, personnel management
  • My contributions resulted in summary savings of 5% for the corporate IT budget

Senior Data Warehouse Architect

Confidential

Responsibilities:

  • Drove the functional architecture and design of the data warehouse processes following Agile methodology
  • Managed the data warehouse processes, including initiation, planning, execution, control, closure, and communication
  • Oversaw data ingest, processing requirements analysis for the ERP systems
  • Controlled budgeting, equipment, and middleware platform acquisition

Data Warehouse Manager and Architect

Confidential

Responsibilities:

  • Managed the technological infrastructure of HR consulting department
  • Was responsible for architecting and delivering DWH and data integration client solutions
  • Produced and delivered hundreds of BI dashboards and reports
  • Delivered solutions leveraging Apache Kafka, Apache Superset, PostgreSQL, Pentaho ETL
  • Our data insights resulted in 15% average savings in total operating costs for the clients

Data Governance Manager

Confidential

Responsibilities:

  • Drove all stages of the data quality lifecycle: requirements & cost analysis, design & architecture, implementation, testing, deployment, client & support
  • Led the team building the Product 360 PIM (product information management) framework of GOODS online marketplace platform, and integration with other systems (merchant platform, manufacturer portal)
  • We were the first to apply the proper Golden Record MDM methodology in Kazakhstan banking industry
  • We built solutions leveraging the following Informatica data platforms: Data Integration, Customer 360, Data Catalog, Data Quality, MDM & 360 Applications
  • Managed Informatica on Linux servers: deployment, administration and performance tuning
  • Overseeing the ETL pipeline for business data workflow (88 TB, 105000 Tables, 400 ETL Workflows) using Informatica PowerCenter
  • Responsible for the design, development, and deployment of data architecture and data models (physical and logical) using Oracle database on Exadata
  • Implemented business automation: Purchasing, Sales, Cost, Warehouse Management (WMS), integration with other systems (MDM, 1C, and others)
  • Acted in various project roles: architect, project manager, lead consultant, client manager
  • Worked as a project manager in presale activities (Leroy Merlin, KamaGames (mobile game dev), NTV Broadcasting Company, Eurocement, EuroChem, Protek, Linzmaster, and others)

We'd love your feedback!