SUMMARY

• Over 8+ years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Solid understand of SQL and understand and have worked with various data source types like Oracle and SQL server.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar
• Graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and
• Global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical
• KPIs and facilitate strategic planning in the organization.
• 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 results.
• Experience in configuring reports from different data sources using data blending.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML
• Improved Reports performance in tableau using extracts and context filters
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS

• BI Tools Tableau Desktop 10.3/9.3/9.0/8.3/8.2/8.1/7, Tableau Server 10.3/9.3/8.2, OBIEE 11g/10.1.3.4
• ETL Tools Informatica 7.x/8.x (Power Center)
• RDBMS SAP Hana, Oracle 9i/10g/11g, MS SQL Server 2008, Teradata
• Languages HTML, XML
• Operating Systems Windows 95/98/NT/2000/XP/7
• FTP Tools WinSCP 5.X, Filezilla 3.5.x, Putty

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Sr. Tableau Developer

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Integrated all portfolios, applications, releases, environments, builds, deployments, QA tests and defects by mapping all with DevOps fields, which are auto-generated.
• Data feeds are coming from vElite server from all Jenkins builds and deployments through Rabit MQ. They are auto-inserted into MySQL DB on the backend.
• Showing only one Portfolio now as POS, with simulated Jenkins Turbo Build for ATG Apps.
• All applications are mapped into a specific list of customized pre-defined codes through a mapping data source.
• Working extensively using Excel to validate the data and use as the source data files.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Provided mock up visuals to speed up requirements visualization.
• Hands-on development in creating and modifying worksheets and data visualization Dashboards.
• Created Level of detail expressions (LOD Expressions) data source columns are computed for each row in the underlying table.
• Applied action filters specific sheets in the dashboard and cross dashboard.
• Experience Dual Axes and show the graph in new visualization.
• Good Experience in data blending with multiple data sources.
• Experience in table calculations like windows max and percentage of total.
• Created data source level filters, context filters and cascading filter to improve performance and user flexibility.
• Developed Tabular, drill down, parameterized, cascaded and sub-reporting
• Designed and Optimized Connections Live, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Performance tuning of reports and resolving issues within Tableau Server.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Testing dashboards to ensure data was matching as per the business requirement if any changes in underlying data.

Environment: Tableau Desktop 10.3/9.3/9.2, Tableau server, SQL, My SQL, Hive, Windows 2007, MS-Access and MS Excel

Confidential, Branchburg, NJ

Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & Functional specifications.
• Created Dashboards with combination of charts to help Users to analyze and understand the data and by navigating through the reports for detail analysis.
• Created Parameters, Actions, and filters etc. for detail Visualization to meet end user needs.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Resolved loops by creating contexts for each fact table and also by adding aliases.
• Track the issues and document the development process for program references
• Conducted Training sessions for Tableau users and created the documents for end-user support.
• Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Interacted with the users and troubleshooting the problems involved with the reports, dashboards and problems related to the privileges.
• Hands-on development assisting users in creating and modifying worksheets and data visualization Dashboards.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau.

Environment: Tableau Desktop 9.0,9.2, Tableau server, SQL, Oracle 11g, SAP Hana, Windows 2007 /XP, MS-Access and MS Excel

Confidential, Houston, TX

Tableau Developer

Responsibilities:

• As part of the Development team, Designed and developed innovative dashboard, analytics, and reports using Tableau Desktop 8.2
• Performed data/systems analysis to determine best BI solution (reports, dashboards, scorecards etc.) using Tableau
• Created Adhoc reports in Tableau 8.2 to visualize top incompatible Apps
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up), List, crosstab etc. using Tableau.
• Created complex formulas and calculations within Tableauto meet the needs of complex business logic
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web
• Developed various data connections from data source toTableauDesktop for report and dashboard development
• Created Technical Documentation for reports and maintenance/enhancements of existing Reports
• Involved in project planning, scheduling for database module with project managers
• Discussed with business people to understand the rules for defining the Test Status of Apps at the report level
• Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images and Maps and interacting with SAP Hana modelers to design materialized view.
• Effectively used data blending feature in tableau. Defined best practices for Tableau report development
• Connect Tableau to SAP Hana using Generic ODBC Connection
• SAP Hana live connection experience with extensive report development experience, dash boarding and development of reporting
• Generated Reports using Global Variables, using SAP Hana source
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using
• Analysis of data for the purpose of Product Version Mapping

Environment: Tableau 8.2 Desktop, SAP Hana, MS SQL Server 2008R2/2005 OBIEE, SSRS, Windows 7, Management Studio

Confidential, Philadelphia, PA

Tableau Developer

Responsibilities:

• Analyzed various reports, dashboards, scorecards in OBIEE and created the same using Tableau Desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard to filter data in multiple views at once.
• Involved in new KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Identify new metrics and enhance the existing KPI's.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards.
• Effectively used data blending, filters, actions and Hierarchies feature in tableau.
• Defined best practices for Tableau report development.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.

Environment: Windows XP, Tableau 8.2/8.1, Tableau Server, SQL Developer, MS-SQL 2008 R2, OBIEE 11g MS-Access, MS Excel and JavaScript.

Confidential, Temple Terrace, FL

BI Developer

Responsibilities:

• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Used MUD environment during development of the project.
• Responsible for Creating the Physical Layer, Business Model and Mapping Layer and Presentation Layer in ANA Repository (.RPD) using Oracle BI Administration Tool.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions like Ago(), To Date based on the Requirements.
• Created Attributes and Metrics in the BMM layer.
• Created Aggregated Tables to improve the Performance of the Reports.
• Created Logical Tables, Logical Columns with Measures Calculated as per the Business need.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Business Model to support Ad hoc Reports for User Access based on Requirements.
• Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
• Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Managed Security privileges for each subject area and dashboards according to user requirements.
• Worked on Installation and up gradation of OBIEE 10.1.3.4.1 to 11.1.1.6.0.
• Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations.
• Used theCatalogmanager and maintained the web catalog to manage Dashboards and Answers.
• Test the reports and data in OBIEE against Micro strategy and validate them.
• Responsible for documenting the OBIEE framework and track the progress.

Environment: OBI 10/11g, Informatica Power center 7.1.2/8.1,Oracle 11g, Microsoft Windows Server 2003, MS VISIO.

Confidential, Stamford, CT

BI Developer

Responsibilities:

• Upgraded the existing Siebel Analytics Application on 7.8.4 to Oracle Business Intelligence 10.1.3.2
• Migrated the existing Web Catalog using SAW Migrate utility.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Added Aggregate measures using Aggregate Persistence Wizard.
• Configured Business Intelligence Delivers
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Designed and implemented the single sing on (SSO) functionality.
• Involved in setting up Clustering of Oracle BI servers for Load Balancing.
• Developed automation tool to seed and purge the cache in Admin tool.
• Migrated the Repository from Development to Production using UDML Utilities.
• Designed Interactive Dashboards and created dashboard prompts.
• Involved in configuring sources, targets, tasks and execution plans using DAC.
• Have developed requests/custom reports using Siebel Answers based on Sales and Promotion subject areas in order to analyze and understand the Sales Opportunities and Promotion details by Brands/Promotions, Forecast to Estimated spending.
• Involved in development of reports like campaign budget break even (CBAB) and campaign management reports
• Involved in Query Tuning to maximize the performance of reports and Dashboards.
• Used Informatica to extract the data from Siebel CRM, transform and load to warehouse.
• Acted as a single point of contact for the Global data mart for coordinating the development across the platform. Responsible for onsite- offshore co-ordination.

Environment: Oracle Business Intelligence 10.1.3.2,Siebel Analytics 7.8.2/7.8.4, Siebel 7.5.3.4, Informatica Power center 7.1.2/8.1, DAC 7.7,Oracle 10g.