Satya

Ph: +1-703-***-****

PROFESSIONAL SUMMARY

Over 7 years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.

Extensive experience in Tableau Desktop, Tableau Server, Tableau Reader and Public in various versions (10.x/9.x/8.x/7.x) of Tableau.

Expertise in Requirements gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.

Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.

Experience in gathering and writing detailed business requirements and translating them into technical specifications and design.

Strong understanding in Automation of backup and logs maintenance on Tableau server.

Experience in installing Tableau Server on both on-Premise as well as the Cloud, using Amazon EC2 instances in Amazon Web Services (AWS).

Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions.

Extensive experience in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.

Established Best Practices for Enterprise Tableau Environment and application intake and development processes.

Experience in creating different visualizations using Bars, Area, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps, Box and Whisker Plots, Highlight tables, and other making use of Calculated fields, Actions, Parameters, Sets, Quick, Context, and b according to the end user requirement.

Outstanding data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems and generating analytical reports/dashboards.

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations Expertise in using Trend Lines, Statistics, and Log Axes, Groups, Hierarchies, Sets to create detail level summary report and Dashboard using KPI's.

Expert in creating Calculations (Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Good experience on LOD expressions Comparative Sales Analysis, Customer Acquisitions, etc.

Hands on experience in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Strong experience in Trouble Shooting, Performance tuning of reports and resolving issues within source data and reports.

Expert in writing SQL Queries using joins, derived tables, sub-queries, correlated subqueries for validating data on reports and also for generating data extracts to suffice source data requirements in Tableau.

Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas.

Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

Demonstrated ability to self-motivate and be flexible within a fast-paced environment

TECHNICAL SKILLS

BI/Reporting Tools:

Tableau desktop 10.3, 9.3, 9.1,8.1.6, 8.0, 7.0, Tableau Server 7.0, 8.1.8, 8.3.2, 9.1, 9.3 OBIEE 10.1.3.3

Requirement Management

Requisite Pro, Microsoft Office

Front End Tools

Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

Document management

Visual Source Safe 6.0, Share point, Ultra Edit, Documentum

Defect management tool

Test Director, HP Quality center

Relational Databases

MS SQL Server, MYSQL server, Oracle, Teradata, Netezza, Kognitio.

Languages

SQL, PL/SQL, T-SQL, Python, HTML, XML, XSL.

Operating systems

Windows 7/XP, Windows Server 2012/2008, UNIX/Linux.

PROFESSIONAL EXPERIENCE

Prime Therapeutics, Eagan MN Oct 2016 - Till Date

Tableau Developer

Responsibilities:

Involved in reviewing business requirements and analyzing data sources from Apache Hive, Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Customized the Tableau Server Home page and designed own Reporting landing Page to give the user feel of a web portal.

Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.

Created dashboard using parameters, sets, groups and calculations.

Assisting users in creating and modifying worksheets and data visualization dashboards.

Created several types of visualizations using Sets, dynamic sorting etc.

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 Apache Hive, Oracle SQL Server and MS Excel.

Utilized Alteryx to integrate data from multiple databases into a DW data model.

Actively involved in testing new/upgraded features like new analysis tab, Level of Detail expressions, Data Interpreter, Split function, smart Geo maps, etc. in Tableau 9.0

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

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.

Involved in adding user’s to the Tableau Server and licensing the user’s based on their role in the project.

Created User Groups based on the user role in the Project and provided the Access to the Groups.

Created Different Schedules based on the requirement and used to create tasks to refresh and Subscriptions to the reports.

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 in Development Environment to make sure data was accurate as per the business requirements before moving the Reports to Production.

Worked on Tableau Server Customization to make user comfortable with look and feel of the portal by using Tableau Database.

Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau 9.x/8.x (Desktop/ Server), Hive, Alteryx, Oracle, SQL server, SQL, UNIX, SQL developer, CA Service Manager, Microsoft Office Suite (Word, Excel, PowerPoint)

BCBS, MA March 16 - Sept - 16

Tableau Developer/Administrator

Responsibilities:

Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.

Deployment of work books from one environment to the other environment through SFTP

Monitor the schedules and tasks on regular basis and also create schedule job based on the user request

Worked on the incident tickets raised by the user based their requirement

Applied row level security to the dashboard based on user specific groups

Involved in trouble shooting of performance issues which was associated with Tableau reports.

Utilized Tableau server to publish and share the reports with the business users. Also involved in administration tasks such as providing access to the users and adding them to the specific group.

Trained the users and helped them to improve and maintain their reports.

Training onsite team using and creating Tableau report.

Managing Testing cycle regarding the reports and dashboard utilizing onsite and in inshore resources.

Designing the Reports as per client Requirement and created the reports using database.

Working closely with the business users to gather requirements

Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.

Created Parameters to achieve desired functionality.

Implemented Binning & Blending concepts in my Tableau Reports.

Worked on Dual Axis concept while working with reports.

Created Filters, Groups, Sets on Tableau Reports.

Created and modified some of the existing reports and dashboards.

Publishing sheets and dashboards on server Using Tableau Desktop.

Created conditional filters and Action links to filter the data on dashboard.

Environments: Tableau Desktop, Tableau Server, Orcale, Teradata, excel, Windows Server 2003.

Teva Pharmaceuticals, West Chester, PA Nov 2014 – Feb 2016

Tableau Developer/ Administrator

Responsibilities:

Installed and configured Tableau Server and Tableau Desktop.

Upgraded Tableau Server from Tableau 8.1.6 to Tableau 8.3 and tested 9.0 BETA version.

Created a multilingual report for different region users with a workaround on the same sheet (for both server and reader), tableau software was impressed with the robust workaround and are now saving the workaround in their knowledge base.

Involved in POC’s with memsql Database, Kognitio Database to get the better performance on the workbooks.

Implemented security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication

Extensively Used Data Blending to Join Multiple Data Sources.

Experience in creating complex Dashboards using Parameters, Filters, Sets and Groups.

Created Custom Admin Views for the server Using Postgre SQL Database to track detailed view of usage, user activity, server activity etc.

Provided production and admin support of Tableau BI reporting solutions

Analyzed, troubleshoot and / or tune product performance or deployment issues when required

Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks as Tableau Administrator

Administered user, user groups, roles, permission setup, Management etc

Did performance turning in tableau to improve report response time.

Used transformations like SCD, CDC, Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all etc., to convert raw data into required data meeting the business requirements

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

Created ODBC connection, DSN to connect to Kognitio database since the native drivers doesn’t support

Created Forecasted Reports for the Upcoming Year to Observe Trends in Tableau

Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.

Monitored VizQL server, Application Server and data server activity to track performance and system stability.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.

Conducted Performance Testing and solved potential Bottlenecks.

Environment: Tableau Desktop 7.0, 8.1.6 Tableau server 7.0, 8.1.6, 8.3, MapR Hadoop Hive, IBM Netezza, Kognitio ODBC, Oracle DB, Teradata, Microsoft SQL Server, SQL, PL/SQL, T-SQL Microsoft Excel 2007, MS Access, Windows 07/08 server, Microsoft office 2007, Business objects 4.0.

Accenture, Pune, India August 2010 to Oct14

Data Analyst / BI Engineer

Project: 1

Responsibilities:

Involved in Data mapping specifications to create and execute detailed system test plans.

The datamapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.

Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.

Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.

Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

Responsible for different Data mapping activities from Source systems to EDW, ODS & data marts.

Created the test environment for Staging area, loading the Staging area with data from multiple sources.

Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.

Resolve the batch monitoring related issues with respect to purchasing module.

Followed company code standardization rule

Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed.

Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

Tested several stored procedures and wrote complex SQL syntax using case, having, connect by etc

Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure

Project: 2

Responsibilities:

Involved in gathering, analyzing, distilling and clearly conveying complex information to business and project team members through JAD sessions

Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements using RUP methodology

Conducted interviews and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions

Performed extensive Requirement Analysis including data analysis and gap analysis. Designed and developed project document templates based on SDLC methodology.

Analyzed the Business and System Requirements of the application. Interacted with user groups to derive the functional requirements

Extensively involved in analysis, Design and development of Data conversion, Data migration and Integration process and procedures

Worked with the database designer in data modeling through ER diagrams to identify tables, attributes and relationships between tables.

Involved in handling Source to Target Data Mapping, Technical Specs documentation, and ETL documentations such as Early Data Inventory, Data Profiling, Data Mapping, and Programmer Specs conforming to internal guidelines.

Managed data validation procedures, and identify/resolve data issues

Analyze the potential impact on users of automation of current data and processes, the movement towards standard data collection and reporting, and the implementation of data validation/verification practices to ensure data integrity.

Assisted Test Lead, Testers understanding business process and helped them for successful completion of Unit Testing, Integration Testing and Requirements Testing

Supported the production database in terms of facilitating the implementation of defect resolutions and minor functionality enhancements.

Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Participate in testing of procedures and data, utilizing PL/SQL, to ensure integrity and quality of data in data warehouse.

Created and Maintained Supporting documents (technical, business, project level and sops) to meet SDLC standards

Supported for executing data requests, custom reports, test scenarios, data migration, data analysis and quality assurance testing.

Ensured current testing practices met legal compliancy standards. Performed data integrity testing by executing SQL statements.

Contact this candidate