SUMMARY

• 8+ years of experience in software development, integration, implementation, and maintenance of Business Intelligence and database platforms.
• 3+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 7.0, 8.0, 8.1, 8.2, 8.3, 9.1 as a developer
• Proficient in Tableau data visualization tools to analyze and obtain insights from different data sources, create compelling interactive reports and dashboards.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Worked with Netezza, Oracle, MS SQL Server, Teradata, MS access databases, Excel and text files.
• Collaborative team player, quick learnerwith good communication, strongproblem solving skills with attention to details.
• Proficient in creating user friendly, interactive dashboards by employing tableau features such as calculated fields, quick filters, parameters, sets, groups, and complex table calculations.
• Established tableau recommended best practices for Enterprise Tableau Environment, and development processes.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Worked on various dashboards to improve its performance tuning as per tableau recommended guidelines.

TECHNICAL SKILLS

Tools: Tableau 9.0.2/8.3/8.2/8.1/8.0/7.0 , BO 4.1/4.0/3.1, Cognos

Database: Oracle, MS SQL Server 2008/2012, DB2, Teradata, MS Access.

Languages: C, C++,SQL, PL/SQL

ETL: SQL Server Integration Services (SSIS).

Operating Systems: Windows 98/ 2000/2005/2008 / XP/NT, MS DOS and Unix.

Packages: MS-Office

Web Servers: Web sphere

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Tableau Developer

Responsibilities:

• Involved in developing strategic tableau dashboards comprising sales, field operations, logistics and marketing. Instrumental in building these dashboards using the new SAP Hana data source and moving from the current legacy system.
• A key team member of ISS - CCBCC, involved in Coke One North America (CONA) project. Cona project emphasizes on standardization of reporting by all bottlers of Coca Cola in the USA.
• Currently working on three important projects - Daily Sales Report (DSR), Field Sales Operation (FSOP), and Red Classic Survey reports.
• Working closely with Project Managers, data team, Business Analysts, QA and also business executives.
• Also involved in training the users on dashboard navigations, interactivity, upload design documents and FAQs, in shared drive for user access.
• Developed and designed reports using tableau recommended guidelines for improved performance, and keeping in mind the user requirement.

Environment: Tableau Desktop 9.0.2, MS - SQL 2014, SAP Hana, Windows 2013

Confidential, Charlotte, NC

Sr. Tableau Developer

Responsibilities:

• Involved in developing tableau dashboards, worksheets, interactive data visualization, and adhoc reports. Instrumental in building these reports in Tableau from the current BO reports and publishing in the tableau server.
• Involved in two major projects in Neurosciences and Sepsis departments. Designed and analysed various complex reports in tableau, built earlier using BO Reports.
• Developed various Charts, Graphs like Bar chart (Side By Side, Stacked), Line graphs, bullet charts, Pie -Charts on Tableau, built earlier in BO Reports.
• Involved in developing adhoc reports comprising clinical reports, financial dashboards, patient population, provider dashboard and claims data.
• Designed and implemented adhoc Reports, extracting data from an IBM Netezza database. Worked with Business Users to develop system requirements, analyze data element and provide continuous end-user support.
• Implemented Security Features like row level, report level to make the data secure, and accessible only to the intended business users
• Worked very closely with database team, project managers of other departments, and production team to coordinate and assist in release roll-out.
• Involved in training the users on interactive dashboards, action filters, sorting and customized views on existing visualizations generated thru Tableau desktop.

Environment: Tableau Desktop 9.0.2, IBM-Netezza, Aginity Workbench for PureData System for Analytics - Version 4.4, MS SQL 11.0, Windows 2013

Confidential, Newark, NJ

Sr. Tableau Developer

Responsibilities:

• Assisted the client with thorough analysis of their existing system, challenges, and business needs. Documented the reporting requirements and interacted with users, gathered information for project development.
• Gathered business requirements, defined data flow coming from multiple sources, analysed data quality, worked with the data warehouse team to develop logical data models.
• Involved in project planning, scheduling timelines for deliverables, and obtaining approval from all the stakeholders.
• Developed, published user friendly interactive reports and dashboards. Automated these reports in tableau server using its strong feature of scheduling and authenticating.
• Employed rich tableau features using action filters, parameters, calculated fields, drill downs and sets giving the user a friendly navigation option through all the views in the dashboard.
• Created tableau dashboards using bar-in-bar graphs, line charts, filled maps, dual axis charts, bubble charts and Gantt charts.
• Effectively used data joining or data blending features for building an integrated view of multiple tables or data sources.
• Documented best practices for tableau report development, performance tuning, and shared it in a common folder for access by the users and other developers.
• Developed dashboards in tableau desktop, published them on to tableau server as .twbx packaged workbook giving the user an option for build customized reports if they so desire.
• Scheduled data refresh on tableau server for daily, weekly, or customized refresh depending on the business requirement to ensure that dashboards update periodically with fresh data.
• Developed and published customized and interactive dashboards, shared URL with the users giving them an option to open the dashboard with a click of a button.
• Initiated and organized for meetings with the data warehouse team, business users, analysts, project managers and leadership team to update the project, and to seek feedback.
• Maintained dashboards, provided post production support, and any quick fixes required.

Environment: Tableau Desktop 8.3/8.2/ 7.0, BusinessObjectsXIR3, IDT, Oracle 11g/10g, SQL Server 2008/2012, Info view, Windows 2008 Server.

Confidential, New York, NY

BI Developer (Cognos, Tableau)

Responsibilities:

• Gathered information, analyzed the data and designed dashboards as per the requirement.
• Developed and maintained design specifications, data presentation and prepared report presentation document with best practices.
• Developed tableau dashboards showing trend analysis on hiring, and attrition reports with option for the user to view the description for attrition reported.
• Designed summary level and detailed reports in Tableau, utilized the cascading feature on dimension filters to provide detailed analysis of the reports.
• Used data extract in tableau and used data source filters to limit the data required for reporting purpose. This enhanced tableau dashboard performance to a great extent.
• Setup stand alone and distributed tableau server to publish and distribute dashboards easily
• Analysis of the requirements for the creation of CRN reports.
• Migrated catalogs and CRN reports from Cognos 7.3 to Cognos 8.2
• Migrated power play cubes and reports from Cognos 7.3 to Cognos 8.2.
• Involved in the design and development of CRN reports in Report Studio.
• Developed standard reports, list, cross tab, charts, drill-through Reports, master detail reports using Report Studio and Query Studio.
• Created query prompts, calculations, conditions and filters in Report Studio.
• Developed prompt pages and conditional variables using Report Studio.
• Experience with conditional blocks and conditional layouts.
• Created the data sources in Cognos Connection.
• Upgraded the existing models and packages to Cognos 8 BI environment.
• Converted the existing ReportNet 1.1 reports to Cognos 8 BI reports.
• Maintained Cognos software (Upgrade, apply patches etc).
• Involved in deployment of applications to production.
• Troubleshoot the errors during the upgrade process

Environment: Tableau Server 6, Tableau Desktop 6, Cognos 10.1, Desktop Reports, Administration, Dashboards, Tera Data, MS SQL Server 2000,T-SQL, Access 2000

Confidential, Cleveland, OH

Cognos Developer

Responsibilities:

• Worked on Associate Reporting project used by 20 carriers and 500 customer providers to monitor their incoming traffic and their funnel activity.
• Designed & implemented various reports for financial dashboards, P&L reports, Retention data, Billing data, Customer Acquisition, Email Marketing, IT & Sales Center, Enterprise wide reporting which left me with abundant subject, applications and data knowledge surrounding the Finance, Planning, Marketing, IT, Operations and Sales Center departments.
• Created metadata models, namespaces, folders, query subjects and packages from SQL data source using Cognos Framework Manager.
• Involved in organizing the Framework Manager model into several different views as required by the end user.
• Generated projects and publishedpackagesusing Framework Manager.
• Developed list, crosstab, chart and complex reports in report studio which involved prompts, cascading prompts, filters, drill through, master-detail relationships, and tabular models and enhanced reports using conditional formatting.
• Created daily, weekly, monthly and quarterly reports for the management team and sales center operation managers using Report Studio.
• Created Query Prompts, Calculations, Conditions and Filters to generate efficient and user-friendly reports.
• Created multi page report based on multiple Master queries to show the data on different pages when the Master record changes in a Report.
• Developed reports with several prompts, (text box, value, select & search and date prompts) and cascading prompts.
• Involved in testing and improving report performance by optimizing the query performance and implementing appropriate prompts.

Environment: Cognos BI 8.4.1/8.3, Cognos Connection, Report Studio, Query Studio, Framework Manager, MS SQL server 2002-2008, SQL, Quality Center, Windows XP.

Confidential, Chicago, IL

SQL / BI Developer

Responsibilities:

• Interacted with clients for business requirements during design & development phases.
• Migrated databases from SQL Server 2005 & various other sources into SQL Server 2008.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, & import/export wizard while developing packages.
• Designed, developed & tested the ETL processes according to industry best practices using SSIS.
• Migrated data to the staging server and later populated to the OLAP (Online Analytical Processing) Server.
• Involved in implementing different types of reports & schedules for reporting purposes using SSRS.
• Generated on-demand, ad-hoc, custom reports for business analysis or Executive reporting using SQL Server Reporting Services (SSRS).
• Used SQL profiler for performance tuning & debugging issue whenever necessary.

Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel, & Windows 2003 server.

Confidential

SQL / BI DEVELOPER

Responsibilities:

• Oversaw installations, upgrades of SQL 2008, SQL 2005 to SQL 2008.
• Involved in database design, creation and maintenance of databases.
• Managed the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitored & tuned SQL scripts by performance monitoring. Created upgrade scripts for production Database and supporting it.
• Fine-tuned & implemented trouble shooting for the server & application.
• Worked on database designing, logical and physical data modelling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views.
• Monitored MS SQL Server performance and network issues.
• Engaged in performance monitoring and tuning of SQL servers.

Environment: MS SQL Server 2008/2005, Windows XP Server, MS Access.