PROFESSIONAL SUMMARY:

• 8+ Years of experience in Tableau Solutions Consultant with BI experience.
• Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams.
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms
• Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
• Proficient in working with various data sources such as Oracle, SQL Server, ODBC and flat file sources.
• Excellent Trouble Shooting skills, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Extensive experience in Installation, Configuration and administration of Tableau Server in a multi - server and multi-tier environment.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Knowledge of deploying and scheduling Reports using SSRS to generate daily, weekly, monthly and quarterly Reports.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Experienced in Business Intelligence (SSIS, SSRS), Data Warehousing and Dashboards.
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Extensive working experience in 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.
• Experienced with migrating SSRS Reports to Performance Point server 2007 and publishing them on to SharePoint.
• Expertise in using Version controllers like TFS, Visual SourceSafe and Clear Case.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

SPECIALTIES: Data Visualization, Business Intelligence (BI), Software Management and Data Collection.

BI TOOLS: Tableau 7.0,Tableau 8.0/8.1,OBIEE 10g,11g,SSRS

RELATIONALDATABASES: MS SQL Server 2005/2008/2012, Oracle 8i/9i/10g/11g Sybase 6, 7, 8, 9, MS Access.

TOOLS: AND PACKAGES: SQL Server Management studio, Toad, Profiler, Microsoft Visual StudioLANGUAGES: SQL, PL/SQL, C, C#, ASP.Net, HTML, XML, XSL

OPERATING SYSTEMS: Windows 2000/2003, 2008 Server, Windows 95/98/2000/XP, UNIX, LINUX.

PROFESSIONAL EXPERIENCE:

Confidential, BERLIN, CT

TABLEAU DEVELOPER

RESPONSIBILITIES:

• Built Test Scripts and Training modules for end users
• Developed reports using custom SQL queries and created .tdsx, .tde and .tds files.
• Created reports and filtered them by various measures and dimensions.
• Blended data from multiple databases into one report.
• Worked on Microstrategy Visual Insight to prepare Ad-hoc reporting within Microstrategy.
• Used Java Script API to customize the views, selects, filters, date and time.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Extensive experience and expertise in OBIEE 10g/11g/12c, which include designing, building and configuring repository, creating and managing OBIEE Intelligent Dashboards, Answers, Delivers and BI Publisher.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.

ENVIRONMENT:: Tableau Desktop V7/V8, Tableau Server, OBIEE, Microstrategy, Java Script, SQLQueries, .tdsx, .tde and .tds files, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential, TAMPA, FL

TABLEAU DEVELOPER

RESPONSIBILITIES:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Experience in OBIEE Installation, configuration, patching, backup and restore.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

ENVIRONMENT: Tableau Desktop V6/V7, Tableau Server, Java Script, OBIEE, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential, NJ

TABLEAU DEVELOPER

RESPONSIBILITIES:

• Delivered Proof of Concepts (POC) presentation and review with project and IT lead along with developing Tableau Dashboards.
• Recommended OS configuration for installing Win Server 2012 R2, Tableau Server, and MS SQL Server 2012 R2.
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations as per requested by CEO and CFO of a $600M firm.
• Adjusted views/dashboards after initial POC presentation to CEO and CFO.
• Brainstormed ideas on what to include in views/dashboards from the data source and document on the fly business requirements.
• Created views and dashboards on end client's sales data. Produce powerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily by CEO and CFO.
• Cleansed and normalized data in MS Excel by combining from various data sources.
• Performed Tableau Server admin duties; added users/groups from Active Directory; and scheduled instances in Tableau Server including weekly data dump.
• Trained end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters, and date functions.

ENVIRONMENT: Tableau Desktop V6/V7, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel, Win Server 2012 R2, Active Directory

Confidential, BARTLESVILLE, OK

SQL SERVER DEVELOPER

RESPONSIBILITIES:

• Involved in planning, defining and designing data and provided documentation.
• Upgraded MS SQL Server 2005 to 2008 using detach/attach, backup and recovery and by replication.
• Used SSIS Import/Export Wizard, for performing the ETL operations.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Performed T- SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 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 using SSRS that 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.
• 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.

Confidential

SOFTWARE DEVELOPER

RESPONSIBILITIES:

• Retrieve data from multiple databases, Transform data as per client request, Load data into reporting client UI, SSRS or load to database.
• Used SQL and T- SQL for Microsoft databases.
• SSRS (SQL Server Reporting Services)Wrote scripts in T SQL and SQL to generate reports
• Included setting up reports for export to excel, access as ad-hoc reports for clients.
• SSIS (SQL Server Integration Services) Migrated DTS packages to SSIS, created new packages as needed.
• Designed SSRS applications that had to meet clients' requests.
• Worked with clients as an analyst for custom UI, data filters and requirements.
• Wrote background code in SQL, PL/ SQL and T- SQL .
• Interface retrieved data from Agency Metering System (AMS), Agency Load Forecast (ALF), and Market Prices web service for IAM application.
• Part of the nMarket support team used by the trading floor to monitor CALISO market.

ENVIRONMENT: SQL, T- SQL, SSRS, SSIS