Uploaded File
George
gmgill@myexpressbox.com
214-450-8632
Saint Petersburg, FL 33704
System Testing Tower Lead/Business Analyst
24 years experience W2
3
Recommendations
Average rating
202
Profile views
Summary

Senior Systems and Business Analyst with 25 years of experience in the IT industry. Including the implementation and operation of Inside/Outside Plant, Customer Care/Service Order, and Customer Billing systems (CC&B) for land-line and wireless customers. I have a blend of information services and business operations experience. In addition to business and functional knowledge, I am also technically proficient with a variety of software tools. I have worked with many applications such as AMDOCS (Telegence), DPI, ICMS, CBSS and others. Test tools I've worked with include HP Quality Center, HP UFT, AOT's, ClalrifyRM and Infoman. Relevant Project Experience Summary
• Frontier Communications - Plant System QA Tower Lead - Met with end users to obtain use case objectives, wrote test plans, test cases, train new on boards for Connecticut Conversion & Verizon CA, FL and TX conversions.
• AT&T - System Testing - Provisioning and Billing for IT Services -
• AT&T Mobility -System Testing on ATT Mobility Micropayment Billing System
• CSG / Fairpoint Communications - Business Analyst/Plant Conversion Test Lead - ICMS Conversion

Experience
System Testing Tower Lead/Business Analyst
Information Technology
Mar 2015 - May 2016
Tower Lead for Plant System Test Team. Performed Business Analyst functions meeting with end users to write test plan and use case/test cases that covered there Functional and Business Requirements. Wrote Test Plan, System Test SQL Data Verification test cases and updating old test cases for the Verizon to Frontier Conversion. Test cases written used Teradata, Razor and Oracle Developer. Worked closely with data mappers and conversion development coders to develop test scenarios based on user business requirements. Conducted test case execution and analyzed results. Assisted and mentored team members. Created, executed, and maintained test cases and scripts, both manually and automated, and defined test data to exercise test scenarios/cases. Detected, documented, and reported software failures and verified bug fixes. Validated severity of issues and quantified impact to systems and stakeholders. HP Quality Center ALM and UFT supported test plan and test lab set up. Wrote SQL in ALM to generated reports on testing and defects. Supported all teams by writing various documents on systems and relationships including "Understanding Fiber Cables Networks", "Understanding Copper Cable Networks and Terminals" and a "DPI Plant Handbook" for new users. I also authored several excel documents that showed the fields and relationships between the major Plant table group for TDM, Fiber, SIP and other Offices, Cables and Pairs, Terminals, Fibers Passive Optical Networks and DPI Line Cards.
Test Planning Test Case Preparation System Testing Teradata SSIS SQL Business Analysis Business Requirements HP QC HP ALM HP UFT Oracle Fiber Optics Microsoft Excel
Remove Skill
References
Average Rating

2 recommendations
System Testing Tower Lead – Production Support and Trend Reports
Telecommunications
Jun 2014 - Mar 2015

Systems testing for ATT Customers converting to Frontier Communications Customer Billing, Information and Plant. Performed Business Analyst functions meeting with end users to write test plan and use case/test cases that covered there Functional and Business Requirements. Ran SQL, Hawkeye, and other AS400 products. Wrote test scripts for testing tables in DPI. Also investigated UAT and production defects, analyzed and submitted fix to developers after researching the issue. Wrote SQL code to research and resolve defects. Performed same functions as succeeding job above from 3/2015 to 5/2016.

System Analysis Production Support Test Planning System Testing SQL Hawkeye AS/400 Test Scripting Business Analysis UAT
Remove Skill
Senior System Analysis – Production Support and Trend Reports
Telecommunications
Jun 2011 - Mar 2014

Provided production Billing & Ordering support. Collected data to identify root cause of problems, recommends, writes, & implements solution. Identified method and process deficiencies that might inhibit effectiveness. Performed UAT testing during code releases. Wrote change requests to correct issues discovered while analyzing production issues. Developed various trend reports for Billing, Revenue Variance, Credit card auditing of files to Chase PaymenTech. Performed verifications of interface files between various AT&T applications. Issued bugs and reviewed corrective actions to previous bugs.

UAT System Analysis Production Support Auditing
Remove Skill
Business Analyst – Business Requirements, Use Cases & Hi-Level BRD
Telecommunications
Jan 2011 - Jun 2011

Met with end users to develop and write Business Requirements document for Version 1.0 of the new Universal Ordering System for Verizon’s VEC (Verizon Enterprise Center) Commercial contract customers and Federal government. Wrote the associated Use Cases for each BRD.

Business Requirements Business Analysis BRD
Remove Skill
Senior Consultant - Systems Analyst /Conversions/Prod Support
Information Technology
Jan 2008 - Jan 2010

(ATT Mobility) Senior Consultant - Systems Analyst /Conversions/Prod Support Tier I Prod Support for Combined Billing ATT Mobility customers accounts with ATT Landline and ATT U-Verse. Tier I Prod Support for ATT Mobility Micropayment Billing Issues UAT Testing after code releases.. Worked with QPASS, AMDOCS, ECTEL, RAP, EDSAT, EDSAT, and ClarifyRM. Worked on Micropayment aggregators and merchants on micropayment billing issues. Supported File check comparisons using TOAD to run SQL scripts and UNIX command level research. Performed UAT Testing after code releases. Tier I Prod Supt for Key Performance Indicators and Key Revenue Assurance Indicators in ECTEL related to Micropayments. Used Business Objects 6.5 to pull data for different departments in the ATT Mobility Data Warehouse. Provided general report, analysis, auditing and reconciliation support for internal customers related to Telegence (AMDOCS) Billing. Worked Extensively in web services and mobile during this project.

System Analysis Data Warehousing Business Objects Auditing Analysis WebServices UAT SQL UNIX Amdocs Clarify TOAD
Remove Skill
References
Average Rating

1 recommendation
Consultant - Business Analyst /Business Development Analyst
Information Technology
Jan 2007 - Dec 2007

Developed Business Process Work Flow and System Process Flow for Telecom circuit ordering system. Analyzed network and circuit engineering business process of current engineering applications. Performed data mapping of existing circuit order system to required attributes of new order system. Wrote Detailed Functional Specifications in CalberRM and High Level Design for new order system that uses Visionael NRM and Visionael Studio. Wrote HLD, XML Schema and WSDL for Web Services between to two EDS Systems. Business Intelligence tools included Altova XML Spy, Oracle tools, TOAD, and CaliberRM.

Business Analysis Business Intelligence Business Development Data Mapping XML WebServices XML Spy TOAD Oracle WSDL
Remove Skill
Consultant - Business Analyst - Strategic Business Unit
Information Technology
Jan 2004 - Dec 2006

ICMS Performed various phases of the systems development life cycle, according to the requirements of the client and project definition. This included: Defect analysis, code review & table maintenance. Business analysis and requirements definition Business development. Performed data analysis, project management, billing issue research and resolution. Ran SQL and DBU queries on AS400 to support data mining, mapping and defect analysis. Ran Brio queries on data warehouse contents when using production files was not available. Reviewed new code and built test cases to prove new code and regression analysis to insure existing functionality not harmed.

Business Analysis Business Development Data Analysis Data Mining Data Warehousing AS/400 Test Case Preparation SQL Project Management Analysis
Remove Skill
Pro-Comm Consulting
Information Technology
Jan 2003 - Jan 2003
Provided Project Management support for gap analysis and requirements gathering process for conversion from existing AIS billing systems to DPI Convergent Billing Platform. End product was used to as RFP for projects bids and planning. This included Vertex Tax implementation and adding a GUI Front end to the DPI application using Seagull Software. Interviewed and selected team members for the Data Mapping Team.
No skills were added
Remove Skill
Manager - Billing Projects
Jan 2002 - Jan 2003
Provided Project Management support for all Billing and Mediation Projects at T-Netix an inmate calling solutions company. Managed team of 12 IT Management members responsible for processing over 1,000,000 CDR records daily. Ensured that all internal departments and external vendors performed the necessary tasks and activities leading to the successful implementation of all billing projects. Developed detailed business requirements for a new mediation system for message processing. Assisted in development of Test Plan and Test Scenarios and testing of new releases. Developed and provided training to operations and table personnel on new system and new releases.
Project Management
Remove Skill
Consultant to Citizens Communications, Inc
Information Technology
Jan 1999 - Jan 2001
IT Project Lead\Unit Tester Lead - Conversion & Implementation Lead for Citizens Communications acquired properties Performed all of the project lead tasks necessary to convert over 1,000,000 access lines purchased by Citizens Communications from Verizon and Qwest, to the Citizens DPI Billing System. Directed unit testing to verify conversion code prior to turnover for User Acceptance Testing. Mentored and lead team responsible for verifying that the mapping from source data to the target data files. Analyzed user billing table updates to insure proper conversion and customer billing on rates, taxes and fractionalized services. Wrote, reviewed and translated written business rules to proper logic for programmers to code in RPG/ILE. Supported Service Level Agreement activities via SQL, BRIO and AS400 queries. Performed annual reviews on team members.
SQL
Remove Skill
Manager Billing Operations
Jan 1999 - Jan 1999
Project Management
Remove Skill
Project Lead - Business Analyst
Information Technology
Jan 1997 - Jan 1999
Managed the end results of the diverse functions required for mailing of timely accurate and quality integrated end user customer bills for Verizon Select Services (CLEC). Direct reports included manager for the Quality Assurance and Regression Test Team Manager of Bill Review group Manager of DBA/MIS Reporting PARS reporting AD HOC Reporting and the Analyzed various trending reports on receivables, pending orders, disconnects, uncollectibles, etc for unfavorable trends. Signed off on and coordinating new billing releases to production. Performed annual review on managers and reviewed and approved annual reviews that my managers wrote on their direct reports.
Business Analysis Project Management
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Business / Accounting
University of South Florida
of 60 hours
University of South Florida
SOAP, API's, XML, etc
HP Quality Center
Skills
Business Analysis
2016
8
SQL
2016
8
Project Management
2006
5
System Analysis
2015
5
UAT
2015
5
Analysis
2010
4
Auditing
2014
4
Data Warehousing
2010
4
Test Case Preparation
2016
4
AS/400
2015
3
Business Development
2007
3
Production Support
2015
3
Amdocs
2010
2
Business Objects
2010
2
Clarify
2010
2
Data Analysis
2006
2
Data Mining
2006
2
Oracle
2016
2
TOAD
2010
2
UNIX
2010
2
WebServices
2010
2
Business Requirements
2016
1
Fiber Optics
2016
1
HP ALM
2016
1
HP QC
2016
1
HP UFT
2016
1
Microsoft Excel
2016
1
SSIS
2016
1
System Testing
2016
1
Teradata
2016
1
Test Planning
2016
1
BRD
2011
1
Business Intelligence
2007
1
C
0
1
Data Mapping
2007
1
Hawkeye
2015
1
Quality Assurance
0
1
Test Scripting
2015
1
WSDL
2007
1
XML
2007
1
XML Spy
2007
1