PROFESSIONAL SUMMARY: -

• Experience in working with Data Cleansing technique in ETL procedures.Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.
• Around 6 years of strong experience in Data Warehousing and Business Intelligence technologies with strong experience of data visualization usingTableauand experience in delivering key technologies in data design and ETL.
• Highly motivated Database Analyst &Developer, with the aptitude to explore and implement new features and capabilities in Business Intelligence.
• Extensive experience inTableauDesktop,TableauServer, andTableauReader in various versions ofTableau6,Tableau7,Tableau8, 9.X andTableau10.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Worked in all phases of BW/BI full life cycles includinganalysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
• Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
• Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Extracted data from SQL Server into data marts, views, and/or flat files forTableauworkbook consumption using T-SQL. Strong DW- BI skills and SQL skills.
• Knowledge Microsoft Power BI, Data zen, DAX expressions, Power View and Power Query integrated with share point.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services, and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Excellent hands on experience in creating groups and measures, KPIs.
• Expertise in front-end Components likeBEx Queries, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.
• Experience In extracting from heterogeneous sources, transformation of data modifying, andend to end transformation to heterogeneous destination as a source of data (SSIS)
• Experience in developing visualization features/designs most appropriate to data and analysis needs of business user's which include data cubing and analyzing the data (SSAS).
• Experience in T-SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R2/2012.

TECHNICAL SKILLS

Reporting Tools: Tableau (Desktop/Server), Micro Strategy (Desktop/WEB), SSRS, DWH, Business Intelligence. Data Integration

(ETL) Tools: Informatica Power Center, SSIS

Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio, OBIEE

SQL Tools: Teradata SQL Assistant, Rapid SQL, Toad, PL/SQL Developer, SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor,(Report Studio, Analysis Studio, Query Studio), SQL* Plus.

RDBMS: Teradata, Oracle, OLAP, SQL Server, Access

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Documentation: Documentum, SharePoint, HP Quality Center.

Scheduling Tools: Autosys, Control M

Operating Systems: UNIX, Linux, Windows 7/XP/2000, 2008/2003, Windows 10

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Tableau Developer/Admin

• Worked closely with Business Analyst, Data Modeler and all team within the organization to understand business processes, gather requirements, understand complexities and end goals to come up with best plans of execution.
• Participated in various meetings, reviews and user group discussion as well as communicating with stakeholders and business groups.
• Present the analysis to Internal and External teams and Explain data from a Business perspective.
• Involved in Semi Automation, Data Modeling, Identifying and Prioritizing KPIs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, aggregate and Slowly Changing Dimension, Merge Join and Union all.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Evaluated data models to design Tableau solutions by created different KPI using calculated key figures and parameters.
• Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Synchronized an Active Directory group withTableau Serverto ensure new users in Active Directory are also added inTableau Server.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
• Developed story telling dashboards inTableauDesktop 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.
• Worked with Microsoft Power BI, Data zen, DAX expressions, Power View and Power Query integrated with share point
• Created Data extract for Amazon Redshift data source and pulled the data through
• Tableau to create the Interactive Dashboards and Storyboards.
• Responsible to Deliver Proof of Concepts usingAWS, understanding customer business requirement.
• Prepared, blend, and analyze all data sources and apply advanced predictive and spatial analytics by Alteryx.
• Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau.
• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Experience in creating SQL queries, and modify/enhance existing SQL queries.
• Created and maintained issue log where business users enter their feedback by working on the dashboard in a test environment. Implemented the feedback and incorporated the necessary changes.
• Preparation of Unit test plans & Unit test results for the reports.
• Performed in data validation and testing process.

Environment: Tableau 8.0,9,9.1,9.2,10 (Desktop/Server), alteryx, SSRS, Teradata SQL Assistant, Teradata Administrator, Adobe Analytics, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Bowie, MD

Tableau Developer/Admin

Roles and Responsibilities:-

• Responsible for gathering/refining requirements from the customer for developing reports in Tableau
• Worked closely with end users in identifying and implementing right set of business criteria to convert raw data into meaningful information.
• Collaborate with business leadership to identify potential areas of analysis
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, actions, parameters, groups, sets and hierarchies in Tableau.
• Built Excel, Qlik View and Domo reports in tableau.
• Created Views and interactive Dashboards using Parameters, Filters, Actions, Bar/Pie/Funnel/Bullet charts, Area/Geo coding/Heat maps, Custom color palettes, scatter plots etc., in Tableau Desktop versions 8 9 and 10.
• Created Webi reports using custom SQL queries and converted them to tableau dashboards for advanced visualizations.
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. in a single dashboard by using parameters.
• Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• Effectively used data blending feature inTableau to combine the data from different sources like Adobe marketing cloud into a single report
• Defined best practices forTableaureport development.
• Designed multiple dashboards for CDI, helping them to convert from manual reporting
• Foundefficientways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Designed and developed various complex SQL Queries, Stored Procedures, Views, and User Defined Functions to implement the business logic.
• Used SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries in Teradata SQL Assistant.
• Presented the findings, graphs to c- suite, replicating the process across various customer segments.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document.
• 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
• Administered and provided production support for enterprise wide Tableau application consisting of multiple key functional business domains.
• Participated in the retrospective meetings and next sprint planning meetings.

Environment: Tableau (Desktop/Server),Altreyx,,Impala, SAS, UNIX, Microsoft Office Suite (Word, Excel, PowerPoint), JavaScript.

Confidential, CHICAGO, IL

MS SQL Server developer/Tableau developer

Responsibilities:

• Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked closely with end users in identifying and implementing right set of business criteria to convert raw data into meaningful information.
• Collaborate with business leadership to identify potential areas of analysis
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, actions, parameters, groups, sets and hierarchies in Tableau.
• Created Webi reports using custom SQL queries and converted them to tableau dashboards for advanced visualizations.
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. in a single dashboard by using parameters.
• Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• Effectively used data blending feature inTableau to combine the data from different sources like Adobe marketing cloud into a single report.
• Defined best practices forTableaureport development.
• Designed multiple dashboards for CDI, helping them to convert from manual reporting
• Designed and developed various complex SQL Queries, Stored Procedures, Views, and User Defined Functions to implement the business logic.
• Used SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries in Teradata SQL Assistant.
• Presented the findings, graphs to c- suite, replicating the process across various customer segments.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document.
• 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
• Administered and provided production support for enterprise wide Tableau application consisting of multiple key functional business domains.
• Participated in the retrospective meetings and next sprint planning meetings.

Environment: Tableau (Desktop/Server), MS SQL Server 2008, UNIX, Microsoft Office Suite (Word, Excel, PowerPoint), JavaScript.