SUMMARY

• 8 years of professional experience in the Information Technology field and a Master’s Degree holder in Computer Science. Exceptional understanding of Business Intelligence and Data Warehousing concepts.
• Have worked with top notch Data Visualization. Reporting and ETL tools in the industry. Passionate about delivering value to customers through data analytics.
• Well Versed with all facets of Tableau 8/9/10 versions. Possess strong acumen in conveying the story inside data with visualizations. 5+ years of data visualization experience using Tableau.
• Experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships.
• Recommending Dashboards per Tableau visualization features and delivering reports to Business team on timely manner.
• Successfully upgraded Tableau platforms in clustered environment and performed content Upgrades.
• Familiarity with Tableau's JavaScript API and performance & load testing with Tabjolt.
• Received multiple customer awards for my work in Tableau and BI in general.
• Worked as aLead Developer and Admin for SAP Business Objects reporting platform with a user base of more than 500.
• Possess Advanced query (SQL) experience across multiple database platforms.
• Advanced experience with ETL tools such as Informatica & Alteryx
• Strong programming skills in Perl, & Python & exposure to the Hadoop Ecosystem.
• Strong experience in interacting with stakeholders/customers and gathering requirements. Exposure to both Agile and Waterfall methodologies.
• Pro - active team player, sound managerial skills and accomplished leadership qualities.
• Experience working with Clickstream Data to perform web analytics.

TECHNICAL SKILLS

Databases: Oracle, MS SQL Server, MS Access, Sybase,Teradata

Data Modeling: Erwin Data Modeler r7.3/4.x (ERD), MS Visio 2000

Languages: Perl, Python, SQL, Oracle PL/SQL, JavaScript

Operating Systems: Windows NT, Windows 95/98/00/xp, Linux, Unix

BI Tools: Tableau Desktop 8/9/10, SAP Business Objects, Informatica, Alteryx, SSRS, SSIS, Pentaho

PROFESSIONAL EXPERIENCE

Confidential - Durham,NC

Sr. Tableau Consultant/ Data Analyst

Responsibilities:

• Played the role of a Data Architect as well as Lead Tableau developer for the Project Management Office (PMO) of Confidential .
• Designed dashboards in Tableau combining multiple data sources. Some sources include Hadoop, Oracle, SQL Server, DB2, Excel Sheets etc
• Developed visualizations showing Actuals, Forecast and health status of projects from across the organization. These dashboards were used to drive key decisions across organization by senior management.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Histogram, Pie Charts, box/scatter plot, time series graph was used to show Project metrics. Backgrounds maps were used to project Resource level data and the amount of resources assigned to projects from different countries.
• Created efficient data extracts for use by other Tableau developers/Business users. I also trained them periodically on tableau and how to use it best achieve their goals.
• Developed dashboards with interactive views, trends and drill downs.
• Used Dynamic Availability feature where in the worksheets on the dashboards were connected by Actions and this provided an interactive reporting environment to the end user.
• Optimized load times on even complex dashboards by various techniques.
• Used Data Blending feature extensively. Created complex calculated fields according to business logic, field actions, sets, parameters and groups to compare and analyze data in different perspectives.
• Performed the role of a Tableau Admin. Worked with Tableau configuration as well as addition and modification of new users and user groups. Also used row level security and user filters for restricting data access.
• Managed data connections, task scheduling and exporting views to the tableau server.
• Performed Tableau Integration with JavaScript API and embedded the dashboard onto webpages for Fidelity internal site.
• Used Tabjolt to do performance and load testing on Tableau Server.
• Creating, Modifying Oracle PL/SQL procs, functions, views on in house Oracle Database were required as well developing a validation plan to ensure consistency.
• Created scripts in Perl and Python as well as used Informatica for ETL processes.
• Perform Database SQL tuning and query optimization tools like Explain Plan.
• Responsible for designing, building, and testing several complex workflows in Alteryx .
• Used Alteryx to publish TDEs to the tableau server.
• Resolved Alteryx production root cause issues. Also performed maintenance, enhancements, performance tuning of code in Alteryx.

Environment: Tableau Desktop 9/10, Tableau Server, Alteryx, Informatica, Windows 7, PL/SQL developer, Sybase, Oracle, SQL Server, Erwin, SSRS, SSIS, Teradata, Agile/Scrum development methodology

Confidential - Durham,NC

Business Intelligence Developer

Responsibilities:

• 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.
• 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
• Converted existing OBIEE and excel reports to tableau dashboards
• Interacted with Business Analyst, data Modelers in understanding the Analytics report requirements
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Developed, Organized, managed and maintained graphs, tables and document templates for the efficient creation of reports.
• Developed Tableau data visualization using cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Created custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.
• Experience in standardizing Tableau for shared service deployment
• Also worked as Business Objects Administrator in a very large database (VLDB) environment. Maintained more than 650 critical reports for WI business unit of Fidelity.
• Worked with Business units on deliverables consisting of requests for Data against Oracle, MySQL, Sybase and flat files.
• Created/Expanded/Modified Universes in Business Objects as needed.
• Maintained non-Prod environments (database, universe) for UAT, DEV and PERF development needs.
• Developed and deployed ETL -Informatica Powercenter scheduled jobs based on client needs.
• Extensively worked on Informatica Designer Components Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Wrote scripts on various scripting languages like Perl for extracting data for user requirements.
• Worked on Hadoop framework with Map Reduce, Hive and Pig. Wrote Map Reduce programs for analysis on big data.

Environment: Windows 7, PL/SQL developer, Agile/Scrum development methodology, Alteryx, Informatica, Tableau 8, Tableau Server, OBIEE, Business Objects

Confidential - Marlborough, MA

Business Intelligence Developer

Responsibilities:

• Captured the business requirements, worked on gap analysis, and prepared the gap analysis document.
• Interacted with business users for gathering requirements for Projects Dashboards.
• Prepared Use cases and look and feel documents and got reviewed with end users.
• Generated tableau dashboards with quick filters and sets for project codes connecting to Oracle Database.
• Generated adhoc Tableau reports on demand for providers.
• Generated Tableau reports with Trend lines.
• Generated Tableau Dashboards with Oracle Essbase multidimensional database.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Performed incremental extracts for OLAP database.
• Created actual sales and target sales view with Trend lines, table calculations to see the difference between each quarter. Designed and developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Involved in Migration, UAT, Go-Live, and Production Support
• Demonstrated ability to produce Executive Level Tableau Dashboard visualization for Senior Management

Environment: Windows vista/7, SQL Server Management Studio, Toad, DB2, Fixed width flat file, ODI, Tableau 7.0.2, Tableau Server