SUMMARY

• Over 8+ years of Experience in Designing, Administration, Analysis, Development and QA in teh Business Intelligence, Client Server Technologies, Web - based Applications and Databases and Experience in industries such as Pharmaceutical, B2B, Financial, Educational, Inventory, Marketing Services.
• Expertise in Tableau 10.4/10.3.1/10.2/10.1/10.0/9.2/9.1/8. x/7.x, Tableau Desktop, Tableau Server, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader, SQL, PL SQL and Unix Shell Scripting and worked on Tableau 10.5
• Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Online.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Gant Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop
• Created highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets and Aggregate measures.
• Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Connected different data sources to Tableau like Oracle JD Edwards, Salesforce.com, IBM Cognos, SQL Server & Excel for live connection on various Dashboards.
• Extracted reports from various BI tools and connected as data source.
• Analyzed teh database and provide detailed information on their operational and forecast for future years.
• Multiple levels of Hierarchies are implemented such as Sales, Product, Partner, Customers and Service Hierarchy etc.
• Worked on pilot batch team for getting trained, testing and implementing Power BI.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Experience in running, using and troubleshooting teh Cloudera Hadoop ecosystem me.e., Hadoop FS, Hive, Spark.
• Experience in Creating Tables, Views, Complex Stored Procedures, Triggers to facilitate efficient data manipulation, data integrity and otherT-SQL(DDL, DML) statements for various applications.
• DesignedSSIS Packagesto extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Experience in DatabaseNormalization,Designing, Creating Indexes, Developed Queries & T-SQL Scripts in MS SQL.
• Expertise in creating complex SSRS reports againstOLTP, OLAPdatabases.
• Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, and Drill through features in using Business Intelligence Development Studio (BIDS).
• Experience in optimizing teh query by creating various Clustered, Non-clusteredindexes.
• Expertise in Report Caching and Subscriptions including Standard and Data-Driven Subscriptions.
• Good Understanding of Technical trends, architectures and highly motivated to no more about teh latest technology update.
• Team player with good communication and interpersonal skills.
• Worked with various cross functional teams and ability to handle multiple tasks concurrently.

TECHNICAL SKILLS

RDBMS: Oracle 8i/9i/10g/11g, MS SQL Server 7.0/2000/2005 , MS Access 2000

Data Base: Hadoop, Mongo DB, Alteryx, Oracle SQL, IBM DB 2, PostgreSQL, SQL Server, AWS Redshift

Programming Languages: SQL, PL/SQL

Data Warehousing ETL tools: Hadoop(Hortonworks), Cloudera (CDH4), SQL SERVER, Alteryx.

Visualization Tools: Tableau 2020.3, 2018.3, 9.2, 9.1, 9.0, 10.0, 10.1, Power BI

Other Tools: Toad Data Point 4.3, Bart, Putty, Sub Version, GIT and Jenkins

PROFESSIONAL EXPERIENCE:

Confidential, TX

Tableau Developer

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Worked with teh client and team members to understand and clarify visualization requirements.
• Created teh reports using external data files (xlsx, csv) or database queries for Tableau Desktop.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server to snowflake.
• Written complex SQL queries and optimized queries for performance tuning.
• Involved in data migration to snowflake using AWS S3 buckets.
• Recreated existing SQL Server objects in snowflake.
• Built different visualizations and reports in tableau using Snowflake data.
• Wrote different Snow SQL queries to interact with compute layer and retrieve data from storage layer.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Worked extensively with Calculations, Actions, Parameters, Background images and Maps. Created Trend Lines, Groups, hierarchies and sets to create detail level summary reports.
• Created dashboards in Tableau Desktop and published onto Tableau Server.
• Worked on advanced viz charts like Bubble, Donut and Step chart. Created Drill down analysis for dashboards.
• Created conditional filters to filter teh data on dashboard and creating Parameters for desired functionality.
• Created complex reports like Detail Level Transaction report's and MTD/YTD calculations.
• Involved in resolving reporting and design issues throughout teh reporting life cycle.
• Published completed dashboards on to server and scheduled extract refresh.
• Strong ability in developing SQL queries to fulfil data and reporting requirements including identifying teh tables and columns.
• Monitored teh project processes, making periodic changes and guaranteeing on-time delivery.
• Documented a whole process of working with Tableau Desktop and evaluating Business Requirements.

Confidential, Durham, NC

Tableau Developer

Responsibilities:

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Created Actions in Worksheets and Dashboards to interact and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Generated KPI for organization targets and customer satisfaction survey results
• Provided tableau training on teh Survey dashboards built to teh end users.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, Level-of- Detail (LOD), calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Produced attractive visuals/dashboards to convey teh story inside teh data publishing and presenting dashboards on web and desktop platforms
• Created automated scripts for tableau workbook refresh when not using live connections.
• Involved in reviewing business requirements and analyzing data sources form Teradata Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Performed Tableau Admin duties dat comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in teh Tableau Server
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Used Data Blending, groups, calculated fields, and aggregated fields to compare and analyze data in different perspectives.
• Worked on groups, sets, different calculation functions including Table calculations.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Performed end-to-end Data Analysis and ensured teh data quality gaps are identified.
• Published Workbooks by creating user filters and security, so intended teams can view it.
• Successfully integrated teh Cloudera distributed Hadoop (CDH) data source with Tableau and fetched teh analytical data to publish in teh workbooks.
• Used Spark API Cloudera YARN to perform analytics on data in HIVE.
• Published Workbooks and Dashboards to teh Tableau server.
• Performance Tuning of Dashboards and working with users and Database teams for design review and modeling.
• Scheduled Tableau Data Extracts using Tableau Server and teh Tableau Command Utility.
• Combined visualizations into Interactive Dashboards and publish them to teh web.
• Involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to teh users and adding them to teh specific group and scheduled instances for reports in Tableau Server.
• Used R functions as Table calculations (aggregated) like Sum, MIN, MAX etc. in Tableau.
• Tested dashboards to ensure data was matching as per teh business requirements and if their were any changes in underlying data
• Involved working in POC to various team for their adhoc analysis of data with Tableau.
• Excellent analytical, problem solving debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement.

Environment: Tableau 10.0, Hadoop, Snowflakes, Microsoft SQL SERVER, Toad datapoint 4.3., Oracle SQL, AWS Redshift.

Confidential, Jacksonville, FL

Tableau Developer/ Tableau SME / Tableau Admin

Responsibilities:

• Created dashboards using Tableau Desktop, Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing teh delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• 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.
• Worked with Business Analyst and teh Business users to understand teh user requirements, layout, and look and feel of teh application to be developed.
• Experience in connecting multiple data base like IBMDB2, Hadoop Hive tables, SQL Server, AWS Redshift, Postgres, Mongo DB, Oracle SQL and custom connected ODBC using ODBC drivers.
• Experience in connecting Power BI with DB2, SQL Server database.
• Experience in handling, configuration and administration of databases likeMySQLand NoSQL databases likeMongoDB.
• Worked on setting driver related different database like Hadoop, Postgres SQL, Snowflakes DB, Mongo DB for initial set up.
• Experiencesetting up connections from Tableau to MongoDBusing MongoDBBI Connector and Using ODBC driver from MongoDB Driver.
• Worked and supported business user for developing dashboard on Quciksight.
• Build multiple Views, Dashboards and Stories using data set from Mongo DB which is in JSON format.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked with Meta-Data Driven SSIS Packages to pull teh data from different Sources and load to Data mart.
• Performed research regarding Python Programming and its uses and efficiency.
• Parsers written inPythonfor extracting useful data from teh design data base.
• Development ofdata structures, xml parsingusingPython.
• Experience in running Linux command to set up security for database, file system and directories.
• Worked on ETL process to loading data into JSON format into MONGODBusing Scala/Spark on Hadoop environment.
• Created tables in MongoDBto load data. Schedulethe shell scriptsto run theprocess automatically.
• Data blending implemented on claim, enrollment, finance databases and generated interactive dashboards.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Created complex calculation fields using Table Calculation, Date, Aggregate functions in Tableau.
• Experience in using LOD expression FIXED, INCLUDE & EXCLUDE function in tableau calculations.
• Extensive use of DDL and DML to change data in Access tables such as Insert, Update, Delete records.
• Effective use of SQL Join to fetch teh data for Tableau Dashboard appropriately.
• Extensively involved in doing user acceptance testing (UAT).
• Created Test Scripts, Test hierarchy to represent teh features and functionality dat need to be test in teh application.
• Analyzed user and business requirements attended periodic meetings for changes in teh application requirements and documents.
• Managed a team of 6 to 8 members includes software’s developers, BSA, Testers and PM.
• Experience in Setting up and driving team meeting with Business and Internal team member to walk through, kick start teh project as needed.
• Experience in driving teh project from end to end.
• Performed Parallel Testing or Production Testing, which ensures dat teh new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in teh User Acceptance Warranty Testing. Involved in doing security and negative testing of teh application.
• Experience is creating Scala scripts to Importing and exporting data from multiple to database.
• Used Scala to develop Scala coded spark projects and executed using spark-submit in Hadoop environment to Hive Tables.
• Created multiple Hive Tables and inserted data using Scala, Sqoop process etc.
• Used Control -m scheduler to execute workflows.
• Worked in waterfall, Jira and Agile process.
• Used GIT and Jenkins to migrate code and maintain teh code repository.
• Review QA test cases with teh QA team.

Environment: Tableau 10.1, Hadoop, Alteryx, Microsoft SQL SERVER, Toad datapoint 4.3., Oracle SQL, AWS Redshift.

Confidential

Tableau Developer

Responsibilities:

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Mastered teh ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Used multiple data source like IBM DB2, SQL Server, Mongo DB, Alteryx, Amazon Redshift to build tableau reports.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 9.1/9.2
• Created multiple visualizations like Heat Maps, Bar Graphs, Bullet Graphs.
• Preparing Dashboards using calculations, parameters in Tableau.
• Converted Celsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Created report schedules, data connections, projects, groups in Tableau server.
• Defined best practices for Tableau report development.
• Extensively used data blending, embed functionalities in Tableau.

Environment: Tableau 9.1, OBIEE 10.1.3.4.1 , Oracle10g/9i