Aishwarya.

405-***-****

Professional Highlights:

* ***** ** ********** ** Data warehousing, Business Intelligence and reporting tools like Tableau, MS Excel with connections to various data sources like SQL Server, MS Access, CSV files, and flat files.

1-year Business analyst Experience.

Experience with Tableau Desktop in different versions ex: Tableau 10.x and 2018.3.

Knowledge on 2018 and 2019 versions.

Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.

Administered user, user groups, and scheduled instances for reports in Tableau.

Good understanding background in financial services and telecom industry.

Experience working independently and, in a team oriented, collaborative environment.

Produced attractive visuals/dashboards to convey the story inside the data.

Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.

Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.

Experience in reporting using SQL Server Reporting Services (SSRS) from relational database.

Knowledge on ETL concepts.

Comfortable working independently or in a team with limited supervision in tighter schedules, meeting deadlines, and ability to learn on the fly.

Excellent communication skills in both written and oral along with ability to tell a story through data.

Ability to meet deadlines and handle multiple tasks, team player, motivated, able to grasp things quickly with analytics and problem-solving skills.

Education

Bachelor’s in computer science, Andhra University, 2009

Master in IT, University of Sydney, 2012.

Technical Skills

Business Intelligence Tools

Tableau 8, 10.x,2018 and 2019.

Databases

MS Excel, MS SQL Server 2005.

Programming Languages

MY SQL, Oracle SQL.

Utilities

Alteryx, Salesforce, MS Project, MS Excel, MS share point, MS Power Point.

Professional Experience:

Client: Hewlett Packard, RI Mar’17- Till Date.

Role: Tableau Developer.

Working with Business team and gathering proper requirements to Building Reports, Views and Dashboards as per end user requirement.

Hands on experience in creating Joins and Blending data from heterogeneous sources.

Used Alteryx to changed unstructured to structured data for better Tableau reporting and data analysis.

Proficient in design and development of various dashboards, reports using Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts etc.

Implemented Quick Filters, Cascading Filters, Context Filters and Data Source Filters while handling huge volume of data.

Blending data by using Alteryx.

Having experience in identifying, analyzing and interpreting trends and patterns in complex data sets.

Adhoc data cleaning and standardization using Alteryx.

Proficient in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.

Mastered the ability to design and deploy rich graphic visualizations with Drill Dow, Drop-Down menu option and parameters using Tableau Desktop.

Created solution driven dashboards by developing different types of charts including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop.

Creating Search option on Dashboards for client to find the required data easy way.

Worked on converting the existing Excel into an Alteryx Application/WF(Workflow).

Involved in creating dashboards by using Level of Detail concept (LOD’s).

Worked on creating visualizations using custom hierarchies, groups and merged data from multiple sources using the data blending technique with in the tableau workbook.

Creative custom fields using Table Calculations and LOD's (Level of Details).

Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community. Created conditional filters and Action links to filter the data on dashboard.

Used various types of aggregations like sum, average, count, count (distinct), median, minimum, maximum, percentile and std. deviation, etc. to build strong informative dashboards.

Developed Tableau workbooks to perform year over year, YTD, QTD and MTD type of analysis.

Hands-on development in assisting users by creating and modifying worksheets to get best data visualizations.

Environment: Tableau Desktop 2018, Alteryx 2011.0.3 and SQL Server.

Client: Experian, NC Aug’16-Feb’17

Role: Tableau Developer

Responsibilities:

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.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Worked on optimizing and tuning the Teradata views and SQL to improve the performance of batch and response time of data for users.

Created parameterized reports, drill down and drill through repots using SSRS.

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.

Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.

Converted charts into Crosstabs for further underlying data analysis in MS Excel.

Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.

Involved in extraction, transformation and loading of data directly from different source systems like flat files and SQL Server.

Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

Creating different reports from different data sources using SSRS.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

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 group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 9.x, MS Project, MS Excel.

Client: EMC, MA Nov ’13 - July’16

Role: Tableau Developer/Business Analyst

Responsibilities:

Involved in creating dashboards by extracting data from different sources.

Created dashboard using parameters, sets, groups and calculations.

Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Involved in creating calculated fields, mapping and hierarchies.

Created drill through reports in dashboard.

Involved in creating data blending in case of merging different sources(Salesforce CRM).

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, Salesforce, Denodo and SQL Server.

Developed LOD reports on various KPI’s.

Utilized Cognos Framework Model and package that crosses several databases in order to create reports that were used the foundation for multiple dashboards.

Performed Tableau type conversion functions when connected to relational data sources.

Performed UNIT testing and help the UAT testing team to performing various testing scenarios.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

Employed Filtered Indexes to improve query performance and reduce the storage and maintenance cost.

Environment: Tableau, SQL Server 2012, PL/SQL.

Client: Commonwealth Bank of Australia June’11 – May’12

Role: Jr. Business Analyst

Responsibilities:

Perform work on time, within scope and with high customer satisfaction.

Document all data sources and code used in data analysis and reporting.

Interact with application development, enterprise architecture, business intelligence, technology services, and vendors on a regular basis.

Developed Business Objects according to client needs and requirements.

Understanding the business requirements through interacting with end users.

Assisted with online banking issues such as error messages or technical troubleshooting.

Attended weekly line of business status meetings and provided status reports.

Monitored bridge calls to initiate potential defect resolutions for system conversions.

Assist in creating UAT test scripts and leverage them in UAT test validation.

Contact this candidate