Data Sql Server

Shwetha Sarma

Sr. Tableau Developer

Ph: 214-***-****

E-mail: acza8g@r.postjobfree.com

Professional summary

Over 7+ years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.

4+ years’ experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, Tableau 8 and Tableau 9.

Strong understanding of advanced tableau features such as calculated field, Sets, Parameters, R integration, dashboard actions, dual access bar chart and data blending.

Extensive Tableau Experience in Enterprise Environment and Experience including technical support, troubleshooting, report design and monitoring of system usage.

Certified Tableau Desktop 10 Qualified associate. Pursuing Tableau Desktop 10 Certified Professional.

Developed various charts which are not available in "Show Me " like Donut Chart, Alert Chart/Table, Lollipop Chart, Motion Chart, Population Pyramid, Waterfall Chart and many more.

Developed workbooks to perform Year over year, quarter over quarter, YTD, QTD, MTD type of analysis.

Hands on experience in designing Tableau dashboards, stories and reports utilizing Tableau visualizations like Bar graphs, pie chart, Line graph, scatter plot, geographic visualization and also using global and local filters to meet client requirement.

Experience including Analysis, Modeling, design and development of Tableau reports and Dashboards for analytics for reporting applications.

Experience in Creating Dashboard reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.

Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the assigned groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.

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.

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

Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables, and Physical and Logical data modeling.

Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.

Experienced in SSIS developer, SSRS and SSAS. Experience in Relational DB’s, development and design.

Hands on experience in R statistical tool. Experience in Teradata, Big Data, Hadoop, Hive and other frameworks.

Worked in designing reports for users to get critical understanding of data and strategic planning of the organization.

Experience in creating aggregates, hierarchies, charts, filters, quick filters, table calculations, trend lines calculated measures.

Created Customized and interactive dashboards using multiple data sources.

Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.

Experience in stepping up to Lead/Manager role whenever required. Trained and mentored junior team members.

Excellent written and verbal communication skills and experience in interacting with business owners both formally and informally.

Technical Skills:

Operating Systems: Windows 95/98/2000, Windows XP Professional, Windows NT.

Languages: SQL, R language

Databases: MS SQL Server 2012/2008R2/2008, Oracle 9i/10g/11g.

Tools: Tableau Server v7/v8/v9, Tableau Desktop v7/v8/v9 .x, QlikView 9.x,10.x.

PROJECTS

Sogeti USA, Raritan, NJ (Aug 2015-Present)

Sr. Tableau Developer

Responsibilities:

Involved in creating dashboards by extracting data from different sources. Created dashboard using parameters, sets, groups and calculations.

Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard. Involved in creating calculated fields, mapping and hierarchies.

Created drill through reports in dashboard. Involved in creating data blending in case of merging different sources. Involved in creating a dual-axis bar chart with multiple measures.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

Got an opportunity to work with Subject Matter experts (SME) to understand their needs.

Working on generating various dashboards in Tableau Server using different data sources such as Oracle, Microsoft SQL Server and Microsoft Analysis Services.

Performed Tableau type conversion functions when connected to relational data sources. Maintained and Installed Tableau Server in all the environments. Created incremental refreshes for data sources on Tableau server.

Monitored VizQL server, Application Server and data server activity to track performance and system stability. Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.

Administered user, user groups, and scheduled instances for reports in Tableau. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Created report schedules, data connections, projects, groups in Tableau server. Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Used trend lines extensively for correlating different KPI’s for new product launches.

Created custom Function's (Date range, Time functions, Logical functions) in the reports.

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

Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.

Consistently attended meetings with the client subject matter experts to understand functional business requirements.

Coached and developed a distributed team of business executives and technical professionals regarding Agile roles, routines and responsibilities resulting in a more thorough understanding of Scrum.

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 Server V8, Tableau Desktop V9, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, LINUX

IDEXX Laboratories, Westbrook, ME (December 2013- July 2015)

Tableau Developer

Responsibilities:

Worked on Proof of Concepts (POC) presentation and review with project and IT lead along with developing Tableau Dashboards.

Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations as per requested by CEO and CFO.

Adjust views/dashboards after initial POC presentation to CEO and CFO.

Brainstorm ideas on what to include in views/dashboards from the data source and document on the fly business requirements.

Create views and dashboards on end client's sales data. Produce powerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily by CEO and CFO.

Cleanse and normalize data in MS Excel by combining from various data sources.

Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.

Created numerous dashboards in Tableau Desktop based on the data collected from Insurance App’s by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.

Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.

Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Insurance App.

Created Crosstab’s to display underlying data based on various graphs and charts created for further data analysis.

Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.

Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling with Quick Filters for on demand needed information with just a click of a button.

Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.

Build a dashboard report in which indicates the Key Performance Indicators (KPI)

Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.

Environment: Tableau Desktop 7/8.0, Tableau Server 7/8.0, MS Excel, MS SQL Server 2008/12 R2, Win Server 2008 R2, Active Directory.

Exilant Technologies Pvt.Ltd, Bangalore, India (January 2012 – November 2013)

Business/Data Analyst/Cognos BI Developer

Responsibilities

Worked as a Data Analyst/ Business System Analyst and assisted the project manager in defining the Scope, Schedule, Business Change Management, Develop Feasibility Study Report for Preliminary Study of the Project, and Budget of the Project

Participated with individual and JAD/RAD sessions (Work Sessions) with the stakeholders (Offer Management) and the technical units (Amdocs) for business requirement gathering followed by (Agile Scrum) approach

Assisted the team members with documentations like Business Requirement Document and Use Case Specification Document by using DOORs

Assisted in Data Analysis by Data Mapping then worked with the design team in the designing of the Databases with extensive use of ERDs for Data Validation, Data Modeling, Data Migration, Reference Data Analysis, and Data Conversion

Applied SQL for cross checking Data Validation for Referential Data in SQL Server

Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.

Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required in Data Warehousing (EDW) and Data Migration by business users

Generate financial reports from Operating Statement Cube and Balance sheet Cube

Developed Complex Report Studio Reports using Bursting, Tabular Objects.

Assisted in creating Data Sample that included specific size of data from the database reflecting different data field elements’ values. Data Sample would then be compared with Source Application Systems to test the accuracy of data field elements values

Created Drill- through reports and Customized Reports with Prompts (List. Cross tab)

Developed Standard templates in Report Studio for developing reports.

Environment: MS Visio, MS Office Suite, HTML, XML, Test Director, VB, Client Server, UML, Waterfall, Windows XP, Test Director, MS Project, MS Access, MS SQL,Oracle, TOAD, Cognos 8.4, Frame Work Manager, Cognos Connection, Report Studio

Coresoft Technologies, Hyderabad, India (February 2010 – November 2012)

Business Analyst

Responsibilities:

Gathered and analyzed both legal and credit datasets, performed due diligence on deals, consulted with credit associations and business representatives, and financial ratios for the preparation of credit reviews.

Translated clients’ needs into useable mapping and coding instructions and created functional requirements document and mock ups for reporting.

Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.

Designed and implemented basic SQL queries for testing and report/data validation.

Developed and maintained reporting using in MS Excel queries and SQL. Produce performance reports and implement changes for improved credit reporting along with performing conditional formatting for data analysis.

Created Test Cases and Activity Diagrams, systems Flow Charts.

Reviewed request to determine basic characteristics, such as origin and report flow, mapping, format, frequency, distribution, and purpose or function of report.

Worked closely with the Information management groups to develop, test, and validate systems and reports, attended meetings with users and IT, documented business, technical, and systems requirements.

Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.

Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.

Environment: UML, RUP, MS Visio, Windows XP, Use-case, MS Excel, MS Power Point

Contact this candidate