Post Job Free

Resume

Sign in

Sql Server Data

Location:
Ambavaram, AP, 523112, India
Posted:
October 12, 2015

Contact this candidate

Resume:

Venkat Email: acr15s@r.postjobfree.com

Tableau Developer Phone: 703-***-****

Professional Summary

Over 8 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.

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

In-depth knowledge on Tableau Desktop, Tableau Reader, Tableau Public and Tableau Server.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.

End to end experience in designing and deploying data visualizations using Tableau.

Extensive experience working in Windows, UNIX, LINUX environments.

Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.

Worked extensively with the major functionality of ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.

Professional in writing complex Formulas, Sub Reports, Summary Reports.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau.

Installation, configuration and administration of Tableau.

Deployed the reports and Scheduled Reports for the use of end users and customers.

Worked extensively with creating reports as per user requirements using Reporting Services.

Extensive working experience in Packages, Procedures, Cursors and Triggers.

Experienced in tuning Long running SQL queries for better performance.

Expertise in using Version controllers like SVN & Serena Dimensions.

Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

Technical Skills

BI Reporting Tools

Tableau Desktop, Public, Server, Reader/Cognos/Microstrategy

Java & J2EE Technologies

Core Java.

Databases

MySQL, SQL Server

Operating Systems

Windows 95/98/2000/XP/Vista/7, Unix

Verizon, Irving, TX May 2014 to Current

Role: Tableau Developer

Responsibilities:

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

Recommended OS configuration for installing Win Server 2012 R2, Tableau Server, and MS SQL Server 2012 R2.

Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations.

Adjust views/dashboards after initial POC presentation.

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.

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.

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.

Involved in migration of Cognos reports to Tableau workbooks.

Environment: Tableau V 8 (Desktop, Server, Reader), SQL Server, Cognos.

BRAND.COM, Philadelphia, PA Sep 2011 to Apr 2014

Role: 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-axes bar chart with multiple measures.

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

Extensively used data blending in Tableau.

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.

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.

Involved in creating Stored Procedures, tables, and views for applications.

Environment: Tableau V 7/8 (Desktop, Server, Reader), Teradata, MS Excel.

Loomstate, Newyork, NY Aug 2009 to Aug 2011

Role: Tableau Developer

Responsibilities:

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

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Converted charts into Crosstabs for further underlying data analysis in MS Excel.

Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

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

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

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.

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

Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Reader, SQL Server, MS Excel.

Goldstone Technologies Ltd., INDIA JUNE 2007- MAY 2009

ROLE: SERVER DEVELOPER

RESPONSIBILITIES:

Implemented the life cycle of the project using requirements from the users and documenting specifications

Creation of new users, roles, privileges, shared folders, Access Control lists using security roles in SSRS

Responsible for coming up with the logic for creating the accounts the users needed for the reports

Managing projects through entire systems development life cycle, including creating timely/thorough status reports and leading status meetings

Created Databases, tables and provide constraints and user defined rules and defaults.

Created documents with both Grids and graphs as per user requirements

Extensively used DTS technologies to Export/Import data from other data sources like MS Access and flat files.

Created marketing materials, including print advertising and company website

Development of agent database to monitor business development and growth

Created strategies for real estate lead generation, and coached agents on business development and planning

Assisting Business System Analysts in user training and creation of accurate documentation

ENVIRONMENT: Windows 2000 Server, SQL Server 2000.

Education

Bachelors in Electronics and Communication Engineering, Visvesvaraya Technological University, Belgaum, Karnataka.



Contact this candidate