SUMMARY:

• Over 8 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms.
• 4+ years of extensive Tableau Experience in Tableau 6.x/7.x/8.x /9.x/ 10.0/10.5/2018.02 (Desktop, Server, Reader, Mobile) as a Developer and Analyst
• Competent in Software Development Life Cycle methodology (SDLC) and Software Testing Life Cycle (STLC) which includes RUP, Agile and Waterfall Methodology.
• Strong knowledge of Business/Process Data flow in organizations and experienced in data modelling concepts.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Prepared Dashboards using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
• End to end experience in designing and deploying data visualizations using Tableau.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), SQL Server MS Access and client/server applications.
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.
• Expertise in analysis, design and implementation of data warehousing/ BI solutions using Tableau, MicroStrategy, SSRS, Informatica and Alteryx.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Expertise in generating reports using global variables, expressions and functions for the reports.
• Experience in using SQL Server 2008 Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like MS Access, Flat File, Excel, Oracle, Lotus notes and DTS (i.e. Import and Export) also worked to Automate the ETL operations.(Automate the SSIS Packages and Import, Export).
• Extensive knowledge on implementation of Set Analysis and worked on the Alternate states to do a comparative analysis in QlikView.
• Experience in developing User Interfaces and QlikView Dashboards using Chart-Box (Drill Down, Drill up & Cyclic Grouping), List Boxes, Input Fields, Table Boxes, Calendars, and Date Islands.
• 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 with Alteryx to collect the required data from large complex databases.
• Experienced in tuning long running SQL queries for better performance.
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level Data Analysis and Data Management Services.
• Experience in Technical Support, Troubleshooting, Report Design and Monitoring of system usage.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS:

Reporting Tools: Tableau Desktop x/v8.x/v9.x/v10.5 Tableau Server v6.x/v7.x/v8.x, Tableau Online v9.x,QlikView11.2/12, Crystal reports XI/2008, Business Objects XI R1/R2/R3.x/4.x, BO Universe Designer, BO Web intelligence

Databases: Teradata, MySQL, MS SQL Server, Alteryx, Hive, ORACLE, IBM DB2, MS Access, Amazon Redshift

ETL Tools: Informatica, SSIS

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, OpenProj, JIRA

Programming Languages: SQL, PL/SQL, HTML, Java/J2EE, ASP.net

Document Management: Documentum, Share point, Ultra Edit

Defect Management tool: HP Quality center

Service Management Tool: HP Service Manager, CA Service Desk

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile, Iterative)

Data Modeling: Power Designer, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Tableau Developer/Analyst

Responsibilities:

• Creating visually compelling and actionable interactive reports and dashboards.
• Reviewed and optimized SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time
• Involved in data conversion to provide reporting capabilities as per the requirement.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Validated the reports before publish reports to Tableau server, troubleshoot Tableau reports, dashboards, etc
• Involved in creating and developing reports and dashboards usingTableauDesktop 10.5
• Involved in creating data visualizations like Bar charts, cross tab, Tree Maps, Line charts, Scatter plot, Mapping Visualization etc withTableaudesktop 10.5
• Analyzed large volumes of data and develops medium to complex reports/dashboards, insights for clients. Has an in-depth understanding of the tools used for analysis, reporting and developing business insights. Involved in creating reports and dashboards using various charts withTableau
• Created different Maps and charts to improve productivity and sales.
• Involved in Data Blending and Merging.
• Created KPI's for the Obsolescence Team and a numerous ad-hoc reports.
• Involved in Admin activities like creating users and groups, publishing workbooks to • server and end users, assigning permissions, subscriptions etc.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets inTableau.
• Collaboration with data group for identifying data/ETL needs.
• Integrated dashboards with live Connection in Microsoft PowerPoint
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in TableauDesktop to validate static and dynamic data for data validation.
• Created SharePoint site to store all tableau workbooks and data source.
• Published Packaged workbooks and Tableau Extensoin.

Environment: Tableau 10.5 / 2018.2, Tableau Server 10.5, Microsoft SQL Server 2013, Alteryx,ERwinr8, Toad 8.7, SalesForce, Sharepoint.

Confidential, New York City, NY

Sr. Tableau Developer/Analyst

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• PerformTableauServer admin duties; add users/groups from Active Directory; instances in Tableau Server.
• Gathered SSRS reports requirements and created in Tableau.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets inTableau.
• Advanced knowledge of QlikView/QlikSense platform, including QlikView/QlikSense architecture, technical know-how, performance tuning, extensions, etc.
• Effectively used data blending feature in Tableau.
• Prepared and published customized reports/dashboards.
• Converted SSRS and Microstrategy reports into Tableau.
• DevelopedQVDashboards using various Chart types (straight, pivot, bar, Pie, gauge, combo, List boxes, Input Field, Table Box, sliders).
• Created different Action filters, Parameters and calculated fields to create most complicated dashboards.
• Worked with Tableau administrator in managing Production, Test and Development environments.
• Used data blending feature in tableau and defined best practices for Tableau report development.
• Created report on Cloud based environment using Amazon Redshift and published on Tableau
• Online.
• Integrated dashboards with live Connection in Microsoft PowerPoint.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau
• Desktop to validate static and dynamic data for data validation.
• Created SharePoint site to store all tableau workbooks and data source.
• Published Packaged workbooks.
• Developed Geo/Area Maps to show details on which states have most sales vs. the least sales.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Converted Pearl Script Query in to SQL Query for ETL.
• Created reports in Tableau using SSRS SQL Queries and Stored procedures.
• Created reports using Custom SQL for complex report views.
• Executed and tested required queries and reports before publishing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau 10.x, Tableau Server 10.x, Microsoft SQL Server 2013, Alteryx, ERwin r8, Toad 8.7, SSRS 2013, SalesForce, Sharepoint.

Confidential, Somerville NJ

Sr. Tableau Developer/Analyst

Responsibilities:

• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Building, publishing customized interactive reports and dashboards using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau and defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Provided support for Tableau developed objects and understand tool administration.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Worked with Tableau administrator in managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• 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.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.
• Created Sharepoint site to share project related documents.

Environment: Tableau 10.x/9.x, Teradata, SAP Business Objects 4.1/4.0, IDT, UDT, WEBI-BI: SAP BW Query Designer, Analyzer, Teradata SQL Assistant, Teradata Administrator, SQL BI Suite (SSRS / SSAS) 2012, Sharepoint

Confidential, Tucson, AZ

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel, Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Involved in creating interactive, parameterized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Creating visually compelling and actionable interactive reports and dashboards.
• Reviewed and optimized SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time
• Involved in data conversion to provide reporting capabilities as per the requirement.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Validated the reports before publish reports to Tableau server, troubleshoot Tableau reports, dashboards, etc
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop /Server), Oracle, SQL Server, DB2, SSIS, SQL, Toad, Unix, MS VISIO, Control-M, Erwin, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, Informatica, Autosys, CA Service Manager, UNIX, MS VISIO, Microsoft Office Suite.

Confidential, Neumann, OH

Sr. Data Analyst /Tableau Developer

Responsibilities:

• Conducted one-on-one sessions with business users to GatherDataWarehouse Requirements.
• Updated existing models to integrate new functionality into an existing application.
• Analyzed database requirements in detail with the project stakeholders by conducting joint Requirement Development sessions.
• Developed normalized Logical and Physical database models to design OLTP system.
• Experience in designing and development ofTableauvisualization solutions and Created Business requirement documents and plans for creating dashboards.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver
• Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Created visualization for logistics calculation and department spend analysis.
• Maintained Test log and Write test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Maintaining and implementingDataModels for EnterpriseDataWarehouse using ERWIN.
• Created and maintained Metadata, including table, column definitions.
• Worked with Database Administrators, BusinessAnalystsand Content Developers to conduct design reviews and validate the developed models.
• Responsible for Defining the Naming Standards fordatawarehouse.
• Possess strong Documentation skills and knowledge sharing among Team, conducteddata modeling review sessions for different user groups, participated in sessions to identify requirement feasibility.
• Extensive experience in PL/SQL programming - Stored Procedures, Functions, Packages and Triggers.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Provided support for Tableau developed objects and understand tool administration.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Worked withTableauadministrator in managing Production, Test and Development environments including installation of patches, security administration and access controls inTableau.
• Created Workbooks and dashboards for analyzing statistical billing data usingTableau8.0
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports inTableau.
• Identified the most appropriatedatasources based on an understanding of corporatedatathus providing a higher level of consistency in reports being used by various levels of management.
• Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the sourcedata.

Environment: Tableau9.x,Windows XP/NT/2000, SQL Server 2008, Teradata, Oracle11g, DB2, Informix, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro, OBIEE.

Confidential

Data Analyst/ Business Systems Analyst

Responsibilities:

• Analysed the business requirements of the project by studying the Business Requirement Specification document.
• Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks
• Created a logical design and physical design in Erwin.
• Worked in BI team to fulfill the needs of regulatory/management/finance/loss mitigation/fraud reporting.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Build a common utility frame work to handle all the exceptions in a Business process.
• Using Excel and VBA in the development of robust and flexible reporting systems.
• Retrieved data from data warehouse and generated a series of meaningful business reports using SSRS.
• Validated and tested reports, then published the reports to the report server.
• Performed and conducted complex custom analytics as needed by clients.
• Designed and developed specific databases for collection, tracking and reporting of data.
• Designed, coded, tested and debugger custom queries using Microsoft T-SQL and SQL reporting services.
• Built data input and designed data collection screens - Managed database design and maintenance, administration and security for the company.
• Discussed intelligence and information requirements with internal and external personnel.
• Data output - Made data chart presentations, coded variables from original data, conducted statistical analysis as and when required and provided summaries of analysis.Extensively used Erwin for developing data model using star schema methodologies.
• Created Entity relationship diagrams (ERD), Function relationship diagrams(FRD), data flow diagrams(DFD) and enforced all referential integrity constraints using Erwin data modeling tool
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Good knowledge and experience on Global Custody operations, capital markets, securities services, vendor management operations, trade finance, trade settlements, income processing, tax, corporate actions, market claims and reconciliations, NAV generations

Environment: Oracle 8i, SQL, PL/SQL, Erwin, SQL*Loader, Perl, TOAD and UNIX.

Confidential

MS SQL Server Developer/BI Developer

Responsibilities:

• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created Stored Procedures, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
• Implemented Data Mart, Facts, Dimensions, Snow Flake schema, Star Schema and OLAP cubes
• Created Calculated Measures and Dimension Members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Worked in visually enhancing reports as per user requirements.
• Responsible for tuning and Optimizing Queries for the reports.
• Expert in SQL Server Management Studio interface for writing queries and stored procedures.
• Created and maintained Roles and Database users.
• Created database objects like views, indexes, user defined functions, triggers and stored procedures.
• Responsible for trouble shooting the reports.
• Maintained DTS 2000 Packages and migrated them to SSIS

Environment: MS SQL Server 2005, MS Visual Studio 2005, Windows XP Professional, Team Foundation Server, ProClarity, SSIS, SSRS, SSAS.