Chandana kasineni Email: ac4mt5@r.postjobfree.com

Sr. Tableau Developer/ Data Analyst Ph No. 240-***-****

Background Summary:

●Around 7 years of experience in Data warehousing and Business Intelligence technologies

●4+ years of data visualization using Tableau Desktop versions 8.1/9.x/10, Tableau Reader, Tableau Public, and Tableau Server.

●Creating SAS datasets, reports, tables, listings, summaries and graphs according to specifications given in SAP and departmental guidelines in the SOP on Windows and UNIX platforms.

●Generating tables employing various SAS data steps and procedures with Statistical SAS procedures, graphs and plots.

●Created dashboards by using Level of Detail concept (LOD’s)

●Produced attractive visuals/dashboards to convey the story inside the data publishing and presenting dashboards on web and desktop platforms

●Administered user, user groups, and scheduled instances for reports in Tableau Server

●Technically hands-on commercially experience mainly with full range of BI Skills with Tableau 8x,9X Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server, SSIS, SSAS, SSRS, MS Performance Point Server (PPS 2007)

●Expertise in SQL, Advanced SQL, PL/SQL for communicating with different databases.

●Expertise in Tableau BI reporting tools & Tableau Dashboards Developments & Server Administration

●Designing, building and deploying, publishing data analysis reports/dashboards for large volumes of data

●Mastered in creating solution driven dashboards by developing different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

●Extensive experience in creating several reports such as drill down, drill through reports, parameterized reports, linked reports, Heat Maps, Dual Charts, Action Dashboards and cascading reports using Tableau

●Experience in configuring reports from different data sources using data blending

●Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security

●Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems

●Expertise in Desktop creating and integrating Micro Strategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes

●Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.

●Experience designing dashboards for leadership connecting to Tableau’s PostGres SQL database.

●Experience on working different types of projects like migration projects, new projects, Ad-hoc reporting and exploratory research to guide predictive modelling.

●Worked on migration of SAP crystal reports to Tableau.

●Good knowledge of Business Intelligence/Data Warehousing BIDW Fundamental architecture concepts, dimensional modeling, requirement gathering.

●Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing (UAT).

●Proven as a dedicated, worth full and energetic well-rounded Business Intelligence/DWH background professional in growth oriented reputed organizations that gives me scope to apply my knowledge and skills

●Proficient in developing Entity-Relationship diagrams, Star/Snowflake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse

●Self-motivated high-energy person who enjoys challenging assignments and good at working on multiple engagements.

●Experience working on both Waterfall and Agile methodologies.

●Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects

●Strong knowledge of Software Development Life Cycle (SDLC)

●Ability to interact professionally with a diverse group including executives and managers

●Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.

Education: Bachelors of Technology in Computer Science.

Technical Skills:

BI Tools

Tableau 9.x/10 Micro Strategy, SSRS

ETL Tools

Alteryx 10, Microsoft SQL Server Integrated Services(SSIS)

Requirements Management

Requisite Pro, Microsoft Office (Word, PowerPoint Excel); Jira

Front End Tools

Microsoft Project, Microsoft Office, Visible Analyst

Databases

Teradata 13.10, Oracle, SQL Server, DB2 etc, Impala, Hive

Document management

Visual Sourcesafe 6.0, Sharepoint, Ultraedit, Documentum

Programming Languages

C, C++, HTML, SQL, Advanced SQL, PL/SQL, XML, R, Python

Data modeling

Power Designer, MS Visio

PROFESSIONAL EXPERIENCE

Client: DrFirst, MD

Sr. Tableau Developer/Data Analyst June 2016 to Present

Project involves creating the dashboard for reports involving Patients visit to Clinics, Medications Prescribed, Sales of Drfirst products, Income generated on prescriptions and future prospects. Some of the reports were deployed based on user requirement for weekly, monthly, quarterly and yearly and few ad-hoc dashboards. Reports are generated based on the data received from various Hospitals around the country that use DrFirst services.

Responsibilities:

●Experience in gathering techno-functional requirements and to oversee the end to end development and deployment of the solution.

●Expertise in creating dashboards by extracting data from different sources.

●Created dashboard using parameters, sets, groups and calculations.

●Extensively experienced in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

●Interacted with stakeholders to get a better understanding of client business processes and gathered the business requirements.

●Facilitated board meetings and acted as a liaison between parties impacted by the change requests.

●Experience in creating calculated fields, mapping and hierarchies.

●Created drill through reports in dashboard.

●Prepared Workflows and Marcos using Alteryx Designer 10.5v

●Configured in creating data blending in case of merging different sources.

●Experience in creating a dual-axis bar chart with multiple measures.

●Mastered in extraction, transformation and loading of data directly from different source systems like flat files, Salesforce, Oracle, Teradata and SQL Server.

●Developed LOD reports on various KPI’s.

●Performed Tableau type conversion functions when connected to relational and SAP BW data sources.

●Maintained and Installed Tableau Server in all the environments.

●Created incremental refreshes for data sources on Tableau server.

●Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.

●Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

●Created report schedules, data connections, projects, groups in Tableau server.

●Experience in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

●Created Tableau reports for Utilities like Gas and Electricity, Corporate Expenses etc.

●Manages platform admin functionalities including installations/configuration, upgrades, patches, change management, performance tuning, standards/ best practices, mentoring, metadata management, cluster/distributed management, cache/ history management, user management, scheduling.

●Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.

●Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau 9.0, Windows, SQL Server, Excel, Alteryx Deisgner10.5 and other internal source applications

Client: American Tower, Boston

Tableau Developer/Data Analyst Jun 2015 to May 2016

Project: Compliance Analysis and Reporting

The project is to develop Analytical visualizations and reports for Compliance Analysis and Reporting team within Enterprise Information Security Line of Business. To document Best Practices of Tableau which can be then shared with other teams. Also to lay foundational processes documentation across Tableau Working team members in Enterprise Information Security Continuous Monitoring Reporting scope.

Responsibilities:

Responsible for Tableau Server Installation, Configuration, Maintenance, Security, creating users, groups, projects, assigning access levels. Production support for monitoring server health

Development of ETL processes based upon complex SQL queries retrieving data from various sources for creating dimensions and cubes, and loading data using Turbo Integrator.

Highly knowledgeable in concepts related to Data Warehouses Schemas Star Schema modeling, and Snowflake modeling and processes.

Performed conversion of Micro strategy reports to Tableau Workbooks.

Performed Extraction, Transformation and Loading (ETL) processes using Alteryx Tool.

In charge of the team that built the shared Tableau Platform over the virtual environment.

Involved in setting-up Tableau Server platform in clustered environment and performing content upgrades.

Established Best Practices for Enterprise Tableau Environment and application intake and development processes.

Various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, Actions, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.

Created different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Worked on Pareto charting, advanced calculations, work with demographic and geographic fields for Geo mapping.

Created drill through reports in dashboard.

Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Involved in creating data blending in case of merging different sources and a dual-axis bar chart with multiple measures.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.

Actively participated in clarification meeting with the Clients.

Created Test Cases and documented the Test Results.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Connected to Data using both live and extract.

Understanding of relational database structures, theories, principles, and practices.

The ability to interact professionally with a diverse group, including executives, managers, and LOB's.

Involved in license management SLA’s with Tableau support.

Handle changes in data source such as field addition, deletion or name changes. Sharing visualizations with business users.

Combine visualizations into interactive dashboards and publish them to the web.

Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.

Executed and tested required queries and data before publishing Dashboard.

Used advanced features of T-SQL to design and tune T-SQL to interface the database and other applications in most efficient manner.

Environment: MySQL, Oracle, Essbase, Teradata, Micro Strategy 9.4.1,9.3/8.1, Source System Applications and Data Visualization Tableau 8x Desktop and Server, MS Excel.

Tech Mahindra Feb 2013 to May 2015

Tableau Report Developer/Data Analyst

The project involved automation of the client billing reporting system. Data was extracted from multiple source systems and moved into a single data warehouse, which was later used to create billing reports for the client. The automation process involved nightly run of DI jobs to capture changed data and update the data warehouse with new data. Consolidating data from different sources like DB2, SQL Server & Oracle for data manipulation and data cleansing purpose using SAS Data Integration Studio 4.2 and SAS Enterprise Guide.

Responsibilities:

Extensively used data blending, embed functionalities in Tableau.

Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.

Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.

Streamline the various reports for automation purpose using Base/SAS and Macros.

Administration activities using SAS Management Console.

Interact professionally with diverse group of professionals in the organization including managers and executives.

Developing Auto-generated Narrative documents in SAS.

Produced reports in PDF and RTF format by using SAS ODS.

Creating analysis dataset for quality check of SDTM datasets.

Created area map to find out customer base usage within United States and found gaps in areas where Vonage lacked coverage due to internet service provider.

Created quick filter to narrow down individual states and cities along with revenue being generated in individual state or city.

Created side by side bar chart comparison of Vonage users who were domestic vs. international along with providing profit revenue generated.

Experience in standardizing Tableau for shared service deployment.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.

Creating users, groups, projects, Data connections, settings as a tableau administrator.

Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.

Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Developed Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.

Gathered user requirements, analyzed and designed software solution based on the requirements.

Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.

Defined best practices for Tableau report development and effectively used data blending feature in tableau.

Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.

Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.

Performed SQL reporting with the ability to create SQL views and wrote SQL queries.

Environment: SAS 9.1, SAS/BASE, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, UNIX, SQL, Windows 2000/NT.

Tableau Desktop 8.0, Tableau Server 8.0, Microsoft Office 2007, SQL Server 2008, Advanced SQL, PL/SQL, T-SQL.

TechMahindra, India Jun 2011 to Feb 2013

Data Analyst

Company hosts a very large database system and other operational databases. Central data repository is setup to capture metadata about many internal operational information sources.

Responsibilities:

●Interacted with business users and performed Gap Analysis of Client requirements

●Elicit business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.

●Performed Analysis of Reference Data, Data sets and Asset classes to bring data into the central repository.

●Worked extensively with MS Visio and Rational tools to document requirements.

●Created the AS-IS and TO-BE process flow diagrams.

●Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions

●Defined functional business requirements, analyzed client requirements, and generated workflow processes

●Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.

●Assisted in project management activities like planning, development, task allocation, project execution

●Provided full project life cycle flow charting, analysis and documentation.

●Responsible for extracting, transforming, and loading data from ODS, flat files and placing it into data warehouse.

●Designed, developed, and tested the jobs using Data stage

●Involved in some part of performance tuning.

●Developed simple and complex jobs using Data stage to load dimensions and fact tables as per STAR schema techniques.

●Created Data Definitions and help maintain Metadata repository.

●Utilized Erwin for reverse engineering the database from DDL scripts.

●Experience in using Micro Strategy in creating and managing reports for an organization.

●Created documentation, worked with users for new module enhancements and testing.

●Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using Micro strategy desktop.

●Defined Hierarchies and drill functionality within Micro Strategy.

●Interacted with the End users on a regular basis for resolving issues pertaining to the reports.

●Defined project milestones, schedules, monitoring progress and updating plans using MS Project.

●Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.

Environment: Oracle, Toad, Data stage, Micro Strategy 8.0.2/7.5.2, 8.1.2 Product Suite (Administrator, Architect, Desktop, Object Manager, Enterprise Manager, Narrowcast Server,), UNIX, Microsoft (Word, Access, Excel, Outlook), MS VISIO, MS Project.

Contact this candidate