SUMMARY

• Over 6+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms
• Expertise in various domains like health care, banking, and retail
• Experience in Agile (Scrum, RUP) and Waterfall SDLC methodologies
• Extensive experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau
• Created Dashboards and Views using Tableau Desktop
• Created incremental refreshes for data sources on Tableau server
• Consistently delivered results in various stages of Software Development Life Cycle
• Experience working with MySQL, Teradata, Oracle, Informatica, SQL, XML, MS. Access, MS SQL server
• Experience in Tableau Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage
• Experience to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop
• Experience in recommending Dashboards as per Tableau visualization features and delivering reports to Business team on timely manner
• Good Knowledge of Tableau Server Concepts like tabcmd, tab admin, creating users, sites and projects
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships
• Excellent understanding of Data modeling on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), MS Access and client/server applications
• Experience working in Mac OS, Windows and UNIX environments
• Established Best Practices for Enterprise Tableau Environment and application intake and Development processes
• Identified Business and Data requirements and converting them into conceptual and logical data models
• Worked on onsite-offshore model
• Good Knowledge in data warehousing concepts and ETL concepts
• Experience working with ETL tool Informatica
• Experience in working with Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes
• Experience with designing and verifying databases on Oracle and SQL Server RDBMS using Entity-Relationship Diagrams
• Experience in writing complex SQL queries for several database activities
• Created triggers, stored procedures and complex queries
• Performed Extract, Transform and Load operations from the databases using Informatics tool
• Good analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement
• Excellent communication & collaboration skills, interest & ability to learn new technologies in short time background in Data warehousing concepts
• Detail-oriented problem solver, quick learner, and flexible team player

TECHNICAL SKILLS

Operating System: Mac OS, Windows, Linux

Reporting tools: Tableau

Database: Oracle, MS Access, My SQL, Teradata, MS SQL Server

Languages: SQL, HTML,CSS,XML

Tools: Informatica, TOAD, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

BI System Analyst

Responsibilities:

• Followed Agile methodology
• Analyzed business requirements, interacted with Project Manager and SMEs to understand the business Processes
• Worked with DBAs to design and implement Conceptual data model, Physical Data Model and workflows to meet business requirements
• Led a small team of Tableau report developers to guide them to create several reports
• Performed requirements analysis and documented the design specifications and development of the solution
• Analyzed raw data from multiple data sources and developed models to solve complex business problem
• Translated data analysis into concise, actionable business insights, often in collaboration with other teams
• Prepared data for dashboards using Oracle11g
• Used TableauDesktop for blending databases and creating different interactive views and dashboards
• Published customized interactive reports and dashboards, report scheduling using Tableau server
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements
• Developed complex SQL scripts to prepare the data for dashboards in the backend from various complex databases
• Created calculated fields as per business requirement and technical requirements
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau
• Developed complex dashboards using Tableau table calculations, quick filters, context filters, hierarchies, parameters and action filters
• Performed several analysis to increase the Tableau performance
• Created dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis
• Developed dashboards with URL and provided drill down feature to show different timelines for different projects
• Defined best practices for Tableau report development
• Published customized interactive reports and dashboards, report scheduling using Tableau server

Environment: Oracle 11g, SQL, Tableau Desktop 9.3, Tableau server 9.3, MySQL, SQL Server

Confidential, Palo Alto, CA

ETL Developer

Responsibilities:

• Analyzed business requirements and written technical specifications
• Interacted with the Business Analysts to analyze the Business Requirements and transform the business requirements into the technical requirements
• Extracted data from various heterogeneous sources like Oracle and Flat Files
• Developed database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling
• Developed complex Informatica mappings using Unconnected Lookup, Sorter, Aggregator and Router transformations for populating target table in efficient manner
• Developed complexETL mapping and its corresponding sessions & work lets, workflows
• Migrated Mappings, Sessions, and Workflows from Development to Test environment
• Identified, fixed the bottle necks and tuned the Mappings, Sessions for improving performance
• Tuned both ETL process as well as SQL procedures
• Worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache
• Worked with both Connected and Unconnected LookupTransformations
• Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated
• Performed ETL design, development, testing and review of code along with supporting documents like Unit test case and technical handover documents
• Monitored sessions and created batches to run the mappings
• Performed code review, testing and co-ordination with Testing team
• Scheduled and monitored automated weekly jobs under UNIX environment
• Involved in Production Support and resolved production issues
• Implemented critical change requests

Environment: Informatica, SQL, Oracle 11g, Windows, Mac OS and Linux operating system

Confidential, Houston, TX

Junior Tableau Developer

Responsibilities:

• Followed Agile SCRUM methodology
• Interacted with the Business Analysts to analyze the Business Requirements and transform the business requirements into the technical requirements
• Designed and developed of Tableau visualization solutions.
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Analyzed the customer data and extracted sets of data which can be useful in several reporting activities
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Created users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Prepared Dashboards using calculations, parameters in Tableau
• Analyzed relational database structures, theories, principles, and practices
• Executed tabadmin and tabcmd commands in creating backups and restoring backups of Tableau repository
• Worked on generating various dashboards in Tableau server using various sources such as Teradata
• Created graphs and tables visually exciting, while at the same time maintaining the accuracy of the core information content that is being communicated
• Involved in license management SLA’s with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Developed Dashboard and prepared ad-Hock Reporting

Environment: Tableau Desktop,Tableauserver / Administrator, SQL developer, SQL 2008, Oracle 11g, SQL,Microsoft Excel,MS Access, Windows 2007 server, Java 1.5 platform, Microsoft office 2007.

Confidential, Lumberton, NC

Tableau developer

Responsibilities:

• Followed Agile methodology
• Gathered user requirements, analyzed and designed software solution based on the requirements
• Managers and executives Developed, organized, managed and maintained graphs, tables, slides and document templates for the efficient creation of reports
• Interacted with diverse group of professionals in the organization including
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets
• Developed Standard Operating Procedures (SOP) for Monitoring
• Performed data blending and embed functionalities in Tableau
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine
• Created and published customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Worked with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies
• Created detail level summary report and Dashboard using KPI's
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau
• Created, customized& shared interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet
• Performed connection to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Created dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Created database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Created complex SQL views and wrote SQL queries

Environment: Tableau Server 7.0, Oracle SQL Developer, SQL Assistant, Oracle 11g, java 1.5 platform, Tera data, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.

Confidential

Tableau Report Developer

Responsibilities:

• Followed Waterfall SDLC methodology
• Developed Tableau dashboards according to user specifications
• Performed Data Blending techniques in dashboard development
• Performed Tableau server administrative functions, installation, configuration, back up of servers and load balancing techniques
• Configured security including user/ group setup, permissions, security roles, configuration of trusted ticket authentication
• Trouble shooter and resolving erroneous reports
• Created calculated fields as per business requirement
• Platform monitoring, availability, performance management, and service reporting (KPI)
• Setup new projects, security groups, roles and administer users for all supported platforms
• Administered user, user groups, and scheduled instances for reports in Tableau
• Monitored of Tableau Servers for its high availability to users
• Used Tabadmin and Tabcmd commands in creating and restoring backups of Tableaurepository
• Worked on Tableau Server upgrades for new versions
• Educated on Tableau Demo's to new on boarding users
• Developed worksheets and data visualization dashboards with graphs and filters
• Created report schedules on Tableau server
• Developed monthly reports and dashboards and perform query optimization
• Defined best practices for Tableau report development

Environment: Tableau Server, Tableau Desktop, Oracle, Excel, Windows, Java API.