- Performed the day to day processing of accounts payable transactions to ensure that company finances are maintained in an effective, up to date and accurate manner
- Verified and confirmed receipt of material or services
- Checked accuracy of employee reimbursement expenses before processing
- Prepared and entered invoices in accounting system for payments ensuring correct approval, coding and matching
- Coordinated with vendors regarding invoicing and payment inquiries and discrepancies
- Responded to vendors inquiries in a timely and professional manner
- Processed cheques run and set up on-line payment batches for the accounting team
- Ensured compliance to Company policies and procedures
- Tools Utilized were Microsoft Office Excel, Word, Outlook, Oracle Peoplesoft Financials and HRMs System on Windows NT 4.0, and Windows 7.
|
- Operated in environment with Microsoft SQL Server 6.5/2000/2005, SQL Server Enterprise Manager, SQL Server Management Studio, Microsoft Transact SQL T-SQL , JDBC, ODBC on Linux, Windows NT 4.0 operating system, and Windows Servers NT 4.0/2000/2003
- Maintained Object to Relational O/R Mapping framework for mapping between Database Schema and EDFUND Core business object model
- Conferred with co-workers to determine impact of database changes and provided level of effort estimates to manager for making changes to database for all project efforts
- Created ad-hoc queries for users and generated required monthly reports for the manager in a timely manner
- Created and modified stored procedures as data sources for application and reports.
- Developed ETL with DTS packages to capture and transform data from transactional databases.
- Designed and executed database backup and recovery procedures including disaster recovery
- Tested, corrected errors, and refined changes to optimize database performance
- Performed database tuning to increase processing performance, and closely monitors usage, storage space, and other influences on database performance
- Designed logical and physical databases and/or reviewed description of changes to database design to understand how changes affect the physical database
- Responsible for developing, maintaining internal relational database instances for development and test environments
- Responsible for developing internet applications for the student loan industry
- Created ColdFusion pages using FuseBox MVC framework
- Implemented interface between EDFUND and an outside business partner for providing electronic signatures E-sign of EDFUND promissory notes utilizing Java 1.3-5.0, ColdFusion MX 6, CSS, JavaScript, JDBC, ODBC, Java Web Server, iPlanet, JBoss on Linux, Windows NT 4.0 operating system and Windows NT 4.0/2000 Servers
- Implemented complex business logic within stored procedures using ANSI SQL and T-SQL within Stored Procedures, functions for loan tracking system and custom and ad hoc reports with , Microsoft Transact SQL T-SQL on Microsoft SQL Server 6/6.5/7/2000
- Worked with the Business Systems Analyst go developed detailed business requirements for internet applications and EDFUND loan delivery web products
- Maintained business rules based service using Blaze Advisor for web applications with Java 1.3-5.0
- Maintained software and reports in Response to changes in federal regulations
- Met the needs of internal and external customers who used EDFUND's loan delivery systems
- Operated in environment with Microsoft SQL Server 6/6.5/7/2000, Microsoft Transact SQL T-SQL , SQL Server Enterprise Manager, Java 1.3-5.0, ColdFusion MX, CSS, JavaScript, JDBC, ODBC, Java Web Server, iPlanet, JBoss on Linux, Windows NT 4.0 operating system and Windows NT 4.0/2000 Servers
- Researched and investigated problems and developed solutions reported findings/recommendations clearly and effectively to team
- Provided technical input for creation of policies, procedures, and associated documentation
- Worked with the Business Systems Analyst and Documentation Management Specialist to record all routine procedures and update appropriate documentation as needed
- Provided day-to-day technical and functional expertise for all applications supported
- Assisted System Administrators with daily support requests when needed
|
- Responsible for maintaining legacy Web Based student loan tracking system
- Enhanced and maintained proprietary tag language pre. jsp1.0 using Servlet technology
- Maintained customized and ad hoc reporting application s for external customers and management
- Implemented complex business logic within stored procedures using ANSI SQL and T-SQL within Stored Procedures, functions for loan tracking system and custom and ad hoc reports
- Worked with business analysts to evaluate end-user requests for application modifications
- Operated in environment with Microsoft SQL Server 6/6.5/7/2000, Microsoft Transact SQL T-SQL , SQL Server Enterprise Manager, Java 1.2/1.3, JavaScript, JDBC, ODBC, Java Web Server on Linux, Windows NT 4.0 operating system and Windows NT 4.0/2000 server
|