Resume

Sign in

Sales Accounts Payable

Location:
Fort Worth, Texas, United States
Posted:
May 31, 2017

Contact this candidate
Sponsored by:
TalentDesk
Post Jobs to
Multiple Job Boards &
Get more Candidates
Try it Free!
Start your 30-day
Free Trial

Alan Price

Developer V - RadioShack

Fort Worth, TX

ac0kn9@r.postjobfree.com - 817-***-****

Highly skilled Senior Software Engineer that likes the challenge to take business ideas to completion - taking on the full development life cycle of projects. I get great satisfaction in contributing to new services and technology tools to grow the business.

Skills & Expertise

SDLC (Software Development Life Cycle)

DOMO

Redshift

My SQL

Teradata (SQL Assistant, Miner, BTEQ, Multiload, FastExport) Perl

Excel VBA

SQL (Teradata, DB2, Oracle, SQL Server, Redshift, My SQL) ETL processes

Systems Analysis

Data Modeling

Data Warehousing

Business Intelligence

WORK EXPERIENCE

Developer V

General Wireless d.b.a. Radioshack - Fort Worth, TX - 2015-07 - Present Responsible for creating a new sales data warehouse and new drill-able visual reporting cards within Domo. This allowed the business to evaluate profitability of stores, products and services to increase sales, reduce losses. Projects included: Intraday Sales, Email capture, Markdown Reporting, Loss Prevention Reporting, Close Store Reporting. Decommissioning of Teradata Warehouse and Reporting. Skills: Domo, Redshift, My SQL, DB2, Oracle, Teradata, Perl.

Developer V

RadioShack - Fort Worth, TX - 2008-06 - 2015-07

Responsible for the full project life cycle(SDLC) of various reporting requirements for company projects and executive reporting requests at Corporate and 4000+ Stores. These reports allowed the business to evaluate profitability of stores, products and services to increase sales, reduce losses. (Primary reporting areas are Wireless, Attach Rates, Marketing).

Projects included: Market Attach, Wireless Profitability, Fix it Here, Black Friday reports, Intraday Sales, Email capture, Loss Prevention Reporting.

Programs were written in Perl v5.16 script calling either canned C# programs(used to create excel Reports) or BTEQ SQL used to Update/Insert data into Teradata or TWM projects. Database platforms: Teradata, DB2, Oracle, SQLServer Languages/Utilities Perl, Teradata (Miner, BTEQ, MultiLoad, Fast Export), Excel VBA, .Net

(C#, VB#) (used to create the initial .net programs in visual 2003 have not coded since then).

• Responsible for maintaining current ETL processes into Hyperion Essbase.

• Upgraded Tableau Servers from 8.0 to 8.1 and 8.1 to 8.2.

• Hyperion reporting (Brio) in 2008 created a dashboard for marketing using Brio and Java which measured how effective marketing campaigns where (this was later replaced by a tableau dashboard) Technical Lead

RadioShack - Fort Worth, TX - 2006-03 - 2008-06

PCI Remediation Phase 2 - Technical Lead for development of Design Project Plans, Design Requirements, System Architecture documents, and Transition Plans. Management & Review of work by 20 RadioShack Employees and 10 Consultants this included Technical Design Documents, Unit Test Plans, and Implementation plans. This Phase remediated credit debit cards in the following Radioshack systems RSU

(RadioShack Unlimited), OMS (Order Management Systems), FileNet Historical data on DB2 databases and a new PCI monitoring application.

• VISA PCI Remediation - Phase 1 of the PCI Remediation project, this phase remediated credit/debit cards on the following Radioshack systems POS (Point of Sale), ANSO (Answers on line), Credit Settlement, Credit Card Research, Daily Report Load, and miscellaneous access databases. For this phase required managing 5 Radioshack employees and 15 Consultants.

Developer IV

RadioShack - Fort Worth, TX - 2004-03 - 2006-03

Business Analysis Projects

• Supply Chain Management - Operational Metrics Reporting - Responsible for gathering and creating Business Requirements, managing development and creating and monitoring integration test plans.

• Multiple Wireless Service Plans - Responsible for creating Business Requirements and creating integration test plans

.

Developer IV at RadioShack Corporation

Developer IV

RadioShack - Fort Worth, TX - 1999-03 - 2004-03

PeopleSoft V8 upgrade AP/GL - Responsible for design requirements, development and testing of all 3Way Matching modules this included assigning tasks, reviewing documents of the offshore team.

• PeopleSoft V8 Upgrade HRMS - Responsible for analysis and requirements for various HRMS modules.

• Version 8 training in PeopleTools I & II, PeopleCode, and application Engine.

• 3Way Matching - Responsibilities included documentaion, design, programming and implementation of panel changes (Peoplesoft) and Interfaces (SQR's). In all phases of the project.

• Accounts Payable Version Upgrade V7.01 to V7.02 - Responsible for documenting and migrating all new peoplecode changes to Accounts Payable Module.

• Financials - responsible for various maintenance projects such as PeopleSoft patches, code fixes, and small enhancements to the Accounts Payable module (primary) also Accounts Receivable and Asset Management modules (secondary) using peoplecode, SQR and PL SQL Senior Analyst

ABACI Inc - Fort Worth, TX - 1996-09 - 1999-03

Responsible for development and conversion of all legacy financial data to Peoplesoft Oracle tables, using Adabas/Natural, JCL, and Smart DB workbench.

• Job required extensive client communication between Functional leads and legacy clients.

• At end of Project helped in troubleshooting of Peoplecode and PL/SQL scripts.

• Participated in the maintenance and upgrade of BR's Financial Accounting systems, Field Data Gathering systems, Well Profitability Reporting, Manual Check Processing, and various client server apps written for BR

• These systems were developed in COBOL, Natural 2.2, VB 3.0, VB 4.0, and Powerbuilder 4.0, using ADABAS, SYBASE, DB2 as the database management platforms on OS/MVS CICS, UNIX and MS Win 95 Operating Systems

• IS Administrator for Hyperion Enterprise Financial Reporting System Senior Analyst

Burlington Resources - Fort Worth, TX - 1992-01 - 1996-09 As Senior Analyst provided support for mainframe and client/server Financial Systems. Participated in the planning, development, testing, and implementation of the following systems: Financial Reporting System using Hyperion Enterprise SE

• State Tax Reporting using VB 3.0 and DB2. Manual Check Processing using VB 3.0, Jetform Design/Central

• Well Profitability Reporting using VB 3.0, Sybase Programmer/Analyst

Trecom Business Systems - Fort Worth, TX - 1988-06 - 1992-01 As Programmer/Analyst at Burlington Resources participated in maintenance and enhancements to BR's Financial, Operations, and Revenue Systems.

• Assisted Arthur Anderson and BR's IST programmers with conversion and integration of COR-1 (Contracts, Operations, Revenue, and First Purchaser integration)

• Assisted with troubleshooting on the new systems after the startup of the COR-1 system.

• As Programmer/Analyst at Sprint, responsible for upgrades to the XL System an interface application between Sprint's Customer Information System and Billing Systems.

• Data was extracted from Adabas files in the Customer Information System and written to tape using COBOL II for input into the Billing System.

.

Programmer

OAO - Oklahoma City, OK - 1986-09 - 1988-06

As Programmer developed, tested and implemented various programs for the FAA NTSB online systems using Adabas/Natural.

• As Programmer at Fort Sill Army Post in Lawton OK, participated in the maintenance and training of personnel on the Army Personnel System.

EDUCATION

Bachelor of Science in Computer Science

University of Oklahoma

1986

SKILLS

SDLC (Software Development Life Cycle), DOMO, Redshift, My SQL, Teradata (SQL Assistant, Miner, BTEQ, Multiload, FastExport), Perl, Excel VBA, SQL (Teradata, DB2, Oracle, SQL Server, Redshift, My SQL), ETL processes, Systems Analysis, Data Modeling, Data Warehousing, Business Intelligence



Contact this candidate