Professional Experience: 4.9+ years of experience as consultant in technology domains like OBIA (OBIEE and ODI) and SQL. Having strong ability to conceptualize, document, and communicate project ideas, Design, Development with proficiency in debugging and problem solving, Testing and Implementation support. Seeking for part time Freelancing opportunity. • Creating/customizing OBIEE Reports, Dashboards and Prompts. • RPD development and BI Administration. • Doing Dimensional modeling for new and modified star schema. • Implementing Opaque views whenever necessary. • Implementing and managing Security in OBIEE. • Developing real time reports from PeopleSoft Campus Solution tables. • Understand the business requirement and implement different graphs, charts as per requirement. • Performance tuning of the reports by creating the right indexes on the column of the tables. • Converting complex sql query solutions in to OBIEE model solutions. • Managing ODI load plans and Developed packages, scenarios using interfaces and variables in ODI. • Troubleshooting the various errors in ODI data load and applying fix for the same. • Experience in data Extraction, Loading and Transformation in data ware house environment. • Implemented SCD Type2 on Dimension tables. • Introducing new tables to data warehouse and Developing ELT mappings. • Applying latest patches to environment. • Presenting permanent solutions to IT. • Understanding the FDDs and identify the technical dependencies • Understanding the Functional and technical structure of Source tables and build ELT interface • Understanding the Source modules to get the required table details for ETL. • Worked with EBS and Peoplesoft as source database.