SUMMARY

• Over 7+ years of experience in IT industry with a strong background in Analysis, Design and Development in the field of Database and implementation of Business Intelligence applications. Extensive experience in Software Development Lifecycle (SDLC) managing project scope, requirement definition, resource management, change management, analysis, managing work schedules, project status reporting, project coordination and conflict resolution.
• Extensive experience working with Tableau Software as a dashboard developer, and SMEand SQL Developer.
• Extensive Tableau experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience working on trend reports, service provider functionality, sample assessment, online business intelligence, fleet management systems and capital markets.
• Extensive experience working in Enterprise Wide Applications.
• Extensive experience creating canned and ad - hoc reports in Tableau Desktop.
• Experience training end users through online and in-class sessions.
• Extensive experience interacting with Department Managers and different levels of users and developers.
• Experience in MS PowerPoint presentations for end users and in MS Access and MS Excel.
• Ability to communicate business and technical issues to both business users and technical users.
• In-depth knowledge on Tableau Desktop, Tableau Viewer and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau
• Professional in writing complexFormulas,Sub Reports,Summary Reports,Cross-Tabsin DESKI & WEBI against Universe and Relational data sources.
• Extensive working experience inPackages, Procedures, Cursors, Triggers and UNIX Scripting.
• Experienced in tuning long running SQL queries for better performance.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Extensive experience working in Windows, UNIX, LINUX environments.
• Expertise in using Version controllers likeClear Quest,Clear CaseandSubversion.
• Excellent ability to work independently and as a part of a multi-functional, geographically diverse team.
• Excellent communication skills, strongteam-building and conflict management skills. Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008 across various environments.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Expert in generating drill down Reports in SSRS 2005/2008

TECHNICAL SKILLS

ETL Tools: Informatica 7x, Tableau Desktop 6.0, 7.0, 8.0

Scripting Languages: SQL, PL/SQL, T-SQL

Database: MS Access, Oracle 9i, MS SQL Server

BI Tools: Tableau BI Products, SSIS, SSRS

Servers: Application Servers (WAS, Tomcat), Webservers (IIS, HIS, Apache).

Data Modeling: Erwin, Visio 2003

Reporting Tools: SSRS, Business Objects 6x, Tableau

OLAP Tools: SSAS

PROFESSIONAL EXPERIENCE

Confidential, Dallas-TX

Tableau / BI Developer

Environment: Tableau Software 7.0, 8.0, Microsoft office, SQL Server

Responsibilities:

• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
• Using Tableau Desktop, 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
• Provided BSC to the management analyzing KPI from Financial, Customer, Internal process and Training perspective for the East zone.
• Embedded live Tableau dashboards on PowerPoint presentations, keeping the slides always updated
• Delivered dashboards tracking viewership, HUT and Advertising sales for a Media channel.
• Created dashboards for System Services Company to measure performance of their field engineers and manufacturer defects.
• Setup stand alone and distributed Tableau Server to publish and distribute dashboards easily
• Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.

Confidential, Irving, TX

Tableau Developer/ Tableau Admin

Environment: s: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008, Oracle 11i, Netezza, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat. TSQL, UNIX, Linux RHEL 5.4.

Responsibilities:

• Involved in creating dashboards and reports in Tableau 6.1.
• Created report schedules on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Worked as technical architect in developing strategy, architecture, and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Tableau application consisting of multiple key functional business domains.
• Documented complete server administration and solutions to troubleshoot performance, scheduling, and server related issues.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used TabadminandTabcmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7-production support for Tableau users.

Confidential, Augusta, ME

MS SQL Developer/SSIS/SSRS

Environment: T-SQL, PL/SQL, MS SQL Server 2000/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports, Oracle 9i, VBScript.

Responsibilities:

• Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.
• Involved in business requirement gathering and created functional/technical specification documents.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Designed data models using Erwin and Created new tables, written stored procedures, triggers for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Developed Web forms using ASP.NET using C#
• Developed application logic using C#
• Used N-tier architecture for presentation layer, the business and data Access layers and were coded using C#.
• Involved in performing data conversions from flat files into a normalized database structure.
• Developed functions, views and triggers for automation.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Provided disaster recovery procedures and policies for backup and recovery of Databases.
• Scheduled Cube Processing from staging Database tables using SQL server Agent.
• Wrote MDX queries and expressions for use in front end BI applications.
• Created KPI objects in line with requirement Docs.
• Optimized Cubes for better query performance..
• Created reports by extracted data form OLAP Cubes.
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS). Developed Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
• Defined report layouts for formatting the report design as per the need.
• Wrote queries for drill down reports to get the dataset required to build the report.
• Identified and included report parameters for parameterized report.
• Formatted the reports using Global variables and expressions.
• Deployed generated reports onto the Report Server to access it through browser.
• Maintained data integrity by performing validation checks.
• Optimized queries, tuned and monitored server performance
• Installing SQL Server Client side utilities and tools for all the front-end developers/programmers
• Involved in performance tuning to optimize SQL queries using query analyzer.

Confidential, Pontiac, MI

SQL Server Developer

Environment: MS SQL Server 2000/2005, SQL Server 2005 Analysis Services (SSAS), Reporting Services (SSRS 2000/2005, Microsoft Visual Studio 2005, BIDS, Visual SourceSafe, MSOffice, HTML, VBScript, Erwin and Visio.

Responsibilities:

• Gathered requirements from users and business analysts and created requirement documents.
• Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems into the databases for Dashboard Reporting on a daily basis
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various revenue modules
• Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
• Expert in SQL joins, sub queries, tracing,usage of Table Variables, Temp tablesetc.
• Experience in Event Logging, error handling& logging Log files, File and File Groups, Security, Backup and Recovery
• Worked on SSRS 2005/2000 to generate about 30+ reports for various user groups and developer groups.
• Created stored procedures to use as the datasets for the Report Design.
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver the reports
• Extensively worked on Report coding to behave according to the front end CRM Application.
• Configured Subscriptions and Security for all critical reports.
• Handled the database components (Code migration, Change control) for application releases.
• Creates technical specifications, test plans and test data to support ETL processes
• Experience with Data migration utilities (Import & Export - BCP,Bulk Insert) from text to SQL Server.
• Involved in Database Administration activities like Back up, Security, Migrations in the Development servers.