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.

view more

view less

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.

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.

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.

(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.

view more

view less

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.

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.

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.

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.

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.

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.