Input your fixed/hourly price in this field.
Freelancers
freelancer

Shilpitha .

0.0/5 (0 Feedback)
Member since March 24, 2021

1

  • $1.00 / hr
  • GA
  • Save

• Over 8 years of experience in Business Intelligence using Oracle Business Intelligence(OBIEE) 10g and 11g. Strong experience in OBIEE 11.1.1.X/10.1.3.x, Informatica and BI Applications ,Siebel Analytics 7.x modeling and developing Metadata, Repositories, Dashboards and Reports. Scheduling and Monitoring ETL routines through DAC on different environments like Development and Test environment. • Worked on implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema, Snowflake Schema, Fact & Dimensions tables, Physical & Logical Data Modeling. • Experience in OLTP / OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact, dimensional tables, slowly changing dimensions, Physical and Logical Data Modeling. • Implemented Oracle BI Apps in all phases like implementing Out of order Box (Vanilla mappings) prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided data warehouse (BAW), OBIEE RPD development, reports and dashboards • Configured Answers (ad-hoc querying, reports), Interactive Dashboards with drill-down capabilities (charts/tables/graphs), Delivers/iBots (alerts), administered Web Catalog Objects (pages, folders), configured OBI Publisher and integrated Publisher reports into dashboards by creating a customized layout. • Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment (MUDE). • Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications. • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. • Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation. • Implemented BI solutions for Pharmaceutical, Retail, Financial and other sectors for their various business processes i.e. Marketing, Sales, Services and Customer Care, Energy etc. • Extensively used the four basic Informatica Power Center tools – Repository Manager, Designer, Workflow Manager and Workflow Monitor. • Expertise in different stages of handling data viz. requirement gathering, identifying data sources/targets , data modeling, data cleansing, data loading. • OBIEE- SECURITY- SSO- LDAP– OID, External Table, OBJECT level Security, ROW level Security using INIT Blocks. Experience with Federated Query tuning strategies. • Detail understanding of OLTP and OLAP Data models to create and manage the repository with the available metadata using OBIEE. • Very good in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytical Dashboards / Reports. • Extensive Experience in Data Warehousing development using ETL tools such as Informatica Power Center / Power Mart 8.x/ 7.x. • Proficient in coding in SQL, PL/SQL, procedures/functions, packages, Explain Plan, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views, Inline Views using SQL Plus, TOAD. • Expertise in all phases of the Software Development Life Cycle (SDLC) including Analysis, Physical and Logical design, Resource Planning, Code development, Testing, Implementation and Maintenance. • Expertise in Debugging, Optimizing and Performance tuning of OBIEE reports. • Outstanding communication, analytical and presentation skills. • Ability to provide timely solutions and work within specified time frames. Technical Skills: Reporting Tools OBIEE 11.1.1.7/10.1.3.x, ODI, OBI Publisher 11.1.1.7/10.1.3.4, Siebel Analytics 7.8x/7.7x/7.5x, OBIA BI Applications 7.9.X ETL Tools Informatica Power Center 8.x/7.x/6.x, DAC 7.8.5 Operating Systems UNIX, MVS, Windows95/98/NT/XP/7/8, MS DOS Languages SQL, PL/SQL, COBOL, JCL, Easytrieve OLTP / Middleware CICS, MQ Series Tools & Utilities SQL Developer, SQL*Plus, PL/SQL Developer, TOAD, SPUFI, QMF, File Aid, ChangeMan, MS Office, IBM Utilities, SDF II Databases Oracle 11g/10g/9i/8i, SQL Server 2000, DB2 UDB, VSAM, MS- Access Web Technologies HTML, CSS/JavaScript, AJAX, XML Data Modelling Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin r7.1/7.2, ER Studio V8.0.1 and Oracle Designer, OLAP.

0

Ongoing 
Projects

0

Completed 
Projects

0

Cancelled 
Projects

3

Ongoing 
Services

0

Completed 
Services

0

Cancelled 
Services

$0.00

Total 
Earnings

* Click the button to send an offer

Send Offer