| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
Chen-Juei (Ricky) HuangDATA ANALYST McKinney, TX Street Address
PHONE NUMBER AVAILABLEEMAIL AVAILABLEPROFILEI am a Data Analyst with expertise in data extraction, transformation, loading, analysis, flow, and extraction within fast-paced production environments. At SMS InfoComm Corporation, I conduct statistical analysis, optimizing the process, reducing the cost, and improving productivity. Capable of adapting to fast-paced, rapidly evolving operations to complete tasks within strict time and budget constraints while building strong internal relationships to achieve strategic corporate objectives. Fluent in English & Mandarin.AREAS OF EXPERTISE Data Analysis & Reporting Data Validation & Verification Data Extraction, Transformation, & Loading (ETL) Data Migration & Exchange Root Cause Analysis
Solution Planning Data Flow Optimization
Relational Database Management
Disaster Recovery Planning Program Deployment Quality Assurance Business Logic Improvement System Configuration Power BI SQL .NET (C#)EDUCATIONMaster of Science, Computer ScienceUniversity of Alabama at Birmingham, 2020Bachelor of Science, Computer Science & Information Management
SooChow University, Taiwan, 2010PROFESSIONAL EXPERIENCESMS InfoComm Corporation(Wistron) 09/2020 to 07/2024Data AnalystFormulate and supply mathematical modeling and other optimizing methods to develop and interpret information that assists management with decision-making, policy formulation, or managerial functions. Collect and analyze data then develop decision support software concept, service flows. Develop and supply optimal time, cost, or logistics networks for program evaluation, review, or implementation. Communicate and collaborate with different departments to collect requirements and perform GAP analysis on the current process. Analyze business operation/issues, solution configuration, and provide problem solving through system and process to achieve business requirements. Perform quality assurance across different vendor unified enterprise applications in addition to report and EDI. Lead the project to automate detection components at product lines that improve company productivity and reduce the human error rate about 20%. Lead the project Auto Receiving Line (ARL) to reduce the headcount and save the time nearly 15%.MINGTAI / Mitsui Sumitomo Insurance Group 4/2015 to 5/2017Senior Data Analyst
Oversaw program deployment within a fast-paced production environment to meet all capability requirements, managing all aspects documentation, logging, configuration, and disaster recovery planning to ensure superior data security. Played a key role in business model development to streamline data flow review and cash flow monitoring with Finance Team Base on Oracle ERP. Led extraction, transformation, data loading (ETL processes), as well as data analysis from COBOL database system to Oracle database system. Partnered with marketing, finance, and sales teams to identify requirements, overseeing database system design, development, and deployment to meet various departmental needs. Managed company financials in Oracle database to balance accounts. Oversaw index file maintenance and data length in the database while relocating data as needed to prevent overflow and storage issues.MSIG Asia MINGTAI, Mitsui Sumitomo Insurance Group 6/2012 to 3/2015Data AnalystLeveraged COBOL language expertise in an IBM mainframe to manage house fire insurance efforts, streamlining communications to build a user-friendly environment.
Identified cross-functional needs of various users and departments to strategize on system enhancements and program development needs. Led the development and implementation of a new data flow and interface that improved user efficiency.TECHNICAL EXPERTISE & CERTIFICATES C, C++, COBOL, JAVA, .NET, C#, Python Relational Databases: SQL Server, Oracle Database, PostgreSQL, JSON Project Management Associate, Level D |
