PROFESSIONAL SUMMARY:

• Over 8+ years of total IT experience in Analysis of data, designing the data, Development of structured data, Documentation and Implementation of Business Intelligence applications.
• Over 4 years of experience in designing, developing and publishing of Tableau Applications.
• Wide - ranging experience in TableauDesktop andTableauServer in various versions ofTableau9.0,9.1,9.2/8.0,8.,8.,8.3/7.0 product suite (Desktop, Server, Public).
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Histograms, Bullets, Heat maps, scatter plots, Gantts, Bubbles, Dual Axis, Box Plots, Tree maps, and Highlight tables.
• Extensive knowledge in various reporting objects like Hierarchies, Transformations, filters, calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Extensive experience on building dashboards usingTableau Desktop.
• Scheduling the reports in Tableauserver.
• Created, defined and optimized data sets for visualizations. And found many ways to improve data visualization capabilities.
• Deploying interactive Dashboards, data Visualizations and Story.
• Extensive usage of Data Blending multiple data sources into a single dashboard.
• Extensive experience on using functions like Discrete, Table down, Table across, Pane Down.
• Experienced in Data warehouse modelling to create source data model and Star schema for Data warehouse.
• To define and get a reporting data view models, worked with data warehouse developers.
• Adaptive to the changing environment.
• Good understanding On Web based Analytics and Reporting.
• Generated tableau dashboards with forecast and reference lines.
• Outstanding team player with excellent problem-solving skills with good interpersonal and excellent business communication skills and the ability to work in a team or as an individual.
• Experience working with advancedTableaufeatures like LOD expressions.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization.
• Effective independent worker and a team player.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop, Server, QlikView11 (Trained), MS Excel, MS Office,MS Access

Databases: Oracle, MS SQL Server, MYSQL Server, Oracle, DB2, MS Access.

Tools and Packages: Word, Excel, PPT, SQL Server Management Studio, Microsoft Visual Studio

Operating Systems: Windows …, UNIX, LINUX

Languages: SQL, PL/SQL, C, C++, HTML, XML.

PROFESSIONAL EXPERIENCE

Confidential, Berkeley Heights, NJ

Tableau Developer

Key Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Analyzed the metric dashboards and identified the formulas and functionality of the dashboards and digitizing the metric dashboards toTableauapplication.
• Found efficient ways to maintain the accuracy of the core information content that is being communicated, while at the same time presenting graphs and tables visually, and aesthetically,
• Created interactive dashboards by combining views inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• UtilizedTableauvisual analytics and best practices like performance improvement, Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and of complex dashboards/reports.
• Developed Cross Tab, Chart, Line, and Drill down through worksheets inTableau.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Developed PL/SQL stored procedures to load data warehouse tables
• Implemented Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Groups, hierarchies.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets. Designed and published customized interactive dashboards.
• Had a knowledge of practicing work in agile development environment.
• Used data blending, filters, parameters, sets, groups etc.
• Generated dashboards using dual axis for comparison.
• Provided Training to different business users to develop dashboards in workspace and workspace advanced.

Environment: TableauDesktop &TableauServer 8.x, 9.x, Tableau API, MS Excel, SQL analysis service cubes.

Confidential, Edison, NJ

Tableau Developer

Responsibilities:

• Played a key role in gathering and documenting Business requirements and conducted requirement walk-through meetings with key stakeholders.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up), crosstab etc. using Tableau.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Created visualizations inTableauusing Excel data extract source.
• Worked and coordinated with other team members from the Data Warehouse team and also with the Data Exchange team to make sure we meet client deliverable deadlines.
• Demonstrating proficiency in writing and editing materials, including all types of digital and online products such as blog posts, statements, reports, and presentations
• Evaluating and reporting on the reach and impact of media activities through regular monitoring and reporting.
• 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.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Learned BI tools like qlikview and DOMO.
• Implemented digital campaigns, review and analyze their effectiveness, and make suggestions and adjustments as needed by checking in with clients
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Hands-on development assisting users in creating and modifying worksheets and data visualization Dashboards.
• Effectively used data blending, data joins and Level of Detail Expressions.

Environment: Tableau Desktop &TableauServer 7.x, 8.0, 8.1, 8.2, Teradata, SQL Server database, Windows, MS office Suite, NoSql.

Confidential, Chicago, IL

TableauAnalyst

Key Responsibilities:

• Analyzed and understood the process flow to provide solution for the proposed requirement change.
• Worked with end users to understand the requirements, layout, and guidelines of the application to be developed.
• Created quick filters to narrow down revenue generation by states and cities.
• Worked on generating various dashboards inTableauserver using various sources like Teradata.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across theTableauBI suite.
• Provided support forTableaudeveloped objects and understand tool administration.
• Worked upon full range ofTableauplatform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Created adhoc reports to users inTableauby connecting various data sources.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Generated context filters and used performance actions while handling huge volume of data.
• Generatedtableaudashboards for sales with forecast and reference lines.
• Interacted extensively with offshore development team to make sure that the developed system matches the requirements.
• Created URL Actions to navigate from one Dashboard visual to another visual opened in a new browser window using separate TDE.
• Effectively used data blending feature inTableau.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.

Confidential, Bridgewater, NJ

Qlikview Developer

Responsibilities:

• Involved in creating Dashboards using Qlik Sense, Qlikview, Tableau.
• Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input toTableau.
• Created visually compelling and actionable interactive worksheets and dashboards.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Involved in creating a dual-axis bar chart with multiple measures.
• CreatedTableauvisualizations by connecting to various Data Sources Relational Databases (Oracle, SQL Server).
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• ConductedTableauuser training, analyze business process, gather requirements, and bridge the needs of the business with the use ofTableauvisual analytics and systems best practice.
• Created Tableau reports based on existing Excel reports.
• Expertise in ETL (Extraction, Transformation and Loading), Data modeling and Report designing using QlikSense and QlikView.
• Prototyping different dashboards in QlikView for different areas which helps in evaluating the tool for particular reporting
• Working upon performance tuning, Trouble shooting and support of existing system.
• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development and testing projects within Tableau Desktop.
• Created Tableau extract files for improving the performance.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.

Environment: TableauDesktop & TableauServer 5.x, 6.x, Microsoft Excel.

Confidential, Memphis, TN

BI Developer

Key Responsibilities:

• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Extracted the data from various data sources such as databases, CSV files, and Excel documents and load the data so that it is available for analyzing and creating dashboards.
• Performed 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.
• Designed and developed many complex reports based on the requirements using complex calculations like Row-level calculations, aggregate calculations, filter Actions, URL actions, filters, trend lines, forecast lines.
• Performed Technical documentation with the concepts of various business processes integration.
• Reviewed Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Communicated with offshore team in the US to track progress on a daily basis.
• Prepared use cases and test cases and help in realizing the use cases in the implemented application.
• Formalized the reporting process by creating the technical specification and requirement specification.
• Experience with Sorting, Building Groups and using in visualizations.
• In order to improve the performance of thetableaudesktop EXTRACT connection is used to get the data intoTableaudata engine for faster retrieval of data. If the database is fast enough to retrieve the data then we usually go for LIVE connection.

Environment:. Windows 7, UNIX, Microsoft (Word, Access, Excel, Outlook), MS-VISIO, MS-Project. .

Confidential, Chicago, IL

BI Consultant

Key Responsibilities:

• Gathered User requirements and reviewed them from a technical perspective and conducted meetings with end users to establish business rules, schedule deliverables and identify potential issues that could impact the development effort.
• Performed Unit testing for all the designed and developed jobs and writing test cases.
• Oversaw activities for a portfolio consisting of fixed income, equity, currency and commodity derivative products.
• Deployed and scheduled the consolidated rapid mart job and other Data Services jobs.
• Generated test data and tested the database to meet the functionalities/deliverables in the project documentation and specifications.
• Conducted Research and Analytics using complex valuation models focusing on Derivatives and Fixed Income, and oversaw process for pricing.
• Designed process functionalities for Quarterly audits.
• Designed Syndicated Data reports for internal drug intelligence database.
• Delivered Software functionalities for Global Data Integrated Platform.
• Controlled the base metal commodity derivatives books.
• Maintaining the trade settlement flows for a series of complex derivative products.
• Collected data from various journals and giving meaning to the data by analyzing and structuring.
• Created reports Using Quick table calculations and business calculations like Year over Year growth, Running Total, Rank etc.
• Handled Complex Queries as separate Query Subjects.
• Updated various database changes into the Framework manger model.
• Worked with Sales and Distribution Team to develop better client demonstrations.
• Provided Training to different business users to develop dashboards in workspace and workspace advanced.

Environment: Oracle, SQL Server, Windows Vista, Unix, MS Excel, MS Access.