Data Analyst Tableau
Resume:
Nadine A. Gondon
Tableau BI Developer/ Data Analyst
EDUCATION:
Bachelor of Arts McDaniel College Westminster
Active Tier 3 Investigation
******.******@*****.***
TECHNICAL SKILLS:
Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Unix
Databases: MS SQL Server 2005/2008/2012, Teradata 12/13, MySQL 5.2, 5.7, Oracle 10g, 11g, DB2
ETL/Other Tools: SAS Base, SAS Enterprise Guide, SSIS, Erwin Data Modeler, ER Assistant
Querying Tools: SQL Management Studio 2008/2012, SQL Plus, SQL Developer
Business Intelligence Tools: Tableau 9.2, 9.3, 10.4, Power BI, MicroStrategy, Excel and PowerPivot, SSRS
Software: Jira
EXPERIENCE:
Feb. 2020- Present
BI Specialist- Remote / Tableau Developer / Defense Travel Management Office / Alexandria, Virginia
Responsible for a wide range of tasks, from creating data sets, reports, providing data for use by DTMO Business Intelligence tool (Tableau), assisting in data integration, data quality and dashboard development to support performance management.
Supported the development, implementation and maintenance of strategic and operational performance metrics to assist the government in measuring the effectiveness and efficiency of the DoD Travel Enterprise including key performance indicators (KPIs), performance reports, and dashboards for managers, executive leadership, and other stakeholders to track program performance and assess the overall health of the DoD Travel Enterprise.
Performed day to day administration of Tableau Server such as managing sites and projects, configuring and managing project permissions, providing periodic reports on Tableau Server usage and publishing Tableau workbooks and data extracts.
Configured and troubleshoot Single Sign On (SSO) issues for Tableau Server.
Created Tableau related Standard Operating Procedures (SOP).
Used Jira Epic to plan, track and create Tableau reports.
Jan. 2018- February 2020
Tableau BI Developer United Urology Owings Mills, MD
Created rich Dashboards using Tableau Desktop and prepared user stories to create compelling Dashboards to deliver actionable insights. Created data visualizations and Dashboards. SQL Server 2012/2008 created complex queries, triggers and stored procedures, SQL indexing, T-SQL scripts
Connected Tableau server to publish Dashboard to a central location for portal integration.
Implemented hierarchies in Tableau with Portfolio as the highest level followed by application and project details
Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
Created data visualization for logistics calculation and department spending analysis.
Generate KPI’s for customer satisfaction survey results.
Utilized Power BI for data extraction and data manipulation
Maintain test log and test evaluation summary reports.
Developed data visualizations and Dashboards in Excel.
Developed Pivot Tables/Charts such as pie chart, line chart, bar chart, and bubble chart for monthly metrics.
Structured the Dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom
Maintain test log and test evaluation summary reports.
Maintains departmental metrics in accordance with goal plan
Jun. 2016 - Dec. 2017
Tableau BI Developer Data Analyst PNC Financial Services Pittsburgh, PA
Experience in creating various views in Tableau (Tree maps, Heat Maps, Scatter plot, dashboards).
Created Views and Database Triggers, Stored Procedures and Functions using SQL such that information entered by a certain WM can make appropriate changes to the respective tables.
Wrote complex SQL queries using advanced SQL concepts like Aggregate functions
Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server.
Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Explain, Stats, Cast and volatile tables on SQL server
Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
Analysed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
Experienced in Data mapping, Data transformation between sources to target data models.
Analysed reporting requirements and develop various Dashboards.
Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
Experience in creating Filters, quick filters, table calculations, calculated measures and parameters.
Responsible for developing, analysing and reporting key risk indicator and key performance indicator metrics that enable management to make timely and effective decisions related to threats, risks and control requirements.
Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
Feb 2015–May 2016
Tableau BI Developer (intern) Hewlett-Packard Company Berkeley Heights, NJ
Design, develop, implement and maintain programs to load, aggregate, and extract data to meet a wide range of business and system requirements using SQL Server mainframe.
Exercise positive interpersonal communication skills and work with small team or independently on all phases of software development lifecycle.
Work with ETL Process which includes SSAS, SSIS, and SSRS. Worked with Business Intelligent tool like Tableau and Power BI on SQL server mainframe.
Administered SQL Server including back up / recovery, creation of user, indexing (Cluster and Non-Cluster) for normalization. Created controls to preserve the integrity of the information being reported
Developed stored procedures, views, triggers, execute test cases and defect management for ETL and BI systems
Contact this candidate