SUMMARY:

• 8+ years of IT industry experience in implementing all phases of the Software Development Life Cycle (SDLC), including Business Requirements Gathering, Design, Development, Testing, and Implementation of Data Warehousing/Business Intelligence Applications
• 4+ years of extensive experience as Tableau Developer on Tableau 2019.1/ 2018.3 / 2018.2 / 10.5/ 10.4/ 10.3/ 9. x product suite ( Desktop, Server, Public, Reader, Online, Mobile, Bridge ) .
• Sound knowledge of Health Care, Technology, Retail, Finance and Banking domains.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Strong understanding of Data Warehouse concepts, Star Schema, Snowflake Schema, Business Process Analysis, Physical and Logical data modeling.
• Experience in Operational Data Store (ODS ) , Business Intelligence, Data Modeling, Data Warehousing concepts, OLAP, ETL tools and Analytics .
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM).
• In depth understanding of the Gap Analysis i.e., As - Is and To-Be business processes and experience in converting these requirements into Technical Specifications and preparing Test Plans.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Pareto Charts, Funnel Charts, Bar Graphs, Scatter Plots, Pie-Charts, Donut Charts, Bubble Charts, Funnel Charts, Heap Maps, Tree Maps, Geographic Visualization and other making use of actions, other local and global filters per the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Hands on experience publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau online & Tableau Servers, Web pages.
• Expert in creating Calculations (LODs, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mark Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• 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.
• Generated KPI for organization targets and customer satisfaction Survey results.
• Extensive experience in creating dashboards to showcase the performance of the product in the market based on the Survey data
• Provided tableau training on the Survey dashboards built to the end users.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Produced attractive visuals/dashboards to convey the story inside the data publishing and presenting dashboards on web and desktop platforms
• Extensive experience in creating several reports such as drill down, drill through reports, parameterized reports, linked reports, Heat Maps, Dual Charts, Action Dashboards and cascading reports.
• Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting
• Experience in creating Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and dashboard using KPI’s.
• Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon redshift services.
• Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure the views and dashboards were displaying the changed data accurately
• Extensive experience on building dashboards in Tableau and involved in Performance Tuning of reports and resolving issues within Tableau Server and Reports.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository
• Worked heavily using Tabadmin tools and Tab Cmd for setting up security profiles for various User groups and Users.
• Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
• Experienced in managing schedules and scheduling workbooks and activities on Tableau Server
• Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems
• Proficient in conducting Gap Analysis, Business Process Re-engineering, Designing Workflows and communicating the trade-off decisions on product features based on technology, budget constraints and customer requirements
• Expertise in writing SQL Queries, Dynamic-queries, and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Extensive experience in using Data Blending for merging data from different datasets and creating different visualizations like Geographic Map, Gantt Charts, Bubbles, Histograms, Heat maps, Scatter plots and Density Chart.
• Ability to manage multiple and varied tasks with enthusiasm, deal with tough and demanding work priorities, prioritize workload with attention to details.
• Flexible, enthusiastic and project-oriented team player with excellent communication skills and leadership capabilities to develop creative solutions in challenging environments.

TECHNICAL SKILLS:

Business Intelligence Tools: Tableau Desktop/Online/Bridge/Server/Reader/Public/Mobile, Microstrategy, Business Objects, Crystal Reports XI, OBIEE, SQL Server Reporting Services (SSRS)

Data Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio.

Databases: SQL Server, Oracle, DB2, Teradata, Netezza, SAP HANA, SAP BW

Document Management: Visual Source Safe, share point, Ultra Edit, Documentum

ETL Tools: Informatica, Alteryx, Microsoft SQL Server Integrated Services, Talend, DataStage.

Methodologies: Kimball/Inman Data Modeling, Star/Snow flake Schema, Waterfall, Agile

Scripting Languages: HTML, SQL, PL/SQL, XML, VB, Java API

Applications: Microsoft Office Suite (Word, Excel, Visio, PowerPoint)

Operating Systems: Windows Server 2003/2008, Windows XP/7, MAC, Unix

Database tools: SQL Developer, TOAD, Teradata SQL Assistant.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Sr. Tableau Developer || Data Analyst

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes.
• Designed and constructed real time dashboards for licensing, enforcement and audit teams using Tableau.
• Worked closely with business power users to create reports/dashboards using tableau desktop
• Created Tableau dashboards using bar graphs, Scatter plots, Donut charts, geographical maps.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to online.
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Designed various filters like data source filter, Quick filter, Context filter,
• Worked extensively with Advance analysis Actions, Drill-Down Analysis, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI’s
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Worked on Tableau bridge to schedule the data refresh.
• Created and managed tableau online user groups and permissions.
• Involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Tableau 2018.3/2019.1 (Desktop/Bridge/Online), Oracle, SQL Server, Erwin, SSIS, SQL Developer, Rally, HP Quality Centre, Microsoft Office Word, PowerPoint, Access, Outlook, Toad, JIRA.

Confidential, Bridgewater, NJ

Sr. Tableau Developer || Data Analyst

Responsibilities

• Work with internal management and team members to understand and clarify reporting requirements / needs.
• Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.
• 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
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• 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.
• Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.

Environment: Tableau 10.5 Desktop/Server, Erwin, Oracle, Toad, Java Script API, JIRA, Rally, HP Quality Centre/HP ALM, SQL Server, SSIS, SQL Developer, Microsoft Office Word/PowerPoint/Access/Outlook.

Confidential, Moline, IL

Sr. Tableau Developer || Data Analyst

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, Scorecards and created using Tableau desktop.
• Analyzed the source systems and created technical design documents and data flow diagrams.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Configured different data sources using Tableau Desktop
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Created users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for the data sources.
• Configured AD security using tableau server.
• Responsible for authorizing the users based on their privileges.
• Involved in migration activities related to Tableau across the environments.
• Prepared BI Interactive Dashboards using calculations, parameters in Tableau.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.

Environment: Tableau Desktop/ Sever/ Reader 10.5, SAP BW/HANA, Oracle 11g, Alteryx, Toad, DB2, Composite, MS Project, MS Visio, MS Office Suite, SQL, Erwin, JavaScript API.

Confidential, Manhattan, New York

Tableau Developer || Data Analyst

Responsibilities:

• Creating and modifying Business Intelligence analytical reports using Tableau.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau server, allowing end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, quick filters, data source filters, global filters, context filters, actions, Hierarchies feature in tableau.
• Implemented best practices and standards in developing Tableau reports.
• Integrated Tableau dashboards into internal web portal using Java Script API.
• Worked on the backend database development which was the source data for the tableau.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Executed and tested required queries and reports before publishing.
• Hands-on development assisting users in creating and modifying worksheets.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Environment: Tableau 8.x/7.x, Tableau Server 8.x/7.x, Data Visualization, MS, Visio, Oracle 10g, Oracle SQL Developer, JavaScript, SQL, Agile & Scrum Methodology, Rally, Asp.Net, SharePoint, JavaScript API, Microsoft Office Suite.

Confidential, Baltimore, MD

Business Intelligence Analyst || Tableau Developer

Responsibilities:

• Interacted directly with Business Users and Business Analyst to gather the Business requirements and translating them into Reporting requirements to be used as an input in designing Universes and Reports.
• Built templates and dashboards for customized views of the data specific to each group and line of business
• Used Oracle warehouse builder tool to enact some ETL processes required as per data source requirements for Tableau reporting
• Conduct Design discussions and meetings to come out with the appropriate reporting Data Marts.
• Involved in creating data models and building data marts.
• Requirement gathering for various users, interviewing them, and satisfying their exact needs.
• Analysed business process workflows and assisted in the development of ETL procedures for moving data from EDW base tables to reporting data marts.
• Tested reports for query optimization and performance before posting them to the repository.
• Analysed and improved performance of several ad-hoc reports (bug fixing) using Oracle SQL/PLSQL.
• Provided on-going production support for End Users in the final stages of the project.
• Analysed existing Business Objects Universes and reports to understand business needs and develop prototypes in Tableau.
• Worked with Tableau administrator in creating users, users groups, projects, and the appropriate permission sets for Tableau server logon’s and security checks.
• Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
• Trained the users to use reporting interface and to create ad-hoc reports based on their needs using Tableau.
• Designed and developed Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts
• Used calculated fields, filters, Parameters, Groups, Sets, Bins, and complex financial calculations for various analytical reports.

Environment: Tableau Desktop/ Server/Admin 8.x/7.x, SQL/PLSQL, ETL, Crystal Reports, Business Objects, Power Designer, Oracle 11i, Data Modeling, SQL Developer, Microsoft Office Word/Excel/PowerPoint.

Bank of the West, San Roman, CA

SQL Developer || Data Analyst

Responsibilities:

• Developed SSIS to extract, transform and load data from different data sources, such asdatabases, CSV, Excel files into SQL Server database for reporting purpose
• Maintained dimensions/facts/data extractions jobs using SSIS
• Developed complex stored procedures to process data in SQL Server 2005/2008
• Optimized SQL queries and fine-tuned indexes to improve system performance
• Understanding SQL Server Replications, Snapshot, Transactional and Merge type
• Used SQL Developer to Load / Extract data into and from Excel files.
• Used Hints, Explain Plan, and Indexes for query tuning and optimizations.
• Conducted impact analysis and designed structures to enhance performance.
• Developed processes, automation of maintenance jobs, tuning SQL Server, data validations,locks and indexes configurations.
• Expertise in Extract Transform and Load (ETL) using SSIS and various tools including Bulkinsert, BCP, Import Export data, DTS packages and SQL Server Integration Analyzed, designedand developed for a Data Warehousing and Data Migrations.
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Cleaned the data and created fact and dimension tables, performed calculations required forthe reports using SQL Server environment and accomplished data modeling.

Environment: Microsoft SQL Server 2005/2008, ETL, DWH, Data Modeling, SSRS, SSIS, Visual Studio, MS Excel, Erwin, ER Studio.

Confidential

Systems Analyst

Responsibilities:

• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Modified the existing Universe and created New Universe against Oracle database as per the reporting requirement to add new features to the reports.
• Developed the reports in Reports Designer using Vertical stacked chart, Pie Chart to view the quarterly metrics.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common reports.
• Created parameter driven reports according to user requirements using Web I.
• Developed the Quarterly Quality Metrics report for end users to view Quarter wise using Drill Down feature.
• Documented Design Documents for reports to provide the detail design and explanation of the reports. And also documented Unit Test documents to evaluate and validate reports.
• Created Universe consisting of Derived tables to create the report for different Business Segments.
• Involved in troubleshooting and tuning of the existing reports.

Environment: Business Objects (BO), WebI, T-SQL, Oracle 10g/9i, Reports Designer, PL/SQL, TOAD & Windows NT