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 Morphx IDE/X++.• Create various elements from the AOT (Application Object Tree) like Tables, Extended Data Types, Enums, Views, Forms, Classes, Queries, Reports and Menu Items when required during the flow of the project.• Work on the modules General ledger, Accounts receivable, Accounts payable and Inventory management in Dynamics AX.• Assist users with day-to-day issues, problems and questions related to production or development environments.• Write classes in AX to create Landed Cost Shipment with multiple vendors from csv files.• Implement and maintain AIF and XML endpoints for EDI integration.• Assist in the creation and documentation of business processes and module configurations.• Involve in creating new company and migrating data from legacy system to Dynamics AX.• Develop Inbound maps for EDI ANSI X12 850 and Outbound maps for 855, 856, 810 using Data Masons UDTIDE. Create table views, UDFs to gather and prepare data sets for EDI mapping.

• 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, scheduling refreshes and subscriptions in Tableau Online. • 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.• Worked closely with marketing and production teams for new product development. • Designed database and workflow to route jobs between production facilities in CA and NJ. • Worked with Data Modeler, Business Analyst to build data model and table structures for Data warehouse.• Created PHP scripts to automate the data load processes to the target Data Warehouse.• Created custom reports to support the need of marketing, financial departments and production team.• Migrated data from legacy system to SAP system. Worked with SAP consultants to create data mapping and data dictionary documents. Wrote PHP application to export legacy data to text file and load the data into SAP using LSMW.