We provide IT Staff Augmentation Services!

Sr. Data Analyst Resume

3.00/5 (Submit Your Rating)

Plano, TX

SUMMARY

  • Sr. Data Analyst offering 5 years experience on business and systems requirements, user acceptance testing, process improvement and end - user training.
  • Experience developing business intelligence to improve business operational planning and implementation.
  • Knowledgeable about business best practices, regulatory standards and optimal control systems. Applied trend and pattern knowledge to bring dramatic improvements.
  • Built Tableau dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
  • Involved in trouble shooting of performance issues which were associated with Tableau reports.
  • Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
  • Experience in efficiently using standard Business Content, extending and enhancing according to the report requirements.
  • Expert in design/development using Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
  • Proficient in creating Calculations like Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals and Formatting with Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding using Tableau Desktop.
  • Extensive Knowledge in use of MS Office tools like MS Access, MS Word, MS Excel, and MS PowerPoint MS Project.
  • Outstanding knowledge in writing complex SQL queries.

TECHNICAL SKILLS

  • Tableau
  • SQL
  • Data collection and analysis
  • Excel
  • SSRS

PROFESSIONAL EXPERIENCE

Sr. Data Analyst

Confidential, Plano, TX

Responsibilities:

  • Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
  • Built dashboards for measures with forecast, trend line and reference lines.
  • Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
  • Orchestrated smooth and effective flow of organizational data to support multiple users.
  • Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
  • Established online configuration knowledge base to support functionality by developing robust system application overview.
  • Created workflow diagrams and Gantt charts to clearly demonstrate business processes and timelines.
  • Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
  • Achieved 70% success in automation by analyzing claim operations, data and system issues to identify discrepancies for troubleshooting and corrective action.
  • Developed KPI metrics derived from company data to track improvements in organizational efficiency.
  • Reviewed files, records and other documents to obtain business information and key data in order to respond to development requests.
  • Synthesized current business intelligence data to produce reports and polished presentations highlighting findings and recommending changes.
  • Assessed impact of current business processes on users and stakeholders and evaluated potential areas for improvement.
  • Assessed strategic implications of business intelligence data for improvement in process areas.
  • Evaluated consistency and importance of different business intelligence data against needs to determine optimal courses of action.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Generated context filters and data source filters while handling huge volume of data.

Data Analyst/Tableau Developer

Confidential, Jersey City, NJ

Responsibilities:

  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Worked with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
  • Created and improved intelligence resources to facilitate consistent results.
  • Coordinated statistical data analysis, design, and information flow.
  • Fine tuned SQL Queries for maximum efficiency and performance.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Evaluated patterns and previous trends to understand competitive environments and assess current strategies.
  • Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields.
  • Updated organizational and streamline subsystems to improve and streamline data collection.
  • Performed system analysis, documentation, testing, implementation and user support for platform transitions.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Created various Excel documents to assist with pulling metrics data and presenting them to give concise understanding of best placement for needed resources.
  • Evaluated consistency and importance of different business intelligence data against needs to determine optimal courses of action.
  • Documented business workflows for stakeholder review.
  • Transformed project data requirements into project data models.
  • Recommended data standardization and usage to ensure data integrity.
  • Identified and documented detailed business rules and use cases based on requirements analysis.
  • Developed database objects, including tables, views and materialized views using SQL.
  • Identified and documented project constraints, assumptions, business impacts, risks and scope exclusions.
  • Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2008 Reports Services (SSRS).
  • Synthesized current business intelligence data to produce reports and polished presentations highlighting findings and recommending changes.

Data Analyst

Confidential

Responsibilities:

  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Coordinated statistical data analysis, design, and information flow.
  • Developed database objects, including tables, views and materialized views using SQL.
  • Designed and developed schema data models.
  • Created different KPI using calculated key figures and parameters.
  • Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
  • Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
  • Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
  • Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

We'd love your feedback!