SUMMARY:

• 5+years of IT experience in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools
• 4+ years of extensive experience with design and development of Tableau visualization solutions.
• Certified Tableau Desktop 9 Qualified Associate with extensive experience inTableau Desktop, Tableau Server, Tableau reader, Tableau Mobilein various versions of Tableau (7.x/8.x/9.x/10) and Vizql,Teradata, SQL and various ETL tools.
• Experience with all the modules of MicroStrategy Product Suite namely MicroStrategy Intelligence Server, Web, Dashboard, Narrowcast Server and Desktop.
• Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.
• Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.
• Efficient in identifying and analyzing Business requirements from documents and end - user discussions and deliver the data requirements necessary to support DW subject areas.
• Extensive experience on designing database using ER modeling and Normalization
• Experienced in designing richInteractive reports and dashboards integrating various reporting components from multiple sources.
• Experience in aggregating data and configuring reports from different data sources using data blending.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. and other making use of actions, other local and global filters.
• Extensive knowledge in various reporting objects like Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Parameters etc.
• Good experience on LOD expressions Comparative Sales Analysis, Customer Acquisitions, etc.
• Hands on experience in embedding Tableau reports and dashboards on external websites using Java API scripting.
• Good knowledge on Embedded views of Tableau with web applications to integrate reports.
• Good experience in MicroStrategy Reporting - Templates, Filters, Metrics, consolidations, Prompts, custom group, and Datamart optimization of reports.
• Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development
• Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for developed ETL Mappings.
• Experience in guiding onshore/offshore development teams to build dashboard applications, developing templates and development framework, design standards and implementation plans.
• Excellent analytical, problem solving, communication and time management skills.

TECHNICAL SKILLS:

Analytical Tools

: Tableau Desktop/Server, MicroStrategy, SSRS

ETL Tools: DataStage, Informatica, SSIS

Requirements Management: Microsoft Office (Word, PowerPoint Excel)

RDBMS and SQL Tools: Teradata, Oracle, SQL Server, Toad, SQL Assistant, SQL Plus

Code Management Tools: UC4, SVN, SharePoint, Quality Center

Methodologies: Kimball/Inmon, OLAP, Waterfall, Agile

Data Modeling Tools: ERwin, ER Studio, MS Visio

Operating System: Windows 2007, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Worked directly with client, data architects, business analyst and internal team members to understand reporting requirements,identified various KPI’s and designed solutions to enhance business decision-making.
• Involved in Agile Methodology (Scrum) from requirements gathering to maintenance and monitoring the progress.
• Experienced on working with Big Data and Hadoop File System (HDFS).
• Involved in creating Hive tables, loading and analyzing data using impala queries
• Developed SQL queries to process the data and generate the data cubes for visualizing
• Implemented schema extraction for Parquet and created External Hive Tables on top of CSV file formats.
• Experienced in running query usingImpala SQL, Spark SQLand used BI tools to run ad-hoc queries directly on Hadoop.
• Used Tableau to connect to Hive ODBC connector generate daily reports of data.
• Created extensive Tableau reports, various interactive dashboards and published them on Tableau Server.
• Created action filters, parameter’s, and calculated measures for preparing dashboards and worksheets in tableau.
• Developed Tableau reports using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Maps, Pie and Bar Charts and donut charts.
• Worked extensively on Advance analysis actions, Calculations, Parameters, Background images, Trend Lines, Statistics and table calculations.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Involved in administration tasks such as Setting permissions, creating useraccess and specific user groups.
• Also involved in the creation of projects, workbooks and the appropriate permission sets for Tableau server logins.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Prepared mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Environment:Tableau (Desktop/Server) 10.x/9.x, Teradata, SQL Server,Oracle 12c/11g, Hive,Spark-SQL,Impala,Java API, Putty, Unix, Microsoft Office suite.

Confidential, Malvern, PA

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Worked with internal management and team members to understand and clarify reporting requirements / needs.
• Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.
• Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.
• Identify key business metrics measurements and develop methods to represent data in support of the measurements.
• Utilized Alteryx to integratedata frommultiple databases into a DW data model.
• Provide guidance and insight on data visualization and dashboard design best practices in Tableau
• Creating customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle and performing data blending in reports.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Created 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.
• Stretched Tableau limits to create unconventional Tableau charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Heat maps and logical calculations to create groups.
• Worked on identifying partition fields and nested filed in process of Migrating of huge amounts of data from different databases like Salesforce to AWS
• Extracting data from databases like Salesforce for getting data to Tableau for creating various dashboards
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.
• Embedded Tableau reports/dashboards on to the external web pages.
• Provide innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.
• Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.
• Maintain thorough and rigorous documentation related to all ETL changes, Metadata, database server configuration, operation, and database change management.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Environment: Tableau (Desktop/Server) 9.x/8.x, Cognos 10.2, Teradata 15, Oracle 12c/11g, Hive, Hbase, BigQuery, Salesforce.com, Teradata SQL Assistant, Java API, Putty, UC4, Microsoft Office.

Confidential, Saint Louis, MO

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Gathered business requirements from end users, analyzed and documented the same for various reporting needs.
• Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed.
• Created side by side bar chart comparison of Vendors who were into Retail along with profit revenue generated.
• Worked with DBA to extract API data into SQL Server and connected to the same from Tableau for various reporting requirements.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Used parameters and input controls to give users control over certain values.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
• Created Data extracts for better performance of dashboards and accessing data offline..
• Extracting data from databases like Salesforce for getting data to Tableau for creating various dashboards
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Integrated dashboards with live Connection in Microsoft PowerPoint.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Created reports using Custom SQL for complex report views.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment:Tableau (Desktop/Server) 8.x, Oracle 11i, Toad, SQL Server, SQL BI Suite (SSIS, SSRS), Java API, Salesforce.com, MS Visio, Microsoft Office Suite(Word, Excel, PowerPoint).

Confidential

Business Analyst

Responsibilities:

• Involved in requirement analysis and planning of delivering projects using Waterfall model
• Assisted developers and testing team with business cases and scenarios
• Planning and monitoring of project execution along with the senior management.
• Elicited requirements and elaborated with planning sessions to the team.
• Organized the requirements into a proper documentation and maintained development efforts
• Translated and simplified requirements to developers elaborately.
• Requirements management and communication with clients and onsite coordinators for executing projects.
• Prepared demo sessions for the development of projects to clients
• Created weekly status reports for different modules in the projects
• Used SQL, PL/SQL for database related functionality.

Environment:SQL Server, Quality Center, Windows XP, Excel Reports, MS Office Suite (Word, Excel, PowerPoint)