SUMMARY

• Overall 10 + years of IT experience in Business Analysis, Data analysis, software development, testing and maintenance of BI/Data Warehousing environment.
• Expertise in designing and creating Analytical Reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Mastered the ability to design and deploy advanced graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Well versed in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Advanced charts like Waterfall, Bubble, Gantt, Pareto, Histograms etc.
• Create Data Extracts connecting to Hive and Netezza database, writing custom SQL queries based on requirement.
• Excellent understanding of Data modeling (Dimensional & Relational) concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), MS Access and client/server applications.
• Involved in Performance Tuning by analyzing and comparing the turnaround times between SQL and Tableau.
• Outstanding knowledge in writing and analyzing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Extensive knowledge of all phases of the Software development life cycle (SDLC), in waterfall and Agile (Scrum) methodology
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
• Involved in business presentations, reviewing and organizing data, with the help of Tableau desktop.

TECHNICAL SKILLS

Reporting Tools: Tableau, Qlikview

MS Tools: MS Excel, Word, PowerPoint

Databases: Hive, IBM Netezza, SQL Server, MS Access

Defect management tool: HP Quality center

Project Management tool: JIRA, Confluence

SQL Languages: HQL, T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential

Tableau Consultant

Responsibilities:

• Involved in reviewing business requirements and analyzing data from data sources like Hive/Netezza/SQL Server for design, analysis and development withinTableauDesktop.
• Developeddashboards using calculated fields, parameters, calculations, groups, sets and hierarchies inTableau.
• Created Complex workbooks and Dashboards by connecting to multiple data sources (Hive/Netezza/Excel/SQL Server) using data blending.
• Build rapid prototypes and visualizations of proposed solution to expedite end user input and increase chances of solution adoption and acceptance.
• Create calculations including string manipulation, advanced arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Extensively worked on advanced chart types Like Butterfly charts, Gantt Charts, Zoom in and Zoom out Charts, Replacing charts etc.
• Created Parameters, customized Calculations, Conditions and Filters for various analytical reports and dashboards.
• Used statistical techniques to describe data using groups, bins, hierarchies, sorts, sets, and filters to create focused and effective visualizations.
• Create and modify Interactive Dashboards and guided navigation links within Interactive Dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Extensive knowledge in creating different visualizations with Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Involved in creating tables in Putty and transferring those tables from Hive toNetezzavia Sqoop process.
• Involved in testing the Hive Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in comparison of data with the finished dashboard and the related data source master table.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Create documentation for the finished end product explaining the details and contents of the dashboard.
• Involved in creating stories in JIRA regarding the project and follow up with the status related to each story.

Environment: TableauDesktop 9.2/9.0, Tableauserver, Hive, IBM Netezza,Sqoop, SQL Server, Microsoft Excel 2007, MS Access, Windows 2007

Confidential

Data Analyst

Responsibilities:

• Interacted with business users and performed Gap Analysis for Client requirements.
• Worked on Proof of Concepts (POC) presentation and review with project and IT lead along with developingTableauDashboards.
• Designed and developed complex SQL scripts inSQL server database for creating tables for tableau reporting.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Worked extensively with Advance Calculations, Actions, Parameters, Background images and Maps.
• Migrated Reports & Dashboards from Development to Testing and to Production Environment.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Utilized advance features of Tableau for linking data from different connections together on dashboard and to filter data in multiple views at once.
• Create and modify Interactive Dashboards and guided navigation links within Interactive Dashboards.
• Combine visualizations into interactive dashboards and publish them to the web.
• Creating New Schedules and checking the tasks daily on the server,maintaining server activities, user activity, check security configuration and customized views on Tableau Server.
• Prepare presentations for strategy meetings that address issues involved with top line and bottom line and provide insights as and when required.
• Ability to correspond with clients, responding to their questions and concerns with detailed information, while adhering to company’ Confidential policies and procedures.
• Can adapt to a changing environment and circumstances and Identity potential show stoppers and escalate to the senior management.
• Good in conveying information through e-mails, discussions, meetings, etc. and make sure that everyone stays on same page avoiding ambiguities.

Environment: TableauDesktop 9.0/8.2/8.0, Tableauserver, SQLdeveloper, SQL 2008 R2, Microsoft Excel 2007, MS Access, Windows 2007 server, java 1.5 platform

Confidential 

Business Analyst

Responsibilities:

• Developed Bankruptcy transaction prototype based on in-house research, technology and client development teams' feedback.
• Interacted with user groups to derive the functional requirements.
• Involved in documentation during various phases of development life cycle.
• Create Use Case diagram and Activity diagrams through MS-Visio and Smart Draw thus defining the data process.
• Designed cohesive platform interface for Bankruptcy and Buyback databases, with inputs from Technology and Design Teams.
• Actively led the testing of the new and enhanced features and designs for back-end and platform.
• Performed manual/functional testing by executing test cases prior to automation.
• Handled post launch testing after each launch to ensure that no new bugs affecting other transaction or non-transaction datasets.
• Prepared process and training manuals on different aspects of transaction datasets under supervision.
• Good MS-Excel, VBA and SQL database skills, with proven ability to multi-task, prioritize, and with strong attention to detail.
• Adept at preparing business presentations, reviewing and organizing financial data, and developing qualitative and quantitative analysis.
• Impart training session for new recruiters, educating them with work process, research skills & issues and implement them in day to day functional process as applicable.
• Work in close coordination with various functional and technical teams for related issues and solutions.
• Documentation handling, functional testing and working on change requests related to products like Celsus and Deal Track.

Environment: Agile-Scrum, Oracle, SQL Server 2005, MS Access, MS EXCEL, MS Visio, MS Office Suite.