WEN SUN 908-***-**** ady6ve@r.postjobfree.com

SUMMARY:

Twenty years of experience in software application development and production support

Proficient in SQL Server, Oracle,.Net, UNIX/LINUX in variety of industries including Telecommunication, insurance and reinsurance, financial services with ETL, Data warehouse, Client/server and web application,

Excellent in working with others and communicating effectively

Highly motivated, with a passion for learning

TECHNICAL SKILLS

SQL Server, Oracle, T-SQL, PL/SQL, SSMS, SQL*Loader, SSIS, SQL Navigator, TOAD, Sybase, Microsoft Visio, MySQL, SQLite, MS Access, Excel, Data Ease

VB.Net, C#, UNIX and LINUX shell script programming, Awk, Perl, JAVA, JAVA scripts, C#, Pro*C, C, C++, HTML, XML, BRIO/SQR, Crystal Report, Siebel7.3, Clarify

MS Visual Studio, LINUX, and UNIX Solaris/SunOS, AIX, HP-UX)

Sufficient in Data Quality, Data Warehousing, Agile Software Development, Business Requirements, Problem Solving, Technical Requirements, Test Cases, User Stories, Visualization, Workload Prioritization

PROFESSIONAL EXPERIENCE

METTEL - Manhattan Telecommunications Corporation, Holmdel, NJ May 2022 – July 2023

Sr. Database Developer/Architect - Using Microsoft SQL Server 2017, Data Warehousing, Software Design · Data Structures · Stored Procedures · SSIS · T-SQL · SQL Load ·

•Participate in designing, writing optimized query, developing store procedures, functions, views, and etc. for ERP applications to integrate with financial data and sageX3 system.

•Enhance real time ETL process by designing, developing and implementing Cash receipt, Client and Suppliers' updates.

•Hot fix and Production Support for AR/AP, Invoices/Payments process.

•Monitor data processes and maintain application.

•Documenting and set up development plan.

HEAT-TIMER, FAIRFIELD, NEW JERSEY

Sr. Software Engineer/Database Lead Jan 2012 – May 2022

Innovate solutions for complex technical problems. Performance Tuning by Analyzing existing database structure and code, rebuild, redesign index, optimizing by re-designed and re-developed the applications. Performance increased significantly, and also reduced the frequency of database maintenance.

Designed, implemented an ETL process from application database to a Data Warehouse for reporting.

Leverage technical expertise to architect and implement critical system, Data flow, Data molding, database structures, tables, keys and constrains, Schedule Jobs, Schemas, Database Links, Users, Permission and etc.,

Key contributor to the Building Net product development. Writing and debugging complex queries. Developing store procedures, functions, views, types and etc., using T-SQL programming language, SSIS and SSRS on SQL Server.

DBA Administrate DB data file, log files, file groups, Recovery model options, maintenance plan, restore/backup, performance tuning, index rebuild/reorganize, transaction log shipping, security control, activity monitor, using Sentry One tool to monitor and alert.

Strong problem solving and analytical skills in production support on Customer based Web Site, Mobile App, Admin Web Site, and batch process cops.

Work collaboratively within the team and across groups to deliver products that broaden and improve our offering to customers. Responsible in backend project designing, and system management, from business requirement, tech specs, workflow, dataflow, system performance, security, deployment, and manageability.

MARTINDALE HUBBELL - LEXISNEXIS GROUP, NEW PROVIDENCE, NEW JERSEY March 2003 – Dec 2011

Leading DB developer on Lawyers.com, invoked performance tuning and data analysis, designed XSD/XML, developed database views and APIs.

Major developer on order fulfillment, data to content management systems (Site Core) on Oracle, java, and php. Coordinate adjacent application for integration and migration across departments, on shore and off shore.

Leading queue system designer and developer on Real Time Update, algorithm designer and database developer for "People You may Know" and "Content Relevant Rating" and many other widgets for LDC and MDC Professional Network

Major developer on order fulfillment, data to content management systems (Site Core) on SQLServer2008R2, and #C, .NET, java, and php. Coordinate adjacent application for integration and migration across departments, on shore and off shore.

Major database designer and major developer for Total Practice Solution – Single Sign On - Interaction Account projects; This Interaction Account provide seamless logon to other LexisNexis web applications. The identity Server accepts inbound URLs from LexisNexis Interaction Servers and responds with user-authenticated URLs for other LexisNexis application.

Involved in database designer and major developer for Newsletter Admin Console – This web based application provides on-line newsletter article searching, allow user to subscribe and unsubscribe newsletter. The admin console also controls user administration authentication and user access tracking.

Designer and developer on url and custom url mapping projects on martindale.com and lawyer.com - large law electronic products

Lead developer for UNIX to LINUX configuration and OCS to Tidal scheduler promotion.

Solo Responsible in the full project lifecycle of planning, designing, developing, testing and implementing a Revenue Recognition system based on finance policy for the domestic and international products for definitions of gross and net revenue - A General Accounting overview of liability, revenue and asset, using Oracle 9i SQL*Loader, PL/SQL, Crystal Report, FTP, Windows Batch and UNIX shell Scripting.

Involved in CRM/Siebel Product, Pricing Administration and Order Management project integration, upgrading, converting, data migration, using Siebel7.5.3 version of Product class, Product Attribute, Product configuration rules, Creating and assigning Price List/Rate List/Cost List, Set up component-based and attribute-base pricing, also used Oracle PL/SQL, SQL*Loader, Siebel isql, Crystal Report, FTP, Unix Shell Scripting, Windows Batch, Database Pilot, and Siebel7.5 developing tools.

Responsibilities for these legal service-electronic products applications include:

oDesigning database structures and entity relationship model by using Oracle 12/11g/10g/9i, SQLServer2005, MS Visio, and Business requirements

oDesigning and generating Oracle and SQLServer database API components (tables, index, packages, procedures, functions and triggers) by using PL/SQL, XML, CLOB/BLOB, encrypt/decrypt functions and others

oDesigning and creating UNIX/LINX shell scripts, SQL Server Agent, Windows Batch to implement loading, batch, and reports

oWorking with QA team to provide release checklist and perform system testing on QA/CERT/PROD environments by using PVCS version control, merant PVCS

oProviding project plan, workflow and detail task list

oMentoring offshore team in their development tasks

MERRILL LYNCH, NEW YORK, NEW YORK Nov. 2000 – Feb. 2003

Sr. Program Developer/AVP

Major contributor in all phases of two financial applications COAST (a market data service CRM system) and TOPS (a trading switching data CRM system) development, enhancement and maintenance under UNIX platforms by communicating with users, clients, vendors;

oDesigned, developed, tested and implemented systems in the full project lifecycle of each product release and enhancement by using Oracle 8.x/9i PL/SQL, (packages, procedures, functions and triggers), SQL*Loader, SQL*Plus, SQL tuning, CRM - Clarify/Clear Basic, BRIO/SQR, UNIX shell scripts, Awk, Perl, Pro*C, FTP, Data Ease, DB Artisan, Remedy, Clear Case/PVCS, Microsoft Projects and business knowledge.

oProduction supported the system including troubleshooting, debugging and users training. Developed, monitored and maintained 24/7 Autosys jobs by using Oracle PL/SQL, (packages, procedures, functions and triggers), SQL*Loader, SQL*Plus, CRM - Clarify/Clear Basic, UNIX shell scripts, Pro*C, FTP, Data Ease, DB Artisan, Remedy, Clear Case/PVCS, Microsoft Projects and business knowledge.

oGenerated reports, design documents, technical design specifications and test plan by analyzing users’ requests.

Production support & QA for a Web based Content Management System for ML's Benefit online and intranet WorldNet home page, using Oracle 9i, Stellent, HTML, XML, VB scripts, ASP and JAVA scripts, XML, XSL and IIS. Generated design documents, user's menu and test plans include unit test, system test and UAT.

STANDARD & POOR'S, NEW YORK, NEW YORK Nov. 1999 - Nov. 2000

Systems Analyst

Involved in business requirement analysis for an insurance rating system. Designed and implemented its application and database using Oracle 7.x/8x, and 2000 Developer. Enhanced National Association of Insurance Commissioners (NAIC) data loading, data transforming & transporting for data warehousing to improve data quality and improve database operation. Provided packages and store procedures for S&P client/server and Web server applications using Oracle PL/SQL, Forms/Reports, Pro*C, Awk, UNIX shell scripts, JAVA, FTP under UNIX and Windows NT.

INFOUSA, MONTVALE, NEW JERSEY Dec. 1998 - Nov. 1999

Programmer/Analyst

Developed, maintained and implemented a database development project for Chase Mortgage Inc., using Oracle PL/SQL, Pro*C, and shell script on UNIX. The project involved initial loading processing, analyzing and reformatting feed data, update processing, and reconciliation procedures. It was securing mortgage loan applications from the public, processing those applications and lending the capital necessary for the purchase of home and business.

Designed, developed and implemented marketing reports for Cisco Systems, Inc.'s web page by using Excel, VBA, ODBC, Oracle SQL*Plus, PL/SQL and etc. These functions enabled the system to fetch data and generate graphs automatically. The monthly analysis & segmentation summary report and two versions comparison detail-report contained information including Cisco customer, prospect and suspect contacts, company and site-type profile, Cisco direct purchase history and other related marketing history, network and technical profile, and the primary countries.

ARGO Group/PXRE REINSURANCE CO., EDISON, NEW JERSEY Feb, 1997 - Dec. 1998

Programmer/Analyst

Enhanced, converted and maintained PXRE and Transnational reinsurance database system. Generated finance reports for detail treaties, line of business, shared business, ceded business and general ledger. They were implemented on UNIX by using Oracle PL/SQL and Pro C.

Developed and generated finance reports for European reinsurance branch offices. These reports provided premium and loss information by different currency for tax purpose. They were implemented on UNIX by using Oracle SQL*PLUS, Oracle Reports, FTP, AWK and C.

Designed and implemented uploading general ledger for accounting purpose. It was implemented on NT by using Visual Basic.

EDUCATION

Master of Computer and Information Science - New Jersey Institute of Technology at Newark, New Jersy

Master of Civil and Environmental Engineering – University of Texas at Arlington, Texas

Bachelor of Civil Engineering – TongJi University, Shanghai, China

Contact this candidate