SUMMARY

• 5 years of experience in design, development, implementation, and administration of various Business Intelligence tools and expertise in implementing various functionalities of Data Warehouse.
• Extensive experience using Tableau Server, Tableau Desktop and Tableau Public.
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2016, 2014, 2012, 2008R2.
• Proficient in Installing, Configuring and Administration of Tableau Server.
• Expertise in designing and development of various dashboards, reports utilizingvarious TableauVisualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Extensive experience inTableauAdministration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Involvedinpublishingofvariouskindsofinteractivedatavisualizations, dashboards and work books from Tableau Desktop to Tableau Servers.
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.
• Creating offline, online map sandal so create custom geocoding and WMS-server to build spatial visualizations of non-geographic data.
• Experience in creating, filters, quick filters, data source filters, global filters, context filters and user filters.
• Designedanddevelopedvariousanalyticalreportsfrommultipledatasourcesbyblendingdataonasingle worksheet in Tableau Desktop.
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables, and Physical and Logical data modeling.
• Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations inTableau.
• Experience in publishing Dashboards to Tableau Server.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau.
• Created various Data Visualization Objects viz. Scatter Plots, Bar Charts etc.
• Expertise in data cleansing for analysis, perform data quality testing for gaps, and liaising with data origination teams.
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms.
• Have been working with various data sources such as Oracle, SQL Server, ODBC and flat file sources.
• Detail-oriented problem solver, quick learner, and flexible team player.
• Excellent skills in communication & collaboration, interest & ability to learn new technologies in short time.

TECHNICAL SKILLS

Reporting Tools: Tableau, Business Object suite (XI R3.1/R2/6.x/5.x), Business Objects BI 4.0, SAP BW, Web I XI/6i/2.6, Designer, Reporter/Desktop Intelligence/Web Intelligence Rich Client (3.1), Supervisor, Broadcast Agent, Info view, Crystal Reports 2008/XI/10, Crystal Enterprise, Central Management Console, Xcelsius, QaawS, Live Office, Xcelsius 2008/4.5.

ETL tools: SQL Loader, Informatica Power Center 8.1, 7.1, 6.2.

Databases: Oracle 12c/11g/10g/9i, SQL Server 2008R 2/2012/2014/2016, Sybase, Teradata, MS Assess, DB2.

Data Modeling Tools: ER Studio, VISIO, Dimensional Data Modeling (Star SchemaSnow-Flake, FACT Dimensions), ERWIN 6.1/4.5/3.5, iGrafx

Languages: SQL, PL/SQL, C, C++, JAVA, J2EE, HTML, XHTML

Operating systems: UNIX, LINUX, Windows 98, XP, 2008/NT.

Application Servers: Web Logic, Web Sphere, Tomcat.

Software Packages: MS OFFICE

PROFESSIONAL EXPERIENCE

Confidential, Farmington Hills, MI

Tableau Developer

Responsibilities:

• Complied interactive dashboards inTableauDesktop and published them toTableauServer, which allowed story telling behind the growth in Loan approval with Quick Filters for on demand needed information with just a click of a button.
• Created Reports and Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Experienced the latest version ofTableauDeveloper 10.1, 9 & below .
• Developed Public Objects like filters, prompts, metrics, templates, consolidations, etc.
• Experienced in using Schema Objects to create reports.
• Worked on Data Warehousing and RDBMS concepts.
• Created view and tables to generate clean SQL for reports.
• Deployed reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
• Tested reports and Dashboards in different environments to ensure the functionality and results.
• Worked with databases like Teradata for testing and validation of data and to create reports.
• Experienced in promotion of Objects to different environments.
• Developed SQL queries as needed against development and production databases for quick-action ad hoc reporting and data quality analysis.
• Performed testing of all reports for the final deployment.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Created template reports using advanced prompts like object prompts, expression prompts, and filters.
• Designed theTableauArchitectural and Developers Documents for the Projects.

Environment: Tableau10.1.1(Desktop, Server), Teradata, SQL, Python 2.7, SharePoint, Windows, BTEQ, MS Office Suite (Word, Excel, PowerPoint), and MS Access.

Confidential, Indianapolis, IN

Tableau Developer

Responsibilities:

• Participated in requirement gathering, analysis and structuring of Business Intelligence objects reports based on user requirements and conducted meetings every month for group of Directors to help them understand how their units are doing
• Grant server access to team members for live connections
• Developed Test Scripts and Training modules for end users
• Developed reports using custom SQL queries and created .tdsx, .tde and .tds files and Created four reports and filtered them by various measures and dimensions
• Blended data from multiple databases into one report
• 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 interactive dashboards by combining views and reports inTableauDesktop that were presented to Business Users, Program Managers, and End Users
• Using MS Excel, charts are converted into Crosstabs for further underlying data analysis
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Concerned in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance

Environment: SQL Queries, .tdsx, .tde and .tds files, TableauDesktop 8.1& 7, Tableau Server, MS Office Suite,Oracle SQL Server2016, MS Excel

Confidential, Irving, TX

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand wherewe have most users vs.least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Projected and forecastedfuture growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on whichstates were connected the most.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• 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.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: TableauDesktop,TableauServer,MS Office Suite,Oracle SQL Server2014, MS Excel.

Confidential, New York City, NY

Tableau Developer

Responsibilities:

• Developed Tableau dashboards according to user specifications.
• Extensively used Data Blending techniques in dashboard development.
• Supported different user groups and business domains.
• Good knowledge of tableau server, administrative functions, installation, configuration, back up of servers and load balancing techniques.
• Defined architecture for Tableau - establish Dev/QA/Prod environments
• Responsible for security configuration including user/ group setup, permissions, security roles, configuration of trusted ticket authentication
• Setup new projects, security groups, roles and administer users for all supported platforms
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Monitoring of Tableau Servers for its high availability to users.
• Worked on Tableau Server upgrades for new versions.
• Providing Tableau Demo’s to new on boarding users.
• Developed worksheets and data visualization dashboards with graphs and filters.
• Created report schedules on Tableau server.
• Develop monthly reports and dashboards.
• Created calculated fields as per business requirement.
• Defined best practices for Tableau report development.
• Used Tab-admin and Tab-cmd commands in creating and restoring backups of Tableau repository.
• Involved in Production support for Tableau.

Environment: Tableau Server V 7.0/8.0/8.1/8.2, Tableau Desktop, Oracle, Netezza, Teradata, Excel, Windows, SQL Server 2012.