SUMMARY

• Tableau/BI Developer with Over 8 Years of IT Experience in Business Intelligence and Data Warehousing applications in Retail, Financial, Health Care, Pharmacy and Manufacturing industries.
• 4+ years of Experience in Tableau Desktop/Server and 4years of experience in SAP Business objects in creating highly interactive Data visualization Reports and Dashboards.
• Extensive knowledge in Dimensional data modeling, Star Schema, Snow - Flake Schema, Normalization, Physical and Logical modeling.
• Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth
• Utilized all Tableau tools including Tableau Desktop, Tableau Public, and Tableau Reader extensively
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Wrote SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports
• Built and expanded reports available for both internal support and external customer/carrier reports, which included increasing the scope of data extracted and utilized for reporting purposes
• Created numerous ad-hoc analysis, dashboards, reports, graphs, and charts
• Experience with analysis, data, databases, and business intelligence
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables
• Excellent in applying Actions and Quick Filters
• Expertise in Data Warehouse development working with Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Data Integrator with DB2 UDB, Oracle, and SQL Server.
• Experience in developing Dashboard using OLAP cubes.
• Experience in using Teradata database to create the reports and dashboards
• SQL Server and Oracle Database development experience using tables, triggers, views, packages and stored procedures in PL/SQL & T-SQL. Strong RDBMS fundamentals.
• Experience in Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008, Teradata, Sybase, Toad, MS Access 2000/97/7.0 and MS Excel. Experience working with SQL, PL/SQL scripts, views, indexes, storedprocedures and other components of database applications.
• Good Knowledge in analysing, designing and modelling data warehouses, OLAP and star schema data marts for various business verticals like Financial, Electronics, retails.
• Experience in validating and Analysing data in worksheets using sorting, filtering, Vlookup,Hlookup, creating PIVOT tables and PIVOT charts, Index techniques.
• Involved in gathering, analysing, and documenting business requirements, functional requirements and data specifications for developing Business Dashboards, reports, scorecards.
• Worked extensively with Business Objects Data Integrator to create complex Data Flows using Query, Table comparison, lookups and all transformations.
• Experienced in managing, monitoring and investigating cases such as trouble tickets from customers and fixing the issues
• Hands on experience with reporting tools BOBJ, Crystal Reports, and Xcelsius.
• Exposure to Full Life Cycle Solution Development (Requirement gathering, Analysis, Design, Development, Documentation, Testing and User training)
• Ability to handle multiple tasks and work independently as well as in a team.

TECHNICAL SKILLS

ETL/BI Reporting Tools: Tableau Suite of Tools 8.1, 8.0. 7, 6, 5.1 which includes Desktop, Server, online and Public and Administration of Tableau Server and SAP Business Objects XI R2, XIR3,OLAP cubes.

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

Programming Languages: SQL, TSQL,PL/SQL, Java, C and C++

Operating Systems: UNIX, Linux, Ubuntu and Windows

Application Servers: WebLogic, WebSphere

Web Services & XML: SOAP, WSDL, XML, and XSLT, Amazon web services(AWS)

Scripting Language: JavaScript, JQuery

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Responsibilities:

• Responsible for the interaction with the Business Stake holders, Product Management, Hospital Planners and gathering the business questions and requirements for the reports and Dashboard development.
• Responsible for the implementation of Row level security with the existing Data Mart
• Involved in the prototyping based on the user requirements and interacting with the management.
• Responsible for the performance tuning of Dashboards based on the best practices of Tableau.
• Involved in the Adhoc reporting for the various teams across the organization.
• Creation of user, groups, folder structures, library and repository Tableau server logons and security checks.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.
• Created Complex workbooks and Dashboards by connecting to multiple data source using datablending.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Setfunctionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards and worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using KeyPerformance Measures ( KPI ) and Measure
• Worked in Agile environment with Rally and involved in Conducting scrum meetings.
• Extensively worked with the QA Team and the Business users during UAT in Sign-off process. Track issues or bugs to resolve.
• Involved in Regression testing, Unit testing (UAT) and fixing issues in the Reports during validation and before approving the reports to Production Environment.

Confidential, Los Angeles, CA

Tableau Developer/Admin

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Used Sheet filters to produce multiple chart types in a single view.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Foundefficientways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Building,publishingcustomizedinteractivereportsanddashboards,reportschedulingusing Tableau server.
• Creating users, groups, projects, Data connections, settings as tableau administrator.
• Developed Dashboards using OLAP cubes.
• Ad-hoc ETL, Reports requirement runs.
• Extensive usage of Amazon web services(AWS) for connecting to the data sources on cloud using Amazon redshift services
• Use of Java script for creating the client side validations in the webpages with dashboards.
• Use of Java script for embedding the dashboards on the webpages.
• InvolvedincreatingdashboardsandreportsinTableau8.1andMaintainingserveractivities,useractivity, and customized views on Server Analysis.
• Createdorganized,customizedanalysisandvisualizedprojectsanddashboardstopresenttoSeniorLevel
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created visualization for logistics calculation and department spend analysis.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Environment: s: TableauDesktop8.0/7.0,Tableauserver/Administrator,SQLdeveloper, SSIS,OLAP, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Confidential

Tableau Developer/Admin

Responsibilities:

• Created Tableau scorecards, 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.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Extensive use of Teradata Database to create the Reports.
• Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 and migrated those toTeradata.
• UsedTeradata utilities fast load, multiload, tpumpto load data
• Installed Tableau Server 7.0 in Dev, QA, UAT and Prod environments.
• Installed patches on the server and documented upgrade plan from tableau 8.0 to 8.1
• 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.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along with user acceptance test and data accuracy test..
• Access dashboards from any browser or tablet.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Use of Java script for creating the client side validations in the web pages with dashboards.
• Involved in license management SLA's with Tableau support.
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users
• Use of Java script for embedding the dashboards on the webpages.

Environment: s: TableauDesktop8.0/7.0,Tableauserver/Administrator,SQLdeveloper, SSIS,OLAP, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Teradata, Windows 2007 server, Microsoft office 2007

Confidential

Tableau Developer/Admin

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Implement infographics and Dash boarding for data visualization.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Experience in standardizing Tableau for shared service deployment.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• 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.
• Involved in license management SLA’s with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in converting OBIEE content into Tableau BI content.
• Experience in providing Tableau server and tableau desktop training.
• Experience with Teradata.
• Experienced with trouble shoot of Teradata connection.
• Testedreportsanduploadedtableaudashboardsontoserverandprovidedproductionsupportfortableau users.

Environment: s: Tableauserver/Administrator, Tableau Desktop v6/v7, Windows Server Standard R2, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL.

Confidential, Portland, Maine

Business Objects Developer

Responsibilities:

• Involved in functional requirements gathering meeting different Business Groups and preparing the Technical specifications.
• Involved in the designing and building of Universes from different data sources like Oracle/SQL Server.
• Linked Universes to share the Universes which had common dimension tables and the classes and objects.
• Generated reports using free-hand SQL as a data provider.
• Migrated Universes, Connections, Full Client / Web I Reports from the existing version 6.5 to XI 3.0 using Import Wizard.
• Created hierarchies to provide the drill down functionality to end-users.
• Involved in Writing Detailed Level Documentation for reports.
• Modified the existing reports by adding new columns based on the result set.
• Created template documents with header, footer and company logo.
• Converted full client report (.rep) to Web Intelligence (.wid) using Report Conversion Tool.
• Created Web I reports using Business Objects Web Intelligence and exported to the corporate documents.
• Exported the Business Objects reports to the repository so that the end users can view the reports through Web I.
• Tested the reports and modified the relevant Objects in the Universe as per the user specifications.
• Developed Desk I Reports using functionalities like cross tab, master detail, drill down, using filters, breaks, alerts and formulae.
• Created user response objects, user prompts in various Desk I Reports.
• Created Interactive Metric Trends (IMT) and score cards using Performance Manager according to the user requirements.
• Created reports to visually represent data using Crystal Xcelsius.

Confidential

Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Involved in the study of user requirements, analysis & review of designs and schema.
• Maintain/update current Business Objects end user reports.
• Create/develop special ad-hoc reports, database queries, status reports, etc. as requested using BOXI.
• Provide ad-hoc analysis and reporting to business units
• Created E-R schema by identifying entities and their related attributes.
• Worked on Erwin tool in created E-R diagrams.
• Designed and developed tables in MS Access Database
• System documentation, program specification and testing.
• Created tables, indexes, sequences and constraints
• Tested and documented the database created.

Environment: s: BOXIR2/6.5 Designer, Desktop Intelligence, Excel, Erwin, Web Intelligence, Import Wizard, CMC, CCM, Oracle 9i, Toad.