Terry Leng Email & Phone Number

Charlotte, Nc, Us

• Experience in Data lake / Big data analytics platform implementation with AWS • Expertise with RDBMS and Data Warehousing (Strong SQL) with Redshift and Athena • Hands-on experience with Apache Airflow• Create ETL data pipeline using Python• In-depth knowledge and experience with data and information architecture patterns and implementation approaches for Operational Data Stores, Data Warehouses, Data Marts and Data Lakes• Proficiency in logical/physical data architecture, design and development

New York, Ny, Us

• Manage SAS jobs to provide solid data for business reports • Develop dashboard using Excel and Tableau to demonstrate the analysis outcome for different teams • Write Python code to automate the data transfer process and simplify control jobs • Creating data migration jobs to integrate various data source into Teradata and Snowflake using Alteryx • Mining large datasets to show key metrics for business function performance • Develop and represent deep data knowledge to support performance monitoring and analysis delivery • Write complex SQL queries to implement various data requests

Tampa, Fl, Us

• Mining large datasets to improve existing Customer Relation Management (CRM) strategies • Coordinate and communicate between technical team and analytical team • Manage projects timelines and divide those projects into specific tasks for team members • Monitor and tracking data migration projects with JIRA dashboard • Implement ETL process through AWS Glue to load data from S3 to AWS Redshift • Write complex SQL queries to extract data from AWS Redshift for further analysis • Write Python jobs to cleanse the data and integrate into AWS Redshift • Proficient in creating dashboards and reports in Tableau and Power BI • Excellent understanding and hands-on experiences of data modeling and architecting for RDBMS • Architect BI solutions from building data warehouse to support clean data for the analytical teams • Implement analytical and business requirements through Python • Create complex SSIS packages to implement the requirements for ETL process • Hands on experience in developing dashboard and reports through Tableau, SSRS and Excel • Proficient in writing all SQL objects including view, index, and store procedure

•Responsible for collecting requirements, creating system specifications and providing high level estimates.•Involved all phases of software development life cycle (SDLC) to complete the implementation of the data warehouse•Load large dataset into QlikView and create scoreboards and dashboards to predict product sales and analyze trends•Use SharePoint to deploy QlikView dashboards and send notification emails to related departments•Using SSAS to create cubes and conduct cube optimization while using different partition modes •Writing SSIS packages through C# •Website Implementation through MVC5 Asp.net •Reading and writing data in C# to perform data transformation•Using C# to develop functions for other business requirements•Designing and Implement multiple types of SQL Server Reporting Services (SSRS) Reports •Excellent knowledge of scheduling jobs and alerts using SQL Server Agent to run SSIS Packages•Proficient in writing T-SQL queries involving creation of tables, views, stored procedures; perform insert, update, delete; and use different joins, sub-queries and adding constraints on the tables.

Mba

Master'S Degree, Computer Science

Ba, International Business