SUMMARY:

• 7 of experience in IT Industry. Expertise in the field of Business Intelligence(BI) Analytics, Reporting & Dashboard development using Tableau and Crystal Repors.
• Good experience in Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 6/ 7/8 / 9 .
• Provide Business Intelligence support using Tableau for implementing effective Business dashboards & visualizations of data.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Skilled in Tableau Desktop for Data visualization , Reporting and Analysis ; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published Dashboards and scheduling Data refresh instances.
• Worked extensively on joining tables, multiple data connections using blending, worked on Data Extracts and managing queries.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Experienced in writing complex SQL Queries involving various tables using SQL joins and writing Sub Queries.
• Experienced in writing complex - SQL Stored Procedures and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity.
• Good RDBMS skills in MS SQL Server 2000/2005/2008, MS-Access, MQ Series, Oracle.
• Established Best Practices for Enterprise Tableau Environment and application intake and Development processes.
• Having experience on various data analyzation techniques, reports efforts estimation, Reports development planning.
• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
• Excellent Communication Skills and Self-motivated team player with strong problem solution skills and a thirst to learn the latest and the greatest technologies in the industry.

TECHNICAL SKILLS:

Business Intelligence tools: Tableau (Desktop & Server), 9.0/8.2/8.4/8.1, Tableau 7, MySQL Server, SQL Server 2008, Oracle 11g, PL/SQL, Microsoft Office 2007, Visual Studio 2010, Crystal Reports 2008(12), SSIS

Tableau Tools: Tableau 8.0/9.2, Tableau server 8.2, Tableau Reader 8.1, Tableau Desktop 9.1/9.2, Tableau Public 9.2, Tableau Reader 8.2, Tableau Server 8.2, SQL Server 2012/2008R2/2008, Oracle, SQL server Reporting Service 2008, SQL Server Management Studio, MS-Excel

Languages: C, C++, C#, SQL, T-SQL, PL/SQL, HTML

Databases: Oracle 10g/11g, MS SQL Server, MS Access, Oracle, MySQL, Teradata

Operating Systems: MS Windows2007/2008/XP/8.1/10, UNIX, Mac OS

PROFESSIONAL EXPERIENCE:

Senior Tableau Developer

Confidential, Cincinnati, OH

Responsibilities:

• Created Relationships, actions, data blending, filters, parameters, hierarchies, Level-of-Detail (LOD), calculated fields, sorting, groupings, live connections, and in-memory in both tableau 10.4 and excel.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau online.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Created views using various axes like Individual Axes, Dual Axes.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Cleared errors according to business requirements excel sheet and helped to create Documentation for the dashboards.
• Used R and exported data via a supported data source and then visualized that data in Tableau.
• Used R functions as Table calculations (aggregated) like Sum, MIN, MAX etc. in Tableau.
• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Conducted ETL development in the Netezza environment using standard business design methodologies.
• Developed Informatica Mappings using various transformations like Lookup, Update Strategy, Expression, Filter, Router etc. and also developed workflows for the developed mappings.
• Work with customers in gathering business requirements for data cleansing and performed data cleansing and data scrubbing.

Environment: Tableau Desktop 8.x, Tableau Server, Metadata, SQL 2012, Oracle 10g/11g, Windows XP, Informatica Power Center 9.5, Netezza Database, UNIX, Autosys

Senior Tableau Developer

Confidential , Niskayuna, NY

Responsibilities:

• Involve in data gathering meetings with business and stake holders.
• Involve in creating technical assessment about the current environment.
• Consult with managerial, engineering, and technical personnel to clarify program intent, identify problems, and suggest changes.
• Developed Tableau data visualization using Cross tabs, Sankey diagram, Heat maps, Waterfall charts, Geographic Map, Bar charts.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Gathered data from different data sources like MySQL, Excel, Oracle, My Access, MSSQL, Hadoop and Hive etc.
• Providing ongoing support and enhancements for the applications.
• Developed Tableau dashboards from multiple data sources using Data Blending
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Created different KPI using calculated key figures and parameters
• Created multiple tableau dashboards with custom SQL queries to enhance the processing of complex visualization.
• Created Dashboards with interactive views, Monthly and Quarterly trends.
• Published Workbooks, Dashboards and Data sources to the Tableau server.
• Create design documents against the requirements captured.
• Highly used level of detailed calculations in the workbook.
• Validate the data for each report and review the reports.
• Created dashboards using Table calculations for Rolling 12 months and Performed report tuning using extracts, Cache options, removing unused fields.
• Created report schedules on Tableau server and Tableau Online.
• Created complex calculations including arithmetic calculations, custom aggregations, Nested calculations and quick table calculations.
• Will also conduct periodic meetings with different teams to discuss progress and roadblocks of the engagement.

Environment: Tableau Desktop 9.3/10.2,Tableau Server, Oracle, Tab Jolt, MySQL, Hadoop, Cloud database, Salesforce, Microsoft PowerPivot, Pivotal HD, HDFS, AWS, Microsoft SQL server 2012, MS Excel/Access, Windows 8.

Business Intelligence (BI) Developer

Confidential, Chicago, IL

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Upgraded Workbooks and Dashboards from Tableau 6 to Tableau 7
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
• Involved in new KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau. Effectively used data blending, quick filters, actions, hierarchy features in tableau.
• Executed and tested required queries and reports before publishing. Converted Metric insight reports to tableau reports.
• Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
• Scheduled frequency and time to refresh data for the data sources are publishes or extracted to server.

Environment: Tableau Server/Reader, Oracle 11i, Windows 2003/ XP, Tableau Desktop 7.0, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, Microsoft office

Tableau Developer

Confidential, Louisville, KY

Responsibilities:

• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Gathered business requirements from end users, analyzed and documented the same for various reporting needs.
• Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Served as a liaison between the business & the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently. Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
• Created Data extracts for better performance of dashboards and accessing data offline.
• Integrated dashboards with live Connection in Microsoft PowerPoint.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Prepared design specification documents as per the inputs received from the Architect and the Business Analyst.
• Extracted data from Heterogeneous source systems like Oracle, SQL Server and Flat files with fixed width and delimited.
• Involved in Cleansing and Extraction of data and defined quality process for the warehouse.
• Developed Informatica ETL mappings, sessions and workflows based on the technical specification document.
• Created Mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Designed and developed the logic for handling Slowly Changing Dimension tables load by flagging the record using update strategy for populating the desired.
• Developed reusable mapplets and transformations for reusable business calculation.
• Used exception handling logic in all mappings to handle the null values or rejected rows.
• Tuned the ETL components to gain the performance and to avoid business continuity.
• Worked with Persistent Caches for Conformed Dimensions for the better performance and faster data load to the data warehouse.

Environment: MS Access, Tableau, SQL, Oracle, Word Press, MS Excel, Tableau Desktop 10, Microsoft Office (Word, Excel, Power Point), Informatica Power Center 8.6, Informatica Data Quality 9.x, IDQ admin console, UC4, Oracle 11g, Toad for Oracle, MS SQL Server 2008, AIX server, Unix, Appworx, Winscp, Putty, Serena Version Manager.

BI Developer

Confidential

Responsibilities:

• Worked with business process owners in collecting Project specifications and their Analysis.
• Designed Crystal Reports using Crystal Reports 10, Formulas, Parameters, Selection Criteria, Sub reports to handle Report Requests
• Extensive experience in creating reports with Charts (Bar Charts, Pie Charts, etc), Cross tabs and Sub reports.
• Analyze Requirements and write technical specifications with the business analysts to develop Reports that conform to the enterprise standards.
• Access multiple different OLAP sources in the same report to get a comprehensive view of the business and the cross-impact that one trend may have on another.
• Use a comprehensive range of business and time calculations.
• Using Xcelsius created Dashboards and provides the ability to create management charts, which are at-a-glance displays that show the status of business metrics.
• Extensively participated in the development of the Universe based on underlying relational (data structures) star schema. Resolved several issues with regards to the contexts, predefined conditions, same prompts handling multiple data sources etc.
• Involved in Training, Quality Analysis and Production Support some of the users in developing the basic reports using Business Objects XI r2.
• Analyzed and created facts and dimension tables.

Environment: Crystal Reports 10, Business Objects 6.5.2/ XI R2, Xcelsius, Oracle 9i/10g, Web Intelligence, 6.5, Infoview 6.5, SQL Server 2005, Teradata v2r6,DB2, Microsoft Visio, Windows XP, ASP.Net, MS Access 2003, MS Excel 2003, Autosys.

BI Developer

Confidential

Responsibilities:

• Responsibilities include understanding the business functionality, direct interaction with users for specifications.
• Designed and developed reports using Crystal Reports.
• Written Stored Procedures and Views on SQL Server 2000 to be used in various Crystal Reports.
• Involved in Physical/Logical design of database, creating and managing the database and all the database objects.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Experience in writing, testing, and implementation of the PL/SQL triggers, stored procedures, functions, and packages to implement business logic.
• Created entry forms/reports for various modules. Created databases, loaded initialization data, generated users, and assigned roles and access.
• Generated the reports and giving those reports to users for verification.
• Responsible for drafting documentation for end user usage and develop training materials.
• Responsibilities included setup and troubleshooting final product on user's desktops.
• Developed database connections, SQL joins, loops, views, aggregates.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports2008(12).
• Used prompts, alerts, drill down analysis as per the end user requirements.

Environment: Crystal Reports2008(12), SQL Server 2008, SQL Server Integration Services (SSIS), TOAD and PL/SQL.