Business Data Analyst/ Tableau Developer Resume
San Jose, CA
OBJECTIVE:
Skilled IT professional with 6.5 +years of experience in consulting on for profit and non - profit projects. Hands n experience with data & business analysis and business process re-engineering. A team player with client’s vision and goal at the fore front of every creative and practical solution.
SUMMARY:
- Over 6.5 + years of professional experience as Business Data Analyst and Tableau Developer.
- Experienced in producing various documents like Business Requirement Document (BRD), Functional Requirements Documents)/Non-Functional Requirements, User Acceptance Test cases and User Manuals.
- Involved in creating the report mock ups, proto types for the end dashboards and interacting with stakeholders for report change request and sign -off on the requirements.
- Experience in using Tableau functionalities for creating different Requests, Filters, Charts, and Interactive Dashboards with page and dashboard Prompts.
- Experience in creating Aggregates, Hierarchies, Charts, Histograms, Filters, Quick filters, Table Calculations, Trend lines and calculates measures, LOD expressions Sets, Groups, Actions, Parameters etc., in Tableau.
- Interacted with the Business users during the various stages of the project lifecycle to identify various KPI's and designed solutions to enhance business decision making.
- Prodigy in creating different visualizations/Dashboards using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables, Page Trails and Density Chart.
- Experienced in creating Ad-hoc dashboards using joins, merges, sets and hierarchies.
- Good knowledge of User Authentication and Authorization in Tableau Server.
- Experienced in developing strategies for Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica.
- Working experience with Big Data and Hadoop File System (HDFS).Knowledge of Pig and Hive's analytical functions, extending Hive and Pig core functionality by writing custom UDFs.
- Wrote Stored Procedures in T-SQL for data interaction with SQL server.
- Experienced in handling Scrum projects, including blending Agile practices with existing processes as well as gaining executive and organizational support for transitions to Agile practices.
- Collected data points required for the dashboard from various sources.
- Identified data gaps in different sources and engage the required groups to address the gaps.
- Validated the data from various data sources.
- Used the elicitation techniques such as JAD, Interview, Brainstorming and Focus groups.
- Facilitated requirements gathering and sign-off and translates into technical requirements.
- Accomplished UAT (user acceptance testing), Functionality Testing, Unit testing, System Testing, Integration Testing and Regression Testing.
CORE COMPETENCIES
- Business/Data Analysis
- Data Migration
- Project Documentation
- Process Improvement
- Stakeholder Relationship Management
- Test Cases & Scripts
TECHNICAL SKILLS:
Business Intelligence Tool: Tableau, Qlik Sense, SSRS,Alteryx, SAP BO,IBM Waston Analytics.
Databases: MS SQL Server, Oracle.
Languages: SQL, UML 2.0, VBA Excel,Python.
ETL: Informatica, SSIS.
Requirements Management Tools: Rational Requisite Pro, Aris.
Methodologies: Waterfall, RUP, Agile, SCRUM, ITIL, XP.
Business Process Modeling Tools: MS Visio, Rational Rose, Enterprise Architect Ver7.0.
Front End Tools: MS Office, Microsoft Project & Visio.
Operating System: 2000/NT, XP, Vista, Windows 7
PROFESSIONAL EXPERIENCE:
Confidential, San Jose, CA
Business Data Analyst/ Tableau Developer
- Generated Tableau Dashboards like Generated Report for Top Customers showing booking & pipeline for different fiscal quarters, Pipeline Tracking comparison SFDC v/s Smartsheet, Qualified leads every month, Monthly sales cycle, Number of leads at each stage of Pipeline.
- Created Tableau Data extracts for improving query performance and enable efficient in-memory data access on Tableau Data Engine.
- Prepared ad-hoc reporting to enable the sales operations to prioritize the SAVM accounts based on bookings and P2B, SFDC pipeline.
- Collect the data, scrub the data, analyze the data and interpret the data.
- Performed Data validation using SQL scripts to identify the duplicate records and performed data profiling to identify the anomalies in a metadata.
- Validated data coming from third party data providers to ensure data quality and re-usability through data profiling and source to target mapping and provided scalable solutions to ensure data quality.
- Created Quarterly reports to show overall pipeline value by division and by key accounts, along with segmenting all sales leads in the CRM system by estimated value, sales stage, close probability, and expected close date.
- Involved in development of Informatica mappings/sessions/workflows to load the data related to Customer, sales Hierarchy.
- Pull data from different sources like Sql server, applications (SFDC) and Flat Files using Informatica Power center 9.5.1 and loaded it into Teradata.
- Exporting data from RDBMS to HIVE, HDFS and HIVE, HDFS to RDBMS by using SQOOP.
- HiveQL scripts to create, load, and query tables in a Hive to perform analysis on webex customer’s.
- Identification & cleansing of incorrect information including duplicates, bad addresses and other "quarantined" accounts to identify "winning" and "losing" accounts based on agreed business logic.
- Mapping of CI account structures to Salesforce Accounts.
- Generated reports based on data pulled from Confidential , SFDC Pipeline Report, other.
- Created comprehensive and accurate functional specifications; Data Mapping, and process flow.
- Gathered Requirements, interacted with the Project lead and SMEs to get a better understanding of the Business Processes.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Created different KPI's using Table calculations and calculated key figures Manipulating Strings, Arithmetic Calculations, Aggregation Options and Logical functions.
- Developed a 360-business dashboard with multiple panels and Parameters.
- Created actual sales and target sales view with Trend lines, Table Calculations to see the difference between each quarter.
- Responsible for creating Metrics, Filters, Calculated fields, parameters using Tableau Desktop.
- Developed various POC (proof of concept) models based on the minimal available data.
- Developed & Maintained the Tableau dashboards by loading, blending the data from Anaplan, and built them using Advanced Tableau functions and publishing the same on Tableau server, allowing executive management to view.
- Developed Complex cross tab Reports. Used advance charts like Dual Axis charts, Bullet Graphs, Stacked bar, Trend Analysis, Histograms in Data Visualizations. Effectively used context filters, action filters and data source filters to improve the performance of the reports Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Dashboard etc. in Tableau.
- Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
- Restricted data for users using Row level security and User Filters.
- Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
Environment: Tableau (Desktop)10/10.2, Microsoft Sql server, Confidential SAP BO, Salesforce, Informatica, smart sheet, UAT, Puma, Microsoft office, Agile, Anaplan, Oracle, Hadoop.
Confidential, Bloomington, Illinois
Business Data Analyst
Responsibilities:
- Utilized corporation developed Agile SDLC methodology.
- Conducted user interviews, gathered requirements, and analyzed the requirements.
- Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
- Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
- Analyzed and reviewed System design and client requirement.
- Gathered the data and resolved various quality problems associated with the data.
- Exported data from HDFS environment into RDBMS using Sqoop for report generation and visualization purpose.
- Used different features of Tableau to create drill-down, filter and interactivity based on user requirement Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Developed Tableau workbooks from multiple data sources using Data Blending.
- Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data.
- Connected Tableau server to publish dashboard to a central location.
- Designed, developed and supported BI solutions, involved in Debugging and monitoring, and troubleshooting issues/tickets.
- Performed QA on BI application developed using tableau for clients.
- Validated system against the specified requirement. Participated in status update meetings.
Environment: Agile, Tableau, Hadoop, SQL server, UML, UAT, SDLC, Rational Rose, Rational Requisite Pro.
Confidential
Data Analyst
Responsibilities:
- Applied Business Rules and met with the different pharmaceutical departments in order to understand and obtain necessary regulatory information to construct quality requirement documentation.
- Responsible to visit client sites to analyze the patient records and collect data required to audit the government health measures compliancy, records and documents all member and provider outreach activity.
- Prepared a High level document describing detailed artifacts required to perform a Bronze Level Compatibility review for Electronic Data Capture (EDC) product.
- Assisted in creating detailed technical design after understanding the 'AS IS' business process and the new requirement. The created technical design will reviewed internally and sent to client to get approval.
- Facilitated meetings with the product owners, scrum master, project coordinator, SME’s and development and testing team.
- Conducted meetings with user groups and internal stakeholders to gather, understand, and document product/service requirements. Developed acceptance criteria to test user stories in sprint planning meeting.
- Developed ETL's for Data Extraction, Data Mapping and data Conversion using SQL and various ETL scripts.
- Extensively used ETL to load data from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
- Created multiple visualization reports/dashboards using Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
- Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
- Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
- Assessed the status of the organization to determine the scope of the application for Gap Analysis.
- Enabled Drill options like Drill down, Drill up, merge dimensions, sections, filters, Hide Sections/rows/tables, set values and rules
- Developed Tableau workbooks involving advanced analysis techniques like Sets & Filters, Data Grouping/Visual Grouping, Computed Sort features and maps.
- Maintained metrics that provide visibility to stakeholders on program-level plans, progress and quality to ensure commitment to the quality. This information may take the form of various Scrum artifacts, from backlogs to burn-down charts.
- Assisted Project Manager in documenting Project Charter using MS Project and actively involved in planning phase (WBS, Schedule and Resource Planning) of Project Management.
- Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project.
- Maintained the quality of data analysis, researched output and reporting, and ensured that all deliverables met specified requirements.
- Created mapping specification spreadsheets to document the transformation logic.
- Analyzed and interpret trends or patterns in complex data sets.
- Performed data analysis and data profiling using SQL queries on various sources.
- Created source to target mapping documents of data mart for all sources.
- Using T-SQL to monitor the performance of test cases used to test data quality and modify test cases accordingly.
- Assisted Project Manager in documenting Project Charter using MS Project and actively involved in planning phase (WBS, Schedule and Resource Planning) of Project Management.
Environment: Windows, IE8, UML, Agile Methodology, SSIS, SSRS, Tableau, MS SQL Server 2012, AWS, Oracle, Java, HTML, MS Office Suite (Word, Excel, PPT, Visio).