SUMMARY

• Senior Tableau Developer with 7+ years of IT experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence Reporting using Tableau v9.x/8.x/7.x.
• Extensive experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and dashboards
• Hands on experience using Qlik v11.x/10.x.
• Strong knowledge in Agile/ Scrum methodologies.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management i.e., Connections, Data Model and VizQL Model.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XML, HTML, andDHTML.

TECHNICAL SKILLS

Reporting Tools: Tableau 9x/8x/7x, SAS, OBIEE 10.1.3x/11g,Qlik v11.x/10.x

Data Modeling Tools: Star Schema Modeling, Snow Flake Modeling, TOAD, SQL Developer, SQL Plus

Data Warehousing ETL Tools: Informatica Power Center 8.X, 7.X, Talend 4x/5x

Databases: Oracle 11g/10g/9i, My SQL, MS SQL

Languages: PL/SQL, SQL, Unix shell scripting, C

Web Tools: HTML, DHTML, XML, JavaScript

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

PROFESSIONAL EXPERIENCE

Confidential, Austin

Sr. Tableau Developer

Responsibilities:

• Gathering user requirements, analyzing, designing and efforts estimations
• Building executive, adhoc, and custom dashboards and publishing toTableauserver.
• Testing, Monitoring performances, cleaning unused dashboards
• Created best practices, publishing checklists and repository backups etc.,
• Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableauas needed
• Effectively used data blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Experience in creating sets, joins, hierarchies, filters, global filters, quick filters, context filters, table calculations, calculated measures and parameters.
• Extensively involved in developing the java code - using HTML, JSP for the front-end screen development.

Environment: s:TableauDesktop 8x upgrade to 9x,TableauServer,Oracle 10g, MS Excel.

Confidential, Peoria

Tableau Developer

Responsibilities:

• Participated in the daily stand up SCRUM agile meetings as part of AGILE process for reporting the day-to-day developments of the work done.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Effectively used data blending feature intableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized usingTableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Provided support for Tableau developed objects and understand tool administration.
• Worked inTableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Created Work books and dashboards for analyzing statistical billing data using Tableau8.0.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.

Environment: Tableau8.1/8.0,TableauServer,Oracle,Microsoft SQL Server, Microsoft Office, Microsoft Visio, Windows 7, Custom SQL.

Confidential, San Mateo

Qlikview Developer

Responsibilities:

• Developed different dashboards with a complex database system behind it, which includes extracting data from the database, storing into QVD files, write load scripts, and develop UI according to user requirements.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts, and Bookmarks.
• Worked onlarge scale and data volume based applications.
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions.
• Implemented Incremental Load, Optimized Load & Binary Loads for performance tuning and for optimized reports.
• Experience in Using QlikView Functions (Date and Time, Keep, Join, Mapping, String & input Fields etc.).
• Developed User Interactive Sheets & Reports as business needs.
• Developed QlikView Dashboards using Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar & Date.
• Worked on writing complex SQL Scripts to load Data in QlikView Applications.
• Developed Macros, SET ANALYSIS to provide custom functionality in QlikView Applications.

Environment: Qlikview 10.x SQL SERVER 2008, Oracle 10g, CSV, XML and Excel files.

Confidential, San Mateo

Qlikview Developer

Responsibilities:

• Created and managed ETL script generation using QlikView Script Builder Application.
• Automated and scheduled daily/weekly/monthly data loads of QVW documents using QlikView Publisher and notified by email to the operators if anything went wrong.
• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Interacted with end-users to collect requirements and acquire the necessary domain knowledge to become a subject matter expert. Trained and provided support to end-users.
• Performed analysis, documentation, for calculation for various attributes.
• 3 Executive Dashboards depicting Sales and Inventory data were created during the stint. Dealt with a data volumes ranging from 20 to 50 million records.
• Worked on Qlikview Server and Publisher, to manage user access, schedule refreshing of documents, mount completed applications.
• Created PDF push reports and setup email distribution on QlikView Publisher 9.
• Reviewed QlikView error logs and provided production support.
• Performance tuning of dashboards was carried out to limit the response time to well under 5 seconds.
• Calculation and defining server sizing for optimal performance of QlikView dashboards.
• Provided support analyst when internal teams have enquiries.
• Write batch scripts in VBS to automate tasks.
• Research and troubleshoot technical problems.
• Trained end users

Environment: Qlikview 9.x, upgrade to 10.x, SQL Server 2008, Excel files, flat files.

Confidential

Business Analyst/ Data Modeler

Responsibilities:

• Involvedwith Business Analysts team in requirements gathering and based on provided business requirements, defined detailed Technical specification documents.
• Translated business needs into data modeling initiatives.
• Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
• Served as point of contact to address customer concerns
• Communicated hard to deliver issues with the customer and made the necessary changes
• Performed the data source mapping.
• Utilized Power Designer’s forward/reverse engineering tools and target database schema conversion process.
• Documented logical, physical, relational and dimensional data models. Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Review the data model with functional and technical team.
• Worked on the reporting requirements and involved in generating the reports for the Data Model.
• Assist developers,ETL, BI team and end users to understand the data model.

Environment: Power Designer,Informatica PowerCenter 8.1.1/8.0/7.1 , Oracle 10g, Teradata, Putty,TOADUNIX.