Design Data Model and develop EDW structure.Collect business requirements and define business transformation rules which are scalable and flexible for change to integrate in EDW.Develop or modify business logic as per business requirement.Develop optimized ETL/ELT Data Pipelines. Develop stored procedures by addressing performance issues.

Develop, implement and maintain Oracle database objects such as tables, views, procedures, and functions.Perform basic ODI(Oracle Data Integrator) work, including ETL (Extract, Transform, Load).Integrate various sources from various platforms.Collaborate closely with customer to gather requirement, understand business needs, and share high level solution.Plan from development to deployment.Unix shell script writing & reviewing, performance tuning of OS & DBBuild report, dashboard in OBIEE, Qlik SenseEnsure capability development and skill backup with the help of available organization tools and frameworkManage clients, resolve conflict and ensure expectation within boundaries.

Receive business requirement from client and keep tracker.Prepare a high level solution with estimated efforts to complete the development.Plan from development to deployment and assign resource.PL/SQL programming, Unix shell script writing & reviewing, performance tuning of OS & DB, new source integration to systemBuild package, scenario, interface in Oracle Data Indicator.Build report, dashboard in OBIEE.Ensure capability development and skill backup with help of available organization tools and frameworkManage clients, resolve conflict and ensure expectation within boundaries.

Conduct daily maintenance, monitoring, performance analysis, trouble shooting and problem resolution of ETL processes.Collect, transform, and load data from multiple systems.Optimize performance, identify bottlenecks and manage resources.

Revenue assurance control designing developing.Monitoring of RA control like MSC Vs SCP. MSC vs SMSC. SCP vs RARE.RA control gap analysis and take necessary actions.Handset Champaign analysis, bonus disbursement calculation and verification. 789 Health line data analysis, revenue sharing calculation, verification and approval.Source data decoding on demand basisCDR testing when new system is incorporated or any change in system.Different Revenue sharing report verification.Ad-hoc support for fraud management.

Network service (activation & after sales) and payment process Quality Check based on end-to-end process/control matrix, front-end (billing system) vs. backend data/service reconciliation to reduce error; KPI analysis & follow-up in terms quality, speed, dependability, flexibility & cost, the 5-factors.Service process documentation and process flow mapping and charting. Explore scope of improvement. Idea workshop organization and facilitation.