SUMMARY

• Over 10 years of IT experience in Teradata, Informatica, Tableau Desktop and Server, SQL Server Integration Services (SSIS). Proficient in creating rich visualizations using Tableau Desktop.
• Ability to Lead the Data Visualization Analysis, Design and Efforts and Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized dashboards using Tableau Desktop.
• Extensive knowledge in various reporting objects like Hierarchies, filters, calculated fields, Sets, Groups, Parameters and Dashboard Actions etc.. in Tableau Dashboard Design.
• Building and publishing customized interactive reports and dashboards, report scheduling using Tableau server and using SSIS to extract and transform data.
• Experience in working on generating various dashboards to Tableau Server using different data sources such as Teradata, Oracle, SAS datasets, MS Excel etc.
• Experience in Tableau admin roles such as managing user roles; create/manage groups, workbooks and Projects.
• Knowledge in Development of Big Data Projects using Hadoop and Hive.
• Experience in performing Data analysis using Hive.
• Knowledge on monitoring server activities/usage statistics to identify possible performance issues.
• Expertise in Data Blending concepts in Tableau Desktop and creating/Publishing interactive dashboards.
• Experience in Generating Tableau Dashboard with quick/context/global filters on Tableau (8.0 / 9.1/9.3) reports.
• Experience in providing Tableau desktop support to the business end users such as usage policies.
• Experience in developing Teradata databases, manipulating data and making change to dimensions in databases using Teradata Utilities
• Expertise in maintaining data quality, data organization, metadata and data profiling.
• Experience in Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Extensively worked with large database Teradata in Development, Test and Production environments.
• Participated in complete life cycle (SDLC) implementation of an Enterprise Data Warehouse and data mart.
• Good understanding of the business rules completely based on High Level document specifications and implementation of the data transformation methodologies.
• Strong business understanding of verticals like Banking, Manufacturing and Pharmaceuticals.
• Ability to meet deadlines and handle multiple tasks, team player, motivated, able to grasp things quickly with analytical and problem solving skills.
• Inclination towards learning new technologies and tools.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, Tableau Server, Tableau Reader, MSBI, Qlikview, Looker.

Operating System: Windows, Unix, Linux.

Bug Tracking Tool: JIRA, HPALM, Asana, Trello

Web Technologies: HTML, CSS, Java Script, Power Shell script.

Database: Oracle, MS SQL, DB2, MySQL, PostgreSQL, Hadoop Hive,, Teradata.

PROFESSIONAL EXPERIENCE

Confidential, Oakland, CA

Tableau Administration/Developer

Environment: Oracle sales force, Hadoop Hive, Postgre, Windows server R2 Enterprise.

Responsibilities:

• Defined tableau standards, best practices for design and development performance considerations.
• Worked on Tableau server, administrative functions, installation, configuration, back up of servers and load Balancing techniques.
• Development and maintenance of enterprise - level analytic solutions. Member of Business Intelligence and Analytics team, multidimensional structures and analytic dashboards. Professional experience with Tableau.
• BI / Data visualization framework and design best practices.
• Designed and developed Tableau Work books, dashboards, Stories.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring high- level data analysis and data management services.
• Responsible for creating sites, projects, user permissions, groups on the web server.
• Responsible for load optimization.
• Create Data source using HDFS (Hadoop Distributed File System).
• Create action filters, parameters and calculations for preparing dashboards and worksheets in Tableau
• Continuous monitoring of tableau server for user availability and refreshes schedule.
• Created custom admin views for monitoring the usage of server and users in addition to pre-built administrative views available on maintenance page.
• Involved in supporting performance-testing team in testing the performance of tableau servers and workbooks.
• Extensively used data blending techniques in dashboard development.
• Supported different user group and business domains.
• Providing tableau Demo's to new on boarding users.
• Defined architecture for Tableau- establish Dev/QA/Prod mount environments
• Setup new projects, security groups, roles and administer users for all supported platforms.
• Migrate the Data sources from QA To Production server.
• Migrate the workbooks and dashboards from QA To Production server.
• Add or update the Batch file for data sources refreshes.
• Replace data sources from old data source to latest data sources Replace the work books from QA server to Production.
• Providing Tableau Demo's to new on boarding users.
• Maintain the data source auto schedules process on Tableau web server.
• Involved in Production support for Business users.

Confidential

Sr.Tableau Developer

Environment: Oracle 11G, MS SQL Server 2012,Tableau 9.1.

Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• Created Interactive Dashboard, worksheets using Tableau with primary and secondary data sources using data blending where primary and secondary data sources linked by specified relationships.
• Create action filters, parameters and calculations for preparing dashboards and worksheets in Tableau
• Hands - on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing workbooks using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Working on generating various dashboards in Tableau server using various sources such as SQL, BD2.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated

Confidential

BI QlikView Developer

Environment: Qlikview 11.0, MS-Access, SharePoint, SQL.

Responsibilities:

• Actively involved in requirement gathering sessions with business analysts, business stakeholders, Subject Matter Experts (SME), developers and sponsors. Invloved in complete SDLC life cycle.
• Design, develop and deploy business intelligence presentation layer solutions in the provider healthcare market focused on analytics and reporting components such as dashboards, scorecards, reports.
• Held timely meetings with Solution Architect, Business Analysts, and Banking Subject Matter Experts to prototype, design and develop solutions to meet requirements.
• Created Dashboards style of reports using QlikView components like ListBox, Slider, Buttons, Charts, and Bookmarks etc.
• Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports more user - friendly in analysis purposes.
• Created daily, weekly, monthly and quarterly reports for the management team based on the Customer requirements.
• Developed Set Analysis to provide custom functionality in QlikView applications.
• Adopted Scrum methodology in the system development process.
• Worked closely with the development team to understand functionality, resolve issues and provided feedback.
• Successfully performed User Acceptance Testing ( UAT) before releasing to Production environment.
• Extensively used SQL scripts for data mapping and querying.
• Developed data mapping procedures ETL - Data Extraction, Data Analysis and Loading process of collected data from mentioned data source.
• Designed business intelligence dashboards using QlikView (Desktop/Server), allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Very good knowledge in handling and troubleshooting the Qlikview Issues.

Confidential

Tableau Developer

Environment: Teradata 14, Teradata SQL assistant, BTEQ, MLOAD, Fast Export, Informatica 9.5 and Tableau 8.0/9.1..

Responsibilities:

• Primarily responsible to deliver the Technical specification document, data flow diagrams, design specs, Unit test documents and other relevant documentation.
• Tested, Cleaned, and Standardized Data to meet the business standards using Execute SQL task, Conditional Split, Data Conversion, and Derived column in different environments.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and Teradata Databases.
• Designed SDAs (Strategic Data Assets) as per the requirements from the CBI users and created in the form of Views, Tables and Join Index.
• Designed dashboards by extracting from different Sources using parameters, sets, groups and calculations and deploying them to the Tableau Server environment.
• Designed interactive dashboard and applied actions (filters and highlights) to the Existing dashboards in order to achieve the better Performance.
• Created calculated fields, mapping, hierarchies and Drill through Reports by extracting the Data from Teradata and Oracle data sources.
• Worked closely with Market Managers to Design reports/dashboards using tableau desktop and Created Heat Maps showing current subscribers by color that were broken into regions allowing business user for Various Analysis.
• Hands on experience in Data Blending to merge Various Sources like Teradata, Oracle and Excel Files.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Involved in creating dual-axis bar charts, Blended Axis charts with multiple measures and ETL of data directly from different source systems like flat files, Excel, Oracle and Teradata and Designing the Dashboards on Tableau server.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Monitoring Tableau server activities to identify possible performance issues and working on performance improvement of Dashboards by creating data extracts or tuning the database objects such as Tables, Views and stored Procedures.
• Tableau server/Desktop configuration and Installation, updated server architecture for scheduling tasks and preparing backups using Tabadmin and Tabcmd commands.
• Formulation of procedures for installation and configuration of Tableau desktop.

Confidential

Tableau Admin

Environment: Environment: Tableau Desktop, Tableau server, Oracle SQL Server R2, Windows 7, MS Excel, MS Office Suite

Responsibilities:

• Understand Requirement, Analyzing Systems and Source Databases.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Used Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.
• Independently worked on owning IT support tasks related to Tableau Reports on Server.
• 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.
• Used parameters and input controls to give users control over certain values.
• Joining tables from different views to tableau and publishing the data source in the server for developing the tableau reports.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Create the public objects like metrics, filters, prompts, custom groups, consolidation and reports.
• Created individual Worksheets and incorporated it into Dashboards with the appropriate filters
• Created the calculated fields and parameters along with the appropriate filters and plotted the measures on the respective graphs with the base data.
• Analyzed the database tables and created database views based on the columns needed.
• Published dashboards to Tableau server.
• Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing & Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services
• (SSRS).
• Representing data using the visualizations such using Charts
• Scheduled data extracts on a daily basis.
• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
• Creating and modifying Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Deploying and publishing Tableau applications on server.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images and Maps.
• Created context filters to limit data sourced into tableau engine.
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Published dashboards on Tableau server for the user community to access through web portal.

Confidential

Tableau Developer

Environment: Tableau Desktop, Tableau Server, PostgreSQL, SQL Server, Windows 7, MS Office 2010, MS Access.

Responsibilities:

• Involved in the requirement gathering, analysis and documentation of functional and technical specification documents.
• Created dimensional data models, conceptual, physical and logical data models using Erwin to load data to dimensional and fact tables.
• Developed ETL Informatica mappings to load incremental data by applying Change Data Capture mechanism using Power Exchange navigator.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Scheduled data extracts on a daily basis.