Skills ? Database Environments: Oracle, SQL Server, MySQL ? Operating Environments: Linux, Windows ? Business Intelligence Tools: ODI 10g/11g, ? Cognos 8.4 & 10, ? OBIEE 10g/11g, ? Oracle BI Publisher 11g ? Toad 9.6 for Oracle ? Cognos 10 BI Author Certified. ? Web development: HTML, JavaScript ? Microsoft Office 2013, 2010, 2007, 2003, 2000 ? Unix Scripts ? Mercury Quality Center 10.0 Employer: Hitachi Consulting Software Solutions Private Limited Role: ETL and Reports Developer Responsibilities: ? Understand project requirements and work towards design and development of the plan layout. ? Develop and deploy analytics and reports properly ? Work with administrators, users and analysts to maintain exchange of reporting requirements ? Developed Extracts to fetch data from the cloud system ? Involved in design and development of objects in layers varying across physical, business and presentation layers. ? Developed and configured alerts for various reports. Employer: Mahindra Satyam Role: ETL and Reports Developer Project: VIVA Telecom Billing & CRM Client: VIVA Telecom Responsibilities: ? ETL development, administration, source to target mappings, business transformations, on call support and documentation. ? Design and development of many complex ODI interfaces/packages to support subject areas like Subscriber, Billing, Roaming and Sales. ? Strong experience in developing complex mappings and monitoring the status of execution through ODI Operator. ? Monitoring daily loading of large chunk of transactional data. ? Job Automation for the Scheduling Process. ? Customizing Knowledge Modules in ODI Designer. ? Developed the Key Performance Indicators (KPIs) from the data in the data warehouse. ? Written SQL queries to test the data using Toad 9.6 for Oracle. ? Developed Adhoc Reports for the data available in the datawarehouse in OBIEE .The Repositories (RPDs) were created and the data was pulled in, to design the Reports using OBIEE. Employer: Mahindra Satyam Role: Reports Developer Client: GE Aviation & Tech Infra Responsibilities: ? Develop the detailed Cognos List/Crosstab/Chart/Map reports with the data from the UECDW database. ? Developed OLAP cubes for the apple devices. ? Developed Multidimensional models to load data directly from relational data sources that is structured in a star or snowflake schema ? Written test cases document and executed the test cases. ? Conducted Testing both in Development and QA environment for all the Reporting activities. ? Mercury Quality Center 10.0 is used to find out all the defects in both DEV and QA. ? Written SQL queries to test the data using Toad for Oracle.