Sql Developer Tableau

Praneetha Charugundla

**.*********@*****.***

Parker, CO - 720-***-****

Professional Summary

7+ years of Experience in design, analysis, development, and implementation of Various applications in environment using BI Tools.

Experience in Data Warehousing and Business Intelligence area in various domains.

Strong hands-on experience implementing dash boarding, data visualizations, and analytics using Tableau desktop and Server.

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

Good experience on in dashboards designing with large data volumes from various data sources (Sql server, Teradata etc.).

Expertise Configuring Repository, Create/Manage Dashboards, Reports/Answers and Building Physical, Business Model and Presentation Layer.

Experienced in Analyzing the BI Needs, interpreting business user requirements and translating them into reports.

Good interaction with clients, understanding Business Applications, Business Data Flow and Data Relations.

Good understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products.

Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.

Ability to handle multiple tasks concurrently and meet the deadlines.

Experience in preparing Test plans, Test Data and executions of Test Cases to ensure applications functionality meet the user requirements.

Knowledge on MONGO DB, HTML & CSS.

Education:

Bachelor of technology - Information Technology, JNT University India

Certifications:

70-461: Querying Microsoft SQL Server 2012/2014

Professional Experience

Client: AiVante October 2018 to Till Date

Role: Tableau Developer

AiVante works with people’s personal health histories, connects them with the experiences of peers in the larger population, and scrutinizes all claims and costs for links, patterns and correlations. As a result, AiVante constructs a unique and highly personalized profile of each participant. This allows participants to experience their data as personally compelling health information, and a window into their future. AiVante takes each individual’s health profile and comprehensively tests it against plan coverage terms. This allows AiVante to identify the best fitting and best value plans for each person’s unique personal health profile.

AiVante constructs tailored and exacting recommendations for clients using AiVante’s sophisticated analytics methods, personalized employee profiles, and massive databases of healthcare information.

Responsibilities:

Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on requirements

Built interactive reports and dashboards using Tableau Desktop

Analyzed data from various databases and formatted it into graphs using Tableau Desktop.

Blended data from multiple databases such as MS Excel and Oracle SQL database by assigning primary key from each database

Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers

Developed parameter and dimension-based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop

Executed and tested required queries and reports before publishing dashboards

Provided support once dashboards were published if there were any data changes, system changes, or requirement changes

Responsible for developing, maintaining, and managing advanced reporting, analytics, dashboards and other BI solutions.

Performing and documenting data analysis, data validation, and data mapping/design.

Create action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Create different calculated fields and parameters in Tableau.

Create various reports using Tableau desktop per requirements.

Develop dashboards utilizing Tableau functionality such as sets, filter, parameters, and groups.

Formulate Tableau dashboards utilizing stack bars, bar graphs, scattered plots, geographical maps.

Configure data refresh of datasets using data extract in Tableau online.

Utilize Tableau server to publish and share reports with business users.

Publish Tableau workbooks to Tableau Online with user filters so that only appropriate teams can view it.

Restrict data for users using Row level security and User Roles in Tableau.

Plan JRD meetings to gather business requirements from business users.

Utilize SQL to pull data from various databases and created various dashboards, scorecards and reports to support business decision making.

Identify problem spots of dashboards by running and interpreting performance recording.

Work with database team on optimizing at database level.

Collaborated with other developers to determine and detail overall goals and requirements.

Translated business requirements into technical requirements.

Created design specifications to meet functional and business requirements.

Developed and enhanced reports connecting to single or multiple data sources to improve performance.

Analyzed business requirements and created functional requirements specifications to build and deploy solutions.

Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs and enhancements.

Adjusted software parameters to boost performance and incorporate new features.

Monitored and troubleshot data source systems for data flaws and errors and upstream data issues.

Provided reporting, analysis and insights about sales drivers and key revenue performance metrics to support corporate analytics.

Interpreted data and translated ad hoc requirements and requests to deliver relevant and impact results.

Managed multiple projects with high degree of accuracy and attention to detail to attain Result.

Environments: Tableau desktop, Tableau public, Tableau Read, MYSQL, MS SQL SERVER, GitHUB, JIRA, MONGO DB

Client: CoreLogic January 2015 to September 2018

Role: Tableau Developer

Harness data-driven insights that provide the intelligence you need to find new prospects and stay informed on key drivers in the housing economy.

CoreLogic delivers the must-have data-driven insights for many of the nation’s top companies. From lead generation solutions to macro-economic forecasts, CoreLogic provides the intelligence our clients rely on to make smarter decisions.

Responsibilities:

Investigated and resolved production issues escalated by Tableau support team.

Created Rich dashboards using Tableau Dashboard 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.

Connected Tableau server to publish dashboard to a central location for portal integration. Connected Tableau server with share-point portal and setup auto refresh feature.

Created visualization for logistics calculation and department spend analysis.

Generate KPI for customer satisfaction survey results and disease management.

Maintained Test log and Wrote test Evaluation, Summary Reports.

Provided reporting, analysis and insights about sales drivers and key revenue performance metrics to support corporate analytics.

Developed and enhanced reports connecting to single or multiple data sources to improve performance.

Managed multiple projects with high degree of accuracy and attention to detail.

Monitored and troubleshot data source systems for data flaws and errors and upstream data issues.

Attended management meetings with other tableau developers to identify risks and maintain project targets.

Analyzed business requirements and created functional requirements specifications to build and deploy solutions.

Collaborated with management to determine and detail overall goals and requirements.

Conducted business stakeholder interviews to ascertain problems and document and create business requirements.

Collaborated with cross-functional development team members to analyze potential system solutions based on evolving client requirements.

Worked closely with other business analysts, development teams and infrastructure specialists to deliver high availability solutions for mission-critical applications.

Environments: Tableau desktop, Tableau public, Tableau Read, MYSQL, MS SQL SERVER.

Client: Continental tires June 2013 to May-2014

Role: Sql Developer

Responsibilities:

Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User Defined Functions and Stored Procedures

Experience in complex T-SQL and PL/SQL Views, Functions, Packages, Cursors, Indexes, User Defined Data Types, Constraints to facilitate efficient data manipulations as per the business rule.

Involved in performing database Backup and Recovery

Involved in performance tuning of T-SQL queries and Stored Procedures

Contact this candidate