Solution Architect Big data & Analytics
Telenor
مجموع سنوات الخبرة :9 years, 9 أشهر
Telenor Pakistan is one of the top Telecom working globally and locally and said to be a market leader in technology and digitization. Working as Solution architect \[Expert\] my roles and responsibilities include:
o Design and implementation of architecture of Analytics Ecosystem.
o Modeling the requirement in Communication data model and Digital data model
o Designing & Implementing Data Pipelines for data lake and EDW.
o Coordinating with business and stakeholders for requirement gathering and documenting
o Designing System architecture as per best practices
o Reviewing the change request and implementation.
o Functional and technical documentation
o Leading teams with vendor coordination
o Areas: Data Engineering | Big data | Contextual marketing | Data Science | Analytics
o Performance, optimization, Scoping and Capacity planning
o Telenor Group Analytics initiatives & strategies
o Developed data wrangling, data pipelines, data control & profiling processes
o Analyze current processes & technologies, contributing in integration of new solutions.
o Document functional & non-functional user requirements and specifications.
o Design new business processes, capabilities and supporting technologies.
o Design on-premises & cloud-based solutions for Data Lake & warehouse.
o Big data Technologies - Cloudera stack | Horton works stack |Spark streaming /batch |Hadoop |
Map Reduce | Hive | Ozzie | Mahout | Flume | Zookeeper | HBase | Cassandra | Sqoop | Kafka | Hue |
Catalog | Solr | Atlas | Kerberos| sentry |ranger|Avro/Orc/parquet | Impala | Spark SQL \[ Not limited
to these\]
Part of Analytics (pvt) Ltd as Business Intelligence and Data integration Team Lead was actively involved in end to end
implementation of Data warehouse integration, Business intelligence implementation and Big data Hadoop implementation in Financial and insurance sector.
Major Responsibilities:
o Managed, developed, and support the organization's EDW and BI projects.
o Capture ETL/BI Requirements.
o Involved in information and dimensional data modeling.
o Developed Functional and technical documentation.
o Involved in developing Business intelligence and ETL architectures.
o Leading Data Warehouse (DWH), Business Intelligence (BI) projects for the company’s clients.
o Designed the processes to meet service level agreements for data timeliness and frequency.
o Determine data growth trends and peak business periods.
o Developing reports/dashboards based on the requirements of the functional units.
o Developed and unit tested information /semantic layers, reports, and GUIs.
o Define BI application requirements.
o Responsible to provide database programming and data integration support using SQL.
o Involved in development of different integration and reporting tools.
o Responsible to work on Data Warehouse EDW and Business Intelligence (BI) projects and POC
for the company’s clients
Tools and Technologies:
o IBM Stack utilities and skills
o IBM Data stage 9.x, Talend Data integration studio 6.x
o IBM Cognos 10.x and 11.x and Microsoft power BI
o IBM DB2 10.x and Vertica 6.x and 7.x
o Erwin data modeler
o Insurance and Banking (financial) Industry data model
Part of Augmantec Software Solution UAE Data integration/Big Data team as Data Integration/Bigdata consultant was
actively involved in end to end implementation of data warehouse integration projects and Bigdata Hadoop implementation in telecom sector.
Client Engagement:
1. OOREDOO - Oman Telecom largest wireline/wireless Telecom of country
o E-Top-Up Sourcing, testing and Deployment
o Cell Site Sourcing, testing and deployment
o Discounts Sourcing
o National Day Offer Sourcing till CDM level
o Revenue Assurance and Recon for year end
o Optimization of ETL transformation and Informatica jobs
o Big Data Hadoop project (Mechanism to move cold Data movement from Teradata to Hadoop)
Tools and Technologies:
o Teradata utilities and skills
o Teradata Data Integration Approach for communication industry
o Teradata (12.x, 13.x, 14.x 15.x)
o Informatica 8.x, 9.x and 10.x Design, development, testing and upgrade
o SLJM Unix based development environment (Design and development)
o Big Data Hadoop (Apache utensils - Scoop, Tdch, ambari, hive-sql, yarn)
Part of Teradata Data integration team as Data Integration consultant was actively involved in end to end implementation of
data warehouse integration projects in mainly telecom sector.
Client Engagement:
1. PTCL ( Etisalat Subsidiary) Second largest wireline/wireless Telecom of country
o Green Field Implementation of EDW/BI (sourcing of OCS, RMS, Mediation, Settlement, Seibel)
o Biometric Verification and Third-party commissions (change requests)
o Forklift Data Mart Sourcing to EDW and development of pilot Analytical Data storage (ADS)
o Golden Gate (Change Data Capture) Sourcing for Maximo and Siebel (CRM) to EDW
2. UFONE PTML PAKISTAN (Third largest wireless Telecom of country)
o Sourcing of Converged Billing system (CBS) From Scratch and integration to existing EDW
o Sourcing of Sales and Distribution (SND) and integration to existing EDW
o Change Request regarding Optimization and hurdles/problems of Informatica
3. Mobilink(JAZZ) PAKISTAN First largest wireless Telecom of country
o Testing of Informatica ETL development and KPI matching of MFS project
4. Telenor PAKISTAN Second largest wireless Telecom of country
o Commission management system(CMS) sourcing to existing EDW
o Data Migration using data mover and DBA Activities
Tools and Technologies:
o Teradata utilities and skills (Bteq, Tpump, fast exports, Mload, Fload, Data mover, DBA activities, Etl scripting, Query Grid, sql, TD Administrator, SQL Assistant, Viewpoint, Teradata Statistics Manager, Teradata Parallel Transporter, Teradata data miner)
o CDM and SDM design and development
o End to end implementation of Teradata Data integration projects
o Teradata (12.x, 13.x, 14.x 15.x)
o Informatica 8.x, 9.x and 10.x Design, development, testing and upgrade
o SLJM Unix based development environment (Design and development)