Stephen Christensen

Systems Analyst

Geisinger Commonwealth School of Medicine•  May 2014 - Present

• Design and Implement improved integrated systems across multiple back-end database/servers. Upgrading current systems from Client Desktop Singles Production Server Platforms to Multi-Secured App/Web/Terminal Servers, Production Server, & Staging Server Platforms. • Provide technical support to Finance/ Accounting, Admissions, Financial Aid, Student/Faculty Affairs, and Human Resource Division's administrative systems (ERP, Jaspersoft BI Application, Microsoft Dynamics GP, Jaspersoft Reporting/JasperServer, Empower SIS, AMP/AMCAS, and Microsoft Dynamics GP Self-Service Portal. • Responsible for programming, developing, creating database schemas and workflow processes, upgrading, documenting, and supporting a variety of systems and applications in the ERP environment for both web & desktop application software. • Utilize ticket system in order to process and complete business units’ requests for reporting, finance/accounting analysis, database construction/analysis, web application development, and technical support. • Conduct research, evaluate and implement software and system solutions, and coordinate upgrades to existing systems. Conduct Software Price/Contract Negotiations, Complete Purchase Orders, and finalize Contract Agreements. • Programming Domains, Analyzing and Designing database solutions/workflows, and Delivering Dynamic Financial Dashboard/Reporting Solutions to CFO, Controller, Finance/Accounting, HRM, Admissions, Student/Faculty Affairs, Financial Aid, and Registrar Divisions throughout the Medical College. • Monitoring, Analyzing, and Programming SQL/VB scripts for Front-End Application Processes, Database Maintenance/Troubleshooting/Data Validation, and Reporting System Processes, Dashboard Reporting, and Audit Trails. • Organizing/Facilitating monthly Meetings for both Student Information Systems & Accounting/Finance Software User Groups for: Product Updates, End User Issues/Concerns, Full-Cycle Impact Overview, and Data Integrity/Reporting.

Application Developer

Qik Entry Apps•  July 2011 - December 2016

• Assist businesses with website development. • Developed Software Applications to streamline end to end data collection and reporting processes. • Performed Sales Pipeline Analysis and developed a database and reporting system to create sales pipeline transparency across the organization. This increased sales and greatly reduced missed sales opportunities, by providing on-demand reporting to the frontline sales teams. • Developed a mobile database and reporting system for energy audits, which provided onsite data modeling and reporting for client use. This system reduced labor hours by 50% and increased productivity by 100%. • Assist businesses with basic business development in areas of marketing, finances, and product merchandising. • Clients include: - Reynolds Construction Management - Resource Collaborative, LLC - Stadt House Bakery - BNT Movers, LLC

Operational Report Analyst II

TMG Health•  September 2012 - May 2014

• Deliver Reporting Solutions throughout the company. • SQL and VB Script to Automate Database Extraction & Reporting Processes for the BPO business model. • Operational Reporting Analyst Lead for multi-million dollar enterprise-wide project. In this role, I was responsible for creating and maintaining databases and applications to track and sustain the development of the new centralized database platform for the new SAAS model. Also, I was acting Liaison between ETL Developers and Business Units to provide backup support, due to shortfall in System Analysts. • Developed CR "Change Request" Tracking System through SQL SSMS to provide executive-level and senior level management with ability to analyze and improve the CR process currently in place. The CR Tracking System provided business analysts with real-time tracking of their CRs and reduced labor hours.

IT Systems Analyst

First National Community Bank•  July 2009 - July 2011

• Provided technical support to all end-users and acted as liaison between the bank and software companies. • Acting DBA responsible for data mart mapping, sql extraction, & financial software to create reports for executive, administrative, and branch-level management. • Led a project to review and reorganize the client relationship management system to improve account management and greatly improve banking compliance. • Implemented new data warehouse processes to increase accuracy in data extraction, efficiency in data analysis, and reporting processes, which led to improving the balance of deposit/loan growth. • Performed auditing on both Deposit Reviews and Loan Reviews for quarterly and annual statements.