SUMMARY:

• 8+ years of expert involvement in Business Intelligence, Software Design, Modeling, Development and Implementation in Information technology with abilities in all periods of Data Warehouse life cycle improvement, utilizing Tableau Desktop, Tableau Server, SQL Server, MySQL, PL/SQL Oracle, Teradata.
• 4+ years of Experience in building visualizations and Dashboards using the suite of Tableau Software Tools like Tableau Desktop, Server, Public and Online in various versions of Tableau 9.0,8.0, 7.0, 6.0.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization to represent different datasets.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Good understanding of Data Modeling techniques employing Normalization and Data Warehouse concepts using Star schema and Snow flake schema modeling, Fact and Dimensions tables, Physical and Logical Data Modeling. Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Expertise in Tableau Filters and actions to perform advance analysis using Highlight, URL to switch between sheets and cross-site.
• Great experience in performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Created incremental refreshes for data sources on Tableau server.
• Creating users, groups, projects, Data connections, settings as a Tableau administrator.
• Extensive experience in PL/SQL and SQL, performance tuning of databases.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating database tables, constraints,indexes.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau.
• Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers.
• Appropriate at writing Data Mapping Documents, Data Transformation Rules and Data dictionary maintenance.
• Good Communication and interpersonal skills.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

Data Modeling Tools: Star Schema Modeling, Snow Flake Modeling

Data Warehousing ETL Tools: Informatica Power Center 8 .X,7.X, Data Cleaner 2.2

Databases: Oracle 11g/10g/9i, MySQL,SQL Server, Teradata

Database Tools: TOAD, SQL Developer, SQL Plus

Reporting Tools: Tableau 9.0/8.3/8.2/8.1/8.0/7.0, SSRS, QlikView

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

Web Tools: HTML, DHTML, XML, JAVA SCRIPT

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

Others: MS Word, Excel, VISIO 2007

PROFESSIONAL EXPERIENCE:

Confidential,St.Louis,MO

Sr. Tableau Developer

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality and publishing them to tableau server and tableau Online.
• Created report schedules on Tableau server and Tableau Online.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Created and assisted users in Tableau dashboard development.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Manage the application’s users, groups, and integration with Active Directory.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Integration of Tableau reports with Asp.Net web applications and usage of JavaScript API for performance improvement.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Involved in testing the Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau Desktop 8.2, Tableau Server, Tableau Online. Oracle 11g, MS Office Suite, Oracle SQL Server R2, MS Excel, Java Script API, Asp.Net VB.

Confidential, St Louis,MO

Tableau Developer

• 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.
• Expert in infographics and Dashboarding 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.
• Extensively used TabAdmin and TabCMD commands in creating backups and restoring backups of Tableau repository.
• 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.

Environment: : Tableau Server v6/v7, Tableau Desktop v6/v7, Windows Server Standard R2, Clearquest, Clearcase, Oracle 11i, Sybase, OBIEE, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.4.

Confidential,Austin, TX

Tableau Developer

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Analyzed the source systems and created Business Requirement Document (BRD).
• Deep experience with the design and development of Tableau visualization solutions.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Configured different data sources using Tableau Desktop
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Performed tableau data blending for multiple data sources.
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for the data sources.
• Configured AD security using tableau server.
• Responsible for authorizing the users based on their privileges.
• Involved in migration activities related to Tableau across the environments.
• Prepared BI Interactive Dashboards using calculations, parameters in Tableau.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Desktop, Tableau server, TabCMD, SQL developer, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server,, Microsoft office 2007, Quality Center

Confidential, Dallas, TX

SQL/Report Developer

• Involved in planning, defining and designing data and provided documentation.
• Upgraded MS SQLServer 2005 to 2008using detach/attach, backup and recovery and by replication.
• Used SSISImport/Export Wizard, for performing the ETL operations.
• Created alerts, notifications, and emails for scheduledSSISpackages execution.
• Performed T-SQLtuning and optimization of queries for reports that take longer execution time using MSSQLProfiler, index tuning wizard andSQLQuery Analyzer in MS SQLServer 2008r2.
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers.
• Designed a star schema for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS.
• Generated reports usingSSRSthat could be used to send information to different Primary vendors, clients and managers.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating Indexes.
• Used the HTML code to make the report manager more functional and customizable.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Tracking the life cycle of project using HP ALM
• Troubleshoot and fixed issues in existing cubes in SSAS.
• Designed a new schema for the data mart databases.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

ENVIRONMENT: MS SQL Server 2008r2, T-SQL, SSRS 2008r2, Visual Studio 2008r2, Erwin 8.0, HP ALM

Confidential

SQL Server Developer

• Oversaw installations, upgrades of SQL 2005 to SQL 2008.
• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Used data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.
• Recovered the backups of SQL Server production databases in test server environment.
• Refactored poorly performing SQL queries to improve application performance.
• Monitoring MS SQL Server performance and network issues.
• Coordinating with peer groups for Network, Infrastructure and Data center Operations.
• Performance monitoring and tuning of SQL servers.
• Used SSIS to load data from multiple SQL Server sources to a denormalized set of tables for analysis.
• Built SSRS report to support reporting needs.

Environment: MS SQL Server 2005/2008, Windows 2000 Advanced Server,XML, Microsoft Suite (Excel, Word, and Visio), Quality Center, and SSRS