Mr

• Strong experience in Implementation and Testing using Data Extraction, Data Transformation and Data Loading (ETL) using ODI.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects and Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges).
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables.
• Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Planning, Essbase, Relational Database Management servers and flat files.
• Hands-on experience with Amazon EC2, Amazon S3, Amazon RDS, VPC, IAM, Amazon Elastic Load Balancing, Auto Scaling, Cloud Front, CloudWatch, SNS, SES, SQS and other services of the AWS family.
• Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing. Experience optimizing ETL workflows.