Resume

Sign in

Engineer Data

Location:
Pittsburgh, Pennsylvania, United States
Posted:
March 10, 2019

Contact this candidate

Resume:

GUOWEI (DAVID) ZHAO

412-***-**** ac8ql9@r.postjobfree.com Pittsburgh, PA

PROFESSIONAL PROFILE

• 7 years of experience in enterprise-level IT project delivery and full life cycle of software development

• 5 years of experience with Microsoft Dynamics CRM as a subject matter expert (SME) in solution architecture, development and implementation

• Utilized methodologies such as Agile/Scrum, Waterfall and Incremental model along with SDLC implementations

• Strong hands-on experience in integrating MS Dynamics CRM with other applications including MS SharePoint and MS SQL Server

• Expertise in client-side extension of MS Dynamics CRM by using HTML, CSS, JavaScript, XML, XSLT

• Extensive hands-on experience in server-side extension of MS Dynamics CRM by developing plug-ins and custom workflows

• Expertise in Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts and dimensions

• Strong hands-on experience in performing ETL processes to transfer data from various data sources to database by implementing SSIS packages

• Strong hands-on experience in developing business intelligence reports using SSRS, Power BI and Tableau

• Excellent leadership, analytical problem-solving skills, and fast-learning with self-motivated personality TECHNICAL SKILLS

• Applications: MS Dynamics CRM 2011/2013/2015/2016/365, MS SharePoint, MS Office Suite

• Programming/Scripting Languages: C#, HTML, CSS, JavaScript, XML, XSLT, SQL/T-SQL

• Database Systems: MS SQL Server, MySQL, Oracle, Teradata

• Development tools: MS Visual Studio, SSIS, SSAS, SSRS, Power BI, Tableau EXPERIENCE

GORDON POINTE ACQUISITION CORP. (a private equity firm, GPAQ (NASDAQ)) Pittsburgh, PA Financial Analyst Intern 5/18 – 8/18

• Business Analytics: Analyzed 30+ private companies via strategy-profitability matrix and delivered investment recommendations to management, by identifying key opportunities, creating KPI measurements and developing compelling data visualization

• Analytical Problem Solving: Conducted due diligence, competitive analysis and product evaluation by gathering information and financial metrics and analyzing financial statements of target companies AVIATION INDUSTRY CORPORATION OF CHINA (a Fortune Global 500 conglomerate) Beijing, China Senior Engineer (MS Dynamics CRM Development) (10/12–6/17) 8/09 – 6/17

• CRM System Design: Designed and developed a custom CRM system by gathering business requirements from various internal departments, creating data model diagrams and formulating project plans

• CRM Configuration: Performed CRM system configuration including administration settings, security settings, business management settings, data management settings, document management settings and service management settings

• CRM Customization: Customized the CRM system by creating custom entities, reorganizing fields, creating and optimizing views, modifying site and form navigation and ribbon controls, relating entities via relationships, creating processes and business rules to meet various business needs

• CRM Extension: Developed various client-side extensions by using HTML, CSS and scripting in JavaScript to improve user experience; Performed server-side extensions by creating plug-ins and custom workflows to coordinate different entities and realize specific business logic

• CRM Integration: Integrated MS Dynamics CRM with MS SQL Server using SSIS and Scribe; Integrated Dynamics CRM with SharePoint to facilitate content management across the company

• Portal Development: Designed and developed a customer portal for quotation, project status tracking and information inquiry, facilitating the connection of MS Dynamics CRM with external customers

• Leadership and Communication: Identified, documented and communicated best practices of CRM configuration and development to the upper management; Designed training material and led training sessions for stakeholders, increasing user engagement and system utilization rate by 15% Engineer (Business intelligence) (06/10–09/12);

• Data Processing: Designed and developed SSIS Packages to ETL data from various data sources (Dynamics CRM system, Excel, flat files, databases, XML format data, etc.) and imported into database; Built, deployed and executed SSIS packages in both development and production environments

• Data Analysis: Developed OLAP cubes using SSAS for data mining and reporting, and defined dimensions and calculated members; Developed tabular reports, matrix reports, gauges and chart reports, parameterized reports, sub reports, drill-down reports and interactive reports using SSRS

• Business Intelligence: Created impactful dashboards in Excel and Tableau to provide support for business decision-making; Extracted, analyzed and interpreted data to delivered interactive reports, identifying key metrics and providing meaningful and actionable insights

• Cross-functional Collaboration: Gathered, drafted, and revised business requirements by communicating with business teams and various stakeholders

Engineer (Energy System Design) (8/09–05/10)

• Process Improvement: Formulated 5+ engineering design solutions by analyzing input data, measuring economic feasibility, and optimizing space utilization, saving construction cost by over 10% EDUCATION

CARNEGIE MELLON UNIVERSITY, TEPPER SCHOOL OF BUSINESS Pittsburgh, PA Master of Business Administration – MBA GMAT: 730/800 8/17 – 5/19

• Concentrations: Information System, Business Analytics

• Core Courses: Modern Data Management, Big Data, Data Mining, Optimization, Statistical Decision-making HARBIN INSTITUTE OF TECHNOLOGY Harbin, China

Master of Science in Refrigeration and Cryogenic Engineering (Top 10 Program in China) 9/07 – 7/09

• Honors: Graduate Merit Scholarship (Top 5%)

TIANJIN UNIVERSITY Tianjin, China

Bachelor of Science in Thermal Energy and Dynamic Engineering (Top 10 Program in China) 9/03 – 7/07

• Honors: Toyota Motor Scholarship (Top 3%), People Scholarship (Top 10%)



Contact this candidate