SUMMARY

• Over 8+ years of experience in Software Design, Development, Implementation, Maintenance and production Support of Business Intelligence and Data Warehousing platforms
• Expertise and demonstrating prolific level of achievement in Tableau Desktop visualization & OBIEE Dashboards & Reports development, data warehouse design, maintenance, data loading, Real time and OLAP reporting
• Proficient in Data Analytics, Transformation, Implementation and Development of projects working with Tableau Desktop
• Experienced in Tableau functionalities with best practices from data extraction to around Worksheets, Dashboards and Report visualizations by using Tableau reporting objects i.e. Facts, Attributes, Hierarchies, Alias, Comments, Transformations, Filters, prompts, Calculated fields, Sets, Groups, Parameters etc.,
• As a Tableau developer responsible for creating wonderful visualization reports to help clients to take their decisions faster on real time data’s
• Expertise in migrating Tableau reports from OBIEE Reports as business needs
• Excellent in requirement gathering, analysis, modeling, design, testing and development
• Excellent experience and customer appreciated performance in playing the role of Business Analyst to Business with technology and providing optimal value adding business solutions
• Excellent experience in interacting with client SME’s on - site and offshore and experience in converting business requirements to functional, technical requirements
• Expertise in setting up Development, Test and Production environments for DWH requirements for the business needs and customize existing schemas as well develop new Subject Areas to suit business needs
• Experience in setting up Development and Infrastructure setup for OBIEE Environment
• Expertise in working OBIEE Administration tool and design Schemas to fit business requirements
• Expertise in OBIEE Web Catalog Administration
• Experience in setting up LDAP Authentication and Authorization for users and groups
• Expertise in design and development of Ad-hoc Reports & Dashboards using OBIEE suite
• Experience in design and development of Dimensional and Position based hierarchies
• Experience in design and development of drill down reports and dashboards for trend analysis
• Experience(Knowledge) in design and development of ETL mappings and workflows using Informatica
• Excellent experience in complete Software Development Lifecycle
• Experience in demonstrating POC’s for business proposals at customer locations directly
• Experience in understanding and working on Siebel, Oracle EBS OLTP and OLAP model

TECHNICAL SKILLS

OLAP/Reporting Tools: Tableau Desktop 9.1/8.X, OBIEE 12c/11g /10g, Siebel Analytics 7.8ETL Tools Informatica 8.6.1/7.1.4 , ODI

CRM-Apps: Siebel 8.0

Operating System: Windows 7,9x/2K /NT, XP, UNIX and Linux

Databases: Oracle 9i/10g/11g, Sql Server 2005/08, Teradata

DW Utilities: DAC 10.1.3.4.1 , MS-VSS, TOAD, Oracle Sql Developer

Programming Languages: C#, Asp.Net, HTML, Java Script

PROFESSIONAL EXPERIENCE

Confidential, Columbus, IN

Sr. BI Lead

Responsibilities:

• Solution designing for reporting requirements from heterogeneous sources
• Involved in requirement gathering and designed the application architecture as per user requirement and OOTB / DW standards
• Business requirements development on interactions with client SME’s and document the requirements
• Monitor and document ETL Load strategy and process to populate Dimensions and Facts
• Designed new Data marts for External sources other than Oracle EBS data.
• Supported different enhancement application’s like CORP (Finance), FBU (Fuel Business Unit) and FSBU (Fuel Shell Business Unit), CBU (Component Business Unit)
• Developed the applications using different chart objects like Bar Chart, Line Chart, Pie Chart, Straight table, Pivot table, Treemap, Heatmap, Waterfall Chart, Donut Chart and Lalipop Chart in Tableau Desktop.
• Used Sets, Bins, Parameters, Aggregate Functions, Filters, Action in Tableau
• Used Tableau Desktop to analyze and obtain insights into large data sets.
• Combine the visualizations into Interactive Dashboards, Stories and publish them to the web using in Tableau Desktop 9.1
• Publishing the Worksheets, Dashboards and Stories on Tableau server to share it with multiple BU’s.
• Develop complex reports on Weekly, Monthly wire line scorecards, Ticket summary, Region level
• Have created visualization reports on Tableau Desktop9.1 on existing data model build in DW
• Create visually compelling and actionable interactive worksheets and dashboards for the clients to analyze various KPIs
• Design and setup Data level security for the Region specific users at the enterprise and Region
• Deriving estimations for development effort for each phase of the deployment of Dashboards/reports. Preparation of Agile approach and detailed task identification, resource estimation, coordination to prepare project plan
• Develop in line record view with action links and develop reports with guided navigation links
• Design and development of OBIEE Dashboards, Answers and catalog Administration
• Design Data model for customization of existing rpd and new development from non-Oracle integrated sources. Design and development of Business model and mapping for the Business rules
• Worked as a POC for upgrading BI reports from 11g to 12c
• Developed custom Reports in 12c as per user business requirements
• Design and development of BRD, HLD, UTP
• Work with DBA and technical team to identify and resolve performance bottlenecks and provide appropriate solution
• Functional exposure with Oracle EBS system, Noetix Views and Noetix custom views

Environment: Tableau Desktop 9.1, OBIEE 10g/11g/12c, OBIA (11.1.1.8.1 ), Oracle 11g/ Exadata, Teradata, Noetix 6.0.1, Windows Server 2008, Citrix, Toad 9, Oracle SQL Developer 1.5.5, SQL Navigator 5.5

Confidential

Sr. BI Developer

Responsibilities:

• Involved in business requirement analysis and responsible for providing LOE for Tableau reports and dashboards.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
• Leveraged tableau built in graphical capabilities to create bar charts, Treemaps, Geomaps, Area charts
• Used Tableau to create visual interactive dashboards, workbooks and stories for better decision making.
• Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Created detailed Functional Specifications Documents, including data samples, use cases, key project assumptions, report samples, data flows, and data models
• Review existing OBIEE, allow it to adapt to new requirements of Tableau 8.2, to improve its performance.
• BI Apps/OBIEE/Informatica/DAC/OBAW implementation of Oracle Financial Analytics Subject Areas:with featuring of GL Balance Sheet, GL Budget and Expenses, GL Cash Flow and GL Detail Transactions
• Monitoring the data load using DAC
• To prepare the Test Scenario and test cases for the testing of the components created and execute the same in different test environments. First to test with the sample data and then with the live data of about 1 million records.
• Part of OBIA 7.9.6.0 (Financial Analytics ) implementation.
• Design and development of OBIEE Dashboards, Answers and catalog Administration
• Performed duties of a production support personnel such as identifying the cause of failure, rectify the problem or notify appropriate personnel.
• Configuring scheduler, iBOTS.
• Have created impact analysis and resolved the post production break fixes through enhancements and implementations.
• Design and development of BRD, HLD, UTP

Environment: Tableau 8.1, OBIA 7.9.6.0(Financial Analytics) OBIEE 10.1.3.4, DAC 10.1.3.4, Informatica 7.1.4, SQL Developer, Putty, WinSCP, Oracle 11g, Windows XP, Solaris 5.8

Confidential

Sr. OBIEE/Tableau Developer

Responsibilities:

• Responsible for performing Enterprise level reporting analysis for the existing divisions by POC with market as the active and good to go Market data
• Analysis and study of existing system running over TPMS (Transaction Processing and Management System)
• Solution designing for reporting requirements from heterogeneous sources
• Business requirements development on interactions with client SME’s and document the requirements
• Deriving estimations for development effort for each phase of the deployment of OBIEE Dashboards/reports
• Design Data model for custom Repository development from non-Oracle integrated sources
• Design and development of Business model and mapping for the Business rules
• Design and development of OBIEE Dashboards, Answers and catalog Administration
• Design and develop ad-hoc reports on Sales rep activities and Sales target analysis
• Develop complex reports on One time charges, Work orders, commissions, Site level
• Design and setup Data level security for the super users at the enterprise level and market level
• Design reports with Positional hierarchies for Sales module across Market
• Develop in line record view with action links and develop reports with guided navigation links
• Design and develop custom and customization of ETL mappings and workflows
• Have worked as a POC in Tableau Desktop
• Have replicated OBIEE reports into Tableau Desktop worksheets and Dashboards
• Design and development of FDD, TDD, UTP, RPR

Environment: OBIEE 11g/ 10.1.3.4.1 , Tableau Desktop, Informatica, DAC, Oracle 11g, Windows Server 2008, Citrix, OEL 5.x, Erwin

Confidential

OBIEE/Siebel Analytics Developer

Responsibilities:

• Requirements gathering on coordination with client SME and BRD preparation
• Design and develop Repository for the data model
• Develop dimensional hierarchies for the Toll collection centers and collection agents
• Design and development of OBIEE Dashboards, Answers
• Preparation of tollgate approach and detailed task identification, resource estimation, coordination to prepare project plan
• Development of Dashboards over the OLAP model designed for MD to deploy for various customers
• Responsible for migration of Analytics reports, repository to OBIEE Environment
• Responsible for design and development of ETL mappings and workflows
• Develop and schedule ibots for users on the collection details and dues
• Responsible for additional activity as Software Configuration Management coordinator
• Design and development of HLD, LLD, UTP
• Involved in upgrade POC from Siebel Analytics to OBIEE
• Involved in SIT, QA, deployment and post production support

Environment: Siebel 8.0, OBIEE 10.1.3.3.2 , Siebel Analytics 7.8.5, Informatica 7.1, Windows Server 2003