PROFESSIONAL SUMMARY:

• 7 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Implementation
• Skilled in Tableau Desktop versions 8.1 and 8.2. for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Experience in configuring reports from different data sources using data blending
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XLS, HTML
• Experience Designing and Developing Crystal Reports using Crystal Reports 8.5/9.0/10/11.5 .
• Experience in Business Objects XI R3/R2/6.X/5.X (Designer, CMC, Web Intelligence, Desktop Intelligence, Scheduler, Import wizard).
• Improved Reports performance in tableau using extracts and context filters
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Results oriented, self - starter looking for challenges, ability to rapidly learn & apply new technologies & good interpersonal skills
• Expertise in preparing code documentation in support of application development, including high level and detailed design documents, unit test specifications, interface specifications, etc
• Excellent Communication, Analytical and Programming skills
• Excellent ability to understand and analyze the client requirements
• Experience in full life cycle development (SDLC)

TECHNICAL SKILLS:

BI/Visualization Tools: Tableau 7.0/8.2, Tableau server 8.2, Tableau Reader 8.1, SSRS. Tableau Desktop 8.1/8.2, Tableau Public 8.2, Tableau Reader 8.2, Tableau Server 8.2, Business Objects XI3.1-R2/6X,Crystal Reports 8.5/9.0/10/11.5

Programming: C, C++, Java, XML &HTML, SQL

Utilities: MS Office Suite, MS SharePoint, MS Project

Databases: Oracle 10g/11i, Oracle SQL Server 2008 R2, MS Access, MS Excel

OS Platforms: Windows7/8/2003/NT, Mac OS, DOS, UNIX, Linux

ETL Tools: Informatica, Datastage, SSIS

CASE Tools: Microsoft Visual Source Safe, PVCS, Version Manager

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Tableau Developer

Responsibilities:

• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
• Generated ad-hoc Tableau reports based on user requirements.
• Combined multiple data sources by joining tables and using Data Blending.
• Generated Tableau reports with Trend lines, lines and Bands and also generated several drill down and drill up reports.
• Worked on groups, sets, different calculation functions including Table calculations.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created dashboards with the security using filters for the clients to measure cost saving.
• Performed end-to-end Data Analysis and ensured the data quality gaps are identified.
• Designed and developed Business Intelligence end to end solutions using Tableau.
• Published Workbooks by creating user filters and security, so intended teams can view it.
• Developed tableau dashboards with combination charts for clear understanding.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps,Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Build complex calculations using advanced functions (ATTR, DATEDIFF, STR, IFs, nested IFs, OR, NOT,AND, SUMIF, COUNTIF, LOOKUPs and QUICK TABLE calculations).
• Created visualizations in Tableau using Excel data extract source, wrote Test Cases and documented the Test Results.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Tableau

Environment: Tableau Desktop 8.2 Tableau server / Administrator, SQL developer, OBIEE, SQL-Server 2008/2005, MS-Access, Oracle 10g, SQL,MS Office, Excel, Outlook, Word, PowerPoint, Windows

Confidential, Lincolnshire, IL

Tableau Developer

Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• 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.
• Created highly interactive visual Reports using Tableau.
• Designed business intelligence dashboards using Tableau (Desktop/Server), allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Gathered, documented requirement from the users and developed Complex Graphical User Interactive reports using various Tableau Objects.
• Strong Skills in Data Modeling & Loading data from multiple data sources.
• Actively involved in deployment and post release support.
• Validated technical design created by developers against functional specifications.
• Created interactive dashboards using OBIEE 10g, created ibots.
• Lead OBIEE and QA teams to design test plan for user Acceptance Testing (UAT)
• Provided formal project presentations to the client, executive management and line staff as required
• Worked closely with sales, marketing, and production business units to perform business and system analysis.

Environment: Dash boarding/Analytics Tableau 8.1, MS SharePoint, SQL, PL/SQL, Oracle9i/10g, Windows

Confidential, Richmond, VA

Tableau Developer

Responsibilities:

• Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input toTableau.
• CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, 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
• Defined best practices forTableaureport development.Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration, and configuration for data warehouse with automated and manual field data collection systems
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Provided 24/7 production support for Tableauusersand conducting s to user on interact, filter, sort and customize views on an existing visualization generated thruTableaudesktop.
• Created SQL Queries for testing the tableau Dashboards.
• Designed and developed reports such asDrill down, Drill Through usingMicrosoft Reporting Services (SSRS)
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 6/7, Tableau Desktop 6/7,MS SQL Server 2008, Oracle 10g, SQL BI Suite (SSIS, SSRS, SSAS) Visual Studio 2010, Windows

Confidential

Crystal/BO Developer

Responsibilities:

• Involved in gathering the requirements to create the reports by conducting user interviews.
• Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.
• Exported Crystal reports into various Formats like PDF, HTML, Excel and Word for the Users.
• Created contexts and aliases for resolving loops in the Universes.
• Performed analysis and collection of claims data involved in Scheduling the monthly, weekly Crystal reports Using Crystal Enterprise.
• Use of Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Creation of reports like, reports by product, reports by customer, reports by period and comparative reports.
• Generated multi-dimensional reports using Info View.
• Created various simple and complex reports using drill down/up, slice and dice, breaks, filters and alerts.
• Created reports using free hand SQL when the existing universe is not supported the report.
• Remedy Ticket Support for Business Objects and Crystal reports for Production Environment.
• Provided to the users, developed user guides, docs, requirement docs etc.
• Written PL/SQL programs on Oracle Database. Performed performance tuning.
• Maintained Supervisor by creating user accounts and assigning privileges.
• Extensively used calculations, variables, breaks, sorting, drill down, slice and dice, alerts for creating Business Objects reports.
• Extensively used Crystal Xcelsius to build Dashboards and Scorecard presentation.
• Created interactive excel dashboards and charts and graphs, created scorecards, metric analytics with Crystal Xcelsius.
• Created users & groups managed users like (resetting password, assigning privileges, enabling their ID's) & managed groups.
• Migration of universes and documents from one domain to another.
• Involved in designing logical and physical data Model designing.

Environment: Crystal Reports XI, Windows NT, Oracle 9i, SQL Server 2000, DB2, SQL, Remedy, MS OFFICE, Business objects XI R2, Toad, VB.Net, HTML, Apache Tomcat, ERWIN, PVCS, Manual Testing.

Confidential

BI DEVELOPER

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, 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.
• Presentation of the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.

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.