Post Job Free

Resume

Sign in

Media Services Sql Server

Location:
Issaquah, WA
Posted:
January 10, 2024

Contact this candidate

Resume:

Zhang, Jinlin

ad2myl@r.postjobfree.com

Summary of Qualifications

•Experience of working in large environments such as Microsoft, JPMorgan Chase Bank.

•Years of work experience in designing and developing enterprise applications in a distributed and Client/Server environment.

•Solid knowledge of Java, JUnit, C++, C, Python, C#, Spring / Spring Boot framework, JSP, JavaScript, VBScript, HTML, CSS, REST Web services, Unix/Linux shell programming, Oracle databases, SQL Server and MySQL.

•Excellent problem solving and debugging skills.

•Successfully completed system integration and performance tuning for major applications.

•Microsoft Azure Media Services experience.

•4 years’ work experience on opensource projects.

PROFESSIONAL EXPERIENCE:

02/2021 to present

Senior SDE

OpenTeams Inc. @Meta

Presto is a distributed SQL query engine that enables querying large data sets distributed over one or more heterogeneous data sources. I am proud to be one of the developers in OpenTeams responsible for developing and maintaining this great opensource project. In the past 2 years, I have authored/co-authored over 140 pull requests using Java. That makes me one of the top contributors in Presto community recognized by OpenTeams.

Additionally, I have also developed a Presto automation project called Presto-bot using Node.js JavaScript and PostgreSQL. The bot is running on Heroku and serves the Presto community.

10/21/2019 to 11/2020

Senior SDE

Digital Intelligence Systems, LLC @Meta

I joined the Meta Buck team and worked as the main maintainer and developer of the open-source Buck project. My responsibilities included debugging and solving issues, reviewing pull requests, and publishing documentation and releases. As part of service improvement, I fully automated the process of creating releases on all three platforms (MacOS, Linux, and Windows) using Java, Python, Docker, YAML, and shell scripts on CircleCI.

05/10/2019 to 10/2019

Senior SDE

Hi-Tech Talents, Bellevue, WA

As a contractor with Microsoft Azure Media Services (AMS) team, I’ve worked on the following projects:

•Media Services SDK samples – Authored a total of 26 Java and .Net samples, some of my work can be found at https://github.com/Azure-Samples/media-services-v3-java and https://github.com/Azure-Samples/media-services-v3-dotnet.

•Azure AMS CLI commands – bug fixes and tests.

•Media Services Java and .Net SDK – Maintain and develop, including bug fixes and customer support.

06/2014 to 05/10/2019

Senior SDE

MediaNet, Seattle, WA

As a senior software developer, my responsibilities include working with content operations and customers to maintain and add new features to a wide variety of projects and systems.

•Ingestion Server (primary support) – Since taking over ownership in December 2014, I had been working as a lead developer on the Ingestion project. This project downloads music files as well as their metadata and resources from publishers, ingests and packages them into production catalog. It also provides REST web services to Ingestion Services and Ingestion Client. Technologies such as Java, Spring, PL/SQL, and Ibatis are used in this system.

•Ingestion Services (primary support) – I’ve owned the system since Dec. 2014. This is an internal web application used for managing Ingestion Servers. Pages are coded in JSP and CSS, JS is used to call REST services to communicate with Ingestion Servers.

•Ingestion Client (primary support) – This is a frontend UI application that consumes REST web services from Ingestion Server and provides editing, promoting etc. functionalities to content operations for managing music products within internal catalog. Coded in C#.

•Preload Utilities (original author) – This includes a total more than 60 utilities coded in Linux AWK, shell script and PL/SQL script. These utilities are used to parse various non-xml formatted publisher feed files and load into Right Management database.

•Xml2Db (primary support) – Coded in Java, this application is a standalone tool that helps customers to convert and upload our XML metadata into their MYSQL or Oracle database.

•Reporting Tool (original author) – Coded in shell script, this tool is used to parse production logs and generate monthly Excel reports for Platform operations.

•Platform (secondary support) –This is a WildFly (formerly JBoss AppServer) web application coded in Java. It provides customers with web services like product discovering, searching, account managing, and download token generating.

•Supernode (secondary support) – Coded in Perl and C++ on HTTPD, the system cooperates with CDN (Content Delivery Network) for music downloading services.

•PublishCtrl (secondary support) – Coded in Java and PL/SQL, it extracts data from catalog database and generates XML and CWR (a music industry format) files for publishers.

•Song Matching tool (secondary support) – Coded in PL/SQL, it uses customer’s incomplete information as input, match against production catalog and returns a full set of metadata of music works.

09/2012 to 06/2014

SDE II

Microsoft, Redmond, WA

•Worked as a software developer on SQL Server components SMO (SQL Server Management Objects), DQS (Data Quality Service), Extended Events and MDS (Master data Service). My responsibility is to work with Customer Service to solve product related problems, investigate RFCs (Request for Change), fix bugs, and signoff test runs to guarantee quality level of SQL Server products.

•Formed a v-team with 3 other volunteers to maintain and support the SQL release tool. Successfully prepared and transitioned the tool from Source Depot to Microsoft TFS (Team Foundation Server).

05/2006 to 08/2012

Software Developer/Architect

JPMorgan Chase, Columbus, OH

•Led a team of 6 to re-design the eATM system. All major function modules have been redesigned and rewritten using Java technology. Annotation and annotation processing technology is widely used to generate boilerplate bridge code to communicate with third party packages and frameworks. The project was successful and released in early 2012.

•Led a team of 3 to design and develop Mixed Deposit. This project added new functionality to ATMs which allow customers to deposit cash and check at the same time in one transaction. Released in 2011.

•Designed software architecture and workflow for the Deposit Automation (allow customers to deposit cash or checks on an ATM) project. Coded most parts of the software. Acted as a lead in the system integration.

•Played a key role in the third party software consolidation and integration project. The eATM used to have many third party software components. To lower the maintenance and development cost, we consolidated our system and reduced the number of third parties we deal with. Several previous third party components were rewritten by the team members. I was responsible for the logging sub-system which replaced the IBM counterpart.

•Provided production support and maintenance.

EDUCATION

•M.S. Computer Applications, Peking University, China.

•B.S. Computer Software, Peking University, China.

REFERENCES:

Available upon request



Contact this candidate