Data Analyst / BI Developer

Ather Javaid

Cell: 516-***-**** Email: *********@*******.*** LinkedIn: www.linkedin.com/in/ather-javaid-5b1a5722

Summary

Over 9+ years of extensive experience in Tableau Enterprise Environment

In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server

Experience in report design, technical support, and troubleshooting of Tableau dashboards

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized using Tableau

Have Extensive Experience in IT data analytics projects, Hands on experience in migrating on premise ETLs to Google Cloud Platform (GCP) using cloud native tools such as BIG query, Cloud Data Proc, Google Cloud Storage, Composer.

Extensively worked with relational databases as well as BigData and Cloud platforms like Hadoop and Google BigQuery.

Strong Experience in Performing data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.

Experience in Nprinting Qlikview/QlikSense Reporting as NPrinting is the most advanced report generation, distribution and scheduling application for Qlik.

Used Parameters and Layout Containers in Tableau dashboards to toggle between sheets

Performed Joins and Data blending to join data in Tableau from different data sources

Utilized Calculation fields, Hierarchies, Groups, Sets and different formatting styles in visualizations

Implemented the latest Tooltip visualization feature of newer versions of Tableau

Extensive Tableau Experience in Enterprise Environment and Tableau Admin and Architect.

Proficient in Installing, Configuring and Administration of Tableau Server and server performance tuning for optimization.

Experience in identifying critical information in process automation, supply chain analytics, building vendor relationships, manufacturing losses reduction, marketing analytics, and building claims forecasting models.

Experience in Tableau Server administration tasks including Tableau server optimization and performance tuning.

Used different filters such as Data source filters, context filters and all other kinds of filters based on requirements

Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database.

Supported team in resolving T-SQL and ETL related issues.

Deployed Tableau dashboards and created report schedules on Tableau server

Expert level skills on T-SQL and query optimization and developing ETL strategies using SSIS.

Experience with data sources such as SQL server, Oracle, OData, Web Connectors, and many more

Extensive knowledge of Healthcare, Finance, and Banking domains

Strong analytical, logical, Communication and problem-solving skills

Ability to adapt to new technologies by self-learning

Technical proficiencies

Visualization Technologies: Tableau, Power BI, Tableau Server administration.

Programming Skills: SQL, HTML/CSS, Java (ability to understand code), Spark

Databases: MS Access, SQL Server, Oracle 12C/19C, IBMDB2, IBM Netezza, Hadoop, PostgreSQL, TSQL, MySQL, Snowflake, Teradata

Other Tools: Git, Latex, JIRA, Amazon Web Services, Google Cloud Platform

Professional Experience:

Client: Citi Bank, Irving TX (Remote) Mar 2023 – Present

Data Analyst/ Tableau developer/administrator

Duties:

Collaborate with Business Analysts, data scientists, and Business users to understand user requirements, layout, and look and feel of dashboards.

Involved in reviewing business requirements and analyzing data sources form Oracle SQL Server for design, development, testing, and production rollover of reporting projects within Tableau Desktop

Strong complex reporting skills – complex Drill- Discontinuous Cross-Tabs, Summary Reports, Burst Reports.

Server maintenance, health checks and troubleshooting for server related issues

Developed dashboards and reports using Google BigQuery.

Worked as QlikSense administrator to optimize Qliksense performance.

Trained users to build their own apps in QlikSense.

Instituted end-to-end technical guidance and end state roadmaps for Supply chain, device monetization Analytics & Sales and forecasting data marts.

Worked with Different Databases like DB2, Teradata, Oracle, Microsoft SQL Server, Microsoft Access databases, Excel Spread sheet etc.

Maintained development process for developing ETL Packages and reports as per the norms like Gathering requirements, Design, Development, Code review, Unit Testing, Peer Review and Review before releasing to QA.

Developed Data stage jobs to do ETL transformations with the requirement provided and load respective Dimension and Fact tables.

Process and analyze huge sets of data in Snowflake, SQL server, Oracle12c/19c

Perform data discovery, integration and identify / fix data quality issues

Designed and developed Tableau Reverse supply chain dashboards (i.e. Iconic Launch, Bid Sale).

Interacted with Customers for requirement gathering, effective analysis and also end-user training.

Managing the extract refresh Scheduled tasks, security administration, troubleshooting, performance tuning, and general systems maintenance.

Creating and monitoring the Autosys jobs to refresh the Tableau data extracts, working on the production issues.

Administer and support a multi-tier Tableau infrastructure including upgrade analysis and planning, security administration, release management, troubleshooting, performance tuning, and general systems maintenance.

Prepared dashboards using calculated fields for parameters, calculations and hierarchies in Tableau.

Create responsive Tableau dashboards to render on Desktop, tablet, and phone devices.

Process and analyze huge sets of data in Snowflake, SQL server, Oracle12c/19c

Lead the Tableau migration project from On-Prem to GCP and also upgrading Tableau to version 2019.4

Responsible for setting up GCP’s cloud identity and access management (IAM) to manage users, roles and privileges

Perform data discovery, integration and identify / fix data quality issues

Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculations.

Involve in all stages of the Report Development Lifecycle from development to production rollout

Develop reports such as Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports

Ensure the user security for the views using User filters

Provide status reports to management periodically.

Synechron Technologies Pvt. Ltd.

Client: Citi Bank, Irving TX (Remote) July 2022 – Feb 2023

Data Analyst/ Tableau Developer

Duties:

Develop and create a proof of concepts/prototypes in Tableau.

Provide logical calculations to the database team to avoid dashboard latency.

Create responsive Tableau dashboards to render on Desktop, tablet, and phone devices.

Process and analyze huge sets of data in Snowflake, SQL server, Oracle12c/19c

Perform data discovery, integration and identify / fix data quality issues

Creating SQL agent jobs after successful development of ETL packages and SQL codes.

End to end Installation and configuration of Tableau Server, Upgrade and performance monitoring and script maintenance for automated jobs.

Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculations.

Involve in all stages of the Report Development Lifecycle from development to production rollout

Develop reports such as Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports, and more.

Creating users, groups, projects, Data connections, settings as a tableau administrator.

Ensure the user security for the views using User filters

Attend various agile meetings, including daily scrum, sprint planning, retrospective, and more

Utilize JIRA to track and manage assigned work

Provide status reports to management periodically.

Cox Automotive Atlanta GA (Remote) Jan 2021 – Jun 2022

Senior Tableau Developer

Duties:

Created proof of concept / prototype the same using Tableau desktop.

Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.

Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.

Created and implemented Tableau best-practices on migrating and governing the dashboards in multiple environments.

Involved in maintaining the server heath by regularly taking care of backup and cleanup activities.

Created and managed Sites, Users, Groups and Projects in Dev/QA/PROD environments.

Championed data center migration from on premise to GCP and migrated data warehouse from Teradata to Google big query and data visualization using Tableau.

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

Strong complex reporting skills – complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.

Process and analyze huge sets of data in Snowflake, SQL server, Oracle12c/19c

Perform data discovery, integration and identify / fix data quality issues

Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.

Prepared dashboards using calculated fields for different logics for trends, parameters, calculations, groups, sets and hierarchies in Tableau.

Ensured the user security for the views using User filters and shared with business users.

Published the developed dashboards into production and refreshed the scheduled extract, tuned the performance of the dashboard and created tableau functional design document

PC Richard and Son NY Jul 2018 – Dec 2020

Tableau Developer

Data & Analytical Duties:

Work closely with data scientists and analysts to design, create and maintain scalable data models and pipelines

Acquire and integrate data from various data sources (cloud, databases, Hadoop, sensors, weblogs and social)

Process and analyze huge sets of data in Snowflake (both structured and unstructured)

Assist in identifying and migrating data sources to tableau server and partner with business to design tableau KPI scorecards & dashboards.

Perform data discovery, integration and identify / fix data quality issues.

Build automates data pipelines and produce feature rich analytical datasets.

Perform impact assessment and deep dive analysis to ensure data integrity, usability and completeness.

Created business intelligence information and applications knowledge center for employees

Lead cross-functional project teams and collaborated with business partners to determine and translate business requirements into technology and training solutions

Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Connected Tableau server to publish dashboard to a central location for portal integration.

Connected Tableau server with share-point portal and setup auto refresh feature.

Created visualization for logistics calculation and department spend analysis.

Generate KPI for customer satisfaction survey results and disease management.

Maintained Test log and Wrote test Evaluation, Summary Reports.

Extensively involved in doing user acceptance testing (UAT).

Northwell Health, Melville, NY Mar 2015 –June 2018

Role: Tableau Developer

Responsibilities:

Data & Analytical Duties:

leverage the Apache Hive ODBC driver to do import via the generic ODBC connector in Tableau Desktop

Query and mine large data sets to discover transaction patterns, examine financial data and filter for targeted information using traditional (SQL Server, Oracle, IBM DB2, Hadoop.)

Expertise in writing complex LOD functions in Tableau.

Automated Power Query refresh using power shell script and windows task scheduler.

Used various sources to pull data into Tableau such as SQL Server, Oracle, MS Azure etc. Had decent amount of exposure using both modes for bringing the data into Tableau desktop (Direct Query and Import Mode).

Created Workspace and content packs for business users to view the developed reports.

Scheduled Automatic refresh and scheduling refresh in Tableau server.

Wrote calculated columns, Measures query’s in Tableau desktop to show good data analysis techniques.

Created stored procedures and SQL queries to pull data into power pivot model.

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Leverage the Hive ODBC driver to do import via the generic ODBC connector in Tableau Desktop.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.

Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.

Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.

Creating data blending in case of merging two different datasets using Tableau

Writing queries in Hive/Impala and designing view in Hive.

Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.

Involved in trouble shooting of performance issues which were associated with Tableau reports.

Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.

Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.

Develop Star Schema in Power BI. Dimensions are used to slice and dice the data, and facts to aggregate numbers

Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager

Using JavaScript API enables to more easily embed reports into applications and to programmatically interact with those reports so that the applications and the reports are more integrated

Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.

Created Drill Down Reports, Drill Through Report by Region.

Environment: SQL Server 2016/12/14, Oracle12c/19c, Denodo, Rest API, Power Platform, Power App, Snowflake, Tableau Prep, Oracle SQL Developer, Python, Azure, Excel, IBM DB2, PL/SQL, Alteryx, Hadoop (Cloudera), Jira, Rally, HUE, LINUX, Impala/Hive, Big Data, Tableau, Alteryx, IBM Cognos, Super putty, PostgreSQL, SFTP etc.

Education

MBA, Human Resources, Preston Institute of Management and Science

Bachelor’s degree in Applied Science, Karachi University

Contact this candidate