We provide IT Staff Augmentation Services!

Oracle Developer Resume

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

Hire Now