PROFESSIONAL SUMMARY:

• Having 10+ years of experience in Software Design, Development, Integration, Implementation of Data Warehousing & Business Intelligence Applications in Tableau Desktop, Tableau Server, Microsoft BI (SSAS, SSIS, SSRS), Power BI, Business Objects, ETL and OBIEE.
• Experience in Tableau 10.4.3/10.2/10.1/9.2/8. x (Desktop and Server), creating various Reports and Dashboards using different visualizations like Bars, Lines, Pies, Maps, Scatter plots, Bubbles and Highlight tables.
• Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Experience in creating aggregates, hierarchies, charts, filters, quick filters, table calculations, trend lines calculated measures.
• Created Customized and interactive dashboards using multiple data sources.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing Ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.
• Experience in OLAP Cube Creation (Created many multidimensional *cubes* Using SSAS of SQL Server 2012/2008/2005 ).
• Experience in Relational and Dimensional Modeling, Designing of Star, Snow Flake Schemas, Development.
• Experience in creating SSAS 2012/2008 cubes, MDX queries, working with facts, dimensions, hierarchies, Perspectives and various storage settings (ROLAP/MOLAP/HOLAP).
• Experience in Cubes Processing in Development and Production Servers. Cubes through creating the OWC Reports and Dashboards.
• Experience in SQL Server Reporting Services (SSRS) Development, Deployment and Support.
• Proficiency in creating different types of reports such as Cross - Tab, Drill-down, Form, OLAP, Dashboard reports, Sub reports and Linked Reports, and formatting them using both SSRS 2012/2005/2008.
• Sending the reports from different output file format into different end users using Standard and Data Driven Subscriptions.
• Experience in configuring automation reports using various delivery mechanisms like Email Links, PDF attachments and Excel attachments.
• Experience in deploying reports in various sources like Web browser, XML and PDF.
• Used the SSIS for extracting, transforming, and loading data into data warehouse.
• Create SSIS Packages used Control flow, Data flow and tasks according to business requirement.
• Created different transformations for loading the data into Oracle and SQL database which includes (*Lookup*, *conditional split*, *SCD*, *Pivot*, *multi cast*, *merge join*, Data conversion, Script task and many more).

TECHNICAL SKILLS:

Reporting Tools: Tableau Reports, BOBJ Reports, SSRS Reports, SSAS Reports, OWC Reports, Tableau, Performance Point Server (PPS 2007).

SQL Server Tools: SSIS, SSRS, SSAS, SSMS, SharePoint Server (MOSS). SQL Profiler, Analyzer, SQL Server Management Studio, DTSOperating Systems: Mac OS, Windows XP/2003/2000/NT, MS DOS.

RDBMS: Teradata, HP Vertica, SAP Hana, MS SQL Server 2012/2008/2005 , Oracle 11g/10g/9i/8, MS-Access 2010/2007/2005.

Programming Languages: T-SQL, ASP.NET,C#.NET,HTML, XML, Java.

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, California

Sr. Tableau Developer

Responsibilities:

• Gathering requirements from business users, Preparing BRD (Business Requirement Documents) and FSD (Functional Specification Documents) documents.
• Created complex dashboards using multiple systems (like RCM and RCS data.)
• Created LMS Reports, Communications Reports and Task Reports based on user requirement (like Post Usage by Date, Views by Post Title, Saved Post Usage, Active User Logins, Channel Card Views, Tasks Status, Tasks Activity, Tasks Note Details and Task Counts by Users).
• Created multiple trend graphs like dual axis charts, Line chars, Bar charts, Pie Charts, Donut Charts, Tabular reports and Matrix reports.
• Developed various dashboards, used context filters, action filters, parameters and calculated sets for preparing dashboards and worksheets dealing with huge volume of data.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Create dashboards like quarterly, monthly, weekly, daily reports and schedule the dashboards to requested users.
• Performance testing on multiple servers (UAT and production).
• 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
• Performance optimization of the data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database application or data content related issues

Environment: Tableau desktop 10.4.3, Tableau Server 10.4, Teradata Database (EDW).

Confidential, Sunnyvale, California

Sr. Tableau Developer

Responsibilities:

• Gathering requirements from business users and Created new Dashboards.
• Migrating BOBJ Reports to Tableau Dashboards and tabular reports.
• Created complex dashboard using multiple data sources (like Teradata, HP Vertica, Oracle, SAP HANA and Excel.)
• Created (ACSE Line Item Metrics, Multi Comparison, Reconciliation, Multiplier Mismatch, iCon Repairs. RFPU, CPFR Dashboards, Trend Analysis etc.. )
• Created AppleCare CPU Usage and System performance Dashboards and Ticket Trend Dashboards.
• Developed various dashboards, used context filters, action filters, parameters and calculated sets for preparing dashboards and worksheets dealing with huge volume of data.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Create dashboards like quarterly, monthly, weekly, daily reports and schedule the dashboards to requested users.
• 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
• Performance optimization of the data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database application or data content related issues

Environment: Tableau desktop 10.2, Tableau Server 10.2, Teradata, HP Vertica, SAP HANA, Business Objects V4.2, Microsoft Office, T-SQL, Oracle PL/SQL.

Confidential, Sunnyvale, California

Sr. Tableau Developer

Responsibilities:

• Interacted with business users for gathering requirements, look and feel of the applications to be develop.
• Created complex dashboard (Sell In, Shell Thru, TSA, BTB, BTB with ASP, BTB without ASP and ASP) using multiple data sources (like Teradata, HP Vertica and Excel).
• Developed various dashboards, used context filters, action filters, parameters and calculated sets for preparing dashboards and worksheets dealing with huge volume of data.
• Blended data from multiple databases into one report by selecting primary key s from each database for data validation.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Create dashboards like quarterly, monthly, weekly, daily reports and schedule the dashboards to requested users.
• 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
• Performance optimization of the data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database application or data content related issues

Environment: Tableau desktop 10.0, Tableau Server 10.0 version, Teradata, HP Vertica, Business Objects, Microsoft Office, MacBook Pro. T-SQL, Oracle PL/SQL.

Confidential, Carlsbad, California

Senior Tableau Developer

Responsibilities:

• Created complex dashboard using multiple data sources (like Sales Force, Oracle, SQL and Excel).and Custom Hierarchies to meet the Business requirement in Tableau.
• Created CMD,LPG,LSG,LPG Demand Waterfall, ERP, Monthly and Cognos (MBD Cube) Dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Star schemas, Snowflake schema, fact and dimension tables, logical and physical modeling.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Regular involving in calls with customer and discussing about status and new requirements of the project.
• Checking the production environment jobs and troubleshooting the failed jobs
• Design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Creating, modifying, deploying and browsing Cubes with multiple fact measures and multiple dimension hierarchies in MBD Cube.

Environment: Tableau desktop 9.2, Tableau Server 9.2 version, Oracle, Microsoft SQL Server 2008 R2/2012, Microsoft Office, Windows 7. T-SQL, Sales Force and MBD Cube.

Confidential

Application Developer

Responsibilities:

• Created Star schemas, Snowflake schema, fact and dimension tables, logical and physical modeling.
• 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.
• Created dashboard using multiple data sources and Custom Hierarchies to meet the Business requirement in Tableau.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Regular involving in calls with customer and discussing about status and new requirements of the project.
• Checking the production environment jobs and troubleshooting the failed jobs
• Design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Transformation of OLTP data to the Data Warehouse using SSIS (ETL) Packages.
• Creating, modifying, deploying and browsing Cubes with multiple fact measures and multiple dimension hierarchies in SSAS
• Experience in SSRS design and deployment of Parameterized, Drilldown, Drill through, Sub, Linked Reports and Dashboards using the MDX Queries and T-SQL Queries.
• Created Jobs, scheduling & running jobs and troubleshooting the failed jobs.

Environment: Tableau 9.1/8.3, Tableau Server, Oracle, Microsoft SQL Server 2008 R2/2012, Microsoft Office, Microsoft Visio, Windows 7. T-SQL, MS SQL Server 2012/2008 R2, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), Team Foundation Server (TFS), Windows 2007, VBScript.

Confidential

Senior Software Engineer

Responsibilities:

• Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance. Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension. Created parameters and quick filters. Created sets to display top products based on their sale.
• Administration of Tableau and server maintenance, Tableau server backup activity. Consolidate multiple data silos that exist on campus to one location. Scheduled data extracts on a daily basis. Sophisticated stored procedures and triggers to provide complete technical solutions. Worked with all levels of development from analysis through implementation and support.
• Migrated Workbooks and Tableau upgrades/migration works. Implemented new features in Tableau to the existing Workbooks and Dashboards.
• Created Business Model to support Ad hoc Reports for User Access based on Requirements. Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
• Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Managed Security privileges for each subject area and dashboards according to user requirements. Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations. Used the Catalog manager and maintained the web catalog to manage Dashboards and Answers. Responsible for documenting the OBIEE framework and track the progress.

Environment: Tableau 8.0, Tableau Server, Oracle 10g, Microsoft SQL Server 2008 R2/2005, Microsoft Office, Windows 7.

Confidential

Senior Software Engineer.

Responsibilities:

• Migrated existing SQL 2000 DTS packages into SQL 2008 R2 SSIS packages.
• Design, Development, Testing the SQL Server 2008 R2 Packages.
• Interaction with Onsite team to validate and clarify requirements for design/development workat offshore.
• SQL query are reside in execute dts 2000 package, convert SQL query into procedure.
• Using Script Component - SSIS tool does not support directly return type refcursor fromprocedure.
• Preparation of Database Development and Development scripts.
• Providing support to the onsite team for resolving application issues.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2008, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Team Foundation Server(TFS), Windows XP, MS-Front Page, Oracle 11g, VBScript.

Confidential

Software Engineer

Responsibilities:

• Handle L2 / L3 Support Tickets
• Provide on-call support to production system to resolve any issues.
• Communicate with other teams like DBA, UNIX and Development team.
• Creating and maintaining various documents like Issues Resolution, Report Access Check List etc.
• Monitor various scheduled Backup / Cube Processing Task.
• Deployments to other environments like Testing, PROD.
• Interacted with end-users, customers during various phases of the implementations(ETL, Reporting, Production Support, Enhancements and bug fixes)

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2008, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Team Foundation Server(TFS), Windows XP, MS-Front Page, Oracle 9i, VBScript, Share Point Server, HP Service Center, Oracle Toad.

Confidential

Software Engineer

Responsibilities:

• Handle the two complete modules of Confidential Analytical module i.e., sales and Manufacturing.
• Created the Stage OLAP (Data warehouse and Data Mart) in SQL server 2005 using SSIS Packages as ETL for both Sales and Manufacturing, where Source and the target are the same SQL Server 2005.a. Where I used the SCD type 1 for Dimension modeling. b. And design the Package in such a way that it will load the fact tables incrementally.
• Created the sales and manufacturing multidimensional cubes using SSAS and analyze many calculated measures and created the KPI’s.
• Created the Analytical reports using SSRS.

Environment: MS SQL Server 2005/2008, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Team Foundation Server (TFS), Windows XP, VBScript.

Confidential

Software Engineer

Responsibilities:

• Handle the complete bizeX Planning and forecasting module of eXbis - Confidential business Intelligence Suit.
• Written all the complex Functions and the stored procedures and given the functional knowledge for their respective screens to the developers.

Environment: MS SQL Server 2005/2008, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Team Foundation Server (TFS), Windows XP, VBScript.

Confidential

Associate Software Engineer

Responsibilities:

• Design the Stage OLAP (Data warehouse and Data Mart) in SQL server 2005.2. Handle the complete ETL Process of the Project using SSIS as ETL tool to load the OLAP.
• Where I used the SCD type 1 for Dimension modeling.
• And design the Package in such a way that it will load the fact tables incrementally.
• Design the master package in such a way that by scheduling the single package the complete process will cover i.e., it will load the dimensions table first then the Fact tables and also the same package is used to process the cube. created the OLAP Cubes and KPI S

Environment: MS SQL Server 2005/2008, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Team Foundation Server (TFS), Windows XP, VBScript.