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 SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential

Oracle Developer

Responsibilities:

• 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

Confidential

Oracle Developer

Responsibilities:

• Worked Extensively for Current -Gen (Arterra) to Next- Confidential 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

Confidential

Oracle Developer

Responsibilities:

• 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