SUMMARY

• 8+ years of experience in design, development, implementation, and administration of various Business Intelligence tools and expertise in implementing various functionalities of Data Warehouse using SQL Server, Oracle and Tableau.
• Expertise in using Tableau Server, Tableau Desktop, Tableau Reader and Tableau Public.
• Expertise in Installing, Configuring and Administration of Tableau Server in Scale - out process
• Expertise in designing and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization
• Used actions, local and global filters according to teh business/client requirement.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating wif other platforms like SharePoint.
• Experience in creating Sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables, and Physical and Logical data modeling.
• Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau.
• Worked extensively wif teh major functionality of ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues wifin Tableau.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Expertise in monitoring teh database server for deadlocks, long running queries and tuning teh same to improve teh performance.
• Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising wif data origination teams.
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms.
• Ability to translate complex data requirements into simple, understandable formats understood by technical and non- technical users.
• Have been working wif various data sources such as Oracle, SQL Server, Teradata, Google analytics, SharePoint List, ODBC and flat file sources.
• Strong experience in SQL Server development, System Analysis, Design, and Support of MS SQL Server.
• Experience in T-SQL, writing complex SQL Queries, Stored Procedures and Functions in SQL Server.
• Excellent skills in communication & collaboration, interest & ability to learn new technologies in short time.

TECHNICAL SKILLS

Reporting Tools: Tableau Desktop v6.x/v7.x/v8.x/v9.x/10.x, 10.5x, Tableau Server v6.x/v7.x/v8.x/9.x/10.x/10.5x, Crystal reports XI/2008, Business Objects XI R1/R2/R3.x/4.x, BO Universe Designer, BO Web intelligence.

Databases: Teradata, MySQL, MS SQL Server, Alteryx,Hive, ORACLE, IBM DB2, MS Access,,, Hadoop HIVE.

ETL Tools: SSIS, Informatica

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes, OpenProj

Scripting Languages: SQL, PL/SQL, Java, HTML

Document Management: Documentum, Share point, Ultra Edit

Defect Management tool: JIRA

Service Management Tool: HP Service Manager, CA Service Desk

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile, Iterative)

Data Modeling: Power Designer, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Tableau Developer/ Data Analyst

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated wif all project teams.
• Interacted wif Subject Matter Experts and End Users to gather business requirements.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Performed extensive GAP analysis in teh project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Analyzed requirements for various reports, dashboards, and scorecards.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current, and forecast sales data.
• Mentored 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
• Developed key indicators and teh appropriate tracking reports wif graphical and written summations to assist in teh quality improvement initiatives.
• Involved in creating interactive, parametrized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch dat included drill-through, filters, Heat/Geo/Tree maps, Pie/Bar charts, Circle views, Line/Area charts, Scatter plots, and Bullet graphs.
• Utilized Data story telling in Tableau to provide more dynamic and more TEMPeffective stories from teh hidden insights locked in teh data.
• Created prompts, customized calculations, conditions, and filters (Local, Global) for various analytical reports and dashboards.
• Created and modified interactive dashboards and developed guided navigation links wifin interactive dashboards.
• Created Table of Contents (TOC), a common navigation page which had all teh links to various reports and dashboards.
• Published teh developed dashboards and reports on theTableauServer so dat teh end users having access to teh server can view teh data.
• Scheduled frequency and time to refresh data when sources are published or extracted to server.
• Played an important role in coordination wif teh entire team and managing teh time estimates for teh entire project.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate teh data in teh warehouse and data marts.
• Ensured on-time and on-budget performance of teh assigned efforts to teh mutual satisfaction of teh business partners/ sponsors.
• Oversaw teh performance of design to develop technical solutions from Analysis documents.
• Provided post implementation production support.

Environment: Tableau Desktop/ Server, MS Project, Teradata, Teradata SQL Assistant, SQL, PL/SQL, SQL Developer, Informatica Power Center, SQL Server, Control-M.

Confidential, Pittsburgh, PA

Tableau Developer

Responsibilities:

• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Gathering business requirements and preparing analyses based on information from internal and external sources to evaluate and demonstrate program TEMPeffectiveness and efficiency supporting projects and change requests
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Create detail level summary report and Dashboard using KPI's.
• Implementation of data warehouse data marts delivering reporting and data analytics using PL/SQL,Tableau, SAP Business Objects, Teradata tools and Performing and collaborating in modeling, designing.
• Created reports using Tableau functionalities like Queries, Drill Down, Prompts Functions to meet teh requirements using SQL Server.
• Extensively worked on Dashboard reports in Tableau 10x analytics to get teh interactivity of teh member and enrollment information based on teh year wise trend analysis. algorithms, statistical analysis
• Worked on Performance tuning of report wif huge queries using concurrent query execution for better performance of report Analysis skills: ETL tools, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts and Tabular reports using Tableau Desktop.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau.
• Worked on teh data provider dat forms teh basis of teh ad-hoc analysis.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring teh correct selection of tool set available across teh Tableau and Power BI suite.

Confidential, Deerfield, IL

Tableau Developer/Data Analyst

Responsibilities:

• Proactively communicated wif teh business users to understand teh needs and develop requirement documentation.
• Involved in requirements gathering, analysis, and functional specification documents.
• Worked in coordination wif Clients for feasibility study of teh project in Tableau and drawing up teh timelines as per project requirement.
• Created Users, Groups and projects in Tableau environment.
• Created and managed schedules for users.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on teh new changes to ensure dat teh views and dashboards were displaying teh updated data.
• Created different views using Tableau Desktop which were published to teh business stake holders for analysis and customization using filters and actions.
• Created different charts showing KPI by color dat were broken into regions allowing business user to understand which stores are teh outperformers in different categories.
• Developed various data connections from data source to Tableau Server for report and dashboard development
• Combined visualizations into Interactive Tableau Dashboards and published them to teh web portal.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate teh data.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• TEMPEffectively used data blending, filters, actions, Hierarchies feature in Tableau.
• Configured Cache settings which improved teh performance of teh reports and Dashboards.
• Participated in meetings, reviews, and user group discussions as well as communicating wif stakeholders and business groups.
• Involved in testing teh SQL Scripts for report development, Tableau reports, Dashboards and handled teh performance issues TEMPeffectively.
• Achieved performance tuning by implementing Caching, Aggregate tables and creating indexes on tables.
• Involved in preparing material and training Business users.

Environment: Tableau 8.x Desktop, Tableau server, SQL Server 2008R2, Informatica 8.x, SQL, T-SQL.

Confidential, NYC, NY

Tableau Developer

Responsibilities:

• Responsible for interaction wif business stake holders, gathering requirements and managing teh delivery, covering teh entire Tableau development lifecycle.
• Experience in Marks, Publisher and Security.
• Experience wif creating Worksheets, Dash boards and info graphics.
• Working wif Multiple data Connections.
• Used Snowflake and Star Schema Designs for data modeling.
• Experience wif troubleshooting.
• Experience in Tableau Rapid Analytics, Custom Geocoding and Reporting.
• Experience wif Tableau for Data Acquisition and data visualizations for client and customers.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Expertise in Experience in BI interactive Dashboards, Tableau Publisher and Tableau Analysis.
• Experience in developing Dashboard using OLAP cubes.
• Experience of Client-Interaction on onsite/Offshore.
• Involved in Test Evaluation, Summary Reports.
• Live, optimized connections to Teradata to leverage teh investments.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005/2008, SSAS, Oracle 11i, Excel, T-SQL

Confidential, Austin, TX

SQL Server Developer

Responsibilities:

• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into teh Data warehouse.
• Used SSIS to implement teh Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used C#.Net to write Script in SSIS tasks like Script Task and Script Component.
• Written Code in C#.Net to make Web Application and connect wif Backend (SQL Server).
• Implemented Master/Child Packages so only teh Master Package TEMPhas to be scheduled which will in turn fire teh other packages.
• Created Sequence in SQL Server 2012 to insert same identity value in multiple dimension tables as per teh business rules.
• Created SSISDB catalog wif SQL Server 2012 to support SSIS package deployments in SSMS wif Environment variables respective to each environment.
• Involved in debugging of packages wif halp of Breakpoints, Checkpoints, Event Handlers and Loggings.
• Handled Performance Tuning and Optimization on SSIS, wif strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Automated teh ETL process by scheduling SSIS package execution by creating jobs.

Environment: SQL Server 2008R2/2012, SQL Server Agent, SQL Server Integration Services (SSIS), SharePoint, TFS, Power Pivot, Windows Server.