PROFESSIONAL SUMMARY:

• Around 8 years of experience in IT industry as a Data Analyst, Business Analyst, and Data Modeler with extensive knowledge in functional and technical domain of Business Intelligence, ETL tools, creating reports, dashboards through Tableau, identifying trends and processing mapping with strong background in Databases and Data Warehousing concepts.
• 4+ years of designing, Tableau 9.2 to 6.1 developing and testing analytic and operational dashboards, Data Visualization, Tableau Server Visual Analytics, BI, Architecture and Management.
• Certified Tableau Desktop 9 Qualified Associate skilled in Tableau Desktop versions 9.2, 9.1, 8.2 and 8.1. for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Involved in full life cycle implementation, which includes Gap Analysis, Requirements Gathering, Development, Testing, Reporting, Go - live and Reconciliation.
• Experience in using Tableau functionalities for creating different Requests, Filters, Chart, Interactive dashboards with Page and dashboard Prompts.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 8.1.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Have been working with various data sources such as Oracle, SQL Server, Hadoop, ODBC and flat file sources.
• Ability to use custom SQL for complex data pulls.
• Extensive Knowledge on SSRS/SSIS and Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Experienced in developing rich interactive report, dashboards and other user interface elements integrating various reporting components from multiple sources.
• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
• Profound knowledge of Data modeling including Star Schema and Snow Flake Dimensional Data modeling, 3NF Normalized Data Modeling. Very good understanding of Logical Modeling and Fine-tuned Physical Data Modeling.
• Involved in creation of logical and physical data models using Erwin 4.1.
• Create a wide variety of analysis including comparisons, trending and what-if analysis.
• Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
• Created PowerPoint presentation for presenting to the seniors managers in the company for the tools developed by my team.
• Experience in documenting the testing process using MS-Office tools including MS-Word, MS-Excel, and MS-Project.
• Extensive experience in developing Unit, Integration and UAT Test plans and Cases and also has experience in generating/executing SQL Test Scripts and Test results.
• Experienced in managing, monitoring and investigating cases such as trouble tickets from customers and fixing the issues.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 9.2, 9.1, 9.0/ 8.X/7.X/6.X, Tableau Server, Tableau Reader,, SSRS

ETL: Informatica, DataStage, SSIS

Operating systems: Windows, Windows Server, UNIX, Linux

RDBMS: Oracle, SQL Server, Teradata, Big data, Netezza, MS Access

Languages: SQL, PL/SQL, HTML, C, JAVA, VBA, Python, C#

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Power Designer, Erwin

Methodologies: Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

ETL Developer/Sr. Tableau Developer

Responsibilities:

• Worked in the agile methodology-using Scrum, which has its primary focus on the management part of the software development in small iterations of weekly sprints.
• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to buildTableauDashboards and managing the delivery.
• Involved in generating reports from excel database forTableauDashboard.
• Designed and developedTableauvisualizations which include preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Provide future forecast analysis and identify past trends for different investments and market segments.
• Developed different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Performed data visualizations using Tree Maps, Bubble Charts, Pie Charts usingJavaScriptAPI& parameterized controls usingTableauto highlight the value added analytics in executive decision support control.
• Worked on generating various dashboards inTableauServer using different data sources such as Microsoft SQL Server and Microsoft Analysis Services.
• Developed different views usingTableauDesktop that were published in Tableau Server to the business stake holders for analysis and customization using filters and actions.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableaudesktop.
• Worked in extracting transforming and loading (ETL) data across multiple databases such as BOM tool, Service Catalog, HPNA and Filemaker into MS SQL Server using SSIS packages.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• UsingTableauDesktop 9.2, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Efficient at using Parameter in calculation field to give flexibility to end user.
• Created global filter for the dashboard that uses different data source.
• Skillfully created different kinds of actions for navigation and drill down.
• Created custom color pallet, custom shapes to use in dashboard.
• Defined best practices forTableaureport development.

Environment: Tableau 9.2/ 9.1, Tableau Server, SSIS, SSRS Oracle, MS SQL Server, Hadoop, SQL, PL-SQL, TSQL, MS Office Suite.

Confidential, Chicago, IL

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

• Reported directly to the Senior Manager for EDW and Business Reporting.
• Designed and perfected the reporting requirement documents and the tracker logs to track and assign the work packets until they get completed /resolved.
• Created Schedules and Extracted the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Extensively used Analysis Tab in Tableau 9 to quickly select a number of common analysis functions like Reference Lines, Averages, Medians, Trend Lines and Forecast models.
• Effectively used data blending, filters, actions, and Hierarchies feature in Tableau 9.
• Provide future forecast analysis and identify past trends for different investments and market segments.
• Scheduled cron jobs on UNIX platform using crontab format.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Usage of Quick Table calculations to compare quarterly trend and sales.
• 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.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that 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.
• Converted Metric insight reports to tableau reports.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Involved in Creating the Schema objects i.e. Attributes, Facts, Hierarchies and Transformations.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.

Environment: Tableau 9.0/ 8.0/7.1, Tableau Server, Oracle, Teradata & Netezza, Hadoop, SQL, PL-SQL, TSQL, SQL Server 2008, MS Office Suite, UNIX.

Confidential, Englewood, CO

Tableau Developer / Data Analyst

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed various reports, dashboards, scorecards in MicroStrategy and created the same usingTableaudesktop server.
• Mentored business power users to create reports/dashboards usingtableaudesktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet inTableau Desktop
• Utilized advance features ofTableausoftware like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• 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 fortableaureporting.
• Identify new metrics and enhance the existing KPI's.
• Created dashboard visualization throughTableauBI application
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
• Effectively used data blending, filters, actions, and Hierarchies feature in tableau
• Defined best practices forTableaureport development.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Executed and tested required queries and reports before publishing
• Converted metric insight reports totableaureports
• Working extensively withTableauBusiness Intelligence tool to develop various dashboards.
• Working extensively using Excel to validate the data and use as the source data files
• Analyzing the data using Statistical features inTableauto develop trend analysis.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server
• Design and development of various reports and dashboards that can be easily accessible throughTableauApp in iPads, iPhones, and other smart mobile phones

Environment: Tableau 7.0/6.1, Tableau Server 7.0, Oracle 10g, Oracle SQL Developer, SQL, Share Point, Agile-Scrum, Rally, Asp.Net, JavaScript.

Confidential, Denver, CO

Tableau Developer/Data Analyst

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Sending the dashboards to users by emails with the help of admin team with subscriptions.
• Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.
• Given training/demos to users on Tableau Desktop for development.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Administered user groups and scheduled instances for reports in tableau.
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, UNIX, Toad, MS Office, Visual Studio 2010.

Confidential, San Diego, CA

Data Analyst

Responsibilities:

• Played a key role in gathering and documenting Business requirements and conducted requirement walk-through meetings with key stakeholders.
• Participated in technical walk-through meetings to develop the functional design for the implementation.
• Performed detailed requirement analysis and created data mapping documents.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Designed the conceptual data and business process models.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Make use of data modeling techniques in designing the data marts project.
• Extensively involved in Data mapping and Data modeling.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Created views and extracted data from Teradata base tables and uploaded data to oracle staging server from Teradata tables, using fast export concept.
• Managing metadata by mapping dimensions and fact tables of various schemas/data models
• Generated reports like subject area reports, entity relationship diagrams, attribute reports, table reports, column reports, indexing reports, relationship reports.
• Perform application testing e.g. of loading, reporting interfaces to BDW to verify all systems are in place and operational and the data restored is correct.
• Conducted JAD sessions, design discussions and SOS meetings to come out with the appropriate data mart.
• Created test cases for carrying out unit testing and part of functional testing.
• Used MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.

Environment:Erwin, ER/ Studio, Oracle, SQL Plus/ PLSQL, Toad, SQL Developer, SQL, MS Office (Word, PowerPoint, Access, Excel, Visio).

Confidential

SQL Developer

Responsibilities:

• Analyzing excel data and creating data model for the application.
• Involved in the development, testing and the deployment phase.
• Managed a team of 5 members for the development of the project assigned to my team. Used the Waterfall model software development model for the project.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system.
• Created unit test plans to unit test the code prior to the handover process to QA.
• Involved in troubleshooting the production issues and providing production support.
• Involved heavily in writing complex SQL queries based on the given requirements.
• Created new tables and designed the databases. Created new indexes on tables to fasten the database.
• Project life cycle maintenance using ALM tool to track the progress.
• Wrote many Ad-Hoc queries daily to get the data needed by the Management.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.

Environment: SQL Server 2000, SQL Server 2005, Import& Export Data, ER-Win, T-SQL, Excel, Access and Windows 2003, ALM, SSRS.