Bin Meng

(***) *** - **** adl5ss@r.postjobfree.com

SUMMARY

A highly motivated, performance-driven IT professional who has taken on career challenges from being an Application Developer to an ETL developer and met objectives for 20 years in VCI. Full lifecycle project delivery experience from creating design documents, coding, conducting unit and system tests, quality assurance, and release into a production environment. Solid understanding and experience in traditional project development methodologies and practicing agile development methodologies. CORE COMPETENCIES

Database Skills: Expert SQL skills in Oracle PL/SQL, MS SQL T-SQL, and Sybase SQL. Participated in analysis, design, and implementation of the ETL processes and the business applications, database modeling and design using all 3 databases. The tasks include creating and developing different database objects such as SQL scripts, Stored Procedures, Packages, Functions, Views, Cursors, and Triggers

Databases: Oracle 11g/12c, MS SQL Server 2014, and Sybase v16. Database Tools:

ETL Tool:

Embarcadero Rapid SQL, MS SQL Server Management Studio, Oracle SQL Developer, and SQL Plus

Informatica Power Center v10

Platforms:

Version Control:

Deployment Tool:

Windows Server, HP Unix and Linux

TFS with Microsoft Visual Studio 2015

TFS Workbench and Microsoft Release Management (RM) Language: MS Visual Studio C#/VB.net 2015, Java Script and Kornshell script Web Services:

Data Lake/AWS:

Interpersonal skills:

XML, XML Schema, SOAP, WSDL, UDDI, XSLT, HTTP, SSL, and Dynamic HTML Basic knowledge about Data Lake and AWS (Currently pursuing on AWS Solutions Architect Certification)

Exceptional troubleshooting skills with ETL Technologies Excellent learning capability to adapt to and apply new concepts quickly Fostered good relationships with business, other IT departments and 3rd parties Analytical and assertive as both a team player and an individual contributor Software Developer Consultant in Data Operations

VW Credit Inc. Libertyville, IL

• ETL Developer involved in various projects related to Data Modeling, Data Analysis, Design and Development for Data Warehousing environments

• Primary developer for the CCT (Call/Contact Center Technology) process, where my responsibilities involved database design, analyze/design and implement ETL processes

• Primary developer who established and maintained database objects (both Oracle/MS SQL) for the Dealer Bonus Incentive process

• Sales and Marketing Analytics for AutoData Brand Sales process: implemented analytics for the sales and marketing data for various products marketed and sold by Audi, VW, and Ducati

• Wrote ad-hoc queries (both Oracle/MS SQL Server) based on schema understanding for diverse needs of business users

• SQL Query Performance Optimization and Tuning in both Oracle and MS SQL Server

• Development coordinator for IT and business departments for DCRs, PCCs, troubleshooting issues in all environments; DEV, QA, UAT, Pre-Prod and Prod. Post deployment supports

02/2015 – 07/2020

Software Developer Consultant in Service Ops. Tech./Shared Services VW Credit Inc. Libertyville, IL

• Cloverleaf Data Conversion - a key developer for data mapping from VCI legacy system including LeasePak (Sybase) and Remarketing (Oracle) to FIS system

• Key developer for the disaster backup of LeasePak (Sybase); closely worked with the Database/Unix/Network teams to create backup procedures, data restores, network setup and configurations

06/2012 – 02/2015

Software Developer Specialist/Consultant in Service Ops. Tech./Shared Services VW Credit Inc. Libertyville, IL

• Maintained initiative to stay updated with new technology to solve, support, and complete LeasePak (Sybase) system and databases by designing, developing, improving, and implementing various applications, which include ETL jobs, Web and Window Client/Server Application development using Informatica, Microsoft.NET Framework, C#.NET, ASP.NET, WCF, HTML, and XML 04/2000 – 06/2012

• Created the standardized Encryption/Decryption process, which has been used by VCI IT Ops for all IN/OUT file transferring since 2008; voluntarily created the user guide simultaneously, resulting in efficient and streamlined running and becoming the standard training material for IT Ops

• LeasePak Expert – One of two primary developers and support of the legacy LeasePak System on Sybase (2000 – 2016): developed over 50% of the code in the master stored Procedure for business requirements; supported the application by troubleshooting bugs, application installations and customization, network setup and configurations on the Windows and Unix servers and Sybase and MS SQL databases

• Developed the first C#.NET LeaseTek app (2006), which was built and run in VCI Libertyville; converted data from Microsoft FoxPro to MS SQL Server to Sybase for the app

CNA Insurance Corp., Chicago, IL

• System Analyst - Modification of VB apps to meet the ABA (American Bar Association) Standards

01/2000 – 04/2000

Raytheon Engineers & Constructors, Downers Grove, IL

• System Analyst

System Integration and Validation for Kraft Food Company and Centeon Pharmaceutical Co.

• Structural Engineer/Sr. Structural Engineer

Assisted in the management of project delivery in order to provide clients with results on time and budget

Support development of technical proposal and provide comments on the technical content and level of effort of the proposed scope of work Conduct design development and contract document work sessions at project site in conjunction with the project manager and other disciplines 09/1994 – 11/1999

05/1998 – 11/1999

09/1994 – 05/1998

EDUCATION AND TRAINING

DePaul University, Chicago, Illinois

Certificate in Window Application Development Program 03/1999 – 10/1999

University of Illinois at Chicago, Chicago, Illinois Master in Civil Engineering

08/1990 – 05/1992

Contact this candidate