Bing Y. Wang acwt8v@r.postjobfree.com

Summary **+ years of IT experience including

Business Intelligence Solution Architect

SSAS/MDX/SSIS Developer

Lead/Senior DBA

SQL Server Migration

Industry/Application Knowledge

Financial, Banking, Insurance, Oil, Retail, Marketing, Service, etc. IT skills Windows Server, Amazon EC2/AWS, Unix/Linux, SQL server, Sybase, Oracle, DB2/UDB, OLAP, ETL, SSAS, SSRS, SSIS, BISM, MDX, SQL Profiler, Idera, ER/Win, ER/Studio, SharePoint, QlikView, Amazon Redshift, MongoDB, AWS/EC2/S3, Crystal Report, SDLC, Microsoft Power BI stack, Unstructured data (non-SQL), Scrum and Agile. Experience

Draftkings (Boston, MA) – Senior BI Engineer/DBA/Lead SSAS Developer, (6/2015 – present) Responsible for leading full life cycle development of all SSAS/SSRS/Power BI projects; initiated systematically SQL server monitoring and auditing. Responsible for SQL server performance tuning - files/file groups allocation, configuration on tempdb and disk storage, utilizing SQL trace, perfmon, and usage auditing. Contributed significantly on SQL 2012 Standard to SQL 2014 Enterprise upgrade and migration in Amazon AWS/EC2 environment.

Citrix Systems (Fort Lauderdale, FL) – BI Architect/Lead SSAS Developer, 10 months, (8/2014 – 5/2015)

Contributed significantly on SSAS/MDX design, development and performance tuning on delivering client’s multidimensional cubes with over 260 measures, complex security setting, and prospective usages.

GenRe (Stamford, CT) – BI Architect/Microsoft BI Consultant, 6 months (3/2014 – 8/2014) Architected client’s MS BI roadmap and reporting strategy; developed MS BI proof of concept utilizing SSAS, BISM tabular, MS Power BI tools, SSIS, and SharePoint. Architected QlikView to MS BI reporting migration strategy and plan. Contributed significantly on SSAS/MDX/Power BI design and development of financial cube/reports.

Evraz (Chicago/Canada) – BI Architect/Principal Consultant, 8 months (5/2013 – 12/2013) Expanded and enhanced Shipment and Inventory data marts, utilized Microsoft BI tools in Oracle, SQL Server (SQL 2012 and SQL 2008 R2) environment. Gathered business requirements, architected BI solutions, created architecture and functional designs, created ETL mappings, and contributed significantly in data modeling, database/Cube design, BI development utilizing BISM tabular, SSIS, SSAS and SSRS. Functioned as a development DBA for server sizing, database server setup, configuration, and upgrade/migration, responsible for managing priorities and user expectations. Huron Consulting (Chicago) – BI Architect, 9 months (8/2012 – 4/2013) Expanded and enhanced data warehouse and application software utilizing Microsoft BI tools in SQL Server environment (SQL 2012, SQL2008 R2). Designed BI solutions and hands-on full SDLC of BI development, including SSIS, SSRS, TFS, SOA, and SQL server performance tuning. DME Automotive (Jacksonville, FL) – BI Architect/Developer, 6 months (2/2012 – 7/2012) Provided BI consulting service on building personalized BI solutions. Utilized Microsoft BI tools and SOA in TFS and SQL Server environment. Responsible for studying customer transactions, reviewing the existing systems, and designing targeted marketing and campaign solutions for maximizing revenues, utilizing Kimball methodology on Slow Changing Dimensions; performed hands-on BI development in SSIS and SSAS.

Peak6 Investment (Chicago) – DBA Team Manager/BI Architect, 22 months (3/2010 – 1/2012) Managed enterprise DBA team and provided production support as lead DBA and BI architect. Initiated BI solutions, data architecting, data warehousing, and data modeling efforts for trading applications. Designed and delivered many cubes and reports. Managed and conducted database design review, code review (including ETLs), query tuning, backup policy, capacity planning, server sizing, DR strategy, database server installation, upgrade and migration. Designed and presented data modeling, database design and SQL best practice classes for over 70 developers and DBAs. Provided administration and support for Cognos and Microsoft Dynamics. Led DBA team in performance tuning and troubleshooting of multi-terabyte databases on clustered SQL server, MySQL, and Postgres (Oracle) environment with over 75 TB data. Contributed significantly in BI architect, SSAS/OLAP, reporting, database performance improvement, monitoring enhancement and achieved remarkable operation cost savings through optimization, performance tuning, integration, migration/upgrade, cleanup and consolidation. Also provided support of MongoDB, Cognos OLAP cubes. Guggenheim Partners, LLC (Chicago) – Lead DBA/BI Architect, 4 years (4/2006 – 3/2010) Initiated, designed and delivered financial data marts, data warehouse, OLAP, and reports for various business unions. Initiated and delivered automated database monitoring and alerting system. Improved data retention and database DR plan. Responsible for BI and database production support, as well as performance tuning, data modeling, database server maintenance, capacity planning, server sizing, database and application migration. Achieved savings in IT budget through SQL server/service optimization and consolidation. Environment consists of Business Objects (Webi), SSRS, SSIS, SSAS, Crystal report, SharePoint, ProClarity, SAN, TFS, VM, and Clustering SQL servers. NewEdge (Fimat USA) (Chicago/New York) – Project Manager and Lead DBA, 2.5 years (8/2003 – 3/2006)

Managed DBA group and provided day-to-day production support. Responsible for data mart enhancement and support (ETL), capacity planning, server sizing, data replications, DR plan, database design, data modeling, DTS/SSIS development, performance tuning, database monitoring, database application migration, database server upgrade and migration in SQL server, Sybase, MVS, DB2, and Oracle environment.

AquiTec International (Chicago) – Lead DBA and Data Architect, 9 months (12/2002 – 8/2003) Responsible for database design, data management, performance tuning, database installation/configuration and upgrade for developing food/grocery supply chain management software. Environment consisted UDB/AIX, DB2/MVS, and SQL server/Windows. Arthur Andersen LLP (Chicago) – Experienced Manager, 1.5 years (4/2001 – 8/2002) Participated in several EAI solutions and proposals for clients national-wide, responsible for requirement gathering, project planning, database planning, SOA design, and EAI implementation. Vignette Inc. (Austin, TX) – Senior Specialist, 13 months (1/2000 – 2/2001) Provided enterprise data warehouse, process re-engineering and EAI solutions for various Vignette clients using Vignette software products in North America. Responsible for sales support, project planning, architect design, project kick-off, and proof of concept. General Motors (Detroit, MI) – eCommerce Architect/Data Architect, 9 months (4/1999 – 12/1999) Participated in architecture design of www.GMBuyPower.com. CNA Insurance (Chicago) – Data Architect/Developer, 2.5 years (9/1997 – 3/1999) Contributed to the full life cycle development of CNA insurance claim data mart. JPMorgan Chase (First Chicago Bank) (Chicago) – Sr. Developer, 6 months (3/1997 - 9/1997) Responsible for production support of its customer call center (client server application). United Airlines (Chicago) – Database architect/developer, 1 year (3/1996 – 3/1997) Participated in data modeling, database design, ETL design of building enterprise data warehouse to achieve flight schedule optimization.

BP (Amoco) (Chicago) – Lead Developer, 1 year (3/1995 – 3/1996) Contributed to the full life cycle development of a crude oil refinery reporting system. BMO Harris Bank (Chicago) – Developer, 2 years (3/1993 – 3/1995) Contributed to the full life cycle development of a check processing system. Training

Bing received certified training on MS OLAP/BI solution, and Data Warehouse Design (Kimball group). Affiliation

Bing was the Area Governor of District 30 (the great Chicago area) of the Toastmasters International organization. Bing was the president of Toastmasters club 3895. Bing is an active member of Microsoft SQL Server User Group. Education

Bing was awarded with Master of Science in Computer Science, Michigan, USA. Reference Available upon request