Nikita Sharma, Senior Telcom Analyst ad2u9n@r.postjobfree.com +1-678-***-**** Alpharetta, Ga 30004

Career Summary:

Seasoned Sr Analyst with 15 years of experience in Quality Engineering in Telecom Service Provisioning/ Operations Support Systems & Billing/Business Support Systems. Currently working as the lead Billing Analyst for Verizon Wireless RSS Solution suite offering telecom services to Resellers and MVNOs (Mobile Virtual Network Operators), leading teams at onshore, offshore.

Academic & Professional Certifications

Batchelor in Engineering: Electronics & Communication Engineering, Rajasthan University of Technology, India

Techno-Functional Expertise:

Programming Languages/IDE

UNIX Shell, PL-SQL

API/WebServices

SOAP, REST

Database

SQL/Oracle

Build & Deployment Tools

SVN, JENKINS

Testing Tools

Test Harness API Integration, Cruise Control, Selenium IDE, RC, Web Driver, SOAP UI

Requirement Analysis, Defect Tracking, Trouble Ticketing

HP QC/ ALM, Rally, Clear Quest, JIRA, Z Tracker, Remedy UET, QTEST

EAI (Enterprise App Interface)

Mediation Zone

Billing Tools

JITR (Just in time rating) In House billing Tools/PL-SQL packages, Netcracker RBM, AMDOCS OCS, Telegence, ICOMS

TMF – Telecom Functions

OSS [Operations Support System] – Network Management System (NMS- Connect, Netcool), Service Provisioning, Fulfillment, Delivery, Assurance (Fault Management/Trouble Ticketing)

BSS [Business Support System] – Order Entry Engines, Customer Management, Product Catalogue, Rating, Billing, Invoicing, Revenue Management, Care (IVR, IBN, iNAV) Operations

Verizon Wireless: Feb 2019 – Current Lead Billing Analyst, Atlanta Ga

Project: RSS (Resellers Solution Suite)

RSS Suite is the heart of Verizon’s Reseller BSS (Business Support System) - revenue management & billing capabilities (viz usage creation, charging, rating postpaid & prepaid ‘resellers’ & ‘leases’ who leverage Verizon telecom solution for their own service offerings. [Eg: Celcom, Bluegrass, Tracfone, etc. & Verizon Telematics customers]. RSS Billing stack consists of in-house suite of applications leveraging net cracker- RBM tools over a microservice architecture. Verizon has been a forerunner in 5G development, testing and pilot. RSS billing supports 5G billing for IOT / telematics for resellers & lessees.

Responsibilities:

Analyze Functional specs and Develop QA/QE Strategy for reseller and lease billing.

Own Execution, Leadership reporting, triage & Certification.

Manage Offshore Work allocation, team coordination, Peer Review & Audit best practices.

Stakeholder Management (UAT, Business, Development & Leadership).

Core Billing responsibilities:

oDevice and execute scripts (UNIX) for running loader jobs for data (3G, 4G, 5G) and voice records. (TDR/IPDR records)

oRun & manage periodic bill cycles, to generate bill data in QLAB and UAT environments.

oDevice complex SQL queries and PL-SQL scripts for validating data and voice records in different billing DB and tables.

oRevenue management processes such as billing, charging, mediation and rating.

oGeneral Ledger (GL) data transfer to Account Receivable (AR), Account Payable (AP) module.

oBill generation, invoice creation, Draft and approval process before validating final reports (financial).

ousage reports, rating and billing.

oRevenue Reconciliation and support RA (Revenue Assurance) team in UAT validations.

obilling reports to ensure the content matches with DB records based on devised rater and billing rule engine.

Key Deliveries:

oLaunched Authorized user access, data encryption when in transit.

oLaunched Security Capability:

encrypted login when accessing sensitive data with authorization.

application data exposed via SPLUNK are validated per Security requirements

practices around strong password, private key, two factor authentications

practices around strong password, private key, two factor authentication

remove un-used built-in accounts, change default passwords.

data classification practices while storing and exposing data under Internal, Restricted, Confidential labels.

record categories appropriately (PCI, SOX, CPNI)

practice of generating session IDs using secure random number generators (eg CryptGenRandom).

Technology, Tools & Platforms: PL-SQL, Net cracker RBM, Mediation Zone, In house tools, UNIX.

Accomplishment: Recognition & Appreciation from RA team & delivery partners.

Equifax: July 2018 - Nov 2018 Technical Analyst – II, Alpharetta, GA

Project Name: Migration IC to SAAS

Migrate legacy systems from IC platform to SAAS which is more reliable, fast, secure and current technology. It comprised of reverse engineering of existing C code to understand the functionality and rewriting the code in Java and move it to new SAAS platform. Comparison analysis was done by testing the functionality on both old and new platform to ensure system is intact and customers are not impacted by this change.

Responsibilities:

Analyze HLDS, IF specs and SRS to understand the functionality

Create high level to detailed technical scenarios, e2e process flow charts depicting functional order journeys.

Participate in reverse engineering to understand the code and functionality.

Conduct internal, external test strategy review with stakeholders & obtain approvals before test execution.

Perform admin jobs like uploading test cases in JIRA, set up milestones for test reporting on tracking portals.

Coordinate deployment with infra team and perform system integration testing on e2e env.

Extensive backend SQL querying, log searching using Unix, bash, log distiller, log4j, Splunk tools.

Issue replication, drive triages, extensive trouble shoot for identifying issue & open defects in Jira, QC

Participate in sprint planning meetings, daily scrums, release retrospection and prepare lessons learnt, identify best practices.

Perform concurrent API, JSON testing using POSTMAN

Support UAT testing and secure sign off ensuring functionality is working fine.

Environment/Tools: IOS, Android, JIRA, Oracle, Toad, SQL Developer, Java, Unix, SharePoint, SPLUNK, WebLogic, XML, XSD, XML Spy, JSON

Cox Communications: Nov 2017- June 2018 Sr Technical Analyst, Alpharetta, GA

Project Name: BAS E2E Testing

Business Application Services (BAS) does E2E testing of various BSS projects across Cox front end, middleware & backend applications viz Cox.com, ICE, INAV, Solution Center, BIS, ICOMS etc. Worked on Legacy Tiers Over PON(LTOP) project that delivered a solution to increase the utilization of the PON network by enabling additional tiers of service.

Responsibilities:

Analyze BRD to create test packages consisting of test plan, test cases, RTM, test data.

Create high level to detailed technical scenarios, e2e process flow charts depicting functional order journeys.

Conduct internal, external test strategy review with stakeholders & obtain approvals before test execution.

Perform admin jobs like uploading test cases in HP QC, set up milestones for test reporting on tracking portals.

Conduct E2E testing across frontend, middleware & backend.

Use different data acquisition platforms like DASH-TNPM, Netcool TNPM, WebNMS, EMS etc. for data validation & verification.

Use visualization platforms like Plantview, Homeview for data validation.

Test & validate devices like ONT, cable modem, PON, OLT in LAB environment.

Extensive backend SQL querying, log searching using Unix, bash, log distiller, log4j, Splunk tools.

Issue replication, drive triages, extensive trouble shoot for identifying issue & open defects in ALM

Participate in test planning meetings, stand up call, release retrospection and prepare lessons learnt, identify best practices.

Perform mobile device testing on both android and IOS platform

Collect thread dumps, monitoring java null pointer exceptions, identify memory run outs.

Perform boundary value testing, concurrent API testing using SOAP UI, REST & Postman

Maintain, update the risk register, identify risks (opportunities, threats) throughout execution.

Coordinate with UAT teams and obtain sign off for deployment of code to production.

Automate the testing of applications using Java based in house tool.

Configure automation framework, setting class path, defining MQ config over Unix env

Environment/Tools: IOS, Android, JIRA, Oracle, Toad, SQL Developer, Java, Unix, HP ALM, SharePoint, SPLUNK, XML, XSD, XML Spy, JSON, ICOMS, SPLUNK, Netcool, Netcracker tools, MOSAIC etc.

Verizon Wireless May 2015- Aug 2017 Sr QA, Alpharetta, Ga

Project Name: RSS & UB JITR

RSS serves as the provisioning back bone for various resellers like TracFone, Celom, etc. who uses Verizon’s infrastructure for telecom services providing billing solution to the client. UB JITR – Usage broker Just in time rating is a java based broker performing real time rating and credit control for prepaid along with postpaid rating for IPDR (4G) and TDR (3G) data and call rating. Netcracker RBM, Digital Route’s Mediation Zone, in house Java & PLSQL package-based Usage Broker and inhouse billing systems contribute towards the overall billing eco system.

Responsibilities:

Analyze HLDS, IF specs and SRS to create test packages consisting of test plan, test cases, RTM, test data.

Create high level to detailed technical scenarios, e2e process flow charts depicting functional order journeys.

Conduct internal, external test strategy review with stakeholders & obtain approvals before test execution.

Deploy java codes on WebLogic servers in test env. & execute functional testing with java based simulation.

Coordinate deployment with infra team and perform system integration testing on e2e env using real apps.

Extensive backend SQL querying, log searching using Unix, bash, log distiller, log4j, Splunk tools.

Issue replication, drive triages, extensive trouble shoot for identifying issue & open defects in Jira, QC

Participate in sprint planning meetings, daily scrums, release retrospection and prepare lessons learnt, identify best practices.

Perform mobile device testing on both android and IOS platform to do functional, UI testing.

Conduct performance testing by injecting big load of provisioning orders using java based in house tool.

Record performance test data and consolidate graphs with varying java memory/heap size, GC / YG memory parameters.

Collect thread dumps, monitoring java null pointer exceptions, identify memory run outs.

Preparing results of the run, monitor trends, performance gains and work closely with performance architects.

Perform boundary value testing, concurrent API testing using SOAP UI & REST

Configure & setup environment, JMS, create test data, conduct e2e testing, system integration testing

Automating the testing of applications using Java based in house tool & Selenium JUnit

Create automation framework, setting class path, defining MQ config over Unix env

Devise shell scripts for automated deployment and server bounce.

Environment/Tools: IOS, Android, JIRA, Mediation Zone, RBM, Netcracker, Oracle, Toad, SQL Developer, Java, Unix, HP ALM, SharePoint, SPLUNK, WebLogic, XML, XSD, XML Spy, JSON, Junit, TestNG, Selenium

AT&T April 2012-March 2015 Sr Technical Analyst, Atlanta, Ga

Project Name: BNS

OPUS is the backbone ATT Retail Stores provisioning running on desktops and hand-held devices like iPad, iPhone. Customer Queue management, KIOSKs for customer self-service, mobile apps for customer account info – applications fall in the BNS umbrella.

Responsibilities:

Create test strategy for functional projects conducting internal, external reviews to finalize test plan.

Create requirement traceability matrix [RTM] for ensuring 100% test: requirement coverage.

Upload test cases in HPQC, monitor test reporting, daily defect and test status reporting & issue escalation.

Conduct functional, system integration testing on e2e for voice, data, video to completion.

Ensure code meets acceptance, done criteria during product for getting approval from product owner.

Execute mobile device testing (functional, mobile UI content) on IOS & android for the mobile apps.

Perform exhaustive testing of KIOSK and attached peripheral devices like cash register, printer, scanner

Validate and test test OS patches, migration of application from Solaris to HP Servers.

Review UI mock ups with the UI design, end client, UAT, product owner.

Extensive back end data validation and order status tracking via SQL queries and shell scripts.

Test plan/execution, defect lodging/track/fixing using Use Microsoft Test Manager, JIRA, CQ, WebTrax.

Execute running automated in QTP for regression.

Develop shell scripts for log extraction and backend and housekeeping.

Writing simple, complex SQL queries for user profile management, DB flags, store set up, order tracking etc.

Create Test Summary & Closure Reports, release retrospection – lessons learnt & best practices.

Executive & detailed report on test progress, risks, escalation for leadership and team.

Provide mid-day turnover and next day warm hand-off to the offshore team

Environment/Tools: Android, IOS, JAVA, J2EE, UNIX, XML, SOAP-UI, Oracle, TOAD, SQL, Windows XP, UNIX, HP Quality Center, JIRA, Splunk, Webtrax, Load Runner, SharePoint, Rally, Microsoft Test Manager.

British Telecom Dec2009–Feb 2012 Technical Analyst, Pune, India

Project Name: BT Retail Hub/ OFS Development

Retail HUB sits at the core of BTs Operational Support System (OSS) which has the business intelligence for the Order Provisioning for Lead to Cash Journey viz PSTN, Broadband, Mobility etc. It is a Business-Critical project handling over 60k orders in production a Day. It had multiples EAIs and in-house Applications built inside it supporting the business logic built on a SOA Architecture.

Responsibilities:

Prepare test plan for different Lines of Businesses viz PSTN, Broadband, Mobility.

Test case management, execution, defect tracking, reporting using HPQC, JIRA

Create web testing test Cases using SOAP- XMLs & perform web testing using TH, SOAP-UI.

Prepare test environment, install java ear files on WebLogic servers, set up configurations and test the code.

Define MQ Managers, create MQs and configure them for each functionality / line of business.

Perform server bounce, adjust the java memory sizes of servers during bounce per interface specs.

Develop shell/bash scripts for automated deployments, post deployment configurations etc.

Extensive back end testing using test harness tool, SQL scripting, Unix commands.

Identify defects, raised defects in QC tool with supportive steps, evidences, actual, expected results.

Monitoring e2e testing and provide application devOps support by acting as a second line of support.

Analysis of e2e issues, classify, prioritize, replicate them and cascade to back end development team for fix.

Create Test Summary Report & obtain “Sign Off” from UAT for production deployment.

Mentor new members of team in alignment with project processes, know how & On-Boarding Activities.

Responsible for onshore: offshore coordination, hand off

Environment/Tools: Sun Solaris, IBM Web sphere MQ, Oracle Web logic, Java, J2EE, Win XP, IE 6, Mozilla Firefox, Test Harness, HP Quality Centre, PR Tool, JIRA

Contact this candidate