SUMMARY

• Over 9 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 10.5,10.4,10.3,10.2,10.0,9.1,8.2,8.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 10.5,10.4,10.3,10.2,10.0,9.1,8.2,8.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 200+ 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, Cloud Computing/ Amazon Web Services - AWS, Amazon Red Shift, Netezza

BI Tools: Tableau Suite of Tools 10.5, 10.4, 10.3, 10.2, 10.1, 9.3, 8.2, 8.1, 8.0, 7, 6, 5.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, QlikView, SAP, Qlik sense, 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, Solaris

PROFESSIONAL EXPERIENCE

Confidential, Oroville, CA

Sr Tableau Developer

Responsibilities:

• Created Tableau Bread Crumbs, using Tableau filter actions for Tax reporting system Dashboard.
• Developed POCs by building reports and dashboards using Tableau 10.4 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 10.4 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 for end users. Worked on creating Pivots, sets, groups, and parameters.
• Worked on Creating various plots and drill down analysis using Tableau desktop 10.4. 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 AWS Redshift and Hive
• 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.3.
• Cleaning and blending multiple data sources 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, work flows, screen shots and Power Point presentations for the Web Applications.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using Data blending.
• Worked in Tableau 10.3 environment to create dashboards like weekly, monthly, daily reports using Tableau desktop 10.3 & 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.3.
• 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.3.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Confidential, Philadelphia, PA

Sr Tableau Consultant

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
• Expertise in installing, configuring, Clustering, Load balancing and Multi-node installation of Qlik view and Qlik Sense Environment
• 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.
• Having good experience on Portal Administration in Congos Connection.
• Connected to Amazon Redshift through Tableau to extract live data for real time analysis.

Confidential, Oakland, CA

Sr Tableau Developer

Responsibilities:

• Analyzed the business requirements, identifying the requirements, reviewing and communicating with business and getting sign offs from business.
• Developed reports, dashboards, and SQL queries using Tableau. Worked on gathering data requirements from different sources and data cleansing.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Log Axes, Groups, hierarchies, sets to create summary level and detailed Reports.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Tableau.
• Implemented AWS security features in Tableau Server to enable a single report or dashboard to securely serve the needs of a broad and diverse user base, including both internal and external users
• Upgraded Tableau server from 8.0 to 9.0 in DEV and QA along with Migration of reports.
• Prepared Tableau reports in various subject areas like Materials Procurement Savings, Bill of Materials, Customer Service Index, Employee Productivity and Employee Safety.
• Played critical role in establishing Best practices for Tableau reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI's and developing POC Dashboards.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel.
• Connected Tableau server with SharePoint portal and setup auto refresh. Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Worked on understanding of relational database structures, theories, principles and practices.
• Wrote Custom SQL scripts for creating aggregate tables and generating views.
• Effectively used data blending feature in Tableau to integrate different database tables. Designed and developed various analytic reports /dashboards using Tableau.
• Developed Complex dashboards and used advance chart visualizations in Tableau like Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.
• Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau.
• Built Excel, Qlik View and Domo reports in Tableau.
• Migrating all the reports from Tableau 9.3 to tableau 10.3 and publishing them on the server.
• Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.
• Resolved various performance issues and analyzed the best process distribution for different projects. Assisted power users in Tableau dashboard development.

Confidential, New York, NY

Tableau Developer/Admin

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Expertise in deploying SSIS Package, SSRS Reports and SSAS Cubes using command line utilities
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Designed and built statistical and machine-learning models and feature extraction systems in Python and R Programming
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Studied various Statistical Data Mining Methods, Random Forests, Neural Nets and applied them on data to get insights using R Programming.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Have clear understanding of Data Warehousing concepts with emphasis on ETL, BI and Life Cycle Development including requirement analysis, design, development, testing and implementation
• Expertise in installing ECC/BW on HANA, Administration of HANA systems, HANA studio, HANA migration, S/4 HANA migration using DMO option, HANA system backup/restore
• Managed selection, architecture and implementation of a SaaS reporting and Data analytics platform for medical data collection using Tableau analytics server technology to provide dashboard reporting and client project health in real-time using the web or mobile devices.
• Power BI developer with skills as well to help deliver a set of dashboards.
• SAP Solution Manager implementation activities like Installation, Post installation activities, Technical Monitoring for different SAP components like ABAP, Java, HANA, MS SQL, R programming, EWA configuration, MOPZ, Maintenance Planner, etc.
• Monitor and plan for Teradata disk space quotas. Promptly respond to warnings that disk space is running low.
• Extracted data from various sources like Oracle, Netezza and flat files and loaded into the target Netezza database
• Involved in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI
• Good Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Created Parameterized reports, Cross-Tab reports, Drill Down reports by using SSRS.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Handling big data loads to Qlik view and Qlik Sense and implemented impactful solutions.
• Creating users, groups, projects, Data connections, settings as a Tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.1.
• Created report schedules on Tableau server.
• Review new API development specification releases and update portal content.
• Created rich dashboards using Power BI to deliver actionable insights for end client.
• Used Python and R Programming to develop analytical and reporting solutions to visualize data and information using Microsoft Power BI
• Designed schema in Amazon Redshift cluster to store EBS operational data optimally.
• Experience in using Multi-Dimensional Expressions (MDX) to query the SSAS Cubes, identifying Key Performance Indicators (KPIs), and in creating Dashboards Score Cards using R Programming.
• Designed Amazon Redshift based Power BI solution platform for optimized performance and usability.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Worked on tab cmd to schedule the report's and setup email reports using command lines.

Confidential, Basking Ridge, NJ

BI Developer/Tableau Report Developer

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Administered user groups and scheduled instances for reports in Tableau.
• Used Parameters, Calculated fields, LOD's, and sets to handle views more efficiently on Tableau Reports.
• Built complex formulas in Tableau for various business calculations.
• Extensively used SQL in command objects of Crystal Reports.
• Enhance/modify existing reports by creating new Parameters, Formulas, Filters
• Created User Groups, Roles to implement the Congos Security.
• Explored on new feature like Teradata Virtual storage
• Successfully integrated backend interface with hosted IVR in WSO2 Gateway that included: Building tokenized APIs with WSO2 API Manager and from Swaggers
• Designed, developed, tested and deployed ECR (Enterprise Custom Reports) on internal and client environments using SQL Server Reporting Services(SSRS)
• Schedule the reports using Info View to run at specific times in a day/week as desired by the Business Users using Business Objects Enterprise, Central Management Console.
• Provided 24/7 production support for Tableau users
• Combined views and reports into interactive dashboards in Tableau Desktop which are presented to End User.
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards.
• Involved in the validation of data in ETL and Power BI layer with the source systems
• Wrote complex SQL queries on Netezza and used them in lookup SQL overrides and Source Qualifier overrides.
• Experiences in migrating client's reports from Micro Strategy, excel (static) based solution to an interactive service.

Confidential, Denver, CO

BI Developer

Responsibilities:

• Partnered with business analysts to understand requirements, source systems, and perform data analysis.
• Transformed OLTP Data to OLAP Data Warehouses based on requirements.
• Developed proof of concepts to showcase BI tool functionality to the end users and management audience including report and dashboards. Built the needed master data objects as "Attribute Views
• Created cube-like view by joining attributes view to fact data. Built a "Data Foundation based on transactional table and join attribute views to data foundation.
• Improved performance by narrowing the data set by creating projection nodes and by applying filters
• Wrote SQL select statements against existing raw tables or Column Stores (preferred)
• Defined output structure and activation creates column store based on Script Output.
• Wrote SQL script required to create Script based Calculation Views
• Built Visualizations and Storyboards. Combined data sets, edit, and cleansed datasets. Enriched data by creating calculated measures and attributes in the data sets. Grouped multiple measures together and used them in visualizations.
• Built necessary Materialized views to support the Data mart and coordinated with ETL for mappings and transformations
• Designed, Developed and Presented Dashboards. Made interactive designs using Multiple Drills Down, Dynamic Visibility, and Alert Features to support various requirement scenarios.
• Available on iPad by changing the theme of applications for mobile and generated QR code for users.
• Designed and presented intuitive Business intelligence presentations by creating slides in power point with SAP Business Objects Analysis in developing interactive analysis views on SAP BEx queries and SAP BW Info providers.
• Dashboards using Advanced Multiple Drills Down, Dynamic Visibility, and Alert Features were designed to support Complex Requirement Scenario.
• Developed and modified applications, authored database procedures and triggers for data processing.Created entry forms/reports for various modules. Created databases, loaded initialization data, generated users, and assigned roles and access.
• Created Tables, Indexes, Table Spaces, Views, Synonyms, and Integrity Constraints.
• Involved in creation of schema objects, roles and privileges.
• Prepared executables for system deployment and led the release of applications following.

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