Providing technical and professional level expertise using various programming tools in supporting, documenting, and monitoring applications for a routine to complex Student Accounts processes and reports.Applying systems analytical expertise to assist Student Accounts staff with processing functions that facilitate their assigned areas of responsibility, including ad hoc reports; Banner job processing, queries and population selections utilized in mailings; student billings; and other activities.Evaluates end-user request for new or modified reports, provides support for integrated relational database applications and converts project specifications into logical computer codes or processes to databases.Performs routine to complex data analysis and data reporting with various programming tools, such as Argos, Crystal, Structured Language (SQL)/Procedural Language Structured Query Language (PL/SQL).Reviews, updates, and edits reports and data extracts, test documents and performs quality assurance on generated reports.Participates in project teams and serve as a technical liaison to facilitate other systems-related activities including serving on the Key Dependency and Data Quality teams; serving on project teams to assist with ongoing production jobs (e.g., student billing, sponsored billing, 1098T processing. Insurance processing, fee assessment, drop for non-payment, refunds, and other CORN production jobs); and collaborating with Production Calendar Group members to organize/coordinate Banner AR processes that merge timelines of production jobs with operations conducted by the Registration, Financial Aid, and Business Services offices.

Developed daily servers’ health check list, failover procedures to verify all the web portals are accessible for all carriers, designed SQL queries to perform account inquiries, verifying billing logs using SQL Server Management, SQL jobs on Servers and designed resolution methods in case of SQL job(s) failure, FTP transfer logs, dispatcher logs, connect Multi-protocol Label Switching (MPLS) routers to verify connectivity, verifying log shipping to the secondary servers. Monitor production job schedule with SQL Server Job Agent, check database mirroring (Mirror, Synchronized / Restoring) and restoring server statusInvolved in 1) creating database objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions, 2) developing SQL scripts for maintaining administration tasks, 3) implementing standby servers and Log shipping, 4) developing stored queries & procedures; and 5) maintaining all relevant SQL documents.Develop a sustained operational process and system to report routine tasks to management. Assist in the implementation of approved changes.Provide Customer & System support for Transaction Service Provider using Web Browser based applications, and Microsoft SQL Server Database.Involved in QA testing and creating ad hoc reports.Routine verification tasks: Plan server migrations, determine server traffic, SQL jobs, Mirroring, database accessibility and restoration, and ticketing services on all servers. Routine monitoring tasks: DNS failover for maintenance, enable/disable Monitoring Notification on DNS, edit IP addresses based on active DMZ servers.Monitor all production and demilitarized zone servers in two geographic locations with Remote Server Administration Tools to provision and manage remote Windows based servers from the desktop without requiring either physical access to the servers.

Daily incident and problem management process to restore normal operations as quickly as possible and minimize any adverse effect on business operations. Continuously look for improvements in daily workflows for servicing customer accounts and managing daily tasks. Develop a sustained operational process and system to report routine tasks to management. Assist in the implementation of approved changes. Maintained and configured POS system for the sales associates. Verified systems to ensure smooth operations and generated required reports daily. Recognized by staff for coaching/mentoring and training assistance, as well as successfully delivering results against financial/operational and compliance objectives

Maintained Window Server 2000, database backup, and daily reports.Assist in gathering audit items to demonstrate payment processes is PCI compliant.Reconfigured existing network for new employees. Responsible for service design & delivery systems, processes, and compliance tracking for nation-wide operations; manage staff of 6 team leads.Identified and awarded “star contributor” status within first 7 months of joining the company.

Facilitate close working relationship between external clients and IT / Software Development groupConsult and coordinate the purchase of hardware, software, and installation of systems for small business clients. Resolved complex customer service disputes in highly charged emotional situations. Provided support for new projects and ongoing support for existing projects ensuring IT Service Levels are achieved for all metrics, ensuring consistent high performances. Designed a retailer display that increased product placements and resulted in 10% annual sales growth. Supervised and trained new associates as a team leader.