Soumya Alla

857-***-**** Tableau Developer admiqq@r.postjobfree.com

Professional Summary:

•Business Intelligence Analyst/Tableau Developer with 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 than 15million of records which intern does the incremental loads every day.

•Connected with multiple sources like SP/Hive/excels/Cubes etc with Alteryx/Trifacta input data app.

•Worked on creating workflows using Alteryx for creating data extracts and cleansing the data.

•Strong understanding of data modeling and dimensional 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 that 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, IBM DB2, Teradata, SQL Server Analysis Service (SSAS), TOAD, HANA, Hadoop.

Programming

T-SQL, PL-SQL, MYSQL, Python, R, SAS

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.

Professional Experience:

Truist Bank, Atlanta, GA March’20-Present

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 the requirements for the reporting.

•Interacted with ETL team to get transformed/cleaned datasets based on the 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 the 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.

•Worked with Hadoop Team on building the views for modeling the Tableau extracts.

•Built Tableau dashboards on top of Hadoop database through live connectivity.

•Extracting data tables using custom generated queries from excel files, Access/SQL database and providing extracted data as an input to Tableau.

•Created Multiple macros using Alteryx and used in other workflow LOBS.

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

•Data preparation, data blending, and the creation of data models/sets using Alteryx.

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

Amtrak, Washington, DC Jan’19 – Feb’20

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

•Combined visualizations into Interactive Dashboards and publish them to the web.

•Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.

•Investigate issues in Hadoop Hue editor for complete end to end validation of the reports

•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 that 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 and monitoring, and troubleshooting issues.

•Ensured projects were completed on time and within budget.

•Tableau server maintenance, Tableau server backup activity.

•Consolidate multiple data silos that 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.

•Data preparation, data blending, and the creation of data models/sets using Alteryx.

•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, Alteryx, Windows 7, SAS and Hadoop Horton works.

Veooz Labs Pvt. Ltd, India Apr’15-Mar’17

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

•Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

•Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

•Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.

•Configured the Usage Tracking and built the Reports to analyze the performance of reports and track the 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 the layouts based on sample reports provided by the users.

•Created many Dashboard reports for company's decision-making purpose and made them Key Performance Indicators (KPI).

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

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

Creative Techno Soft Systems, India May’11-Mar’15

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 using Tableau Desktop that were published the business stake holders for analysis and customization using filters and actions.

•Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.

•Configured the BI Publisher and Smart View to do some of the 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 in Tableau environment.

•Created and managed schedules for users.

•Provide regular status of the project to the management.

•Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the 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.

Educational Qualifications:

•Masters in Information Technology, Bentley University- Waltham MA.

•Graduate Certificate in Business Analytics, Bentley University- Waltham MA.

•Bachelor of Technology, JNTU-Kakinada, India.

Contact this candidate