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.
