SUMMARY:

• 10+ plus years of experience in the fields of Information Technology
• Experienced in gathering Business Requirements, Analysis, Design, Development, Testing, and Documentation of various functionalities of business application systems
• Experienced in green - field implementation, upgrade, support & maintenance of OBIA 7.9.6.x
• Hands-on experience in OBIEE 11g installation, configuration & administration on Linux, Windows.
• Hands-on experience in OBIEE 12c Installation and Configuration on Linux, Windows environment.
• Skilled in OBIEE RPD development on Physical, BMM, and Presentation layers.
• Skilled in creating complex measures in BMM (Business Model and Mapping Layer) using Level based Measures, Time Series calculations, and different Aggregation Strategies.
• Skilled in developing interactive dashboards, ad-hoc reports, configuring agents in OBIEE 11g.
• Skilled in designing BI Publisher reports with bursting features.
• Skilled in designing RTF Templates by Using BI Publisher Template Builder.
• Experience in OBIEE upgrade, Multi-User Development Environment configuration (MUDE).
• Experience in create/manage users, groups, roles in WebLogic EM, and Console.
• Experience in RPD and Catalog deployment and migration to non-prod and prod environments.
• Extensive experience in working with OBIA modules Finance, HR, Procurement & Spend, SC & OM.
• Provided rich UI enrichments using scripting languages like JavaScript, HTML, and CSS.
• Skilled in the development of interactive reports using Microsoft SQL Server Reporting Services (SSRS).
• Skilled in creating custom expressions in SSRS using the combination of common functions and Operations.
• Experienced in Build & Deploy SSRS projects to the server.
• Skilled in enabling subscriptions & Security in SSRS.
• Good knowledge in SSIS & SSAS.
• Skilled in creating powerful, interactive visualizations in Power BI.
• Experience in creating & managing the content packs, workspaces in Power BI.
• Experience in managing the gateways in Power BI.
• Skilled in creating DAX functions, custom tables, columns & measures in Power BI.
• Skilled in publishing Power Bi reports of dashboards in the Power BI server and scheduling the dataset to refresh for live data in the Power BI server.
• Experience in creating paginated reports in Power BI.
• Skilled in creating dashboards and Stories in Tableau.
• Skilled in creating Tableau worksheets by using calculations and aggregations.
• Created Worksheets by using calculations and aggregations.
• Knowledge in refreshing the Data Extracts and Auto updates in Tableau.
• Experience in deploying Tableau Worksheets, Dashboards & Stories to Tableau Server.
• Experience in writing Oracle PL/SQL programs like Package, Function, Stored Procedures, Triggers, and Cursors.
• Hands-on experience across all stages of the Software Development Life Cycle (SDLC).
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.

TECHNICAL SKILLS:

Front End Analytics & Reporting Tools: Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle BI Publisher, Oracle Data Visualizer, OBIA, Power BI, SSRS, Tableau

ETL/ELT Tools: Informatica, Oracle Data Integrator (ODI), SSAS, SSIS

Scheduler Tools: DAC

Databases: Oracle, MS Access, SQL Server

Programming Skills: C, C++,Java, VB, SQL, PL/SQL

Web Technologies: HTML, Java Script, CSS

Operating Systems: Windows & Linux

Tools: MS Office, SQL developer, Toad

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, California

Sr. Software Engineer

Responsibilities:

• Gather requirements, analyze, and document the use cases, and define the To-Be processes.
• Analyze and Capture the Cognos data model, reports, and dashboards.
• Prepared migration documentation to migrate existing legacy environments from Cognos to OBIEE.
• Develop OBIEE Repository at Physical Layer, Logical Layer & Presentation Layer.
• Create OBIEE Dashboards using different visualizations like Table, Graph charts, Pivot, Tittle view, Narrative View, etc.
• Enabled custom features to end-users, to select the attributes at run time to execute the report.
• Convert SF Open Book reports from Cognos to SSRS & Power BI.
• Used scripting languages like JavaScript, HTML & CSS for UI Enhancements.
• Create a Build and Deployment guide for Production environment migration.

Environment: Cognos 10.x, OBIEE 11.x, OBIEE12.x, ODI 11g, Power BI, SSRS, SQL Server, Oracle Database.

Confidential, Nashville, TN

BI Lead

Responsibilities:

• Worked on the design and development of Tableau visualization solutions using operational dashboards, reports, workbooks
• Developed Tableau Dashboards for visualization solutions.
• Developed data model to create reports and dashboards.
• Worked on Individual Axis, Blended Axis, and Dual Axis concept while working with reports.
• Created Worksheets by using calculations and aggregations.
• Created parameters using customized calculations.
• Created reports using conditional formatting.
• Involved in refreshing the Data Extracts and Auto updates in Dashboards.
• Created Filters, Groups, Sets on Tableau Reports.
• Worked with Live and Extract connection.
• Publishing sheets and dashboards on server Using Tableau Desktop.
• Developed complex reports and visualizations using Tableau Desktop as per requirements.
• Created Cascading reports in Dashboard.
• Created Dashboards and Stories by using Table calculations.
• Created Parameters to achieve the desired functionality.
• Experienced in creating dashboards and various chart views in tableau.
• Experienced in creating Filters, quick filters, table calculations, calculated measures, and parameters.
• Formatted the Reports as per the Client requirement.

Environment: BI Publisher 11g, Tableau Desktop 10.5.2, Power BI

Confidential, Nashville, TN

Sr. BI Developer

Responsibilities:

• Enabled OOB reports for Oracle Identify Management and Oracle Access Management
• Created/Modified reports in BI Publisher using the RTF template.
• Enabled bursting features for BI Publisher.
• Created and developed Power BI Dashboards into a rich look and configuring data gateways to have an automatic refresh of the dataset.
• Expertise in publishing Power Bi reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server
• Created powerful, interactive visualizations in Power BI.
• Formatting Axes, Titles, and configuring cross-filtering across the charts as needed by the demonstration.
• Developing a data model to create reports and dashboards.
• Created Worksheets by using calculations and aggregations.
• Created parameters using customized calculations.
• Created reports using conditional formatting.
• Used DAX functions SUMX, COUNTX, CONTAINS, CONTAINSROW, SWITCH, LEFT, SEARCH, IF, DATESBETWEEN, DATEDIFF, CROSSFILTER, TRUNC etc. for creating custom columns & measures
• Formatted the Reports as per the Client requirement.

Environment: Power BI, Oracle Identity Management (OIM), Oracle Access Management (OAM), Oracle DB, BI Publisher 11g.

Confidential, Nashville, TN

BI Consultant

Responsibilities:

• Evaluate and analyze business domain, design, and develop a data model and reporting for Business functions such as case management and Payment processing.
• Responsible for leading the offshore team and delivering Business functionality.
• Enhanced User Experience for customers in ADF.
• Develop, revise and debug application programs using BI Stack
• Evaluate Business Use cases and authoring System Design Documents for implementation.
• Handle Operations and Deployment for existing TCCMS (Tennessee Child Care Management System) production environment.
• Responsible for Test Case documents and developing Unit Test Cases
• Develop program logic to access relational databases (tables, views, indexes, functions, and replication)
• Responsible for converting COBOL programs Technical design documents to convert to SSRS.
• Responsible for converting automating cronjobs to auto-scheduling jobs.
• Responsible for providing end-user training for the reports and analytical solutions.
• Responsible for maintaining an awareness and understanding of technological advances; provide continuous research and assessment of new resources and technology available.

Environment: COBOL, VS2012, VS2015, SSRS, Oracle 12c DB, SQL Developer, Oracle ADF.

Confidential

Sr. BI Consultant

Responsibilities:

• Interacting with the product vendor for better analyzing the product functionality and preparing a roadmap for customizing the EHA model in the new environment and upgrade RPD and Catalog from OBIEE 11g to 12c.
• Oracle 12c DB installation on Linux environment.
• OBIEE 12c installation and configuration on the Linux environment.
• Exploring and analyzing the OBIEE 12c features from development and administration prospect.

Environment: OBIEE 12c, BI Publisher 12c, Oracle 12c Data Base, Linux RHEL 6.5

Confidential

Sr. BI Consultant

Responsibilities:

• Analyze the product functionality and dimension modeling of the EHA data model.
• Enhancement on existing Subject Areas and development of end - to-end new Subject Areas on the RPD layer for the clinical module.
• Designing custom reports and interactive dashboards with different analytical views (table, pivot, charts, and graphs).
• Designing custom reports on BI Publisher 11g with bursting features.
• Designing RTF Templates by Using BI Publisher 11g Template Builder for Word.
• OBIEE administration and RPD & Catalog deployment and migration from Development to Test Environment.
• RPD and Catalog migration using WebLogic EM console.
• Preparing design documents

Environment: OBIEE 11g, BI Publisher, Oracle DB, Linux RHEL 6.5

Confidential

Sr. BI Consultant

Responsibilities:

• Developed and Customized OOB Retail Analytics repository
• Implemented Cache Purging techniques and data level/ object-level security.
• Responsible for leading the team and delivering the Business functionality.
• Enabled Usage Tracking to track user activity login details, most used dashboards/reports, and to check the execution time taken by individual report/dashboard.
• Implemented Language Translation
• Configured Map Viewer and created customized reports
• Customized maps to provide more user-driven features to End Users.
• Involved in Oracle BIEE environment setup for QA and Production
• Creating/Modifying templates/Documents to track daily status/issues.

Environment: Oracle Data Integrator 11g, Oracle Business Intelligence Enterprise Edition (OBIEE), BI Publisher, Oracle 12c, UNIX & Shell Scripting.

Confidential

BI Consultant

Responsibilities:

• Enabled & Customized OOTB BIAPPS Dashboard & Reports.
• Disabled out of scope Subject Areas & Dashboards as per the client requirement.
• Enabled Usage Tracking to track user activity.
• Enabled Data Level and Object-level security.
• Involved in code Migrations.
• Used Write Back to allow users to write directly into the database using the analysis and dashboard.

Environment: OBIEE 11.1.1.6.2 , Oracle 11g, Toad, Windows Server 2008.