Data Sql Server

Meghana Email:*******.*******@*****.***

Tableau Developer Contact: 989-***-****

Professional summary:

Around 5+ years of Experience in Information technology and a decent expert involvement in Business necessities gathering, business knowledge, improvement, Testing, documentation, coding, product design, great management skills. Capable for comprehension extends in various levels and business Intelligence implementation and maintenance, Data warehousing, great in web application improvement.

Professional experience on Tableau Desktop and Server. (Tableau versions 7 / 8 / 9/10.1)

Analyzing and acquire experiences into large data sets, create visually compelling and actionable interactive reports and dashboards.

Define specifications, design, and build of Tableau desktop reports and dashboards.

Installation setup, performance tuning, user management and other administration of Tableau Server.

Professional expert in Data Visualization development using tableau to creating complex, intuitive and dashboards.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.

Implemented Data blending on multiple data sources and generated interactive dashboards.

Used Performance monitoring tool of tableau desktop to analyze the performance of data heavy dashboards and implemented the best practices to improve the end user experience.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets

Expert in designing customized interactive dashboards in tableau using marks, Action, filters, parameters, Security Concepts, calculations, and relationships.

Expert in RDBMS concepts and constructs along with Database objects creation such as tables, Index’s, stored procedures, Views, user Defined functions, Triggers, and cursors.

Extensive knowledge in creating Tableau scorecards, bar graphs, dashboards using stack bars, geographical maps, scattered plots, Gantt charts using show me functionality.

Good experience in Software Development Life Cycle like project documentation design, testing and production development.

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.

Uses OBIEE for creating Datasheets.

Involved in the installation of Tableau Server Application software, Tableau Desktop 8.0.

Good experience on Databases skills with testing complex SQL & PL/SQL queries.

Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.

Expert in modeling, Extraction Transform and Loading (ETL) using DTS and SSIS

Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS. Proficient in handling parameterized reports in SSRS.

Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling

Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server

Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact, and Dimensions tables.

Having knowledge on ETL tools like Informatica and all Informatica Designer tools including (Source Analyzer, Warehouse Designer, Transformation Developer, and Mapping Designer).

Extensive knowledge on various Internet-related platforms with specialization in SQL, PL/SQL, HTML and XML.1

Good communication skills, collaboration and building skills, ready to work with new team employees, flexible to work in different project levels.

Technical Skills:

BI Tools Experience:

Tableau (Desktop 7 to 9, Tableau Server and Reader), Power BI, OBIEE

Data warehousing ETL Tools:

Informatics Power Center 8 .X,7.X

Operating Systems:

Windows 95/98/XP/2000/2003, UNIX, Linux.

Languages:

HTML, CSS, JSP, SQL, PL/SQL, Java, C.

Databases:

Teradata, ORACLE 9i, 10g, 11g, DB2, MS SQL Server 2012, and MS-Access.

Software Packages:

MS-Office 2003, Microsoft Word, Excel and Power Point.

Database Tools:

Toad, SQL Navigator, SSRS,SSAS,SSIS

PROFESSIONAL EXPERIENCE:

Client: Verizon Wireless Tampa, FL Feb 2016 - Present

Title: Tableau Developer

Roles and Responsibilities:

Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.

Worked in Tableau environment to create dashboards like Yearly, monthly reports using tableau desktop & publish them to server.

Converted Excel Reports to Tableau Dashboard with High Visualization and Good Flexibility.

Developed formatted, complex reusable formula reports.

Used advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.

Created affinity analysis dashboard and Radical charts for better understanding data.

Used Trend Lines, Reference Lines and statistical techniques to describe data.

Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Radical chart Geographic maps, Line chart, Pie charts and etc.,

Created Financial reports, Demographics. This report explains the Company profit and employee relationships and we calculated using norm for comparison.

Used Context filters and Created Geographic map reports which explain the company financial keys according to the members.

Created Sets, Groups, and Data Bins as per user requirements.

Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.

Created views using various axes like Individual Axes, Dual Axes.

Created Data extracts for better performance and accessing data offline.

Used parameters and input controls to give users control over certain values.

Implemented Data blending with multiple data sources on a single worksheet for data analysis.

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

Cleared errors according to business requirements excel sheet and helped to create Documentation for the dashboards.

Created and Published Tableau Dashboards into Tableau Server.

Also used Power BI for reporting.

Writing SQL queries for data validation by using join conditions.

Created SQL Documentation for Benchmark queries and implemented new methods for better performance.

Provided support for Tableau developed objects and understand tool administration.

Involved to create Documentation for debugging report for Tableau.

Developed the table documentation for Tableau Dashboards.

Environment: Tableau Desktop9.3, Tableau server, Microsoft SQL Server 2012.

GE Health Care, Milwaukee, WI Aug 2015- Jan 2016

Title: Tableau Developer

GE Health Care provides medical imaging and information technologies, medical diagnostics, patient monitoring systems, drug discovery, bio pharmaceutical manufacturing technologies and performance solutions services.

Responsibilities:

Assisted QA with writing test cases/scripts, project migrations and developing technical documentation.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.

Created Cascading dashboards, data extracts Action filters for better performance of Tableau.

Used data sources like SQL, Oracle, Sales force, SSAS cubes and files to generate reports in Tableau.

Utilized Tableau products to rapidly generate impactful, interactive visualizations (Reports & Dashboards).

Involved in reviewing business requirements and analyzing data sources form Teradata Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Implemented swapping measures as a parameter for bars and tables in tableau.

Created users, groups, security roles and SSL authentications.

Restricting data for particular users using Row level security and User filters.

Created adhoc reports to users in Tableau by connecting various data sources.

Used Power BI for creating reports.

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.

Environment: Tableau 8.1, SQL Server 2012, SSAS,SSIS, SSRS, Import/Export tools,PL/SQL, SQL Server Agent, T-SQL, SVN source control.

Client: Birla soft, Bangalore, India Feb 2012-June2015

Title: Tableau developer/SQL BI developer

Roles and Responsibilities:

Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.

Involved in design and development of two main technological components, a Database to store data of all transactions related to each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.

Patient Record Dashboards for patient visiting doctor information and pharmacy bills, medical assistance, insurance track records and all categories included in this dash board.

Origination Profit Analysis Dashboards: As is the case in any business, hospitals are always looking for ways to reduce costs and increase revenue.

Patient Claim Payouts by Region this dashboard useful to find patient insurance claims records and payments

Involved in the publishing of various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.

Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.

Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.

Involved in created stored procedures, views, and custom sql queries to import data from sql server to tableau.

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

Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.

Involved in conducting training to a user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop

Involved a key member in the development of E-R modeling (Logical design) of database incorporating business logic and user requirement

Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.

Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.

Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.

Published Reports, workbooks & data source to the server and exporting the reports in different Formats.

Good experience in using URL’s, Hyperlinks, Filters for developing Complex dashboards

Education:

Bachelor of Technology(JNTU) - India

Contact this candidate