Home

Neelofer - Tableau Power BI

[email protected]

Location: Herndon, Virginia, USA

Relocation:

Visa: H1B

NEELOFER FIRDOUS Senior Tableau / Power BI Developer PROFESSIONAL SUMMARY Over 9 years of Information Technology Industry experience in Analysis, Design, Development, Administration, and Implementation of various Business Intelligence tools including Tableau Desktop/Server, SSIS, SSRS, SSAS, Informatica, MS SQL Server, Oracle SQL, and MySQL. Experience in Power BI Desktop, Alteryx, Tableau Desktop, Tableau Server, and Tableau Public in various versions of Tableau 2019.1, 2019.3,10x/ 9x/ 8x/7x. Proficient in Maintaining, installing, configuring, and administering the Tableau Server in all environments and experience in creating Tableau Mobile dashboards. Experience in Tableau administration duties that comprised upgrading Tableau Servers, user & user group creation, managing licenses, and data connections, setting up security features, scheduling tasks, and embedding views in Tableau Server. Expertise in designing, creating, developing, and publishing various dashboards, and reports utilizing various Power BI Visualizations like Dual Axes, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Donut Charts and 100% Stacked-Bar Charts and Geographical Visualizations and more also making use of actions, local and global filters according to the Client requirement. Experience creating Sets, Joins, Bins, Hierarchies, Sorting, Grouping, Legends, Table calculations, Functions, and Parameters. Experience with Alteryx in data cleansing and building workflows. Expert in performing Power BI & Tableau data extracts, Data blending, Dashboard actions, and Row-level security. Proficient in Mastering the ability to design and deploy Rich Graphic visualizations with the Drill Down Menu option and Parameterized using Tableau. Expert in Developing complex reports using multiple measures like Individual Axes, Dual Axes, and Blended Axes to demonstrate Sales KPIs, namely Sales Funnel Leakage and Marketing Collateral Usage. Effectively used the Data Blending Feature in Tableau to build Analytical Reports from various data sources like MS Access, Excel, MySQL, MS SQL Server, Teradata, and Oracle on a single worksheet. Expert in Performing the ETL (Extract, Transform, and Load) process of data directly from different source systems using SSIS and Informatica. Outstanding knowledge of Star / Snowflake Schema Modeling, which includes understanding Business Processes, Modeling Dimensions, Facts, and Physical and Logical Data Modelling. Hands-on experience implementing Queries in SQL SERVER including User Defined Functions, Stored Procedures, Customized Aggregate Functions, View, CTE, Index, etc. Experience in migration of data with SSIS (SQL Server Integration Service) as an ETL tool for Data Integration Services and Business Applications. Created several SSIS packages using various data transformations like Conditional Splitting, Derived Column, Fuzzy Lookup, Multi-Column, and Cast Conversion. Conducted incremental load of the data using SSIS and performed Data Automation using SQL Agent Jobs. Efficiently performed Data Conversion and Data Migration using SSIS and DTS (Data Transformation Services) across different data sources like SQL Servers, Flat Files, and MS Access. Worked extensively on configuring the Report Server, scheduling Report Manager, and giving permissions to different level users in SQL Server Reporting Server (SSRS). Strong knowledge in Troubleshooting, Performance tuning of reports, and resolving issues within Tableau. Experience with all phases and methodologies of the Software Development Life Cycle including Waterfall, Agile/Scrum, and RUP. EDUCATION MS in Business Analytics BS in Electrical and Electronics Engineering TECHNICAL SKILLS Languages Python, SQL, R, #, T-SQL, XML, HTML, DHTML, C Database/ Server MySQL, Teradata, Oracle, DB2, SQL Server, Oracle SQL, IBM Netezza, PL/SQL Data Warehousing Warehouse Designer, Transformation Developer BI Tools Tableau Desktop 2020.1, 2019X, 2018X, 10x, 9x, 8x, 7x, Tableau Server, Power BI, Alteryx, JIRA, Rally, MS Office Suite, SharePoint Scripting Python Analytics /Reporting SSIS, SSAS, SSRS OS Windows Variants, Linux/Unix MS Technologies MS Office (Word, Excel, PowerPoint), MS Access, MS Visio, MS SharePoint Cloud AWS Methodology Agile Methodologies PROFESSIONAL EXPERIENCE TransAmerica, Denver, CO Feb 2023 Present Senior Tableau Developer/Admin Responsibilities: Orchestrated as administrator/architect performing responsibilities like Installing, Configuring, and Administration of Data Visualization Product Suites like Tableau Server, Tableau Enterprise, Alteryx servers, etc. Directed Server architecture and solutions to troubleshoot performance, scheduling, and server-related issues. Actively lead the BI Developers and Analysts to develop opportunity assessments, gather requirements, design solutions, develop and implement process and/or technology improvements as well as build prototypes, train users, and ensure that the BI team completes projects. Setup and configuration of Tableau server in various environments and use Tableau CMD and Tableau admin tools to configure the server according to best practices. Accomplished monitoring Tableau server performance and application status reporting and maintenance of 3000 users globally, 400 Dashboards, and 150 data sources. Managing the extract refresh Scheduled tasks, security administration, troubleshooting, performance tuning, and general systems maintenance. Administer and support a multi-tier Tableau infrastructure including upgrade analysis and planning, security administration, release management, troubleshooting, performance tuning, and general systems maintenance. Creating users, groups, projects, and sites on the Tableau server and Involving in Tableau deployments during the monthly production releases and post-release support Backup, data recovery, and service restoration management & Incident, problem, and service outage management Configuring the Tableau server for alerts which is for system health and low disk space monitoring the disk usage in the administrative views and Configuring failover and high availability gateways. Define best practices for Tableau deployment and create reusable templates Defined, developed, and implemented Power BI view dashboards, scorecards, and reports Developing the Tableau data sources by connecting to different databases including Oracle, SQL Server, Vertica, excel files, Flat files, TDE files from Alteryx. Environment: Tableau, Alteryx Servers, Oracle, SQL Server, Vertica, Excel, Windows. USAA, San Antonio, TX Nov 2018 Nov 2022 Power BI & Tableau Developer/ Data Analyst Responsibilities: Worked closely with Business Analysts to understand the requirements and suggested efficient Data visualization techniques. Helped the client in retiring two of the UDAs (User Developed Applications) by automating them to IT-supported systems. Converted SAS code into NZSQL queries and created dashboards. Worked with the EMM business team and helped them with creating multiple dashboards and ad-hoc reports based on the requirements. Worked with the EPP team as a Payments Analyst and helped them with Cost Transaction Analysis of different payment gateways like Zelle, Wires, Funds transfer, and Bill Pay. Created reports in Excel according to the team s needs. Build Pivot tables and VLOOKUP s and do deeper analysis as per the requirement Built Dashboards using Power BI, and exported data to create Excel dashboards based on urgent requirements. Implemented machine learning models in Alteryx to predict business outcomes using Random Forest and Regression models. Created macros and workflows in Alteryx to minimize manual efforts towards benefit calculations. Worked with the ESM team as a Power BI Developer and built dashboards from scratch using existing SAS code and converted the SAS code into SQL queries. Involved in Tableau dashboard lifecycle which begins with understanding the clientele needs and requirements gathering and data analysis creating the dashboards and publishing them to the Tableau server along with scheduling the refreshes accordingly. Involved in analyzing and reviewing data from various sources like Netezza, Excel, and CSV and performed joins and data blending techniques accordingly. Built complex dashboards according to the client requirements and published them to the Tableau Servers, Worked as Site admin as well. Worked with the latest versions of Tableau Desktop and Servers. Hands-on experience working with Business Objects and converting existing business object reports into Tableau according to the requirements. Worked with the business team and worked with multiple stakeholders at the same time and assisted them with an understanding of the visualizations. Performed performance tuning on dashboards that are taking longer to load, used best techniques like going for extracts, tried to use less of quick filters, showed fewer marks on the dashboards, and tuned them up. Created KPI dashboards and Ad-hoc reports based on the client s requirements. Good understanding of the banking domain and terms associated with it. Worked closely with AVP and ED of Enterprise Payments Platform. Environment: Power BI Desktop, Tableau Desktop 2019.1, 2019.3, 2018.3 Microsoft Excel, CSV, Tableau Server, SAS (Statistical Analysis Systems) Alteryx, SQL Server, PL/SQL, MS Office, Slack, JIRA, Rally, IBM Netezza, Agility Workbench, Oracle SQL Verizon, Dallas, TX Aug 2017 Oct 2018 Tableau Developer Responsibilities: Gathered and analyzed the business requirements and then translated them to technical specifications and designed documents for development. Actively interacted with Users, Team leads, DBA, and Technical Managers to fully understand the system's requirements. Worked extensively using EXCEL to validate the data and use them as the source data files. Alteryx has been used for Preparing data for analysis &data transformation functions. Analyzed the data using statistical features in Tableau to develop Trend Analysis. Automate the data flow process in the Alteryx from data sources (flat files, My SQL) to S3 bucket using Python, SQL, and Alteryx tool inbuild capabilities. Provided mock-up visuals to speed up the requirement visualizations. Hands-on experience in creating and modifying worksheets and data visualization dashboards. Created LOD(Level of Detail) expressions data source columns that are computed for each row in the underlying data. Created Data Source Level Filter, Context Filter, and Cascading Filters to improve performance and user flexibility. Performed tuning of reports and resolving issues with Tableau Server. Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, and Symbol Maps according to deliverable specifications. Used Trend Lines, Log Axes, Groups, Hierarchies, and Sets to create a detail-level summary report and Dashboard using KPIs. Involved in fixing the bugs and handled the CR (Change Requests) & interacted with clients for the requirement for different CRs and bug fixing after client site testing. Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization. Knowledge of Tableau servers such as Hosting and Embedding the views in a web page. Created Relationships, Actions, Data Blending, Filters, Parameters, Hierarchies, Calculated Fields, Sorting, Groupings, and Live connections in memory in both Tableau and Excel. Worked extensively with advanced analysis Actions, Background images, and Maps. Worked as a Developer in creating complex Stored Procedures, Triggers, Tables, and other SQL code and SQL Joins for applications. Extensively used PL/SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity. Worked on the automation factory building and Alteryx server setup to improve the reporting process and enhance the customer experience. Identified the key facts and dimensions that are necessary to support the business requirements and developed the Logical Dimensional Models. Created SSIS Packages by extracting data from various sources like Text Files, Excel, and Databases. Worked with various Control flow and Data flow tasks based on requirements. Used various Transformations in SSIS which include Merge files, Conditional Split, Aggregate, Union All, Derived column, Lookup, Fuzzy Lookup, Pivot, and Un-Pivot. Environment: Tableau Desktop10.0v, Alteryx, MS SQL Server 2017, SQL BI Suite, SQL Server Integration Services (SSIS), Microsoft Excel, PL/SQL, MS Office, Visual Studio 2010 Dallas Capital Bank, Dallas, TX Jun 2015 - Jul 2017 Tableau Developer Responsibilities: Worked directly with Business lines in Customer care, Loans, Management Information Systems, and Card management to gather dashboard requirements for development. Extensive experience in reviewing those business requirements and analyzing data sources from Excel/Oracle SQL Server to Design, Develop, test reporting, and analyze projects within Tableau Desktop. Created views in Tableau Desktop that were published to the internal team for review and further data analysis and customization using Filters and Actions. Created Heat Maps showing current service subscribers by the color that was broken into regions allowing business Users to understand where we have the most users vs. least users. Projected and forecasted future growth by developing reports to show in detail. Converted charts into Crosstabs for further underlying data analysis in MS Excel. Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server, and MS Excel. Blended data from multiple databases into one report by selecting primary keys from each database for data validation. Combined various workbooks into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users. Reviewed basic SQL Queries and edited inner, left, and right Joins in Tableau Desktop by connecting Live/Dynamic and Static datasets. Developed storytelling dashboards in Tableau Desktop and published them on Tableau Server, allowing end users to understand the data on the fly using quick filters for on-demand needed information. Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards accurately displayed the changed data. Tested dashboards to ensure data was matching the business requirements and if there were any changes in underlying data. Collaborate with the development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups. Environment: MySQL, Oracle, Essbase, Teradata, SQL Server, Source System Applications and Data Visualization Tableau 8x Desktop and Server, MS Excel Keywords: cprogramm business intelligence sthree active directory rlang information technology microsoft procedural language Colorado Texas