SUMMARY

• 8+ years of IT experience interacting wif business users and technical community for requirements gathering, software data modeling/design, solution delivery planning and communication on various BI/Data Analytics platforms.
• 4+ years of experience in Tableau Desktop/ Tableau Server 9.x/8.x/7.x, creating highly interactive Data visualization Dashboards using feature such as Data Blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM).
• In depth understanding of the Gap Analysis me.e., As - Is and To-Be business processes and experience in converting these requirements into Technical Specifications and preparing Test Plans.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Pareto Charts, Funnel Charts, Bar Graphs, Scatter Plots, Pie-Charts, Donut Charts, Bubble Charts, Funnel Charts, Heap Maps, Tree Maps, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Extensive experience in developing reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating various reporting components from multiple sources.
• Expertise in analysis, design and implementation of data warehousing/ BI solutions using Teradata, Oracle, SQL Server, Tableau, Informatica, SSIS, MicroStrategy, Business Objects, SSRS technologies.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Good noledge of Data Warehousing concepts, RDBMS and multi-dimensional schema(Star Schema and Snowflake Schema) and worked on both OLAP and OLTP databases.
• Worked in the onshore/offshore model, performing key responsibilities.
• Highly motivated team player wif excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

BI Tools: Tableau (Desktop/Server), MicroStrategy, Business Objects, SSRS

ETL Tools: Informatica, DataStage, Confidential SQL Server Integrated Services

Front End Tools: MS Project, MS Office Suite ( Word, Excel, PowerPoint), Visible Analyst

Databases: Teradata, Oracle, SQL Server, DB2, Sybase, Access

Document Management: Visual Source Safe, Share point, Ultra Edit, Documentum

Defect Management tool: HP Quality Center, Test Director

Methodologies: Kimball/Incondite Modeling, Star/Snow flake Schema, Waterfall, Agile

Scripting Languages: Java Script, HTML, SQL, PL/SQL, and XML

Data modeling: ERwin, ER Studio

PROFESSIONAL EXPERIENCE

Confidential, Kent, WA

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated wif all project teams.
• Interacted wif Subject Matter Experts & End Users and gathered business requirements.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
• Worked in coordination wif clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
• Deployment of TableauServer in clustered environment by mapping server nodes to primary machine.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact wif data as necessary.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure dat the views and dashboards were displaying the changed data accurately.
• Created Heat Map showing sales data by color dat were broken into regions allowing business user to understand sales pattern (least vs. highest) in various regions.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data.
• Worked wif Individual Axes, Blended Axes, and Dual Axes.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users
• Pushed all the created stored procedures and functions to the development, training and production servers.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Provided post implementation production support.

Environment: Tableau 9.x/8.x (Desktop/ Server), MS SQL Server 2012, SSIS, SSRS, Java Script, JQuery, Oracle 10g, ERwin.

Confidential, Redmond, WA

Sr.Tableau Developer

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gathered Business Requirements, Interacted wif the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Analyzed the source systems and created Business Requirement Document (BRD).
• Designed and developedTableauvisualization solutions by connecting to Google Analytics, Oracle and SQL databases.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Configured different data sources using Tableau Desktop
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Blended data using multiple data sources (primary and secondary).
• Developed custom SQL connections and calculated fields wifin Tableau to facilitate automated production of data visualizations.
• Used JavaScript API to set and create filters, select and highlight elements in the view, and process the view to retrieve updated data.
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
• Designed and developed trend reports including forecast and trend lines.
• Configured incremental data refresh for the data sources.
• Develop, organize, manage and maintain graph, table, slide and document templates dat will allow for efficient creation of reports.
• Mentored power users to blend Google Analytics data and Offline data.
• Background in installing and upgrading ofTableauserver and server performance tuning for optimization.
• Configured AD security using tableau server.
• Responsible for authorizing the users based on their privileges.
• Involved in migration activities related to Tableau across the environments.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
• Established, maintained and ensured adherence to application standards for data reporting.

Environment: TableauDesktop/Tableauserver, Google Analytics, SQLdeveloper, SQL 2008, Oracle, MS Access, Windows 2007 server, Java 1.5 platform, Confidential office Suite (Office, Excel, PowerPoint)

Confidential, Chicago, IL

Tableau Developer/Sr. Data Analyst

Responsibilities:

• Analyzed the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Developed predictive statistical models using statistical analysis and other predictive modeling techniques.
• Build and analyze queries from databases using SQL.
• Participated in weekly staff meetings and collaborate wif various teams to develop and support ongoing analysis.
• Conducted dataaccuracy analysis and support stakeholders for decision-making.
• Analyzed data using advance Excel functions such as Pivot Table, Charts, Graphs and Macros.
• Handled the company’s day-to-day reporting anddataaccess needs
• Developed and implemented a business intelligence strategy dat ensures the systemdatais secure, integrated and accessible to staff
• Worked across departments to identify and understand key business questions, and standardize key metrics and measures
• Implemented Complex business logic wif User-Defined-Functions, Index, Views and also created User Defined Data type, Clustered & Non-clustered Indexes
• Written several scripts using Java script for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Analyzed and designed Logical and Physical data models using E-R diagrams.
• Redesigned the data source having data from different sources into one SQL Server and to tableau.
• Analyzed and gained understanding of the underlying data and generated tableau dashboards wif forecast and reference lines.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developed Tableau dashboards pertaining to Revenue and Sales monitoring using Tableau 8.x.
• Demo of Tableau dashboard to users to enhance their noledge on all the key capabilities of application.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• TEMPEffectively used data blending, filters, actions, Hierarchies feature in tableau.
• Defined best practices for Tableau report development.
• Executed and tested required queries and reports before publishing.
• Worked on querying data and creating on-demand reports using Tableau Desktop and publish the same to Server.
• Designed and created Report templates, bar graphs and pie charts based on the customer data.

Environment: Tableau 8.x ( Desktop/ Server),SQL Server 2005/2008 R2, MS Access, MS Excel, MS Power Point, Informatica, VBScript, HTML, XML, Visio.

Confidential, Greenwood Village, CO

Data Analyst/ Tableau Developer

Responsibilities:

• Conducted JAD sessions wif management, SME, vendors, users and other stakeholders for open and pending issues.
• Planned and defined system requirements to Wire Frames wif Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro and managed the concurrence of the parties involved wif respect to the evaluation criterion.
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Database Servers.
• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case.
• Used SQL queries for organizing and extracting data from Teradata databases to suffice adhoc data requests for Business Users.
• Captured Data flow diagrams and formatting of the data flowing through interfaces.
• Accumulated system requirements for analytical reports across different subject areas like Finance, Marketing, Merchandising users to convert MicroStrategy reports to Tableau reports.
• Designed standardized datamarts wif aggregated tables and views to suffice data sourcing requirements for Tableau reporting solutions.
• Configured the Data mapping between Oracle and SQL Server to Teradata.
• Designed and Developed single reports instead of multiple reports as in Tableau by implementing row level security and user filters to cater multiple users wif different access levels to the data.
• Conducted meetings wif users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
• Facilitated user acceptance testing and test strategies wif Tableau power users.
• Performed manual front-end testing to check all functionalities of different modules.
• Suggested measures and recommendations to improve the current application performance wif the aid of SCR’s (Small Change Requests).
• Developed strategies wif Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).

Environment: Tableau (Desktop/ Server), Teradata, Share Point, Agile-Scrum, Informatica, MicroStrategy, UNIX, SQL Server, ERwin, MS VISIO, Confidential Office (Word, Access, Excel, Outlook, Project).

Confidential, Atlanta, GA

Data Analyst

Responsibilities:

• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along wif mapping documents to assist the developers in their coding.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
• Worked wif data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Written several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Metrics reporting, data mining and trends in helpdesk environment using Access
• Create and Monitor workflows using workflow designer and workflow monitor.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked wif data quality issues.
• Identify & record defects wif required information for issue to be reproduced by development team.
• Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
• Flexible to work late hours to coordinate wif offshore team.

Environment: Teradata, Oracle, PL/SQL, SQL Server 2008, MS SQL, Informatica, MicroStrategy, Erwin, DB2, HP Open View, Windows XP, MS Office Suite (Word, Excel, PowerPoint).

Confidential

Jr. SQL BI Analyst / Developer

Responsibilities:

• Involved in Database design, creation and maintenance of Databases.
• Managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Used data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.
• Recovered the backups of SQL Server production databases in test server environment.
• Refactored poorly performing SQL queries to improve application performance.
• Monitoring MS SQL Server performance and network issues.
• Coordinating wif peer groups for Network, Infrastructure and DatacenterOperations.
• Performance monitoring and tuning of SQL servers.
• Used SSIS to load data from multiple SQL Server sources to arenormalizedset of tables for analysis.
• Built SSRS report to support reporting needs.

Environment: MS SQL Server 2005/2008, Windows 2000 Advanced Server,XML, Confidential Suite (Excel, Word, and Visio), Quality Center, and SSRS