SUMMARY

• 9.1 years of experience in software industry as Senior Data Analyst (SQL)/ Business Intelligence Developer (Tableau) with passion of learning new software technologies also having strong experience in Reporting and Processes, Root Cause and Predictive Analytics. Below are my PROFESSIONAL SUMMARY which I have played during technology and learning period
• Collaborate with business partners and various applications teams to understand reporting requirement and creating business required visualization report
• Produced attractive visuals/dashboards to convey the story inside the data.
• Strong understanding of Tableau features including date function, filters, parameters, table calculations, row - level security, joins, data blending, and dashboard actions
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Created dashboard reports on forecast, trend line and reference lines, year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Created Tableau Dashboards with interactive views, charts, trends, geographic view and drill downs along with user level security
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data
• Expert in writing Advanced SQL queries and optimizing the queries in Oracle SQL
• Having strong predictive analytics background in SQL and Tableau
• Having very good experience in analyzing the log files.
• Having Good Experience in data extract and loading ETL Tool Pentaho
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle, splunk, Microsoft Excel, including pivoting and trend analysis.
• Possess Strong analytical and problem solving skills, organizational skills and ability to learn new technologies as per the projects needs.
• Worked with large sets of data to build proper visualizations and setups for consumption by users that are diverse in their level of complex data comprehension

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/XP/2003/7

Languages/Front End: C,C++,Visual Basic 6.0,HTML,R Programming

Data Visualization: Tableau Business Intelligence

Database Programming Language: Oracle SQL Developer,PL/SQL,MS SQL Server 2005/2008, MicrosoftSSIS

Technology: ASP, ASP.NET, XML,HTML,Baiscs of Hadoop Big Data, Hadoop HUE

ETL: Pentaho

Softwares/other Tools: Splunk,BMC REMEDY,Citirix,Hyperion,FileZilla,Putty,Microsoft Excel,MS Access

PROFESSIONAL EXPERIENCE

Confidential

TABLEAU DESKTOP BI DEVELOPER /SENIER DATA ANALYST

Environment: Oracle SQL developer (SQL),PL/SQL, TABLEAU DESKTOP 9 and 10, Pentaho,Splunk,Hue Hadoop, Microsoft Excel pivot, lookup, Oracle Hyperion

Responsibilities:

• Predictive and root cause analysis of the top trending customer order failures reported in various order flow systems and provided solution to business and application teams to fix the issues.
• Created Tableau reports in customer Billing order entry process, activation process, order flow process and order failure, activation failure based on customer defined intervals.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Challenges faced and worked towards to identify customer Theft service that was a major area affected in the organization revenue.
• Worked IVR and Truck roll, customer care ticketing related analysis and reports.
• Running the SQL quires in various order flow systems to identify the top 10 Errors and do the root cause and helped the relevant team to fix the issues.
• Captured successful/failure percentage on device activation attempts through online, Technician and IVR based tableau report on weekly/Monthly basis
• Created Tableau based Automation report that helped to avoid the regular manual intervention reports/Tasks.
• Created Tableau reports on pulling the data from splunk that helped team to understand well about logs based data.
• Created Dashboard reports, score card reports for Confidential business users to analyses the overall product and cost oriented.
• Generated Daily,weekly,monthly based Customer order failure report to find the overall High speed internet, voice and video order Flow through Prercentage and Trend Report

Confidential

DATA ANALYST

Environment: Oracle SQL Developer, VISUAL BASIC, PL/SQL, Microsoft office Excel

Responsibilities:

• Analysis of specification given by the client and identify the top flaws in the system.
• Running the SQL quires to identify the top issues and created excel based dashboard reports using PIVOT and LOOKUP functions.
• Performed data analysis and data profiling using complex SQL on Client systems including Oracle and Microsoft Excel.
• Very good knowledge in Visual basic macro creation.
• Created Trend Analysis and Dashboard Reports
• Enhancement in the crew forms.
• Created more than 15 crew based reports to the stakeholders.

Confidential

Application support and Reporting

Environment: PL/SQL,VB.NET, Sql Server 2005,BMC Remedy

Responsibilities:

• Provided L3 Application support and code fix for 3 different main application like HomeScan, Audit and CRS applications.
• Code walk through Analysis, troubleshooting the issues, on call support provided to the various stockholders.
• Created Customized reports on running SQL quires and shared with stakeholders.
• Mostly worked on SQL quires and Excel Dashboard reports that helped business users to take effectively for their business.
• Good Knowledge in creating various artifacts for projects which include specification documents, data mapping and data analysis documents