We provide IT Staff Augmentation Services!

Tableau Developer Data Analyst Resume

SUMMARY

  • Highly organized and result - oriented professional with experience in Tableau Development and Data Analytics
  • Proficient in QAQC, Business Intelligence, Data Validation, Database and Data warehouse
  • Advanced level of SQL Server databases, Microsoft SQL Server
  • Proven experience in Tableau server, Tableau prep builder, Tableau desktop
  • Strong Knowledge of Power Bi, Thought-Spot, and Adobe analytics
  • Proficient in all Microsoft applications, Word, PowerPoint, ADVANCED EXCEL skills (Pivot Tables, VLOOKUP, Macros), MS Office suite, MS Access, Google Suite
  • Knowledge of Workbench, Teradata, Data3sixty, Sales Force and Query Fabric
  • Experience assisting Business Analysts in gathering requirements for development purposes
  • Proven understanding of translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs.
  • Proven experience in the use of DAX (Data Analysis Expressions) language
  • Experience in Data Analysis and manipulation of complex data set for business need
  • Understanding of SQL to generate queries in Database for exporting purpose
  • Strong project management skills with good working knowledge and understanding of business and operational processes
  • Ability to interact and work with internal & external stakeholders/vendors/clients at all levels.
  • Self-aware, reflective and able to learn from mistakes, with an ability to learn quickly while on the job

TECHNICAL SKILLS

Languages: VBA, SQL, DAX(Excel), Tableau

Databases: MS-Access 2.0/97/2000/XP/ 2002/2003/2007

Operating Systems: WINDOWS NT 4.0, WINDOWS 98/95, WINDOWS XP, MS DOS

Tools: MS (Access, Excel, Word PowerPoint)

Other skills: VLOOKUP, Pivot table, VBA

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer Data Analyst

Responsibilities:

  • Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.
  • Work with business teams in various areas of field sales to develop reports or address data needs to provide reporting solutions
  • Maintain and manage advanced reporting, analytics, dashboards and other BI solutions using both Tableau and Power BI but not limited to it, which includes other reporting tools like ThoughtSpot
  • Perform and document data analysis, data validation, data mapping/design, by accessing multiple sources, specifically data residing in data warehouses
  • Synthesize and translate Business data needs into creative visualizations in Tableau
  • Extract, Upload and Manipulate data on Enterprise Business Intelligence Software
  • Write SQL query and perform table joins and complex data merges
  • Manipulate Tables on Excel and Import to SQL using Enterprise Business Intelligence
  • Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs
  • Identify and translate business needs and requirements into customized design and implementation of intuitive information dashboards, reports, and visualizations that are optimized for performance and use best practices
  • Manipulate data on Salesforce for Visualization purpose.
  • Create complex reports on Adobe Analytics
  • Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
  • Interpret data, analyze results using statistical techniques and provide ongoing reports

Confidential

Tableau Developer/ Data Analyst

Responsibilities:

  • Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs
  • Data migration and Data validation/Testing through MS Access and MS Excel
  • Wrote VBA codes for automated transferring of data between spreadsheets and work books
  • Wrote VBA codes for exporting queries from Access Database to Excel
  • Importing of data to Access and SQL Server from flat files and Excel spread sheets
  • Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions
  • Maintained Access database for the purpose of extracting reports
  • Developed interactive Tableau dashboards for presentations purpose
  • Worked with the Business users to understand what reports were critical, non-critical and not needed.

Confidential

Data Analyst

Responsibilities:

  • Created an MS Access database to collect data systems in order to provide lists, status reports and management overview reports
  • Created BI reports in Tableau, Power BI, pivot charts, graph and other visualization format to Analyze trends
  • Created Dynamic Charts/Graphs in MS Excel and MS Access using VBA
  • Imported data from pre-existing text files and excel spreadsheets
  • Generated the necessary BI reports and information to litigate tax appeals for properties
  • Assisted Business Analysts in gathering requirements for Development purpose
  • Documented weekly meetings with internal and external Stakeholders
  • Created Dynamic Charts/Graphs in MS Excel and Access for biweekly/Monthly reporting purpose
  • Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions
  • Communicated with external business vendors/clients and other general administrative tasks as assigned

Confidential

Data Analyst

Responsibilities:

  • Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas per business needs
  • Data migration and Data validation/Testing through MS Access and MS Excel
  • Wrote VBA codes for automated transferring of data between spreadsheets and work books
  • Wrote VBA codes for exporting queries from Access Database to Excel
  • Importing of data to Access and SQL Server from flat files and Excel spread sheets
  • Manual review and correction of numerous errors and gaps for dataset using Data Analysis Expressions
  • Maintained Access database for the purpose of extracting reports
  • Developed interactive Microsoft Excel dashboards for presentations purpose
  • Worked with the Business users to understand what reports were critical, non-critical and not needed.

Hire Now