Mohammed Yahya Sarayi

Cognos, Tableau & Power BI Developer

adqxzr@r.postjobfree.com

469-***-****

https://www.linkedin.com/in/mohammed-sarayi-b577506a/

https://public.tableau.com/profile/mohammed.sarayi#!/

Professional Summary:

●12 years of experience in Cognos development, Cognos BI - Created, modeled, and published packages in Framework Manager from multiple databases for use with Report Studio, Query Studio and Analysis Studios. Report Authoring using Cognos 11, 10.2.2 10.1 8.4 8.3, 8.2 Suite, Cognos Series 8.0 and Cognos Report Studio, Query Studio and Analysis Studio.

Experience creating executive level dashboards, analytics, and reports using advanced visualization.

●4 years of experience in Tableau Development and Data Visualization. Extensive experience in developing, maintaining, and managing Tableau driven dashboards & analytics. Experienced in Tableau administration/architecture. Hands on data reporting with large data sets. Experience in building visual reports, dashboards and KPI scorecards. Expert creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps Tree maps, etc.

●3 years of experience in Power BI. Set context and design data models to transform raw data into meaningful insights. Create dashboards and interactive visual reports using Power BI. Experience in working with Power BI datasets and modeling. Identify key performance indicators (KPIs) with clear objectives and consistently monitor those. Analyzing data and present data through reports that aid decision-making. Convert business requirements into technical specifications and decide timeline. Design, develop, test, and deploy Power BI scripts. Perform DAX queries and functions in Power BI.

●Industry domain experience in Finance, Marketing, Retail, Chemical, Insurance and Sales.

●Strong Analytical skills, Detail Oriented and ability to multi-task.

Professional Experience

LANGSTON UNIVERSITY

Cognos/Programmer Analyst May 2021 Current

Design, create and modify reports in Report Studio.

Assists the Office of the Vice President for research, Strategically analyzing electronic research administration data to visualize trends in research funding, partnerships and impact.

Developed complex reports related to Student enrollment and Instructors Subjects report.

Gather reporting requirements and develop reports to meet the specifications based the business requirements.

Environment: COGNOS 10.1 SQL Server 2008, ODS, Oracle 10g.

US BANK ST PAUL MN Sep 2019-Jan 2020

Cognos Developer

Involved in designing and creating various reports in Report Studio related to Zelle’s account.

Customized data by adding filters at Report level. Worked with cross-functional teams and ensured finishing the tasks and achieving project deadlines. Experience in Design, Development & Build activities in Cognos Suite of Products. Hands-on development mentality, with a willingness to troubleshoot and solve complex problems.

Worked with cross-functional teams across regions to ensure increased efficiency and accuracy in reporting and data.

Environment: Cognos 11.01

INPAX, Dallas TX Nov 2016- Sep 2019

Cognos Developer/Tableau Developer/Power BI

Responsibilities:

Tableau Developer, Power Bi Desktop Data Visualization, working with various databases that include Oracle, SQL Server Databases. Microsoft Azure Data Explorer, Power BI Cloud direct queries, and Dax expressions.

Worked on Framework manager, and Reports created as a delivery package for the drivers.

Expert creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps Tree maps, etc.

In-depth experience with Microsoft Business Intelligence Suite. Maintenance and support Framework Manager Created, modelled, and published packages in Framework Manager. Involved in designing and creating various reports in Report Studio.

Environment: Microsoft SQL Server 2005, Oracle 10g, Oracle 11g/12c, Cognos 11, 10.2.

IBM, New Orleans, LA Jul 2016-Nov 2016

Sr. Cognos Report Developer

Responsibilities:

Involved in designing and creating various reports in Report Studio.

Cognos 10.1Creating/updating Relational Model and publishing packages using Framework Manager

Created reports like List, Cross tab and Dashboards.

Developed, maintained, and supported Cognos Reports, Data Visualization.

Environment: Cognos 10.1 Oracle 10g.

LEIDOS, New Orleans, LA May 2015 – May 2016

Cognos Report Developer

Responsibilities:

Involved in designing and creating various reports in Report Studio.

Cognos Report Studio, Query Studio and Analysis Studio.

Cognos experts in the upgrade of Data net, IBM Cognos 10.0

Experience in Design, Development & Build activities in Cognos Suite of Products.

Customized data by adding Calculations filters at Report level.

Create a security filter and apply it to a specific query subject.

Environment: Microsoft SQL Server 2005, Oracle 10g/12c, Cognos 10.1

AIG, Fort Worth, TX Feb 2015 – Apr 2015

Cognos Developer/ Tableau Developer/ Business Analyst

Responsibilities:

Worked on Cognos 10 and built new Cognos features increasing confidence with business users.

Design and implementation of BI reports and dashboards using Cognos.

Created daily, weekly, and monthly reports.

Experience in building Complex Reports using prompts and parameters in Report

Created Drill Through reports.

Environment: Seed, UAT, Cognos 10.1, Oracle 10g/12c.

SDLC Partners, Monroeville, PA Dec 2014 – Jan 2015

Cognos Report Developer

Responsibilities:

Created reports like List, Cross tab and Dashboards.

Developed Customizable reports by adding Calculations, filters at Report level.

Conditional Formatting by using Report Studio, Data Visualization.

Environment: Cognos 10.1 SQL Server 2008, DB2, Oracle 10g/12c.

Capital District Physicians’ Health Plan INC, Albany, NY Apr 2013 – Mar 2014

Cognos Developer/Admin

Responsibilities:

Created Drill Through reports and Conditional Formatting by using Report Studio

Created reports like List, Cross tab and Dashboards by using Report Studio

Extensively worked on complex reports, drill through reports, master detail reports, conditional prompts.

Developed Multi Page Reports.

Environment: COGNOS 10.1 SQL Server 2008, DB2, Oracle 10g.

Sun life Financials, Boston, MA May 2011 – Jan 2013

Cognos Developer

Responsibilities:

Created Framework Manager Packages defining the cardinalities and namespaces

Modeled Metadata and add business rules such as filters and calculations.

Developed Dimensional Models for Cognos 8 Analysis Studios.

Defined security over packages, package level access and object level access to allow users to create calculations over the query items.

Developed Prompt pages and Conditional Variables in the report.

Created multipage reports with master-detail relationships, Query Prompts, Calculations, Conditions & Filters.

Environment: Cognos Series 8.0 (Report Studio, Analysis Studio, Framework Manager Query Studio), Oracle 9i, Microsoft SQL Server 2005/2008

Sun Power, Denton, TX Dec 2005 – Feb 2011

PC/Desktop/Network Support Specialist

Responsibilities:

Respond to user support requests in Track-IT.

Maintain PC/Laptops images, maintain hardware, supplies and software inventories.

Setup new employees' hardware, software, access permissions, upgrade and replace old hardware, repair and maintain existing hardware.

Support Windows XP, Vista, Windows TCP/IP networking, minor LAN hardware architecture (link speeds, NIC configuration), PC hardware installations (ie. CD-ROM drives, video cards, RAM Sims etc.) local and network printer installation and configuration and troubleshoot and diagnose issues with all the workstations issues.

Experience utilizing Remote Desktop, Teamviewer 5/6, Ultra NC 1.0.8.2 and Log Mein 4.1.13 to solve hardware and software issues.

Review and make recommendations for standard corporate computing system hardware.

Troubleshoot and identify issues related to application deployment and address them directly or through coordination with other teams.

Virtualization of applications.

Also conditionally formatted reports and reports using set operators.

Create user groups and user roles, assigning capabilities, deploying reports and scheduling reports Helping team in testing of the reports and models.

R.S. Food Mart, Austin, TX Jul 1989 – Oct 2005

Manager

Responsibilities:

Purchasing and Selling Foods, Auto Parts also Managing 13 Employees Inventory Control, Bookkeeping, Banking and also dealing with the Customer.

Also Provides technical support for Desktops/Laptops and associated networks.

Installs, troubleshoots, services and repairs personal computers, network equipment such as servers, modems.

Provides personal computer/Laptops hardware and software support.

Installs services and repairs personal computers and installs attendant software.

Connects personal computers and terminals to existing data networks.

Maintains trouble logs.

Instructs users in the use of personal computers and networks.

Investigates information, network and communications needs of users and makes recommendations regarding software and hardware purchase.

Maintain PC images; maintain hardware, supplies and software inventories.

Setup new employees' hardware, software, access permissions, upgrade and replace old hardware, repair and maintain existing hardware.

National Semiconductor, Sunnyvale, CA Jan 1982 – Feb 1989

Technician

Responsibilities:

Technician in a Fabrication area; wafer aligning and use of chemicals, Computer Programmer.

Education:

Bachelor’s in engineering in mechanical

Technical Skills:

BI Tools: Cognos 8.1/8.2/8.3/8.4/8.4.1 10.1 10.2.1 10.2.2 11. BI (Report Studio, Query Studio,

Analysis Studio, Frame Manager, Metric manager, Cognos Connection), Cognos Series 8

(Impromptu, Power Play, Transformer Upfront)

Tableau 8.0/9.0/10.0

Power BI

Migration Tools: MigS7, MiG Deploy

Operating Systems: Windows 2000/2003/ Vista/ 2008, Windows 7

Software Packages: MS- Office, Microsoft Word, Excel and Power Point vision

Databases: MS SQL Server 2005/ 2008, Oracle 11g/12c, 10g/ 9i/ 8i

Database tools: SQL*Plus 3.3/8.0, PL/SQL Developer Load

Data Modeling: Physical and logical, Star schema, snowflake schema, Normalization

Microsoft SQL Server Reporting Services (MSSQLRS)

Contact this candidate