Data Warehouse
Resume:
MYINT HTWE
Forest Hills, NY 11375
718-***-**** (Home)
917-***-**** (Cell)
******@*****.*** (Mail)
PROFILE:
Professional with 18 years of experience in the 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.
9 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.
Key strength in business analysis, quality products delivery and collaborating with financial professionals, project managers and developers. Teaming up with senior management in improving operational efficiency by providing business intelligence. Solid technical knowledge of PeopleSoft Systems in Financial, EPM and HR modules.
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, Oracle 9i/10G/11G, Hyperion Business Performance/Interactive Suite On Demand Server 6.6/8.3, Microsoft OLAP Server (2000-5/SSAS, Microsoft Reporting Services/SSRS, SYBASE SQL Server 12.x (NT), VMWare GSX/ESX, 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, Data Stage 8.1.
Experience
New York University (2009 August – current)
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)
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 between multiple modules and systems
Produce Data Lineage Documents for Data Stage ETL jobs developing, sequencing and population of Dimensions and FACTs
Developed OBIEE Reports using Peoplesoft EPM Data warehouse.
Work with OBIEE developers and provide meta data 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 new system.
Responsible for ongoing customization and performance tuning of purchase order, budget, general ledger and encumbrance reports.
Involved in Facilitating meetings, process mapping, and knowledge transfer
Setup meetings with the end users in gathering their concerns and issued with the postproduction and providing solutions to resolve them.
Troubleshot 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 re-design 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
Troubleshot 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 load using SQL stored procedures and functions
Design XML and XSLT for various 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 implement extracting data from Peoplesoft Financial and HR system (Oracle platform) and integrate 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 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 of all reporting activities, which include 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 business definition for Reporting database which use 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 placing of data files, table design, and column design, 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 healthy data warehouse.
Developed DTS/SSIS packages and performed unit test and integration test and produce production 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 unit test and integration test and produce production 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 information of international and HQ projects.
Design data flow mechanism to support 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 Meta data business layer to translate data or transformed data for different business perspective. Design renormalized tables to satisfy business requirements. Implement guidelines to produce efficient business spec for application development and implementation.
Design MSSQL database, based on UNDP business requirement to achieve optimal performance, including placing of data files, table design, and column design, 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 healthy 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. Process included analyzing existing business requirement and functions of products, which can deliver these requirements.
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, implement 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 implementing and QA procedures.
Assist data model designers 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 produce 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.
Contact this candidate