07/24/2024 updated

ZY
100 % available

Senior Application Engineer, Workday Integration Specialist, Sr. Programmer/Analyst,

Land O Lakes, USA
Only remote
Master of Computer Science
Land O Lakes, USA
Only remote
Master of Computer Science

Profile attachments

JohnYi.resume.doc

Web InterfacesASP.NETC (Programming Language)HTMLJava (Programming Language).NET FrameworkComputer-Aided DesignADO.NETUnit TestingMicrosoft AzureBackup DevicesC Sharp (Programming Language)UnixC++ (Programming Language)Cloud ComputingSoftware DocumentationEncodingsInformation SystemsComputer ProgrammingDatabasesSAP Crystal ReportsData ManagementData MigrationData WarehousingSoftware Design DocumentsProgramming ToolsDOS (Disk Operating System)File TransferFoxProSync (Unix)Java AppletMachine LearningMicrosoft Visual StudioMicrosoft SQL ServersOpen Database ConnectivityPVCS Version ManagerQuality ManagementRegression TestingMicrosoft Power BIUser Defined FunctionsWorkday IntegrationsMicrosoft Visual SourceSafeSoftware EngineeringStored ProcedureSQL DatabasesSQL Server Reporting ServicesTransact-SQLWeb ApplicationsWeb ServicesExtensible Markup Language (XML)Extensible Stylesheet Language Transformations (XSLT)User ControlsConcurrencyBackendIntegration TestsVba Programming LanguageWorkday StudioIntegration FrameworksSearch EnginesOperational SystemsReporting ToolsEIBWorkday ReportingSoftware Version ControlWorkdayCode MigrationProgramming Languages
Microsoft .Net, ADO.NET, ASP.NET, Backend, data back, C, C#, C++, cloud, code migration, Programming, designing software, Concurrency, Crystal Report, crystal reports, DOS, Data Management System, Data Migration, Data Warehouse Environment, Database, databases, EIB, encoding, XML, XSLT, File Transfer, Foxpro, HTML, Information System, Information Technology, COMPUTER SERVICES, Computer Science, integration design, Integration Testing, Java, Java Applet, ML, Microsoft Access, Azure DevOps, SQL server, Microsoft SQL Server 2000, Microsoft SQL Server, Visual Source Safe, Visual Studio.NET, Visual Studio, Windows, ODBC, Operating Systems, PVCS, Power Bi, Programming Languages, Development tools, Regression Testing, SQL, SSRS, stored procedures, search engine, design documents, design document, user documentation, application development, software development, Software Design, Version Control Systems, sync, Reporting tools, T-SQL, unit tests, Unix Environment, Unix, User controls, User Defined Functions, Visual Basic, Web-based, Web applications, Web Application, web interfaces, Webservices, Web Services, Workday, Workday integration, workday reporting, Workday Studio

Experience

Professional experience10+ years
Freelancer since2024

Languages

EnglishFluent

Project history

Sr. Programmer/Analyst

Ellucian @ Ocean County College
* Developing and maintaining the Ellucian Colleague System, Developing new applications and
customizing of existing process using Colleague Studio
* Mainly provide the support to College Continuing and Professional Education (CPE) Department
and HR Payroll department.
* Developing CPE Instant Enrollment Webadvisor Applications
* Developing Budget Transfers Through Webadvisor
* Developing NJ State Health Insurance Deduction Automation
* Creating SSRS/Informer reports and dashboards
* Administrator of ImageNow system, creating workflow, eForm, installing ImageNow client,
setting up user access and security.
* Working on Unidata to SQL migration project, assist with Data Migration, Reports and custom
code migration.

Quality Assurance Manager

Guangzhou Enjoy Information Technology CO.,LTD
Involved in creating and maintaining test plans for the retail management software system.
Involved in preparation of Test Cases and executed Test Cases.
Defect Tracking using PVCS
Involved in Functional, System, Integration, Database/Backend, Positive, Negative, Build
Verification, User Acceptance, Regression Testing.

Programmer/Analyst

Austin Community College
* Working on Datatel R18 Migration Project
* Developing and maintaining the Datatel Colleague System, Developing new applications/reports
and mainly provide the support to College Accounting Department and admission office.

Application Developer/Tester

Laureate Education Inc.
* Developing and maintaining the Datatel Colleague Student System included customization of
existing process, developing and designing new processes using Envision Took Kit Programming,
Unibasic and Uniquery. The process included Screen Process, Batch/Report process, Subroutines
and Uniquery Paragraph. Participated in the development of Web-based PSP - Students online
system on Microsoft .Net development platform, using ASP.NET, ADO.NET, C#, and SQL Sever 2000
in Window Environment. Creating unit tests, testing the application. Main projects includes:
1. Developed the Walden University Transcripts (for Registrar office)
2. Developed/maintain the Read/Update Wrappers (Envision code) that work with ASP.NET Web
applications, the read wrapper retrieves the data from Colleague return as XML format
outputs. The outputs will be used by ASP.NET Web Application and sync the Data in SQL server
DB. The update wrapper writes the data back to Colleague from Web Application.
1. Using ELF process to import the data that created in PSP (Web Application) side into
Colleague.
2. Developed Online Billing processes that send the student AR information to FA provider (for
Bursar Office).
3. Developed Suspension report for the collection department.
4. Developed Application reports For Admission office.
5. Developed/maintain the student list severs for all Academic departments/schools.

NET Web Application developer/Tester

Aerotek Engineering, Inc.
Participated in the development of Web-based Construction Quality Assurance Information Delivery
System for Austin SH 130 TURNPIKE PROJECT and Web-based Commercial Electronic Engineering Data
Management System on Microsoft .Net development platform, using ASP.NET, ADO.NET, C#, Crystal Report
and SQL Sever 2000 in Window Environment. Advanced functionality included data records
creation/update/deletion, Concurrency handling, data records check-in/out, departmental access
control, grained user access control, various reports and search engine functions
* Gathering/Analysis user requirements
* Creating ASP.NET web interfaces (forms) and User controls
* Writing server side code(C#) and client side script
* Designing/Creating database table, stored procedures, User Defined Functions, triggers, and
view in Microsoft SQL Server 2000
* Developing data-access layer using ADO.NET
* Creating crystal reports
* Developing unit tests, testing the application
* Performing Functional, System, Integration Testing

Programmer/Analyst

AFFILIATED COMPUTER SERVICES (ACS); State and Local Solutions Group
Participated in the development of North Carolina Community College Administrative Information
System using Datatel's ADE tool-Envision, Webadvisor, Unibasic, Uniquery,Java, IBM UniData nested
Relational (non-FNF) Database in Unix Environment.
* Gathering all necessary information about the complex custom tasks, needs, objectives,
functions, features, and input and output requirements by working with Clients, team members,
* Full life cycle software development, Software Design, Coding screen layouts, processes,
subroutines, printed outputs.
* Develop the required applications, interfaces and conversions and reports using Envision, ELF,
Webadvisor and Unibasic.
* Develop and maintain enhancements and corresponding databases by evaluating client needs;
analyzing requirements and change requests; designing software systems; creating high level
and detail design documents.
* Program the enhancement by using Envision, ELF, Unibasic and Webadvisor to encoding the
enhancement's requirements as described in the corresponding detail design document.
* Confirm program operation by designing and conducting tests; modifying program sequence and/or
codes.
* Developed custom transcripts. (ST)
* Developed Undergraduate Transfer Students Report(ST)
* Developed NC Higher Education Data (NCHED) A-10 Student Financial Aid Summary Report
* Customized HUB Report (CF)
* Convert the data from legacy system to Colleague by using ELF or Envision Batch process
(Demographic conversion, Vendor Conversion, Student Course/Academic credit conversion, HRPER
conversion, PAYTODAT Conversion...)
* Customized FTP subroutine and added Secure File Transfer function.
* Developed new Fire Certification/Regional Calendaring Enhancements with Webadvisor screens
(ST)
* Provide reference for use of the enhancement by writing and maintaining user documentation;
providing second level help desk support.
* Prepare clients to use system and software by conducting training sessions.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in