We provide IT Staff Augmentation Services!

Sr Obiee Developer Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • Over 7 years of experienceas Oracle Business Intelligence Developer and Data Analyst
  • Skilled in BI Architecture, Data Visualization, Analytics, BI Reporting, Dashboard Designs, & Dimensional Data Modeling using Star/Snowflake Schema using Kimball
  • Expertise in OBIEE Administrative Tool, OBIEE Answers/Analysis, OBIEE Dashboards, OBIEE Delivers, BI Publisher and RPD in designing, developing and with prebuilt
  • Proficient in Data extraction Transformations, ETL, Data warehouse and RDBMS implementation, and OLAP Technologies and developing Informatica mapping
  • Excellent verbal and written communication skills to liaise with all Business Stakeholders including Senior Management, Clients, SME’s and Technical teams and a self - directed team player
  • Strong management, development skills used to deliver projects on time following Agile/Scrum methodologies in multinational/multicultural on-shore/off-shore teams

TECHNICAL SKILLS

Reporting Tools: OBIEE 10g/11g/12c, BI Publisher, Siebel Analytics 7.8, Tableau

ETL Tools: Informatica Power Center 8.x, 9.x

Languages: SQL, PL/SQL

Scheduling/Monitoring: Control-M, DAC

Data Virtualization: Denodo 5.5

Project Tracking: Jira, Confluence, HP Service Manager

DevOps/Process Modeling: Bamboo, SVN, Crucible, Visio, Microsoft office 365, Toad

PROFESSIONAL EXPERIENCE

Confidential

Sr OBIEE Developer

Responsibilities:

  • Led and successfullydelivered UK Offshore regulatory audit project utilizing OBIEE & BI Publisher for KPMG and HMRC within deadlines in fast-paced Agile environments
  • Managed team of 6 overseeing task assignments, project timeline, and progress tracking, interactions with SME’s to capture business requirements, as well as facilitated training for graduate programmers, end-users and client demonstrations
  • Prepared technical design specifications documents and implementation plans for Prod releases
  • Analyzed and accurately identified issues, risks and created the technical plan for OBIEE implementation to replace existing Web FOCUSreports
  • Created Dimensional Hierarchies, Level-Based Measures, & adding multiple sources to BMM objects
  • Developed RPD for the different work streams with the necessary logic
  • Proficient in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience
  • Defined session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically
  • Enhanced performance of Reports / Dashboards by implementing the Materialized Views, Table partitions, re-building of indexes, managing Cache and following best practices in RPD

Confidential

OBIEE/BI Developer

Responsibilities:

  • Promoted to Senior Analyst Programmer for successful implementation of investor tax regulatory project on time and without production issue leaks utilizing OBIEE, BI Publisher & Informatica (Awarded Spot On 2016 award)
  • Created BI publisher and OBIEE reports, dashboards and Repository semantic layer designing and development and metadata modeling, also responsible for performance tuning of reports
  • Implemented Object Level Security by creating roles & web groups using External tables and web logic console
  • Assisted business users in testing Regulatory Reports and data mart in analyzing and improving data (UAT support) as well as created and performed test cases for QA testing
  • Planned and supervised code deployment to the higher environments and prepared pre and post-release activities process document templates to establish best practices
  • Designing Scheduler Draft for the Batch to run end to end (Control-M)
  • Development of Informatica mappings to load and fetch the data from the DB & store them in respective staging tables

Confidential

OBIEE Developer

Responsibilities:

  • Coordinated the development, testing, and deployment of modules between onshore-offshore teams
  • Prepared and defined user requirement and technical specifications documents
  • Customized and developedrepository, Oracle BI answers and dashboards, configured metadata objects,and web catalog Objects
  • Implemented LDAP securitymodel for OBIEE users and published daily status reports on Sharepoint using BI Publisher
  • Worked on performance tuning of reports using aggregate tables, caching and event polling tables
  • Customized BI screens as per the UI/UX designs standards followed by the company
  • Implemented Variables, Hierarchies, Usage tracking, Opaque views, Pipeline functions & Direct SQL

Confidential

BI Developer

Responsibilities:

  • Promoted to Senior Software Engineer for Successful re-building of DWH for analytics environment utilizing Informatica and PL/SQL from Siebel CRM DB (Awarded STAR performer 2012)
  • Received Customer Service Appreciation Award in 2011, 2012 and 2013 by client GE Healthcare
  • Configured Siebel Analytics, OBIEE 10g at the repository level and web catalog level
  • Developed and Scheduled Ad-hoc and Canned reports using Answers and Dashboards
  • Designed dimensional data modeling at all three layers (physical, BMM, and presentation) of RPD
  • Development of ETL jobs for the creation of Data warehouse required for the end reports. Developed stored procedures using PL/SQL
  • Customized and Programmed DAC workflows

We'd love your feedback!