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
