Sr Data Modeler/Data Analyst Resume

SUMMARY:

Proficient experience in Data Modeling methodologies, data management, data analysis, data mapping and data profiling, managing the modeling process from conceptualization to logical model and then produce physical models.
Highly experienced in Telecommunication and ERP industries.
Excellent understanding of business operations and analytics tools for TEMPeffective analysis of data.

TECHNICAL SKILLS:

Excellent working noledge of: Teradata SQL assistant and Teradata Administrator tools Experienced PL SQL, Python, R, ETL tools( Data Stage), Teraminer

PROFESSIONAL EXPERIENCE:

Sr Data Modeler/Data Analyst

Confidential

Responsibilities:

Interpreted Ericsson data charging platform and developed revenue reports for Data products.
Participated in creating the model for integrating Ericson Data system (CS5 version) in Data Warehouse using Teradata Logical Model for Telecom Industry and Erwin tool.
Managed complete integration of Ericsson CS3 and CS5 flows into Data Warehouse starting from gathering business requirements, building models, providing assistance in ETL processes till delivery.
Participated in implementing Churn Prediction model leading to reducing churners by 20%.
Built reports for SIM Card acquisition and activation processesleading to minimizing discrepancy within different platforms and increasing sales.
Implemented the model for integration of Siebel modules within Data Warehouse.
Build set of routine reports for Siebel customer data, campaigns and loyalty modules for reducing campaign costs and building customized and targeted campaigns.
Extracted and Modeled Mobinil Sales Distribution system which includes the acquisition module and the accounting module using Erwin and PL SQL and supervised its integration process within Data Warehouse.
Participated in availing Ericsson CS5 new business features and formats in the Data Warehouse; delivered the customization needed in EMM flow and mapping documents for both logical data model and reporting layer using Teradata LDM and Erwin.
Extracted data and developed data quality checks for Ferma databases source using PL SQL and TOAD.
Analyzed Mobinil solution documents during swap of Ferma to Ericsson charging system, delivered mapping documents for both CLDM and BI layers.
Participated in implementing Teradata model while revamping DWH from Oracle to Teradata;

ETL developer

Confidential

Responsibilities:

Developed jobs for loading Roaming traffic into Data warehouse using Datastage.
Developed jobs for loading Prepaid billing traffic into Data warehouse using Datastage.

Senior Programmer

Confidential

Responsibilities:

Developed and maintained modules for library database using PowerBuilder 7. Examples include: cataloging module, search module, Marc and Z39 modules.
Participated in development of assets software systems.
Developed new features such as report generator, Interface modifier using PowerBuilder 7

Senior Programmer

Confidential

Responsibilities:

Analyzed the requirements needed by Siro Misr Factory and developed Production Planning, Material Planning, Product Costing, Sales and Inventory modules using PowerBuilder 7
Worked as a consultant in the Development Office in “American University in Cairo” to maintain their Fund Raising Program and created reports including all Donors' data, this reporting tool is implemented in all offices in Egypt and New York City.
Analyzed the requirements needed and developed Sales, Purchase, Inventory and Item Packing modules of “Archi Touch Company” for office furniture using Power - builder 6.5.
Built all the modules of “New Cairo City” company including the Geographical module, sales module and structural module.
Participated in Automation of the departments of “Fremier Brokerage Company” for insurance and reinsurance services using PowerBuilder 7

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship