Tableau Developer Computer Programmer
Resume:
Mohammed Yahya Sarayi
Cognos, Tableau & Power BI Developer
********@*****.***
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