SUMMARY

• Over 7+ years of Data warehousing experience with Business Intelligence Tableau 8.0/ 7.0, SAS, OLTP and OLAP Microsoft SQL Server, SSRS, SSIS as a Developer in various companies.
• 4+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0, 8.1 and 8.2 as a developer and Administrator.
• Created 1000+ worksheets and 200+ Dashboards in large BI environments using Tableau 8.1/8.0/7.0.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.
• Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.
• Reports development using various reporting tools like Tableau, SAS, SSRS.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server.
• Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Proficient in design 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 and other making use of actions, other local and global filters according to the end user requirement.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in installation of Tableau desktop 8.0, Tableau server Application software
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 8.1
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expert in modeling, Extraction Transform Loading (ETL) using DTS and SSIS.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Proficient in handling parameterized reports in SSRS.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server
• Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables.

TECHNICAL SKILLS

Data Warehousing ETL Tools: SSIS, Informatica Power Center 8 .X,7.X, Talend 4.2.x/5.1.2

Databases: SQL Server 2012,SQL Server 2008/2008 R2, SQL Server 2005, SQL Server 2000/7, Access, Oracle 8i/9i/10g, MYSQL, Data warehouse.

Data Modeling tools: Star Schema Modeling, Snow Flake Modeling

Reporting Tools: Tableau 8.0/7.0, SAS, SSRS, Crystal Reports 9.0/8.5,OLAP

Languages: PL/SQL, SQL, Unix shell scripting, Java, C

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Tableau Lead

Responsibilities:

• Onshore Team Lead for Report Development.
• Involved in reviewing business requirements and analyzing data sources form Teradata Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Worked directly with business customers to build reports, dashboards, ad-hoc reports
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
• In charge of the team that builds tableau architecture and dashboards using Tableau desktop, Tableau Server.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop.
• Utilized advance features ofTableausoftware like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Executed and tested required queries and reports before publishing dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0.
• Created multiple visualizations like Heat Maps, Bar Graphs, Bullet Graphs.
• Preparing Dashboards using calculations, parameters in Tableau.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.

Environment: Tableau Desktop 8.2, Tableau Server, MS Office Suite, Teradata, MS Excel.

Confidential, Erie, PA

Tableau/MSSQL BI Developer

Responsibilities:

• Built Strategic, Analytical and operational dashboards using Tableau and Xcelsius.
• 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.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created report schedules, data connections, projects, groups inTableauserver.
• Involved in license management SLA's withTableausupport.
• Created scripts on windows task scheduler for auto sync of users from Active Directory groups.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableaurepository.
• Worked on various reports using best practices and different visualizations like Donut charts, Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
• Developed reports using multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• 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 SQL Server and MS Excel.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• 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.
• Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.

Environment: Desktop 8.1, Tableau Server, MS Office Suite, SQL Server, SSRS,SSIS, MS Excel.

Confidential, Tampa, FL

Tableau/BI Analyst

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Involved in installation of Tableau desktop 7.0, Tableau server Application software
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Creating New Schedule's and checking the task's daily on the server
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Worked on tabcmd to schedule the report's and setup email reports using command lines.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

Environment: Tableau Desktop 8x/7x, Tableau Server/Administrator, Tabcmd, SSRS,SSIS

Confidential, Canonsburg, PA

Tableau Developer/SQL BI developer

Responsibilities:

• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Involved a key member in development of E-R modeling (Logical design) of database incorporating business logic and user requirement.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ) and Measure

Environment: Tableau 7.0, SQL Server 2008 R2, SSMS, MS Excel, T-SQL.

Confidential, Boston, MA

SQL BI Developer

Responsibilities:

• Directly interacting with clients to elicit the requirements and translate them into terms that development team can comprehend.
• Created SSIS Packages using SSIS Designer for importing heterogeneous data from OLEDB Sources, Excel Spreadsheet, text files into Data Warehouse.
• Various ETL Transformation tools were used for Control Flow and Data Flow tasks
• Experienced in creating reports (SSRS) in Drill mode using tables, matrix and charts in SQL SERVER 2008
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS
• Created star schema in SSAS and developed SSRS reports based on the cube.
• Conduct client interviews, high-level reviews, and be part of focus groups to derive and execute action plans, meet deadlines, and follow industry standards and best practices.
• Facilitate User Acceptance Testing (UAT) and production rollouts, and the defects detected were tracked and managed using HP Quality Center.
• Produced reporting documents and led weekly meetings with developers and business units to discuss outstanding technical issues and deadlines that had to be met.
• Involved in maintaining and updating database objects like tables, views, procedures, functions using basic SQL queries to provide definition, structure, and to maintain data efficiently.
• Assist BAs in the team with appropriate documentation and domain knowledge.
• Perform data modeling, periodic report validation and data analysis by writing SQL queries using TOAD.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in writing queries for Stored procedures, clustered and non-clustered indexes
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Interaction and coordination with end users and management to identify Business system needs evaluated solutions for business problems bottlenecks and evaluated alternate methods to increase efficiency and improve control.

Environment: SQL Server 05/08, MS Office, MS Excel, MS SQL Server 2005 Management Studio, Windows XP Server, MS Excel, MS Access, Text Pad text editor, MS Visio 2005, DTS, SQL Query Analyzer, SQL Developer.

Confidential

ETL Developer/Data Analyst

Responsibilities:

• Assessing the quality of data fit for use
• Extracting the Data from the required sources and loading into the Target system
• Developed complex Talend ETL jobs to migrate the data from flat files to database
• Monitoring the system objects like huge files/ unused indexes and taking necessary steps to improve the performance of applications as well as batch jobs
• Improving the batch jobs performance, by suggesting the effective ways of design to application development team.
• Resolution and analysis of critical end-user issues.
• Responsible for the system stability.
• Integration of the new web services into the other applications, to improve the system performance by reducing the number of connections
• Creation of tickets and getting the required approvals to perform any changes in production environment if required
• Prepared detailed on boarding documentation for each every application for which we received the KT. Also prepared the tech validation document for each and every application, which will be useful to validate the application at any point of time
• Performing Analysis like Column Analysis, Table Analysis and Redundancy Analysis necessary for the Data

Environment: Talend Data Quality, Oracle 10g, Windows XP, Flat Files, Thod.

Confidential

SQL Server Developer/SQL Server DBA

Responsibilities:

• Assisted clients with physical database modeling, data archiving strategies, data purges and disaster recovery planning.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification, indexing and statistics update.
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Involved in writing T-SQL statements for retrieval of data.
• Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster.

Environment: MS SQL Server 2000, Enterprise Manager, T-SQL, DTS, Query Analyzer, SQL Profiler, Crystal Reports.