SUMMARY

• A result oriented professional with excellent analytical, problem - solving, interpersonal and communication skills with ability to work in time-constrained environment, along with experience both as individual contributor and as a team player.
• More than 9 years of adept experience in gathering Business Requirements, Impact Analysis, Technical Design, Development, Implementation and Testing of various functionalities of Business Intelligence, Datawarehousing and ETL.
• Expertise in OBIEE/OBIA, Oracle BI Publisher and Informatica Powercenter and good understanding of SSIS and SSRS.
• Oracle certified OBI Apps implementation specialist.
• Extensive experience in providing end-to-end BI solution by Dimensional modeling design, Creation of Logical/Physical models, Configuration of OBIEE repository, Creation of Analyses/Answers, Agents/Delivers and Interactive Dashboards.
• Experience in OBIEE Performance tuning by Reports/dashboards re-deign, RPD configurations, Cache management, server optimization and database tuning.
• Extensive knowledge of OBIEE Security model using LDAP Authentication, Setup of Users and groups, RPD Authorization and data level and object level security setup.
• A good experience on OBIEE integration(SSO) with Siebel and EBS applications with experience of customizing Write-back functionality and Action Links.
• Strong Data modeling experience using Star/Snowflake schemas, Reengineering, Dimensional Data modeling, Fact & Dimension tables.
• Proficiency in Informatica Designer Components (Source analyzer, Warehouse designer, Mapping designer, Mapplet designer, Transformation developer, Workflow manager and Workflow monitor)
• Expertise in Design and development of Oracle BI Publisher reports and their Integration with Siebel application.
• A good experience of conducting technical workshops and trainings for application users along with an exposure to Pre-sales activities for OBIEE projects.
• Familiarity in conducting Functional and Technical sessions to peers and project juniors for BI/DW basics and project related trainings.
• Skilled in working with MS-Excel, Macros and VBScripting.

TECHNICAL SKILLS

BFS: Counterparty Credit Risk, Wholesale Banking - Profitability, GL and Reconciliations

BI Tool: OBIEE 12c, OBIEE 11.1.1.X, 10.1.3.X & BI Applications 7.9.X, Oracle BI Publisher, SSRS

ETL: Informatica Power Center, SSIS

Database Tools: TOAD, SQL*Plus, SQL Developer, Teradata SQL Assistant, SSMS

Applications: Siebel Analytics, OBIEE integrated with Siebel/EBS, Argus Safety 705/81X

Databases: Oracle 9i/10g/11g, SQL Server 2000/2005, Teradata, SQL Server

Operating Systems: Windows NT/XP/2000/98, UNIX/Linux, Solaris

Microsoft Tools: MS-Excel, MS-PowerPoint, Visio and MS-Word.

PROFESSIONAL EXPERIENCE

Confidential

BI Architect

Responsibilities:

• Gathering the Business requirements for the upcoming projects, performing impact study on the existing architecture, creating design documentation and implementing the change.
• Coordinating with Business analysts, project managers, track owners and testing team for the items as part of the release/project.
• Creating BI Dashboard/solutions for Case data corrections and submission related files to be resubmitted to the Safety system.
• Designing RTF and Excel based templates, along with complex data models for the BIP reports to suit the formatting/layout specification as per the HA/ICH standards.
• Creating complex BI reports/dashboards for submissions to the Health Authorities and internal to the client for their compliance standards.
• Implementing the changes/enhancements, bug fixes and performing unit testing.
• Working on issues related to OBIEE 12c upgrade and creating a knowledge repository for similar issues.
• Working on creating Use cases for development of Data Mart which can be used instead of Transactional system for better performance and analysis purposes.
• Coordinating with offshore and onsite team to help them in understanding the requirements and resolved the issues faced by them.
• Working on implementing Argus 811 upgrade to reporting and fixing related issues.

Confidential

Technical Analyst

Responsibilities:

• Gathering the Business requirements/stories, conducting grooming sessions with SMEs and Product owners for in-depth understanding of the functionality and performing impact study on the existing architecture.
• Worked in Agile and writing stories/requirements to cater to each Sprint deliverables, their tracking in JIRA for progress/ pending/ completed items and product backlog.
• Perform the Data Reconciliation between Source and Target systems and root cause of analysis of the data mismatch.
• Arrange the Business/Technical story grooming session with Development and QA team to help them in understanding the requirements and resolved the issues faced by them, along with coordination with client and project management teams.
• Development logical data mapping between source and target for Development team to build the ETL mapping.
• Handled the existing ETL, SSRS reports and outbound feed deconstruction activity with the Technical Team.
• Coordinated with offshore and onsite team to help them in understanding the requirements and resolved the issues faced by them
• Writing SQL Queries needed for data analysis purpose

Confidential

ProfitView FE Onshore Lead

Responsibilities:

• Prioritization, estimation, impact analysis and development work for Production Defects, Key enhancements and fixes to cater to the business requirements, along with testing and coordination with various stakeholders like QA team, DB team and business users.
• Working on Security revamp related enhancements to tune up overall system's performance along with reduced storage requirements.
• System's Performance improvement initiatives to improvise the OBIEE reports/dashboards performance.
• Identify critical issues and processing faults to optimize BI dashboards and reports.
• Identifying bugs and their relevant fixes, along with coordination with Oracle support for OBIEE 12c upgrade related challenges.
• Onsite-Offshore coordination and communication with key stakeholders.