SUMMARY

• Over 7+ years of Data warehousing experience with Business Intelligence Tableau 8.0/ 7.0, SAS BI, JMP, OLTP and OLAP Microsoft SQL Server, SSRS, SSIS as a Developer in various companies.
• 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.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Extensive knowledge of tableau architecture,
• 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 Modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts

TECHNICAL SKILLS

Data Warehousing ETL Tools and Environment: SSIS, Informatica, Power Center 8 .X,7.X, Salesforce, Teradata, Hadoop, Stone Eagle

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

Reporting Tools: Tableau 9.0/8.3/8.2/8.1/8.0/7.0 , SAS, SSRS, Crystal Reports 9.0/8.5,OLAP, Cognos, Power BI

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

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

PROFESSIONAL EXPERIENCE

Confidential, Mansfield, MA

Tableau administrator/Developer

Responsibilities:

• Developed Dashboards using Calculations, Sets & Bins in Tableau.
• Used Tableau Desktop and analyze and obtain insights into large data sets.
• Created Parameters to achieve desired functionality.
• Created complex Dashboards utilizing the features like Hierarchy, Functions and Table Calculation.
• Involved in and out of the client conversation to understand the business requirement.
• Good in scheduling and deployment of Tableau reports.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Involved in creating the timelines and resource allocated to work on the projects.
• End to End process involvement from gathering client business requirements, developing the dashboard in Tableau and publishing the dashboard into server.
• Developed a user authentication dashboard through Tableau to get the desired output.
• Excellent in managing subscriptions in Tableau Server.
• Tuning, patching and troubleshooting tableau server environment (Multitier Environment),
• Manage user groups, user license requests and user Active directory management,
• Administrating tableau server infrastructure (DEV/QA and PROD),
• Developed tableau server audit reports to view and analyze tableau server insights (health, tableau server usage, tableau server data extract failures etc.)
• Tableau server status reporting and data extract management,
• Tableau server analysis and recommending requirement as per the usage,
• Developing complex queries and formula to design tableau dashboards as per the departmental request,
• Creating and maintaining new data extracts as per the new requirements,
• Prototyping and designing reports,
• Resolving ODBC driver issues with the data extracts,
• Automation of various tableau server AD group refresh,
• Implementing third party tools inside tableau server to give collaborative tools to the users,
• Tableau desktop and server tickets resolution (primary contact for support),
• Resolving tableau dashboards development issues,
• Involved in health check ups with onsite tableau support,
• Resolving dashboard development issues for wide range dashboards published by different department,
• Developing and perfecting tableau dashboards,
• Setting up tableau server system standard procedures,
• Report migration from SSRS to tableau,
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.

Environment: Desktop 8.2/8.3, Tableau Server, MS Office Suite, SQL Server, SSRS, SSIS, MS Excel, Salesforce, Oracle DB, Teradata

Confidential, Racine, Wisconsin

Tableau Administrator /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.
• 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.
• Tableau integration with the Salesforce for enhanced experience for the users.
• 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.
• Extensive work on tabcmd utility for the custom scheduling and tableau server administration,
• 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.
• Built custom landing page connected to PostgreSQL in order to get information required on landing page such recently viewed, usage of the reports, user status etc,
• Duplicating the cognos and SSRS reports for the internal users in the tableau
• Tableau dashboards embedding into Salesforce for the continuous data experience for the users,
• Built Strategic, Analytical and operational dashboards using Tableau,
• Built custom tableau dashboards for the Salesforce for accepting the parameters from the Salesforce in order to show the relevant data for that particular selected object,
• Setting up 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,
• Best practices in order to save on IdP service provider and data security,
• Effectively used tabcmd for the maintenance of server. Scheduled tasks, imported user list, restarted server and performed various other roles through tabcmd
• Worked on seamless single sign on experience for Salesforce and tableau users,
• Demonstration of the tableau dashboards and its functionality to the business users for the self service business intelligence,
• Connecting and extraction to different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines,
• Developed tableau dashboard landing page for the embedding into Salesforce in order to provide integrated views and navigation inside Salesforce for the users,
• Developed various dashboards for non-Salesforce group of users for their specific goals of understanding data,
• Customization of the Single sign on page for the Salesforce and tableau,
• Best practices to enhances the response time of tableau dashboards and speed for the embedded dashboards,
• Tableau administration and development roles,
• Helped client with the issues of data connections, extraction and maintenance,
• Best practices for naming classes, objects inside Salesforce for the integration,
• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau,
• Implemented row level security for the tableau dashboards,
• Tableau server and desktop upgrade from 8.2 to 8.3.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• 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, sharepoint, Salesforce, Teradata, Stone eagle,Cognos, Hadoop, Grenn Plum.

Confidential, des moines IA

Tableau developer/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.
• 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.
• See a comprehensive view of your sales pipeline and results.
• Access dashboards from any browser or tablet.
• 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,
• Trend Lines, Statistics, and Groups, hierarchies, Sets to create detail level summary report and Dashboard

Environment: Tableau Desktop 8.0/7.0, Tableau Server/Administrator, Tabcmd, SSRS,SSIS

Confidential, SC

Tableau Developer/SSIS developer

Responsibilities:

• Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
• Created pie and bar charts and combined them into dashboards to show top content viewed by customers in each category including sports and news channels allowing interaction between the two charts for drill down analysis.
• Analyzed data from various databases and formatted it into graphs using Tableau Desktop.
• Created line charts to show over time in a breakdown of daily, weekly, quarterly, and yearly parameter numbers of viewers watching a particular sports channel.
• Blended data from multiple databases such as MS Excel and SQL database by assigning primary key from each databases.
• Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Administered user, user groups, and scheduled instances for reports in Tableau Server.
• Presented, interacted, and communicated with business and user groups for explaining the dashboards that I have created with the ability to change and view the data on the fly.

Environment: Tableau Desktop 7, Tableau Server, SQL Server 2008, MS Excel.

Confidential, NY

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 Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• 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, NY

SQL BI Developer

Responsibilities:

• Directly interacting with clients to elicit the requirements and translate them into terms that development team can comprehend.
• 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.
• 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: Tableau 7.0, SQL Server 2008, MS Office, MS Excel.

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.

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