SUMMARY:

Strong data management, migration, and analyzing skills; Experienced in SQL Server, SQL, Microsoft Business Intelligence (SSIS/SSRS/SSAS); administrated SQL servers and Application servers; designed and developed 4+ C#/VB/ASP.Net/LDAP web applications with Microsoft SQL Server; 4+ years working experience in SAP across different modules (SD, MM, PP, FICO, Vistex), 4 years experience in SAP implementations and data migrations (Ascential/BDC/LSMW/Script); Fluent in English and Mandarin;

PROFESSIONAL EXPERIENCE:

Data Migration Auditor

Confidential

Responsibilities:

• Conducted data migration audit for client to evaluation and recommend data migration procedure and methodology for ERP system implementation within short timeframe.
• Extracted 1.8 billion rows of legacy data using SSIS.
• Transformed and mapping to modern ERP system field using SQL Query/SSIS in BOA Data Migration Toolset™.
• Analyzed data quality and relevancy in SSRS and BOA Data Migration Toolset™.
• Programmed data enrichment application for potential data cleansing and data construction in BOA Data Migration Toolset™ using SQL as backend.

Data Migration Consultant

Confidential

Responsibilities:

• Designed database and developed queries/views/store procedures/functions in Microsoft SQL Server 2005/2008.
• Programmed SQL Server Integration Services (SSIS) and C#/.Net web applications for ETL process.
• Developed SQL queries/views Microsoft SQL Server Reporting Services (SSRS) reports and Report Model.
• Attached to BackOffice Data Dialysis® reports to assist data mediation and auditing.
• Applied BOA Data Migration Toolset™ assisting Data Migration project in System integrations; aligned data migration requirement with business needs; delivered Data StagingWarehouse™ and DataGarage® construction, EZMap™ methods, and cAPP (DataConstructionServer™) applications development work in excellent quality and way before schedule; Assisted data ETL for interface programming; programmed customized DTS package to support data transferring between Legacy System and Target system (Oracle/PL/SQL and MSSQL).

EBS Specialist

Confidential

Responsibilities:

• Analyzed business requirement and developed data/reporting solution in Microsoft SQL Server 2005/2008; supported SAP reporting and developed different report models through SSRS; designed and developed data extracting and transforming packages from SAP to SQL server using SSIS.
• Developed web applications for Sales Rebate application using C#/ASP.Net with Microsoft SQL Server 2008; designed and developed SSIS package for ETL processes; designed and developed SSRS reports and report model; integrated security and contact settings via LDAP classes; collected business requirements and delivered design of reports for user group and sales force; supported SAP Vistex; supported SAP Business Warehouse business requirement gathering for Vistex reporting (Pricing and Rebates); analyzed requirement and proposed cube/ODS structure for the developers; developed SAP BW queries.
• Implemented Loftware Label Design as new standard label printing software; designed new data structure for the label data in Microsoft SQL Server 2008; developed migration plan using SSIS as transforming packages and SSRS as reporting and data auditing tool; developed interface for data maintaining/construction/enrichment through .Net web application (C#).
• Supported SAP Security Redesign project; performed large scale data extracting and analyzing for transaction usage and business process to address security concerns by using Microsoft SQL Server SSIS/SSRS; suggested redesign approaches.
• Supported MTL SAP implementation of (3)4 locations in APAC and 8 locations in UK, Europe, and India; analyzed legacy business process and data structure and advised configuration requirements; led and conducted data migration using SSIS/SSRS/Datastage/LSMW; designed data migration plan to meet business needs; conducted data migration for Master Data and Transactional Data using Direct Input, Batch Input, LSMW, and GUIScripting; supported go - live and user training; loaded and analyzed financial balances (inventory and transaction data); conducted SAP Business Warehouse reporting training.
• Participated WCMS (DAY software pack) implementation; analyzed Division business needs for web content management system; participated in vendor selections and interviews; participated in WCMS implementation for the division and supported web content migration to the new system.
• Continue to support Project Tracking Database application; supported server moving; assisted in Database and Active Directory security design and deployment.
• Continue to support Enterprise Business System (EBS)/IT helpdesk for a user group of 1000+ users.

EBS A. Specialist

Confidential

Responsibilities:

• Designed, developed, and deployed Project Tracking Database application, a web application to support tracking, prioritizing, and reporting projects across whole Cooper Industries; users are normal project managers, project team member, and executives; developed using Microsoft SQL Server 2005 and .Net web application (C# w. AJAX); secured via LDAP (Active Directory) integration; extracting and transforming data through Microsoft SQL Server Integration Services (SSIS); achieved reporting functions through Microsoft SQL Server Reporting Services (SSRS); designed and deployed Reports Model.
• Designed, developed, and deployed Statistical Inventory Management System, a web application to calculate Inventory key figures, i.e., safety stock by using statistical algorithm; application mainly used by Inventory managers and Supply Chain managers and staff; extracting and transforming data through SSIS; developed using Microsoft SQL Server and .Net web application (VB.Net w. AJAX); achieved reporting functions through SSRS; designed and deployed Reports Model.
• Designed, developed, and deployed Crouse-Hinds Classroom and Training, an online classroom system, allowing trainer to publish class schedule and materials and allow user to register classes; developed using SQL database and .Net web application (C# w. AJAX); secured via LDAP (Active Directory) integration; achieved reporting functions through SSRS; designed and deployed Reports Model.
• Designed, developed, and deployed MVP Training recording system, an online training recording system, allowing user to maintain MVP training records; developed using Microsoft SQL Server 2005 and .Net web application (C# w. AJAX); secured via LDAP (Active Directory) integration; extracting and transforming data through SSIS; achieved reporting functions through SSRS; designed and deployed Reports Model.
• Designed, developed, and deployed Helpdesk Reporting, a reporting model and reports in Microsoft SQL Server 2005 and SSRS to support reporting of helpdesk tickets (Remedy System) and work load.
• Supported Active Directory clean-up project; programmed LDAP extract and load program via VBA.
• Supported WPI SAP implementation for 5 locations in US and Mexico; developed data migration plan; extracting and transforming data using SSIS/DTS/Datastage; executed data migration of master and transactional data using SAP Direct Input, Batch Input, LSMW, and GUIScripting; supported go-live and user training.
• Supported ICI SAP implementation for 2 locations in US; developed data migration plan for Master data such as Material Master, BOM, Routing, etc.; extracting and transforming data using SSIS/DTS/Datastage; executed data migration of master and transactional data using SAP Direct Input, Batch Input, LSMW, and GUIScripting; supported go-live and user training.
• Supported Dubai-Sourcing SAP Project by supporting material movement in SAP from Asia to Middle-East plants; conducted data migration for purchasing related data such as Material Master, Purchasing Info Records, Source List, etc; extracting and transforming data using SSIS/DTS/Datastage; executed data migration using SAP Direct Input, Batch Input, LSMW, and GUIScripting;
• Supported MTL WAVE 1 SAP implementation of 2 locations in US; analyzed legacy business process and advised configuration requirements; led data migration; designed data migration plan to meet business needs; extracting and transforming data using SSIS/DTS/Datastage; executed data migration using SAP Direct Input, Batch Input, LSMW, and GUIScripting; supported go-live and user training; loaded and analyzed balances (inventory); conducted SAP Business Warehouse reporting training.

Graduate Student/Intern

Confidential

Responsibilities:

• Designed and developed a project management system using Microsoft SQL Server 2005, SSIS/SSRS, and .Net technology.