SUMMARY:

• Over 8+ years IT experience in Database Design, Development and Implementation of SQLSERVER 2014/2012/2008 R2/2005, Tableau 7.0, 8.0 and 8.1, 8.2,9.0,9.2 and providing ETL/Business Intelligence applications using Confidential components.
• 4+ yrs Experience in Tableau Dashboards in latest Design and Presentation
• Experience including analysis, modeling, design, and development of Tableau reports and dashboards for analytics.
• Effectively involved in all the phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation and Maintenance of projects.
• Extensive SQL Development experience in a Banking & Healthcare environment with a strong understanding of data & analytics.
• Experience with utilizing scripting languages to leverage Tableau's APIs (JavaScript API, Data Extract API, REST API).
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Experience on calculations using different type of functions like logical, Number, String, Aggregate, date functions.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles,
• Design and develop Teradata presentation layer according to users' requirements
• Used Teradata utilities fastload, multiload, tpump to load data
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Expertise in writing T - SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Expert in using SQL Server Agent to Schedule and monitor Jobs.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Advanced knowledge of business process analysis and function specification
• Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.
• Strong Experience in Unit, Integration and System Testing.

SKILLSET:

Tools/Utility: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor,TS,Analysis Manager,CP,SQL Profiler, Visual Studio 2003/2005/2010 , Visual SourceSafe 8.0

Programming Languages: T-SQL, PL/SQL, HTML, XML, Teradata Macros, BTEQ, MLOAD, FASTLOAD, FAST EXPORT, Shell scripting

Tools: DTS, SSIS, SSRS, SSAS, Erwin,Tableau(Desktop & Server), Teradata SQL Assistant, Teradata Manager,cognos,business objects,Informatica (Power Center 9.x, 8.x)

DATABASE: MS Access, MS SQL Server 2005/2008/2008 R2/2012/2014, Oracle8i/9i/10g, DB2,AzureDatabase,google cloud

Operating Systems: Windows NT/98/2000/XP/2003/2008 server

Software: MS Office Visio, MS-Project 2000

IT Processes: Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE:

Confidential, REDMOND, WA

Sr.Tableau Developer

Responsibilities:

• Created reports using Tableau functionality’s like Queries, Drill Down, Prompts Functions to meet the requirements using SQL Server
• Experience in tableau created Rapid Analytics and Reporting
• Experience with Tableau for Data Acquisition and data visualizations for client and customers.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Working 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 andDashboard using KPI's
• Technically hands-on commercially experience mainly with full range of BI Skills with Tableau 7x, Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server, SSIS, SSAS, SSRS, MS Performance Point Server (PPS 2007) and Informatica
• Created different KPI using calculated key figures and parameters
• 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.
• Worked with backend developers to convert HTML/CSS non-functional pages into dynamic JSP pages.
• Handled all the client side validations, slide show, hide and show controls, dropdown menus and tab navigation using JQUERY.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Created Development and Production support documents

Environment: SQL T-SQL, MS Office 2003/2007, Power pivot, T-SQL, Tableau Desktop

Confidential, Scottadale, Arizona

Tableau Developer

Responsibilities:

• Worked with business stakeholders and participated in requirement gathering sessions to understand the business needs and then translate them to technical specifications
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management
• Working on generating various dashboards in Tableau Server using different data sources such as Sql,Google Cloud
• 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.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security
• Development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• User Java Script API to customize the views, selects, filters, date and time.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Experience in Extraction, Transformation & Loading of data from multiple sources to Data Warehouse using Informatica OTB mappings and DAC.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Developed complex calculated fields for the business logic, field, actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Developed Tableau Workbooks to perform Year over Year,Quarter over Quarter,YTD,QTD and MTD type of analysis
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation
• Created side by side bar chart comparison of ford users who were domestic vs. international along with providing profit revenue generated
• Mastered in extraction, transformation and loading of data directly from different source systems like flat files, Salesforce, Oracle, Teradata and SQL Server.
• Provided 24/7 production support for Tableau users and conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.

Environment: SQL Server 2012 Enterprise Edition, Oracle SQL Server R2,Tableau Desktop9.0/9.2

Confidential, REDMOND, WA

Sr.Tableau Developer

Responsibilities:

• Created reports using Tableau functionality’s like Queries, Drill Down, Prompts Functions to meet the requirements using SQL Server
• Experience in tableau created Rapid Analytics and Reporting
• Experience with Tableau for Data Acquisition and data visualizations for client and customers.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed client side validation code using JavaScript and JQUERY.
• Worked with backend developers to convert HTML/CSS non-functional pages into dynamic JSP pages.
• Handled all the client side validations, slide show, hide and show controls, dropdown menus and tab navigation using JQUERY.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report Analysis skills: ETL tools, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Created complex SSAS cubes with fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created Development and Production support documents

Environment: SQL Server 2014 Enterprise Edition, SSAS, SSIS, T-SQL, MS Office 2003/2007, Power pivot, T-SQL, Tableau Desktop

Confidential, Nashville, TN

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created Sets, Groups and Data Bins as per user requirements.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc...
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Reference Lines and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries for data validation by using join conditions.

Environment: Tableau Desktop, Tableau server, Sql Server, Oracle, Windows 8

Confidential, Dallas, TX

MS SQL Server Developer

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Developed SSIS Templates that can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev., Test and Production Environments.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS.
• Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security and Created reports with Analysis Services Cube as the data source using SSRS 2005/2008.
• Created incremental data load task using SQL Server Integration services
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server.
• Involved in migration from SQL Server 2005 to SQL Server 2008

Environment: MS SQL Server 2008/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle10g, 11g, Enterprise Manager,, Power Pivot,Windows Server 2003/2008, DTSHTML, XML, Visual Studio 2005, MS Access, MS Excel 2007.

Confidential

SQL ETL Developer SSIS/SSRS/SSAS

Responsibilities:

• SQL database design, architecture, data modeling using Erwin; Data Warehousing and
• Analysis skills: ETL tools, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Business Intelligence Development Studio (BIDS) -- Using BIDS to create, edit, and deploy SSRS, SSAS, and
• SSIS projects. Developed deployed and monitored SSIS packages including upgrades DTS to SSIS.
• Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and
• Deploying and Processing SSAS objects.
• Migrated data from Oracle to SQL Server data warehouse and to generate the reports using SSRS for different
• OLAP design (SSAS 2008R2) for different cloud services and service items. Implemented OLAP cube and connecting using Excel PowerPivot.
• Analysis Services (SSAS) -- Creating data sources and data source views (DSVs), named calculations and named queries. Creating cubes, dimensions, measures, measure groups, key performance indicators (KPIs), Perspectives, measure group partitions, partition aggregations, data mining models. Deploying and processing

Environment: SQL Server 2008/2005, Enterprise Edition, SSAS, SSIS, SSRS, T-SQL, MS Office 2003/2007, Share point Server 2007 (MOSS),Power pivot, T-SQL

Confidential

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes
• Installed and configure servers and clients using SQL Server 2008,Upgraded SQL databases
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards
• Knowledge of Database Performance monitoring tools
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Implement automated Index Maintenance strategy run as SQL Job on a daily basis
• Resolving any dead locks issues with the Databases/Servers on a real-time basis.

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, Confidential Visio 2003, SFTP