PROFESSIONAL EXPERIENCE:

• Around 6+ years of experience in Business Intelligence and DWH/Database Applications on multiple domains. Strong abilities and Hands on experience in analysis, design, testing, development.
• Proficient in managing all phases of data warehouse life cycle, including Requirement Analysis, Architecture, Design, Development, Testing, Implementation, Debugging, Production Support & Maintenance.
• Proven expertise in Data Analysis, Report Generation, Maintenance of Business Report Processes and Data Verifications and Validations.
• Interacted with Business and Subject Matter Experts to acquire functional business requirements and identify the Data set tables in order to build dashboards to satisfy the business's needs
• Facilitated cross - functional development of business rules, integration touch points, and use cases.
• Involved in understanding Business and data needs and analyze multiple data sources and document data mapping to meet the needs.
• Experienced with different Relational databases like Teradata, Oracle and SQL Server.
• Excellent Data Modeling experience in Star Schema, Snow-Flake Schema, FACT and Dimensions tables, Physical and logical data modeling and De-normalization techniques.
• Ability to write numerous SQL Queries, Stored procedures, triggers and performing ADHOC analysis.
• Optimized several SQL queries and reduced execution time from Hours to Minutes by using appropriate indexes and analyzing explain plans.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management
• Used respected native connectors for RDBMS databases to perform extracts and data preparation for Tableau to create dashboards
• Proficient in design and development of various worksheets and data visualization dashboards, reports utilizing Tableau Visualizations like Bars, Lines and Pies, Scatter plots, Gantts, Bubbles, Bullets, Heat maps and Highlight tables, geographic visualization
• Expertise in designing and creating various Data Visualization Dashboards, Scorecards and analytical reports to help users to identify critical KPIs and facilitate strategic planning in the organization
• Expertise in Identifying the need and use of Actions (Filter, URL and Highlight) according to the end user requirement
• Expertise in designing and creating various Data Visualization Dashboards, Scorecards (Using Crosstabs) and analytical reports to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects etc. in Tableau desktop/Server.
• Expertise in Performance Tuning of Tableau Dashboards to reduce Rendering time
• Technical hands-on experience using Tableau components like Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views
• Created Row-level (Data), Object-level (Roles an Permissions) and Access-level (Authentication) security and report schedules on Tableau server.
• Identified the right dataset and provided extract filters to retrieve the limited dataset to Tableau layer
• Experience with Business Objects modules like Universe Designer, Web Intelligence, Crystal Reports, Import Wizard, Migration Wizard, Dashboard Manager, Publishing Wizard, Central Management console and Xcelsius dashboards
• Prepared different highly formatted financial reports such as consolidated income statements and balance sheets using Crystal Report and Ad-hoc reports using Web Intelligence.
• Good experience in Production Support, Identifying root causes, Trouble shooting and Submitting Change Controls
• Excellent ability with competitive spirit in finding various approaches for problem solving and highly skillful, creative and innovative in developing efficient logic/code.

TECHNICAL SKILLS:

Data Visualization Tools: Tableau Desktop/ Server 9.1/9.0/8.3/8.1 , Tableau Reader/Public

Reporting Tools: Business Objects BI 4.0, Web Intelligence/ Info View, Universe Designer

Database: Oracle 9i/10g/11g, MS SQL Server 2003/2005, Teradata

PROFESSIONAL EXPERIENCE:

Confidential, Saline MI

Tableau Developer

Environment: Tableau (Desktop, Server 9.0/9.1, MS SQL Server 2012, Teradata 14

Responsibilities:

• Interacted with Business users to understand their requirements and handled Analysis, Design and Development Phases starting from SQL query building, report development, performance tuning and production rollout for every report of Information Technology Department.
• Analyzed the source system to understand the data and table of multiple subject areas.
• Analyzed and designed the data visualizations using Tableau and provided insight on data visualization and Tableau dashboard design best practices
• Used Python to validate data between multiple environments to ensure data quality
• Used Pandas library in Python to build data quality checks
• Worked on Numerous Ad-hoc Data Pull requests from Business Analyst, BSA and Financial Analyst.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Good SQL Server developer skills in creating/modifying Tables, Materialized Views, SQL joins and other query writing as part of Project requirements
• Knowledgeable in creating Indexes to improve the performance of the SQL queries.
• Extensively worked on optimization and performance tuning of several complex SQL queries.
• Developed various dashboards, used context filters and sets to handle huge volumes of data.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created side-by-side bars, Bar on bar, Bar line combined chart, Heat Maps, Trending charts and Waterfall charts according to deliverable specifications.
• Effectively used data blending feature in tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu options and Parameterized using Tableau.
• Created dashboards for weekly, monthly, daily reports using Tableau desktop & published them to server.
• Executed and tested required queries and reports before publishing.
• Built, published customized interactive reports and dashboards, report scheduling using Tableau server.
• Published Tableau files to Tableau Server
• Define best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Connected to Teradata and SQL Server using native connectors within Tableau and performed data extract and data preparations
• Performed tuning of performance to reduce the Tableau rendering time both at report and database level.

Confidential, Jersey city NJ

Tableau Developer

Environment: Tableau 10.x, Tableau 9.x, SQL Server- 2008/2012/2016 , Oracle Database, BI Applications.

Responsibilities:

• Coordinating and conducting business, systems requirements’ meetings with the business users and the project managers.
• Creating Proof of Concepts for the initial requirements and getting feedback from the business users.
• Developing the dashboards using multiple data sources by Data blending.
• Migrated all the tableau dashboards to Tableau 10 after extensive testing of all the features and functionalities.
• Involved in administration tasks such as setting different kinds of permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Optimizing the existing dashboard performance.
• Migrating the legacy excel dashboards to Tableau dashboards with additional improvement.
• Publishing dashboards to the production server and resolving any encountered issues.
• Following the consistency and design patterns for all the developed dashboards.
• Supporting the business users in their issues with the dashboards.
• Training the business users about the Tableau usage from the scratch.
• Creating refreshes for the dashboards on a regular basis and monitoring them.

Confidential, San Jose, CA

Tableau Developer

Environment: MS SQL Server 2012/2008/2005 , Windows 2003 Server, Tableau Desktop (8 and 9), Tableau Server, Tableau Reader.

Responsibilities:

• Involved in creating interactive dashboards and applied actions (filter, highlight and URL) to dashboard
• Gathered reports requirement and collaborated with users, asking users exactly what they are looking for and communicated with technical and non-technical users.
• Worked with Data cleansing for Analysis and Visualization since we are getting lots of data we need to work on it and get what we need, worked with different Data cleansing tools.
• Created POC dashboard ad generated some interaction dashboards. Configured interaction dashboard with drilldown capabilities using global and local filter
• Created histograms, pie charts, box plots, scatter plots for inventory management background maps illustrating the total value change with respect to several weeks ago data.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• Creating Data blending in case of merging two different datasets-using tableau.
• Developed automated dashboard with Trend Lines, Reference Lines and statistical techniques to describe the data, created calculations like string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Validated the created dashboard with comparing of data in dashboard with the data we have.
• Published Workbooks by creating user filters so that only appropriate teams could view it.
• Used excel sheet, flat files, CSV files to generated Tableau ad hoc reports.
• Trained end users on working with tableau how to pass the values in parameters

Confidential, Vijayawada, IND

Business Objects Developer

Environment: Web Intelligence 4.0, Universe (IDT), Teradata, Oracle 10g, SQL Assistant, Toad

Responsibilities:

• Conducting meetings with the data architects to understand the source system elements
• Responsible for gathering business requirements from cross-functional teams, worked directly with business units to define requirements and support various business initiatives and projects as it relates to analytics and reporting
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Created Tables, Views and other SQL joins per the business requirements.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Created Objects using different Business Objects functionalities like @ prompt, @variable, @select in the process of designing the universes.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Provided post implementation production support.
• Involved in troubleshooting the production issues and providing production support.