MA

Mohammad Alkoni

available

Last update: 06.09.2022

Sr. Consultant, Lead Developer, Analyst Programmer

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Limited professional)

Attachments

mohammadalkoni_businessintelligence.doc

Skills

Qlik Sense, Qlikview, Tableau, IBM Cognos, Power BI, Data, RDBMS Oracle, SQL server, Teradata, Cognos Framework, SAP, Qlik Sense/Qlikview, Qlik Sense administration, XLS, CSV files, database, Qlik, Qlik NPrinting, Qlik APIs, Extensions, ODAG, Qlik Geoanalytics, Java Script, HTML, CSS, SDLC, Excel, Oracle, binary QVW, Inline & .txt files, data sources, Pivot tables, Trend graphs, Bar graphs, Stacked Graphs, tables, implement two Tier Architecture, SET analysis, Mapping Load, ApplyMap, What-If, Geospatial, ArcGIS Map, Cylindrical gauge, Text, DAX queries, Tableau Server, Tableau Desktop, various versions, Tableau 9, Cognos 8, Query Studio, Report Studio, models & Created package using FM, IBM COGNOS Suite, Cognos 10, SAP BO, ETL, Informatica, Pervasive Data Integrator, BODI, Data Modeling Framework Manager, Powerplay Transformer, SQL, Oracle 9i/10g, JIRA, TFS and QC, Windows 7/8/XP/10, Microsoft Suite, Power Apps, Microsoft Office, Visio, SQL databases, script, UAT, Analytics, data modeling, GCC, Cognos, test case, RDD, metadata, Bug fixing, backups, mobile phone, network connection, Cognos 8.3, Oracle 9i, Windows XP, BI tool, Data warehouse, ETL tool, OLAP, Cognos ETL, telecommunication, Cognos 7, Cognos 8 reports

Project history

01/2021 - 01/2021
Sr. Consultant

GCC Reporting Project

Client Name : GCC
Project : BPO Analytics
Project Duration : Jun 2014 - Jun 2015
Standard Role : Sr. Consultant

Project & Role Description:

GCC Reporting project is built to provide cross engagement reporting through the use of a single
technology platform. GCC reporting dashboard enables delivery of internal BPO reports to senior
management. GCC Dashboard will show performance of engagements against internal KPI metrics
specified as part of ongoing Zafiro change program, it provides centralized, standardized
mechanism for recording, storing and displaying KPIs.

* Understanding business requirement and enhancement of Cognos 10 reports.
* Monitoring performance in Production.
* Writing Script for testing those report by running SQL query in SQL Server.
* Refreshing Dev. reports for different towers, processes & levels.
* Updating technical design document.
* Creating FM Design document & uploading in Team Forge.
* Deployment of Cognos package & reports to production environment.

06/2014 - 10/2015
Sr. Consultant
Capgemini


11/2013 - 05/2014
Lead Developer
Talentain Technologies


02/2012 - 10/2013
Sr. Developer
LMA Implementation

LMA Implementation

Client Name : Travelers, US
Project : Claims
Project Duration : Feb 2012 - Oct 2013
Standard Role : Sr. Developer


Project & Role Description:

Travelers are the largest American Insurance company by market value. It is also the third largest
writer of U.S. Commercial property casualty providing a broad range of insurance products including
workers' compensation, integrated disability, property, liability, specialty lines, surety bonds,
inland/ocean marine, and boiler and machinery. They are assisting Travelers with the Business
Intelligence Report Development work in the Legal Matter Application Program with the goal of
developing and implementing a new application for management of legal matters by the Claim Staff
Counsel.
Travelers, to become high performers by BI analysis and promoting their insurance business in better
way. Used to get functional specification for the Cognos report from onsite coordinator and
analyzing the specification, asking for the clarification & resolution if needed and then creating
reports for the business users.

* Understanding business requirement, preparing technical design and test case.
* Analyzing HLD, RDD document and designing report specification.
* Preparing metadata layer and framework manager development,
* Creating package and publishing it in Cognos connection.
* Design and development of simple and complex Cognos reports.
* Testing reports and mocking-up business view data in Teradata.
* Bug fixing, scheduling and delivering business reports to end users.
* Interacting with Client and status reporting to offshore/onshore manager.

11/2010 - 10/2013
Analyst Programmer
Accenture


08/2011 - 01/2012
Analyst Programmer
VQA Implementation

VQA Implementation

Client Name : Mattel, US
Project : PLM
Project Duration : Aug 2011 - Jan 2012
Standard Role : Analyst Programmer

Project & Role Description:

Mattel, Inc. US is the world's largest toy company, based on revenue. It produces Barbie dolls, Hot
Wheels and Matchbox cars, American Girl dolls, board games etc. Mattel became popular with the
introduction of Barbie in 1959. Toy manufacturers produce and distribute most of our toys. They also
research and develop new toys and buy or license toy inventions from inventors.
We are providing BI service to customer which helps them to improve execution of the existing toy
business; globalize the brands; extend the brands; catch new trends; and develop people by doing
business analysis to promote their business in their areas. Its primary mission is to analyze
business data in order to run their business in a better way.

* Understanding business requirement, preparing technical design n test case.
* Preparing metadata layer and framework manager development,
* Creating package and publishing it in Cognos connection.
* Design and development of Cognos reports (simple and complex).
* Developed Master detail, drill through and rank reports by using report studio.
* Bug fixing, scheduling and delivering business reports to end users.
* Deployment of Cognos package & reports to test and production environment.
* Created Daily backups by using Congo's Connection
* Reviewed the reports developed by other team members.
* Created HTML Items, packages, templates and reusable components.

Health-Care Management System

Client : Pfizer, US
Project : Pfizer BI ASM
Project Duration : Dec 2010 - Aug 2011

Project & Role Description:

Pfizer, US is a life science project for one of the largest health-care system in the world which
involves in extending lives and enhancing the well-being of individuals throughout the world. Life
science enables clients to become high performers by BI analysis and promoting their health-care
business in better way. Used to get functional specification for the report from onsite coordinator
and then analyzing specification, asking for the clarification & resolution if needed & then
creating reports for business users and supporting and enhancement of MSTR application as well.

* Understanding business requirement, preparing technical design & test cases.
* Analyzing HLD, RDD document and designing report specification.
* Preparing metadata layer and framework manager development.
* Creating package and publishing it in Cognos connection.
* Design and development of Cognos reports (simple and complex).
* Testing reports and mocking-up business view data in Teradata.
* Bug fixing, scheduling and delivering business reports to end users.
* Deployment of Cognos package & reports to test and production environment.
* Interacting with Client and status reporting to offshore/onshore manager.

06/2009 - 11/2010
Team Lead
Hewlett-Packard


07/2006 - 06/2009
Software Developer
Wipro Technologies


Local Availability

Only available in these countries: United Kingdom
Profileimage by Mohammad Alkoni Sr. Consultant, Lead Developer, Analyst Programmer from Sr. Consultant, Lead Developer, Analyst Programmer
Register