Hamayoon Tariq
*************@*****.*** 929-***-**** https://www.linkedin.com/in/humayoon-tariq-342943206/
Summary
Over 6 years of experience in business intelligence /Business Analyst,System Analysis & Design, Development, testing and implementation of BI/Data Warehousing projects using Tableau, SAP, BOBJ and Power BI In Finance, Banking, Health Care, and Retail and Payroll Services industries.
Interviewed SMEs and Stakeholders to get a better understanding of client business processes and authored Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
Experience in creating UI visualizations with Tableau Desktop, Power BI
Expertise in Power BI, Power BI Pro, Power BI Mobile, Power BI Services.
Experience in designing, developing and publishing visually rich and intuitively interactive Tableau and power Bi workbooks and dashboards for executive decision making.
Strong understanding of project life cycle and Software Development Life Cycle(SDLC) methodologies including RUP, RAD, Waterfall and Agile.
Exceptional experience in dealing with various databases like SAP HANA,Oracle, DB2, SQL Server, MS Access, and Flat files.
Experience in Developing, Designing and Support inter active Tableau dashboards. Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
Worked in IDT to create universe to connect to SAP BOBJ tool such as Webi to create reports.
Experiences:
USPS May 2020 - Present
BI Developer/Analyst (Tableau/Power BI/)
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.
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.
Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
Strong Dashboard design experience and passionate practitioner of effective data visualization.
Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
Utilized Tableau server to publish and share the reports with the business users.
Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community. Analyzed systems to understand and document data elements, their attributes, relationships, and data flow, dependencies, and related interfaces.
Involved in creating conditions, operators, formulas, filters, rank, sorting, combine queries in web intelligence.
Created Linked, Unlinked, Parameterized and On-demand sub reports in crystal designer for various business needs, scheduled reports for different file based / schedule-based events, distributed in email, PDF and HTML format
Created complex Cross Tab, Master Detail reports with Slice and Dice, Drill Down functionalities using WebI
Designed reports that include formatting options such as Grouping, Sorting, Drill-down, Parameter prompts
Developed different types of standard reports with drilling capabilities in tables, cross-tab and charts with complex calculations.
Generated WebI reports involving complex queries, sub queries, Unions and Intersection
Customized the reports with graphical representation using line and bar charts as per end user requirement
Created Periodic reports: daily report, weekly, monthly and annual reports, till and employee reports
Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports
DaVita, Bridgewater, NJ June 2018 to April 2020
Business Intelligence Analyst (BOBJ/Tableau/Power BI)
Responsibilities:
Negotiate and liaise between business teams, technology teams, and support teams
Deliver cost effective, high performance technology solutions
Worked with users and stakeholders to analyze and validate requirements
Manage project through status meetings, weekly reports, identifying risks, and tracking issues
Designed, developed, and deployed business intelligence applications.
Worked closely with end users in identifying and implementing right set of business criteria to convert raw data into meaningful information.
Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop. Participated in the retrospective meetings and next sprint planning meetings. .
Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. in a single dashboard by using parameters. Generated
Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.
Effectively used data blending feature in Tableau to combine the data from different sources like Adobe marketing cloud into a single report.
Consistently attended meetings with the client subject matter experts to acquire functional business requirements.
Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting.
Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
Scheduled extract refresh for weekly and monthly reports.
GSK, Dallas, TX April 2017-May 2018
Business Intelligence Consultant
Responsibilities:
Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.
Developed various dashboards, used context filters, sets while dealing with huge volume of data. Provided Tableau desktop training for end users. Worked on creating Pivots, sets, groups, and parameters.
Worked on Creating various plots and drill down analysis using Tableau desktop. Worked on scheduling reports, managing data sources and refresh extracts. Developed SQL scripts to create database objects like Tables, Views and Sequences.
Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau. Generated Tableau dashboards with combination charts for clear understanding.
Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Published the dynamic dashboard reports to Tableau server for navigating the developed dashboards in web.
Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
Successfully administered users, user groups, and scheduled instances for reports in Tableau. Resolved various performance issues and analyzed the best process distribution for different projects.
Under Armor, Baltimore, MD February 2016 to February 2017
Business Intelligence Analyst
Responsibilities:
Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
Translate stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagrams, data flow/data model diagrams.
Evaluate risks related to requirements implementation, testing processes, project communications, and training saving the company on average $5,000+.
Identify and reconcile errors in client data to ensure accurate business requirements.
Draft and maintain business requirements and align them with functional and technical requirements.
Facilitate monthly meetings with clients to document requirements and explore potential solutions.
Develop business architecture using requirements such as scope, processes, alternatives, and risks.
Analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
Conduct 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.
Communicate client’s business requirements by constructing easy-to-understand data and process models.
Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
Famous Horse, Inc. New York Apr 2015 - Jan 2016
Data Analyst (Tableau)
Extracted, compiled, and tracked data, and analyzed data to generate reports.
Worked with other team members to complete special projects and achieve project deadlines.
Developed optimized data collection and qualifying procedures.
Leveraged analytical tools to develop efficient system operations.
Brown Brothers Harriman Jul 2014 – Mar 2015
Information Technology Support Specialist
Imaging, configuring and installing systems issued to users, decommission retired systems
Undertaking other duties not specifically stated which from time to time are necessary without altering the nature or level of responsibility
Updating inventory records via IT Asset management system
Tuning up the system’s performance for the best efficiency of the service
Providing Telecom and Conference Room support
Installing, Managing, and Configuration Windows Operating System
Managing hardware and software inventory and ensure the inventory is up to date
Education:
Bachelor of Computer Sciences
Technical Skills:
Tableau 9/10/2019.1, POWER BI, BOBJ, SQL server, Oracle, SAP Hana Modeling, SAP analytics Cloud, Microsoft Azure, MS Access, SQL Server, Oracle 11g/12C, IBMDB2, IBM Netezza, Hadoop, PostgreSQL, Snowflake, Alteryx, Tableau Prep, Data warehousing, Tabular and Multi-Dimensional Data