SUMMARY:

• 10+ years of strong hands on experience in area of Business Intelligence & Data Warehousing with 6+ years on Tableau reporting and visualizations.
• Strong understanding of business requirements and transforming them into designs and implementation.
• Ability to interpret underlying data and communicate actionable insights effectively to various business groups
• Highly experienced in implementing custom & real - time reporting solutions
• Understanding of testing process and performance tuning on BI tools.
• Quick learner with strong communication and client handling skills.
• Ability to write complex sql queries.
• Experienced in client facing roles.
• Individual as well as Team contributor
• Excellent analytical skills with strong technical background having the ability to meet deadlines and quickly master new technologies and skills.
• Successful track record in delivery & execution of BI Projects through onsite-offshore models.
• Experience working with Consumer Finance, Re-marketing, Automotive, Supply Chain Manufacturing and Healthcare domains.
• Excellent Experience Managing & Lead Projects (Waterfall/Agile)
• Prior consulting experience working one of the BIG4 Accounting firms
• Strong knowledge with Microsoft Office software
• Knowledge on R &Amazon Redshift
• Certified on Tableau, OBIEE and Cognos (Internal)

TECHNICAL SKILLS:

Business Intelligence Tool: Tableau 9.1, OBIEE 12C, OBIA - 7.9.X, OBIEE 10.1/11.7.1. x,BI Publisher Cognos 8.1

Data Integration Tools: Informatica 9.1, SSIS, SAS

Databases: Netezza/ Agility Workbench, Teradata, Oracle, MS SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

Sr. BI Developer (Tableau)

Responsibilities:

• Worked with business users in identifying key metrics and document functional and non-functional requirements
• Provided effort estimations for BI scope across enterprise.
• Recommend Data visualizations best suited for the business in order to facilitate more insights into the data.
• Implemented enterprise wide design solutions on dashboards and analytical reports.
• Worked with data analysts in building aggregated/summarized tables to provide better performance and scalability.
• Created great visualizations and stories/dashboards using Tableau Desktop & online version.
• Worked on Data Blending and importing multiple data sources into single dashboard
• Worked on advanced features of Tableau such as Include/Exclude/Fixed and using various time related functions.
• Used Sheet filters to produce multiple chart types in a single view.
• Built reports on Predictive and Diagnostic Analytics
• Performed gate reviews of all the reports across various data marts before moving to UAT & Prod environments
• Involved in report migration across different instances and versions
• Participated in BI tool selections based on analytical needs of the customer
• Maintained repository catalog and performed Admin activities on Reporting server
• Built customized reports/dashboards for different business units in the project lifecycle.
• Planned and coordinated deployment of releases in Production.
• Led cross-functional teams to execute deliverables.
• Gave presentations & demos to various user groups on BI Tools used in the organization and facilitated self - service reporting capabilities.

Environment: Tableau Desktop 9.1, Tableau Server, Netezza, Oracle, MS Access, Active, TABADMIN, TABCMD, CSV files, Apache 2.2, Share point, TDE Files,Aginity Workbench, Unix, OBIEE 12C

BI Developer (Tableau)

Responsibilities:

• Involved in Requirement gathering process with business users on understanding source systems, perform gap analysis, creating POCs on desired layout/functionality and participate in Playback Sessions.
• Experienced in converting OBIEE content into Tableau BI content
• Involved in design discussions with source/db.Teams in translating the reporting requirements with possible data modeling and table structures to fulfill reporting req.
• Defined best practices for Tableau report development.
• Performed Data acquisition, Data Transformation and Data Consumption
• Prepared the design documentations along with mapping elements for quick reference for the IT and business teams.
• Semantic modeling - Import Metadata in Data Source Page, provide physical joins to develop into star schema layout, add logical/calculated columns.
• Created various parameters and custom filters to support the requirements
• Report Development includes creation of interactive &intuitive Dashboards.
• Closely worked with multiple vendors/stakeholders during project lifecycle.
• Involved in following tasks like user set up, assigning of Roles & Groups, analyzing query logs, Start/Stop Services, Deployments to prod and non- prod environments
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Implemented data based Security filters on user logins.
• Experienced in providing Tableau server and tableau desktop training.

Environment: s: Tableau server, Tableau Desktop v7/v8, Oracle, Linux, OBIEE 11g, RPD

BI Consultant

Responsibilities:

• Participated in various requirements, design and development meetings
• Developed RPD modelling and imported DB objects into Physical,BMM and Presentation layer
• Created Report Specs for in corporation of logics in reports.
• Complex reportsand Dashboards development using OBIEE 10g
• Created Ibots and guided navigation reporting
• Worked on creating hierarchies and calculated fields in RPD
• Developed Drill through reports,listreports.pivot reports
• Added users and groups in Console
• Data validation and end to end testing
• Wrote sql queries to validate the data from reporting till etl tables/views.
• Worked with Oracle in support issues and followed up on SR resolutions.
• Altered config files in order to increase the export and display limits on presentation layer
• Conducted user sessions and mentored the team
• Worked on OBI Apps for customizing Out of the Box dashboards and reports for Contact Center and Supply Chain modules

Environment: Oracle Business Intelligence Suite, OBI APPS, SQL Server, MS Excel 2003/2007, MS Access 2003, Windows, Oracle 10g

Senior Engineer

Responsibilities:

• Imported Metadata from Source.
• Created Determinants based on Index-key value pairs.
• Created Star-Schema grouping for the underlying base tables available in the data mart.
• Involved in creating the data extraction and loading process from heterogeneous sources Informix and SQL Server.
• Created calculations at the database level to include Time Dimensions.
• Involved in creating the hierarchies and levels for the identifed dimensions and associating them with the measures which comply with the business requirements
• Involved in creating Parameter Maps and assigning Scope Relationships.
• Applied filters on the Time Dimension to provide access to relevant date range.
• Created Standard Reports in Analysis Studio for Business Users

Environment: SQL Server, SQL Server Reporting Services (SSRS), MS Excel 2003/2007, MS Access 2003, SQL Server Management Studio, Windows, Oracle 10g, Cognos