PROFESSIONAL SUMMARY:

• BusinessIntelligence Analyst/Tableau Developerwith 8+ years’ experience in coordinating with Stakeholders, SMEs, Business users, Architects, DBAs and Cross - Functional teams.
• Hands on experience on Tableau 20.3,20.1,19.3,12.1,11.0,11.3,10.1/10.0/9.3/9.0/8.3/8.0/7.0.
• Requirements Gathering, Gap Analysis, Feasibility Analysis, Solution Development, Application Implementation, Data Visualization and Data Analysis.
• Experience in defining Business processes, Business Rules, and Use Case development using UML methodology.
• Good understanding of Software Development Life Cycle (SDLC), including knowledge of RUP, Agile and Waterfall methodology.
• Experience in developing project plans, identifying documents, and validating requirements and reengineering process.
• Conducted JAD Sessions and communicated with Stakeholders, SMEs, Users and Cross-Functional teams.
• Experience in developing Wireframes, Screen mock ups, BRDs, FRDs, Use Cases, Data Flow Diagrams, BAT and UAT.
• Experience in data analysis using Business Intelligence tool Tableau including Tableau Desktop, Tableau Server.
• Expertise in Tableau Desktop. Trouble shooting, Report design, Performance Tuning, and resolving Issues within Tableau Reports.
• Expertise in Designing and developing comprehensive dashboards and publishing in Tableau Server.
• Extracted with custom SQL more TEMPthan 15million of records which intern does teh incremental loads every day.
• Connected with multiple sources like SP/Hive/excels/Cubes etc with Alteryx/Trifacta input data app.
• Strong understanding ofdata modelinganddimensional modeling, and designing Kimball’s Star and Snowflake schemas
• Worked on Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment. Extensive Tableau Experience in Enterprise Environment and Tableau Administrator
• Extensively used Tabadmin and Tabcmd commands in creating backup's and restoring backups of Tableau repository
• Have hands on experience in creating Views and interactive Dashboards using Parameters, Filters, Actions, Bar/Pie/Funnel/Bullet charts, Area/Geo coding/Heat maps, Custom color palettes, scatter plots etc., in Tableau Desktop versions (9.0/9.3/10.1/2018.1/2020.3).
• Experience in creating Users, Groups, Projects, Sites, and Permissions.
• Experience in installing Tableau Server in Clustered environment and administer Tableau Server.
• Excellent Knowledge in Data Warehouse Concepts, Data Modeling, ETL.
• Extensively worked in OLTP & OLAP environments dat include QA, Production and development, implement maintain database schema (in source code control) and Entity relationship diagrams from business requirements.
• Experience in creating SQL queries, and modify/enhance existing SQL queries.
• Excellent verbal/written communication skills and can perform well both independently and as a team player.
• Ability to quickly master new concepts/applications & identify operational deficiencies and system improvements. Strongly self-motivated, willing to assume responsibilities & very detail oriented. Excellent at communication, analysis & presentation.

TECHNICAL SKILLS:

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Informatica 7.1.3/6.2/8/9, Talend, Alteryx

Reporting Tools: Tableau 7.0/8.1/9.0/9.3/10.1/2018.1/2020.3, Power BI, SQL Server Reporting Services (SSRS) (2000/2005/2008 R2/2012), MS Excel.

Database: MS SQL Server, MS Access, Oracle, Teradata, SQL Server Analysis Service (SSAS), TOAD, HANA, Hadoop.

Programming: T-SQL, PL-SQL, C, MYSQL, Python, R

Operating Systems: Windows NT 2000/2003 Server, Windows XP/7, Unix/Linux.

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP& OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Developed multiple reports like daily incident detection, UFO aging, All SAR Aging, workflow history, Enigma hotlist, FCM reports, IFMx reports and other Integrated fraud management under ActOne project using MS-SQL server and Tableau 2018.
• Interacted with business to gather teh requirements for teh reporting.
• Interacted with ETL team to get transformed/cleaned datasets based on teh requirements from business to load into tableau desktop.
• Developed dashboards with quick filters, parameters and sets to handle views more effectively.
• Created and maintained complex views and stored procedures in SQL server to pull daily reports and data analysis used for fraud detection.
• Created reports using Tableau functionality’s like queries, drill down, prompts functions to meet teh requirement using SQL server.
• Worked on motion chart, bubble chart, drill down analysis using tableau desktop.
• Worked extensively with Advanced analysis actions, calculations, parameters, maps, trendlines, statistics and log axis. Group, hierarchies, sets to create detail level summary report and dashboards using KPIs.
• Created tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts and heat maps.
• Extracting data tables using custom generated queries from excel files, Access/SQL database and providing extracted data as an input to Tableau.
• Involved in publishing various kinds of live, interactive data visualizations, dashboards, reports and workbooks from tableau desktop to tableau servers.
• Defined best practices for tableau report development. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled data extracts on a daily basis.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Postproduction support to Tableau users and wrote custom sql to support business requirements.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD analysis
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.

Environment: Tableau Desktop 2018.1/2020.4, Actimize Visual Analytics, Tableau Server, Oracle, SSIS, SSMS 18.2, Excel, Actimize Risk Case Management (RCM).

Confidential, Washington, DC

Business Intelligence Analyst-Tableau Developer

Responsibilities:

• Developed various data connections from data source to Tableau Server for report and dashboard development
• Developed Dashboards using Hadoop as a data source.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate teh data.
• Combined visualizations into Interactive Dashboards and publish them to teh web.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Built Tableau dashboards for showing insights of different portfolios dashboards and customer level detailed reports for relational managers, Directors and VP.Generated various Analytics reports like Formulary Report and Direct Enrollments Report using global and local filters.
• Experienced in Tableau administration Tool for Configuration adding users /groups/Projects/sites/managing licenses and data connections scheduling tasks embedding views by integrating with other platforms like Service Now.
• Extensively used Tabadmin and Tabcmd commands in creating backup's and restoring backups of Tableau repository
• Designed and developed many Smart Works Dashboards/Reports dat are Dynamic & Interactive with intuitive drilldowns, drill-across & drillable charts (bar-charts, pie-charts, radars, and bubble-charts), Capabilities split reports for summary & details information
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging andmonitoring, and troubleshooting issues.
• Ensured projects were completed on time and within budget.
• Tableau server maintenance, Tableau server backup activity.
• Consolidate multiple data silos dat exist on campus to one location.
• Sophisticated stored procedures and triggers to provide complete technical solutions.
• Worked with all levels of development from analysis through implementation and support.
• Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.
• Environment Support to User community, Service Request & Resolution.
• Expertise in failed over activities in production Environments.

Environment: Tableau 9/10.1/2018/2019, Tableau Server, Oracle 11g R12, Windows 7 and Hadoop Horton works.

Confidential

Sr. Tableau Developer

Responsibilities:

• Participated in requirements gathering and translate business requirements into report visualization specifications design documents. Created different views in workbook to visually analyze teh data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Involved in testing teh SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled teh performance issues effectively.
• Created Tableau worksheet which involves Schema Import, Implementing teh business logic by customization.
• Configured teh Usage Tracking and built teh Reports to analyze teh performance of reports and track teh reports being used by different users
• Designed and Developed Object Level and Data Level Security for Business Users to define users, groups, set roles and responsibilities by integrating OBIEE users with Organization’s OID.
• Used Different BI Publisher Templates like RTF, Excel to replicate teh layouts based on sample reports provided by teh users.
• Created many Dashboard reports for company's decision-making purpose and made them Key Performance Indicators (KPI).
• Gatheird user requirements, analyzed and designed software solution based on teh requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Provided 24/7 production support for Tableau users.

Environment: Tableau 8.3, SQL Server 2008/2008 R2, T-SQL, SQL Server Management Studio, Microsoft Excel.

Confidential

Tableau Developer

Responsibilities:

• Understand analytics requirements from users and build design specifications.
• Create worksheets and dashboards.
• Develop rich data visualizations on Tableau using crosstabs, heat maps, pie charts & bar charts etc.
• Used groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations
• Designed multiple dashboards for operational and executive users.
• Created different views usingTableauDesktop dat were published teh business stake holders for analysis and customization using filters and actions.
• Combined visualizations into InteractiveTableauDashboards and published them to teh web portal.
• Configured teh BI Publisher and Smart View to do some of teh Reports which required cell level calculations.
• Refreshing Tableau Extracts.
• Responsible for migrating RPD, WebCatalog across multiple environments.
• Performance tuning of complex SQL queries, Metadata to improve overall BI Performance.
• Created Users, Groups and projects inTableauenvironment.
• Created and managed schedules for users.
• Provide regular status of teh project to teh management.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate teh data.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.Build advanced analytics by building complex reports and dashboards.
• Prepare test scenarios, test cases and execution of test cases.

Environment: Tableau 7/8.1, Windows Server 2008 & Oracle 11g/12c, MS Access database, SQL Server and MS Excel.