Bi & Data Warehouse Architect Resume
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 ArchitectResponsibilities:
- 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.
