Sam Cheng Email & Phone Number

Holly Springs, Nc, Us

Radnor, Pa, Us

• Design and develop data warehouse, data modeling for healthcare analytics solution focused on improving health of population, patient & provider experience and reduce cost of care. • Orchestrate Azure data factory pipelines to integrate claims data from health systems into SQL server instance for consumption. • Validate variances in ingested data to ensure consistency, accuracy and overall data integrity.• Stage, promote, archive, restore databases as part of data lifecycle to provide latest as well as historic data for our data scientists' analysis.• Create, enhance and troubleshoot stored procedures, functions and views used in ETL/ELT processes.• Build and publish SSDT scripts to deploy code and schema changes from data warehouse repository to test environments before moving to production.• Develop, maintain and modify python scripts and repos used for validation automation, API integration and complex reporting.• Participate in code review, sprint planning in Azure DevOps. Collaborate with data scientists to QA code changes for data warehouse development in Azure GIT repos following best practices.• Identify opportunities for improving data pipeline infrastructure, workflows and developer quality of life.

Leverkusen, North Rhine-Westphalia, De

• As the IT contractor on the Knowledge Information Management team, provide technical & development support for all digital data transformation projects within the Regulatory Affairs group.• Update existing/develop new data visualizations using Tableau and Power BI. Converting traditional reports and data sources into interactive modern dashboards.• Utilize Regex and PowerShell to mine information from word documents transforming form data into report ready tabular format for analysis, eliminating manual collection of sensitive data.• Write scripts to collect, cleanse and load data from local files to Oracle DB tables for integration with other systems and applications.• Drive and lead projects to create user-friendly applications within the Microsoft stack using Power Apps, Automate/Flow, Power BI together to maximize the utilization of data scattered across different systems.

Bristol, Pa, Us

• Python Data Analysis - Translate business requirements and problems into python scripts/jupyter notebooks designs providing immediate insights and results to identify, pinpoint and troubleshoot data errors from across different data platforms. • Python Development - Research, experiment and create proof of concepts using various data mining, web scraping, webservices requests and data techniques to explore the use cases of API test automation, advanced analytics and machine learning for operational benefits.• SQL (Oracle) - Create and test new queries per business/analysis needs. Update legacy queries to tune/optimize statement performances in deployed applications. Create PL blocks for stored procedures/functions used in DML and ETL processes.• Data Visualization - Develop custom analytics dashboards in Qlik Sense using connectors, load scripts, advanced analysis and modern charts/diagrams to generate actionable insights from the data.

Trenton, New Jersey, Us

• UI & backend Java web development for in-house inventory management system • Support program development cycle by collaborating with testers and users in dev, staging and production environments • Monitor and review server logs to identify and troubleshoot errors • Continuous integration with trunk based development via SVN and Jenkins • Provide project estimates based on business requirements • Establish cron scheduler for inbound-outbound client data feeds on SFTP

Trenton, New Jersey, Us

• Write SQL queries for data analysis, track record staging status and provide targeted lists for internal and external consumption • Collect, organize, cleanse, analyze and transform data into information to help improve operational efficiency and identify billing opportunities • Communicate business requirements for new campaigns, systems integration and application development between Client Services and IT department • Code and develop custom automation tools/scripts/utility GUIs to automate manual tasks • Execute Mainframe JCLs to queue and troubleshoot job execution

- Worked as a liaison between local managers and foreign management team to communicate and coordinate daily activities- Translated business documents, proposals and plans between Chinese (Mandarin), French and English- Developed lessons, class activities, and exams as part of the three month English curriculum- Trained a group of eight managers to become competent in speaking, listening and writing in English- Assisted the managers with presentations in English at the monthly meetings to track the training progress