SUMMARY

• 7+ years of extensive Experience in the Business Requirements Analysis, Development, Testing, Implementation and maintenance of Business Intelligence, Data warehousing, Client Server applications, Web applications, Tableau Desktop and Tableau Server.
• 6+ years of Experience in Tableau Desktop/Server 2019.2,2018.2,2018.1, 10.5,10.4,10.3,10.2,10.0 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.
• Technically hands - on commercially experience mainly with full range of BI Skills with Tableau 2019.2,2018.2,2018.1,10.5,10.4,10.3,10.2,10.0 Tableau Desktop, Tableau Server and Tableau Public, MS SQL Server, SSIS, SSAS, SSRS, MS Performance Point Server (PPS 2007) and Informatica.
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2016, 2012, 2008, 2005 and 2000.
• Created 1000+ worksheets and 300+ Dashboards in large BI environments using Tableau.
• Extensive usage of Tableau 10.5 features like Viz in Tooltip, Power trendlines, Hyper & Nested Projects.
• Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Utilized all Tableau tools including Tableau Desktop, Tableau Reader and Tableau Public. Strong understanding of project life cycle and Software Development Life Cycle (SDLC) methodologies including RUP, RAD, Waterfall and Agile.
• Used the API for the functionality enhancement on server for site users and sites on Tableau server.
• Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon redshift services
• Proficient in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts (Horizontal, Stacked), Bullet Graphs, Area Charts, Scatter Plots, etc.
• Used Sign in Method using the REST API for successful sign in operations
• Used the REST API with Tableau server to manage and change Tableau server resources programmatically.
• Expertise in Developing User Objects ( filters, prompts, metrics, Sets and Groups, Calculated Fields ) to develop Documents and reports.
• Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
• Experience in Developing, Designing and Support inter active Tableau dashboards. Knowledge 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 SQL SERVER
• 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 .
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.
• Used tools like MS SQL Profiler, Index Tuning Wizard, and Pervasive and Windows performance for monitoring and tuning SQL Server performance .
• Excellent hands on Experience in ETL (Extraction Transformation and Loading) by extracting large volumes of data from various data sources using SSIS.
• Skilled at building and deploying multi-valued parameterized reports using Power BI, Tableau.
• 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.
• Used R Programming and SAS Enterprise data miner for the analysis.
• Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• Good knowledge on QlikView and Qlik Sense .
• Experienced in OLTP, OLAP, GUI, Relational Database Management Systems (RDBMS) and Report Development .
• Highly Proficient in Agile , Test Driven, Iterative, Scrum and Waterfall software development life cycle
• Experienced in Data Analytics and Machine Learning with strong skills in analyzing large datasets using R, Weka and AWS .
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSRS) and ProClarity.
• Proficient with T-SQL, SSIS including developing and maintaining packages, developing connectivity to QlikView, SSRS, using SOAP, XML, etc., as well as having prior experience with DTS/SSIS and other ETL tools.
• Creating and managing Data Warehouses Using SQL Server.
• Excellent troubleshooting techniques and experience with Replication, Migration and DTS
• Strong in PowerShell scripting and 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.

TECHNICAL SKILLS

Databases: SQL Server 2016/2014/2012/2008 R2/2005/2000, MS Access, Oracle 11g/10g, PostgreSQL, MySQL, DB2, Mongo DB, Teradata, Hadoop, Cloud Computing/ Amazon Web Services - AWS, Amazon Red Shift, Netezza

BI Tools: Tableau Suite of Tools 2018.2,2018.1,10.5, 10.4, 10.3, 10.2, 10.1 which includes Desktop, Server, online and Public and Administration of Tableau Server, Business Intelligence Development Studio (SSIS/SSRS), Web intelligence, Xcelsius 2008 and Crystal Reports, Alteryx, 2008 XI, SAP, Power BI, MicroStrategy and Cognos.

Reporting Tools: SQL Server Reporting Services, Power BI, MS Excel, SharePoint, Oracle Report Builder & Tableau

Programming Languages: T-SQL, PL/SQL, C, C++, Java, Unix, Python, XML

Web Scripting Languages: XML, XHTML, JavaScript, Ajax, J Query, ASP 3.0, Visual Studio

Data Modeling Tools: Star Schema Modeling, Snow Flake Modeling

Operating System: Windows XP/7/8/10, Linux/Unix

PROFESSIONAL EXPERIENCE

Confidential, Rochester, MN

Sr Tableau Developer

Responsibilities:

• Developed POCs by building reports and dashboards using Tableau 2019.2 to demonstrate quick wins.
• Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.
• Developed reports, dashboards using Tableau 2018.1 for quick reviews to be presented to Business and IT users.
• Developed Tableau Excel incremental refresh for year 2017 and up to Jan 2018 at vanguard for various financial dashboards.
• Involved in analysis of Key Performance Indicators (KPI's)
• Involved in the design and conversion of KPI's into Tableau Dashboard reports, using chart such as pie, bar, line, maps, stack bars, dual axis graphs, etc.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data. Provided Tableau desktop training for end users. Worked on creating Pivots, sets, groups, and parameters.
• Worked on Creating various plots and drill down analysis using Tableau desktop 10.5. Worked on scheduling reports, managing data sources and refresh extracts. Developed SQL scripts to create database objects like Tables, Views and Sequences.
• Worked on creating schemas and connecting tableau to Hadoop and SharePoint.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization and Financial dashboard
• Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau 10.2.
• Cleaning and blending multiple data sources ( Hadoop, SQL Server, SharePoint and Oracle ) to allow for different views on application data in a single dashboard.
• Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Worked with client and team members to understand and clarify visualization requirements and check performance tuning of dashboards.
• Conducted Gap Analysis, created Use Cases, workflows, screen shots and Power Point presentations for the Web Applications.
• Created Complex workbooks and Dashboards by connecting to multiple data sources (Teradata, Hadoop, SQL Server) using Data blending.
• Worked in Tableau 10.2 environment to create dashboards like weekly, monthly, daily reports using Tableau desktop 10.2 & publish them to server.
• Tested reports and uploaded Tableau dashboards onto server and provided production support for Tableau users
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop 10.2.
• Published the dynamic dashboard reports to Tableau server for navigating the developed dashboards in web.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access. Successfully administered users, user groups, and scheduled instances for reports in Tableau 10.2.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Confidential, St. Louis, MO.

Sr Tableau Developer

Responsibilities:

• Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the reports specifications document and report inventory.
• Worked on gathering and converting data over to Tableau using SQL/SAS/Excel data over to Tableau reports and Dashboards.
• Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data Creating New Schedule's and checking the task's daily on the server.
• Involved in creating ad-hoc analysis and reporting requests in a timely manner for Business Risk related to fraud, Approval's, Declines daily, monthly and yearly.
• Installed and Monitored of Tableau Server 9.1.4 (Dev and Prod) on AWS Environment.
• Created Complicated Calculation Based LOD (Level of detail) feature.
• Expert in SAP Service Connections , Applying support packages, Add-on components, Kernel Upgrades and SPAM updates
• Designing and developing data warehouse and Amazon Redshift BI based solutions.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Automated the incoming data intake using R Programming.
• Involved in managing the application's users, groups, and integration with Active Directory
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics .
• Evaluated database performance issues and executed database optimization.
• Prepared backups using Tab admin and Tab cmd commands.
• Promoted and supported the infrastructure of reporting and Power BI strategy , including standards and best practices.
• Use various data source like SQL server, SQL Analysis server (cube), Amazon Redshift, Hadoop and Hive
• Act as a Tableau Administrator , used Tableau Server 9.1.4 for publishing the developed dashboards to server, authentication, authorization, security , Tableau Extracts scheduling and refreshments, User Management Adding users and Groups, Content Restriction to users, to content based on access level as a Tableau Content Administrator
• Effectively communicated with team members and Business teams to Tableau the requirements to ensure the correct functionality is achieved.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS
• Created SQL Server Reports and developed query for generating drill down and drill through reports using Power BI
• Formulated learning strategies for students on dummy datasets SAS UE, SAS 9.4, SAS Studio and R Programming Studio.
• Acted as Tableau Developer (for designing and developing, proto typing the various dashboards using tableau desktop . Also involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering (Quick Filters, Cascading filters, context Filters), ranking, Top-N Analysis, hierarchies)
• Involved in scheduling data refresh on Tableau Server for weekly and monthly basis on business change to ensure that the views and dashboards were displaying the updated data correctly.
• Created different hierarchical, interactive storage reports using C# .
• Collaborated with a team of .NET developers in designing and developing enhancements to a large enterprise application developed in C#.
• 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
• Implementation of Physical modeling on Teradata such as creation of tables, indexes, views, normalization.
• Strong experience in creating the extensions using Java script both in Qlik view and Qlik Sense.
• Involved in designing Amazon Redshift DB Clusters, Schema, and tables .
• Security implementation among Congo's applications using Access Manager Documenting API guides for development web portal.
• Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Worked with clients to better understand their reporting and dash boarding needs and present solutions using structured Waterfall and Agile project methodology approach.
• Interacted with user groups for delivering 100+ enterprise Reports using SSRS/Crystal reports for various reporting needs.
• Connected to Amazon Redshift through Tableau to extract live data for real time analysis.

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 thru 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.