We provide IT Staff Augmentation Services!

Data Analyst / Tableau Developer Resume

Baltimore, MD

SUMMARY

  • Driven by bottom line of any organization coupled with Core Technology skills to delivering exceptional services. Seeking a position as a Data Analyst and Tableau Developer/Analyst, utilizing knowledge of relational database and Business Intelligence models to improve on efficiency and effectiveness of organization’s IT functions towards achieving an ultimate goal.
  • Utilized business intelligence tools to include OLAP (Online Analytical processing), data warehousing, reporting, querying tools and excel.
  • Experience in Data Analysis and ETL techniques for loading enormous amounts of data.
  • Experience with DATA MINING.
  • Identified issues when reports are created from several and complex data sources.
  • Excellent knowledge and usage of statistical/mathematical analytics software like Stata, SPSS and Minitab.
  • Possess strong computer and office administration skills with a vast knowledge of Windows and Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio).
  • Excellent knowledge and usage of reporting tools such as Tableau.
  • Experience in data scrubbing and cleansing.
  • Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
  • Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
  • Self - motivated individual with strong communication skills, great attention to details and the ability to work under pressure.
  • Exceptional organizational and time management skills and the ability to work independently.
  • Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments.

TECHNICAL SKILLS

Operating Systems: Win XP, Vista, 7, Windows Server 2003, 2008(X32, X64), Linux.

Databases: MS SQL Server 2005/2008/2012 , Teradata 12/13, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g

ETL/Other Tools: Informatica Power Center 8.6.1/9, SAS Enterprise Guide, SSIS (Visual Studio), Erwin Data Modeler, ER Assistant, R.

Test Tools: HP Quick Test Professional 10/11, HP Quality Center 10

Querying Tools: SQL Management Studio 2008/2012, Teradata SQL Assistant, SQL Plus, SQL Developer, Teradata PL/SQL

Querying language: SQL, PL/SQL, TSQL

Business Intelligence Tools: Tableau 10.4, 10.5, 18.1, 18.2, 18.3, 19.1, 19.2, 19.3, 19.4, 20.1, 20.2, 20.3 SSIS, Excel and Power Pivot, SSRS, OBIEE.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Data Analyst / Tableau Developer

Responsibilities:

  • Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.
  • Using OBIEE, I created some dimensional hierarchies, fact table, dimension table and mapped them in BMM layer. I then drag them into the Presentation layer.
  • Created some interactive dashboards with filters and prompts to allow users to enter what they want to see using OBIEE.
  • In my daily responsibilities at Confidential, I interacted and had scrum meetings with client (USPS Representative or Post Masters and Prime third-party sellers). I sent daily emails to District post offices of sprint notes discussed and daily kip’s
  • Perform weekly evaluation with Prime third-party sellers’ products
  • I pulled data from heterogeneous / multiple sources like Hadoop, Oracle, excel, csv files, my SQL, SQL server into Tableau to create dashboards during a recent project involving Confidential and whole foods.
  • My knowledge about SDLC methodology Scrum Agile helped me with these meetings.
  • Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different SQL Server databases
  • Utilize SISS for ETL data modeling, data migration, and analysis
  • Prepare high level analysis reports with Excel
  • Provides feedback on the quality of data including identification of billing patterns and outliers
  • Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts
  • Carrying out data extraction and data manipulation using SQL as per business requirements
  • Documenting the extent to which data fails to meet threshold reporting requirements.
  • Used Tableau server as a front-end BI tool and MS SQL Server 2012 as a back-end database to design and develop workbooks, dashboards, global filter page, and complex parameters-based calculations.
  • Working with team of developers, designed, developed and implemented a BI solution for Sales, Product and Customer KPIs.
  • Using Tableau server, l created permissions and privileges for designated / authorized users.
  • Connect Tableau server to publish dashboard to a central location for portal integration.
  • Implement Tableau mobile dashboards via Tableau mobile application.
  • Involve in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
  • Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau.
  • I ensured Security by restricting data access based on users’ characteristics such as their roles by creating ‘user filters' which is also known as ‘row level security'(RLS).

Confidential, Baltimore MD

Tableau Reports Developer

Responsibilities:

  • Used Tableau server as a front-end BI tool and MS SQL Server 2012 as a backend database to design and develop workbooks, dashboards, global filter page, and complex parameters-based calculations.
  • Working with team of developers, designed, developed and implemented a BI solution for Sales, Product and Customer KPIs.
  • Create compelling dashboards using tableau dashboard and prepare user stories to deliver actionable insights.
  • Connect Tableau server to publish dashboard to a central location for portal integration.
  • Implement Tableau mobile dashboards via Tableau mobile application.
  • Involve in creating database objects like tables, views, procedures, triggers, and functions using T-SQ L to provide definition, structure and to maintain data efficiently.
  • Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau.
  • Develop Tableau workbooks from numerous data sources using Data Blending.
  • Develop Tableau visualizations and dashboards using Tableau Desktop.
Confidential, Framingham, MA

Data Analyst

Responsibilities:

  • Responsible for Backup and Recovery, Monitoring, creating data from multiple systems and databases including SQL Server and Oracle to bring it into a centralized system.
  • Created and populated Customer data using advanced SQL and PL/SQL queries and scripts and also performed Teradata SQL performance tuning
  • Worked on analysis of the parts claims processing application in order to gather requirements to comply with HIPAA 5010
  • Created transformation and mapping by using ERWIN, ER ASSISTANT.
  • Maintained data consistency, Oracle database integrity and reported instances of data corruption.
  • Created mappings using transformations like Source Qualifier, Aggregator, Filter, Update strategy, Joiner, Normalizer, Union, Store procedure and XML transformations
  • Performed numerous data extraction requests involving SQL scripts and UNIX
  • Performed data migration between different environments and Third-Party Databases
  • Performed drill down analysis reports using SQL Server Reporting Services
  • Created data dictionary for the retail and sales aberrancy rules.

Hire Now