Data Analyst

Resume

Sreedhar Chemidthi

** ****** **, *** **, Maple shade, New Jersey 08054

Phone: 720-***-**** Email: ************@*****.***

Work Summary:

Around 12 years of experience in Telecom domain ranging from Telecom ordering, provisioning, activation, Billing and EBI Reporting for Cable & Wireless Business

Headed test team as a test lead with good strategy to attain the project goal and earned the reputation of customers qualitatively and quantitatively

As part of Agile process – involved in Sprint grooming/ planning/Scrum meetings/Retrospective meetings

Implemented and involved in whole Software Testing life cycle (STLC)

Experience in gathering and documenting system requirements

Well versed with UML diagrams – Sequence diagrams/flow charts & State Transition diagrams

Extensive experience in analyzing the Business Requirement Documents, Functional Specifications and Technical Specifications

Preparing and maintaining Requirement Traceability Matrix

Involved in Creating Test strategy, test plans, test summary report, test cases and test scripts

Hadoop Jobs deployment to Hadoop environment from GitHub plus job execution and Log analysis

Well versed with Process control verifications

Experience in writing Hive Queries for analyzing data in Hive Warehouse-Data Quality checks & SCD verifications between source (Data Lake: INT) & targets (Data Lake: Stage & Base)

Experience in Sqoop for transferring data from Relational data base (Oracle) to Hadoop

Views creation in Hadoop Data lake environment for viewing JSON CLOB data by using built in functions: Hive-JSON SerDe / Json_tuple/ get_json_object along with applying rules on data columns

Experience in validating tables with Partitions, bucketing and Loading data into HIVE tables

Publishing & subscribing messages using Kafka

Continuous data streaming analysis by using Kafka streaming process and spark framework

Good Unix Experience at command level

Experience in Scala w.r.t creating data frames and querying using Spark SQL

Well versed with Data Warehouse/ETL & BI concepts

Data model & data elements mapping Reviews with data modelers

Informatica & Pentaho Jobs deployment, execution and log analysis

Data ingestion and verifications as per requirements from various source systems: Tera- data, Mongo DB, file systems (.txt, csv) to target data bases Oracle

Flat files ->txt, CSV conversion to EDI -856 files format and ingestion to Landing & Transaction tables by validating the EDI data against rule (MIS) & process engines

Metric calculations on the target data for business reporting

Tableau reports validations against the views on which reports are generated

Experience in testing Rest API’s/ Stateless API’s

SOA implementation with Partner product ordering gateway application for catering the telecom sales via vendors

Experience in validating the migration of existing web services to micro services

SOA automation by using the Parasoft SOA tool features

Familiar with API Documentation tool – Swagger

Well versed with XML & JSON formats

Automation of ETL tests for pentaho jobs by using Python, Gherkins and BDD framework

Continuous integration (CI) / Continuous Development (CD) with Jenkins

E2E Order journey testing for telecom SMB & Enterprise business by using Salesforce CRM integrating with Inhouse and COTS products

PCI – DSS compliance testing

Production deployment support as per the Roaster plan

Trained and mentored the project members on Domain and applications knowledge across geographies – offshore/near shore & onshore

Daily test Metrics with stakeholders plus quarterly presentations with Directors and Sr. managers

Technical Skill set

Technology

Manual Test

Area: Functional

Validation Test: Sanity, Integration, System, System integration testing, Regression Test, E2E, Business acceptance testing and SQL Test

Verification Test: Static Testing

Non-Functional: Usability, Accessibility and Security Test

Back end: Data base – SQL Test, Logs and XML validation, Order migrations

Test Management Tool: ALM 11, Bugzilla 3.2.2, Rally

Database Tools: SQL Developer and Toad

Screen Emulators: Power Term, Putty

CRM test

Sales force CRM, Uniface (Legacy inbuilt CRM tool), Amdocs CRM

SOA Test

Parasoft SOA, SOAP UI, Postman

ETL Test

Informatica 9.6.1 (PowerCenter Client), Pentaho, Informatica DV

Big data Test

HDFS, Hive, Map Reduce, Spark, Scala, Sqoop, Impala, Kafka, Zookeeper

Quoting tools

Pricing & Promotion Management (IVIS), Configure Price Quote (IBM-Sterling)

Database

Oracle 11g, Teradata, MongoDB, Bigdata

Languages

SQL, VB Script, Python

Version control tools

GIT & GITHUB

Build /Integration Tools

Jenkins, GIT

Test Management tools

HP ALM, Jira, Rally

Operating Systems

Windows, Unix

Clients:

Working for Comcast Cable communications from Dec 2012 to till date

Worked for Qwest Telecommunications (Now Century Link) from Oct 2010 to Nov 2012

Worked for Carphone warehouse – Telecom retailer for Mar 2008 to Sep 2010

1 - Working for the Comcast Cable communications of US from Dec 2012 – Till date.

Projects worked -

Project: NextGen Xfinity Mobile Data Management Jan 2019 – Till date

Description: Working as Data Analyst for Xfinity Mobile Data Management projects which provides EBI reports related to Xfinity Mobile business to various stakeholders for business analytics & decisions

Major Areas Worked –

EBI reporting for various features w.r.t Comcast Wireless business for consumers – XMBI/Business Operations/EBI/Device Team

Kafka streaming testing for near real time reporting for customer behavior analytics

Flat files ->txt, CSV conversion to EDI -856 files format and ingestion to Landing & Transaction tables

Tableau reports validations against the views on which reports are created

Project: Arcadia Next-Gen Biller Jan 2018 – Dec 2019

Description: Next-Gen billing Platform caters the wide variety needs of Comcast Xfinity mobile business Ranging from - customer management, order management, quoting, Inventory management, customer communications, service delivery, activations, billing, collections, fault/Case management.

Major Areas Worked –

Worked Extensively for Current -Gen (Arterra) to Next-Gen Biller migration starting - for strategy document write up to till product goes live

Scenarios write up and execution

Interaction with various stakeholders for defect triaging and resolutions

Dress Rehearsals & Employee trail migrations

Around 100 Rest API’s are tested during Next-Gen Platform product testing.

Test scripts design and execution for Stateless API’s

Project: Bulk Order Manager Feb 2017 – Dec 2017

Description: Project is aimed for swapping Legacy devices with programs: MPEG4, X1, Cable Modems/EMTA, Netflix, IHEART and Youtube. BOM also provides orchestration and automation of Drop ship orders.

Major areas worked –

Verification of BOM Micro Services interaction with various Consumers (MY Account, EBIF/TVX, IVR, X1APP, DOTCOM, CAE’s)

BOM services interaction with Upstream system Campaign manager to confirm the swap eligibility

BOM Micro Services interaction with downstream systems like - Order Management System, Billers (CSG/DDP) & Fulfillment system’s

Environment /Configuration setup/Querying in MONGO DB

Messages Log’s validation from Kibana

Kafka Message Queueing validations

Project: National Data Ware House Feb 2016 – Jan 2017

Description: Working as Data Analyst for National Data warehouse which is designed to create a single holistic, comprehensive, detailed data solution that leverages the enterprise data warehousing platform - Teradata.

Major areas worked –

Worked on the Spartan Platform for providing the Data Quality

Worked on data Quality check at all levels - Basic, Basic+, Enhanced

Metrics Calculation and Threshold setup

Reporting and Communication

Project: Business Services (salesforce CRM, CPQ, Workbench & Century) Dec 2012 – Jan 2016

Description: worked on this entire application stack which handles Presales to Post sale’s activity for Comcast cable business for Residential, SMB & Enterprise Customers.

For SMB - Salesforce CPQ Workbench Singleview

For Enterprise: Salesforce CPQ Century Singleview

Major areas worked -

Handling E2E ordering - Presales to Post sale’s activity for Comcast cable business for Residential, SMB & Enterprise Customers

Document generation & validations

Credit check validations

Task management as a part of pre-ordering for enterprise customers

Business class & hospitality vertical order management & service delivery for Data, Video and voice

SIP & PRI Trunking

BCV to BVE/BCT Partial & Full migrations

MACD’s & SUPP’s

CRCP implementation

SFDC and Workbench integrations

2 – Worked for the Century Link (Qwest Communications) from Oct 2010 to Nov 2012

Partner product Ordering: Worked on SOA implementation by performing webservice testing to facilitate the customer providing services in the business area of fixed Phone line, broad bands with high speed technologies, satellite TV through a tie up with Direct TV. Providing TV connection through internet, called as IPTV through partners

Major areas worked -

Introduction of high-speed tiers with pair bonding on listed technologies – ADSL2 & VDSL2

Introduction on IPTV on high speed tiers

Payment testing based on R scores for different markets

Order detail & status verification

Extranet GUI verification

Reports testing

Order flow verifications in Downstream systems

3 – Worked for Carphone Warehouse telecom retailer of UK from Mar 2008 to Sep 2010

Point of Integrated Sale Environment (P.I.E): Worked for a major telecom retailer in UK which is a one stop shop for all telecom related products which sells telecom services to customers through wide variety of channels retail, online and indirect channels

Major areas worked -

E2E ordering for customer purchased services through various channels

IVIS pricing and promotion tool kit integration with PIE

Offers, promotions and discounts

Retentions of customers through Trade In’s

Payment gate way testing from postilion to Commidea payment gateway

Domain Knowledge

Telecom ordering

Telecom provisioning & Activation

Telecom Billing – Single view

Qualifications

Bachelor of Engineering in Electrical & Electronics Engineering from JNTU University

Contact this candidate