Qi Wei Email & Phone Number

Shanghai, China

Shanghai

Data Management:Organized and established a comprehensive data management system. Business Data Management: managed standards and usage of business data, strengthening the master data system of Sinotrans. Operational Data Management: responsible for the BI system construction, including technical platform, content framework, business decision support, and network/data security. Data Asset Management: improved data asset registration and executed centralized data procurement. Data Governance:Developed data governance strategies and frameworks, planning the direction and methods for governance. Created standards and responsibilities for data usage, implementing organizational structures, processes, and tools for governance. Enhanced business data governance and quality through monitoring, risk assessment, and optimization of data systems, ensuring usability, consistency, quality, and security of data.

Baltimore, Maryland Area

• Collects and analyzes BI end-user requirements and evaluates the feasibility of these requirements from a technical perspective to derive software designs and performance solutions.• Design, implement, execute and debug manual test cases and automated test scripts using a variety of testing techniques.• Track a data element from source to transformation to target.• Designs and develops relational and multidimensional data models and optimizes the data-mining performance function including the use of data modeling tools.• Creates and implements BI reporting solutions, Extract Transform Load (ETL) solutions using best practices and methodologies; identifies root causes of issues with data quality and other related issues.• Designs and codes new software or enhances existing software and integrates into new or modified systems and/or operational environments.• Works with a reporting team optimizing the ETL/data pipeline process to ensure that business requirements are met.• Documents all phases of work including gathering requirements, database diagrams, source to target mappings and other program technical specifications using current specified design standards for new or revised solutions.

Greater Pittsburgh Area

• Department: Enterprise Information Management. Title: Business Intelligence Developer.• Design, develop and implement the ETL process using SSIS to ingest information from various data sources, the majority of the data source is the Syteline ERP system.• Design, develop and implement Store Procedures, Views, Functions and other artifacts in TSQL for sourcing data and building the enterprise data warehouse (EDW).• Design, develop, implement and maintain SSRS report models and reports.• Design, develop and implement multi-dimensional SSAS cubes for forecasting and analytical purpose.• Design, develop and implement Tableau data visualization solutions to satisfy business requirements based on ERP system (OLTP) and EDW (OLAP) structure.• Corporate with Business Analyst (BA) and Subject Matter Expert (SME) to achieve the requirement gathering, designing, analysis, confirmation and manipulation.• Work with SME throughout the organization to identify opportunities for leveraging company data to drive business solutions. Mine and analyze data from EDW to drive optimization and improvement in areas of operational excellence, driving growth and other PCNA initiatives. Applied performance tuning on cubes, report models, reports, stored procedures, views and jobs.• Provide assists to SME to set up BI&A environment, ensure users’ experience. Provide training material to maximize the value of BI&A products.• Develop, maintain and implement automation processer Macro Scheduler to deal with ERP data ad-hoc entry and manipulate request.• Coach and mentor PCNA BI team members on the various aspects of BI development.

Greater New York City Area

Provide assistant service for department needs.Tutoring for all level students in their courses requirement'grading study material (quiz, work, exam);Monitoring examinations.