Chi Do Email & Phone Number

Greenwood Village, Colorado, United States

• Support production deployments, including standard Microsoft D365 upgrades.
• Manage user access and security roles.
• Provide technical support and assistance to the users and stakeholders of the system.

Compton, California, United States

• Migrate Master and Transaction data from legacy system into Microsoft Dynamics 365.
• Support the testing of migrated data and provide data and analysis through all testing phases.

• Design and build a Data Warehouse for analysis and reporting. Create design documents for data mapping, transformation processes and data structures in the data warehouse.
• Design and develop SSIS packages to extract, transform and load the source data from various formats into data warehouse.
• Create and configure SSIS Catalog. Deploy SSIS projects built using the Project Deployment Model to the SSIS Catalog and schedule jobs to execute SSIS Packages from SQL Server Agent.
• Design and develop T-SQL scripts, user-defined functions and stored procedures to gather and prepare data sets for reports.
• Assist users in building data model and DAX formulas in Power Pivot to create Excel pivot table reports.
• Develop numerous daily, weekly and monthly summary and detail reports to support management reporting requirements in multiple formats using SQL Server Reporting Services (SSRS), Excel Power Pivot and Dynamics AX.

• Analyzed the business requirements and designed data warehouse for reporting and data analytics.
• Designed and developed ETL processes using Talend Open Studio.
• Set up data sources and prepared data for analysis in Tableau.
• Responsible for verifying accuracy of data, maintaining and supporting the data warehouse.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects.
• Assisted users with questions and issues using Tableau. Worked with infrastructure team and Tableau support team to help improve dashboard response time.

• Involved in building company database driven web site using PHP5 and MySQL.
• Integrated web site with back-end Interchange to process online orders using Perl, PHP and PostgreSQL.
• Migrated existing systems from Fedora to RHEL.
• Wrote PHP application for Third-Party Order Processing. The XML work order is sent to Magnet vendor along with artwork. Magnet vendor ships order directly to the customer.
• Built a custom transactional email system to improve communication in customer service and customer support.
• Involved in building a central coupon system using Perl, PHP and JSON for website and back-end Interchange. Integrated the coupon system into back-end Interchange order routines.