SUMMARY

• Over 9 years of experience in Software Design, Development of DWH, BI Administration and Data Administration Platforms.
• Excellent understanding of different Software Development Lifecycle methodologies (SDLC) including Agile (Scrum) and Waterfall.
• Well - Versed in Open-ended and Closed-ended Interviews when gathering, recording, and analyzing Business Requirements (BR), Functional Requirements (FR), Non-Functional Requirements (NFR) and Data Requirements from both Business and IT Stakeholders.
• Proficient in interacting with business users to identify information needs and initiating process changes and creating Use Cases, Use Case diagrams, Activity diagrams using tools like MS Visio.
• Strong understanding of relational database concepts, Star and Snow Flake Schema.
• Extensive Experience in Tableau as a BI Consultant/Analyst and Lead BI Developer.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Skilled in Tableau Desktop for Data visualization, Reporting and Analysis.
• Expertise in resolving the reports, dashboards, performance issues and implementing best practices using Tableau/OBIEE/SAP BO.
• Skilled in Understanding client Best-Practices & Report standards, ability to provide visualization alternatives, assist in developing reports.
• Experience in Tableau application security/release management methods.
• Expertise in Tableau Server Configuration, Administration and Cloud Deployment
• Expertise in Tableau Enterprise Scalability and Integration with existing Data Flow Architecture
• Involved in Deployment, Maintenance and Troubleshooting of Tableau Servers and integration with Databases
• Experienced in Optimization and Performance improvement of Tableau Workbooks
• Troubleshoot existing reports, understanding of data connections to Oracle, MS-SQL Server and other Databases.
• Proficient in creating calculations, formatting using Tableau /SAP BO and OBIEE.
• Experience in Improving Reports performance in Tableau/SAP BO/OBIEE.
• Experience in Tableau/OBIEE Administration/development and architecture.
• Experience in creating Admin views/System metrics using TabMon or TabJolt applications.
• Experience as an OBIEE developer-supporting medium to large data marts.
• Experience in developing custom OBIEE data marts and extending OOTB OBIA data marts.
• Experience in Tableau application security/release management methods.
• Database experience in Oracle 11g/10g, My-SQL, MS-SQL Server, Teradata etc.

TECHNICAL SKILLS

• HTML, PL/SQL
• SQL
• Java Script
• Python
• Shell Scripting
• Oracle SQL Developer
• Salesforce.com
• TOAD, SSMS
• Google Analytics
• Informatica
• Alteryx
• SSIS
• SSAS
• Tableau Server
• Tableau Desktop
• OBIEE
• Micro strategy
• SSRS
• SAP BO
• Windows
• UNIX
• Linux

• Oracle, MS Access
• MS SQL Server
• Postgres SQL
• Teradata
• Apache Tomcat
• Web logic Server 8.1/9.2/10
• MS IIS 5/6.0.
• MS Office
• Toad
• Putty
• Rapid SQL
• SharePoint

PROFESSIONAL EXPERIENCE

Tableau Admin / Developer

Confidential, San Diego, CA

Responsibilities:

• Worked in coordination with 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
• Created Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau Users.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Created complex Executive dashboards using Tableau Desktop that was published for the business stake holders for analysis and customization using filters and actions.
• Created dashboard using parameters, sets, groups and complex calculations.
• Implemented various data connections from data source toTableauServer for report and dashboard development
• Monitored VizQL server, Application Server and data server activity to track performance and system stability
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Developed many reports with multiple data connections and performed data blending and created different visualizations like Bar Charts, Gantt Bar Charts, tree maps, bubble charts using complex joins.
• Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal reports,
• Quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report.
• Worked with SSIS and SSRS for developing and extracting reports.
• Involved in creating guided navigation links for Interactive dashboards in Tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.

• Wrote T-SQL queries for database validation and provided 24/7 production support for Tableau users.
• Involved in testing dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed SQL tuning by using Database Engine Tuning Advisor for long execution plans.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Reader, Tableau Server, Tabcmd, Oracle, MS Office 2007/2010, SQL Server 2008, Windows 7, Enterprise Manager, SQL Server Management Studio, Microsoft Excel.

Tableau Developer / Administrator / Sr. BI Consultant

Confidential, Houston, TX

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better Worked on the backend SSAS cube development, which was the source data for the tableau.
• Performed an evaluation of Tableau platform in the enterprise data architecture.
• Collected, Analyzed and documented requirements specifications from the users to design a robust implementation plan.
• Developed best practice guidelines for the Tableau platform in the development, troubleshooting and maintenance space.
• Interacted with customers across multiple Lines of Business on a daily basis regarding Tableau Dashboard enhancements and troubleshooting of the various issues related with Tableau Desktop and Tableau Server.
• Helped the team setup new physical servers for the Tableau Environment, Tested Workbooks and ramped up to 400 users on the Tableau server in less than 2 months.
• Was involved in Administration, User Security and setting up the template for Tableau Monitoring Dashboards.
• Improvised existing Tableau workbooks by doing a performance analysis, performance monitoring and implementing the best practices in development of dashboards.
• Designed a Proof of Concept around Tableau connectivity with Hadoop and other Big Data Sources.
• Developed Tableau dashboards by using SQL Server, Oracle and Excel as data sources.
• Developed Tableau workbooks for regular Tableau Server Monitoring for users across multiple sites.
• Regularly interacted with Tableau Consultants in developing a series of monitoring dashboards and visualization best practices.
• Raised Incident tickets with Tableau Software for issue resolution.
• Integrated Tableau with different data sources and created a Data Visualizations and Analytics platform on Tableau.
• Migrated 400 Users from a Virtual Tableau Platform to Physical Tableau platform for a Line of Business.
• Helped with Tableau 9 Beta platform testing with customers in a classroom setting.
• Highly effective in problem solving and a skillful negotiator with customers.

Environment: Windows XP, Tableau Desktop, Tableau Server, TabMon, Tab Jolt, Alteryx, Oracle 12c/11gR2, Crystal Reports, SQL Developer, MS-SQL Server, SSIS, SSRS, SharePoint, MS-Access, MS Excel and JavaScript, Python.

Sr. BI Developer

Confidential, Franklin, TN

Responsibilities:

• Responsible for Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Responsible for understanding the source systems to implement EDW.
• Responsible for Data Modeling, Data Analysis, Data Integration and Data Visualization.
• Experience in working with Tableau server to publish data sources, creating users and Tableau installation.
• Responsible for creating Tableau models, architectures, frameworks and strategies based on business requirements.
• Responsible for technical solutions to support and streamline data reporting requests requiring integration of data from multiple systems.
• Responsible for Analyzing and trouble-shooting technical issues related to reporting.
• Experience in creating Dashboards by connecting to different data sources like Google Analytics, Salesforce and different data sources.
• Experience with creating advanced reports in Salesforce.com.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterization using Tableau.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Responsible for providing Tableau training to business users and helping them in self-service Analytics.
• Supported enterprise wide deployment and developed object security.
• Formulated and executed practices for Tableau report development.
• Installed and configured Tableau desktop along with silent mode features.
• Documented and modified user groups for Tableau reports.
• Participated in tracking and monitoring server performance.
• Assisted in mapping of server nodes for Tableau server deployments.
• Created server architecture and analyzed scheduling related issues.
• Conducted platform performance tests and implemented Tableau platforms.
• Documented and maintained system designs and Tableau technical aspects.
• Evaluated performance test results and developed technical architecture.
• Connected to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.
• Utilized the JavaScript API to create a customized portal for the property management group.
• Consulted on Tableau server performance enhancements.
• Upgraded from version 8.2 to 8.3 and server reconfiguration based on workbook complexity and data extraction.
• Customized the Tableau landing page with site listing as icons and descriptions.
• Configured data extraction by schedule, every business day at 6 am / 7 PM to enhance performance.

Environment: Windows XP, Tableau 8.x, Tableau Server, Talend, Oracle Database 12c/11g, SQL Developer, MS-SQL 2008 R2, MS-Access, Salesforce Marketing Cloud, Google Analytics, Netezza, SAP BO, MS Excel and JavaScript.

Sr. BI Developer

Confidential

Responsibilities:

• Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.
• Supported operations and performed Tableau server maintenance, Security Administration, License Management and Performance Monitoring. Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Responsible for new releases of Tableau Application and drivers, suggest and support user with proper drivers installation.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.

• Created Bar Charts, which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Developed Scatter Plots and Area Maps to find Outliers i.e., states utilizing the Mobile App most vs. least.
• 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.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
• Responsible for Installation, configuration and upgrade Tableau server.
• Created highly formatted reports using BI Publisher based on conventional data sources (such as Oracle Database).
• Developed Calculated Measures and assigning these Aggregation levels based on Dimension Hierarchies.
• Worked with ETL team and Data Modeler to provide the required Data specifications for reporting. Used Informatica to clean the data as required for reporting.
• Configured Presentation layer used by different User Groups and established the various standard queries, in order to support the presentation layer.
• Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements.
• Responsible for creating ETL mapping documents to define data flow from source system to target database.
• Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped
• Validated the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and validating repository level calculations done in the business model layer.
• Provided best practices for development, administration process and documentation for tableau server platform.

Environment: OBIEE 10.x/11.x,Oracle 10.x/11.x,Tableau Server, Tableau Desktop, Micro strategy, Informatica, SQL Server, TOAD, Windows XP, MS Excel, JavaScript, Postgres SQL, Python, MS Access, UNIX.

Business Data Analyst

Confidential

Responsibilities:

• Followed Agile Methodology to configure and develop process, standards, and procedures
• Reviewed the Standard Operating Procedures (SOPs) and monitored program performance KPIs
• Identified, researched, and analyzed production problems developed solutions, and resolved problems.
• Identified system enhancements, documented business needs and determined development impact to current system processing. Worked with programmers and users to ensure accuracy of enhancements.
• Generated functional requirement, reporting requirement and data requirement.
• Identified legacy database using SQL to understand table relationship, schema relationship, data type, data format, and other metadata information.
• Extracted Data from Teradata using Informatica PowerCenter ETL to the target database including SQL Server and used the data for Reporting purposes.
• Conducted data profiling and data quality analysis using Informatic Power Center.
• Conducted data cleansing using R, SAS and SQL Queries.
• Responsible for Logical data modeling, Dimensional modeling, Reporting & analysis, Data quality, Data cleansing, Master Data Management (MDM), Data mart, Software engineering, Software Development Life Cycle (SDLC), Documentation, Agile software development
• Conducted Business Interviews/Meetings with business users and stakeholders to gather and document requirements
• Interfaced with business users and data architects in order to translate user requirements into data requirements.
• Performed data analysis on source and targeted tables utilizing SAS to create accurate data mapping within functional requirements.
• Assisted in logical data modeling, schema design using Erwin data modeler.
• Responsible for analyzing and understanding database Schema and perform regression testing for data migration using Extract, Transform and Load (ETL) tools like Informatic Power Center.

• Processed and analyzed large data sets and developed presentations of analysis, trends, metrics and results to management.
• Researched different functions and aspects of MDM to optimize the performance of existing and future jobs.
• Analyzed Requirements and created Use cases, Use Case diagrams, Data Flow Diagrams using Visio.
• Clarified User Stories during developing phases, eliminated misunderstanding towards requirements.
• Prioritized the User Stories according to their impact on the project and clients need.
• Communicated and verify User stories and acceptance criteria with business partners to improve the quality of user stories.
• Conducted sprint release plan, delivered product backlog, conducted planning poker meeting, facilitated daily scrum meeting and sprint review meeting.
• Facilitated scrum master to conduct burn down chart and participated in generating reports using Tableau BI.
• Participated in User Acceptance Testing to confirm that the coded product successfully implements the software specifications and User Experience Design.
• Provided end user support and training to the business users, in terms of new application training, demo’s and assistance with new features, and on boarding new users.
• Attended Retrospective Meetings to improve the quality of all deliverables.

Environment: Oracle Database 8i / 9i, SQL*Plus, PL/SQL, Oracle 9i Data Guard, Red Hat Linux AS 2.1, MS Visio, SAS, R, Quality Center, JavaScript.

Jr. Data Analyst

Confidential

Responsibilities:

• Involved in Preparing Test Plan and Test Approach.
• Participated in Requirement Analysis, Use-Case Analysis and Gap Analysis.
• Test Development was implemented under Agile/Scrum Methodology.
• Coordinated Daily meetings, Sprint Retrospectives and Scrum calls and Analyzed user Stories.
• Developed Test Artifacts for each Sprint.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix in IBM Rational Test Suite.
• Organized meetings for Test Plan Reviews and Test Approach Summary.
• Tested ETL jobs used for creating the warehouse using Informatica.
• Tested the ETL applications and ETL Process using Informatica.
• Developed Test Plans, Test Cases for ETL/Data Warehouse applications.
• Executed sessions and batches in Informatica and tracked the log file for failed sessions
• Validated Informatica transformation loading process by using SQL and PL/SQL
• Tested DW reports developed in Business Objects.
• Responsible for Backend testing and executing SQL queries
• Wrote extensive PL/SQL and SQL queries to validate conversion of data from the source warehouse tables to target tables.
• Helped in testing and validating reports created using SSIS/SSAS
• Conducted Back-end Testing on Oracle database whenever necessary using SQL
• Queries via Oracle SQL Developer.
• Written queries in Access, TOAD, SQL Developer and Db Visualizer.
• Executed Test Scripts and Opened defects.
• Trained other testers and Communicated with development team regarding fix status and timelines.
• Used Clear Quest extensively for Defect Tracking, Creating Queries for Defect Reporting.
• Actively participated in walkthroughs, weekly QA status, Defects and SME meetings.
• Conducted Integration, System, Functional, GUI, Regression, Smoke, Database Integrity, User-Acceptance (UAT) and Performance testing.
• Responsible for the documentation of the whole Testing Process of Core Applications for future Acquisitions.
• Active Participation in Implementation Plan Reviews

Environment: Informatica, Business Objects, SQL, PL/SQL, SQL Developer, Advanced SQL, Oracle 9i, SQL server 2005, Db Visualizer, Java, J2EE, EJB, Java Scripts, Business Objects, FORTENT/Searchspace, KYC 3.2, Rational Clear Quest, Java, V.B 6.0, Oracle, DB2, MS Office, Windows XP