SUMMARY

• As a BI/Tableau Developer, was involved in multiple full life cycle implementation in Financial Services, State and Local Governments, Pharmaceutical, Pharmacy Benefits & Claims, Logistics, Automotive and Utility Industry, Retail and medical equipment manufacturer with responsibilities ranging from project management, business analysis, system architecture, design, develop and implementation. Have gained valuable experience working with Big 5 consulting firm, utilizing off - shore development model.
• Expertise with Development of Scalable Dashboards on Tableau Desktop
• Expertise in Tableau Server Configuration, Administration and Cloud Deployment
• Expertise in Tableau Enterprise Scalability and Integration with existing Data Flow Architecture
• Involved in Deployment, Maintenance and Troubleshooting of Tableau Servers and integration with Teradata
• Development of best practices in development of Tableau Dashboards
• Involved and implemented various phases of testing’s such as integration testing, system testing, regression testing, performance testing, operational testing of the mappings, jobs and sessions are involved in extraction, transformation, and loading of data from source toDWH.
• IntegratedTableauinto Front-End Web Application usingJavaScriptAPI to call parameters and filters as well as individual sheets.
• Proficient in analysis, design and implementation ofdatawarehousing/ BI solutions usingTableau, Alteryx, Informatica, Micro Strategy,Tableauand Database technologies.
• Experienced in Optimization and Performance improvement of Tableau Workbooks
• Expertise in web integration of Tableau Reports with HTML or Asp.Net.
• Good usage of Tableau JavaScript API for performance improvement of web page.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Experience using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling and designed Data models using Erwin.
• Experience in developing SSAS Cubes, Dimensions and data source views and Deploying and Processing SSAS objects
• Experience with Data Movement and Governance tools for ETL and Data Quality purposes
• Good knowledge in SQL and coding PL/SQL Packages, Stored Procedures, Views, indexes, Function and database Triggers. Experience in using SQL*Plus, Toad 7.6.
• Expertise in migration and Transition of Business Objects Reports and Excel spreadsheets to Tableau frame work
• Mentored team members in developing, troubleshooting and maintaining the Tableau Dashboards on Desktop and Tableau Server
• Experience in Building / Enhancing Universes and creating Ad hoc Reports using Business Objects XI and Web Intelligence Modules.
• Worked on complete life cycles of projects including Gap Analysis, Blue Printing, Realization, Production Support, Testing Documentation, Requirement Analysis, Data Extraction, Data Modelling, Data Loading and Reporting and performed Installations. Administration with emphasis on upgrading, troubleshooting and day-to-day support.
• Highly experienced in Rational Unified Process frame work
• Skilled negotiator and team leader with a strong commitment to getting the job done right the first time with dedication to providing solutions rather than dwelling on problems.
• Demonstrated ability to effectively transfer knowledge to clients or team members and to create clear, concise documentation.

TECHNICAL SKILLS

Visualization Tools: Tableau Desktop 9.3/8.2/8.1/7 , Tableau Server 8.2/7, Tableau Reader

Business Intelligence Tools: QlikView 10 & 11, QlikSense, QlikView Server/Publisher 10 SR3

Databases: Oracle 10g/9i/8i, MS SQL Server 2000/2005, Teradata and IBM DB2

Servers: Application Servers (Tomcat), Web Servers (IIS, Apache)

Languages: PL/SQL, SQL, HTML, C, C++, Java

Environment: Windows XP/2000/2003/NT 4.0, UNIX, Sun Solaris

Front End Tools: MA Project, MS Office Suite (Word, Excel, PowerPoint, Visio)

ETL Tools: Informatica 8.6/9.1, SSIS, Data stage

Operating Systems: Windows XP/7/8/10, UNIX, iOS

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Tableau Admin/Developer

Responsibilities:

• Performed an evaluation of Tableau platform in the enterprise data architecture
• Collected, Analyzed and documented requirements specifications from the users to design a robust implementation plan
• Developed best practice guidelines for the Tableau platform in the development, troubleshooting and maintenance space
• Interacted with customers across multiple Lines of Business on a daily basis regarding Tableau Dashboard enhancements and troubleshooting of the various issues related with Tableau Desktop and Tableau Server
• Helped the team setup New physical servers for the Tableau Environment, Tested Workbooks and ramped up to 400 users on the Tableau server in less than 2 months
• Proficient in designing the Design Documents for loadingdataintoDataWarehouseandDataMart tables and creating reports from the same.
• Used SQL server andOracledatabase as source and destination data warehouse.
• Actively involved in the enterpriseDataWarehousedesigning using Kimball design methodologies and following DW Design Best Practices.
• Actively involved in creating a custom portal design hostingTableauworkbooks usingJava Script API.
• Was involved in Administration, User Security and setting up the template for Tableau Monitoring Dashboards
• Improvised existing Tableau workbooks by doing a performance analysis, performance monitoring and implementing the best practices in development of dashboards
• Designed a Proof of Concept around Tableau connectivity with Hadoop and other Big Data Sources
• Developed Tableau workbooks for regular Tableau Server Monitoring for users across multiple sites
• Regularly interacted with Tableau Consultants in developing a series of monitoring dashboards and visualization best practices
• UsedJavaScriptAPI to set and create filters, select and highlight elements in the view, and process the view to retrieve updateddata.
• Raised Incident tickets with Tableau Software for issue resolution
• Integrated Tableau with Teradata and created a Data Visualization and Analytics platform on Tableau
• Migrated 400 Users from a Virtual Tableau Platform to Physical Tableau platform for a Line of Business
• Integration ofTableaureports with Asp.Net web applications and usage ofJavaScriptAPIfor performance improvement.
• Helped with Tableau 9 Beta platform testing with customers in a classroom setting

Environment: Tableau 8.1/8.2, Oracle 10g/11g, MS SQL Server 2008, HP Quality Center, MS Office, JavaScript

Confidential, New York City, NY

Tableau Admin/Developer

Responsibilities:

• Led a team to upgrade Business Objects from 3.1 to 4.0 and integrate it with SQL Server System and Teradata.
• Involved in designing the BI Strategy and Implementation for the Confidential Accounting Resource System(STAARS) Project which focuses in bringing together all the various BI systems on one single Business Intelligence Platform-Tableau
• Performed Loading operation of historicaldatausing full load and incremental load into Enterprise DataWarehouse.
• Understand the Business requirements and convert into functional and technical specifications and developed maps for Extraction Transformation, Cleansing and Loading process ofDWto make the deliverables at appropriate time.
• Integrated Tableau with Teradata and created a Data Visualization and Analytics platform on Tableau
• Built Mobile Analytics Strategy on Tableau Reporting platform for State Users in the field
• Deployed Tableau on Cloud and Mobile for 2000 Users spread across different agencies of Confidential
• Expertise in Deployment, Configuration, Administration, Maintenance, Performance and troubleshooting of Tableau Servers and Development platform on an Enterprise wide scale
• Developed and Led a team of 6 developers in developing and maintaining Tableau Dash Boards for various agencies of the Confidential
• Managed ETL processes fordataextraction, staging, transformation, aggregation and loading of data to data warehouse checkingdataconsistency, cleanliness and accuracy.
• Developed training materials and Reference Documents on Developing Dashboards on Tableau desktop
• Trained Users of State Agencies on Dashboard development on Tableau in classroom and Virtual environment
• Develop and Recommend integration architecture for effective Tableau Deployment that minimize data redundancy and maximize “use in Place “Data
• Identified all the reports and Universes in Business Objects system to be migrated to Tableau and develop a project plan.
• Familiarity and Implementation with Tableau Best Practices
• Designed various dimension and Fact tables to migrate Legacydatafrom various sources to New Consolidated EnterpriseDataWarehouse.
• Involved in integration ofTableauJavaScriptAPIFilters in web application
• Defined best practices forTableaureport development
• Was involved in Budgeting, forecasting and resource planning for the project.
• Identified key Business intelligence processes and areas to be improved and submitted a strategy document to the client.

Environment: Tableau Server v8/v7, Excel, Oracle 11g, MS SQL Server 2008R2, JavaScript

Confidential, Altoona, PA

Tableau Developer

Responsibilities:

• Analyse Requirements and write technical specifications with the business analysts to develop Reports that conform to the enterprise standards.
• Evaluated and implemented of Tableau reporting solution with Teradata integration.
• Directly interviewed Management and stake holders to determine the correct blend of Business Information Services and Products to best support the business, documenting requirements, providing estimates, creating High Level Design and Detail Design Specifications
• Involved in Administration, Deployment and Maintenance of Tableau in an Enterprise wide Environment
• Expertise in User Configuration, Maintenance and Troubleshooting across the Tableau platform
• Involved in Process improvement and Delivery of BI Solutions to State Agencies
• Installed and configured environments for Test, Development and Production on Tableau on Tomcat-Apache Servers
• Worked on Data Modelling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modelling.
• Developed Dashboards and Scorecards using Tableau
• Deployed Tableau Enterprise Server on the Cloud
• Project rolled out within set timelines. Trained the users in creation and usage of Reports

Environment: Tableau Server v8/v7, Excel, Oracle 10g, MS SQL Server 2008

Confidential

SQL/Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in timelines, testing, and technical delivery.
• Worked closely with business 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
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, Customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Developed Tableau dashboards by using Teradata, Hadoop and Excel as data sources
• Creating Tabular, Matrix reports (crosstab orpivot), Charts and graphs as per customer requirements Using SSRS andPowerBI
• Created OLAP cubes usingSSASand created reports from the OLAP cubes using SSRS.
• Deployed SSRS Reports with SharePoint integration mode
• Published the developed dashboard, reports on theTableauServer so that the end users having access to the server and can view the data.
• Scheduled frequency and time to refresh data when sources are published or extracted to server.
• System administration and programming skills such as storage capacity management, performance tuning
• Used Cloudera Hadoop to setup, configuration and management of security, manage and monitor platform infrastructure
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPads, iPhones, and other smart mobile phones.
• Administering large scale Cloudera Hadoop environments build and support including design, cluster set up, performance tuning and monitoring in an enterprise environment
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau, Teradata, Teradata SQL Assistant, SSIS, SSAS, PG admin, SQL, PL/SQL, MS Project

Confidential

SQL Developer

Responsibilities:

• Interacted with the Business Users and Supervisors to gather business requirements.
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents.
• Identified the dimension, fact tables and designed thedatawarehouseusing star schema
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server 2005
• Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Designed ER diagrams (Physical and Logical using MS Visio) and mapping the data into database objects.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application Database Tables, along with checkpoints for testing verification.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Analyzed long running queries and tuned the complex queries to optimize application and system performance.
• Developed unit test cases and validated test results during user acceptance testing.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: MS SQL Server 2005/SQL Server 2008, SSRS Import & Export Data, SQL Reporting Services, MS Visio