SUMMARY:

• Over 4+ years of experience in all the phases of SDLC Design, Development, Integration, Implementation and Maintenance of MS Business Intelligence and Tableau Platforms.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau Administration and Tableau Reader in various versions of Tableau.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in Tableau, MySQL, Teradata, Oracle, QlikView, Informatica, SQL, XML, MS Access, MS SQL server.
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server.
• Solid knowledge of Power BI and Tableau Desktop report performance optimization.
• Used SQL Azure extensively for database needs in various applications.
• Experienced in Tableau Platform Dash Boarding In-Memory OLAP processing.
• Extensive experience in dealing with Relational Database Management Systems (RDBMS), including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Working in both Semantic layers of Business objects like Universes and Business views as Data source for Crystal reports.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Experience in BI Cognos and Data Warehousing, with expertise in providing business solutions in Functional as well as Technical approach and good in Data Warehousing.
• Experienced in BI Dashboard and developing Dashboards Reports in Cognos.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

TECHNICAL SKILLS:

Business Intelligence tools: Tableau, Tableau Server, Business Intelligence Development Studio, SSIS/SSRS, Informatica Power Center, Cognos, Azure

Data Base: MS Access, RDBMS, OLTP, OLAP, Teradata, MS. Access, MS SQL server, Oracle, Microsoft office Suite

Reporting: SSRS, Tableau, Access 2007/2010, Power BI, Azure, Crystal Reports

SQL, T: SQL, PL/SQL, Teradata, MySQL, Excel Visual Basic

Data Modelling: Oracle, MS Access, MS SQL Server, TOAD

Operating Systems: XP, Windows NT, Linux, iOS

PROFESSIONAL EXPERIENCE:

Confidential

Tableau/SQL/BI Developer

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Built and enhanced BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data.
• Developed ETL processes extracted data daily from ORACLE Databases, and loaded data into a SAS based Decision Support Warehouse.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Working with the help of Microsoft office for expanding the data from Excel and VLOOKUP Up.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and dashboard using KPI's.
• Installed patches on the server and documented upgrade plan from Tableau 8.0 to 10.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Use TOAD to write SQL queries and review view code delivered by the offshore development team.
• Worked on BI Report Tuning and Report Validation SQL Tuning.

Confidential

Tableau/BI/SQL Developer

• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Data blending implemented on EMPI databases and generated interactive dashboards.
• Created dashboards for analyzing POS data using Tableau.
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Utilized tools like TOAD during development of the application .
• Debug and analyze VBA code/ SQL stored procedures.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Designed, coded and tested several T-SQL Queries to Support the System.
• Developed SSIS packages to extract data from OLTP to OLAP systems and schedule the same as jobs using SQL.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Designed, Coded, Tested, Implemented Stored Procedures to get data for the reports.
• Designed the reports using Crystal Reports and SSRS to create reports for the end users.
• Created ad-hoc reports, drill down, and drill through reports using Crystal Reports and SSRS.
• Scheduled meetings with the end users and business owners and gathered requirements for the system.
• Generated tableau dashboards with combination charts for clear understanding.
• Developed tabular queries for efficient analysis of report using PowerPivot/Unpivot in T-SQL.