SUMMARY

• Overall 7+ years of IT experience in Software Development and 4 years of experience in Tableau Desktop, Tableau Server, Tableau Reader and Tableau Public in versions 8.x and 9.0.
• Experience with creating solution driven views and dashboards by developing different chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in Tableau Desktop.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Partnered with Business stakeholders and executives with the goal of providing them with the ability to make decisions and gain insights through data visualization reports and operational reports.
• Experience in building proof of concept for demonstration and illustration purposes for Business partners and senior leaders
• Involved inRequirements gathering/analysis,Design, Development, TestingandProduction rollover of Reporting and Analysis projects
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Very good experience in working with Parameters, Actions, Filters, Legends, Measures, Dimensions, Functions and Calculated Fields with Tableau.
• Understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle),SQL Server, MS Access and client/server applications.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Experience with all components such as Source Analyzer, Target designer, Transformation,Mappings Designer.
• Participated inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau.
• Worked extensively with creating reports as per user requirements using Reporting Services.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
• Demonstrated ability to self-motivate and be flexible within a fast-paced environment

TECHNICAL SKILLS

BI Reporting Tools: Tableau Desktop, Tableau Server

Databases: Oracle, Teradata, SQL Server

Operating Systems: Windows 95/98/2000/XP/Vista/7, Unix, Linux

ETL Tools: Informatica 8.6.1

Office Tools: MS Word, Excel, PowerPoint, MS Outlook

Testing Tools: HP Quality Centre, JIRA

Query Tool: TOAD

PROFESSIONAL EXPERIENCE

Confidential, Mc Lean, VA

Tableau developer

Responsibilities:

• Worked closely with the business users to identify various KPI’s and designed solutions to enhance business decision-making.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Developed and modified Business Intelligence analytical reports/ dashboards using Tableau Desktop.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Created rich dashboards using Tableau dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Designed and developed very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Advanced analytics using data blending, context filters, date filters, sorts and analytics.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, Oracle, SQL Server, MS Excel, MS Access, Win Server 2008 R2.

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• 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.
• 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.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• 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.
• Involved in creating a dual-axes bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Worked on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server
• Extensively used data blending in Tableau.
• Performed Tableau type conversion functions when connected to relational data sources.
• Created incremental refreshes for data sources on Tableau server.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• 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 7 & 8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel.

Confidential, Hoffman Estates, IL

BI/Tableau Reporting Analyst

Responsibilities:

• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created Tableau extract files for improving the performance.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Reviewed Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau
• Server and Reports.

Environment: Tableau Desktop, Tableau Server, Oracle Server, MS Excel, MS Access, Windows Server 2008 R2

Confidential, OH

Informatica Developer

Responsibilities:

• Worked with business analysts for gathering requirements from high-end users and Performed Analysis on Business Data
• Responsible for development, support and maintenance of theETL(Extract, Transform and Load) processes usingInformatica Power Center
• Developed an ETL Informatica mapping in order to load data into staging area. Extracted from flat files and databases and loaded into Oracle 10g target database
• Created mappings using the transformations likeSource Qualifier, Aggregator, Expression, Look Up, Router, Filter, Update Strategy, Joiner, Sequence GeneratorsandStored Procedure
• Worked with various Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer & Mapplet, Transformations
• Utilized Unconnected Lookup to update slowly-changing dimensions
• Createdreusable transformationsandMappletsand used them in complex mappings
• Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL Server 2008, PL/SQL, TOAD, Windows XP

Confidential, ON

Quality Assurance Analyst

Responsibilities:

• Reviewed Software and Functional Specification documents for Test Planning. Worked closely with the QA Lead to create test plan and test scenarios.
• Involved in development, design and maintenance of reusable test automation scripts. Maintained manual and automated test cases using Quality Center.
• Followed Agile Methodology throughout development and testing phases.
• Created and Executed SQL queries to test data integrity across modules.
• Aided in root cause analysis of issues, resolving issues, and driving issues to closure.
• Analysis ofFunctional RequirementSpecificationand Technical specification document to write test cases and associated scripts for the verification and validation of the application and ensuring that it meets all defined functional requirements.
• PerformedManual Testing (Functional testing & Re-testing). PerformedDatabase testing.
• Understood theDefectmanagement of the company and submitted thebugsas per the company's bug cycle format.
• Participated in bug reviews and weekly status meetings to improve overall process. And generated Daily/Weekly Reports.

Environment: HP Quality Centre, QTP, SQL, UNIX, Windows, MS Access, MS Excel, JIRA.