PROFESSIONAL SUMMARY:

• Over 7 Years of Experience in Software Design, Database Design, Development, Testing, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Good experience on Advance Excel, SQL, Tableau Business Intelligence reporting tool for developing dynamic reports.
• Extensively worked on Tableau 8.x/9.x/10.x (Desktop, Server, Reader, Mobile and Public).
• Extensive knowledge of tableau architecture and Dimensional Modeling experience.
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server.
• Extensively worked on databases like Oracle, SQL Server, and DB2.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau Dashboards.
• Strong knowledge of Extraction, Transformation and Loading (ETL) processes using Data Stage ETL Tool.
• Hands on Experience in Design of ETL jobs as per the technical requirement and source to target mapping.
• Proficient in Oracle Database and UNIX Shell Scripting.
• Experience in UNIX environment to work with scripts and running the jobs using commands.
• Experience handling data to design & develop models that depict business KPI trends/variations or behavior in the customer base.
• Experience in visualizing and creating high - level models used for analyzing, extending, and maturing business architecture.
• Good Hands-on skills with use of action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Donut Chart, Map Charts, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization, Spot Lighting and Multi Conditional Score Card other making use of actions, other different filters and Parameters according to the end user requirement.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geo and custom geo maps and other making use of actions, local and global filters based to the end user requirement.

TECHNICAL SKILLS:

Reporting Tools: Tableau 10.x/9.x/8.x Desktop and Server. OBIEE 10.1.3x/11g

ETL Tools: Informatica, Data Stage, Talend, Microsoft SQL SSIS.

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2008/2012, PostgreSql 9.x/10.x, Teradata.

Languages: SQL and PL/SQL.

Tools: TOAD and SQL Developer, HPSM Control-M, NetSuite.

Methodologies: Data Modeling, ETL, OLTP, OLAP, Erwin, Complete Software Development Lifecycle, Agile & Waterfall.

Operating Systems: Unix/Linux Shell Scripting, Windows Variants.

PROFESSIONAL EXPERIENCE:

Confidential, Deer Park, NY.

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.
• Worked with UNIX environment to execute shell scripts along with basic tasks.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on a business change to ensure that the views and dashboards were displaying the changed data accurately.
• Setting up an active directory on the tableau server for the effortless password management for the single sign-on in the Salesforce and to view the embedded dashboards.
• 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.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Created calculated fields, parameters and action filters for building dashboards and worksheets in tableau.
• Designed and developed graphic rich visualizations with Drill Down and Drop Down menu option.
• 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.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Created Data Connections, published on Tableau Server for usage with operational/Monitoring Dashboards.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Desktop 10.x/9.x, Tableau Server 8.x,, MYSQL Server, MS SQL Server 2008, Oracle 10g, Unix shell scripting.

Confidential, Eden Prairie, Minnesota.

BI Tableau Consultant

Responsibilities:

• Collaborated with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Developed market intelligence report using pie charts to present competitor's analysis by analyzing market share of voice (SOV), channels of distribution, and product messaging focus.
• Developed Tableau workbooks using time series analysis to perform YTD, QTD and MTD charts which increases profitability.
• Created executive weekly view dashboards presenting leads, sales, competition, and forecast for the sales & marketing team bar charts, line charts, and pie charts.
• Designed standardized DataMart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers in implementation.
• Collaborated in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Generated various dashboards in Tableau server using various data sources like SQL Server, Oracle, Excel, Text, and Salesforce using data blending feature in tableau.
• Update and maintain various release documentation, and JIRA tickets.
• Managed server activities, user activity, and customized views on Server Analysis by Creating users, groups, projects, Data connections, settings as a tableau administration.
• Performed testing using BI Validator for Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau 8/9, Oracle, Teradata, MS Share point, Windows/Unix, Jira.

Confidential, Atlanta, GA

Tableau Developer

Roles & Responsibilities:

• Scope of the project was to enhance the Mobile Banking App's systematic processes which were associated with SunTrust Bank's Personal Banking division
• Developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability, and transfer money to get better understanding of future enhancements
• Involved in End-to-End Implementation and Enhancements on Mobile Banking App data starting from requirement gathering and dashboards development in Tableau Desktop.
• Studied and analyzed similar applications and brainstormed with business team to Gather Effective Requirements for the system along with dashboard development
• Created numerous Dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states
• Created Bar Charts complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Created Crosstab's to display underlying data based on various graphs and charts created for further data analysis.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed Story Telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups

Environment: Tableau 9.x/8.x, Oracle, Excel, Windows.

Confidential

SQL Developer

Roles &Responsibilities:

• Created stored procedures, scripts, views in Oracle database design and create SQL database, tables, indexes, and views.
• Created user defined functions, stored procedures, triggers, and suggested creating clustered and non-clustered indexes on tables for performance improvement.
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing, fine tune complex SQL queries and stored procedures to increase performance.
• Extensively used XML documents to pass multiple parameters for stored procedures to read and write database table.
• Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Worked on DTS Package, DTS import for transferring data from Oracle and lotus notes.
• Worked as a developer in creating complex stored procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, instances, linked servers and indexes.

Environment: MS SQL Server 2008, SSIS, SSRS, DTS, SQL Management Studio, SQL Server Business Intelligence tools, Windows 2003, SQL Server Query Analyzer, Oracle 8i, SQL Profiler, Crystal Reports.

Confidential

SQL Developer

Roles &Responsibilities:

• Involved in Optimization and normalization of database and tables.
• Involved in ER diagrams (Physical and Logical using Erwin) and data mapping the data into database objects.
• Created Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement
• Performed query plans and making sure each and every query is using appropriate useful Indexes.
• Created and Modified T-SQL Stored Procedures/Triggers for validating the integrity.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using
• Report Designer as well as Report Builder.
• Extensive experience in multidimensional data modeling, such as star schemas, snowflakes, de-normalized models, handling slow-changing dimensions/attributes
• Analyzed and created Multidimensional Cubes in Facts and Dimension Tables using SSAS
• Scheduled Backups and performed Restore operations for system test data

Environment : MS SQL Server Management Studio 2005, T-SQL, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Erwin.