Bi Architect, Resume
Durham, NC
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 8 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 s 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 s.
- Skilled in working with MS-Excel, Macros and VBScripting.
TECHNICAL SKILLS:
Domains 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
ETL: Informatica Power Center
Database Tools: TOAD, SQL*Plus, SQL Developer, Teradata SQL Assistant, SSMS
Applications: Siebel Analytics, OBIEE integrated with Siebel/EBS
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:
BI Architect,
Confidential, Durham, NC
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.
- 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, and working on development of ETL prototype using Informatica powercenter.
- 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.
Technical Analyst,
Confidential, Charlotte
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
ProfitView FE Onshore Lead,
Confidential, Charlotte
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.
Asset Lead - Value Control
Confidential,
Responsibilities:
- Key responsibilities include anchoring the Daily activities (Daily Controls, Reconciliations), Adhoc business requests.
- Account hierarchy change analysis which includes Impact of GL Remaps/Exception pointing (Add/Remove) and Margin analysis, which included impact on P&L and Treasury.
Offshore Lead,
Confidential,
Responsibilities:
- Establish new processes and standards for development and migration operations to boost the project approach and scope.
- Provide regular support and resolution of analytical problems and reporting needs of OBIEE and data warehouse application.
- Development of many complex Informatica mappings and mapplets to build key interfaces for loading data into Data Warehouse.
- Set up incremental data load from existing daily full data load to datawarehouse.
- Involved in troubleshooting the load failure cases, including database problems.
Onsite Lead,
Confidential,
Responsibilities:
- Conduct sessions and workshops with key business users and country coordinators for business requirements gathering.
- Analysis & Validation of the Business Requirement Specifications provided by the client
- Preparation of Estimates and Impact analysis of the Business requirements
- Creation of Complex reports with data sets from different sources and the related layouts as per business requirements
- Scheduling of BI Publisher reports and implementation of Bursting feature to deliver reports to multiple business users
- Creation and testing BI Publisher reports using BI Publisher Desktop and their integration with Siebel-CRM application
- Creation and Testing of PL/SQL procedures, functions and packages
- Performance tuning of the existing reports and PL/SQL packages
Senior Developer
Confidential,
Responsibilities:
- Development of major enhancements and change requests related to Informatica mappings and workflows, along with OBIEE and BI Publisher reports
- Provide primary support for all Informatica and OBIEE issues
- Development and testing of Informatica mappings and workflows, ETL performance tuning. Validate that the all the data transformations are correct according to the business rules and data warehouse is correctly populated with the transformed data
- Create OBIEE Dashboards, Delivers, Reports, Filters and Prompts and also involved in RPD configuration.
- Creation and testing of BI Publisher reports using BI Publisher Desktop and their integration with Siebel CRM application
- Redesigned the application to enhance the performance of OBIEE reports along with tuning Informatica mappings
- Configured BI Scheduler and created iBots to schedule and deliver analytics content to multiple delivery destinations and also as Cache Seeding mechanism.
- Integrated OBIEE with Siebel for Single Sign On mechanism.
- Regular monitoring of data load jobs in ControlM scheduling tool to ensure successful completion of daily ETL loads
- Apart from technical responsibilities, also took care of internal processes and project quality parameters through Infosys internal systems and well-rehearsed with CMMI practices for project
- Involved in impact analysis and high level estimates for OBIEE upgrade from 10g to 11g.
BI Developer,
Confidential,
Responsibilities:
- Development of Informatica mappings and customizing the seeded one for Sales, Marketing and Service modules of Siebel Analytics
- Writing test cases for ETL and OBIEE reports to ensure quality deployment and migration to production
- Managing OBIEE metadata and deploying the RPD, Web Catalog in OBI Clustered environment
- Drive the workshops with business users to deliberate the business process and customer needs for reporting.
Environment: OBIEE 10g (Sales analytics and Service Analytics), Informatica 8.6, DAC 10.1.3.4.1 .