SUMMARY:

• 7 Years of IT experience in Business Intelligence, Data warehousing, Data architecture and Data Modeling.
• Experience including analysis, modeling, design, and development of Tableau reports and dashboards for analytics
• Strong Knowledge and hands on experience of SDLC methodologies and Business Process Models (BPM) like Agile Modeling and Waterfall model.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions 6.x/7.x/8.x/9.x/10.x
• Have good understanding of Tableau architecture, design, development and end user experience.
• Perform business requirements analysis and transform those into plans and recommendations that are presented to company management.
• Worked on Tableau Desktop, Public and Tableau Server.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Worked Extensively on Adobe Analytics and generated reports using Adobe workspace.
• Hands - on with configuration, deployment & installation of Dynamics CRM, CRM Outlook Client
• Experience on Star schema and Snowflake schema.
• Good experience working with various BI/DW tools like Tableau, Data Stage, SSIS, SSRS, Teradata, Oracle, SQL Server, UNIX, Toad, Microsoft Office Suite.
• Worked extensively on the BI stack (SSRS/SSIS/SSAS)
• Strong experience working on modifying, updating SSRS reports
• Excellent on working with SSIS packages.
• Experience in Tableau Desktop, Tableau Server in various versions of tableau including Tableau 7x and Tableau 8x,9.x,10.x Extensive Tableau Experience in Enterprise Environment and Tableau Administration experience including technical support, troubleshooting, report design and monitoring of system administration parameters.
• Extensive experience in troubleshooting, performance tuning and supporting Business reporting platforms.
• Extensive experience with SQL language with major database systems including Teradata, Oracle, Microsoft SQL Server.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Excellent in scheduling and deployment of reports in Tableau
• Extensive experience in writing SQL and Jet SQL scripts to validate the database systems and for backend database testing.
• Designed the Logical and Physical Data Model (LDM & PDM) on the new Ratings Stream data mart, and enhanced the existing EDW Physical Data Model.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, Ms Access, Flat files into a staging area.
• Extensive Experience working on Confidential
• Excellent in rendering reports, managing subscriptions, creating reports in Tableau
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
• Excellent analytical and problem solving using tableau and SQL debugging skills.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple resources
• Excellent presentation, communication and interpersonal skills.
• Resourceful team player with excellent communication, interpersonal and managerial skills
• Extensive and successful experience in results-oriented business analysis for high-growth organizations

TECHNICAL SKILLS:

ETL/BI Reporting Tools: Tableau Suite of Tools 10.4, 10.3, 10.2, 10.1, 10, 9.3, 9.1 8.1, 8.0. 7 which includes Desktop, Server, online and Public and Administration of Tableau Server and.

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, MS Access 2000, Oracle 11g/10g/9i/8i/8.0, Jet SQL

Oracle Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export / Import, Oracle Discoverer 10g, Control-M,Autosys Scheduler

Programming Languages: C, C++, Java, HTML, JavaScript, Visual Basic 6.0, UNIX Shell Scripting, SQL, SQL*PLUS, PL / SQL

Computer Skills: MS Office - Excel, Word, Access, Outlook, Publisher, PowerPoint, SharePoint.

Operating Systems: UNIX, HP, Sun Solaris 2.x / 7 / 8, Windows ME / 2000 / 2003 / NT / XP, IBM AIX, Exceed (Editor)

Data Modeling Tools: ERWIN, Visio

Web Services & XML: SOAP, WSDL, XML, and XSLT

Scripting Language: JavaScript, JQuery

PROFESSIONAL EXPERIENCE:

Confidential, Lincolnshire, IL

Sr. Tableau Developer

Responsibilities:

• Developed executive dashboards to show reports from various departments
• Used complex calculated fields to meet exact requirements provided by users
• Extensively worked on multi-dimensional data source i.e., Confidential
• Responsible for creating complex calculated member using MDX formulas, and effectively made use of hierarchies
• Worked on Adobe Analytics to pull the data files and to validate the data using Adobe workspace
• Involved in the requirements gathering process to prepare the business requirement documents
• Conducted weekly meetings to inform users of progress of projects
• Restructured data using Initial SQL Queries, to allow flexibility in chart developments according to requirements
• Worked with data blends and joins to ensure maximum efficiency in dashboard performance
• Created complex custom SQL queries to pull the data from SQL Tables
• Conducted meetings with stakeholders to gather the requirements
• Created targets/goals for future months based on Tableau forecasting
• Optimized reports and created performance analysis dashboards
• Conducted in-depth analysis of requirements to provide efficient solution to users and to ensure best practices
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports.
• Build many Tableau reports using Bar Char, side-by-side bars, stacked bars, maps, tree map, pie charts, line charts, interactive reports using Tableau Desktop and Dashboard.
• Implemented solutions using action filters to navigate between various dashboards
• Coordinated with onshore and offshore teams to work on requirements
• Ensured extensive knowledge and documentation transfer to support teams to conclude each project
• Used Extract and Live connections of data to develop reports with efficiency
• Implemented permissions for users and ensure user security according to various clearance levels of business users
• Scheduled reports and ensured users were informed with each dashboard refresh

Environment: Tableau 10.4, 10.3, 10.2, 10.1 (Desktop, Server), Adobe Analytics, SQL 2012, Confidential

Confidential

Sr. Tableau Developer/Deployment Lead

Responsibilities:

• Worked as a Tableau Deployment lead.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, parameter driven analysis and create context filters, data source filters and follow to cascade filters while handling huge volume of data.
• Generated csv files with the help of Tableau API which in turn will be used by Microsoft CRM in order to retrieve the data without hitting the database.
• Implemented different action filters used for navigation, filtering and for comparison of data both from desktop and server perspective
• Created extracts for the workbooks to make them function faster.
• Created different KPI's using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
• Created Complex visualizations sourcing data from heterogeneous sources and cross joined them using Tableau 10.
• Created Aggregates, Hierarchies, Charts, filters, Quick filters, Context filters, User filters, Table Calculations, Trend Lines, calculated measures and reference lines to track the performance year distributions
• Implemented data blending and joins to work with data from multiple databases by establishing a relationship, verify the blended components from the data warehousing architect to achieve the required numbers.
• Leveraged Tableau built in graphical capabilities and functions to create out of box visualizations and calculations.
• Integrated Narratives for Tableau for Interpreting visuals in natural language for business users.
• Developed views which can visualize YOY, QOQ, YTD, STLY, QTD and MTD type of analysis and LOD functionality
• Implement language translations on the dashboards created and gave the ease of selecting the languages through the parameters, filters and responsible for the maintenance of its data source and deploy the dashboards through different server environments and sites by following the deployment standard created by the Team.

Environment: Tableau 9.1, 9.3, 10 (Desktop, Server), Microsoft CRM, Oracle 12c, Team Foundation Service.

Confidential, Hudson, OH

Sr.Tableau Developer/Admin

Responsibilities:

• Created worksheets and dashboards by using custom queries and multiple tables.
• Created various interactive customized dashboards and stories.
• Lead a team of ETL and BI developers for all the ETL processes and Report development.
• Created Rich dashboards using Tableau and prepared user stories to create compelling dashboards to deliver actionable insights.
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• • Developed various operational Drill-through and Drill-down reports using SSRS
• Developed Informatica Mappings and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting and loading data from various data sources.
• Used JavaScript API to set and create filters, select and highlight elements in the view, and process the view to retrieve updated data.
• Worked fully on customer management and relationship using MS Dynamic CRM.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Involved in creating Tree Map, Heat maps and background maps.
• Used Tableau's JavaScript API to integrate Tableau visualizations into web applications.
• Integrated Tableau with R and used Statistical R functions in various visualizations of the Performance dashboard.
• Worked with Tableau administrators in integrating fully interactive Tableau views on external websites through Java API scripting.
• Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Designed and implemented the regular (Daily, Weekly, Monthly, Quarterly …) or Non-regular financial reports by Oracle Packages, Procedures, Trigger, SAS System and Unix Shell Scripts.
• Completing the new development and enhancement tasks following the SDLC process
• Involved in Developing Tableau visualizations and dashboards using Tableau Desktop.
• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Extensively used data blending in Tableau
• Responsible for inside Sales, Tele Sales, Field Sales and Technical Support Team were brought on the CRM for smarter collaboration by implementing MS CRM.
• Used Tableau Desktop to analyze and obtain insights into large data sets & also Generated Tableau reports with Trend lines.
• Experience in creating complex SQL queries from scratch, and tuning existing SQL queries for better performance.
• Analyzing and building proof of concepts to convert SAS reports into tableau or use SAS dataset in Tableau.
• Migrated SAS reports to Tableau by converting SAS Dataset to csv format and reported from Tableau. This method uses a SAS dataset to feed the Tableau environment. Created a POC to show based on the requirements of SAS/Tableau analytical data requirements.
• Involved in creating tables, views, Extracts, Teradata, Data blending, Table joining and various database objects in Google Big Query.
• Had thorough study of the requirements and gathered the necessary information to start the report design
• Developed and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Generated tableau dashboards with combination charts for clear understanding using forecast and reference lines
• Expertise in analysis, design and implementation of data warehousing applications using Tableau, Cognos, Teradata, DataStage, SQL Server, UNIX, DB2, Oracle technologies.
• Applied various types of filters like Data source filters, Quick filters and Context Filters.
• Regularly interacting with customer to resolve issues.
• Responsible for Preparing the Report Design specifications based on the User's requirement.
• Extracted data from various sources and performed data blending.
• Developed various types of complex reports like Cross tab reports, Drill Down and Master Detail Relationships.
• Worked collaboratively with a team of Teradata developers to build ETL process needed for reporting.
• Coordinating with Business Analyst in validating report requirements.
• Designed, developed and documented the ETL processes using Informatica for extracting the data and data transformations.
• Applied the actions in the work sheets and dashboards.

Environment: Tableau (Desktop, Server),Oracle 11g, Oracle 12c, Teradata, Informatica 9.1, SSRS, SSIS, SSAS Data Modelling, SAS 9.3, Tableau ODBC Connection for SAS data set. Java API

Confidential, Pittsburgh, PA

Tableau Developer/Admin

Responsibilities:

• Deep experience with the design and development of Tableau Confidential .
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2005 Integration Services (SSIS), SQL Server Reporting Service (SSRS) including MDX Development, and SQL Server Analysis Service (SSAS).
• Proven team leader and project manager able to coordinate daily operations and activities.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Developed JQuery Ajax components and integrated with Java Server Pages
• Designed customized software application for information management system using Java Standard Edition
• Improved the Performance of data extracts created from Hadoop using contexts and Action filters instead of quick filters
• Defined best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Managed Client/Prospect management, Activity Tracking and Reporting, Deal/Pipeline management, Referrals management, Client Coverage Team management, data maintenance processes and integration with compensation processes using MS CRM.
• Exported data from a report to several file formats likes PDF, Image and Excel according to the needs of management.
• Exported reports into various formats like PDF, HTML, EXCEL and WORD for end users.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Developed complex visualizations using Amazon Redshift.
• Good understanding of NoSQL databases such as Cassandra, HBase and MongoDB.
• Experience in creating complex SQL queries from scratch, and tuning existing SQL queries for better performance.
• Analyzing and building proof of concepts to convert SAS reports into tableau or use SAS dataset in Tableau.
• Developed XMLs, JavaScript and Java classes for dynamic HTML5 generation to perform the server-side processing on the client requests
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Involved in license management SLA’s with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.

Environment: Tableau Desktop 7.0, 8.0, 8.1, 8.2,Tableau server / Administrator Teradata, Teradata SQL Assistant, SSRS, SSIS, SSAS Teradata Administrator, Teradata, SQL,Agile-Scrum, UNIX, MS VISIO, Microsoft Office Suite. JQuery, JavaScript.

Confidential, Columbus, OH

SQL Developer

Responsibilities:

• Interacted with the Business Analysts for requirement analysis and created Functional Specification Documents based on the business requirements.
• Worked through all the phases of Software Development Life Cycle (SDLC) including Requirements Gathering, Analysis, Design, Development, Testing, Production and Post - production Support.
• Developed many Stored Procedures and User Defined Functions for providing input feed for front end applications.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Involved in Extraction, Transformation and loading of data from Oracle and flat file sources into Target SQL Server database.
• Identified the DTS packages which are complex and re-designed those packages in SSIS for better use of new optimized features and buffer management system of SSIS.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.

Environment: Windows 2008, 2008, MS SQL Server 2005/2008 R2/2012, SSIS, Microsoft office, SQL Server 2008, SQL Server Reporting Services (SSRS).