SUMMARY:

• Strong understanding of Dimensional Modeling, Star and Snowflake schemas.
• Extensive knowledge of Oracle Business Intelligence Enterprise Edition 11g
• Extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as a Developer and Analyst.
• Preparing Dashboards using calculations, parameters in Tableau knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Bubble Charts, Tree Maps, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Development experience includes Oracle BI Analytics Repository (.rpd) which consists of: Physical Layer, Business Model and Mapping Layer, Presentation Layer, Interactive Dashboards, Reports with drill-down capabilities using page and dashboard prompts and other Web Catalog Objects such as Filters, Folders
• Extensive knowledge of setting up Data Level Security.
• Extensive knowledge of tuning report/query performance by utilizing aggregate tables, materialized views etc.
• Extensive experience in building Interactive Dashboards with drill- down and drill- across capabilities
• Experience in modeling aggregate tables to speed processing and building calculated measures for the fact tables.
• Hands on experience in developing OBIEE repository development, configuring metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports).
• Experience in creating dimensional hierarchies, level-based measures and adding multiple sources to business model objects.
• General knowledge of query languages such as R; Python; SQL; SAS
• Experience with Authorization to the external tables.
• Experience in setting up a Multi-User Development Environment (MUD) and using OBI Answers to run queries to test and validate the repository.
• Proficient in using the Time-Series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts and creating pivot tables using OBI.
• Use of Key Performance Indicators for clear analysis for business users
• Strong knowledge in working with core Java
• Quick learner, able to work with conflicting priorities, excellent team player with the ability to meet deadlines under pressure.

TECHNICAL SKILLS:

BI Tools: OBIEE 11gR1/R2, 10.1.3.x, Web Logic Server 10.3, 10.3.3, Tableau

Languages: XML,HTML,python,Java,C++,SQLServer Management studio 2008

Languages/Utilities: SQL,SSRS, PL/SQL, C++, Core Java, TOAD, UNIX Shell Scripting, LINUX, Java Script, XML, HTML, SQL Server Management Studio, Python, CSS, Apache Tomcat, MS Office Suite, Eclipse IDE

EXPERIENCE:

Tableau Developer

Confidential, Philadelphia, PA

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Improve SDLC processes and capabilities to deploy a Point-Of-Sale/Service enterprise application
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• 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.
• 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.
• Automate regular repository back up based as per business needs.
• Analyzing the existing system and to identify the areas of improvement.
• Create Technical design document, provide end user training and training manual.
• Experience with statistical software packages (SPSS, SAS, Stata)
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Create the public objects like metrics, filters, prompts, custom groups, consolidation and reports.
• 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.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: TableauDesktop 7 &8.3,9.2TableauServer,MS Office Suite,SSRS,Oracle sql, MS. Excel

Tableau Developer

Confidential, Westborough, MA

Responsibilities:

• Involved in creating database objects like tables,views to maintain data efficiently
• Building customized interactive reports and dashboards
• Report scheduling using Tableau server.
• Created action filters, parameters and caluculated sets for preparing dashboards and worksheets in Tableau.
• Performed objective assessment of the SDLC processes and capabilities to effectively mitigate risk and test a Point-Of-Sale/Service enterprise application
• Creating row level security like restricting access of data.
• Developed Tableau workbooks from multiple data sources using data blending
• Developed Tableau visualizations and dashboards using Tableau desktop
• Advocated, mentored and drove policy and process improvements throughout the product development life cycle / SDLC to support organizational objectives for CMMI-2 & 3 process compliance and to achieve business, operational, and engineering goals
• Worked on Enterprise data Integration tool (Informatica) testing the data migration from IBM DB2 to Oracle Database and reviewed the mapping document and developed test cases for ETL testing.

OBIEE Developer

Confidential

Responsibilities:

• Analyze and Gather business requirements to provide better & enhanced reporting solution
• Created the Technical Specification Document and Functional Specification Document based on business specs.
• Configured OBIEE Repository to provide Analytical Reporting solutions to business.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements.
• Implemented MUD (Multi User Development) Environment.
• Implemented Security & Cache features to accommodate business requirements.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs.
• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users.
• Tested ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database
• Used prompts such as Global Filters, Column Filters for the manager to select particular column
• Used the Catalog manager and maintained the web catalog to manage Dashboards, Answers.
• Developed various reports using OBIEE presentation services.
• Extensively worked in Dashboard Prompts, Page Prompts, Narratives and presentation variables in the RPD and Dashboards.
• Involved in setting up Data level security for the OBIEE Reports and also handled the security and privileges from the Database to the Oracle repository.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Tailored SDLC process artifacts to support in corporation of requirements management and design tools: CaliberRM and Together Architect
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports
• Use of Key Performance Indicators in viewing the results from the database.
• Worked on SSIS,SSRS interface.

OBIEE developer

Confidential

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements.
• Involved in creating the Star Schema, Logical and Physical Modeling.
• Built the repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer).
• Created Complex Joins, Alias Tables and Views.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance.
• Worked extensively on Answers, Delivers, and Interactive Dashboards for Procurement and Spend Analytics.
• To prepare and deliver a variety of interactive and printed reportsused SSRS along with crystal reports.
• Developed Various Dashboards and Reports and Created the Business Model for Ad-hoc queries using Oracle BI Answers and assigning them to application specific dashboards.
• Designed the Row Level Security for the Managers to View the Reports pertaining to their Region.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Involved in Testing the reports and writing Test cases for Reports developed.
• Installed and configured Oracle BI Publisher and its integration with Oracle BI Presentation services.
• Analyzed the Functional specifications provided by the Data Architect and Created Technical