Information Technology Business Intelligence

NASIM AHMED

********@*****.*** +1-469-***-****

PROFESSIONAL SUMMARY

Business Analytics & Data analytics professional with 8 years of experience in Information Technology and a wide range of progressive experience in providing product specifications, design, analysis, development, documentation, testing and implementation of the BI solutions using IBM Cognos, Tableau and Power BI.

•Well versed with a knowledge of RDBMS, data warehouse i.e., OLTP & OLAP systems.

•Strong experience in creating and publishing packages in Framework Manager.

•Well-versed in developing reporting applications using Cognos Business Intelligence components like Report Studio, Framework Manager, Query Studio, Analysis Studio, Workspace, WS Advanced and Cognos Connection.

•Strong complex reporting skills – complex Drill-Through, Discontinuous Crosstabs, Summary Reports, Schedule and Burst Reports.

•Used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.

Experienced in developing Dashboards and Stories in Cognos Analytics.

Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.

Strong knowledge in SQL (SQL Server, Oracle and DB2) programing language ( R )

Client Duration Industry

Project

USXPRESS

NEW CENNY,

Tx

Jul 2022 – current

Transport &

distribution

services provided through foreign affiliates established abroad. This indicator is measured in USD transaction and transport, postal and courier, and distribution, environmental for imports and net trade.

Trading - Worked for back office/middle office/ front office, compliance, gas supply, QA metrics, ODS, ad hoc reporting efforts for its trading and supply business.

LNG

Houston, Tx

Nov 2020 –

May 2022

Trading

Analyst

Phillips66,

Houston, TX

Feb 2019 -

Apr 2020

Oil & Gas

(Downstream m)

Energy

Marketing - Worked for P66's marketing department's discount tool reporting effort. This was combining transactional data to refinery's data and public data to get an ultimate discount tool for the marketing department when negotiating deals with fuel distributors.

Dominion

Resources,

Richmond, VA

Sep 2016 -

Dec 2018

Utilities

Dominion Delivery, Transmission & Reliability - This Client is a

Utility Provider in Virginia, North Carolina, Ohio, Pennsylvania, and West Virginia. There are various BI efforts like work management, asset resource management, electric reliability, gas delivery &

transmission, retail, etc. engineered, developed & deployed efficient BI solutions for these projects

Hyatt Hotels,

Chicago, IL

Apr 2014 -

Jul 2016

Hospitality

EMS - Event Management System at Hyatt manages corporate and group multi-day events. EMS Cognos application sends out various reports to different departments in different Hyatt properties & franchises related to their daily events.

Cognos Framework Manager – Have working knowledge of -

Creating data sources from one or more sources Modelling.

Database layer – baseline data objects (tables/views/SPs), joins, cardinalities.

Business Layer – Complex business logics, additional joins, aggregations (if any), Complex Joins, Joins after aggregations, Order of Joins, Filters, order of filters, etc.

Presentation Layer

Granularity – Joins at different granular level, higher level joins either using modelling or using determinants.

Multi database joins, database processing & local processing, etc.

Report Studio/Cognos Analytics – extensively worked with or have working knowledge of

Different Reports lists/crosstabs/visualizations/combinations/dashboards/active reports/etc.

Calculations/filters/aggregations/prompts/cascaded prompts, etc. and use of functions/macros/etc.

Queries/joins/set operations.

Layouts and formatting, conditional formatting, conditional variables, layout

Transformer – Worked with or have working knowledge of - Cubes, data sources (IQDs, FM query subjects) Dimensions, facts, Levels, Manual Categories, etc.

Query Studio/Workspace/Workspace Advanced/Analysis Studio –

Extensively worked with or have working knowledge of -

Ad-hoc reporting, Analyses, slicing & dicing, filters, conditional formatting, etc. Dashboard, Reports.

Cognos Connection/Analytics – Extensively worked with or have working.

knowledge of Security at folder level, package level, report level, report view level, etc. Reports, report views, shortcuts, saving prompts on views, versions, report outputs Scheduling and distribution, bursting, jobs, etc.

Power BI / Data Analyst

Designed and built dashboards for use in monitoring performance metrics while maintaining existing dashboards for accuracy and efficiency and incorporating changes using power BI. A decade of expertise as a data scientist, Data analyst, Power BI professional is undoubtedly valuable. However, it is crucial to effectively demonstrate your depth of knowledge and experience in business intelligence. This demonstration is pivotal as it determines your eligibility for an interview opportunity.

To present yourself effectively, you have undertaken and the positive impacts you have had for both the users and the company.

Tableau Developer/Data Analyst

•Designed and built dashboards for use in monitoring performance metrics while maintaining existing dashboards for accuracy and efficiency and incorporating changes using Tableau.

•Used advanced chart visualizations in Tableau—such as dual axis, box plots, bullet graphs, tree maps, bubble charts, and waterfall charts—to solve complex problems and to create interactive dashboards and visualizations.

•Served as a Tableau Liaison to mentor our team on all Tableau best-practices while supporting other developers specifically in data-source identification.

•Developed and reviewed simultaneous SQL queries in Tableau Desktop to validate both static and dynamic data for data validation.

SQL-

SQL skills help data experts maintain, create and retrieve information from relational databases, which separate data into columns and rows. It also allows them to access, update, manipulate, insert and modify data efficiently.

TECHNICAL SKILLS

Business Intelligence Data analytics Tool: Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos, Tableau and Power BI

Connection), Framework Manager, Cognos Impromptu, Powerplay Transformer,

Databases: MSSQL Server 2008/12/16, Oracle 9g-12g, MS Access, DB2

DB Tools: SSMS, SQL Developer, SQL (SQL Server, Oracle and DB2) programing language (R) Operating Systems: Windows 95/98/XP/NT, UNIX (Solaris, Linux)

EDUCATION:

Bachelor of Accounts/Commerce

University of Karachi, Pakistan

Certificate: Data Analytics (Google Certificate)

Contact this candidate