SUMMARY

• Over 7+ years of experience in Information Technology in designing, developing, architecture, administration and implementation of Business Intelligence, Data Warehouse Applications under different environments.
• Core focus on Data Warehousing OLAP tools, BI and PL/SQL.
• 3+ years of Experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and Dashboards using feature such as Data Blending
• Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• Extensive experience in working with Tableau 9.2 Workbook sheets and Dashboards.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Proficient in design and development of various dashboards, reports utilizing Tableau
• Visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive charts, graphs, and other user interface elements.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Improved Reports performance in tableau using extracts and context filter.
• Expertise in Tableau v9.x/8.x.
• Involved in Tableau Server installation, configuration, creating Users, Groups, Projects and assign Privileges etc.,
• Created Global Prompts which can be used across dashboards with default values.
• Expert in creation of dimension and fact tables, logical columns, hierarchies, level based measures in Business model& mapping layer.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Involved in importing Source Tables from the different databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.

TECHNICAL SKILLS

Tableau: Tableau Desktop v8.x/7.x, Tableau Server, Tableau Admin.

Hardware & Operating Systems: Windows 7/XP/2003/2000/NT

Databases: T-SQL, SQL Server - 2000, 2005 and 7.0, PL-SQL, Oracle 8, 9i,10g and MS Access

Other Tools: ERWIN, Autosys, SQL Loader

Programming Languages: C, .NET, Java, SQL, XML, COBOL

Software Packages: MS Office Suite, MS Project

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer/BI Analyst

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications.
• Prepare dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Designed, Developed and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Generate context filters and use performance actions while handling huge volume of data.
• Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.
• Monitored user activity on a weekly basis for benchmarking adaptability and usability of reports.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.

Environment: Tableau (Desktop/Server), SQL Server, Java API, Microsoft office Suite (Word, Excel, PowerPoint)

Confidential, GA

Tableau Developer/BI Analyst

Responsibilities:

• Involved in requirement s gathering for the development in Tableau
• Worked with SAP BW team to understand the data extensively
• Involved in building financial reports in Tableau so as to have nice look and feel.
• Worked both on Tableau Desktop and Tableau Server
• Involved in almost most of the concepts in tableau like sets, grouping, parameters, highlight actions,
• Involved in data blending with dummy data to have perfect alignment of rows and columns
• Created static customer list as per the requirement
• Worked on Agile Environment.

Environment: Tableau Desktop v8.x/7.x, Tableau Server, Tableau Admin, SQL Server, T-SQL, SQL Server Management Studio, MS Excel, MS Access.

Confidential, St Louis, MO

Tableau Developer/BI Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form 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.
• Created Heat Map showing current services by color that was broken into regions allowing business user to understand..
• Projected and forecasted future growth in terms of number of subscribers developing Area Maps to show details at the county level.
• 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 Oracle, Teradata and MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• 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 Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Involved in importing Source Tables from the different databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• 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.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop v8.x/7.x, Reader, SQL Server 2005, Windows 2000 Server, MS Excel, MS Access.

Confidential

Report Analyst

Responsibilities:

• Good analytical ability to review the trends based on analysis of past financial reports.
• Keep an effective track record of the financial conditions in the current scenario.
• Provided the required information, reports and schedules to the auditors.
• Developed reports, which are connected to Excel database source.
• Developed reports, interactive dashboards and internal procedures.
• Ensured integrity of data in reporting systems and resolved discrepancies.

Environment: BEA-WebLogic Server, Oracle 10G, JDK 1.5, ERWIN, Autosys, SQL Loader.

Confidential

Reporting Analyst

Responsibilities:

• Developed, analyzed and managed reporting requirements for new clients and reporting enhancements for existing clients.
• Modify Reports content and export Reports in multiple formats (Excel, .CSV, tab separated PDF, .RPT etc) based on user input.
• Worked on performance tuning of all the reports before moving them into production.
• Have sent the Status Report (Daily, Weekly etc.) to the Client
• Attended the regular client call and discussed the weekly status with the client.
• Provided data analysis from both within and outside of department.
• Developed reports, interactive dashboards and internal procedures.
• Coordinated with technical teams for research and evaluation of healthcare and operational problems.
• Participated in critical review and revision of existing systems for updates and enhancements.
• Tracked and reported upon development activities, required resources, defects reworked and their status, performance baselines
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports usingSSRS.
• Worked with the client directly to understand the requirements clearly and to update the daily status of work
• Published the Reports onto server and scheduled the reports to run monthly, quarterly, weekly, daily.
• Prepared strategic trend reports to measure KPI, Increased leadership focus on key Performance Indicator

Environment: Asp.Net, SQL, SQL Reporting, Autosys, MS Excel Reporting, Windows, Legacy systems

Confidential

Technical Associate - Reporting

Responsibilities:

• Implementation of the system according to the customer requirement.
• Adding new ATMs in the network as and when new ATM’s are installed
• Used to generated reports for the online payment bills such as TTD and Shirdi temple payments.
• Used to generate the report monthly, quarterly, weekly, daily for the ATM’s which are not working.
• Generating the report for the CMS indicating the downtime of the ATM’s it took to get the Problem rectified.
• Report on PINS and ATM cards generation
• Ensured integrity of data in reporting systems and resolved discrepancies.
• Maintained reports for clients, trustees, custodians and record keepers.
• Prepared and developed ATM Cash Replenish report analysis in zone wise.
• Formulated short/long-term plans and key objectives. Worked out measurable plans of action to ensure success.
• Provided comprehensive reports for client companies interested in determining presence across the marketplace.
• Designed new queries and utilized existing query models to draw relevant customer information for development of financial reports utilized in forecasting, trending, and results analysis.

Environment: Oracle, PL/SQL, Oracle Forms & Reports, MS Access Reporting, MS Excel Reporting, Windows, Legacy systems