SUMMARY

• Over 14+ years of IT experience with good knowledge of Telecom, Energy &Utility and Retail domain and ability to adopt new domain quickly.
• 9+ years of experience in Oracle database and 3+ years of experience in NoSQL Apache Cassandra.
• 5+ years of experience in Data Modeling, Data Visualization and Business Intelligence tools.
• Excellent experience in Oracle (SQL) and Cassandra (CQL) query languages.
• Excellent requirements gathering, written and verbal communication skills, Interpret and analyze data from various source systems to support data mapping, data modelling and data reporting needs.
• Technological forte ; Oracle SQL, Cassandra CQL, ERwin Data Modelling, Tableau for Data Visualization and Reporting, XML & XSD creation using XmlSpy Altova, MS Excel and Basic Unix Commands.
• Current role as ‘Data Analyst’ which includes client interaction, requirement gathering, user story write - up using agile methodology, functional and technical designing, source to target data mapping, logical and physical data modelling using ERwin Data Modeler tool, retrieving and analyzing large and complex data through SQL or CQL, MS-Excel Pivot and lookups, request and response XSD creation using XmlSpy Altova, business critical Reports, Dashboards and Data Visualization using Tableau, validation & verification and troubleshooting of data set in production Env’s using Unix commands, SQL or CQL database queries.
• Hands on experience in Data Modelling, Data Mapping, Data Profiling, Data Loading, Data Analytics, Data Mining, Data Cleansing, Data Visualization, Data Transformation, Data Validation and pivot tables, macros, and vlookups.
• Immense Experience - in gathering requirements for OLTP (i.e. ODS, SOR) and OLAP (i.e. Data Warehouses, Data Mart) related projects with 360-degree view of ‘data’ storage, transformation, movement, mapping, integration and modelling and significant depth of knowledge in Cloud Platform.
• Certified SAFe-4 Agilest (Scaled Agile) and enormous experience in Agile and Waterfall methodology.
• Adaptable to new environments and technologies, self-motivated, quick to learn, goal-oriented, team player, possessing strong interpersonal skills.
• Hands-on experience on large volumes of data to identify trends and provide structure to the data by building data models.
• Working as data steward and responsible for utilizing an organization's data governance processes to ensure fitness of data elements (content and metadata).
• Immense experience on Operational activities, Operational improvement and automations, Deployment Process.
• Immense experience in Telecom Domain as Telecom BSS & OSS consultant and Telecom Data Analyst.
• Worked on Oracle based Convergys Infinys rating and Billing (IRB/Geneva) Telecom Billing Tool and Oracle Customer Care & Billing (CC&B) Utility Tool.
• Excellent practice and experience with various international and domestic clients from USA, South Africa, Japan and India.

TECHNICAL SKILLS

Programming: Oracle SQL, Cassandra CQL

Data Modelling: Erwin Data Modeler 9.64

BI/Data Visualization: Tableau Desktop and Server 2018.3, MS Excel, MS PowerPoint, Oracle BI Publisher 11.1

Editor Tool: Toad Editor for SQL, CQLSH for CQL

Databases: Oracle 9i, 10g and 11g, Apache Cassandra 3.11

Documentation: AgileCraft for User Story and MS-Office Word, Excel, PowerPoint

Operating Systems: Unix/Linux access through MobaXterm or Putty.

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst, Erwin Data Modeler and Data Steward

Responsibilities:

• System Requirement, High Level Designing, User Story write up for Agile and SAFe Agile Projects, Data Mapping, Data Modelling, Data analysis, MIS/BI Reporting, Data Visualization and XML/XSD creation.
• Client Interaction and business requirement gathering for new functional and Non- functional requirement, enhancement and change request.
• Prepare System requirement documents for Data Layer applications based on the business requirement, Business requirement document and Solution definition document.
• Prepare Agile based functional and Non-functional User Stories in TDP/Rally Dev based on the given Business requirement, system feasibility and data analysis.
• Prepare User Stories in AgileCraft as per SAFe Agile provided Features.
• Prepare High-level design document based on the given business requirement, system feasibility and data analysis.
• Translates functional and technical requirements into detailed design.
• Prepare Source to Target Data Mapping.
• Prepare Conceptual, Logical & Physical ER Data models covering all the entities using Erwin Data Modeler 9.64.
• Expertise in Erwin Data Modeler tool for Relational and Dimensional Data Modelling.
• Request and Response XSD creation using Altova XML Spy and Oracle JDeveloper 11g tool.
• Debug PL/SQL procedures/packages/triggers; creating and tuning complex SQL/CQL.
• Ability to query Relational/NoSQL databases using standard SQL/CQL, and to extract, analyze, and reconcile large sums of data.
• Strong understanding of Master data, Operational data, Analytical/BI Data and metadata management, High volume media data analysis and demonstrated experience and knowledge of multi-tier architectures.
• Prepare Business Critical Reports and Dashboards based on Business intelligence tools like Oracle BI Publisher and Tableau.
• Prepare dashboards/reports/graphs/presentations using Tableau.
• Act as a visualization subject matter expert by supporting clients and team members in the use and interpretation of data.
• Exploring Apache Big Data based system like Cassandra and Hive based on POC projects.
• Experience with revision control source code repositories (Git, SVN).

Environment: and Tools: Oracle SQL, Apache Cassandra CQL, Erwin Data Modeler 9.64, Oracle 11g, Oracle JDeveloper 11g, Oracle BI Publisher 11.1, Tableau Desktop and Server, GIT, CodeCloud, SVN, AgileCraft, Rally Dev, IBM TDP.

Confidential

Oracle PL/SQL Application Designer and Developer

Responsibilities:

• Development, Low-Level Designing and Data analysis
• Client Interaction and requirement gathering for new requirement, Enhancement, Change Request.
• Prepare Low-level design document based on the given business requirement, high-level design document, system feasibility and data analysis for waterfall-based Data Layer Applications.
• Changes and Creation of new PL/SQL packages as per business requirement.
• Creating PL/SQL Procedures, Functions and Objects as per the requirement.
• Customizing the existing PL/SQL packages, Procedures, debugging, and bug fixing.
• Writing co-related SQL queries and sub queries and Involved in creating Tables & Views.
• Using advance XMLs function and Bulk Collect concept in the Stored Procedures
• Supporting in Production deployment with Production Support team.
• Exploring Big Data based system like Apache Hadoop and Hive
• Working on Big Data based system like Apache Hadoop, Hive and Cassandra.
• Good knowledge on Agile Based (~Scrum) projects as well.

Environment: Oracle PL/SQL, SQL Oracle 11g, UNIX based Operating System

Confidential

Telecom Billing Production Support and Operational Lead

Responsibilities:

• Oracle Pl/SQL Production Supports (Tier-1+Tier-2+Tier-3) and Training.
• Client Interaction for CR’s, operational issues and billing escalated cases for quick resolution and follow up with development team.
• Providing all the E2E Telecom functional/Business knowledge to the customers.
• Manage the entire (13 members) billing production support team. (I.e. Order management, Bill Plans, Bill delivery, operational process, WSR, docket resolution).
• Providing Operational support on all the Telecom operational processes like (i.e. Rating, Billing, Dunning, Payment loading, Adjustment).
• Responsibility to deliver the bills of 79 SSAs (across west zone) on time.
• Resolving all the issues related to Rating, Billing, Bill formatting and dunning process.
• Functional knowledge of CRM (SAP tool), Clarity (provisioning system), EAI (Integration system), PMS (Payment management system) and Mediation.
• Maintain and Handle all the production servers database, N/wing, users, login security .
• Maintaining the entire project related documents, checklist and other repository.
• Requirement gathering, feasibility check, impact analysis and effort estimate, for new requirements.

Environment: HP-Unix, PL/SQL, SQL Programming Oracle 9i, Convergys IRB 3.0 Telecom Billing Tool, CRM-SAP, CLARITY, EAI

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Development and maintenance
• The implementation and customizations of the Geneva Billing System tools.
• Development and Enhancements: Bill Post Processor (BPP), Batch Data Communications (BDC), Pre Bill-Generator (Pre-BG), Plug-In.
• Client Interaction for CR’s, Enhancements and follow-up for escalated cases.
• Requirement gathering, feasibility check, impact analysis and effort estimate, for new requirements.
• Application Optimization including workflow optimization, code optimization.
• Unit testing and System Integration testing.
• Maintain and Handle all the servers N/wing, users, login security .
• Maintaining the entire project related documents, checklist and other repository.

Environment: HP UNIX, Pro *C, C, SQL, PL/SQL Programming Oracle 9i, Convergys Geneva 5.3.39 Telecom Billing tool (IRB).