JAMIE WANG

ad4sk8@r.postjobfree.com

425-***-****

SUMMARY

Experienced Web and BI developer backed by solid credentials and strong technical background.

Expert in developing database solutions on multiple platforms including SQL Server, TeraData and Oracle. Proficient in relational and dimensional modeling, SQL Server, ETL and BI tools such as SSIS and SSAS, Azure, Power BI, Tableau, SSRS and BusinessObjects. Developed solutions using C#, Python, Pandas, Javascript, and VisualBasic programming languages.

Proven success in designing high-integrity BI solutions supporting critical business decisions.

EXPERIENCE

Senior Software Engineer, T-Mobile, Inc.

Bellevue, WA November 2010 – September 2020

Successfully completed many data import, export, transformation and aggregation processes which supported critical sales and customer support decision making under tight deadlines. Responsibilities included designing the dimensional database schema, creating database scripts in various database environments such as SQL Server, Azure, TeraData, and Oracle. Designed and implemented automated ETL processes using SSIS and meta data driven T-SQL scripts that loaded large volume of data from multiple sources and applied complex business rules. Created .NET #C based Scripts in SSIS to transform data. Designed and implemented OLAP cubes in SSAS environment to support slicing and dicing of data by advanced business users. Improved existing legacy processes by greatly reducing processing time, eliminating redundant storage, trouble shooting and fixing data integrity issues, and allowing greater flexibility and re-usability of software components. Created Power BI reports and dashboards for business teams to drill down and slice and dice data.

Senior Data Warehouse Engineer, Infospace, Inc.

Bellevue, WA October 2005 – October 2010

Designed and developed data warehouse and reporting solutions which provided various business units with key performance metrics to successfully run their business and be competitive in their marketplace. Worked with business teams to identify reporting requirements. Designed, developed, and deployed ETL processes and terabyte sized data marts to track Web user click stream, E-Commerce orders, and on-line service subscriptions. Designed data warehouse schema and data load processes. Identified dependencies on various data sources and implemented automated process to support them. Created and tested SSIS components to perform daily data extraction, transformation and movement. Created, tested and deployed OLAP cubes, reports, charts and data aggregations using SSAS and SSRS.

CRM Customization and Reporting Developer, 180Solutions, Inc.

Bellevue, WA February 2005 – October 2005

Responsible for designing, implementing and deploying enterprise CRM (Customer Relationships Management) applications including both analytical processes and transactional processes. Created, tested, and supported 50 plus reports built on MS SQL Reporting Services used by different sales and business development teams. Designed and implemented a management dashboard as a go-to place for enterprise business information. Significantly increased management usage of CRM system by providing in-depth sales pipeline analysis and sales force productivity reports. Supported management data analysis needs by performing ad hoc SQL Queries. Defined data mapping and ETL processes that transferred large volume of data from multiple transactional databases to a CRM reporting data mart. Designed and implemented OLAP cubes for multi-dimensional analysis of data. Analyzed detailed data flow to troubleshoot data mapping and aggregation errors. Additionally, implemented .NET Web Services to support integration between CRM system and other enterprise systems which were built on heterogeneous platforms.

CRM Software Program Manager, Microsoft Corporation

Redmond, WA September 1999 - January 2005

Responsible for designing, building and testing the reporting and business intelligence module of Microsoft CRM product in two full releases. Gathered customer reporting requirements such as sales pipeline analysis and revenue forecast. Performed functional analysis on these requirements. Created and tested over 300 prepackaged reports built on Crystal Reports and Microsoft SQL Reporting Services. Managed a partnership with Business Objects to build Microsoft CRM reporting solution on OEM edition of Crystal Enterprise server. Defined concise, solid functional specifications, managed project schedule and dependencies across various feature areas, and partnered with other team members to resolve product integration issues.

SKILLS

- Database Environment: MS SQL Server, Azure, TeraData, Oracle, Netezza, MongoDB, IndexedDB

- ETL Tools: MS Integration Services (SSIS)

- BI Tools: MS Analysis Services (SSAS), MS SQL Reporting Services (SSRS), MDX, Power BI, Tableau, Business Objects, Excel

- SQL Skills: Transact-SQL, PL-SQL, Netezza SQL, TeraData SQL

- Schema design: Relational and dimensional modeling, Erwin, Embarcadero E-R Studio, Visio

- Programming Skills: .NET, C#, Windows Services, Web Services, Python, JavaScript, VisualBasic, HTML, CSS, TypeScript, React

EDUCATION

- Master of Business Administration, Management Information Systems, University of Wisconsin - Madison

- Bachelor of Science, South China University of Technology

Contact this candidate