CONTACT

Phone : 417-***-****

Email : ad3kqh@r.postjobfree.com

SKILLS

Business Skills/ Technical Skills:

RDBMS : SQL Server, MySQL,

Hadoop, Impala/HIVE, Teradata,

Netezza

Reporting Server : Tableau, OBIEE,

Actuate

Reporting Tools : Tableau

MicroStrategy, OBIEE, Alteryx, and

Python

Enterprise Environment : Maximo

6/7.1, Business Objects, MSBI Stack

(SSIS, SSRS & SSAS)

ETL: SSIS, Informatica, Objects Data

Integrator

Microsoft Office : MS Word, MS

Excel, MS. PowerPoint, MS. Access,

MS. Outlook

PROFESSIONAL SUMMARY

● Over 9+ years of Data warehousing experience leading highly technical Tableau and data analysis projects across many domains by leveraging SQL, Alteryx, Python, SSIS to perform thorough data mining, data discovery, and data visualization.

● More than 7 years working closely with Senior Managements and VPs, SMEs, Project managers, and directors from different teams to gather and analyze requirements and expert level recommendations for data solutions.

● Extensive experience (8+ years) expertly writing and improving the performance of complex SQL queries.

● Well versed in using T-SQL for developing complex and well-tested Stored Procedures, Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, and Indexing.

● Rich hands-on experience (8 years) designing clean and efficient dashboards to provide insights, improve efficiency, and promote data-driven decision making.

● Deep experience using customized charts and solutions Sankey, Waterfall, Pareto, Hyper API, JavaScript API, and Python APIs to meet complex requirements.

● Expert level of experience creating executive dashboards with top-notch Security (Row Level Security) and fast load and rendering times (good performance).

● Rich hands-on experience evaluating data models to ensure high performing queries and Tables conducive for reporting.

● Created Tableau wireframes for various lines of business.

● Prepared advanced Tableau dashboards with quick/context/global filters, parameters and calculated fields that allowed to track and improve customer units KPIs.

● Skilled in working with OLAP and Relational Database Management Systems Including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers, and cursors.

● Proficiency in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), Test Case Document (TCD).

● Administered user, user groups, and scheduled instances for reports in Tableau.

● Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and till maintenance.

● Highly experienced in Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.

● Proficient in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

● Strong experience in tuning Tableau Dashboards to increase performance, developing new dashboards, troubleshooting the existing dashboards and performance management.

● Automated reports and data ingestion processes for many finance reports using SQL, Excel VBA, and Python tools.

AMY LINDEMANN

● Experienced in implementing Row Level security, utilizing authentication and permission to secure dashboard access to only the appropriate people. WORK HISTORY

Senior Data Analyst/ Tableau Consultant, 08/2022 to Current PayPal - San Jose, CA

Responsibilities:

● Design and develop visuals and dashboard to convey the story of the data.

● Lead requirement analysis efforts to ensure requirements are specific, measurable, and realistic.

● Collaborated with SMEs, Directors, and business-side stakeholders to develop KPIs and reports and ensure performance and risk mitigation.

● Skillfully and successfully tuned many dashboards using Tableau best practices and performance tuning principles.

● Expertly employed complex Row Level Security using Tableau server and the database

● Created and published data sources to Tableau server to be used by multiple workbooks.

● Designed ETL process to extract data from multiple source systems and publish it to Tableau server.

● Designed and evaluated data modes to boost reporting processes and increase performance.

● Comfortably created design documents, user manuals, and mockups.

● Performed extensive data analysis, data validation, data mapping/design, by accessing multiple sources to discover patterns and data suitability for reporting.

● Expertly tuned complex workbooks and large datasets for optimal Tableau performance and maintainability.

Senior Data Analyst/Tableau Developer, 10/2020 to 07/2022 KeyBank - Cleveland, OH

Responsibilities

● Accomplished wide range of development activities involving requirement gathering, documentation, code and reports developments, to testing and release/deployment.

● Leveraged SQL to create custom queries and reports to generate data for reports through the use and creation of Stored Procedures, Functions, Views, and Tables.

● Extracted data from various sources and scheduled refresh using Tableau Server, Alteryx, and Python.

● Effectively used advanced analysis action, calculations, parameters, background images, maps, trend lines, statistics, and table calculations.

● Efficiently combined data from multiple sources using Data Blending, Cross Database, and data models (physical and logical Tables).

● Developed and designed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop per business requirements.

● Expertly employed various workarounds to meeting functional and non-functional requirements.

● Created materialized views to effectively summarize data for Tableau to increase performance.

● Collaborated with business users to analyze requirements, determine the scope of projects, and address concerns of business questions.

● Migrated dashboards from Power BI, MicroStrategy, and Cognos into Tableau

● Successfully accomplished a wide range of development activities involving requirement gathering, documentation, code and reports development, testing and release/deployment.

● Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

● Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler.

● Provided expert recommendations and training on security, performance, and best practices to stakeholders and less experienced Tableau Developer

● Successfully tuned several Tableau Dashboards and queries to perform according to standards.

● Created Business requirement documents and plans for creating dashboards.

● Scheduled extract refresh (Incremental and Full refresh) using Tableau server, Alteryx, and Python

● Provided training to end client users on Tableau Desktop by providing step-by- step guidance from basics to advanced functions in Tableau including working with calculations, parameters, and date functions. Data Analyst/Tableau Developer, 05/2018 to 09/2020 LabCorp - Burlington, NC

Responsibilities:

● Standardize data collection and extraction process by developing and enforcing ETL processes using Alteryx and SSIS.

● Migrated reports from Cognos, MicroStrategy, PowerPoint, and MS Excel into Tableau.

● Established effective automated ETL processes with Alteryx and Python to replace manual processes.

● Utilized Alteryx to publish data to Tableau Server and automate reporting process.

● Provided real time reporting capabilities to help facilitate timely data-driven decisions.

● Comfortably served as Tableau subject-matter-expert by providing recommendations and training to senior managers, VPs, directors, and project managers.

● Extracted data from multiple databases and data warehouses and combined that data using joins, blends, cross database joins, and data models

(relationships) for Tableau reports.

● Wrote SQL queries using advanced features to validate data in Tableau reports.

● Utilize SQL queries to analyze data, compare files, and build database objects for Tableau reports.

Tableau Developer, 05/2015 to 04/2018

First Data Corporation - Jersey City, NJ

Responsibilities:

● Delivered database objects such as tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

● Published data to Tableau server and schedule independent refresh schedules of published data sources.

● Skilled in writing complex Tableau calculations using LOD, Date functions and applying complex, compound calculations to large, complex data sets.

● Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user communities.

● Developed dashboards using calculation, parameters in tableau and created calculated fields, sets and hierarchies.

● Performed database tuning and performance monitoring.

● Created multiple scorecards and dashboards with action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

● Effectively used advanced chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, funnel charts etc., to assist business users in solving complex problems.

● Developed effective, interactive, and complex business reports/ dashboards.

● Expertly created Tables, Views, and Stored Procedures to data sources for dashboards to optimize Tableau performance.

● Worked with data from data sources like Salesforce, Amazon Redshift, SAS, DB2, SQL server and Excel files for getting data to Tableau for creating various dashboards.

● Scheduled extract refresh (Incremental and Full refresh) using Tableau server, Alteryx, and Python.

● Provided Ongoing support to BI applications running in production & troubleshooting.

● Pinpointed performance bottlenecks especially in data model, data integration components, data load and implemented performance tuning to make the dashboard work efficiently.

EDUCATION

Master of Arts

Liberty University - Lynchburg, VA

Bachelor of Science

Drury University - Springfield, MO

Contact this candidate