SUMMARY

• Over 7.9 years of IT experience in SQL, SQL Server, Tableau Desktop, Tableau Server and Tableau Online.
• Experience in implementing Tableau Online, a SaaS application with teh same architecture as Tableau Server that enables cloud implementation of analytics.
• Expertise in Tableau BI reporting tools &Tableau Dashboards Developments & Server Administration.
• Created dashboards and Scorecards like analytical and operational reports.
• Very good experience in designing, building, publishing data analysis reports/dashboards for large Volumes of data.
• Good knowledge on Qlikview.
• Creating dashboards in line with teh analytical uniformity using teh Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects.
• Provide database coding to support business applications using T - SQL.
• Perform quality assurance and testing of SQL server environment.
• Worked on building queries to retrieve data into Tableau from SQL
• Server 2008 and Oracle SQL Developer, and developed T-SQL statements for loading data into target database.
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Developed best practices guide for Tableau implementation using Tableau and Tableau server online.
• Involved in creating Dashboards using Tableau Desktop, Tableau Server, QlikView and Hyperion IR.
• Created incremental refreshes for data sources on Tableau server.
• Having strong analytical, logical, Communication and problem solving skills. Ability to adapt to new technologies by self-learning.
• Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.

TECHNICAL SKILLS

Business Intelligence: Tableau Desktop, Tableau Server, Tableau Online and Qlikview.

Databases: SQL Server 2012, Oracle 11g/12c, MySQL.

Operating System: Windows, Unix, Macintosh.

Languages: C, Java, PHP, PL/SQL Java Script, XML.

Testing Tools: Quality Center, QTP, Test Tracker, Selenium.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Tableau Developer / SQL Developer

Responsibilities:

• Involved in Exploring, Designing, Building, Testing and Deployment of teh high level Dashboards for Board of Directors, Marketing Decision makers, Finance for critical metrics.
• Involved in understanding teh reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau.
• Desktop and publish it to Tableau Server to meet business specific challenges.
• Developed new reports and enhancing existing reports in Business Objects Web Intelligence environment.
• Presented to higher management teh discovered trends and analysis, forecast data, recommendations and risks identified.
• Coordinated and conducted business, system requirements analysis meetings with business and technology partners, business analysts and DBA’s.
• Analyzed teh Business requirements and translated them into Application and operational requirements.
• Performed PL/SQL validation queries by cross testing teh resulting data from teh reports.
• Implemented Security Features of Business Objects like row level, object level and report level to make teh data secure.
• Recommended and took lead on new ideas of implementation/developing of WebI reports involving responsibilities towards getting dashboard requirements, design, document, develop and test front end dashboards and reports.
• Created Classes and Objects for management system based on teh warehouse schema in Universe.
• Created Reports using all teh BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in teh universe.
• Created Star Flake Schema and created new universe by using techniques like indexing, derived tables, setting up contexts and creating Loves.
• Revised teh Group Structure in both Development and Production Environments.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Developed Webi, Webi Rich Client and Xcelsius Dashboards.
• Design processes to minimize data quality risks and proactively identify potential data issues.
• Involved in Tableau Licensing and Installation.
• Worked on Tableau Metadata tables and Postgre SQL.
• Provided support to different levels of Tableau developers.
• Involved in Creating and Managing security rules for dashboards and views.

Environment: Windows XP, Linux, Windows 7, Tableau, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL, Java, JavaScript, SQL, VB.

Confidential, New York, NY

Tableau Developer/Tableau Admin

Responsibilities:

• Creation of metrics, attributes, filters, reports and dashboards created advanced chart types, visualizations and complex calculations to manipulate teh data.
• Transformed TABLEAU into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geocoding to build spatial visualizations of non-geographic data.
• Work directly with management to ensure that Web-site's financial transactions and database management applications operate Confidential peak efficiency.
• Ensured projects were completed on time.
• Played key role in enhancing client's Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Purchasing, Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Scheduled data extracts on a daily basis.
• Sophisticated stored procedures and triggers to provide complete technical solutions.
• Worked with all levels of development from analysis through implementation and support.
• Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT.

Environment: Tableau Desktop, Tableau Server, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL, MS Access, Windows 2007 server, MS Office 2010.

Confidential

Responsibilities:

• Installation and administration of MS SQL Server 2000 and Windows 2000.
• Coding complex SQL Stored procedures according to teh specs joining teh different tables and conditions.
• Created Temp tables in teh stored procedure for different application.
• Wrote stored procedures and T-SQL code to accomplish various tasks.
• Created SQL functions.
• Created index to increase performance of stored procedures.
• Created database tables, constraints and indexes.
• Involved in performing a data mapping, quality assessment converting multiple databases for all product types.
• Partitioned tables, which had frequent inserts, deletes and updates to improve teh overall performance.

Environment: SQL Server 2000, T-SQL, VB 6.0, MS Office, and Windows 2000.

Confidential 

SQL Developer

Responsibilities:

• Programmed clients website and applications - worked collaboratively with clients.
• Provided insightful ideas for developing effective and accurate codes - Evaluated latest technology on teh market and made recommendations to clients to integrate new designs as available by new technology.
• Collaborated with end users and other related departments to ensure that teh website is meeting teh client's expectations and business requirements.
• Collaborated with technical team members to integrate back-end and front-end elements.

Environment: Windows XP, SQL Developer, MS-SQL 2008 R2, MS Access, MS Excel, SQL-PLU and ava.