SUMMARY

• Seasoned Business Intelligence professional with 9 years of experience in design, testing, implementation, and deployment of enterprise BI applications at multiple clients with special emphasis Tableau, Oracle Business Intelligence (OBIEE), OBIA, Informatica.
• Expertise in Tableau 9/10.x, Tableau Reader and Tableau Server.
• Hands on experience implementing comprehensive dashboards, data visualizations and analytics using Tableau desktop for Netezza SQL, Python and Unix Code.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Performed administrative and support activities across a multi - environment Tableau infrastructure including security implementation, release management and report trouble shooting.
• Experience in analyzing BI needs and good interaction with clients, understanding Business Applications, data flow and data relation.
• Developing and maintaining OBI Repository (RPD) at all three layers (viz. Physical Layer, Business Model & Mapping Layer, Presentation Layer) on OBIEE 11g/10g etc.
• Extensive experience in developing Interactive Dashboards with drill-down capabilities, Security Implementation (Creating groups, grant access privileges, data level and report level), Metadata and Web Catalog Objects (pages, folders, and reports) and scheduling reports using BI Delivers.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Experience in using Informatica and Data Warehouse Administration Console (DAC) tools to Configure, Monitor and Schedule ETL routines/ Informatica TDM, ODI 12C and BI Publisher.
• Hands on experience in 3M Grouper Software by CGS.
• Cross trained on Alteryx, Azure Data Factory and Power BI.

TECHNICAL SKILLS

BI Tools: Tableau Desktop and Server, OBIEE 11.1.1.7.1 ,11g/10.x, OBIA 7.9.x

ETL: TDM, Informatica 8.6/8.1/7.x, ODI (Oracle Data Integrator 12C).

Data Warehouse: SAP BW (SAP NetWeaver, FI and SD modules), DAC, SQL* Loader

ERP Modules: Oracle Revenue Management, Supply Chain and Order Management, AR, AP

RDBMS & Programming Languages: Oracle PL/SQL, Teradata, SQL Developer, TOAD, IBM Netezza, Core Java.

Automation Tools: Selenium RC, Selenium Web driver, Selenium Grid, Selenium IDE and TestNG.

PROFESSIONAL EXPERIENCE

Confidential, Oakland CA

Sr. Tableau Developer

Responsibilities:

• Identified different internal and external sources for the Machine learning applications.
• Performed Source to Target Mapping for the data elements and performed GAP Analysis for the data in the warehouse.
• Participates in Functional and Technical Requirements discussions along with Business Stakeholders, gathered test data requirements from project/testing teams.
• Used IBM Netezza SQL Scripts to maintain ETL frameworks and methodologies in use by the company and conducted code Analysis for the Python Scripts and Unix Code.
• Developed code for Initial and Incremental loads for a BSC Datamart.
• Developed, tested, and maintained Tableau functional Reports based on user requirements.
• Created action filters, parameters, and calculated sets, statics for preparing various dashboards and worksheets on Tableau Desktop, utilized Tableau server to publish and share the reports with the business users.
• Wrote Custom SQL to support business requirements.
• Supported and mentored BI Super users and Data Analyst to align analytics and data governance across the organization.
• Worked on Advanced Analytics, used Web Connectors and restricted data for users using Row level security and User filters.
• Developed Tableau data visualizations with Cross Tabs, Heat Maps, Box and Whisker charts, Scatter Plots, Geographic, and Pie, Bar, Donut Charts, and workbooks from multiple data sources using Data Blending.
• Implemented row level security for the Tableau dashboards and used various advanced table calculations by configuring reports that help measure performance and progress within healthcare improvement programs.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Build, published customized interactive reports and dashboards, report scheduling using Tableau Online.
• Worked on “Enhanced Ambulatory Grouping System” 3M EAPG Grouper Software by passing Input and generated Output based on customized Templates.

Confidential

Tableau Developer

Responsibilities:

• Demonstrate Test data in Health management of Legacy Applications support functions while constantly striving to implement Development strategies.
• Includes consulting with business clients, creating Tableau dashboard reports, collaborating with developer teams, using data visualization tools, and using the Tableau platform to create business intelligence visualizations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Extensively involved in creating graphs by using measures and dimensions data from various databases using data blending concept in Tableau.
• Involved in reviewing business requirements and analyzing data sources from Flat file, Excel, SQL Server for design, development, and analysis projects within Tableau Desktop.
• Created different KPI using calculated fields using key figures and extensively used Advanced analysis Actions, Calculations, Parameters, Maps and Table Calculations.
• Provide Production support to Tableau users and wrote custom SQL to support customized Reports.
• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into Tableau.
• Experience in using Tableau functionalities for creating different Requests, Filters, Chart, Interactive dashboards with Page and Dashboard Prompts.
• Ensured the user security for the views using User filters and shared with business users.
• Published the developed dashboards into production and refreshed the scheduled extract, tuned the performance of the dashboard, and created Tableau functional design document.
• Provided Hardware and Software Procurement details to the client.

Confidential, CA

Informatica/Tableau Developer

Responsibilities:

• Worked on 2 different projects and that involves technologies after cross train on Tableau Reports as a POC and Informatica TDM for test data.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security and used quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Performed data extraction from external sources using ETL tools like Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Understood the existing ETL design, relational database and performed Informatica activities.
• Involved in Data Masking -Data Creation, Masking of sensitive fields and loading of Masked data to non-production environments.
• Validation and verification of Duplicate fields, Data continuity, Row counts and Joins.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Status tracking of monthly, quarterly, and annual goals and status update to senior management.
• Socializing/Education sessions for App owners and solicit special masking requirements.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Involved in installation and configurations of Informatica and TDM 10.1 version on Linux Server.
• Provided Hardware and Software Procurement details to the client.
• Analysis of collected data to define Rollout sets, Strategy & initial Plan, to define infrastructure plan for masking program.

Confidential

Informatica Developer

Responsibilities:

• Primary responsibilities include gathering business requirements, designing the functional and technical specifications.
• Modeling activities that include building star schema (Teradata Views) as per the business requirements.
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems by incorporating business rules using different objects and functions that the tool supports.
• Used Source Analyzer & Warehouse Designer to import the sources and targets databases.
• Used mapping designer to map source to the target with required Business logic.
• Developed reusable mapplets using mapplet designer.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules and used various transformations like Source Qualifier, Joiner, Lookup, and router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used Workflow manager for session management, database connection management and scheduling of jobs. Monitored sessions using the workflow monitor, which were scheduled, running, completed, or failed. Debugged mappings for failed sessions.
• Worked extensively to customize Informatica, DAC Execution Plans, Subject areas, Task Definitions and Tables for OBIA Financial and Supply Chain Analytics.
• Worked extensively to customize DAC Execution Plans, Subject areas, Tasks, Task Groups and Tables for OBIA to configure, monitor and schedule ETL routines.

Environment: Informatica Power center 9.0/8.6, Informatica MDM, oracle 11g/10g, Unix, Unix Shell Script, Dollar Universe, OBIEE 10.1, TOAD, Teradata, SQL Assistant.