Data Sql Server

Aneesh

Tableau Developer

Professional Summary:

A Certified Tableau Developer having 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.

Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.

Extensive experience working as a Business Intelligence Consultant with specialization in SSRS.

Extensive experience working in Windows, UNIX, LINUX environments.

Experience in dealing with OLTP/OLAP Systems.

Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.

Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.

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

Worked extensively with the major functionality of SSRSad-hoc reports, Drill down reports, multi-parameterizedreports 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 SSRS.

Installation, configuration and administration of SSRS.

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

In-depth knowledge on Tableau Desktop, Tableau Reader 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

Worked extensively with creating reports as per user requirements using MS Reporting Services 2005/2008R2

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 Clear Quest, Clear Case, SVN and PVCS.

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

Integrating Jasyptwith tableau for hiding of the sensitive data.

TECHNICAL SKILLS:

Languages : HTML, PL/SQL, SQL, XML, Java/J2EE

Applications : Oracle SQL Developer

Reporting tool : SQL server 2005/2008 R2 SSAS/SSRS/SSIS, Tableau Desktop, Tableau Server

Databases : Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2000/2005/2008R2

RDBMS : MS Access, Teradata

Operating Systems : Windows XP/7/8, MS-DOS, Sun Solaris, Linux

Web/App Servers : Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0, JBoss

Packages / Tools : MS Office, Toad, Putty, FrontPage 2000.

PROFESSIONAL EXPERIENCE:

Intel, Hillsboro, OR Jun’15- Present

Tableau Developer

Responsibilities:

Developed Tableau reports using SSAS Cubes

Worked on creating advanced Tableau dashboard, using Intermediate MSBI Tabular models.

Created calculated members for dashboard development.

Written MDX queries to create new measure with rebuilding cubes.

Used MDX queries to create the filters and parameters according to the requirement.

Actively participated in moving tableau dashboard under tabular model in to impala.

Focused on creating dashboards in such away end user can understand by just looking at it in 10 sec.

Closed with Business Analyst for gathering requirements and educating in using tableau.

Closed worked with PM, others developers, architects, QAs for software design, estimation, development and testing.

Actively participated with Architect in decision and moving to Cloudera from Tabular models.

Worked on merging multiple tableau workbooks to create a single workbook.

Trained teammates With Tableau

Environments: Tableau Desktop v8, v9, Tableau Server v9, SQLserver, MDX, Hadoop (Cloudera, Impala).

ZYNX Health, Los Angeles, CA Nov’14- May’15

SQL/Tableau Developer

Responsibilities:

Involved in creating Tableau reports using complex custom SQL queries.

Involved in designing new projects and execute them with minimal human resources.

Created dashboards using multiple data sources.

Administered Tableau server and helped in tuning of server.

Involved in gathering information from clients.

Worked with MySQL and optimization of SQL Queries.

Created semantic/metadata layer in Tableau

Created executive dashboard with KPI visualization (1-2 dashboards, 4-8 KPIs)

Created underlying drill through detailed reports

Created Wide variety of dashboards.

Involved in creation of aggregated tables using OLAP data source (DW)

Worked with customers, internal and external, to define and document the scope and functional requirements for data and reporting needs.

Involved in backup of tableau server and optimization of server performance.

Closely worked with manager for designing the requirements.

Integrated Jasypt encrypted data into tableau and integrated special passwords for viewer to look the sensitive data.

Worked in integrating the tableau into mobile applications.

Environments: Tableau Desktop v8, Tableau Server v8, MySQL, Jasypt, Sql server, Careinsync, Java, Excel, CSV files.

Pfizer, San Diego, CA Sep’14- Nov’14

SQL/Tableau Developer

Responsibilities:

Involved in requirements gathering and technical discussion of the reporting data model.

Worked on different Adhoc scenarios to come up with various functional specs / Demo’s for User acceptance.

Created dashboard using parameters, sets, groups and calculations.

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

Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle and Redshift& Google big query.

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

Involved in importing data from Aster ODBC connections for applications.

Involved in Analyzing Aster SQL MR Functions in Aster data.

Involved in using Amazon Redshift & Google Analytics for creating data extracts for workbooks & Dashboards.

Created custom API’s to interact with java framework in order to display the dashboards.

Created dynamic parameters on the dashboard, which user has an option to display various views and selection of different columns & rows as per the need.

Involved in UAT & Stress test of the workbooks and also data integrity.

Environments: Tableau Desktop v8, Server, Reader, Oracle, Teradata, Redshift, GoogleAnalytics, Excel, JAVA, J2EE.

Bityota, Mountain View, CA July’14- Aug’14

SQL/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.

Extensively used data blending in Tableau.

Performed Tableau type conversion functions when connected to relational data sources.

Created incremental refreshes for data sources on Tableau server.

Ability to authoring on Tableau online 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 online.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Involved in creating reports as per user requirements using MS Reporting Services 2005/2008R2.

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

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

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 online related issues.

Environments: Tableau online, Tableau Desktop v7/v8, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, Linux RHEL 5.4.

Merck, Boston, MA Jun’12- Jun’14

SQL/Tableau Developer

Responsibilities:

Involved in creating dashboards by extracting data from different sources.

Created dashboard using parameters, sets, groups andcalculations.

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.

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

Extensively used data blending in Tableau.

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.

MonitoredVizQL 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 Tabcmdcommands in creating backups and restoring backups of Tableau repository.

Involved in creating reports as per user requirements using MS Reporting Services 2005/2008R2.

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

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

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.

Environments: Tableau Server v7/v8, Tableau Desktop v7/v8, Windows Server Standard R2, Clear quest, Clear case,Excel, JAVA, J2EE, SQL Server management studio,MS SQL Server 2008R2, UNIX, Linux RHEL 5.4.

Cerner, Kansas City, MO Nov 11- Jun’12

SQL/Tableau Developer/ Analyst

Responsibilities:

Involved in creating dashboards and reports in Tableau 6.1.

Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Created dashboard using parameters, sets, groups and calculations.

Created drill down and drill upin worksheets.

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

Created report schedules on Tableau server.

Created incremental refreshes for data sources on Tableau server.

Administered user, user groups, and scheduled instances for reports in Tableau server and documented upgrade plan from Tableau 6.0 to Tableau 6.1

Created and assisted users in Tableau dashboard development.

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

Defined and created procedures to install Tableau desktop in silent mode.

Defined best practices for Tableau report development.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Involved in creating reports as per user requirements using MS Reporting Services 2005/2008R2.

Involved in writing complex SQL queries using table joins (inner and outer).

Environments: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008, Oracle 11i, Netezza, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.4.

AmeriGroup, Virginia Beach, VA July 10 - Oct 11

Oracle Developer

Responsibilities:

Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination

Created process force and deployed into run time depository using ware house builder

Involved in logical modeling and physical modeling of application.

Used multiple operators (union, router) for loading data using owb.

Having strong knowledge in creating and maintaining the owb

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Involved in developing CRONTAB to schedule the information of cronentries.

Involved in creation of Conceptual Modeling covering all the business requirements.

Loaded the data into database tables using SQL*loader from text and excel files.

Developed data model, SQL Queries, SQL Query tuning process and Schemas.

Worked with bulk collect to Implement the performance of multi row queries

Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Developed SQL scripts, packages and procedures for Business rules check to implement business rules.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Data loaded from legacy systems using PL/SQL and SQL*Loader.

Remediate Oracle application Custom object components like Forms, report and Concurrent Program (PLSQL code).

Involved in development of Oracle Forms/Reports, New Screen designs, Modifications.

Upgraded to Forms 10g, Reports 10g maintained and troubleshoot Oracle Forms and Reports.

Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.

Worked on admin and user editions of discoverer 10g and used AIM (application implementation methodology) in documenting the development tasks.

Developed Master Detail, Detail reports using tabular and Group above reports.

Developed Procedures for efficient error handling process by capturing errors into user managed tables.

Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables, which will be sent back to sender notifying the errors.

Generated various analytical reports using Microsoft Access.

Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.

Developed UNIX Shell scripts to automate table creation, execute procedures.

Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Used UTI_FILE PACKAGES for writing DBMS_OUTPUT messages to file.

Environments: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g,Reports10g, UNIX, Windows XP/2000.owb 10g.

GATI Transport - Hyderabad, India Feb 07 - July 10

Oracle Developer

Responsibilities:

Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader – for different cases)

Explain Plan, TKPROF was used for checking the performance of queries

Modified and updated existing custom forms to adapt to new database schema

Created SQL scripts for conversion of legacy data (including validations) and then load it into the tables

Developed SQL*Loader programs &PL/SQL scripts to load legacy data into Oracle Apps.

Developed reports using Reports 6i.

Developed PL/SQL programs for various modules to validate data while importing into oracle system.

Participated in database development like creating PL/SQL triggers, packages, procedures function.

Performed exception handling for data that did not conform to the required format.

Responsible for making the merged data in turn available to other clients.

Wrote UNIX scripts to automate loading files into database using error handling and notification.

Involved in implementing the data integrity validation checks through constraints and triggers.

Involved in developing packages for implementing business logic through procedures and functions.

Environment: ORACLE 7.x, Reports 6i, PL/SQL, SQL Loader, SQL.

Contact this candidate