IT and Data Management Specialist
NGC Transmission Equipment (America), Inc.
May 2018 - Jun 2021 (3 years 2 months)
• Maintained ERP database based on Microsoft SQL Server for production team as system administrator
• Wrote complex SQL queries to extract data from database based on requirements from different departments
• Designed and created Tableau dashboards to analyze purchase and selling data gathered from Salesforce and database
• Led Salesforce project and cooperated with third-party company to customize Field Service Lightning Application
• Coordinated with different teams to design workflows and processes in Salesforce
• Controlled user access and assured data security through Active Directory
• Documented IT projects and tracked changes of systems
• Created guidebooks and provided trainings to new Salesforce