PROFESSIONAL SUMMARY:

• Over 10+ 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.
• Experience with utilizing scripting languages to leverage Tableau's APIs (JavaScript API, Data Extract API, REST API).
• 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.
• Designed ETL packages using proper Loggings and Checkpoints, secured packages with Encryption in conjunction with passwords.
• Designed and developed ETL packages to convert and migrate data, transform data using like Lookup, Merge joins, derived columns, and built the data warehouses using the Snowflake Schema.
• 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.
• GoodHands-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 2018.x/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

TableauDeveloper

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.
• Query data and Blend information from diverse data sources to create rich datasets that enable better visualizations & decision-making by the business.
• Organized dashboards in Tableau to analyze the revenue, expense over various attributes of customers, project, time and location dimension.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data.
• Track profit, loss with an intuitive ESF dashboard, the top two views provide an overall picture of quarterly and yearly performance over the past three years. The views include key financial measures such as net sales, net profit, and net profit margin.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Build Financial dashboard YoY, YTD, FYF for Cash flow, Income statement & Balance Sheet, showed profitability and growth YoY.
• Developed Tableau data visualization using cross tabs, Box and Whisker Charts, Scatter Plots. Pie Charts and Bar Charts.
• Worked extensively with Calculated field, hierarchies, parameter, groups, and Set.
• Build & Created Cascading Filter for complex dashboard & Graph Charts.
• Built Tableau dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations.
• Created Rich HR management dashboard using HR information like Headcount Tracking & Forecast, Recruiting Metrics, Compensation & Benefits.
• Build line charts to track Headcount with current year with prior year, with business unit and department.
• Ability to simplify, translate and explain complex processes, wrote SQL statement.
• Created KPI using calculated key figure and parameter
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Perform quality assurance and testing of SQL server environment.
• User Java Script API to customize the views, selects, filters, date and time.
• Developed client side validation code using JavaScript and JQUERY.
• 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.
• 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.
• 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.

Environment: Tableau Desktop 2018.x/10.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.x/9.x, Oracle, Teradata, MS Share point, Windows/Unix, Jira.

Confidential, Atlanta, GA

Tableau Developer

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

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

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.