Post Job Free

Resume

Sign in

Analyst Sql Server

Location:
San Francisco, CA
Posted:
March 19, 2019

Contact this candidate

Resume:

James B. Yin

San Francisco, CA

415-***-****

ac8t80@r.postjobfree.com

OBJECTIVE

Software Engineer position

TECHNICAL PROFILE

JavaScript, TypeScript, C#, .NET, Angular, AngularJS, RESTful API, JSON, jQuery, HTML, XML, Microsoft SQL Server, Oracle Database, IIS, ASP.NET, NPM, Git, HL7 FHIR, SOAP, Salesforce.com, Azure EXPERIENCE

Senior Software Engineer (remote) 10/04 - Present

Surescripts, Inc., Minneapolis, MN & Hillsboro, OR Designed and developed various components and architecture of nation’s pharmacy health information exchange network which facilitates the electronic transmission of prescription information between physicians and pharmacists.

● Designed and programmed Specialty Pharmacy Onboard web application in Angular which facilitates questionnaire and answer response communication (RESTful FHIR JSON messages) between pharmacies and physicians to identify patient needs and qualification for specialized medication treatment

● Programmed and maintained the primary administrative ASP.NET MVC/WebForm website portal for physicians and pharmacists to view their exchange messages

● AJAX implementation with AngularJS, jQuery, jQuery UI, and JSON to enhance existing web site user experience

● Designed and implemented the members’ directory service and interface through both RESTful API and SOAP Web Services

● Part of the team that helped defining and implementing the standard XML message between physicians and pharmacists

● Implemented automatic Salesforce.com support case generation for internal and external support personnel through the administrative ASP.NET website

● Designed and implemented the translation between XML documents and PDF documents for automatic faxing delivery with XSLT & iText library

● Backend servers include Microsoft Windows Server IIS, Microsoft SQL Server, and Oracle Database Programmer Analyst / Contractor 7/04 - 10/04

Wells Fargo Bank, Concord, CA

Designed and developed Intranet ASP.NET consumer sales applications for bank branches across the nation.

● Designed and implemented various ASP.NET UserControls hosted within the main application framework

● Handled and parsed various XML messages transported among various service providers both internal and external of the enterprise

● Applied MVC (model-view-controller) architecture along with Visual Studio .NET to implement different tiers of the system

● Utilized several software design pattern such as Adaptor and Factory

● Implemented customized source code configuration tools to facilitate build and release process through the Visual Source Safe API

● All applications were implemented in ASP.NET, C#, HTML, and JavaScript

● Developed Microsoft SQL Server 2000 Transact-SQL stored procedures James B Yin

Page 1

Programmer Analyst / Contractor 2/04 - 7/04

Charles Schwab & Co., San Francisco, CA

Designed and developed Intranet ASP.NET applications as well as Windows Forms.NET decision support applications for the internal Securities Lending & Firms Management groups.

● Designed and implemented an ASP.NET message board application to facilitate internal communication for brokers

● Designed and implemented an ASP.NET application that keeps track of 3rd party firms relationships

● Applied MVC (model-view-controller) architecture along with Visual Studio .NET to implement different tiers of the system

● Designed and implemented a Windows Forms.NET desktop application to help Securities Lending group’s decision support issues

● Developed a Window Service component to access data through HTTP web request provided by NASDAQ as a background batch process

● All applications were implemented in ASP.NET, C#, HTML, and JavaScript

● Developed Oracle 9i objects including tables, sequencers, and triggers Technical Lead / Contractor 8/03 - 1/04

Gap, Inc., San Bruno, CA

Managed and architected client/server development projects for the finance and administrative areas of the enterprise.

● Documented detail design writings and architectural diagrams with PowerPoint, Word, Excel, and Visio

● Verbally communicated technical presentations to managers, directors, and architectural review board

● Worked closely with outside vendors, business partners, server engineers, QA engineers, and database administrators throughout the design, construction, and delivery phases of the projects

● Designed and implemented a Visual Basic program to automate a data transformation process through Excel VBA

● Project platforms included Windows 2000 Server, BEA WebLogic, Citrix MetaFrame XP Server, SQL Server 2000, C-Cure badge security system, and Oracle 9i

Programmer Analyst / Contractor 2/03 - 5/03

Visa USA, Inc., San Mateo, CA

Designed and developed Internet cross-browser web application, Commercial Card Data Repository, to support business users’ expense tracking, approval processing, and reporting.

● Designed and implemented data entry forms to gather user information with input error checking using JSP, DHTML, CSS

● Developed business object components with JavaBeans to encapsulate business processing rules

● Developed Form Beans, Value Objects, Data Access Objects to encapsulate the data access layers with JDBC API calls

● Developed Java Servlets as controllers to direct user and backend initiated actions to the appropriate components

● Project developed with WebSphere Application Developer (WSAD) and deployed to WebSphere Application Server

● Involved with converting SQL syntax from Sybase Adaptive Server to IBM DB2 Universal Server Programmer Analyst / Contractor 10/02 - 1/03

Barclays Global Investors, San Francisco, CA

Designed and developed Intranet web application to track and monitor firm’s Process Improvement Opportunity (PIO) and Operational Loss (OpLoss).

● Converted an aged CGI application to the new .NET environment

● Architected the new .NET system with Microsoft proposed best practices

● Project developed with Visual Studio .NET along with ASP.NET and Visual C#

● Application was targeted and deployed to Windows 2000 IIS

● Utilized the .NET complex web server controls such as DataList, DataGrid, and Validation controls

● Designed and improved database tables and models on Microsoft SQL Server 2000

● Designed and implemented Data Transformation Service (DTS) packages to load data from another Sybase system

● Designed and implemented stored procedures to encapsulate business logic and speed improvement

● Designed and re-implemented all static HTML pages with JavaScript, DHTML, and CSS

● Developed and improved user and executive reports with Excel and RTF formats James B Yin

Page 2

Programmer Analyst / Contractor 8/99 - 8/02

Charles Schwab & Co., San Francisco, CA

Designed, architected, and developed Intranet enterprise-wide mission critical J2EE server and Java desktop applications for customer application and document processing with automatic workflow management.

● Architected the new system from ground up with requirement from business group and enterprise-wide standards

● Drafted technical system design specification according to business requirements

● Designed and developed stateless session EJBs to encapsulate business logic and proprietary data access methods

(JSEntry) from mainframe

● Designed and implemented web application for system administration using JSP and Servlets

● Designed and implemented web report HTML pages by connecting to the backend Oracle database server

● Designed and developed Java Swing desktop client applications to interface with server EJBs through RMI/IIOP

● Utilized complex Swing components such as Table, Tab, and Tree controls

● Development tools involved: JBuilder, ANT, Visual SourceSafe, and Visual Café

● Developed applications targeted to BEA WebLogic and IBM WebSphere in the UNIX environment

● Designed and implemented XML data repository to store large sets of data cache on the client machines

● Utilized Microsoft XML DOM parser with XML data repository

● Improved existing ASP web system with more requirement additions

● Converted existing ASP system to J2EE environment to accommodate enterprise standards, user base demand, and additional business requirement

● Mentored and provided coding techniques and architectural designs with the in-house developers Programmer Analyst / Contractor 6/99 - 8/99

The SoftAd Group, Inc., Mill Valley, CA

Designed and developed the administrative and management web application for the e-commerce commercial product marketed by the company. The project involved extensive use of Internet Explorer, Microsoft XML parser object, Visual Basic, Visual InterDev, Visual SourceSafe, ActiveX COM+ component and controls development, DCOM, ActiveX Data Object, Remote Data Services, and Microsoft SQL Server in the Windows NT and 95/98 environment. Programmer Analyst / Contractor 4/99 - 6/99

Adauction.com, San Francisco, CA

Designed and developed Internet e-commerce web application for online bidding and auctioning of popular web-site advertising lots. The project involved extensive use of Internet Information Server, Active Server Pages, Microsoft Site Server with Commerce Edition (auction components), Java AWT applet, JavaScript, HTML, Visual Basic, Visual InterDev, Visual SourceSafe, ActiveX COM component development, ActiveX Data Object, Microsoft Transaction Server, stored procedure programming (Transact-SQL), and Microsoft SQL Server in the Windows NT environment. Programmer Analyst / Contractor 2/99 - 4/99

Multimedia Live, Petaluma, CA

Designed and developed Internet e-commerce web application for www.selfcare.com relating to inventory-control and on-line purchasing. The project involved extensive use of Internet Information Server, Active Server Pages, JavaScript, HTML, Windows Scripting Host, stored procedure programming (Transact-SQL), and MICROSOFT SQL Server in the Windows NT environment.

Programmer Analyst / Contractor 11/98 - 4/99

MarketTouch, Inc., San Francisco, CA

Designed and developed Windows web (Internet & Intranet) client-server (2-tier & 3-tier) tools for marketing sales automation. The projects involved extensive use of Internet Explorer programming, HTML, JavaScript, VBScript, Windows Scripting Host, Active Directory Service Interfaces, Internet Information Server, Active Server Pages, Visual InterDev, Microsoft Word VBA, stored procedure programming (Transact-SQL), Visual Basic, ActiveX COM component and controls development, ActiveX Data Object, VBA with Word, Remote Data Services, Microsoft Transaction Server, Microsoft SQL Server (Full-Text Search), and InstallShield in the Windows NT and 95/98 environment. James B Yin

Page 3

Programmer Analyst / Contractor 5/98 - 11/98

SelectTech, Inc., San Francisco, CA

Designed and developed Windows client-server (3-tier) applications to automate insurance application processing. The projects involved extensive use of Internet Explorer programming, HTML, Dynamic HTML, JavaScript, VBScript, Windows Scripting Host, Internet Information Server, Active Server Pages, Visual InterDev, stored procedure programming

(Transact-SQL), Visual Basic, Visual C++, ActiveX COM components and controls development, ActiveX Data Object (ADO), Microsoft Transaction Server, Microsoft SQL Server, Oracle, and Seagate Crystal Reports tools in the Windows NT and 95 environment.

Programmer Analyst / Contractor 2/98 - 5/98

Visa USA, Inc., Foster City, CA

Designed and developed Windows client-server (2-tier) applications to maintain and report statistical information about US merchants regarding sales transaction and volume. The projects involve extensive use of Visual Basic, Microsoft SQL Server, stored procedure programming, ActiveX components development, report generation with Seagate Crystal Reports Pro, OLE automation through VBA with Excel, Access, and PowerPoint applications in the Windows NT and 95 environments. Team Lead / Programmer Analyst 8/97 - 1/98

NationsBanc Montgomery Securities, San Francisco, CA Defined and deployed client-server (n-tier) application architecture for the client/server technology employed throughout the firm. Also supervised and lead team members for various infrastructure projects including code review, verification, and validation. The projects involved extensive use of web browsers, Java AWT applet, HTML, JavaScript, VBScript, Active Server Pages, stored procedure programming, Visual Basic, Visual InterDev, Visual C++, ActiveX components (including OCX), Microsoft Transaction Server, Microsoft SQL Server, and report generation tools in the Windows NT environment. Programmer Analyst / Contractor 9/96 - 8/97

Charles Schwab & Co., San Francisco, CA

Designed and developed Windows client-server (3-tier) intranet database front-end applications to provide the entry and navigation points for customer and account service functions on the retail desktops across the nation. The projects involved extensive use of Internet Explorer, HTML, Active Server Pages, VBScript, Visual Basic, Visual InterDev, Visual C++, OLE automation server/client programming, and reusable ActiveX component development (including OCX) in the Windows NT environment.

Programmer Analyst / Contractor 2/96 - 12/96

Pacific Gas & Electric Co., San Francisco, CA

Designed and developed Windows client-server (2-tier) applications to help power contract users to evaluate retail and wholesale electricity transactions. The projects involved extensive use of Visual Basic, ERWin (data modeling), Transact-SQL

(stored procedures), Crystal Reporter Writer, ODBC, Microsoft Access, Sybase SQL Server, and Microsoft SQL Server. Programmer Analyst / Contractor 11/95 - 2/96

Wells Fargo Bank, San Francisco, CA

Designed and developed Windows client-server (2-tier) database front-end applications to support online banking transactions generated from Internet web browsers, Microsoft Money, and Intuit Quicken. The projects involved extensive use of Visual Basic, ODBC, Informix Database Server, and Microsoft Access in both Windows and Windows 95 environments. Senior Programmer Analyst 12/94 - 11/95

Visa International Inc., Belmont, CA

Designed and developed Windows client-server (2-tier) applications to uniquely identify merchants from mainframe sales draft transactions. Merchants were identified through phonetic (fuzzy) searching, matching, and decision-support front-end tools. The projects involved extensive use of Visual Basic, Visual C++, ERWin (data modeling), Transact-SQL (stored procedures), WinHLLAPI, Crystal Reporter Writer, ODBC, Microsoft SQL Server, and Microsoft Access in both Windows for Workgroup and Windows NT environments.

James B Yin

Page 4

Programmer Analyst / Contractor 4/94 - 12/94

US Postal Service, San Mateo, CA

Designed and developed Windows client-server database front-end application to manage and arrange mail delivery routes in US. The project, AMS III (Address Management System), involved extensive use of Visual Basic, Microsoft Access, Crystal Report Writer, and custom control VBX’s.

Project Leader / Multimedia Programmer 11/92 - 4/94 CD Technology / MediAlive, Sunnyvale, CA

Designed and developed Windows multimedia CD-ROM software using Visual Basic and Visual C++. Also supervised and lead team members for various projects including code review, verification, and validation. Projects involved extensive use of custom control VBX and DLL’s, Microsoft Media Control Interface, Microsoft Video for Windows, Apple QuickTime for Windows, Microsoft Access, and Microsoft FoxPro for Windows. Programmer Analyst 9/91 - 11/92

Computer Curriculum Corporation, Sunnyvale, CA

Designed and developed educational and computer aided instructional (CAI) software on PC and Macintosh using the in-house authoring tools. Also wrote in-house C and C++ programs on both platforms. EDUCATION

California State University, Sacramento

Sacramento, California

● B.S., Computer Science

James B Yin

Page 5



Contact this candidate