PROFESSIONAL SUMMARY:

• Over 6+ years of experience in Analysis, Design, Development, Implementation and Maintenance of Business Intelligence, Client Server Applications, Web Applications, Data Warehousing, Tableau Desktop and Tableau Server.
• 5 years of Experience in Tableau Desktop (V - 2019.1,2018.3/2/1,10.5,10.4,10.3,10.2,9.2,9.1,8.2,8.0), Tableau Server, creating highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures, etc.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization utilizing action filters, quick filters and normal filters according to the business/client requirement.
• Worked on Tableau Administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling, SSL, SMTP, batch jobs, configuring IIS, data uploading, backup & recovery.
• Expertise in managing application users, groups, workbooks, projects, Database Views, Data Sources, Data Connections and integration with Active Directory and Local Authentication.
• Followed SOPs and administration guidelines for server upgrades, backups, patching, performance tuning, security and administration of the applications.
• Provided Tableau Support to users by Analyzing documentation for policies, procedures and best practices.
• Strong understanding of project life cycle and Software Development Life Cycle(SDLC) methodologies including Waterfall and Agile.
• Extensive experience developing complex Dashboards, Charts/Graphs and Visualizations.
• Used the REST API with Tableau server to manage and change Tableau server resources programmatically.
• Expertise in utilizing features like Hyper, Box Connecter, Power Trendlines and Web authoring improvements in Tableau 10.5 for faster data ingest and Analytical query processing on large and complex data sets.
• Built interactive dashboards using techniques like guided analytics and visual best practices provided by Tableau.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and authored Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Extensive experience in designing and developing data warehouse and its component tools for data storage.
• Experienced in OLTP, OLAP, GUI, Relational Database Management Systems (RDBMS) and Report Development.
• Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
• Expertise in performing development activities from gathering requirements and designing solutions, through developing code/ reports to testing, release/deployment.
• In depth knowledge in Tableau advance analysis features like Actions, Calculations, forecasting, Parameters and Trend lines.
• Extensive usage of data sources like Amazon Redshift (AWS), SAS, Teradata, Oracle, Microsoft Access and experience in establishing respective driver connections.
• Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
• Extensive experience in tuning SQL statements, Stored procedures and their respective applications to enhance the data load as well as to improve the application response time.
• Extensively built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data using Tableau.
• Experience in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER
• Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Joins, Keys and Data Import/Export.
• Experience in developing and debugging Stored Procedures and Triggers.
• Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, Transformations, filters, Sets, Groups, prompts, Parameters etc. in Tableau.
• Used AWS’s Virtual Private Cloud (VPC) feature to set up a separate logically isolated network for to launch and run server.
• Performance tuning for the Tableau Visualizations and Tableau server for more than 2500 concurrent users.
• Worked on JavaScript API to interact with visualizations embedded in HTML. Used tableau API tools to communicate tableau with HTML & CSS.
• Excellent hands on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.
• Creating and managing Data Warehouses Using SQL Server and good knowledge on QlikView and Qlik Sense.
• Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Extensive experience working in Windows, LINUX and UNIX environments.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS:

Databases: SQL Server/2008R 2/2012/2014/2016/2017 , MS Access 2003, DB2, Oracle Database 10g/11g, Teradata, Cloud Computing, Amazon Web Services(AWS), Amazon Red Shift, PostgreSQL.

Languages: C, C++, T-SQL, HTML, XML, SQL, PL/SQL, R

Tableau Tools V: 2019.1,2018.3/2/1,10.5,10.4,10.3,10.2,9.2,9.1,8.2,8.0 which includes Desktop, Server, Online, Public and Administration of Tableau Server, Business Intelligence Development Studio (SSIS/SSRS), Web intelligence, Crystal Reports, QlikView, SAP, Qlik sense, Power BI, Micro Strategy (Desktop/WEB), SQL Server Analysis Services 2012, 2014, 2016.

Software Packages: MS Office 14.0,15.0,16.0, MS Outlook 2010,2013,2015.

Operating Systems: Windows 10/8/7/Professional/XP, Unix, Linux.

Data Modelling Tools: ER Studio, VISIO, Dimensional Data Modeling (Star Schema, Snow-Flake, FACT Dimensions)

ETL: Talend, Data Migrator, SAS Data Management, Oracle Warehouse Builder and SSIS

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created action filters, parameters and calculated fields for preparing dashboards and worksheets in Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Bubble Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Created custom reports showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• As a site Administrator involved in tasks such as back up recovery techniques, High availability, Security, Installation, Trouble shooting and Performance Tuning in Tableau Server.
• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Worked closely with Business users, Interacted with ETL developers, Project Managers, and members of the QA teams.
• Performed advanced Tableau server management tasks like clustering, load balancing.
• Involved in administrator duties including publishing reports, creating, modifying, or managing server task schedules, monitoring server activity and usage statistics to identify possible performance issues and enhancements.
• Expertise in managing application users, groups, workbooks and Projects, Database Views, Data Sources, Data Connections and integration with Active Directory.
• Setup trusted authentication in Tableau server and pass requests from Web server.
• Created detailed documentation of the implemented security controls needed.
• 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.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them.
• Created lot of cus tom reports using complex stored procedures and Crystal reports.
• Worked on creating schemas and connecting tableau to AWS Redshift and Hive.
• Created report schedules on Tableau server.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Performed Data Blending from multiple databases into one report by selecting primary keys 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.
• 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 to identify opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion.

Confidential, Tulsa, OK

Tableau Developer/Admin

Responsibilities:

• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server , which allowed story telling behind the growth in Loan approval with Quick Filters for on demand needed information with just a click of a button.
• Involved in data prep like Joining and Blending the tables from different data sources, writing Custom SQL queries and setting up data source filters before developing the sheets and dashboards.
• Created connections and Relationships between data using actions, filters, parameters, hierarchies, calculated fields, sets, groups in Tableau desktop.
• Created Financial reports using horizontal and vertical layouts in dashboards to compare and analyze the data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Used Data Blending, groups, calculated fields, aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created real time updated financial reports using live connection to data source in Tableau Desktop.
• Worked on groups, sets, different calculation functions including Table calculations.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created dashboards with the security using filters for the clients to measure cost saving.
• Developed Tableau workbooks to perform YTD, QTD and MTD type of analysis.
• Involved in creating ad-hoc analysis and reporting requests in a timely manner for Business Risk related to Fraud, Approvals, Declines daily, monthly and yearly.
• Experience with load scripting, front-end work, or QlikView set expression
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the dashboards.
• Published the developed dashboards and reports to Tableau server.
• Set up authentication, authorization, security, Tableau Extracts scheduling and refreshments.
• Involved in User Management like adding users and Groups, Content Restriction to users, to content based on access level.
• Performed end-to-end Data Analysis and ensured the data quality gaps are identified.
• Collaborated with a team of .NET developers in designing and developing enhancements to a large enterprise application developed in C#.
• Designed and developed Business Intelligence end to end solutions using Tableau.
• Published Workbooks by creating user filters and security, so intended teams can view it.
• Created Actions in Worksheets and Dashboards to interact and to compare data against different views.
• Performance Tuning of Dashboards and working with users and Database teams for design review and modeling.
• Scheduled Tableau Data Extracts using Tableau Server and the Tableau Command Utility.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Wrote heavy Netezza SQL scripts to load the data between Netezza tables and implemented ELT process for SCD type 1 and SCD type 2 dimensions.
• Used commands in Tabcmd and Tab admin utility tool.
• Involved working in POC to various team for their Adhoc analysis of data with Tableau.

Confidential, Chicago, IL

Tableau Developer

Responsibilities:

• Performed development activities like gathering requirements, designing solutions, developing reports, testing, release deployment.
• Building, publishing customized interactive reports and dashboards , report scheduling using Tableau server .
• Generated Context filters and Data source filters while handling huge volume of data.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators ( KPI ) and Measure.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts, etc.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Responsible for various Administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using Data blending.
• Created action filters , parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Extensively worked on micro strategy administration that includes intelligence server administration, configuration of memory settings and performance monitoring.
• Worked heavily using Tab admin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• Implementation of Physical modeling on Teradata such as creation of tables, indexes, views, normalization.
• Created URL Actions to navigate from one Dashboard visual to another visual opened in a new browser window using separate. tde to improve Report performance .
• Setup trusted authentication in Tableau server and pass requests from Web server.
• Involved in creating database objects like tables, views, procedures, triggers , functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Involved in Agile Methodology (Scrum) from requirements gathering to maintenance and monitoring the progress.
• Developed a 360-business dashboard with multiple panels and parameters that became a favorite sales tool for most of the sales force at CE.
• Restricted data for users using Row level security and User filters.
• Handled Tableau admin activities like granting access to users, managing extracts and installations.
• Used the REST API for the functionality enhancement on server for site users and sites on Tableau server.
• Involved in functional skills in analyzing the client requirements , translating new ideas into client-specific solutions using opportunity identification, requirements development, delivery, support , analysis.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development.
• Wrote and integrated stored procedures to generate the special reports according to client's need.
• Worked on Bar charts, line Charts, combo charts, heat maps and incorporated them into dashboards.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience with Sorting, Building Groups and using in visualizations . Worked on Global, local and Context filters.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Automating day to day maintenance tasks using PowerShell scripts, converting existing T-SQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.
• Experience with Tableau for Data Acquisition and data visualizations .
• Developed SSIS packages using various transformations such as Conditional Split, Fuzzy Look Ups, Aggregations, and Multicasting.
• Developed complex SSAS cubes with multiple fact measures and multiple dimensions.
• Daily migration and deployment of Cognos content to different servers.
• Worked extensively with Date, String and Logical Functions.
• Worked with ETL team for performance improvement using custom SQLs.

Confidential

Tableau Developer

Responsibilities:

• Created Reports and Dashboards with Quick filters, Parameters, Sets and Groups to handle views more efficiently.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and optimized the procedures and triggers.
• Developed Public Objects like filters, prompts, metrics, templates, consolidations , etc.
• Experienced in using Schema Objects to create reports.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Worked on Data Warehousing and RDBMS concepts.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze patient data in different perspectives.
• Created view and tables to generate clean SQL for reports.
• Deployed reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Tested reports and Dashboards in different environments to ensure the functionality and results.
• Worked with databases like Teradata for testing and validation of data and to create reports.
• Created different Fact and Dimension tables to increase the performance of complex SQL queries that are used in Tableau reporting.
• Explored on new feature like Teradata Virtual storage.
• Having constant involvement in tasks such as back up recovery techniques, High availability, Security, Installation, Trouble shooting and Performance Tuning.
• Monitor and plan for Teradata disk space quotas. Promptly respond to warnings that disk space is running low.
• Experienced in promotion of Objects to different environments.
• Used ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Developed Tableau visuals for Controls and Compliance team mapping banking regulations to internal policies, standards, and processes to be used in presentations.
• Developed SQL queries as needed against development and production databases for quick-action ad hoc reporting and data quality analysis.
• Developed modules to extract, process & transfer the customer data using Teradata utilities.
• Greatly involved in Performance tuning to optimize SQL queries using query analyzer.
• Performed testing of all reports for the final deployment.
• Responsible for various Administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Knowledge in creating Crystal Reports using crystal reports formulas, Grouping, Parameters, selection criteria to handle the customer’s requests from Tables, Views and command objects.
• Changed stored procedures according to the new hierarchy.
• Created template reports using advanced prompts like object prompts, expression prompts, and filters .
• Designed the Tableau Architectural and Developers Documents for the Projects.
• Interacted with the existing database developers and DBA to understand the existing schema.
• Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.

Confidential

SQL BI Developer

Responsibilities:

• Developed dashboards and worksheets by blending multiple data sources such as SQL Server and excel data .
• Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily.
• Built dashboards for measures with forecast, trend line and reference lines.
• Generated reports using SQL queries in Tableau & published them to users in online through Tableau server .
• Involved in most of phases (SDLC) of this project from requirement gathering, develop, unit test and implementation.
• Created automated procedure to upload data in excel format and upload into the database.
• Optimized and performance tuned existing reports to provide smooth user functionality.
• Involved loading data application into the database and automated procedures to load them on weekly basis.
• Generated context filters and data source filters while handling huge volume of data.
• Have used various Tableau features including calculated fields, parameters, table calculations, joins, data blending, and dashboard actions.
• Setup and configure new server and migrate existing data, SSIS packages, store procedures and automated tasks by creating partitions of tables, create views and store procedures for the surveillance systems.
• Performed ETL operations using SQL packages load data from legacy systems and automated the process by scheduling jobs to run periodically.
• Creating and maintaining databases, tables, views, users, logins, Indexes, check constraints, and business rules. Responsible for Performance tuning the queries, stored procedures and tables by creating indexes on the tables.
• Wrote complex SQL Queries involving multiple tables with joins and generated queries to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Developed SQL Joins, SQL queries, tuned SQL, test tables, scripts in development environment
• Writing complex SQL queries using Joins, Sub queries and Functions in PL/SQL to retrieve data from multiple tables and developed stored procedures for both backend and frontend applications.
• Generated reports published them to users in online.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Modified different procedures, functions, views, and tables, related to the development work.