321-***-**** firstname.lastname@example.org www.linkedin.com/in/juewei-weng-249a561b/
Hands-on, solutions-driven professional with 18+ years of experience in Software Development Life Cycle (SDLC). Strong learning, analyzing, problem-solving and troubleshooting skills. Proven track record in designing, developing, coding, testing, supporting, debugging, and maintaining complex, distributed database and application systems. Productive in both team-based and self-managed projects. Special interest in database performance tuning and application optimization.
Oracle PL/SQL, Sybase ASE, Large-Scale Database Systems, Data Analysis, Data Warehouse, ETL, Performance Tuning, Data Migration, Database Application Support, QA, SQL Server
Unix/Linux, Shell Script, Perl, C/C++, OOD/OOP, Visual Studio, ASP.NET, C#/MVC/Web API 2, Entity Framework, JSON
NORTHROP GRUMMAN, Orlando, Florida 05/2018 – 08/2018
Took part in Network Management System detailed design, coded in C#, MVC and Web API 2. Worked on backend using Entity Framework mapping Postgres database tables.
INMARSAT INC (Formerly known as Globe Wireless), Palm Bay, Florida 05/2009 - 11/2017
Senior Software Engineer
Extensive experience in Oracle and Sybase database development by writing Packages, Stored Procedures,
Functions, Triggers, Ref Cursors, Dynamic SQL, Exception Handling and creating and maintaining Database Objects like Tables, Views and Materialized views, Constraints, Sequences, Synonyms and Database Links. Strong knowledge in performance tuning which including Joins, Indexes, Explain Plans, Hints and Partitions.
Designed, implemented and supported monthly revenue and margin analyzing and estimating system in Oracle PL/SQL, Sybase iSql, Visual C++. Work includes loading and processing CDR data using SQL*Loader and BCP, coding stored procedures, functions, packages, triggers and tuning complicated queries.
Integrated, maintained and took full responsibility of Monthly Traffic Invoicing Process run ($6M revenue). Performed parsing complex formats of CDR data, analyzing traffic types, enhancing performance for very large tables, fine tuning complicated queries and stored procedures, researching and investigating complicated billing issues.
Optimized bill run time from six days with constant supervision to ten hours with no intervention. Constantly analyzed, verified, and improved invoicing process by rewriting and modifying code.
Initiated and delivered an invoicing software to satisfying customers’ detailed and accurate billing request by utilizing Firewall traffic data, calculate and present information depending on various plans, identify specific traffic types and ports.
Created special program (split billing) replacing manual process to reduce 40 hours monthly labor cost.
Worked closely with Finance team and management to resolve complicated invoicing issues effectively by deeply understanding algorithm and logic of invoicing process code.
MEDAI INC, Orlando, Florida 04/2008 - 12/2008 Oracle PL/SQL Developer (Contractor)
Started MEDAI’s new project PinPoint Review designed to provide hospital with forecasting to indicate that patient has the characteristics of having less than favorable outcomes during an admission.
Analyzed customer data, creating Oracle schemas, tablespaces, tables and indexes and loading data based on business logic and project guidelines.
Wrote SQL scripts, PL/SQL procedures, functions and packages for critical measures.
Used Oracle Enterprise Manager and SQL Navigator to maintain and monitor database performance.
SYMANTEC CORPORATION, Heathrow, Florida 01/2007 - 03/2008
Advanced Technical Support Engineer
Provided technical support for Symantec Application Performance Management (APM) System by communicating with customers and partners for plan of action, using available tools to investigate, troubleshoot, diagnose, document, and resolve customer issues.
Coordinated, analyzed, tracked, resolved and responded to 10+ customer cases per week and received excellent customer service satisfactory award in customer survey.
Installed, customized, configured Veritas i3 systems and resolved problems for various Oracle database management and performance issues through Phone/Webex support.
Advised and directed customers tuning Oracle databases to prevent and/or resolve any performance problems.
WALT DISNEY WORLD, Lake Buena Vista, Florida 08/2004 - 12/2006
Senior Programmer Analyst/Technical Support
Developed and implemented supporting standardized operational scripts for Nightly Batch Processes for Disney Cruise Line Revenue Management System (DCLRMS) using Oracle PL/SQL, Perl, and Linux Shell Scripts. Monitored, maintained, troubleshot, updated, modified, and expanded existing applications and Import/Export databases for Disney Data Warehouse.
Performed installation of Application Servers and Databases for DCLRMS and deployed/configured server-side Linux, C/C++ and database environments and client-side user interface and database configurations.
Analyzed inspection data to confirm operational efficiency.
Performed 24/7 on-call for DCLRMS to provide technical support and advanced services to business users.
Created and migrated all database objects through various development, testing, and production environments.
Performed validation of nightly batch outcome including the testing and debugging of data discrepancies, application and forecaster errors.
Supported and Performed complete QA testing circle for DCLRMS.
VERIZON (Formerly known as MCI WorldCom), Clinton, Mississippi 04/1997 - 06/2004
Software Systems Engineer/Programmer Analyst
Delivered Trouble Reporting System (TRS) for BroadBand Operations Support System. Analyzed and designed system functional specifications, implemented and unit-tested C++ classes, Oracle PL/SQL and Sybase Transact-SQL code, and CGI interface. System reclaimed equipment and improved data integrity in company's several network inventory and equipment systems. Project resulted in cost avoidance and labor saving of over $1.9 million.
Updated and enhanced adapter and server of Translations Provisioning System (TPS), company's critical logic inventory database system. Reviewed detail data mapping design, added/modified multi-threaded, CORBA C++/IDL and database communication/transaction code. New release increased automation support of service orders for MCI Advantage Product and Time Warner network systems, which significantly reduced company's operating budget.
Created data synchronization of Siemens switches for TPS with near real time view of switch data. Designed and developed data mapping, remote transaction, and performance tuning. Implemented C++ classes, complex PL/SQL packages, stored procedures, triggers, and functions for large-scale data transactions. Project accomplished during very stressful time while losing company's reference sources and resulted in greatly reduced data discrepancy among company's several network inventory and equipment systems.
Designed and implemented Tuxedo Client/Server, Queues, multi-service communications, C++ classes, PL/SQL and Transact-SQL code. Setup Tuxedo developing and testing environment and domains configuration.
Designed, developed, and implemented tools for creation of PL/SQL stored procedures that greatly increased the quantity of code that could be produced. Project greatly reduced company's labor cost.
M.S. Degree in Computer Science/Minor in Electrical Engineering
University of North Texas, Denton, Texas 07/97
Scholarship from Department of Computer Science. GPA: 3.6/4.0
M.S. Degree in Physics/Minor in Electrical Engineering
Shanghai Jiao Tong University, Shanghai, China 02/87