Sr. Programmer/Analyst
Ellucian @ Ocean County College
Keywords
Microsoft SQL Servers
Software Engineering
Web Applications
Unix
Databases
Crystal Reports (Reporting Software)
Software Design Documents
Microsoft Visual Studio
Web Services
Web Interfaces
Skills
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
Project history
03/2014
-
08/2015
* 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.
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.
06/2008
-
02/2014
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.
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.
07/2006
-
05/2008
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.
* Developing and maintaining the Datatel Colleague System, Developing new applications/reports
and mainly provide the support to College Accounting Department and admission office.
04/2005
-
07/2006
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.
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.
05/2004
-
04/2005
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
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
05/2000
-
05/2004
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.
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.
Local Availability
Only available for remote work
