SUMMARY

• Having over 11+ Years Experience in diversified business domains in large Organizations including Banking, Finance,Telecome, e - Commerce, Logistics, Healthcare and Insurance Domain with a strong experience of business processes and ability to work as a Team lead, part of a team or independently.
• Having good experience in Business Intelligence, Data warehousing, Data modeling on working with Tableau, OBIEE,OBIA, Informatica, OracleSQL/Plsql and Business Analysis.
• 10 years of experience working with Data visualization and BI tools like Tableau, OBIEE and Cogons Reports.
• Experience including analysis, modeling, design and development of Tableau reports and dashboards for analytics and reporting applications.
• Tableau Administration - Infrastructure Builds and Maintenance
• Good experience in Tableau Desktop, Tableau Reader, OBIEE Dashboards, KPI’s and agents in various versions of Tableau8/9/10 and OBIEE 10g &11g.
• Worked extensively on joining tables, multiple data connections using data blending, worked on Data Extracts and managing queries.
• Very good experience in using Custom SQL, aggregations, calculated fields like Level of Detail, Quick calculations, Running totals and logical, string, number, date calculations.
• Extensive knowledge of various reporting objects like Facts, Attributes, Hierarchies, Transformations, prompts, Sets, Filters, sorts, Groups, Parameters etc.,in Tableau.
• Experienced in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps, stack, combination chart, circle view and Highlight tables.
• Expertise in Pareto charting, advanced calculations, work with demographic and geographic fields.
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimension tables, physical and logical data modeling.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Good experience in Converting the existing OBIEE reports into tableau dashboards and Scheduling &deploying the dashboards from Tableau server.
• Proficient in Installation, configuration, administration and up-gradation of the OBIEE platform.
• Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources of business model objects in OBIEE.
• Skilled at creating and scheduling IBOTS (Agents) in Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
• Database Tables and configuring the object level and data level security.
• Very proficient in working with large Databases in DB2, Oracle, Teradata and SQL Server.
• Solid experience in translating business requirements into the creation of Database Objects and developed complex, reliable, professional database applications by using Oracle PL/SQL and SQL.
• Strong Exposure in writing Simple and Complex SQL(DDL,DML & DCL) statements, PL/SQL Functions, Procedures, Packages and creation of Materialized views, Triggers, Nested Tables and Collections.
• Significant experience in the Disaster recovery activity
• Good Knowledge on Micro strategy.
• Good knowledge on Python Data analysis.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction.
• Significant experience in 24/7 Production Environment Support.

TECHNICAL SKILLS

Business Intelligence Tools: Tableau Desktop 8.2/9.2/9.3/10, Tableau server 8.3/9.3/10, OBIEE 10&11g, BI Applications 7.9.X, Cognos Impromptu

ETL Tools: Hadoop (CDH5),Informatica Power Center 8.6/8.1.1/7.1/6.1, SSIS 2005/2008R2/2012

Operating Systems: Windows 7/VISTA/NT/ XP/ 2000/ 95/ 98, LINUX/UNIX.

Databases: Hive/Impala, Oracle 9i/10g/11g,SQL Server 2012/2008/2005, IBM DB2 UDB 8.2, Teradata

Programming Languages: SQL, PL/SQL,C++, Core Java, Java Script, HTML.

Networking Protocols: TCP/IP, UDP, IP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Boston

Tableau Lead Developer/Tableau Administrator/Architect

Responsibilities:

• Gathering business requirements and translate them into the technical documents
• Work closely with business leaders and users to define and design the data sources requirements and data access.
• Tableau Administration - Infrastructure Builds and Maintenance
• Tableau Administration - Performance Testing and Availability
• Maintaining Security and Create/manage Users, Groups, Licenses and integrate with Active directory.
• Setup Sites and Access policies
• Gather requirements for Capacity planning and load balancing a multi node server installation
• Monitor server activity/usage statistics to identify possible performance issues/enhancements
• User Management/Change Management
• Monitoring and tuning of the Tableau servers
• Involved in development/Test/Prod/Disaster recovery server installation and configured the active directory for user access.
• Configured Trusted Authentication mechanism for all the servers.
• Administered user, user groups, and scheduled instances for reports inTableau
• Configured the single sign on using SAML
• Set up a cloud era hadoop impala connection using Kerberos and Ad key tab option.
• Configured native application using Confidential portal
• Monitor the Tableau server health issues.
• Implemented row level security based on the users login.
• Created the various visualization based on the user requirements.
• Generated Dashboards with Quick filters, Parameters, sets & groups to handle views more efficiently.
• Using cloud era impala as a source created the workbooks.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data
• Generated context filters and used performance actions while handling huge volume of data
• User Java Script API to customize the views, selects, filters, date and time.
• Analyzed the source data and handled efficiently by modifying the data types
• Generated tableau dashboards with combination charts for clear understanding
• Created different kind of visualizations like Dual axis, combined sets, pie chart, stack bar chart, Line Chart and Geo maps
• Built complex reports using table calculations and Tableau predefined functions for developing Reports
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Involved in data validation of the reports.
• Implemented Tableau security, back-up and restore process
• Provided production and admin support of Tableau BI reporting solutions
• Achieved drastic improvement in performance of the reports by fine tuning the rendering time
• Participate in the test planning and performs testing activities including unit, integration and user acceptance testing.

Environment: Microsoft Windows 12 (Client Tools), Tableau Desktop 9.3,Tableau Server9.3,ESP,Oracle 11g,Cloud era hadoop(CDH5),Hive/Impala.

Confidential, Blue Bell

Tableau Lead Develpoer

Responsibilities:

• Gathering business requirements, creating business requirement documents (BRD /FRD).
• FIT and GAP analysis of the existing system and propose new solutions.
• Work closely with business leaders and users to define and design the data sources requirements and data access
• Translate the Functional requirements into Technical design documents.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
• Extensively Used Data Blending to Join Multiple Data Sources
• Generated Dashboards with Quick filters, Parameters, sets & groups to handle views more efficiently
• Generated context filters and used performance actions while handling huge volume of data
• Analyzed the source data and handled efficiently by modifying the data types
• Generated tableau dashboards with combination charts for clear understanding
• Created different kind of visualizations like Dual axis, forecasting, combined sets, pie chart, stack bar chart, Line Chart and Geo maps
• Built complex reports using table calculations and Tableau predefined functions for developing Reports
• Developed Tableau workbooks to perform Year to date, Period to date compared to last year type of analysis
• Good knowledge oftableauserver, administrative functions, installation, configuration, back up of servers
• Experienced in Performance tuning of dashboards
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports
• Defined architecture forTableau, established Dev/QA/Prod environments
• Setup new projects, security groups, roles and administer users for all supported platforms
• Administered user, user groups, and scheduled instances for reports inTableau
• Implemented Tableau security, back-up and restore process
• Implemented Tableau Failover configuration
• Use the Tableau JavaScript API to integrate Tableau visualizations into web applications
• Maintenance and scheduling of Tableau Data Extracts using Tableau Server
• Troubleshoot and debug the issues with the help of tableau server log files.
• Monitoring ofTableauServersfor its high availability to users
• Provided production and admin support of Tableau BI reporting solutions
• Provide appropriate training and support to business users on the use of Tableau interactive web reports, and Tableau Desktop.
• Developed and document standards/best practices for development and administration of the Tableau platform.
• Achieved drastic improvement in performance of the reports by fine tuning the rendering time
• Participate in the test planning and performs testing activities including unit, integration and user acceptance testing.

Environment: Microsoft Windows 7 (Client Tools), Tableau Desktop 9.2,Tableau Server9.2, SSIS, Sybase, SQL Server 2012, SQL Developer

Confidential, Pittsburgh

Tableau Lead Develpoer

Responsibilities:

• Analyses .IQD queries and created GAP Analysis Document, shared the same to the business group to highlight and resolve the open GAPs.
• Created the technical Design Document the based on the Functional requirement document
• Design and development of Tableau visualization solutions.
• Creating extracts and publishing data sources/workbooks to server.
• Involved in reviewing business requirements and analyzing data sources for design, development, testing of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop those were published to further data analysis and customization using filters and actions.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau
• Created Cascading dashboards, data extracts Action filters for better performance of Tableau
• Also involved in administrative tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Scatter Plots, Geographic Map, Cross tabs, etc.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• 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.
• Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application.

Environment: Microsoft Windows 7 (Client Tools), Tableau 8.2,Cognos Impromptu, Informatica 8.6,Oracle 11g.

Confidential

Tableau Lead Developer/Tableau Administrator

Responsibilities:

• Created adhoc reports to users in Tableau by connecting various data sources.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it and Embedded the Tableau views in to SharePoint
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and reference lines.
• User Java Script API to customize the views, selects, filters, date and time.
• Generated tableau dashboards with combination charts for clear understanding.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Transformed TABLEAU into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.
• Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Ensured projects were completed on time and within budget.

Environment: Microsoft Windows 7 (Client Tools), Tableau Deskop 8.1 and Tableau server 8.1,SQL Server 2008

Confidential

OBIEE Lead Develpoer

Responsibilities:

• Upgrade the reports from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.5.
• Involved in completely on Oracle BI servers and applications, setting up the Oracle BI environments for different projects.
• Involved working with Development teams on the environmental systems.
• Applied OBIEE patches to upgrade to higher versions
• Customizes the existing OBIEE reports based on the user requirement
• Working with business partners to get the business requirements sign off.
• Co-ordinate and remediate the business requirements into Dimension Models.
• Work with business DBA, Business Analyst, End Users to capture reports requirement and translating them to technical design
• Configured and designed and created OBIEE Repository of physical, business and presentation layers of metadata repository using OBIEE Administration Tool.
• Created dimensional hierarchies and level based measures.
• Created the various calculated metrics using calculationwizard.
• Supporting Administrative technical issues related to OBIEE in Integration and Production environments.
• Configured the metadata report to easily identify the database source columns.

Environment: Linux (Server), Microsoft Windows 7 (Client Tools), OBIEE 10.1.3.4.1, OBIEE 11.1.1.5, OBIEE 11.1.7.1, SSIS 2008 R2, SQL Server 2008

Senior OBIEE Developer

Responsibilities:

• Lead Migration and implementation of OBIEE 11.1.1.6.
• Assistance in validating and implementing recommendations based on review of the OBIEE 10g repository.
• Gathering business requirements, creating business requirement documents (BRD /FRD).
• FIT and GAP analysis of the existing system and propose new solutions.
• Working with business partners to get the business requirements sign off.
• Co-ordinate and remediate the business requirements into Dimension Models.
• Work with Confidential ’s technical and functional resources to validate VMDash metadata design and implement identified retrofits.
• Fix metadata warnings arising during consistency checks through appropriate application of design principles or workarounds.
• Assisting Confidential technical team in their validation of the OBIEE 11g upgrade and production roll out of the upgraded OBIEE 11g application.
• Re-create Usage Tracking
• Establish OBIEE 11g Test environment and OBIEE 11g Production environment based on Configuration management standard practices.
• Integrate RPD and Catalog content between environments and establish uniform architecture across all Confidential environments
• Support Confidential technical team during user testing of OBIEE 11g
• Provide oversight and guidance for the technical team in OBIEE 11g administration tasks
• Provide oversight and guidance for the technical team in OBIEE 11g custom LDAP security integration.
• Implemented Cache Management (Cache Seeding and Cache Purging).

Environment: Linux (Server), Microsoft Windows XP (Client Tools), OBIEE 10.1.3.4.1, OBIEE 11.1.1.6, OBIEE 11.1.1.5, Informatica 8.6, Oracle 11g Database, SQL Developer

OBIEE Developer

Responsibilities:

• Involved in design, analysis, development, testing and deployment of reports in OBIEE 10g.
• Configured and designed and created OBIEE Repository of physical, business and presentation layers of metadata repository using OBIEE Administration Tool.
• Used the OBIEE Administration tool to develop and enhance Data Model.
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Developed custom reports/Ad-hoc queries using Answers.
• Developed complex and rich reports using pivots tables, charts, and view selector. Used global and local Filters for data abstraction.
• Managed security privileges for each subject area in repository and web catalogue according to user requirements.
• Design, develop, test and prepare detailed specification of new requirements
• Supporting Administrative technical issues related to OBIEE in Integration and Production environments.
• Migrated reports from Microstrategy to OBIEE
• Testing, debugging and Performance Tuning applications prior to user acceptance testing (UAT).

Environment: Linux (Server), Microsoft Windows XP (Client Tools), OBIEE 10g,Microstrategy 8.0 X, Informatica 7.2,Oracle 10g Database, Toad, SQL Developer

Confidential

Responsibilities:

• MUDE - leading and supporting off-shore developers.
• Experience performing data validation on enterprise reports.
• Expertise with OBIEE Repository, report and database performance tuning.
• Strong SQL skills, written and verbal communications.
• Identified Facts, Dimensions, and Hierarchies of the business model.
• Identified the granularity level of the business model based on the end user requirements.
• Used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Replaced iDashboard reporting with OBIEE Analysis and Dashboards to create the reports according to user requirements.
• Created complex mappings to load the data mart and monitored them.
• The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.

Environment: Linux (Server), Microsoft Windows XP (Client Tools), OBIEE 10g, Informatica 7.2Oracle 10g Database, Toad.