*Sr. ODI/BI/OBIEE Developer consultant available for the new project, **Please do share your **requirement** to **rob...@g3infotek.com <rob...@g3infotek.com>*
*Praneeth Ponnaganti* *408-663-5798* ------------------------------ *PROFESSIONAL SUMMARY* · *8 *years of experience in Business Intelligence, Data Warehousing and DatabaseApplications including Analysis, Design, Development, Testing and Support using ODI, OBIEE and BI APPS. · Proficient in Data Warehousing, Dimensional modeling using star schema/ snow flake schema modeling, Fact and Dimension identification. · Expertise with all ODI graphic tools *- Topology, Security Manager, Designer and Operator.* · Hands on experience working with ODI Knowledge Modules- LKM, IKM, RKM, JKM and CKM. Customized versions for the existing ODI Knowledge modules, which can be re-used in data integration projects. · Expertise in developing ODI objects - *Project, Model, interfaces, Yellow interfaces, Procedures, Filters, Models, Load plans* and generating / regenerating ODI scenarios. · Excellent experience in implementing Change Data Capture (CDC), Slowly Changing Dimension (SCD) type 1, type 2, type 3using ODI. · Expertise in building Metadata Repositories (.rpd) using Physical layer, Business Model and Mapping layer, Presentation layer with the Oracle BI Administration tool. · Participated in creating ETL design and architecture documents and source, target mapping documents. · Proficient in rpd designing, developing and generating dashboard Reports, Business views, Unit Testing, Quality Assurance, Project Planning and Documentation. · Experienced in developing and implementing Dimensional Hierarchies, Level Based Measures, Aggregation Rules, Time Series Functions, Rank Functions. · Skilled in configuring *OBIEE Metadata objects* including repository variables, initialization blocks, and connection pools using ODBC, OCI and Universal Adapters. · Experienced in designing customized and complex interactive dashboards in OBIEE using drill down/ drill up, guided navigation, prompts, filters and variables. · Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables besides configuring object level and database level security. · Expertise in *database Performance Tuning* by implementing Parallel Execution, Partitions, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing. · Good knowledge in using OBIEE answers to create queries, format views, and charts to enhance the user experience. · Skilled at creating and *scheduling Agents (iBots) using Oracle BI* Delivers to provide real-time, personalized and actionable intelligence data to subscribers. · Experienced in upgrading and migrating of OBIEE reports between dev/test/prod environments. · Performed Extraction, Transformation, and loading (ETL) data from various sources into Data Warehouses. · Created *Oracle PL/SQL* queries, Stored Procedures, triggers and Cursors. · Worked on data loads using *Oracle PL/SQL* and SQL *Loader from legacy systems and uploaded into Oracle. · Created *LOAD PLANS* and *Schedules* using *ODIOperator* · Experience in *Database design using Normalization and E/R Diagrams*. · Expertise in *creating stored procedures, functions, packages, collections and bulk collectionsusing PL/SQL*. · Good knowledge in Oracle tools like SQL*Plus, SQL Loader, SQL Developer using TOAD in secure databases. · Highly motivated team- player with excellent communication / problem-solving skills and quick learning ability. *EDUCATION:* *Bachelor of Technology *in *Electronics and communication Engineering* from ACHARYA NAGARJUNA University, GUNTUR, INDIA. *TECHNICAL SKILLS:* RDBMS Oracle 11g/10g/9i, Oracle Exadata Database Tools SQL developer, SQL*Plus, TOAD, SQL Loader. Programming Languages C, C++, SQL, PL/SQL, HTML. ETL Tools ODI 10g/11g/12c Operating system Windows XP, Windows 7, Linux Tools MS Office Reporting Tools OBIEE 11G/10G *Regards:* *Robert | G3 INFOTEK* *Sr. Sales Recruiter* *1001 Durham Avenue, Suite#321* *South PlainField, NJ, 07080* *O: (732) 416-5572* *E-mail: **rob...@g3infotek.com* <rob...@g3infotek.com> *Gtalk: Usitstaffing16* -- You received this message because you are subscribed to the Google Groups "as400placements1" group. To unsubscribe from this group and stop receiving emails from it, send an email to hrccpl+unsubscr...@googlegroups.com. To post to this group, send an email to hrccpl@googlegroups.com. Visit this group at http://groups.google.com/group/hrccpl. For more options, visit https://groups.google.com/d/optout.
