Senior Software Engineer ( Granite , Data Warehouse , ETL , ODI )
Ericsson (STC Granite Inventory)
Total years of experience :15 years, 2 Months
• STC Granite Inventory Project (from 1/5/2016 Until Now)
o Working as Senior Software Developer with ADM Team.
o Owned the design and development of many modules in OSS integration and fulfillment solution as part of STC ADM project to fully manage/support Customer enterprise needs, services, systems and technology management.
o Using mainly tools based on Ericsson portfolio (Granite Inventory, Granite APIs) along with Java SE, J2EE, Maven and Spring.
• STC Granite Inventory Reconciliation and Data Cleansing Project
o Analyzing and processing large volumes of data.
o Performing reconciliation and validation routines across all deliverables.
o Implementing data cleansing and standardization across the system.
o Developing and implementing data analytic processes and procedures.
o Providing data analysis and insight generation.
o Extract reports for match and mismatch services, work orders, customers and services status between Ericsson Granite system and ICMS IBM system using oracle PL SQl.
o Develop tools to migrate the missing data and clean the wrong data using JAVA (MAVEN, JAVA SE, Spring).
• MCS project for Data Warehouse and Business Intelligence Reports
o Working as Senior Data Warehouse developer and ODI Consultant.
o Working as Senior Integrated system Engineer.
o Responsible for designing, developing, and maintaining data warehouse and analytics architecture to meet an enterprise’s business analysis and reporting needs.
o Gather of business requirements and creating architectural designs.
o Design, Develop, and support new and current ETL processes employing industry standards and best practices to enhance loading of data from and into different source/ target systems.
o Analyze, modify, and create ETLs, testing, debugging, integration and implementation processes.
o Document technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.
o Using the ODI tool as ETL tool to extract, transform and load the data from source system to DWH.
o Ensure data quality throughout entire ETL process
o Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked
o Design and implement ETL processes and data architecture to ensure proper functioning of analytics lad, as well as client’s or third-party’s reporting environments and dashboard.
o Carry out monitoring, tuning, and database performance analysis.
o Perform the design and extension of data marts, meta data, and data models.
o Ensure all data warehouse architecture codes are maintained in a version control system.
o Consolidate and optimize available data warehouse infrastructure.
o Conceive analytics and business intelligence platform architecture for clients, including internal and third-party clients.
o Develop and implement ETL routines according to the DWH design and architecture.
o Develop ETL code, metadata definitions and models, queries and reports, schedules, work processes and maintenance procedures.
o Deliver Support OBIEE
o Build physical, Business, Presentation Layer using BI Administration Tool.
o Building BI Reports
- Working on Data migration activities from legacy systems (physical and logical network systems) at Ooredoo into Ericsson's Network Engineer and Ericsson's Granite inventory.
- I'm responsible for making the migration approach and architect how to obtain the data, what's needed for migration and to lead the teams to make the migration to Granite 7.3 from various sources and systems.
- I serve as team leader for multiple items of the inventory in the migration and as a consultant for other teams with respect to any issue with their inventory items
- Integrating physical inventory (Network Engineer) with logical inventory (Granite) with Ericsson's IIEP .
- Building new interfaces that interacts with other systems at Ooredoo for service provisioning.
- I was working as design engineer to make and add modification in the drawings to make as built on site.
- I was working as site engineer to follow the technicians during install the cables and the equipments and hand over the systems to the client.
- I was working as developer engineer to make some programing and configurations during install the software for the systems.
- The Entertainment solutions systems (Home Automation systems ) that worked out are the following :
Home Theater (Yamaha, Arcam…)
Audio Distribution (Arcam, Russound….)
MATV
LAN - WIFI
Lighting Control (LiteTouch, Centralite…)
Security Systems (Cytech…)
Pronto systems (Touch screens to control all systems )
Crestron systems (Touch screens to control all systems )