SUMMARY

• Over 7+ years of Data warehousing experience with Business Intelligence Tableau 9.0/ 8.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.
• Involved in installation of Tableau desktop 9.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 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

Front end tools: Microsoft Project, Microsoft Office

PROFESSIONAL EXPERIENCE

Confidential, Johns creek, GA

Sr. Tableau Developer

Responsibilities:

• 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,
• Effectively used tabcmd for the maintenance of server. Scheduled tasks, imported user list, restarted server and performed various other roles through tabcmd
• 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,
• Best practices to enhances the response time of tableau dashboards and speed for the embedded dashboards,
• Tableau administration and development roles.
• 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.3 to 9.0.

Environment: Desktop 9.0/8.3, Tableau Server, MS Office Suite, SQL Server, SSRS, SSIS, MS Excel, Salesforce

Confidential, Johns Creek, GA

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.
• Tableau server upgrade to tableau server 8.2.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• 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.
• Created extracts and published data sources on tableau Server for the users from various databases in Green Plum.
• Used complex joins and validated them by running and tuning long SQL queries.
• 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.
• Data connections to the cloudera hadoop for the data analysis and visualization in tableau
• 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.
• 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, Pittsburgh, PA

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.
• 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.
• Involved in installation of Tableau desktop 7.0,
• 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, Newton, MA

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.
• Worked on 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 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

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.