SUMMARY:

• Highly skilled software engineer bringing 20 years of experience in full life cycle of enterprise software development. Excellent communication skills. Advanced knowledge in C++, C#, XML and SQL on Microsoft SQL server.

TECHNICAL SKILLS:

• Excellent coding skills. Creative problem solving. Ability to design for robustness, longevity, and extensibility across releases.
• Advanced knowledge in Client/Server application using C++.
• Advanced knowledge in database design, SQL, TSQL using Microsoft SQL Server.
• Extensive experience in C# and .Net Framework.
• Cloud Computing, REST API of Google Drive, OneDrive API, Outlook, MAPI etc.
• XML, HTML, CSS, NAWK
• Troubleshooting and Performance Optimization for both client/server applications and query scripts.

PROFESSIONAL EXPERIENCE:

Confidential, Tinton Fall, New Jersey

Principal Member of Technical Staff

• Maintained and improved multiple back - end services and features that manage critical data with heavy traffic accessing databases in multi-threaded environment, including but not limited to Auxiliary Copy Manager, Media Manager, Archive Manager, Vault Tracker, Disaster Recovery and Qscripts using C++, STL, SQL and XML extensively.
• Maintained utilities written in C# and .NET framework to migrate files from Google Drive, Microsoft OneDrive personal account and Outlook Email to CommVault Cloud. Added support to migrate files from work or school account using OneDrive for Business (Office 365).
• Supported and enhanced operations that collect system information and application logs from server on Windows, clients and media agents on multi-platforms, including Linux, Unix and Windows.
• Enhanced performance and functionalities on multiple HTML reports generated in C++ code running database queries. Fixed a critical customer issue on a report that could not be identified by other developers for months and required servers to be rebooted daily due to memory leak.
• Designed XML protocols for GUI to communicate with GUI server.
• Modified existing code to improve performance. Cleaned and rewrote code with minimum regression impact. Excised good coding practice by adding missing comments, reducing duplicated code, etc. Fixed many issues caused by bad coding practices.
• Analyzed user needs and software requirements to determine feasibility of new features. Wrote design documents, then designed and implemented them within time and cost constraints. Features were all thoroughly tested before being moved to QA team.
• Maintained wonderful relationship with QA team. Worked closely with testers and technical writers to ensure proper testing and documentation on features.
• Developed data models for many applications using metadata tables, views or related database structures on Microsoft SQL Server.
• Provided technical support to clients, conducted peer code review and mentored junior developers.
• Performed trouble shooting on customer issues, provided workarounds or patches on customer issues.

Confidential, Tinton Fall, New Jersey

Principal Member of Technical Staff

• Solely designed and developed Dynamic Stream Allocation (DSA) for offline read operations. Relational database design and complex queries are used on Microsoft SQL Server. This feature allows data on disks to be distributed evenly to multiple pseudo streams in parallel for all operations that read data from disk, such as Auxiliary Copy job, Data Verification job, Synthetic Full backups, Content Indexing job, Deduplication Database (DDB) Reconstruction, etc. Performance is improved significantly using DSA comparing with fixed stream allocation.
• Developed multiple utilities with GUI to migrate data from Google Drive and OneDrive to CommVault Cloud using C#, .Net Framework, Google Drive REST API, OneDrive API and OAuth 2.0 authentication. Developed an Outlook addin to migrate email attachments to CommVault Cloud using C#, .Net Framework, Outlook MAPI, HTML, CSS and CommVault REST API.
• Performed revision, repair, or expansion of existing programs written in C++ to increase operating efficiency or adapt to new requirements for multiple services that manipulating critical enterprise data.
• Designed and implemented QScript utility to allow user to execute stored procedures directly through simple commands.
• Main developer for security checking on multiple services and GUI operations.
• Conducted performance tuning on services and operations related to Media Manager and Auxiliary Copy.
• Troubleshooted customer issues and provided fixed or workarounds.
• Performed code reviewing for peer developers.

Confidential, Tinton Fall, New Jersey

Senior Software Engineer

• Designed and implemented back end databases including tables, views and stored procedures on Microsoft SQL server for Snapshot Backup and Recovery.
• Implemented the communication protocols and interface APIs in C++ for clients and Media Agents to communicate with all services on server during Snapshot Backup and Recovery.
• Worked closely with GUI developer and testers to define communication protocols and provide commands and backend GUI server support for multiple services and features, including Archive Manager, Media Manager, Vault Tracker, Disaster Recovery, etc.
• Maintained and improved Disaster Recovery feature to backup and restore multiple server databases on Microsoft SQL Server.
• Designed and implemented both client and server code to collect system information and application logs and backed them up as part of Disaster Recovery job. Client code is run on multiple platforms, including UNIX, Linux and Windows OS.
• Maintained and improved Vault Tracker feature to track media location, set media container, send export request, handle media import, and report media due back.
• Troubleshooted database issues for customer. Fixed database corruptions.
• Supported database upgrade for tables used by multiple services.

Confidential, Tinton Fall, New Jersey

Software Engineer

• Designed new algorithms for Data Aging Job to prune data generated by CommVault Enterprise Backup and Recovery software. Improved performance from days to hours. Increased media reuse rate and reduced media to be kept for backup data significantly. Earned patents on one of the algorithm that is still used today.
• Solely designed and developed CommCell Migration utility to migrate clients cross CommCell servers using relation database design and implementation. This allows data produced from one server to be used from another server. It improved the flexibility and usability of the software. The same utility was later expanded but still using the same framework.
• Designed and implemented many Archive Manager APIs to be called by GUI to browse backup data and by Job Manager to get the right data for recovery.
• Designed database upgrade framework and implemented generic database upgrade scripts to be called by upgrade utility.
• Maintained NAWK, GAWK scripts as part of MAKE file to parse input files and produce SQL executable query files for table, view, function, trigger and stored procedures.

Confidential, Tinton Fall, New Jersey

Automation Developer

• Designed and developed automated testing scripts using WinRunner.
• Updated automated test scripts to ensure currency.
• Wrote test cases and documents on how to run the test scripts.
• Executed test cases and wrote modification requests on bugs detected.

Confidential, Herndon, Virginia

Software Engineer

• Designed test plans, scenarios, scripts, or procedures.
• Implemented automated testing tools for C-Tree database and customer APIs using Visual Basic and .Net Framework.
• Performed installation, configuration, testing of hardware and software on multiple platforms.
• Provided technical support during software installation or configuration.

Confidential

Architect

• Completed architectural designs for both residential and commercial buildings based on functional requirements, budgets and customer preferences.
• Draw rough and detailed scale plans for foundations, buildings and structures, based on preliminary concepts, sketches, engineering calculations, specification sheets and other data.
• Prepare colored drawings of exterior and interior designs for presentation to client.