SUMMARY

• 7+ Years’ experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms and Worked on various domains including Insurance, Finance, Banking, Healthcare and Retail.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher - level data analysis and data management services.
• Involved in Full Life Cycle Development of Reporting Projects, includes Requirements gathering/analysis, Design, Development, Testing and Production rollover.
• In-depth hands on experience on Tableau Desktop and Tableau Server.
• Created Dashboard's using multiple BI Tools with Drill-Down capabilities using Dashboard prompts, Local and Global Filters.
• Extensive TableauExperience in Enterprise Environment and TableauAdministrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Created different visualizations to convey the story inside the data Involved in Requirements gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI’s
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Pie charts using show me functionality.
• IntroducedTableau to Client's to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.
• Extensive experience in preparation of reports, tables, listings and graphs
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Proven ability to work efficiently in both independent and team work environments
• Expertise in Data warehousing concepts like OLTP/OLAP System Study, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling and XSD.
• Preparing test cases and test plans. Maintaining deliverables, contributing significantly in taking Tools training to the team.
• Created incremental refreshes for data sources on Tableau server.
• Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment.
• Expert in using Tableau and Power BI Desktop to Analyze and obtain insights into large data sets, create visually compelling and actionable interactive reports and dashboards.
• Extensive experience on Big data sources like Hadoop Hive, Amazon Redshift with Tableau as the front end and created several reports.
• Experience in using various MS office tools for analyzing, arranging and presenting data.
• Understanding value proposition of the project and translate the requirements and business specifications into application functionality.
• Interacting with Team in fixing errors, executing test plans, providing Test Data and Test Cases and Test Procedures.

TECHNICAL SKILLS

Office Tools: MS Outlook, MS Excel, MS Word, MS Access, MS Power Point

Reporting Tools: Tableau 10.3/10.2/10.1/9. x/8.x, Tableau Admin 10.x/9.x/8.x, Power BI Desktop, IBM Congo’s 10.x/8.x

Operating Systems: Windows XP/NT/2000/98/95, UNIX, Linux, MAC OSX

Databases & Tools: Teradata, Oracle 11g/10g, MS Access DB 2013/16, Hadoop Hive, Amazon Redshift, MS SQL Server 2008, Alteryx

Programming Languages: PL/SQL, SQL, XML

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

BI Developer/Data Analyst

Responsibilities:

• Interacted with business users for requirement analysis and to define business and functional specifications.
• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Created Business requirement documents and plans for creating dashboards.
• DevelopedTableau dashboards with combination charts for clear understanding.
• Responsible for implementing effective Business dashboards & visualizations for senior management employing Tableau Software.
• Created visually compelling and actionable interactive reports and dashboards. Utilized table calculations, parameters, filters, charts, mark cards, sets, nested sorting, trend lines etc.
• Creating New Schedule's and checking the task's daily on the server
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in installing tabcmd to schedule the report's and setup email reports using command lines.
• Identified information and analytical needs of business users with regard to data analytics, Business Intelligence.
• Extracted data from DB2, Flat files, XML Files, Flat Files and populated into EDW(SQL Server) and consumed by Tableau Desktop
• Prepared software requirement specifications, business rules interacting with business units and designed Star schema, logical and physical database design for Domains.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Creating New Schedule's and checking the task's daily on the Tableau server
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Have used Custom SQL, Aggregate and Analytical functions to extract the required data for campaigns, reports and dashboard development.
• Scheduled Meetings with Business users to understand current reconciliation process; Gathered requirements from end users and mcustomers experts to define the scope and requirements of Reports.

Environment: Tableau Desktop 10.3,10.x,9.x, Tableau Admin 10.x,9.x Power BI Desktop, Teradata, SQL Server, SQL, MS Office

Confidential, Atlanta, GA

BI/SQL Developer

Responsibilities:

• Documented business reporting requirements (functional/non-functional) and translated them into solutions.
• Worked on multiple Complex tables through custom SQL.
• Coded complex SQL queries to retrieve data from the database depending on the need
• Made use of Sub query-Factoring (WITH clause) to make complex SQL statements simple and make them more efficient
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Developed and presented reporting models and mock-reports to get feedback and approval from business users. Installed and administeredTableauServer.
• Building, publishing interactive reports and dashboards, report scheduling using Tableau Server
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other SQL code and SQL joins for applications.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Filled maps, actions, parameters, Filter and calculated sets for preparing dashboards and worksheets using Tableau.
• Strong team member with good communication and analytical skills.
• Experienced in tuning long running SQL queries for better performance.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Experience in the Date Modeling using Power BI Desktop to extract, transform and load the data from the Oracle Database.
• Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: Tableau Desktop 9.0, 8.3, 8.2, Tableau Server, SQL, Power BI, SQL Server, MS Access, Oracle.

Confidential

Tableau Developer

Responsibilities:

• Created several dashboards that captured Operational Performance, Financial Performance, Information Security, Talent Management and Project Performance metrics
• Migrated content from Production, QA to Development Environment
• Used Actions extensively to link and filter sheets for easier navigation in Dashboards
• Interacted with business users to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau
• Implemented ETL process to load the Data Warehouse and developed repositories (Microsoft SQL Server)
• Performed dimensional modeling to help prioritize different business processes
• Developed several scripts and SQL queries to create various reports for administration
• Developed MicroStrategy reporting tutorial for employees to help them create their own customized report
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium
• Worked in Tableau environment to Create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server
• Manage Production, Test and Development environments including installation of patches, security administration and access controls.
• Involved in writing complex business rules for populating dimension tables, fact tables, and Aggregate tables.
• Created complex reports like Detail Level Transaction report's, monthly Aging, YTD cash goal reports,
• Created extensive joins for data blending from several different data sources
• Helped customize Tableau Server with Company Logo and Company Pop-Ups
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
• Attended meetings with Data Warehouse team, ETL team and Project Managers to track deliverable status
• Performing complex data management, mapping and query development
• Identification and integration of data from a variety of sources
• Data fetching by going against different source systems like DB2 and Oracle
• Assist with the design and development of analytic datasets
• Liaise between business users and Tableau support team.
• Work with various infrastructure teams and Tableau support team to help improve dashboard response time.

Environment: Tableau 8.0, 8.1, 8.2, Tableau Server, Oracle, SQL Server, MS Office

Confidential

Report Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Business Objects, timelines, testing, and technical delivery.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
• Make use of filters and making them local and global accordingly.
• Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in pads, iPhones, and other smart mobile phones.
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, Teradata, Microsoft office 2007.