SUMMARY

• 9 years of global experience in Analysis, Design, Development and gather Business Requirements.
• 8 years of enterprise experience under Development, Testing, Implementations and Documentation of various functionalities of BI Analysis, Data Warehousing, Data Mart, and Transactional applications.
• Expertise in extensive Business Intelligence and Data warehousing techniques with Kimball and Inmon Methodology using Tableau 9.1/2018.1/ 2020.1, OBIEE 11g/12c, OAS, OBIA, Oracle BI Publisher, ODI 11G, Informatica 7.x on different platforms like Linux, Wintel, Oracle cloud and Azure Cloud systems.
• Ability to represent the report analysis in variety of reporting formats like table, pivot, Bar, Pie chart, line, dual axis charts, scatter plot, Box plot, Geo maps, Tree maps, Gantt chart and many more.
• Extensive experience in creating interactive reports and dashboards using parameters, data functions, groups, sets, action filters, context filters, global filters, dynamic and static variables, and other key features of the tool.
• Build Hierarchical structures, Level of Detail expressions (LOD), Custom Aggregations and calculated fields, analyze and develop data (Star/ Snowflake) schemas, Slowly Changing Dimensions (SCD) and custom data models as per the business standards in the report and database level.
• Implemented Normalization and De - Normalization techniques for OLAP Systems and worked on manipulating table constraints like primary key, foreign key, and indexes to achieve required data sets.
• Expertise in Automation and scheduling of actions and tasks using UI Path, Tableau deliveries, and OBIEE Agents, python scripts.
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository using Oracle BI Administration Tool.
• Strong expertise in ODI architecture and installation of Topology, Security Manager, Designer, Agents, Operator, Master Repository and Work Repository.
• Experience in creating Database Objects like Packages, Stored Procedures, Functions and Triggers in ODI, Informatica, SSIS and PLSQL
• Expertise in BI Apps (OBIA) for Finance Analytics, Sales and Service Analytics, EAM, Human Capital Management (HCM), Procurements, Order Management, Supply Chain Management, Manufacturing and Project analytics.
• Strong expertise in implementing Data level and Row level security in BI reports, Backend repositories and in database level.
• Strong expertise in administrative tasks like implementing authentication and authorization protocols, catalog and repository migration using automated scripts, Jenkins and application management tools.
• Expertise in working with different data sources through flat files, Excel spreadsheets, HFM, DRM, Oracle ERPs, SQL Server, MemSQL, Greenplum, Snowflake, SnowSQL 1.2 etc.

TECHNICAL SKILLS

Applications: Tableau 2020.1/2018.1, 9.1 OBIEE 12c/11g, OAS, ODI 12c/11g, Informatica 8.1/7.x, DAC 7.8.3, OBIA 7.9.x, EBS R12/11i, SAP, Power BI, Alteryx, DRM, HFM, Smart View, Oracle Cloud Services, Azure Cloud Services

Technologies and Languages: Oracle SQL, MemSQL, PLSQL, C, HTML, XML, CSS, UNIX Shell Scripting, PostGreSQL, Java Script, Python, SnowSQL

Database: Oracle 11g/10g/9i, Oracle Cloud Autonomous DB, MySQL, SQL Server, GreenPlum, MemSQL, Snowflake

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Tableau Developer

Responsibilities:

• Consolidate and lead Project requirement, design and implement the specifications as per business requirement.
• Lead the offshore team by directing the project guidelines and tracking the progress of project tasks and activities.
• Created stories based on Tableau visualizations to explore the data narrative and provide necessary context and demonstrate how the decisions impact the outcome and help in business forecasting.
• Developed, enhanced, and maintained finance reports like Trial Balance, Transaction Register, Income Statement, Workbench Reports, Manual Journal Entry Reports, Remeasurement Reports, Human Resource Capital Management, Workforce FCTA Validation and Variance Reports, FDM and Hyperion Planning Reports.
• Created the above reports in both Tableau 2020.1 & OBIEE 12c Visualizations like linear, cross tab formats and represented the factual comparisons, sectional analysis and GAP Analysis using Floating Bar charts, Pie chart, line, dual axis charts, scatter plot, Box plot, heat maps, geo maps, Gantt charts, etc.
• Developed various complex reports including drill-down reports, conditional reports, parameter-based reports, summary reports, charts and sub reports using dynamic prompts, Command Objects, Running Totals, etc. in OBIEE 12c and Tableau 2020.1.
• Created calculated fields, aggregations, Level of Detail (LOD), groups, sets and Hierarchical tree structure to represent complex data in almost all the reports.
• Diagnose and troubleshoot service requests and cases logged by the business users raise through ticketing systems like ALM (Application Lifecycle Management), Confidential Support Central, IDM (Identity Management Manager) and Service now.
• Maintaining hardware reliability, system level security, system level performance monitoring and tuning, and automation of production activities including extract and load functions, repetitively produced queries/reports using BI and ETL methodologies.
• Developed the Metadata Repository with subject areas related to the business specifications using OBI Admin tool by importing the fact and dimension views from the data warehouse and integrating them with hierarchies with drill down capabilities for complicated analytics.
• Automate the BI processes and report execution by using Tableau deliveries, OBIEE Agents, UI Path and Python Scripts.
• Setup active directory access security in the application and maintain and monitor security system in Weblogic and BI Server.
• Developed and modify ELT (Extract - Load - Transform) packages and objects in Oracle Data Integrator (ODI) using oracle and SAP data sources.
• Monitor multiple ELT data loads and incremental loads using BIACM and ODI Console and troubleshoot if required.
• Build Unix/Shell scripts for activating triggers to initiate loads in ODI and to send out notifications.

Environment: Tableau 2020.1/2018.1, 9.1 OBIEE 12c/11g, OAS, ODI 12c/11g, SQL, UI Path, Python, Shell, Redhat, Linux, Windows, Oracle Cloud, Azure Cloud services, Oracle 11g/10g/9i, MemSQL, GreenPlum.

Confidential, Costa Mesa, CA

Sr. BI Developer / Admin

Responsibilities:

• Gather project requirements, implement specifications, and maintain Application code base.
• Track the over progress of the project and report it to the project Manager.
• Updating regular activities and assignment status in Service manager
• Identifying, documenting, and administering the metadata repository and design data definitions, data models, data flow diagrams from it.
• Reconfigure OBIEE, OBIA and Informatica with new DB Oracle 12c and Source EBS 12.2.6.
• Move the customized OBIEE catalog objects and Informatica packages from legacy servers to new server.
• Design and develop reports for Procurements, Spend Analytics, Financial Analytics, Service Analytics and Project Analytics using OBIEE and BI Publisher objects.
• Maintaining hardware reliability, system level security, system level performance monitoring and tuning, and automation of production activities including extract and load functions, and repetitively produced queries/reports.

Environment: OBIEE 12c/11g, ODI 12c/11g, SQL, Oracle 11g/10g/9i, Python, Shell, Redhat, Windows

Confidential, Irvine, CA

Sr. Tableau Developer / Admin

Responsibilities:

• Interacting with Business users and management for gathering requirements and building the analytical reporting solutions to business.
• Developed Complex Reports with various views including pivots, charts, column selectors, drill down hierarchies, etc., and these catalog objects along with dashboard prompts to provide intuitive drill downs and links to exploit the full benefit of Analytical Dashboards in Tableau 9.1 and OBIEE 11g
• Customized OBIA modules - Financials, Projects, Account Payables, Procurement and Spend Analytics, Human Capital Management (HR, Workforce, EPM) Order Management, Inventory, Purchase Orders, GL, Account Receivables, reports and subject areas in the RPD and developed new analytics using these OOTB objects.
• Developed data models in Physical Layer of RPD and then constructing logical structures in the BMM layer and organizing the subject areas in the Presentation layer.
• Implemented data level and object level security by following Business Intelligence and DW security protocols using Tableau Security protocols.
• Performing Admin Tasks like merging workbooks, security objects, setting permissions, performance tuning, Deployment, Maintain and Monitor BI and WebLogic services, etc.
• Implemented multiple LDAP’s through WebLogic console for secured authentication and authorization.
• Implemented Usage tracking in OBIEE setup through enterprise manager and then developed reports/ Dashboards for Usage tracking.
• Designed, Developed and Modified OBIEE Functional Metadata RPD by using the OBI Administration tool and developed similar data model to serve as data source for Tableau Reports to similar data analysis.
• Developed RPD in Multiuser Development Environment (MUDE) in a shared network drive and merged them parent RPD.
• Migrated (Recreated) all the OBIEE reports to Tableau 9.1 with same or enhanced business standards.
• Created Customized application roles for restricted access to OBIEE Objects and assigning them to securing groups in AD for designated OBIEE Users
• Designed packages, interfaces, Procedures, KM's and scenarios in ODI (Oracle Data Integrator) using Oracle EBS and SAP source system objects.
• Customized OOTB OBIA packages for ETL using ODI studio based on the business requirements.
• Manage and Monitor Daily ODI incremental loads using BIACM and ODI Console for any issues.
• Maintain and manage the LINUX server platform for effective operations of the OBIEE and ODI applications.

Environment: Tableau 2020.1/2018.1, 9.1 OBIEE 12c/11g, ODI 12c/11g, Oracle 11g/10g/9i, Oracle EBS, SAP, PLSQL, Shell, Redhat, Linux, Windows, Oracle Cloud services.

Confidential, Houston, TX

BI Developer / Admin

Responsibilities:

• Was involved in the end-to-end life cycle of the project from requirements gathering to deployment.
• Designed and developed the Metadata Repository using OBIEE Admin tool by importing the required objects (Dimensions & Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Subject Areas in Presentation Layer.
• Designed and developed variousInteractive Dashboardsand reports with drill downs, guided navigation, filters, and prompts.
• ConfiguredBI SchedulerandOracle BI Delivers- Agentsto deliver alerts and published updated content to subscribed users as per the schedules and requirements.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to data model, Aggregated and non-aggregated objects and implementing indexes to physical tables.
• DevelopedFunctional Requirement Document and Technical Requirement Document for Commercial Analytics using OBIA-Siebel.
• Installed and configured OBIA with the existing OBIEE setup by merging the RPD and importing all the OOTB OBIA objects and custom columns from Siebel source.
• Worked in OBIA Modules - Financials, Procurements and Spend, Projects and HR Analytics
• Modifying and managing the Informatica workflows relating to OBIA OOTB objects.
• Configured DAC and integrated it with the Informatica workflows and scheduled the full load and incremental loads for the objects required.
• Tuned Informatica mappings, sessions, SQL queries, lookup, aggregator, sorter and joiner.
• Optimizing Informatica sessions by effectively applying session partitioning and partition point features.
• Installed and configured OBIA with the existing OBIEE setup by merging the RPD and importing all the OOTB OBIA objects and custom columns from Siebel source.
• Developed, maintained, and monitored incremental and full data modular loads from Oracle EBS- Informatica through DAC (Data Warehouse Administration Console).
• Managed the ETL Process by running PL/SQL Stored Procedures through Control-M Jobs.
• Worked on data models from 4 different source systems (Oracle EBS, Seibel, LoadStar and Tibco)
• Performed lead operations with the offshore team to meet the deadlines for OBIEE and OBIA projects
• Performed admin tasks like maintaining and monitor the OBIEE server, Migration of catalog objects and RPD files, Monitoring cache files and temp files and managing the full system performance on wintel platform.

Environment: Tableau 2020.1/2018.1, 9.1 OBIEE 12c/11g, Informatica 8.1/7.x, DAC 7.8.3, Oracle 11g/10g/9i, Oracle EBS, SAP, PLSQL, Shell, Redhat, Linux, Windows, Oracle Cloud services.

Confidential

SQL Developer

Responsibilities:

• Worked for the client Dish Network through 247 Customer, US Based TV Network provider.
• Monitor and report the network traffic and tab all the technical issues faced by the signal simulators, transmitters and receivers through
• Write PLSQL packages to aggregate and load data into target database systems for data analysis.
• Used SQL Programming to query and analyze the monthly assembled data.
• Collect and assemble the weekly data through application interface and load them into backend databases.
• Optimized SQL queries using SQL profiler, indexed views and indexes.
• Successfully transferred old data from various sources like flat files, MS Access, and MS Excel into MS SQL Server 2008/2005.
• Provide PLSQL Packages to ETL Development team along with required ER Diagrams to build the automated procedures and packages for incremental and full loads in Informatica.
• Implement and integrate PLSQL packages in Cron Jobs for automated scripts.
• Develop shell scripts for automatic triggers scheduled from the source systems.

Environment: PLSQL, Oracle EBS, SAP, Informatica 8.1, Oracle SQL Developer, Toad, Windows, Linux