To help people meet their computing needs by designing, maintaining, and coding the most reliable and secure programs feasible and training them to use it.
11900 NE 18th St Apt 561
Vancouver, WA 98684-5111
Phone: 360-891-8439
Email: joe@josephdwagner.info
Download this resume in:
• Microsoft Word format
• Plain Text format
To help people meet their computing needs by designing, maintaining, and coding the most reliable and secure programs feasible and training them to use it.
ASP, ADO, C/C++, C#, COBOL, HTML, JavaScript, Java, Java Servlets, JSP, JDBC, .NET Framework, SQL, Visual Basic
Microsoft Windows 95, NT, 98, 2000, ME, XP, Vista, 7;
Red Hat Linux & Fedora.
Billing Systems: CSG, ICOMS, CBP, iCommVergence.
Data Reporting: CA Forest & Trees; Toad for Data Analysts
GNU: awk; gcc; sed.
Microsoft: Office 97-2010; Visual Studio 97-2010.
SQL: Microsoft SQL Server 2000-2008; Oracle Client.
Business Intelligence Developer -- I analyze real-world data problems and develop practical solutions. My tasks include:
Analysis & Documentation: I analyze and document the internal workings of datasets, including the upstream processes which generate the data, the effect of the results on downstream processes, and edge-case scenarios which produce unexpected information.
Process Improvement & Automation: I review existing processes, and I design and develop solutions to improve their efficiency and accuracy, which often includes automation. Tools used to develop these solutions include Crystal Reports, Windows PowerShell, Excel macros, Access databases with forms, and data marts in Microsoft SQL Server.
Reporting: I develop, maintain, and run a number of reports and reporting systems centered on billing and finance. These range from aesthetic overviews for executives (using Crystal Reports) to self-help data marts for proficient users to comb through large data sets (using Microsoft SQL Server).
Business Reporting Developer* -- I transform data with the aim of extracting useful information and facilitating conclusions. My tasks include:
SQL Queries:I write SQL queries to pull data based upon a comprehensive set of business requirements. Examples include reports for marketing, engineering, finance, and quality control.
Macros: I write Windows PowerShell scripts & DOS batch files in order to automate processes. Previously, I also wrote Visual Basic macros to automate mass changes.
* In Apr. 2011, my title was realigned to better reflect my duties. My previous title was Billing Application Analyst.
Reporting Server: I designed, implemented, and supported a Microsoft SQL Server for reporting. This included SSIS ETL, tables & SQL queries, and SSRS reports. Reports included commissions, sales, homes passed & penetration, and technical operations metrics.
In Feb. 2008, my department was reorganized. Previously, my duties included those below. After the reorganization, they were dropped in order to focus on reporting and automation.
Project Execution: I led and executed a number of minor projects from inception to completion, which included defining the scope, developing & executing a step-by-step plan, and communicating & coordinating with other departments. Projects I managed included data cleanup & reconciliation, quality control, and revenue assurance.
Case-Based Support: I provided troubleshooting and support for personnel having difficulty operating the CSG billing software. Personnel I supported included customer service & front-counter representatives, leads, & supervisors; dispatchers; technicians; and managers.
Billing System Configuration: From time-to-time, I was tasked with changing configuration parameters, including service codes, rates, packages, discounts, taxes, prerequisites rule sets, provisioning of addressable services & equipment, and securities. Examples include projects where I increased rates, launched new equipment, and launched new services.
High Speed Data Specialist -- I served customers by troubleshooting problems with their Internet connection. I also provided product and service information relating to Internet access and other new product lines, and I solicited orders for new products and services.
Sales Associate -- I helped customers find and choose the products that met their needs.
Technical Assistant -- I supervised the computer labs and helped people diagnose and solve computer problems. Occasionally, I assisted the Information Technology department in deploying system updates.
Graduated with a Bachelor of Arts (4 year) Degree in Computer Science.
Professional Reference
Alex Minster
IA Analyst
HP
Aaron Van Gieson
Operations and Analytics Manager
Micron Technology
Personal Reference
Lori Bryan
Billing Application Analyst
Charter Communications
Negotiable
• CompTIA A+ Certified