Call Center Process Server

Summary

IT Professional with ** years’ experience providing IT solutions. Extensive experience in evaluating, implementing third party software, and developing cost effective custom solutions. Ability to manage multi-million-dollar software projects with responsibility for large technical teams with accountability for budgets, timelines, and project deliverables.

Key Accomplishments

Architected and Developed the Eye Experts Reporting System (TEERS) utilizing C#, .Net, and SQL Server Stored Procedures. This system augments NextGen’s EHR and PM modules to provide additional reporting needs for The Eye Experts.

Led SAP Human Capital Management implementation consolidating Human Resource Systems located around the world onto a central SAP instance - “On Time and Under Budget”.

Conceptualized and managed the development of PowerVision which consolidates Sales and Operations standard practices into a single application with the guiding principle of “Gather the data one time at the Source”. This application was developed using Oracle Forms and Reports. It uses Oracle’s Advanced Replication Services with over 40 connected database servers.

Architected and managed the development of Key Performance Indicator reports utilizing SAP Business Intelligence to collect information from multiple systems to measure productivity.

Staffed Application Teams to provide ongoing support and development for SAP and PowerVision.

Technologies

Languages: SQL (1996-Present), C# (2010-Present), C++ (1993-Present), C (1986-Present), SSRS (2012-Present), Progress (1990-2010), .Net (2010-Present), WPF/WCF (2010-Present)

Databases: Microsoft SQL Server 2008 thru 2019, Oracle Database (1996-2010)

Environments: Visual Studio (6.0 - VS 2019), SSMS (2008 R2 – Present)

Experience

ARS National Services; Houston, Texas Nov 2018 – Mar 2023

ARS is a proven leader in the accounts receivable management industry. Working with Customers in all 50 states, through 5 regional offices throughout the United States.

Sr. Applications Engineer

ARS uses a service with a web interface to execute all their daily processes. They can be scheduled or run manually. I enhanced the process server to add additional schedules (weekly) using C# and .Net.

Developed the process to import new clients (Toyota, American Express, and US Bank) using C#, .Net, and SQL Server stored procedures.

Modified processes that interfaced with LiveVox a contact and call center software using C# and .Net.

Created a process to wrap a pdf file inside an xml file for JP Morgan Chase using C#, .Net and Regex.

Created several processes to email Excel Spreadsheets to individuals using C# and .Net.

Modified several existing processes due to file layout changes using C#, .Net. I also modified the SQL Server stored procedures.

Created processes to load data into the data warehouse using C#, .Net, and SQL Server stored procedures.

Created processes to interface with positive pay using C# and .Net.

Modified SQL Server stored procedures using SQL Server Management Studio.

Provided App Support.

Alliant Keystone; Houston, Texas Nov 2010 – Nov 2018

Alliant Keystone is a provider of Information Technology Consulting services for the Oil and Gas industry, Healthcare Industry, Government Prime Contractors, and Government Agencies.

Senior Software Developer/Senior Database Developer

Senior Software Developer/Senior Database Developer for The Eye Experts Clinic. The Eye Clinic is an Ophthalmology practice with 3 offices and 6 doctors. They employee 66 people and have 100 Workstations. They are currently running NextGen’s EPM and EHR modules. I am in the process of developing The Eye Experts Reporting System (TEERS). The reports are created using C# Reports calling SQL Server stored procedures gathering data from the NextGen database. I perform SQL Server Database Administration and Performance Tuning. I also perform contract negotiations on behalf of The Eye Experts.

Designed, and developed a 3-tier application to create upload Distribution Check spreadsheets for BOLO’s ERP system for iEnergy Logistics. The system creates and outputs PDF and XLS exception reports for invalid data. It also creates the upload spreadsheets for the missing information that can be uploaded into BOLO. It produces exception reports to allow management by exception. The presentation layer was developed in WPF. The business layer was developed in C#. The database layer was developed in SQL Server. All database access and processing were developed utilizing SQL Stored procedures. This product is currently available as a Software as a Service. The Config Builder program listed below was incorporated into this program during one of the version updates.

Designed and developed a File Converter program that acts as a front end to the application listed above. It takes files in different formats and converts them to a standardized format using templates that are stored in SQL Server. The presentation layer was developed in WPF using the MVVM design pattern. The business layer was developed in C#. The database layer was developed in SQL Server. All database access and processing were developed utilizing SQL Stored procedures.

Designed and developed a Template Configuration Builder program that allows the user to build a template for the program listed above. The presentation layer was developed in WPF. The business layer was developed in C#. The database layer was developed in SQL Server. All database access and processing were developed utilizing SQL Stored procedures. This program was later discontinued as a standalone product and incorporated into the latest version of bullet item 2 above.

Developed Microsoft SQL Server stored procedures for an Oil and Gas Lease Program Database Application that utilizes Microsoft Access as the front end and SQL Server as the backend for iEnergy Logistics. Perform database performance tuning. Modify and maintain Microsoft Access VBA code for upgrades and maintenance. Develop C# .net programs that access the SQL Server backend to Extract, Transform and Load data into SQL Server.

Designed, and developed a 3-tier application to measure Payroll Performance Metrics and provide Gross to Net Reconciliation for SAP payroll systems. This system was designed for the Payroll Director at Rowan Drilling. The presentation layer and business layer were developed in C#. The database layer was developed in SQL Server. All database access was developed utilizing SQL Stored procedures.

Developed an application for Alliant Keystone to aid in development projects in C# that will read the schema of a SQL Server Database and generate the C# code for the Database layer and the Business layer of a 3-tier application. It builds the C# procedures for Inserting, Updating, Deleting and Truncating tables as well as Select procedures for the Primary Key, Foreign Keys and will return a complete C# List of all rows. In addition, it builds the SQL Stored Procedures that are utilized by the C# Database Layer. All the C# applications listed above have utilized this program to build their base code which reduced the development time by 75%.

Created an outsourced on-site system support desk to augment Petrohawk’s existing support desk system. The system support desk performed specialized services which included System Administration, Database Administration, Workflow administration, Oracle EBS application support and Enterprise Resource Planning (ERP) data conversion.

Created an outsourced on-site application development team to augment BHP Billiton’s existing application development team. The application development teams performed Extract, Transform and Load (ETL) data conversion services from existing Oracle EBS and SAP systems to an Oracle Business Intelligence Enterprise Edition data warehouse. The team members helped design and build the data warehouse. The team members worked alongside BHP Billiton employees to Design, Develop, and Implement OBIEE end user reports. The team also Designed, Developed, and Implemented SQL Server Reporting Services reports from legacy systems. Recruited highly skilled personnel to staff the on-site system support desk.

Cameron; Houston, Texas May 2010 – Nov 2010

Cameron is a leading provider of flow equipment products, systems, and services to worldwide oil, gas and process industries. Cameron generated $5.2 billion in revenue in 2009 with approximately 18,000 employees working together.

Enterprise Technical Lead

Conducted a detailed analysis of the current Human Resources, and Payroll business processes and practices.

Provided subject Matter expertise in global Human Resources and Payroll related best business processes and practices.

Identified and documented opportunities for business process improvement and enhanced utilization of SAP functionality.

Coordinated project activities with other business and technical teams to identify business process and SAP system integration requirements.

Identified, developed, and presented detailed future state business process transformation and SAP Human Resources/Payroll design and implementation strategies.

BJ Services; Houston, Texas Apr 1990 – May 2010

BJ Services Company is a leading worldwide provider of pressure pumping and oilfield services for the petroleum industry. BJ generated $4.1 billion in revenue in 2009 with approximately 16,000 employees working together.

Assistant Director of Applications Nov 2007 – May 2010

Managed 22 Permanent Employees and up to 46 simultaneous contract employees.

oManaged the PowerVision Application Development Manager located in our Tomball facility. This manager oversees 9 employees.

oManaged the SAP Human Capital Management Application Development Manager located in our corporate headquarters. This manager oversees 11 employees.

Responsible for $4.1M annual expense budget.

Managed ~$20M in Capital expenditures primarily for the SAP Implementation.

Responsible for the Software Development Life Cycle for SAP and PowerVision.

Responsible for approving Change requests for SAP and PowerVision.

Member of the Change Advisory Board to review all software changes.

Member of the Project Review Board which oversees all MIS Project Managers.

Maintained and developed new C/C++/C# programs to interface with PowerVision.

Projects and Key Accomplishments:

Purchased SAP's Human Capital Management System (ECC 6.0).

oLed SAP Human Capital Management implementation.

oImplemented the following SAP modules globally: Organization Management, Personnel Administration, Learning Solution, Portal, Netweaver, Employee Self Service, Manager Self Service, and Business Intelligence.

oImplemented the following SAP modules in the United States, Canada, Norway and the United Kingdom: Payroll, Benefits, Time Evaluation, and CATS.

oImplemented Kaba Benzig Time Clocks in the United States.

oArchitected and managed the development of Key Performance Indicator reports.

oRecruited and managed a team of 12 permanent SAP Software Developers.

oEvaluated and selected a team of 46 temporary SAP Software Consultants.

oApproved Project Plans, Risk Registers, Issue Logs, Change Requests, and Scope Changes.

oPerformed periodic updates to the Human Capital Management Guidance Committee and the Executive Guidance Committee.

Application Development Manager Dec 1992 – Nov 2007

Managed a staff of 10 permanent employees.

Responsible for $1.2M annual expense budget.

Managed ~$6M in Capital expenditures primarily for the development of PowerVision.

Responsible for the Software Development Lifecycle for PowerVision.

Developed Vendor Relations and performed Contract Negotiation.

Projects and Key Accomplishments:

Managed the Implementation of BMH's OPEN4 Human Resource System.

Conceptualized and managed the development of an application named PowerVision.

oElectronic Engineering Proposal System component named PowerPro.

oField Automation System component named PowerTrax.

oGeographical Information System component named PowerLink.

oStaffed a team of 7 Oracle Software Developers and 1 Database Administrator.

oEvaluated and selected a Third-party consulting firm to provide 18 consultants. Approved contractors, monitored progress, approved time sheets, and assigned tasks.

oEvaluated and selected Third Party development tools. PowerVision was built using Oracle Designer/2000, Oracle Forms 4.5, Oracle Reports 2.5, and Oracle RDBMS.

oPowerVision consists of 800+ Oracle databases with 3 Centralized Databases on an IBM I5, 40 Regional Databases on Mid-Range Servers, and 800+ Personal Oracle 9i databases running on Laptops under Windows XP. This System utilizes Oracle’s Advanced Replication Services for 41 n-way replication and 800+ 1-way replication using read only and updateable snapshots.

oRecruited and Managed 2 employees to staff a Technical Support Help Desk.

Designed, developed, implemented, and provided ongoing support for a Human Resource System to integrate with BMH’s OPEN4 Payroll System in Progress.

Implemented BMH's OPEN4 Payroll System.

Designed, developed, implemented, and provided ongoing support for a Fleet Maintenance System in Progress.

Designed, developed, implemented, and provided ongoing support a Field Reporting System in Progress.

Programmer/Analyst Apr 1990 – Dec 1992

Crane Company; Rogers, Arkansas Feb 1988 – Mar 1990

Programmer Analyst

Education:

Bachelor of Science, Data Processing Quantitative Analysis, University of Arkansas

Contact this candidate