Software Engineer Data
Resume:
LOKESH
Voice: +91-953*******
Email:ab2rto@r.postjobfree.com
Professional Summary:
> Having 3.5 years of experience in Oracle Business Intelligence (OBIEE) .
> Expertise in developing and customizing all 3 layers of the Analytics Repository (Physical Layer, Business Mapping and Modeling Layer & Presentation Layer).
> Expertise in Data Modeling design, analyze and implement - conceptual, logical and physical data model, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.
> Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
> Administrator ETL and data warehousing applications and tools
> Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
> Understand the standard of best practices in BI administration environment
> Worked extensively in the analysis and development of Data warehousing applications using OBIEE 11.1.1.6x.
> Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
> experience in Oracle Business Intelligence and OBIEE Administration
> experience in installing, upgrading and configuring OBIEE tools
> Strong experience in developing OBIEE (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer)
> Worked on Parent child, Level Based, Ragged Hierarchies
> implemented Fragmentation, Aggregate Navigation in the BI repository in 10g
> Proficient in the use of repository variables and session variable, presentation variable and request variable.
> Worked on OBIEE 11g New Features Action Links,Scorecard, Mapview, Master Detail Event
> Worked on Lookup Tables in OBIEE 11g
> Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool.
> Hands on experience in customizing reports, filters and charts in Oracle Answers.
> Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views .
> Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
> Hands on experience on setting up LDAP for OBIEE.
> Knowledge in Data warehousing development using ETL tools such as Informatica Power Center 8.x/7.x/ 6.x and developed Informatica Mappings and Workflows with Worklets & Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
> Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills.
> Excellent interpersonal and communication skills for efficient client interaction.
> Good problem solver and prompt decision maker
> Can work in teams as well as independently
> Handle multiple projects administration responsibilities
> Ability to handle stress and problems in work and the work environment
> Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
> Configuring Analytics Security and creating User's Groups and setting Privileges.
> Ability to translate functional specifications into detailed technical design specification.
> Experienced in Preparing Technical documentation (HLD, LLD).
> Experienced in HLS, LLS, Unit Test cases and Bug fixes.
> Having good knowledge on SQL and Pl/Sql.
> Good knowledge in estimations for new requirements
> Good communication, Presentation and problem-solving skills.
> Strong aptitude for learning and understanding business process and needs.
Educational Qualification:
> B.Sc(Computers) from Sri Venkateswara University
Professional Experience:
> Working as a Senior Software Engineer for LNT InfoTech from Dec 2011 to till date.
> Worked as a Software Engineer for Maxx Technologies from Jan 2010 to Oct 2011.
Technical Skills:
Operating Systems : Windows
Database : Oracle 8i/9i/10g
Tools : OBIEE 10.1.3.X, OBIEE 11.1.1.6, TOAD
Project : 1
Client : Loyalty Partner Solutions
Duration : May 2012 to till date
Solution Environment : OBIEE, Windows, Oracle
Tools : OBIEE 11.1.1.6, Toad
Description:
Loyalty Partner is the centre of expertise for marketing and couponing platforms within the American Express Group. The partnership - comprising 89 million cards in 140 countries - creates one of the world's leading loyalty management companies.
Loyalty Partner is reaping the benefits of this approach. PAYBACK is proving a real success in Germany, Poland, India and Mexico - both as a loyalty programme and as a multichannel marketing platform with very efficient and, above all, effective communication channels.
Responsibilities:
> Experienced in Customized OBIEE Admin Tool to develop the three layers in the Repository.
> Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
> Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
> Developed the custom reports/dashboards for Financial Analytics.
> Worked extensively on Oracle Answers to create the reports.
> Gather user requirements and identify gaps in between pre-built reports/dashboards and user needs and prioritize requirements to be implemented.
> Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
> Good Knowledge in BI Publisher reports and using various templates to publish the reports as per user requirements.
> Preparing Technical documentation (HLD, LLD).
> Good knowledge in estimations for new requirements
> Unit testing for the developed RPD and Dashboards and test overall System functionality
> Preparing Test cases to report the Bugs reported by Clients
> Experience in preparation of test cases and testing of mappings and reports.
> Created Proactive agents and configured Interactive dashboards.
Project : 2
Client : AICTE (All India council for technical education)
Duration : March 2011 to Mar 2012
Solution Environment : OBIEE, Oracle, Windows
Tools : OBIEE 11.1.1.6, Oracle 8i.
Description:
AICTE was constituted in 1945 as an advisory body in all matters relating to technical education. Even though it had no statutory powers, it played a very important role in the development of technical education in the country. It had four regional committees with offices at Chennai, Mumbai, Kanpur and Calcutta. All the new schemes and proposals for starting new institutions/Programmers were approved by the corresponding Regional Committee and subsequently vetted by the Council.
Responsibilities:
> Experienced in Customized OBIEE Admin Tool to develop the three layers in the Repository.
> Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
> Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
> Developed the custom reports/dashboards for Loyalty Analytics.
> Maintaining role base security and Visibility. Implement security to restrict access to sensitive data.
> Creating Joins in the Physical layer and Business Layer.
> Creating the Variables at the Repository Level.
> Testing, debugging the Data loading.
> Unit testing for the developed RPD and Dashboards and test overall System functionality
> Preparing Test cases to report the Bugs reported by Clients
> Experience in preparation of test cases and testing of mappings and reports.
> Creating the Dashboard prompts.
> Preparing Technical documentation (HLD, LLD).
> Good knowledge in estimations for new requirements
> Unit testing for the developed RPD and Dashboards and test overall System functionality
> Preparing Test cases to report the Bugs reported by Clients
> Experience in preparation of test cases and testing of mappings and reports.
Project : 3
Client : Procter & Gamble (P&G)
Duration : Jan 2010 to Jan 2011
Solution Environment : OBIEE, Oracle, Windows
Description :
Procter & Gamble (P&G) is one of the largest manufacturers of household products and is headquartered in Cincinnati, OH. P&G manufactures and markets ~250 brands to nearly 5 billion consumers in over 130 countries, with a global workforce of over 100,000 people. Some of its popular brands are Tide, Ariel, Crest, Pantene Pro-V, Whisper, Bounty, Pampers, and Vicks among others. The scope of this project includes creating the Demand Planning reports, which requires complete implementation of the Warehouse, Reports, OBI repository and Web-catalog configuration in line with the standards established at P&G. The Demand Planning process develops and gains alignment to a single Demand Forecast and detailed Sales Plan for the business and also allows combined reporting through a uniform reporting platform across multiple geographical regions
Responsibilities:
> Imported Physical tables and defined relations between Physical tables at the Physical Layer.
> Created Hierarchies, Levels, and implemented Business Logic by creating level based measures.
> Developed reports using different Analytics Views (Pivot Table, Chart, Column and View Selector).
> Design and customization of Siebel Answers, Reports and Dashboards.
> Creating the Dashboard prompts.
> Customized Reports look and Feel using Column Formatting, Conditional formatting.
> Imported the custom fact and dimension tables and configured it in the 3 layers of the RPD. Implemented Level Based Measures in the BMM layer.
> Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
> Created Security settings in OBIEE Admin Tool to setup groups, access privileges.
> Experience in BI Publisher reports and using various templates to publish the reports as per user requirements.
> Preparing Technical documentation (HLD, LLD).
> Good knowledge in estimations for new requirements
> Unit testing for the developed RPD and Dashboards and test overall System functionality
> Preparing Test cases to report the Bugs reported by Clients
> Experience in preparation of test cases and testing of mappings and reports.
> Experienced in HLS, LLS, Unit Test cases and Bug fixes.
> Created Proactive agents and configured Interactive dashboards.
Contact this candidate