Poonam Chand Chaganraj
poonamchand.is027@gmail.com
+1 412-979-4906
_______________________________________________________...
 Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design,
building bus...
PROFESSIONAL EXPERIENCE
Client: PNC Financial Services Group, Pittsburgh PA
Sr. OBIEE Consultant
Project Name:
1. PNC I&R ...
• Worked on Multi-User Environment (MUDE) by merging and importing multiple projects throughout
the development phase.
• C...
• Performed Upgrade Assistant on repository and web catalog from OBIEE 10g to OBIEE 11g.
• Conducted mockup and Training s...
• Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.
• Created various templates, reports,...
• Understand and design the generic metadata RPD, physical and business model diagram
mapping and joins with facts and dim...
PERSONAL DETAILS
Date of Birth : April 10th 1987
Gender : Male
Present Work Location : 600 Grant Street, Pittsburgh, PA, Z...
of 8

Poonam Chand Chaganraj_Resume_OBIEE_Consultant

Published on: Mar 4, 2016
Source: www.slideshare.net


Transcripts - Poonam Chand Chaganraj_Resume_OBIEE_Consultant

  • 1. Poonam Chand Chaganraj poonamchand.is027@gmail.com +1 412-979-4906 __________________________________________________________________________________ CAREER OBJECTIVE Seeking the position of an OBIEE Lead/Developer in an organization, wherein, my technical efficiency and commitment will contribute towards the organizational as well as personal growth. Current Role Description: OBIEE Lead Overall 5.9 years experience in field of development, implementation and support in Tata Consultancy Services, with 5.7 years of relevant experience in Oracle Business Intelligence Enterprise Edition Reporting Tool and BI Publisher. Also have experience in Informatica, Tableau and data modeling. PROFESSIONAL SUMMARY OBIEE  Result Oriented IT professional with 5.7 years of extensive expertise in analyzing requirements, application design, development, testing (Full Systems Development Life Cycle) and a comprehensive background in Data Warehousing and Business Intelligence.  Experience of around 5+ years in the dome of Business Intelligence (OBIEE), BIP Publisher and in designing & developing Business Intelligence solutions.  Experience of around 6 month in the dome of Tableau.  Proficient in working with OBIEE administration tool developing metadata repository and strong experience in working with Oracle BI answers, Oracle BI dashboards and Oracle BI Delivers.  Excellent understanding of OLTP/OLAPSystem Study, Analysis and developing Database Schemas like Star schema and Snowflake schema.  Experience in implementing the Oracle BI Security Setup (groups, data access/query privileges).  Proficient in developing OBIEE Interactive Dashboards/Reports with different analytics view (Drill- Down/Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters), configuring OBIEE Metadata objects (Subject Area, Table, Column), Presentation Services/Web Catalog objects (Dashboards, Pages, Folders, Reports), Scheduling iBots/Agents.  Expertise in OBIEE features like cache, usage tracking, dimensional hierarchy, aggregate navigation, variables /initialization blocks configuration, Dim extensions, physical and logical data modeling.  Experience in debugging and optimizing the OBIEE Dashboards/Reports.  Hands on experience in Oracle BIEE testing, unit testing, report data validation, report data testing based on SQL results, OBIEE query log data validation.  Experienced with OBIEE 11g and also took part in the upgrade activities of OBIEE 10g to OBIEE 11g.  Exposure to Data Warehousing ETL tools Informatica Power Center.  Expertise in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems  Proficient at interviewing stakeholders from CXO level executives to end users, and in translating users’ statements of needed system behavior and functionality into Business and Functional Requirement  Very strong Analytical and Presentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort  Good Analytic and Statistical Exposure to create Reports, Proficient in building analytical repository, presentation layer, business models, generating reports, and creating dynamic Dashboards using OBIEE. P a g e 1 | 8
  • 2.  Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers/Analysis, Delivers / IBots, creating reports / Dashboards, cache monitor, and building Analytics Repository using OBIEE.  Experience in implementing security in OBI using Repository Variables, Initialization Blocks, and Session Variables and creating Object Level Security and Row Level Security at the repository level.  Worked on implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse concepts, Star Schema, Data Modeling, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.  Self-driven and passionate performer with the yearn to learn new technologies and concepts  Can handle multiple projects at one time and deliver quality work.  Experience working with AGILE methodology and participating in daily SCRUM meetings for time critical projects.  Handled complex navigation using GO-URL navigation syntax.  Used JavaScript code to enable email feature to send across the OBIEE runtime report in multiple formats dynamically, as per the groups selected by the user via prompts.  Migrating the application from development environment to QA staging and production environments.  Developed test cases and performed unit testing and integration testing of the Repository and Web Catalogs.  Execute defect prevention and causal analysis activities.  Analyzing the SSRS reports and coming up with the best possible solutions in OBIEE to achieve the same.  Used JavaScript code to enable email feature to send across the OBIEE runtime report in multiple formats dynamically, as per the groups selected by the user via prompts.  In Business model mapping Layer we implemented the Dimensional Hierarchy, level based measures, aggregations, security groups and roles using LDAP Authentication, etc.  Implemented the Caching for speeding up the reports and to improve the performance wise.  Merging the RPD and Web Catalog Folder with OBI Admin Tool and Catalog Manager BI Publisher:  Experience in implementing Data Model, Multiple Data Set Join, Parameter, procedure call.  Experience in implementing Data template (RTF and Excel)  Developed so many complex BIP report. Added Multiple Group, If else condition, For Loop, Exception condition, complex template level calculation.  Knowledge of XDO, XSLT Function  Created Navigation Report : OBIEE to BIP and vice versa  BIP Migration from 10G to 11g  In reports created the charts, tables, Pivot tables and so on.  Created an RTF template reports with a table and Chart using BI Publisher desktop in MS Word, Created and Publish multiple templates for a BI Publisher reports using the native features of MS Word and Schedule and manage the BI Publisher reports.  Implemented the Caching for speeding up the reports and to improve the performance wise.  Merging the BI Publisher Web Catalog Folder with OBI Admin Tool and Catalog Manager TECHNICAL SKILLS BI / Reporting Tools OBIEE 11g/10g, BI Publisher, SAP BO. Data Modeling / ETL Star and Snow flake Design, Informatica 8.6.1 RDBMS Oracle 11g/10g / 9i, SQL Server 2008 / 2005 / 2003 / 2000. Database Tools TOAD, SQL Developer Web Technologies HTML, Java, JavaScript, XML, XHTML. Programming Languages: SQL, PL/SQL, Oracle Operating Systems Windows 7, 8, XP / 2000/NT/2003/2008 P a g e 2 | 8
  • 3. PROFESSIONAL EXPERIENCE Client: PNC Financial Services Group, Pittsburgh PA Sr. OBIEE Consultant Project Name: 1. PNC I&R Reporting and Dashboard (OBIEE) : Jan 2013 – Till Date 2. PNC Investment (OBIEE) : Mar 2014 – Till Date 3. IRW BI Publisher Reports (BI Publisher) : Mar 2014 – Till Date 4. Asset under Management Group (OBIEE) : Mar 2015 – Till Date 5. PNCI BOB Project (OBIEE) : Apr 2015 – Till Date 6. Crystal Report Migration to BI Publisher : Jan 2015 – Till Date PNC bank is targeted to deliver key metrics reports at the Firm level, Region, Market, LOB, Business segment level and Managerial level mostly for the Investments and Retirement business arm of the organization. Many customized reports were developed to showcase Stacked Advisor Rankings, Financial Planning, Total Insight Accounts, Referral, Revenue, Product (Mutual Fund, Fixed Income UIT, Online trading... etc.) , Sales, Operation and Goals. Responsibilities: • Involved in the whole SDLC of the project which includes requirement gathering, design, development, testing and release and production support. • Designed and built Oracle BIEE Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model. • Worked closely with Business Users in understanding the requirements and created the business model for generating reports as per the user requirements. • Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns. • Used the Catalog manager and maintained the web catalog to manage Dashboards, Analysis. • Created Drill down Hierarchies and implemented Business Logics for Facts. • Analyzed and validated the business model in Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer. • Interacted with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications. • Conducted and delivered Mock Up-Presentations with Business Users as a part of the AGILE methodology and facilitated in getting approvals and signoffs. • Developed many Reports / Dashboards to showcase Referrals, Sales Metrics, Pipeline, Opportunities and Performance Metrics etc. with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE Presentation server. • Managed security privileges for each subject area and dashboards according to user requirements. • Configured OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required, and changed the physical joins/key on the existing tables. P a g e 3 | 8
  • 4. • Worked on Multi-User Environment (MUDE) by merging and importing multiple projects throughout the development phase. • Created/manipulated initialization blocks and variables for usage in reports. • Worked on setting up column level security for the OBIEE Reports and also handled the security and privileges from the Database to the Oracle repository. • Created user and groups using Web logic Administration Console. • Created Roles and policies using Web logic Enterprise Manager. • Worked closely with the Business Users, corresponding track developers and Administrators to resolve ongoing production issues. Environment: OBIEE 11g, BI Publisher, Oracle 11gR2, Informatica 9, TOAD, Windows Server 2008. PNC Financial Services Group, Pittsburgh PA Sr. OBIEE Consultant Project Name: 1. IMW BOB Reporting Project (OBIEE) : March 2014 – Nov 2014 2. Copilot BI Publisher Project (BI Publisher) : August 2014 – March 2015 3. Basel 2 Pillar 3 : June 2014 – Feb 2015 PNC Financial Services Group, Inc., an American financial services corporation, aimed to understand and achieve growth in its wealth management (LOB) division using reports developed on OBIEE. Responsibilities: • Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports. • Analyzed the specifications provided by the client, understanding the business. • Install, configure, and administer the OBIEE platform. • Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS • Designed Star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary. • Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool. • Specified Dimensional hierarchy, Aggregate levels for the dimensions. • Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers. • Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports. • Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, View Selector, Tabular with global and local Filters) using Oracle BI Presentation Services. • Helped built a custom Usage Tracking Report to showcase user and dashboard based usage tracking. • Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards & answers. • Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, Directors, Business Development Officers • Managed Security privileges for each Subject area and Dashboards according to user requirements • Developed under MUDE environment for concurrent rpd development. Developed and debugged many Dashboards using different Analytics Views. • Worked closely with the team in upgrading to new version OBIEE11g on all the environmental servers • Involved in System Integration Testing (SIT), User Acceptance testing (UAT) and Production support. P a g e 4 | 8
  • 5. • Performed Upgrade Assistant on repository and web catalog from OBIEE 10g to OBIEE 11g. • Conducted mockup and Training sessions for the end user. Environment: OBIEE 11g, BI Publisher, Oracle 11gR2, Informatica 9, TOAD, Windows Server 2008 PNC Financial Services Group, Pittsburgh PA OBIEE Consultant Project Name: 1. AML Trending Report (OBIEE / BI Publisher) : Jan 2013 - Oct 2013 2. SWC project (OBIEE) : Feb 2013 - Dec 2013 3. XSELLerate (OBIEE) : June 2013 - Nov 2013 PNC Financial Services Group, Inc., an American financial services corporation, aimed to understand Am Trust division data using reports developed on OBIEE. XSELLerate project was targeted to enhance current Institutional data and reporting capabilities in order to support knowledge management, improved management reporting and BDO performance management by providing them access to a common place to access Opportunity, Sales Metrics, Book of Business, training materials and other tools PNC Bank is implementing SWC Business Intelligence project as a suite of business intelligence tools, including CRM and business analytics. Overall, these tools will provide insights and data to allow users to gain knowledge about business performance and to understand progress toward goals, including state of the art referral, prospect and pipeline management, access to data and information related to the existing book of business, streamlined and centralized access to consistent data across the user base and the identification of potential trends. Responsibilities: • Installed Business Objects Enterprise on both server and client machines and Enterprise Performance Management on the server machine. • Interacted with users on a daily basis to gather requirements for the corporate dashboard. • Managed ODBC connections with created meta data and repositories according to needed subject areas. • Designed and implemented physical and logical star schemas using facts, dimensions, alias, metrics and extension tables provided with foreign and complex joins. • Created a dashboard with menus and sub menus using dashboard builder to organize the analytics in an intuitive manner. • Created and maintained security within OBIEE using a combination of LDAP integration, data level security, and presentation catalog groups. • Extensively used BO reporting functionalities like slice & dice, drill-down, cross-tab, @functions, master/detail, breaks and extended syntax. • Created interactive reports with drop down filters that were used to navigate from the analytics for detailed information. • Used advance features in designer like aggregate awareness to accommodate the aggregate tables in the datamart and security management to apply object and row level security. • Implemented row and object level security depending on user rights. • Implemented drill down feature for multiple level drilling down in reports. • Implemented charts like 2D and 3D, tables, cross-tabs in the reports. P a g e 5 | 8
  • 6. • Integrated BI Publisher with OBIEE to build reports in word, excel and doc format. • Created various templates, reports, and prompts in BI Publisher. • Created schedulers and developed iBots to deliver reports and dashboards to the subscribers as per the schedules and alerts. • Performed the performance tuning of dashboards and reports and made required changes to repository and database • Maintained and modified existing reports according to needs of users. • Supported the administrator in installing patches, migration, setting user privileges and access restrictions, and resolving server issues. • Used SQL extensively for performing unit testing for the developed Modules. Coordinated with the testing team to test the flow of data from ODS to Informatica ETL to Data warehouse to reports. Compared data in reports against source systems. • Participated in designing, coordination and execution of user acceptance testing (UAT) with QA, BA and selected business users. Environment: Oracle BI Administration, Oracle BI Presentation, Oracle BI Dashboards, BI Publisher 10g, JavaScript, XML, HTML, Oracle 10G,Toad,WIndows 2008. . PNC Financial Services Group, Pune (India) OBIEE Consultant Project Name: 1. Stucky (OBIEE) : Jan 2010 - Oct 2010 2. LPA (Landing Process Automation) (OBIEE) : Nov 2010 - Oct 2011 3. Employee Experience (OBIEE) : Dec 2010 - July 2011 4. CACS (OBIEE) : Oct 2011 - May 2012 5. VRR (BI Publisher) : Jun 2012 - Nov 2012 6. Managed Account Workflow : Apr 2012 – Dec 2012 PNC bank provides services in Banking and Finance in United States, It is the one of the largest bank by deposit in the United States. PNC's consumer analytics teams provide analytics to support consumer and business banking asset class strategies and pricing. To give users easier access to critical information of Reveleus in Risk management dashboards are created using Dashboard Manager. Dashboard contained reports that presented the Credit Risk, Market Risk, Liquidity Risk, and Operation Risk. Dashboard shows Geography wise Risk reports which help clients to differentiate Risk between different branches. Software Development Life Cycle (SDLC) and Agile methodologies are used in the project. Responsibilities: • Worked with business analyst on user requirements and wrote functional and technical requirements documents. • Daily attending the status meeting with clients and coordinating with onsite team to discuss further move. P a g e 6 | 8
  • 7. • Understand and design the generic metadata RPD, physical and business model diagram mapping and joins with facts and dimensions based on the star and snow flake schemas as per best practices. • Implemented and Worked on MUDE (Multi-User Development Environment) mode setting up with different users and developers prospective. • In Business model mapping Layer implemented the dimensional hierarchy, level based measures, aggregations, security groups and roles using LDAP authentication, etc. • Created new logical columns defining the business logic as per the requirements. • Involved in setting up session such as user session and repository (static and dynamic) variables such as location as static and current day/month/year as dynamic variable using various initialization blocks. • Merging the RPD and web catalog folder with OBI admin tool and catalog manager. • Responsible for implementing data-level security and object-level (dashboards/reports) security among users, groups and web-groups. • Highly experienced in setting up session variables and repository variables using various Initialization Blocks. • Responsible for creating additional users and maintaining visibility privileges using OBIEE administration on repository side as well as front end to display OBIEE reports based on the business user for that particular area. • In reports created the filters and time dimension prompts for all the dashboard pages ,charts, tables, Pivot tables, Narrative view and View/Column selector, etc. • Developed time series objects using Ago and ToDate functions for time series comparisons. • Implemented write back capability to enter values directly into a report and have those values used in calculations and charts in the report. • Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling. • Configured Oracle BI scheduler for delivery options of a report and also scheduled FTP delivery options for a report. • Handled complex navigation using GO-URL navigation syntax. • Used javaScript code to enable email feature to send across the OBIEE runtime report in multiple formats dynamically, as per the groups selected by the user via prompts. • Migrating the application from development environment to QA staging and production environments. • OBIEE Environment migration from 10G to 11G. • Developed test cases and performed unit testing and integration testing of the Repository and Web Catalogs. • Execute defect prevention and causal analysis activities. Environment: Oracle BI Administration, Oracle BI Presentation, Oracle BI Dashboards, Oracle BI Application Server & MUD Environment, BI Publisher, JavaScript, XML, MS Office, Oracle 10g/11g ,SQL Developer, Toad, Windows 2008/XP P a g e 7 | 8
  • 8. PERSONAL DETAILS Date of Birth : April 10th 1987 Gender : Male Present Work Location : 600 Grant Street, Pittsburgh, PA, Zip Code: 15222 Present Home Location : 1405 Teal Trace, Pittsburgh, PA, Zip Code: 15237 Joining Date : November 9th 2009 Education: : Bachelors in CS (Information Science), VTU University, Karnataka, India. Achievements: : Awarded Technically Excellence in TCS for Oracle Business Intelligence Foundation Suite 10g/11g. P a g e 8 | 8

Related Documents