Candidates About

 

Myint Htwe

 

PROFILE:                             

 Professional with 20 years of experience in the project management, business analysis, quality assurance and application development, operation and management of application and database systems/data warehousing, including design, research and hardware selection that result in the ability to conduct fact-based management that effectively supports the business, as well as in the implementation, support and maintenance of production environments and software testing.  

 

Nine years of direct experience in planning and coordinating with various business partners to define corporate reporting and analysis requirements, liaising with functional and technical counterparts to accurately translate the business requirements into detailed technical specifications, and finally ensuring quality control of the delivered product.  

 

A key strength in business analysis, quality products delivery and collaborating with financial professionals, project managers and developers. With senior management direction, improved operational efficiency on providing business intelligence. Solid technical knowledge of PeopleSoft Systems in Financial, EPM, and Human Resource Modules and WORKDAY HCM Modules.  

1

 

EDUCATION:            NEW YORK INSTITUTE OF TECHNOLOGY, New York

Degree and Academic: Masters of Science in Computer Science

Passed with distinction

 

SOFTWARE:  Windows 2008/2003/2000, Sun Solaris 8/9,  Microsoft IIS 6.x, Microsoft SQL Server 7.0/2000/2005/2008/2012/2014(SSAS,SSIS,SSRS), Oracle 9i/10G/11G, Hyperion Business Performance/Interactive Suite On Demand Server 6.6/8.3, SYBASE SQL Server 12.x, 14.x ,  VMWare GSX/ESX,  Hyperion IR11, Brio Query Tools, Business Objects,  .Net Development on SOA/Database Applications and XML, Erwin Tools, Toad, Visio, Visual Mining Dashboard Software, Panorama Business Intelligence Software, Netik Data Warehouse, Pivotal CRM System, PeopleSoft 9.0 AP/KK/GL. OBIEE 10/11. Oracle Financial EPM 9.x, Workday HCM, Data Stage 8.1, Tableau 10.x and Microsoft Power BI.

 

 

Experience

 

University of Texas at Austin (UT) (2017 June – Current)

Business Analyst BI  (Student Information System Data Warehouse)

 

Perform business process & requirements analyses by leading stakeholder engagements on the gathering, documentation & detailed analysis of business requirements, and the mapping of business processes into functional & technical specifications for team’s modifications & integrations to existing BI data & reporting capabilities. 

Analyze current operational procedures, investigate problems and other data quality reports and recommend solutions. 

Document/analyze/translate client/business requirements into technical requirements 
Define current and future operational scenarios (processes, models, use cases, plans and solutions) 

Collaborate closely with our BI Team to develop, co-develop and enhance BI data capabilities & reporting solutions following the Agile methodology and the Ralph Kimball approach to data warehouse development. 

Coordinate and collaborate with functional users, software & system teams to identify, develop and co-develop BI solutions that automate data loading, data processing and analytics reporting from a variety of data sources. 

Participate in a Business Analyst/Developer role on our scrum software managed projects. 

Provide end user support and train users on newly delivered functionality. 

 

 

Montclair State University (MSU) (2015 October – 2017 May)

Data Warehouse Architect Technical Lead

 

Integrated Data Warehouse (Banner/Workday/PeopleSoft)

Perform business process & requirements analyses by leading stakeholder engagements on the gathering, documentation & detailed analysis of business requirements, and the mapping of business processes into functional & technical specifications for team’s modifications & integrations to existing BI data & reporting capabilities. 
Analyze current operational procedures, investigate problems and other data quality reports and recommend solutions. 

Integrate the different layers of the warehouse using Oracle Tools and IBM InfoSphere

Design DataMart’s using knowledge of data warehouse principles, architectures, and technologies.

Tune ETL processes and Oracle SQL statements to provide optimal load times and report execution.

Design and develop the business intelligence interface to the warehouse using IBM Cognos

Performing other duties as assigned and work efficiently on multiple projects concurrently

Ensure a stable, reliable and credible data warehouse environment.

 

Banner Student Information System Data Warehouse

Reviewing and defining functional department business process requirements.

Performing system/infrastructure and software evaluation to ensure that systems operate efficiently, effectively, and maintain data integrity.

Designing and developing reports that resolve business/functional problems or meet university business operational needs.

Design and implement strategies for maintaining security roles, privileges, and authentication.

Working collaboratively with functional domain users and IT staff and

planned roll-out of new capabilities from IT Services.

 

 

Workday HR System Data Warehouse

Analyze Workday Reports and Workday Business Process steps.

Coordinate design and architecture review meetings with development and business team members reviewing/adjusting priorities and reporting on the status of development efforts.

Develop and document policies and procedures for business processes.

Analyze business requirements in various business functional areas and translate them into conceptual, logical and physical data models.

Evaluate and implement integration tools and methods for message and build master data management and data quality solutions

Assess and implement integration tools, and Workday Studio and methods for management of existing interfaces.

Provide infrastructure support (code and object migrations, metadata backups, project duplications, scheduler process setup) for the warehouse project.

Develop and customize DataStage ETL processes for loading the ODS layer of the data warehouse environment.

Tune ETL processes and Oracle SQL statements to provide optimal load times and report execution.

Design and develop the business intelligence interface to the warehouse using IBM Cognos.

 

PeopleSoft Financial Data Warehouse

Analyze business requirements in various business functional areas and translate them into conceptual, logical and physical data models.

Develop and customize DataStage ETL processes for loading the ODS layer of the data warehouse environment.

Tune ETL processes and Oracle SQL statements to provide optimal load times and report execution.

Design and develop the business intelligence interface to the warehouse using IBM Cognos

Provide infrastructure support (code and object migrations, metadata backups, project duplications, scheduler process setup) for the data warehouse project.

 

 

 

Automatic Data Processing (ADP) (2014 March – 2015 October)

Principal Business Intelligence Application Developer/Analyst

 

 Lead in developing business intelligence systems for business performance measurements and forecasting.  

Interacting with users and collecting business requirements and prepared functional and technical specification documents.

Performed Data Quality Assurance, Fit Gap Analysis, analyze Current System Business Process Flows, Security Issues, Defects, Reports information and mapping to new reports on Oracle database.

Re-engineered and developed customize Hyperion Interactive reports using Oracle databases.  Troubleshoot and fixing problems on development, Test Environment and moving changes to Hyperion IR11 Production Environment Responsible for writing and confirming test cases, test results and release plans.

Design ETL packages using MSSQL SSIS/TSQL for data transformation for Data Warehouse.

Using PLSQL for redesigning Report views on Data Warehouse.

Design and build Tableau analysis dashboard using customized SQL.

 

New York University (2009 August –2014 February)

            Senior Systems Data Architect (PeopleSoft Business Analyst ERP Financial Reporting and Business Intelligence Reporting)

Peoplesoft EPM/OBIEE/ETL Business Analyst/Data Architect/Developer/Functional Lead 

 

 Perform business process & requirements analyses by leading stakeholder engagements on the gathering, documentation & detailed analysis of business requirements, and the mapping of business processes into functional & technical specifications for team’s modifications & integrations to existing BI data & reporting capabilities. 
Analyze current operational procedures, investigate problems and other data quality reports and recommend solutions. 

Analyze data flow between PeopleSoft 9.0 GL/KK/AP to EPM 9.0 OWS and MDW  Analyze Dimension/Dimension Attributes and FACT tables and develop test cases.

Worked with ETL and OBIEE Developers to implement row level security Design Composite Dimension and FACTs to use multiple modules and systems.

  Produce Data Lineage Documents to use in Data Stage ETL development, jobs sequencing and a population of Dimension and FACT tables.   Developed OBIEE Reports using Peoplesoft EPM Data Warehouse.  

Work with OBIEE developers and provide metadata information for report develop and produce Functional test cases on OBIEE 10/11.1.1.5 G.

 Work with DBA to designed data partitions for OWS and MDW data store.   

Re-engineered existing PeopleSoft Financials 9.0  (GL/AP/AR and KK) reports and reporting database architecture to improve performance  Re-engineered and developed customize Hyperion Interactive reports. 

Re-engineered existing database report views to provide PeopleSoft General Ledger Multicurrency reports.

 Analyze user requirements and perform ad-hoc reporting development support on Hyperion Interactive Reporting System.

Interacting with users and collecting business requirements and prepared functional and technical specification documents.

Performed Fit Gap Analysis, analyze Current System Business Process, Process Flows, Security Issues, Defects, Reports information and mapping to a new system.

Responsible for ongoing customization and performance tuning of a purchase order, budget, general ledger and encumbrance reports. 

Involved in Facilitating meetings, process mapping, and knowledge transfer. Arranged meetings with end users in gathering their concerns and issued with the postproduction and providing solutions to resolve them. 

Troubleshoot and fixing problems on development, Test Environment and moving changes to Production Environment Responsible for writing and confirming test cases, test results and release plans.

 

New York Department of Education (2009 July – 2009 October)

            MSSQL Data Warehouse Architect

            (Accountability Division)

 Analyze and redesign existing Periodic Assessment System Dimensional data model.

Developed SQL/ETL  packages for populating Dimensions and Fact data.  

Involved as a leading role in performance tuning activities on data load and report runtime.

Analyzed existing SQL server architecture and setup procedures to improve performance on data load and report queries.

Troubleshoot and fixing problems on development, Test Environment and moving changes to Production Environment.

Responsible for writing and confirming test cases, test results and release plans.

Merrill Lynch & Co. (2007 March – 2009 July)

            MSSQL Data Warehouse Developer, Business Analyst and Quality Assurance

(Alternative Investment/Global Wealth Management)

 

Served as lead technical person on developing reporting system using Service Oriented  Architecture (SOA)

Design and deployed data warehouse to track accurate financial market data

Develop Stored Procedures, Functions, ad-hoc SQL script for data retrieval and ETL packages using SQL.

Participate as technical lead in converting MSSQL 2000 databases to MSSQL 2005 databases

Lead re-engineering of ETL packages for various data loads using SQL stored procedures and functions

Design XML and XSLT for different acquisition

Design Client Reporting Database (ODS) for storing relational and XML data.

Design and write business specifications for ETL data load templates for market data and commentaries for analytic data repository

Participate in designing and implementing Pivotal CRM software to perform Hedge Fund Origination, Planning, and Due Diligence activities.

Produce technical documents for Quality Assurance Procedures, Use Cases, Test Cases and Test Scripts using Quality Center and Quick Test Pro.

Develop mechanism to monitor and report data anomalies from various data load

Develop and assists developers to implement data validation mechanism

Monitor and assist production data load issues and provide resolutions

Analyze data load statistics and advice DBA and developers to improve data load performance

Produce Software release reports, Business Analysis Reviews, Technical Procedures,  Production Procedures, and Project Status Reports

 

 

United Nations Office for Project Services (2006 January_2007 March )

                    PeopleSoft Reporting Team Lead, Business Analyst/Senior Data Warehouse Developer/ Database Systems Architect

 

Manage Business Intelligence (BI) Project, which implements extracting data from Peoplesoft Financial and HR system (Oracle platform) and integrates into MSSQL database and Data Warehouse.

Manage Data Warehouse and reporting database-implementing project on Microsoft platform to deploy Business Intelligence Software and Finance Monitoring Dashboard for corporate finance monitoring.

Designed and produce data flow diagram, data mapping documents and detail technical specifications based on business requirements

Manage UNOPS Reporting Team to achieve the organizational information delivery goals, which include technical implementation, daily data operation, and analytical requirements.

Co-ordinate with UNOPS Business Units and translate business requirements to the conceptual model and develop reporting strategies to implement solutions which can accommodate UNOPS current and future information delivery needs.

Manage and support UNOPS HQ/Decentralized Offices and project staffs on information management to improve coordination and the effectiveness of the response.

Plan and manage project plans for all reporting activities, which include the status of various reporting initiatives and timely delivery of executive reports to the UNOPS Senior Management.

Recommends improving existing data analysis tools and design methodology to use new tools for Financial Reporting, data management, and business intelligence deliverables.

Design Daily extracting mechanism using DTS service to extract data from Peoplesoft Oracle databases to MSSQL database for Atlas HR and Financial Reporting.

Design effective development procedures to accommodate existing organization business requirements and Decentralized Offices information management procedures.

Analyze Peoplesoft HCM and Finance Functional Modules and Data models to translate physical data to the business definition for Reporting database which uses as an information data store for data warehouse development, which includes building de-normalize tables to improve report performance. 

Design MSSQL database, based on UNOPS business requirement to achieve optimal performance, including the placing of data files, table, and column layout, placing of indexes, and designing of indexes, considering daily and weekly maintenance performance and backup/restore performance. 

Setup data analysis mechanism on business modules to ensure the quality of data reporting.

Developed reporting and data management strategies, standards and procedures to use Atlas, IMIS, and other data sources to accommodate UNOPS Business Unit Requirement.

Develop UNOPS Financial Performance Tracking System (Dashboard) to monitor project delivery.

Implement monitoring software to track data growth, CPU usage, io usage and user counts to establish capacity planning, hardware and software upgrade, understand data usage, redesign maintenance procedure, backup procedure, data file placement and index optimization to keep real data warehouse.

Developed DTS/SSIS packages and performed the unit test and integration test and produce release documents.

Perform analysis on data from modules to ensure that quality of data for reporting.

Produce and performed training and training related materials.

Perform capacity planning and hardware upgrades.

 

 

United Nations Development Programme (1999 October – 2006 January)

                                  Business Analyst/Senior Database Developer/Programmer, Database Systems Architect

Manage Business Intelligence Project to implement data extraction projects from Corporate Finance Application (Sybase database) to MSSQL database and Data Warehouse.

Manage Project for implementing Data Warehouse and reporting database on MSSQL to deploy Business Intelligence software for corporate finance monitoring.

Designed and produce data flow diagram, data mapping documents and detail technical specifications based on business requirements

Developed DTS/SSIS packages and performed the unit test and integration test and produce release documents.

Designed Proof of Concept Model for Peoplesoft ERP implementation.

Perform GAP analysis between IMIS system and new ERP system.

Develop reporting functionality (information data store/data warehouse) for UNDP to track the status of financial reporting of International and HQ projects.

Design data flow mechanism to support the production of management and analytical reports that promote effective decision-making.

Develop operation data store to aggregate data from MSSQL, Oracle, Sybase and Access in a data warehouse to enable reporting on comparative and trend analyses.

Eliminate data redundancy and implement data quality check mechanism. 

Using a business intelligence tool, extract data from operation data store and deliver scheduled reports.

Design database to accommodate denormalized tables efficiently. 

Implement Brio Intelligence server for business analysis and Cold Fusion server for standard reporting as report delivery tools.  Country offices worldwide access reports via Cold Fusion Servers and Hyperion On-Demand Servers.

Plan and design reporting databases and reporting systems to accommodate emergency need such as year-end financial statement producing and preparation for audit reports.

Build Microsoft Analysis Server and used Hyperion Business Intelligence front end (former Brio business intelligence) to produce customized consolidated reports.

Develop Metadata business layer to translate data or transformed data for different business perspective. Design renormalized tables to satisfy business requirements.  Implement guidelines to produce an efficient business specifications for application development and implementation.

Design MSSQL database, based on UNDP business requirement to achieve optimal performance, including the placing of data files, database tables, and table columns layout, placing of indexes, and designing of indexes, considering daily and weekly maintenance performance and backup/restore performance.  Implement monitoring software to track data growth, CPU usage, io usage and user counts to establish capacity planning, hardware and software upgrade, understand data usage, redesign maintenance procedure, backup procedure, data file placement and index optimization to keep real data warehouse. Perform capacity planning and hardware upgrades. 

Participate in selection of reporting tools and business intelligence tools for IMIS and existing country office systems. The process included analyzing existing business requirement and functions of products, which can deliver these demands.

Develop, test, implement and maintain MOLAP cubes using MSSQL OLAP 2000 server and Hyperion (Brio) on-demand server for financial data analysis.

Develop, test, implement and maintain.Net Web database applications using XML and web services.

Analyze data for network and server availability using Mercury Topaz software.

Implement the pilot stage for PeopleSoft Financial and HR Modules on Oracle 9i and Solaris platform.

Redesign AD structure for existing Microsoft Windows environment.

Restructure and Design Data Warehouse Architecture to facilitate business requirements.

Develop, implement and maintain client server applications, which develop in VB6.

Responsible for Hardware Selection, Windows OS, and MSSQL server implementation.

Implement strategy and develop interfaces to consolidate data from newly developed and existing applications. 

Implement replication and clustering MSSQL database servers for high availability.

Restructure, deploy and upgrade Business Intelligent System using Brio On-demand server to improve performance and facilitate business needs.

Improve existing database server physical design and accommodate developers for application and SQL scripts performance tuning.

Design application is implementing and QA procedures.

Assist data modelers to convert logical data models to physical data models.

Produce and performed training and training related materials.

Perform Server Consolidation on Windows and IIS Servers using VMotion and VCenter Software.

Perform patch/server management on Windows Servers and Workstations.

 

 

  August 1998 to 1999 February   THE SEGAL COMPANY

                                             Database Administrator/Developer

Support of Production, Development, Reporting and Test Servers of MSSQL Servers for Financial, Human Resources, Procurement and other applications.

Responsible for Hardware Selection, Windows NT, and MSSQL 6.5 installation,

Responsible for Backup & Recovery of Production, Reporting and Development databases.

Responsible for Hardware, Software and Operating System Maintenance on Windows NT and MSSQL.

Monitoring server performance and data statistics of MSSQL servers.

Writing batch files and Windows scripts to schedules tasks on WindowsNT.

Administrative support for various applications in production.

Implement strategy and develop interfaces to consolidate data from newly developed applications. 

Restructure and Design Information Infrastructure (Physical and Logical).

 

 

United Nations Office for Project Services (1993 July -1998 August)

Systems Analyst and Programmer

Develop reporting (data warehouse) for UNOPS (United Nations Office for Project Services) to track financial information status of international projects.

Using converted data from Main Frame to Sybase and MSSQL 6.5 database server to monitor UNOPS project delivery status.

Using client-server reporting tool called Forest & Trees, develop decision support tool for project management officers to track their delivery.  Used Brio (now Hyperion) software to produce presentation and assist executive director to conduct and conduct business analysis and produce reports.

Optimize extraction mechanism to support producing Project Delivery Reports.

Integrate Admin/Payroll data (from IMIS) and Projects Expenditure data (from FCS) to generate on-demand delivery reports.

Support of Production, Development, Reporting and Test Servers of MSSQL Servers for Financial, Human Resources, Procurement and other applications.

Responsible for Hardware Selection, Windows NT, and MSSQL installation,

Responsible for Backup & Recovery of Production, Reporting and Development databases.

Responsible for Hardware, Software and Operating System Maintenance on Windows NT and MSSQL.

Creating databases, tables, indexes, triggers, stored procedures, new logins, users, etc.

Monitoring server performance and data statistics of MSSQL servers.

Writing batch files and Windows scripts to schedules tasks on WindowsNT.

Administrative support for various applications in production and new production rollouts.

Re-design existing data warehouse to accommodate new business rules using Star Designer and Sybase.

Implement strategy and develop interfaces to consolidate data from newly developed applications. 

Setup database administration tools such as DbArtisan on Citrix Server and HYDRA Terminal.