SUMMARY

• 8 years of experience in Tableau developer.
• Industry experience includes Information Technology, Health Care, Insurance
• Engineering degree holder and Certified in Project Management
• Expertise in Report Authoring, SQL querying, Testing, Business Requirements & Data Analysis
• Implemented full life cycle implementations starting from Requirement gathering stage to Production.
• BI Reporting Professional - Web Intelligence/Xcelsius/Universe Designer/Tableau with proven experience in gathering report requirements and analyzing business processes.
• Extensively used SQL for report optimization and strong knowledge of layered architecture in BI.
• Proven ability to communicate project approaches, goals and objectives to business and technical stakeholders.
• Designed reports compatible for Mobile Devices using WebI and Tableau.
• Strong knowledge in DW concepts like data modeling, Info providers, Star Schema, Snow Flake, Fact Constellation, Dimension and Fact tables.
• Outstanding knowledge in writing and analyzing complex SQL queries, database tuning, query optimization and resolving key performance issues.
• Experience in creating Customized and Adhoc reports using Business Objects tools and Tableau.
• Analyzed metrics and generated reports that were used by executive management to make decisions.
• Strong knowledge and experience on Agile Project Management, and process improvement workflows.
• Strong knowledge on defect tracking tools like JIRA, ALM.

TECHNICAL SKILLS

BI: SAP BO 3.1,4.0,4.1, Tableau 9.3

SAP Tools: SAP data warehousing, SAP Business Objects, Web Intelligence Rich Client (WEBI), Info View, Xcelsius, OLAP, OLTP, BODS

Reporting Tools: SAP Business Objects4.1, 4.0, 3.1, Xcelsius, Design studio, Web Intelligence, Tableau 8.3

Databases: Oracle 11.2/10g/9i/8i/8.0/7.x, MS SQL Server 2005/2000, SQL Loader, SQL*Plus, Teradata and oracle DBMS Packages, MS-Access, XML.

Environment: MS Windows 95 - 2000, MS- Windows NT/XP

PROFESSIONAL EXPERIENCE

Confidential - Los Angeles, CA

Tableau Consultant

Responsibilities:

• Gather business user requirements, analyze the data and designed software solutions in Tableau Desktop based on the requirements.
• Primary responsibility was to put data into Tableau understanding needs and reverse engineering existing BO reports, focused on understand the business problem and providing solutions in Tableau.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server.
• Worked generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle and MS Excel.
• Responsible for upgrading the Tableau 8.x to Tableau 9.x.
• Effectively used data blending, sets, groups, filters, parameters, actions, and Hierarchies in Tableau.
• Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting to live and extract datasets.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Intelligent Drop down list for the parameters has been developed using ASP .NET.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Responsible for creating /delivering monthly reports to business users.

Environment: Oracle 11g, R 3.1.3, Tableau Desktop and server 8.x/9.x, Toad, MS SQL Server 2012, Business Objects, Teradata, ASP.NET,T-SQL, TFS, Windows Server 2012, MS Office 2007.

Confidential - Kansas City, MO

Tableau Developer

Responsibilities:

• Delivered BI projects to enable analytics for Healthcare administration in hospitals that improved operation efficiency by 30%
• Advocated Tableau best practices to ensure optimal usage of tool’s capabilities to deliver efficient visualizations
• Resolved technical issues in Tableau faced by the team, that ensured on-time project delivery
• Developed tableau reports to examine its technical feasibility. Features demonstrated in these reports like motion charts, dual axis chart, line charts, bar charts resulted in a new project initiation
• Prepared team work plan, tracked and presented status to senior leadership to ensure progress
• Worked with business users in decision making on selection of hand-held devices based on end user usability, compatibility with Tableau and Tools supported.
• Experienced in development and design of reports and dashboards for supporting the business analysis using Business Objects 4.0- WebI, Xcelsius, and Tableau.
• Designed Universe using IDT tool on SQL database.
• Resolved BO Universe problems like Loops, chasm trap, fan trap using Alias and context.
• Extensively worked on WebI Report functionality like Variables, Breaks, Filters, Open Document, Sorts and Query Prompt
• Created Dashboards reports based on different data source such as Excel, SQL Server and Oracle that helps users with unique business information.
• Extensive experience in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Action filters, Calculated fields like YTD, MTD, Sets, Groups, Parameters etc., in Tableau.
• Install upgrade Tableau server and server performance tuning for optimization.
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access to the Data.
• Designed Reports compatible for Mobile Devices using WebI and Tableau.
• Scheduling various reports for daily, weekly and monthly runs.
• Involved in validating reports by validating numbers against data by querying to the data base.
• Worked on different defect tracking tools like JIRA and ALM
• Worked on versioning tools like Tortoise SVN

Environment: Tableau Desktop/Server 9.3, Business Objects XI 4.1, 4.0, Xcelsius,ASP.NET, WebI, SQL Server 2008

Confidential, Falls Church, VA

Tableau Developer

Responsibilities:

• Provided BI solutions to help clients make decisions on sales data, speed risk assessment and automate underwriting decisions
• Developed visualizations using Tableau and made enhancements to the existing Tableau reports.
• Designed impressive Tableau reporting solutions according to user specifications to bring meaning to the data and solve complex business.
• Developed visualizations using tableau for several insurance clients to track different metrics and KPIs
• Validated reports for data accuracy against initial requirements and interacted with clients for requirement clarifications.
• Worked with data integration team (ETL) team to complete project deliverables
• Clearly translate business and functional specifications into detail technical specification.
• Maintain and optimize universe using SQL queries, query stripping.
• Wrote optimized SQL queries to access source data from RDBMS, and provided reports according to the requirements.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Used advanced mapping techniques, Aggregate Calculations, Duplicate Data connections, swapping dimensions with parameters in Tableau workbooks and dashboard development.
• Developed multiple Views and combined them into Dashboards for interactivity by providing Quick Filter and Parameters for further data drilling capability.

Environment: Tableau Desktop/Server v9.3, SAP Business Objects XI 4.0, ASP.NET,Xcelsius, WebI, MS Excel, SQL Server 2005

Confidential, Falls Church, VA

Tableau Developer

Responsibilities:

• Worked with Business Analysts and End users to analyze reporting requirements
• Developed reports to migrate existing Cognos reports into BO reports
• Developed several detail and summary reports including bar charts, pie charts and sub reports using SAP BO
• Tested reports by running SQL queries and matching the report generated data with SQL queried to the database
• Devised application test cases and coordinated with business users to perform solution validation
• Created, modified, enhanced, deployed and maintained Universes using Universe designer, to include objects like dimensions, details and measures as per the user requirements.
• Resolved universe loops by creating Aliases and Contexts and checked the integrity of the universe.
• Used derived tables and @Prompt in Derived Tables in developing universes.
• Worked extensively with major functionality of BO like Breaks, ranks, alerters, variables, formulas, filters, sorts, query prompts and drill filters.
• Developed hierarchies to support drill down reports.
• Created hyperlink reports for users to navigate from parent report to child report, as per business requirement.
• Retrieved data from multiple data providers like universe and personal data files.
• Performed some admin activities like BO scheduling of reports, managing user profiles and setting rights through CMC.

Confidential, Falls Church, VA

Tableau Developer

Responsibilities:

• Administered user security on BO platform including select privileges and visibility for power users
• Worked on change requests and defect fixes tracked using JIRA
• Analyzed and documented functional requirements by working with various business groups
• Analysis of the requirement given by the client. Clearing out any doubts on the universe structure And report format and logic.
• Designing the universe. Solving universe related issues like fan and chasm traps, creating alias tables, contexts.
• Creating reports based on the universe using Webi, Dashboards.
• Testing the reports by running SQL queries.
• Creating test plans and test cases based on different scenarios after analyzing the business requirement.