SUMMARY:

• Over 8 years of experience in Data Analysis/Business Analysis, System Analysis & Design, Development, Testing and Implementation of BI/Data warehousing projects using Tableau, Micro Strategy, Domo, etc. in Finance, Health Care, Manufacturing, Marketing, and Retail and Payroll Services industries.
• Extensive experience in creating UI visualizations with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.x/8.x/7.x/6.x.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and authored Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making. visual best practices to convey the story inside the data using Tableau.
• Proficient in creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bubble Charts, Funnel Charts, Bar Charts (Horizontal, Stacked), Bullet Graphs, Area Charts, Scatter Plots, etc.
• Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
• Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
• Good knowledge on REST API, integration of Tableau with web applications and AWS Application architect.
• Proficient in Dimensional Modeling using Kimball and Inmon methodologies for Star and Snowflake schema designs of Data Warehouse and Data Integration projects.
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Extensively involved in Reverse - Engineering and Business Rules Extraction Expert in project planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.

TECHNICAL SKILLS:

Reporting Tools: Tableau (Desktop/Server), MicroStrategy (Desktop/WEB),SSRS, DWH, MS BI, Business Intelligence, SAP BO.

Data Integration (ETL) Tools: Informatica Power Center, SSIS

Modeling Tools: Power Designer, Erwin, ER Studio, MS Visio, OBIEE

SQL Tools: Teradata SQL Assistant, Rapid SQL, Toad, PL/SQL Developer

RDBMS: Teradata, Oracle, OLAP, SAP HANA, SQL Server, DB2, Mongo, Access etc, Hadoop

UI Tools: CICS, ROSE, PUTTY, Visible Analyst, Lotus Notes

Documentation: Documentum, SharePoint, HP Quality Center.

Scripting/Languages: HTML, Python, PERL, SQL, PL/SQL,XML, JSON, CSS

Scheduling Tools: Autosys, Control M

Operating Systems: UNIX, Linux, Windows 7/XP/2000

Functional Skills: Finance, Health Care, Sales, Quality Assurance, Subscription, IT service management

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Sr. Tableau Developer/Admin

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations and drill through reports.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau .
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes.

Environment: Tableau (Desktop/Server), APEX, SAS, Workday, SharePoint, Google Analytics, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Bellevue, WA

Sr. Tableau Developer/Admin

Responsibilities:

• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Prepared Tableau reports in various subject areas like Materials Procurement Savings, Bill of Materials, Customer Service Index, Employee Productivity and Employee Safety.
• Played critical role in establishing Best practices for tableau reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI’s and developing POC Dashboards.
• Developed Complex dashboards and used advance chart visualizations in Tableau like Pareto Chart, Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.
• Worked extensively with advanced analysis actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to created summary level and detailed Reports.
• Connected Tableau server with SharePoint portal and setup auto refresh.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Wrote Custom SQL scripts for creating aggregate tables and generating views.
• Worked on understanding of relational database structures, theories, principles and practices.
• Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
• Created Data extract for Amazon Redshift data source and pulled the data through Tableau to create the Interactive Dashboards and Storyboards.
• Successfully administered users, user groups, and scheduled instances for reports in Tableau.
• Upgraded Tableau server from 8.0 to 9.0 in DEV and QA along with Migration of reports.
• Developed a SSB BI Landing Page for all the reports and authored user guides of Tableau reports for the user community.
• Participated in RAD sessions with the stakeholders and technical units for business requirement gathering followed by Agile approach.
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement
• Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau.
• Involved in dashboards on SAP HANA views and publishing the HTML files/reports back to XS server on SAP HANA.
• Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.

Environment: Tableau (Desktop/Server/Admin), Teradata, Teradata SQL Assistant, Teradata Administrator, Adobe Analytics, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Raritan, NJ

Tableau Developer/BI Developer

Responsibilities:

• Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.
• Worked closely with end users in identifying and implementing right set of business criteria to convert raw data into meaningful information.
• Collaborate with business leadership to identify potential areas of analysis.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, actions, parameters, groups, sets and hierarchies in Tableau.
• Created Webi reports using custom SQL queries and converted them to tableau dashboards for advanced visualizations.
• Created dashboards and reports on MS BI.
• Created interactive information for wide ranges of users and customers through ad hoc reporting and portable analytics.
• Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. in a single dashboard by using parameters.
• Displayed multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• Effectively used data blending feature in Tableau to combine the data from different sources like Adobe marketing cloud into a single report.
• Designed multiple dashboards for CDI, helping them to convert from manual reporting.
• Found efficient ways to make tables and graphs that were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Designed and developed various complex SQL Queries, Stored Procedures, Views, and User Defined Functions to implement the business logic.
• Used SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries in Teradata SQL Assistant.
• Presented the findings, graphs to c- suite, replicating the process across various customer segments.
• Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document.
• 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.
• Administered and provided production support for enterprise wide Tableau application consisting of multiple key functional business domains.
• Participated in the retrospective meetings and next sprint planning meetings.

Environment: Tableau (Desktop/Server), MS SQL Server 2008, UNIX, Microsoft Office Suite (Word, Excel, PowerPoint), Python.

Confidential, Franklin Park, IL

BI Developer / Data Analyst

Responsibilities:

• Created Star schemas, Snowflake schema, fact and dimension tables, logical and physical modeling.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created dashboard using multiple data sources and Custom Hierarchies to meet the Business requirement in Tableau.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Regular involving in calls with customer and discussing about status and new requirements of the project.
• Checking the production environment jobs and troubleshooting the failed jobs.
• Design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Worked on SAP BO to generate reports and visualizations.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Environment: Tableau, Tableau Server, Oracle, Microsoft SQL Server 2008 R2/2012, Microsoft Office, Microsoft Visio, Windows 7, SAP BO.

Confidential, Phoenix, AZ

Tableau Developer / Data Analyst

Responsibilities:

• Translated business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Prepared detailed technical documents from the functional specifications.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Created advance connections, join new tables, create & manage Extract and monitor Queries using SQL Assistant.
• Designed and developed Complex workbooks and Dashboards by connecting to multiple data sources using data blending.
• Extensively worked on Tableau Desktop, by creating complex reports & Dashboards on Arizona lottery data.
• Designed and developed complex data Views to calculate multiple measures which can be used as data sources for Tableau reports.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Published of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Conducted trainings to user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.

Environment: Tableau (Desktop/Server), SQL Server 2008/2008 R2, SQL Server Management Studio, MS Office Suite (Excel, PowerPoint, Word, Visio).

Confidential

SQL BI Developer

Responsibilities:

• Understand and evaluate UNIX, SQL and or Data Modeling.
• Develop underlying data models and databases.
• Develop, manage and maintain data dictionary and or metadata.
• Ensure compliance of standards and conventions in developing programs.
• Design, develop and implement complete life cycle of data warehouses.
• Translate business requirements into software applications and models.
• Resolve and troubleshoot complex issues.
• Maintain and manage all versions of data models for production, testing and developing databases.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Involved in creation of Tabular reports, chart reports, Drill through reports and Parameterized reports

Environment: MS Outlook, MS SQL Server 2000, Microsoft Visio, Test Director, XML MS Office Suite (Word, Excel, PowerPoint).