We provide IT Staff Augmentation Services!

Bi & Data Warehouse Architect Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Hard - working and dependable IT professional with 15 years experiences in IT system implementation, support and business workflow analysis.
  • 8 years IT project implement solutions, Excellent analytical and problem-solving / conflict-solving skills with proven ability to hit the ground running.
  • 7 years Business process improvement & Intelligent report architecture experiences.
  • Adept at contributing to team effort in all aspects of the system life cycle.
  • Successful roles as tech lead, tech designer, business analyst, QA tester and application developer.

TECHNICAL PORTFOLIO:

Methodologies: Project Management Body of Knowledge PMI member. Software Engineering Management Data Mining Progress SQL Designer

Platforms: Unix Microsoft Windows Linux, Novel Suse Novell Netware WANG OS Unix

Databases: Microsoft SQL Server 2003up Sybase ASE Oracle Database Progress DB2

ERP: QAD / SAP / Axapta / Hyperion Production Planning (PP) Sales Distribution (SD) Finance & Accounting (FA)

EAI & BPM: Brog Business E-Flow CorVu Business Intelligence Ware Crystal Reports(Microsoft & SAP) SQL Server Reporting Services Talend Data Integration system

Programming Languages: Object Pascal (Using Borland Delphi) Unix & Mainframe COBOL Unix Shell Microsoft WinScript Microsoft SQL Visual Foxpro Sybase Power Builder

Technologies: Database Mining & deployment Process Clustering Design Network Security Design Business Process Improve

KEY EXPERIENCES:

Confidential

BI & Data Warehouse Architect

Responsibilities:

  • Hands on experience in all aspects of building a user interactive, secure, e-commerce website utilizing Java applets, HTML and Java script programming.
  • E-commerce market: North Europe, North Africa, Asia Infrastructure maintained activities.
  • Interfaced system to existing Servers with TCP/IP, FTP and SNA connectivity.
  • Responsible for the daily operation of computers, servers, printers, and communications equipment.
  • Applies knowledge and skills to a wide range of standard and non-standard situations.
  • Translates user needs into clinical product requirements
  • Demonstrates clinical knowledge of pharmacy industry
  • Controlled expenditures in accordance with budget allocations.
  • Provided leadership in the implementation and support of factory automation, data management and shop floor systems.

Confidential

IT Manager, Fremont, CA

Responsibilities:

  • Planned and developed methods and procedures for implementing program.
  • Reviewed, evaluated, and approved specifications for ERP system supplier.
  • Managed program to ensure that implementation and prescribed activities were carried out in accordance with specified objectives.
  • Determined boundaries and priorities of new POS system and discussed system capacity and equipment acquisitions.
  • Planned and developed methods and procedures for BI program
  • Business Discovery
  • Analyzed data processing requirements to plan data processing system that will provide capabilities required for projected workloads.
  • Conferred with data processing and project managers to obtain information on the limitations of existing system.
  • DW Logical and Data Modeling
  • ETL Structure process define
  • Hardware networking / backup/ recovery deployment.
  • Front End Application Development ( User Application)
  • Back End application running service development.
  • Financial validation.
  • Accounting code control rule validation.
  • Financial process improvement.
  • Controlled expenditures in accordance with budget allocations.
  • Directed and coordinated program activities.

Confidential

Senior Program Manager

Responsibilities:

  • Responsible for the Government IT software and hardware improvement
  • Preparing RFP/RFQ for Government department tender issue
  • Initial plan of work
  • Establishing statement of work and execution of the program plan.
  • Planning schedule & breakdown working structure.
  • Budget Issues. 5 millions / per year and driving 3 years
  • 5 to 7 Projects per years, Have to finish and delivering object in 7 month from Initial to close phase.
  • Supervised planning and execution of the program
  • Methodologies & Skills
  • Risk mitigation plans
  • Rapid application development, Agile/Scrum, Waterfall
  • Control Project schedule process, Resolving conflict.
  • Change & Risk management control
  • Find out solutions for unexpected impact event
  • ICT center Technical support including (Level 2 & Level3 ): networking devices deploy installation education & training resolve the problem using various debugging methods
  • The Government includes: Saint Kitts, Saint Lucia, Confidential and Belize
  • Work with key business stakeholders to define a delivery strategy and roadmaps
  • Controlled operational budget and expenditures
  • DMV system
  • Criminal information System
  • Agriculture Resource System
  • Civil Status Registry System
  • Establishing Data Intelligent report for Police Department to prevent and predictive offence increase.
  • Integrated DMV/Civil/Criminal Records DB
  • Establishing Data Exchange rules & Platform.
  • Establishing Data Event Trigger rules (offense rate).
  • Methodologies & Skills
  • Waterfall, Prototyping, Agile, Rapid application development. e-Mail System
  • Country Root DNS(Domain Name service) build up
  • Government Web Portal
  • Hospital of Government system

Confidential

BI & Data Warehouse Architect

Responsibilities:

  • Government Web Portal
  • Database System of Supply Control Unit
  • Archives Information Management System
  • Database System of Investment Unit

Confidential

CIO & Senior Program Manager

Responsibilities:

  • Defined Statement of Work and Project Charter
  • Developed SAP-To-QAD Data Migration & Confidential Process.
  • Implement Confidential system: Germany and Confidential subsidiary Confidential Process.
  • Developed Germany and Headquarter Confidential Finance Consolidate Process.
  • To Implement distribution /Manufacturing / Financials modules
  • Writing UAT specs, performing Business process testing, documenting Lesson learn.
  • Collaborating with various teams to collect data / information and carry out assigned tasks
  • Establishing business flow fit into Mfg/QAD system flow
  • Establishing Statement of Work
  • Developed Enterprise Business Consolidate Process
  • Developed Work Flow Project Management Plan
  • Improved 20 business process, cost down more than one million.
  • Methodologies & Skills
  • Waterfall, Prototyping, Agile
  • Brog Business BPM, .NET, ETL, DW & BI
  • Establishing Data Migration and Exchange Platform
  • SQL Database deployments and configuration management
  • ETL / Data integration: Designed Data Mining rule and import data migrating process.
  • Defined and Create Enterprise High-Level Management Report
  • Establishing Business object
  • High level report: CEO / CFO / Entities Leader
  • Middle Level report: Sr. Manager
  • Regular Report: Key user
  • DW & BI system Integrating SAP/QAD/Oracle(HR)/AX/Hyperion Databadse
  • Methodologies & Skills
  • Waterfall, Prototyping, Agile, Rapid application development, KPI, Balance Score Card, strategic performance management
  • SSRS, SSIS, Crystal report, Corvu BI Development tools
  • Migrating Wang system(payroll) to New HR system(Oracle)
  • Handle HR system implementation project.
  • Evaluated subordinate job performance and conformance to regulations, and recommended appropriate personnel action
  • Oversaw, coordinated, and performed activities associated with shipping, receiving, distribution, and transportation.
  • Planned and developed methods and procedures for POS system implementing program. Successfully Implement POS system for Ordifen's 115 sites in China in 0ne year.

We'd love your feedback!