Tableau Developer available for c2c roles.... Please REMOTE Only
Name : Srija
Skill : TABLEAU Developer
Current Client and Location : Meridian Integration LLC, Jacksonville, FL
Visa : OPT
Rate: $60/hr on c2c
Professional Summary:
· Around 6 years of IT experience in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools
· 4 years of extensive experience with design and development of Tableau visualization solutions.
· Extensive experience in Tableau Desktop, Tableau Server, Tableau reader in various versions of Tableau (7.x/8.x/9.x/10.x/2019.2) and Vizql, Teradata, SQL, BTEQ scripts and various ETL tools.
· Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.
· Experienced in designing rich interactive reports and dashboards integrating various reporting components from multiple sources.
· Experience in aggregating data and configuring reports from different data sources using data blending.
· Experience in interacting with clients, understanding Business Applications, Business Data Flow and Data Relations.
· Experienced in writing complex SQL Queries involving various tables using SQL joins and writing Sub Queries.
· Have experience on various data analyzation techniques, reports efforts estimation, Reports development planning.
· Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently with Tableau.
· Worked on data blending and increased the dashboard performance by extracting data.
· Expertise in designing and creating various analytical reports and Dashboards with rich interactive visualizations to help users to identify critical KPIs and facilitate strategic planning in the organization.
· Optimized underlying SQL queries to create “high performance” reports.
· Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, maps, funnel charts, pareto charts, donuts, bubbles, etc. and other making use of actions, other local and global filters according to the end user requirement.
· Good at installation, configuration, design and implementation of Tableau
· Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development
· Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling, and planning and tracking of results.
· Developed Gaze pose estimation of a car driver using Python which helps predict the driver behavior.
· Extensive use of Amazon Web Services (AWS) for connecting to the data sources on cloud using Amazon redshift services.
· Implemented ETL process in Alteryx to extract data from multiple sources (SQL Server, XML, Excel, CSV) and schedule workflows.
· Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for developed ETL Mappings.
· Experience in guiding onshore/offshore development teams to build dashboard applications, developing templates and development framework, design standards and implementation plans.
· Excellent analytical, problem solving, communication and time management skills.
Technical Skills:
Analytical Tools
Tableau Desktop/Server (10/9.x/8.x/7.x), Micro Strategy, BO , SSRS, SSAS, Google Analytics, R, Power BI, Python
ETL Tools
Informatica, SSIS, Alteryx
Requirements Management
Microsoft Office (Excel, Word , PowerPoint)
RDBMS and SQL Tools
Teradata, Oracle, SQL Server, AWS RedShift, Toad, SQL Assistant, SQL Plus, PL/ SQL
Code Management Tools
UC4, SVN, SharePoint, Quality Center
Methodologies
Kimball/Inmon, OLAP, Waterfall, Agile
Data Modeling Tools
ERwin, ER Studio, MS Visio
Operating System
Windows, Unix
Professional Experience:
Role: Tableau Developer & Admin
Client: Meridian Integration LLC, Jacksonville, FL March 2020 – Till Date
Responsibilities:
· Coordinated with business user at various levels and call meetings during the different phase of projects to deliver successfully.
· Interacted with multiple team and users within the organization to understand data and business processes.
· Involved in gathering analyzing and documenting business requirements functional requirements and data specifications.
· prepared technical documents like data mapping, data profiling sheet, report mockup and also updated confluence page
· Designed and developed ETL workflows and datasets in Alteryx to be used by the BI reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)
· Wrote complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx.
· Understanding the data warehouse Start Schema Model and wrote SQL queries joining multiple dimension and fact tables.
· Understanding data transformations and converting into SQL/tableau report; helps build star schema data marts.
· Read data from Teradata and CSV file through tableau for creating Dashboards/ Reports.
· Implemented context filters and data source filters for handling large volume of data.
· Worked with different type’s visualizations like Combination charts, Slicers, Map visualizations, Scatter charts Waterfall and funnel charts, Visual hierarchies, drill-down etc.
· Used MS excel to data analyzing and producing ad-hoc reports.
· Worked on adding KPIs to analyze performance.
· Created calculated tables, calculated columns, KPI and measures.
· Wrote SQL queries to understand data for reporting need.
· Developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
· Maintained test log and Wrote test Evaluation, Summary Reports. Extensively involved in doing user acceptance testing.
· Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
· Performed data mining on data using very complex SQL queries and discovered multiple data issue.
· Refreshed/republish reports and datasets manually and also created ad-hoc reports as per need
· Created individual Worksheets and incorporated it into Dashboards with the appropriate filters.
· Troubleshoot any performance issues or bottlenecks.
Environment: Tableau 2018.2, Teradata 16, Teradata SQL assistant, SQL Server 2016, Confluence, Rally, Advance Excel
Role: Data Analyst/ Tableau Developer
Client: Inspire Brands, Sandy springs, GA Jan 2019 – Dec 2019
Responsibilities:
· Created Relationships, actions, data blending, filters, parameters, hierarchies, Level-of-Detail (LOD), calculated fields, sorting, groupings, live connections, and in-memory in both tableau 10.4 and excel.
· Building, publishing customized interactive reports and dashboards, report scheduling using Tableau online.
· Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's
· Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
· Created views using various axes like Individual Axes, Dual Axes.
· Created Data extracts for better performance and accessing data offline.
· Used parameters and input controls to give users control over certain values.
· Implemented Data blending with multiple data sources on a single worksheet for data analysis.
· Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
· Cleared errors according to business requirements excel sheet and helped to create Documentation for the dashboards.
· Created workflows to fetch data from different sources using Alteryx.
· Used R and exported data via a supported data source and then visualized that data in Tableau.
· Used R functions as Table calculations (aggregated) like Sum, MIN, MAX etc. in Tableau.
· Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement.
· Extensive use of Amazon Web Services (AWS) for connecting to the data sources on cloud using Amazon redshift services.
· Connected to AWS Redshift directly from Tableau to access to cloud data warehouse and quickly perform visual analysis.
· Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
· Conducted ETL development in the Netezza environment using standard business design methodologies.
· Developed Informatica Mappings using various transformations like Lookup, Update Strategy, Expression, Filter, Router etc. and also developed workflows for the developed mappings.
· Work with customers in gathering business requirements for data cleansing and performed data cleansing and data scrubbing.
Environment: Tableau Desktop 8.x, Tableau Server, Metadata, SQL 2012, Oracle 10g/11g, Windows XP, Informatica Power Center 9.5, Netezza Database, UNIX, Autosys
Role: Tableau Developer
Client: Decision Minds, Milpitas, CA July 2017– Feb 2018
Responsibilities:
· Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
· Mentored business power users to create reports/dashboards using tableau desktop.
· Created Dashboards with interactive views, trends and drill downs.
· Published Workbooks and Dashboards to the Tableau server.
· Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and SSRS.
· Combined visualizations into Interactive Dashboards and publish them to the web.
· Created groups and users in Tableau server
· Transferred large volumes of data using Teradata Fast Load, MultiLoad and T-Pump. · Developed interactive dashboards for Analysed customer response to new promotions effectiveness, acceptance, discontinuation, trend detections, seasonal forecasting and market intelligence.
· Upgraded Workbooks and Dashboards from Tableau 9 to 10
· Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
· Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
· Utilized advance features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
· Expert in new KPI generation for Scorecards. Data collection and leveraging on data manipulation teams for required data.
· Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
· Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
· Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
· Effectively used data blending, quick filters, actions, hierarchy features in tableau.
· Analysed the data using statistical features in tableau to develop Trend Analysis reports.
· Experienced in assisting users in creating and modifying worksheets and data visualization dashboards.
· Scheduled frequency and time to refresh data for the data sources are publishes or extracted to server.
· Regularly interacting with customer to resolve issues.
· Created dashboards that is fully interactive and enables full filtering, zooming, and drill down capabilities.
· Responsible for Preparing the Report Design specifications based on the User’s requirement.
· Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
· Developing, Designing and supporting interactive Tableau Dashboard reports.
· Experienced with the design and development of Tableau visualization solutions.
· Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.
Environment: Tableau software 10.x, Tableau Desktop, Tableau Server, Teradata, Oracle, SQL, Oracle, Windows NT (Desktop/Agent, Object Manager, WEB, Cognos, Enterprise Manager and Database’s like, Green Plum, AWS, Hive
Role: Tableau Developer
Client: Point soft Private Limited, India May 2016 – June 2017
Responsibilities:
· Worked with internal management and team members to understand and clarify reporting requirements / needs.
· Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.
· Identify key business metrics measurements and develop methods to represent data in support of the measurements.
· Provide guidance and insight on data visualization and dashboard design best practices in Tableau
· Creating customized Tableau Dashboards, integrating Custom SQL from Teradata and SQL Server and performing data blending in reports.
· Performed development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release / deployment.
· Stretched Tableau limits to create unconventional Tableau charts such as Grouped Bar Charts, Donut Charts, and Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Heat maps and logical calculations to create groups.
· Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
· Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.
· Embedded Tableau reports/dashboards on to the external web pages.
· Provide innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.
· Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.
· Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
· Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
Environment: Tableau (Desktop/Server) 10/9.x, Teradata, MS SQL Server, SQL, ServiceNow, Teradata SQL Assistant, R, Java API, Putty, UC4, Hadoop, Microsoft (Word, Access, Excel, Outlook).
Role: Intern Analyst June 2015 – March 2016
Client: Esoteky Solutions Private Limited, India
Responsibilities:
· Created the database objects, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server.
· Managed the user access, logins, audit trials, assigning user rules and permissions.
· Created Table views and functions to restrict the data visibility based on user access and to implement security.
· Administrated the SQL Server with various tools like SQL Server Enterprise Manager and Query Analyzer to monitor the server health.
· Developed MS-SQL queries and procedures, custom reports, and modified the ERP user forms to enhance
· Organizational productivity.
· Retrieved the metadata from the SQL Server System Tables.
· Scripted several stored procedures and triggers required from the program queries as per the client requirements.
· Monitored and fixed the DBCC consistency checks and data corruption issues occurred in the application.
Role: SQL Developer May 2014 – March 2015
Client: ICICI Bank, India
Responsibilities:
· Understand and evaluate UNIX, SQL and or Data Modeling.
· Design and develop T-SQL procedures, query performance tunings and SSIS packages.
· Develop underlying data models and databases.
· Develop, manage and maintain data dictionary and or metadata.
· Ensure compliance of standards and conventions in developing programs.
· Design, develop and implement complete life cycle of data warehouses.
· Translate business requirements into software applications and models.
· Resolve and troubleshoot complex issues.
· Perform and execute data extraction, transformation and loading using ETL tools.
· Maintain and manage all versions of data models for production, testing and developing databases.
Environment: Oracle 9i, SQL SERVER, Flat Files, SQL, PL/SQL, Windows NT.
Education:
Master’s degree Jan 2020 – May 2021
Kennesaw State University
Software Engineering
GPA: 4/4
Bachelor’s degree July 2012 – May 2016
Andhra University
Computer Science
CGPA: 7.59 / 10
Thanks & Regards
Naveen
Team Lead- Sales
TechSmart Global Inc.
666 Plainsboro Rd, Suite 1116, Plainsboro, NJ 08536.
