MOHAMMAD GUFFRAN
*******.********@*****.*** UAE: +971-*********
Sr. System Analyst(Oracle sql, pl/sql, Tableau, CRM Application support)
Professional Summary
Having more than 10 years IT Experience on Telecom/Internet/Fixed lines/webhosting/emails/website domains/Satellite Channels.
Strong oracle SQL skills with good knowledge of RDBMS concepts
Expertise in write complex SQL queries,Pl/sql blocks
Experience in Business Intelligence technologies along with around 3 years of data visualization using Tableau.
Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
Hands on experience on Tableau Desktop versions 2019, Tableau Public, Tableau Reader and Tableau Online.
Experience in Tableau with oracle SQL connectivity.
Produced attractive visuals/dashboards to convey the story inside the data.
Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
Involved in trouble shooting of performance issues which were associated with Tableau reports.
Experience in filters and calculation attributes.
Experience in RPA (Robotic process automation)
Good knowledge on python programming.
Worked on application support in L2 level which is most important for correction in production environments.
Experience on UAT and documention
Good understanding of business environment, excellent communication skill and ability to work proactively in a fast paced environment.
TECHNICAL SKILLS:
BI Tools : Tableau Desktop 2019
Environment : Windows10,CRM,COMS,MS DOS
Database : Oracle 9i/11g,
Language : HTML, SQL,RPA, Python, Machine Learning, Artificial Intelligence,MS Office
Other tools: IBM Clear quest, TOAD, PL/SQL Developer, PyCharm,HP Open view, HP Service Manager,Putty,SSH
Current Work Summary:
Company: Omnix International LLC
Client : Etisalat Telecommunications, Abu Dhabi, UAE
Role: Sr. System Analyst/Tableau Developer
Responsibilities
Understand the Requirements and Functionality of the application from specifications.
Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
Converted existing BO reports to tableau dashboards
Created different KPI using calculated key figures and parameters
Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
Developing and implementing the solutions, addressing the business requirement changes using SQL and PL/SQL Scripts.
Logging, prioritizing and resolving incidents, and track them against various SLAs.
Resolving recurring incidents permanently, performing break fixes and implementing preventative action items.
Manage and support high-availability 24/7 production systems with an on-call rotation.
Research, develop, and deploy automation scripts and tools to improve the teams overall efficiency
Work History
Sr. System Analyst 06/2017 to Current
Omnix International LLC
Client: Etisalat Telecommunications, Abu Dhabi, UAE
Sr. Application Administrator 05/2013 to 05/2017
Etisalat Software Solutions (P) Ltd (Technologia)
Client: Etisalat Telecommunications, Abu Dhabi, UAE
Application Support Consultant 04/2012 to 04/2013
Abudhabi & Gulf computers LLC – Abudhabi, UAE
Client: Etisalat Telecommunications, Abu Dhabi, UAE
Sr. Implementation & Support Engineer 04/2007 to 04/2012
MagnaQuest Technologies (P) Ltd – INDIA
EDUCATION HISTORY
Graduation in B.Sc Computer Science,Statistics,Mathematics, ANDHRA UNIVERSITY, INDIA.
Post Graduation in M.Sc Mathematcs (Distance education), S.V UNIVERSITY, INDIA.