Jieranai T Maier



















 


Jieranai T Maier
United States
E-mail: jericarmel@aol.com


Education

QUALIFICATIONS:
  • Proven track record of building entire IT team and infrastructure from ground up, managing internal and external resources; In-depth knowledge of business logistics (manufacturing, financials, distribution, customer service, etc.); Implementation methodology of Database Management and Data Warehouse solutions; Hands-on experience with state-of-the-art computer hardware and software, Operating Systems, relational database design and modeling, programming languages and tools, Internet and Intranet and web design, telecommunication, remote access, e-mails. Setup policies and procedures.
  • 20+ years of IT and programming/system analysis experiences.
  • Excellent project management, communication, negotiation, employee motivation, team building, analytical and problem-solving skills. Technical competent and business savvy.

Operating Systems:

Unix, DOS, Windows 3.x, Windows95/98, NT, Windows 2000, MVS TSO, VM/CMS

Network:

TCP/IP, NetWare. LAN, WAN,

Languages:

SQL, Visual Basic, HTML, Java, Perl CGI-script, C++, Cobol, FOCUS, VB Script

Applications:

Oracle, Access, Microsoft Office, FOCUS, DB2, Sybase

Case Tools and Others:

IEF, LBMS Systems Engineer, Erwin, Silverrun, ER Studio, Realto, Sunrise, Tracker, SarosDM, Remedy AR System, FrontPage 98 FrontPage 97, MS Office , Intel Video Phone, Web Cam,

Misc. Softwares

 Dreamweaver, Photoshop, CoffeeCup, Java Razor, Visio, MS Project, MS Org Chart

 

WORK EXPERIENCE:
  • Faculty Member
    September 2002 - Present.

    University Of Phoenix-College of Information Technology

    Teaches online and on-ground Database, Database Systems (Oracle, Access), Systems Development and Web technology courses.

  • Data Architect,
    June 2000-June 2001

    Enterprise Data Warehouse,
    Intel Corporation.

    Data Modeling, Process Modeling using Silverrun case tools.

    Analyze and converted Oracle and SAP data bases to accommodate the designing and building of the new corporate Enterprise Data Warehouse.

    Managed Data modeling project from Logical design and implementation of Physical Database for Teradata database.

    Converted and Re-engineered from Oracle and SAP to Teredata using Silverrun case tools.

    Built conceptual, logical and physical data models utilizing existing business models.

    Direct interaction with Business Analysts and project team to assist in the designing of business entities and rules.

    Facilitated and participated in design, set up standards for the project.

    Facilitated and engaged in data modeling sessions.

  • Sr. Programmer/Analyst,
    1990 - 2001

    Planning & Logistics Group
    Intel Corporation

    Worked in various job function and job areas:
    24X7 Production Support Duties for Mainframe and Unix Server for Planning Systems (Order Planning and Scheduling Processing) and Intel Worldwide Inventory Systems. (Unix, Oracle, Visual Basic, Excel, Intranet Web Site, Window 98, Window NT)

    Data Modeling, Process Modeling using IEF, LBMS/Select Software Systems Engineering Case Tools. Managed Database Change Process and Cycle for

    New software releases. Managed Data modeling project from Logical design and implementation of Physical Database. DB functions for DB2 and Oracle Database. Converted and Re-engineered from IEF Case Tool to LBMS Systems Engineer. Converted database for the planning system from Sybase to Oracle

    Knowledge of building conceptual data models utilizing existing business models.

    Direct interaction with Business Analysts and project team to assist in the designing of business entities and rules.

    Facilitated and leaded data modeling sessions.

    Analyze existing data schemas and identify problems and opportunities for improvement, use existing data structures as a foundation for building new solutions, and map data flows between existing and new systems.

    Managed and used the case tools to create and maintain ERD and Data Diagrams and Data definitions.

    Trained new data-modeler to work with DBA's to assure ccorrect implementation of physical data model.

    Trained new programmers, developers and business analysts in the correct
    ussage of the data models and assure consistent usage across projects

    Managed the database change cycles to existing models and coordinate

    Implementation of database changes with program changes

    Systems Analysis using IEF & LBMS (Systems Engineer) CASE Tools.

    Programming in FOCUS for Finance and Planning Systems.

    Programming using SQL for Worldwide Inventory and Order Management Systems.

    Coordinated business reengineering to achieve maximum efficiency. (From 1992 to 1999)

    Knowledge of FOCUS, DB2, JCL, SQL, Visual Basic, Access, ASP, NT Server, UNIX, UNIX Web Server, Windows 2000, ORACLE 7.3, Erwin, Silverrun, Platinum ER Studio, PC hardware and software

    Web Master for Department and own personal web sites. Coding HTML, CGI, Perl, JAVA, on Unix, NT and Windows 2000 Servers.

  • Sr. Programmer/Analyst,
    1989 - 1990
    National Semi-conductor

    Sr. Programmer/Analyst for Mil-Aero Information System group.

    Programming and analysis for Planing, QA Specs, Finance and Marketing Departments using FOCUS, Cobol, REXX, Mainframe, VM CMS & MVS/TSO.

  • Master Planner/Systems Analyst,
    1978 - 1988
    Signetics/Philips
    <P>Sr. Master Planner and Systems Analysis for Standard Products Division.

    Responsible for Strategic, Tactical Mfg. Planning, Sales Forecasting Systems with $240 million in annual sales. Responsible for Monthly and Quarterly Capacity Requirement Forecasting.

    Responsible for FOCUS programming, maintenance of the Manufacturing, Assembly Forecast, and Planning Systems.

    Responsible for Plants Assembly and Sales Forecasting Reporting Systems.



    PERSONAL PROJECTS:

    Web Master and Director for a Non Profit organization.
    1995 - Present

  • Web Master and Founder of a not-for-profit web site.

  • Created and maintain interactive web site and contents for users worldwide.

    Board Of Director.
    2001 - Present

  • Member of Board Of Director of several non-profit organizations.
    Actively involve in and providing business guidelines, strategies and advices.

    CFO for Family business.
    1995 - Present

  • Business Information Systems & Financial Responsibility for family owned business.

  • Designed and maintain financial and marketing information systems for the business using Visual Basic and Access.
    REFERENCES:
    Supplied upon request


    
University & College Links:
    
. Saybrook Graduate School,
    San Francisco, CA.  
M.S. Systems Management,  
. College Of Notre Dame, Belmont, Ca. 
B.S, Applied Economics,  
. U. of San Francisco, S.F., Ca.  
A.S. Management & Supervision,
. Mission College, Santa Clara, Ca.

    Last updated - May, 2003