CTF Life (FTLife) - Agency Recruitment Digital Project, the help client CTF to build agency recruitment system, and all recruitment process data will be extracted and processed into Azure Datalake, after ETL processing then provide to Power BI report consumingResponsibilities: As the only data team member, take responsibility as following:• Clarify requirement from BA or CTF client;• SQL Development to generate Excel version report;• Azure pipeline control center… Show more CTF Life (FTLife) - Agency Recruitment Digital Project, the help client CTF to build agency recruitment system, and all recruitment process data will be extracted and processed into Azure Datalake, after ETL processing then provide to Power BI report consumingResponsibilities: As the only data team member, take responsibility as following:• Clarify requirement from BA or CTF client;• SQL Development to generate Excel version report;• Azure pipeline control center data maintenance for Agency Recruitment system• Process SMSS data into Azure Datalake Raw layer• ETL development in Databricks Notebooks by Pyspark• Azure ADF pipeline enhancement• Test ETL logics for created tables• Power BI report development• Test Power BI visual dataTools and Technologies: Pyspark, Power BI, Azure Databricks, Azure Data Factory, Azure Synapse Analytics, SQL Management Studio Show less

EPAM Project Description: Big Data analytics solution built on Cloudera platform to enable standardized measurements and analytics for Sales Representatives and their First Line Managers. The activity data is ingested from CRM, Centris CRM, Offline files, Sales Integrator systems, etc. Source data are mainly on Call, RTW, HCP Portal, Meeting , all aggragated data should be ready on RDS and provide to report tool Qlicksense for extractionTeam Size: Phase I: BA:2; Dev: 5; QA:2Phase II:… Show more EPAM Project Description: Big Data analytics solution built on Cloudera platform to enable standardized measurements and analytics for Sales Representatives and their First Line Managers. The activity data is ingested from CRM, Centris CRM, Offline files, Sales Integrator systems, etc. Source data are mainly on Call, RTW, HCP Portal, Meeting , all aggragated data should be ready on RDS and provide to report tool Qlicksense for extractionTeam Size: Phase I: BA:2; Dev: 5; QA:2Phase II: BA:1; Dev:2; QA:1Project Roles: BI BAResponsibilities: •Participant as Business Analyst•Collect data requirement from business users•Source Data study and do data profiling•Make data solutions for data requirements and implement in SQL•Check source data qualities against business requirements•Consolidate data requirements and provide data solutions in JIRA stories and tasks•Prioritize and Schedule tasks in the team•Prepare UAT test strategy and data stretagy•Verify data output against business data requirements•Support business user on UAT test•Support user to check PROD data issues•Coordinate UAT/PROD release processTools and Technologies: (Before Migration)Impala/Hive from S3; SQL Server, (After Migration) AWS S3; AWS Redshift;PostGre (RDS), JIRA+XRay, Pycharm, Notepad++, Excel, Impala SQL, Hive SQL, Redshift SQL, PostGre SQL, SQL Server SQL , Transact-SQL, cucumber(old), pyspark, Excel Data Analysis; AWS Service Show less

Description:Data migration for Novartis Business Services from global platform to China AWS F1 platform.Responsibilities:• Analyze and prepare STTM with AS-IS platform ETL logic and transform to TO-BE platform suitable logic for 5 Dashboards with about 120 tables;• Integrate MDM ID change in the migration logic;• Provide test strategy on data migration with MDM ID change;• Daily UAT on Pre-PROD and analyze data issue.Tools and TTechnologies: PostgreSQL… Show more Description:Data migration for Novartis Business Services from global platform to China AWS F1 platform.Responsibilities:• Analyze and prepare STTM with AS-IS platform ETL logic and transform to TO-BE platform suitable logic for 5 Dashboards with about 120 tables;• Integrate MDM ID change in the migration logic;• Provide test strategy on data migration with MDM ID change;• Daily UAT on Pre-PROD and analyze data issue.Tools and TTechnologies: PostgreSQL, SQL Management Studio, PySpark, SQL, Apache Impala, Microsoft Excel, Amazon Redshift,qTest, JIRA, XRay-JIRA Show less

The small-scale project involves migrating the AS-IS SMSS source data of Alcon China to AWS cloud platform After data cleaning and integration through a data lake, the data will be extracted to the Alteryx reporting system.- AS-IS Source Data quality and data profile study;- Design Data Migration test stretagy, make test plan, assign and track test tasks progress- Test data logic in ETL in the AWS datalake;- Compare AS-IS and TO-BE data output;- Track data quality… Show more The small-scale project involves migrating the AS-IS SMSS source data of Alcon China to AWS cloud platform After data cleaning and integration through a data lake, the data will be extracted to the Alteryx reporting system.- AS-IS Source Data quality and data profile study;- Design Data Migration test stretagy, make test plan, assign and track test tasks progress- Test data logic in ETL in the AWS datalake;- Compare AS-IS and TO-BE data output;- Track data quality issues;Platform and Tools:SMSS, AWS S3, Glue Job, Scala Spark, Alteryx Show less

Project:NKE DATA project is to help NIKE China migrate DW BI data from SQL Server into Amozon EMR platform, which is integrated with spark, hive, airflow. The migration include data ingestion via ETL into data lake and Data Aggregation/Integration into DataMart (snowflake), finally feed data to Tabluea Dashboard reports.Environment: Legacy DB: SQL Server (SSIS, SSMS, Visiual Studio IDE) New Data Lake: Amazon s3, Spark, Hive, Snowflake, AWS EMR, Airflow, Pycharm, Yarn, Zeppelin, Hue, AWS… Show more Project:NKE DATA project is to help NIKE China migrate DW BI data from SQL Server into Amozon EMR platform, which is integrated with spark, hive, airflow. The migration include data ingestion via ETL into data lake and Data Aggregation/Integration into DataMart (snowflake), finally feed data to Tabluea Dashboard reports.Environment: Legacy DB: SQL Server (SSIS, SSMS, Visiual Studio IDE) New Data Lake: Amazon s3, Spark, Hive, Snowflake, AWS EMR, Airflow, Pycharm, Yarn, Zeppelin, Hue, AWS s3,Snowflake, SSMS, SSIS, Pyspark.sql, HIVE SQL, PL/SQL, python• Act as test team leader and key tester;• Design test stretagy, make test plan, assign and track test tasks progress• Test method ingestion testing, aggregation testing and E2E flow testing• Design test document templates(test case, defect, test evidence, test report)• Design case and test comlicated SQLs with sql unit test technologies• Technologies investigation for testing with pyspark.sql• Test data preparation with pyspark Show less

Customer: UBSProject Description: UBS Fund Agent – Fund Retail Agent for China market, covers mobile app, settlement control center, portfolio management, Finance reconciliation;BLTR - BLTR is Block Trading system. This system is part of UBS' complete investing system, it mainly helps giant clients to find out potential matchers for block sell/buy orders, so that dealers/traders(system user) can get contact to the matched clients to facilitate the block order deal via OTC, this… Show more Customer: UBSProject Description: UBS Fund Agent – Fund Retail Agent for China market, covers mobile app, settlement control center, portfolio management, Finance reconciliation;BLTR - BLTR is Block Trading system. This system is part of UBS' complete investing system, it mainly helps giant clients to find out potential matchers for block sell/buy orders, so that dealers/traders(system user) can get contact to the matched clients to facilitate the block order deal via OTC, this operation can avoid sending the block orders to the Exchange for trading which introduces big fluctuation to the stock price at a high riskSSTS - SSTS stands for Securities and Sales Trading System, this system mainly does the cash settlement for FXMM derivative products of eMerging market and provides GGL and reconciliation data feed to financial departments. Various derivative products are supported in this system, including FX, MM, Swap, Bond, Security, IRS/CRS. SSTS belongs to Back-end office, we have multiple upstream applications in Front-end office, and have other financial and reconciliation applications in downstreamResponsibilities:• Evaluate the test workload and make the test resource plan• Control the test process and handle any problems happened during the test execution• Automation: Design and create Robotframework (based on Python) automation test framework for Rest Service API and Stream Service API (Websocket-Stomp)• Automation: Write automation test cases and python test scripts, perform automation test• API Interface Test :Design and execute server side test cases, including REST API, Websocket API requests• Code Review: Review developer's DB procedure and help developers to improve the quality of DB procedures• Provide the test report to all related stakeholders• Communicate among Clients, IT Supports, Operators and Vendor developing teams based on the product functions Show less

Customer:Expedia GroupProject: Expedia is the world largest online travel website, there are more than 80 localized sites around the world. Expedia has a release version each week, covering all sites. We are responsible for the Integration Test and Pre-Production Test before new version goes online. Because of the big amount of test work, we have 100% automated our test pack. Each week we do one round of Trunk Test, and Jenkins Build Test, then we'll do Release Integration Test and… Show more Customer:Expedia GroupProject: Expedia is the world largest online travel website, there are more than 80 localized sites around the world. Expedia has a release version each week, covering all sites. We are responsible for the Integration Test and Pre-Production Test before new version goes online. Because of the big amount of test work, we have 100% automated our test pack. Each week we do one round of Trunk Test, and Jenkins Build Test, then we'll do Release Integration Test and Pre-Production Test, and open correspondent bug types (Defects, Automation and Environment) to responsible teams. We also need to fix automation bugs and write E2E test casesTeam Size: Integration Testing Team: 12Tasks performed: •(1)Use internal-developed test tool Labrun Manager to run all test cases in Trunk, Integration and Pre-Production version and analyze all failure reasons via Ruby debugging, manual repro and log analysis, and open correspondent bugs to responsible team•(2)Fix automation bugs and do E2E automation cases development•(3)Have located the root cause of multiple failures from Respec/Gherkin library levelEnvironment: RubyMine / Jenkins / LabRun, Ruby + Cucumber + Watir Show less

Project: Arina Stock Trading System, belonging to Deutsche Bank, is developed for dealers/ traders to trade stocks in corresponding Stock Markets (including Shenzhen, Shanghai, Hongkong, Taiwan, Thailand, Malaysia, India, Singapore, Indonisia, etc) under specific price policy. We are responsible for the Integration and UAT test phase. We cooperate with Hongkong Business Analyst team to work out test cases, test plan and test suites from requirements. We need to execute test according to the… Show more Project: Arina Stock Trading System, belonging to Deutsche Bank, is developed for dealers/ traders to trade stocks in corresponding Stock Markets (including Shenzhen, Shanghai, Hongkong, Taiwan, Thailand, Malaysia, India, Singapore, Indonisia, etc) under specific price policy. We are responsible for the Integration and UAT test phase. We cooperate with Hongkong Business Analyst team to work out test cases, test plan and test suites from requirements. We need to execute test according to the test plan and file bugs if new defects are found. We also need to send Daily report to address our execution process and summarize test KPI data to all stakeholdersProject Role: Test AnalysisTasks performed: •(1)Perform SIT/UAT test: analyze test requirements, create test plan, design test cases and evaluate test effort•(2)Execute test cases, cooperate with BA team to clarify issues and report bugs to DEV teamEnvironment: Citrix Show less

Customer: HuaweiProject: DT (Dynamic Tariffing) is a BI discount calculation system for customer's cell phone fee. This system includes 2 part: one part is data mining and analyzing module, this module provide customer's phone call behavior data analysis report; other module is discount calculation module, this part is to calculate customer's discount by multiple algorithms, like key-means, normal distributionTeam Size: Dev Team: 15 QA Team: 6Tasks performed: •1. Acted as… Show more Customer: HuaweiProject: DT (Dynamic Tariffing) is a BI discount calculation system for customer's cell phone fee. This system includes 2 part: one part is data mining and analyzing module, this module provide customer's phone call behavior data analysis report; other module is discount calculation module, this part is to calculate customer's discount by multiple algorithms, like key-means, normal distributionTeam Size: Dev Team: 15 QA Team: 6Tasks performed: •1. Acted as Test Leader for one and a half year in DT project, take in charge of test planning, test risk evaluation, test strategy decision. As TSE take the responsibility of analyzing test requirements and test scenarios designing•2. Familiar with maintainence of SUSE linux OS system, and have built two automation test frameworks based on TestNG(JAVA)+ DBUnit and RFT•3. Familiar with Agile process very well, helped the project leader to streamline agile process within our project•4. Travelled to Bangalore to provide a two-month long English business training to Huawei India DT team members•5. Travelled to Dhaka, Bangladesh to Supported DT commercial launch for three months, in charge of trouble shooting, data extraction features (DB Procedure) development for on-site•6. Familiar with ETL data extration process and K-means algothrim for business analysis•7. Organized English Salon in our team to improve all members English, this activity was very popularEnvironment: Oracle, ETL, Bugzilla, SecureCRT, Unix System, VCS (Dual Machine maintenance) , Oracle Admin, Oracle Procedure, SQL, Java(TestNG) Show less