Akhila P

Email: ac4nf2@r.postjobfree.com

Phone: 479-***-****

SUMMARY:

Over 4 years of Experience in Designing, Administration, Analysis, Management in the Business Intelligence Data warehousing, Client Server Technologies, Web-based Applications and Databases and Experience in industries such as Retail, Financial, Accounting, Distribution, Logistics, Inventory, Manufacturing, Marketing, Services, Networking and Engineering.

Experience in all the Latest BI Tools Tableau, Qlikview Dashboard Design, and Spotfire.

Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, upgrade, Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time/ Cost/Budget Management, SDLC concepts.

3 yrs Experience in Tableau and Qlikview Dashboards in latest Design and Presentation.

Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.

Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.

Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.

Experience in Developing Performance Dashboards, Score cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons),Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain, and Transportation, Sales/Marketing, Variable Objects with formulas.

WORK EXPERIENCE.

WIZ IT TECH, North Carolina. Aug 2016 – Till Date

Tableau Consultant.

Project : Prism

Description: Prism is an application which aids the users in the process of arbitration. This application has modules such as User Management, Contact Information, Event Management, Financials, Scheduling, Neutrals Management, Document Management, Communications Module, and Notes Management. This project is to convert the existing Dashboards and SQL metrics,filters and reports into advanced chart types and visualization.

Responsibilities:

Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

Responsible for interaction with business stake holders, gathering requirements and managing the delivery.

Connected Tableau server to publish dashboard to a central location for portal integration . Implemented tableau mobile dashboards via tableau mobile application.

Connected Tableau server with share-point portal and setup auto refresh feature.

Created visualization for logistics calculation and department spend analysis.

Generate KPI for customer satisfaction survey results and disease management.

Maintained Test log and Wrote test Evaluation, Summary Reports.

Extensively involved in doing user acceptance testing (UAT).

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.

Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.

Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

Purchasing, Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.

Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing & Deleting Users and activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.

Environment : Windows 7 and Linux, Tableau, tableau server, MS-Excel, SQL Server, SharePoint, Microsoft office, Jdeveloper, SQL-PLUS, C++, Visual Basic.

Calvari Infotech, INDIA jan 2015 –Dec 2015

Tableau Developer

Responsibilities:

Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.

Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.

Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop. Created tableau scorecards, dashboards using stack bars, scattered plots, geographic maps.

Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency, defect tracking and normal issues to meet the goals.

Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.

Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.

Working with User for requirements and part of the team developing the software.

Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.

Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.

Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.

Designed Tableau Workbooks, Tableau Reports, Dashboards and Tableau Administration.

Scheduled reports debugged issues and provided resolutions for Tableau.

Done report performance tuning to optimize the run time.

Changed stored procedures according to the new hierarchy.

Designed and created Report templates, bar graphs and pie charts based on the financial data using Tableau.

Involved in designing Parameterized Reports and Report Models for generating Ad-hoc reports as per the client requirements.

Environment: Tableau Desktop developer, Admin, SQL Server 2008R2/2008/2005, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, XML, MS Project, MS Access 2000 & Windows Server 2000.

Tech India Solutions Pvt Ltd, INDIA April 2013 –Dec 2014

BI Developer (SQL and Tableau)

Project : QANTAS

Description: Qantas is an airline company based in Australia. It’s one of the leading airline company in Australia. In this project maintaining the Database was the key task. Database maintaining consisted of their customer details, feedbacks, ticket sales, transactions, maintaining and developing dashboards and other amenities.

Responsibilities:

Plan, design, and implement application database code objects such as stored procedures and views.

Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.

Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.

Provide database coding to support business applications using T-SQL.

Perform quality assurance and testing of SQL server environment.

Develop new processes to facilitate import and normalization, including data files for counterparties.

Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.

Trained and mentored EBI team, users and assisted and coached them in material, processes and delivery of training, training standards and best practices.

Interacted with report owners to establish/clarify their requirements and developed report specifications.

Performed development activities from gathering requirements and designing solutions, through developing code/ reports, to testing and release / deployment

Environment: Microsoft, Linux, Oracle 10g / 9i / 8i / 7.x, DB2 7.x / 8.x, SQL Server 2005/2000, MS Access 2000

Contact this candidate