SUMMARY

• Over 9 years of extensive experience in Report design, Dashboard development, Administration
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• Proven ability to deliver and ensure success in high - pressure/high-risk situations.
• Involved in many aspects of the SDLC including requirements gathering, proof of concept delivery, Implementation, user support and maintenance.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization Dashboards.
• Created incremental refreshes for data sources on Tableau server.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble ChartsTree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and making use f actions, other local and global filters according to the end user requirement.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu options and Parameterized view selections in Tableau.
• Worked on moving Tableau Dashboard from Development to Production Live Environment.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards in Tableau.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help Users to identify critical KPIs and facilitate strategic planning in the organization.
• Extensive knowledge of Data Warehousing concepts, RDBMS and multi-dimensional schema (Star Schema and Snowflake Schema) and worked on both OLAP and OLTP databases.
• Experienced in all activities of full life cycle implementation including Project management, requirement analysis, Data Modelling, Design, Specification development, Reporting, Web publishing, Portal integration, Performance tuning, testing, Documentation and maintenance in Tableau
• Business analyst experience interacting with end users, functional/technical experts and management to identifying, analyze and developing the reports that meet the business needs.
• Strong knowledge of business/process data flow in organizations and experienced in data modelling Concepts.
• Strong experience on Universe Design Tool for Creating Universe.
• Extensively worked on development of Web Intelligence, Desktop Intelligence Reports.
• Hands on experience writing SQL Queries.
• Strong knowledge of all phases of Software Testing Life Cycle (STLC) along with agile development methodologies.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries for better performance.
• Experience in Tableau Server & Infrastructure.
• Experience in doing administration, authorization, authentication, security, maintainance, user management, and upgrading of tableau server in single and distributed environments.
• Experience with Tableau REST API to manage and changeTableau Serverresources programmatically, via HTTP and to create custom applications or to script interactions withTableau Serverresources.
• Experience with Tableau JavaScript API tointegrate Tableau visualizations into your own web applications.
• Experience in Installation and configuration of tableau server in cluster environment and in AWS.
• Experience with connecting tableau with SAP HANA and accessing code book from HANA.
• Hands on knowledge of Tableau server backup/restore configurations.
• Ability to migrate the tableau server and its processes and user accounts and data from the old server to the new server.
• Experience in Performance optimization techniques and SQL tuning.
• Implement best practices for Backup, Recovery & DR strategy.
• Good knowledge on troubleshooting and problem solving skills.
• Strong knowledge and experience with Windows Servers, network technologies with Active Directory, SAML for authentication.
• Excellent communication skills, strong team-building and conflict management skills.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

Operating Systems: Windows 9x/NT/2003/2008, UNIX

Languages: SQL, PL/SQL, Java, R, XML, UNIX shell Scripting, JavaScript API.

RDBMS: Oracle 8i/9i/10g/11g, MS SQL Server 7.0/2000/2005 , MS Access 2000, Teradata,13, Teradata 14Visualization Tools Tableau 7.X, 8.X, 9.X, Oracle Data Visualization Desktop 12c

Reporting Tools: Oracle Business Intelligence, MicroStrategy

Other Tools: Toad, Putty, SQL Developer

ETL tools: Informatica

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Sr. Business Intelligence Developer

Responsibilities:

• Gathered and analyzed the business requirements for reporting and dashboard’s needs and worked with Project Manager and ETL team to understand the data in the form of fact tables, dimension tables and measures.
• Delegating, interacting and reviewing work with the offshore team for report and dashboard development
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
• Defined best practices for Tableau report development.
• Effectively used data blending feature in tableau to get data from Teradata and Salesforce.
• Connected with different data sources like Teradata, Flat Files, Custom SQL to meet the desired requirements
• Converted OBIEE Reports to Tableau Dashboards for Advanced Visualizations
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps using show me functionality.
• Created Custom Hierarchies to meet Business requirement in Tableau 9.3
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau 9.3.
• Publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and data before publishing Dashboard.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created Dual Axis, side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Migrated OBIEE reports into Tableau
• Used Group functionality to group all small products and named as other for Business flexibility.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build data and relation that would be used in dashboards to satisfy the business’s needs.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 9.0.
• Experience with Tableau REST API, JavaScript API.
• Experience in Installation and configuration of tableau server in cluster environment.
• Hands on knowledge of Tableau server backup/restore configurations.
• Ability to migrate the tableau server and its processes and user accounts and data from the old server to the new server.
• Experience in Performance optimization techniques and SQL tuning.
• Implement best practices for Backup, Recovery & DR strategy.

Environment: Tableau Desktop 9.3, Tableau Server, Tableau Reader, Erwin, Informatica PowerCenter 9.1, WINSCP, MS Office

Confidential, St. Louis, MO

Sr.Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources from Oracle, Vertica for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop those were published to internal team for review and further data analysisand customization using filters and actions.
• Created fresh and innovative designs and superior data visualization.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer 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 onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Upgraded Workbooks and Dashboards from Tableau 7 to Tableau 8
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Collaborated with cross-functional teams to execute against product roadmaps and contributed new and unique ideas to the design of rich applications/content
• Participated in meetings, reviews, and user groupdiscussionsas well as communicated with stakeholders and business groups.

Environment: Tableau 8.0, Tableau Reader, MS Project, Informatica PowerCenter, PL/SQL, SQL, SQL Loader, Toad.

Confidential, Houston, Texas

Tableau Developer

Responsibilities:

• Worked with business stakeholders and participated in requirement gathering sessions to understand the business needs.
• Responsible for creating dashboards and overall creation of data visualizations.
• Created dashboard designing with effective data visualization of large data volumes from various data Sources (SQL server, oracle, spreadsheets etc.).
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts And Bar Charts, Page Trails, and Density Chart.
• Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, Sets and hierarchies etc.
• Used Oracle, SQL server as data sources for designing Tableau Reports and Dashboards.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF etc.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.
• Expert level capability in Tableau calculations and applied complex, compound calculations to large, Complex data sets.
• Worked closely with reporting team for deploying Tableau reports and publishing them on the Tableau and Share point server.
• Validated data at the row level and data level to ensure completeness and correctness of data
• Reconciled the report data with the source systems and reviewed it to find any data anomalies.
• Created custom date time calculations and macros in the reports.
• Created jobs, schedules and report views for the business users.
• Involved in administrative activities, doing deployment and monitoring schedules and jobs.

Environment: Tableau 7.0, Tableau Reader, MS Project, Informatica PowerCenter, PL/SQL, SQL, SQL Loader, Toad.

Confidential, VA

OBIEE Developer/Admin

Responsibilities:

• Installed and configured OBIEE repository Server, OBIEE Presentation Sever, oc4j, JDK, BI Publisher.
• Migrated and merged OBIEE Repository and Catalogs
• Monitoring the overall usage and taking necessary steps to improve the performance if needed
• Server Space management as per the need.
• Did the Necessary RPD and Catalog upgrades and applied patches as part of admin team.
• Provided extended production support based on the demand and complexity of the issue.
• Implemented Over all security, SSO, OBIEE content and Data level security
• Create/Manage Repository/Web Users and Groups and assigning permissions using Enterprise Manager and Console.
• Worked with Business analysts to identify, analyze and document business requirements.
• Gathered requirements for GAP Analysis, translated them into technical design documents and worked in making recommendations to close the GAP.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Used Siebel CRM as source to populate Data warehouse using Informatica
• Used Siebel CRM prebuilt RPD and Catalog and merged them to existing Dashboards and RPD and implemented Security
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Worked in End to End construction of the BI model from repository to reports development
• Worked with OBIEE Answers, Intelligence Dashboards in OBIEE 11g. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Moved data from one database to other database, using Informatica for data migration.
• Designed and developed physical, logical and presentation layers of the repository with new data model changes.
• Developed dimensional hierarchies to facilitate the drill down and report navigation.
• Configured Bi Scheduler and created iBots to schedule and deliver Analytics content to multiple delivery destinations and also a Cache Seeding mechanism
• Used DAC for both incremental and full loads and created custom Execution plans.
• Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.
• Implemented the Caching Strategy according to the client's data load frequency
• Enabled Usage Tracking to monitor the usage and performance of reports
• Managed/Administered OBIEE web catalog using Catalog Manager
• Implemented MUDE (Multi User Development Environment) in OBIEE
• Created complex measures in BMM(Business Model and Mapping Layer) using Level based Measures, Time Series calculations and different Aggregation Strategies
• Created new Repository Variables, Session variables and Initialization blocks to configure security, data access and authorization on Repository and Catalog objects
• Implemented connection aggregate navigation by creating multiple logical table sources for the same logical table
• Configured the pool settings according to the requirements
• Set up BI publisher Security to control access given to business users.
• Experienced in working with BI (XML) Publisher, Data Templates, RTF, and XSL Templates and provided the capability to download the reports in the user defined formats.

Environment: OBIEE 11.1.1.7.x, BI publisher 11g, Oracle 11g, Toad, PL/SQL, HPUX, Informatica

Confidential

OBIEE Developer

Responsibilities:

• Used Siebel Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository (.rpd).
• Sourced Data from multiple databases & files.
• Worked Extensively on Siebel Answers to create the reports as per the business requirements.
• Configured Intelligence Dashboards by adding embedded content such as links/images, HTML objects and folders.
• Used Catalog manager to maintain Analytics web catalog to manage Dashboards, Answers.
• Designed the logical and physical data model for Siebel data warehouse to store OLAP data.
• Analytics Admin work: New ID creation, Account modification of existing users, Password reset and Deletion of accounts.
• Developed and supported ETL process using Informatica tools.
• Analyzed complex mappings to extract and transfer source data from different databases.
• Worked in ETL process using Informatica for various transactions and loading data from Flat Files and Relational Database. Used different transformations to develop Mappings such as Joiner, Aggregator, Router, normalizer & Expression.
• Designed, Created and used Mapplets for Repeated functionalities.

Environment: Siebel Analytics 7.7, Oracle 9i, Informatica 7.1, Windows 2000/XP, UNIX