We provide IT Staff Augmentation Services!

Tech Lead Resume

SUMMARY

  • High - skilled BI professional having 11+ years of experience spearheading numerous on-site and off-site project engagements. Providing technical expertise in the areas of insights and analytics, including Design, Development and Implementation of BI Applications. Extensive experience in Oracle BI, ERP, Tableau, ETL, Data Warehousing, Data Modelling, Project Management and Stakeholder Management.
  • Experience on migrating OBIEE 11g to OBIEE 12c.
  • Developed visualizations and dashboards using Tableau Desktop and published workbooks to Tableau server and provided support to end users.
  • Delivered reporting solutions and provided technical support for Microsoft Power BI users.
  • Worked on a POC for Exasol with Tableau Visualization to compare with Oracle DB and Tableau on Performance and data processing capabilities.
  • Knowledge on OBIA and Informatica.
  • Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using Informatica PowerCenter- transformations and update strategy to meet business logic in the mappings.
  • Performed the performance tuning at the source, Target levels using Indexes, Hints and Partitioning in ORACLE and Informatica.
  • Knowledge of Python Scripting.
  • Providing Subject Matter Expert (SME) technical solution and execute data mapping, quality, Analyze and transform and migrate data utilizing Oracle database.
  • Improving and streamlining processes regarding data flow and data quality to improve data accuracy, viability and value.
  • Install, upgrade and configure all components of Oracle Business Intelligence (OBIEE) 11g/12c and Tableau Reporting Tool.
  • Creating the Dimensional Hierarchies, Level-Based Measures, Time- series Functions, Initialization Blocks and Variables depending upon the need for Business Reports using the OBIEE Admin tool.
  • Building Subject area and dashboards using OBIEE 12c, Oracle Visual Analyzer 12c and Tableau Analytical Reporting Tool and producing attractive visuals/dashboards to convey the story inside the data to the Management.
  • Creating PL/SQL, SQL and Database Packages, Stored Procedures, Functions, Views and Triggers in Oracle Database based on the requirement specified by end users.
  • Designing and creating Common Dimension and Facts based on the Source Database modules by Extracting, Transforming and Loading Method using Informatica or Oracle Data Integrator Tools.
  • Developing different kinds of Key Performance Indicator Report and Executive Summary and detail reports (pivots, charts, tabular) using Filters and Modifying Views and Assigning Data Level and object level security to users.
  • Customizing and modifying the physical, business mode and presentation layer of the BI repository using Oracle Repository Administrator.
  • Experience in Design and Implementation of Data warehouse/Data Mart, Gathering Business Requirements, System Analysis and Data model.
  • Good Knowledge in Reports, different charts, narrative view, column selector, view selector, pivot table and Dashboards with Prompts.
  • Good experience in developing Oracle Forms and Oracle Reports (6i/10g).
  • Worked on different Reports for Oracle ERP Modules such as GL, AP, AR, Inventory etc.
  • Creation of Solution approach documents after gathering initial information from the end users.
  • Performance Tuning of the SQL Queries.

TECHNICAL SKILLS

Languages/Utilities: SQL, PL/SQL, Python

Applications: Oracle e-Business Suite 11i, Oracle e-Business Suite R12

Reporting Tools: Oracle Report Builder 6i/10g, XML Publisher, BI Publisher, Oracle Apex

OLAP Tools: Oracle BI (OBIEE 10.1.3.4.1), (OBIEE 11.1.1.7.0), (OBIEE 12.1.1.0), Tableau 9, 10.3,4 and 2018.2, Microsoft Power BI

ETL Tools: Oracle Warehouse Builder, Informatica

Database: Oracle 10g, 11g, 12C, Exasol, SQL Server 2017

PROFESSIONAL EXPERIENCE

Confidential

Tech lead

Tools: OBIEE 12c, Tableau 10.4, Oracle 12c, SQL, PL/SQL, TOAD 11, Oracle EBS R12, Power BI

Responsibilities:

  • As a Team Leader cum Onsite Co-Ordinator will be responsible for the Overall BI Delivery, Process, Quality for the SYSS BI Project.
  • Provide weekly update about offshore progress to onshore Manager; Automation migration and planning.
  • Review the estimate, Project Plan and test deliverables created by the offshore team.
  • Identify test scenarios and discuss with business IT team to freeze the scope of testing scenarios for project milestones.
  • Provide inputs to the offshore team and review technical requirement documents
  • Prepare functional and technical design Documents
  • Identify data mapping between Oracle EBS 11i data and Oracle EBS R12 tables
  • Co-Ordinate with the Business team on the test data to perform unit testing
  • Discuss and provide inputs to the business team to test each Oracle scenario
  • Worked on Re-Design and Implementation of Data warehouse/Data Mart, Gathering Business Requirements, System Analysis and Data model.
  • Modified PL/SQL procedures, functions, Packages, Triggers etc. as part of Oracle EBS R12 upgrade as per PANAYA tool suggestion.
  • Created RedZone dashboard, Executive summary dashboards using Tableau 10.5 and published to the server for management view to understand the trend of the Order / Bookings entered before and after the R12 upgrade and Sales summary.
  • Provided Subject area, Predefined Facts and dimension to the users and Provided demo on Visualization tools like Oracle VA, Tableau and Power BI as part of BI Self Service initiative.
  • Created Project Revenue and Cost dashboard to European users using Power BI and by utilizing existing Projects Module Datamarts and common dimensions.
  • Currently working with Emerson Finance Team to Build Interactive dashboard on US operations and Sales for SYSS group considering the Finance process and module changes in New ERP R12 release.

Confidential

Tech lead

Responsibilities:

  • Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
  • I was involved in the End to End Implementation of this project. Installed OBIEE 12c and Configured on Windows Environment.
  • Upgraded the BI 11g catalog to 12c and involved in LDAP authentication and providing security for all the users. Currently, Upgradation is in progress and current UAT is in progress.
  • Worked on the Design and Implementation of Data warehouse/Data Mart, Gathering Business Requirements, System Analysis and Data model.
  • Developed PL/SQL procedures, functions, Packages, Triggers, Objects for inserting, updating, retrieving and validating of data to achieve the mission-critical tasks.
  • Created Different Database Objects like Views, Synonyms, Indexes, and Sequences.
  • Worked with ERP Functional Consultants and End Users and Designed Common Dimensions and Facts based on the Modules such as OM, AR, AP, GL, PA, INV modules.
  • Conduct reviews of team projects on a routine basis, sought information about completion obstacles, and aligned teams as necessary or managed customer expectations as necessary.
  • Mentor the development team on OBIEE development.
  • Documented all the configurations and new reports creation.

Confidential

Analyst & Designer

Responsibilities:

  • Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
  • I was involved in the End to End Implementation of this project. Installed OBIEE 11.1.1.7.0 and Configured on Windows Environment.
  • Upgraded the BI 10g catalog to 11g and involved in LDAP authentication and providing security for all the users.
  • Worked on the Design and Implementation of Data warehouse/Data Mart, Gathering Business Requirements, System Analysis and Data model.
  • Developed PL/SQL procedures, functions, Packages, Triggers, Objects for inserting, updating, retrieving and validating of data to achieve the mission-critical tasks.
  • Mentor the development team on OBIEE development.
  • Configuring Map Viewer and using Maps in Analysis and Dashboards.

Confidential

Sr Oracle Business Intelligence Developer

Responsibilities:

  • Understanding the Business requirements, involved in Designing and Configuration of Business Intelligence Server Repository as per Business Needs and improving performance.
  • Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business model, and presentation layer of the repository.
  • Creating the Dimensional Hierarchies, Level-Based Measures, and Time series -Functions, Initialization Blocks and Variables depending upon the need for Business Reports using the OBIEE Admin tool.
  • Customized Reports look and Feel using Column Formatting & Conditional formatting.
  • Developed Interactive Dashboards using Reports with different Views, implementing pagination (Drill-Down, guided navigation, Pivot Table, Chart, Column Selector, dashboard and page prompts) using Oracle Presentation Services.

Hire Now