EXPERIENCE SUMMARY:

• Over 13+ years of IT experience wif good knowledge of Telecom, Energy &Utility and Retail domain.
• Immense experience in Telecom Domain as Telecom BSS & OSS consultant and Telecom Data Analyst.
• Vast knowledge in the area of Database Management Systems and associated tools me.e. Oracle, Cassandra, Erwin Data Modeler, Business Intelligence and Oracle BI-Publisher.
• Hands on experience in Data Modelling, Data Mapping, Data Profiling, Data Analytics, Data Mining, Data Integration, Data Cleansing, Data Loading, Data Transformation, Data Migration and Data Validation.
• Technological forte is Oracle SQL, Cassandra CQL, Erwin Data Modeler tool, Oracle BI Publisher Reporting tool and Unix Commands.
• Immense knowledge in various phases of SDLC such as Requirement, Analysis, Designing, Development, Testing, Deployment, Maintenance, Operational and Support.
• Certified SAFe-4 Agilist and enormous experience in Waterfall methodology.
• Proactive on business/client interaction, requirement gathering, functional and technical designing, functional and non-functional user story writing, source to target data mapping, data modelling, database designing, retrieving and analysing large and complex Data set through SQL queries, MS-Excel Pivot and lookups, request and response XML-XSD creation, KPI Dashboard and other business critical reports.
• 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.
• Immense Experience - in gathering requirements for data lakes, data warehouses and databases related projects wif 360-degree view of Data storage, transformation, mapping and modelling.
• Strong knowledge in machine learning and statistical methods.
• Trained on artificial intelligence, machine learning, and data mining algorithms, statistical methods and programming Language R and Python.
• Strong analytical skills wif the ability to collect, organize, analyse, and disseminate significant amounts of information wif attention to detail and accuracy
• Immense experience on Production Support (L1, L2 and L3), Production Deployment Process and Operational activities improvement and automations.
• Worked on Oracle based Convergys Infinys Rating and Billing(IRB) Telecom Billing Tool and Oracle Customer Care & Billing (CC&B) Utility Tool.
• Excellent practice and experience wif various international and domestic clients from USA, South Africa, Japan and India.

TECHNICAL SKILLS:

Languages: Oracle SQL, Cassandra CQL, PL/SQL

Editor Tool: Toad, DataStex

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

Data Modelling: Erwin Data Modeler 9.64

Reporting Tools: Oracle BI Publisher 11.1

Operating Systems: Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst and Erwin Data Modeler

Responsibilities:

• Client Interaction and business requirement gathering for new functional and Non- functional requirement, enhancement and change request.
• Integrate data from multiple sources to produce requested or required data elements wif the halp of Data mapping and modelling.
• Prepare System requirement documents for Data Layer applications based on the business requirement, Business requirement document and Solution definition document.
• Prepare High-level design document based on the given business requirement, system feasibility and data analysis.
• 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 Source to Target Data Mapping.
• Prepare Conceptual, Logical & Physical Data models covering all the entities using Erwin Data Modeler 9.64.
• Expertise in Erwin Data Modeler tool for ER, Dimensional Data Modelling.
• Work on PL/SQL procedures/packages/triggers; creating and tuning complex SQL
• Request and Response XSD creation using Altova XML Spy and Oracle JDeveloper 11g tool.
• Trained on machine learning, data mining algorithms, statistical methods and programming Language R and Python.
• Exploring Apache Big Data based system like Cassandra and Hive based on POC projects.
• Working knowledge of message queuing, stream processing and highly scalable ‘big data’ data stores.
• Good knowledge on Agile Based projects by using Rally Dev tool/TDP tool along wif waterfall based projects.

Confidential

Application Designer and Developer

Responsibilities:

• Client Interaction and requirement gathering for new requirement, Enhancement, Change Request.
• Manage the entire team (9 members) of CCR-R module.
• 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 wif Production Support team.
• Exploring Big Data based system like Apache Hadoop, Hive and Pig.
• Working on Big Data based system like Apache Hadoop, Hive and Cassandra.
• Good knowledge on Agile Based projects as well.

Confidential

Responsibilities:

• Client Interaction for CR’s, operational issues and billing escalated cases for quick resolution and follow up wif development team.
• Providing all the E2E Telecom functional/Business knowledge to the customers.
• Manage the entire (13 members) billing production support team. (me.e. Order management, Bill Plans, Bill delivery, operational process, WSR, docket resolution).
• Providing Operational support on all the Telecom operational processes like (me.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.

Confidential

Responsibilities:

• dis project is all about Telecom Billing Process.
• To enhancement, implement and customize the Converges developed Geneva Billing System for Corporate Services and automate the Corporate billing and achieve billing efficiency. dis customization process involves from the Customer creation to till Bill Generation.
• We are also performing product configuration, pricing configuration, Customer and Account Maintenance and Bill Generation Process.

Oracle PL/SQL Developer

Responsibilities:

• 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.