David Z. Qian

Barrington, IL*****

847-***-**** (C)

adzw3u@r.postjobfree.com

Summary:

Have 10+ year experiences of utilizing data analysis techniques for finding business intelligence solutions; have advanced education in math, engineering, and business management fields; have excellent data modeling, data analysis, and AI programming skills; eager and willing to resolve difficult and/or complex problems. Proficient in Power BI, Power Query, DAX, SQL, Python, and Excel/Access based tools and related application developments.

Experiences:

03/22 – Present Senior Business Analyst+

OMS National Insurance Company, 425 N. Martingale Road, Suite 900, Schaumburg, IL 60173

• Spearheaded the creation of dataflows through the proficient utilization of Power Query and SQL, facilitating the generation of comprehensive claim and policy data models tailored for reports and dashboards; demonstrated expertise in crafting and fine-tuning DAX measures, integral to data models utilized for insightful reporting and in-depth analysis.

• Developed a robust portfolio of 34 Power BI desktop and paginated reports spanning across departments such as claim management, finance, underwriting, and marketing. These reports empower teams to efficiently manage claims, dissect financial data, monitor agency performance, and optimize workloads.

• Collaborated closely with business stakeholders to gather requirements, delivered insightful demos, and addressed inquiries. Conducted educational sessions to familiarize users with Power BI reports, teaching them to harness the full potential of interactive and dynamic features. Pioneered the application and prototyping of AI-driven data analysis algorithms in Python, showcasing the transformative potential of AI in cost reduction and overall bottom- line improvement for the company.

05/20 – Present Principal Power BI Developer

Walgreens Corporation, 200 Wilmot Rd, Deerfield, IL 60015

• Led the development of financial reports and dashboards, designed a series of dashboards to reflect key account activities and KPIs, those reports/dashboards, such as Supply Costs, Travel, Financials, Temp Labor, Projected Financial Summary, Utilities, Facilities, Events & Sponsorships, and People Recruitment & Development, offer interactive visuals, drill up/down functions, and from summary to detail navigations. Implemented and managed role level securities to control the access to data sensitive reports/dashboards; managed on time delivery of company wise daily sales reports; guided junior Power BI developers to resolve their technical issues.

• Conducted Power BI paginated report development. The reports were developed directly from tabular data models by using DAX queries and measures. Paginated reports as part of the Power BI family offer precise layout and rich data details. They have been combined with power bi reports/dashboards for users to get a comprehensive view.

• Designed auto flows by using Power Automate for developed reports/dashboards to achieve auto refresh, auto archive, and on time delivery.

06/19 – 04/20 Principal Power BI Consultant

Gallagher Bassett, Rolling Meadows, IL 60008

• Led the development of Managed Care dashboards, in which include Medical Bill Review KPIs, PC365 KPIs, Pharmacy KPIs, and Network KPIs. Those dashboards provide a full information view of workers’ comp losses and medical related claims. The KPIs, such as categorized charges, savings, fees, payment trends, annual/regional benchmarks, predisposition/disposition changes, incident report lags, prescription costs/savings, opioid/high risk drug distributions, and network penetrations, as well as interactive visuals, and drill through details are covered. The dashboard employed Power Query, DAX, and Python script for manipulating variety datasets, process procedures to maximize its performances, and plotting marching learning results. The DAX and M functions generated measures, created temp tables, automated processes, filtered/aggregated values, interconnected datasets, provided synchronized data reactions, and showcased interactive sliding effects.

08/16 – 05/19 Principal Business Analyst

True Value Company, Chicago, IL 60631

• Conducted Power BI and SSRS dashboard and report developments for senior management teams, planners, and merchants. The reports integrated multiple data sources across Teradata, Oracle, SQL, and DB2 database servers and applied DAX and M functions to present highly interactive and dynamic visual effects to reflect overall business trends as well as detailed product, department, class, subclass, vendor, and store performances. The reports provide visualization presentations to cover entire supply chain management activities from member scorecards, vendor sales, inventory status, to ship later, fill rates, and forecast details, which have become important sources for daily business decision making and data tracking.

• Built data models and applied machine learning algorithms to analyze history data for future sales predictions. Conducted time series analysis to identify sales trend and seasonality patterns by using Python and other analytic tools. Statistic models, multiple regressions, decision tree, random forest, K-means clustering, and correlation analysis were also used to achieve the results.

• Evaluated forecast results from a newly implemented ERP system (JDA) by comparing its results with those from AI based analysis, which not only revealed the cause of prediction errors, but also helped to clarify the system improvement procedures.

• Performed data transform and analysis by using variety programming methods, ETL tools, and analytic techniques. Evaluated KPI preferences and proposed recommendations to senior management team based on thorough research and data analysis. Identified and initiated key projects to improve company’s bottom-lines and to optimize daily operations. Lead internal team to resolve complex analysis problems and data processing issues.

• Designed hypothesis tests to conduct statistical analysis on procurement, sales, operation data. Variety statistic models were used to identify data variations and its significant levels among specific groups and different time periods. The tests provided scientific evidences to the area or sector where improvements needed to be done or returns could be maximized, which let the senior management team obtain a clear picture about the business dynamics, and made their decisions focus on how to optimize company’s resource allocations.

• Developed web-based tools to replace Microsoft Access based VBA applications. These implementations significantly gained the user accessibility and lowered maintenance efforts. The developments employed ASP.NET, C#, MVC, and ADO.NET related programming schemes and presented multiple database access and dynamic data display capabilities.

• Conducted analytic research on historic promotion and event sales records that involved vendor rebates and discounts, in which multi-million dollars of missing credits and refunds were found. This discovery provided a guideline for a potential fund recovering. The process was also becoming a standard daily procedure for early credit/refund detections.

• Supported managers and planners’ requirements for data pulling and presentations. Provided ad hoc analysis to serve the team’s real-time problem solving and customer service goals. Gave technical guidance and ideas to team members when difficult or complex issues were handled.

08/07 – 07/16 Senior Strategic Project Analyst

American LabelMark Company, Chicago, IL 60646

• Closely worked with senior management to analyze company’s business and financial data; built advanced reports with tables, charts, and interactive/auto update functions; conducted database creation, data mining, and information system design and development; monitored and maintained database systems to confirm data accuracy and integrity.

• Built up supply chain, procurement, and operation cost models, analyzed risk and spending of company’s supply chain to optimize operations of purchasing and manufacturing; calculated Total Cost of Ownership (TCO), determined global and local sourcing items; thoroughly studied the top 20% expensive accounts, which cover about the 80% of the annual spending of raw materials, finished goods, and parts, to balance savings and supply risk controls; created comprehensive data reports for progress monitoring and business decision making; identified the best methodology for each account/product line to optimize inventory levels, profit margarines, inventory turnovers, and cash follows under acceptable risk levels; tracked project progresses, identified bottlenecks/critical tasks, provided potential solutions, and resolved issues;

• Developed a supply chain forecast program based on statistical models to guide purchasing activities; calculated EOQs by analyzing annual sales, carrying cost, and fixed cost for all the internal manufactured items, resale goods, and raw materials; applied the forecast and EOQ methodologies based on the nature of the items to minimize the total costs of both purchased and manufactured goods, and improve on-time delivery rates;

• Designed and developed a warehouse raw material tracking system with SQL database, laser guns, mobile printers, and software applications to monitor raw material bin locations, movements, and usages. Wrote all the programs for both PC and mobile computers;

• Developed and maintained a barcode printing software application for labeling manufactured items and storage cartons. The application is connected to a database for easy updating, and is used for manufacturing, receiving, and warehousing stations;

• Led and coached a sourcing team; developed global sourcing strategies, setup operational performance metrics, determined and utilized proper global sources of supply for the most economical purchases consistent with quality, lead time, and payment terms; setup supplier qualification measurements to screen potential vendors. Established second sources for critical and/or heavily spending accounts to secure supplies and to achieve the best prices; 12/98-07/07 Principal Engineer

First International Digital, Inc. (A Motorola Spin-off), Schaumburg, IL 60195

• Managed and Led Consumer Electronic Product Development Invented and patented MP3i technologies, which offer synchronized multimedia (mp3, image, video, and text) playback with interactive audiovisual effects. It is backward compatible with the conventional MP3s; developed encoding and decoding algorithms and software modules. Wrote product specs, conducted firmware developments, tested samples, managed production schedules, and worked closely with OEM manufacturers in Korea. 1. Managed irock 600 MP3 Player Firmware Development irock! 600 is the first MP3 karaoke player based on MP3i technology I invented and patented in 2002. This player uses TI DSP. Except managing the software develop team, my roles also included designing a codec for the synchronized lyrics encoding/decoding, and developing an LCD driver for lyrics display. 2. Managed irock! 730i Development

iorck! 730i is the second generation mp3i player, which offers synchronized lyrics and images. The product was awarded by CES (Consumer Electronic Show) in 2003.

• Managed and Led Mobile Software Development

1. Mobile Jukebox

A J2ME/BREW based client/server application for mobile music and karaoke services. Its BREW version had been launched since early 2004 on Verizon wireless. Currently support 11 phones and have over 100 popular songs for each handset. The J2ME version was launch in China and preloaded to Motorola cell phones (via MIG.com). 2. EduMax

A Java based client/server application for mobile language learning services. It is licensed to TOM.com and is secluded to launch in early 2005. 3. maxMIDI Bundles

maxMIDI is a subset of SuperMedia. This product uses a bundled (content plus decoder) J2ME application to deliver mobile karaoke contents. It was preloaded on 5 Motorola phones for total 1.5 million units in year 2003.

4. SuperMedia Creator

A content authoring tool (PC software) for SuperMedia contents 5. Karaoke DIY

An Internet application that allows modifying and/or creating customized karaoke songs.

6. Designed MusicPrint Application

MusicPrint is a J2ME application for music recognition. It uses Grace Note CDDB service to identify music titles and provide music related information.

• Managed and Led PC Software Development

1. MP3i Creator

MP3i Creator is a PC software application that generates mp3i files by adding synchronized lyrics and images to existing mp3s.

2. OEM Software

An OEM version of MP3i Creator was developed for Casio and used for its electronic dictionary products.

3. MP3i Contents

Worked with McGraw Hill for its language learning books. Created a synchronized and interactive CD ROM for readers

Wrote product specs, conducted firmware developments, tested samples, managed production schedules, and worked closely with OEM manufacturers in Korea. Other developments include:

1) Managed irock 600 MP3 Player Firmware Development 2) Managed irock! 730i Development

3) Managed and Led Mobile Software Developments

4) Managed and Led PC Software Developments

5) Developed and Managed eCommerce Websites

9/96-12/98 Research Assistant

Portland State University, Portland, OR

Conducted research on wavelet transforms, video data processing, image compression, wavelet domain watermarking, and high-performance embedded image codec design. The encoding algorithm developed for image and video compression is transform independent, and can be used for compressing different data forms, such as DCT and wavelet transformed image plus residuals, to form a highly embedded bit stream. Under the same coding condition, it outperforms most of the published algorithms. Patent:

1. Encoding an Audio Sequence with Synchronized Data and Outputting the Same

(6,442,517), August 27, 2002

Other Publications:

1. "A Bit-Plane Based Embedded Quad-Tree Codec for Universal Image and Video Compression" ICASSP Phoenix, March 1999

2. "Some Improvements to Bit-Plane Based Image Compression Algorithms", IEE Electronics Letters, 18 (vol. 34), 1998, pp.1736-1737 Education:

PhD in Electrical & Computer Engineering, 1998

Portland State University, Portland, OR

Master of Science in Applied Mathematics & Physics Beijing University of Aeronautics & Astronautics, Beijing, P.R. China. Bachelor of Science in Applied Physics

National University of Defense Technology, Changsha, P.R. China. Reference:

Available Upon Request.

Contact this candidate