MUHAMMAD FAROOQ
Chicago,IL
Summary
Business Intelligence and Data Analytics expert with 10+ years of experience in reporting, data analysis, data warehousing, data visualization, and business systems analysis. Proficient in writing complex SQL queries and developing database objects, demonstrating a strong grasp of data warehousing concepts. Skilled at analyzing requirements and enhancing reports to meet business needs. Experienced in creating mapping documents for object migration. Strong communicator and team player, adept at managing multiple tasks and meeting deadlines in dynamic environments. Excellent problem-solving skills and proactive approach to teamwork.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Business Systems and Data Analyst
Bayer Crop Science
03.2021 - Current
- Developed visually appealing dashboards and data visualizations in Tableau Desktop and Power BI using a range of chart options like heat maps,residual plots,bars graph, choropleth map,funnel plot,and donut chart.
- Applied various Tableau and Power BI functionalities such as calculated fields, sets, bins, groups, parameters actions, action filters, Level of Details (LOD), and DAX functions like FILTER SUM CALCULATE ALL SUMX DISTINCT.
- Implemented diverse filtering techniques such as quick filtering, data source filtering, context filtering, and extract filtering
- Scheduled data refreshes on Tableau Server to ensure the dashboards displayed updated data
- Implemented row-level security and user filters to restrict data access for specific users
- Published reports in Power BI service, managed Gateway, set up scheduler refresh to dashboards, and implemented row-level security to restrict data when end-users accessed the reports
- Created reports and dashboards to track executive-level sales trends, both past and present, as well as forecasting.
- Utilized a range of date and time functions (such as YTD, YOY, MTD, MOM, DateDiff, and DateAdd) to generate reports
- Developed and enhanced database objects including tables, views, partitions, materialized views, stored procedures, packages, triggers, cursors, and indexes using SQL/PL-SQL to align with business needs
- Developed and executed dynamic SQL queries using Execute Immediate statements
- Extensively utilized the import/export feature to generate ad-hoc reports, retrieving data from multiple tables and exporting it in CSV/Excel format.
- Enhanced performance by optimizing SQL queries
- Utilized joins, sub-queries, CTE queries, inner queries, filters, decode and case statements to achieve desired outcomes and enhance data transformation for business needs
- Performed data reconciliation and validation across multiple systems to ensure accurate data population.
- Performed unit testing in accordance with requirements and documented test results following thorough verification.
- Created mapping documents for migrating objects from Teradata to BigQuery, ensuring accurate and efficient data transitions.
Data Analyst
DB Schenker
07.2018 - 03.2021
- Utilized Tableau Desktop and Power BI to design and create visually appealing data visualizations, analytical reports, and dashboards that aided analysis and strategic planning efforts
- Analyzed user requirements, validated data, and proposed dashboard design
- With expertise in data blending and customized SQL queries, efficiently extracted and manipulated data to fulfill diverse requirements for reporting purposes.
- Utilized various Tableau reporting features including hierarchy, drill down and up, grouping, calculated fields, filters, ranking, parameters, graphs, forecasting, trend analysis, sets, action filters, custom color pallets, and statistical analysis to fulfill business needs
- Modeling, cleaning, and preparing data in Tableau through understanding of data warehouse structure
- Scheduled regular data refreshes for accurate display of updated data on Tableau Server views and dashboards.
- Utilized various chart types, including Dual axis, bar, Stacked Bar, Pie and Donut charts, Tree Maps, Heat Maps, and Scatter Plots to visually present data to executives.
- Generated on-demand reports for management/users
- Used Snowflake connection to pull data from into Tableau to create data visualizations
- Wrote SQL queries for data validation
- Produced monthly reports using advanced Excel spreadsheet functions.
Business Intelligence Developer
CVS Pharmacy
01.2016 - 06.2018
- Created and presented data visualizations using Tableau and Power BI, utilizing thorough data analysis for executive leadership
- Utilized a range of data visualizations charts including histograms, box plots, pie charts, and scatter plots to visually convey the impact on potential revenue and publish them to the repository
- Utilized SQL queries with joins and filters to extract data for analysis
- Utilized DBeaver to effectively query data from Amazon Redshift.
- Utilized various Tableau features including filters, groups, sets, hierarchy, calculated fields, forecasting, data blending and relationships.
- Published workbooks and data sources to the Tableau server
- Maintained accuracy of displayed data on views and dashboards by scheduling data refreshes on Tableau Server
- Utilized DAX functions such as FILTER, SUMX, CALCULATE and more to develop efficient calculated columns and measures.
- Generated various charts and comprehensive reports by utilizing conditional formatting and data segmentation
- Developed reports incorporating various time intelligence metrics such as YTD, MTD, SPLY, YOY, and MOM.
- Enhanced user experience by creating optimized workspace and content packs enabling business users to effortlessly navigate through developed reports
- Implemented LOD functions including fixed, Include, and Exclude to showcase diverse granularities comprising region, State, and stores
- Managed Gateway and set up scheduler refresh to dashboards while also implementing row-level security for restricted data access.
Education
Masters in Commerce - Accounting And Business/Management
University of Karachi
Karachi05.2011
Bachelors in Commerce - Accounting And Business/Management
University of Karachi
Karachi12.2005
Skills
- Business Intelligence Tools/Language: Tableau, Power BI, SQL and PL/SQL
- Database: Oracle, Teradata, BigQuery, SQL Server, Snowflake, Amazon Redshift
- Development Tools: SQL Developer, IntelliJ, DBeaver
- Other Applications: MS Office Suite, Vision, Sharepoint
- Data Visualization and Presentations
- Data Analysis
- Excel Functions
- Data Cleaning
- Data Governance and Stewardship
- Data Validation
- Data Mapping
- Data Warehousing
Certification
- Project Management Professional
- Tableau Desktop Specialist
Timeline
Business Systems and Data Analyst
Bayer Crop Science
03.2021 - Current
Data Analyst
DB Schenker
07.2018 - 03.2021
Business Intelligence Developer
CVS Pharmacy
01.2016 - 06.2018
Masters in Commerce - Accounting And Business/Management
University of Karachi
Bachelors in Commerce - Accounting And Business/Management
University of Karachi
Similar Profiles
Alessandro CostanzoAlessandro Costanzo
Customer Interface Business Advisor at Bayer Crop Science - Bayer Holland B VCustomer Interface Business Advisor at Bayer Crop Science - Bayer Holland B V
Sandip B. DhobiSandip B. Dhobi
Head of Packaging Technology, APAC at Bayer Crop ScienceHead of Packaging Technology, APAC at Bayer Crop Science
Anu ReedAnu Reed
Senior Marketing Specialist at Bayer Crop ScienceSenior Marketing Specialist at Bayer Crop Science
Kevin LockwoodKevin Lockwood
Health, Safety, Environment (HSE) Representative at Bayer Crop ScienceHealth, Safety, Environment (HSE) Representative at Bayer Crop Science
Skye NewsomeSkye Newsome
Customer Experience Champion II at VerizonCustomer Experience Champion II at Verizon