Data Analytics & Visualization Associate Resume
Nyc, NY
SUMMARY:
- High - skilled BI professional having 6+ years of experience spearheading numerous on-site and off-site projects and ensuring delivery into areas of insights and analytics, such as Survey Synthesis, incorporating Market Intelligence studies, augmenting Financial Health Assessments, Customer Segmentation Analysis, Predictive Analytics, Forecasting, Data Harmonization, and Developing Interactive Dashboards.
- Expertise in handling large data sets, insights generation, output interpretation, BI automation and advanced visualizations.
- Successfully enabled Tableau as a technology and self-service data visualization for several clients of Tableau Software.
- Managed Expert Help Desk program for Tableau and Confidential . Tableau outsourced this program to Confidential globally.
- Solved hundreds of complex problems in Tableau Desktop for Tableau users across North America. Served as Tableau medic to handle these requests in Real-time.
- Designed and developed interactive user’s stories and dashboards for 10+ functional areas and integrated by highlighting key metrics for executive management team to gain foresight into internal projects, functional towers, utilization and performance trends providing capabilities to answer really hard "what if Questions".
- Interacted with senior decision makers assisting them with Actionable Analytics using Tableau Software
- Setup Tableau Server for a multi-clustered environment
- Trained team members to build high-performance visualizations implementing Confidential ’s “Monitor Detail Analyze” framework for visualization best practice
- Automated batch and extract refresh for Tableau Software and performance tested visualizations
- BI Assessment, BI Roadmap and Strategic Consulting
- BI Platform Architecture and Administration
- BI Solution Design, Development
- Self Service BI, Data Discovery and Data Visualization
- Dashboards and Reporting
- Data Integration and ETL
- Data Analysis, Data & Dimensional Modeling
- Data Governance, User /Content Management
TECHNOLOGIES:
Data Visualization & Data Discovery: Tableau 8.x, 9.x, 10.x, Oracle, SQL, AWS Redshift
Reporting Tools: SAP Business Objects, Microsoft Office
Data Integration & ETL: SQL Server Integration Services, Alteryx, Snowflake
Database: Microsoft SQL Server, Oracle, Hive, Alation.
Industries: Manufacturing, Telecom, Energy, Retail, Logistics
Functional knowledge: Pricing, Procurement, Supply Chain
PROFESSIONAL EXPERIENCE:
Data Analytics & Visualization Associate
Confidential, NYC, NY
Responsibilities:
- Successfully delivered Tableau demo to financial clients followed by implementation of dashboards.
- Trained Financial clients and provided possible solutions and workarounds for interactive tableau dashboards
- Implemented tableau automation for date filters for leading payroll client.
- Designed and developed dashboards for leading shared space services client in New York city, followed by hands on training for analytics team new to tableau.
- Design and documented workflows for Alteryx book 2019.2.
- Successfully delivered Tableau POC’s to leading financial brokerage clients in New York City.
Tableau Dashboards: Tableau Public: tabsoft.co/2LcQFSW
Confidential, Philadelphia, PA
Data Visualization Developer
Responsibilities:
- In developing executive reports to visualize business data of Confidential Cable Corporation.
- Responsible for communicating with Networks Engineers to explain them Metrics and Usage of Dashboards.
- Developing Crosstabs, Bar Graphs, Line charts and Maps.
- Being on call with PMO’s for live upgrades and assisting them in understanding dashboards.
- Educating users about the tool’s (Tableau, Dataverse) on how to make it useful with data views and re-arrangement of rows and columns as per there requirement and comfort.
- Interact with Business Users, Business Analyst and source system owners to gather the Requirements and Business logics.
Confidential, NJ
BI Visualization Developer
Responsibilities:
- Responsible for creating reports by communicating on a regular basis with VDSI ( Confidential data Services India) Team.
- Responsible for All VzT (Telecom) and VzB (Business) reports to be published through my supervision in production server.
- Efficiently created reports using custom shape Maps, Trails on Map and drill down maps to track installations in interior towns using Zip codes.
- Implemented calculated fields and parameters to make dashboard more user friendly for business users.
- Created Usage metrics reports on regular basis to track and analyze dashboard use by users and raise questions if the user activity goes down on certain dashboards in production.
- Developed reports using Bar charts, Line charts and cross tabs.
- Responsible for spot on root cause analysis and avoid data discrepancy and remove anomalies.
- Notify network users and engineers to update certain Sites by performing data analysis.
- Responsible to gather data from AWS for VzB create extracts for reports that require cross tab visualization.
- Responsible for creating Confidential FIOS Financial executive Reports.
Confidential, Plano, TX
Data Visualization Developer
Responsibilities:
- In Creating Tableau dashboards using Gantt Charts, Bar in Bar graphs, Line over Bar Graphs, Scattered plots, Maps, Trend Lines & Donuts.
- In Creating Tableau Dashboards with interactive views, trends and drill downs along with user level security.
- Worked on the development of Dashboard reports for the Key Performance Indicators for the top management
- In Generating Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (9.0 / 9.3/10.0/10.1 ) reports.
- Built, published and customized interactive reports and dashboards using Tableau server.
- Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Created dashboards for analyzing POS data using Tableau 9.3 on top of SAP HANA
- Extensive knowledge in various reporting objects like facts, Attributes, Hierarchies, Filters, Sets, Groups, Parameters in Tableau.
- Experience on scripting using Tabcmd and Tabadmin.
- Worked on administration tasks like adding workbook Permissions, Ownerships.
- Executive Dashboards designed with live data with high performance by placing input parameters at HANA level
- Design an online campaign to maximize relevant traffic to our business site
- Designed and developed various analytical views from multiple data sources by blending data on a single worksheet in Tableau Desktop.
- Perform “Trend Analysis” to identify the nature of the traffic flow on the site & Implemented optimization techniques to improve effectiveness of the campaign
Confidential
BI Developer
Responsibilities:
- Collected business requirements from different sources and wrote the technical specifications for building the Data model.
- Developed workbooks and dashboards using Tableau 8.3 Visualizations like Heat maps, Pie Charts, Dual Axis workbooks and Charts, Bar Graphs, Scatter Plots, Trending and Forecast dashboards, Waterfall Charts, Geographic maps using local and global filters.
- Involved in creating calculated fields, mapping and hierarchies.
- Worked creating Aggregations, calculated fields, mapping, hierarchies, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
- Preformed Statistical, Frequency and descriptive analysis in SPSS.
- Imported excel sheet data into SPSS to analyze and create a TDE Extract for tableau visualization.
- Created clean data sets for analysis both by importing and also manually creating structured variable view,
- Execute and tested required queries and reports before publishing
- Designed the ETL process to load data to the server through SSIS with a variety of data sources including Flat files, Access, Excel.
Confidential
Programmer
Responsibilities:
- Used ADO.NET (Data Adapters, Data Sets) for database connectivity to SQL Server database.
- Designed SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
- Experience in Database Normalization, Designing, Creating Indexes, Developed Queries & T-SQL Scripts in MS SQL.
- Experience in developing SSAS Cubes, Dimensions and data source views and Deploying & Processing SSAS objects.
- Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
- Created ASP.NET web forms and Class libraries containing code for business and data access logic using C#.NET.
- Developed 3 tier architecture for ASP.net front end
- Involved in developing web Pages with rich UI, AJAX, and jQuery using ASP.NET.
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
- Extract Transform Load (ETL) development Using SQL server 2008, SQL 2008 Integration Services (SSIS).
- Implemented the object-oriented programming concepts in C#, Web Forms and ASP.Net.
- Server-side code was developed using ASP.Net and C# 3.5/4.0.