Heping Liu Email & Phone Number

*Proficient in Extract, Transform, Load (ETL/ELT) processes, adept at integrating data from diverse sources like APIs, databases, and flat files such as CSV.*Experienced in using SQL Server Integration Services (SSIS) for building data packages and SQL Server Reporting Services (SSRS) for deploying reports in web environments.*Demonstrated skills in data analysis and corporate reporting, utilizing tools like Power BI (with M and DAX languages), Tableau, and QlikView for insightful visuals and reports.*Advanced proficiency in SQL, capable of crafting complex queries, functions, and stored procedures. Expertise includes grouped queries, pivoting/unpivoting, leveraging SQL Window Functions, subqueries, and Common Table Expressions (CTEs).*Competent in implementing algorithms for data preparation and validation, and conducting common analyses like A/B testing, decision trees, logistic regression, and prediction using Python (Pandas, Matplotlib, Seaborn, Scikit-learn, NumPy, PySpark) and R for statistical analysis.*In-depth knowledge and experience with multiple databases like SQL Server, Oracle, Progress, etc. Good understanding of NoSQL databases such as MongoDB.*Extensive background in generating, automating, and managing ad hoc and periodic reports. Proficient in developing KPIs, OEE, Waste%, Inventory, MRP, etc., utilizing spreadsheets, metrics, scorecards, and dashboards.*Familiarity with Microsoft Azure Portal, managing resources such as Azure AD, Storage, SQL Databases, VMs, and a solid understanding of AWS cloud platforms.*Proficient in Microsoft Excel, including VBA/Macro programming, advanced formulas, and functions like pivot tables and graphing.*Experience in data modeling and database design, including normalization (1st, 2nd, 3rd normal forms) and denormalization concepts (Star/Snowflake Schema).*Good understanding of Machine Learning (ML) principles and Microsoft Azure AI technologies.*5+ years of experience in IT systems administration, including ERPs, Microsoft 365, and Azure Active Directory.*Over 4 years of experience in web and online application development using Object-Oriented Programming (OOP) principles, with proficiency in version control systems like Git and SVN.*Detail-oriented professional passionate about transforming data into actionable insights through critical thinking, analytical, and problem-solving skills.*Strong communicator with excellent interpersonal abilities, self-motivated and team-oriented.*Elected Employee of the Year.*Oracle Certified Associate (OCA).

Listed skills include Software Development, Java, Perl, Linux, and 11 others.

• 

  Seneca Polytechnic