SUMMARY:

• Over Eighteen years’ experience in Information Technology industry.
• Proficient in designing & implementation of all QA test strategy plans manual and automated test solutions for client server and Web based applications using testing tools HP QC, HPALM,
• Soup UI /REST.
• Efficient in testing RDBMS Oracle, DB2, Access Database, MySQL, AS/400 iSeries Navigator, Infinys RBM (Rating and Billing Manager) Configuration, Chameleon Host Link, RUMBA AS/400, BBGUI - Jwalk/Seagull, Mainframe, CSG Billing System, AMDOCS (DDP/DDPF) Billing System, CRM Web Launcher (Sterling 7 for Residential and Sterling 9 for Business), Dynamics, Salesforce, Aggregator and Warehouse Maintenance (WMS), Web based applications/systems.
• Strong skills in Business Requirement Analyst, Quality Assurance Process (SDLC), AGILE/SCRUM, Conversion/ Implementation Support, Data Mapping and Methodology and ETL Tools Informatica.
• Expert in performing Functional Testing, Integration, Regression Testing, Backend Testing, User Acceptance and End to End Testing.
• Expert in SQL Queries, AS/400 Work QRY Tool, SQL Server, Toad, JMS and Messaging Queues (MQ).
• Self-motivated, with strong technical and interpersonal skills. Excellent attitude towards work

OBJECTIVE:

Seeking a challenging position in the field of Requirements Analyst/Implementation Support/Quality Assurance Analyst and Configuration, for the implementation of User/Business/Functional requirements so as to enable the product as defect free product.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98, Windows 2000, Window XP, Windows NT, MS-DOSOS/390 Mainframe & OS/400 Client Access V6.0 iSeries V6.0 for Windows AS/ 50 Terminal Emulators RUMBA, ChameleoniSeries, Mocha). RPG/400 and CL Commands, BBGUI - JWALK/Seagull.

Languages: SQL, PL/SQL, C, ASP, JSP, Java, J2EE, HTML

GUI: Visual Basic 5.0 & Developer 2000

Databases: Oracle 7.X/8i, IBM DB2, MS Access 2000, SQL Server

Software: MS Office, Coral Word Perfect, Quick Books, Vertex Comm Tax Q Series, KPMG kTrain Tool, Pitney Bowes Spectrum 9.0, Sales ForceCRM Sterling 7 & 9, Dynamics, Aggregator. Lotus Notes5.0, Clarify V10.1 SR1

Database Tools: Toad, SQL Navigator.

Web Browsers: Microsoft Internet Explorer, Netscape, Google Chrome, Fire Fox

Testing Tools: Win Runner, Test Director, QTP, HP Quality Center ALM, Soup UI

WORK EXPERIENCE:

Sr. App Specialist/Data Analyst and Mapping

Confidential, Charlotte, NC

Responsibilities:

• I am responsible for Mapping from CSG and ICOMS Billing System Files to Enterprise Dataware House Core Tables to generate High Level Dash Board Reports.
• Mapping ICOMS and CSG Tables and fields to Core Tables to each subject areas.
• Subject Areas are in Phase 1 Account, Address, Billing Products and Work Order,
• Subject Areas are in Phase 2 Equipment, PPV/VOD, Credit Adjustments, Account, Serviceability, Charter Stores.
• Data Analysis and mapping related subject areas discussions with Modeling and BI teams.
• Analyze all the related mapping documents before submit to the TERA DATA Developers for coding.
• Responsible for Data Analysis and work with Developers, BI Team, Modeling Team and QA Team.
• Any changes required in modeling or mapping will update periodically and resubmit mapping documents to developers.
• Run Queries using SQL and CL Commands WRKQRY, STRSQL, DSPCMD etc., for reviewing the Data from the Tables.
• Analyze all the mapping files before submit to the Development Teams.
• Extract by the subject areas flat files from Source billing system ICOMS and send to developers to load in Stage and Persist Tables in Teradata.

Environment: IBM iSeries AS400, RPG, CL Commands, DB2, Windows XP, MS Office, Access DatabaseTeraData SQL Assistant, ViewPoint Explorer and COIN Share point.

Telecom Billing (SME) / Sr. QA Analyst

Confidential, Twinsburg, OH

Responsibilities:

• Work with Tables, Mapping and Data scrubs team to validate the Source System RevChaing7 and Target System RevChain8 Billing system configuration.
• As a QA team I am responsible for writing test plan, test cases and execute test cases and also using test cases to execute and track the defects using SPIRA TEAM.
• Conduct Regression testing after the defects fixed and also test surrounding areas of fixed defect.
• Responsible for to test conversion existing Subscriber Services, Bundles, Packages, Rate Plans, Promotions, Discounts, Rewards, Taxes and Statement Presentation and also Day 1 Services, Bundles, Packages, Promotions, Discounts, Rewards.
• Confidential statement comparison with RevChain7 with RevChain8 billing statement for all rate plans, promotions, discounts, rewards, usage plans and Taxes. Order Management, Product Management (Promotions, Discounts, and Rewards) and Services & Equipment Maintenance, Taxes Test Customer Billing Cycles and Statement Presentation.
• Review the Functional and Non-Functional specifications which are to be included in the project/release Notes
• Interface with development, mapping and table maintenance teams. Research leading QA practices, methodology, and technology.
• Usage (Local, Long Distance, Data) Testing according to the Call Plans, Rates and Price Plans.
• Developed Test Scripts for functional testing using SPIRA TEAM Tool.
• Back end Testing Run Queries using SQL and CL Command WRKQRY, STRSQL, etc., for reviewing the Data from the Tables and also validating Value Mapping Files from Source Data.
• Extract the files from Source and Target Systems then load into Toad or Access database to do the data validation comparisons.
• Analyze Defect Reports and work closely with Application Developers, Mapping team for resolution. Testing Production problems and product modifications (CR’s), price changes, campaigns using remedy application.

Environment: Winforce(SFDC), PAO (Quotes), WinCare-CRM (Ordering),RevChain8 (Billing System), MSS/M6 (Inventory/Provisioning) Spira Team (Testing Tool).

Confidential, Atlanta, GA

Sr. Telecom Cable Billing (SME)/ Sr. QA Analyst

Responsibilities:

• Work with Tables, Mapping and Data scrubs team to validate the DPI Billing system configuration.
• As a QA team I am responsible for writing test plan, test cases and execute test cases and also using test cases to execute and track the defects using HP ALM.
• Entering Defects and review with Test team before sending out to Developers/Mapping team and also attend daily defect status calls to track all the existing and new defects.
• Conduct Regression testing after the defects fixed and also test surrounding areas of fixed defect.
• Analyze existing system to create test cases for Business Simplification process Enhancements and for Regression testing.
• Responsible for to test conversion existing Subscriber Services, Bundles, Packages, Rates, Promotions, Discounts, Rewards, Taxes and Statement Presentation after billing cycle run complete and also Day 1 Services, Bundles, Packages, Promotions, Discounts, Rewards.
• Confidential statement comparison with Verizon Statement for all the rates, promotions, discounts, rewards and Taxes.
• Resolves test issues and Maintained Subscriber Information Management, Address Maintenance Validation, Order Management, Product Management (Promotions, Discounts, and Rewards) and Services & Equipment Maintenance, Taxes Maintenance by product category by GEO Codes and Tax Districts. Test Customer Billing Cycles and Statement Presentation.
• DPI Jwalk GUI Web Based application Billing system testing.
• Review the Functional and Non-Functional specifications which are to be included in the project/release Notes weekly basis.
• Interface with development, mapping and table maintenance teams. Research leading QA practices, methodology, and technology and determine and utilize automation technology and processes.
• Facilitates complex group meetings and conducts information gathering sessions. Resolves conflicts/issues to escalate as appropriate. Provides expertise, direction, coaching and development in all areas related to testing and QA in order to build the project teams capability.
• Business Simplification process service code rate master and rate matrix price changes and also service type changes premium to Auxiliary setup and also package Id’s calling features (Local, Regional and Long Distance) in the system.
• Usage (Local, Long Distance, Data) Testing according to the Call Plans, and Rates and price plans.
• Developed Test Scripts for functional testing Using HP Quality Center (ALM) Tool.
• Backend Testing Run Queries using SQL and CL Commands WRKQRY, STRSQL, etc., for reviewing the Data from the Tables and also validating Value Mapping Files from Source Data.
• Extract the files from AS/400 host to desktop and load into Toad or Access database to do the comparison data validations.
• Analyze Defect Reports and work closely with Application Developers, Mapping team and Tables team for resolution.
• Testing Production problems and product modifications (CR’s), price changes, campaigns using Clear Quality Application (Change Management System).

Environment: IBM AS/400 iSeries, RPG, CL Commands, DB2, JWalk, MS Access Database, System i Navigator, Windows XP, Windows Server 2008, Microsoft Office, Vertex Comm Tax Q Series, HP Quality Center(ALM).

Confidential

Sr. Application Specialist

Responsibilities:

• Setup Company, Division, GL Majors and GL Minors.
• Setup Franchise Master and assign GL Minors and Rate Master Grouping code.
• Responsible for configure Tax Types and Tax Grouping Codes
• Responsible for configure TAR Codes and assign Tax Groups and Tax Types to the TAR Codes.
• Responsible for configure Tax Rates for all TAR Codes and all the Tax Types, Amount Capping, Line Capping and Tax on Taxes.
• Responsible for configure System Parameters Service Codes and Rater Master and also other required System Parameters.
• Maintained Customer Information Management, House Maintenance, Order Management, Product Management (Promotions, Campaigns) and Services Maintenance, Taxes Maintenance by product category by GEO Codes.
• Developed and maintained Campaigns, Discounts and Offers Analysis.
• Performed functional testing provisioning, Tax Rates and also verify the end user Billing and Statements.
• ICOMS Jwalk GUI Web Based application billing system testing.
• Entering Defects HP Quality Center and review with Test team before sending out to Developers and also conduct Weekly Defect Status calls to track all the existing and new defects.
• Run nightly and Billing in Test Slices Billing system and verified End user statements.
• Write MACRO’s to upload data in to ICOMS Billing System tables configuration.
• Run AS/400 Queries using SQL and CL Commands WRKQRY, STRSQL, STRPDM, DSPLF etc., for reviewing the Data from the Tables.
• Extract files from AS/400 system to PC through AS/400 iSeries Navigator or FTP.

Environment: AS/400 iSeries, RPG, CL Commands, DB2, BBGUI-Jwalk/Seagull, CSG (ACSR/ACP), Amdocs (DDP/DDPF) Windows XP, Microsoft Office, HP Quality Center.

Confidential, New Jersey, NJ

Sr. Telecom/Cable Billing/Data Analyst/Configuration/Sr. QA Analyst

Responsibilities:

• Work with Tables, Mapping and Data scrubs team to validate the DPI Billing system configuration.
• As a QA team I am responsible for writing test plan, test cases and execute test cases and also using test cases to execute and track the defects using HP ALM.
• Entering Defects and review with Test team before sending out to Developers/Mapping team and also attend daily defect status calls to track all the existing and new defects.
• Conduct Regression testing after the defects fixed and also test surrounding areas of fixed defect.
• Analyze existing system to create test cases for Business Simplification process Enhancements and for Regression testing.
• Responsible for to test conversion existing Subscriber Services, Bundles, Packages, Rates, Promotions, Discounts, Rewards, Taxes and Statement Presentation after billing cycle run complete and also Day 1 Services, Bundles, Packages, Promotions, Discounts, Rewards.
• Confidential statement comparison with ATT Statement for all the rates, promotions, discounts, rewards and Taxes.
• Resolves test issues and Maintained Subscriber Information Management, Address Maintenance Validation, Order Management, Product Management (Promotions, Discounts, and Rewards) and Services & Equipment Maintenance, Taxes Maintenance by product category by GEO Codes and Tax Districts. Test Customer Billing Cycles and Statement Presentation.
• DPI Jwalk GUI Web Based application Billing system testing.
• Review the Functional and Non-Functional specifications which are to be included in the project/release Notes weekly basis.
• Interface with development, mapping and table maintenance teams. Research leading QA practices, methodology, and technology and determine and utilize automation technology and processes.
• Facilitates complex group meetings and conducts information gathering sessions. Resolves conflicts/issues to escalate as appropriate. Provides expertise, direction, coaching and development in all areas related to testing and QA in order to build the project teams capability.
• Business Simplification process service code rate master and rate matrix price changes and also service type changes premium to Auxiliary setup and also package Id’s calling features (Local, Regional and Long Distance) in the system.
• Usage (Local, Long Distance, Data) Testing according to the Call Plans, and Rates and price plans.
• Developed Test Scripts for functional testing Using HP Quality Center (ALM) Tool.
• Backend Testing Run Queries using SQL and CL Commands WRKQRY, STRSQL, etc., for reviewing the Data from the Tables and also validating Value Mapping Files from Source Data.
• Extract the files from AS/400 host to desktop and load into Toad or Access database to do the comparison data validations.
• Analyze Defect Reports and work closely with Application Developers, Mapping team and Tables team for resolution.
• Testing Production problems and product modifications (CR’s), price changes, campaigns using Clear Quality Application (Change Management System).

Environment: IBM AS/400 iSeries, RPG, CL Commands, DB2, JWalk, MS Access Database, System i Navigator, Windows XP, Windows Server 2008, Microsoft Office, Vertex Comm Tax Q Series, HP Quality Center(ALM), CRM Web Launcher Sterling 7 &9, Dynamics, Sales Force and Aggregator Apps.

Confidential, New Jersey, NJ

Sr. Taxes Analyst

Responsibilities:

• Responsible to download Tax Rate changes flat file from Vertex website.
• Responsible to Export flat file in to Vertex Communications Tax Q Series user interface.
• Responsible to Import Tax Update file and also Import Customizations and Franchise Fee files in to Vertex Communications Tax Q Series user interface.
• Responsible to Publish Customizations and Franchise Fee files in Vertex Communications Tax Q Series user interface.
• Worked on Pitney Bowes Spectrum Technology software used GeoTAX Module and Universal Addressing Module to validate the USA addresses and also configure Management console and validate the addresses and GEO Codes in Enterprise Designer Management.
• Worked on K-Train (KPMG Tool) configuration to update new Sites, Tax Groups, Tax Types, Tax Statement Line numbers, GL Minor numbers, Tax Exempt Codes, Tax Rates, Tax Amount Capping, Tax Line Capping and Tax on Tax, Tax Rate changes and also Custom Tax Types.
• Worked on Import files from Billing System to KPMG K-Train House Master File and all Tax Files and also export from K-Train updated files in to the Billing Systems.
• Worked on incorrect TAR Codes after importing house file in to K-Train then update all the incorrect TAR Codes using TAR Codes Process Utility to update in to the Billing System.
• Worked on all Tax Files after imported from Billing Systems to update in K-Train used utilities for Amount Capping, Line Capping, Tax Exempt Codes, Tax Statement Line Numbers, GL Minor numbers and Tax on Tax and also Custom Tax Types.
• Responsible for All the House Master TAR Codes file and also all the updated Tax Files process in to the Billing Systems before billing run.
• Run AS/400 Queries using WRKQRY, STRSQL and CL Commands STRPDM, DSPLF etc., for reviewing the Data from the Tables and also used to run sequel queries in Access Database and SQL Server.

Environment: AS/400 iSeries, RPG, CL Commands, DB2, MS Access Database System i Navigator, Windows XP, Windows Server 2008, Microsoft Office, SQL Server (Navicat), Vertex Comm Tax Q Series, KPMG K-Train, HP Quality Center, FTP Voyager, Pitney Bowes Spectrum v9.0 SP11.

Confidential, Denver, CO

SOA Business Functional Requirement Analyst

Responsibilities:

• Functional Requirements SOA (Service Oriented Architecture) project Interfaces API’s used to ICOMS, CSG, and Hawaii Oceanic Billing Systems and third party systems Connects, StrikeIron and Call Scheduler (IVR Script), Siebel Product Catalog and Service Catalogs and also Sales Order Management (SOM).
• Received Business Requirements Documents and converted into Functional Requirement Document and also reviewed Functional Requirements with SOA Development and QA Team before submit FRD Document to SOA development and QA Team and also upload in to SharePoint.
• Worked on PerformanceOutageNotification functional requirements and Non-Functional requirements document and reviewed with SOA Development and QA Team uploaded in SharePoint. Element definitions, defined required element fields, Notification types mapping to Connects (KANA e-mail notifications), StrikeIron (SMS Text Message notifications), and Call Scheduler IVR (Voice Message notification) and also Campaigns mapped to all 3 third party systems.
• Developed Test sets for Web based Services using HP Quality Center, Soap UI and REST messages in XML Documents.
• Developed GetOrderList enhancement Functional Requirements Document updated with new enhancements functional requirements like updated request XML definitions and also updated functional requirements and provided to SOA Development and QA Team.
• Entering Defects in HP Quality Center and review with Test team before sending out to Developers and also conduct Weekly Defect Status calls to track all the existing and new defects.
• Worked on StatementNotification Functional Requirements document and reviewed with SOA Development and QA Team. This process will received statement files from CSG and Hawaii Oceanic system and also get the additional required data from billing systems and send statement notification to JMS to Connects system and Connects will send email notification to the EBPP Residential and Commercial customers.
• Worked on GetAccountStatementDetails Functional Requirements document for to get the Statement details from the Billing Systems (CSG/ACP, ICOMS). This process SOA service will send request to Vantage System (ACP Mirror Database) and ICOMS Billing System to get the Customer Account information such as First Name, Last Name, EBPP Flag, Paperless Flag etc., This is within the Statement Notification FRD.
• Working on TWC Internal Catalyst project BRD Review sessions related to SOA services and also working on developing functional requirements for Customer Billing Information, Payments and Risk Assessment and Credit check (External Equifax and Internal Billing systems ICOMS, ACP and Hawaii Oceanic). And also involved complete Business Requirements Document JAD sessions.

Environment: AS/400 iSeries, RPG, CL Commands, DB2 Database, CSG/ACP and Hawaii Oceanic Billing System, Windows XP, Microsoft Office, Sales Order Management, SharePoint, Enterprise Product & Service Catalogs, HP Quality Center, Soup UI.

Confidential, Atlanta, GA

Sr. Applications Specialist/Sr. QA Analyst

Responsibilities:

• Worked on North East and Carolina Regions Sales Automation Project and also support Midwest Sales Automation errors doing ICOMS Billing System Analysis.
• Responsible for Sales Automation process ICOMS Billing System work order analysis, Service Codes analysis by rate groups by franchises, Service codes Prereqs and also Campaigns analysis pricing and discounted service codes. And also did analysis related to automation work order User Id, related System Parameters and employee information and also work order codes.
• Data Analysis on Customer Information Management, House Maintenance, Order Management, Product Management (Promotions, Campaigns) and Services Maintenance, Taxes Maintenance by product category by GEO Codes.
• Prepared Excel files for Enterprise Service Catalog by Franchise by Rate groups and also put GPD (Get Product Details) file together for Packages, Service codes, Campaign Pricing and ala carte prices and also exception service codes for Enterprise Product Catalog configuration.
• Responsible for doing configuration all the Enterprise Service Catalog excel files by Division in Siebel Service Catalog default and also by Company/Division/Franchise with business rules.
• Responsible for doing configuration Enterprise Product Catalog and also Campaigns Analysis using IBM Unica tool.
• Developed test sets for Sales Automation process End to End all the required web services and API’s using Soup UI and HP Quality Center and also monitored completed and dropped orders.
• And also reviewed XML message documents reason for dropped order and did analysis in Billing Systems and also Enterprise Service & Product Catalogs.
• Entering Defects in HP Quality Center and review with Test team before sending out to Configuration team and also conduct Weekly Defect Status calls to track all the existing and new defects.
• Northeast and Carolina Merge project for Sales Automation work order analysis, Franchises by rate group analysis and also did configuration in Siebel Call Center Module Service Catalog files by Default and also exceptions configured by Company/Division/Franchise with business rules.
• Responsible for reviewing issues logs and do more analysis in ICOMS Billing system ex: Service code not available in Rate group, Install Protect Service Codes, Price mismatch errors, Service code does not meet the requirement and also One time charges requirements and also reviewing SOM (Sales Order Management XML Strings. And also closely work with other team members and also other sales automation support application team members.

Environment: AS/400 iSeries, RPG, CL Commands, DB2 Database, Windows XP, Microsoft Office, Sales Order Management, HP Quality Center, SOUP UI, SharePoint, Enterprise Service and Product Catalogs.

Confidential, Herndon, VA

Sr. Application Specialist (Configuration/UAT Testing)

Responsibilities:

• Configure and Maintain the Confidential environment and also Revenue Reconciliation with Divisions.
• Setup Company, Division, GL Majors and GL Minors.
• Setup Franchise Master and assign GL Minors and Rate Master Grouping code.
• Responsible for configure Tax Types and Tax Grouping Codes
• Responsible for configure TAR Codes and assign Tax Groups and Tax Types to the TAR Codes.
• Responsible for configure Tax Rates for all TAR Codes and all the Tax Types, Amount Capping, Line Capping and Tax on Taxes.
• Responsible for configure System Parameters Service Codes and Rater Master and also other required System Parameters.
• Maintained Customer Information Management, House Maintenance, Order Management, Product Management (Promotions, Campaigns) and Services Maintenance, Taxes Maintenance by product category by GEO Codes.
• Developed and maintained Campaigns and Offers Analysis using IBM Unica tool.
• Coordinate with CloseTabs for Order Processing and Revenue Reconciliation using Hoback Report.
• Performed functional testing provisioning, Tax Rates and also verify the end user Billing and Statements.
• ICOMS Jwalk GUI Web Based application Billing system testing.
• Testing API’s in between CLOSETABS & SALESFORCE.com provisioning Systems and Confidential ICOMS Billing System. Fixed API Errors in Close Tabs & Salesforce.com and Confidential ICOMS Billing System.
• Entering Defects HP Quality Center and review with Test team before sending out to Developers and also conduct Weekly Defect Status calls to track all the existing and new defects.
• Run nightly and Billing in NBCUAT Billing system and verified End user statements.
• Write MACRO’s to upload data in to ICOMS Billing System tables configuration.
• Run AS/400 Queries using SQL and CL Commands WRKQRY, STRSQL, STRPDM, DSPLF etc., for reviewing the Data from the Tables.
• Extract files from AS/400 system to PC through AS/400 iSeries Navigator or FTP.

Environment: AS/400 iSeries, RPG, CL Commands, DB2, BBGUI-Jwalk/Seagull, Windows XP, Microsoft Office, HP Quality Center, Close Tabs, Sales Force.

Confidential, Herndon, VA

Application Requirements Analyst/Sr. QA Analyst

Responsibilities:

• Gathering Provisioning Transaction Manager (PTM) related standard requirements for the Digital Phone Service and VoIP.
• Manage PTM Requirements Data value spreadsheets for the Client to support Digital Phone Service and VoIP. Create PTM Migration, Extracts and reports process document.
• Configure all the System Parameters for PTM and create XML scripts.
• Maintain auto generated XML scripts and co-ordinate to XML strings mapping to OMSe System.
• Configuration Provisioning Transaction Manager (PTM) Interfaces Setup and X-references.
• PTM Outbound
• PTM Inbound
• PTM Splitter
• ICOMS PWS (Parallel Working Staging) Requirements for Digital Phone Service.
• Create PWS FTP Launch Guide for prerequisites document, Pre and Post release activities.
• Helping (Flow Through Provisioning) FTP-PWS to OMSe Mapping Translation cross reference.
• Review ICOMS and ESB Derivation Rules.
• Analyze and document issues, challenges and opportunities associated with business, testing process and related system activities. Document and/or develop process flows.
• Identify, document and communicate opportunities for improvement both from a manual operations and system perspective.
• Work with various organizational units that are responsible for end user teams.
• Review and give input to schedule and sequence of testing activities for appropriate projects. Review Test Strategy and master Test Plans for appropriate projects in the work program.
• Review the Functional and Non-Functional specifications which are to be included in the project/release.
• Interface with development and maintenance teams. Research leading QA practices, methodology, and technology and determine and utilize automation technology and processes.
• Facilitates complex group meetings and conducts information gathering sessions.
• Resolves conflicts/issues and escalates others as appropriate.
• Testing Interface response status through Order Entry functionality, work order auto update and Equipment Status.
• Coordinated User Acceptance Testing. Reviewing Use Cases for processing.
• Support OSS/BSS Provisioning and Activations. Support OSS (Operations Support Systems) Provisioning and Activations.
• Testing on a Telephony/Cable/HSD/VoIP order entry and Billing Application.
• Entering Defects in Test Director and review with Test team before sending out to Developers and also conduct Weekly Defect Status calls to track all the existing and new defects.
• Extract the files from AS/400 box through AS/400 iSeries Navigator.
• Backend Testing Run Queries using SQL and CL Commands WRKQRY, STRSQL, STRPDM, DSPLF etc., for reviewing the Data from the Tables and export files from AS/400 using iSeries Navigator.

Environment: AS400 iSeries, RPG, CL Commands, DB2, BBGUI-Jwalk/Seagull, Windows XP, Microsoft Office, Test Director 8.x

Confidential, Atlanta, GA

Sr. Applications Specialist/Sr. QA Analyst

Responsibilities:

• I am responsible for Manual/Automated Conversions Mapping from CSG and Cable Data (AMDOCS-DDP & DDPF) Files to ICOMS files field to field.
• Conduct Mapping Franchise Master, House Master, Equipment Master, Service Codes Cable/Telephone/HSD and VoIP (Rate Master), Package Codes, Rate Matrix, Campaigns, Bill Cycles, AR Adjustment Codes, Tax Types, Tax Rates, Customer Type and Categories, Development Master, Residential, Commercial and Bulk Customers, VIP Codes, Work order Related files and also Look up Tables in System Parameter tables and also Support Backlog Go Live.
• Data Analysis and Conversion Mapping for Customer Information Management, House Maintenance, Order Management, Product Management (Promotions, Campaigns) and Services Maintenance, Equipment Warehouse Maintenance, Taxes Maintenance by product category by GEO Codes and Customers Billing Cycles.
• Balance all the reports Houses Homes Passed, Equipments, A/R totals, and also Customers.
• Automated conversions using ICOMS Keys (Example Keys CF, 04, 10, 51, 13, 29, 17, 12, 01 and also Control file Maintenance mapping from CSG and DST(Amdocs DDF&DDPF) to ICOMS each and every Corp and Sys Prins and also keying in Keys.
• Analyze all the related documents for System Configuration Master Files Co/Div/Fran, GL Major/Minor, Campaigns, Rate Master, System Parameters, Taxes, Developments, Item Master and Service Codes for Cable/Telephone/HSD and VoIP.
• Supporting Adelphia Conversions and Standardization & Merge projects.
• Support Audit Testing and Quality Assurance Testing.
• Backend Testing Run Queries using SQL and CL Commands WRKQRY, STRSQL, STRPDM, DSPLF etc., for reviewing the Data from the Tables.
• Extract the files from AS/400 box through AS/400 iSeries Navigator.
• Testing Production System Master File parameters, Campaigns, Rate master, Taxes and system Parameters values through Order Entry.
• Analyze Managed Network Inventory Management (NIM), which maintains the TN Inventory, Rate Centers, and Switch Facilities for Client.
• Analyze all the System files before process the Conversion programs.

Environment: AS400 iSeries, RPG, CL Commands, DB2, IBM Mainframe, BBGUI - Jwalk/Seagull, Windows XP, MS Office, Access Database, Test Director 8.x.

Confidential, Atlanta, GA

Business Analyst/Sr. QA Analyst

Responsibilities:

• I am responsible for ICOMS Toll Rating, PPV Order Entry, and Service Location BA documents. And also created functional checklist and functional Analysis documents for Service Configuration, Customer Management, and Account Management.
• Maintained all ICOMS @CM/CI Functions/Options functionality and Inclusions/Exclusions Analysis Document.
• Created ICOMSUI documents for User Experience fields (Required, Prompt, default Values, Filter/Search and Initial Sorting) for PPV Order Entry, Service Configuration, Account Management, and Service Location to do ICOMS UI to INFINYS UI’s Gap Analysis.
• Analyzed existing System (ICOMS) to create Functional Analysis Document and Functional Checklist using ICOMS documentation 6.1, 6.1.1, and 7.1.
• Reviewed Wireless Billing support Functional Analysis Documents and Functional Checklist with Corporate SMEs.
• Perform the Gap Analysis with existing system (ICOMS) functionality to new system functional requirements (INFINYS Client/Server Application) and prepared GAP Analysis Documents.
• Gaps from ICOMS functionality and INFINYS requirements maintained in SharePoint.
• Reviewed INFINYS RBM (Client/Server) Requirements Business Analysis Documents BA Acceptance Review, Scope Review with Confidential SME’s, Internal Review with COX SME’s and documented the issues in SharePoint and issues spreadsheet submit to the Confidential .
• After received Issues responses spreadsheet from Confidential Joint Review with Confidential SME’s and Cox SME’s review all the open issues that submitted to Confidential and wait for revised Business Analysis Document.
• Revised BA Document reviewed and makes sure all the existing ICOMS Functionalities met in the Infinys RBM BA final document than approved Final BA documents.
• Testing Infinys RBM Web based Billing System Phase I and ICOMS 7.1. Upgrade.
• Reviewed RBM (Rating and Billing Manager) configuration with ICOMS Toll Rating Module comparison documents and did GAP Analysis.
• Backend Testing Run Queries using SQL and CL Commands from AS/400 Command line.
• Extract the files from AS/400 box through AS/400 iSeries Navigator. And also connect AS/400 Environment through iSeries.
• Support BSS/OSS (Operations Support Systems) Provisioning and Activations. Support OSS (Operations Support Systems) Provisioning and Activations.
• Performed functional testing on a Telephony/Cable/HSD/VoIP order entry and Billing Application.
• Analyze and document issues, challenges and opportunities associated with business, testing process and related system activities. Document and/or develop process flows.
• Identify, document and communicate opportunities for improvement both from a manual operations and system perspective.
• Work with various organizational units that are responsible for end user teams. Organizational change management, methods and procedures, project/program management, and systems development.
• Review and give input to schedule and sequence of testing activities for appropriate projects.
• Review the Functional and Non-Functional specifications which are to be included in the project/release.
• Facilitates complex group meetings and conducts information gathering sessions.

Environment: AS400 iSeries, Infinys RBM, RPG, CL Commands, DB2, BBGUI-Jwalk/Seagull, Windows 2000, MS Office, Oracle RAC, Java, J2EE, Unix, Linux, Test Director 8.x.