BigData Consultant
LigaData
Total years of experience :16 years, 6 Months
LIGADATA /USA
APR 2014 TILL DATE
BUSINESS INTELLIGENCE CONSULTANT
Main Environment: Hadoop
System analyst and Technical Lead - MTN south africa
System analyst and Technical Lead - MTN Auganda
Big Data Technical Lead - MTN Ghana/Nigeria
Big Data Consultant - Barclays Bank London /Northampton
Responsibilities:
• Plan and analyse complex business requirements and implement technology enabled solutions to address multidiscipline business opportunities/problems,
• Conduct planning, analysis and design activities in conjunction with other development specialists.
• Participate in analysis of complex business opportunities/problems to deliver designs meeting requirements.
• Participate in estimation of tasks and assist in the development of project plans.
• Code or makes modifications to programs of high complexity, according to specifications.
• Conduct walkthroughs and quality review of deliverables.
• Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces.
• Provide guidance and mentoring on business intelligence technology and systems in general, especially in the area of ETL processes under Hadoop Env
• Participate in the formulation of standards to support the data acquisition development process.
• Design, develop and execute complex data acquisition, routines using ETL tool, ensuring that business and technical requirements are met.
• Ensure compliance with established policies, standards and methodologies
• Provided design recommendations and thought leadership to sponsors/stakeholders that improved review processes and resolved technical problems
• Tuning the sparks jobs in production Environment
ZAIN JORDAN
JULY 2013- APRIL 2014
Main Environment: Oracle
Data Warehouse - Technical Lead /Business Intelligence CONSULTANT
Responsibilities:
• Provide leadership to members of the development team
• Provided design recommendations and thought leadership to sponsors/stakeholders that improved review processes and resolved technical problems
• Analyzed the data mapping and developed scenarios to verify the data migration from different data sources from Zain database to BSCS
• Interface with client on various ongoing and new projects
• Make sure projects are timely delivered
• Write and design new ETL processes to handle BSCS cases and logic .
• Document the technical and system specifications documents for all ETL processes and perform unit tests on all processes
• Prepare the UNIX programs and scripts for ETL processes
• Coordinate with the ETL team for the implementation of all ETL procedures and maintain existing procedures
• Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers
• Perform various tests and validate all data flows
• Prepare all ETL processes according to business requirements and incorporate all business requirements into design specifications
• Develop data warehouse models and prepare reports for all meta data integration into systems
• Carry out scheduling of necessary ETL processes and prepare documents for all data flow diagrams.
• Ensure that ETL codes delivered are running, conforms to specifications and design guidelines.
• Unit testing of all ETL codes to ensure they can be delivered and run in a system testing environment
• Raise technical issues that may impact on the timeline to the Bi Manager
Build data warehouse solution for new BSCS system
Provided design recommendations and thought leadership to sponsors/stakeholders that
improved review processes and resolved technical problems
Defined Check constraints, Business Rules, Indexes, and Views
Design and implement ETL solutions.
Design and build data staging and summary(aggregated) area
A business facing role which require continuous interaction with business users for
Requirement gathering.
Understanding the data structure and meaning in both the source and the target systems and
obtaining complete knowledge of the physical database schema and identifying new
integration requirements.
Prepared & consolidated monthly Post-paid and Pre-paid Revenue reports and related data.
Prepared & consolidated monthly Roaming Reports
Developed ad-hoc reports for management to measure the Performance for specific
promotions and products
Plays key role in design and prepare documentation for all sources integration and LDM
changes
Mange ETL migration project
Analyzed the data mapping and developed scenarios to verify the data migration from
different data sources from Zain database to BSCS
In collaboration with other team members, analyzed raw data to ensure the data will meet
the business need. Worked with the business owner to identify key data elements that will be
monitored on an on-going basis to ensure a high level of data quality within the data
Warehouse
Responsible for the building of test plans, strategy and procedures throughout the life cycle
of a project from technical and business requirements through to user acceptance.
Wrote test case scripts; executed and documented detailed results and summary reports
Executed systems and data quality testing to ensure all development deliverables are
production ready.
Responsible for in-house development project to migrate current DWH sources.
Design and implement ETL solutions.
Design and build data staging and summary(aggregated) area
Perform Data visualization techniques like dashboards, scorecards using OBIEE
Tuning the Sql query for DWH projects
Developed Sql packages, function and procedure
Developed layout solution using oracle form builder
oracle developer
supurt report form for mor than 10 insurance company in jordan
training orcl SQL, PLSQL, FORM
67%