Miao (Mia) Duan Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Toronto, Canada Area

Toronto, Canada Area

• Utilized Python and SQL to analyze actions taken by users in the system that produces process insights to the business partners, in return, enables them to identify the user behavior gaps for the opportunity to improve their process efficiency and accuracy.• Developed and maintained ETL (Data Extraction, Transformation and Loading) scripts to extract the data from multiple source systems e.g. Oracle Database, SQL Server, flat files and conduct analysis and consolidation on the data in order to present the findings in Tableau, Excel, or PowerPoint for business users to review.• Provided fully automated reporting solution by using Task Scheduler to schedule scripts to run and perform the tasks from begin to end including sending out the report to end users on regular basis.• Collaborated with other developers on maintaining and completing Python scripts using Git and Bitbucket.• Resolved data discrepancy across reports by creating a centralized data storage within SQL server that updated based on user input on Access database with set of business rules to ensure the data integrity.

• Developed strong communication and problem solving skills via the need to resolve system issues and provide guidance and instructions for the team as part of the newly launched contingent labour system integration and implementation across the Bank’s IT groups• Consistently find ways to improve work efficiency and increase consistency of work activities by using VBA and HTML to program repetitive tasks, i.e. sending unique data to large numbers of internal Managers via single communication• Dramatically improved the accuracy and shortened report creation time by dealing with large amounts of complex data in Access Database with Query, SQL and VBA to conquer the limitations of Excel• Reduced human error and improved efficiency by design of an Excel User Form to standardize data formats and retrieve information from other systems to ensure data integrity• Increased data security by design of an Access Database with sign in forms to control and restrict access at user setup• Enhanced business data visualization incorporating strong Excel skills to produce complex multi-dimensional graphs for contingent labour vendor management analysis• Worked closely with other IT&S technical teams on different key systems and processes to coordinate the work effort among groups that resolves external contractors’ access issues resulting from poor cross-system data• Assist the Senior BA in managing our team’s growing number of contractors

• Worked with internal lines of Business and external companies, i.e. IESO, LDCs, and Meter Service Providers to complete wholesale and retail, which includes Generators, settlement tasks.• Efficiently and accurately managed large data databases and documentation on daily basis with a great level of attention to details and strong analysis skills• Improved the quality of the work by overseeing work progress, coordinating work schedule, tracking error patterns and reporting work status to management• Improved work effectiveness by leading the weekly meeting to identify the status and progress of the work• Ensured the smooth operation of the department by monitoring and escalating delays in projects and bottlenecks in business process

St. Catharines, On

• Collected research data through planning and technical abilities to complete large market research data collection of marketing survey implemented by faculty• Accelerated the research process with attention to detail to utilize SPSS to formulate data and provide strong proof of the results• Increased market research reliability and quality by applying business research methods for collecting marketing data from students at Brock integrating SPSS skillfully

St. Catharines, On, Canada

• Encouraged and helped graduate students get involved by promoting, planning, organizing, and implementing events for Graduate Business Council• Ensured the smooth process of events through active collaboration among all event Committee meetings from date of selection until post event feedback meeting, and provided a report of activities to Director upon event completion• Improved the efficiency of event implementation with leadership to manage Event Committee and other GBC Volunteers

Toronto, Canada Area

• Increased sales and surpassed the sales target by 20% by promoting events via social media and utilizing personal networking with large organizations• Fostered strong business relationships with initiative to develop communication among large organizations to promote business and help identify mutual need of related workshop development • Contributed to company’s product development by conducting research to develop workshops using PowerPoint as a communication medium; being used as a continuous workshop resource.• Impacted company’s performance with demonstrated leadership to take on challenge provided by management to create PowerPoint that would provide a professional resource for workshop content

Online

• Initiated expansion of access to information for Chinese students who are eager to learn via open classes that are provided by world-class universities through communication and attention to detail to translate and edit English subtitles to Chinese• Manipulated time axis of video structure to implement detailed subtitles through analysis of the time continuum to assure proper text and video alignment• Impacted quality of translation with research and strong attention to detail to ensure the accuracy of written communication by means of spelling, grammar, proper language and punctuation • Overcame competition from alternate editing groups by initiating an organized schedule to manage our time effectively our subtitled version would finish ahead and be integrated into related classes

Welland, On, Canada

• Managed food inventory in proper manner by communicating with managers and staff to understand the requirements for organizing and arranging materials and goods• Contributed to the inventory tracking system by attentively recording incoming physical inventory• Satisfied and met client demands and needs by offering suggestions and giving help to find the food and life necessities they are entitled to

School Of Continuing Studies, Data Science

1) Foundations of Data Science 2) Statistics for Data Science 3) Big Data Management Systems & Tools 4) Machine Learning - In Progress

Master Of Business Administration (M.B.A.), Finance, General, 85/100

Bachelor Of Business Administration (B.B.A.), International Business

Activities and Societies: • Exchange Study: (March – August 2010) International Management and Leadership Hochschule Neu-Ulm, Neu-Ulm.